Available for Opportunities

Ritik Nipane

Data Analyst | Turning Complex Data into Actionable Intelligence

Scroll
📉Reduced Discrepancies25%•
💰Annual Savings₹5 Lakh•
📦SKUs Centralized5,000+•
⚡Efficiency Improved20%•
📊Dashboards Built15+•
🎯Risk Accuracy+15%•
🏭Overstocking Reduced15%•
👥Teams Empowered50+•
📉Reduced Discrepancies25%•
💰Annual Savings₹5 Lakh•
📦SKUs Centralized5,000+•
⚡Efficiency Improved20%•
📊Dashboards Built15+•
🎯Risk Accuracy+15%•
🏭Overstocking Reduced15%•
👥Teams Empowered50+•
📉Reduced Discrepancies25%•
💰Annual Savings₹5 Lakh•
📦SKUs Centralized5,000+•
⚡Efficiency Improved20%•
📊Dashboards Built15+•
🎯Risk Accuracy+15%•
🏭Overstocking Reduced15%•
👥Teams Empowered50+•
// About

Data-Driven
Decision Maker

2+
Years Experience
15+
Dashboards Built
5K+
SKUs Managed
₹5L
Cost Savings

Data Analyst with 2+ years specializing in financial, operational, and supply chain risk analysis. I transform raw, complex datasets into strategic intelligence that drives measurable business outcomes.

Experienced in Python, MySQL, and Excel for cleaning, modeling, and analyzing large datasets. Skilled in building dashboards that identify risk patterns, detect anomalies, and support strategic decision-making.

PythonMySQLPower BITableauPandasLooker
ritiknipane456@gmail.com
// Experience

The Data Pipeline

A career journey where each role fed insights forward — like data flowing through a processing pipeline.

Apr 2024 – Present
Mumbai, India
PythonPower BILookerMySQL
Current Role

Data Analyst

BTIPL

  • 💹Built automated dashboards for revenue, expenses, cash flow & P&L — enabling early detection of loss-making months.
  • 🔍Developed Expense Tracking System that cut financial discrepancies by 25% and identified cost leakages across logistics and warehousing.
  • 🌍Analyzed supplier risk across Japan, China & Europe — tracking pricing trends, lead times, and duty fluctuations. Result: ₹5 Lakh annual savings.
  • 📦Inventory Risk Analysis using 1Y/6M/3M sales trends for MSQ, Safety Stock, and reorder levels — reducing overstocking by 15%.
  • 🎯Centralized 5,000+ SKUs in a Bearing Stock & Sales Monitoring Dashboard, cutting manual tracking errors by 20%.
  • 👥Standardized reporting systems empowering 50+ employees across sales, purchase, and finance teams.
Strategy Intern

Strategy Intern

Liquiloans

  • 📊Developed 5 risk & performance monitoring dashboards using Power BI, Looker Studio, Excel & Python for portfolio trend analysis.
  • 🏅Built a unified Gold Loan Risk Dashboard — improving operational risk efficiency by 20%.
  • 🔎Analyzed corporate & IFA historical data to identify risk patterns and default trends, improving risk assessment accuracy by 15%.
  • ⚙️Streamlined data flows with cross-functional teams, contributing to a 10% reduction in operational turnaround time.
Nov 2023 – Feb 2024
Mumbai, India
Power BILookerPythonExcel
Jun 2023 – Nov 2023
Mumbai, India
PythonMySQLLookerExcel
Data Science Intern

Data Science Intern

FlipRobo

  • 🧮Analyzed financial data using Python, MySQL, Looker & Excel — driving insights that boosted operational efficiency by 15%.
  • ⚙️Configured and enhanced finance modules within Workday, improving module accuracy by 95%.
  • 🔗Collaborated with cross-functional teams to optimize data workflows, reducing processing errors by 20%.
// Skills

Technical Arsenal

Languages
PythonMySQLSQL (Intermediate)
Frameworks & Libraries
PandasMatplotlibSeabornScikit-learn
BI & Visualization Tools
Power BITableauLooker StudioGoogle Sheets
Core Competencies
Risk AnalysisFinancial ModelingSupply Chain AnalyticsExcel
// Projects

Featured Work

Real-world data solutions built to reduce risk, cut costs, and drive strategic growth.

🌐BTIPL — Operational Risk
01

Supply Chain Risk Intelligence

End-to-end supply chain risk dashboard tracking import pricing trends, lead times, shipment delays, and duty fluctuations across suppliers in Japan, China, and Europe.

₹5L Saved25% Fewer Errors3 Regions
PythonPower BIMySQL
Explore Project
analytics.btipl.com/proj1
₹5L
Saved
25%
Fewer Errors
3
Regions
Trend AnalysisLive
Risk Score
72 / 100
Data Quality
94 / 100
📦BTIPL — Inventory Analytics
02

Inventory & Stock Optimizer

Centralized 5,000+ bearing SKUs with automated MSQ, Safety Stock, and reorder level calculations using 1Y/6M/3M sales trend analysis. Cut overstocking by 15%.

5K+ SKUs15% Less Overstock20% Error Reduction
ExcelPythonLooker
Explore Project
analytics.btipl.com/proj2
5K+
SKUs
15%
Less Overstock
20%
Error Reduction
Trend AnalysisLive
Risk Score
72 / 100
Data Quality
94 / 100
🏅Liquiloans — Credit Risk
03

Gold Loan Risk Dashboard

Unified Gold Loan Risk Dashboard providing visibility into credit risk indicators, IFA performance profiles, and portfolio-wide anomaly detection for strategic risk mitigation.

20% Efficiency Gain15% Better Accuracy5 Dashboards
Power BILookerPython
Explore Project
analytics.btipl.com/proj3
20%
Efficiency Gain
15%
Better Accuracy
5
Dashboards
Trend AnalysisLive
Risk Score
72 / 100
Data Quality
94 / 100
💹BTIPL — Financial Analytics
04

Financial P&L Automation

Automated revenue, expense, cash flow, and P&L dashboards for early detection of loss-making months, cash shortages, and margin risks across product segments.

50+ UsersReal-time AlertsMargin Insights
Power BIExcelPython
Explore Project
analytics.btipl.com/proj4
50+
Users
Real-time
Alerts
Margin
Insights
Trend AnalysisLive
Risk Score
72 / 100
Data Quality
94 / 100
// Education & Certifications

Built on Knowledge

B.Sc. Information Technology

University of Mumbai

CGPA: 7.3 • Mumbai, India

Relevant Coursework

Machine Learning
Data Structures & Algorithms
Data Visualization
Data Science

Certifications

IBM Python for Data Science
IBM
Data Analytics & Visualization
Accenture
SQL (Intermediate)
HackerRank
Microsoft 365 Certified
Microsoft
Data Science Certification
Industry
Data Analysis using Excel
Industry
// Contact

Let's Build
Something Impactful

I'm actively looking for the next big challenge. If you need someone to transform your data into competitive advantage, let's talk.

ritiknipane456@gmail.com+91 9082116054