A budding Data Analyst with * months of experience in Data Mining, Data Visualizations, Data Analysis and creating dashboards and reports

Acquired knowledge of MS Office, MATLAB, Power BI and HTML

Extracted, transformed and cleaned Data using SQL, Excel, Python

Created weekly reports to track booking conversions of the leads, with the help of Spreadsheet

Knowhow of Business Development and client interaction

Undertook the roles of a Volunteer and Change Leader at World Youth Council (WYC) for 1 month, in 2020

Participated and cleared AITSE conducted by NTC

Knowhow of Computer systems, MS Word, MS Excel and excellent knowledge of SAS Programming and SQL

Excellent Time Management, Presentation, Problem-solving, Interpersonal, Leadership and Analytical Skills Stanza Living, Gurugram

Data Analyst (June’22 – Sept’22)

Role:

Created Live Google Sheets using Python Script

Prepared dashboards using Power BI

Developed SQL queries to fetch data from multiple tables (Redshift)

Tracked the booking conversions of the lead on a weekly basis

Extracted the data from Amazon Redshift as per the data request

Created weekly reports to track booking conversions of the leads, using Excel or Google sheet

Updated weekly Data Reports in the Google Sheets using Python and SQL queries, to effectively communicate the insights & predictions gained from the data

Triggered the phone numbers of the potential leads into database using Postman API

Performed Data Mining on various data sources before organizing the data in a readable format

Prepared and implemented Data Analysis Strategies to optimize the Statistical quality and efficiency of the organization

Created documentation, allowing stakeholders to comprehend the complete Data Analysis Process, for future use

Highlights:

Tracked the number of leads/clients through detailed data analysis, which gave business insights, like which market to focus on and made the business process smooth

~ C Programming

~ Data Visualization

~ Statistical Knowledge

~ Data Mining

~ Data Extraction

~ Data Analysis

YASH JASNANI

Phone : +918********* / E- Mail: yashjasnani 76 @ gmail. com Objective

An achievement-driven Data Analyst; targeting for full-time Analyst, MIS Executive or Business Development Executive role in a growth oriented organization having collaborative environment, in Noida, Gurgaon or Delhi, to best utilize and enhance the knowledge and skills and foster organisational and career growth.

Profile Summary

Core Competencies

Work Experience

Volunteer and Change Leader at World Youth Council (WYC) from June 2020-July 2020

Conducted 15 live sessions for less privileged children, maintained database for classes taken and was a part of Teach From Home (TFH) Program, which became very successful and gained great momentum within 2 weeks

B.Sc.(Hons.) in Electronic Science: Electronics, from Sri Venkateswara College, New Delhi, with 9.311 CGPA in 2022

Senior Secondary from D.A.V. Public School, Faridabad, with 89.8% in 2019

High School from D.A.V. Public School, Faridabad with 95% in 2017

Secured 1st Rank in 10th Standard

Secured 2nd Rank throughout the 3 years of Graduation (2019-22) in Sri Venkateswara College, Delhi University

Participated and secured 2nd rank in AITSE conducted by NTC in 2017

SAS (Base and Advanced) Programming Certification, from High Technologies Solutions Institute, Delhi in 2022

HTML

SQL

Microsoft Word

Microsoft Excel/Google Sheet

MATLAB

SAS Programming

Power BI

Date of Birth : 23rd April 2000

Languages Known : English and Hindi

Address : B-21, Ashoka Enclave, Sector 37, Faridabad-121003, Haryana Voluntary Work

Education

Academic Achievements

Certifications

IT Skills

Personal Details

Contact this candidate