Data Manager
Resume:
RAO JAGARLAMUDI
PH # 913-***-****
******@*****.***
SUMMARY
. Around 10+years of IT experience in the System Analysis, Design,
Development, Implementation Testing and Production support of
Database, Data warehousing, Client/ Server/Legacy applications for
various industries, using Data Modeling, Data Extraction, Data
Transformation, Data Loading and Data Analysis.
. Around 7 years of high-end programming experience using SQL, PL/SQL,
ANSI SQL, Transact SQL, SQL*Plus, SQL*Loader, Unix Shell
Programming/Scripting, Visual Basic 4.0/5.0/6.0, Developer 2000, C,
HTML 4.0, DHTML, XML, Windows 3.x/95/98/2000, Win NT 4.0, Sun
Solaris8,HP-UX and AIX 4.3.
. Around 5+years Experience in ETL & Business Intelligence using
WebSphere DataStage version 8.1 8.0.1, 7.5/7.0/6.0/5.2/5.1/4.2/TX
(DataStage Manager, DataStage Designer, DataStage Director, Parallel
Extender,Server edition,DataStage Administrator) and Informatica
PowerCenter 7.x.
. Expertise includes Data Modeling (Star & Snowflake schema), using
DSS/OLAP tools for Datawarehouse, Crystal Reports 8.0 / 8.5, Crystal
Info 7.5, Report net 1.1, Cognos 8 (Framework Manager, Event Studio,
Query Studio, Analysis Studio, Report Studio ),
Cognos Suite - Impromptu, Transformer, and Power Play, Impromptu Web
Reports.
. Relational Databases like Oracle 10g,9i/8i/8.0/7.x,, DB2 8, MS SQL
Server 2005.
TECHNICAL SKILLS:
ETL Tools : WebSphere DataStage version 8.1, 8.0.1/7.5.2,
WebSphere QualityStage,
WebSphere Information Analyzer,
MQSeries(WebSphere MQ).
BI : Cognos 6.x, 7.x, Cognos 8.3.
LANGUAGES : HTML4.0, ASP3.0, VBScript, JavaScript, VB,XML
Programming : SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus
3.3/8.0/9/10g, SQL*Loader,,Visual Basic 6.0/5.0,
ASP, Java, JSP, TOAD, C, C++, BASIC, Unix Shell
Scripting, Dbase III,
DATABASE : ORACLE 7.x/8i/ 9i/10g, Microsoft SQL 2005, DB2 and
MS-Access,
OLAP Servers : Oracle Express, MS-DTS
HARDWARE : HP-UX, SUN Solaris, IBM-AIX
OPERATING SYSTEMS : UNIX, Windows 95/NT/2000 and MS-DOS
ERP : EPM 8.9, SAP BW 3.5, 3.1C, 3.0B, 2.1C, SAP R/3 4.7,4.6C,
4.6B
OTHER SERVERS : IBM Information Server 8.
PROFESSIONAL EXPERIENCE:
Bank of America, NJ (Sr.Datastage Developer)
Feb2009-Present
. My current assignment with BOA - Involved in Migration project from
BOA to ML, EDW projects are getting the transactional data and events
data from BOA sources to ML.
. I was involved in Designing the Target Schema definition and
Extraction, Transformation (ETL) using Data stage both server and
parallel editions and worked with XML files and XSD's.
. Worked with objects in IBM Information Server Repository like jobs,
sequences, parameter sets, routines, shared containers and table
definitions.
. Extensively Used Datastage (ETL Tool), Oracle PL/SQL, UNIX, MS
Products to Extract, Cleanse, Transform and load data to target
systems with right format and level of detail.
. Used the Datastage Designer to develop the ETL processes for
extracting, cleansing, transforming and integrating the EDW data into
datamarts.
. Used Star Schema and Dimensional modeling for creating data mappings
between various JNJ data sources to the EDW Data marts.
Environment: SQL, PL/SQL, Ascential Datastage 8.1 (Parallel Extender and
server edition) (Designer, Director, Administrator), DB2,Oracle 10g, IBM-
AIX, Windows server 2003 sp2, COGNOS Impromptu 8 series / IWR,Test
Director, IBM Information Server
Johnson & Johnson, NJ (Sr.Datastage Developer)
Feb2009-Present
. My current assignment with Johnson & Johnson - Health Care Products &
Pharmaceuticals. I involved in 2 Data warehouse projects acuvue (JNJ)
and Jet(JNJ) These EDW projects are getting the transactional data
and events data from JNJ sources and create a data marts for different
reporting systems ( consumer, campaign management, survey process,
email responses, Corematrics).
. Used the Datastage Designer to develop the ETL processes for
extracting, cleansing, transforming and integrating the EDW data into
datamarts.
. Extensively used Merge, Aggregator, Remove Duplicates,CDC, Lkp
stages, join stage, Surrogate_Key_Generator,Sort,Funnel, etc..
. Extensively used Data stage Director for Job Scheduling, production
support for troubleshooting from LOG files Administrate the New and
current DataStage Projects and ETL Process.
. Migration of the existing DataStage Projects to subsequent releases of
the software from 7.5.2 to 8.01.Worked with Datastage Administrator in
creating new projects, Environment variables for the projects.
. Worked with Sequential jobs and Batch jobs and involved in control
process.and created the config files param files..
. Used Star Schema and Dimensional modeling for creating data mappings
between various JNJ data sources to the EDW Data marts.
Environment: SQL, PL/SQL, Ascential Datastage 8.1 (Parallel Extender and
server edition) (Designer, Director, Administrator), DB2,Oracle 10g, IBM-
AIX, Windows server 2003 sp2, COGNOS Impromptu 8 series / IWR,Test
Director, IBM Information Server
Dow Jones, NJ (Sr.Datastage Developer)
May2007-Jan2009
. Dow Jones is a leading provider of global business news and
information services. Its Consumer Media Group publishes The Wall
Street Journal, Barron's, MarketWatch and the Far Eastern Economic
Review. .EDW warehouse(OLF,ICS,MW) projects get the transactional
data from CMG and create the data marts for different reporting
systems.
. Designing the Target Schema definition and Extraction, Transformation
(ETL) using Data stage.
. Involved in gathering requirements from the End users. And Involved in
designing the functional specifications and technical specifications
for project.
. Worked with objects in IBM WebSphere Repository like jobs, parameter
sets, routines,shared containers and table definitions
. Designed Data Stage Best practices, Naming conventions to be followed
for the developers.
. Used the Datastage Designer to develop processes for extracting,
cleansing, transforming and integrating.
. Extensively used Merge, Aggregator, Remove Duplicates,CDC, Lkp
stages, join stage, Surrogate_Key_Generator,Sort,Funnel, etc.
. Extensively created PL/SQL procedures, functions and packages for
implementing complex business rules.
. Migration of the existing DataStage Projects to subsequent releases of
the software from 7.5.2 to 8.01.
. Extensively used Designer, Administrator and Director for creating
and implementing jobs.
. Worked with Datastage Administrator in creating new projects,
Environment variables for the projects.
. Worked with Sequential jobs and Batch jobs and involved in control
process.and created the config files param files.
Environment: SQL, PL/SQL, Ascential Datastage 8.0.1 (Parallel Extender)
(Designer, Director, Administrator), DB2,Oracle10g, IBM-AIX, Windows NT,
cognos Impromptu 8 series / IWR, IBM Information Server
ASURION, Nashville ( Sr.Datastage Developer)
June 2006-May2007
. Asurion, the leading provider of enhanced services to the wireless
telecommunication industry. Its a largest provider of wireless
roadside assistance services and wireless handset insurance
company.EDW warehouse project get the transactional data from mobile
company's and create the data marts for different reporting systems.
. Designing the Target Schema definition and Extraction, Transformation
(ETL) using Data stage.
. Involved in gathering requirements from the End users. And Involved in
designing the functional specifications and technical specifications
for project.
. Designed Data Stage Best practices, Naming conventions to be followed
for the developers.
. Used the Data Stage Director and its run-time engine to schedule
running the solution, testing and debugging its components, and
monitoring the resulting executable versions.
. Created Shared Container to simplify the Datastage design, and used it
as a common job component through out the project.
. Involved in performance tuning of the ETL process and performed the
Data warehouse testing
. Used the Datastage Designer to develop processes for extracting,
cleansing, transforming and integrating.
. Extensively used Datastage Manager, Designer, Administrator and
Director for creating and implementing jobs.
Environment : Ascential Datastage 7.5.2 (Parallel Extender) (Manager,
Designer, Director, Administrator), Oracle 9i, PL/SQL, SQL Server 2005.
cognos Impromptu 7 series / IWR, Power play Transformer and Windows XP,
Cognos Impromptu 7.3, Test Director, IBM-AIX, Windows NT
SKILLSOFT, Nashua
July 2005 -June 2006
EPM/DataStage Developer
. SkillSoft is a leading global provider of comprehensive e-learning
content and technology products for business and information
technology professionals within global enterprises. SkillSoft's multi-
modal learning solutions support and enhance the speed and
effectiveness of both formal and informal processes and integrate
SkillSoft's in-depth content resources, learning management system,
virtual classroom technology and support services.
. This is a PeopleSoft Enterprise Performance Maintenance (EPM)
warehousing project for Skillsoft and EPM has feed from Peoplesoft
Financial for Contract State and Forecast Actual Reports. In this
project EPM/ETL DataStage is used to extract the data from Peoplesoft
for all GEO and populate the EPM, which are used by end users for
obtaining the relevant data. Data is extracted from multiple data
feeds and transformed through the processes of Translation,
Formatting, and Staging and then loaded into the EPM tables (Sql
Server).
. Demonstrated ability to manage and meet assignment deadlines through
personal initiative on several simultaneously assigned tasks.
. Star Schema and Dimensional modeling was used in creating data
mappings between various Peoplesoft applications sources to the
Peoplesoft EPM data warehouse (SQL SERVER 2000).
. Incremental mappings were designed using CRC logic to extract data
from Peoplesoft Transaction system into OWS (EPM) and OWS dimensions
were TYP2ed.
. Created and tested ETL processes composed of multiple DataStage jobs
using DataStage Batch Jobs.
. Enhanced the existing Jobs for performance improvement which reduced
the process time.
. Used Shell Scripts to update data into staging area and data warehouse
from Source systems.
. Created Batch monitored reports using Crystal Reports and Crystal
Enterprise 9.0 for data warehouse batch load.
Environment: SQL, PL/SQL, Oracle9i, Ascential Data stage 7.5, EPM 8.9,
People Tools, App Designer, Data Mover, Sql Server 2000, Windows 2003,
Autosys.
TIME WARNER, Charlotte Oct 2003 - June
2005
DW Consultant
. Designed, developed, and deployed DataStage7.5 Jobs and associated
functionality of Time Warner EPM 8.9 implementation. The Warehouse
employed highly complex data transformations including Slowly Changing
Dimensions and a series of Stored Procedures, which made performance
tuning and efficient mapping highly critical. Along with designing
jobs from scratch, re-wrote existing code to enhance performance and
trouble-shoot errors in both DataStage & Oracle9i.
. Used Cognos to develop Financial Reporting System for developing
Financial Reports for its various branch locations across United
States.
. Responsibilities
. Used DataStage Manager for importing metadata from repository, new job
categories and creating new data elements
. Tuned DataStage jobs for better performance by creating DataStage Hash
files for staging the data and lookups. Used DataStage Director for
running and monitor the Jobs.
. Created shell scripts, which will invoke the DataStage jobs passing
all the variables for the job to execute like Source and Target
databases connection information, userid, password and others, file
locations.
. Developed processes for Extracting, cleansing, transforming,
integrating and loading data into Oracle database using DataStage
Designer.
. Worked with all DataStage components for Data conversion & loading
data into target.
. Created database procedures, functions using PL/SQL.
Environment : Oracle 8i/9i, PL/SQL, Data Stage 7.0/7.5, People Soft EPM
8.9, XML plug in's, version control,Sql Server 8.0, HP-UNIX and Windows
NT, Lotus Notes, Cognos 7x.
GE, Milwaukee (ETL Developer) Oct
2002 - Oct 2003
. The Monetization process is set up to accelerate the cash flow in
GEMS. GEMS sell all of its receivables, which are eligible through an
agreement. Each month GEMS has to provide a portfolio of new eligible
invoices to different banks for Monetization which needs to be
identified.
. Parsing high-level design spec to simple DataStage ETL coding and
mapping standards.
. Extensively used DataStage Manager, Designer, Administrator, and
Director for creating and implementing jobs.
. Used the DataStage Designer to develop processes for extracting,
cleansing, transforming, integrating, and loading data into data
warehouse database.
. Involved in writing the procedures for getting the data from all
systems to Data Warehousing system.
. Developed various jobs using ODBC, Hashed file, Aggregator, Sequential
file stages.
. Involved in writing the test plans based on Functional Requirement and
Business Requirement Documents.
. Performed GUI, Functional, Regression, Integration and System Testing.
. Tracked and Reported Defects Using TestDirector.
Environment: Data Stage 6.0/7.0 Oracle 8i,DB2, SQL, PL/SQL, SQL*Loader,
Stored, Unix Business Objects, Windows NT, IBM AIX 4.2, Test Director
GE (ERC), Kansas (ETL Developer) Feb
2001 - Oct 2002
. ODS is an extranet application that enables clients and underwriters
to retrieve, edit and account information. The present release adds
functionality to get quotes and write new business online.
. Involved in Installation & Configuration of Informatica Server and
Client Tools.
. Extracted data from sources like Oracle database, Flat Files and XML
files.
. Created Mappings using Mapping Designer to load the data from various
sources, using different transformations like Aggregator, Expression,
Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier,
and Update Strategy transformations.
. Created Mapping Parameters and Variables.
. Involved in Optimizing the Performance by eliminating Target, Source,
Mapping, and Session bottlenecks.
. Implemented various transformations like Expression, Lookup, Sequence
generator, and Source Qualifier, Rank, Aggregator etc. to load the
data from Staging area to DW.
. Created and scheduled Sessions.
. Tuned the mappings to perform better using different logics and
checking the Cache to provide maximum efficiency and Performance.
. Use of Reporter, Designer and Supervisor modules, Query Panel and Data
Provider; handling of ODBC issues
. Use of Filters and Conditions, Slice and Dice
Environment : Informatica Power Center 5.1, Power Mart 4.x, Oracle 9i,
ERwin 4.0, SQL, PL/SQL, SQL*Loader, Shell Scripting,, HP-UNIX, Windows
NT/2000
ADVANCEPCS, Dallas
June 2000 - Feb 2001
Pharmacy & Non-Pharmacy Sales and customer data Analysis.
. AdvancePcs is one of marketers of Pharmacy & Non-Pharmacy products.
Advance provides a robust online purchasing center for their clients,
. which compliments the company's extensive call-center oriented mail
order operations? To configure a three tier Data Warehouse with Oracle
8i as a back-end and Cognos Power Play as an OLAP Tool. Cognos is a
User-friendly querying and analysis tool. In this project, data was
extracted from legacy systems and was loaded into the warehouse tables
for query, analysis and reporting. The project was aimed at studying
sales variations for different promotional campaigns
. Involved in Business Process Study and Technical Requirements.
. Dimensional modeling using the STAR schemas (Facts and Dimensions).
. Coordinating the design of the data model (used ER-Win) for the
warehouse using the Star Schema methodology.
. Developed PL/SQL and UNIX Shell Scripts.
. Publish IWR, use Distribution Shuttle Builder & Impromptu Report
Administrator.
. Published the IWR reports on the web server.
Environment : Cognos Impromptu 6.0, PowerPlay 6.5, Informatica Power
Mart 4.7, IWR, Transformer 6.5, DB2, SQL Server, Oracle, Cognos Shuttle
Builder, Upfront, PL/SQL, MVS, Unix and Windows NT.
BEST BUY INC., Minneapolis Oct 1999 -
May 2000
Financial metrics
. Best Buy needed an integrated business intelligence system that would
provide both internal users and external partners and supply chain
members with visibility into its business performance.
. Using Cognos, Best Buy's Business and Vendor Performance Application
allows its users to view performance data, perform trending analysis
on sales, inventory, advertising, pricing and all forms of financial
metrics - like revenue and operating margin - via a single, simple Web
interface.
. Created Multi-Dimensional reports using Power Play.
. Provided various management levels with reports, time series graphs
and piecharts using PowerPlay cubes.
. Created Impromptu Web Reports (IWR/HTML) and published them in the
. Web server.
. Environment : Cognos Impromptu 5.0, PowerPlay, IWR, Transformer 6.5,
DB2, SQL Server, Oracle, Cognos Shuttle Builder, Upfront, Brio,
PL/SQL, MVS, Unix and Windows NT.
EDUCATION:
Bachelor's Degree in Engineering
Post Graduate Diploma in Computer Information Systems (Frontier
Institute of Information Technology)
Diploma Course in Software Training (All India Management Education
Institute, India)
Contact this candidate