Data Analysis Business Process

Sairam Mudadla

Contact no: 331-***-**** Email: ******.*********@*****.***

SUMMARY OF QUALIFICATIONS:

A diligent and enthusiastic professional with 5 years of IT industrial experience.

Experienced in service activity work-flow management using Jira.

Experienced in data extraction and data analysis using SQL.

Experienced in data consolidation for monitoring & reporting using Tableau Dashboards.

Experienced in collaborating with external teams to coordinate activities for smooth execution of business processes.

Experienced in managing logistics of the vehicle fleet, administration, customer on-boarding, customer invoice management and accruals on monthly basis. Contributed towards streamlining & improving business process.

Good team player with excellent communication, analytical and interpersonal skills.

ANALYTICAL/TECHNICAL EXPERTISE:

ANALYSIS:

Tableau, PowerBI, Microsoft Excel, Alteryx

LANGUAGES:

SQL, Python

APPLICATIONS:

Microsoft Office, Microsoft Project, MySQL, SQL Server, Google Docs, JIRA

EDUCATION:

Master of Science in Data Science Expected: December 2024

Lewis University, Romeoville, IL GPA: 3.7/4.0

Bachelor of Technology May 2015

Dadi Institute of engineering GPA: 71/100

Majors: Electrical Engineering

Minor: Electronics Engineering

PROFESSIONAL EXPERIENCE:

As an MIS Analyst, December 2021 – December 2022

Yupp Tv, Hyderabad, India

Organization Description:

Apalya Technologies is an end-to-end plug and play OTT platform that handles content management, CDN, security, user experience management, transactions, promotions, analytics and insights.

Roles & Responsibilities:

As a client of Vodafone Idea I used to track all the data of VI OTT platform on a daily basis, maintain the data and do analysis by generating a repots and publish it to the client for insights.

Responsible for data extraction using SQL from data base and do data analysis for the extracted data using MS-Excel and draw the conclusions accordingly and share the reports across the teams.

Responsible for data extraction from different source medium like Clevertap, Tableau, Appsflyer, Google Analytics and Google play console and share it across the teams and client based on requirement.

Responsible for data analysis & identify data patterns to determine demand across the content partners which are a part of Vodafone idea.

As an Operations Analyst July 2019 – November 2021

Zoomcar, Hyderabad, India

Organization Description:

Zoomcar is a self-drive car rental company and has given customers more control, and freedom. It has enabled driving convenience for travelers around the country and is fast expanding.

Roles & Responsibilities:

Responsible for data analysis & identify data patterns to determine demand-to-supply ratios for vehicle brands & models. Based on data diagnosis, make informed decisions on increase or decrease of monthly subscription price for a vehicle brand & model.

An enthusiastic individual with attention to detail to functional behavior, covering different business scenarios. In this role, showed great potential in learning the comprehensive view & streamlining the business process.

Customer invoice management and accruals on monthly basis for about 700 Zoomcar monthly subscribers including invoice generation, invoice discrepancies resolution, invoice payments tracking and root cause analysis are part of OKR's. In case of payment default, the car is recovered and monthly subscription is terminated on Zoomcar platform until dues are settled.

Maintained cars inventory data relevant for monthly subscriptions. Applicable car data is consolidated through Tableau dashboards, data extracts using SQL queries. Manage & track status of car maintenance & service activity work-flow management using JIRA

As an MIS Analyst December 2016 – December 2018

Ola Cabs, Hyderabad, India

Organization Description:

Ola Cabs is a rides offering company which also offers services that include vehicle for hire and food delivery.

Roles & Responsibilities:

Manage customers demand for Hyderabad region on vehicles usage (cabs & autos) and maintain the data for decision making for revenue generation.

Responsible for data analysis on customers vehicle usage demand to determine patterns considering multiple factors like areas, time periods, week-day versus week-end to ensure the existing vehicle supply meets the customers demand at any time.

Responsible for improvement of revenue generation. In areas of opportunities, structured creation of incentive offers & organize on-line campaigns (within approved thresholds) for vehicle owners to be available at certain time periods & areas. Track the incentives redemption to determine the vehicle owners & customers behaviors to perform future business analysis for decision making.

Reports generation for management review on the business analysis, decisions considered along with the rationale and redemption behavior of customers/vehicle owners.

Contact this candidate