Venkata Akhil Mettu

I'm Data Analyst

About

Skilled data analyst and aspiring enterprise solutions analyst adept at leveraging data-driven insights to optimize processes, drive innovation, and fuel business growth.

Data Analyst & Enterprise Solutions Analyst.

Proven expertise in Python, SQL, machine learning, and data visualization techniques. Committed to collaborating cross-functionally to align analytics with organizational goals.

  • Phone: +1 (802) 261-5876
  • City: New York, USA
  • Degree: MS in Data Science
  • Email: makhil@saintpeters.edu

Passionate about delivering impactful solutions that provide a competitive edge and tangible value.

Skills

Leveraging data-driven insights to optimize processes, drive innovation, and fuel business growth. Proficient in programming languages, machine learning, data visualization, and statistical analysis.

Python (Pandas, NumPy, SciKit-Learn, PyTorch) 90%
R 80%
SQL 85%
Regression, Classification, Clustering 85%
Natural Language Processing (NLP) 80%
Neural Networks, CNNs 75%
PostgreSQL 85%
MySQL 80%
NoSQL, MongoDB 75%
Data modeling, Statistics, Experiment design 80%
ETL processes 75%
Tableau 90%
Power BI 85%
Matplotlib, Seaborn 80%
Plotly, Dash 75%
Hypothesis testing 85%
Regression analysis 80%
AWS 75%
GCP 70%
Data Cleaning and Preprocessing 85%
VBA, Power Query, Macros 85%
Pivot Tables, Index/Match 80%
Power Pivot, Data Modeling 80%
Data Analysis Expressions (DAX) 75%
Microsoft Office: Word, PowerPoint, Outlook, Access 90%

Resume

Skilled data analyst and enterprise solutions analyst with a strong foundation in leveraging data-driven insights to optimize processes and drive innovation. With a proven track record in Python, SQL, machine learning, and data visualization, I excel at uncovering trends, building predictive models, and creating compelling data stories. My experience includes enhancing operational efficiency, reducing costs, and improving marketing campaigns. I am passionate about delivering impactful solutions that align with organizational goals and provide tangible value.

Sumary

Venkata Akhil Mettu

Skilled data analyst and aspiring enterprise solutions analyst adept at leveraging data-driven insights to optimize processes, drive innovation, and fuel business growth.

  • New York, USA
  • +1 (802) 261-5876
  • makhil@saintpeters.edu

Education

MS in Data Science

Saint Peter's University, New Jersey, USA

GPA: 3.97/4

Coursework: Data Analysis & Decision Modelling, Introduction to Data Science, Python Libraries, Business Intelligence Tools, Data Mining, Database Management System, Predictive Analytics, Big Data, Databricks, HDFS, SSIS, SSRS, SSAS, NLP, Deep Learning, Power BI, DAX, M-Code, Dashboard Designs, Microsoft Azure, Apache Spark, Hadoop, MapReduce, Kafka, RDD, API, Hive, Hbase

Bachelor of Engineering

A.V. I. T, Vinayaka Mission's Research Foundation, India

GPA: 3.71/4

Coursework: Programming in Python, Programming in Python Lab, Essentials of Computing, Numerical Methods, Mathematical Modeling and Simulation, Business Intelligence and Its Applications, Internet of Things, Virtual Instrumentation, Total Quality Management, Engineering Startups and Entrepreneurial Management, Renewable Energy, Ethical Hacking, Machine Learning

Professional Experience

Enterprise Solutions Analyst

Feb 2024 - Present

NAVCO INDUSTRIES PVT LTD, Remote

  • Engage with key stakeholders and clients to understand business requirements, processes, and pain points.
  • Gather and analyze business and technical requirements through interviews, workshops, and documentation review.
  • Develop functional and technical specifications for enterprise solutions leveraging analytical tools such as SQL, Python, and Excel.
  • Create data models, database schemas, queries, and reports to support business intelligence and data-driven decision-making.
  • Collaborate with cross-functional teams including IT, operations, and business units to manage solution development and rollout.
  • Develop test cases and conduct thorough testing to ensure solutions meet all requirements and perform robustly.
  • Provide training and support to end users on enterprise solutions and act as an ongoing resource to address any questions or issues.
  • Monitor and analyze solution performance metrics to proactively identify areas for optimization and enhancement.

