Sumant Kumar

1) Conducted detailed requirement gathering sessions , translating stakeholder needs into actionable project deliverables.

2) Simplified complex datasets into easily understandable visuals, enabling management to make informed decisions quickly using Tableau.

3) Worked on developing the Benchmarking report for comparing the organization's Performance metric with industry standards using Python and tableau.

• Used K-Means Clustering for Calculating the cost at different cluster and then comparing it.

4) Conducted detailed Data requirement sessions and providing advance SQL Script for transformations.

1) Build Strategic as well as Analytical Dashboard for Client with KPI such as purchase compliance rate,order cycle time, supplier defect rate, Vendor rejection rate using Tableau.

2) Build Operational reporting in Tableau to find areas of improvement for contractor resulting in 30k Annual reduction in Fixed cost.

3) Data Analysis & Strategy: I gather, cleanse, and analyze extensive datasets to unveil trends in revenue, competitor sales, market dynamics, and customer engagement.
4) Stakeholder Engagement: I excel in translating complex data findings into actionable insights, effectively communicating key recommendations with business leaders to guide strategic decisions.

1) Created T-SQL Triggers, Functions and Performance tuning for maintenance of data integrity.

2) Extracting and harmonizing data coming from various channels digital channel.

3) Performing QA on weekly basis for 15 M rows of Data

4) Handling Adhoc requests and project tracker to ensure client SLA are met.

Language and Technologies: Python, SQL

1) Generating Daily Weekly and Monthly Sales reports.

2) Augmenting the revenue by 30 percent by regularly monitoring the KPIs and seeking strategic solution

Language and Technologies: SQL, Microsoft excel