Summary
Overview
Work History
Education
Skills
Timeline
Generic

SUPRABATH REDDY GANGANA

EDISON

Summary

Cloud Data Analytics professional with 3 years of experience in Amazon Prime for driving business solutions. Good understanding of different AWS cloud services like EC2, S3, Athena, Lambda, Kinesis. Good working knowledge in all SQL – DDL, DML, DCL, TCL commands. Experience in working with air table to create and share relational databases. Implemented numerous SQL queries like joins, views, synonyms, functions for business requirements. Utilized MS SQL, data warehousing programs, Tableau, and other dashboard toolsets for data analysis. Experience in Business Intelligence, Data Modeling, and expertise in using different file formats like Text files, CSV, JSON, XML, parquet, and others. Proficient in data extraction, data cleaning, data loading, statistical data analysis, exploratory data analysis, data wrangling, predictive modeling using R. Knowledge of R based environment, along with data analytics and Excel data extracts Advanced Microsoft Excel skills for data analysis & experience using complex formulae and functions. Converted data into actionable insights by predicting and modeling future outcomes. Collected and analyzed data on prospective customers, competitors, and marketing channels. Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. Proven experience in managing large datasets, developing insights from the ambiguous data, and facilitating team decisions. Smart project management skills and ability to identify processes that can be automated to save man-hours and resources. Excellent team player with ability to work independently, with strong analytical and communication skills.

Overview

2
2
years of professional experience

Work History

Cloud Data Analyst

Amazon Prime
Hyderabad
10.2020 - 08.2021
  • Analyze market and customer engagement statistics on pilot projects to determine viability for mass launching
  • Apply data and back-end customer engagement metrics to motivate assumptions and assertions of business value
  • Maintained policy, procedures, work instructions and projects for quality and continuous improvement agendas
  • Used AirTable to create and share relational databases by storing, organizing, and collaborating on the data
  • Performed analytics for the data stored in S3 using Athena
  • Created dashboards using Tableau for the master data exported from Athena
  • Identified and analyzed business strategy implications for growing companies to increase longevity
  • Collaborated cross-functionally with business analysts, developers, and testers to explain new process transformations
  • Created, maintained, modified, and optimized SQL server databases, database security and auditing
  • Designed and developed weekly, monthly reports by using MS Excel techniques (Charts, Graphs, Pivot tables) and power point presentations
  • Streamlined processes, increasing efficiency and consistency to support quality initiatives
  • Created a standard operating procedure (SOP) for the amazon vision operation center (AVOC)
  • Audited training and production processes, enforcing adherence to SOPs
  • Generated a regular detailed billing report (DBR) at the end of the month
  • Analyzed data sets gathered through testing to produce and present reports quantifying metrics indicating conformance or variance from production standards
  • Root cause analysis (RCA) and suggestive action revamp
  • Authored SQL-Overrides and filters in source qualifier thereby improving the performance of mapping
  • Performed Data validation, Data cleansing, Data integrity, Data Quality checking before delivering data to operations, Business, by using SQL, Teradata.

Social Work Intern / Sathguru

Management consultancy
Hyderabad
11.2019 - 09.2020
  • Interviewed clients individually and in family groups to determine services to best address specific needs
  • Provided mental health support to homeless clients and connected each with community resources
  • Referred patients to community resources for mental health treatment, child protective services and assistance for people with developmental disabilities
  • Worked on field with farmers to help them build solar panels surrounding their farms which were affected by wild boars around the town
  • Was part of a project with children to make their parents lives easy by donating funds, books and organizing events for them
  • Maintained confidential case documentation
  • ACCOMPLISHMENTS
  • Dashboards: Created visually impactful dashboards in Tableau for data reporting by using heat maps, tree maps, scatter plots and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
  • Data Mining and Modeling: Collected, cleansed, and provided modeling analysis of structured and unstructured data used for business initiatives
  • Recognized as Employee of the month for more than 8 times in the span of 3 years for outstanding performance and team contributions
  • Promoted from AVOC associate to Cloud Data Analyst, in less than 7 months
  • Earned recognition from upper management and financial rewards.

Education

Bachelor of Science - Business, Computer Science Engineering

University of New Haven
05.2023

Computer And Information Sciences

Jawaharlal Nehru Technological University
Hyderbad
08.2021

Skills

  • TECHNICAL SKILLS
  • AWS stack: EC2, S3, Athena, Lambda, Kinesis
  • Programming: R studio
  • Database Management:
  • Microsoft SQL Server, MySQL, AirTable
  • Analytics: Data Cleansing, Data Mining, Data Wrangling, Data Analysis, Statistical Trend Analysis
  • Visualization: Power Bi & Dashboarding, Tableau, RStudio, MS Excel

Timeline

Cloud Data Analyst

Amazon Prime
10.2020 - 08.2021

Social Work Intern / Sathguru

Management consultancy
11.2019 - 09.2020

Bachelor of Science - Business, Computer Science Engineering

University of New Haven

Computer And Information Sciences

Jawaharlal Nehru Technological University
SUPRABATH REDDY GANGANA