Prachi Chavan
Graduate Research Assistant · HR Analytics, University of Connecticut
Hartford, CTWork Experience
Graduate Research Assistant
HR Analytics, University of Connecticut2018 – 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 Connecticut2019 – 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 Limited2015 – 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 Technology2015
Bachelor's in Computer Science
Master of Science
University of Connecticut School of Business2019
Master of Science