SUMMARY:

• A Dynamic IT professional with 7+years of work experience in Data Integration for Data Warehouses including IBM Info Sphere/ Web Sphere/ Ascential Datastage (11.3/ 9.1/ 8.7/ 8.5/ 8.0.1/ 7.5.1/ 7.5.2 ) Server Edition, Enterprise Edition (Designer, Director, Administrator)
• Experience in Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP)
• Extensive experience on the Data Modeling phases conceptual, logical, physical.
• Strong experience in Data warehouse development life cycle and Design of Data marts with Star Schemas, Snowflake Schemas and Integrated Schemas.
• Used the Data Stage Designer to develop processes for extracting, transforming and loading data into data warehouse and databases.
• Experience in client/server business systems in design/analysis/testing, GUI prototyping, Data Warehousing and application development.
• Experience in Pipeline and Partitioning Concept.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Worked extensively with different database stages of Data Stage like Oracle Enterprise, Dynamic RDBMS, Stored Procedure, ODBC.
• Worked extensively with different file stages of Data Stage like Sequential, Dataset, File set, Lookup File set.
• Worked extensively with different processing stages of Data Stage like Filter, Sort, Aggregator, Copy, Transformer, Funnel, Join, Look Up, Merge, Pivot, Modify, Switch, Change Capture, Surrogate Key Generator, Remove Duplicates
• Worked extensively with different development/debug stages of Data Stage like Head, Tail, Row Generator, Column Generator and Peek.
• Worked with Local Containers, Shared Containers and Job Sequences.
• Knowledge in SQL & PL/SQL and expertise in writing Stored Procedures, functions and Packages.
• Extensive experience in dealing with High Volume Data, Performance Tuning, Maintaining, Multiple Job Compile, Surrogate Key Generator Stage, Job Reports, Message Handler Options.
• Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Extensively Worked on Job Sequences to control the flow of job execution using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command.
• Excellent problem - solving and trouble-shooting capabilities. Quick learner, highly motivated, result oriented and an enthusiastic team player. Good interpersonal skills, experience in handling communication and interactions between different teams.

TECHNICAL SKILLS:

ETL Packages: IBM Info Sphere/Web Sphere Data Stage and Quality Stage 9.1,8.7, 8.5, 8.0.1, Ascential Data Stage 7.5.1/2 (Designer, Director, Administrator)

Databases: Teradata 13.11 client, Oracle 10g/11g, MS SQL Server 2005/2008, DB2 UDB 8.1/7.2

Database Tools: SQL* Plus, SQL Loader, Toad,Zena, Serena

Database Modeling: Anchor Modeling, Star-Schema Modeling, Snowflakes Modeling, Integrated Schema, E-R Modeling, FACT and Dimension Tables,ERWIN 4/7.1/8

Operating Systems: Windows NT / 2000 / XP Pro / Vista, 7, Windows Server 2000 / 2003 / 2008, UNIX - Solaris/AIX/UX, Linux - Mint, Ubuntu

Languages: SQL, PL/SQL, UNIX Shell scripting, C,C++

Reporting Tools: OBIEE, Micro strategy, Business Objects, IBM Cognos, Framework Manager

PROFESSIONAL EXPERIENCE:

Senior Datastage Developer

Confidential, Franklin, TN

Responsibilities:

