PAVANI DONEPUDI

SUMMARY Pavani is a skilled professional with a strong acumen towards data

analysis with a natural talent to extract right message stored in the

data. She has over 13 years of experience in providing analytic and

reporting solutions in a data warehouse environment. Her strengths

are in Data Visualization, Data Retrieval, Cleansing, Transformation,

Slicking / Dicing of huge data in EDW enviroments and building

Excel Models with a touch of User Interactivity. She has a hands on

experience to query data from relational databases such as DB2,

Oracle, MS Access, SQL Server and in BI tools such as BEX

Analyzer, Query Designer. Pavani is looking forward to challenge

her Data Analysis skill in a senior role (Manager / Sr Analyst) while

providing value added services to her client.

SOFTWARE MS Office Suite, Advanced Excel, Visio, IBM Quality Management

System (QMS), Rational Portfolio Management (RPM), SAP

BusinessObjects, Crystal Reports XIR2/2008

LANGUAGES VBA, C, Java, COBOL

DATABASES DB2 9.0, MS Access, Excel, My SQL, SQL Server, Oracle, DB2

TOOLS SAP Bex Analyser, SAP Query Designer, TOAD for Data Analysts

ACHIEVEMENTS Round 2 candidate in ModelOff Financial Modeling World

Championships – 2013 (top 10%)

TRAINING Cloudera Data Analyst Training:Using Pig, Hive, and Impala with

Hadoop - 2013

PROFESSIONAL RESOLVIT RESOURCES, LLC. 09/12–

present

EXPERIENCE

MAXIM INTEGRATED INC

Sr. Data Analyst

• Redesigned a complicated Excel model for Distribution

Scorecard into a more efficient, easier to prepare and flexible

enough to draw various insights for the finance executive

Erica Chasco, Account Manager

(o) 408-***-****

(m) 408-***-****

Pavani Donepudi

management; the report output aids CFO and executive

management teams as one of the inputs for monthly press

releases.

• Designed and built a VBA based Excel macro tool to calculate

the participation fees; the automated process has benefitted

the accounting and finance teams by reducing 80 man hours of

manual intensive highly prone process to under one hour.

• Improved the operational efficiency of various periodic and

adhoc reports by building Excel Models (VBA and Excel

Formula based).

• Provided training sessions on Excel formulas ( such as

VLOOKUP, INDEX / MATCH, INDIRECT, and SUMIFS) to

Maxim Finance Audience (Executive Directors to Analysts.

KAISER PERMANENTE 02/12-09/12

Sr. Reporting Analyst

• Automated reporting processes for a Call Handling and

Tracking System that required intensive manual intervention

into a streamlined and scheduled process; the resulting process

almost completely eliminated the need for manual intervention.

• Played a key role in identifying the gaps in the Contact Center

Queue dashboards to provide enhancements highlighting

crucial information for executive management.

• Optimized SQL queries and built Excel templates with Macros

and VBA for monthly QA dashboards.

• Improvised the dashboard process and provided greater

flexibility in data visualization and accuracy with a significant

reduction in the manual effort.

• Analyzed long-running SQL queries and fine-tuned the queries

that improved the query performance and reduced the

execution time from three hours to less than 30 minutes.

SEARS HOME SERVICES 04/11 –

02/12

Sr. Reporting Analyst

• Participated in functional requirement gathering from the

business users and database design teams

• Performed root cause analysis by querying and analyzing

multi-source databases for data inconsistencies and provided

alternative and corrective measures for data discrepancies

• Translated the business requirements into technical design

specifications for web intelligence reports that include features

such as drill downs, charts, cross tabs, and summary reports

• Played a pivotal role in the design and development of the

reporting solutions for sales and services tracking systems that

Page 2 of 4

Pavani Donepudi

provided executives with the leading indicators to help set the

strategic decision

2008 – 2011

NAVISTAR INC.

Sr. Reporting Analyst

• Managed both client and internal resources located onshore and

offshore to facilitate project evaluation, gather requirements,

design, and implement data warehouse and reporting solutions

• Served as the primary liaison between inventory control

manager, plant managers, business analysts, and the internal

development team and provided senior level systems support

• Ensured the operational readiness of the reporting needs for

seven assembly plants for bi-annual KPMG audits

• Proposed and implemented a strategic process improvement

solution for the inventory management systems to track the

reasons for lost or missing inventory; the results influenced the

management team to implement controlling measures that

reduced annual inventory losses by almost 40%

• Chaired weekly multi-team cohort meetings with remote and

local teams to ensure effective collaboration and sharing of

resources; built consensus and drove the deliverable schedule

for sister teams

• Designed and built automated cycle counting reporting process

via Excel and DB2 and exported them to SharePoint on a

monthly basis; the new automated process reduced the

management effort by 60%

PRUDENTIAL INC. 2001 – 2008

Technical Lead (2005 to 2008)

• Performed synergies and gap analysis between the status quo

and proposed system to merge Prudential and Cigna defined

benefits plans

• Led a team of 15 developers to implement the merger of

Prudential-Cigna Defined Benefits plans

• Delivered a successful project that enabled Prudential to

migrate 2,500 defined benefit plans and 1.5 million annuitants

to Prudential systems

• Coordinated and played a pivotal role with the data warehouse

team to design and implement a key decision support reporting

application post Prudential Cigna merger

• Identified the root cause and provided solutions for 25

recurring issues that contributed 60% to the maintenance effort

• Led a team of three associates to implement the solutions,

Page 3 of 4

Pavani Donepudi

reducing maintenance effort to 20%

• Organized and planned several reporting projects, overseeing

the complete project life cycle

• Developed, organized, and facilitated training programs

serving both client business users, business analysts and

development team on the usage and access of improvised

business systems

• Created the data mapping, lookup tables, and data validation

rules between the source data and the target data

• Involved in creating the test data and setting up the test

environments for performing the integration testing, system

testing, load testing, and regression testing for implementation

• Executed training programs to 40 CIGNA and Prudential

business users on the business functionalities offered by the

ABC system

Sr. Software Developer (2001 to 2004)

• Led a five member technical team to successfully integrate

quote calculation and tax withholding functionality into the

annuity benefit consolidation system

• Ensured the system reduced manual intervention of the user

community by almost 70% and provided an error-free benefit

plan, quotes, and tax calculations

• Played a key role in the technical development team to enhance

the security for the application benefit consolidation system

• Enhanced the system and enabled it to allow restricted user

accessibility to critical finance applications

• Significantly improved user accountability

EDUCATION Master of Business Administration (Finance specialization)

Duke University

Master of Computer Applications

National Institute of Technology, India

B.S. – Computer Science

Nagarjuna University, India

Page 4 of 4

Contact this candidate