Back to Developers
Saransh Sharma

Saransh Sharma

Data Analyst

Mohali, Punjab 2+ yrs exp 86 ยท Excellent

About

Data Analyst with 2.8+ years of experience turning raw, multi-source data into business-ready insights for a US-based FinTech client. Writes complex SQL (CTEs, window functions, multi-table joins), builds and maintains 10+ BI dashboards across 30+ KPIs for 20+ stakeholders, and owns ETL and data-validation processes end-to-end. Ranked 1st of 50 in a rigorous analytics internship covering Excel, SQL, Python, and Tableau. Comfortable working independently in a remote, cross-functional environment and translating business questions into clean, accurate reporting.

Skills & Expertise (22)

SQL Advanced
8.5/10
3
Years Exp
Apache Superset Intermediate
7.2/10
1
Years Exp
stakeholder communication Intermediate
7.0/10
3
Years Exp
Pandas Intermediate
7.0/10
2
Years Exp
Python Intermediate
7.0/10
3
Years Exp
Advanced Excel Intermediate
7.0/10
3
Years Exp
Business Reporting Intermediate
7.0/10
3
Years Exp
Data Validation Intermediate
7.0/10
3
Years Exp
Forecasting Intermediate
7.0/10
3
Years Exp
Data Cleaning Intermediate
7.0/10
3
Years Exp
ETL Intermediate
7.0/10
2
Years Exp
Statistical Analysis Intermediate
6.5/10
3
Years Exp
Tableau Intermediate
6.5/10
2
Years Exp
MySql Intermediate
6.5/10
2
Years Exp
Power BI Intermediate
6.5/10
2
Years Exp
NumPy Intermediate
6.5/10
2
Years Exp
QA Intermediate
6.0/10
3
Years Exp
Google Sheets Intermediate
6.0/10
3
Years Exp
Google Workspace Intermediate
6.0/10
3
Years Exp
Slack Intermediate
5.0/10
3
Years Exp
GitHub Intermediate
5.0/10
2
Years Exp
Asana Intermediate
5.0/10
2
Years Exp

Work Experience

Data Analyst (AI-Enabled)

LNP Infotech

Dec 2023 - Present

Own SQL and BI reporting end-to-end: write complex SQL (CTEs, window functions, multi-table joins) and build/maintain 10+ Apache Superset dashboards across 30+ KPIs for 20+ stakeholders. Validate data accuracy through SQL-based reconciliation checks across reporting layers, catching 20โ€“50 discrepancies per quarter before they reach stakeholders. Design and maintain ETL pipelines across Snowflake, AWS S3, and Google Sheets for cross-system data cleaning and reconciliation, cutting manual reporting effort by ~60%. Built a loan-pipeline forecasting model using 4+ years of historical data to predict daily application inflow and stage-wise conversion, supporting proactive resource planning for finance's monthly close. Built an on-demand ETL pipeline pulling property/title data via API for loan underwriting, processing 100+ records per week for the capital markets team โ€” a net-new reporting capability. Aggregate and analyze multi-channel CSAT/NPS data into retention analytics, surfacing satisfaction and risk trends for leadership in BI dashboards. Automate tracking of 500+ monthly compliance notices against regulatory deadlines, with at-risk alerting to prevent missed reporting windows. Automated extraction and validation of financial data (income statements, trust deeds) from unstructured PDFs using Python and OCR, reducing manual audit effort by 60%. Partner directly with operations, compliance, and engineering teams to gather requirements and turn them into accurate, decision-ready reports and dashboards. Document analysis workflows and standardize metric definitions across reporting layers to support consistency and knowledge transfer.

Data Analytics Intern

Trainity

May 2023 - Sep 2023

Completed 8 hands-on analytics projects spanning Excel (pivot tables, formulas), MySQL, Python, and Tableau. Ranked 1st among 50 participants with a perfect leaderboard score of 290/290.

Education

B.Tech in Electrical Engineering - University Institute of Information Technology

2019 - 2023 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 11/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 86/100

Profile Overview

Member sinceJul 2026

Availability Details

Relocation

Depends on Offer