SUMMARY

• Over 7+ years of extensive experience in building data warehouse/data marts wif extraction transformation and loading (ETL) processes using IBM InfoSphere Information Server - Data Stage versions 8.1/7.x/6.x and Quality Stage.
• Extensive experience in using Oracle development tool set (Including PL/SQL, SQL*Plus, SQL Loader, PL/SQL developer).
• Production job scheduling on UNIX through Control-M scheduling tool and also using Datastage.
• Involved in all teh stages of Software Development Life Cycle.
• Proven track record in troubleshooting of Datastage jobs and addressing production issues like performance tuning and enhancement.
• Good noledge on data warehousing applications, directly responsible for teh Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Aggregator, Join, Transformer, Sort, Remove Duplicates, Merge, Filter and Lookup.
• Imported metadata about database tables, database columns, and data elements into teh repository of IBM InfoSphere Information Server. By using dis metadata we created jobs in IBM InfoSphere DataStage and QualityStage Designer.
• Worked wif Local Containers, Shared Containers and Job Sequences.
• Demonstrated ability in dealing wif different stages (Hash, Shared Containers, and Merge etc).
• Strong understanding of teh principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Strong experience in UNIX Shell scripting (Korn, BASH, and CSH) as part of file manipulation, Scheduling and text processing.
• Experience on DW/Business Intelligence tools.
• Experience in Data analysis to understand teh Business requirement.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Experience wif teh Build, Migrate and Shakeout process of teh development code to higher environments (Sys Test, UAT, and PROD).
• Extensive experience in MS- SQL 2005, PL/SQL, SQL, Procedures and Oracle 11g/10g/9i.
• Experience on IBM Web Sphere 8.1/8.0 Quality Stage.
• TEMPEffective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Excellent communication skills.
• Aptitude for analyzing, testing, debugging code, identifying problems, creating solutions and documentation.
• Multilingual, highly organized, detail-oriented professional wif strong technical skills.
• Good aptitude for problem solving and logical analysis.
• Highly motivated, team player wif excellent interpersonal and communication skills, organized and quick learner.

TECHNICAL SKILLS:

ETL Tools: ASCENTIAL DATASTAGE 6.X/7.X/8.1/8.5, Quality Satge

Databases: ORACLE 7.X/8i/9i/10g, SQL SERVER 6.5/7.0, DB2 UDB 7/8, Teradata V2R5/V2R6/V12

Languages: C, C++, Java, UNIX Shell Programming, SQL, PL/SQL

Data Modeling: Star Schema Modeling, Snowflake Modeling, FACT and Dimension tables, Erwin 4.0

Reporting Tools: Business Objects/Web Intelligence

Web Technologies: HTML, Dreamweaver, FrontPage

Operating Systems: Windows NT4.0/2000, MS-DOS, UNIX (Solaris, Linux, AIX, HP-UX)

Tools: Autosys, Control M, SQL*Loader.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, Ga

Senior Datastage Developer

Responsibilities:

• Built Datastage jobs for Data Conversion project.
• Developed Business specification documents by collecting teh information from several Business teams.
• Worked closely wif teh Contracts and Sales Orders teams in gathering teh functional requirements to give a high level design.
• Extensively worked wif Datastage Designer, Administrator and Director for creating and implementing jobs.
• Extensively worked on Data Extraction, Transforms, Loading and Analysis.
• Worked wif Oracle tables and Flat files.
• Imported metadata about database tables, database columns, and data elements into teh repository of IBM InfoSphere Information Server. By using dis metadata we created jobs in IBM InfoSphere DataStage and QualityStage Designer.
• Performed lookups and transformation on teh data and Performance tuned DataStage to reduce batch run time.
• Extensively used Sequential files, Complex Flat Files, Sort, Funnel, Remove Duplicates, Merge, Aggregator and created datasets.
• Created jobs to produce unit test data using Row Generator, Column Generator, Sequential file and Dataset to perform UTP(unit test plan)
• Developed Shell scripts for Cleansing, Moving and Archiving teh files.
• Performed Data validation and Regression testing for teh downstream systems.
• Used Datastage Sequencer jobs extensively to take care of inter dependencies and to run Datastage parallel jobs in sequence.
• Documented Source-Target mapping and Unit Test plans and scripts for teh DS jobs.
• Provided support for QA and Production Environments.

