SUMMARY:

• Senior data warehouse and BI architect and PM with proven ability in multiple full life - cycle data warehousing and BI implementation and project leadership, spanning requirements definition, data architect, data modeling, database design, ETL, OLAP, enterprise reporting, integration testing, DBA and production rollout.
• Eight years combined project management, planning, team leadership and coordination experiences
• Extensive experience in all aspects of business intelligence projects including business analysis, data analysis, data architect/modeling, ETL, and presentation layer.
• Hands-on knowledge of best practices for design, build, testing, and deployment of all technical layers of analytic systems including DW, ETL, BI security and presentation layer.
• ETL: DataStage, Pentaho Kettle and Informatica PowerCenter architect, administration, design and development.
• BI and OLAP: Cognos 10 BI, PowerPlay, Pentaho BI and Tableau.
• Extensive hands-on experience in SQL, Erwin, PL/SQL, UNIX and UNIX shell script, Windows.
• Extensive experience in Oracle, MS SQL Server, DB2, and Teradata.
• OCP-certified Oracle DBA with 3+ years of Oracle DBA experience.
• Excellent problem-solving skills and ability to learn new technology quickly.

EXPERIENCE:

Data Warehouse Architect

Confidential, San Francisco, CA

Responsibilities:

• Designed the dimensional data model for external data evaluation project.
• Provided technical leadership and architect on the DataStage upgrade and migration.
• Installed and set up IIS 11.5 environment for FRB at San Francisco
• DataStage Administrator for the FRB DW team in San Francisco
• Designed and developed the ETL process for the external data evaluation project.

Data Architect Consultant

Confidential

Responsibilities:

• Defined the project scope and requirements; provided the solutions; discovered source data; performed data profiling; designed the dimensional models and source to target mapping; designed the ETL framework and process using Kettle ETL tool for: an eCommerce data warehouse project and a franchised restaurant data warehouse project in Shanghai, China. a manufacturing data warehouse project in Wuzhou, China. a power supplier data warehouse project in Guangzhou, China.
• Provided the training classes on DataStage and Data Modeling in Shanghai, China.

Senior Consultant

Confidential, Westlake Village, CA

Responsibilities:

• Performed administrative tasks for the supply chain BI system which included Oracle, DataStage, Cognos BI and Oracle’s APEX.
• Provided secondary technical and administrative support for mixed Unix/Windows Data Warehouse environment.
• Performed IBM Information Server 8.7 installation, environment set up and administration;
• Defined the ETL conversion architect and standards;
• Lead the daily meetings to resolve the technical issues during the conversion;
• Lead and performed the data migration and go-live activities.
• Performed DBA support for the system’s oracle databases.
• Performed performance tuning of the views and materialized views.
• Developed an automatic mechanism and process of both unix and wintel servers performance monitoring.

Consultant

Confidential, Chicago, IL

Responsibilities:

• Set ETL architecture and naming standards;
• Designed and developed error handling process;
• Defined and designed the parameter sets;
• Led a project on DataStage job performance benchmark/tuning and configuration optimization;
• Defined code development, backup, version control and migration standards and guidelines;
• Performed DataStage admin tasks.
• Worked in the data modeling team to design the data model using ERwin;
• Designed and developed the Data Integration’s error handling, email notification and file movement components;
• Designed item related master data and item cost DataStage ETL processes;
• Coordinated the SIT, UAT and Pre-Production testing and scheduling tasks.

Data Analyst

Confidential, Irvine, CA

Responsibilities:

• Designed and lead developed Commission Extraction DataStage ETL process;
• Designed Partner Analytics DataStage ETL process;
• Managed the offshore development team of Partner Analytics datamart;
• Technical Lead on the enterprise master data in the area of Organization Party.

Principal Consultant

Confidential, Chicago, IL

Responsibilities:

• Developed strategy and plan to conduct business interviews following the master plan methodology;
• Led and facilitated interviews to capture Business Drivers, Operational and Analytical Data Needs and Data Quality Issues and requirements;
• Delivered the Needs Assessment Document to the client;
• Worked with the Technical Track Team to develop the Target Information Architecture and ensure the integration of business needs in the final recommendation.
• Participated in business requirement definition, data analysis and data modeling;
• Defined the project plans and managed the timelines;
• Designed and documented the Informatica PowerCenter ETL architecture and process;
• Led and/or coordinated the ETL, SIT and UAT teams.

Lead ETL Designer

Confidential, Minneapolis, MN

Responsibilities:

• Designed the detailed ETL process based on the tool’s best practice;
• Managed and worked with the offshore development team;
• Built the constructive, trusted and long-term client relationship by helping them solving their issues and provide advises;
• Hosted the design team’s daily defect meetings.

BI Architect

Confidential, Buffalo, New York

Responsibilities:

• Proposed a rework of Cognos metadata modeling and led the rework team;
• Conducted the complex metadata modeling with Cognos best practice so that the model gives predictable queries and results;
• Led the effort of testing, validation and migration of the metadata model to production.

ETL Architect/Designer and Data Analyst

Confidential, Pleasanton, CA

Responsibilities:

• Defined and documented the ETL architecture;
• Designed the detailed ETL jobs and worked with the offshore development team;
• Analyzed, identified and documented the data quality issues of various data sources;
• Participated in the development of various reports using MicroStrategy.

ETL Lead / Designer

Confidential, Milwaukee, WI

Responsibilities:

• Led the DataStage ETL team for more than 15 months;
• Designed and developed the DataStage ETL jobs;
• Developed and implemented the audit, balance and control (ABC) process;
• Coordinated and participated in defect correction, documentation, knowledge transfer, client training, and production support.

Senior Data Warehouse Architect

Confidential, Pleasanton, CA

Responsibilities:

• Defined user requirements and system architecture;
• Developed ETL jobs using DataStage to populate the data warehouse and data mart by integrating multiple data sources;
• Designed and created 10 multi-dimensional cubes for OLAP analysis of member transaction, loan risk and finance;
• Designed and created canned Impromptu reports;
• Developed the data warehouse administration/data input user interface using VB.NET;
• Created and maintained the Cognos catalog;
• Led system integration testing, performance tuning, and production rollout.

Senior Consultant

Confidential, Redwood City, CA

Responsibilities:

• Defined user requirements and system architecture;
• Set up and managed development and production environments, which included Oracle database servers, E.piphany application servers, and Web servers;
• Developed star schema;
• Implemented data extractors and data loaders;
• Conducted data loading, aggregation and validation;
• Led system integration testing, performance tuning, and production rollout;

Staff Research Engineer

Confidential, Pleasanton, CA

Responsibilities:

• Key member of the team to develop computer models that simulated the dynamic behavior of the reduction cell. The models were developed using Visual C++.
• Developed Stub-to-carbon voltage drop and stress models using Visual C++ and StingRay’s ObjectiveGrid . The model uses the grid control as the user interface for input and output.
• Developed the graphic user interface for Kaiser’s rolling model package using Visual Basic.