• Involved in analyzing the system and gathering the requirements.
• Worked with the project and business teams to understand the business processes involved.
• Worked with the Solution Architect in designing the Data Model.
• Responsible for developing the process & testing as it pertains to data flow for the interfaces.
• Used Datastage Designer to develop multiple processing jobs to read data from CPF and load into Oracle. Used Datastage Manager for import/export jobs, metadata from one project to another project.
• Extensively worked with Parallel Extender/Enterprise Edition (EE) using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Extensively worked on Unix Shell scripts to load data to SFTP server.
• Used different types of Stages like Sequential File, Lookup stage, Transformer, Change capture, Remove Duplicates, External source, XML input/output, Funnel, Sort, Aggregator, and ODBC for developing different Jobs.
• Used Datastage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various Datastage jobs.
• Used PL/SQL languages for writing stored procedures and functions and were called in Datastage Jobs.
• Configured File for Parallel extender as per number of processors available to process the data by using Datastage Manager.
• Coordinated with team members at times of change in Business requirements and change in design.
• Used Datastage Sequencer to run jobs in sequence.
• Used Autosys to trigger the jobs on a daily basis.
• Developed UNIX shell scripts for scheduling the jobs and for automation of loading processes.
• Participated in the system testing and unit testing.
• Production support and maintain for the all applications owned.
• Responsible for Documenting and support maintenance.

Environment: IBM WebsphereDatastage 8.5, Oracle 10g, Quality Stage Designer, Director,Administrator), SQL, PL/SQL, UNIX Shell Scripting, Datastage Version Control, MS SQL server, Cognos,Framework Manager.

Senior Datastage Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Loading Members related data for various applications into the DB2 Enterprise Data Warehouse and MS SQL server is the goal of the project. This involved, pulling in data from various source systems like Flat Files, Oracle, DB2 and Sybase and loading the target to EDW data warehouse.
• Scope of the project is to build integrated reporting of healthcare management system that includes integrated, web-based, on demand reporting capabilities for employers as well as internal consulting staff. Thereby improving customer access to clinical and financial data.
• Involved in designing the simple to complex Datastage jobs.
• Involved in Design Development and Deployment of Datastage Server jobs. Used stages like sort, aggregator, transformer, link collector, link partitioner, XML input, XML output, pivot, FTP stage,etc.
• Worked with Provider, Claims, Membership, Member Risk, Products, Audit and Capitation modules under the HIPAA.
• Involved in building the base fact tables, aggregate fact tables, dimension tables, Data mart tables, change requests and defect issues related to the Data Warehouse project.
• Involved in the technical development delivery strategy packages that include technical design, development and testing phase.
• Effectively used Datastage Manager to Import/Export projects from development server to production server and implemented Slowly Changing Dimension techniques.
• Created and executed SQL queries for validating transformation rules used in source to target mappings.
• Used the Datastage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on a scheduled basis.
• Developed Job Sequences, job activities, execute commands, user variable activity and implemented logics for job sequence loops, recovery and restart.
• Identified performance bottlenecks and suggested improvements.
• Used Quality Stage to ensure consistency, removing data anomalies and spelling errors of the source.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: InfoSphere Datastage v8.5, Oracle 10g, Erwin 4.1, Windows XP, SQL Plus, Quality Stage, DB2, Sybase.

Datastage Developer

Confidential, Westlake Village, CA

Responsibilities:

• Understanding the requirements and preparing Low Level Design documents and there by developing parallel and sequence jobs.
• Developed Shared containers and Server Routines, which are used across the project in most of the interfaces.
• Worked in Data Migration project.
• Involved in Each Phase of project - End to End module.
• Written complex queries to facilitate the supply of data to other teams.
• Responsible for using different types of Stages such as FTP, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.
• 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 Datastage Director for Schedule jobs in production for some of the projects.
• Datastage Enterprise Edition for parallel processing as part of ETL conversion process integrating multiple source systems.
• Prepared Unit Test Cases and executing them.
• Provide support to Testing Team and fix defects raised in different phases of testing.
• Developing Datastage Parallel and Sequence Jobs.
• Developed UNIX shell Scripts used to validate the files.
• Trained team members in learning Datastage.
• Understand the existing PL/SQL procedures to extract data loaded by People Soft.
• Have Extensive knowledge on creating info types and sending to ADP.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Tuned Datastage transformations and jobs to enhance their performance.
• Used Control-M for Scheduling jobs and monitors the same.
• Provide Post Implementation Support.

