SUMMARY:

• Senior database leader with significant experience in data architecture and vision
• Veteran in Oracle database leadership, architecture, design and development
• Written project database design and development standards documents, including naming standards, data model guidelines and data migration strategy
• Experienced in normalized and de - normalized data structure design (OLTP and OLAP), and data warehousing
• Experienced in end to end database architecture, design and development, and in determining data models from user requirements
• Inherited projects significantly behind schedule and turned them around to meet KPI and SLA requirements
• Excellent at interacting with the business community and communicating in non technical language
• Very experienced at understanding user requirements and building data systems to support the business

TECHNICAL SKILLS:

Platforms: HP Superdome, Sun SPARC, HP 9000, IBM PC, ES9000

OS: Solaris, HPUX, DOS, Windows, Unix SVR4

Tools: /Databases: Oracle, Data Analytics, Exadata, Toad, ERWIN, PostgreSQL, Goldengate Multimaster, Oracle Reports, Pro*C, Peoplesoft SQR, SQL, PL/SQL, OLAP, ERP systems, Developer 6, Designer 6, Oracle Discoverer, Control-M, Visual SourceSafe, Datawarehousing, DB2/Spufi, MVS/JCL, Cobol, Java, Javascript, HTML, Perl DBI/DBD, MQSeries

PROFESSIONAL EXPERIENCE:

Confidential (Guelph, Ontario)

Technology: Oracle, Tibco Spotfire

Responsibilities:

• Creation of Analytics platform using Tibco Spotfire
• Owner of data architecture, performance and validity
• Supporting the data needs of a diverse suite of Equipment rental management applications

Confidential (Charlotte, North Carolina)

Senior Consultant - Database Performance

Technology: Oracle, PL/SQL, Oracle Enterprise Manager

Responsibilities:

• Performance and data analysis for a vendor based pricing system
• Understanding of application functionality and rewriting in PL/SQL to generate better performance
• Using Oracle Enterprise Manager and AWR snaps to analyze and eliminate complexity and improve performance

Confidential

Senior Consultant - Warehouse Management System

Technology: Oracle, PL/SQL, Manhattan WMS

Responsibilities:

• Analysis and design of new and changed processes for implementation of new WMS
• Instituted for all designers and developers on efficient database batch processing with significant focus on performance

Confidential

Senior Consultant

Technology: Oracle R12, PL/SQL

Responsibilities:

• Leadership of data conversion efforts from multiple sources into Oracle for OLBB
• Lead conversion efforts for 3 phases of customer data migration into new systems

Confidential

DBA - IT strategy

Technology: SQL Server, PostgreSQL, MS Access, VB

Responsibilities:

• Resolution of complex technology and integration issues
• Reviewed existing reporting models and architecture leading to new development that improved performance of reporting by more than 50%
• Highlighted gaps in reporting and data management capabilities and developed mitigation strategies

Confidential

Senior Database Solution Designer

Technology: Oracle 11g, ANSI SQL, PL/SQL, Java

Responsibilities:

• Responsible for all aspects of database design, development and ownership of Oracle and PL/SQL code for FATCA
• Leadership and mentoring of design and development teams, creation and oversight of design documents and code
• Lead initiatives to determine and fix important data and processing issues in a highly complex architecture
• Identified capabilities and supporting applications’ imbalances resulting in revisions to corporate data models and reporting capabilities
• Worked with all levels of external and internal business customers for requirements development

Confidential

Database specialist - Manufacturing IT Database Development

Technology: Oracle 11g, Goldengate, Exadata reporting, Toad, ANSI SQL, PL/SQL, GoldenGate(Multimaster)

Responsibilities:

• Responsible for all areas of manufacturing database transaction logging and reporting in a complex high-availability global system
• Conceptual integration of a very complex manufacturing (OLTP) and reporting (batch) environment
• Designed, developed and supported a complex Java based manufacturing reporting system with Oracle backend
• Supported global manufacturing in highly dynamic environment with massive transaction volumes to minimize downtime resulting in significant cost savings
• Actively involved with internal customers and external manufacturing partners in providing efficient solutions for end-to-end manufacturing

Confidential

Senior Consultant - Risk Management System

Technology: Oracle 9i, PL/SQL, Unix (AIX), KSH Shell scripts, AutoSys

Responsibilities:

• Development of SQL scripts for consolidation of aggregates of credit card transactions for fraud prevention
• Developed scheduler scripts to automate multi-module data generation and load scripts
• Developed KSH scripts for data validation and loading

Senior Oracle DBA - Insurance Systems

Technology: Oracle 10g, Discoverer, PL/SQL, Unix (AIX), SQL Server 2005

Responsibilities:

• Re-engineered premium allocation stored procedures for Large Property Insurance module
• Streamlined day to day job schedules and created automated failure monitoring
• Documented and resolved production problems reported by the business

Confidential

Senior Database Developer - HR systems

Technology: Oracle 10g, PL/SQL, SQR, Unix (AIX), Ksh, Visual SourceSafe, Control-M

Responsibilities:

• Developed several API’s for commonly used HR and Benef Confidential s
• 24X7 support of production environment - monitoring execution, responding to alerts and notifying clients
• Timely and accurate delivery of downstream data feeds
• Interacted with internal and external business clients on a frequent basis

Confidential

Senior Migration Developer - Collections System

Responsibilities:

• Municipal Property Assessment Corporation (Pickering, Ontario) Senior Consultant - Integrated Property System