Deepak Yadav

• Designed and implemented a product for notifying and deactivating users based on their inactivity period in Azure DevOps. This product was end-user driven and takes action based on user response. Multiple Azure technologies were involved, such as Logic Apps, SQL Server, Outlook, Azure web jobs, Azure app configurations, Azure key vault, and C#.
• Security enhancements in product using threat modelling tool, securing network using Azure VPN, and managed Identity.
• Worked on OKR tracker tool and made multiple enhancements, reducing the cost from $1,200 to less than $100. Also, migrated Azure data clusters from one subscription to another, resulting in cost savings. Removal of certificate expiration using managed identity, which is server-to-server communication on Azure.
• Index reporting of monthly business review for Azure hardware. Designed and developed a tool for parsing complex Excel sheet with merged cells by auto-filling cells and processing for report generation on a monthly basis. For data storage, Azure Data Lake Storage and Logic Apps, and Azure Functions were used.
• Integrated Azure OpenAI natural language to SQL converter into OKR tracker tool to simplify user queries. This tool basically takes user queries in the English language and translates them to Azure data cluster queries using an adapter, and returns results.
• Design and build a unified line of business tools, which is a one-stop shop for all lines of business tools. Integrated various services AuthN & Z using Azure AD, telemetry logging, Azure deployments on app, multiple APIs built in C#, built CI/CD pipelines, virtual networks, decision making on technology stack, etc.
• Design and built Firmware grand central solution for managing firmware packages for Azure. Multiple APIs and firmware resources deployment in Azure, and interfacing with external teams.

• Designed and developed a scalable and concurrent product using multithreading to migrate Solr data to Elasticsearch of 110 million in just 2 hours. No tools available on the internet were fully developed from scratch. With features such as API rate limiting, field-level validation using high-performance key-value store RocksDB.

• Designed and developed a permission management tool from scratch, which works across cloud providers such as Google Cloud and Azure Cloud. This tool handles permissions for cloud services - Azure Data Lake Storage v2 (ADLS v2), Google BigQuery, and Databricks (integrated in Azure Cloud). Basically, this tool manages permissions at the database/tables/view level with read-only access. Highly automated with git configuration, which triggers permissions tool for grant/revoke access.

• Designed and developed a data comparison tool using a fast hashing library (jpountz) to compare data integrity of Teradata and BigQuery. It performs complete table hash and compares for data correctness. Based on the results, Google Dataproc job gets triggered to find invalid rows.

• Designed and developed a generic Event DQ application, which identifies whether event data is valid against the Avro schema. Currently, it is deployed to identify Azure Event Hub events. It's a generic application that takes rule configuration as input, reads events as input, and validates the event received from the event hub.

• Designed and developed CDC system to inform recipients about change data capture of table metadata across databases from different database flavors: MySQL, Databricks, Azure Cosmos, and Teradata, with support of in-memory caching.

• Designed and developed a highly scalable metadata crawler for Databricks and Google BigQuery.

• Developed and integrated a logging interceptor at the API level to make APIs searchable on Splunk.
• Developed resiliency pattern - health services to provide health of downstream services.
• Integrated Google Dapper infrastructure to trace requests across microservices in the cloud.
• Developed APIs for customer service chat on the TWILIO platform, on Amazon AWS Lambda, and later migrated to Amazon AWS ECS.
• Code reviews of SDEs and suggesting improvements in code.
• Low-level and high-level design of chat API for customer service.
• Integrated E2E test with chat API using JMeter and unit test using JUnit framework.
• Performance testing of APIs using JMeter test plan and integrated CI/CD pipeline.
• Integrated classification rules using DynamoDB for different points of sale.
• Integrated eventing framework with fault tolerance in chat application.
• Designed phoneapi's using DynamoDB and integrated for fast search. Integrated in-memory caching for API performance.
• Migrated REST APIs to eventing architecture.
• Design of Low-level and High-level TaskRouter product from scratch, which replaced existing Twilio third party with an in-house solution.

• Developed generic data ingestor to consume finance product data from external sources using Kafka and Java 8 and enhanced to support multithreaded.
• Created kafka publisher to push computed finance data to external sources for generating reports.
• Created REST services to integrate with external services protected by SiteMinder authentication and authorization on cloud environments.
• Designed and developed front end in ReactJS to show validation errors during ingestion process.
• Contributed to compiler to support DSL( English expression ) to SQL query generator with Hibernate as middle layer using Scala and combinatory parsers.
• Optimized data analytics tool using multi-threading to get results faster.

• Development of LCC Project - Asset Management using AngularJS, Node.js, Java, MongoDB, Sybase IQ, Vert.x.
• Developed document manager using Node.js and Vert.x as backend services to support millions of documents. - Developed front end using AngularJS, SlickGrid, and Lodash to support fast uploading and searching.
• LCC Project: ETL Mapping Tool - Developed ETL Process to upload database mapping into NoSQL database, Sybase IQ, via ETL Stages with concurrency support and email functionality at each stage using Object-Oriented Database, SecDB, and Slang.
• Arjen London business development and support.
• Developed regression code to test the functionality of Arjen London Deal.
• Mortgage business development and support.
• Lending Club: Daily simple interest calculator on monthly remittances and aggregate the report via ETL.

• Development of Trade Blotters like Structured notes, Trade Tracking, Fixed income using J2EE, Java, Spring, and Hibernate technologies.
• Trade Blotter application enhancement and support in Java.
• In-view application development for capital market using SOA architecture based on SOAP/REST-based and Web services development in Java.
• InView application enhancement and production support in Java.

Client: IBM.

• PIM Functionality Development in Java.
• PIM Defects Fixing in Java.
• PIM L3 Product Technical Support.
• IBM ETL Module Development in Java.
• GIAM Functionality Development in Java.
• ITIM L3 Product Technical Support.

Client: Cisco

• SQL queries development, Perl development, UI development using HTML, jQuery, and CSS.
• Report analytics using Hive, Pig, and Java MapReduce programs on a Hadoop Standalone cluster