Mohan Prajapati

Associate Software Engineer

Lowe's India•  August 2022 - April 2024•  Bangalore

* Spearheaded the development and maintenance of RESTful APIs, ensuring flawless communication between frontend and backend systems, thereby enhancing the overall user experience. * Pioneered the creation of a Role-Based Access API, establishing a robust security role model for managing permissions within internal applications, facilitating streamlined permission control. * Engineered RESTful APIs optimising the validation and insertion of ELC rates into Db2 tables, achieving a remarkable reduction in processing time to 40-50 seconds, significantly boosting operational efficiency. * Successfully executed the migration of web applications from Site Minder to ForgeRock, transitioning applications from VM to carbon, contributing to improved security and streamlined deployment. * Upgraded micro-services from JDBC to JPA, driving performance improvements, enhancing code readability, and reducing complexity by eliminating boilerplate code. * Developed a Spring Boot application utilising dynamic aggregation pipelines to retrieve best-fit records based on aggregation scores, showcasing advanced problem-solving skills. * Integrated Apache Kafka for real-time data streaming, fostering seamless communication among micro- services and elevating system responsiveness to dynamic data needs. * Conducted comprehensive performance analysis and implemented optimisations, resulting in a substantial reduction in API response times. * Collaborated seamlessly within cross-functional teams in an Agile environment, ensuring the timely delivery of high-quality software. * Built ELC Core Engine, developed using Iterator Design Pattern. This is one of the most crucial application for accurately and precisely calculating the landing cost for International Shipments. This helps us to build transparency between Supply Chain and Finance department.

Python Engineer Intern

Q2ebanking•  July 2021 - July 2022•  Remote

* Developed Python frameworks to transform Online Banking data from flat files to relational databases as per Business Analyst's specifications. * Resolved critical migration bugs. * Certified in SDK & Multi-tenant extensions deployment using CDM. * Implemented T-SQL database modifications, including creating Stored Procedures (MS-SQL Server). * Wrote and updated data mapping specifications document, outlining data sources, transformations, and target locations. * Conducted data analysis tasks in SQL Server and DB2 databases to prepare for and execute ETL processes for migration. Skills: ETL (Extract, Transform, Load) · Pandas · NumPy · Git · Bitbucket · Python (Programming Language) · Data Mining · Microsoft SQL Server · PySpark