Shubham Ranakoti

Shubham Ranakoti

Data Analyst
United Arab Emirates
Hindi, Japanese, English

About Me

Diligent data analyst with 2.5 years of experience in evaluating and creating dashboards and creating interactive reports with extensive knowledge of SQL, Python, Power BI. Honing strong analytical skills, decision-makin…

Experience

Data Analyst

Cognizant
Mar 2022 - Jul 2024 · 2 years 3 months

Retrieved data from client servers using Snowflake and SQL workbench and then modified the data as per the requirement by data preparation & processing and then transformed and visualized the data. Data cleaning and visualization using different python libraries such as Pandas, NumPy, Seaborn and Matplotlib. Responding to data-related queries, setting up processes to make data more efficient. Analysing and interpreting trends from the data, and reporting trends to add business value using Power Bi and SQL which helped the organization increase sales value over a quarter. Created summarized interactive reports for the BU heads and client meetings to showcase the spend analytics and indirect cost using Microsoft Power Bi DAX queries which helped the organization increasing the Managed revenue by 20 million $.

Data Analyst

Cognizant, Pune

Retrieved data from client servers using Snowflake and SQL workbench.
Modified the data as per the requirement by data preparation and processing.
Transformed and visualized the data.
Performed data cleaning and visualization using Pandas, NumPy, Seaborn, and Matplotlib.
Responded to data-related queries.
Set up processes to make data more efficient.
Analysed and interpreted trends from the data.
Reported trends to add business value using Power BI and SQL.
Helped the organization increase sales value over a quarter.
Created summarized interactive reports for the BU heads and client meetings.
Showcased spend analytics and indirect cost using Microsoft Power BI DAX queries.
Helped the organization increase the Managed revenue by 20 million $.

Skills

Power BI DAX Data Modelling Data Cleaning Data Transformation Data Visualization SQL ETL Query Optimization Data Loading Data Manipulation Python Pandas Matplotlib NumPy Seaborn Azure SQL database Azure Data Lake Azure Data Factory Advanced Excel Power Pivot Power Query Macros Charts Problem Solving Critical thinking Creativity Active listening Adaptability Teamwork Snowflake SQL Workbench
Report this Profile?