Rama Krishna

Data Analyst

UBER•  March 2024 - Present•  Chennai

Deep diving into Marketing Analytics. Delivered insights to campaign recommendations analysis, day-parting analysis, competitor analysis, etc., leading to increased spending on the Uber Eats platform. Optimizing data solutions with tools and platforms such as Python, SQL and Tableau. Developed a Tableau based Offer Dashboard rendering the need for post campaign offer report obsolete. Developed SQL Queries for data extraction.

Associate

Cognizant•  November 2021 - March 2023

Used Python Libraries such as NumPy, Pandas, Matplotlib and Seaborn to Analyze large Data sets. Performed Data Pre-Processing and Cleansing using Python. Extracted the data from various applications and databases. Developed SQL queries as per Business requirements. Prepared Business Reports and published to relevant teams. Performed tasks like Data Extraction, Data Validation and Transformation. Identified Data Mismatch /loss and reported the same.

Management Information System Analyst

Reliance Retail•  February 2021 - November 2021

Created Business Reports for higher management using data visualization techniques. Developed SQL Queries for data extraction. Prepared Data Visualization Dash Boards, Charts &Calculations using Tableau. Experienced in designing complex dashboards that take advantage of all Tableau functions including data blending, actions, parameters, Reference Lines and more. Expertise in creating different visualizations using Lines, Pies, Histograms, Waterfall Chart, Funnel Chart, Donut Charts, Scatter, Bullets, Heat Maps, Tree maps, etc. Having good Experience in creating dashboards, volume reports, operating summaries and presentations. Prepared MIS Reports using MS Excel and published the same to Relevant teams.

Senior Management Information System Analyst

Flipkart•  November 2019 - January 2021

Preparing Dashboards using calculations, parameters in POWER BI. Used Trend Lines, Parameters, Slicers, Aggregate Functions and filters. Read business user requirements, analyze data, and generate reports in power bi Desktop based on the requirements. Designing & developing of Power bi reports in dashboards for Operations & Marketing business group Built interactive reports and dashboards using Power bi Desktop. Extensively used SQL Queries for Data Extraction. Developed SQL Queries for Business Requirements. Prepared Supply Chain Reports like Purchase Orders, Goods Received, Sales. Coordinated with Buying Managers and Warehouse Managers. Maintained Google sheet Trackers for data updates.

Data Reporting Analyst

Tesco•  April 2016 - August 2017

Prepared supply chain Reports like Inventory Report, Purchase orders Report, goods received Report, Sales Report using MS Excel. Used advanced excel formulas like Index match, VLOOKUP and Nested IF conditions. Prepared summary reports using Pivot Tables. Developed Excel Dashboard with various Charts and Graphs. Quickly Responded to emailed requests for data updates. Verified documents like GRN, PO, Invoice, Debit note, and Credit note. Resolved vendor’s complaints relating to short deliveries and over deliveries. Created documentation and provided cross training on developed Excel templates.