Overview
Work History
Education
Skills
Projects
Leadershipandcommunityinvolvement
Work Availability
Summary
Languages
Interests
Timeline
CustomerServiceRepresentative
Shubhanggam Parajuli

Shubhanggam Parajuli

Student
Rock Island,Illinois

Overview

3
3
years of professional experience

Work History

Community Advisor(CA/RA)

Augustana College
08.2024 - Current
  • Fostered a safe and respectful living environment for 86 residents by maintaining open communication, addressing concerns promptly, and ensuring compliance with community guidelines, as measured by reduced incident reports
  • Increased resident engagement with resources by 25% by designing monthly bulletin boards on themes such as wellness, academic success, and inclusivity, using visually appealing and informative content
  • Strengthened campus community connections by organizing and facilitating interactive events (e.g., study nights and wellness workshops), resulting in a 30% increase in resident participation in campus activities
  • Demonstrated leadership by collaborating with campus staff and resident assistants to implement proactive community-building strategies, including weekly check-ins and team-driven problem-solving sessions, resulting in improved team coordination and timely resolution of resident concerns

Data Analyst Intern

Education Park Nepal
03.2021 - 01.2022
  • Enhanced data accuracy by organizing and cleaning over 500 student enrollment records, reducing errors and inconsistencies by 95%, and enabling reliable analysis and reporting for academic planning
  • Identified key trends in course preferences and enrollment over three semesters by leveraging advanced Excel tools (e.g., pivot tables, formulas) and visualized findings through professional-grade bar and line charts, facilitating data-driven decision-making in team discussions
  • Prioritized and completed weekly data requests from team members, ensuring timely delivery of accurate insights for ongoing projects

Accounting Intern

Active International Import and Export
01.2020 - 03.2021
  • Streamlined tax return preparation by accurately entering daily revenue and expense data into accounting software, ensuring error-free financial records for reporting and compliance
  • Ensured compliance with Nepal's tax regulations by organizing and filing VAT and TDS documentation, contributing to the company's timely and accurate tax submissions
  • Improved bookkeeping efficiency by verifying the accuracy of receipts and invoices, identifying and resolving discrepancies in collaboration with senior accountants to maintain precise financial records

Education

Bachelors of Arts - Accounting and Data Analytics

Augustana College

Skills

  • Advanced Excel
  • SQL
  • Python
  • R Programming
  • Web Scraping
  • Tableau
  • Power BI
  • Analytical Thinking
  • Data Interpretation
  • Problem Solving
  • Risk Analysis
  • Actuarial Methodologies
  • Data Reconciliation
  • Market Trend Analysis
  • Pandas
  • NumPy
  • Matplotlib

Projects

Spotify Data Analysis

(Sql, Python)

01/24 - 08/24

- Analyzed Spotify data using SQL to extract insights, including top-streamed tracks, artist and album statistics, and track energy levels.

- Optimized data retrieval and analysis processes, reducing query execution time by up to 30% and saving approximately 10+ hours per week compared to manual data handling. 

- Published an interactive dashboard and optimized queries for performance and usability.

 T20 World Cup Cricket Data Analytics

(Python, Web scraping, Pandas, Power BI)

 01/24 - Present

- Created a Power BI report to identify the top 11 players for a T20 cricket team by scraping data from EspnCricInfo with a Brightdata website tool, cleaning and transforming the data with Pandas, and evaluating various player performance metrics.

- Used the resulting Power BI dashboard to select players for various categories (openers, middle order/anchors, finishers, all-rounders, specialist fast bowlers) and ultimately choose the top 11 players to play in the match.

- Utilized statistical modeling and data visualization to evaluate player performance, demonstrating actionable insights for decision-making.

Leadershipandcommunityinvolvement

Co-Founder / Vice-President

Augustana College Baking Club

09/24 - Present 

- Organized outreach programs to recruit diverse members, prioritizing inclusivity and ensuring that labor within the club does not fall disproportionately on women.

- Managed a $1,500 budget by tracking fundraiser income and event expenses, maintaining 100% accurate financial records to support club activities and events. 

- Led the planning and execution of 10+ baking workshops and themed events, organizing schedules, preparing supplies for over 50 participants per event, and delegating tasks to a team of 5 officers to ensure smooth operations.

- Reduced baking supply waste by 30% by leading the development of a streamlined inventory system, optimizing resources for weekly sessions attended by 25+ members and improving operational efficiency.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Summary

Out of all the jobs I’ve worked, the one that truly stuck with me was my internship as a data analyst. Learning SQL and uncovering insights from complex datasets sparked my passion for analytics and problem-solving. It was during this time that I realized the power of data to tell stories, make impactful decisions, and drive meaningful change.

Now, as a Data Analytics/Accounting major, I am building on that foundation, refining my technical skills, and exploring how data can be used to solve real-world challenges. I am set to be CPA-eligible by December 2026 and am excited to explore opportunities in data analytics and accounting roles where I can make a positive impact.

Languages

English
Native or Bilingual
Nepali
Native or Bilingual
Hindi
Native or Bilingual

Interests

Community Engagement & Inclusivity Initiatives

Public Speaking & Networking

Soccer

Music / Singing

Travel

Exercise / Gym

Timeline

Community Advisor(CA/RA)

Augustana College
08.2024 - Current

Data Analyst Intern

Education Park Nepal
03.2021 - 01.2022

Accounting Intern

Active International Import and Export
01.2020 - 03.2021

Bachelors of Arts - Accounting and Data Analytics

Augustana College
Shubhanggam ParajuliStudent