RP

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.

Open to

Mumbai

Work style

onsite, remote, hybrid

Identity verified by DigiLocker
Contact details — on requestProof of Work — on request

Experience

O

Consultant Data Analyst

Omnino Solutions Private Limited · Jan 2023 – Present

Not yet confirmed
  • 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.
H

QA Analyst

Harjai Computers · Jan 2022 – Jan 2023

Not yet confirmed
  • 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.
S

QA Analyst

Sirpi Data Science · Jul 2021 – Jan 2022

Not yet confirmed
  • 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

Life Asia UsageOn-time DeliveryWeb Element IdentificationRoot Cause AnalysisDatabase ManagementData VisualizationGoal AchievementAttention to DetailProject ExecutionBusiness AcumenTechnical UnderstandingSoftware Quality AssuranceTechnical Knowledge SharingTeamworkTaking OwnershipEffective CommunicationAdaptabilityWork Planning and PrioritizationXPath Locator StrategyDynamic UI Synchronization HandlingTest Automation Framework DesignTestNG Framework UsageFailure Mode AnalysisError HandlingIntegration TestingCode ReusabilityAutomation Test DevelopmentRegression TestingFunctional TestingJava DevelopmentSelenium Test AutomationAutomated Report GenerationJira UsageDefect TrackingSystem TestingPostgreSQL Database UsageTest DocumentationTest Case EvaluationFact Table DesignStar Schema DesignMicrosoft ExcelStakeholder Communication AdaptationDrill-through ReportingSegmented Performance AnalysisTime Series Trend AnalysisDashboard UI DesignDAX Expression DevelopmentData ModelingData TransformationTabular Data Cleaning & ValidationData ValidationSQL ProgrammingData ExtractionRequirements AnalysisKPI AnalysisPower BI

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 — Builds what holds

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