Resume

Sign in

DataStage Senior Consultant,Oracle,SQL,Unix,Quality Stage

Location:
Apex, North Carolina, United States
Posted:
January 25, 2017

Contact this candidate

PRASANNA PILLI

acyg1g@r.postjobfree.com

919-***-****

Employer :

Durga

Sr.Manager-Business Development

acyg1g@r.postjobfree.com

Direct: 682-***-****

IMG Systems Inc.

PROFESSIONAL SUMMARY

Over 10 years of IT experience in Analysis, Design, Development, Implementation and Testing of Data warehousing technologies and Applications.

9 years of technical experience with strong knowledge base in Extraction Transformation Loading(ETL) applications for Datawarehouse using DataStage 11.3/9.1/8.7/8.1/7.5(Parallel Extender & Server), Quality Stage and Unix Shell Scripting including 1 year of PL/SQL experience

IBM Certified Solution Developer, InfoSphere DataStage v8.0

Oracle Certified PL/SQL Developer Associate, Oracle 9i

Hands on experience in writing, testing and implementation of Oracle SQL queries, PL/SQL Triggers, Procedures and Functions

Good knowledge and understanding of Data Warehousing concepts and Unix.

Experience in dealing with Business Analysts and Subject Matter Experts to gather requirements and understand Business needs

Played significant role in various phases of Software Development Life cycle(SDLC)

Team Player and quick learner with excellent Analytical and Problem solving skills

Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.

ACHIEVEMENTS

Applause & Spot Awards from Deloitte Consulting India for exceptional Performance.

TCS Gems Service and Commitment Award for Continuous Commitment.

CERTIFICATIONS

IBM Certified Solution Developer, InfoSphere DataStage v8.0

Oracle PL/SQL Developer Certified Associate (OCA) – Oracle9i

TECHNICAL SKILLS

ETL Tools

IBM Infosphere DataStage 11.3,9.1,8.7,8.1,7.5

Business Intelligence Tools

Cognos

Programming Languages

SQL, PL/SQL

Databases

Oracle 9i/10g/11i, MS SQL Server 2000

Version Control Systems

Microsoft VSS, IBM Rational Clearcase, Solution Manager, Subversion

Platforms

UNIX AIX, Red Hat Linux,Win 9x/NT/XP

Engineering Tools

Eclipse, MS-Office, Notepad++

Database Tools

PL/SQL Developer, Oracle SQL Developer, SQL Plus, Toad

Operating Systems

Windows NT/2K/XP, AIX UNIX, Sun Solaris, REDHAT LINUX

Scheduling tools

Autosys, Unix Cron, Control M

ETL/Datastage Senior Consultant (Deloitte)

Project #1 : EU Supply Chain Integration Jan2014 – Till Date

Client : Baxter, Chicago, IL

Responsibilities:

Lead and manage the team by assigning action items as per requirements.

Convert Functional requirements to Technical requirements by developing mapping specifications for building the Datawarehouse for Europe supply chain

Design Technology solution to cater to client requirements

Lead and manage the team in all phases of SDLC starting from Build, System Integration Testing to Deployment.

Analyze the Change Requests and update the Technical Specifications documents

Coordinate and resolve technical and functional queries of the team during development and testing.

Communicate effectively in meetings with onsite and offshore.

Perform Code and System Integration Testing reviews.

Prepare ETL Run Book for the Support team

Prepare Deployment document and ensure successful deployment of the project.

Environment: IBM Information Server 8.7/11.3, Datastage, Oracle, Ctrl M, UNIX AIX.

Project #2 : ERP - BI Finance

Client : Baxter

Responsibilities:

Convert Functional requirements to Technical requirements

Design Technology solution to cater to client requirements

Drive technical Activities at each phase of project

Manage work of the team and send out action items

Coordinate with onsite on requirement gathering and status updates

Resolve technical issues in daily run of jobs in the project

Analyze the Change Requests and update the Technical Specifications documents

Enhance ETL Datastage Jobs to implement the business logic of the Change Request

Unit Test the Code in Development Environment

Migrate the code to SIT environment and perform the System

Integration Testing

Communicate effectively in meetings with onsite and offshore.

Perform Code reviews to ensure that the code follows Datastage Coding standards

Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX.

Project #3 : Spend Analytics

Client : Baxter

Responsibilities:

Convert Functional requirements to Technical requirements

Design Technology solution to cater to client requirements

Drive technical Activities at each phase of project

Manage work of the team and send out action items

Coordinate with onsite on requirement gathering and status updates

Analyze the Change Requests and update the Technical Specifications documents

Enhance ETL Datastage Jobs to implement the business logic of the Change Request

