Anand R
Choolaimedu
Summary
To put my professional and committed efforts in all the ventures that I undertake and contribute my best performance to the organization for its excellence in a competitive and challenging environment.
Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
Overview
11
11
years of professional experience
Work History
MIS EXECUTIVE
NLGIC(NLGIC SUPPORT SERVICES PVT LTD
04.2023 - Current
- MIS Executive – Health Insurance
- Manage end-to-end MIS reporting for Health Insurance Claims and Management, ensuring accurate and timely delivery of daily, weekly, monthly, and quarterly reports.
- Generate TAT reports, daily claims utilization reports, claims projection reports, Pre-Approval Inward Flow reports, and Cost Band analysis to monitor operational performance.
- Perform TPA-wise claims forecasting and trend analysis to identify patterns, anticipate claim volumes, and support operational planning.
- Prepare Claim Analysis Reports and share insights with Sales Coordinators and management to support performance reviews and business reporting.
- Analyze claim volume, pending/ageing cases, approved/rejected claims, settlement status, utilization, and TAT performance to identify operational gaps and trends.
- Prepare Management MIS, dashboards, and performance reports covering claims, policies, premium, renewals, and key business KPIs.
- Conduct Loss Ratio Analysis for Group Policies, providing insights to Relationship Managers and internal management to support client strategy and portfolio performance.
- Monitor KPI, SLA, and TAT performance, highlighting exceptions, deviations, and emerging trends to relevant stakeholders.
- Investigate suspected fraudulent claims by gathering relevant evidence, reviewing case information, and supporting investigation activities.
- Generate actionable business insights and trend analysis to support operational efficiency and management decision-making.
- Coordinate with Claims, TPA, Sales, Operations, and other stakeholders for data collection, validation, analysis, and timely report closure.
- Utilize Advanced Excel including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, charts, dashboards, and data analysis techniques.
- Streamline and improve recurring MIS processes to enhance data accuracy, reporting efficiency, and turnaround time.
- Contribute process-improvement ideas and practical solutions to enhance team productivity, reporting quality, and operational outcomes.
MIS
OPPO(BRO MOBILE TRADEING PVT LTD)
07.2022 - 03.2023
- - Manage end-to-end MIS reporting for Mobile Sales Operations, covering daily, weekly, monthly, and quarterly business performance.
- - Tracked primary and secondary sales, stock availability, inventory movement, and product-wise sales performance to ensure accurate inventory management.
- - Prepare sales projections and forecasting reports based on historical trends, current sales performance, and market requirements.
- - Analyzed brand-wise, model-wise, region-wise, dealer-wise, and channel-wise sales data to identify business trends and inform performance improvement strategies.
- - Monitor sales targets, achievements, productivity, incentives, and KPIs and highlight deviations to management.
- - Prepare Management MIS dashboards and presentations to support business review meetings and decision-making.
- - Track stock aging, slow-moving products, stock-in/stock-out status, and inventory requirements.
- - Perform data consolidation, validation, reconciliation, and quality checks to ensure accuracy and reliability of MIS reports.
- - Coordinate with Sales, Finance, Operations, Warehouse, Dealers, and Regional Teams for data collection and report closure.
- - Analyze sales trends and provide actionable business insights to support sales planning and inventory management.
- - Use Advanced Excel including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, charts, dashboards, and data analysis.
- - Automate and streamline recurring reports to improve reporting accuracy, efficiency, and turnaround time.
- - Maintain standardized MIS formats, sales trackers, master data, and historical databases for management review.
SUPERVISOR(Sales,Service)
TATA PLAY
09.2020 - 07.2022
- Developed company overview for TATA SKY to enhance brand identity.
- Coordinating with Team ,Executed marketing activities to enhance customer engagement.
- Followed turnaround time for all processes to ensure efficiency.es
- Led team by leveraging leadership and problem-solving skills to streamline workflows and enhance operational efficiency.
FTA Manager
BHARTI AIRTEL LTD
08.2018 - 08.2020
- Maintained quality scores while training team members on best practices.
- Ensured compliance with regulations by reviewing documentation and processes.
- Managed turnaround time by streamlining workflow and improving efficiency.es
Junior Executive(Team Leader)&Data Entry Operator
Writer Document Service (Part Time)
09.2017 - 07.2018
Junior Executive(Team Leader)&Data Entry Operator
Cameo Corporate Services (Part Time)
08.2015 - 08.2017
- Responsible for 6 locations with each location having average of 6 to 8 team members.
- Have to maintain the collection of forms from distributors and have to maintain the forms till activation and dispatch to the warehouse.
- Organized and sorted incoming and outgoing mail for efficient communication. and both incoming and outgoing correspondence, mail, email and faxes.
Education
10th (S.S.L.C.) -
Government Higher Secondary School
Arumbakkam, ChennaiHHSC -
Government Higher Secondary School
Arumbakkam, ChennaiB.COM. CORPORATE SECRETARYSHIP -
Madras University (Batch -2018)
ChennaiSkills
- Technological involvement
- MIS reporting
- Advanced Excel
- Data analysis
- Management presentations
- Performance monitoring
- Team collaboration
- Dashboard creation
- Claims analysis
- Business reporting
- Trend analysis
- KPI tracking
Disclaimer
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
Personal Information
Languages
- Tamil
- English
Timeline
MIS EXECUTIVE
NLGIC(NLGIC SUPPORT SERVICES PVT LTD
04.2023 - Current
MIS
OPPO(BRO MOBILE TRADEING PVT LTD)
07.2022 - 03.2023
SUPERVISOR(Sales,Service)
TATA PLAY
09.2020 - 07.2022
FTA Manager
BHARTI AIRTEL LTD
08.2018 - 08.2020
Junior Executive(Team Leader)&Data Entry Operator
Writer Document Service (Part Time)
09.2017 - 07.2018
Junior Executive(Team Leader)&Data Entry Operator
Cameo Corporate Services (Part Time)
08.2015 - 08.2017
10th (S.S.L.C.) -
Government Higher Secondary School
HHSC -
Government Higher Secondary School
B.COM. CORPORATE SECRETARYSHIP -
Madras University (Batch -2018)