Peningo Systems, Inc.

Contact: info@peningo.com

PEN21

Profile

A Data Warehouse Developer with over 10 years of experience in delivering feasible cross-platform solutions in the financial industry, mostly. Capable to execute or perform a task without assistance and capable to help or lead others to perform task at a high level. Comes with own set of data warehouse feasible technologies. Security Clearance and experience with government and large financial, telecommunication, and pharmaceutical corporations. A M.Sc. and F.L.M.I. (www.loma.org).

An ETL, Data Quality, and Metadata Repository Instructor.

Keywords:

AIX, Ascential, ASG, ASP.NET, Audit, Auditor, Basic, BI, BPwin, C, C++, C#, Cleansing, Clinical, Cobol, Cognos, Conceptual, Contextual, Control, CORE, Cube, Data, DataStage, DB2, DCOM, DW, DWC, EEE, EJB, Engineering, ERwin, Essbase, ETL, Extender, Extract, FileNET, Finance, Financial, FLMI, Framework, Geographical, GIS, HTML, Hyperion, Impromptu, Informatica, Inmon, Integrity, Internal, Investment, Java, JavaScript, JDBC, Kimball, Legacy, Linux, Load, Logical, Mapplets, Mart, Metadata, MetaRecon, Model, MQSeries, Multidimensional, MVS, Netezza, Normalization, NT, ODBC, ODS, OLAP, OLTP, Oracle, Oxley, Parallel, PeopleSoft, Perl, Physical, PL/SQL, Portal, PowerCenter, PowerPlay, ProC, ProfileStage, Profiling, QualityStage, Rational, Relational, Reverse, RIM, Rochade, Repository, s390, SAP, Sarbanes, Schema, Script, Server, Shell, Solaris, Spatial, Sphere, SQL, Star, Sybase, Teradata, Transform, Transparency, UDB, UML, Unix, Vality, VB, VB.NET, VBScript, VisionPLUS, Visual, VSAM, Warehouse, Web, Windows, XE, XML, Zachman

Projects Overview (Extract)

Hoffmann - La Roche, Nutley, NJ, 2004 - present

As a Corporate Transparency Auditor (NAFTA US TN classification: Computer Systems Analyst) has on site coached the development team and delivered key feasible solutions for the Corporate Transparency Audit, Internal Control, Sarbanes-Oxley Act, Sections 302 and 404, development in the Informatica PowerCenter, Oracle Clinical, and HP UNIX environment.

Feasible Solutions and Major Technologies:

< Corporate Transparency Audit, a metadata development and team coaching

- Corporate Data Exposure Internal Control under new US Corporate Transparency Regulation, Sarbanes-Oxley Act, Sections 302 and 404

- Advanced run time tracing and control of data and metadata through Informatica workflows, sessions, tasks, mappings, parameters, and users from Informatica Power Center Repository

- Informatica advanced normalization (row splitting) and de-normalization (row composing, one from multiple)

- Oracle PL/SQL, SQL, and Java JDBC views, procedures, and triggers

- C/C++, advanced file buffering, data transformations, Informatica Advanced External Procedure Transformations, API, HP Unix Bounded Non ANSI C Compiler

- HP Unix Shell Script for Informatica and Oracle

Enbridge, Consumers Gas, Toronto, ON, 2003

As a DataStage ETL Instructor (NAFTA US TN classification: Computer Systems Analyst) has on site coached the development team and delivered key feasible solutions for the Ascential DataStage ETL development in the Oracle and Solaris UNIX environment.

Feasible Solutions and Major Technologies:

< Ascential DataStage ETL, Oracle, and Solaris UNIX Shell Script development team coaching

- Advanced job execution redirection and warning handling from Ascential DataStage Sequence

- Ascential DataStage Shared Container concurrency

- ETL on table level instead of row level

- Pipeline and Partition Parallel Massive Data ETL

- Oracle PL/SQL cursor failure, ORA-01555 Snapshot Too Old, for large data transformations

- Solaris Unix Shell Script for Ascential DataStage and Oracle

Amex, American Express, Markham, ON Canada

Amex, American Express, Brighton, ES United Kingdom, 2003

As a Senior ETL Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Data Warehouse and Reporting derived from Credit Card Transaction Processing System based on the VisionPLUS, First Data (PaySys), and Pega. Directly saved $150,000 during first week on the project.

