Vicky
Mohali
Summary
I am wishing to obtain an entry level position in an office environment where I can utilize my pre-existing skills in computing, database management and business intelligence and gain experience of working as part of a team.
Overview
8
8
years of professional experience
Work History
Mis Executive
Atulaya Healthcare Private Limited
06.2025 - Current
- Designed, maintained, and automated daily/weekly/monthly MIS reports and dashboards to track business KPIs.
- Collected, cleaned, and analyzed large data sets from multiple sources to support management decisions.
- Developed customized Excel reports and dashboards for department heads to improve visibility of key metrics.
- Automated repetitive reporting tasks using advanced Excel, Power Query, and macros, reducing manual effort.
- Created pivot tables, VLOOKUP, HLOOKUP, and complex Excel formulas to generate actionable insights.
- Prepared variance analysis, sales forecasting, and trend analysis reports for senior management.
- Supported management in decision-making by presenting concise and visualized data reports.
- Coordinated with cross-functional teams (Finance, Sales, Operations) to gather requirements and standardize reporting formats.
MIS Executive
Krsnaa Diagnostics Pvt. Ltd.
06.2023 - 06.2025
- Managed daily, weekly, and monthly MIS reports on patient registrations, diagnostic tests, billing, and revenue for diagnostic management.
- Designed, maintained, and automated daily/weekly/monthly MIS reports and dashboards to track business KPIs.
- Compiled and analyzed data from LIS (Laboratory Information System) to monitor operational performance, TAT (turnaround time), and quality indicators.
- Ensured data accuracy and timely availability of reports for management reviews.
- Created pivot tables, VLOOKUP, HLOOKUP, and complex Excel formulas to generate actionable insights.
- Provided ad-hoc analytics on high-value tests, revenue leakages, referral patterns, and operational bottlenecks.
- Prepared variance analysis, sales forecasting, and trend analysis reports for senior management.
Back Office and MIS Executive
Excel Agencies Pvt. Ltd.
10.2020 - 06.2023
- Managed and maintained daily MIS of customer accounts, overdue payments, and collection status for multiple portfolios (credit cards, personal loans, etc.).
- ·Prepared and circulated daily/weekly/monthly reports on bucket-wise collections, recovery percentages, and agent productivity.
- ·Coordinated with field and call-center collection teams to capture updated contact details, payment status, and promises-to-pay (PTP).
- ·Maintained and updated master data of borrowers, allocation of accounts to agents, and their collection performance metrics.
- Data downloading. Processing, cleaning & formatting
- Handling multiple reports, working with formula, pivot table, pivot chart & various others excel sheets components for accurate data.
Cashier/CRO
Quess Corp, Idea Cellular Limited
10.2017 - 06.2020
- Handled walk-in customer queries, complaints, and requests related to new connections, plan changes, and bill payments.
- Processed cash, cheque, card, and online payments for postpaid bills, prepaid recharges, and device sales with 100% accuracy.
- Balanced and reconciled daily cash and credit transactions at the end of each shift; prepared deposit slips for bank submission.
- Assisted customers in activating SIM cards, mobile number portability (MNP), and verifying KYC documents as per TRAI/DOT guidelines.
- Generated daily/weekly MIS reports on cash collections, bill payments, and service activations for management.
- Maintained accurate records of customer interactions, payments, and service requests in CRM systems.
- Upsold and cross-sold new plans, add-on services, and devices to walk-in customers, meeting or exceeding monthly sales targets.
- Trained new counter staff on payment systems, KYC norms, and customer handling procedures.
Education
Bachelor of Art -
Panjab University
01.2011
Computer Operator and Programming Assistant -
ITI
Chandigarh01.2009
12th - undefined
G.M.S.S School Sedor-8
01.2008
10th - undefined
Govt High School
Sector-11, Chandigarh01.2006
Skills
- MS WORD- (Mail Merge), MS POWER POINT, MS OUTLOOK EXPRESS
- MS EXCEL-VLOOKUP, HLOOKUP, Pivot, Charts, Advanced excel, IF functions, Power Query, Macros
- Data analytics
Hobbies and Interests
Listening Music & Watching Movies, Cooking, Sketching
Hobbies
• ·Listening Music & Watching Movies
• ·Cooking
• Sketching
Timeline
Mis Executive
Atulaya Healthcare Private Limited
06.2025 - Current
MIS Executive
Krsnaa Diagnostics Pvt. Ltd.
06.2023 - 06.2025
Back Office and MIS Executive
Excel Agencies Pvt. Ltd.
10.2020 - 06.2023
Cashier/CRO
Quess Corp, Idea Cellular Limited
10.2017 - 06.2020
12th - undefined
G.M.S.S School Sedor-8
10th - undefined
Govt High School
Bachelor of Art -
Panjab University
Computer Operator and Programming Assistant -
ITI
Similar Profiles
Vishal GoyalVishal Goyal
Assistant General Manager at Atulaya Healthcare Private LimitedAssistant General Manager at Atulaya Healthcare Private Limited
RAMAN KUMARRAMAN KUMAR
Laboratory Technician at Atulaya HealthcareLaboratory Technician at Atulaya Healthcare
B Hemanth KumarB Hemanth Kumar
Senior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limitedSenior Ar Caller at U.S Medical billing, Visionary Rcm Infotech India Pvt Ltd, Omega Healthcare private limited and Access Healthcare private limited
NITIKA AMBARDARNITIKA AMBARDAR
Senior Renewals Strategist at ZscalerSenior Renewals Strategist at Zscaler
Amit KumarAmit Kumar
Chief Sales Manager at QServices IT Solutions Pvt. Ltd.Chief Sales Manager at QServices IT Solutions Pvt. Ltd.