RADHAMOHAN SHARMA

• Used statistical methods to analyze data and generate useful business reports.
• Extracted and interpreted data patterns to translate findings into actionable outcomes.
• Utilized data visualization tools to effectively communicate business insights.
• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Created data models to support decision-making processes.
• Developed complex dashboard and reporting tools to track business performance metrics.
• Created dashboards to monitor and track key performance indicators.
• Developed customized reports, summarizing and presenting data in visually appealing format.

I. P2P Data Analytics

The Major Objective of this project was to analyze the P2P data of one of the India's largest paper/yarn manufacturers. The analytics helped us in identifying the loopholes in the process as well as the potential fraud happening in the procurement to payment process.

Contributions:

• Performed the initial data quality checks
• Built the SSIS packages to load the data
• Developed 20+ rules to identify the process gaps/potential frauds
• Built a PowerBI dashboard to show the major KPIs related to analysis done.

II. Travel Data Analytics

• The Major Objective of this project was to analyze the travel data of one of the India's largest online travel agency
• The analytics helped us in identifying the issues in their data and to identify various finance related KPIs.

Contributions:

• Performed the initial data quality checks
• Built the SSIS packages to load the data
• Built a PowerBI dashboard to show the major finance related KPIs.

I. Digital Audit Analytics Review Tool (DAART) – July 2018 to Jan 2022

DAART provides an end-to-end platform to the internal auditors of the Samvardhana Motherson Group to perform Audit across areas like Sales, Purchase, and Inventory etc. Based on the complete data of the Companies stored in the Data Warehouse.

Contributions:

• Data cleaning and standardization using Python.
• Configuration and Development of a highly flexible Rule Engine using T-SQL (with 100+ Rules) that can fulfill all the process differences of various ERP’s.
• Built the basic dashboards for DAART using Power BI/SSRS to monitor various KPI’s like the trend of Revenue Coverage, Exception’s trend Quarterly, Rule engine performance, etc.
• Lead and manage meetings with clients for identifying the gaps in the processes and taking feedbacks from them to improve such processes.
• Handling 2-3 members team dedicated to the development of client’s requirement.

II. Spend Analytics (Global Supplier Performance) – Aug 2018 to Mar 2019

The main objective of GSP - Spend Analytics is to deep dive into the procurement data and derive useful insights from it that can help the management in monitoring purchases at their plants and identifying areas that can help in reducing the spend of plants.

Contributions:

• Vendor data cleaning and standardization.
• Classification of spend into various categories at different manufacturing plants.
• Build KPI’s to monitor spend on various commodities and take decisions to reduce spend.
• Price Alert System that determines drastic change in the price of commodities.

III. Maruti Suzuki Demand Forecasting – Jun 2019 to Mar 2020

The main objective of this project – to match customer demand with plant production, Optimize Plant Production Schedules, Improve Dealer Order Management etc.

Contributions:

• Data cleaning and standardization.
• Built the entire data set for the analysis as per the requirement of the algorithms.
• Helped in building a POC for time-series demand forecast on monthly data using Amazon SageMaker.