Prasanna Kodukula

MIS Analyst with 6 years of experience in MIS reporting, data management, and dashboard development across BPO and recruitment operations, including Talent Acquisition support. Strong in Advanced Excel (Pivot Tables, VLOOKUP, XLOOKUP, IF formulas, conditional formatting, data validation) with experience preparing recruitment MIS reports, master trackers, and management dashboards covering open positions, candidate pipelines, interviews, offers, joiners, and onboarding. Skilled in validating data across trackers, identifying and resolving discrepancies, following up with HR and stakeholders, and meeting strict reporting deadlines.

Working knowledge of Power BI, SQL, and Excel-based reporting automation.

MIS Analyst at Inspiredge IT Solutions Pvt Ltd (2022-02 – 2026-06)

• Managed and maintained recruitment and operational data for MIS reporting, keeping trackers accurate and up to date.
• Collected, consolidated, and validated data from multiple sources, including HR, Operations, and vendor systems, to ensure accuracy and consistency across trackers and reports.
• Prepared daily, weekly, and monthly MIS reports and master trackers for management, HR, and operational teams.
• Developed and maintained dashboards and trackers to monitor performance, pending actions, and turnaround times.
• Utilized Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, SUMIFS, COUNTIFS, Power Query, data validation, conditional formatting) for data analysis and reporting.
• Automated recurring reports using Excel and Power Query, reducing manual effort and improving turnaround time.
• Maintained attendance, adherence, shrinkage, and workforce-related trackers, following up on pending updates to meet defined timelines.
• Performed data reconciliation, identified discrepancies, and resolved them by coordinating with Operations, HR, and other departments to keep trackers and reports consistent.
• Created KPI reports and dashboards to support business reviews, trend analysis, and management decision-making.
• Prepared SOPs and reports for audits and process compliance, and maintained supporting documentation.
• Handled ad hoc reporting requests and provided data analysis based on business requirements.
• Communicated with cross-functional stakeholders to gather and update reporting data, track pending actions, and meet strict deadlines.

MIS Analyst at Technosoft Pvt Ltd (2021-07 – 2022-01)

• Prepared and maintained daily, weekly, and monthly recruitment MIS reports and trackers for recruitment and operational teams.
• Developed Excel dashboards using Pivot Tables, Charts, and Slicers for management reporting on recruitment activity.
• Automated routine reporting activities using Excel formulas and macros.
• Generated ad hoc reports and analysis for stakeholders based on business needs.
• Maintained recruitment and onboarding records, employee data, timesheets, and Background Verification (BGV) status reports, following up on pending items.
• Ensured data accuracy and timely submission of reports to management; validated data consistency across trackers.

MIS Executive at Inspiredge IT Solutions Pvt Ltd (2016-03 – 2017-11)

• Prepared and distributed periodic MIS reports and performance summaries for senior management.
• Analyzed operational data and identified performance trends that supported process improvement initiatives.
• Maintained reporting systems, databases, and ensured consistent data accuracy and integrity.
• Managed backend operations, data entry, and regular data backups to maintain business continuity.

Master of Computer Applications (M.C.A.) – BVC College of Engineering and Technology (2015)