Data Warehouse/ETL Consultant Resume San Jose, CA - Hire IT People

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:

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.

We provide IT Staff Augmentation Services!

Data Warehouse/etl Consultant Resume

San Jose, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship