Neha Ajgaonkar
Worcester,MA
Overview
7
7
years of professional experience
Work History
SENIOR DATA ANALYST
University Of Massachusetts President's Office, UPST
Boston, MA
02.2021 - Current
- Successfully delivered significant end-to-end transparency into UMass's procurement data, resulting in positive changes
- Implemented system-wide procurement and spend analytics dashboards for strategic sourcing activities and provided faster insights to UMass stakeholders
- Contributed 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
- Leveraged analytical segmentation models to create a hierarchical category tree and mapped 99% of spend to appropriate categories and subcategories to assist in transforming and building more robust purchase categorizations
- Project managed to integrate and merge XML and historical data from multiple transaction systems to build automated data models for Requisitions, Purchase Orders, Invoices, Contracts, and Supplier management
- Managed and trained data analytics interns by setting tasks and responsibilities, including supervision, mentoring, and tracking interns' progress to meet expectations and deadlines
- Maintained databases and data systems by monitoring performance and quality control plans
- Designed optimal analytical solutions with a cross-functional team across the supply chain, IT, finance, and product.
DATA ANALYST
University Of Massachusetts President's Office, UPST
01.2020 - 02.2021
- Measured performance, analyzed trends, and designed Salesforce Dashboards for customer case management and sourcing events
- Automated, interactive, and actionable Tableau Dashboards to track UPST transactions against each functional KPI/metric, weekly staff performance management, and contract management
- 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
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
University Of Massachusetts Lowell
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
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 - Business Analytics - Big Data Analytics
University of Massachusetts - Lowell
Lowell, MA05.2018
MA IN BUSINESS MANAGEMENT -
University of Mumbai
Mumbai05.2016
BACHELOR OF MANAGEMENT STUDIES IN MARKETING -
University of Mumbai
04.2014
Skills
- Tableau
- Visio
- SQL
- Python
- R
- Salesforce
- IBM SPSS
- Power BI
- Rapid Miner
- MS - Excel
- Data Mining
- Data Visualization
- Machine Learning
- Statistics
- ETL
- Text mining
- Descriptive
- Predictive & Prescriptive Analytics
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 President's Office, UPST
02.2021 - Current
DATA ANALYST
University Of Massachusetts President's Office, UPST
01.2020 - 02.2021
RESEARCH ANALYST
University Of Massachusetts Lowell
10.2018 - 12.2019
COMPENSATION DATA ANALYST
University Of Massachusetts Lowell
03.2018 - 12.2019
ASSISTANT REPORTING ANALYST
Office Of University Advancement
03.2017 - 02.2018
Master of Science - Business Analytics - Big Data Analytics
University of Massachusetts - Lowell
MA IN BUSINESS MANAGEMENT -
University of Mumbai
BACHELOR OF MANAGEMENT STUDIES IN MARKETING -
University of Mumbai
Similar Profiles
Neha AjgaonkarNeha Ajgaonkar
SENIOR DATA ANALYST at University of Massachusetts (UMass) President's Office, Unified Procurement Services Team (UPST)SENIOR DATA ANALYST at University of Massachusetts (UMass) President's Office, Unified Procurement Services Team (UPST)
Kelci CrandallKelci Crandall
Office Assistant at Saint Louis University President's OfficeOffice Assistant at Saint Louis University President's Office
Deepika DhanajayanDeepika Dhanajayan
Student Intern at University of Massachusetts, Provost’s OfficeStudent Intern at University of Massachusetts, Provost’s Office
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