Shivam Gupta

Software Developer Intern

: shivam-gupta-4b62a0206

Work Experience

Software Developer Intern
- Future Solver Pvt. Ltd.
  • Examined system performance by 35% through server-side logic. Optimized cross-browser compatibility, improving load speed by 20%. Combined front-end and back-end, reducing data processing errors by 15%.
  • Created a Power BI dashboard tracking client retention and user retention metrics, delivering insights that boosted engagement by 20% and improved retention trends by 15%.
04/2024 - 08/2024
Remote
Associate Software Developer Intern
- Shipway Technology Pvt. Ltd.
  • Enhanced UI using the MERN stack, cutting page load times by 30%. Refined system performance by 30% through code optimization and bug fixes.
  • Boosted user engagement by 20% with responsive design and new webpages. Increased accessibility by 25% through intuitive UI elements and navigation.
05/2023 - 08/2023
Gurgaon

Education

Bachelor's in Computer Science and Engineering
08/2020 - 08/2024
University College of engineering and technology, Bikaner

Projects

Pizza Sales Analysis Project
  • A SQL-driven project analyzing 1000+ sales records to derive insights and improve business strategies.
  • Analyzed 10+ SQL queries to calculate total revenue and identify top 3 pizza types.
  • Performed aggregation across 5+ tables to determine category-wise sales distribution and revenue contributions.
  • Generated reports on hourly order trends, optimizing insights from 1000+ customer orders.
11/2024 - 11/2024
Telecom Customer Churn Analysis
  • Conducted an in-depth analysis of a 7,043-row telecom dataset to identify churn patterns.
  • Utilized Python, pandas, seaborn, and matplotlib for data preprocessing and visualization. 26.54% customer churn rate identified via visualizations.
  • Senior citizens (16% of customers) showed a higher churn rate of 41%. Month-to-month contract holders experienced a 42% churn rate, the highest among contract types.
  • Customers without online security faced a 45% churn rate, compared to 24% for those with it. Electronic check users, comprising 33.6% of the customer base, had the highest churn rate of 46%.
11/2024 - 11/2024
Sales Dashboard
  • A sales dashboard tracks key metrics like revenue and growth providing insights with real-time data, e.g., 500K revenue.
  • Designed and implemented a Sales Dashboard using Power BI and MS Excel to provide real-time insights into sales metrics, product categories, and geographic performance.
  • Enhanced decision-making and business analysis by visualizing KPIs such as total sales, profit, and brand performance, resulting in a 20% increase in operational efficiency.
  • Utilized advanced data visualization techniques in Power BI, optimizing the reporting process and achieving a 50% reduction in report generation time. Improved accessibility for 20+ cross-functional users.
08/2023 - 09/2024

Certifications

Responsive Web design
  • FreeCodeCamp.
SQL, CSS, ReactJs
  • HackerRank Test Passed.

Awards

HackerRank - 4-Star
  • in SQL, C++, 10 days of code. Also, 3-Star in Python.
Code Studio - Ronin Badge
  • in Arrays, Linked List, Math, Sorting, Stacks, and Queues.
LinkedIn - Earn Badge
  • of HTML, CSS, JavaScript, frontend, ReactJS and NodeJS.