SUMMARY:

• IT professional with 15+ years of development, database administration, data warehousing and ETL experience with a track record for continuous career growth and progression. This is demonstrated through Michael's diverse and extensive experience with Oracle PL/SQL and SQL, including administration, development, design, architecture, team leadership and mentoring/. Michael has both a solid understanding of, and practical experience with many aspects of the BI/DW project life cycle, including business requirements gathering, data analysis, dimensional data modeling, and testing strategies. Michael excels as a Senior Oracle DBA/Developer, Team Lead and ETL Architect.
• 10+ years of Data Warehousing experience
• 15+ years of Oracle experience - PL/SQL Programming, Database Administration and Design
• 8+ years of SQLServer/Sybase/UDB2/MySql experience
• 8+ years of Data Warehouse and Database Team Lead for small, medium and large size projects
• 5+ years of Oracle trainer/mentor experience
• 5+ years of Project Management skills -project scoping, estimation, planning and execution
• 4+ years of Insurance domain Data Warehouse experience
• 10+ years of Oracle with Unix shell scripting experience
• 4+ years of Banking and Financial domain Data Warehouse experience
• 10+ years of Data Modeling experience and Requirements Gathering.

TECHNICAL SKILLS:

ETL Tools: Oracle 6thru 12c, 18c Custom PL/SQL Packages, Export/Import, Sql Server DTS/Pkgs

Databases: Oracle 6 thru 12c, 18c, MS SQL Server 2008, 2012, DB2, AS400, Sybase, MySql

Data Modeling: Erwin, System Architect, Oracle Designer, Oracle Developer, Datamodeler

Backup/Recovery: Oracle Data Guard, Oracle Recovery Manger (RMAN), Oracle Resource Manager

Operating Systems: Unix, Windows, Linux

Testing Custom: PL/Sql Packages and Automated Tools

Defect Tracking: Rational Rose Clear Case, Information Technology Infrastructure Library (ITIL)

Productivity: MS Office, VISIO, Eclipse, PeopleSoft, Oracle Financials, SAP Business Obj

Scheduling: Unix/Linux Shell Scripts, Sql Server Agent, Oracle Job Scheduler

Programming/Design: PL/SQL, C, C++, Zend, PHP, Java, JavaScript, UnixScript, Cobol, Powerbuilder, GitHub

WORK EXPERIENCE:

Production Support Analyst

Confidential

Responsibilities:

• Provided day-to-day Production Support Contract Settlements, Dealer Commissions, Fraud Systems
• Ensured expected application support levels were achieved, maintained availability Service Level Agreements
• Participated in the development of Support Automation in Microsoft Excel, Sql Server, Oracle environments
• Created ETL routines using Sql Server packages moving large data between Oracle and Sql Server dbs.
• Created Run Job documentation for end-to-end Wireless Commissions dataload/calculation procedures

Oracle 11g, Sql Server 2008, Sql Server 2012, Microsoft Visual Studio 2010, .Net 4.0, TOAD, Microsoft Excel, Test Director, Oracle Financials - Oracle Time and Labour, SAP Business Objects

At Home Caregiver

Confidential

Responsibilities:

• Provided day-to-day meals and companionship to my 82 year old Father
• Complete shopping, transportation, yard and exterior home maintenance as required

Website Designer/Developer

Confidential

Responsibilities:

• Designed and built an e-commerce website for a major clothing distributor in the greater Toronto area
• Collecting/cleansing/transforming all data for online quote engine
• Designed/Created/Loaded the database, all authorization and data access routines
• Met with client to determine requirements of the system
• Transformed Paradox application to PHP, Zend Framework and designing/building Adobe PDF reports

Application Developer

Confidential

• Duties included gathering user requirements for a Corporate Security Incident Report application
• Worked with Security Manager to add program extensions to Microsoft Word document using Visual Basic
• Gathered all requirements to design input forms and underlying XML format.
• Coded context sensitive drop down lists with a standard template document
• Implemented enabling saving document data to an accompanying XML file for transmission to head office
• Created and programmed new Word Doc to upload multiple XML documents into Microsoft Access Database
• Originally hired as an Oracle DBA, to provide an Entity-Relationship diagram of the Oracle database

Database Team Lead

Confidential

Responsibilities:

• Lead and mentored a group of five developers
• Designed database packages and procedures according to business specifications
• Checked developer’s work to ensure adherence to company standards and best programming practices
• Gathered business requirements and designed and developed Sql*loader, PL/SQL, SQL, and Unix shell scripts
• Migrated half a million home phone customers from outsourcing firm into Rogers’ systems
• Created validation programs to verified data integrity and requirements matched to business rules
• Ensured clean feeds to AS400, Siebel and Oracle database systems within Rogers’ infrastructure
• All records were sequenced and traceable for error reporting and re-entry following error correction
• Designed, built, maintained multiple complex database packages to support modifications, multiple projects
• Oracle 10g Enterprise Edition Release 10.1, Rational Rose ClearCase Explorer, SQL Navigator, TOAD, Microsoft Excel, Test Director, Sybase - Adaptive Server Enterprise 12.5, SQL Adv, Central 4.3, Oracle Financials - OTL

