Project Sap
Resume:
Varun Agarwal
E-*** Windwards Society
Kaspate Vasti Pune
(M.H.)
*****.***********@*****.***
Professional Summary:
. 2 Years 7 Months of Experience in IT Industry Well versed and
certified in SAP BODS XI R2, SQL, ETL and Data Migration.
. Worked extensively with Data migration, Data profiling and ETL
Processes.
. Familiar with SAP BI-BW, SAP EMIGALL & SAP LSMW.
. Having experience in Utility & Manufacturing domain.
. Experience in managing all stages of data migration from data analysis
to pre go-live validations, user acceptance testing, user sign-off,
Cut-Over plans, migrating to Dev/QA/ Prod landscapes, and post go-live
validations.
. Having experience in end to end project implementation.
. Having excellent communication skills, proactive, process oriented, take
ownership of initiatives.
Employment Summary:
Organization Designation Duration
WIPRO TECHNOLOGIES ASSOCIATE CONSULTANT MARCH 2012-TILL DATE
ONMOBILE GLOBAL LIMITED PRODUCT QUALITY ENGINEER NOV 2011-MARCH 2012
Skills and Certifications:
PRIMARY SKILL ETL,DATA MIGRATION,SQL
OPERATING SYSTEM WINDOWS
DBMS ORACLE
TOOLS SAP BODS XI 4.0, SAP BW, SAP LSMW,
SAP EMIGALL, PL/SQL DEVEPLOPER,
SQL*PLUS
Education:
Degree College\School-Year University Marks\C.G.P.A
Graduation B.TECH(CS) - 2011 Uttar Pradesh 71.74%
from Pranveer Singh Technical University
Institute Of - UPTU
Technology
12th St. Joseph's Sr. CBSE BOARD 65.20%
Sec. School
10th St. Joseph's Sr. CBSE BOARD 69.40%
Sec. School
Project Details:
Project Name: TS_QUATNTUM_DEV
Client Transfield Services
Role Team Lead, Associate Consultant - SAP BODS
Duration February/2014-Till Date
Team Size Project : 10 Module : 5
Environment Languages : SQL
(with skill
versions)
Software's : SAP BODS XI 4.0, SAP LSMW, SAP PL/SQL
DEVELOPER
Database : Oracle
Project Description: Transfield Services is a Service company which
operates in Australia, United States and New Zealand. It is a Data
Migration Project where the aim is to standardise the business process and
to have a single integrated system instead of having multiple systems
across the globe.
Contribution:
. Distributing objects among the team members and guiding them if and
when required in the development and testing phases.
. Design, Development and Analysis of ETL Mappings using SAP BODS and
doing Code Reviews.
. Preparing Technical specifications & Unit Test Cases and maintaining
proper version control of the documents throughout the project life
cycle.
. Estimating ETL requirements, designing and architecting integration
solutions. Understanding the change data capture, Data Profiling and
Data Reconciliation concepts.
Project Name: UIL Phase 3
Client United Illuminating
Role ETL Developer
Duration September/2012- January/2014
Team Size Project : 15 Module : 4
Environment Languages : SQL
(with skill
versions)
Software's : SAP BODS XI 4.0, SAP BW, SAP LSMW, SAP
EMIGALL, PL/SQL DEVELOPER
Database : Oracle
Project Description: United Illuminating provides for the transmission and
delivery of electricity and other energy related Services for Connecticut,
Greater New Haven and Bridgeport areas. Client has taken an initiative for
bringing various technologies together into the SAP platform.
Contribution:
. Design, Development & Performance Optimization of ETL mappings using
SAP BODS.
. Perform Error Handling, Scheduling, Identifying ETL Job Dependency and
Recovery mechanisms.
. Estimating ETL requirements, designing and architecting integration
solutions. Understanding the change data capture, Data Profiling and
Data Reconciliation concepts.
. End to End migration of HR module with extensive knowledge of
Technical as well as Functional aspects.
Project Name: Airtel
Client BHARTI AIRTEL LIMITED
Role Product Quality Engineer
Organization ONMOBILE GLOBAL LIMITED
Duration November/2012 - March/2013
Team Size Project : 25
Environment Languages : SQL
(with skill
versions)
Software's : SQL*PLUS
Database : Oracle
Project Description:
It is a leading global telecommunications company with operations in 20
countries
across Asia and Africa. Central to this project is the Development &
Testing of
Mobile Applications and Caller tones Grammar and maintenance of Client's
Databases
including Billing, Offers, Installations, Validity etc.
Contribution:
. Resolving data issues and dependencies between the tables.
. Creating and maintaining Staging Area used for Billing and
Installation records in Oracle 11g.
. Query preparation to fetch the required data from the database.
. Basic query optimization for faster data fetching.
Personal Details:
Name : Varun Agarwal
Father's Name : J M Agarwal
Gender : Male
Marital Status : Single
Date of Birth : 02/11/1988
Languages Known : English/Hindi
Declaration:
I hereby declare that the information given above is true to the best of my
knowledge. I will make it my
Earnest endeavour to discharge competently and carefully the duties you may
be pleased to entrust me.
PLACE: PUNE VARUN AGARWAL
Contact this candidate