SUMMARY

• Over 10+ years of experience in System Analysis, Design and Development in the fields of Data Warehousing, Data Integration, Data Migration and developing Client server application using Confidential Infosphere DataStage/QualityStage (8.x/7.x/9.x),Oracle, PL/SQL, DB2 UDB and Shell Scripts. Working with Confidential from .
• Extensive experience in Data warehousing tools Confidential DataStage v 9.1/8.x/7.x Parallel Extender PX and Data Modeling Tools (Erwin, VISIO).
• In Depth knowledge in Data Warehousing & Business Intelligence concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Strong experience with Star and Snowflake schema, Dimensional Data Modeling, Fact and Dimensional tables, Slowly Changing Dimensions.
• Experience in extracting data from sources like SFDC, SAP, Oracle, DB2, SQL Server, Mainframe flat files, XML files and loading to target tables using Confidential DataStage Tool.
• Developed Audit Controls and Reports using DataStage Routines, Shell Scripts and Stored Procedures to audit the data at several different stages of the ETL processing like Source systems, Staging, Data Warehouse and Data Mart.
• Developed Test Cases, Test Scripts and SQL to perform Unit Testing, System Testing and Load Testing. Worked with Operations and Platform teams to migrate ETL Code and DB objects from Development to Testing, UAT and Production.
• Extensive Knowledge on the Project life cycle and Project Management process.
• Experience in supervising and leading development teams for ETL code development, unit testing and documentation across onsite and offshore.
• Coordinated with cross functional team like Solution Architecture, Business Analyst, QA Testing, Performance Tuning and Operations team to ensure the timely and successful delivery of projects.
• Experience with working in the Agile Development Methodology.

TECHNICAL SKILLS

ETL Tools: DataStage/QualityStage 9.1/8.x/7.x (SAP Pack 6.0, SFDC Pack), Pentaho 4.2.1

Databases: Oracle 11g/10g/9.x, DB2 UDB 8.x/7.x

Database Modeling: Erwin 3.5.2/4.0, Microsoft VISIO

Software Tools: MS Office Suite, TOAD, SQL Programmer, PVCS Version Manager, HP Quality Center

Job Schedulers: Autosys

Languages: SQL

Operating Systems: Windows 7/XP/2000, DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Team Lead/ Project Lead

Responsibilities:

• Performed data profiling on the source data to investigate for special characters, nulls and data anomalies. Documented the results for designing the error handling rules engine.
• Designed the error handling engine to perform data validations, error checks on the source data and to handle and report the data errors and processing errors.
• Led a team of ETL developers to develop and unit test the Source to Target jobs ensuring all the required gateway documents like technical specification and test results are prepared.
• Worked closely with the development team to ensure that all deliverables were met as per the project plan.
• Developed UNIX Shell scripts for file validations, FTP files to and from ETL servers.
• Create Autosys JIL’s and schedule the same in Autosys
• Coded the DataStage jobs for the daily change data capture process. This was accomplished using a set of generic jobs.

Confidential, RTP, NC

ETL Technical Lead

Responsibilities:

• As Onsite coordinator, handling a Team of 10, their assignments, Responsible for in time delivery of all the projects for the team members and their technical mentoring.
• Analyzing business requirements with Business Users and provide the KT session with offshore.
• Addressing User issues, end to end analysis of production problems and suggesting resolutions for the same.
• Data Validation and Analysis.
• Tuning and enhancement of the existing Data Stage (Server) and parallel jobs.
• Review all the deliverables

Confidential, Sunnyvale, CA

ETL Technical Lead

Responsibilities:

• Developed the ETL for the Source to Stage extracts from SAP CRM system using DataStage SAP Pack.
• Worked closely with the SAP team to understand the relationships between the source tables and then implement them in the ETL.
• Coordinated with the SAP basis team to execute the Load test against the SAP system.
• Worked closely with the offshore team to ensure that the data is delivered in time during the QA and UAT phases of the project.
• Worked closely with the ETL/DB Admin team to ensure that all Database/ETL objects and components are correctly migrated for the Production deployment.
• Led the effort to do performance tuning for the Source to Stage and Stage to EDW jobs for Install Base project.
• The IB cycle end to end run time came down from ~ 7.5 hours to ~ 1.5 hours after the tuning efforts.
• IB Sustaining - addressed production issues and closed them in a timely manner.
• Performed Root Cause Analysis, ETL code fix/data fix for Data issues raised by the business in the Data Warehouse.
• Manage and provide L3 Technical production support for fixing data issues and ETL code issues in the Install Base, Auto Support, Global Services, Stickiness, Service Renewals and PSA areas.
• Scheduled weekly status meetings with business facing teams to keep track of the status of the production support tickets.

Confidential, Warrenville, IL

DataStage ETL Developer/Lead/ETL Tester

Responsibilities:

• Responsible for developing DataStage Jobs based upon the Functional Specification.
• Responsible for creating Technical Design Document for the Functional Specification.
• Responsible for creating Unix script for the DataStage process which would be scheduled in CNTRL-M.
• Responsible for creating Test Case Document for the design and record the result in the Test Environment.
• Responsible for creating documents, required for internal auditing purpose.
• Performed unit testing and system acceptance testing including creating the appropriate test data of the daily change data capture DataStage Jobs, created test SQL, resolved issues found during testing.
• Participated in model reviews and ETL design review meetings.
• Performed code reviews of the developed jobs and fixed the identified defects in the jobs.
• Assisted DataStage developers with design and development recommendations.

Confidential 

DataStage ETL Developer/Lead

Responsibilities:

• Managing and maintaining the applications
• Managing the application includes keeping track of tickets, CSR’s executed against each application, providing the estimates for the Major CSR’s
• Perform the activity of the Application DBA in DB2 for all the applications in the tower.
• Maintaining the application would include solving the technical queries of the application SME’s
• Providing the weekly status report to senior management
• Responsible for managing scope, tracking, change control, aspects of the applications. Ensuring all the Service Request / Change Management related document is present in RPM before we deliver to the customer.
• Supported client by providing ideas to effectively implement business process change into the application change.
• As Technical Team Lead in GMIA Sustain project, I have done requirement analysis for ISAR, IBVA application (sub project) and prepare high level estimates to provide the scope time- lines assumptions and risks for the development of the application.