SUMMARY

• Over 10 years of IT Experience in Software Analysis, Design and Development in Client/Server systems, Data warehousing and Business Intelligence applications.
• 7+ years of experience in building Data Warehouse/Data Marts using InfoSphere DataStage 5.x/6.x/7.x/ 8.01/8.1/8.5
• Extensively worked with Parallel Extender for splitting bulk data into subsets to distribute the data to all available processors to achieve best job performance.
• Experience in integration of various data sources like Oracle, DB2/UDB, SQL Server and Teradata.
• Experienced in UNIX Shell scripting as part of file manipulation, Scheduling and text processing.
• Prepared scripts to transfer the files using FTP, SFTP and SSH protocols.
• 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 and DB2 stages.
• Extensively worked on Data Quality stages like Standardize, Investigate, Match Frequency, Reference Match, Unduplicate, Match, Survive etc
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using SQL, PL/SQL.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Extensive experience in loading high volumes of data.
• Extensively worked in DR (Disaster Recovery ) exercise’s

TECHNICAL SKILLS

ETL Tools: DataStage 8.7/8.5/8.0.1/7.5.2/7.5/7.1/6.0/5.2

Databases: Oracle 11g/10g/9i/8i, Teradata, SQL Server 2000/2005, DB2/UDB 9.7/8.5

Languages: SQL, PL/SQL, C

Operating Systems: Windows NT& 2000/XP, HP - UX, IBM AIX 5.3/4.2/4.1

Data modeling Tools: Erwin4.1, Micro Soft Visio

Other Tools: Toad, AppWorx 6, Oracle SQL Developer, Mercury Quality Center 9.0/10 and MS Office, Autosys, Tidal, IBM WTX, Rational Clear case and Rational Clear Quest, Business objects 5.x

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

ETL/ Sr Data Stage Developer

Responsibilities:

• Developed ETL procedures to ensure conformity, compliance with Ameri Health Standards and to translate business rules and functionality requirements into ETL Procedures.
• Implemented Complex Designs using parallel Stages like Join, Lookup, Pivot, Change Capture and Surrogate Key.
• Designed Jobs involving IBM WTX to set the Business rules in Ops console to load Data from source file’s and load it to STG Tables.
• Wrote Unit test plan documents, captured the test logs and created the test Summary results.
• Worked on Facet’s to validate member information and DRG codes before loading the data to warehouse.
• Worked on TPL Inbound/Outbound load’s from State/ vendor’s..
• Worked on M360 Project (Member data) for Call center rep to provide a detailed info when attending an Member call
• Parameterized the Server/Parallel Jobs using Environmental variables, Parameter Sets and Job Parameters.
• Automation of ETL cycle and by setting the process and its dependency in Tidal scheduler, execution of the same from Tidal scheduler.
• Wrote Unit test plan documents, captured the test logs and created the test summary results.
• Assigning and prioritizing tasks and enforcing project processes and policies.
• Assisting developers with design work, analysis and requirements gathering.
• Participate in peer code review to make sure that coding standard follow.
• Completing a weekly status report for the project manager.

Environment: IBM Information Server DataStage 11.3 /8.7/8.5 , Oracle 11g, Sybase, SQL Server, IBM WTX, Tidal, Clear Case (GUI), Ops Console .Net, OLTP Systems.

Confidential, Erie, PA

ETL/ Data Stage Developer

Responsibilities:

• Built new ODS by extracting data from source system, to help business objects to point their universe to ODS.
• Used different types of Stages like Transformer, Sort, Change Data Capture, Lookup, Join, Merge, Aggregator, ODBC for developing different Jobs.
• Developed Job Sequences using various stages like Job Activity, Routine Activity and Execute Command, and message handlers.
• Extensively worked on Data Quality stages like Standardize, Investigate, Match Frequency, Reference Match, Unduplicate, Match, Survive etc
• Used DataStage Director for compressing warnings.
• Created source to Confidential mapping documents from landing tables to Data Warehouse.

Confidential

Responsibilities:

• Developed and implemented code, Decode at enterprise level.
• Extensively used the DataStage designer to build new data mart with FACT tables.
• Primary technical contact during the analysis, planning, design, development, and implementation stages of data quality projects using Integrity (Quality Stage).
• Used XML source from mainframes and transformed by applying the business logic.
• Developed and implemented job routines, DB2 9.1 storage procedures and parameter sets.
• Extensively involved in implementing the Slowly changing Dimension table
• Created multiple landing zones with data retention logic.

Environment: InfoSphere DataStage Quality stage (8.5), DataStage 7.5. DB2 9.1, DB2 UDB V8.1, Oracle, MDM,Sybase.

Confidential, Durham, NC

ETL/ Data Stage Developer

Responsibilities:

• Involved in requirements gathering and source data analysis and identifying business rules.
• Extensively used the DataStage designer to develop various parallel jobs to extract, transform, integrate and load the data into Active Enterprise Data warehouse (AEDW).
• Used different types of Stages like Sequential File, Transformer, Sort, Change Data Capture, Lookup, Join, Merge, Aggregator, ODBC and TeraData Enterprise for developing different Jobs.
• Developed Job Sequences using various stages like Job Activity, Routine Activity and Execute Command.
• Used DataStage Director to monitoring jobs, run and validating its components.
• Extensively involved in implementing the Slowly changing Dimension table
• Created source to Confidential mapping documents from staging area to Data Warehouse.
• Analyzed and implemented the complex business rules in DataStage
• Wrote BTEQ scripts to load and update data into Teradata tables.
• Participated in the review of Technical and Business requirement documents.
• Created and maintained ETL design document and integration test plans.

Environment: IBM Information Server DataStage 8.1/8.5, Oracle 11g, Microsoft SQL Server 2005, IBM AIX 6.1, Sun Solaris 10, BMC Control-M, Clear Case (GUI), Clear Quest, Java J2EE, Web Services, OLTP Systems.

Confidential, McLean, VA

Sr. Data Stage Developer

Responsibilities:

• Involved in high level Detail design, Technical Design and Unit Test Plans for Projects.
• Requirements gathering and identifying business rules for data mappings and validations.
• Fine tuning of jobs by using best design practices, configuration changes and best data partitioning/collecting methodologies to meet the project requirement.
• Extensively used Data Stage Designer to develop various jobs to extract, transform, integrate and load data into Data mart.
• Extensively used Data Stage Manager to import/export metadata, jobs, and routines from repository, and also created data elements.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Designed and developed the ETL jobs using Parallel Extender which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Designed parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Sort, Change Data Capture, and Aggregator.
• Developed sequencers in designer to run and control set of jobs.
• Handled Performance Tuning of DataStage Jobs to ensure faster Data Loads.
• Created Master controlling sequencer jobs using Data Stage Job Sequencer.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provides values to Data Stage jobs during runtime, execute Data Stage jobs.
• Used DataStage Director to monitoring jobs, run and validating its components.
• Handled Version Control through Rational Clear Case.
• Migrated projects from development to QA to Production environments.
• Scheduled jobs using Autosys job scheduler utility based on the requirements and monitored the production closely for any possible errors.

Environment: InfoSphere DataStage 8.1, DataStage 7.5.3, Parallel Extender, DB2 UDB V9.5, DB2 UDB V8.1, Oracle, Sybase, AIX 5.3, Autosys, Rational Clear case, Rational Clear Quest.

Confidential, Chicago, IL

Data Stage ETL Designer/Developer

Responsibilities:

• Involved in creating Detailed Level Design and Mapping documents for ETL process.
• Developed various jobs using stages ORACLE Enterprise, Sequential File, Wrapper Stage, lookup, Dataset, Join, Sort, Aggregator, Surrogate-key Generator, Pivot, Filter, Transformer, Funnel, Copy, Remove Duplicate and Shared Container.
• Created Wrapper Scripts that are invoked by the Wrapper Stage through DataStage.
• Validated the Input Sequential File which is created using SQL Server Stored Procedures.
• Created DataStage jobs to transfer data between OLTP System Databases.
• Written Insert and Update SQL’s in Oracle Enterprise Stage and validated the load process into the Confidential tables.
• Created Sequence jobs to combine all different Subject area jobs based on the dependencies and functionality of the OLTP System Tables & Chase Commercial Data Warehouse Tables.
• Written various Unix Scripts to invoke DataStage jobs and capture different types of jobs data like Run, Log Summary, and Job Info. Also to invoke DataStage Sequence jobs.
• Involved in integrating and testing the java code through DataStage using UNIX shell scripts.
• Created Dependency Flow Diagram to Create the Sequence Job Activity Flow and to Create Inter Dependencies based master process Sequencer.
• Created Server Routines and Parallel Shared Container for updating the job status, start timestamp and end timestamp in the log tables.
• Performed the Unit testing for jobs developed to ensure they met business requirements.
• Used Clear Case for Version control.
• Used HP Quality Center for Defect tracking.
• Involved in Development Integration Test during DevInt (System Test), Quality Assurance Test and User Acceptance Testing.
• Provided Support for Production failures.

