Post Job Free

Resume

Sign in

Data Analyst

Location:
Richardson, TX
Posted:
October 19, 2020

Contact this candidate

Resume:

GAUTHAM SAI MADALA RAJAGOPALA NAIDU

adg4ju@r.postjobfree.com 469-***-**** linkedin.com/in/gauthamsaimr github.com/gauthamsaimr SUMMARY

Analytics champion with experience in building and managing analytical, business strategies and statistical tools for Data- driven decision making and managing end to end program. Innovating on efficiency-boosting hacks to create products and make customers’ lives better.

EXPERIENCE

Data Analyst, ParkHub, Dallas, TX Aug 2019 - Oct 2020

• Implemented KPI’s to help increase cashless payments and analyzed payments data using Python, SQL to predict the likelihood of prepaid’s for clients using linear and logistic regression with an accuracy of 65%

• Provided ad-hoc datasets, data analysis, reports and interactive dashboards on inventory management, customer success, payments using Postgres, Python, AWS, Tableau and Pivot Tables

• Created data pipelines, data cleaning and preprocessing procedures on 15+ JSON files to tabular format for Business Intelligence using AWS, Python, RESTful API and reduced latency by 35%

• Classified Covid-19 data using R, Machine learning algorithms to understand key factors that influenced the customers behavior and its effects on the company’s business using multivariate analytical models in Python, PowerBI

• Maintained internal reporting platforms, dashboards and performed troubleshooting procedures on data pipelines, and developed report specifications and solutions based on requirements

• Analyzed product data to solve client issues and reduced the return merchandise by 30% and saved 1M $ every quarter Analyst, Under25, Bangalore, India Apr 2017 - May 2018

• Developed and automated reports, dashboards in PowerBI over 100 services provided for various clients and created internal reports for sales and accounts team using Pivot tables, SSRS

• Coordinated with the product, operations team for new data tables, and helped with the schema, data pipelines needed for real-time reports using Postgres, Oracle

• Provided strategy and preliminary analysis needed before the launch a new campaign in serviceable cities over the existing campaign,and analyzed the effects using statistical inference and improved conversions by 35%

• Analyzed sales data on a daily basis using SAS, SSRS for media and marketing team to identify partnerships, deals and increased the reach by 35% in 5 cities

• Surveyed the trend regarding companys different membership tiers; developed and launched a new membership tier projecting an increase of 100K new users in the first 12 months PROJECTS

E-commerce Product Analysis using Azure Data factory

• Used Azure Data services to build data pipelines from blob storage, SQL databases with product data, performed preprocessing using Azure Databricks and created reports in PowerBI to visualize the KPI’s needed for decision making Big Data Analysis on California State Truck fleet

• Utilized Cloudera VM to import data to Hive and performed analysis using Hive, PySpark to determine risk factors for truck drivers in the U.S. to predict, forecast accidents and fatalities reported the visualizations in Tableau Titanic data analysis using Machine learning

• Performed data wrangling, Decision tree analysis, K-mean clustering using R and visualized the same in Tableau

• Analyzing whether sex, class of ticket, etc affected the survival rate of the passengers in the Titanic EDUCATION

Master of Science, Information Technology Management Aug 2018 - May 2020 University of Texas at Dallas

Bachelor of Engineering, Information Science Aug 2014 - Jun 2018 PES University

SKILLS

Databases: MySQL, PostgreSQL, Oracle 11g

Programming Languages: Python, R, SQL, JavaScript, C Management Tools: JIRA, Zendesk, Asana, Kanban

Analytical tools: Tableau, PowerBI, Azure, SAS, Hadoop, AWS, SSRS, Databricks, Excel Certifications: Tableau Desktop Specialist, AWS Data fundamentals, Machine learning, Azure Data fundamentals LEADERSHIP

• President - MIS Club UTDallas : Dec 2018 - Jan 2020

• Speaker Curator- TedXPESITBSC : Dec 2016 - Mar 2018

• Vice Chair- IEEE Pesit BSC : Feb 2017 - Nov 2017



Contact this candidate