SUMMARY:

• Database administrator, developer, and QA analyst with over seventeen years of experience. Proven skills in database technology, quality assurance, tools development, automation and problem determination.
• Broad industry experience: academic, banking, consumer goods, financial, government, healthcare, logistics, media, publishing, software (services and development), retail and telecommunications.
• University Bachelor’s and Master’s degrees in engineering. Multiple IT s.
• Superior communications skills. Published author in leading journals. Knowledge of four languages: English (Native fluency), Spanish (Native fluency), French (Professional fluency) and Portuguese (Professional fluency).
• Professional Engineer in the Canadian province of Ontario. Pursuing Canadian Chartered Professional Accountant (CPA) designation.

TECHNICAL SKILLS:

s: IBM Certified Advanced DBA, IBM Certified DBA, IBM Certified Application Developer, IBM Certified Database Associate.

Operating Systems: Linux, UNIX (AIX, HP - UX, Solaris), Windows, zOS, i5/OS.

Languages: .NET, Java, C/C++, Perl, UNIX Shell scripting (Korn, C, Bourne), Python, XML, HTML.

Databases: DB2 UDB for LUW, DB2 for zOS, SQL Server, DB2 for i, Oracle.

System Tools: Visual Studio, Rational Application Developer, Rational Rose, ERWin, Rational Data Architect, SAP PowerDesigner, CMVC, PVCS, Clearcase/Clearquest, VSTS, Tivoli Workload Scheduler.

PROFESSIONAL EXPERIENCE:

Consulting DBA

Confidential

Responsibilities:

• Db2 database administrator of Enterprise Data Warehouse on AIX, using database partitioning feature. Administration of IIAS.
• Supported Informatica and SAS applications.
• DB2 Database administrator on AIX, Linux and Windows, including implementations with PureScale feature.
• Supported Datastage, MDM and Pega applications.

Consulting DBA

Confidential

Responsibilities:

• Supported distributed and multi-partitioned DB2 for LUW databases at BMO's Scarborough Computing Center, versions 9.7, 10.1, 10.5 and 11.1.
• Applications supported included SAP, PeopleSoft, Norkom and WebFOCUS. Database ETL tools included Informatica and Ab Initio.
• Developed scripts in Korn shell, Perl and Python to perform database maintenance and ad-hoc tasks.
• Operated in highly regulated environment. Extensive use of CMMI methods and documentation.

Consulting DBA

Confidential

Responsibilities:

• Worked onsite at Nestlé global headquarters in Vevey, Switzerland, for IBM’s Nestlé global account team. Served as a supporting DB2 database consultant for Nestlé’s DB2 for LUW+SAP environment, at the time the second largest of its type in the world.
• Managed IBM PMRs and APARs for Nestlé. Managed meetings between IBM support and the customer. Managed Nestlé’s database special build requirements.
• Advised and contributed on the application of new DB2 database features to Nestlé’s landscape: range partitioning in DB2 version 9.7; adaptive compression in DB2 version 10.1; BLU technology in DB2 for LUW version 10.5.
• Participated in proof of concept project involving IBM's high capacity transactional database product, DB2 pureScale.
• Participated in proof of concept project to deploy SAP HANA and DB2 BLU columnar database solutions. Analyzed strengths and weaknesses of both products in warehouse and transactional environments. Considered migration scenarios from DB2 v10.1 to SAP HANA. Worked closely with functional analysts and business users to ensure migrations would not lead to a degradation of performance and functionality.
• Developed and maintained Korn-shell scripts for deployment via Tivoli Workload Scheduler.

Consultant Independent Consultant

Confidential

Responsibilities:

• Software consultant specializing in database administration and development, and software quality assurance, providing services in cities and towns across North America, Europe and the Middle East.
• Advised on database logical and physical design, maintenance, performance and security issues for DB2 databases as large as 300 TB. Tasks were performed on and single and multiple-partition databases.
• Monitored and performance-tuned various Data Warehouse and OLTP database environments. Setup and configured DB2 Federation, Replication (SQL and Q), Infosphere CDC, HADR, WLM and DB2 Performance Expert. Applications run against supported databases have included: Ab Initio, Callidus, Cognos, Informatica, Lawson, Microstrategy, SAP, Peoplesoft, SuitCASE, Webfocus and Websphere Application Server.
• Developed user-defined functions and stored procedures in PL SQL.
• Advanced knowledge of technologies such as DB2 Everyplace, DB2 for iSeries, DB2 for zOS, SQL Server, Oracle and Websphere Application Server. Familiarity with IBM TotalStorage, HP EVA and EMC storage solutions.
• Performed quality assurance services for database and telecommunications related software.
• Customers have included some of the largest companies in the world:
• Aastra Technologies
• Bank of Montreal
• Callidus Software
• Canadian Blood Services
• Circuit City Stores
• CSC
• Diebold-Noxdorf
• EBSCO Industries
• HealthNow New York
• IBM
• K&K America
• Saudi Ministry of Interior
• The Law Society of Upper Canada
• Lowes Companies Inc.
• Marketron International
• MCAP
• Nestlé S.A.
• New York University
• NASDAQ OMX
• Pacific Sunwear Stores
• Siemens
• Sun Products Corporation
• Toronto Dominion Bank
• Ticketmaster Entertainment.
• TransX Group
• Winners Merchants International
• Unitrin Inc.

Software Developer

Confidential

Responsibilities:

• Tested software during the development lifecycle of versions 6, 7 and 8 of IBM’s flagship database product, DB2 UDB for Linux, UNIX and Windows, finding hundreds of defects and saving the company thousands of dollars in support costs.
• Developed and maintained tools for the automation of database testing using different database access APIs, including SQL PL, CLP, JDBC, ODBC, OleDB and .NET.
• Led the effort to develop tools written in C/C++, Java and C#.NET for the automatic generation of C#.NET stored procedures, as part of IBM Data Management’s effort to test DB2 UDB v8.2’s new CLR routine capabilities.
• Assisted with DB2 UDB’s globalization testing, writing test cases and serving as a liaison between the translators and the GUI developers, thus making the software available in dozens of languages.
• Wrote three papers in leading trade press publications, detailing some of DB2 UDB’s capabilities.

Intern Software Developer

Confidential

Responsibilities:

• Built web-based Java application to provide online tool for printed circuit board designers within the company.
• Implemented algorithms for electromagnetic and thermal measurement and network design models.