Arunima Rai

Advanced Data Analyst

Noida, India $50/hr Remote Full-time 2+ yrs exp 94 · Outstanding

About

Advanced Data Analyst (2+ yrs) with strong analytical skills and problem solving techniques, delivering end-to-end analytics solutions — from SQL-based data analysis and data modeling through Power BI dashboard deployment — across fintech, lending, and merchant-support (shared-services / GBS-style) environments. Delivers 100% audit-traceable reporting, a 20% reduction in issue resolution time, and zero unresolved data-quality discrepancies by enforcing rigorous data quality frameworks and governance standards. Partners closely with stakeholders on stakeholder management and requirement gathering, and drives process improvement and change management to ensure solutions stay stable, scalable, and adopted post-deployment while consistently meeting business objectives. Uses AI prompting (ChatGPT, Claude, Gemini) to accelerate development end to end.

Skills & Expertise (26)

Claude Intermediate

8.0/10

Years Exp

Google Gemini Intermediate

8.0/10

Years Exp

ChatGPT Intermediate

8.0/10

Years Exp

Power BI Advanced

7.8/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Apache Superset Intermediate

7.5/10

Years Exp

Excel Advanced

7.5/10

Years Exp

Advanced SQL Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Google Sheets Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

MySql Intermediate

7.0/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Stakeholder Management Intermediate

6.5/10

Years Exp

Requirement gathering Intermediate

6.5/10

Years Exp

Process Optimization Intermediate

6.5/10

Years Exp

Jupyter Notebook Intermediate

6.5/10

Years Exp

Snowflake Intermediate

6.0/10

Years Exp

SciPy Intermediate

6.0/10

Years Exp

data quality frameworks Intermediate

6.0/10

Years Exp

workflow tools Intermediate

6.0/10

Years Exp

Change Management Intermediate

6.0/10

Years Exp

SAP HANA GitHub Copilot SQL (Data Extraction & Queries) Microsoft PowerPoint and Power Bi

Work Experience

Team Lead, Data Analyst

Paytm

Dec 2024 - Present

Own end-to-end analytics delivery across 6+ merchant-support data streams (Bot, IVR, AI IVR, Ticket, Email, Social, Chat) — from SQL-based data modeling through Power BI dashboard deployment — establishing a single source-of-truth data governance framework that delivers zero unresolved audit discrepancies every quarter. Act as a trusted analytics partner to product, operations, and leadership stakeholders — gather requirements and translate ambiguous business questions into structured KPI/scorecard data models, driving adoption through hands-on change management. Re-architected SQL (Starburst) data models to cut merchant issue resolution time by 20%, and designed a unified Power BI/Apache Superset scorecard suite (TAT, CSAT, FCR, FRT, Churn, Aging) for real-time data visualization, replacing fragmented reporting. Apply AI prompting (ChatGPT, Claude, Gemini) to accelerate dashboard development and automate issue-intent classification, cutting the executive cross-channel reporting cycle to under 60 seconds. Lead process improvement initiatives with data engineering to rebuild broken source-to-report pipeline logic — reclaiming 10+ hours/week through report automation (Easy Report, Excel/Microsoft Office) and improving reporting reliability org-wide.

Business Analyst (Consultant)

Cars24

Sep 2024 - Nov 2024

Analyzed loan portfolio performance for Loans24 (Cars24 Financial Services Pvt. Ltd.), an RBI-registered NBFC — built Snowflake SQL-based creditworthiness segmentation and default-risk scoring models across used-car loan, loan-against-car, and personal loan portfolios to flag which borrower segments carried the highest risk. Investigated gaps between approval-rate, default-rate, and loan-performance figures across source systems and reports — reconciled every discrepancy end-to-end via Tableau dashboards and Google Sheets scorecards, giving stakeholders one trusted view of portfolio health.

Data Analyst Intern

Jio

Jun 2024 - Aug 2024

Investigated retail performance trends for Reliance Smart Point (neighborhood retail & last-mile delivery format) and Tira (Reliance's beauty & cosmetics retail chain) — queried large-scale SAP HANA datasets to identify the merchandising and operational patterns driving store-level performance. Translated those findings into Power BI dashboards and Excel-based reports, giving cross-functional retail teams a clear, stakeholder-ready view to guide merchandising and operational decisions.