Data Analyst | SQL | Power BI | Python | Business Analytics

Mumbai, India
📧 suryawanshis107@gmail.com
🔗 LinkedIn: https://linkedin.com/in/om-suryawanshi-83406427b
🔗 GitHub: https://github.com/Om200327

Data Analyst with hands-on experience in operational analytics, MIS reporting, reconciliation analysis, and dashboard development.

Worked on real business workflows involving subscription data, payments, service timelines, and KPI monitoring. Experienced in converting large raw operational datasets into structured reports and management dashboards used for decision making.

Experienced across the full analysis lifecycle: Data extraction → Data cleaning → Validation → SQL analysis → KPI reporting → Dashboard visualization

IndiaFilings.com | May 2025 – Aug 2025

• Managed daily and monthly MIS reporting covering 25+ operational KPIs
• Automated 8+ Excel reports using Power Query and VBA reducing manual work by 40%
• Reconciled 5,000+ subscription and payment records every month
• Maintained and improved 6 operational dashboards
• Coordinated across multiple teams to resolve workflow and data inconsistencies
• Implemented data quality checks and exception tracking

IndiaFilings.com | Feb 2025 – May 2025

• Analyzed 10,000+ operational records using SQL
• Built analytics dashboards tracking reconciliation, GST subscriptions, and churn
• Cleaned and structured 50,000+ records for reporting reliability
• Identified customer drop-off points and improved conversion performance

End-to-end analytics system that processes operational transactions into financial and operational KPIs.

Pipeline: Raw Business Data → Python ETL → SQL Warehouse → Data Model → Power BI Dashboard

Technologies: Azure Storage • Python • SQL • Star Schema • Power BI

Project Repository: https://github.com/Om200327/azure-order-to-cash-analytics

Power BI funnel analytics dashboard analyzing 50,000+ user journeys across application lifecycle stages and conversion behaviour.

Relational database system managing products, suppliers and stock tracking using SQL joins, aggregation and relational modeling.

Python EDA analyzing Indian startup funding trends, investors and sector growth patterns.

Data Analysis

• SQL (Joins, Aggregations, CTEs, Window Functions)
• Data Cleaning & Validation
• Exploratory Data Analysis

Business Intelligence

• Power BI Dashboard Development
• DAX Measures
• Star Schema Modeling
• KPI Design

Programming

• Python (Pandas, NumPy, Matplotlib, Seaborn)

Reporting & Tools

• Excel (Advanced formulas, Power Query, VBA)
• Git & GitHub
• Jupyter Notebook
• VS Code

Databases

• MySQL
• PostgreSQL
• SQLite

• Business performance reporting
• KPI dashboards
• SQL data analysis
• Operational analytics
• Data quality validation
• Process performance analysis

View My Resume

Seeking entry-level Data Analyst or Business Analyst roles involving SQL querying, reporting, dashboard development and operational performance analysis.