Vivek Chalvadi Email and Phone Number

Downloading Data from server and mapping the same as per requirement.Coordinating with different Team for data checking and accuracy.Creating PAN-INDIA dashboard.Cluster(Regional) Dynamic dashboard in Excel.REVENUE analysis.

Tableau

Designed and built statistical analysis models on large data sets that helped lowered decarburization rate by 9%. which automatically qualified customers need resulting in a lift in production rate of 23% using MS excel, Data validation, Conditional Formatting, Data cleaning, Pivot Tables and charts for visualization to find insights. Automated MIS report for the Production team using MS Excel, Formulas, conditional Formatting and Macros.Proficiency in data analysis tools and coding experience with Python, SQL. Apply statistical techniques and data visualization to communicate findings effectively.Advanced Excel skills with 1-2 years of data processing experience Strong data visualization skills, and usage of data visualization tools Tableau, Power BI.Experience in working with large and complex datasets, data warehousing and data modeling.Project management experience and the ability to prioritize and manage multiple tasks effectively.Monitor project timelines and ensure timely delivery of high-quality analytics solutions.Use data visualization skills and storytelling to drive actions from internal customers. Handling customer complaints.

1. Collected, cleaned, and provided modeling of structured and unstructured data used for boost the production by reducing lead time.2. Analyzed the dataset using data cleaning, advance excel dashboard to visualize and create a model specific for individual Rolling mill plan, which effectively boost the production by 14%.3. Analyzed data on established and prospective customers to create a dashboard in Excel for data reporting using pivot tables and VLOOKUP that helped to boost dispatch by 25%.