<ul><li>Completed an intensive data science certification program covering topics such as data analysis and data visualization&nbsp;</li><li>Skills/Tools: SQL, Power BI, Spreadsheets</li></ul>

Professional Certificate Course in Data Science

Bachelor of Technology

Mechanical Engineering

Intermediate (Class XII)

Mathematics

Matriculation (Class X)

Not Applicable

<ul><li>Flow Management: Designed and maintained flow management sheets to monitor and streamline daily operations.</li><li>Inventory Control: Developed and updated inventory management sheets to track stock levels and usage.</li><li>Reporting: Prepared detailed stock reports to support procurement and decision-making.</li><li>Data Management: Created customized Excel/Google Sheets dashboards for data tracking and reporting.</li><li>Accuracy: Ensured accuracy and consistency of data across all management sheets and reports.</li><li>Decision Support: Provided management with timely insights to improve efficiency and resource utilization.</li></ul>

MIS Executive

<ul><li>Managed daily operations, including inventory, vendor relations, and customer service.</li><li>Analyzed sales data to identify trends and forecast demand, reducing stockouts and increasing sales.</li><li>Conducted financial analysis and budgeting, leading to increased profit margins.</li><li>Developed targeted marketing strategies based on customer feedback and purchasing patterns.</li><li>Improved overall store efficiency by streamlining processes and implementing effective management practices.</li></ul>

Founder & Owner

Raj Kumar Goel Institute Of Technology, Ghaziabad

India

Passionate data enthusiast with strong foundations in SQL, Excel, Power BI. Recent graduate of an online data science certification program that helped develop my skills in data collection, processing, analysis and generating appealing visualisations and dashboards. I am eager to apply my analytical acumen and data science passion to real-world challenges. Seeking an entry-level position in data science to begin my professional journey and meaningful contribution to an innovative organization.

<ul><li>Conducted comprehensive data analysis using SQL and PowerBI to examine customer behavior, churn rates, and financial metrics across different demographics and geographic regions.</li><li>Identified key patterns in customer spending habits, product affinity, and risk segments, providing actionable insights for improving customer retention and cross-selling strategies.</li><li>Analyzed churn rates by gender, geography, and other demographics, recommending targeted interventions to reduce churn and enhance customer loyalty.</li><li>Developed and executed complex SQL queries to extract, manipulate, and analyze data, including average income calculations, tenure analysis, and segmentation based on credit scores.</li><li>- Designed and implemented interactive dashboards to visualize KPIs, customer trends, and churn metrics, facilitating data-driven decision-making for stakeholders.</li></ul>Skills used - Power BI , SQL

Analytical CRM Development

<ul><li>Conducted thorough data cleaning and analysis using Power BI to address inconsistencies and missing values, ensuring accurate insights into sales performance and customer behavior.</li><li>Calculated total revenue, analyzed unique customer purchases annually, and identified trends in product popularity and sales fluctuations over the years.</li><li>Designed and implemented a multi-tab Power BI report to visualize key metrics, including total sales, revenue, customer satisfaction, and product performance, tailored for different stakeholder needs.</li><li>Analyzed revenue distribution across locations, identified months for promotional opportunities, and developed targeted marketing strategies to boost sales of underperforming and high-priced products.</li><li>Developed strategies for customer loyalty programs by segmenting customers and providing targeted benefits to enhance customer satisfaction and retention.</li></ul>Skills used - Power BI

Amazon E-Commerce

<ul><li>Ensured data consistency and completeness by cleaning the dataset and using LookUp functions to fill in missing country information.</li><li>Designed a dashboard with date and country slicers, providing insights into restaurant openings per country and year, and distribution across price ranges.</li><li>Analyzed market competition to suggest countries with lesser competition for new restaurants, using visualizations to justify recommendations.</li><li>Provided insights on optimal cuisines, the impact of online delivery and table booking on ratings, and the correlation between cuisine pricing and feedback.</li></ul>Skills used - Microsoft Excel

Shubham JaiswalIndia

Social Accounts

Achievements

Projects

Analytical CRM Development

Amazon E-Commerce

Zomato Restaurant Analysis

Experience

MIS Executive

Founder & Owner

Education

Raj Kumar Goel Institute of Technology

B I C Baijnattha

Sunbeam Academy

Certificates

Professional Certificate Course in Data Science

Skills