Environment: IBM InfoSphere Datastage 8.1v, UNIX shell Script, ORACLE 10g, ORACLE 11g, SQL Developer Client for Oracle 10g, Office, Visio.

Datastage Developer

Confidential, Quincy, MA

Responsibilities:

• Developed ETL specifications for ETL designing and development.
• Source to Target mapping document creation.
• Attended Corporate Information Architecture (CIA) committee meetings for getting approvals for ETL specifications and designs.
• Loading reference tables from Operational Data Source (ODS) to CIRS data warehouse environment.
• Worked with Datastage EE 7.0 to create the parallel jobs.
• Designed and Developed jobs using Server jobs. Used Parallel Extender for splitting bulk Data into subsets and to dynamically distribute to all available Nodes to achieve best job performance.
• Performed testing of these Parallel jobs using Row Generator and Column Generator stages.
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage.
• Developed jobs for transforming the data and stages like Join, Merge, Lookup, Funnel, Transformer, Pivot and Aggregator.
• Used Row Generator and Column Generator stages to create the test data for performing Testing operations.
• Created database procedures, functions and triggers using PL/SQL.
• Created and used Oracle Stored Procedures in the Datastage jobs to increase the performance of the jobs.
• Worked with TOAD to interact with Oracle and Used SQL Trace and Explain Plan to improve the performance of the PL/SQL programs.
• Loading protected category tables from ODS to CIRS.
• Creating Protected Category hash files using CIRS table as source in CCDB and CIRS formats.
• Validating the Inbound file from care management providers according to Business rules.

Environment: IBM Datastage 8.1, HP-UX11.11, Oracle9.2, Teradatav2r6, RemedyASR8.2, Autosys, PL/SQL Developer 6.0.3, Flat files, Windows 2000.

Database Developer/Analyst

Confidential

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Created Complex UNIX Shell scripts.
• Involved in requirement gathering with the business users, vendors and the banks (client of our client).
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Responsible for extracting, transforming and loading data Using UTL FILE, SQL LOADER.
• Leading and managing five developers, be a bridge over for onsite and offshore teams.
• Conducting regular status calls with onsite managers and offshore teams to update any issues and progress of the project.
• Performed Data masking to secure personal and confidential data.
• Handling Design Change Request’s and updating Technical reports as per the changes.
• Extensively tested design code for various scenarios and environments.
• Adaptively working in multiple challenging environments without missing any deadlines.

Environment: Oracle 9i/10g, UNIX Shell Scripting, SQL Loader, PL/SQL, TOAD, Windows 2000, UNIX

Datastage Developer

Confidential

Responsibilities:

• Involved as primary on-site ETL Developer during the analysis, planning, and design, development and implementation stages of projects using IBM WebSphere 8.1 (Datastage and Quality Stage v8.1 and Information Analyzer)
• Experienced in working with different stages in Quality Stage for performing Master Data Management.
• Interacted with Business Analysts and Source System Experts to gain better understanding of the Business Process, Requirements and Design.
• Involved in the Datastage administration tasks like creating the users, projects, configuration files and Environment set up.
• Designed and Developed Datastage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Creating and modifying MULTI LOADS for Datastage using UNIX and Loading data into IDW (Integrated Data warehouse).
• Loading data from various data sources and legacy systems into Teradata development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Datastage.
• Used various Parallel Extender partitioning and collecting methods.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head and Peek for development and de-bugging purposes.
• Created Basic routines and process to capture and reporting row counts and job status.
• Refreshed the data by using fastexport and fastload utilities.
• Creating and modifying MULTI LOADS for Datastage using UNIX and Loading data into IDW (Integrated Data warehouse).
• Loading data from various data sources and legacy systems into Teradata development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Datastage.

Environment: IBM Web sphere Datastage 8.0.1, (Designer, Director) Information Server, Teradata Database 13, UNIX scripting, TOAD, PL/SQL.