Sanskar Chaudhary |9354797278|sanskar.work77@gmail.
com|LinkedIn |Portfolio
EDUCATION:
Maharaja Surajmal Institute of Technology, Delhi. Jun 2024
B.Tech, Information Technology
EXPERIENCE:
->Analyst Intern, Boltly Electric, Remote Sep 2022 – Nov 2022
● Designed and automated a Power BI dashboard for product price analysis using SQL, resulting in a 20% improvement in
decision-making speed and ensuring alignment with business objectives.
->Analyst Intern, Ezyhelpers, Remote Aug 2022 – Sep 2022
● Designed a Power BI dashboard that streamlined HR processes by tracking employee data (working hours, attendance,
performance, leaves), saving 3-4 hours of work daily.
SKILLS:
Analytical Tools: Programming Languages: Database:
● Power BI ● SQL (Structured Query ● MySQL
● Advanced Excel Language) ● Microsoft SQL Server
● Tableau ● Python
PROJECT Experience:
Business 360 - Brick & mortar and ecommerce [Power BI | SQL | Excel | Dax Studio] Live Dashboard Mar 2024
● Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by
gathering data from 2 different sources (Excel/CSV files and a SQL database).
● Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of
the report by 5%.
● Developed a dashboard that enabled Atliq Hardware to analyze department sales trends, driving a projected 10% revenue
acceleration and a 20% reduction in data-related expenses.
T20 World Cup Cricket Analytics- [Power BI | Python | Pandas | Web Scrapping] Live Dashboard Aug 2024
● Created a Power BI report to identify top 11 players for a T20 cricket team by scraping data from ESPNcricinfo with
a Bright data 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.
● Selected team using the Power BI dashboard has 90% of chances to win the game.
Hospitality Analysis - Hotel Chain Business [Power BI | Excel] Live Dashboard Jan 2024
● Spearheaded Comprehensive Market and Competitor Analysis to identify key factors behind a 20% decline in Market Share
and Revenue.
● Improved Online Presence and Booking Channels, resulting in a 30% increase in online bookings and a 20% decrease in
booking abandonment rate.
● Regained a 10% boost in Market Share and Revenue within six months through strategic implementation of promotional
offers.
CERTIFICATIONS / AWARDS:
● Excel: Mother of Business Intelligencer.
● Infosys Certified Python Associate Get Job Ready: Power Bi Data Analytics for All Levels 2.0.
● SQL Beginner to Advance for Data Professionals.
● Python For Beginner and Intermediate Learners.
OTHER ACTIVITIES:
● Founding director of Rotary Club.
○ Managed end-to-end event planning, from ideation to execution, resulting in successful implementation of
5 majorevents with an average attendance increase of 25% year-over-year.
○ Conducted candidate interviews, leading to a 20% improvement in team quality.
● Hult Prize, MSIT –
○ Organized an international event at the college level for startups, successfully securing sponsorships and
arranging judges for the competition.
○ Managed event logistics and coordination, contributing to the overall success and recognition of the
event within the college community.
