SUMMARY:

• Around 8 years of overall IT experience on ETL processes using IBM DataStage 8.7/8.1/ 7.x, Designing and developing jobs using DataStage Designer, DataStage Manager, DataStage Director and DS Debugger.
• Extensive knowledge of Data Warehousing, business intelligence, ETL processing and Data Modeling
• Experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage.
• Developed jobs for SCD Type 2 using CDC stage.
• Extensively used DataStage Designer to design and develop server and parallel jobs to migrate data from transactional systems (Sybase, DB2UDB and flat files) into the Data Warehouse.
• Knowledge in Extraction, cleansing and modification of data from/to various Data sources like Oracle, XML files, Flat files and Comma Delimited files.
• Extensively worked on DataStage Parallel Jobs using Various Stages like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, and Data set, Oracle Enterprise, Merge, Aggregator, Transformer and Remove Duplicate Stages.
• Practical Understanding of Data Modelling concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience in Data warehouse development life cycle and Design of Data marts
• Worked with DB2, SQL, SQL*PLUS, Oracle PL/SQL, Stored Procedures, Table Partitions, SQL queries, and loading data into Data Warehouse/Data Marts.
• Good knowledge of Database concepts such as indexing, views, schemas and other database objects in both Oracle and DB2 databases.
• Conceptual knowledge of Pentaho Report Designer, Hyperion and Cognos.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.
• Generated Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Experience in resolving Data Transformation, Cleansing and Capturing rejects and Exception and Error reporting.
• Extensively worked on SAP MDM Pack to deliver data to online analytical processing (OLAP).
• Good knowledge on reporting tools like, Business Objects, Congo’s 7 and micro strategy.
• Good experience in Transforming Business specific rules into functional Specs.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e - mail task for capturing issues via e-mail along with the session logs.
• Working experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.

TECHNICAL SKILLS:

ETL Tools: IBM Info Sphere Data Stage Enterprise Edition 8.5/8.0.1/8.0/7.5, Toad, Erwin 7.0 (Administrator, Manager, Designer, Director, Orchestrate, Information Analyzer, Quality Stage)

Operating Systems: IBM AIX 4.3 and Windows NT 4.0/2000/2003/ XP windows 7.

Languages: SQL*Loader, Autosys, Perl, SQL, PL/SQL, XML, UNIX shell scripting, Windows/2008, IBM AIX 7.1

Database: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, UDB/DB2 on AIX.

Other: MS SQL Server 2008/2012, DB2, Sybase, MS Access, Business Objects 5.1/6.0(Designer, Reporter, Supervisor), MS Visio, MS Office, Cognos 7.3, Pentagon Report Designer, Hyperion.

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Sr.Data StageDeveloper

Responsibilities:

• Assisted in updating the logical model with all related entities, attributes and relationships between entities based on the rules provided by the business manager using Erwin.
• Involved in requirement gathering, analysis and study of existing systems.
• Extensively used Data Stage Designer for developing Server jobs, Parallel jobs and performed complex mappings based on user specifications.
• Used Data Stage Designer for Extracting Data, Performing Data Transformations and Aggregate Data.
• Performed lookups using Hashed files.
• Used Data Stage Manager to store and manage reusable Metadata, and created custom routines and transforms for the jobs.
• Experience in using Data Stage Director to Validate, Run, and Schedule and Monitor Data Stage jobs.
• Worked extensively on all the stages such as Sequential file, Aggregator, Hashed Files, Sort, Link Partitioned, Link Collector and ODBC.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator and Peek stages.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Used Ascential Metastases for data integration and standardization for loading in Oracle data warehouse.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from Oracle and DB2 databases, transformed data and loaded into Oracle data warehouse.
• Also extracted data from Flat files, Sequential files and access files, applied transformations and loaded the data into Oracle data warehouse.
• Created Data Stage jobs and Job sequences and tuned them for better performance.
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse.

Environment: Accentual Data Stage 7.5, Erwin4.0, Oracle 9i, DB2 UDB 7.2, TOAD 7.4, PL/SQL, Windows server 2003/NT, AIX UNIX 5.2.

Confidential, Durham, NC

Sr. Data Stage Developer

Responsibilities:

• The Project goal is to load the Members related data for various Applications into the DB2 Enterprise Data Warehouse and MS SQL Server. This involved in pulling data from various source systems like Flat Files, Oracle, DB2 and Sybase and loading the target to EDW data warehouse.
• The main purpose of the project was to build integrated reporting of health and care management including integrated, web-based, on demand reporting capabilities for employers as well as internal consulting staff thereby improving customer access to clinical and financial data to help.
• Worked with Provider, Claims, and . Member Risk, Products, Audit and

  Capitation modules under the HIPAA.

• Worked on more than 8 waves among 24 and involved in migration from server jobs to parallel, Involved in designing the simple to complex Data Stage jobs.
• 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 Data Stage Manager to Import/Export projects from development server to production server and implemented Slowly Changing Dimension techniques.
• Coordinated K tables with dba for each wave in dev, test, prod and monitored common routines list and priority, providing specifications.
• Created and executed SQL queries for validating transformation rules used in source to target mappings. Worked on SQL/PLSQL queries for extraction of data.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Developed Job Sequences, job activities, execute commands, user variable activity and implemented logics for job sequence loops, recovery and restart.
• Performed the unit testing using MS Access and extensively used Daptiv for defects management.
• Identified performance bottlenecks and suggested improvements.

