Abhishek Dangwal

adx81r@r.postjobfree.com +** – 875******* Noida linkedin.com/in/abhishek-dangwal SUMMARY

A Passionate Data Reporting Analyst having Proven ability to analyse and transform data leveraging tools and services to create data extracts and deliver reports to achieve organizational objectives. Innovative problem solver whose areas of expertise include Data analysis, Data Sanity and Data visualization. Interested in utilizing data for Business insight and take business to next level. Experienced in Reporting management dedicated to developing high quality reports and positive results. Well versed in client communication and achieving Compliance & Optimization . SKILLS

Computer Programming language : Python

Data Cleansing: Numpy, Pandas, Excel, Vlook up, Hlook up, Macros, Power Query, DAX,Power Pivot, SQL

Data Visualization : Matplotlib, Seaborn, Power Bi, KPI cards, Score Cards, Dashboard, Excel

Application Experience: Microsoft Excel, Microsoft Powerpoint, Visual Basic Application, Power BI desktop, My SQl,Jira

Databases: MY SQL, Excel

Core Competencies: Effective Communication and Analytical Thinking, Stakeholder Management, Management Re- porting, Strategy Improvement, Data Analysis, Data Modeling, Requirment Elicitation, Agile,Business Process Modeling, Analytical Reporting, Data Insight, EDA, Data Management,Business Analysis, Statistics INTERNSHIP

KPMG-Data Analytics Virtual Internship

Practical Task : Data quality Assessment, Data insight, Data insight and presentation PROJECTS

Fandango platform analysis ( EDA Project)

Fandango is in controversies that it artificially giving higher rating to movie just to sell more movie tickets .

Using pandas for filtering the data and seaborn, matplotlib for visualization

During analysis it is found that none of movie in fandango had rated below 3 stars .Comparings fandango data with other sites data such as rotten tomatoes and IMDB .Thus from analysis it is clearly shown fandango artificially show higher rating to movie just to sell more movie ticket just to increase it revenue Data Mart Analysis ( SQL Project)

Large scale Supply changes were made at Data Mart. All Data Mart products now use Sustainable packaging methods in every single step from the farm all the way to the customer.

Data Cleansing and Exploration done with the help of SQL to find out sales for each region, each month etc .

Count of retail shopping is more as comparison to online . Atliq Mart Supply Chain Analysis (Power BI Project)

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. Essentials products were either not delivered on time or not delivered in full over a continued period,.

Filtering and cleaning it’s data using excel, dax, power query for the visualization and more clear insight .

Analize it’s On Time Delivery ( OT%), In Full Delivery ( IF%), On Time Full Delivery (OTIF%) using KPI cards to show the trends . Dairy product are the top in not delivered quantity .In order to expend they to improve their Line fill rate and Volume rate .

EDUCATION

Bachelor of Technology ( C.E) Jul 2015 - Jul 2019 APJ Abdul Kalam Technical University

CERTIFICATIONS

Google Data Analytics Professional certificate MS Excel for Data Analysis - Udemy Microsoft Power BI – Udemy My SQL – Udemy

Python - Udemy Jira - udemy

Contact this candidate