SUMMARY:

Extensive data warehousing, data design, systems analysis, process modeling including development and production support experience within the Retail, Health Care and Banking industries .

TECHNICAL SUMMARY:

BI Solutions | Data Warehousing & Dimensional Modeling | ETL| IBM Ascential DataStage | Salesforce | BW | Oracle | Toad | Business Objects | Maestro 8.1 | MicroStrategy 7.2.2 | SQL | SQL*Plus | SQL* Loader | UNIX AIX | Windows NT| MS Office | AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Data Warehouse/ETL Consultant

Responsibilities:

• Deployment and support of ETL processes in data warehouse environments.
• Tuning of mission critical databases.
• Document and communicate the status of progress against plans, taking corrective action as necessary.
• Identify, clarify, and resolve project activity issues and risks, escalating them as needed.

Confidential, San Francisco, CA

Data Warehouse ETL - DataStage Consultant

Responsibilities:

• Analyzed source and target databases for data profiling and patterns.
• Developed source to target mappings and technical specification for ETL programs.
• Designed and develop DataStage ETL codes.
• Loaded data feeds from various sources into Target.
• Designed reconciliation and data validation processes.
• Collaborated with Project Manager, Tech Lead, and Business SMEs to ensure delivered solutions optimally support the of business outcomes for Inventory Planning System.

Confidential, San Francisco, CA

Data Warehouse/BI Development and Support Analyst

Responsibilities:

• Designed the data structures necessary to capture required data elements.
• Designed necessary IBM DataStage processes to map required data from source systems to target data structures.
• Analyzed and identified source data elements, extract logic and processing strategy.
• Designed data flows through any intermediary data stores.
• Identified interfaces (inputs/outputs) influencing or impacting BI applications or supported process streams.
• Analyzed, designed, coded, tested and/or debugged application programs.
• Resolved and supported processing problems as they occurred.

Confidential, Dublin, CA

ETL Consultant

Responsibilities:

• Customized and implemented DataStage jobs for PeopleSoft EPM data warehouse and analytical application.
• Designed and developed SQL and Ascential DataStage jobs required to extract, transform, clean and move data into data warehouse and for the management information reporting system.
• Developed and tested extraction, transformation and load (ETL) processes.
• Mapped source system data to data warehouse models and maintained data conformity rules.
• Worked with business requirements analyst to identify and understand business rules, data definitions, source system data models and information reporting requirements.

Confidential, Concord, CA

AVP, Consultant Application Programmer

Responsibilities:

• Designed, developed, implemented and supported complex enhancements to the data warehouse using SQL and DataStage.
• Developed functional and technical design, business and technical requirements, project scope and project plan.
• Participated in the data warehouse schema redesign.
• Designed ETL- DataStage Parallel Extender for the redesign of the GPS-MIS data warehouse.
• Designed, developed and tested ETL DataStage jobs for data warehouse redesign project.
• Analyzed and suggested resolution to various issues of moderate to complex nature resulting from multiple SIT and UAT cycles for GPS-MIS Client Market View redesign project.
• Designed and developed SQL scripts for creating Data Marts.
• Created detailed run-books for executing batch cycles in the production and UAT environments.
• Created and implemented Maestro job schedules on new production server.

Confidential, San Francisco, CA

Application Systems Engineer

Responsibilities:

• Designed and developed an integrated customer database to convert wholesale banking customers to new products and accounts.
• Designed and developed a data warehouse that provided a robust, accessible, data analysis facility for marketing, finance and product groups.
• Participated in the design, development and implementation of an Oracle Express application for product management analysis.
• Analyzed requirements and designed systems and processes.
• Developed specifications and test processes.
• Developed test plans and scripts.
• Designed and implemented various data load strategies.