PROFESSIONAL SUMMARY:

• 7 years of experience in developing, testing and maintaining applications in Data Warehouse using ETL tool IBM Web Sphere DataStage and Ascential DataStage
• Experience in Strategic Analysis, Design, Development, Maintenance, Testing and Implementation of Client/Server, Relational and Dimensional Modeling, Data Marts/ Data Warehouses and Business Intelligence Technologies using Relational Database Management Systems like Oracle, Teradata, DB2, SQL Server.
• Area of expertise encompasses Database designing, ETL phases of Data Warehousing. This is achieved with an emphasis on relational data modeling and dimensional data modeling for OLTP and OLAP systems
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse
• Experience in design and implementation of Star, Snowflake schemas and multi dimensional modeling
• Experience in integration of various data sources like SQL Server, Oracle, MS Access and Flat Files into staging area
• Experience in writing, testing and implementation of the Packages, triggers, Procedures, functions at Database level and form level using PL/SQL
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader
• Experienced in Secure File Transfer Protocol/SFTP/
• Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Experience in SSIS,SSRS
• Designed and developed complex mappings.
• Extensive knowledge in handling slowly changing dimensions.
• Strong in Data warehousing concepts and using Star Schema and Snowflakes methodologies
• Execution of test plans for loading the data successfully into the targets.
• Implemented Various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Experience in Database Management, Data Mining, Software Development Fundamentals, Strategic Planning, Operating Systems, Requirements Analysis, Data Warehousing, Data Modeling, Data Marts.
• Experience in writing UNIX shell.
• A versatile team player with strong programming and problem solving skills
• Excellent communication and interpersonal skills and strong ability to perform as part of a team and individually

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere Server, Datastage - 7.x, 8.x, 9.1Datastage, Informatica.

RDMS Databases: SQL Server, Teradata 13.x. oracle, db2, .

Database Tools: SQL Management studio, Teradata 13.x. oracle, db2

Scripting: UNIX Scripting, SQL Queries, PL/SQL.

Operating system: UNIX, Windows, SFTP

Scheduling tool: Tivoli

PROFESSIONAL EXPERIENCE:

Sr DataStage Developer.

Confidential, MI

Responsibilities:

• Participated in meetings with Business users and Subject Matter Experts (SMEs) to Understand Business requirements.
• Worked with Business customers to identify the different sources of data in operational systems and developed strategies to build data warehouse.
• Preparation of technical specifications for the development of Extraction, Transformation and Loading (ETL) jobs to load data into various tables in Data marts and mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Extensively worked with Information analyzer to understand the nature of source data and quality by using Column analysis, Primary Key analysis, Foreign Key analysis and Base Line Reports.
• Verified Environment Variables, Job Parameters and Routines for developing Parameter Driven Jobs and debugging them and incorporated environment variables ($PROJDEF) in all DataStage PX jobs to maintain consistency across different environment (dev, test, prod).
• Created parameters in the tables by using the ACES Frame work tables to group DataStage and QualityStage job parameters and store default values in tables to make sequence jobs and shared containers faster and easier to build.
• Used IBM InfoSphere DataStage 8.7/9.1 as ETL tool to Extract, Transform data from source systems such as Oracle, Flat files, Fixed width files, MS Access Database and load into EDW tables.
• Involved in modeling the Party Model and developed datastage jobs to load the Member, Subscriber, Provider, Practitioner/Facility data into the model.
• Designed and developed the generic jobs for Change data Capture using Generic Stage and loaded the data from FACETS to ODS and developed jobs to load the data to the Facts and Dimensions in EDW for reporting with Cognos.
• Used several stages like Sequential file, Aggregator, Funnel, Change Capture, Change Apply, Transformer and Lookup during the development process of the DataStage jobs.
• Applied the change data capture (SCD II) logic for all the tables before loading the dimensions into Enterprise data warehouse.
• Created Unix shell scripts to schedule the DataStage sequence jobs passing all job parameters from the ACES Tables to execute dynamically during run time.
• Used DataStage Director extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics
• Developed Claim process, Drug process, Patient process to load claims into fact transaction claim table after various checks and validations including ETL architecture design and development.
• Developed Provider process to load provider related information into provider table after various checks and validations including ETL architecture design and development.
• Developed Group process to load group related information into group tables after various checks and validations including ETL architecture design and development.
• Involved in performance tuning and optimization of DataStage jobs using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used Open Process job scheduler for automating the weekly, monthly and regular runs of EDW cycle in both production and UAT environments.

Environment: IBM InfoSphere Server DataStage 8.7/8.5, Oracle 11g, MS SQL Server 2005, MS Access, Flat files, Erwin 8.0, SQL, Open Process Scheduler, UNIX Shell Scripting, SQL*Loader.

Sr DataStage Developer.

Confidential, Saint Paul, MN

Responsibilities:

