- Designed, implemented, and maintained scalable cloud-native data pipelines using Azure Data Factory, Azure Blob Storage, Azure Synapse, and Azure Databricks, supporting both greenfield initiatives and the migration of legacy systems. - Built real-time streaming pipelines with Databricks Structured Streaming, storing data in Delta Lake format for ACID compliance, scalable performance, and time travel. - Developed and orchestrated modular transformations using dbt Cloud on Databricks, enabling version-controlled, testable data models within the Lakehouse. - Implemented Unity Catalog for centralized data access control and lineage tracking across development, staging, and production environments. - Designed and optimized NoSQL data models in Azure Cosmos DB (MongoDB API), supporting high-throughput apps with over 10M documents. - Developed 10+ Power BI dashboards (DAX, Power Query), enabling data-driven decisions across 5 business units. - Automated and modernized SSIS-based ETL workflows, increasing data pipeline reliability and reducing manual overhead by 40%. - Created internal Power Apps to empower business users with self-service access to curated datasets. - Authored comprehensive technical documentation to support onboarding, data governance, and operational continuity.

- Designed and maintained streaming and batch data pipelines using Apache Kafka, Apache Flink, and Spark Structured Streaming, enabling near real-time analytics for clients in fintech and e-commerce. - Orchestrated workflows with Apache Airflow, improving pipeline reliability and reducing operational overhead. - Containerized and deployed data applications using Docker and Kubernetes, ensuring portability and scalability. - Delivered data warehouse solutions with open-source and AWS-native components, supporting advanced analytics. - Built and maintained interactive dashboards and reports in Tableau and Power BI, providing business stakeholders with actionable insights. - Acted as both Data Engineer and BI Analyst, covering the full data lifecycle from ingestion and transformation to visualization and decision support.

- Migrated legacy on-prem systems to Amazon S3, centralizing batch and streaming data for analytics and ML using Airbyte for ingestion and schema tracking. - Built scalable batch pipelines with Apache Spark and real-time streaming with Kafka + Apache Flink, enabling low-latency processing and large-scale data movement. - Integrated NoSQL sources including MongoDB, enriching the lakehouse with semi-structured data for analytics and reporting. - Implemented Apache Iceberg on S3, ensuring ACID compliance, time travel, and efficient storage across raw, staged, and curated layers. - Managed end-to-end workflows in Apache Airflow, handling task dependencies, retries, and SLA monitoring. - Integrated Redshift as a serving layer for downstream BI and SQL analytics, improving stakeholder access to curated data. - Collaborated with data analysts, scientists, and DevOps to ensure data quality, observability, and CI/CD automation across the data lifecycle.

- Performing data manipulations using MySQL and Power Query tools with further dashboard visualisation in Power BI. - Prepare dashboards based on analysis and present them to Top Management.

* Analyze sales of L’Oreal products and its competitors based on Nielsen data by distribution channels to identify if all planned sales and trade initiatives were effective, with further action plan development. * Prepare reports based on analysis in the form of presentation and present them to Top Management. * Prepare analysis of media channels’ efficiency based on costs and sales.

* Prepared analysis and forecasts of revenues and costs based on SAP data for 3 years. * Engaged in monthly closing: reconciled revenues on each product based on SAP data. * Made target costing analysis for price purposes: identified maximum production costs based on market price, target margins, and excise taxes. * Developed template in SAP in collaboration with IT team that decreased report preparation from 10 to 2 hours.