Sql Server Sales

Vikesh Juneja

A-***, Lorelle Apartments,

Near Dutta Mandir, Wakad, Pune - 411057

E-mail: acefdl@r.postjobfree.com

Mobile: +91-987*******/ +91-779*******

CAREER OBJECTIVE

To be a qualified SAP Consultant/Business Analyst sand work in a

challenging environment using my technical, analytical and management

skills for the growth of organization and improve and build upon my

knowledge and expertise for personal and professional growth.

PROFESSIONAL SUMMARY

Date of Birth / Gender: 09 Oct 1988 / Male

> Around 3 years of experience in Data Warehousing, Data Migration and

ETL tool SAP BODS 4.0

> Currently working as a System Engineer in Infosys Limited.

> Expertise in developing and maintaining data warehouse applications

in ETL process using SAP BODS tools and having sound perception of

latest technologies in BODS.

> Well versed with phases of project life cycle viz. Coding and

Development, Testing and Documenting in ETL tool.

> Good experience in understanding the Business Process and mapping as

per client requirements.

> Expertise in working on RDBMS like SQL Server.

> Having complete domain and development life cycle knowledge of Data

warehousing.

> Having strong desire and willingness to learn new functionality and

technical skills and demonstrated ability to pro-actively accomplish

this through self-study and as formal training.

SKILL SET

RDBMS : SQL Server 2008

Tools : SAP BODS 4.0

Operating System : Windows

Language : SQL, PL/SQL

Domain Experience : Life Sciences, Finance & Insurance

EDUCATION

> Bachelor of Technology(ECE) from Maharaja Surajmal Institute of

Technology, New Delhi (affl Guru Gobind Singh Indraprastha University)

with CPI of 66.64 in 2011.

> H.S.C. from Sh.N.M.C.S.Se. School, Hanumangarh(Raj) with 81.08% in

2006.

> S.S.C. from Sh.N.M.C.S.Se. School, Hanumangarh(Raj) with 77.83% in

2004.

PROFESSIONAL EXPERIENCE

Infosys Limited, Pune

August 2011-Till Date

System Engineer

Project Name: Novartis AH SRS implementation

Client Novartis Animal Health

Role SAP BODS Consultant and Developer

Environment SAP Business Objects Data Services(BODI/BODS) 4.0, SQL

Server-2008, Force.com IDE, Windows

Duration Sep 2013 to till date

Description: Novatris Animal Health is one of the major pharmaceutical

companies in the world.

The main objective of SRS implementation is to provide Novartis a

datawarehouse for Europe region that can be used to create various sales

related reports.

The project involves migration of data held in the Client's legacy systems

to SAP platform. The project involves data Extraction, Analysis of data,

Transformation as per business rules and generating various Sales Reports

required by business. The data is pulled from various Legacy Systems (like

Veeva system and Flatfiles), which is loaded to staging database and then

it is loaded to SAP BW for reporting.

Responsibilities:

> Interacts with client to elicit architectural and non-functional

requirements.

> Responsibilities included understanding the OLTP data and their

requirements, designing the jobs for ETL process using BODS designer

and SQL Server.

> Test the code in Development and Quality environment, documenting

changes, issues.

> Debugging any issues occurred, changing mappings when requirement is

changed.

> Prepared KT document and provide session to the production support

team.

Project Name: Novartis AH iNSIGHT

implementation

Client Novartis Animal Health

Role SAP BODS Consultant and Developer

Environment SAP Business Objects Data Services(BODI/BODS) 4.0, SQL

Server-2008, Force.com IDE, Windows

Duration Oct 2012 - Aug 2013

Description: Novatris Animal Health is one of the major pharmaceutical

companies in the world. The main objective of iNSIGHT implementation is to

provide Novartis a datawarehouse for North America region that can be used

to create various sales related reports.

The project involves migration of data held in the Client's legacy systems

to SAP platform. The project involves data Extraction, Analysis of data,

Transformation as per business rules and generating various Sales Reports

required by business. The data is pulled from various Legacy Systems (like

Veeva system and Flatfiles), which is loaded to staging database and then

it is loaded to SAP BW for reporting.

Responsibilities:

> Interacts with client to elicit architectural and non-functional

requirements.

> Responsibilities included understanding the OLTP data and their

requirements, designing the jobs for ETL process using BODS designer

and SQL Server.

> Test the code in Development and Quality environment, documenting

changes, issues.

> Debugging any issues occurred, changing mappings when requirement is

changed.

> Prepared KT document and provide session to the production support

team.

Project Name: Novartis Pharma

Client Novartis Pharma

Role SAP BODS Consultant and Developer

Environment SAP Business Objects Data Services(BODI/BODS) 4.0, SQL

Server-2008, Force.com IDE, Windows

Duration Feb 2012 - Sep 2012

Description: Novatris Pharmaceuticals is one of the major pharmaceutical

companies in the world. The main objective of this project is to provide

Novartis a datawarehouse for North America region that can be used to

create various sales related reports.

The project involves migration of data held in the Client's legacy systems

to SAP platform. The project involves data Extraction, Analysis of data,

Transformation as per business rules and generating various Sales Reports

required by business. The data is pulled from Veeva legacy systems, which

is loaded to SAP BW for reporting.

Responsibilities:

> Interacts with client to elicit architectural and non-functional

requirements.

> Responsibilities included understanding the OLTP data and their

requirements, designing the jobs for ETL process using BODS designer

and SQL Server.

> Test the code in Development and Quality environment, documenting

changes, issues.

> Debugging any issues occurred, changing mappings when requirement is

changed.

Project Name: P&G Data Load

Client P&G

Role SAP BODS Developer

Environment SAP Business Objects Data Services(BODI/BODS) 4.0, SQL

Server-2008, Force.com IDE, Windows

Duration Aug 2011 - Jan 2012

Description: P&G is one of the major health care companies in the world.

The main objective of this project is to load the historical data of

previous 2 years in orders flow so that data is available in all the

reports created in Phase 2.

The project involves migration of data held in the Client's legacy systems

to SAP platform. The data is pulled from Veeva System and then it is loaded

to SAP BW for reporting after applying business rules.

Responsibilities:

> Interacts with client to elicit architectural and non-functional

requirements.

> Responsibilities included understanding the OLTP data and their

requirements, designing the jobs for ETL process using BODS designer

and SQL Server.

> Test the code in Development environment, documenting changes, issues.

> Debugging any issues occurred, changing mappings when requirement is

changed.

OTHER ACHIEVEMENTS

> Won 2nd prize in event B-Plan held at Netaji Subhash

institute of Technology (under DCE currently known as DTU)

in 2009.

Contact this candidate