Environment: WebSphere DataStage 7.5.2/8.0.1 , Quality Stage, Information analyzer, Teradata 6.1, Sun Solaris 5.10, Teradata SQL Assistant, Mercury Quality Center 8.2, Microsoft Visio

Confidential, St Louis, MO

ETL/ Data Stage Developer

Responsibilities:

• Developed various ETL jobs to Load Data warehouse from Lawson ERP, Tecsys and PMM systems.
• Worked with the migration of ETL jobs from DataStage 7.5.2 to WebSphere DataStage 8.0.1.
• Created complex data stage jobs in Enterprise Edition using various stages.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.
• Involved in building Logic for Error Management and capture daily load status in to Audit Process Tables for daily ETL runs.
• Developed various Sequence jobs to maintain the process flow.
• Developed Chains and Modules in APPWORX 6 for ETL Job Scheduling.
• Extensively used Mercury Quality Center 9.0 for issue tracking.
• Analyzed and implemented new Business rules for the existing jobs.
• Developed ETL High level and low level design document and production implementation documents.
• Actively participated in knowledge transfer to Production Support Team.
• Created UNIX Shell scripts to call DataStage Job Sequences.
• Wrote several Test Cases and Test Scripts to perform the system testing.
• Created Production Support document and Migrated ETL jobs to Production environment.
• Involved in Production support for ETL Financial DataMart.

Environment: Web Sphere DataStage 8.0.1, Ascential DataStage 7.5.2, LAWSON ERP, Oracle 10g, Oracle 9i, SQL Server2000, TOAD, Oracle SQL Developer, AppWorx 6, SQL, Erwin 4.x, AIX-UNIX 5.3, Mercury Quality Center 9.0, Microsoft Visio.

Confidential, Minneapolis, MN

ETL/ Data Stage Developer

Responsibilities:

• Actively participated in the system design, coordinate with business groups in order to define the requirements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Developed parallel jobs between multiple source systems.
• Used Parallel Extender to create jobs using stages like Aggregator, Transformer, sort, merge, join, lookup, and filter.
• Developed job sequence and implemented restartability using various checkpoints.
• Extensively used Nested condition, Notification activity, sequencer and routine activities in sequence job.
• Took project backups and implemented version control through CVS.
• Performed import and export datastage jobs and various components through manager.
• Involved in system testing and unit testing.
• Responsible for supporting and managing database activity during the development process.
• Developed UNIX shell scripts to automate the Data Load processes through autosys.

Environment: Ascential DataStage 7.5, Oracle 9.0.2, TOAD, SQL, PL/SQL, Erwin 3.5.2, UNIX, CVS and Windows XP.

Confidential

Software Programmer/Analyst

Responsibilities:

• Involved in Designed jobs and analyzing scope of application, defining relationship within groups of data.
• Extensive experience in creating and loading data warehouse tables like dimensional, fact and aggregate tables using Ascential Data Stage.
• Wrote Job Control routines and Transform functions for converting data from one format to other Format.
• Involved in Designing and developing Oracle forms for generating reports from warehouse databases.
• Attended several business sessions with the business users and created daily, monthly and quarter Analysis reports using Business Objects and altered some of the dimensional and Fact tables to satisfy their reporting needs.

Environment: Ascential DataStage 4.2, Oracle 8i, SQL Server, SQL, PL/SQL, Web Intelligence, Windows NT 4.0 and AIX4.2/4.3.