PROFESSIONAL SUMMARY:

• Over 10 years of IT experience in data warehousing projects with working experience on IBM DataStage, Apache Impala, Oracle, DB2, MS - BI and UNIX scripting.
• Experience Working on Data Analysis of multiple systems like IBM-MDM, Salesforce, Loans, ACH, Wires, AML, Peoplesoft ERM.
• Worked on designing, developing, debugging DataStage Server as well as parallel jobs on versions 7.5, 8.1, 8.5, 9.1, 11.3 & 11.5.
• Working experience on Data Mapping, Physical Data Modelling, establishing Data Dictionary for Wealth & Asset Management.
• Worked on DataStage Server installation and Database configuration.
• Worked on Data Integration with Salesforce, Web services, Peoplesoft ERM, IBM-MDM, MQ Server.
• Extensive experience working on C++ functions used for creating Parallel Routines in DataStage.
• Experience on DataStage Administrative tasks like Creating users, Groups assigning roles, Server restart, Job Unlocking.
• Excellent performer in all Software Development Life Cycle from Requirement gathering, Mapping, Design, Build, Test, Review, Analysis and Deployment.
• Expertise on UNIX shell scripting for file FTP’s, File modifications, DataStage job scheduling.
• Lead the team of engineers to successfully implement 2 of major DataStage migration projects from DS v7.5 Server to DS v8.1 Parallel jobs, project constituted of 7k hours.
• Deep understanding of DW/BI concepts and life cycle.
• Experienced working on several scheduling tools like Control-M, Cron jobs.

TECHNICAL SKILLS:

Data Warehousing: DataStage v 7.5, 8.1, 8.5, 9.1, 11.3 & 11.5, SSIS, Apache Impala

Reporting Tools: Cognos 10

RDBMS: Oracle 11g,10g,9i, MS SQL Server 2008, UDB DB2 9.x

Programming: SQL, PL/SQL, SOQL, UNIX Shell Scripting, C++

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Other Tools: TOAD, MS-Office suite (Word, Excel, Project and Outlook), Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Data Analyst / Data Integration Lead / DataStage Developer

Responsibilities:

• Work with Business Users, Business Analysts to gather business requirements and use cases.
• Prepare Data Mapping, Data Dictionary, Reference Data documents & develop Physical data modelling.
• Work on ETL detailed design, coding, review & project delivery.
• As a Data Analyst work with Business users to understand several source systems feeding data to AML, use several rules to compare data from source systems vs AML vs MDM to certify MDM as a new source to AML.
• Establish SQL queries in Oracle, Impala based on data rules available from business users. Discover the data at Account & Transaction level granularity.
• Design the Interface documentation to expose data to multiple downstream systems

Environment: IIS DataStage 9.1, 11.3 & 11.5, Unix, Oracle SQL developer 4.0, Control m v8.0, Apache Impala

Confidential, San Antonio, TX

ETL Lead, Data Analyst, Developer

Responsibilities:

• Providing thought-leadership on ETL development and administration and perform technical lead role across multiple projects simultaneously.
• Working with the project team members to develop a reliable project plan and ensure the timely delivery of the project deliverables.
• Working with the SME's and business user to define requirements and address any issue occur in the conversation/testing phase.
• Partner with other application development teams to ensure scalable and stable ETL integration applications.
• Lead the ETL team to implement 2 migration projects from DS Server Edition v7.5 to Parallel Edition v8.1(including 370 DS jobs), And 1 data warehouse development Project for Clients Sales Reporting across Time, Products, and Areas. Supported and stabilized the key ETL cycles of actuaries.
• Proposed error handling and Performance improvement solutions to gain business to the client
• Migrated around 370 DataStage jobs from v8.1 to 9.1
• ETL Design, Review, Domain understanding, Client Communications and Providing Technical Solutions, requirements translations & estimation preparations.
• Lead the team of 5 for two of major DataStage migrations from server v7.5 to parallel v8.1 and from parallel v8.1 to v9.1.
• Responsible for DataStage job design flow, troubleshooting, DataStage environment setup, data analysis, Job reviews, deployment & support

Environment: IIS DataStage 9.1, Oracle & Microsoft SQL, Control-M, Unix Shell Scripting.

Confidential

ETL Developer/ Lead

Responsibilities:

• Interacting with business analysts to understand the data transformation requirements.
• Developing design, DataStage job build on v8.1, preparing test plan and test scripts and data analysis.
• Analyzing the PL/SQL procedures to gather the business logic which needs to be implemented.
• Executing and comparing the outputs of PL/SQL as well as ETL to perform testing.
• Experienced in troubleshooting DataStage jobs, fixing bugs and addressing production issues like performance tuning and enhancements.
• Actively involved with all other cross functional support teams to ensure the smooth delivery as per project plan. Participated weekly status calls and provides updated status to all stake holders
• Performed troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs.
• Managed Security, Active Sessions, Logs, Unlock Jobs, Datasets, Scratch, Schedules and Assets from Web Console Designing and coding the data transformation interfaces to meet the data transformation needs with optimum performance.

Environment: IIS DataStage 8.1(Parallel Edition), Oracle 9i, Unix Shell Scripting, Oracle

Confidential

ETL Developer and Mentor

Responsibilities:

• Interacting with business analysts to understand the data transformation requirements.
• Worked on DataStage v8.1 & 8.5 to build jobs and help team on technical challenges.
• Data analysis and comparison of transactional reports and Reports from OLAP layer.
• Have worked on server installation and configuration for initial tool setup.
• Have developed shell scripts to call DataStage and schedule the flow.

Environment: IIS DataStage 8.1/8.5, IBM DB2 V9.7, Erwin, DB2, DW-BI Concepts

Confidential

ETL Developer

Responsibilities:

• ETL design, build and testing on DataStage 7.5 Server Version.
• Also worked on preparing test plan and cases.
• Developed various kinds of jobs/job sequences using DataStage designer for data loading.
• Compile, Run, Monitor & Test the developed jobs.
• Written Unit test cases based on the ETL Specification & Involved in ETL documentation.

Environment: DataStage server edition v7.5 and SQL Server 2005, PL/SQL Scripts