Rohan Sharma

Woolworths

• Engineered and maintained robust end-to-end data pipelines to support critical business requirements, focusing on the integration and consolidation of data from diverse sources (POS systems, online sales platforms, loyalty programs) into a centralized data infrastructure, ensuring efficient ETL processes.
• Utilized SQL to extract and load data seamlessly into data warehouses, supporting analytical queries.
• Utilized Python (pandas) to extensively transform and manipulate extensive datasets through cleaning, merging, and transforming processes.
• Developed and implemented automated Python scripts for real-time data ingestion and processing, significantly improving the speed and reliability of data-driven decision-making by 15%.
• Developed interactive Power BI dashboards and visualizations for real-time tracking of customer footfall, average transaction values, and product category performance, resulting in a 40% increase in data-driven decision making.
• Built and optimized machine learning models for customer segmentation and predictive analytics using Python libraries such as scikit-learn, improving targeted marketing strategies by 35% and increasing customer engagement by 20%.
• Collaborated with cross-functional teams to ensure that data solutions were aligned with business objectives and optimized for performance, scalability, and security.
• Utilized Jira to track project tasks, manage sprints, and ensure timely delivery of data engineering projects.

Samsung

• Designed and developed custom Python-based data pipelines for the extraction, transformation, and loading of customer support interactions, feedback surveys, and service call data from various channels via REST APIs, contributing to the seamless integration within the data infrastructure.
• Designed and implemented scalable data architecture solutions for efficient handling of large-scale data, ensuring integrity and consistency organization-wide.
• Leveraged Python (pandas) for advanced data wrangling tasks such as cleansing, transforming, and normalizing data.
• Automated routine data processing tasks using Python, improving data update cycles and ensuring timely availability of accurate data across various systems.
• Executed complex SQL queries to enhance analysis efficiency and support cloud-based data storage and management solutions.
• Implemented deployment of scikit-learn machine learning models for the purpose of analyzing customer sentiment and predicting support service performance. This resulted in a significant 20% uplift in customer satisfaction metrics.
• Conducted EDA in Python to extract insights from customer support data, resulting in a 15% improvement in service quality.
• Developed and managed dynamic dashboards and reports using Tableau, providing stakeholders with real-time insights into customer sentiment and support service performance, facilitating a 30% increase in data-driven decision making.
• Implemented automated reporting solutions using Python, resulting in a 25% improvement in reporting efficiency and supporting strategic decision-making processes.
• Coordinated and managed data engineering tasks using Jira, ensuring adherence to project timelines and delivering high-quality data solutions.
• Utilized Postman to conduct API research and testing, guaranteeing the precision and effectiveness of data integration procedures by rigorously validating and troubleshooting REST APIs.

Database Management

• Managed production metrics and quality control measures by utilizing SQL to update records, ensuring data accuracy and enhancing database efficiency.
• Processed and organized extensive datasets relating to paper production and mill operations. Utilized Python for data wrangling, enhancing operational efficiency and streamlining data management practices.

Documentation and Reporting

• Extracted and analyzed data using SQL queries and Python scripts to prepare comprehensive reports summarizing key performance indicators.
• Worked closely with teammates to uphold the integrity and accuracy of mill databases, supporting informed decision-making based on reliable data.