Application and Database Designer/Developer

Confidential

Responsibilities:

• Gathered user requirements for a Safety Deposit Box maintenance system
• Re-designed existing Microsoft Access application to Oracle Forms/Reports database and application
• Consulted with system users to determine most effective configuration and use of data
• Designed and coded all data-mappings, migration, verification and Oracle 9i database architecture objects
• The design relied heavily on server-side database packages to accommodate client Forms operations
• Produced 19 custom designed reports which helped refresh my knowledge of Oracle Reports
• Implemented Safety Deposit Box Key Management techniques coding routines fully indexed and audit-able
• System security was also a high-priority requirement
• Designed/coded application logon procedures using Oracle roles and time-sensitive un/pw validation
• Gathered requirements to perform a large number of development tasks to deliver a secure application

Database Developer/Business-Technical Analyst

Confidential

Responsibilities:

• Designed/Created Oracle db procedures used to test/verify Electronic Data Interchange (EDI) translations
• Created database objects used to create test input data and provide expected results of data translation
• Gathered requirements, extracted data from flat files, cleansed/transformed data and loaded corrected/translated data into ER model db for use with Powerbuilder front end
• Traveled to Montreal to Team Lead six Policy Administration Analysts to direct tests, problem id/resolution
• Worked with PAD representatives, tailor end-to-end test cases according to business Use Case requirements
• Created custom automated testing software, reported software bugs via custom tracking application
• Reviewed code for fixed bugs and re-tested front-end and database procedures

Technical Analyst/Forms Developer

Confidential

Responsibilities:

• Created Technical Design Doc from Functional Specs documentation for Oracle upgrade of BANNER CIS
• Designing and creating Oracle Forms for existing Utility Management Software
• Designed, implement forms mods to implement new business validation rules multi-jurisdiction service rates
• Created and implemented Unit Testing Documentation, using SQL to validate all Oracle Forms/Reports input/output via Object and Data Layers for triple-tier architecture Oracle 9.2 Database

Database Developer/Team Lead/Business Analyst/DBA

Confidential

Responsibilities:

• Duties included production database programming, troubleshooting and data mining/maintenance
• Design and build Pl/Sql database packages used to convert Annual to Quarterly accounts, Conversion Burner rate increase and custom Bill Message procedures for BANNER CIS
• Create Master Billing Increase programs, provide test plans, verification queries to business and programmers
• Dial-in to provide off-site support for production database data issues
• Design/Build test instance of database for de-regulated electricity market billing application
• Created full db extract PL/SQL pkgs used to extract all account data to flat files to be exported to head office
• Created incremental update programs, ETL jobs used to load DW and balance major financial transactions
• Worked as Team Lead with four programmers - SQL, PL/SQL, Business Analysis, optimization and debugging
• Worked with Microsoft SQL Server database to load and transform data for website
• Created Bank Account translation and Cash Remittance BANNER format files for import to convert and maintain all electronic payment records for major conversion/migration from OnSource to OHE db format

Database Administrator/Data Modeler/Developer

Confidential

Responsibilities:

• Worked with a Business Analyst to design and build Market Deregulation Billing Support Oracle 8i database
• BA provided a list of tables and high-level explanations of business processes - Use Case documents
• I took verbal specifications of all aspects of the system and built the database and application from scratch
• Responsibilities included Data Modeling, including logical and physical design of the database
• Designed and created all database integrity constraints, database triggers, security roles, user ids and indexes to produce high quality 30 Gigabyte database
• Designed and developed MBS application consisting of complex PL/SQL Procedures and packages used to generate output to PeopleSoft Financial application for Daily and Monthly billing invoices
• Designed, built and maintained complex SQL*Loader, Java and PL/SQL validation procedures to load flat files from IBM-DB2 database into Oracle
• Web front end to the db, works in conjunction with Work Flow db/app integrating many Hydro One dbs, apps
• Continued modifications and enhancements while maintaining multiple instances of the database through development, user acceptance testing (UAT), and system integration phases of the project

Business Analyst/Database Administrator/Developer

Confidential

Responsibilities:

• Production db programming, troubleshooting, data maintenance and user support for 800,000 customers
• Created managerial decision support PL/SQL queries on customers, premises and inventory for utility billing
• Possess in-depth knowledge of BANNER advance billing application - Oracle Developer 2000 Forms
• Work with Marketing, Software Implementation, Collections, Accounting and Information Technology managers and Customer Support Representatives to identify and resolve data inconsistencies
• Prepared project plans and estimates using Microsoft Project working directly with the CIO

Consultant

