Management Information System Executive
CurrentDeveloped and maintained comprehensive MIS reports and dashboards, analyzing Subway Stores' data to reconcile, identify trends, missing values, and forecast performance. Key accomplishments include: - _Automated Reporting_: Reduced report generation time by 40% and increased data accuracy by automating routine reporting process by using power query and macros - _Manager Performance Analysis_: Analyzed sales performance, including tips and oversales, for Subway Stores managers. - _Collaborative Approach_: Collaborated closely with sales teams to customize reports, enhancing data relevance and usability. - _MIS Dashboard Development_: Created daily, weekly, and fortnightly dashboards, providing stakeholders with timely and actionable insights, such as void and refund reports. - _Database Management_: Managed database responsibilities, ensuring data accuracy and integrity. - _Incentive Calculation_: Calculated performance incentives for employees and recognition scores, contributing to a motivating work environment. Technical Skills: - MIS reporting and dashboard development - Data analysis and visualization - Database management - Automation of reporting processes - Reconciliation of transactions made in stores - Advanced Excel (VLOOKUPs, SUMIFS, conditional formatting, macros, and pivot tables) Soft Skills: - Collaborative approach - Strong analytical and problem-solving skills - Effective communication and presentation skills (with experience communicating with US clients and managers) - Ability to work under pressure and meet deadlinesTop 5 key skills:Sql, Advanced Excel( VLOOKUP, SUMIF)
