Holding 5+Years Of Experience in Data Analyst by using statistical data analysis. Possess strong analytical, troubleshooting, problem-solving, and project management skills. external and internal business partners including interactions with all levels from high-level executives to subject matter experts.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
Work History
Data Analyst
OLA
Bangalore
03.2022 - Current
Writes SQL queries to fetch data from database using data platform HUE (Hive & Presto)
Created Interactive reports by using PowerBi
Makes Trackers in google sheet to track daily level cab/auto/bike bookings, active cars, drivers etc
Preparing vendor payments Files
Set up a automated schedule for SQL query it will automatically write the result of query in google sheet
Experience of using excel/google sheet functions & formulae like if, Sumifs, countifs, averageifs, vlookup, index match, left, right, mid, trim, substitute, weeknum, conditional formatting, pivot table, query, importrange, excel and google sheet column chart, pi chart, column chart, line chart etc
Hands on experience on SQL statement select, where, left join, inner join, outer join, group by, window functions, row_number() and case when etc
Making Adhoc Calling Reports Hours and Daily wise by using Google Sheets
Weekly Update AHT (Average Handle Time) based on this per agent how many hours working
Reactivation SAC calculations, Creating SAC every week on drive weekly folder 'SAC' (Supply Acquisition Cost)
Update 'GMV' (Gross merchant value), incentive and 'SAC' calculation on GMV sheet
Operations Executive
Prione Business Service Private Limited, AMAZON
Bangalore
03.2020 - 12.2021
Prepared monthly & weekly Performance Status Reports
Preparing Reports PowerBI Dashboard
Successfully process invoice for IHS, prime food and FPA
Created PR’s for IHS (I Have Space) & amazon food (prime food)
Automate reports which were used to send on daily bases
Handling the Onboarding and Offboarding associates joining process by Lead square
Follow up with multiple Agencies to get the desired results
I used various tools to provide on ground support to assess inputs like PO management, Shipment, Procurement, Billing invoices
Understanding the standard operating procedures (SOP) for vendor management and implementation
Extensive experience with Billing invoices and PO management I have gained good knowledge in
billing invoices which let me grow myself from an individual contributor role to team management role.
Data Analyst
Nielsen Sports India Private Limited Bangalore
05.2017 - 06.2019
Downloading, updating & processing files using MS-Excel & Data analysis, from the server using
MELTWATER
Responsible for extracting, loading & validation of sports-related data around the globe according
to the client requirement
Process the analyzed Consolidate data through Quality Check if any error found then correct them
Assisted in the training of 3 junior trainee analysts
Responsible for data gathering and updating in company’s Database
By integrating a suite of industry leading tools, we offer brands and rights holders a range of solutions
to optimize the commercial effectiveness of clients and help them make smarter business decision
ACHIEVEMENTS
Achieved LIMELIGHT AWARD for outstanding performance in Nielsen Sports
ACADEMIC RECORD
B
Tech (Electronics & Communication) from JNTU Anantapur mu (A.P)
Education
Bachelor of Technology - Electronics And Communications Engineering
Jntua
Anantapur
06.2011 - 05.2015
Skills
TECHNICAL SKILLSundefined
Timeline
Data Analyst
OLA
03.2022 - Current
Operations Executive
Prione Business Service Private Limited, AMAZON
03.2020 - 12.2021
Data Analyst
Nielsen Sports India Private Limited Bangalore
05.2017 - 06.2019
Bachelor of Technology - Electronics And Communications Engineering