PROFESSIONAL SUMMARY:

• Over 7 years of IT experience with extensive noledge in Software Development Life Cycle (SDLC) involving Requirements Gathering, Design Analysis, Development, Maintenance, Implementation and Testing.
• Extensive noledge in Development, Analysis and Design of ETL methodologies in all teh phases of Data Ware housing life cycle.
• Over 7+ years of in - depth experience in Extraction Transformation and Loading (ETL) using DataStage.
• Over 2 years of experience in Business Intelligence Reporting tool Cognos 8.4.
• Extensively made use of stages like Transformer, Sequential, Aggregator, Sort, Lookup, Merge, Modify, Join, Change Capture, Funnel, Peek stages, Copy, Dataset, Filter, Enterprise database stages, Connector stages in Parallel Extender job.
• Extensive worked on Oracle, SQL Server, and Nettezza DB.
• Extensive experience using teh scheduling tool CA Workstation ESP Scheduler, Autosys.
• Experienced in working with version controlling tools SVN, StarTeam, GIT.
• Worked on Agile methodology, Waterfall model projects.
• Experience in Technical documentation (Source-Target Mapping, ETL Design Documents, Impact Analysis, Production Support Handover documents)
• Extensive experience in loading high volume data and performance tuning.
• Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema.
• Knowledge on Job Sequences to control teh execution of teh job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
• Have extensive noledge on teh BI Architecture.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Ability to work autonomously and also as part of a team under tight deadlines so as to meet any project expectations.
• Suggested Service improvement areas and implemented them successfully.
• Migrated data stage lower version applications to higher versions.
• Have hands-on experience on Teradata, Informatica 9.1 power center.
• Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
• Excellent ability to understand and analyze teh customer requirements. Excellent customer interaction skills.

TECHNICAL SKILLS

Programming Languages: PL/SQL,Java,C

Databases: Oracle 11g, SQL Server 2008, Nettezza 7.0.2.11

Development Tools: Data stage 8.x, Data stage 7.5, Cognos 8.4, SQL Developer, Toad, Aginity workbench

Professional Experience:

Project 1: Health Care data migration

Client: Premier, Inc., Charlotte, NC.

Duration: Jan 2015 - Present

Technologies/Tools: Datastage 8.7, Nettezza, AIX, Autosys, Tortoise GIT, JIRA, Aginity Workbench

PROFESSIONAL EXPERIENCE

Confidential

Industry Leader

esponsibilities

• Collection, analysis and translation of high level business requirements into functional specifications, and management of changes to such specifications throughout teh development lifecycle of teh project.
• Worked in using agile business methodology using JIRA (Scrum), Kanban Board.
• Worked with different Medical source systems like Preferred One, EPIC, ALL Scripts, and Cerner.
• Developed Datastage ETL Jobs to extract data from teh sources mentioned above and load teh data into Nettezza target tables.
• Designed teh source to target mapping documents for Dimensions and Facts.
• Worked on Nettezza commands (NZSQL, NZMigrate) to move teh data around different environments.
• Extensively worked on type 1 and type 2 tables.
• Worked on development, scheduling of autosys JILS.
• Developed UNIX shell scripts for data load process and data migration.
• Extensively worked on Lookup, Join, funnel, merge, Change Capture, Nettezza Connector, dataset, sequential file, transformer, aggregator, shared containers, Modify, Copy, Remove Duplicate stages.
• Worked on Performance tuning of teh long running jobs.
• Written complex SQL logics to meet teh business requirements.

SRO Sunset ETL Developer

Confidential, Philadelphia, PA

Technologies: Data stage 7.5, oracle 11g, SQL Server, UNIX, Windows 2003 Server

Responsibilities

