Profile

 A total 8+ years of professional experience in IT Development, extensively
in Data Conversions, ETL design and development, and Business Intelligence with
Fortune 100 companies.
 Expertise on various tools and technologies like DataStage
8.0.1/7.5/7.1/5.2, Quality Stage 7.5/7.1, AB-Initio 2.15, Cognos 7.0, Oracle
10g/9i/8.x, DB2-UDB, Teradata, SQL Server 2005 and UNIX.
 Experienced in architecture design and performance tuning of ETL
applications.
 Expertise in integrating the ETL processes with external systems like SAP,
Oracle Apps, PeopleSoft, and Web services.
 Expertise in designing the User Interfaces between ETL process and external
applications.
 Expertise in design and optimization of DataStage parallel jobs and server
jobs.
 Expertise on building DataStage process for Real Time Integration (RTI) with
web services.
 Expertise in developing the DS Process using Webservices for capturing the
Online Updates.
 Expertise in using advanced DataStage plug-in’s like BAPI, ABAP Extract,
Web services, XML Read, XML Write, MQ Series.
 Expertise in handling the XML messages with external applications using
DataStage.
 Experienced on latest version of DataStage that is IBM Information server,
Information Analyzer, Websphere Qualitystage, and Websphere DataStage and on
Metadata services.
 Expertise in Standardization, Investigate, Match and Survive the data using
QualityStage jobs.
 Expertise in developing the DS Batches for handling multiple iterations in a
single run.
 Good knowledge in upgrading the DataStage jobs from lower version to higher
version of DataStage.
 Expertise on DataStage Administration, Setups, Migration and upgrades.
 Experienced in interacting with heterogeneous source systems like DB2,
Mainframe sources (Cobol Copy books & IMS), Teradata, Sybase, PeopleSoft, Oracle
databases, XML, datasets and Flat files.
 Experience in performance tuning and optimization of SQL queries - Oracle.
 Expertise in writing the Stored Procedures and PL/SQL blocks.
 Expertise in writing Unix Shell Scripts for automating the ETL process.
 Experience in Scheduling the jobs, Creating Batches and Autosys
environment.
 Good knowledge on Java programming, JSP applets and its interface screens.
 Good Knowledge on SAP Objects, ABAP, Automation Structures, ISMW Tool of
SAP.
 Good Knowledge on SAP FSCD basics and navigation of screens.
 Knowledge on Reporting tools like Cognos and Business Objects.
 Expertises in preparing the project documentation like technical specs,
mapping docs and test cases etc.
 Good Knowledge on Finance, Manufacturing and Insurance domains
 Excellent Inter-personal & Communication skills.
EDUCATION 

B.Tech from Jawaharlal Nehru Technological University.



TRAINING

 Data stage 7.1 at Ascential Software Pvt. (India) Limited.
 IBM Certified course in Quality Stage Concepts and Fundamentals.
 IBM Certified course in Datastage Parallel Extender concepts.
 IBM Certified course in Data Quality Concepts and Tips for improving the
quality of data used in organizations.
 Certificate course in Data warehousing project and systems development and
Business Intelligence SDLC.
 Five days training on AB-Initio GDE 1.10 and its Backend Co-Op System 2.15
 Three days training on SAP FSCD basics and navigation of screens.
 Five days training on SAP ABAP programming.
 Oracle Fundamentals and Advanced Programming.
 Completed training on Integrated Process Management System (IPMS) –
TCS’s proprietary tool for Project Management & Quality


AWARDS

Received Gold Medal for achieving First Rank in B.Tech from Governor of Andhra
Pradesh, India.




TECHNICAL SKILLS ACQUIRED

ETL Tools: Ascential DataStage 8.0.1/7.5/7.1/5.2, AB-Initio GDE -1.17/Co-Op
2.14
 Qualitystage 7.5, ProfileStage, Monarch 8.02
Reporting Tools: Cognos (Power play and Impromptu 7.0).
Databases: UDB DB2 8.0, Oracle 9i/8i, SQL Server 2005, MS Access
Utilities: Erwin 4.1, Toad, Rapid SQL, SQL Navigator, Putty, SSH,
Languages: C, SQL, PL-SQL, UNIX Shell Scripting, ABAP
Methodologies: Erwin Data Modeling, Kimball Lifecycle, Star Schema and other
data warehouse concepts, Toad Data modeler.
Operating systems: Windows 95/98/NT 4.0/2000/XP, Unix (IBM - AIX, Sun –
Solaris) FC Linux 2.2, SUSE Linux
Shells: Korn, Bash
ERP Packages: SAP FSCD (Basics & Navigation), Oracle Apps 11.5.10 (Order and
Invoice Management).
Process Tools Autosys, Change Management, Database Change requests, Mercury Test
Director, PVCS Dimensions/Serena, Datastage Version Control System, and Abinitio
Enterprise Meta Environment.
Business Systems: Finance, Manufacturing and Insurance


