Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
AccountManager

Sai Ranadeep Reddy Gopu

St Louis,MO

Summary

  • Fast-paced, innovative, and dedicated Data Analyst with hands-on Azure and Data analytics expertise.
  • Data Analyst with more than3 years of experience in all phases of the Software development life cycle (SDLC) including System Analysis, Design, and Data Modeling. Specialize in leveraging data to drive business process insights and enhance performance. Collaborate with stakeholders and cross-functional teams to ensure successful outcomes and excellent communication skills.
  • In dynamic and fast-paced environment, developed skills in data analysis, problem-solving, and strategic thinking. Excel in interpreting complex data sets and delivering actionable insights to support business objectives. Seeking to transition into new field where these transferrable skills can drive meaningful impact and innovation.
  • Utilizes data visualization tools to make clear and concise visual representations of data. Deploy, automate, maintain, and manage cloud-based infrastructure and services, to ensure the availability, performance, scalability, and security of production systems.
  • Thrive on solving complex problems, employing critical thinking skills, interpersonal skills, analytical skills, and maintaining attention to detail.
  • Deliver comprehensive data integrity and analytics solutions with exceptional analytical, customer service-focused, and flexible approaches.
  • Effectively work with stakeholders with a professional attitude to understand their needs and objectives, ensuring their satisfaction and success. Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
  • Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards and storylines on web and desktop platforms.
  • Experience in creating visualizations, interactive dashboards, reports, and data stories using Tableau. Performed Data Analysis on the Analytic data present in Teradata and AWS using SQL and Python.
  • Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach.
  • Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans.
  • Dedicated and hard-working with passion for Big Data. Results-driven data professional with keen eye for detail and passion for uncovering actionable insights from data. Proven track record of utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented with strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments.
  • Experienced with data manipulation, statistical analysis, and data visualization. Utilizes advanced analytical techniques to uncover trends and inform business strategies. Track record of employing critical thinking skills to solve complex problems and deliver meaningful insights. Positive and analytical with knack for turning data into actionable insights. Comprehensive understanding of statistical analysis and data visualization tools such as SQL and Tableau.
  • Dedicated to leveraging data-driven strategies to drive success and innovation. Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst

Toyota Motors
02.2023 - Current
  • Performing data analysis to generate weekly and monthly client sales reports using SQL queries
  • Designing an interactive dashboard using the insights gained from the data in MS Excel with the help of pivot tables
  • Explored the past trends of the client data for analyzing the sales trend over the years
  • Developing and implementing a cost optimization strategy for a client's GCP infrastructure, resulting in a25% reduction in monthly cloud spend
  • Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and customers
  • DevOps engineer with almost3+ years of experience focusing on AWS, using EC2, Lambda, and K8S
  • Hands-on experience in automation tools like Jenkins, Code pipeline, and scripting languages like Python and Bash
  • Developing and maintaining Azure cloud infrastructure, including virtual networks, storage accounts, and virtual machines
  • Designing and implementing cloud-based solutions using Azure services such as App Services, Functions, and Logic Apps
  • Created reports for clients that documented the information gained from their sales data
  • Implementing MDM practices for consistent, accurate data
  • Centralized master data repository
  • Streamlined data integration and lifecycle management
  • Enhanced operational efficiency, and regulatory compliance
  • Created reporting dashboards and performed data mining and product analytics to understand customer purchase behavior
  • Automate cloud-based deployments using Azure DevOps
  • Implement security best practices for cloud-based applications and services
  • Utilize Spark's APIs (Python/PySpark) for data transformations, aggregations, and advanced analytics
  • Create real-time dashboards in Tableau to visualize and monitor key metrics and perform A/B testing using external and internal data
  • Performing a bivariate analysis of the correlation between school performance and students’ environment using Kaggle, JSON, and Python with pandas (Pydata)
  • Develop an ML model to train and test data using various Algorithms to get maximum accuracy
  • ML, Data Visualizations, Python- Pandas, NumPy, Matplotlib, Sorted and organized files, spreadsheets, and reports
  • Improved decision-making processes with accurate data analysis and visualization techniques.

Data Analyst

