Summary
Overview
Work History
Education
Skills
Projects
Websites
Accomplishments
Certification
References
Timeline
Generic

VENKATA PRAVALLIKA ADUSUMILLI

Lithia

Summary

  • Experienced Business Analyst with strong expertise in extracting, analyzing, and interpreting data using SQL, Excel, and Python.
  • Experienced Business Analyst with a strong data analysis background, enhanced by the practical application of AI/ML for predictive insights, anomaly detection, and risk modeling. Skilled in using Python, R, and Azure ML tools to develop and deploy machine learning models in real business contexts.
  • Proficient in data visualization and reporting using Tableau, with expertise in building predictive models and ETL pipelines.
  • Adept at conducting stakeholder meetings, gathering business requirements, and creating process flow charts.
  • Know how to work on Microsoft products (Word, PowerPoint, and Excel). Proficient in the Software Development Life Cycle (SDLC) phases, specializing in Planning, Analysis/Design, Development, Testing, and demonstrating strong teamwork and collaboration in cross-functional environments.
  • Experienced in leveraging Azure DevOps for end-to-end project lifecycle management, including work item tracking, automated testing integration, ensuring alignment with Agile methodologies, and faster delivery cycles.
  • Comfortable working independently or with a team, with limited supervision, and working under tighter schedules, meeting deadlines, and having the ability to learn on the fly.
  • Excellent communication skills in facing the end users and training them in using the company product.
  • Possess detailed and flexible attitudes, along with relationship building, team management, a friendly nature, a positive attitude, active listening, critical thinking, reliability and trustworthiness, a good work ethic, planning and organizing, strong work ethics, and time management skills. Strong knowledge of data governance frameworks, including data quality, metadata management, and lineage practices.

Overview

2
2
years of professional experience
5
5
Certifications

Work History

Business Analyst

BOMBARDIER-INFOSYS
12.2021 - 08.2023
  • Experienced Business Analyst with hands-on expertise in tools such as ARBORTEXT, CONTENTA, XPP, Tableau, and programming/scripting in CSS, JavaScript, SQL, and Python.
  • I specialized in analyzing system behavior, devising data-driven solutions, and optimizing product adoption strategies through user feedback and behavioral analysis.
  • Actively contributed to cross-functional collaboration by supporting development and functional teams, delivering client presentations, and documenting workflows and technical processes.
  • Drafted and updated system-level test plans to verify performance metrics and ensure quality assurance during long-term data studies.
  • Maintained direct communication with clients to provide status updates and solutions to reported issues, ensuring high levels of client satisfaction and transparency.
  • Played a key role in the Software Development Life Cycle (SDLC) by working closely with project management and engineering teams to deliver data-centric software solutions.
  • Performed comprehensive data cleaning, normalization, and enrichment to ensure accuracy, completeness, and consistency across large-scale financial datasets.
  • Developed interactive Tableau dashboards and Excel-based reporting models to deliver real-time insights into key performance indicators and financial metrics.
  • Utilized advanced SQL (joins, subqueries, window functions) for data extraction, transformation, and analysis, driving actionable insights from complex datasets.
  • Built scalable and automated ETL pipelines using Python to streamline data flow and improve consistency.
  • Deployed and managed data infrastructure on the Microsoft Azure Devops platform, ensuring efficient data storage, processing, and analytics.
  • Utilized Azure Boards for agile sprint tracking and backlog management, improving transparency across cross-functional teams.
  • Environment: SQL, Tableau, Python, Azure, Agile/SDLC-aligned software development practices

Education

Master of Science - BUSINESS ANALYTICS

MERCER UNIVERSITY
ATLANTA, GEORGIA

Bachelor of Technology - Electronics and Communication Engineering

GITAM UNIVERSITY
VISAKHAPATNAM, AP

Skills

  • Azure Devops
  • User Acceptance Testing
  • SQL Proficiency
  • Web: HTML
  • CSS
  • Tools: XPP
  • ARBORTEXT
  • CONTENTA
  • Tableau
  • MS Office (Excel, Word, PowerPoint)
  • Software Development Life Cycle
  • Process Flow Development
  • Cross-functional collaboration
  • Problem solving
  • Critical thinking
  • Attention to detail
  • Project management
  • Time management
  • Data mining
  • Data mapping
  • Clear communication
  • Data visualization
  • Problem-solving
  • Data analysis

Projects

Business Analyst – Capstone Project

Project Title: Diabetes Health Prediction using Health Indicators

Tools: R studio and Python. 

  • The study aims to develop a model to predict diabetes risk using health indicators and lifestyle factors, ultimately contributing to early detection and prevention.
  • The research utilizes data from the 2023 CDC's BRFSS, focusing on key variables like BMI, blood pressure, smoking, and physical activity. Machine learning models, including Random Forest, Logistic Regression, and XGBoost, are employed to predict diabetes risk.
  • Random Forest and XGBoost show strong performance in predicting diabetes risk, with BMI, high blood pressure, and age identified as significant predictors.
  • The findings support the use of machine learning in healthcare for personalized risk assessment, early detection, and improved diabetes management, with potential benefits for individuals and healthcare systems.

Data Analyst – Data Visualisation Project

Project Title: Wealth by Sector: Unveiling the Dominant Industries of Billionaires
Tools: Tableau, Tableau Prep, Excel 

  • Analyzed Forbes Billionaires data (2021–2023) to uncover sector-wise, regional, and demographic wealth trends among global billionaires.
  • Cleaned and integrated over 6,000 data records using Tableau Prep, ensuring consistency across multi-year datasets.
  • Created interactive dashboards in Tableau Desktop showcasing the distribution of billionaire wealth by industry, gender, geography, and age. Identified that Technology, Manufacturing, and Finance remained the most dominant wealth sectors consistently across three years. Revealed that the United States, China, and India housed the highest concentration of billionaires, with notable growth in India from 2021 to 2023., Visualized gender disparities, showing that male billionaires accounted for over 85%, yet the number of female billionaires increased steadily. Highlighted the age group of 50–70 as the most dominant among billionaires, providing insights into the lifecycle of wealth accumulation. Enabled data-driven insights for audience storytelling, delivering clear visual narratives around economic sectors and demographic trends.

Accomplishments

  • Achieved and sustained exceptional customer satisfaction ratings throughout projects and engagements.
  • Demonstrated strong teamwork and collaboration skills through active participation in group projects and team-based initiatives.
  • Good communication skills and innovative thinking.
  • Time and stress management.
  • Leader and pay attention to details.
  • Adaptability to various environments.
  • Critical thinker with strong problem-solving skills.
  • Recognized for achieving high customer satisfaction ratings.
  • Able to track requirements throughout SDLC lifecycle.

Certification

Get started with Jira - Coursera, 2025

References

References available upon request.

Timeline

Business Analyst

BOMBARDIER-INFOSYS
12.2021 - 08.2023

Master of Science - BUSINESS ANALYTICS

MERCER UNIVERSITY

Bachelor of Technology - Electronics and Communication Engineering

GITAM UNIVERSITY
VENKATA PRAVALLIKA ADUSUMILLI