* Web Scraping Optimization: Developed and optimized web scrapers using Python (BeautifulSoup, Scrapy) and OpenAI API, reducing manual job vacancy collection by 40 hours weekly. Stored data in AWS S3 for lead generation.* Real-time Monitoring Automation: Automated session monitoring using Puppeteer, Node.js, and AWS Lambda, resolving live session sync issues from DynamoDB, significantly improving system reliability.* OTUS Reporting Enhancements: Designed and implemented Redis and Elasticsearch-based alerting for data discrepancies in OTUS reports, improving troubleshooting and monitoring efficiency.* Complex MySQL Procedure Redesign: Fixed critical OTUS allocation bugs by redesigning complex MySQL stored procedures and integrating Polly for reliable SQL connections, ensuring robust report generation.* Report Management: Managed and delivered OTUS reports using C# .NET Framework with automated cron jobs, enhancing accuracy, timeliness, and error handling in report generation.

- Data Analysis of Customers for personal profiling -* Constructed queries on AWS Athena (Interactive Analytics Service) to analyze the customer data based on demography, gender, age, and categories of items customers are buying which is further being used in Profiling Repeat Purchase Customers and predicting their future demands and personalizing ads to make the user experience better.* Implemented data cleaning techniques to remove duplicates, and spelling mistake corrections (stemming and lemmatization) to perform accurate analysis. * Used Tableau to visualize and analyze data graphically to understand the data better which further helped in making business decisions.- Built automated E-mail functionality which was triggered every time a user onboarded/credited a loan from the Dhani platform.* Managed services like FastMail, Amazon SES, net core, MIME, and SMTP library alongside to send the mails in case any service failed to successfully send the emails.* Encrypted attachments rendered for every new user and saved them on Amazon S3.- Developed search functionality for an In-house CRM system where multiple parameters can be used for getting the details of the customer.- Built functionality for creating a No Objection Certificate (NOC) and Foreclosure Letter (FCL) for customers taking loans from Dhani.* Rendered HTML/CSS for creating NOC and FCL.* Constructed SQL queries to fill the data dynamically for every user.* ORM* DB handling* Implemented logic for refund, due, excess, extra charge, penalty, and waived-off amount.- Handled/filtered bureau data of customers from Experian (decisioning as a service) which is further used for customer analysis.* User auth, error handling, JSON/XML* Pagination* Sorting* creating pre-signed URLs- Handled/Filtered KYC data of customers.

*Built an interactive web-platform Customer Relationship Management (CRM) from scratch (Front-end to back-end and everything in between) using PHP7, JavaScript.*Assessed in building the front-end using HTML, CSS, Bootstrap, AJAX.*Used MySQL for building queries to perform live updation of the alerts created by company members and for the relational modeling.