Project Management

SANYUKTA PATNAIK, MBA, MS

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

Newark, CA 94560

********.*******@*****.***

Cell: 408-***-****

Summary

. 7 YEARS OF DATA ANALYTICAL EXPERIENCE OF WHICH FOUR YEARS AT THE

LARGEST US HEALTHCARE ORGANIZATION.

. Expertise in analysis, management reporting and metrics creation with

sophisticated charts and graphs for dashboard, scorecard and other

tools

. Interfacing with senior management to produce timely results, project

coordination, project management and implementation.

. Experienced in ad-hoc reporting with metrics, automated tool

development for leadership, business forecasting, analyzing current

and past trends in performance indicators.

. History of design research plans for statistical data gathering and

analysis, experienced in interpreting analysis and developing action

plans.

Professional Experience

KAISER PERMANENTE, OAKLAND, CA APR 2007 - MAY 2011

Business Analyst -HR Workforce Metrics and Analytics -Center of

Excellence

Managed projects related to performance improvement, data analytics and

management.

. Designed, created and project managed HR Operational Dashboard metrics

with charts to consolidate reporting for regional and area leadership

to manage daily business of medical Centers, Leveraging world class

Hospital Scorecard, and Saratoga benchmarks to include value-added key

metrics from HR areas of Compliance, Employee and Labor Relations-

Disability Management,Union Grievances, Incentive based Pay Program

and Recruitment metrics.

. Estimated cost to KP for violation of matter related to the

compliance, statistical data analysis of work place injury related

(Industrial) and medical leave and organizational effort to

accommodate the employees on transitional work and reduce cost.

. Estimating time to resolve union grievances, analyzing hotline

complaints, timeliness of LOA, Late terms to maximize compliance

performance and minimize grievances, analyzing sick day utilization to

measure employee attendance and injury rate to monitor workplace

safety.

. Designed process to map 26,000 jobs into mapping category to meet

different reporting requirement of the leaders.

. Designed and developed hiring forecast tool to hire employees based on

financial projection, internal employee movement, and termination by

analyzing historical statistical data.

. Designed and developed retirement tool to capture social security and

KP retirement eligibility to see if employees are skipping retirement

age to work longer or accept better incentive to retire earlier by

analyzing historical data..

. Designed and developed career progress tracking and monitoring Tool

by analyzing KP New Grad Nursing/Pharmacy Intern/ Residents data for

hiring managers to make hiring decisions and monitor financial

educational aid programs.

. Designed and developed Recruitment Scorecard and Workforce Dashboard

to measure recruitment performance and help the Hiring Manager to make

recruitment decision.

. Developed national reporting tool for the leaders/managers to monitor

recruitment performance of all Kaiser Facilities.

. UAT/QA-tested the functionality/accuracy of recruitment tools:

-Recruitment Scorecard, HR Recruitment and Payroll Dashboard, HR-

Operational Dashboard and HR Workforce Dashbaord.

. Analyzed cost and projected hiring for New Hospitals at Antioch,

Modesto, Roseville and Vacaville.

. Designed metrics and created functionality for HR Recruitment

Dashboard Production to measure recruitment performance and retention.

. Analyzed Employee demographics data.

Mason Tillman Associates Ltd, Oakland

Mar 2006 - Dec 2006

Database Analyst

. Coordinated projects for Disparity study of State of Texas, Wayne

County Airport Authority, Alameda County Juvenile Justice, and City of

Dayton to measure minority and women representation in government

contracting opportunities. The job involved research work, surveys,

questionnaires, public opinion polls and reviewing the survey work of

staff members and research assistants, coordination with research team

members in survey planning, implementation and evaluation; report and

recommendation preparation on the basis of survey data; writing

disposition reports and calculation of response rates to monitor and

evaluate performance of survey

. Collected statistical data from the government-Federal/City/State and

research in different Excel forms and Access database using advanced

Excel, Data import from Excel to Access and vice versa. Data cleaning

and formatting the data in usable form, Preparing Data Error report

. Analyzed Statistical data to prepare report inclusive of chart, graph,

table

. Prepared Error report by comparing with previous month's report to

detect data discrepancy

. Designed and documented report for leaders and managers to make

executive level decision.

. Designed database structure, created data entry/view forms and reports

necessary to satisfy project needs.

San Francisco State University, San Francisco

2002 - 2005

Graduate Marketing Research Assistant

. Collected, analyzed and interpreted statistical data collected for

marketing research purpose.

. Research Assistant in the Department of Statistics

Technical skills: Advanced Excel and Access database including Pivot

Tables, VBA, Vlookup, Macros, SQL. Microsoft Word, PowerPoint. Hyperion,

OLAP, Crystal Report, Data Warehousing,MS-Project,Visio.

Education

MBA, SAN FRANCISCO STATE UNIVERSITY, CA

MS, Econometrics and Statistics, Calcutta University, India

Professional Development

7 HABITS OF HIGHLY EFFECTIVE PEOPLE, 2010

Franklin Covey Presentation Advantage, 2010

Data Modeling and Database Design, 2009

Data Warehousing Fundamentals, 2009

SDLC Project Management I-PM Skills, 2007

SDLC Project Management II-MS Project, 2007

SDLC Project Management IV-PMP Test Prep, 2007

Programming Crystal Reports, 2007

Contact this candidate