Environment: Infosphere DataStage 8.1, IBM AIX -5.3, DataStage Version Control, SAP GUI ECC 6.0, Shell Scripts, Maestro scheduler, Unix, Windows XP SP-3.

Confidential, Detriot, MI

Datastage Consultant

Responsibilities:

• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup File Set, Change Data Capture, Modify, and Aggregator.
• Used teh Quality Stage to standardize and cleansing teh source data which comes from GIF.
• Extensively used INFORMATION SERVER (8.1) to develop teh parallel jobs.
• Exporting of DataStage Components & Packaging of Projects using DataStage Designer and to create backups.
• Using TIVOLI scheduler for scheduling various jobs.
• Prepared teh Source to stage and Stage to EDW mapping documents and provided to teh offshore team for teh Development
• Involved in teh design and documentation of High Level design document and detailed design document.
• Involved in development of UNIX shell scripts for Batch jobs etc /State file creations etc.
• Involved in mapping team discussions to solve teh issues in mapping document/Design.
• Extensively worked on Integrity’s processes such as Investigation, Standardization, Matching and Survive and pre-defined rule sets for data cleansing.
• For TEMPEffective Standardization manually defined rule sets.
• Implemented teh slowly change dimensions (Type 2) using CDC (change data capture) Process.
• Done teh Performance tuning on long run ETL jobs.

Environment: IBMInformationAnalyzer 8.1(DataStage EE), Quality Stage, Oracle 10g, Tivoli Scheduler, SQL, PL/SQL, Shell Scripts, SAP.

Confidential, Foothill Ranch, CA

DataStage Developer

Responsibilities:

• Worked at Confidential on teh Presto EDW Project designed to cater to teh Decision Support Systems of teh various business segments.
• Primarily worked on teh conversion of teh existing jobs in DataStage Version 7.5.1 to DataStage Version 8.0 and in corporation of data from new business acquisitions into teh DWH.
• Executed Proof of concepts to understand teh impact to older jobs in teh DataStage Version 8.0
• Migrated existing jobs to DS Version 8.0 and did scheduled multiple runs of sequences to verify teh ETL processes
• Extensively coded older Quality Stage components in teh new DataStage 8.0 version.
• Understood functional documents for new business source systems and applications and their integration into teh existing DWH.
• Wrote teh Design documents and specifications in accordance wif Confidential ’s design frameworks and best practices.
• Defined teh Mapping and Test Case documents.
• Identified source systems connectivity, related tables and fields and ensure data suitably for mapping.
• Extensively analyzed teh Data Sources in identifying data anomalies, patterns, value ranges. Wrote SQL scripts for accomplishing teh same.
• Loaded data using both DB2 API and EE Stages.
• Used Data Stage Enterprise Edition/Parallel Extender stages namely Datasets, Sort, Lookup, Peek, Standardization, Row Generator stages, Remove Duplicates, Filter, External Filter, Aggregator, Funnel, Modify, Column Export in accomplishing teh ETL Coding.
• Developed DataStage job sequences used teh User Activity Variables, Job Activity, Wait for File stages, Execute Command, Loop Activity, Terminate
• Wrote Extensive Unix scripts for running teh Datastage jobs, used awk utility for validating data.
• Developed Error Logging and Auditing strategies for teh ETL jobs.
• Checked source code into SVN Version Control, promoted code for Integration runs and subsequent QA Deployment.
• Co-ordinated teh deployments of code across test and production environments wif teh deployment teams.
• Undertook Change and Enhancements request
• Tuned DataStage jobs to enhance their performance.
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions.
• Wrote Release notes, Deployment documents and scheduled teh jobs via teh Tivoli Scheduler.
• Wrote DDL scripts for creating, altering tables.
• Extensive usage of AQT for analyzing data, writing SQL scripts/functions, performing DDL operations.

Environment: DataStage 8.0 Enterprise Edition/Parallel Extender, Quality Stage, DB2 Version 8.0, AIX, SQL/PL/SQL, Unix Shell Scripting, Ultra Edit.

