As a Data Engineer Lead, I played a pivotal role in the development of the EUDB platform, designed to streamline compliance with EUDB regulations while minimizing manual work and enhancing operational efficiency. The platform features a unified user experience for attestation and re-ownership of Azure DevOps (ADO) work items, alongside a dashboard that allows owners to view their assigned tasks requiring action. The integration with Azure DevOps automatically captures request details in ADO tickets, sends email alerts upon request submission, and provides regular reminders to owners to complete their tasks. This seamless platform significantly reduces the need for multiple hand-offs during ticket triage and automates ADO fields for efficient ticket management.In my role, I led the data engineering team in the design and implementation of the EUDB platform, collaborating closely with stakeholders to gather requirements and ensure the solution met business needs. I oversaw the integration with Azure DevOps, focusing on automating request management and enhancing user experience. My responsibilities included ensuring platform scalability and compliance with Microsoft standards, as well as creating technical documentation for ongoing support. Through these efforts, I contributed to the development of an efficient, secure, and user-friendly platform that meets organizational compliance requirements.

As a Data Engineer Lead, I was instrumental in the development of the MarTech Access Form, a DAP-developed tool designed to provide a seamless, self-service platform for accelerating account creation and provisioning in Adobe. This platform enables the support team to efficiently fulfill access requests for business users by leveraging key capabilities that ensure compliance with security regulations, including validating user identities and the types of access requested. The tool enhances operational efficiency by reducing manual interventions required for governance of security policies.In my role, I led the data engineering team in designing and implementing the MarTech Access Form, collaborating closely with stakeholders to gather requirements and ensure alignment with business needs. I oversaw the development of the access framework, integrating compliance measures and automated processes. My responsibilities included ensuring high performance of the platform, creating documentation for ongoing support, and providing guidance for future enhancements. Overall, my efforts contributed to improving the efficiency and reliability of the account provisioning process within Adobe.

As a Data Engineer Lead, I played a crucial role in developing DDAM, a robust platform designed to streamline user access requests and multi-tier approvals. DDAM provides a common access framework across data platforms and simplifies access evaluation strategies, ensuring compliance with security regulations. This platform enhances operational efficiency by minimizing manual interventions in the governance of security and privacy policies.Key features of DDAM include a multi-step approval process, integration with Microsoft Teams for approval updates, and a full history view of access requests. The delegation feature ensures approvals during an approver's absence, while multiple approval routes expedite the process. All approval requests are centralized, improving compliance and reducing errors. Notifications for approval or rejection are provided, and approved requests are automatically forwarded to DevOps for provisioning.In this role, I led a team of data engineers, collaborated with stakeholders to align platform features with business needs, and developed a secure and efficient access framework. I implemented Teams integration, automated provisioning processes, and ensured high platform performance. Additionally, I created technical documentation and offered guidance for ongoing support and enhancements.

In Technical Lead role as a developer on the Envoy project, I worked on a microservices-based platform aimed at solving data engineering challenges by automating data wrangling processes. Envoy's primary objective was to eliminate the manual effort of writing SCOPE scripts and copying data from Cosmos to SQL, enhancing overall efficiency. The platform also empowered business users and analysts to create segments and metrics in Adobe Analytics based on campaign and promotion data.Key features of the solution included the ability to submit SCOPE scripts without prior knowledge, simplified onboarding and analysis of small datasets, automated reports and ad hoc data requests, and setting up recursive processes for data engineering.My responsibilities included performing technical exploration and feasibility studies for new implementations using Azure resources, designing server-side computing architectures to optimize data access queries, and implementing security, scalability, and integration with various microservices. I also gathered user requirements, designed the data stores, and managed configuration tasks such as Git branching, labeling, merging, and setting up build and release pipelines. Additionally, I was involved in troubleshooting and creating technical documentation, Azure cost estimation, deployment guidance, and troubleshooting guides for common issues.

In Developer role, I worked on the MSCOM Analytics project, which aimed to achieve consistent metrics, reporting, and analytics across Microsoft's various web properties. The program's objective was to deliver scalable and accurate web analytics and global reporting, integrating multiple dimensions and facts into cohesive data warehouses for a comprehensive reporting environment using Microsoft-owned data. The project followed MSCOM standards, which are a consistent set of digital guidelines, storage services, and programs that facilitate data collection mechanisms, measure user behavior, and optimize data processing on a large scale.The solution featured several key aspects. Data consolidation involved cleaning, enriching, and aggregating data collected in Cosmos, ensuring high-quality and usable information. The measurement phase focused on onboarding metadata and other massive datasets into data marts, which supported better analysis and decision-making. Additionally, the publishing aspect included the aggregation of data, calculation of fields, and the creation of measure groups, all aimed at distributing data effectively to downstream systems and applications.As part of the project, I was responsible for analyzing customer requirements and preparing functional and technical specification documents based on those requirements. I also designed, created, and modified application databases, ensuring they were optimized for performance and reliability. Consolidating and optimizing the available database infrastructure was another key responsibility, aimed at enhancing the efficiency and scalability of the solution.

In my previous role, I worked on implementing the Vendor Code Creation Module (VCCM) in an ASP.NET application. VCCM is a process in SAP used for vendor code creation, involving different roles such as Initiator, Approver, Processor, Conformer, and Admin. The main features of the solution include making the vendor code creation process faster, managing all approval processes efficiently, generating detailed reports, and sending email notifications for every issue raised or updated. The implementation improved the payment process by reducing the turnaround time by 3 days.Roles and responsibilities: I was responsible for analyzing customer requirements and preparing functional and technical specification documents accordingly. I designed, created, and modified application databases, ensuring that they were efficient and reliable. Consolidating and optimizing the available database infrastructure was also a key responsibility, aimed at enhancing the efficiency of the solution.Additionally, I collaborated with business and technology stakeholders to ensure the development and utilization of a robust data warehouse architecture. This collaboration ensured that the technical implementation aligned with business requirements. Furthermore, I carried out monitoring, tuning, and database performance analysis to maintain optimal database performance.

In my role as a developer for Aashay Measurements, I worked on a weather reporting web application that provided daily weather reports for Katraj, Pune, including data in graphical formats using Google Graph. I was responsible for extracting data from different input sources, developing reusable custom datasets, and generating text files for real-time optimization. I also created SQL and PowerShell scripts, monitored data services for issues, and enhanced overall application performance. My work included creating Excel reports, developing/enhancing reporting dashboards, and ensuring data warehouse architecture development through collaboration with stakeholders. Additionally, I optimized the database infrastructure and conducted monitoring and tuning to maintain performance.