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 SKILLS

  • 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 achievement 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.

Hire Now