Likhith Mahankali
+1-419-***-**** ******************@*****.*** www.linkedin.com/in/likhith-mahankali SUMMARY
Enthusiastic and detail-oriented Data Science graduate with a strong foundation in machine learning and data visualization. Proficient in Python, SQL, and R. Passionate about deriving actionable insights from complex datasets to drive business decisions. Skilled in Scikit-Learn, Pandas, and Power BI/Tableau for building and interpreting data-driven solutions. Eager to apply analytical skills and problem-solving abilities in a dynamic, data-driven environment.
EDUCATION
• BOWLING GREEN State University, Bowling Green, Ohio Master’s in Data Science Aug 2024–May 2026
• Anurag University
Bachelors in Computer Science Aug 2020–May 2024
ACADEMIC EXPERIENCE
Power BI Developer
• Professional specializing in enterprise BI solutions, data modeling, and interactive dashboard development. Transformed complex datasets into actionable insights using Power BI, DAX, and Azure data services.
• Assisted in developing interactive dashboards and reports using Power BI to visualize complex business data.
• Optimized DAX queries for efficient data analysis and implemented advanced calculations to enhance reporting accuracy.
• Additionally designed and maintained tabular and multidimensional models in compliance with data warehouse standards.
Data Analyst
• Data Integration & Cleaning: - Consolidated 8+ data sources (APIs, SQL DBs, Excel) using Python (pandas) and Azure Synapse, improving data completeness by 35% - Standardized inconsistent flight records across 500K+ monthly entries using Power Query transformations.
• Predictive Analytics & Modeling: - Built time-series forecasting models predicting passenger traffic with 88% accuracy (Python) - Developed 10+ DAX measures for KPIs: on-time departure rate, baggage mishandling rate, revenue per passenger
• Decision Intelligence Dashboards: - Created executive-level Power BI dashboards monitoring:
– Operations: Gate utilization, tarmac delay root causes.
– Financials: Route profitability, concession sales trends.
– Safety: Incident frequency by terminal.
Web Development Intern
• Developed a conversion-focused, SEO-optimized website using React, Hooks, HTML5, CSS3, and the Google Maps API.
• Implemented responsive design principles, ensuring seamless user experience across all devices.
• Gained hands-on experience with MySQL/SQLite, managing databases for efficient data storage and retrieval.
• Optimized user experience (UX) and interface design (UI) to enhance engagement and customer conversion rates.
1
PROJECTS
Airport Authority Data Analysis
• Developed an Airport Authority Data Analysis System to enhance decision-making using Power BI and advanced data analytics. Integrated multiple data sources, including flight operations, passenger traffic, and financial data, for real-time insights.
• Designed interactive dashboards to visualize key metrics such as flight delays, baggage handling efficiency, and revenue performance.
• Implemented DAX calculations and Power Query transformations for accurate data modeling and predictive analytics.
• Optimized airport operations by forecasting passenger trends, monitoring real-time flight data, and automating report generation.
• Tech Stack: Power BI, SQL, DAX, Power Query, Python, APIs (Flight Data), Azure Synapse. Automated Face Recognition Attendance System Using Deep Learning
• Developed an Automated Face Recognition Attendance System to streamline attendance processes using advanced deep learning techniques. Utilized facial images captured via camera, with preprocessing and feature extraction for accurate identification.
• Employed CNN for facial feature analysis and classification, and KNN to enhance recognition precision. Replaced manual data entry with automated attendance, reducing human error and increasing efficiency.
• Optimized real-time face detection and recognition using dlib and face-recognition libraries.
• Replaced traditional attendance methods with automated data logging into MySQL, reducing human error and increasing operational efficiency.
• Tech Stack: Python, MySQL, OpenCV, Face recognition and dlib libraries TECHNICAL SKILLS
• Languages: Python, R, Java, HTML, CSS, SQL.
• Packages/Tools/Frameworks: Machine Learning, Deep Learning, OpenCV, Scikit-Learn, NumPy, Pandas, Matplotlib, Jupyter Notebook, PyTorch, Tableau, PowerBI.
• Databases: MySQL, MongoDB, Excel.
• Statistics/ML: Linear/Logistic/Ridge/Lasso Regression, K-means Clustering, Classification, Data Mining, Deep Learning, Decision Trees.
CERTIFICATIONS
• Infosys SpringBoard - Basics of Python, Python Data Structures and Algorithms, Java Programming Fundamentals
• LearnTube – PowerBI
• Coursera - Introduction to Data Analytics for Business, AI For Everyone 2