Data Analyst

GANESH KUMAR MYLAPALLI

Richmond, Virginia ***** 804-***-**** **********************@*****.*** LinkedIn PROFESSIONAL SUMMARY

Driven and detail-oriented Business & Data Analyst with 1.5 years of experience in data analysis, machine learning, and business systems. Proficient in Python, R, SQL, and business intelligence tools such as Tableau and Power BI. Skilled in building and optimizing ETL data pipelines to drive insightful decision-making. Expertise in predictive modeling, statistical analysis, and leveraging cloud technologies for process improvements and data quality assurance. Adept at collaborating with cross-functional teams in Agile environments, gathering requirements, and creating technical documentation. Proven ability to optimize business operations, improve forecasting accuracy, and enhance efficiency. Certified in Advanced SQL and Python, with a strong focus on strategic decision-making and data-driven insights. PROFESSIONAL EXPERIENCES

Niftek 08/2024 – 11/2024

Business Data Analyst Intern Frisco, USA

• Analyzed large datasets using SQL Query and Tableau, uncovering key insights that improved decision-making.

• Created interactive dashboards with Tableau, resulting in a 12% increase in data accessibility for stakeholders

• Developed and maintained ETL pipelines using Hive, optimizing data processing and integration from multiple sources, ensuring efficient data flow and accessibility for reporting.

• Enhanced data processing speed, resulting in significant reductions in execution time. Smart Neta 05/2023 – 07/2023

Research Analyst Intern Bengaluru, India

• Developed a Power BI data model integrating Excel data and using advanced DAX, achieving 74% accuracy in analysis and reducing data processing time by 10%.

• Predicted outcomes with 85% accuracy using Python machine learning models, effectively handling ad hoc data analysis requests to provide strategic insights.

• Presented a comprehensive report with actionable recommendations, offering critical insights to support strategic decision- making.

Amara Raja Group of Industries 04/2022 – 07/2022

Operations Analyst Intern Tirupati, India

• Conducted time-series forecasting using a custom-built SAS solution to predict production trends, enabling proactive operational planning.

• Optimized SQL queries to enhance data retrieval speed, enhancing data processing and supporting timely decisions.

• Developed an 83% accurate regression model to identify inefficiencies, leading to a 2% production efficiency.

• Collaborated with cross-functional teams to resolve operational bottlenecks, improve workflow. Kumar Dresses 05/2021- 04/2022

Business Operations Associate Rajampet, India

• Developed and implemented operational policies, achieving an 8% increase in efficiency and a 5% rise in sales.

• Utilized Excel for data visualization and analysis, identifying key areas for improvement.

• Optimized inventory management using ERP systems, reducing waste and saving $15,000 monthly.

• Streamlined communication with suppliers and clients, ensuring smooth operations and improved response times. SKILLS

Languages: Python, R studio, SQL, SPSS, SAS.

Business Intelligence Tools: Tableau, Power BI, Advanced Excel, DAX. Libraries & framework: Scikit-Learn, Pandas, NumPy, Matplotlib, Seaborn, XGBoost, Monte Carlo Simulation. Data Processing & ETL Tools: Hive, Apache Spark, PyCharm. Visualization & Collaboration Tools: Google Colab, Lucid Charts, Microsoft Office. EDUCATION

Virginia Commonwealth University 08/2023 – 05/2024 Master’s in Decision Analytics concentration in Data Analytics GPA 3.70/4.00 Richmond, Virginia Christ (Deemed-To-Be-University) 07/2022 – 04/2024 Master’s of Business Administration in Business Analytics GPA 3.41/4.00 Bengaluru, India Jain College (CGS) 06/2018 – 05/2021

Bachelor’s of Commerce in Finance and Statistics GPA 3.38/4.00 Bengaluru, India RESEARCH & ACADEMIC PROJECTS

Analysis of Overdraft Facility by Fintech to MSME’s In India: A Risk Analysis on Credit Assessment Machine learning

• Conducted in-depth research on credit assessment for fintech overdraft facilities to MSMEs, and developed machine learning models in Python, with the random forest model achieving 93% accuracy, making it the best for identifying loan defaulters. Analytical Approaches to Campus Safety: Decision Trees and Crime Probability Analysis statistical analysis

• Developed a decision tree in SPSS and used Poisson distribution to assess crime probabilities, enhancing campus safety strategies. Analysis showed increased surveillance and transportation measures could reduce crime by 5% to 7%. Food Supply Chain Simulation Project using simulation model

• Developed a Monte Carlo simulation model in Python, applying distribution analysis and statistical techniques to assess goodness of fit. Identified that 25 to 30 trucks per week would be the optimal scheduling option for pallet fulfillment CERTIFICATIONS

• Microsoft - Business Analyst Professional Certificate

• Accenture North America - Data Analytics and Visualization Job Simulation

Contact this candidate