Himanshu Dwivedi

Extracted, cleaned, and transformed large datasets from various sources, ensuring data accuracy and consistency for sales performance analysis. Retrieved and manipulated sales data from the company's databases, including extracting information on product sales, customer demographics, and regional performance. Collaborated with the sales and marketing teams to identify key performance indicators (KPIs) and generate custom reports, dashboards, and visualisations using Excel and Matplotlib resulting in a 10% increase in revenue. Implemented advanced Excel functions, such as VLOOKUP and PivotTables, to analyse sales data and customer preferences, enabling personalised marketing strategies. Developed Python scripts for automating data cleansing processes, saving over hours per day in manual data preparation tasks. Presented actionable insights and recommendations to senior management through visually compelling reports and presentations, influencing sales strategies.

Conducted comprehensive data analysis on user behaviour patterns using SQL queries, Python scripts, and Excel spreadsheets to optimise website and app performance. Collaborated closely with development teams to define key performance indicators (KPIs) and generated custom reports and visualisations using Excel and data visualisation tools. Utilised SQL to extract, clean, and transform data from web and app usage logs, uncovering insights that influenced feature enhancements and user engagement strategies. Developed Python scripts to automate data processing tasks, such as data cleaning, aggregation, and validation, resulting in a reduction in data preparation time. Created detailed documentation for data analysis processes, ensuring transparency and knowledge sharing among team members.