• Used DataStage 7.5.1 as ETL tool to extract data from source systems such as Oracle,Teradata, SQL Server, Flat files to target system
• Used DRS and Hashed file Stage as a table based on a single key
• Used Lookup transformations to manipulate the information
• Used Secure File Transfer Protocol/SFTP/.
• Used Transformer stage for different transformations and aggregations
• Developed DataStage jobs using DataStage Designer and DataStage Manager. In depth experience in dealing with different stages including Transformer, Aggregator, Sort, Hash Lookup, Inter Process, Link Collector and Link Partition.
• Worked with EE stage and developed jobs
• Experience in Parallel Extender (DS-PX) developing Parallel jobs using various stages including Lookup, Aggregator, Join, Transformer, Sort, Merge, Filter, Compare, Funnel, Remove Duplicates, Change Data Capture, Peek, Head, Tail, Copy, Row Generator and Column Generator
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Worked with production support, ETL Issues and Performance tuning
• Developed Extract, Transform, and Load processes for extracting data from various systems and loading into PeopleSoft EPM Staging Tables, Data Warehouse Tables and Data Mart Tables.
• Excellent in Creating/Developing PeopleSoft Projects, Records/Tables, Fields, Pages, and AppEngine programs to automate job schedule process and run the ETL batch jobs through PeopleSoft EPM.
• Developed Technical Design Documents/Design Specification Documents, Mapping Specification Documents, ETL Component Specification Documents and ETL Derivation specifications.
• Extensive knowledge in creating/developing Logical/Physical Data Models in Microsoft Visio and Erwin with STAR Schema/Snowflake schema.
• In depth knowledge to work with Credit Risk Data Warehouse, Extensive experience in solving ERP/ETL Issues and Responsible for creating/executing and scheduling DataStage jobs
• Designed/Developed and tested DataStage jobs to lead data into DW
• Developed several transformations in the process of building DW
• Achieved true end-to-end enterprise meta data integration via meta data sharing among data modeling, data integration and business intelligence tools and standards

Environment: ETL datastage, Oracle 10g, PL/SQL Developer, PL/SQL, Microsoft Visio, Window XP, UNIX/Shell Scripting

DataStage Developer.

Confidential, Dallas, TX.

Responsibilities:

• Team-coordination and ensuring customer satisfaction by providing extensive support.
• Planning for project execution.
• Used Parallelism concepts for distributing load among different processors by implementing Pipeline and partitioning of data.
• Involved in Designing Parallel and server Jobs.
• Creating new batches that utilized parallelism better (Multi Instance)
• Simplifying the environment by removing unneeded objects.
• Reviewing ETL architecture and recommending changes as per Standards.
• Created and Monitored sequences using Data stage sequencer.
• Created containers to use in multiple jobs.
• Used debugger to test the data flow and fix jobs.
• Defined data base triggers & PL/SQL stored procedures for business validations.
• Extensively wrote Routines and Transforms.
• Involved in performance tuning of jobs.
• Created and Monitored sequences using Data stage sequencer
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Funnel, Row Generator, slowly changing dimensions, Modify, Peek etc. for development and de-bugging purposes
• Responsible for metadata management, creating shared containers for reusability.
• Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities and Trigger.
• Maintained the Data Stage Production and Development servers. Worked on various admin issues to keep the server up at all times.
• Actively worked during nights and weekends during go-live and post production.

Environment: Informatica, Oracle 10g, PL/SQL Developer, PL/SQL, Microsoft Visio, Window XP, UNIX/Shell Scripting

Sr ETL Analyst & Developer.

Confidential

Responsibilities:

• Involve Analyzing, designing, developing, documenting, and testing of ETL jobs and preparing source & target mappings in Datastage 8.5 Parallel jobs.
• Project Management in Agile development environment
• Daily scrum meetings, sprint planning, sprint review, and sprint retrospective
• Development of Equity/FI Data mart, Client Applications Data mart as per the sprint user story.
• Requirement Gathering, Process Mapping and Gap Analysis with business
• Business process blueprinting for multiple functional areas and reengineering. BPM Tool used: Mega
• Designing parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Extract data from various data sources (Oracle, SQL Server, files) into data staging area.
• Discussing closely with SME for the clarification of functional queries.
• Schedule and Monitor the Data Stage jobs by using Tivoli scheduler in QA and Prod environment.
• Provide SIT/UAT & PROD Support, and fixing the issues on a daily basis.
• Attending the daily & weekly status call.
• Preparation of daily tasks & assigning to offshore team.
• Code deployment to TEST & PROD from DEV by using change management tool.
• Working as a part of Production Support team to the Data marts are listed above.

Environment: Informatica, Oracle 10g, PL/SQL Developer, PL/SQL, Microsoft Visio, Window XP, UNIX/Shell Scripting.

ETL Informatica Developer.

Confidential, Jersey, NJ

Responsibilities:

• Involved in gathering business requirements, analysis, design, development and testing and production support of client application.
• Created high level design documents, functional specification documents.
• Extracted data from various heterogeneous sources like Oracle, Netezza, MS Access, and Flat files.
• Extensive programming experience of PL/SQL, Stored Procedures, Functions, Packages, Database Triggers for Oracle and SQL Server.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Involved in handling the production tickets and resolve them in timely manner.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Used SQL Override function in Source Qualifier Transformation, worked with Source Qualifier Transformation to join the homogeneous sources and Joiner Transformation to join the heterogeneous sources.
• Implemented Informatica PowerExchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
• Informatica Web Services integrated with Informatica PowerCenter to exploit the platform’s scalability and management of Web services for enterprise deployment.
• Worked with both Connected and Un-Connected Lookups.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked with Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Environment: Informatica Power Center 8.x, Power Exchange, Power Connect, Oracle 10g, PLSQL Developer, PL/SQL, UNIX, Microsoft Visio, Window XP