Sep 2020 – May 2024 · 3 yrs 8 mos · Boxmeer, North Brabant, Netherlands · On-site

• 🎯 Led and delivered end-to-end Business Intelligence (BI) solutions for marketing, commercial, and manufacturing teams at MSD/Merck Animal Health, providing strategic leadership in driving impactful results.
• ☁️ Spearheaded the implementation of a cloud-first strategy, mentoring team members and leading the migration of new projects to AWS cloud as part of an enterprise-level digital transformation.
• 🤝 Collaborated closely with third-party vendors, providing leadership in ensuring timely project delivery while guiding and mentoring cross-functional teams.
• 🛠️ Designed and established migration architectures for transitioning on-premises systems to the cloud, leading teams through lift-and-shift, partial, and full re-architectures.
• 🔄 Led the migration of complex data systems from Oracle and SQL Server to AWS Cloud Stack, mentoring team members through each stage of the process.
• 🚀 Applied Agile methodologies, taking a leadership role in scrum ceremonies (stand-ups, sprint reviews, planning, retrospectives) and mentoring teams while using project tracking tools like Kanban and JIRA boards.

Aug 2018 – Aug 2020 · 2 yrs · Brussels Area, Belgium · On-site

• 🚀 Led multiple end-to-end analytics projects, from data integration to dashboard creation, leveraging Azure and MicroStrategy tech stack to deliver impactful insights.
• 📊 Collected real-time modem data using Apache Ni-Fi and processed it with Azure DataBricks, enabling efficient data flow and analysis.
• ⏱️ Developed near real-time analytics to monitor and assess modem health, providing actionable insights for proactive management.
• 🛠️ Worked with Apache Airflow for orchestration, streamlining data workflows and ensuring seamless execution of data pipelines.
• 💡 Created a fraud detection analytics product used by the finance department to identify customers misusing SIM cards, enhancing security and compliance.
• 🌍 Led teams in both on-shore and off-shore models, effectively managing collaboration and delivering results across global teams.

Feb 2017 – Jul 2018 · 1 yr 5 mos · Bengaluru Area, India · On-site

• 🔄 Worked in Enstoa's implementation team, specializing in data integration and migration with Primavera Unifier and SQL Server, delivering robust solutions for diverse client needs and ensuring seamless data transitions.
• 📊 Delivered multiple data solutions for clients, using Enstoa's Adapters and Oracle BI Publisher to create effective dashboards and reports, providing clear, actionable insights for better decision-making.
• 🤖 Implemented and automated Salesforce and QuickBooks integration, developing workflows to streamline internal processes, reduce manual effort, and improve data accuracy in report generation.
• 🛠️ Built advanced parsing solutions for JSON and XML data formats using SQL Server, enhancing data processing efficiency and improving reporting capabilities for complex datasets.

Jun 2015 – Jan 2017 · 1 yr 7 mos · Bengaluru Area, India

• 🎯 Developed operational data warehouse and master data management solutions for a leading US-based insurance firm, collaborating with a team of 8 on data integration using Informatica PowerCenter.
• 📊 Built complex ETL pipelines, including SCD-2, historical data loads, and pushdown optimization to handle large data volumes effectively.
• ✅ Created a data quality template to resolve diverse DQ issues from heterogeneous sources, standardizing data consistency across systems.
• 🛠️ Utilized advanced transformations like Union, Normalizer, and Java transformations to manage unique and edge case scenarios in ETL processes.
• 🗂️ Involved in data modeling to ensure industry standards and accurate data relationships, optimizing performance and scalability.
• 🔍 Worked on Informatica MDM after setting up the ODS layer, defining custom rules for a comprehensive 360-degree view of customer data.

Jul 2012 – May 2015 · 2 yrs 10 mos · Bengaluru Area, India · On-site

• 🔄 Worked on multiple data integration and migration projects, ensuring seamless data transitions and efficient integration across systems.
• 💻 Developed SQL scripts and PL-SQL procedures, optimizing database operations and enhancing data processing efficiency.
• 🛠️ Built data pipelines using Talend DI to create the Operational Data Store (ODS), streamlining data flow and storage.
• 📊 Utilized Informatica PowerCenter to design SCD Type-1 and SCD Type-2 dimensions, ensuring accurate historical data tracking and efficient data modeling.
• 🖥️ Created Unix scripts to manage and process various file types before loading them into Oracle DB, automating tasks and improving data handling accuracy.