Sep 2024 – Present · 1 yr 9 mos

Dec 2022 – Sep 2024 · 1 yr 9 mos

• Designing and Optimizing PySpark Data Pipelines for PowerApps, DataLakehouse, and Monitors for Business Performance Analytics (BPA) which is a model-driven Power App that consumes data from Dynamics 365 for Finance and Operations (F&O), followed by ingestion into Dataverse, formerly known as CommonDataService, and is then utilized to create Power BI datasets.
• My role is to design, develop, and optimize data pipelines to facilitate this process while ensuring data accuracy, reliability, and compliance that streamline and enhance critical business processes.
• Collaborated with cross-functional teams to design and implement ETL pipelines for ingesting Dynamics 365 for Finance and Operations data into Dataverse-managed data lakes and create BPA.
• Implemented rigorous data governance and quality assurance practices to maintain data consistency, integrity and high performance. throughout the pipeline.
• Played a pivotal role in troubleshooting and resolving issues, minimizing disruptions to business operations.
• Achievements and Impact
• 1. Implemented data quality checks, resulting in a reduction of data error rates by over 90%,improving overall data reliability.
• 2. Identified and addressed the frequently occurring transform failures in ETL processes, leading to a 77% reduction in transform failures, making the system more scalable and reliable.
• 3. Researched and documented ambiguous terms that laid foundation for improvements in BPA Update & Upgrade.
• 4. Created comprehensive build sign-off criteria P0 Build Acceptance Tests (BATs) for BPA-ETL, serving as a crucial guide for post-build validations in the PROD environment.
• 5. Authored and collated Root Cause Analyses (RCAs) to create Troubleshooting Guides to enable seamless cross-team collaboration and accelerate the on-boarding process for new team members.
• 6. Resolving customer issues with RCA in less time than committed Time-to-Mitigate (TTM) of 72 hrs.
• This reflects a strong commitment to customer satisfaction.

Jan 2022 – Nov 2022 · 10 mos

• One of the first set of engineers to work on Financial Insights, Financial Analytical Reporting & Financial Operations for Dynamic-365(ERP - cum- CRM by Microsoft) suite in India.
• Achievements & Impacts:
• 1. Optimized the validation of external tables in Install workflow of FAR (Finance Analytical Reporting) by reducing the number of calls made to Synapse and successfully able to run quick performance tests to ascertain close to ~95% improvement (without changes average time taken was ~3sec, with changes the time was reduced to ~300ms) .This unblocked on-boarding of close to 50+ customers as the earlier ~300ms retry limit was being breached out.
• 2. Came up with the idea to add an extra attribute "Error Code" to the already existing Environment class in API Contracts(this was used as a medium to exchange environment related details between services, specifically Finance Analytical Reporting & Finance Reporting Deployment) - this in turn helped the services to pass specific detailed errors(if any) to the calling services which actually facilitated easier debugging as a result of specific errors being logged in contrast to very general ones in the earlier version of the services.
• 3. Transformed a General Ledger view to a pyspark dimension – the first ever pyspark transformation [ETL] written by the team.
• 4. Enhanced monitor tests to include changes in API contracts and error codes.
• 5. Created automated incident creation for customers on install, extract & transform failures.
• 6. Created dashboards for detailed information on success/failures from Control Plane – for improved & more efficient DRI process.
• Technologies/Frameworks/Tools/Languages:
• C#, .NET, Microservices, Visual Studio, Azure, Dynamic-365

Nov 2023 – Jun 2025 · 1 yr 7 mos · Greater Bengaluru Area · Remote

• Mentored batch of 150+ learners for SQL, Schema Design, Low Level Design & High Level Design

Oct 2022 – Oct 2023 · 1 yr · Greater Bengaluru Area · Remote

• Mentored multiple batches on SQL, Low Level Design, High Level Design, Data Structures & Algorithm, Problem Solving.

Jul 2021 – Sep 2022 · 1 yr 2 mos · Bengaluru, Karnataka, India · Remote

• Tutored multiple batches of 30 students & working professionals, helping them understand Data Structures & Algorithms along with System Design - by taking live classes and live problem solving sessions.
• Mentor & Mock Interviewer

Sep 2020 – Jan 2022 · 1 yr 4 mos · Bengaluru, Karnataka, India

• Designed, developed and implemented Capacity Manager - a cost effective Backend Spring Boot Microservice(JAVA) for Oracle Cloud Infrastructure(OCI) Resource Management which helps in reducing failure scenarios due to unavailable capacity in pod provisioning compared to existing solution and also provided users with many key and advanced new features like intelligent answer whether quota is available to satisfy provisioning request, report the limiting resources in case it cannot be fulfilled, apart from an integrated Cronjob that alerts admin through a Slack message in case of insufficient capacity along with a simple UI for the same in React.js.
• Designed and developed REST API using Spring Boot Microservices in JAVA (and later in Helidon MP Microservices) to expose endpoints for schema-mapping in meta data format using JAVA SDKs for Oracle Cloud Storage(OCI) to allow future scalability of using multiple 3rd party E-Signing services – an improvement from earlier single possible E-Signing service.
• Developed a JAVA Spring Boot Microservice based Cronjob to publish data to development environment which aimed towards automation of the task (manual earlier) and also optimized data retrieval since the process was running at regular intervals to publish latest data in the development environment.
• Worked for a short duration on a Web Development Project in Oracle Store Front(OSF) – a framework built over React.js which aims at consumerising B2B experience. Involved in consuming endpoints for create, delete, update and read Quotes which is required to cater to Sales Experience under B2B - using B2X generalised APIs with certain modifications, if any ---- using Spring Boot Microservices
• Technologies/Frameworks/Tools/Languages:
• JAVA, Spring Boot, Microservices, REST API designing & coding, simple UI development using React.js, Unit Testing, Mockito & Power Mockito, Postman, Helidon MP, Java Quartz(for Cronjobs), OCI, JavaScript

Sep 2020 – Jun 2021 · 9 mos · Bengaluru, Karnataka, India · Remote

• Curated recorded content around Data Structures & Algorithms - English & Hindi
• 1:1 mentoring of students for engineering-specific roles by facilitating and taking Mock interviews.
• Contributed in creating YouTube content around Technical & Behavioural questions for interviews.