SUMMARY

• Over 7+ years of experience on Data warehousing in the areas of ETL design and development.
• Proficient in all stages of Software Development life - cycle including System Analysis, Design, Development, Implementation, Production Support and Maintenance.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal technical and communicational skills.
• Experience in Data Stage 11.3/9.x/8.x/7.x using components like DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator, Quality stage, Information server and Parallel Extender. Designed Mapping documents ETL architecture documents and specifications.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Involved in complete Software Development life-cycle (SDLC) of various projects, including requirements gathering, system designing, data modeling, ETL.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, and sort, Remove duplicate, and Funnel, Filter, Pivot, and Shared containers for developing jobs.
• Strong knowledge on SQL, Stored Procedures, Functions, Triggers.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Diverse knowledge of data dependencies using Metadata of DataStage and preparing job sequences for existing jobs to facilitate scheduling of multiple jobs.
• Good Knowledge about the principles of DW like Data marts, OLTP, OLAP, Dimensional Modeling, fact tables, dimension tables and star/snowflake schema modeling.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogates key assignment and CDC (ChangeDataCapture).
• Expert in unit testing, system integration testing, implementation, maintenance and performance.
• Helped functional team in writing up of source to target mapping documents.
• Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2008/2005 and Oracle 10g/9i/8i.
• Worked with UNIX shell scripting for enhancing the job performance.
• Worked on scheduling tools like Auto Sys, Control M and Tivoli to schedule DataStage jobs.
• Upgraded Data Stage jobs from server to parallel.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Extensive experience in Database query tuning, Performance tuning and troubleshooting performance issues on OLTP and DSS systems
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

• IBM DataStage and Quality Stage 11.3/8.7(Manager, Designer, Director, Administrator)
• Fast track
• Oracle connector migration
• Oracle 11g
• SYBASE
• DB2 UDB
• SQL
• PL/SQL
• Toad
• SQL * Loader
• UNIX
• Control m
• Erwin 3.5

PROFESSIONAL EXPERIENCE

Confidential, Berlin, VT

ETL DataStage Developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities
• Actively participated in the Team meetings to gather business requirements and in developing the Specifications.
• Responsible to create Source to Target mappings.
• Extracted Data from Source System like DB2.
• Prepared ETL Technical design document and mapping documents.
• Developed and Supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Used Data Stage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Developed a Data Stage Jobs to extract data from various Databases and load into the DB2 Database
• Developed the Data Stage parallel Jobs using various Processing Stages like Join Stage, Connector Stages, Copy Stage, Merge Stage, Aggregator Stage, Filter Stage, Look up Stage, Transformer Stage, Modify, Filter Stage, Funnel Stage, Remove Duplicate Stage, Surrogate key Generator Stage, Change capture stage, Row Generator and Column Generator Stage.
• Developed Unit testing, System testing and integration testing.
• Used the Data Stage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Performed in writing complex SQL queries involving multiple tables inner and outer joins.
• New foreign keys are created on child tables because of this we need to modify the DataStage jobs wherever a child table record is inserted/updated used in jobs we need to check lookup validation.
• Extensively worked with Parallel Extender using Parallel Processing (pipeline and Partition Parallelism techniques).
• Involved in modifying existing DataStage Jobs for better performance.
• Handling large volume data loads, automatic error handling and auditing, performance tuning for bulk data load, aggregation in optimized time using ETL tools
• Expertise in creating reusable components like Shared Containers and Local Containers in DataStage.
• Worked closely with Data Analysts to make sure the data is accurate and consistent for table loads.
• Experience in developing SSIS, SSRS Reports.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning.
• Extremely motivated, able to work smoothly under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

Environment: IBM DataStage and Quality Stage 11.3/8.7(Manager, Designer, Director, Administrator), DB2 connector, IBM DB2, SQL SERVER,SQL, PL/SQL, UNIX, Rapid SQL 8.7,SAS.

Confidential, Chicago, IL

Sr DataStage Developer

Responsibilities:

• Business model Analysis, analyzing existing Data Model and Data dictionary.
• Requirements gathering, source system analysis to merge multiple source systems into a single entity.
• Design the entire ETL process and jobs considering all the existing enterprise process and guidelines.
• Responsible to create Source to Target (STT) mappings.
• Extracted Data from Various Source Systems like Oracle, DB2 and SYBASE.
• Prepared ETL Technical design document and mapping documents.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Developed the Data Stage parallel Jobs using various Processing Stages like Join Stage, Connector Stages, Copy Stage, Merge Stage, Aggregator Stage, Filter Stage, Look up Stage, Transformer Stage, Modify, Filter Stage, Funnel Stage, Change capture stage, Row Generator and Column Generator Stage.
• Responsible to develop job sequences to run multiple jobs with correct dependency and using various Activity stages like Job Activity, Execution Command, Start Loop Activity, End Loop Activity, Notification Activity, User Variables Activity Stage, Routine Activity Stage.
• Expertize in converting PL/SQL Codes into DataStage Codes.
• Used Data Stage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Developed a Data Stage Jobs to extract data from SYBASE Database and load into the Oracle Database using the existing Java code loading data from SYBASE Database to DB2 Database.
• Worked on Converting the Oracle enterprise stage to Oracle Connector stages.
• Experience with all the new features in DataStage 11.3 and migrated all the jobs from 8.7 to 11.3.
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Hands on experience using various partitioning methods like Hash by, Entire and Range for bulk data loading and for performance boost
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages.
• Developed Unit testing, System testing and integration testing.
• Extensively used Control-M for automation of scheduling DataStage Jobs and UNIX shell script jobs on daily, weekly monthly basis with proper dependencies
• Used the Data Stage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics

