Data Analyst

KAITTKEE PURI

920-***-**** ********@*****.*** http://in.linkedin.com/in/kaittkeepuri

SUMMARY

Experienced Data Analyst with 5 years of expertise in HealthCare Analytics.

Experienced with ETL, SQL Server Management Studio (SSMS), Salient Interactive Miner (SIM) and Salient Dashboard Miner (SDM), Business Intelligence concepts and Software Development Life Cycles (SDLC).

Knowledge of New York State (NYS) Medicaid Claims data, Welfare to Work data, Payments data.

TECHNICAL SKILLS

Tools: Tableau, Oracle SQL Developer, WinSQL, MS-SQL Server Management Studio (SSMS), Salient Interactive Miner, Salient Dashboard Miner, Salient ETL

Languages: R, SAS, SQL and PL/SQL

Database: Oracle & MS-SQL Server Database

Operating Systems/Computer Skills: Windows, MS-Office – Word, Excel, PowerPoint, Outlook

EDUCATION

THE COLLEGE OF WILLIAM AND MARY, MASON SCHOOL OF BUSINESS Williamsburg, VA

Master of Business Administration - General Management, GPA: 3.58 May, 2014

Healthcare Informatics/Business Analytics, Lean Six Sigma Green Belt

Winner of Deloitte Data Analytics Case Competition

MEERUT UNIVERSITY, I.T.S. DENTAL COLLEGE Ghaziabad, India

Bachelor of Dental Surgery, GPA: 3.71 March, 2010

EXPERIENCE

SALIENT MANAGEMENT COMPANY (Data Analytics/BI) Albany, NY

Data Analyst II - June 2014 to Present

County Data Analysis – Project Lead

Performed Data Validation using SQL to ensure that the data in the client database matched the source data; reduced data errors by 30%.

Analyzed transactional and non-transactional data for 9 counties of New York State and produced, verified and interpreted client reports.

Developed and refactored ETL and data computation logic.

Conducted user training sessions to help users understand the Medicaid data.

Supportive Housing Program – Project Lead

Managed all phases of the project from requirements gathering to user acceptance testing and documentation development for NYS Supportive Housing Program. Helped NYS Medicaid Redesign Team track costs.

Validated data prior to importing into databases and provided post-implementation support to the clients.

DSRIP – Data Analyst

Identified logic for Performance Indicators in Medicaid Data Warehouse using SQL.

Developed a test plans to validate and verify calculation logic for Performance Indicators.

NYCDOHMH Data Analysis – Project Lead

Completed ad-hoc projects relating to data investigation, follow-ups on analysis results and other client requests using Excel and SQL.

Analyzed health care data - including medical and pharmacy claims, membership files to better understand the quality and level of care delivered.

Developed algorithm to the measure the effectiveness of the organization's services as it relates to both clinical quality and financial returns.

ICD – 10 Conversion – Data Analyst

Performed analysis to identify ICD-10 replacement codes for the user cohorts.

Developed a communication plan to inform the users of transition to ICD-10 coding system.

Updated logic with ICD-10 codes and the version codes.

BRAND ACUMEN LLC. (A UNIT OF HAVAS HEALTH) New York, NY Summer Associate- July 2013-October 2013

Improved process efficiency by 30% through capacity planning and resource utilization.

Decreased lead time by 15% by standardizing processes which improved new proposal workflow.

Conducted market research for 15 RFPs (valued at ~ $95K).

PJ HICKSVILLE INC. Hicksville, NY

Procurement Intern – May 2013-August 2013

Created EOQ and reorder points to reduce inventory carrying cost; reduced wastage by 25%.

Conducted VOC surveys to identify customer preferences.

Forecasted inventory; reduced carrying cost by 20%.

Prepared budgets based on historical data ensuring controlled spending and correct allocation of resources.

PAUL DENTAL HOSPITAL New Delhi, India

Care Manager – April 2010- June 2012

Developed business plan to integrate dental surgery unit with mainstream multi-specialty hospital, which reduced lead time by 20% and improved process efficiency.

Reviewed, researched and negotiated insurance plans, enabling patients to make informed decisions.

Enhanced productivity and decreased the patient wait time by 25%.

Managed budgets, volume forecasts and vendor relationships.

Analyzed patient satisfaction data and implemented performance improvement measures. Increased patient inflow by 30%.

I.T.S. DENTAL COLLEGE Ghaziabad, India

Intern - March 2009 – March 2010

Reduced out-of-pocket dental surgery expenses for patients by using advanced diagnostic techniques.

Managed client relationships for community dental camps, raising funds of $2000 for the treatment of uninsured cancer patients.

ACADEMIC PROJECTS

MedCPU Richmond, VA Project Lead - October 2013-April 2014

Performed data analysis to identify monetization opportunities.

Developed a commercialization plan while working within an interdisciplinary team of experienced business, scientific, and medical professionals

Performed market assessment including market sizing, segmentation, identification of channels/partners (ACO's, health insurance companies, EMR's)

VOLUNTEER ACTIVITES

REAL CAUSE, Non-Governmental Organization (NGO) New Delhi, India

Operations Associate (full-time/part-time) - May 2002-June 2012

Oversaw project cycle management, conducting marketing research, focusing on generation of knowledge practice and methodologies.

ADDITIONAL SKILLS

Desire and ability to lead, direct and balance multiple, concurrent assignments and effectively manage priorities/deadlines.

Acumen to quickly comprehend business knowledge and understand/analyze different systems/large data-sets.

Brainstorm/recommend processing, technology changes to drive new initiatives and finding synergies.

Excellent oral and written communication, presentation skills.

Contact this candidate