•&nbsp;Pursuing Data Science Certificate Course specialising in Data Analysis, Business Analysis, Visualisation and ML.•&nbsp;Upskilled myself in the field of Data Science using Excel, SQL, Power BI, Python, Libraries, Machine Learning and Deep Learning.

Professional Certificate Course in Data Science and AI

<ul><li>Badminton: State Gold Medalist in Badminton and participated in various CBSE games and District level tournaments.</li><li>School Prefect: Performed Duties and Responsibilities as a School Prefect</li></ul>

Bachelor of Commerce

Commerce

Intermediate (Class XII)

Matriculation (Class X)

Not Applicable

<ul><li><a href="https://drive.google.com/file/d/1LDjJ0ZM6S15ymXrMoAXJ7NNmTFvUQ7Im/view?usp=drive_link">https://drive.google.com/file/d/1LDjJ0ZM6S15ymXrMoAXJ7NNmTFvUQ7Im/view?usp=drive_link</a></li><li>Utilised MS Excel skills to clean, organise and manipulate company data.</li><li>Generated monthly reports for expenditure and inventory turnover.</li><li>Used advance excel skills to create pivot tables for employees classification and details.</li></ul>

Admin Trainee

National Post Graduate College

India

Aspiring data analyst and data visualization enthusiast with a strong commerce background, applying analytical skills and business knowledge to the field of data science.

<ul><li>Executed complex SQL queries for customer segmentation, churn rate analysis, and behavior prediction across various demographics and geographic regions.</li><li>Analyzed customer behavior, product affinity, and spending habits to inform cross-selling strategies and improve customer loyalty.</li><li>Identified data discrepancies, handled missing values, and ensured data integrity through robust data cleaning and transformation processes.</li><li>Developed dynamic dashboards in POWER BI with interactive slicers to visualize KPIs, churn trends, and geographic market performance for decision-making.</li><li>Modeled customer lifetime value and analyzed marketing campaign effectiveness, providing actionable insights to reduce churn and optimize retention strategies.</li></ul>

Bank CRM- POWER BI

<ul><li>Conducted thorough analysis of users and their activities using SQL Functions.</li><li>Constructed Sub Queries and CTEs to create tables and use advance functions.</li><li>Classification of users according to their engagements.</li><li>Generated list of loyal and genuine users on the website.</li><li>Evaluated growth oportunities and increase user activity.</li><li>Suggested various strategies and and methods to engage more users.</li></ul>

Social Media Project- SQL

<ul><li>Analyzed Zomato's Country and sales dataset using MS Excel.&nbsp;</li><li>Created pivot tables for efficient data organization.</li><li>Generated charts to visualize and communicate sales trends.</li><li>Compiled charts into a comprehensive dashboard for thorough analysis.</li><li>Key skills: MS Excel, Pivot Tables, Charting, Dashboard Creation, Data Interpretation.&nbsp;</li></ul>

Ankit SinghIndia

Social Accounts

Achievements

Projects

Bank CRM- POWER BI

Social Media Project- SQL

Zomato: Expansion Project

Experience

Admin Trainee

Education

National Post Graduate College Lucknow

Ben Hur Public School Pilibhit

Ben Hur Public School Pilibhit

Certificates

Professional Certificate Course in Data Science and AI

Skills