Rambabu Rs

MIS and Reporting professional with 8 years of experience in MIS Reporting, Advanced Excel, Google Sheets, Dashboard Development, Data Analysis and Management Reporting, along with 1 year of hands-on experience in Power BI. Experienced in preparing daily, weekly and monthly MIS reports, KPI dashboards, data validation, reconciliation, data consolidation and ad-hoc reports. Skilled in transforming raw data into meaningful reports and dashboards to support business decision-making.

Strong experience in Advanced Excel, Google Sheets, Power Query, Power BI, DAX, SQL and MS Access.

Sr. Mis Executive - Anion Healthcare Services LLP

(2023-06)

• Collected, managed, and securely stored healthcare data while ensuring compliance with privacy regulations such as HIPAA.
• Analyzed healthcare data to generate insights that support decision-making, improve patient care, and streamline operations.
• Developed and generated management reports covering financial, operational, and clinical data to support informed decisions.
• Tracked the performance of healthcare IT systems and ensured adherence to defined Service Level Agreements (SLAs).
• Provided regular updates and reports on IT performance, system updates, data analytics, and operational efficiencies.
• Monitored and enforced cyber security protocols to protect patient data and prevent unauthorized access.
• Identified potential risks related to data integrity, IT systems, or compliance, and worked on mitigation strategies.
• Ensured secure access controls and monitored user activity to prevent data breaches.
• Developed Power BI dashboards and interactive visualizations to track KPIs, analyze performance, and communicate insights to stakeholders.
• Automated recurring MIS reports by implementing Excel formulas, standardized formats, and reporting templates, reducing manual reporting effort and improving overall team productivity and production output.

Sr. Mis Executive - KFin Technologies Ltd

(2022-05 - 2023-06)

• Prepared daily, weekly, and monthly MIS reports using Microsoft Excel.
• Managed and analyzed large datasets with high accuracy, performing regular data validation and reconciliation.
• Created dashboards and reports using Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, and advanced Excel formulas.
• Generated management reports to support business decision-making and monitored KPIs.
• Coordinated with internal departments to collect and consolidate business data, resolving any data discrepancies.
• Automated repetitive reporting tasks using Excel macros and VBA, improving efficiency.
• Maintained databases, updated records on a timely basis, and performed data cleaning, sorting, filtering, and formatting.
• Assisted in preparing audit-related reports and documentation while maintaining the confidentiality of sensitive information.

Mis Executive - Adani Wilmar Ltd

(2017-08 - 2022-04)

• Prepared daily, weekly, and monthly sales reports, generating MIS reports for sales performance, primary sales, and secondary sales analysis.
• Consolidated sales data from regional teams and maintained distributor, retailer, and customer master data with high accuracy.
• Tracked sales targets versus achievements, prepared variance reports, and analyzed product, region, territory, and salesperson performance.
• Prepared stock movement, inventory, and dispatch reports, monitoring order processing and delivery timelines.
• Coordinated with Sales, Logistics, Warehouse, and Finance teams to ensure smooth operations.
• Created interactive dashboards using Microsoft Excel features including Pivot Tables, Charts, Slicers, and advanced formulas.
• Automated recurring MIS reports using Excel formulas and VBA macros where applicable.
• Prepared monthly incentive and sales achievement reports, monitored outstanding orders, returns, and claims, and generated follow-up reports.

MBA - Finance & HR - Dravidian University, Kuppam (2008-05 - 2010-08)

B.A. - History - TRR Govt Degree College, Kandukur (2003-06 - 2005-03)

Intermediate - MPC - TRR Govt Jr. College, Kandukur (2000-05 - 2002-03)

SSC - Govt ZPH School, Ponnaluru (1999-06 - 2000-03)