Python Automation• Automated file preprocessing operations like decryption, formatting adjustments, and header insertion with Python and SQL.• Designed server-side automation solutions independent of MS Excel, ensuring broader applicability.• Automated 150+ trade blotter preprocessing, saving the support team an estimated 4400+ hours annually.• Skills: Python Automation , Data Preprocessing, SQL, data cleaningLinedata Software• Developing C#, VBA, VB.NET, Python, and SQL based Recon Application.• Integrated Azure Entra ID Login Authentication in React app.• Implemented Power Automate workflow automation and trigger through REST API for tasks such as Power BI data refresh, Azure pipeline execution, email notifications, and stored procedure execution.• Skills: C#, VBA, Excel, VB.NET, SQL, Azure Entra IDDevOps• Designed fully automated CI/CD pipelines for SQL Scripts, React micro frontend and dotnet backend applications. • CI/CD pipelines had the functionality of automated test execution, creating binaries backup, changing variables and successive environment deployment.• This made deployment human error-free, and increased efficiency.• Skills: Azure DevOps, DevOps , Proof of Concept Development

UI Validation Application • Developed Selenium and Multithreading-based Automated UI Validation Application end to end.• The application can run custom tests and provide personalized execution reports.• Presented application at the company’s annual Hackathon for 4 Blue Yonder LCT software tenants.• This application can potentially be used for all Blue Yonder Products.• Used Java for the back end, HTML, CSS, and JavaScript for the front end, MySQL as the database, and Selenium and TestNG for testing• Annual Manual effort saving is approximately 6208 hours or 776 person-days when used for all Blue Yonder LCT s/w Clients.• Please find application architecture for reference here :https://drive.google.com/file/d/1RbNhDAtfq1EAJO5SwcciNVIK1Gw8O2p5/view

Got an opportunity to work with recently introduced ISHRAE BITS-PILANI Chapter