Neha Ajgaonkar
Senior Data Analyst
Worcester,MA
Overview
8
8
years of professional experience
Work History
SENIOR DATA ANALYST
University of Massachusetts (UMass) President's Office, Unified Procurement Services Team (UPST)
11.2022 - Current
- Successfully delivered significant end-to-end transparency into UMass's procurement data, resulting in positive changes across UMass system.
- Developed university wide reporting tool for tracking and enhanced visibility into sourcing and contract processes, system-wide contract utilization and supplier diversity insights (copyrighted as SPARC Pro- Strategic Planning Analytics and Reporting for campuses for Procurement)
- Leveraged Looker platform to design and implement reports and dashboards for real-time tracking of transactions and processes.
- Developed a contact center dashboard to analyze calls from Zoom and track KPIs for comprehensive insights and automating data collection and data mining processes.
- Developed and implemented a comprehensive Data Literacy Program, equipping internal and external stakeholders with the skills and tools to access, analyze, and interpret data, leading to improved daily activities.
- Led predictive analytics initiatives, forecasting transaction and request volumes for UPST. Implemented strategies to anticipate peak times, enabling proactive resource management and optimizing efficiency.
- Utilized Google Analytics and Coveo to uncover actionable insights that drove website optimization and improved content engagement.
- Conducted a comprehensive review of data and analytics architecture, implementing improvements for system efficiency.
- Contributed to the development of a chatbot solution to enhance efficiency and reduce human effort.
- Provided Data Analytics expertise to UMass IT Value Added Resellers Project, rationalizing 1600 vendors to 4 strategic vendors and helping UMass achieve a 12-20% reduction in overall costs.
- Successfully managed a dynamic Data Analytics Team, providing leadership and mentorship to foster skill development and collaboration among team members.
- Contributed to the development of a contact center dashboard to analyze calls data from Zoom and track KPIs for comprehensive insights and automating data collection and data mining processes.
DATA ANALYST
University Of Massachusetts President's Office, UPST
01.2020 - 10.2022
- · Developed and maintained Salesforce customer case management dashboards for insightful data visualization.
- Project managed to integrate and merge XML and historical data from multiple transaction systems to build automated data models for Requisitions, Purchase Orders, Invoices, Spend Cube, Contracts, and Supplier management.
- Maintained databases and data systems by monitoring performance and quality control plans.
- Implemented system-wide procurement and spend analytics dashboards for strategic sourcing activities and provided faster insights to UMass stakeholders.
- Automated interactive, and actionable Tableau Dashboards to track UPST transactions against each functional KPI/metric, weekly staff performance management, and contract management.
- Designed optimal analytical solutions with a cross-functional team across the supply chain, IT, finance, and product.
- Successfully contributed to the department's cost reduction and resource optimization initiatives by providing insights into the impact of COVID-19 on the business.
RESEARCH ANALYST
University Of Massachusetts Lowell (UMass Lowell), Strategic Analysis & Data Mgmt. Office
10.2018 - 12.2019
- Analyzed and improved processes using data from systems by generating ad-hoc and standard reports.
- Assisted with the draft, execution, and presentation of assigned projects and quality-review data submissions.
- Managed research databases using Tableau and SQL, analyzed data and resolved discrepancies and deviations.
- Applied Clustering techniques for Student Retention Analysis to understand reasons for college withdrawals.
COMPENSATION DATA ANALYST
UMass Lowell, Human Resources Office
03.2018 - 12.2019
- Developed an analytical assessment tool that helped implement the Massachusetts Equity Pay law in the department.
- Analyzed data to ensure no statistically significant difference was salaries based on gender, race, position, qualifications, and other factors.
- Performed data integration and visualization, built regression models, and report analysis.
- Provided Statistical, Descriptive, and Prescriptive Analysis using Tableau, R, and Python.
- Successfully solved salary review problems, outlier detection, and salary adjustments to improve trend lines.
- Computed salary range for different groups and conducted statistical tests to ensure effective decision- making.
ASSISTANT REPORTING ANALYST
UMass Lowell, Office of University Advancement
03.2017 - 02.2018
- Built compelling, robust and interactive dashboards that answered key business questions using Tableau and SQL.
- Provided Statistical and Descriptive analysis with dynamic reports to assist leadership in data-driven decision making.
- Highlighted performance gaps and strategy improvements to meet goals and increased fund collection by 7%.
Education
Master of Science in Business Analytics - Big Data Analytics -
University of Massachusetts Lowell
Lowell, MA05.2018
Master of Commerce - Business Management - undefined
University of Mumbai
Mumbai, India05.2016
Bachelor of Management Studies - Marketing - undefined
University of Mumbai
Mumbai, India04.2014
Skills
- Tableau
- Visio
- Looker
- SQL
- Python
- R
- Salesforce
- IBM SPSS
- Power BI
- Python Programming
- Business Intelligence
- Advanced analytics
- Machine Learning
- Data Mining
- Data Visualization
- Data Engineering
- Text mining
- Descriptive Analytics
- Predictive Analytics
- Advanced Excel
Awards
- 2021 Commonwealth's Recognition Certificate for Outstanding Performance
- Winner of "Outstanding Business Analytics student" award at UMass Lowell.
- Finalist at Teradata's "2017 Analytics Challenge" international competition in Anaheim, CA.
- Winner at UMass Lowell's Student Research Symposium for medical appointments analysis.
Timeline
SENIOR DATA ANALYST
University of Massachusetts (UMass) President's Office, Unified Procurement Services Team (UPST)
11.2022 - Current
DATA ANALYST
University Of Massachusetts President's Office, UPST
01.2020 - 10.2022
RESEARCH ANALYST
University Of Massachusetts Lowell (UMass Lowell), Strategic Analysis & Data Mgmt. Office
10.2018 - 12.2019
COMPENSATION DATA ANALYST
UMass Lowell, Human Resources Office
03.2018 - 12.2019
ASSISTANT REPORTING ANALYST
UMass Lowell, Office of University Advancement
03.2017 - 02.2018
Master of Science in Business Analytics - Big Data Analytics -
University of Massachusetts Lowell
Master of Commerce - Business Management - undefined
University of Mumbai
Bachelor of Management Studies - Marketing - undefined
University of Mumbai
Similar Profiles
Neha AjgaonkarNeha Ajgaonkar
SENIOR DATA ANALYST at University Of Massachusetts President's Office, UPSTSENIOR DATA ANALYST at University Of Massachusetts President's Office, UPST
Hula KhalifaHula Khalifa
Resident Assistant at University Of Massachusetts UmassResident Assistant at University Of Massachusetts Umass
LaTasha MoodyLaTasha Moody
Professor of Military Science at University Of Massachusetts UmassProfessor of Military Science at University Of Massachusetts Umass
Onika HarriganOnika Harrigan
Switchboard Operator at Saint Vincent HospitalSwitchboard Operator at Saint Vincent Hospital
Karin DaigleKarin Daigle
Senior Graphic Designer at Fallon HealthSenior Graphic Designer at Fallon Health