Unit Test the Code in Development Environment

Migrate the code to SIT environment and perform the System

Integration Testing

Communicate effectively in meetings with onsite and offshore.

Perform Code reviews to ensure that the code follows Datastage Coding standards

Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

Project# 4 : BackOrder and Demand CR’s

Client : Baxter

Responsibilities:

Analyze the Change Requests and update the Technical Specifications documents

Update the Data Mapping documents as per the requirement

Enhance ETL Datastage Jobs to implement the business logic of the Change Request

Unit Test the Code in Development Environment

Migrate the code to SIT environment and perform the System Integration Testing

Coordinate with onsite on requirement gathering and status updates

Communicate effectively in meetings with onsite and offshore.

Perform Code reviews to ensure that the code follows Datastage Coding standards

Involved in end to end SDLC phases until the code moves to production

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

ETL/DataStage Consultant (Deloitte India)

Project#5 : ERP_BI Supply Chain Jul 2013 - Dec 2013

Client : Baxter

Responsibilities:

Develop ETL Jobs to extract data from JDE source systems and load into Staging database

Develop ETL Jobs to extract data from Staging source systems and load into RDW database

Developed Job Sequencers to load data

Developed Ctrl M Code for scheduling the load

Implemented reusability in design by using generic jobs and multiple instance

Performed Code reviews to ensure that the code follows Datastage Coding standards

Interacted effectively in meetings to discuss business requirements

Worked on enhancements of ETL code as per the Change Requests

Involved in end to end SDLC phases until the code moves to production

Effectively done the System Integration testing of all the Change Requests

Environment: IBM Information Server 8.7, Datastage, Oracle, Ctrl M, UNIX AIX

ETL/DataStage Consultant (Bank of America Continuum)

Project# 1 : Master Data Hub Apr 2012 –May 2013

Client : Bank of America

Responsibilities:

Develop ETL Jobs to extract data from SQL Server source systems and load into DB2 database

Developed Shell scripts and Job Sequencers to load data

Developed Autosys Code for scheduling the load

Suggested Performance Enhancements to reduce loading times

Implemented reusability in design by using generic jobs and multiple instance

Performed Code reviews to ensure that the code follows Datastage Coding standards

Handled Support issues and solved within SLA

Performed Migration of IIS code for UAT and Production Environments

Implemented the IIS code in Disaster Recovery Environment

Interacted effectively in meetings to discuss business requirements

Effectively Planned the Migration activity and implemented successfully

Received Appreciation for dedication and commitment towards the deliverables

Environment: IBM Information Server 8.1, DB2, Datastage, Autosys, UNIX AIX, SSH Tectia Client.

Project# 2 : Quality Management System Jan 2012 – Mar 2012

Client : Bank of America

Responsibilities:

Migrate the code from Informatica to DataStage 8.1 by designing reusable jobs in DataStage

Develop ETL Jobs to extract data from Oracle source systems and load into DB2 database

Developed Shell scripts and Job Sequencers to load data

Developed Autosys Code for scheduling the load

Suggested Performance Enhancements to reduce loading times

Implemented reusability in design by using generic jobs and multiple instance

Performed Code reviews to ensure that the code follows Datastage Coding standards

Handled Support issues and solved within SLA

Interacted effectively in meetings to discuss business requirements

Environment: IBM Information Server 8.1, DB2, Datastage, Autosys, UNIX AIX, SSH Tectia Client

DataStage Consultant (Tata Consultancy Services)

Project# 1 : Marketing and Sales Data Mart Jan 2011 – Apr 2011

Client : USAA

Responsibilities:

Develop ETL Jobs to extract data from DB2 source systems and load data into Marketing and Sales Data Marts based on business logic

Develop ETL jobs to load rejected data into tables

Design & Develop Sequencers for loading data

Executed Control M scripts to run the Sequencers

Transported ETL Jobs into QA environment

Perform Code reviews to ensure that the code follows Datastage Coding standards

Implemented Best practices in Job Design and Development

Interacted with Onsite to gather requirements

Environment: SunOS 5.10, IBM Information Server 8.0, Datastage, DB2, Control M

Project# 2 : Business Information Project Jan 2010 – Dec 2010

Client : Owens Corning, Toledo, Ohio

Responsibilities:

Develop ETL Jobs to extract data from SAP systems and load into SAP Business Information Warehouse using the Data Mapping Specifications

Develop Jobs to load data into XML Flat Files using the XML output Stage

Design and implement logic for converting Full loads into Delta for reducing the loading

times of Master Data Objects

Interacted with the Master Data Management Team to gather Business Requirements

Design & Develop Sequencers for loading Master & Transaction Data Objects

