PROFESSIONAL SUMMARY:

• Over 13 years of Software Experience with 10 years of experience in Data Warehouse development and Data Warehouse Management System.
• Excellent experience in Data warehouse Development using ETL tool Ascential DataStage 8.01/7.5/6.x/5.x. (DataStage Server & Parallel Extender), Data cleansing and Metastage.
• Experience in converting business requirements into a feasible technical solution by applying client - server and database skills using DB2 UDB, Oracle, SQL Server, and MS Access in mixed OS environments.
• Experience in designing and co-coordinating development efforts in my role as Architect, Lead & Developer. Successfully implemented ETL projects on time by monitoring and suggesting improvements to other ETL developers.
• Doing multiple POC’s related to Big Data.
• Developed ETL Standards & Best Practices for DatStage projects
• Created Functional Design & Detail Design Template for development
• Multi Tasked with large teams and Multiple Projects. Well versed with all phases of Software Development Life Cycle (SDLC).
• Understands complex test requirements and able to formulate test planning and design approaches to support requirements; able to perform multiple responsibilities concurrently.
• Extensive experience in design and development of Decision support Systems (DSS).
• Good experience in Requirements Gathering, Data flow Diagrams Designed, Application Systems Developed, Maintained and Redesigned.
• Extensive experience in writing and implementing of Triggers, Stored Procedures and Functions using PL/SQL.
• Involved in training other members of the team on using Ascential DataStage/ Unix / Business Objects.
• Excellent knowledge of Unix Shell Scripting including Job Schedulers such as Cron and Autosys.

TECHNICAL SKILLS:

ETL Tools: DataStage 9.1/8.7/8.0.1/7. x/6.x, Quality Manager, Ab-Initio 2.13, Hadoop, Hbase, HIVE, PIG

Client/Server: D2K, Visual Basic, Visual FoxPro 6.0, Lotus Notes

Reporting Tools: Business Objects 5.x/4.1, Crystal Reports

Testing Tools: WinRunner7.5, TestDirector

Languages: C, C++, COBOL,C#,.NET, SQL, PL/SQL and Java

Databases: Oracle 10g/11g, DB2 UDB, Netezza,Teradata, MS-SQL Server, Sybase

Operating System: Windows NT/2000, UNIX (HP UX, Solaris 2.7/8, AIX),AS/400, OS/390.

Web Applications: HTML, Perl, XML and JavaScript

Wireless Technologies: WAP, WML, WMLScript, GPRS and Bluetooth

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Sr. IT Consultant

RESPONSIBILITIES:

• Accountable for successful delivery of the Compliance Framework (CF) using Enterprise information integration Data Model on Operational Data Store (ODS) with various source systems data through ETL DataStage.
• Extensively participated in data model design for Compliance framework which has 60 plus tables.
• Responsible for managing the project level status, timeline, risks, issues, change requests for various project deliverables.
• Extensively involved in design, implementation and maintenance phases of major compliance projects.
• Collaborated in developing Java Custom Objects to derive the data using Java API. used Java Client and Java Transformer to integrate the functionality of a java class into the flow of a Data Stage Job.
• Well-tuned ETL DataStage jobs for Compliance Dashboard application for better performance.
• Currently leading three major initiatives.
• Designed 20 plus Cognos reports.
• Responsible for managing Off-shore team to delivers product in given time lines with high efficiency.

Environment: Ascential DataStage 9.1, DB2, Oracle, Teradata, Cognos, Linux, Java 6,AIX 5.2

Confidential, Chicago

Sr.ETL Consultant

RESPONSIBILITIES:

• Written Technical Documents for multiple Functional Area’s
• Migrated complete project from 8.0.1 version to 8.7 version
• Designed and developed various DataStage jobs that cater various business needs.
• Trained other ETL developers on the best practices as well as performance improvement techniques. Trained other members of the team new to DataStage.
• Identifying and addressing the data quality issues.
• Created SQL Scripts for QA Analyst for Testing Data.
• Technical support to other teams on ETL as well as trouble shooting issues with the tool.
• Optimization/Tuning of code to improve performance

Environment: Ascential DataStage 8.7/8.0.1 EE, Oracle, AIX 5.2

Confidential, Chicago

ETL Designer

RESPONSIBILITIES:

• Written Technical Documents for multiple Functional Area’s
• Migrated complete project from 7.5.1 version to 8.1 version
• Worked on multiple enhancement project and developed and modified the existing jobs
• Support to SIT & UAT environments

Environment: Ascential DataStage 8.0.1/7.5.1 EE, DB2, QC, AIX

Confidential, Chicago

Sr. ETL Consultant

RESPONSIBILITIES:

• Constantly identifying and creating common components to use across projects and standardizing code implementation thereby increasing productivity of the team as a whole.
• Implemented Batch Architecture framework
• Data Modeling for ETL Audit module
• Worked simultaneously on multiple projects
• Performed the requirement analysis and written Detail Design documents as per Functional Design.
• Created more than 100 jobs/ routines to load database tables.
• Optimization/Tuning of code to improve performance
• Created SQL Scripts for QA Analyst for Testing Data.
• Performed Unit testing and Integration testing of the module.
• Technical support to other teams on ETL as well as trouble shooting issues with the tool.
• Defects were tracked using BugZilla to analyze the variation between the expected and actual results.

