AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Data Analyst with 6+ years in MIS Reporting & Power BI Dashboards
To obtain a challenging role that allows me to utilize my professional and technical skills to contribute meaningfully to organizational success. As MIS professional with 5.7 years of experience in reporting, has successfully managed Operations and management reporting. Hands on experience in Advanced Excel, VLOOKUP, HLOOKUP, Pivot Table and If, Nested If conditions. Expert in Excel operations like Data validation, Remove Duplicates, Advanced Filter, Goal seek. Prepare reports for various line of business on periodical basis to drive on decision making based reports. Extensively used Excel functions in developing dashboards. Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports, Sub reports and AdHoc reports. Designing the Dashboards for business overview. Exceptional communication, analytical, and project management skills Co-ordinate with other teams globally to understand business need and provide suitable MIS reporting. Implement the macro in end user environment. Design and develop Excel dashboards and reports. Using pivot tables to summarize the raw data. Analyze data and create reports in a presentable format. Visualizing the data by using pivot tables, slicers, and charts. Receiving and downloading data from different sources and Cleaning and formatting data using by Excel. A professional, innovative, creative and self-motivated team player who can guide/lead projects independently. Interacting with client directly through scheduled daily/weekly Business Conversation.
JNTUH University
B-Tech (ECE) · Electronics and Communication Engineering
August 1, 2010 – June 30, 2014
Shriram Life Insurance Pvt Ltd.
Assistant Manager-MIS Reporting
November 1, 2023 – Present
Hyderābād, Telangana, India
Insure Joy Broking Service Pvt Ltd.
MIS-Reporting
May 1, 2023 – October 1, 2023
India
Insure Joy Broking Service Pvt Ltd.
Assistant Manager - Business Analyst
May 1, 2023 – October 1, 2023
Hyderābād, Telangana, India
G Square Realtors Pvt Ltd.
Senior Executive MIS-Reporting
August 1, 2022 – April 1, 2023
Hyderābād, Telangana, India
Shriram Life Insurance
MIS Executive
May 1, 2021 – June 1, 2022
Hyderābād, Telangana, India
I Share Business Solutions (India) Pvt Ltd.
MIS Executive
November 1, 2019 – May 1, 2021
Hyderābād, Telangana, India
Latest
November 1, 2023 – June 1, 2026
Client: Shri Ram Life Insurance Pvt ltd. RESPONSIBILITY: Shri Ram Life Insurance as life insurance Selling company which is competitor to LIC and SBI Life insurance. I am a part of Ops Quality team here I will analysis the Maturity Payment's for the Day & MTD, YTD’s. And we do work mainly for reporting solution and channels wise payments & also the DO wise payments. A part from this I also handling another Project Smart Suraksha Card. This Smart Suraksha card is digital policy documents access & renewal payments access through the smart card. Mainly collecting the Raw from the CRM portal business done data for the pervious date & preparing the data into pre-defined format, this will be providing to the vendor for printing of Smart cards. Collecting dispatch details data from the vendor & share with the concern Channels & Do's. Reconciliation the data, & coordinating the vendor for invoice processing & coordinating with the accounts team for the processing of payments. Preparing the YTD, MTD reports for the business review meetings. Technologies used: Excel, Advance Excel formulas.
Previous
May 1, 2023 – October 1, 2023
Client: Insure Joy Broking Service Pvt Ltd. Insure Joy Broking Service Pvt Ltd is an Insurance broking company headquartered at the Hyderabad. This company is tie up with all insurance company in India for providing the insurance policies products selling like Health, Term, Life & Motor. This company will recruit the agents by them this will earn the revenue from the insurance companies. Technologies used: Excel. ROLE: Business Analyst: RESPONSIBILITY: Collecting the data from the CRM portals. Preparing Sales vs targets achieved by the Zones Day to Day wise & also the agent wise. Recollection of the business revenue data which will be received from the insurer company. If in case any discrepancy in the insurer data provided in it coordinating with them for rectification. Publish the Dashboards to the receptive zonal heads for further actions. Preparing the Dashboard presentations in PowerPoint.
Cultural Fit Analysis
The candidate has worked across multiple companies within the insurance and real estate sectors, indicating adaptability to different organizational environments. Their roles consistently involve MIS reporting and data analysis, aligning well with a Data Analyst position. The breadth of skills is primarily focused on Excel and basic Power BI, which might limit fit for roles requiring more diverse data tools or advanced analytical techniques. The project diversity is somewhat limited to operational reporting within specific industries.
Soft Skills & Operational Fit
The candidate demonstrates strong organizational and analytical skills through their detailed descriptions of report generation, data reconciliation, and coordination activities. Their experience in client interaction and stakeholder communication for report optimization suggests a good operational fit for roles requiring cross-functional collaboration. The resume highlights a self-motivated and team-oriented individual capable of leading projects independently.