Project Manager Data Warehouse

Afsaneh Farvard

***************@*****.***

C: 925-***-****

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 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

Sephora, San Francisco, CA

May 2012 to Oct 2012

Data Warehouse ETL - DataStage Consultant

. Collaborated with Project Manager, Tech Lead, and Business SMEs to

ensure delivered solutions optimally support the achievement of

business outcomes for Inventory Planning System.

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

McKesson, San Francisco, CA

Data Warehouse/BI Development and Support Analyst

Feb 2006 to Mar 2012

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

Franklin Templeton Investments, Dublin, CA

ETL Consultant

Jun 2005 to Oct 2005

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

Bank of America, Concord, CA

AVP, Consultant Application Programmer

Aug 2000 to Apr 2005

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

Wells Fargo Bank, San Francisco, CA

Application Systems Engineer

Oct 1995 to Aug 2000

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

Education

B.S., Bachelors of Science, Business Information and Computing Systems, San

Francisco State University

Professional Development

. SAP BW Education 2009-2010

. Ascential Software DataStage Parallel Extender Essentials 2003

. Ascential Software DataStage 314 Svr 2003

. MicroStrategy Reporting 2002

. Kimball University, Data Warehouse Lifecycle in Depth 2001

. C++, HTML, JavaScript - training 1999-2000

. Oracle Express Database Design and Control 1998

. Oracle Sales Analyzer for Administrators 1998

Contact this candidate