Assistant Manager - Bajaj Allianz Life Insurance
(2022-05)
- Developed the UAT Test cases and executed them with the flow of the Project.
- Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR).
- Participated in regular project status meetings related to testing.
- Created and executed the SQL Queries to validate the Database.
- Improved data extraction process efficiency by 70% through automation, reducing manual effort.
- Perform analysis for monthly/quarterly discussion with stakeholders & highlights actionable insights and share recommendations.
- Work with various stakeholders across the business verticals to ensure Business Metrics and functional user requirements are clearly defined, delivered, and approved for deployment.
- Good knowledge of Power Point, Canva, Draw.io, Chat GPT etc. to create visualized storytelling and informative presentations. Experience in creating Dashboards, Business hierarchy roadmaps, PDF documents and WhatsApp's templates also.
- Regularly review the existing processes and enhance the efficiency within the team. Document the Standard Operating Procedures etc.
Data Analyst - Aviva Life Insurance
(2019-09 - 2022-05)
- Work with Business Insight team to understand and analyse business processes, requirements and developed predictive excel models for sales forecasting.
- Design & develop the construct for Incentives & get it approved from the concerned stakeholders.
- Developed daily Reports / Dashboards with key insights using VBA, Macro, and SQL. This resulted in efficient data collection and a 70% reduction in turnaround time.
- Familiar with charts and functions like (List box, Pivot Charts-Tables, Lookups, Index-Match, Logical, Slicers, Conditional formatting etc.)
- Prepare and analyse payout data for employee's who is eligible for Monthly, Quarterly, Yearly for Incentives, Contest, Business allowance and Bonus as well.
- Collaborate with cross-functional teams including Business Insight, HR for employee's promotion, Finance for budget or cost and IT team to smooth inflow/outflow of data to reduce data processing time by 20%.
Data Analyst - Max Bupa Health Insurance
(2017-10 - 2019-09)
- Managed Banca Channel including HDFC, Federal, Bank of Baroda, South Indian, Standard Chartered, Bajaj Finance, Deutsche Bank, Sarva U.P. Gramin, Karur Vysya Banks and NBFC also.
- Transformed large and complex data into clear and relevant data with the help of SQL and applied data analysis techniques to identify key patterns and trends and presented them in attractive dashboard for strategic planning.
- Designed and automated management, business, and ad-hoc reports using VBA, Macro, and SQL.
- Prepare and analyse monthly, quarterly, and annual business payouts of sales employees.
- Design Power Point templates for Incentive, R&R and Goal Sheets to Channel Head for approval.
- Coordinate with Finance, IT, HR team to ensure that all the issues related to incentives, R&R and Goal Sheets are resolved and payout, promotion and rewards is disbursed timely.
Operation Executive - Mattsenkumar Services Pvt. Ltd.
(2016-05 - 2017-05)
- Worked in Barclays Bank process, which provides a wide range of financial products and services.
- Create and maintain work roster of Quality Consultant and Quality Analyst.
- Design Dashboards, reports and share the relevant reports with senior management.
- Performing impact analysis for Workday, providing a detailed plan for completion, and executing tasks of Quality Consultant and Quality Analyst.
- Prepare weekly and monthly Quality dashboards on incoming customer service, outbound lead generation calls of the agents.