Environment: Ascential DataStage 8.0.1/7.5.2. a EE, Oracle 10g, AIX 5.1

Confidential, Louisville

Sr. ETL Consultant

RESPONSIBILITIES:

• Designed Shared Container jobs.
• Solving the Production Issues.
• Created more than 50 Parallel and Server Jobs in Enterprise Edition to load data into Web Services
• Developed RTI Job’s and integrate with Web Services
• Extensively used XML Input Stage to read Soap Message from Web services and process large volume of files to different Database’s.
• Used XML Output Stage to create XML Structures from relational data
• Tested the Web Services with Soap Scope
• Worked with Confidential in solving key issues of Web Services.
• Identifying and addressing the data quality issues.
• Optimization/Tuning of code to improve performance
• Written shell Scripts to clean tmp files and log files
• Enhancement to current jobs

Environment: Ascential DataStage 7.5.1.a EE, TWS, Netezza, Oracle 9i, AQT, AIX 5.1, Web Services 5.1

Confidential, Chicago

Sr. ETL Developer

RESPONSIBILITIES:

• Used SAP R/3 Load IDoc Stage to load data into MARA Tables
• Used SAP R/3 Load IDoc Stage to load data into PNWYTH Tables
• Used SAP R/3 Load IDoc Stage to load data into KNA1 Tables
• Extensively involved in Developing Shared Containers.
• Used Complex Flat Files to read Cobol Copy books and load data into Sql Server Tables
• Identifying and addressing the data quality issues.
• Optimization/Tuning of code to improve performance

Environment: Ascential DataStage 7.5 Px, SQL Server2000, Ascential Version Control, DB2 UDB, AQT.

Confidential, Chicago

Lead Developer

RESPONSIBILITIES:

• Designed and developed various DataStage jobs that cater various business needs.
• Trained other ETL developers on the best practices as well as performance improvement techniques. Trained other members of the team new to DataStage.
• Identifying and addressing the data quality issues.
• Created SQL Scripts for QA Analyst for Testing Data.
• Technical support to other teams on ETL as well as trouble shooting issues with the tool.
• Optimization/Tuning of code to improve performance
• Created scripts to backup projects everyday, there by creating a failsafe system in case of server crashes.
• Tested the production data by comparing the data in the Crystal report with source data in the database.
• Performed Unit testing and Integration testing of the module.

Environment: Ascential DataStage 7X, Ascential Version Control, Oracle 9i, Fox Pro 8

Confidential

Spoke Lead

RESPONSIBILITIES:

• Actively involved in writing Confidential Design for various spokes
• Completed three Spokes Successfully for the Citizen bank
• Designed and developed various DataStage jobs that cater various business needs
• Identifying and addressing the data quality issues.
• Optimization/Tuning of code to improve performance
• Collected the information from various departments in the organization and created test Scripts and plans based on that information.
• Tested the production data by comparing the data in the Web Focus report with source data in the database.
• Defects were tracked using TestDirector to analyze the variation between the expected and actual results.
• Performed Unit testing and Integration testing of the module.

Environment: Ascential DataStage 7.5 PX, SQL Server2000, DB2 UDB,, Web Focus, UNIX Shell Scripting, and Test Director.

Confidential

Sr. ETL Developer

RESPONSIBILITIES:

• Actively involved in the design and development of the auditing of ETL jobs, which would give information on the job success/failures, as well as the ability of back out of database loads. This process helped identify many issues with the jobs and the ability of run metrics and analysis on the ETL jobs coded.
• Converted DTS packages into datastage.
• Supported & modified the exiting DTS packages as per new business requirements.
• Extensively worked with Administrator in modifying odbc.ini files and configuring the databases.
• Accessed DataStage internal files to retrieve information not available through traditional means of the tool. This information was helpful for the diagnosis of jobs.
• Completed three projects for the bank and acted as the spoke lead in achieving the deliverables.
• Created routines to automate processes those were done manually during promotion of code to production. This negated the human errors thereby saving time for the team.
• Created scripts to backup projects everyday, there by creating a failsafe system in case of server crashes.

Environment: Ascential DataStage 7.5/7.0, Ascential Version Control, DB2 UDB,, BusinessObjects, UNIX Shell Scripting, DTS SQL, SQL Server 2000,TestDirector.

Confidential

Applications Developer

Responsibilities:

• Designing the user interface for all modules, developing, testing programs for quality & preparing documentation in Developer/2000 Forms 6i, Reports 6i.
• Upgraded Oracle Applications customized forms from 10.7 Char Mode to 11i using Flint 60 utility tool.
• Modified and created custom views in Oracle Order Management and Oracle Receivables modules to support Oracle 11i table structure.
• Developed multi query matrix reports using Reports 6i.
• Wrote complex PL/SQL scripts and reports for accurate data interaction and reporting.

Environment: Oracle 8i, WinNT, Crystal Reports

Confidential

Programmer

Responsibilities:

• Developed ORACLE database for storing inventory and payroll details. I had the sole responsibility from requirement analysis to software installation.
• Designed front end using ORACLE FORMS and reports using ORACLE REPORTS enabled employees to access the inventory and payroll data by developing Web interface for the database. HTML, ASP and DHTML were used for web design.
• Development and Customization Framework using .NET.

Environment: Oracle7.x, ASP,.NET,HTML and Windows NT