Aditya M. Email & Phone Number

Chicago, IL, US

Chicago, IL, US

• Utilized SQL, and advanced Excel functions ( Vlookup’s, Pivot table and Power query) for data analysis, data modelling and customer segmentation.
• Leveraged Google Sheets extensively, utilizing Google Apps Script to automate tasks and implement time-driven triggers, resulting in an 80% reduction in manual intervention and enhanced operational efficiency.
• Developed ETL processes using SQL and Excel to compile and organize data from multiple sources, ensuring seamless data flow from data management ( SAS ), aligning with end-to-end ownership of operational and technical.
• Produced comprehensive reports and data visualizations using Tableau, PowerBI, and Excel, simplifying and automating reporting activities, and enhancing data availability for key stakeholders.
• Automated the generation of monthly reports, Bi-weekly reports, aggregating and visualizing (KPI) using SQL, Appscript and Gsheets. Successfully streamlined the reporting workflow, saving 20 hours/month and ensuring.
• Developed 10 Tableau reports and 2 dashboards for Office of Civil Rights, enhancing data communication and contributing to informed decision-making.

East Dundee, Illinois, US

• Analyzed faculty schedules to identify patterns and trends in faculty availability and workload.
• Developed and implemented a system to automate and streamline the faculty scheduling process, reducing the cost of 2 FTES and providing a great value proposition for UIC by removing manual intervention.
• Worked closely with faculty members, project managers, and other stakeholders to gather requirements and ensure that everyone's needs were being met.
• Conducted stakeholder interviews and facilitated meetings to gather feedback on the scheduling process and identify areas for improvement.
• Monitored scheduling metrics and KPIs to track performance and identify areas for further improvement.

Mumbai, Maharashtra, IN

• Conduct ad-hoc financial analysis to support business decisions, including forecasting revenue, analyzing cost savings opportunities, and assessing the financial impact of new initiatives.
• Analyze sales, and procurement data to identify trends and opportunities for revenue growth and collaborate with sales leaders to develop action plans to achieve targets.
• Automated the process of common audit analysis using IDEA Software which resulted in 90% reduction manual reporting time hours.
• Developed Spreadsheets that redefined how the company reconciled balance sheets monthly/quarterly and annually.
• Manage data curation, compilation, synthesis of findings, recommendations, and report writing to share outcomes.

Chicago, IL, US

• Worked on Financial management and enterprise software (IDEA) and Excel to perform various analyses in different Audit domains such as Healthcare, Finance, Accounting, Payroll, Human Resources – Time management.
• Led and managed a team of 3 in the collaborative development of the reconciliation of the balance sheet, data curation, and various analysis.
• Developed Spreadsheets that redefined how the company reconciled balance sheets monthly/quarterly and annually.
• Manage data curation, compilation, synthesis of findings, recommendations, and report writing to share outcomes.

Master'S Degree, Management Information Systems

Electronics Engineering