Nagaraju
( : +91-886*******
(: *********@*****.***
Summary of Experience:
> Having 3+ years of Professional IT Experience in Business Objects Data
Integrator / Data Services.
> Experience in Data Warehouse development working with Extraction,
Transformation and Loading.
> SAP BODS with OLTP, Flat files, Excel Workbooks, SAP Sources and
Databases.
> Experience in Using Business Objects Data Integrator in development of
data marts according to the Business Requirements
> Configuration of Central Repository for Multi User Environment
> Hands on Migration of Databases & Repositories..
> Working on Flat files and Excel Workbooks.
> Knowledge on Data Quality Transforms Like Base Match Transform.
> Knowledge on Legacy System Migration Workbench (LSMW).
> Prepared Technical Specification From Functional Specification.
> Extensive Knowledge of Data Warehousing Concepts.
Educational Qualification:
Master of Computer Application from Nagarjuna University in
2009
Technical Skills:
SAP Module : SAP BODS 3.2, 4.0
Operating Systems : Windows XP/ 2007
Languages : SQL.
Database : Oracle 9i/10g, SQL Server 2005
ERP : SAP ECC 6.0
Experience Summary:
. Working as ETL Developer in MINDTREE, Bangalore from Jan 2012
to Till Date.
. Worked as Developer in Tech Mahindra, Bangalore from Dec
2009 to Dec 2011.
Professional and Project Experience:
Project - 1
Project : Health Care Market
Client : American Healthcare Corporation
Role : ETL Developer
Duration : Jan 2012 - Till Date
Project Summary:
American health care Corporation, the leading provider of real time
surveillance health care information and market research to its global
pharmaceutical and healthcare companies. It provides syndicate research
intelligence data which tracks and predict illness and product sales for
pharmaceutical and health care companies
Responsibilities:
> Understanding existing business model and customer requirements
> Have done Functional specification review for sign off.
> Have done Peer Reviews for technical specification.
> Have done Development Peer Reviews of other objects.
> Worked with various tables like IIM,AVM,IWM,AVT,ZRT,ZRC and HPO
> Developed Projects, Workflows, Dataflow, Data stores, Tables, Template
tables, Flat files and Excel workbooks.
> Involved in the designing and implementation of the mappings for stage
to data warehouse data loading.
> Extensively involved in Data Extraction, Transform and Loading (ETL
Process) from Source to target systems using BODS 4.0.
> Created jobs to load data from source into Target using Flat File
format, Query Transform, Case Transformation, Lookup function, and
Merge, Validation and Table Comparison Transformation.
> Involved in Unit testing of Jobs.
> Delivered objects on time as per the delivery date.
> Given Knowledge transfer to testers for testing.
> Used the Web Administrator to schedule the jobs and monitoring the
resulting
Executable versions
Environment: SAP BODS 4.0, Oracle 10g, Windows 2007
Project - 2
Project : financial service
Client : Zurich Switzerland
Role : ETL Developer
Duration : Dec 2009 - Dec 2011
Project Summary:
Zurich is a leading provider of long-term savings products with a range of
innovative solutions for pensions, investments and protection.
Zurich is active in some 20 countries on four continents. Europe is the
base, and the largest markets are Switzerland, UK and Germany. Zurich is
also active in selected growth markets in Asia and Latin America.
Zurich offer services that meet their customer's needs for savings
solutions and financial security in various phases of life. By
concentrating on core competencies - fund selection, concept development,
and market support & service
Responsibilities:
> Understanding existing business model and customer requirements
> Mapping Data Items from Source system to the Target system.
> Involved in the designing and implementation of the mappings for stage
to data warehouse data loading.
> Extensively involved in Data Extraction, Transform and Loading (ETL
Process) from Source to target systems using BODS.
> Created jobs to load data from source into Target using Flat File
format, Query Transform, Case Transformation, Lookup function, and
Merge, Validation and Table Comparison Transformation.
> Used the Web Administrator to schedule the jobs and monitoring the
resulting
Executable versions
Environment: SAP BODS 3.2, Oracle 9i, Windows XP
(RAJAN)