Data Analyst with 2+ years in BFSI, specializing in Power BI, SQL & Advanced Excel.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
TCS Process Associate with 2+ years of BFSI experience in Life & Pensions, KYC/AML, and operational reporting for Lloyds Banking Group. Skilled in Power BI, SQL, and Advanced Excel — certified in both and actively building data projects. Looking to leverage domain expertise and analytical skills in a Data Analyst role.
Institute of Science, Nagpur University
Bachelor of Science (B.Sc.)
August 1, 2020 – June 30, 2023
Tata Consultancy Services (TCS)
Process Associate
April 1, 2024 – Present
Nagpur, Maharashtra, India
Sales & Customer Analytics Dashboard
June 1, 2026 – Present
Built an end-to-end Power BI solution using Star Schema data model, developing 40+ DAX measures including Revenue, Profit, YTD Performance, Return Rate, and dynamic metric switching via Field Parameters. Identified Accessories as the top revenue-driving category and flagged Tires & Tubes for highest return rate — enabling targeted operational improvement decisions. Tracked 24.9M revenue and 10.5M profit across 5 interactive dashboards — revealed improved Average Order Value despite declining orders, directly supporting strategic business decisions.
View ProjectInsurance Analytics Dashboard
June 1, 2026 – Present
Built a 6-page end-to-end Insurance Analytics Dashboard in Power BI using Star Schema data model with DAX measures — analyzing 7,299 policies across Executive Summary, Regional Performance, Investment vs Maturity, Premium vs Protection, Liability Analysis, and Sales Hierarchy. Revealed ~32% premium collected vs ~67% payable exposure and identified 19%+ ROI on high-performing insurance plans — enabling early visibility into future liabilities and pricing imbalance. Benchmarked Agent, Zonal, and Regional Manager sales performance across hierarchy - delivering a single source of truth for stakeholders to monitor profitability, risk exposure, and operational efficiency.
View ProjectSOD/EOD Operational Reporting Automation
June 1, 2026 – Present
Designed and automated daily SOD/EOD operational dashboards using Advanced Excel for volume tracking and team performance. Reduced manual reporting effort and enabled real-time SLA and KPI visibility for Team Leads
Complete SQL Bootcamp (PostgreSQL)
Udemy
June 1, 2026 – Present
Microsoft Power BI Desktop for Business Intelligence
Udemy
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's personal projects demonstrate initiative and a proactive approach to skill development beyond their professional role. Their experience in the BFSI domain aligns well with roles requiring industry-specific data analysis. The breadth of skills (Power BI, SQL, Excel) and project diversity (sales, insurance, operational reporting) indicate adaptability and a willingness to tackle different analytical challenges. The focus on delivering actionable insights and improving operational efficiency suggests a results-oriented mindset.
Soft Skills & Operational Fit
The candidate demonstrates strong operational fit through their experience in automating daily reports, maintaining compliance accuracy, and training new joiners. Their ability to resolve complex queries with zero escalations and collaborate with quality assurance teams indicates good problem-solving and teamwork skills. The project descriptions are clear and highlight the business impact of their work, suggesting good communication of analytical insights.