ANKUSH KUMAR SINGH

Freelance project consultant, looking for full-time roles in Analytics. Motivated, team-oriented, and responsible Data Analyst with significant experience in exploratory data science, data visualization and predictive Modelling.

• Among the top five of the Confluence-2015 Group Discussion Competition organised by MES, BRCM
• Won 3rd Prize in Project Demonstration event of Technical Fest ACME-March 2016 by MES, BRCM
• Won 1st Position in Treasure Hunt event of ACME- Oct.2016 by MES, BRCM
• Nominate as Secretary of Mechanical Engineering Society, BRCM for session 2015-2019
• Won 3rd Prize in the PPT event of Enthusia-2016 organized by ES, BRCM
• Won 3rd position on Engineers Day 2018

• Father's Name: Mr. Ajay Kumar Singh
• Mother's Name: Mrs. Kiran Singh
• Date of Birth: 03/07/97
• Gender: Male
• Nationality: Indian
• Marital Status: Unmarried

• Debate Competition organized by BRCM Club of Nobles (BCON)-2017
• Audio/Video Quiz organised by BRCM Club of Nobel's (BCON)-2017
• Technical PowerPoint Presentation event "ENTHUSIA-2016" and presented a paper on "Thermocouple"
• Technical Exhibition event of Engineer's Day 2017
• National Conference "SEPMWET-2017", presented a research paper on "Thermocouple"

• Watching videos on YouTube
• Playing computer games
• Long drives on the weekends
• Interested in coding & visualizations

Madhav e-commerce Electronic, Furniture & Clothing [Excel | Power BI] (Nov 2023)

• 1) Analysed the e-commerce market in India for the Company -Madhav e-commerce, focusing on Clothing and Electronics in India.
• 2) Uncovered crucial insights on consumer preferences, with 80% of respondents indicating their preferences.
• 3) Most customers prefer Cash On Delivery in India (approximately 44%).
• 4) Maharashtra generates maximum profit by sub-category by 23%.
• 5)Used data-driven decisions and recommendations based on the insights derived from the dashboard, resulting in a 20% increase in data-directed decision-making.

Vrinda Store Data Analysis (Excel Dashboard) (Nov 2023)

• The Vrinda store wants to create an annual report for 2022. So that, Vrinda can understand their customers and grow more sales in 2023. Steps:-
• 1) Data Cleaning
• 2) Data Processing
• 3) Data Analysis
• 4) Interactive Dashboard
• Insights Conclusion:- Target Women customers of the age group (30-40 years) living in Maharashtra, Karnataka, and UP by showing ads/offers/coupons available on Amazon, Flipkart, and Myntra.

Music Store Analysis - [SQL |Postgre SQL ] (Dec2023)

• 1) Presented Insights on Music Store to the executive management team, by querying the million rows database using SQL.
• 2)Insights from my presentation have the potential to reduce overall operational costs by approximately 10 % significantly

diwali_sales_analysis_project [Jupyter Notebook|Python] (Jan2024)

• Customized multi-functional sales trends over the global market by gathering data from different sources (Excel/CSV files).
• Married women age group 26-35 years from UP, Maharastra and Karnataka working in IT, Healthcare and Aviation are more likely to buy products from Food, Clothing and Electronics categories.
• Developed Exploratory Data Analysis (EDA), and optimised the report with Jupyter Notebook which improved the report's performance by 5%.
• Enabled Seaborn & Matplotlib to analyze different department sales trends and make decisions based on data, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.

Covid-19-Analysis [Jupyter Notebook|Python] (Jan2024)

• Confirmed, Death & Recovered Cases across the Globe.
• ->Insight are as below⬇️
• -> The maximum number of confirmed cases is in the US Region. (us confirmed cases = 1039909(MAX)).
• -> The least confirmed cases are in the Yemen Region. (Yemen confirmed cases = 6(MINIMUM)).
• -> India Stats are below:-
• Region - India
• Confirmed - 33062
• Deaths- 1079
• Recovered - 8437
• ->Max Recovered from Spain, the United States & Germany country.
• ->India Recovered 8437.

Accenture North America Data Analytics and Visualization Job Simulation on Forage - January 2024

• Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture
• Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions
• Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders

Tata Data Visualisation: Empowering Business with Effective Insights Job Simulation on Forage - January 2024

• Completed a simulation involving creating data visualizations for Tata Consultancy Services
• Prepared questions for a meeting with client senior leadership
• Created visuals for data analysis to help executives with effective decision-making

PwC Switzerland Power BI Job Simulation on Forage - January 2024

• Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
• Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
• Strong communication skills reflected in concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
• Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.

IBM Data Analyst Professional Certificate:-

Link-https://www.coursera.org/account/accomplishments/professional-cert/RHJUHWHG39MJ

Microsoft Power BI Data Analyst Professional Certificate

Link-https://www.coursera.org/account/accomplishments/professional-cert/BBLS8HV23RC3