Environment: IBM DataStage and Quality Stage 11.3/8.7(Manager, Designer, Director, Administrator),Fast track, Oracle connector migration, Oracle 11g,SYBASE, DB2 UDB, SQL, PL/SQL, Toad, SQL * Loader, UNIX, Control m, Erwin 3.5

Confidential, Boston, MA

ETL DataStage Developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables and to prepare Test Cases.
• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities
• Actively participated in the Team meetings to gather business requirements and in developing the Specifications.
• Extensively worked with Data Stage Job Sequences to Control and Execute DataStage Jobs and Job Sequences using various Activities and Triggers.
• Using Shell programming, worked on development of batch programming, where data stage jobs called from UNIX shell programs in batches.
• Performed Unit testing of DataStage Jobs using Unix Shell Scripting and with web application to ensure that it meets the requirements.
• Working with stages like Complex Flat File and Transformer, Aggregator, Sort, Join, Lookup, and Data masking pack.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.
• Performed in writing complex SQL queries involving multiple tables inner and outer joins.
• Assisted in configuration, development and testing of Autosys JIL and other scripts.
• Participated in complete process of functionality testing of all versions of AutoSys applications.
• Extensively used Control-M for automation of scheduling UNIX shell script jobs on daily, weekly monthly basis with proper dependencies
• Interact with multiple teams DBA, Middleware and Reporting for the design and end to end implementation of solution
• Extensively worked in XML data processing.
• Technical documentation for designs of DataMart and ETL process
• Participated in implementing strategies to minimize the exposure to any risk.
• Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Created DataMart’s for monitoring AML Transactions, ALM Accounts.
• Developed Data Stage jobs for AML Sanction Screening to monitor Fraud Accounts.

Environment: IBM Information Server 8.5/9.1 (DataStage) Oracle11g, Toad, SQL Developer, UNIX, Windows XP, Autosys, Sequential Files

Confidential, Minneapolis MN

Datastage ETL Developer

Responsibilities:

• Our team involved in Gap analysis for Confidential mercy families of companies and PerformCare/CBHNP.
• Based on the analysis done during the requirements phase, the impact to scope, schedule to be derived and provided to AMFC.
• Any module needs to be developed using other or similar existing technology which becomes known after the completion of design phase.
• At the end of the 'Gap Analysis' phase, our team will validate the proposed solution, scope and any assumptions made during proposal submission
• Gathering the requirements and interacting with business user to understand requirements and design, development and documentation.
• Designed, Developed, Tested ETL jobs using DataStage according to technical design documents. Used DataStage Director and scheduler for running ETL jobs, monitoring scheduling and validate
• Created UNIX shell scripts to be used in conjunction with files and ETL execution scripts for automating jobs
• Extensively used Parallel Extender to load data into the data warehouse with different techniques like Pipeline and Partition in MPP environment
• Analyzed the performance of the jobs and project and enhance the performance using the required techniques

Environment: IBM WebSphere Data Stage 7.5.2, SQL Server 2000/2005, SQL Analysis Services/Integration Services, AS/400, SQL, PL/SQL, Korn Shell Scripts.

Confidential, Kansas City, MO

ETL DataStage Developer

Responsibilities:

• Extensively used Data Stage as the data migration/transformation tool for Corporate Data Warehouse application.
• Gathered requirements from business and created source to target mapping sheets and modified existing data modeling.
• Designed the logical and physical data warehouse schema. Analyzed source systems and creating a mapping to the target database schema.
• Involved in Design, Development and unit testing of DataStage jobs and migrating the code from one environment to the other.
• Extensively worked with Parallel Extender using Parallel Processing (pipeline and Partition Parallelism techniques).
• Involved in modifying existing DataStage Jobs for better performance.
• Extensively used the aggregate Stage for calculations and used to load the aggregated data in the EDW target Tables.
• Extensively used Data Stage Designer to design and develop Server and PX jobs to migrate data from transactional system (Oracle 9i) into the Data Warehouse.
• Worked closely with Business Analysts to understand business rules and developed Prototype jobs.
• Extensively developed Server/PX Shared Containers for Reusability.
• Extensively used Data Stage Manager to Export/Import DataStage Job components and Import Plug in Table Definitions from Oracle database.
• Created UNIX Shell Scripts as wrappers to automate the process of running DataStage jobs and to track DataStage Job logs and Script logs.
• Redesigned many existing ETL jobs (SQL scripts, Shell Scripts) in DataStage as per the Framework approach.
• Handling large volume data loads, automatic error handling and auditing, performance tuning for bulk data load, aggregation in optimized time using ETL tools
• Expertise in creating reusable components like Shared Containers and Local Containers in DataStage.
• Provided Support to various groups to design and develop ETL job flow using DataStage and Shell Scripts.
• Designed AutoSys based solutions for communication of issues to technical teams.
• Worked closely with Data Analysts to make sure the data is accurate and consistent for table loads.
• Experience in developing SSIS, SSRS Reports.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning.
• Extremely motivated, able to work smoothly under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

Environment: IBM DataStage 8.5 (Parallel Extender), UNIX, Erwin, Autosys, Oracle 10g/11g, SQL Server 2005/2008.