Tapas Kumar Rout
Hyderabad,Telangana
Summary
To pursue a challenging and rewarding position where I can utilize my skills, knowledge, and dedication to contribute to enhance organizational growth while enhancing my professional capabilities and achieving career development.
Overview
9
9
years of professional experience
1
1
Certification
1
1
Language
Work History
Assistant Manager (Product Management)
American Institute of Pathology & Laboratory Sciences Pvt Ltd
2023.03 - Current
- Prepare daily, weekly, and monthly MIS reports and dashboards.
- Reconcile revenue and resolve billing discrepancies, cancellations, and refunds.
- Develop Excel reports using Pivot Tables, lookup functions, and advanced formulas.
- Monitor KPIs, analyse performance gaps, and share insights with management.
- Coordinate with Sales, Finance, Operations, and IT teams to ensure data accuracy.
- Identify and correct duplicate records, missing data, and reporting errors.
- Standardize reporting formats and campaign codes across departments.
- Analyze sales trends and performance variances for business reviews.
- Use Power BI for basic dashboards, data visualization, and KPI tracking.
- Apply basic SQL queries for data retrieval, analysis, and validation.
- Ensure timely reporting, data accuracy, and confidentiality.
BYZAN SYSTEM PRIVATE LIMITED
2021.01 - 2023.01
- Prepared and delivered daily, weekly, and monthly performance reports to clients, empowering data-driven decision-making and strategic planning.
- Extracted transformed and analyzed raw data to produce accurate and actionable MIS reports.
- Resolved customer chargebacks efficiently, ensuring timely closure within defined TAT.
- Leveraged advanced Excel functions (VLOOKUP, Pivot Tables, Charts) for high-quality data analysis and reporting.
- Maintained accuracy, timeliness and completeness in all MIS reporting activities.
- Handled multiple responsibilities simultaneously, including communication, documentation, and issue resolution
- Conducted in-depth report analysis to identify performance trends and discrepancies.
KARVY STOCK BROKING LIMITED
2018.01 - 2021.01
- Prepare and maintain daily, weekly, and monthly MIS reports for capital market operations.
- Track trade settlements, pay-in/pay-out status, shortages, and auction details also.
- Provide operational data and insights to management for decision-making.
- Ensure accuracy, timeliness, and compliance in all MIS reporting.
Education
MBA - Master of Business Administration
Andhra University
Andhra PradeshB.com - commerce
Fakir Mohan University
Intermediate
Simulia College Markona
Skills
Advanced Excel: Pivot Tables, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and advanced formulas
PowerPoint: Skilled in creating impactful and visually engaging presentations
Power BI: Interactive dashboards, data visualization, KPI monitoring, Power Query, and DAX
Operating Systems: Windows 10, Windows 11
VBA (Visual Basic for Applications): Automation of repetitive tasks in Excel
SQL (Basic): Knowledge of data querying and manipulation using SQL
Certification
AI tools workshop from BE10X
Timeline
Assistant Manager (Product Management)
American Institute of Pathology & Laboratory Sciences Pvt Ltd
2023.03 - Current
BYZAN SYSTEM PRIVATE LIMITED
2021.01 - 2023.01
KARVY STOCK BROKING LIMITED
2018.01 - 2021.01
B.com - commerce
Fakir Mohan University
Intermediate
Simulia College Markona
MBA - Master of Business Administration
Andhra University
CURRICULUM VITAE
CURRICULUM VITAE
DECLARATION
I hereby declare that the above-mentioned information is correct up to my knowledge and if given a chance, I will try my best to make your aspirations come true.