Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Projects
Timeline
Generic
Raman Kumar

Raman Kumar

Bengaluru

Summary

Data Engineering | Data Analysis | Data Science | Big Data | Microsoft Azure

Experienced data professional with over 11 years of expertise in Data Engineering, Data Analytics, Big Data and Data Science within the BFSI and Finance & Accounts domains. Proficient in SQL, Python, Spark, Hadoop, Linux, and visualization tools like Power BI, Tableau, and Apache Superset. Skilled in data wrangling data Analysis and impactful visualization. Demonstrated ability to handle large datasets and collaborate effectively across teams. Ready to apply expertise to drive success in challenging projects.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Kadel Labs
06.2023 - Current
  • Analyze the Last Mile Delivery data and extract important insights from it
  • Automate Multiple Daily MIS Reports for Clients
  • Created Multiple Dashboards for both Operations and Finance team to analyze their activity on daily basis.
  • Created an Daily Automated Reports for Senior Management and Stakeholders to Analyze the business performance
  • Tools Used- Python, Excel, Sql, Apache Superset.

Lead Infrastructure MIS Data & Analytics

Concentrix
01.2023 - 06.2023
  • Analyze and categorize the globally raised Incidents with the help of Text Analytics and NLP using Python
  • MIS Reporting using Excel & Data Visualization using Power BI Predictive Analytics (Creating a Forecasting Model to predict the future requirements)
  • Machine Learning
  • Automating the MIS activity part in Excel to reduce the manual effort by using Python
  • Tools Used- Share Point, BMC, Remedy, Python, R, Excel, Power BI

Data Engineering Support Analyst - ETL

Tata Consultancy Services
03.2019 - 12.2022
  • Worked as an individual contributor managing the entire ETL project to run it as BAU
  • Extract the both Transactional and Non Transactional Data from different sources to the landing path; analyze the quality, consistency, accuracy & relevancy of data.
  • Analyze the root cause of any failure during production for Application Support specific and get it resolved within SLA
  • Monitor the Production activity to get it complete within defined interval
  • Incident , Alerts & CR Management Through Service Now
  • Creating Monthly Service Review PPT where entire monthly activity is represented to client in both Tabular and Graphical format
  • Tools Used- MySql, Tableau, Hadoop, Linux, Hive, Azure, ETL, PySpark

Data Analyst

Tata Consultancy services
11.2012 - 02.2019
  • Reconcile the accounts based on statement received from customers against the invoice posted in system
  • Provide resolutions against the Vendor Queries
  • Raising EFT
  • MIS Reporting using Excel Creating and Analyzing Monthly Payments Reports & Dashboards
  • Tools Used- SAP FI, Excel, Power BI

Education

Masters, Physics -

Mahatma Gandhi Kashi Vidyapeeth
06.2012

Skills

  • SQL
  • Python
  • PySpark
  • Tableau
  • Power BI
  • Excel
  • Hadoop
  • Hive
  • Linux
  • Jenkins
  • CI/CD
  • Git
  • GitHub
  • Azure DataBricks
  • Azure DataFactory
  • Azure Synapse Analytics
  • Data Modeling
  • System Design
  • Data Warehousing
  • Dashboard Creation
  • Machine Learning

Certification

  • IBM Data Science Professional Certification
  • Tableau Desktop Professional Certification
  • Microsoft Power BI
  • Python

Accomplishments

  • Employee Of The Year
  • Star Performer of the Quarter
  • Start Performer of the Month

Projects

Enhancing Packing Algo Analytics-

Leveraged targeted access to delivery and driver data to optimize packing algorithms and boost operational efficiency, focusing on each territory. Conducted analyses including Delivery Volume, Driver Pay, Consignment Size distribution, Distance Traveled, and Consignment Size Average.

Operations Dashboard-

Successfully executed enhancements for the Operations Dashboard, implementing an hourly data refresh cycle. Leveraged the System Data as the foundation for reporting metrics, including Total Volume and On-Time Delivery (OTD) Orders, ensuring accuracy and timeliness

Finance Dashboard-

Successfully led and executed enhancements to the Finance Dashboards, streamlining data visualization and analysis processes. Utilized SQL and data analytics expertise to calculate various KPIs, such as Total Revenue, Total Expenses, Gross Profit, Active Drivers Insights and many more.

Timeline

Senior Data Analyst

Kadel Labs
06.2023 - Current

Lead Infrastructure MIS Data & Analytics

Concentrix
01.2023 - 06.2023

Data Engineering Support Analyst - ETL

Tata Consultancy Services
03.2019 - 12.2022

Data Analyst

Tata Consultancy services
11.2012 - 02.2019

Masters, Physics -

Mahatma Gandhi Kashi Vidyapeeth

Similar Profiles

CREATE PROFILE
Raman Kumar