Hello!

I'm Swapnil Singh



A Data Analyst

LinkedIn My works

Name: Swapnil Singh

Job Role: Data Analyst

Experience: 2 Years

Address: Bhilai, India

Skills

SQL 85%
PYTHON 70%
Data Visualization 85%
Statistical Analysis 85%
Advance Excel 85%

About

About Me

Certified Data Analyst with almost 2 years of comprehensive experience in data science and analytics, holding a bachelor's degree in engineering, proficient in data analysis, modeling, exploration, visualization, and statistical analysis. Demonstrated expertise at Stock Holding Corporation of India Limited in extracting actionable insights from complex datasets using SQL, Python, Microsoft Power BI, and Excel, with a strong ability to identify valuable patterns for informed decision-making.

  • Profile: Data Science & Analytics
  • Education: B.Tech in Computer Science and Engineering
  • Language: English, Hindi
  • Skills: SQL, Power BI, Excel, Python, Statistical Analysis, Data Modeling, Data Manipulation, Data Analysis & Data Visualization
  • Interest: Geopolitics Enthusiast, Personal Finance and Stock Market Enthusiast, Passionate about Travel and Exploration

0 +   Projects completed

LinkedIn

Resume

Resume

Certified Data Analyst with two years of experience at Stock Holding Corporation of India Limited. Proficient in extracting actionable insights from complex datasets using SQL, Python, Microsoft Power BI, and Excel. Skilled in statistical analysis, adept at identifying valuable patterns for informed decision-making.

Experience


Jul 2021 - Jun 2023

Executive

Stock Holding Corporation of India Limited

SHCIL, is a financial institution in India that provides various services related to securities and financial assets. It was established in 1986 and is a subsidiary of Industrial Finance Corporation of India.

  • Operated SQL queries to analyze client data, extracting valuable insights on financials, transactions, profit & loss, portfolio stocks, etc.
  • Employed Microsoft Power BI for trend analysis by leveraging data insights like age group-specific, client occupation, client earning, etc.
  • Demonstrated adept problem-solving for prompt resolution of daily challenges, promoting seamless collaboration across departments.
  • Generated a report highlighting the need to diversify customer base due to 60% reliance on senior citizens, identified concentration risk with top 10 clients contributing 50% of total revenue, and emphasized opportunities to shift 70% of customers from the terminal to online trading facilities.

Apr 2023 - Dec 2023

Data Analytics Certification

Coding Invaders

I have successfully completed a certification from Coding Invaders in Data Analytics, acquiring skills in SQL, Python, Power BI, Excel, statistical analysis, data modeling, data analysis, data manipulation, and data visualization.

  • Road Accident Data Power BI Dashboard: Implemented casualty analysis on the Power BI Dashboard, featuring vehicle type, month, year, road type, area, location, and light condition. Key indicators included total casualties, accidents, fatalities, and serious casualties.
  • Music Store Data Analysis SQL Project: Designed and executed SQL queries covering various complexities, from basic aggregations and filtering to advanced scenarios involving subqueries and ranking functions.
  • Ride Sharing Service Business End-To-End Project (SQL, Power BI): Conducted an extensive analysis to gain insights into the performance and patterns within the ride-sharing service. Addressed aspects such as success rates, payment trends, location-specific patterns, and user interactions.



Education


2016-2020

B.Tech in CSE

Chandigarh University

Mohali, Punjab

CGPA: 6.7

2014-2016

Higher Secondary School

MP & EV English Medium School

Visakhatpatnam, Andhra Pradesh

Percentage: 76

Download CV

Projects

Projects

Below are the sample Data Analytics projects on SQL, Power BI & Spreadsheet.

Music Store Data Analysis using SQL

SQL queries cover a range of complexities, from basic aggregations and filtering to more advanced scenarios involving subqueries and ranking functions. The project aims to extract meaningful insights from the music database.

Ride Sharing Business Data Analysis using SQL

The project involves analyzing and extracting valuable insights from a database related to a transportation service, likely a ride-sharing platform. This involves understanding the success rates, payment trends, location-specific patterns, and analyzing user interactions with the platform, such as searches, quotes, and bookings.

Ride Sharing Business Data Analysis using Power BI

The project involves analyzing and extracting valuable insights from a database related to a transportation service, likely a ride-sharing platform. This involves understanding the success rates, payment trends, location-specific patterns, and analyzing user interactions with the platform, such as searches, quotes, and bookings.


Zomato Data Analysis Using SQL

Led a comprehensive data analysis project for Zomato, utilizing SQL queries on diverse database tables. Extracted key insights, including total spending, visit frequency, first purchases, popular items, and gold membership impacts. Calculated Zomato points, identified top-earning products, and ranked transactions. Project demonstrated proficiency in SQL, data analysis, and provided actionable insights for business optimization.

Road Accident Data Analysis Using Power BI

Executed casualty analysis on the Power BI Dashboard, featuring vehicle type, month, year, road type, area, location, and light condition, along with key indicators like total casualties, accidents, fatalities, and serious casualties.

0 Projects
Experience
0 Cups of coffee

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Bhilai, India

Contact Number

+919079673646

Email Address

swapnil.singhci@gmail.com

Download Resume

Resume




  • Find me on