Data Analyst

Mar 2022 - May 2023

NAVCO INDUSTRIES PVT LTD

  • Uncovered trends in production data through SQL analysis and Python, increasing output by 5%
  • Built Tableau sales dashboards providing real-time visibility into customer insights, enabling targeted marketing.
  • Developed Prophet forecasting models to predict demand more accurately, reducing inventory costs by 8%.
  • Designed and analyzed DOE experiments to identify factors driving quality issues, improving defect rates by 12%.
  • Automated data validation checks through Python, enhancing data accuracy and efficiency.
  • Partnered with cross-functional teams to align on KPIs and analytics adoption, elevating data culture.
  • Created compelling presentations and data stories to recommend process optimizations backed by statistics.

Junior Data Analyst

Oct 2021 - Feb 2022

NAVCO INDUSTRIES PVT LTD

  • Performed exploratory data analysis in Python and SQL to uncover insightful trends, patterns, and correlations.
  • Created interactive Tableau dashboards to visualize key metrics, elevating stakeholder data literacy.
  • Employed statistical modeling and forecasting techniques to better predict future outcomes.
  • Conducted A/B testing and controlled experiments to optimize marketing campaigns, product features, and processes.
  • Leveraged data storytelling skills to translate technical findings into compelling insights and recommendations.
  • Collaborated cross-functionally to align business goals with analytics efforts.
  • Developed forecasting models using time series analysis to improve demand planning and inventory management.

Junior Data Analyst

Oct 2020 - Aug 2021

VLHS PVT LTD

  • Conducted comprehensive data analysis to support business decisions in the manufacturing and distribution of medical-grade gloves.
  • Utilized statistical techniques to evaluate production processes, resulting in a 10% increase in operational efficiency.
  • Created visualizations and dashboards using tools like Tableau and Power BI to report on sales trends, leading to enhanced inventory management and a reduction in overstock by 15%.
  • Collaborated with cross-functional teams to identify and analyze key performance indicators (KPIs), enhancing the company's market positioning and product development strategies.
  • Conducted A/B testing on the company’s website, providing insights that improved customer online engagement by 20%.

Data Analyst Intern

Aug 2020 - Sep 2020

VLHS PVT LTD

  • Supported data collection and analysis tasks, contributing to the maintenance of high-quality data systems in line with medical industry standards.
  • Performed regular data quality checks, identifying and correcting errors to enhance the accuracy of reporting.
  • Participated in the preparation of weekly and monthly reports on production and sales metrics for senior management review.
  • Assisted in the development of documentation for data processes, ensuring compliance with regulatory standards.

Portfolio

Here are some of the projects I have worked on:

  • All
  • Data Analysis
  • Machine Learning
  • Business Intelligence
  • Data Engineering
  • Artificial Intelligence

Production Data Analysis

Uncovered trends in production data using SQL and Python, resulting in a 5% increase in output.

Demand Forecasting Model

Developed Prophet forecasting models to predict demand more accurately, reducing inventory costs by 8%.

Sales Dashboard

Built interactive Tableau sales dashboards providing real-time visibility into customer insights and enabling targeted marketing.

ETL Process Optimization

Optimized ETL processes to improve data pipeline efficiency and reduce processing time by 15%.

AI Chatbot Development

Created an AI-powered chatbot for customer service to automate responses and improve customer experience.

Services

Offering a range of data-driven services to optimize processes, drive innovation, and fuel business growth.

Data Analysis

Leveraging advanced data analysis techniques and tools to uncover trends, patterns, and insights that drive informed decision-making.

Machine Learning

Developing predictive models and machine learning algorithms to enhance business processes, improve customer experiences, and drive innovation.

Data Engineering

Designing, building, and maintaining scalable data pipelines and databases to ensure robust and efficient data management and accessibility.

Business Intelligence

Creating interactive dashboards and data visualizations to provide real-time insights and enhance strategic decision-making.

Consulting

Providing expert consulting services to help businesses develop and implement effective data strategies and solutions.

Contact

Feel free to reach out for any inquiries or collaborations.

Address: New York, USA

Call: +1 (802) 261-5876