Excel, MySQL, python, power bi

kumar ajay prasad

Data Analyst Trainee

* ***** * ****** +91-854******* prasadkumarajay@gm

ail.com

Profile Summary

Data Analyst Enthusiastic

Dynamic Data Analyst Trainee with hands-on experience at Trainity. exceling in data cleansing and visualization using Python and Tableau. Proven ablity to enhance data quaity and drive strategic decisions. Adept at implementing analytical tools, ensuring accuracy, and resolving complex issues. contributing to successful project outcomes.

Education

Work Experience

Jan 2023 - Present

Data Analyst Trainee

Trainity, Jaipur, Rajasthan

Internship focusing on data analysis and visualization .

- Analysed large data sets using SQL and python, identifying key trends and pattern, which improves data-driven decision- making by 30%.

- Developed and presented data visualization using power bi resulting in enhanced stakeholders understanding of complex data sets.

- Collabrated in a project to enhance data quality,achieving a 20% improvement in data accuracy.

- Automated excel report for financial and sales forecasting,reducing manual efforts by 50%.

- Conducted exploletry data analysis(EDA) using python to extract insight from complex data sets.

Jul 2012 - Feb 2013

Key skills

Tableau

Excel

SQL

Python

Power BI

ETL

Data Cleansing

Data Visualization

Report Writing

R Analytics

Dashboarding

Statistical Data Analysis

Database Management

Data Warehousing

Data Modeling

Communication Skills

Problem Solving

Personal Information

City Ranchi, Jharkhand

Country INDIA

Languages

Hindi

English

M.Tech, 2022

Swami Vivekanand University, Sagar,MP

B.Tech/B.E., 2012

Vinayaka Mission University (VMU),

Salem,Tamilnadu

Jr. engineer (R and D & Production)

Tekson Electronics, Pune, Maharashtra

- Implemented strategies to optimize production volume and efficiency, resulting in a 25% reduction in production cost.

- Coordinated quality assurance protocol and collaborated closely with Production Manager.

- Prepared monthly reconciliations, collected, and analyzed employee data, and generated demand and inventory forecasts.

- Evaluated current production procedures to enhance efficiency and minimize expenses.

- Complied monthly reports and actively engaged in weekly team meetings with the manager while fulfilling additional assigned responsibilities.

- Worked on research and development projects for auto electrical and electronic parts, including voltage regulators, flashers, buzzers, and CDIs for 2- and 3-wheelers.

- Checked all project-related documents such as purchase orders, drawings, and technical specifications.

- Planned the execution activities and implemented them according to technical details, drawings, and client demands.

- Resolved problems related to the test jigs and auto electrical and electronic parts.

Projects

3 Months

Instagram user analytics project

Evaluated Instagram user data for 100+ Users, identified 26 inactive Users and top 5 hashtags Used 59 times, and recommended optimal ad scheduling strategies for targeted marketing campaigns and enhanced user engagement.

3 Months

Operation and metric analytics

Analyzed operational metrics across 100,000+ records, computed 7- day rolling averages, detected anomalies, and facilitated process improvements, driving operational efficiency. and enabling informed decision-making.

3 Months

Hiring process analytics

Evaluated hiring data, determining gender distribution (2563 males, 1855 females hired). calculated average salary, and provided insights for strategic hiring decisions.

3 Months

IMDB movie analysis

Performed in-depth analysis of IMDB movie data, uncovering 'Avatar as the highest-profit film with $523 million, and identified popular genres and critic/audience preferences for data-driven decision-making in the entertainment industry.

Social links

https://www.linkedin.com/i n/kumar-ajay-

prasad-a3ba

Extra curricular

-Undergone Training under the INFOSYS

CAMPUS CONNECT LIFE SKILLS PROGRAM.

-Soft skills training duration 50 hours

completed with grade A from HEWLETT-

PAKARED CO.

-15 Days Vocational training completed at

DAMODAR VALLEY CORPORATION (Bokaro

Thermal Power Station) on 07/05/10 to

07/20/10.

-7 Days training in 'Fundamentals of

telecommunications' completed at BHARAT

SANCHAR NIGAM LIMITED (BSNL). Salem for

one week from 08/04/1l to 08/08/ 1.

-Participated in the 12th ISMA National Karate

Training Camp held at Maranghada Y.M.C.A.

(Ranchi) from the 23rd of Nov. to 25th of Nov.

2001 conducted by Indian School of Martial

Arts. " Successfully achieved the Brown Belt

3rd dan (Rank) in the style of Indian school of

martial arts recognized by the government of

India, All India Karate-Do Federation, All India

United Shitoryu Karate-Do Federation.

3 Months

Bank Loan case study

This case study attempts to demonstrate the application of EDA in a real world business environment.in this case study in addition to using the techniques learn in the EDA module,gain a basic grasp of risk analytics in banking and financial services,as well as how data is utilized to reduce the risk of loosing money when lending to consumers.

12 Months

CDI & HT COIL Tester, CRANK Case Heater, Wiring Harness. Electronic Control Unit (ECU),

Evaluated current production procedure to enhance efficiency and minimize expenses " Complied monthly reports.Recognised 25% reduction in production cost.

1 Weeks

Vrinda store annual sales report

This project focuses on analysing sales data to uncover actionable insights for business growth .the excel based dashboard provides a comprehensive view of customer behaviour, regional performance and sales channel.

Certification

Ramco systems based Cloud Computing and application development

Introduction to the Oracle-9i as part of Oracle workforce development program.

Business analytics with excel by Simpli learn

Introduction to Data analytics from Simpli learn

Data visualization with Power BI from Great learning ADDITIONAL EDUCATION

- Master in Business Studies (Marketing management) from Savitri Bai Phule Pune University - 64.90% -2017

- PGDBM in Marketing Management from Savitri Bai Phule Pune University - 62.20% - 2015

ADDRESS

Saraswati Enclave, 2nd floor, Flat no -D2, Near Maa Rampyari Ortho Hospital, Karamtoli, Ahirtoli-834001, Jharkhand

Contact this candidate