Confidential

Responsibilities:

• Network Support Analyst for this thriving Home and Auto Insurance brokerage
• Duties included installing software and troubleshooting network communication issues
• Additional activities included Database Design
• Created Oracle Forms and Reports using Oracle Developer 2000

Database Administrator/Developer

Confidential

Responsibilities:

• Oracle Database Administrat
• r and Application Designer/Developer for Canada’s largest restaurant chain
• Maintained database storage and online and batch application programs in a Unix environment
• Created Oracle Forms/Reports using Oracle Developer 2000
• Designed and implemented stored database procedures using advanced PL/SQL
• Created and executed SQL queries in Oracle and IBM DB2 databases to verify contents were in sync

Database Administrator/Developer

Confidential

Responsibilities:

• Oracle DBA/Developer for this pension administration firm
• Maintained db security, storage and user access for multiple dbs using Enterprise Manager and SQL*Plus
• Implemented db triggers, stored db procedures, reviewed data structures for integrity, auditing, performance
• Installed software upgrades and maintained version control on source programs
• Database design, create Oracle Forms and Reports and create intra-net website

Senior Oracle Consultant

Confidential

Responsibilities:

• Performed DBA, Senior System Analyst and Senior Programmer Analyst duties for various clients
• Installed Oracle RDBMS software, designed/created databases, moving data between databases
• Monitoring storage requirements, tuning queries and troubleshooting communications issues
• Unix scripting on UnixWare/Sco Unix to enable batch run programs, file manipulation, db backup/recovery

Confidential

Responsibilities:

• Created Unix Shell Scripts and PL/SQL stored procedures used to summarize investment data
• Custom reports detailed all aspects of costs of doing business in the Wealth Management department
• Used Cognos products to create cubes for reporting and Data Mining purposes from the Data Warehouse

Confidential

Responsibilities:

• Worked on a team of 3 developers to create/maintain custom PowerBuilder application on Sybase db
• Haematology lab data, Sybase Data Warehouse, displayed graphically in Object-Oriented, custom PB software

Confidential

Responsibilities:

• Designed and built PL/SQL routines used to load Oracle Datamart database for SAP implementation
• Worked with PeopleSoft Financials consultant, created formulas for Glass manufacture to load Supply Chain

Confidential

Responsibilities:

• Designed and built a PowerBuilder/Oracle application used to migrate data from one database to another
• PL/SQL programs had to be designed, developed and tested according to strict government regulations
• Trained junior staff member in PowerBuilder 5 PFC object-oriented application development techniques
• Worked with SAP team members to verify Oracle Data Warehouse contents for migration to SAP
• Maintained data and PowerBuilder application, provided reports used to verify consistency of the SAP data
• Performed DBA duties and Data Modeling using System Architect for modifications to DW schema

Confidential

Responsibilities:

• Worked as Database Administrator and Application Designer/Developer on Confidential ' sales database
• Screen and report design and development, also performed back-up, restoration and other DBA duties
• Created new Data Model to support Data Warehouse reporting/flat file extraction for Canadian restaurants

Confidential

Responsibilities:

• PowerBuilder object oriented application maintenance programmer
• Debugged and modified screens used in kiosks across Ontario for the New Business registration program
• I was also involved in the initial development of this pre-internet era communication module

Confidential

Responsibilities:

• Augment Data Model, build and implement PL/SQL routines, load the GIS from multiple MS Access dbs
• Maintained spatial db data for a layered topographical mapping of bear habitats, trails/wetlands in Ontario

Confidential

Responsibilities:

• Lead developer on SQL*Forms/ReportWriter project for the Ontario Ministry of Agriculture and Farming
• Developed and Debugged complex screens and reports for this system
• The Oracle database application maintained all information on government grants and university projects

Computer Programmer/Analyst

Confidential

Responsibilities:

• Created and maintained online and batch programs using Oracle tools and Pro*Cobol
• Developed form-based data manipulation screens using SQL*Forms 3.0
• Complex triggers and PL/SQL routines, calling print programs written in Pro*Cobol or ReportWriter on Unix
• Illustrations of screen layouts along with pseudo-code functionality was provided by the system designer
• I worked with a minimal amount of supervision to program the operations in the most efficient manner

Computer Operator

Confidential

Responsibilities:

• Trained on the job - Learned to use utilities to manipulate and maintain files in a Unix environment
• Performed nightly back-up of mainframe and micro-computers
• Attended George Brown College Computer Programming course full-time days while working afternoon shift
• Rapidly advanced to this insurance company’s Computer Programming department

CAD/CAM Operator - Robotics Programmer 

Confidential

Responsibilities:

• Used CAD software to design and program patterns cut in sheet metal on electric plasma arch cutting table
• Prepared accounting statements using Lotus 123
• Excellent organization and communication skills
• Quick to learn new responsibilities - Thank you for reading the entire CV