Mar 2022 – Oct 2023 · 1 yr 7 mos · Hyderabad, Telangana, India

• Re-architectured all the SLA(Subledger Accounting) accounting APIs consumed by the Oracle Fusion products(FIN, HCM, SCM, PRC, CRM) to account their transactions, for zero downtime patching compatibility using EBR(Edition Based Redefinition architecture)
• Participated in brainstorming discussions and provided/raised complex solutions/concern while finalizing the solution of the project
• Wrote multiple SQL scripts and enhanced multiple UI setup components to maintain the data flow across different editions during upgrade/patching the changes from consuming products on customer pods
• Changes done making sure to minimize the functional as well as code changes from consuming products to diminish the error possibility
• Coordinated with Manual/Automation QA team and consuming product teams to perform the regressive testing for multiple upgrade scenarios and suggested new 25+ possible edge cases

Sep 2020 – Mar 2022 · 1 yr 6 mos · Hyderabad, Telangana, India

• Analyzed and tuned SQL queries of BIP reports by monitoring their execution plans, joins, index and query hints saving 80% execution time
• Implemented feature in BICC extraction tool allowing user to add query hints dynamically in runtime query to decrease the query execution time based on their data shape
• Enhanced multiple BIP reports to run in summary/detail style mode leading to major performance improvement in case of huge data volume
• Rationalized multiple localization BI Publisher reports of GL(General Ledger) to a unified back-end solution
• Addressed and fixed numerous customer bugs/enhancements on BIP reports, Oracle BICC extraction tool

May 2019 – Jul 2019 · 2 mos · Pune Area, India · On-site

• Cloned existing Fusion360 mobile application in React Native(unified code base for Android and IOS) to evaluate it for supporting complex 3-D UI features
• Implemented compound features like LMV file render(3-D view), markup tools, measurement of designs over mobile screen, comment/feedback section etc

Mar 2019 – May 2019 · 2 mos · Mumbai, Maharashtra, India (WFH)

Mar 2019 – May 2019 · 2 mos · Bengaluru, Karnataka, India (WFH)

Feb 2019 – Jun 2019 · 4 mos · Mumbai, Maharashtra, India (WFH)

• Developed the website from scratch.

Dec 2017 – Mar 2019 · 1 yr 3 mos · IIT Roorkee

• Programme of IIT Roorkee to provide research exposure to interested undergraduate students of IITR and other institutes.
• Built web application using MERN stack to receive student applications, faculty projects.
• Developed RESTful APIs that served the backend for user authentication, file uploading, resume shortlisting, e-certificate features
• Automated online payments of stipend, reimbursement and miscellaneous expenses after approvals by integrating RazorPay payment gateway
• Leveraged cloud computing technologies like docker, AWS EC2, Nginx to improve scalability and security using load balancing and reverse proxy

Jul 2017 – Jul 2019 · 2 yrs · IIT Roorkee

• Lead eight member technical team who implemented progressive web portal using MERN stack and mobile app on React Native for the fest
• Implemented day planner of the events during fest based on the interest entered by participants so that they don't miss any relevant event and have more fun
• Took new initiatives like Digital ID card, e-certificate, online payment, digital ads

Jun 2017 – Jul 2017 · 1 mo · Jaipur

• It is an online specialist doctor consulting company which provides an online platform feature to its clients.
• Developed a software for the patient to search the doctors according to their diseases or symptoms. Used google calendar APIs to record and show the day to day activities of the clients on their dashboard.
• Used google Graph APIs for showing statistics of the clients'' activities(health improvement etc.).