Sap Data Entry
Resume:
Purnima
Sharma, OCP
Cherry Hill,
NJ 08003
Email: ****************@*****.***
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