Environment: Ascential Data Stage 7.5, Erwin4.0, Oracle 9i, DB2 UDB 7.2, TOAD 7.4, PL/SQL, Windows server 2003/NT, AIX UNIX 5.2.

Confidential, Chicago, IL

Sr. ETL/ Data Stage Developer

Responsibilities:

• Extensively worked with Data stage Designer for developing various server jobs and parallel jobs using Sequential file, Teradata Connector, MQ Connector, XML Parser and Transformer stages.
• Developed BTEQ Scripts to process the data from staging to history database and from history to simulation database.
• Worked on MQ Connector, which was the source system for most of the feeds.
• Created Master controlling sequencer jobs using Data Stage Job Sequencer.
• Monitored the jobs in production for any possible errors.
• Assisted Data stage Admin to create environment variables and projects using Data stage Administrator.
• Created support documents for the offshore team. Conducted Knowledge Transfer sessions to help the offshore team understand the process.
• Deployed projects from development environment to Prep rod and from Prep rod to Production.
• Prepared mapping documents and high-level documents.
• Analyzed the source data to check if it is matching the requirements.
• Error handling was done by loading the reject data into the metadata and error tables.
• Resolved the error tickets by revisiting the jobs and
• Used XML Parser to parse the data
• Designed and developed DataStage routines to populate the Meta data tables.
• Migrated previously developed projects from DataStage 7.5 to 8.5.
• Handled different source systems such as flat files, XML Feeds, MQ Connector.
• Monitored MQ to check the messages in the queue and to load the queue with the messages.
• Involved in Unit, Integration, System and User Acceptance Testing (UAT).
• Supported business users during User Acceptance Test (UAT) and Post Implementation Phase.

Environment: IBM Info Sphere Data Stage 8.5 (Administrator, Designer, Director), DataStage Enterprise Edition 7.5.2/7.1, MQ 7.5, Message Broker, Teradata, BTEQs, shell scripts, SQL, PL/SQL, XML, PUTTY, WinSCP, Corntab, AutoSys.

Confidential, Bloomington, IL

Sr. Data stage Developer

Responsibilities:

• Worked closely with data population developers, multiple business units and report developers to identify key information that will enhance business decision-making.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates Business Rules and Functionality Requirements into ETL procedures.
• Used various Source Databases like (DB2, MS SQL, Sequential Files, and Complex Flatfiles) to Read Data and Transformed in to Target DB2 tables using various Transformation Rules (Business Rules).
• Generated various jobs using DataStage Stages like Aggregator, Join, Transformer, and Hashed file, Sort, Merge and ODBC.
• Used Various After and Before Built in Routines (DSSendMail, DSWaitForFile, and ExecSH).
• Used Built-in, Plug-in and Custom Stages for Extraction, transformation and loading of the data, provided derivations over DS Links.
• Scheduled job sequences using Autosys and Windows scripts.
• Written documentation to describe program development, logic, coding, testing, changes and corrections. 11
• Worked with DataStage Administrator to create/modify/delete projects and cleanup projects.
• Provided technical assistance and support to IT analysts and business community.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interface

Environment: IBM WebSphere DataStage 7.5, IBM DB2, MS-Visio, Autosys and Windows XP Professional

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in DataStage Designer.
• Extensively worked with Facts and Dimension tables to produce source - target mappings based upon business specs.
• Used Data Stage Manager to implement the Import and Export Interfaces.
• Developed many DataStage application jobs for data processing, loading and jobs are scheduled using DataStage Director.
• Designed several Data Stage parallel jobs using Sequential File, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Dataset, Pivot stages, Aggregator, Transformer, Modify, and Compare.
• Automated Job Control using Batch logic to execute and Schedule various DataStage jobs.
• Migrated data from Oracle, SQL Server, DB2 and other flat files data sources using DataStage.
• Analyzed and tuned the database application for performance improvement.
• Extensively used Data Stage Designer components to design various Parallel jobs in accordance with business specs.
• Developed the ETL Jobs for handling the SCD Type-II Surrogate Key generation.
• Used Before and After Stage subroutines to further enhance performance of the system.
• Developed the Data Quality jobs, performed the Unit testing of all the jobs through the Job Sequences and documented the test case results as per the standards.

Environment: Ascential Data Stage 7.1, DB2, Teradata, Oracle 9i, SQL, PL/SQL, Shell Scripts, Erwin, UNIX, Windows NT 4.0.

Confidential

DWH Developer

Responsibilities:

• Database servers and backup server’s installation.
• Support of Production, Development and Test Environments of Oracle and Sybase Databases for multiple applications.
• Troubleshooting and Performance tuning of SQL Servers and applications.
• Backup and Recovery procedures for Production and Development servers.
• Running DBCC and fixing database consistency and allocation errors.
• Creating databases, tables, indexes, new logins, users etc.
• Monitoring performance of Oracle database.
• I extensively worked on Oracle PL/SQL programming. As part of this, I developed packages, procedures, and functions.
• Statistics maintenance.
• Converted Dozens of SQR Reports to Teradata SQL reports.
• Writing shell scripts to schedule tasks.
• Creating stored procedures and triggers.

Environment: Informatics 6.1, Oracle 9i/10g, DB2, flat files, PL/ SQL, Windows 2003 Server, UNIX (Korn Scripts), and SQL* Loader, Erwin.