Feasible Solutions and Major Technologies:

< Data Warehouse and Reporting

- Logical, Physical, and Process Model: CA Platinum ERwin and Bpwin

- Credit Card Transaction Processing System: VisionPLUS, First Data (PaySys) and Pega

- ETL: DB2 UDB DWC, Data Warehouse Center

- Legacy (VisionPLUS) Data Access: First Data (PaySys) Information Access System

- Custom ETL Components for DB2 UDB DWC: VB.NET (Visual Basic)

- Enterprise OLTP and Data Warehouse: DB2 UDB EEE

- Enterprise Multidimensional Reporting: Hyperion Essbase, Cognos PowerPlay

- DBA DB2 UDB Optimization and Performance Tuning for Data Warehouse and Reporting

Canadian Imperial Bank of Commerce, Toronto, ON, 2003

As a Senior DataStage ETL Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Data Warehouse based on the CORE CGI CogniCase advanced Financial Processing Solutions for Customer Centric Approach that provides a reporting functionality and interface generator for Legislation & Taxation, Business Operations, Investment Management, Payment, and Contribution.

Feasible Solutions and Major Technologies:

< CORE Data Warehouse, Advanced Financial Processing Solutions for Customer Centric Approach

- Logical, Physical, and Process Model: CA Platinum ERwin and Bpwin

- Data Cleansing and Enriching: Ascential QualityStage (Vality Integrity)

- Data Source Profiling: Ascential ProfileStage (MetaRecon)

- ETL: Ascential DataStage XE Parallel Extender

- Data Transformation for DB2 UDB EEE: DataStage DB2 Stage

- Custom ETL Components for Parallel Jobs: DataStage Wrapped Stages

- Enterprise Financial Processing Solutions: CORE (CGI CogniCase)

- Enterprise OLTP and Data Warehouse: DB2 UDB EEE

- Enterprise BI Appliance: Netezza Performance Server (www.netezza.com)

Gap, San Francisco, CA, 2003

As a Senior DataStage ETL Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Oracle Financials Interface for the Financial Portal.

Feasible Solutions and Major Technologies:

< Oracle Financials Interface for the Financial Portal

- Logical, Physical, and Process Model: CA Platinum ERwin and Bpwin

- Data Cleansing and Enriching: Ascential Vality Integrity

- Data Source Profiling: Ascential MetaRecon

- ETL: Ascential DataStage XE Parallel Extender

- Data Transformation for Oracle: DataStage Oracle Stage

- Custom ETL Components for Parallel Jobs: DataStage Wrapped Stages, C/C++, Unix Shell Script

- Financial Modeling: Time Value of Money, Bond Pricing, Black Scholes Option Pricing, Capital Asset Pricing Model, Monte Carlo Methods, Forecasting

- Enterprise ERP: Oracle Financials, PeopleSoft

- Enterprise OLTP and Data Warehouse: Oracle

- Enterprise BI Appliance: Netezza Performance Server (www.netezza.com)

Bell Canada, Toronto, ON, 2003

As a Senior DataStage ETL Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Operational Data Store, ODS, for the NIM project, the implementation of a new advanced Network Inventory Management technology.

Feasible Solutions and Major Technologies:

< ODS for NIM the Network Inventory Management, an ETL by the Pattern development for extremely large and complex data vaults using Ascential DataStage in an Oracle and IBM DB2 environment. Data are Extracted, Transformed, and Loaded by their instrict pattern.

- Logical, Physical, and Process Model: CA Platinum ERwin and BPwin

- Data Cleansing and Enriching: Ascential Vality Integrity

- Data Source Profiling: Ascential MetaRecon

- ETL: Ascential DataStage XE Parallel Extender

- Data Transformation for Oracle: DataStage Oracle Stage

- Custom ETL Components for Parallel Jobs: DataStage Wrapped Stages

- Enterprise OLTP and Data Warehouse: Oracle

- Enterprise Operational Data Store: DB2 UDB, MQSeries

- Enterprise BI Appliance: Netezza Performance Server (www.netezza.com)

Bell Canada, Montreal, QC, 2002 - 2003

As a Senior DataStage ETL Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Operational Data Store, ODS, for the CUTTING EDGE project, the implementation of a new advanced telecommunication technology.

