Mayur Joshi

: +91-958*******

: adj7kr@r.postjobfree.com

PERSONAL SUMMARY

Process oriented data analyst with 2.5+ years of experience. Experienced in interpreting and analyzing data to extract actionable insights. Furnish analytics, data visualization, insights and business intelligence needed to guide decisions.

EXPERIENCE

I am working with Abstinent Research and Technology, Bhopal as a Data analyst from February 2018.

Data Extraction and Transformation: Extracted data from different sources by using ETL process, Excel and then transformed and cleaned them to perform analysis using tools in Microsoft SQL (SSMS and Tableau.

Data Mining and Modeling: Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives with SQL.

Dashboards and Reports: Extracted, transformed, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information by using different tools like SQL and tableau for client Bedrock Data warehouse and analytics which includes:

1.Healthcare: In healthcare we have created different type of reports on Patients records, floor plan, Sickness report, staff absence, mental health and on medical supplies.

2.Data Migration: Performed Dimensional Analysis, Data Analysis and Data Quality Validation in Data Migration. Migration of data from various sources using SSMS and SSIS.

3.Fire incidents: Created visually impactful dashboards and reports according to fire incidents, location, and time interval and fire incident type.

4.Design and develop ETL jobs or extracts to pull the data required for the visualizations. Build data sources to power the visualizations and create data models for each data source.

5.Involved in troubleshooting, resolving and escalating data related issues and validating t data to improve data quality for reporting and dashboards.

Cenerio : Manage product development for a client. Product name is Cenerio which is based on financial data which involves extraction of data, creating of dummy data for testing & analysis, and creation of dashboard to compare different customer’s financial activities.

Data Simulation: Generate various types of generic data for testing and demo by using SQL and R.

Training on any aspect of Reporting Tools (where required).

Excel: Excel skills with success in maintaining and organizing data, formulas, conditional formatting.

TECHNICAL KEY SKILLS

MSSQL Server- SSMS

Tableau

Power BI

R program

Basic Python

ACADEMIC QUALIFICATIONS

MBA in Finance and Retail Management with 67%.

B.com Computers from B.U. University with 71%.

12th class from M.P. Board(Commerce Computers) with 62%

10th class from M.P. Board with 65.40%

EXTRACURRICULAR ACTIVITIES

Worked as coordinator of Marketing Club Activity MBA 2012-14.

State player of Basketball.

State player of taekwondo.

Secured “A+” grade in examination JD “ a part under the authority of Ministry Of Defence Govt. of India.

Participated in combined annual training camp (CATC), National integration camp (NIC) of N.C.C Naval.

HOBBIES

Sports

Travelling

Adventure activities

PERSONAL DETAILS

Languages Known: English, Hindi

Residential Address: Bhopal – City, 462003

Location Preference: Anywhere

Signature

Contact this candidate