Abhishek Reddy Vangala

Proficient Data Analyst: Over 3 years of experience leveraging SQL, Tableau, and Power BI to analyze complex data sets, develop custom dashboards, and deliver actionable insights that drive business decisions. Technical Skills: Strong programming abilities in Python and C++, combined with hands-on experience in data cleaning, manipulation, and transformation to create scalable business solutions.

• AI for everyone By Deep Learning AI
• Microsoft Power BI Service
• IBM Data Analytics with Excel and R Specialization
• IBM Data Engineering Specialization
• Backend Rest API with node JS
• C/C++

Automated E-Commerce Testing Suite

• Developed a comprehensive automated testing suite using Python and Selenium to ensure seamless functionality across an e-commerce platform's critical workflows.
• Automated key features including product search, add-to-cart workflows (item selection, quantity adjustments, and dynamic cart validation), and end-to-end checkout processes.
• Validated user interactions such as form submissions, payment processing, and order confirmation receipt generation.
• Debugged WebDriver setup and element locators to address issues with dynamic content and ensure robust test execution.
• Organized and modularized test scripts using the pytest framework for scalability and maintainability.
• Configured ChromeDriver within the VS Code environment for efficient test execution.
• Incorporated exception handling mechanisms to manage missing elements and dynamic content changes.
• Technologies: Python, Selenium, pytest, ChromeDriver, Visual Studio Code, Techniques: Automated Functional Testing, Exception Handling

Real-Time Weather Dashboard API

• Designed and implemented a RESTful API using Flask to fetch and display real-time weather data from the OpenWeatherMap API.
• Integrated SQLite to store and retrieve historical weather data for trend analysis and monitoring.
• Developed utility modules for data validation and error handling to ensure seamless API performance.
• Built a modular project structure (routes, models, utils) for scalability and maintainability.
• Tested API endpoints using Postman, ensuring adherence to REST standards and robust responses for edge cases.
• Tools & Technologies: Python, Flask, SQLite, OpenWeatherMap API, Postman, Git.

Browser Automation Project

• Designed and implemented a web automation script using Python and Playwright to automate Google Search and extract structured data.
• Developed robust workflows to handle dynamic web elements, consent popups, and regional redirects for seamless navigation.
• Extracted and parsed search result titles and URLs, saving them in JSON format for further analysis and reporting.
• Enhanced script reliability through advanced error handling, dynamic wait conditions, and modular reusable components.
• Leveraged headless and non-headless modes for debugging and production-ready execution.
• Ensured optimal performance by incorporating efficient selectors, explicit waits, and context-aware element interactions.
• Technologies: Python, Playwright, JSON, Visual Studio Code.

Supply Chain Optimization and Analytics System

• Developed a platform using SQL and Python to optimize logistics, inventory, and vendor performance with real-time data processing and predictive analytics.
• Created dynamic dashboards in Tableau/Power BI to visualize KPIs like order fulfillment rates and lead times.
• Integrated IoT-enabled inventory tracking and automated alerts to address bottlenecks and enhance efficiency.
• Tools & Technologies: MySQL, MongoDB, Python (pandas, TensorFlow), Tableau, Power BI.

Healthcare Analytics and Insights Platform

• Developed an analytics suite using Python to track patient outcomes, hospital efficiency, and financial metrics, ensuring HIPAA compliance.
• Built predictive models for patient readmissions and health risk scoring, along with real-time monitoring of hospital performance.
• Delivered actionable insights through interactive Power BI dashboards.
• Tools & Technologies: SQL, NoSQL, Python (pandas, scikit-learn), Power BI.

CO2 Emissions Data Applications (SQL)

• Developed a CO2 Emission Data Application to analyze vehicle and flight emissions, leveraging datasets from Kaggle and data.gov to provide actionable insights for users.
• Implemented a user-friendly interface using PHP, HTML, and CSS, allowing for customizable analysis and reporting features.
• Enabled users to make informed decisions aimed at reducing their carbon footprint and enhancing overall sustainability efforts.

Net meds Pharmacy (Tableau)

• Developed Tableau BI dashboard to track profit margins, yearly sales, stock levels, and annual profits for Net Meds Pharmacy, improving real-time visibility of key metrics.
• Enhanced decision-making and operational efficiency by visualizing data trends and performance insights in an interactive dashboard
• Collaborated with cross-functional teams to ensure data accuracy and seamless integration with SQL databases, optimizing inventory and financial management.