Data Analyst, MIS Analyst, VBA Developer, MS BI developer

TUSHAR KHANDARE

Senior Analyst

About Me

Professional Experience

Detail-oriented Data Analyst with a decade of experience specializing in interpreting and analyzing intricate datasets to facilitate strategic business decisions. Adept in statistical analysis, data visualization, and project management techniques. Skilled in MIS reporting, VBA Macro development, and proficient in Database Administration.

Skills

Advanced Excel/VBA

Power BI (Power Query / DAX / ETL)

MS-SQL Server (SQL)

Python for Data Analysis

MS Purview

Azure Fundamentals

Data Analysis & Visualization

DBA

MIS Reporting

CRM

Predictive Analytics/Statistical Analysis

Education Background

Amravati University

Bachelor of Science in Computer Science

Completed in 2009

Amravati University

Master of Business Management in Finance

Completed in 2012

My Contact

ad5wag@r.postjobfree.com

Charholi, Pune - 412105

+91-744*******

tushar-khandare-56b37825

Citco Shared Services

Allstate Solutions Pvt. Ltd.

Yardi Software Solutions

Nov 2020 – Till Date

2016 - 2020

2014- 2016

Data gathering from various sources for database management like employee and client Database. Managed data cleaning and preprocessing tasks to ensure data accuracy and reliability for analysis and analyse data from multiple databases. Requirement gathering from stakeholders. Created interactive dashboards and reports using Excel/Power BI to visualize data for decision making. Handling MIS reporting using Power BI, Adv. Excel, MS SQL Server and prepare presentations (PPT) for Management. Identify the opportunities of process improvement and automate tasks using VBA.

Conducted in-depth data analysis to identify trends, patterns, and correlations, resulting in actionable insights for key stakeholders. Developed and maintained complex SQL queries and stored procedures to extract, manipulate Worked on various Macros for process improvement using Excel VBA. Coordinate with development and Testing team for Process software Development. Dashboard/Report generation using Adv. Excel, SQL & Power BI. Worked on Quality check of PINs produced by Team along with work allocation.

Worked on MS SQL Server Database as an administrator. Also worked on Database backups, restore, import export of data from various sources to SQL Server Database. Designed and developed interactive dashboards using tools like Power BI. Coordinate with clients for New Client/Vendor/Property system setups. Worked in Macro development team to develop various Macros using VBA for process improvement. Syntel India Pvt. Ltd

2013- 2014

Worked on share Reconciliation. Research on financial data by using different tools like MCH, E-Horizon, and Bloomberg to find the cause of unsettled trade. Achieved daily deadlines and sent reports to clients. Certifications

IBM Certified Data Scientist.

Certified Business Analyst using Power BI

(C82FLHBY) from Edureka

VBA Macros Developer (AYCN76G6) from

Edureka

Contact this candidate