SUMMARY

• Database Analyst with extensive global systems development experience on financial trading and mission critical industrial systems.
• Demonstrated noledge in Database development, Database Administration, ETL, Systems Analysis, performance tuning, problem solving and application programming in a variety of languages.
• Ability to work TEMPeffectively cross functionally, with teams and all levels of management. Strong analytical, communication and interpersonal skills. Proven experience working with global teams, and for international clients in Canada, the US and Thailand. Self - starter, able to work under pressure on multiple simultaneous projects.
• Database Development
• Database Design
• Database Administration
• Application Programming
• Data Warehouse/ETL
• Analysis

TECHNICAL SKILLS

Database: PostgreSQL, Greenplum, DB2, MemSQL, MSSQL, Sybase, Oracle, MySQL, T-SQL, SQL, SQL/PL, PL/SQL, PL/pgSQL, MPSQL, ETL, SQL*Loader, DTS, Faircom.

Languages: Python, Perl, C, C++, C#, C++Builder, Delphi, UNIX Shell Scripting, Pascal, ASP

Tools: DBArtisan, pgAdmin, Toad, DBeaver, SSMS, Crystal Reports, SSRS, SSIS, ERWin, Silverrun, EDI, Excel, Autosys, Websphere MQ, SQL Developer, psql

Platforms: Linux, UNIX (HP-UX), QNX, Windows, Azure

PROFESSIONAL EXPERIENCE

Confidential, Montreal, QC

Database Consultant

Responsibilities:

• Develop data extraction procedures from internal systems in both Postgres and DB2 and using Python, Perl and Unix shell scripting.
• Validation of reporting / data integrity.
• Performed data management, data analysis, data migration, data modeling and database design in Postgres, DB2 and Sybase data warehouses.
• Analyze, troubleshoot and recommend database performance issues.
• Participated in code review and acceptance process.

Confidential, Montreal, QC

Database Consultant

Responsibilities:

• Migrate DDL and code from Oracle 11g to Postgres for Azure.
• Analyze and determine migration constraints between the 2 platforms.
• Troubleshoot and analyze any code or performance issues caused during migration.
• Evaluate availability of Postgres extensions as a replacement to Oracle functionality.

Confidential, Montreal, QC

DB Consultant

Responsibilities:

• Developed Oracle PL/SQL to extract and prepare data for consumption.
• Analyzed and created tables, pk, index, constraints.
• Troubleshoot and analyze database performance issues.

Confidential, Montreal, QC

DB Consultant/DBA

Responsibilities:

• Ported OLAP infrastructure from DB2 to the Greenplum columnar Postgres DB.
• Developed/Analyzed/Tested Postgres and DB2 database objects.
• Troubleshoot database performance issues.
• Provide technical database assistance to project team members and DBAs.
• Carried out performance assessments, optimization and tuning on Postgres and DB2 databases.
• Built proof of concept MemSQL loader to load billions of rows per day of data into a star schema database.
• Providing reporting to senior management.
• Monitored database performance, tracked stored procedures and queries’ execution times and implemented improvements on efficiency.

Confidential, Montreal, QC

DB2 Database Consultant, 2012 - 2013

Reporting to DM Development Manager, contracted to develop proof of concept solutions using mainframe DB2 and related technologies. Worked with DBA's, technical architects, developers and PMs to implement DB2 stored procedures in a new environment. Implemented software best practices and mentored junior/intermediate programmers. Optimized DB2 queries and procedures.

Key Responsibilities:

• Substantially improved system capabilities; delivered a 75% reduction in processing time for a complex OLAP procedure.
• Worked with a team spearheading a proof of concept to convert CoolGen DB2 SQL calls to stored procedures under challenging circumstances.
• Implemented database best practices and mentored junior/intermediate programmers.
• Analyzed/optimized SQL queries and stored procedures.

Confidential, Montreal, QC

Commodities Developer

Responsibilities:

• Optimized DB2 trading system reconciliation process to reduce total processing time by over 90%.
• Developed reconciliations against Firm reference data, substantially reducing inconsistent data leading to increased data reliability.
• Produced summary trade and regulatory reports for senior management.
• Developed an automated Sybase metadata extraction process. The automated process allowed developers to create new application screens 10 times faster TEMPthan the manual process.
• Developed Sybase, DB2 and SQL Server ETL scripts.

Confidential, Montreal

Consultant

Responsibilities:

• Integrated an RF based shipping system with a client’s production system reducing shipping mistakes by 98% and increasing inventory accuracy from 65% to 95%.
• Evaluated client needs and produced quotations for services to global customers which generated annual revenue in excess of $500,000.
• Designed and implemented a production optimization program which reduced waste, and allowed the client to generate annual savings of $1.4M.
• Supervised and trained a staff of 6 junior programmers. Coordinated training and implementation schedules with global client IT staff.

Confidential, Tampa

Responsibilities:

• Developed, tested and implemented over 200 Oracle ETL scripts in half the time budgeted for the project.
• Developed Oracle PL/SQL scripts/procedures/triggers.
• Troubleshoot database performance issues.

Confidential, Montreal

Programmer/Analyst

Responsibilities:

• Responsible for the analysis, design and development of mission-critical production tracking systems containing over 200 applications. These complex systems also handle quality management, inventory control, and interface to ERP systems for financial and inventory reporting.
• Provided 24-hour support to global clients on mission critical systems.
• Provided Y2K analysis and upgrade of existing software for clients with 100% success rate.