Avinash Shinde

• Developed interactive Power BI Dashboards & Reports for Hotels

across the World, Publishing on BI Service, model modifications, Transforming (Power Query Editor) and writing DAX queries as per clients specific enhancement requests. Data Modelling as per requirement for the projects.

• Performed ETL Processes in many projects that were based on

Python, Utilised pandas, numpy libraries for data transformations, and many other python libraries for enhancing the product design

and informativeness. Python scripts fully automised to run on

specific time with task schedular.

• Programmed & Implemented VBA Macros for automating repetitive tasks in the projects that enhanced productivity & efficiency.Pivot tables, Email automation, Export, data cleaning, data formatting,data integration and UDFs.

• Designed & modified databases for projects running on MySQL database. Written complex queries for ETL processes, used stored procedure, Events for better & time efficient results.

• Executed complex SQL queries involving CTEs, Joins, Subqueries, along with the implementation of Triggers, Views, and Stored Procedures for efficient data retrieval on SQL Server. SSRS reporting service hands on experience.

• Performed data preparation, exploratory analysis, data visualisation utilized Python libraries: Pandas, NumPy, Matplotlib, Seaborn, and more.

• Utilised Excel & Power BI for the data transformation(Power Pivot, Power Query Editor),DAX complex queries, data visualisation, dashboards along with Excel VBA Macro for automating the repetitive tasks.

• Developed interactive Tableau dashboards to transform raw data into actionable insights. Data cleansing, modelling, blending and visualization. Table calculations, LOD expressions, Calculated fields for advance level analysis. Tableau server for publishing workbook.

• Machine learning libraries for implementing algorithims.