Ann Chen Email & Phone Number

Daly City, CA, US

San Francisco Bay Area

San Francisco Bay Area

Vancouver, Canada Area

Senior DataStage ETL Developer for Safeway – ICE (Integration Center of Excellence) team. General responsibilities for ICE Team:Assist with the requirements definition, analysis and high-level design of Integration projectsProvide feedback and recommend practices on the overall architecture of the applicationReview and provide feedback on DataStage design.

Portland, Oregon Area

Senior DataStage ETL Developer for The Standard Insurance – CTA (California Teachers Association) project. · Involved in all the five technologies that were implemented for the CTA/UNUM project. WebSphere Customer Center (WCC), DataStage, QualityStage, WebSphere Message Broker (WMB) and MQSeries. · Primarily involved in coding, designing, developing with.

Kent, WA

Senior DataStage ETL Developer for REI Product Data Hub project. REI Product Data Hub is an infrastructure investment in support of data integration and architecture across REI’s enterprise. Responsibilities are Analysis, Coding, Designing, Developing, and Testing all DataStage jobs, job sequencers, and scripts. DataStage version 7.5.2, server on Linux.

Santa Clara, CA

Senior DataStage Developer for Data Mart team for QACK system (Questions Answers Comments and Knowledge System). DataStage version 7.x, server on UNIX Platform, Oracle database, and used PL/SQL. Written Unix shell scripts for before or after program process.

Hayward, CA

Lead DataStage ETL Developer for Data Conversion/Integration for Mervyns Financial and Merchandise System project. Gather mapping requirements for sour to target. Defined program specification Documented the ETL mapping document to translate the ETL coding logic. Used DataStage Parallel Extender version 7X for coding, designing and developing jobs and.

Dallas, Texas, United States

Analyst, designer, developer, and tester for Price Optimization Project. Project use Ascential DataStage version 7.5 and PX tools, server on a UNIX Platform- HP-UX, Oracle 9x database, Relational Database Management System (RDBMS), and used PL/SQL. Written Unix shell scripts for before or after program process.

San Bruno, California, United States

Gap’s Global Merchandise System (GMS) Integration project. Primary ETL application is DataStage and Parallel Extender version 7x on Unix platform. Target and source areas are Oracle 9i, DB2 (Mainframe tables), Retek RIB and Message Queue, XML, and Sequential files.. Majority developments are Parallel Extender (PX) jobs. Involved in the Failover and.

Milwaukee, Wisconsin, United States

ETL Lead and coordinator for Health Insurance Sales Data Mart project in Relational Database Management System (RDBMS). Responsibilities are Analysis, Coding, Design, Develop, Testing, and Scheduling. Target database is Oracle Database version 9x and source from Data Warehouse Oracle Database 9x, Mainframe DB2, and sequential files. Primary ETL application.

Dallas, TX

Analysis, Coding, Testing, Design, Develop, Scheduling, and Production Support G/L Financial, Sales Audit and HR Peer Metric Data Warehousing project (Lead ETL Developer). Large volume of data extracting from AS400 and some sequential files and loading it into Oracle Database. Primary technologies used in this project are Ascential DataStage 6.1, HP Unix.

Dallas, Texas, United States

Analyst, designer, developer, and tester for a large Data Warehousing project – Terabyte size of data. Involved in source data analysis, quality assurance, data cleansing, and ETL Ascential DataStage process design and development. Use “best practices and quality design” methodologies. Project use Ascential DataStage version 6.0 tools, server on a UNIX.

Chicago, Illinois, United States

Led the development an Online Registration Application project using the Ascential DataStage 5.2 ETL tool and used PL/SQL and SQL Loader. Directly interacted with clients to obtain and to create the business requirements and designed the mapping for the project. Installed DataStage clients and coordinated with Unix team for installing the Ascential.

Racine, Wisconsin, United States

Gathered and analyzed business requirements Reviewed dimensional model and made modifications corresponding to new requirements Analyzed source data and reviewed data mapping document, ensuring that required data was available to extract correctly Designed and developed over 200 ETL jobs using Ascential DataStage 3.62 and PL/SQL Developed batch program.

Downers Grove, Illinois, United States

Supported the Eddie Bauer Marketing Customer Information System (CIS) in the open system environment Resolved all on-call production issues and immediate problems in a timely manner (average 10 production issues a day) Maintained and enhanced the CIS system  Automated manual processes using UNIX, C-Shell, and PerlManaged the database to allocate DASD.

Associate'S Degree, Computer Science

Bachelor Of Science (Bs), Business