Dnyanesh Tiwatane

Data Analyst

Pune, India 5+ yrs exp 90 · Outstanding

About

Data Analyst with 5+ years of experience in SQL, Python, Power BI, and Excel, specializing in data modeling, ETL pipeline development, statistical analysis, and interactive dashboard design. Skilled in transforming complex datasets into actionable insights, automating reporting processes, and optimizing data workflows to enhance operational efficiency and support data-driven decision-making. Experienced in financial analysis, time-series forecasting, and implementing scalable cloud-based data solutions.

Skills & Expertise (36)

Power BI Advanced

8.5/10

Years Exp

Python Advanced

8.2/10

Years Exp

Pandas Advanced

8.0/10

Years Exp

Data Cleaning & Validation Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

NumPy Advanced

7.8/10

Years Exp

Tableau Intermediate

7.5/10

Years Exp

Azure Data Factory Intermediate

7.0/10

Years Exp

Time Series Forecasting Intermediate

7.0/10

Years Exp

Excel Hypothesis Testing Regression ARIMA Pivot Tables AWS S3 VLOOKUP Power Query Microsoft Azure Google Sheets Data Migration Git ETL Data Storytelling DAX Excel Dashboards Query Optimization CTEs Stored Procedures Azure SQL Postgresql MySql KPI development Trend & Variance Analysis EDA Seaborn Matplotlib

Work Experience

Data Analyst

ICE Mortgage Technology

Dec 2020 - Present

Developed automated Power BI dashboards improving reporting efficiency by 20%. Analyzed large financial and operational datasets using SQL and Python. Improved reporting accuracy by 15% through data validation and transformation. Conducted trend and variance analysis to support budgeting and forecasting. Optimized SQL queries and indexing to enhance database performance.