Feasible Solutions and Major Technologies:

< ODS for CuttingEdge a new telecommunication technology, an ETL development for extremely large volume of data of 2500 million records using Ascential DataStage in an NCR Teradata and IBM DB2 environment.

- Logical, Physical, and Process Model: CA Platinum ERwin and BPwin

- Data Cleansing and Enriching: Ascential Vality Integrity

- Data Source Profiling: Ascential MetaRecon

- ETL: Ascential DataStage XE Parallel Extender

- Data Transformation for NCR Teradata: DataStage Teradata Stage

- Custom ETL Components for Parallel Jobs: DataStage Wrapped Stages

- Enterprise Data Warehouse: NCR Teradata

- Enterprise DW Appliance: NCR Teradata

- Enterprise Operational Data Store: DB2 UDB, MQSeries

- Enterprise BI Appliance: Netezza Performance Server (www.netezza.com)

WCB Alberta, Edmonton, AB, 2001 - 2002

As a Senior Metadata Repository Developer and Administrator (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the ASG Rochade Metadata Repository, a high performance enterprise level metadata management system. Problem Identification, Metadata Repository Information Model (RIM) Customization, New RIM Development, Metadata Repository Installation and Administration. Worked in the team with John Zachman personal participation.

Feasible Solutions and Major Technologies:

< Metadata Repository (ASG Rochade) Development and Implementation for Enterprise Level Metadata Management

- Enterprise Architecture: Zachman Framework, Column DATA (What) and Column FUNCTION (How), Rows Contextual, Conceptual, Logical, and Physical

- Metadata Repository: ASG Rochade

- Logical, Physical, and Process Model: CA Platinum ERwin and BPwin, Rational Rose

- Metadata Cleansing and Enriching: Ascential Vality Integrity

- Metadata Source Profiling: Ascential MetaRecon

- ETL, Metadata Extract, Transform, Load: Customized Scanners and Buses, XML, Ascential Data Stage, C#, ODBC/OLEDB, SQL, RoLoader, Perl

- GUI, Metadata Portal: RoAccess, Perl, HTML, ASP.NET, VB.NET, SQL, SQL Server 2000

- Metadata RIM Model and Reverse Engineering: XML, Erwin, SQL Server

- Metadata Reporting and BI: Cognos Impromptu, Cognos IWR, Crystal Reports

- Metadata Administration, Application Hierarchy, Content Versioning, Content Check In/Out, Performance Tuning, Optimization, User Management, Security

Ministry of Health, Ontario, 2000 - 2001

As a Senior Data Warehouse Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the ARIS and GIS Data Warehouse, a high performance data management system. Problem Identification, Logical and Physical Relational Model, Metadata Repository, VSAM Catalogue, Multidimensional Model, ETL from Legacy (VSAM) to Relational (SQL) and from Relational (SQL) to Spatial (BLOB) and Multidimensional (OLAP) Storage, DBA SQL Server and DB2 UDB Optimization and Performance Tuning for Data Warehouse.

Feasible Solutions and Major Technologies:

< ARIS (Emergency Call and Dispatch Tracking System) and GIS (Geographic Information System) Data Warehouse Development and Implementation for tracking of several millions calls and several hundred million corresponding records per year, deriving from Data Warehouse and daily update of three Data Marts for Emergency Response Analysis and Multidimensional Reporting, Surface Vehicles Data Mart, Fixed Wing Data Mart, and Rotating Wings Data Mart. Bulk Volume transformed 50 million rows per 9 minutes

- Enterprise Architecture: Zachman Framework, Column DATA (What) and Column FUNCTION (How), Rows Contextual, Conceptual, Logical, and Physical

- Metadata Repository: ASG Rochade, Informatica Metadata Repository

- Logical, Physical, and Process Model: CA Platinum ERwin and BPwin, Rational Rose

- Data Cleansing and Enriching: Ascential Vality Integrity

- Data Source Profiling: Ascential MetaRecon

- ETL: Informatica PowerCenter, Ascential DataStage

- Data Transformation Components: Informatica Transformations and Mappings, SQL, C/C++, ODBC, ADO

- Reusable ETL Components for Dimensions in the Star: Informatica Mapplets

- GUI Application Prototype: Informatica Developer, Visual Basic 6

- Star-Schema and Cubes: Cognos Transformer and PowerPlay

- Legacy Data Source: VSAM, Informatica PowerConnect for Mainframe

- Relational and Spatial (Geographical) Storage: MS SQL Server, DB2 UDB

- Multidimensional Storage: DB2 OLAP Server (Hyperion Essbase)

- Data Reports and BI: Cognos Impromptu, Cognos IWR, Crystal Reports

- DBA SQL Server and DB2 UDB Optimization and Performance Tuning for Data Warehouse

ISM - IBM Global Services, Toronto, ON, 1998 - 2000

As a Senior Data Warehouse Developer (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Data Vault and Historical Server for Data Warehouse, a high performance data management solution. Problem Identification, Logical and Physical Model, Metadata Repository, VSAM Catalogue, Multidimensional Model, ETL from Legacy (VSAM) to Relational (SQL) and from Relational (SQL) to Multidimensional (OLAP) Storage, DBA DB2 UDB Optimization and Performance Tuning for Data Warehouse. Derived 5,3 million customers Event Trigger Data Mart from 600 million customers Data Warehouse.

d.d. synergy GmbH, Hamburg, Germany, 1998

As a Document Data Warehouse Instructor (NAFTA US TN classification: Computer Systems Analyst) has lead development and delivered key feasible solutions for the Panagon Document Warehouse for SAP, a high performance document data archiving and document management solution for SAP R/3, based on FileNet, ready to expand on the North American market, with SAP R/3, DCOM, RDO, BAPI, RFC, Rational Rose, Visual Basic, C/C++, ODBC, PL/SQL, Oracle, FileNET, Microsoft Windows Visual ANSI C/C++ Compiler, HP Unix Bounded Non ANSI C Compiler, HP UX UNIX Shell Script, vi, sed, makefile

Glaxo Wellcome Inc., Mississauga, ON, 1997 - 1998

As an Oracle ProC Data Warehouse Developer (NAFTA US TN classification: Computer Systems Analyst) has delivered the re-alignment of the Customer Management GIS System Data Mart, an Oracle ProC based ETL application on HP UX that reengineering and expanding local Great Toronto Area database system in order to cover all world customer service, with Oracle ProC and PL/SQL on HP UX, Cognos Impromptu, ERwin, C/C++, HP UNIX Shell Script

IBM Canada Ltd., Toronto, ON, 1996 - 1997

As a DB2 UDB Engine Developer (NAFTA US TN classification: Computer Systems Analyst) has developed the Embedded SQL Precompilers for C/C++, Cobol and Java for the DB2 UDB Version 5, a world leading all platform Universal Database Server.

Spectra Securities Software Inc., Toronto, ON, 1995 - 1996

As a Senior Software Developer (NAFTA US TN classification: Computer Systems Analyst) has developed the Retail Order Management - Fixed Income, a three - tiered real time order entry and information link between sales and trading personnel (Financial Modeling) with Oracle ProC, Sybase OpenClient OpenServer, C++, RPC on Windows NT and Solaris

Westbury Canadian Life, Hamilton, ON, 1995

As a Senior Programmer/Analyst (NAFTA US TN classification: Computer Systems Analyst) has developed the Library of functions (DLL) for the insurance actuarial mathematics (Financial Modeling) and Product Illustration System with C++, Rational Rose, sDesigner, ODBC, and MS SQL Server

Delrina Corp., Toronto, ON, 1994 - 1995

As a Senior FormFlow Developer (NAFTA US TN classification: Computer Systems Analyst) has developed the DLLs for FormFlow and WinFax, for xBase, Paradox, and ODBC database support with C++ and ODBC

ODIN Technologies for Global Travel, Toronto, ON, 1993 - 1994

As a Systems Developer (NAFTA US TN classification: Computer Systems Analyst) has developed the Matrix Transaction Specification System, an automated tool for the ETL and Reverse Engendering of the mainframe based data warehouse transactions for porting to UNIX with C++, ODBC, Sybase, IPSYS Information Engineering Toolset (James Martin Information Systems Framework), AIX UNIX Shell Script

For more information about these and other project unique feasible solutions and technologies or for a feasible solution for your project call me for a detailed interview.