Satish Gupta Email and Phone Number

◦ Developed an ETL batch process for reading data from CSV files stored on an SFTP server and efficiently loading it into a MySQL database. This solution harnessed the power of Apache Spark to handle large volumes of data seamlessly.◦ Converted the single-tenant architecture into a multi-tenant model and introduced a context-level filter within the ORM (Entity Framework) to ensure security against unauthorized data access from other organizations and to reduce the deployment effort and lower the infra cost.◦ Switched from a standalone Solr setup to Solr Cloud in order to make use of the scalability, high availability,load balancing, and distributed indexing features offered by Solr Cloud.◦ Upgraded software from .NET Core 2.2 to 5.0, enhancing system performance and ensuring compatibility with the latest technology. This upgrade prepared the system for the future while reducing technical effort.◦ Designed and implemented the core customer screening algorithm for scoring and filtering, enhancing theeffectiveness of the process.◦ Created and deployed a customer screening API on Kubernetes to ensure scalability, high availability.◦ Enhanced the Screening batch to process 100,000 customer records within just 30 minutes, a significantimprovement compared to the previous 28-hour processing time. This achievement was made possible byreducing database calls, optimizing IO operations, implementing efficient hashing, caching, leveragingasynchronous processing, incorporating multi-threading, and enhancing the existing algorithm for better overall performance.◦ Revamped the screening batch using Apache Spark, enabling distributed screening. This transformation enabled us to process 10 million customer records in just 60 minutes, achieving remarkable scalability and performance gains.◦ Continuously manage and uphold the operational performance and reliability of services within the production environment.◦ Conducted load testing on critical APIs using JMeter .

◦ Implemented a feature to maintain and show change history of configuration by user in the application.◦ Implemented a search functionality with Apache Solr to search on large volume of data with full-text , fuzzymatching and facet search with low latency.◦ Created a News Portal application (Adverse Media) which identifies news articles from different sources based on keywords to combat with fraud, terror and money-laudering.◦ Implemented an export data feature enabling the extraction of data from MySQL into CSV format, followed by the application of analysis and filtering.◦ Collaborated with machine learning team to integrate machine learning model in the application with restfulAPIs.◦ Developed a script for scheduled MySQL database backups using cron and automated the process of pushing the backups to Azure Blob Storage.◦ Implemented parser to collect and parse data from different sources and insert into database.◦ Worked on a batch scheduler to schedule application tasks using cron job.◦ Integrated email alerts for any failure in internal batches and jobs.◦ Designed, developed, and deployed applications by containerizing it with Docker technology, ensuring efficient and scalable deployment.