PROFESSIONAL EXPERIENCE

Masco Contractor Services, Daytona Beach, FL Dec ’08 to Till Date
V2R – Vision to Reality – Conversions
Sr. DataStage Developer

MCS is a group of independent companies, which are subsidiaries of Masco
Corporation, is one of the world’s leading manufacturers of home improvement
and building products and a leading provider of services that include
installation of insulation and other building products. It has more than 200
divisions and 52 distribution sites in the United States. As a part of Vision to
reality project, Masco is in process of developing an centralized system for
handling the Order Management, Billing System in Oracle Applications.

Responsibilities:

 Analyze the source systems data and the current reports at the client side
(Division level) to gather the requirements for the Data Warehouse Data Model
 Studied the relationship of data from business perspective in the source
systems
 Supervise the installation of DataStage v8 Software and established all the
setups including db connections, plug-in, configuration file setup, directory
setups.
 Designed and build a process to migrate the data from the divisions to
centralized application.
 Developed some complex jobs to migrate the data from different applications
to Oracle apps
 Developed Quality stage jobs to clean the Customers Master data using
Standardize Stage, Investigate Stage, Match Stage and Survive Stage.
 Developed Complex DataStage Routines, DS Sequences, and Batches for
integrating all DS jobs.
 Involved in mapping the flat file structure to Oracle Applications table
structure for Invoices, Customers, and Requisitions (Using External Table,
staging, Clean and Pre-Load stages before loading them into Oracle Apps).
 Developed triggers, Stored procedures, Oracle alerts for Invoice, Vendor,
Purchase related Reports (AP/PO) using SQL, PL/SQL.
 Developed an Interface to execute a DS Job from front end using Concurrent
Program in Oracle Apps.
 Used Parallel Extender for parallel processing of data extraction and
transformation.
 Actively played a vital role in upgrading the jobs from 7.5 to 8.0.1
version.
 Developed Job templates, Shared components, DS functions and DS routines in
order to reduce the level of effort for future development and ongoing support.
 Assisted in logical, physical data modeling and conceptual data modeling
 Developed Unix Shell Scripts to run DS Jobs as part of automation in
Conversion process.
 Developed Shell Scripts to send status/alert emails, login status and DB
performance status etc to the end users.
 Developed Unix Shell Scripts to automate the process and for creating
Process, Error Warn Reports and for mailing those reports to the support groups
etc.,



Environment: IBM Information server 8.0.1, Ascential DataStage 7.5 EE, Ascential
Quality Stage 7.5, SUSE – Linux 2.6. SMP, Oracle Apps 11.5.10, Oracle Database
10g, Monarch 8.2.




Tata Consultancy Services, Jersey City, NJ May’ 07 to Nov’08
American Insurance Group – AR Data Migration – Interface Source Layer
ETL/DataStage Developer

Domestic Brokerage Group (DBG), a division of American International Group (AIG)
is seeking to replace its existing Account Receivable (A/R) and billing systems
with SAP (C/D Module) based solutions and hence it is imperative that legacy data
to be migrated and divert the input feeds of ARTS to SAP daily. The source data
exists in multiple environments such as IMS database, VSAM files, Sybase (People
soft) and DB2. Interface Source Layer (ISL) process and diverts incoming data to
ARTS application to SAP.


Responsibilities:

 Developed the DS individual Process to extract the data from DBS, DMSS, REFT
Tables, PLS, MGA and to process it for SAP Systems
 Used Advance Plug-in’s like BAPI, ABAP Extract, Web Services, XML Reader
and XML Writer.
 Developed SAP ABAP programs and executed them using DataStage to extract and
insert the data into Interface tables.
 Designed and developed User Interfaces using DataStage jobs, XML, JSP and
Unix Shell scripts.
 Developed Complex DataStage Routines, DS Sequences, and Batches for
integrating all DS jobs.
 Developed a asynchronous running DS jobs using XML and Webservices to
capture the online updates.
 Developed an iterative process using DataStage Jobs, Batches and Routine to
create only one SAP User and role in each run.
 Used Ascential DataStage Manager to import Metadata Table Definition.
Developed jobs in Parallel Extender using different stages like Transformer,
Join, Aggregator, Lookup, Source dataset, External Filter, Row Generator, Column
Generator, FTP, Sorting, Expand, Funnel, Remove Duplicates, and Merge.
 Configured multiples configuration files to match the jobs characteristics
and to optimize the overall throughput of the ETL process. 
 Developed jobs for Real Time Integration of web services in Customer
Matching Process.
 Developed the DataStage jobs to extract the Data from heterogeneous
applications like PeopleSoft (Sybase), DB2, VSAM files and IMS.
 Used Parallel Extender for parallel proce