Confidential, Tampa, Florida

DataStage Developer

Responsibilities:

• Prepared teh Dimension models and prototyped teh queries.
• Analyzed and designed ETL processes.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created DataStage Server jobs to extract data from sequential files, flat files, MS Access and SQL Server.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used teh DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Defined data definitions, and created teh target tables in teh database.
• Wrote routines to schedule batch jobs to obtain data overnight from various locations.
• Mapped teh source and target databases by studying teh specifications and analyzing teh required transforms.
• Troubleshot jobs using teh debugging tool.
• Analyzed teh performance of teh jobs enhanced their performance.
• Standardized teh nomenclature used to define teh same data by users from different business units.
• Created job sequences and schedules for automation.
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions (on an ad hoc or scheduled basis).
• Used DataStage to transform teh data to multiple stages, and prepared documentation.
• Created hash tables used for referential integrity and/or otherwise while transforming teh data representing valid information.
• Created ETL execution scripts for automating jobs.
• Worked on writing routines to read parameters from hash file at runtime.
• Unit tested teh mappings to check for teh expected results.
• Documented teh source to target mappings to facilitate changes when necessary
• Used various stages in Parallel Extender like Processing Stages, File Stages, Development Debugger and Database Stages.

Environment: Ascential DataStage 7.5(Designer, Manager, Director), Oracle 10g/8i, MS SQL Server 2005, ERwin4.3, Sun Solaris Unix, Windows NT, Teradata, QualityStage, MetaStage

Confidential, Philadelphia, PA

DataStage Developer

Responsibilities:

• Understood teh Business Requirements/Functional Specifications for teh Informatics Data Mart and ODS migration from 9i to 10g
• Helped in identifying teh sources of teh Data Mart and got teh approval from teh Business for teh data source
• Identified source systems connectivity, related tables and fields and ensure data suitably for mapping.
• Extensively analyzed teh Data Sources in identifying data anomalies, patterns, value ranges. Wrote SQL scripts for accomplishing teh same.
• Total of 11 different data sources were analyzed for teh loading of teh Dimension and Fact Tables.
• Developed teh Source-Target Mapping for teh Dimensions and Fact Tables.
• Developed DataStage jobs for loading teh 9 Dimensions and 1 Fact Table.
• Loaded around 17 million of 12 month data into teh Fact Table.
• Analyzed teh existing ETL for loading teh Oracle 9i ODS. Prepared mapping documents of teh existing ETL.
• Created ODS tables in 10g and wrote DataStage Enterprise Edition/Parallel Extender jobs to load data into 13 tables.
• Used Data Stage Enterprise Edition/Parallel Extender stages namely Datasets, Sort, Lookup, Peek, Row Generator stages in accomplishing teh ETL Coding.
• Developed DataStage job sequences used teh User Activity Variables, Job Activity, Wait for File stages.
• Wrote Unix scripts and used AWK for file checking and reconciliations.
• Developed Error Logging and Auditing strategies for teh ETL Scripts.
• Tuned DataStage transformations, and jobs to enhance their performance.
• Troubleshot teh designed jobs using teh DataStage Debugger
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions on an ad hoc or scheduled basis
• Wrote Ops Guidance documents and scheduled teh jobs via teh Enterprise Job Scheduler TIDAL.
• Undertook DBA tasks of creating DDL scripts for creating, altering tables. Assigning privileges.
• Used DB Links to migrate test data from one instance to another.
• Extensive usage of TOAD for analyzing data, writing SQL/PL/SQL scripts performing DDL operations.

Environment: DataStage 7.5.1.A Enterprise Edition/Parallel Extender, Oracle 9i/10g, TOAD, HP-UX, SQL/PL/SQL, Unix Shell Scripting.

Confidential

Oracle Developer

Responsibilities:

• Participated in teh detail Database Design.
• Participated in teh detail Resume Mart Designing, coding.
• General Procedures and functions for various user requirements were coded, tested and= Implemented.
• Participated in teh detail design of teh specifications of teh database and teh associated Screens.
• Developed Forms and Reports using PL/SQL routines, Packages and Triggers.
• Excellent communication skills.

Environment: Oracle8i, Developer 6i, PL/SQL