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 documentsReview and provide feedback on the coding of DataStage jobsReview standards for architecture, design and coding of Information Server applications, including those standards and guidelines provided by the Safeway ICE Team in addition to IBM’s Standard PracticesProvide recommendations on improvements and recommended practices with respect to DataStage design and development, applying the Safeway standard and guidelines as well as IBM’s Standard PracticesProvide mentoring and development support to Safeway ICE Team members for DataStage design, code, testing, and system administrationProvide design, coding, and testing for Integration projects with DataStage Parallel Extender version 8X (IBM Information Server version 8), maintaining ETL/QS server on UNIX, source from DB2 database and sequential files, and DB2 Mainframe and SQL Server as the target databasesMentor Safeway employees on DataStage developmentProvide DataStage assistance to the Net Landed Cost (NLC) projectProvide assistance to the eComm Integration project to provide feedback on the design approach created by the Infosys team

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 DataStage Parallel Extender version 7X, maintaining ETL/QS server on UNIX. · Worked on QualityStage that has been used for data cleaning, Name & Address Standardization and US Postal Address verification using CASS.· Involved in business requirement gathering and developed parallel that sources from XML files, Oracle database, SQL Server and VSAM. The jobs also have multiple targets such as XML files, Oracle database tables and CSV extracts.· Created and designed staging tables in Oracle database · Worked on Rational ClearCase application to track projects and code versions. · Performed unit, component and system testing. Managed the Mercury Quality Center to track defects and metrics.· Documented the ETL mapping document to translate the ETL coding logic.· Maintained and customized the automation of DataStage job migration (import/export) process.· Created ETL jobs to implement complex CTA and UNUM multi-step merge process.· Designed the field level change capture design (CDC) by creating custom Parallel routine and EE jobs.· Actively involved in automation of job scheduling and sequencing using Job Sequencer and ESP agent.

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 Platform, DB2 database.

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.

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 routines. Mentored and coached 4 junior DataStage developers. Maintained ETL DataStage server on AIX Platform. Written Unix shell scripts for before and/or after program process. Involved in automation of job scheduling and sequencing using Job Sequencer and job scheduler.

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.

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 Production Support processes. Responsibilities are Analysis, Coding, Design, Develop, Testing, Supports, and provide detailed documentation for each interface design.

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 is DataStage version 7x installed in Window 2000 server. Worked on Erwin Data Modeling tool to design physical and logical data model and used PL/SQL. Worked as ETL and Data architect. Created batches, job sequences, and scripts for Autosys Scheduler and make sure the process of job sequences and dependencies are in order. Made significant suggestions to users. Involved in decision making for Sales Data Mart project.

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, Scripts, Oracle 8.1, and Relational Database Management System (RDBMS), and used PL/SQL. Worked as ETL and Data architect. In order to keep track the version of the codes and programs, ClearCase software product was used.

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 Platform- HP-UX, Oracle 8.1 database, and Relational Database Management System (RDBMS), and used PL/SQL. Resolved various production issues. Exposed to Parallel Extender.

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 DataStage on a Solaris 2.7 server. Designed, coded, tested, provided documentation and implemented approximately 150 DataStage ETL jobs. Provided production support and on-call for resolution of production issues until successful launch. The data was sourced from a Sybase database and targeted to an Oracle 8.x normalized database environment. Subject matter consisted of an online transactional data environment. Written Perl and Unix shell scripts. Worked as ETL and Data architect.

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 using Universe Basic in controlling flow of all ETL jobs and sending e-mail and paging for job failures Sourced systems from SAP R/3, AS/400/BPCS, ADABAS, DB2, SQL Server, text files, Excel files, and targeted system was DB2 AIX. Used System/Project Life Cycle Methodology and version 3.62 of the Ascential DataStage tool  Designed, coded, tested and documented for data warehouse Production supported and on-call for production issues Subject matter consisted of a data warehouse, sales reporting, manufacturing, raw materials, deal fund and deal plan management Provided skills and knowledge transfer to others Written Unix scripts

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 spaces Designed, coded, and tested over 100 ETL jobs for CDM Program Specification that describes the customer information system using Ascential DataStage version 4.0 under Solaris/Oracle database platform. Created and utilized unit and system test specificationsValidated different sources of data for the data martSupported the Merchandising Ultimate Outlet General Ledger reporting enhancement project. Specifically reported on high sell cost and depreciation cost. Modified the Merchandising Return Good Indicator (RGI) project for Eddie Bauer Created the small system design and project tracking charts for different projects