Data Project
Resume:
S.D.SivaKumarReddy Mobile: +91-738*******.
Email: ****************@*****.***
Overall 4+ years of Experience in Data Warehousing in the role of ETL developer.
Detailed understanding of Data warehouse concepts and Data warehousing Architecture.
Extensive Experience in Extraction, Transformation and Loading (ETL) of data from different
heterogeneous source systems like flat files, CSV, Excel files, SQL server and Oracle.
Good experience in implementation of SCD and CDC
Good experience in conversion of technical specification from functional specification as per development
standards
Proficiency in understanding of business processes involved in development of Projects.
Extensively worked on SAP BODS 3.2 and SAP BODS 4.0
Experienced in Data Migration/Conversion methodologies, specifically around (Legacy System, RDBMS,
and Third Party source) to 1-SAP system using SAP Business Object Data Services as an ETL tool.
Implemented performance tuning techniques at various levels (Batch job, Data flow, Source and target
systems, Push down operations, etc.,)
Experience in integration of various data sources like Oracle, SQL Server, Flat files.
Experience in Creating Batch Job, Data Flow and Validating, Tracing and Debugging Batch Jobs using
Data Services.
Experienced in monitoring, executing, manage repositories and perform metadata reporting and
scheduling of the jobs by using DS Management Console.
Experience in various transformations in BODS, scripts, custom functions.
Excellent analytical, problem-solving, communication and interpersonal skills.
Prepared Unit Test Cases.
Good knowledge in creating Data Stores considering SAP BW as Source and Target system.
Experienced in SAP BODS Job monitoring, troubleshooting failures and performance issues.
Experienced in Using Business Objects Data Services in development of data marts according.
Good understanding of source to target jobs and Business rules associated with the ETL processes. And
performing the data cleansing and transformation of a source field data.
Self-Managed, Result-oriented, producing quality works on time.
Ability to be a team player with excellent interpersonal skills.
Analytical skills include identifying, forecasting and resolving problem.
2 Education Qualifications
B.Tech from Sri KottamTulasiReddycollege of Engineering, JNTUH in 2010.
3 Experience Summary
1. worked as Software Engneir in PROG9 SOFT TECH PVT. LTD from Oct-2010 to Dec-2012.
2. Worked as SAP BODS consultant in Capgemini from DEC-2012 to MAY 2014.
3. Working BODS Senior Consultant in KPIT June-2014 to till date.
Work Experience
Project Name Arbonne/BI Reports /Migration
Client ARBONNE
Role ETL Developer
Duration June 2014 to TillDate
Roles performed Mainly involved in ETL Development.
CRON jobs(UNIX shell Scripts) conversion and OEM packages
into DS jobs
Extracting the data from flat files (Delimited and fixed width
format)
Used different types of variables to get the data from different
files dynamically.
Prepared mapping documents capturing all the rules from the
business.
Created, Tested and executed data Services jobs using designer to
transfer data from source to target.
Gathering requirements from the client.
Worked on Master Data and transactional data.
Used various functions in their batch jobs such as look up, sql,
sub-string, ltrim, rtrim, lpad, rpad, and search replace, ifthenelse,
lookup etc.
Extract the data from Oracle using BODS and Load the data in to
Staging Database SQL Server.
Migrate the repository using repository manager from SAP
BODS3.1 to SAP BODS 4.2 repository.
Using designer to create source definitions, design targets, create
jobs and develop transformations.
Validation, Tracing and debugging Batch job; Capturing changes
in data (Initial/Delta load) using Table Comparison, History
Preserving, Key Generation Transforms.
Applied Performance tuning techniques in ETL flows.
Validation, Tracing and debugging Batch job, built in
Transformation, Built in
Functions, Data services Scripting language and variables.
Technology used in Operating System Windows 8
project DWH BI SAP BODS 4.2
Database Oracle 9i/SQL Server 2012
Description
The client is a leading player in the Cosmetics industry, with a dominating
presence.
Involved in designing Supply Chain Management System at Arbonne
New jersey in existing Data warehouse, for all types of users using
Business objects as front end
Including Supply Chain and Transportation Analysts. The business-
intelligence solution we designed for the client enabled them to do
enhanced analysis of, Revenue by brand, geography, business unit.
Project Name Unilever_connect(IPA)
Client Unilever is a British-Dutch multinational consumer goods company.
Its products include foods, beverages, cleaning agents and personal
care products. It is the world’s largest consumer goods company
measured by 2011 revenues (after Proctar & Gamble and Nestle) and
world’s largest maker of ice cream.
Role ETL Developer
Duration Dec-2013 to MAY- 2014
Roles performed Mainly involved in ETL Development.
Analyzed the sources, targets, transformed the data, and
mapped the data and loading the data into Targets using
BODS.
Worked on Master Data and transactional data.
For master data objects applied Logical delete aged records.
Worked on Frameworks re-startability and recoverability.
Building of the BODS Jobs, Workflows, Data Flows as per
the Mapping Specification.
Designed various mappings for extracting data from SAP
ECC sources.
Using designer to create source definitions, design targets,
create jobs and develop transformations.
Used Push-Down, Bulk Loader in BODS to transform the
data from CSV File to Staging area and Staging to EDW
tables.
Technology used in Operating System Windows 7
project DWH BI SAP BODS 4.0
Database Teradata
Description Indirect Procurement Analytics
The aim is to provide a single global system for collection, analysis
and reporting, of all of Unilever’s Indirect expenditure (approx
€15B/Year)
Indirect Procurement Analytics reports reliable buying data in fast and
flexible manner presented in an intuitive and user friendly way.
It allows the IP organization to understand buying patterns and
process performance and in this way drive savings and process
improvements
Project Name Glenmark MDA
Client Glenmark
Role ETL Developer
Duration JAN-2013 to Dec-2013
Roles performed Mainly involved in ETL Development.
Analyzed the sources, targets, transformed the data, and mapped
the data and loading the data into Targets using BODS.
Worked on Master Data and transactional data.
Building of the BODS Jobs, Workflows, Data Flows as per the
Mapping Specification.
Designed various mappings for extracting data from SAP ECC
sources.
Using designer to create source definitions, design targets, create
jobs and develop transformations.
Created different transformations for loading the data into SQL
SERVER database e.g. Query, Case, Match, Validation, Merge,
SQL, Pivot, Reverse pivot transformations.
Involved in Unit Testing.
Resolving if any issues in transformations and mappings with
help of Technical Specifications.
Technology used in Operating System Windows 7
project DWH BI SAP BODS 4.0
Database SQL SERVER 2008
Description Glenmark Pharmaceuticals is a pharmaceutical company headquartered in
Mumbai, India. It manufactures and markets generic formulation products
and active pharmaceutical ingredients (API), both in the domestic and
international markets.
Glenmark reorganized its business into two separate, clearly
directed entities - Glenmark Pharmaceuticals Ltd (GPL) and Glenmark
Generics Ltd (GGL).As a part of the project, data is extracted from this
two sources (SAP system) using BODS.
Project Name Sales Information System
Client The Eagle Company, Boston
Role ETL Developer
Duration July-2012 to DEC-2012
Roles performed Mainly involved in ETL Development.
Analyzed the sources, targets, transformed the data, and mapped
the data and loading the data into Targets using BODS.
Developed various Jobs, Workflows, Data Flows and
Transformations for migration of data using BODS Designer.
Designed various mappings for extracting data from various
sources involving flat files and relational tables.
Using designer to create source definitions, design targets, create
jobs and develop transformations.
Created different transformations for loading the data into oracle
database e.g. Merge, SQL, Query, Table Comparison, Map
Operation and History Preserving transformations.
Created Scripts using BODS Designer.
Involved in Unit Testing and prepared Test Case.
Resolving if any issues in transformations and mappings with
help of Technical Specifications.
Technology used in Operating System Windows XP
project DWH BI SAP BODS 4.0
Database Oracle
Description This project is designed to know the sales of the Products manufactured
by the Company. The reports were analyzed on Product, sales in different
time periods at various Promotional Conditions which facilitates eagle to
have an integrated view of the amount and the type of business with its
trade customers worldwide identifying its partners that do significant
business and analyzing the profitability on the basis of customer, product,
region, etc.
Project Name Ford EDWH
Client Ford, USA
Role ETL Developer
Duration Dec-2010 to June-2011
Roles performed Mainly involved in ETL Development.
Analyzed the sources, Targets, Transformed the data and Mapped the
data and loading the data into Targets using Data Services.
Experience in Development the Jobs using needed Transformations
in Data Services Tool according to technical specifications.
Developed various Mappings with the collection of all Sources,
Targets and Transformations using Designer.
Created complex mappings using Look up Functions, Query
Transformations and Scripts.
Testing and executing of Batch Jobs.
Creation of Jobs, Workflows, Data flows and Scripts.
Involved in Optimizing and performance tuning logic on targets,
sources, Data Flows, and Workflows to increase the efficiency of
Jobs.
Involved in Unit testing.
Technology used in project Operating System Windows 2003
DWH Technologies SAP BODS 3.2.
RDBMS Oracle 10g
Description The Ford Motor Company is an American multinational corporation based in
Dearborn, Michigan, a suburb of Detroit. Ford introduced methods for large-
scale manufacturing of cars and large-scale management of an industrial
workforce using elaborately engineered manufacturing sequences typified by
moving assembly lines. Ford is currently the second largest automaker in the
U.S. and the fourth-largest in the world based on number of vehicles sold
annually. It has been manufacturing different types of vehicles like cars,
Crossovers and trucks. They are mainly concentration on customer’s
satisfaction.
Contact this candidate