OBJECTIVE

• Data Warehouse developer in Informatica PowerCenter (8.6), Oracle/Sybase/SQL Server, Unix, and job scheduler such as Autosys and Control - M.

SUMMARY

• 8+ years of ETL experience in the Informatica PowerCenter and PowerExchange, and UNIX

TECHNICAL SKILLS

• Informatica PowerCenter (8.5)
• PowerExchange
• Cognos DecisionStream
• Oracle (10g)
• PL/SQL
• SQL/Plus
• SQL/Loader
• Sybase isql
• Teradata
• Microstragy
• Business Object
• Cognos Framework Manager
• Cognos Transformer
• Cognos Powerplay
• Cognos Impromptu
• PVCS
• Control-M
• Tivoli Maestro
• Autosys
• CRON
• UNIX (IBM AIX
• HP UNIX
• Sun Solaris)
• Korn & Bourne Shell Scripts
• Perl scripts
• Sed & Awk
• Business Objects
• C/C++

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Data Warehouse Developer

Responsibilities:

• Lead the ETL development project to build the IDB (Investment Database) for APEX users (Portfolio managers) using Morgan Stanley Composite Index source data and Bloomberg source data using Informatica PowerCenter 8.6
• Designed the star schema model with dimension and fact tables with ERWIN and implemented the logical model and physical model
• Performed the performance tuning using explain plan and revise the SQL with bottleneck
• Developed and improved the Oracle stored procedures and package header/body called by various programs and scripts
• Monitored and maintained the Oracle Database using TOAD
• Developed the Korn shell scripts to control the Informatica workflows, invoke the PL/SQL stored procedures and packages
• Developed the Requirement Solution Document and Detail design document for the development
• Developed the data cleansing process with Informatica data cleansing product, especially address fields, using USPS data
• Develop the Informatica ETL process with various source systems (XML source files, MQ series, Sybase, Oracle, Mainframe files) and Oracle target database
• Migrate the Informatica components from DEV repository through PROD repository via QA repository using folder migration, export/import XML, and copy/paste methods
• Manage the Informatica repositories such as back up the repository, start/stop/restart the repository, performance tuning
• Implement and support the production jobs based on AUTOSYS job scheduler
• Design and develop the multi-dimensional model using Cognos Framework Manager and export the model with IQD
• Design and develop the multi-dimensional OLAP cube using PowerPlay Transformer
• Support production Cognos web portal to manage the OLAP cube and folders
• Design and develop the web portal report using Report Studio and Query Studio
• Deploy the multi-dimensional cube into the Cognos Web Portal environment
• Design the logical data model and physical data model for the data warehouse system using ERWIN
• Design and develop the ETL process to extract the source to star schema with ETL tool

Confidential, Irvine, CA

Data Warehouse Developer

Responsibilities:

• Design the ETL process between ODS (operational data source) and EDW (enterprise data warehouse)
• Design the Data mart for lending service area
• Design the target data model with ERWIN and build the logical and physical data model
• Develop the Informatica workflows to extract the mainframe data with PowerExchange and load the data into Oracle tables for Microstrategy BI tools
• Develop the Requirement Solution Document with users group for the development project
• Develop the Detail Design Document for coding and unit testing plus QA testing strategy and production migration plan
• Work with other Business Intelligence (Microstrategy) team members, data base administrator, and user groups
• Develop and enhance the best practice guide for designing, developing, testing, and production version control with Informatica Powercenter
• Convert the SQL/Loader and C++ programs to Informatica ETL process
• Develop the Informatica workflows, sessions, and mappings to extract the various source data (Oracle, mainframe, Sybase, flat files) and load the target tables (Oracle)
• Develop the perl scripts to extract, transform, and load the Sybase data base
• Develop the korn shell scripts (wrapper) to manage and simulate the scheduled jobs at UAT environment

Confidential, Santa Ana, CA

Data Warehouse Specialist

Responsibilities:

• Support the production e-Business data warehouse system.
• Develop the internet market system data mart and interface system between Google and Yahoo
• Enhance the existing web data warehouse system to collect the web log and provide the extraction for data mining
• Design new EDW Enterprise Data Warehouse system with Teradata, Oracle, Informatica, and AIX servers.
• Design and develop the data warehouse for the Global Institute Billing System
• Develop the ETL Architect document for the Global Institute Billing System
• Design the logical data model and physical data model for the data warehouse system
• Develop eDoc data warehouse migration programs to retrieve PDF (BLOB) and XML (CLOB) files from the enterprise data warehouse (Oracle 10g), store the BLOB/CLOB files in the UNIX directory, and ZIP/FTP the BLOB/CLOB files.
• Develop the ETL part for Dash Board projects using Informatica
• Develop the data integration projects using Informatica ETL tool
• Develop the data cleansing process for address tables using Informatica data cleansing tool
• Develop PL/SQL programs and stored procedure programs in Oracle 10g
• Manage Informatica Repositories for Production, QA, and Development environments
• Perform folder organization, security, migration, and backup/restore tasks
• With meta database query, manage the connection string, sequence generator, and AIX file directory items at the different environments
• Support job scheduling with Informatica scheduler and Tivoli job scheduler.

Confidential, Torrance, CA

Data Warehouse Developer

Responsibilities:

• Develop ETL processes with Informatica ETL tools in the UDB, DB2, MS-SQL server and AIX environments
• Develop SAS application for data mining processes in UNIX, Mainframe environments
• Develop shell scripts for job triggering processes and control the ETL processes in the AIX environment
• Manage Informatica Repositories for Production, QA, and Development environments
• Perform folder organization, security, migration, and backup/restore tasks
• With meta database query, manage the connection string, sequence generator, and AIX file directory items at the different environments
• Support job scheduling with Informatica scheduler, and Control-M

Confidential, Chicago, IL

Application Specialist II

Responsibilities:

• Design and Develop the ETL processes for Phoenix Medical and Dental systems using Informatica, Oracle, and Teradata environment
• Develop ETL module (1 star schema with 7 tables) for Executive Dash Board (EDB) project with Informatica ETL tool
• Develop new data warehouse system using Informatica ETL tool in the Unix (HP-UX and AIX), Oracle, Mainframe and DB2 environment
• Develop (analysis, design, coding, test, implementation, document) the data warehouse back-end system using Oracle, SQL/PLUS, PL/SQL, and Korn / Bourne shell script
• Enhance Cognos Impromptu and Powerplay components
• Lead the Oracle new development project technically and provide better solutions for performance issues
• Improve SQL performance with SQL tuning tool
• Develop the extract, transform, and load system between mainframe DB2 and Unix Oracle databases
• Provide (and generate) ad-hoc query reports mainframe jobs for user groups
• Take over on-call responsibilities of both IBM mainframe and Unix production system
• Develop ‘How to guide’ document for new project members and other project members

Confidential, Elk Grove, IL

Senior Analyst

Responsibilities:

• Be in charge of Aircraft scheduling and planning system in HP Unix Oracle and IBM mainframe DB2/SAS environments
• Support crew (pilot and flight attendants) scheduling system
• Take over DBA responsibilities to load and unload the Oracle and DB2 tables, performance tuning, and version upgrade
• Develop and support the airline schedule dissemination system in Unix Oracle and C/C++
• Develop and support airlines code share system for Confidential and its code share partners, Star Alliances, based on the optimization models