Data Analytics & Insight Specialist

Nikhita Bhandula

Lawrenceville, GA ***** • ***********@*****.*** • 706-***-**** • linkedin.com/in/nikhita-bhandula/ • GitHub EDUCATION

Georgia Gwinnett College Lawrenceville, GA

Bachelor of Science in Information Technology December 2025 Concentration, Data Science and Analytics GPA: 3.81

• Academic Awards: President’s List (Spring 2022, Spring 2024, Fall 2025), Dean’s List (Fall 2022, Spring 2023, Fall 2024, Spring 2025), Honorable Mention Award – Science and Technology Research Symposium (2025)

• Certification: Information Technology Specialist (ITS) – Networking, Certiport (Nov 2024) PROFESSIONAL EXPERIENCE

Metropolitan Atlanta Rapid Transit Authority (MARTA) Atlanta, GA Data Collection Specialist Intern, Research & Analysis Department August 2025

• Cleaned, validated, and transformed 1,000+ rider survey responses using Python and SQL, improving data accuracy and analysis readiness by 25%

• Performed quadrant analysis and exploratory data analysis (EDA) across 25+ service attributes, identifying top strengths (staff courtesy, driver safety) and key improvement areas (station cleanliness, on-time bus performance), informing targeted operational strategies

• Developed interactive Power BI dashboards with 15+ KPIs, enabling cross-station performance monitoring and tracking improvements, resulting in a 20% faster reporting cycle for management

• Standardized reporting workflows and maintained comprehensive data dictionaries for 30+ fields, translating VoC

(Voice of the Customer) insights into actionable recommendations that supported service enhancements and improved customer satisfaction metrics

• Skills/Tools: Python (NumPy, Pandas), SQL, Excel, Power BI, Data Cleaning & Validation, EDA, KPI Development, Quadrant Analysis

RELEVANT PROJECTS

AI Financial & Market Trends Analysis Lawrenceville, GA Data Analysis Project December 2025

• Performed comprehensive AI financial and market analysis for Google (Gemini), OpenAI (ChatGPT), and Meta

(Llama) from 2015–2025, analyzing R&D spending, AI revenue, revenue growth, stock impact, and key product launches using Python

• Built a predictive linear regression model to estimate AI revenue from R&D investment and stock performance, achieving R = 0.87 and MSE = 227.84; correlation analysis revealed a strong positive relationship (r = 0.94) between R&D and AI revenue

• Applied Principal Component Analysis (PCA) and KMeans clustering (k = 3) to identify distinct AI investment and revenue behavior patterns, segmenting companies by investment scale, growth efficiency, and market response, and built interactive visualizations, including monthly trends and growth comparisons, to support strategic decision-making and R&D prioritization

• Tools & Skills: Python (pandas, NumPy, matplotlib, seaborn, Plotly), Excel, PCA, KMeans Clustering, Linear Regression, Correlation Analysis, Data Visualization, Trend Analysis, Predictive Modeling Grizzly Paths 2025 – Career Path & Skill Recommendation Platform Lawrenceville, GA Capstone Project (website) May 2025

• Collected and processed 30,000+ IT job postings from LinkedIn, Glassdoor, and Indeed using Python, Bright Data a web scraping techniques, extracting job titles, skill sets, locations, and course mappings for analysis

• Applied Natural Language Processing (NLTK) to map in-demand skills to relevant academic courses, producing personalized recommendations that guide IT students in career planning

• Developed interactive graphs using Plotly and Power BI and a responsive web application with React and Render, enabling users to click on any major or job title to dynamically explore skills, top courses, and career insights in a highly visual, user-friendly format.

• Tools & Skills: Python (pandas, NumPy, NLTK), Web Scraping (Bright Data), Plotly, Power BI, React, Render, HTML/CSS, JavaScript

Pulse Mortality Metrics – Heart Rate & Mortality Analysis Lawrenceville, GA ST Data Intensive Fundamental May 2024

• Processed large-scale heart rate and mortality data using Hadoop MapReduce, implementing Mapper, Reducer, and Driver programs to aggregate and analyze health metrics.

• Analyzed individuals aged 35+ in Massachusetts (MA) and identified higher cardiovascular risk and mortality prevalence among males compared to females.

• Created data visualizations using Python libraries (pandas, matplotlib, seaborn) to illustrate mortality trends, heart-rate distributions, and gender-based differences.

• Skills/Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, Hadoop, Spark, Git/GitHub SKILLS

Data Analysis & Reporting: Excel (Pivot Tables, VLOOKUP, INDEX-MATCH, Charts), Smartsheet, Ad-hoc Reporting, Data Validation

Visualization & BI Tools: Tableau, Power BI, Google Looker Studio, Quick Sight, Matplotlib, Seaborn, Plotly Databases & Querying: SQL (MySQL, Oracle), SAP HANA, JSON, Access, Data Dictionary Creation, Dataset Documentation

Programming: Python, R, Java, JavaScript, HTML/CSS Big Data & Cloud: Hadoop, Spark, AWS, Microsoft Azure Collaboration & Tools: Jira, Scrum, Agile, Lucid chart, UML, Visio, Microsoft Office Suite, Google Workspace, Power Automate

Contact this candidate