Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

SAI GANESH RAMESETTI

New Rochelle,NY

Summary

Myself an Analytics professional with experience in statistical modeling, time series forecasting, text mining,supply chain analyst and data analysis. Doing Master's in Data Science at the University of Newhaven, Connecticut.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst (Supply Chain Analyst)

VAMSTAR
07.2022 - 12.2022
  • Data procurement By Using Python automate data acquisition and collecting, saving 60–70% of time and allowing for constant modification based on required data
  • Crafted interactive dashboards with Power BI, and SQL (Oracle, Postgresql) & NoSQL (S3) databases, demonstrating strong software development skills and a solid understanding of machine learning ecosystems, for real-time data visualization and analysis
  • Analyzing large sets of supply chain data to identify trends, inefficiencies, and opportunities for improvement of 30% to reach more suppliers
  • Architected and maintained PostgreSQL database for structured and unstructured data storage, leveraging track record of building and applying ensuring data integrity, and optimizing query performance for machine learning initiatives
  • Implemented Continuous Integration/Deployment Pipeline Integration using GitLab, collaborating effectively with other members of engineering research team and broader data services group, in Agile Sprint Planning, and other team meetings, with strong interest in finance and investment.

ETL-Developer

ACCENTURE
08.2021 - 07.2022
  • Analyze, design, build, and/or test new components or enhancements to ETL Informatica mappings and Develop visualizations (charts, graphs) to communicate complex data in understandable manner.
  • Handle 10 lakhs data rows for transferring through designed pipeline, improved efficiency nearly 30%.
  • Worked as part of Data Migration from one DB to Another Environment
  • Troubleshoot and resolve issues with data extraction, transformation, and loading
  • Transform data according to business rules, including cleansing, filtering, aggregating, and integrating data from multiple sources
  • Optimize ETL processes for performance and scalability and Worked in Agile Methodology JIRA as Story Board
  • Providing biweekly reports on various incidents raised by stakeholders and discussing how to speed up long prevailing tickets
  • Troubleshoot and resolve issues with data extraction, transformation, and loading
  • Using Shell Script to import, export and modifying data.
  • Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
  • Collaborated with cross-functional teams to design robust data models that catered to diverse reporting needs.
  • Reduced processing time for ETL tasks through implementation of parallel execution strategies.
  • Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.

Intern

Pantech Pro Ed Pvt Ltd
07.2019 - 08.2019
  • • Optimized XG Boost Model for Churn Prediction, achieving accuracy of 81% with AUC of 0.69, up from 66% and 0.60.
  • • Reduced customer churn by 3% by identifying key churn drivers through data analysis and implementing data-driven interventions.

Education

Master of Science - Data Science

University of New Haven
New Haven, CT
12.2024

Bachelor of Science - Computer Science

Amrita Sai Institute of Science And Technology
Vijayawada
07.2021

Skills

  • Data Analysis & Visualization Tools:
  • Tableau, Power BI, MS-Excel, Hadoop, SAS, Aws, Snowflake
  • Database Management Systems:
  • MySQL, Oracle, PostgreSQL
  • Programming Languages: Python (NumPy, Pandas, Scikit learn, SciPy, Matplotlib, TensorFlow, Pyomo), R, PySpark
  • Project Management Tools: JIRA, Microsoft Project
  • Machine Learning Algorithms: Clustering, Deep Learning, Anomaly Detection, Supervised Learning, Unsupervised Learning, Natural Language Processing (NLP), Hypothesis Testing, Linear & Non-Linear Optimization
  • Cloud Computing: AWS(S3, EC2,Athena)
  • Analytical Thinking
  • Problem-Solving
  • Dependable and Responsible

Certification

MICROSOFT POWER-BI DATA ANALYST (PL-300) – MICROSOFT CERTIFIED JIRA FUNDAMENTALS IBM DATA ANALYST PROFESSIONAL CERTIFICATE- IBM CERTIFIED

Timeline

Data Analyst (Supply Chain Analyst)

VAMSTAR
07.2022 - 12.2022

ETL-Developer

ACCENTURE
08.2021 - 07.2022

Intern

Pantech Pro Ed Pvt Ltd
07.2019 - 08.2019

Master of Science - Data Science

University of New Haven

Bachelor of Science - Computer Science

Amrita Sai Institute of Science And Technology

Similar Profiles

CREATE PROFILE
SAI GANESH RAMESETTI