Rahul Pal
Mumbai
As a data analyst with over five years of experience, I approach challenges with a pragmatic and logical mindset, driven by a strong sense of accountability. My ambition fuels my continuous curiosity to explore new solutions, and I thrive in collaborative environments where flexibility allows us to adapt and achieve shared goals.
Experience
Consultant Data Analyst
Omnino Solutions Private Limited · Jan 2023 – Present
- Analyzed BRDs and collaborated with stakeholders to understand business requirements and functional specifications.
- Developed interactive Power BI dashboards to monitor key insurance KPIs, including Premium Collection, Claims, Policy Issuance, Customer Retention, and Business Performance, enabling data-driven decision-making.
- Designed and implemented Star Schema data models by creating relationships between fact and dimension tables, improving data organization, query performance, and report scalability.
- Extracted, analyzed, and validated insurance data using SQL, ensuring accuracy and consistency across policy, claims, and transaction datasets.
- Performed data cleaning, profiling, and validation using Advanced Excel and SQL to identify missing values, duplicates, and data inconsistencies before reporting.
- Built and maintained Power BI data models and developed DAX measures for KPIs, trend analysis, and executive reporting.
- Created automated dashboards and recurring MIS reports using Power BI and Excel, reducing manual reporting efforts and improving reporting efficiency.
- Analyzed policy lifecycle data, including New Business, Premium Collection, Lapse, Paid-up, Surrender, Maturity, and Claims, to identify business trends and operational insights.
- Gathered business requirements from stakeholders and documented them into BRDs and FRDs, ensuring alignment between business objectives and technical implementation.
- Utilized Advanced Excel functions, including Pivot Tables, XLOOKUP/VLOOKUP, IF, Conditional Formatting, and Data Validation, to prepare analysis-ready datasets.
- Supported business teams with actionable insights through dashboard reporting, KPI tracking, and operational performance analysis.
QA Analyst
Harjai Computers · Jan 2022 – Jan 2023
- Designed and executed test scenarios and test cases for Life Insurance applications, ensuring complete functional and business requirement validation.
- Performed end-to-end testing of ULIP, Traditional, Term Plans, and critical transactions including Policy Issuance, Premium Payment, Surrender, Fund Switch, FPR, and Claims.
- Automated MIS reports using Advanced Excel (Pivot Tables, XLOOKUP/VLOOKUP, IF), improving reporting efficiency and reducing manual effort.
- Built Power BI dashboards and performed SQL-based data validation to monitor testing metrics, data quality, and business performance.
QA Analyst
Sirpi Data Science · Jul 2021 – Jan 2022
- Performed functional, regression, and integration testing using Selenium with Java, ensuring application quality and business requirement compliance.
- Utilized SQL, Advanced Excel, and JIRA for data validation, defect tracking, test execution, and reporting while collaborating with cross-functional teams.
- Maintained test documentation, supported Agile release activities, and contributed to improving testing efficiency through accurate analysis and process adherence.
Skills 0 proven through work
Also works with
Proof of Work
Proof of Work
Rahul shares this with people who ask. You'll hear back either way.
Education
Master of Computer Applications, MCA
Savitribai Phule Pune University · 2021 — 2021
Contact details
Contact details
Rahul shares this with people who ask. You'll hear back either way.
What drives their work
The Architect
You design robust systems and frameworks that ensure stability and scalability.
Rahul's superpower
You excel at structuring complex data and processes into scalable, efficient systems that drive clear insights and reliable operations.
How Rahul works
You thrive in teams focused on building robust, scalable data and automation solutions that directly impact business decision-making.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal