I've earned the&nbsp;MySQL Advanced Certification&nbsp;from HackerRank.This certification represents countless hours of solving complex database challenges and optimizing queries for peak performance.

SQL (Advanced) Certificate

I’ve earned my&nbsp;MySQL (Intermediate).This certification has sharpened my ability to:<ul><li>Master Complex Queries&nbsp;–&nbsp;JOINs&nbsp;(INNER, LEFT, RIGHT),&nbsp;Subqueries,&nbsp;UNION.</li><li>Optimize Data Analysis&nbsp;–&nbsp;GROUP BY&nbsp;with&nbsp;ROLLUP,&nbsp;HAVING,&nbsp;CASE&nbsp;statements.</li><li>Enhance Performance&nbsp;– Indexing,&nbsp;EXPLAIN&nbsp;plans, and query optimization.</li><li>Advanced Functions(Windows)&nbsp;-(RANK(),&nbsp;DENSE_RANK(),&nbsp;ROW_NUMBER()),&nbsp;CTEs&nbsp;(WITH clauses).</li></ul>

SQL (Intermediate) Certificate

Completed certification and gained expertise in Requirements gathering,Project management, and Business analysis by LinkedIn &amp; Microsoft.

Career Essentials in Business Analysis

I’ve earned my&nbsp;MySQL (Basic) Certification&nbsp;from&nbsp;HackerRank. This certification has strengthened my foundation in:<ul><li>Querying Data&nbsp;–&nbsp;SELECT,&nbsp;WHERE,&nbsp;GROUP BY</li><li>Data Manipulation&nbsp;–&nbsp;INSERT,&nbsp;UPDATE,&nbsp;DELETE</li><li>Functions &amp; Aggregations&nbsp;–&nbsp;COUNT(),&nbsp;SUM(),&nbsp;AVG(),&nbsp;MAX()/MIN()</li><li>Sorting &amp; Filtering&nbsp;–&nbsp;ORDER BY,&nbsp;DISTINCT,&nbsp;LIKE</li></ul>

SQL (Basic)

<ul><li>Completed the Data Analyst certification as part of the Data Scientist course at Newton School, gaining hands-on experience in key data analysis tools and techniques.</li><li>Developed expertise in Excel, SQL, Power BI, and Machine Learning, utilizing these tools for data manipulation, reporting, and predictive modeling.</li><li>Acquired proficiency in data modeling, data analysis, and data visualization, leveraging industry-standard practices to derive actionable insights.</li><li>Applied skills to complete comprehensive projects, demonstrating the ability to solve complex data challenges and deliver impactful solutions.</li><li>Equipped with the capability to analyze and interpret large datasets, enabling informed decision-making and supporting business intelligence strategies.</li></ul>

Professional Certificate in Data Science -  February 2024

Personal Portfolio Website | Self-Initiated Project (2025)<ul><li>Designed and developed a responsive personal portfolio using HTML &amp; CSS to showcase my career journey, skills, and projects.</li><li>Hosted on GitHub Pages for public access, ensuring an interactive user experience.</li><li>Features a clean UI with sections for About Me, Skills, Projects, and Contact Information.</li><li>Live Link: https://roshni3033.github.io/roshniportfolio80.github.io/index.html</li></ul>

Bachelor of Computer Applications

Computer Science

Intermediate (Class XII)

Actuarial Science

<ul><li>Analyzed and validated patient demographics and insurance documents utilizing Phreesia CRM and Amita Meditech across multiple healthcare platforms (Amita Meditech, Indiana Cerner, Amita Cerner, Amita Epic), ensuring accurate and efficient processing of patient information in a fast-paced emergency department environment.</li><li>Delivered exceptional performance, achieving a 98% reduction in workflow, 0% absenteeism, and 100% quality standards, consistently earning A+ performance ratings on a monthly basis.</li><li>Spearheaded design and automation of comprehensive production reporting using advanced data analysis and visualization tools (Power BI, Excel, Google Sheets), generating actionable insights through daily, weekly, and monthly reports.</li><li>Proactively took on additional reporting responsibilities outside of core job duties, leveraging pivot tables, charts, formulas, and workflow automation to enhance reporting accuracy, timeliness, and efficiency, showcasing adaptability, ownership, and technical expertise.</li></ul>

