As a Deputy Manager Data Analyst at Aakash Educational Services Limited, I am in charge of automating reports for the management and conducting ad-hoc analysis.My area of expertise lies in Python scripting and VBA scripting, along with AWS Glue and Excel Macro, which I use to automate repetitive tasks and clean databases based on predefined rules.I create visually appealing dashboards on AWS Quicksight and Tableau Desktop to ensure that stakeholders can easily interpret and understand the data.Overall, my role involves leveraging my technical skills to streamline data management and analysis, enabling better decision-making across the organization.

As an Assistant Manager, my primary responsibilities included:Creating Excel macros to automate important reports that were otherwise time-consuming, resulting in significant time savings and improved team productivity.Generating daily, weekly, and monthly reports such as Target Vs. Achievement, Pan India Ranking, Region Wise Reports, and Pan India Budget Reports to support the management team in making informed decisions.Collaborating with cross-functional teams to ensure that the reports were accurate and delivered on time, while also addressing any data-related issues that may arise.Continuously improving the reporting process by identifying opportunities for automation, optimization, and enhancement, resulting in more efficient and effective reporting mechanisms.Overall, my role was critical in supporting the organization's strategic decision-making processes by providing accurate and timely data insights.

Created Excel macros to automate reports, saving valuable time and improving team performance.Generated daily, weekly, and monthly reports to support the Director in making informed decisions.Devised metrics and dashboards to monitor and improve performance of processing centers, area managers, and regional managers.Created engaging presentations to review the performance of branch managers, area managers, and regional managers.Ensured data-driven decision-making and optimized organizational performance in the fast-paced education industry.

Automated reports using Excel macros, saving time and improving team performance.Generated daily, weekly, and monthly reports for Sales, Collections, and Outstanding reports to support the management team.Devised metrics and dashboards to monitor and improve the performance of processing centers, Area Managers, and Regional Managers.Created engaging presentations in Microsoft Excel to review the performance of processing centers, Area Managers, and Regional Managers on a daily and monthly basis.Contributed to data-driven decision-making and optimization of organizational performance in the Portfolio and Performance department.

Improved processing center's performance by devising metrics and dashboards to monitor progress and creating presentations in Excel for daily and monthly performance reviews.Collaborated with the Line-haul Team, PC's managers, and P and E Team to coordinate efforts aimed at improving the processing center's performance.Produced performance reports in Excel on same-day intra-city shipments, high-value shipments, and high-aging shipments to further enhance processing center's efficiency.Contributed to data-driven decision-making and optimization of organizational performance in the logistics industry.