Expertise

Language

Experience

Results-driven professional experienced in

data analysis, visualization, and project

management. Skilled in managing MIS

and internal Automation, developing

interactive dashboards, and leading

successful data migration projects.

Dedicated to expanding knowledge in

data governance with Microsoft Azure

Purview

About Me

+91-744*******

ad4zjv@r.postjobfree.com

tushar-khandare-56b37825

Pune, Maharashtra, India

Citco Shared Services

Pune - India

Nov 2020 – Till Date

Yardi Software Solutions

Pune - India

2014- 2016

Allstate Solutions Pvt. Ltd.

Pune - India

2016 - 2020

Worked on various Macros for process improvement using Excel VBA. Coordinating with development and texting for Process software Development. Data Analysis and report generation using Adv. Excel, SQL & Power BI. Worked on Quality check of PINs produced by Team,

Exploring MS Purview for Data Governance. Configuration of Azure Purview, creation of data collection registering different data sources, generating catalog, training teams to get on boarded, providing permissions on collection level etc. Handling MIS reporting and Internal Automation using Excel VBA. Data Analysis using Power BI, Adv. Excel, MS SQL Server

& Presentations. Identity the opportunities of process improvement and automate process using Excel VBA.

Worked on MS SQL Server Database as an administrator for storing and ETL operations. Also worked on Database backups, restore, import export of data from an to sql server database. Installation and configuration. Designed and developed interactive dashboards using tools like Power BI.

·Worked on Data mining, ETL Process and Visualization using power BI. Used MS SQL Server for Data extraction.· Coordinate with clients for New Client/Vendor/Property system setups.

English

Marathi

Hindi

MIS Reporting

Power BI

Advanced Excel/VBA

Data Analysis & Visualization

MS-SQL Server (SQL)

MS Purview

Azure Fundamentals

Power Query/DAX

ETL

TUSHAR KHANDARE

Operations Analyst / Data Governance / SQL DBA

Certifications

Projects

Education

Master of Business Management

2010 - 2012

Bachelor of Science in Computer Science

2006 - 2009

Project 1 : MS Excel to MS SQL Migration

Role: Lead Member

Tools: MS SQL Server 2016, Adv. Excel

Details: Lead migration project from MS Excel to MS SQL databases, enhancing data management and scalability. Managed planning, execution, and validation to ensure smooth transition of critical business data. Analyzed Excel structures, identified key fields for migration, and designed efficient database schema in MS SQL. Developed

scripts/used ETL tools for data extraction and loading, conducted validation, and collaborated with stakeholders on mapping issues. Provided training/documentation for data access in new MS SQL environment, monitored post- migration performance, and addressed data-related issues. Amravati University

Amravati University

Data Scientist from IBM

Python for Data Science

(4276777) from Simplilearn

Business Analyst using Power

BI (C82FLHBY) from Edureka

VBA Macros Developer

(AYCN76G6) from Edureka.

Syntel India Pvt. Ltd

Pune - India

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.

Project 2 : Employee and Client Database

Role: Lead Member

Tools: Power Query, VBA, Advanced Excel.

Data Collection & Integration: Gathered and integrated data from diverse sources with precision and consistency. Data Cleansing & Transformation: Utilized Power Query to cleanse and enhance raw data, ensuring optimal usability. Database Architecture: Designed the database to manage intricate relationships between employee and client data efficiently. VBA Automation: Developed scripts to automate tasks, streamline updates, and improve database

functionality. UI Enhancement: Implemented intuitive interfaces in Excel for seamless data handling and analysis.

Contact this candidate