SANGEET ARORA

Phone: +91-880*******

Email: acvc3w@r.postjobfree.com

Professional Summary

IT professional with 3.8 years of experience in Business Reporting and database.

Enormous experience in Reporting with SAP Business Objects XI and 4.0.

Worked on data quality projects.

Created Webi reports with proper understanding of business user requirements.

Migration of reports and universe from R2 to R4.

Created and modified universes in universe designer.

Created few dashboards for Pre Sales team as a part of demo to be shown to various clients.

Good knowledge of PL/SQL in constructing packages, procedures/functions, tables and hands on

experience in Data warehousing concepts.

Experience in data profiling, data standardization, data cleansing and data enrichment.

Interpersonal skills, Quick learner and good performer both in team & independent job environments.

Academia

Passed High School in 2006 from Eicher School Faridabad (Haryana).

Passed Intermediate in 2008 from Eicher School Faridabad (Haryana).

Completed B. Tech (C.S) in 2012 from GSMVNIET Palwal (Haryana).

Experience Summary

Working as a Software Consultant Developer at Amtex Software Solutions Pvt. Ltd since Sept 2014

Worked as a Software Developer at Qualtech Consultants Pvt. Ltd from Oct2012 till Aug2014.

Technical Expertise

BI Reporting Tools SAP Business Objects WebI

Data Quality Tools iWay Data Quality Server, dfPower Studio (SAS-DataFlux)

Database Oracle 9i / 10g, SQL Server 2008/2012

Languages SQL, PL/SQL

Utilities TOAD, PL/SQL Developer, Putty

Professional Experience

In Reverse Chronological Order

Project: Pre Sales Systems / Amtex Systems

Client: Information Builders Duration: Sept 2015 - Till Date

Role: Software Developer Consultant Team size: 5

Application/Project:

Information Builders provides software and services that bring smarter decision-making

and streamlined processes to leading organizations in business, government, and education

worldwide. Business intelligence (BI) platform delivers massively scalable information

applications, analytics, and customer facing portals to the new generation of information users to

deliver game-changing business results.

Environment:

SAP Business Objects 4.0, Dashboard Designer

Roles/Responsibilities:

Coordinated technical pre-sales activities, technical and product knowledge to customers via good

written, verbal and presentation skills.

supported the successful achievement of sales projects by analyzing the technical needs and providing

ability to deliver the IT solutions proposed to prospects or existing customers.

Working with on-shore team to create/enhance the existing reports through Web intelligence and updating

DB queries to analyze the reporting data.

Understanding the client requirements and handling weekly scheduled calls.

Project: Avamere Health Services / Amtex Systems

Client: Avamere Duration: Jun 2015 Sept 2015

Role: Software Developer Consultant Team size: 4

Application/Project:

Avamere is a health care group of companies whose mission is to enhance the life of

every person they serve. Its continuously innovating its care models. The project involved the

nurse to enter patient details in a user friendly page and the details get saved at backend, so as

to maintain history of patients.

Environment:

SAP BO 4.0, Oracle 10g

Roles/Responsibilities:

Data analysis through creating reports in Webi

Modification in previously created universe

Backup of universe and reports on weekly basis

Project: Frontline / Amtex Systems

Client: Frontline Duration: Jan 2015 May 2015

Role: Software Developer Consultant Team size: 6

Application/Project:

Frontline project is an insurance domain project to develop their database through

ETL process using SQL Server 2012 and to to create new & enhance their existing reports

Environment:

SAP BO 4.0, IDT

Roles/Responsibilities:

Universe modification by creating new objects and classes

Security levels assigned to users & groups

Data testing of reports with db tables in SQL Server

Project: Bank of New York Mellon / Amtex Systems

Client: BNY Mellon Duration: Sept 2014 Dec 2014

Role: Software Developer Consultant Team size: 3

Application/Project:

BNY is a project for data quality to standardize and cleanse the customize records and

hence deelop new logic using the existing plans and flows created in iWay data quality server.

Environment:

iWay Data quality server

Roles/Responsibilities:

cleansing the customer records from salesforce.com and legacy applications.

Replaced address doctor component with Loqate component and providing enhanced results.

Analysis of data to migrate the code.

Project: Internal Reporting / Qualtech Consultants Pvt. Ltd

Client: Max Life Insurance Duration: Oct 2012 Aug 2014

Role: Software Developer Team size: 4

Application/Project:

Objective of the project is to maintain and optimize the system which should provide

daily reports to business users.

Environment:

Business Objects XI R2, SQL

Roles/Responsibilities:

Created reports in web intelligence rich client

Changes done in universe for the objects as per the requirements. Created new objects as well.

Roles and Permissions given to various business users as per their designation and rights to see different

reports

Involved in gathering, analyzing, and documenting business requirements, functional requirements and

data specifications for Business Objects Universes and Reports

Project: Dedupe Operations / Qualtech Consultants Pvt. Ltd

Client: Max Life Insurance Duration: Oct 2012 Mar 2013

Role: Software Developer Team size: 4

Application/Project:

Project involves data profiling, data integrity & cleansing. Finance and Marketing

departments performed De-Dupe operations on the company data with the help of Data Flux

(Data cleansing tool) collating data from multiple records in order to perform cleansing

process modification in the Quality Knowledge Base (QKB) as per the requirement to

enhance the quality of data.

Environment:

SAS Data-flux, SQL

Roles/Responsibilities:

Project Involved Data Profiling, Data Integrity & Cleansing required for the analysis of finance and

marketing departments

Performed De-Dupe operations on the company data with the help of Data Flux. The primary objective of

the operation is to clean the data having multiple records or duplicity to make data consistent, which

helps the company to generate more revenue and helps executives to create more clients.

Collating data from multiple records in order to perform cleansing process.

Personal Details

Fathers Name : R.G. Arora

Mothers Name : Santosh Arora

: 16th Dec1989

Date of Birth

Gender : Male

Marital Status : Single

Languages Known : English, Hindi & Punjabi

PANCARD : BAZPA4220N

Declaration

I hereby declare that the information furnished above is true to the best of my knowledge.

Date:

Place: Faridabad (SANGEET ARORA)

Contact this candidate