E-info chips, India
02.2020 - 07.2021
  • Imported the claims data into Python using Pandas libraries and performed various data analyses
  • Wrote MySQL queries from scratch and created views on MySQL for Tableau
  • Carried out various mathematical operations for calculation purposes using Python libraries NumPy, SciPy, and Pandas
  • Served as a Tableau Liaison to mentor our team on all Tableau best practices while supporting other developers specifically in data-source identification
  • Involved in working on different sets of layers of Business Intelligence Infrastructure
  • Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards
  • Monitor, Triage, Track, and resolve issues with the Excel Power BI reports
  • Prepare the data rules spreadsheet using MS Excel that is used to update allowed values, findings, and profiling results
  • Collaborated with cross-functional teams to gather requirements, design data models, and optimize performance in SSIS, SSRS, and SSAS solutions, resulting in streamlined processes and improved data accessibility
  • Experience with ETL/ELT tools like Databricks, Matillion, Azure Data Factory, and Informatica
  • Experienced in cloud-based data warehousing solutions such as Redshift, Synapse Analytics, and Big Query
  • Built comprehensive dashboards in MS Excel using Pivot Table and VLOOKUP to analyze and create forecasts that articulate business requirements, financial data, and operational results
  • Designed and deployed reports with Drill Down, Drill Through, and Dropdown menu options and Parameterized and Linked reports using Tableau
  • Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, and structure and to maintain data efficiently
  • Created Tableau scorecards, and dashboards using stack bars, bar graphs, scattered plots, geographical maps, and Gantt charts using show me functionality during POC
  • Generating various capacity planning reports (graphical) using Python packages like NumPy, Matplotlib, and SciPy
  • Published Dashboards onto Tableau Server and from there consumers would choose viewing medium laptop, PC, or iPad
  • Performed statistical analysis using R for hypothesis testing, regression analysis, and insight generation to improve click-through rate and sales
  • Proficient in working with NoSQL databases like MongoDB, utilizing their flexible schema design and efficiency
  • Data retrieval capabilities for handling large volumes of structured and unstructured data
  • Performed Data Analysis and Data profiling using complex SQL on various source systems including MS SQL Server
  • The building, and publishing of customized interactive reports and dashboards, report scheduling using Tableau
  • Responsible for physical/logical data modeling, metadata documentation, user documentation, and production specs
  • Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality

Machine Learning- Intern

DIGITHON
05.2019 - 07.2019
  • Text Analysis and Classification of SMS spam were trained in Supervised, Unsupervised, and reinforcement ML models
  • Cleansed and Transformed data extracted from various data sources using NLP
  • Developed ML model to train and test data using various Algorithms to get maximum accuracy
  • ML, Data Visualizations, Python- Pandas, NumPy, Matplotlib
  • Sorted and organized files, spreadsheets, and reports

Education

Master’s degree - computer science

Missouri State University
Springfield, MO
12.2022

Bachelor in computer science and engineering -

Malla Reddy College of Engineering And Technology
Hyderabad
09.2020

Skills

  • Programming Languages: SQL, Python, R, PL/SQL
  • Databases: Redshift, SQL Server, DB2, MySQL, PostgreSQL, Oracle, NoSQL (MongoDB, Cassandra)
  • Data Visualization Tools: Business Intelligence (Power BI), Tableau, Oracle BIP, Snowflake
  • Data Science: Proficient in statistics, analysis, data exploration, predictive modeling, and implementing machine-learning algorithms for data-driven insights and decision-making
  • Data/Statistical Analysis: Packages such as R – ggplot2, Python – NumPy, pandas, SAS, and MATLAB
  • Amazon Web Services (AWS): Familiar with AWS solutions like EC2, DynamoDB, S3
  • Data Mining and ETL: Experience in data mining, ETL processes, and working with large-scale, complex datasets in a business environment, Apache Spark
  • Microsoft Office Suite: MS Word, MS Excel, MS PowerPoint, Microsoft Visio, MS Access
  • Other Skills: Git, GitHub, Project Management, Agile Methodologies, Software Development Life Cycle (SDLC), Communication, Problem Solving, Customer Focus, and Root Cause Analysis (RCA)

Certification

  • Google Data Analytics Professional Certificate
  • Course certification by Super Data Science on Machine Learning using Python & R
  • Microsoft Technology Associate: Introduction to Programming Using Python
  • Microsoft Certified: Azure Data Engineer Associate - Microsoft
  • Data science - Missouri State University - Dec2022
  • SQL (Advanced) - Hacker Rank – Mar2023

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

Toyota Motors
02.2023 - Current

Data Analyst

E-info chips, India
02.2020 - 07.2021

Machine Learning- Intern

DIGITHON
05.2019 - 07.2019

Master’s degree - computer science

Missouri State University

Bachelor in computer science and engineering -

Malla Reddy College of Engineering And Technology

Similar Profiles

CREATE PROFILE
Sai Ranadeep Reddy Gopu