DataStage Senior Consultant,Oracle,SQL,Unix,Quality Stage
Resume:
PRASANNA PILLI
********.*****@*****.***
Employer :
Durga
Sr.Manager-Business Development
*******@**********.***
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