JOHN DOE Hyderabad | 9876543211 |
john.doe912112@gmail.com
Data Analyst LinkedIn | Portfolio | Website
EXPERIENCE
SME | Codebasics (Remote) Dec 2023 – Present
Facilitated the community by guiding over 8000 students on the Codebasics Discord channel.
Addressed Data Analysis course-related queries in Advanced Excel, Power BI, and SQL demonstrating
expertise and commitment to guiding learners on the educational journey.
Analyzed 650+ resumes and LinkedIn profiles of Data Analyst aspirants to check if the information is
relevant.
Data Analyst Intern | Tektree Software Services Private Limited (Hyderabad) Jun 2023 – Nov
2023
Leveraged the latest technologies and tools in data analytics to collect, process, and analyze data, resulting
in a 20% improvement in data accuracy.
Exploited Power BI, SQL, and Advanced Excel to analyze datasets of over 1 million records, supporting
businesses in making data-driven decisions, and increasing efficiency by 25%.
SKILLS
Analytical & Reporting Tools: Power BI, Advance Excel, Looker Studio
Programming Languages: SQL
Database Management: MySQL
PROJECTS
AtliQ Grand Hotel Data Analysis [Power BI | SQL | Excel] (Link)
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.
Business Insights 360 - Brick & Mortar [Power BI | SQL | Excel | Dax Studio] (Link)
Designed a Power BI multi-view dashboard for 5 departments of AtliQ Hardware (Finance, Sales, Marketing,
Supply Chain, and Executive) enabling management of the reports easily.
Established a dashboard gathering sales data from 2 different sources (Excel/CSV, SQL database), totaling
over 1 million records, ensuring Integrity, and Quality Assurance.
Drafted a Profit & Loss statement that allows the company to analyze the performance of the customers,
share of the company’s products & scale business processes by 10% using DAX.
CERTIFICATIONS
Power BI Data Analytics for All Levels | Udemy
Introduction to Business Analysis Using Spreadsheets: Basics | Coursera
Data Visualization: Business with Effective Insights - Forage | Tata Group
ACHIEVEMENTS
HackerRank SQL (Intermediate, 5-Star Rating)
Community Champion among 5000+ learners | Codebasics
EDUCATION
BA - English Literature
Jul 2014 | Andhra Christian College, Guntur