We provide IT Staff Augmentation Services!

Data Warehouse/etl Consultant Resume

San Jose, CA

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.

Hire Now