Summary
Overview
Work History
Education
Skills
Projects
Most Proud Of
Timeline
Generic

RUPALI MANE

Pune

Summary

Results-oriented professional with 2 years of experience in Data Analyst and 3 years in the Financial Industry, specializing in leveraging data-driven insights to improve business performance. Leveraged SQL and Power BI to streamline data cleaning and visualization processes, improving efficiency by 35%. Gained experience across e-commerce and healthcare industries, consistently receiving recognition for data-driven decision-making.

Overview

6
6
years of professional experience

Work History

ANALYST

DEUTSCHE INDIA PVT LTD
Pune
08.2022 - Current
  • Engaged clients to identify data analysis needs, and delivered customized solutions.
  • Collaborated with cross-functional teams to define data requirements and provide actionable insights.
  • Prepared detailed reports summarizing data analysis findings, and key recommendations.
  • Organized surveys and statistical collections to gather diverse, issue-related data.
  • Implemented machine learning models to automate tasks, enhancing operational efficiency.
  • Analyzed large datasets using SQL and Python, extracting insights for strategic decision-making.
  • Integrated SQL Server with Power BI for real-time data visualization and decision support.

FINANCIAL ANALYST (ASSOCIATE)

STATE STREET SYNTEL SERVICES PVT LTD
Pune
02.2020 - 07.2022
  • Facilitates wire processing in custody, accounting, trade booking, and clearing cash breaks.
  • Analyzing Key Performance Indicators (KPIs) to oversee real-time deadlines for cash settlements.
  • Functioned as an SME, delivering process updates to team members, and facilitating training for new hires.
  • Facilitated the reconciliation of custodian bank and customer accounts using Multicurrency Horizon.
  • Overseeing and communicating cash availability on an account-wise basis to the investment manager.
  • Facilitate month-end closing by recording income and expenses.
  • Investigate and rectify payment discrepancies.
  • Facilitating the settlement of corporate action trades and executing capital stock processing.
  • Managed trade booking and settlement across various currencies.
  • Evaluating cash position and predicting necessary funds for diverse expenses, scheduling, and finalizing both domestic and international trades.
  • Managed escalations and reverts within the business unit by applying a thorough understanding of the process flow.
  • Collaborated with Capital Markets on NAV calculation and fund accounting for mutual funds and derivatives.

Education

Master of Commerce - Business Administration

Savitribai Phule Pune University
Pune
01-2017

Skills

  • Data extraction
  • Data transformation
  • Dashboard development
  • Advanced Excel
  • SQL
  • Python
  • Power BI, DAX queries
  • Power Query, Power Apps development, Power Apps
  • Power Automate, paginated report, BIM data analytics
  • Azure Databricks, dashboards
  • Azure, data modeling
  • Power BI Report Builder
  • SAP BO to Power BI migration
  • Real-time data integration

Projects

1. Sales Performance Dashboard

Problem: Needed a real-time view of total sales and year-over-year (YOY) growth, along with other sales metrics.

Execution: Built an interactive dashboard to track sales, YoY growth, and other metrics. Integrated real-time data from SQL Server and applied RLS for secure access.

Results: Improved decision-making efficiency by 30% and reduced report generation time.

2. Finance Reporting System

Problem: The finance team manually generated reports for Profit & Loss (P&L) and cash flow, which was time-consuming and

prone to errors.

Execution: Automated the manual process of generating P&L and cash flow reports using Power BI and DAX.

Results: Enhanced reporting efficiency by 50%, cut manual errors by 20%, and provided real-time financial insights.

3. Inventory Management Dashboard

Problem: Inefficiencies in tracking inventory levels, leading to either overstocking or stock outs.

Execution: Developed a dashboard to monitor inventory turnover, calculate reorder points, and integrate real-time data from SQL Server.

Results: Reduced stock outs by 25% and improved inventory turnover by 15%.

Most Proud Of

  • Internal Certification Program (ICP)
  • Preparing presentation board and presented HPC presentation for process vertical.
  • Received “Champ of the Team Award"
  • Titan of the Team Award
  • Received an “Spot Award” for handling all the task of the team on a priority basis

Timeline

ANALYST

DEUTSCHE INDIA PVT LTD
08.2022 - Current

FINANCIAL ANALYST (ASSOCIATE)

STATE STREET SYNTEL SERVICES PVT LTD
02.2020 - 07.2022

Master of Commerce - Business Administration

Savitribai Phule Pune University
RUPALI MANE