Purnima

Sharma, OCP

** ********* *****

Cherry Hill,

NJ 08003

856-***-****

Email: acfw22@r.postjobfree.com

SUMMARY: Business Intelligence Analyst level III, BO Universe

Developer with over eight years

of experience in using RDBMS and SAP

Business Objects tools. In addition, I have expertise in

developing complex reports for financial

analysis and data reconciliation using complex SQL,

MS Excel, Web Intelligence, and Desktop.

I recently passed certification in SAP HANA Application

Associate.

I am a fast learner with a quick grasp of new technologies,

willing to take on additional

responsibilities and highly adaptable to a fast paced

environment. Experience working on

complex team-oriented project.

CERTIFICATION: Oracle Certification (Oracle 8i) in Development by Oracle

Corporation in Internet

Applications Development.

Rrr

SAP HANA Application

Associate SAP C_HANAIMP_1

COMPUTER: RDBMS: Oracle, Microsoft

Access

SKILLS Languages: SQL, PL/SQL

GUI: Business

Objects XI, R2/R3/R4 Development, BO Universe Designer, IDT, BO

Desktop,

Web

Intelligence all versions, BO Dashboards, SAP Explorer

Infospaces. Familiarity

with

ETL Tools - BODS

ACHIEVEMENTS: I was awarded 'Partners of Excellence' award

multiple times for various projects.

. Successfully completed financial projects

involving creation and automation of

complicated financial reports to view ROI

for all clients at a glance. The reports that

took 3-4

days and involved 4-5 accounting personnel

could be created instantaneously and refreshed

on

demand. Further, the future requirement of

data entry was completely eliminated. Several

unprofitable contracts were renegotiated

after the reports' analysis and findings.

. I created scorecards and budget reports for

several of our major clients involving complex

Organizational hierarchies and complex

formulas for calculating KPIs for each level.

. I was solely responsible for creating universe

and reports for our Call Center Management.

The scorecard I created helped the Call

Center managers to do performance analytics,

manage

the calls and design effective strategies to

improve performance. It brought consistent

visibility

to key call performance metrices such as

average call handle time. The CMS managers

reported

a YTD 6% decrease in this critical statistics

after implemengtimg the scorecard.

. I created and automated many telematics reports,

most important being reports for excessive fuel

consumption because of speeding and idling.

The measures taken after implementation of

these reports saved our clients thousands of

dollars per year. Some of the reports I created

were

cited in our clients' White Pages.

. I was given promotions multiple times for

successfully handling above mentioned

high profile assignments.

TECHNICAL Development experience in BO XI R2/R3, R4

Universe Designer, Webi XIR2/R3/R4, Desktop

STRENGTHS: Intelligence, development of Infospaces for SAP

Explorer, and day to day administration of about

2000 BO user accounts.

Experience in designing Attribute, Analytical, and Calculation

views in SAP

HANA and designing explorer

Infospaces based on those views.

. Extensive experience in BO Universes development utilizing

complex joins, contexts, hierarchies, aliases, predefined

conditions, calculations, and derived tables

. Ability to create complex Webi reports and troubleshoot

business issues

. Proficient in performance tuning of the queries

. Communicate with business customers to define business

intelligence requirements and then lead initiatives to

deliver solutions accordingly

. Ability to lead projects and teams to accomplish project

goals

. Analyze, prioritize, assign and follow-up of projects and

provide regular updates on

progress of assignments to users and management

. Mentor, guide, support and train end users, occasionally

clients

. Proficiency in data and financial analysis using SQL and

advance Excel techniques

. Ability to interact with end users at all levels,

including senior management personnel

. Strong background in SQL, PL/SQL and retrieval of data

using ad-hoc queries including Oracle analytical

functions

. Experience in managing BO users accounts and BO

administration

. Experience in designing Attribute, Analytical, and

Calculation views in SAP HANA

. Experience in designing SAP Explorer Infospaces

EXPERIENCE: Business Intelligence Analyst Level III, ARI NJ, Apr'07 till

Date

Worked as a consultant from April'07 to Aug' 07 through Robert

Half technology and started working as a full time employee

from Sep'07.

Responsibilities:

. To create new BO universes on an on-going basis and

maintain about 120 existing BO universes

. To interact with people at all levels, gather

requirements and translate their business needs into

technical requirements and then create universes

according to their requirements

. Assist the reporting group by developing complex and

advance level reports which the reporting group is not

able to handle

. Analyze, prioritize, assign and follow-up on FleetTrak

cases assigned to BI team

. Assist in the design and support of an enterprise-wide

data warehouse

. Communicate with customers and managers of other

departments to define business intelligence requirements

and then lead initiatives to deliver solutions

accordingly

. To develop, document, and support the web based Corporate

Reporting and troubleshoot existing BO Reports

. Incorporate complex logic through free hand SQL to

implement complex business rules in

BO universes

. Create InfoSpaces for SAP Explorer

. Responsible for creation and maintenance of user accounts

for about 2000 users in the absence of BO administrators

. Assists in the design of data models that depicts our

transactional and reporting systems

. Create Attribute, Analytical, and Calculation views in

SAP HANA

. Create Infospaces for Explorer

Reporting Analyst: GMAC Mortgage, NJ, Nov'05 to March'07

(Contract)

Responsibilities: Maintained full responsibility for

creating and managing BO universes that decreased the

reporting time by 50% within multiple departments. In

addition to designing and maintaining universes, I

automated several reports using macros and programming

skills, which resulted in reducing the time required for

report generation by 75%. Previously a tedious function of

report processing and generation was streamlined and was

more accurate and efficient.

. Responsible for the data management and reporting for

GM Direct Lending Finance

and Strategic Planning

. Designing Universes

. Provide Data Processing and analytics support for financial

administration

. Designing and maintenance of financial, commission, and incentive

databases

. Designing ad hoc queries and generating complex

reports involving accounts

reconciliation with vendors and rectify

inconsistencies

EXPERIENCE: Clinician Informatics: Kennedy Health System, New

Jersey, Feb' 05 to Nov, 05 (Contract)

Responsibilities:

. Development of physicians' profiles, peer reviews,

incidents reports, other related

reports using free hand sql for Vice President and

Corporate Directors in Performance

Evaluation Department

. Development of databases for falls, injuries, and

mortalities for the department's performance

. Handling statistical inquiries regarding compliance from

various departments using Oracle

Database Programmer: OHM Remediation

Services, Irvine, CA, April' 96- June 2001

EDUCATION: MBA, Daniels College of Business, University of Denver,

earned 12 academic credits

MBA, B.Sc., Delhi University, India.

REFERENCES: Available upon request.

Contact this candidate