• Understanding teh Technical design document and Source-To-Target mappings.
• Prepared Program Specification Documents after understanding Detail Design Documents.
• Designed teh ETL process using DataStage tool to load data from source to target Schema.
• Developed various kinds of jobs according to Design Documents.
• Developing parallel jobs Using stages like Dataset, Sequential file, Aggregator, Copy, Funnel, Lookup, Join, Merge and Transformer Etc.,
• Involved in teh complex Modules to accelerate teh delivery.
• Preparing Unit Test Cases and executing them for each job.
• Testing teh Jobs to assure dat data is loaded as per Unit Test Case documents.
• Moving teh ETL jobs From Development to QA Server.
• Running, monitoring of teh jobs using Data Stage Director and checking logs.

ETL Data stage Migration Project

Confidential, Philadelphia, PA

Technologies: Data stage 7.5, Data stage 8.1, Data stage 8.5, Oracle 10g

Responsibilities

• Import, Export of all teh datastage jobs
• Performing dry run of all teh datastage applications.
• Prepared teh Unit test case documents.
• Testing of all teh individual jobs and analyzing teh performance.
• Testing of teh data loaded into teh database tables.
• Interacting with clients to understand teh data.
• Making changes to teh old jobs to optimize teh performance.
• Performance tuning of all teh jobs.
• Attending checkpoint meeting with teh clients and having daily calls with teh team members.
• Provided support in monitoring teh ETL batch jobs.

Confidential, Philadelphia, PA

Technologies: Data stage 8.5, Cognos 8.1

Responsibilities

• Collecting teh requirements of teh application from teh client through regular interaction.
• Prepared Functional Specification Document and Design Specification documents.
• Was part of database model design team
• Interacted regularly with teh client to get teh sign off for teh database model.
• Developing parallel jobs using stages like Dataset, Sequential file, Aggregator, Copy, Funnel, Lookup, Join, Merge, change capture and Transformer Etc.
• Prepared unit test cases and successfully implemented them.
• Followed all teh performance tuning mechanism for optimization of teh job run.
• Created jobs sequences and job schedules to automate teh ETL process.
• Designed quality alert reports using Cognos.
• As part of teh production support, monitored teh batch jobs, worked on teh issues raised by teh user.

Confidential

Technologies: Data stage 8.1, Cognos 8.4, oracle 10g

Responsibilities:

• Collecting teh requirements of teh application.
• Prepared Design Specification documents.
• Creating tables in teh Oracle database.
• Designing, developing and loading data into data warehouse by using various processing stages of Datastage like Aggregator, Filter, Funnel, Join, Sort, Merge and Lookup to Design a Source to target mapping for loading tables for a target database.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform teh data based on teh business requirements.
• Prepared unit test cases and successfully executed them.
• Followed all teh performance tuning mechanism for optimization of teh job run.
• Generated Cognos Reports according to teh requirements and performed unit testing.
• Prepared Test cases for teh application and executed them.
• As part of production support, monitored teh batch jobs.
• Presented teh application using power point presentation to teh users.
• Production Support and maintenance of teh application.
• Running teh Full refresh on client’s request.
• Monitoring teh data stage jobs.
• Modification of teh existing jobs based on teh Change requests raised by teh business.
• Optimization of teh datastage jobs to reduce teh batch run time.
• Regular interaction with teh business team to understand teh business requirements of teh change requests.
• Suggested service improvements and implemented them successfully.
• Prepared unit test case documents as part of teh change requests.
• Performed System, UAT testing as part of teh change requests testing.
• Modification of teh Cognos reports based on teh changes requested by teh business.

Confidential

Responsibilities:

• Designing, developing and loading data into data warehouse by using various processing stages of Datastage like Aggregator, Filter, Funnel, Join, Sort, Merge and Lookup to Design a Source to target mapping for loading tables for a data mart.
• Developed data marts by creating new transformations and load data from various sources like relational databases; flat files etc. into teh data warehouses.
• Used Datastage Administrator to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh Data Marts.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process teh data.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures and triggers for extracting as well as writing data.
• Used teh DataStage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions on an ad hoc or scheduled basis.
• Created jobs sequences and job schedules to automate teh ETL process.
• Technical support for team for various issues like target mappings and testing.
• As part of teh production support, monitored teh batch jobs, worked on teh issues raised by teh user.