Senior Business Analyst, Senior Financial Analyst, Decision Planning

SANDHYA A. PANDURANGI

*** ********* ******* *****, • St. Charles, MO 63303

Home: 636-***-**** • Mobile: 636-***-**** • l6w167@r.postjobfree.com

Finance professional with extensive experience in financial, statistical, qualitative, quantitative and financial system analysis.

A detailed oriented person with solid knowledge of GAAP, creating financial reports, intercompany reports, extracting data from using multiple database, creating queries, and building models, excel complex spreadsheets.

A creative team player with proven track record collaborating with professionals with varied backgrounds and making presentations before internal and external clients.

PROFESSIONAL ACCOMPLISHMENTS

• Improved 38-40% performance efficiency by automating work procedures & building spreadsheet models.

• Saved several million $$ to utility customers through comparative analysis of rates and accomplished rate reductions for customers by testifying as an expert witness before Federal Regulatory Commission.

• Assisted director on specific radiopharmacetical product through research analysis.

• Accomplished utility customer satisfaction through external vendors collaboration on in depth analysis of sudden rate spikes, while staying within the budget.

• Nominated as a team member of the Peoplesoft implementation program.

• Awarded A grade from Insurance Bureaus for timely & best quality financial reports for 2004-2008.

CORE COMPETENCIES

Financial Management/Analysis Financial System Analysis Regulatory Compliance

Budgeting/Forecasting Analysis Variance Analysis Internal Systems & Controls

Program Evaluation Process Improvement Cost Containment

Market Research Studies Cost Benefit Analysis Grant Proposal Review

EDUCATION

• Master of Public Administration, West Virginia University.

• Associate degree in healthcare administration, West Virginia University

• Master of Business Administration (MBA), Poona University, India. Major in Finance and Materials Management.

• Bachelor of Science in Accounting from Poona University, India.

PROFESSIONAL

BJC St Peters Hospital, St Peters, Missouri June 2009 - Present

Volunteer:

• Creating database for projects related to patient care. Also working on reviewing, updating, organizing various projects related to patient care management.

• Building, updating financial models for asset management, closing of fixed and capital assets, depreciation, forecasting, and budgeting.

SAFETY NATIONAL CASUALTY CORPORATION, St. Louis, MO Dec 2004-Nov 2008

Statistical Reporting Analyst

• Extracted data from multiple database. Prepared & analyzed month-end/quarter-end and adhoc financial, statistical, intercompany and marketing reports.

• Testing of inhouse developed/purchased/ upgrade system. Tested for system functionality and useability.

• Improved 40 % process time by coordinating with IT staff to integrate different database to extract specific & accurate information related to product revenue, market size, penetration, and trends.

• Participated in the month-end close, revenues reports in different currencies, AR journal entries, reconciliation reports. Responded to various inquiries both form internal as well as external clients.

• Team player in the Peoplesoft implementation process. Tested AR modules for functionality.

• Developed and submitted various annual financial/statistical reports for internal & external agencies.

• Assisted internal and external auditors. Also assisted internal auditors in testing SOX procedures.

• Accepted additional responsibilities on several occasions by going above and beyond my duties calls.

VOLUNTEER WORK: St Joseph Hospital, Nashua, NH. Nov 2003- March 2004

• Assisted nursing staff with patient care for elderly stoke and MI patients:

MISSOURI PUBLIC SERVICE COMMISSION, Jefferson City, MO May 1996 –Oct 2002

Utility Policy Analyst

• Saved several million $$ to utility customers by analyzing various complex financial issues, financial Statements, and testifying as an expert witness before Federal Regulatory Commission and accomplishing rate reductions for customers.

• Enhanced quality of work procedure by 40 % through developing complex cost-of-service and other financial models.

• Involved in Utility Settlement discussions, negotiations meeting with external clients. Regularly interacted with the state & federal Commissioners, utility & natural gas pipeline companies’ executives, public councils, and consumers.

• Evaluated RFPs/bids, lead player in the selection process of external market research vendors.

• Coordinated and monitored external vendor’s survey design, market research analysis with a report resulting in completion of projects within the allotted budget and/or saved $$ with quality products.

• Moderated focus group discussion on accounting practice and regulatory issues during national regulatory conferences.

• Nominated as a Member of the National Association of Regulatory Utility Commissioners.

• Made presentations to internal as well as external clients.

MO DEPT OF SOCIAL SERVICES, Research and Evaluation Unit, Jefferson City, MO

Research Analyst II & III (promoted to Research Analyst III within one year) July 1994 –May 1996

• Prepared budget appropriations report for the management. Monitored and analyzed appropriations and expenditures related to Division of Medical Services. Assisted in preparing monthly forecast.

• Researched and evaluated several programs. Reduced 30% of cost by improving work procedures.

• Performed routine and ad hoc financial and statistical analysis for senior management and customers (state and other agencies).

• Compiled data and performed statistical (qualitative and quantitative) analysis on Childrens' Service programs, from survey design to summary reports. Prepared annual reports of Children Service Program.

• Collaborated with MU faculties while working on various projects. Involved in exploring & finding business opportunities with other state agencies.

• Conducted a primary market research study on (a) identification of healthcare needs of low income groups, (b) effectiveness of the home health care and (c) cost efficiency of tuberculosis screening of state school employees.

• Spearheaded a project to review the Medicaid billing practices of local health agencies and submitted the report to the Program Director. This research project involved planning, survey design, conducting primary market research, statistical analysis and report writing.

RADIOLOGICAL RESEARCH CENTER, RADIOLOGY, MU, Columbia MO Jan 1994 –July 1994

Business Analyst:

• Assisted Director on new diagnostic noninvasive imaging agents including radiopharmaceuticals and contrast agents.

• Responsible for identifying the players in the imaging markets, their products, monitoring the markets and alerting the management of any new development in this market.

• Maintained inventories, purchase journal of commercial products and tracked its expenses.

• Tracking expenses of various research projects and report variance of expenses.

COMPUTER SKILLS

Sound working knowledge of AS\400, Access, mainframe, database, reinsurance package, PeopleSoft, Clarus, Billing system, Crystal Reports query tool, Lotus, SAS, COBOL, and FORTRAN, MS Office, advanced skills in Excel (including Vlookup & pivot tables), PageMaker and NCSS.

Contact this candidate