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.