SUMMARY

• 7+ years of IT experience with special emphasis on Analysis, Design, and Development of ETL methodologies in all the phases of the Data Warehousing life cycle.
• 6 years of extensive & diversified experience in loading and maintaining Data Warehouses and Data Marts using IBM Information Server/Infosphere Datastage 9.1.2/8.5/8.1.2 ,/PE/EE/7.5/7.1/6.0 (Manager, Designer, Director, Administrator) ETL processes, Quality Stage8.1.2,8.0.1,7.5, Information Analyzer, Scheduling tools AutoSys, Control - M.
• Worked on Information Analyzer to conduct end to end data profiling and content analysis.
• Extensively worked on DataQuality stages like Standardize, Investigate, Match Frequency, ReferenceMatch, Unduplicate Match, Survive etc
• Experienced in Extraction, Cleansing, Integration, and Loading of data from/to various data sources.
• Designed the database models like Star, Snowflake and Multistar Schemas.
• Designed and developed parallel jobs in SMP architecture on Datastage Parallel Extender.
• Experienced in scheduling Batch jobs.
• Experienced in integration of various data sources (DB2-UDB, SQL Server, Oracle, Sybase, and MS Access).
• Extensively worked on various stages like ODBC, Transformer, Sequential file, Hashed file, Join, Lookup, Lookup file set, Sort, Aggregator, Copy, Dataset, Merge, Oracle, Remove duplicates, DB2 stage, Teradata Stage (Multiload, Fast load, Tpump)
• Extensive experience in loading high volumes of data.
• Experienced in UNIXShell Scripting as a part of file manipulation, scheduling and text processing.
• Involved in functional requirements gathering, analysis, design, development, test and implementation.
• Experience in writing, testing and implementation of the triggers, Procedures, functions at Database level and form level using PL/SQL.

TECHNICAL SKILLS

ETL Tools: IBM DataStage 9.1, 8.5/8.0.1/7. X/6.X, Quality Stage 8.1.2, 8.0.1, 7.5, Information Analyzer, Profile Stage, MVS Mainframe OS390

Operating Systems: MVS, OS-390, Windows 98/2000, Windows NT 4.0,Novell, HP-UX, IBM AIX 4.0

Databases: TeraData V2R5/V2R6/V2R7, Oracle 7.x/8.0/8i/9i,10g,11i Sybase, SQL Server 2000/2005, MS-Access, DB2UDB/EEE, IMS DB/DC, DB2,MDM

Languages: PL/SQL, Cobol, C++, SQL, Unix shell programming, C, JCL, Pro*C, HTML.

Database Tools: SQL Plus, SQL*Loader, Import, Export and TOAD

Scheduling: Control-M, Autosys, Crontab Utility

PROFESSIONAL EXPERIENCE

Confidential

ETL/ Data Stage Developer

Responsibilities:

• Studying thebusiness requirement and worked extensively with Project Manager, BA’s and users to effectively capture the user specifications.
• Extensively used Data Stage stages namely Data set, Sequential file, Transformer, Aggregate, Sort, Remove Duplicates, Join, Lookup, Change Capture, Funnel, Peek, Row Generator, Filter stages in accomplishing the ETL Coding.
• Extensively dealt with change capture techniques for implementing slowly changing dimensions process.
• Used Information Analyzer to conduct end to end data profiling and content analysis.
• Worked with Information Analyzer and Quality Stages to understand and cleanse metadata to build Data Model.
• Developed Parallel Jobs which loads Dimension Tables and maintained Surrogate key generation in multiple run.
• Developed Subject Area Jobs for performing all the transformations required in the data process for creating the load ready files.
• Designed ETL jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.
• Used DB2 stage to load data into mart tables and DB2 bulk load stage to load data into staging tables.
• Performed unit as well as integrated testing to validate the job designs and check for data reliability.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Familiar with import/export of Data Stage Components (Jobs, DS Routines, DS Transforms, and Table Definitions) between Data Stage Projects, use of Dataset Management (DSM) utility and multiple jobs compile utility with use of Data Stage Director.
• Excessively used DS Director for monitoring Job logs to resolve issues.
• Involved in the migration of Data Stage jobs from development to QA and then to production environment.

Environment: IBM Infosphere Data Stage 9.1 (IBM Websphere Datastage, information Analyzer and Quality Stage Designer, Director, Administrator), DB2 UDB 9.8, Flat files, UNIX-AIX, Sequential files, Autosys, SQL, PL/SQL, UNIX Shell Scripting, DB2 Visualizer.

