PRAFFUL SOMANI
Specialist MIS
Hyderabad,TG
Summary
Specialist MIS executive with a focus on dashboard reporting, Excel automation, and data analysis for operational and client billing workflows. Builds reports, visualizations, and management presentations that improve visibility and support process decisions. Partners with cross-functional teams, troubleshoots data issues, and delivers training on basic Excel.
Overview
9
9
years of professional experience
Work History
Sr. MIS executive
SAGILITY IND LTD.
08.2023 - Current
- Designed and maintained comprehensive dashboards and reports, leading to a 15% improvement in operational efficiency.
- Automated daily, weekly, and monthly reporting processes using advanced Excel
- Functions (e.g., PivotTables, VLOOKUP, HLOOKUP) to reduce manual effort by 10%.
- Collaborated with cross-functional teams to understand reporting needs and translate them into effective data visualizations and presentations.
- Analyzed large datasets to identify trends, inconsistencies, and opportunities for improvement, providing data-driven recommendations to management.
- Client billing(invoicing & accrual), billing hours assumption, monitoring and modification
- Troubleshot and resolved data-related issues to ensure the accuracy and integrity of all reports.
- Developed and delivered training sessions for team members on basic Excel.
Accounts receivable
HGS
09.2019 - 08.2023
- Worked in AR (Accounts Receivable) process where we worked on frontend details on claims from insurance company. Calling the payers for insurance information and patient insurance policy information.
- Working as per the denial instructions to get the claim processed
- Buddy-up with new hires to learn the process by guiding them and clearing their doubts
- Mentoring secessions to new batches in the processes
- Attending client meetings on process updates
- Rolling out updates to team
Intern
Niranjan & Co (Tax Consultants)
04.2017 - 12.2017
- Assisted in preparing tax returns using advanced accounting software and tools.
- Conducted research on tax regulations to ensure compliance and accuracy in filings.
- Supported senior consultants by organizing client documents and maintaining records efficiently.
- Collaborated with team members to streamline processes, enhancing overall workflow productivity.
Jr Accountant
Loyal LED
01.2018 - 08.2019
- Managed accounts payable and receivable processes to ensure timely transactions.
- Prepared monthly financial statements and reports for management review.
- Reconciled bank statements with company records to ensure accuracy.
- Inventory Reconciliaiton
Education
MBA - Finance
Osmania University
01-2022
B.COM - undefined
Jagruthi degree and PG college
01-2017
Skills
- MIS Reporting
- Data Analysis
- Microsoft Power BI (Visualization)
- MS Office
- Tally ERP
- Oriel
- Leadership
- Presentation
- Communication
- Client handling
- Training delivery
Timeline
Sr. MIS executive
SAGILITY IND LTD.
08.2023 - Current
Accounts receivable
HGS
09.2019 - 08.2023
Jr Accountant
Loyal LED
01.2018 - 08.2019
Intern
Niranjan & Co (Tax Consultants)
04.2017 - 12.2017
B.COM - undefined
Jagruthi degree and PG college
MBA - Finance
Osmania University