Senior Analyst

<ul><li>Led a targeted initiative to analyze customer data and identify key needs, recommending tailored health insurance plans that resulted in enhanced customer satisfaction and loyalty.</li><li>Spearheaded a project focused on optimizing lead conversion strategies, achieving an 80% lead conversion rate and providing actionable insights that improved sales processes and customer engagement.</li><li>Consistently exceeded sales targets, contributing to a team-driven initiative that improved overall performance, earning the highest incentive of ₹45,000 and receiving recognition from the CEO for outstanding contributions to the organization’s growth.</li></ul>

Sales Executive

<ul><li>Analyzed customer issues to identify patterns and provided data-driven solutions tailored to customer needs.</li><li>Maintained 100% task quality, receiving top feedback for effective problem-solving and communication skills.</li><li>Delivered exceptional customer service by leveraging from data analysis, enhancing overall customer satisfaction.</li></ul>

Customer Associate

Indira Gandhi National Open University, New Delhi

India

Certified Data Analyst with expertise in Excel, SQL, and Power BI, specializing in delivering data-driven insights to shape business strategy. Experienced in applying statistical modeling, data mining, and machine learning techniques to develop comprehensive projects and drive business outcomes.

Analysed Chicago crime data (2022), identifying key trends and insights to inform law enforcement strategies. • Developed Power BI dashboards to visualize crime trends, hotspots, and policing efficiency. • Analysed case resolution and arrest rates, identifying gaps in enforcement and resource allocation. • Developed targeted policing strategies for high-risk areas and district-specific interventions.

Chicago Crime Data Analysis (Power BI)

<ul><li>Conducted data quality checks on the Chinook music store’s dataset, identifying and addressing missing or duplicate values across multiple tables to ensure accuracy in analysis.</li><li>Segmented customers into categories (New, Existing, and Loyal) based on behavior, and analyzed metrics such as average lifetime value (LTV) and average order value (AOV) for each segment to drive strategic decisions.</li><li>Analyzed customer purchasing behavior, including frequency, basket size, and spending patterns, to identify top-selling tracks, artists, albums, and genres by region.</li><li>Evaluated customer churn rates, assessed contributing factors, and performed risk profiling based on transaction history and purchasing behavior to improve retention strategies.</li><li>Applied customer lifetime value (CLV) modeling to predict future value, providing insights for targeted marketing and loyalty initiatives to optimize customer engagement and retention.</li><li>Leveraged Power BI to convert complex data into clear, actionable visualizations and created interactive dashboards that presented key trends and performance metrics, enabling informed, data-driven decisions.</li></ul>

Chinook Music Store Analysis (SQL + PowerBI)

<ul><li>Analyzed Zomato's vast dataset to identify trends, insights, and patterns, ensuring data accuracy by handling duplicates and missing values.</li><li>Uncovered essential findings to guide Zomato's expansion, providing location-wise comparisons and highlighting suitable areas for new restaurant launches using data visualization techniques.</li><li>Conducted market analysis to determine the best countries for new restaurant launches, considering consumer behavior, customer ratings, overall average ratings, price ranges, average votes and yearly fluctuations in restaurant numbers.</li><li>Developed data-driven insights on market segmentation and competitive positioning, presenting findings through interactive visualizations and dynamic dashboards.</li><li>Provided actionable recommendations to enhance online delivery and table reservation processes, suggesting services like online delivery and table booking to maximize growth potential and business profits.</li></ul>

Roshni KumariIndia

Social Accounts

Achievements

Projects

Chicago Crime Data Analysis (Power BI)

Chinook Music Store Analysis (SQL + PowerBI)

Zomato Restaurants Data Analysis (Excel)

Experience

Senior Analyst

Sales Executive

Customer Associate

Education

Indira Gandhi National Open University

Govt. Sarvodaya Kanya Vidyalaya, Samalka

Certificates

SQL (Advanced) Certificate

SQL (Intermediate) Certificate

Career Essentials in Business Analysis

SQL (Basic)

Professional Certificate in Data Science - February 2024

Skills