SUMMARY

• 8+ 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/Datastage 8.5/8.1.2,8.0.1/PE/EE/7.5/7.1/6.0 (Manager, Designer, Director, and Administrator) ETL processes, Quality Stage 8.1.2,8.0.1,7.5, Information Analyzer, Scheduling tools AutoSys, Control - M.
• Used Information Analyzer to conduct end to end data profiling and content analysis.
• Extensively worked on DataQuality stages like Standardize, Investigate, Match Frequency, Reference Match, 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 UNIX Shell 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 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, NC

Sr. DataStage Consultant

Responsibilities:

• Working with the Data Integration Architect to create ETL standards, High Level and Low-level design documents.
• Involved in creation of new jobs using with different stages like Change capture for Type1 and Type2, Sort, Filter, funnel and Join Stages.
• Used column import stage to capture source flat file rejected records in to a sequential file.
• Involved in Extraction, Cleansing, Validating and Integrating of data from multiple systems and transforming Business specific rules into functional Specs.
• Created objects like tables, views, Materialized views procedures, packages using Oracle tools like PL /SQL, SQL*Plus, SQL*Loader and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Designing Parallel, Job Sequencers and Batch Jobs in DataStage 8.5 and maintains Star team version control while migrate to higher environments.
• Extensively worked with partitioning for splitting multiple data streams into sub chunks to distribute the load evenly across all available processors to achieve maximum thru put.
• Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, Fact tables and Dimensional tables.
• Integration of various data sources like Oracle and DB2.
• Converting historical Access data source .csv files load them in to Staging, dimension tables after the aggregations to load them in to fact tables.
• Writes and modified Shell Scripts to support for Autosys automation to run the DS jobs and Capture results of the Job run timings, file vs table counts in to the 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.
• Responsible for Production Support and involved in On-Call for the period of application warranty.
• Worked on tuning mappings, identify and resolving performance bottlenecks in various levels like source and target mappings.

Environment: IBM Info Sphere Information Server V8.5 Suite DataStage, Information Analyzer, IS Manager, Star team, Oracle 11g/10gR2, Access data Flat files, PL/SQL, Shell Scripts, Autosys, Windows XP, Linux v2.6

Confidential, Riverdale, MD

Datastage Developer

Responsibilities:

• Working as a ETL developer to implement the ETL Jobs by using IBM Datastage.
• 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.
• Used Toad for analyzing data, writing SQL, PL/SQL scripts performing DDL operations.
• Integration of various data sources like Oracle and Ms-Access.
• 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.
• 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 & parallel 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

Confidential, McLean, VA

Technical Analyst

Responsibilities:

• Used the Datastage Designer to develop processes for extraction, cleaning, transforming, integrating and loading data into data warehouse database.
• Run, Monitor the jobs with Datastage Director.
• Extensively used DataStage- Designer to design and develop Server and Parallel Extender jobs to migrate data from transactional systems (Mainframe DB2, VSAM files, Sybase, DB2UDB) into the Data Warehouse.
• Worked with Datastage Manager to Import, Export Datastage Jobs from one environment to another (ex: dev to prod).
• Used clear case, clear quest Version Control to move the scheduling jobs from development to production.
• Developed stored procedures to load historical data and to update, insert or deletion of data as per the business rules for type 2 dimension tables.
• Used MCM to move mainframe SAS, COBOL and JCLs from Dev to Prod.
• Involved coding the Cobol/JCL and modified the existing Cobol/JCL programs and PROCS to include the additional logic and writing and modifying the copybooks to include the additional fields.
• Performed Data Cleansing and Conversion of Mainframe datasets from EBCIDIC to ASCII format.
• By using the Datastage FTP stage we loaded the mainframe data.
• Developed all the jobs confirming to the SOX specifications.
• Wrote Data Quality Jobs for doing the source to target compare using SAS.
• Automated the sending of data quality reports to the management/business users.

Environment: Ascential DataStage 7.x Parallel Extender (Manager, Designer, Director, Administrator), Mainframe DB2, DB2UDB, DB2 Bulk Loader, SQL, UNIX Korn Shell Script, JCL, Cobol II, Autosys, ClearCase/ClearQuest, Windows 2000/NT, IBM AIX, OS/390, MVS.

Confidential

PL/SQL Developer

Responsibilities:

• Created forms for new Policy entry détails.
• Responsible for maintaining Policies as per the Customer requirement.
• Wrote SQL queries for data extraction.
• Creation of Reports that allows the user to retrieve complete information as required for the financial status like monthly reports, day to day transaction.
• Customizing and designing reports using Oracle Report Writer.

Environnent: Oracle 8, SQL, Oracle forms 4.5, Oracle reports 2.5, UNIX and Windows.