Confidential

Datastage Developer

Responsibilities:

• Written high level, detail level design documents.
• Developed the datastage jobs, sequencers and modified the existing datastage jobs.
• Created jobs that are used to aggregate, sort, merge data that we get from third party servicers.
• Extensively used all kinds of stages like LookUp, Join, Sequential File, Transformer, DataSet, Peak, Funnel, Row Generator, Row Merger and other stages
• Developed a process in DataStage to validate the extensive loan accounting data and report exceptions.
• Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables.
• Created XML files as data extract reports for sending to other systems.
• Converting historical Access data source .csv files load them in to Staging, dimension tables after the aggregations to load them in to fact tables.
• Developed ETL control model to capture the results for the file, table counts, Job run times and raise exception if any variance between file and table counts.
• In file validations job, verify file level checks like, duplicate, schema validation, transmission sequence number validation.
• Used FastTrack to automate creation of ETL DataStage jobs, to leverage published profiling results from Information Analyzer and to create and link Business Glossary terms and their relationships.
• Played a key role in designing, developing, unit testing and implementing the audit functionality to make sure all records are passing from source to target.
• After the validations, developed data stage jobs for preparing and loading into ODS.
• Imported the contents of DataStage and FastTrack into Business Glossary. Created data lineage and impact analysis reports in Metadata Workbench.
• Developed the datastage job sequencers to implement job execution logic.
• Wrote Unit test plan documents, captured the test logs and created the test summary results.

Environment: IBM Websphere DataStage 8.5/8.1.2 (PX & Server),Oracle 11/10.2g,TOAD 9.7, Sun Solaris, Mainframe, Access data Flat files, Autosys.

Confidential, CT

Application Tech Specialist

Responsibilities:

• Involved in design and development of complex Parallel and Server Jobs.
• Actively participated in business meetings with the business users in order to gather the business requirements.
• Used Datastage job Sequencers and ZEKE to Schedule and run the Datastage jobs.
• Collected the information about different Entities and attributes by studying the existing ODS and reverse engineering into Erwin.
• Worked on integration of Health Claims ODS from legacy systems.
• Good knowledge on Voluntary Insurance plans to employers to offer total Insurance packages and good knowledge on policy and claims processing.
• Used DataStage director for job scheduling and monitoring. Used Datastage manager to define table structures and metadata.
• Developed parallel jobs between multiple source systems.
• Used FastTrack to automate creation of ETL DataStage jobs, to leverage published profiling results from Information Analyzer and to create and link Business Glossary terms and their relationships.
• Involved in system testing and unit testing.
• Responsible for supporting and managing database activity during the development process.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.
• Analyzed and implemented new Business rules for the existing jobs.
• Developed ETL High level and low level design document and production implementation documents.

Environment: IBM DataStage V8.1 Suite (Designer, Director, Administrator, ProfileStage, QualityStage, Business Glossary, Metadata Workbench & FastTrack), SQL Server 2005, Oracle 10g/11i, AS/400, ERwin4.0, IBM AIX 4.2/4.1,PL/SQL.

Confidential, Malvern, PA

Datastage Developer

Responsibilities:

• Created complex data stage jobs in Enterprise Edition using various stages.
• Used DataStage Designer to develop server¶llel jobs for extracting, transforming, integrating and loading data to targets.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.
• Developed ETL High level and low level design document and production implementation documents.
• Experience in using Teradata Utilities (BTEQ, MLOAD, FASTEXPORT) and Teradata HASH functions for analyzing data placement.
• Did error handling and performance tuning in Teradata queries and utilities.
• Involved in data reconciliation in various source system and in Teradata.
• Used the Datastage Administrator to assign Privileges to users or user groups (to control which DataStage client applications or jobs they see or run), move, rename, or delete projects, and manage or publish jobs from development to production status.
• Created jobs that are used to aggregate, sort, merge data that we get from third party services.
• Used Datastage job Sequencers and Control- M to Schedule and run the Datastage jobs.
• Experience with Configuration of Sources and Analysis Settings.
• Used Information Analyzer to conducted end to end data profiling and content analysis
• By using IA Conducted column analysis, primary key analysis, and cross domain analysis.

Environment: IBM Web sphere DataStage 8.0.1/7.5.2 , DB2UDB7.2,Teradata, Oracle 10g, TOAD, PL/SQL, SQL Loader, AIX-UNIX 5.3, Control-M.