OBJECTIVE:

Seeking a consulting project with a dynamic company that will effectively utilize my consulting, technical experiences.

SUMMARY:

• Multiple data warehouse project with both relational and star - schema data structures.
• Four plus years in leading a warehouse DBA and development staff. Advise clients and team members in the area of technology, system implementation and process improvements.
• Data Warehouse experience with full life cycle, ETL tools, i.e. Ascential DataStage 7.x & 8.x, MS SQL 6.x, Oracle 10x, and Sybase 10.x database on NT and UNIX platforms.
• Ability to bridge gap between logical and physical models, i.e. Erwin, PowerSoft - S-Designor tools.
• Data Warehouse/Data Architect/Data Modeler.
• Multi-Dimensional Database Design, OLAP, Star Schema, dimensional data modeling.
• Guiding the development of interfaces between applications and databases to ensure that the interface specifications are met and to guide the data purification and conversion processes as well.
• Strong programming skills in Informix’s Universe application tools, Oracle PL/SQL and MS SQL.

COMPUTER LITERACY:

Network / Client OS: Windows NT 4.0, UNIX, Windows XP

DBMS: Oracle 7.x 8.x, 9.x, 10.x, MS SQL 6.x & 7.0 (MCP MS SQL 6.5), Sybase10x, MS Access 7.x, Personal Oracle 8.x, Paradox, Watcom

Software Application Tools: Visual InterDev 6.0, Visual Basic (5.0 & 6.0), Power Builder (3.x & 4.x), S-Designor 5.0, Crystal Reports 6.0, Information, Pick Basic, IBM Universe (9.4.3),Quest Toad (8.x), Erwin

EIS Reporting and Data Transformation Tools: Cognos Impromptu and Power Play, IBM Datastage 7x & 8.x, MS SQL 7 DTS

WORK EXPERIENCE:

Data Warehouse ETL Senior Consultant

Confidential, Wilmington, DE

Responsibilities:

• Responsible for the analysis, design, and development of data warehouses including data and workflow. Worked with the end user community to identify and satisfy the production, decision support requirements for the company as well as collaborated with the data warehouse experts and architects of the IT department in order to maintain the architecture and technology consistency with the rest of the corporation.
• Assessed the performance and capacity requirements of the data warehouse; made key technology decisions, verified that the architecture and implementation met all user requirements. Implemented and oversaw the development of interfaces between applications and databases (MSSQL Oracle) using the Ascential DataStage ETL tools to ensure that the interface specifications are met and to guide the data scrubbing and conversion processes.
• Lead the creation and designing of Cognos Powerplay and Impromptu reports for the financial end users.
• Analyzed, designed and enhanced the performance for creating distributed hash files to be used as lookups for value mappings.
• Redesigned and developed DataStage jobs to streamline the process and including improving the performance throughput of data extraction and load jobs.

DataStage Senior ETL Developer

Confidential, Deerfield, Illinois

Responsibilities:

• Worked on the development team on Pharmacy Data Warehouse project for the Legal Department.
• Develop DataStage jobs that extracted, transformed, and handled primary and foreign keys.
• Also analyzed existing code and provided guidance to other developers in order to construct code that was both efficient and maintainable.

Business Data Analyst

Confidential, Chicago, Illinois

Responsibilities:

• Performed data analysis and problem solving; developed metadata definitions from business rules, data model, documents the current operational processes and data sources to establish support for current and future reporting requirements.
• Developed and designed requirements for data mapping and data loading processes, assist with the development of the data model(s) for the data repository guided by the data warehouse architect. Provided recommendations for all data strategies and out-of-scope processes and assisted in the establishment and maintenance of the metadata management system, identified and enforced data standards to ensure consistent and maintainable application metadata.
• Performed source system analysis and design mapping logic between source systems and the Enterprise Data Warehouse, analyze data in source systems to assess data quality. In addition, worked with the in-house team member to review the existing Sagent ETL source system to remap and design the new ETL mapping for the DataStage jobs development.

Data Warehouse ETL Consultant

Confidential, Wilmington DE

Responsibilities:

• Analyzed existing code and provided guidance to other developers in order to construct code that was both efficient and maintainable.
• Designed and developed a set of robust and maintainable functions to shield the developers from the complexities of job management. These functions handled job execution, error reporting, records reprocessing, load balancing, and standards compliance.
• Utilized DataStage 7.5 to analyze and gain working knowledge of how data is extracted from current production source systems, transformed per client mappings specifications.
• Participated in determining necessary common ETL job changes as business requirements dictate for corporate business intelligent data warehouse.
• Analyzed and gained working knowledge of DataStage jobs that handle error management using hash files and Oracle tables, as well as DataStage job sequences to control job execution, triggering, and dependencies.
• Analyzed, designed and created distributed hash files to be used as lookups for value mappings.
• Developed and documented DataStage jobs including job flow.
• Designed and developed DataStage maintenance jobs to monitor the hash files growth and size for house cleaning.

Data Warehouse ETL Consultant

Confidential

Responsibilities:

• Utilized DataStage 7.1 to analyze and gain working knowledge of jobs used to populate SAP warehouse.
• Utilized DataStage 7.1 to analyze and gain working knowledge of how data is extracted from current production source systems, transformed per client mappings specifications.
• Participated in determining necessary common ETL job changes as business requirements dictate for France specific mappings.
• Analyzed and gained working knowledge of DataStage jobs that handle error management using hash files and Oracle tables.
• Analyzed and gained working knowledge of how hash files are created from Oracle tables to be used as lookups for value mappings.
• Documented DataStage jobs for main function. Document job flow.
• Analyzed and gained working knowledge of DataStage job sequences to control job execution, triggering, and dependencies.

Senior Manager Consultant

Confidential, Houston TX

Responsibilities:

• Senior level, managing consultant responsible for all aspects of custom application development projects including, functional and technical design, database management and optimization, project staffing and scheduling, as well as, strategic planning and technology evaluation.
• Lead DBA, data warehousing, DataStage - ETL and EIS reporting analyst.
• Responsible for managing, developing and designing multiple projects with full Profit/Loss responsibility for each engagement.

Senior Application Developer

Confidential

Responsibilities:

• Development of new software package for a midsize distribution and ‘pick & pack-hold packaging’ company in New Jersey.
• Using AREV 2.11 and AREV 3.1, Powerbuilder 3.x, 4.x; migrated applications from Lantastic to Confidential network.
• Ported applications to a client server environment using Power Builder and Sybase as a DBMS.

Product Design Manager & Sr. Consultant

Confidential, Short Hills, NJ

Responsibilities:

• Directed and managed the programming staff in the development of our multi-currency financial applications.
• The Confidential applications run on any minicomputer and Confidential runs in PC single or multi-user environments.
• My responsibilities included enhancing and implementing concepts, and improving the speed of our packages.