SUMMARY:

• Bachelor of Computer Science and Engineer with 12 years of IT experience in the Analysis, Design, Modelling, Development, Implementation and Testing of Data Warehousing applications
• Experience in complete SDLC of Datawarehouse projects (Software Development Life cycle).Involved in Requirement gathering, Design, Development, Testing, Deployment and Production Support.
• DW DataStage: 10 years of strong expertise in Data Warehousing using IBM DataStage 7x/8x/9.1, 3 years in Informatica 7.1.
• Experience in handling large teams for various Onsite - Offshore model projects and thoroughly involved in implementation of data warehouse projects.
• Databases: Good Exposure in DB2,Oracle, Teradata, MS SQL-Server
• Development/Productivity tools: UNIX Shell Scripts(AIX 5.0)
• Functional Areas: Retail-Warehouse Operations, Healthcare, Banking(BFSI),Communications & Media (CMIE),Insurance
• Experience in working different project deliverable methodology - Waterfall, Agile
• Experience in leading large teams and handling Onsite-Offshore model projects along with skill in co-ordinating with clients.
• Work Authorization - “Permanent Resident” - Green Card and entitled to work in US until 2024.

TECHNICAL SKILLS:

Data Warehousing: IBM DataStage7x/8/9.1x,Informatica 7.1

Databases: DB2 7.1, NCR Teradata, Oracle 8i,9i,10i,11gMS-SQL Server 2008 R2

Development Tools: Unix Shell Scripts, PL-SQL scripts, Mainframe

Environment: AIX 5.0, Win 95/98/2000, Win NT 4.0 Schedulers: Control-M, Zeke Scheduler,Autosys,MQFTE

PROFESSIONAL EXPERIENCE

Confidential

Team Lead - Associate

Responsibility:

• Developed Datastage Jobs for extracting, transforming, integrating and loading data from various sources into the Datamart database.
• Developed Analytics Overview Datamart with Dimension and Fact tables for Reports.
• Guiding team in Requirements Analysis and creation Component Design Specification.
• Ensuring the correctness and completeness of Design. Implementing the quality process, and training new team members on the same.
• Analyzing the technical feasibility through Proof-of-Concepts (for e.g. Using RCP enabled Generic jobs and triggering them through wrapper scripts).
• Leading Datastage Job Development. Creation of Test plan, preparation of Unit test data as per test bed criteria. Guiding the team in Unit & Integration Testing of the Jobs.
• Create the Autosys Job for scheduling and co-ordinate with the Batch Support Team for its execution through creation of Autosys .JIL and DocIt for the same.
• Enhancement of existing Datastage codes to fulfill the changes in Business requirement.
• Monitor and Support the existing process in AODM and fix the jobs in case of job aborts within the given SLA period.
• Co-ordinate with the MQFTE team to create the MQFTE agents for source and destination servers & folders for file transmission.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).
• As an Onsite Lead responsible for leading Onshore Co-ordination with offshore and clients.

Confidential

Team Lead - Associate

Responsibility:

• Extensively used DataStage Designer to explore the existing job processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse database
• Guiding team in Requirements Analysis and creation Component Design Specification.
• Ensuring the correctness and completeness of Design. Implementing the quality process, and training new team members on the same.
• Analyzing the technical feasibility through Proof-of-Concepts (for e.g. Using RCP enabled Generic jobs and triggering them through wrapper scripts).
• Leading Datastage Job Development. Creation of Test plan, preparation of Unit test data as per test bed criteria. Guiding the team in Unit & Integration Testing of the Jobs.
• Coordinating QES support to ensure quick turnaround of observation/defects. Mentoring internal Quality Process to the new team members to ensure quality.
• As a Offshore Lead responsible for leading Offshore Co-ordination with onsite and clients.

Confidential

Team Lead - Associate

Responsibility:

• Extensively used DataStage Designer to explore the existing job processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse database
• Worked asETL Administrator at Offshore.
• Involved in Server shutdown and start up process. Involved in lock Administration, New Project creation and providing settings, job Migration from one environment to another through Data stage version control.
• Maintaining Disk space and clearing archive files through Unix process. Involved in CRON tab Scheduling process and good exposure in server and parallel jobs.
• Coordinating QES support to ensure quick turnaround of observation/defects. Mentoring internal Quality Process to the new team members to ensure quality.
• As a Offshore Lead responsible for leading Offshore Co-ordination with onsite and clients.

Confidential

Team Lead

Responsibility:

• Extensively used DataStage Designer to explore the existing job processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse database
• Extensively used SQL and Oracle coding in DataStage jobs for processing data
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Developed UNIX shell scripts to automate job execution and data loading procedures based on business requirements
• Modification/Enhancement of the existing components and working on new CR's

Confidential

Team Lead

Responsibility:

• Extensively used DataStage Designer to explore the existing job processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse database
• Interacted with Experian/SAS for business transformations for handling special cases
• Involved in decommissioning of specific database columns as per the client’s specification.
• Worked with PVCS Version Controller Tool for code check-in/check-out
• Developed batches and sequencers in designer to run and control set of jobs
• Used the DataStage Director and its run-time engine to schedule running the job, testing and debugging its components, and monitoring the resulting executable versions
• Performed the Unit testing, System testing for jobs developed to ensure that it meets the requirements
• Created the Control-M flow in Visio to submit in scheduler for scheduling the jobs based on impacts.

Confidential

Team Lead and Onsite Coordinator

Responsibility:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data marts.
• Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
• Creation of re-usable components using shared containers for local use or shared use.
• Wrote routines for Error Correction and inserting default values for specific errors.
• Installed Plug-in stages like Teradata Load and Teradata MultiLoad.
• Creation of jobs sequences and job schedules using Tivoli scheduler to automate the ETL process.

Confidential

Team Lead

Responsibility:

• Involved in understanding the scope of application, present schema, data model and defining relationship within and between groups of data
• Implemented and wrote ETL programs to load Intermediary Person and Product dimension tables. Also contributed efforts to develop ETL process for Time, Location, Group dimension tables.
• Created user defined transforms and routines for handling special cases
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).
• Scheduled ETL jobs in Control-M scheduler. Coordinated with System Operators to Schedule the jobs in scheduler. Provided Level 3-production support.