PC

Prachi Chavan

Graduate Research Assistant · HR Analytics, University of Connecticut

Hartford, CT

Work Experience

Graduate Research Assistant

HR Analytics, University of Connecticut

2018 – Present

• Talent Management Research Project at Ulta Beauty in collaboration with University of Connecticut • Assist professor in creating data-driven tools to enable Ulta Beauty managers to better understand and address the primary causes of turnover and predict which employees are most likely to quit using tools as STATA and R

Graduate Teaching Assistant

Predictive Modelling, University of Connecticut

2019 – Present

Assisted professors with lessons, evaluated homework, tests, and held office hours to ensure students understood course concepts and involved in the development of new materials for department courses

Worked on Informatica Analyst Tool IDQ

Capgemini Technology Services India Limited

2015 – 2018

to get scorecards reports for data issues for building an efficient data warehouse • Implemented various data profiling rules on IDQ tools to find incorrect and ambiguous values in GL_BALANCES table and improved efficiency of General Ledger report Extract, Transform and Load Informatica 9.0.1/9.6.1 PowerCenter, DAC Performed Session Partitioning technique and increased session performance by 50% • Reduced an ETL refresh process that was running for 6-10 hours and frequently causing production outages to a reliable less than a one-hour process and received "Rising Star" award from Employer for outstanding contribution • Competent in Error handling, Troubleshooting using various log files and problem fixing in Informatica and writing SQL queries for Data extraction and validation Dashboard Creation Excel, OBIEE 11 g Leveraged Advance Excel to create Pivot tables • Developed analysis using KPI to help customers measure the progress and performance of organization using OBIEE Requirement Gathering and Data Warehousing Experienced in Requirement Gathering, Dimensional Modelling, Designing and Maintaining Datawarehouse • Worked with Agile, Scrum methodology to ensure delivery of high-quality work with every monthly iteration using ServiceNow

Education

Bachelor's in Computer Science

Pune Institute of Computer Technology

2015

Bachelor's in Computer Science

Master of Science

University of Connecticut School of Business

2019

Master of Science