Written and Executed Unix Shell Scripts for use in Before Job routines in the DataStage Jobs

Transported ETL Jobs and ABAP Programs into QA environment

Provide on call support to Production system to resolve issues

Perform Code reviews to ensure that the code follows Datastage Coding standards

Reviewed Technical Specifications for Restart & Manual Run Procedures

Implemented Best practices in Job Design and Development

Trained an employee in DataStage

Earned Certification in SAP ABAP Transports

Environment: SunOS 5.10, IBM Information Server 8.0(SAP BW Pack), Datastage, Oracle 10g, SQL Plus, SAP Solution Manager, SAP BW 7.0, SAP Redwood

PL/SQL Developer (Tata Consultancy Services)

Project# 3 : Coordcom 5.1 Jan 2009 – Dec 2009

Client : Ericsson, Sweden

Responsibilities:

Understand the functionality of various Modules in the Coordcom Application

Design and Develop PL/SQL Procedures and Triggers as per the Requirements

Implemented XML Functions and worked with CLOB data types in Procedures

Ported Database components from SQL Server to Oracle 11g

Preparation of Unit Test Case Document and Unit Testing of Database components

Coordinated with the C# team for Integration testing of the Procedures

Integration Testing from the Coordcom Application to ensure successful functionality

Document Control using IBM Rational Clearcase

User Acceptance Testing (UAT) to ensure successful move to production

Ensured Team Work to meet the deadlines for all releases

Environment: SQL Server 2000, C#, Oracle SQL Developer, Rational Clearcase, Oracle 11g

DataStage Consultant (Tata Consultancy Services)

Project# 4 : Verizon Telco Audit Tool (VERIFY) Nov 2007 – Dec 2008

Client : Verizon, Mississippi

Responsibilities:

Developed ETL Jobs to extract data from the Electronic invoices in the form of flat files namely CABS and SECABS and load into an Oracle Database

Used Filter stage to split the files and applied Business Logic to load data

Implemented Merging logic to load a set of split files into a single Oracle Table

Designed sequencers for each format for the daily run

Implemented Error handling to reject bad records in the files

Developed Quality Stage Jobs in order to perform Data cleansing using Investigate, Standardize Stage, Match Frequency, Survive Stage

Implemented Reconciliation logic in SQL and PL/SQL Procedures for reconciling the electronic invoices for the daily load

Prepared Operational Guide for Restart and Recovery Procedure in case of Failure

Used Row generator stage for generating test data for the files

Trained and Managed six associates in DataStage

Conducted code walkthroughs and reviewed peer code and documentation

Worked with developers, DBAs and systems support personnel in elevating and automating successful move to production.

Environment: Red Hat Linux, IBM Information Server 8.0.1, Datastage, SQL Plus, PL/SQL

Project# 5 : McKinsey DC2 PB BI Support Jun 2007 – Oct 2007

Client : Mckinsey and Company, New York

Responsibilities:

Analyzed the Batch Jobs involved in loading of the Data Marts in the SAIL Data warehouse to implement restart and recovery solutions

Analyzed the loading dependencies between various data marts in the server jobs

Recovery of the load ensuring integrity and consistency of the Data warehouse

Understand Business logic and enhance jobs to load tables in SAIL Data warehouse

Understanding the functionality and supporting the Operational Reference Store

Understanding the complex coding related to PPN DataMart and reporting bugs

Provide inputs for feasibility of coding in Pl/SQL using PL/SQL Developer

Optimized complex SQL queries to improve the performance and reduce loading times

Preparing Impact Analysis documents for Enhancements.

Preparation of Unit Test cases document.

Environment: UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos

Project# 6 : SAIL MARS Jan 2007 – May 2007

Client : Mckinsey and Company, New York

Responsibilities:

Understand the loading and design of SAIL MARS Data Mart

Prepare design documents for Development

Development of Server jobs for loading the Data Mart

Preparation of Unit Test cases document.

Unit Testing of Datastage Jobs.

Integration Testing from the MARS Application

Environment: UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos

Project# 7 : Reverse Engineering of PPN & Engagement Data Marts

Client : Mckinsey and Company, New York Jun 2006 – Dec 2006

Responsibilities:

Understand the Business Logic and ETL Design for the PPN and Engagements Data Marts

Reverse Engineering the loading of SCD Type 2 Dimension called DPerson

Interacting with the Business Analysts and Customers in understanding the logic

Preparing technical documents on the logic

Understanding design of batch jobs involved in the loading and document the same

Received Client Appreciation Certificate for exceptional performance in the Project

Environment: UNIX AIX, Ascential DataStage 7.5, PL SQL Developer, Toad, Cognos.



Contact this candidate