Omkar Lapshetwar

Integration Experience: Experienced Integration Specialist and NetSuite Developer with proven expertise in implementing and managing complex enterprise integrations between NetSuite and major systems including Salesforce, SAP SuccessFactors, and Rydoo. Proficient in developing custom financial solutions using SuiteScript 2.0/2.1 framework, implementing various script types including User Event Scripts (beforeLoad, beforeSubmit, afterSubmit), Client Scripts (fieldChanged, pageInit, saveRecord, validateField), Scheduled Scripts, MapReduce Scripts for large dataset processing, Suitelet Scripts for custom UI pages, RESTlets with secure API endpoints and IP-based access controls, Workflow Actions Scripts, and Mass Update Scripts. Specialized in financial business logic development, including automated journal entries, custom transaction processing, and real-time data synchronization across integrated platforms.

Vendor Portal Development: Architected and implemented a comprehensive vendor management portal from scratch, seamlessly integrated with NetSuite. Developed custom SuiteApp featuring RESTlets and Workflow Action scripts for NetSuite data manipulation, enabling automated vendor registration, approval workflows, and secure credential management. Built a robust tech stack using Node.js and Redis for backend operations, Next.js for frontend development, ensuring optimal performance and user experience. Implemented sophisticated features including automated NetSuite record creation, multi-step approval workflows with email notifications, secure password generation and distribution, invoice upload capabilities, and vendor-specific record visibility. The portal streamlines vendor onboarding and management processes while maintaining data integrity and security between the portal and NetSuite.

• SuiteScript Development: Extensive experience with SuiteScript, including Suitelets, Workflows, User Events, Map/Reduce scripts, and RESTlets.
• Item Constitution Automation: Developed a solution to automate item creation within NetSuite by integrating with supplier APIs. Fetched product data via JSON endpoints and transformed it into NetSuite item records, ensuring compliance with promotional standards (ASI, SAGE).
• ExtendFrame Portal Development: Contributed to the development of ExtendFrame, a highly customizable portal enabling users to perform custom actions (create, edit, list, view) on any NetSuite record. Implemented a flexible system allowing users to define custom fields and actions through the portal's configuration screen. Leveraged RESTlets for seamless communication between the Solid.js frontend and Node.js backend, empowering users to manipulate NetSuite data directly from the portal.

• DSE-Diamond Standard Exchange: As a software engineer on the DSE (Diamond Standard Exchange) project, I was responsible for developing and implementing APIs, optimizing logics and flows, and managing the AWS infrastructure. My strong expertise in Node.js and database management using MySQL enabled me to create a robust and efficient backend for the application. The DSE project allowed diamond vendors to buy and sell diamonds to DSE, as well as participate in bidding and bargaining. My APIs ensured seamless transactions and supported the needs of the users. I optimized the system logic and flows, resulting in improved efficiency and user experience. In addition to my technical skills, I also provided ongoing support and maintenance for the application. This involved working closely with the rest of the development team to identify and resolve any issues and ensure that the application continued to meet the needs of users. My experience in API development, backend development using Node.js, database management, AWS management, and my ability to support and maintain applications, make me a valuable asset to any organization. I am confident in my ability to deliver high-quality solutions and meet the needs of users.

• CHORUS: As a software engineer on the Chorus project, I played a key role in managing research paper data from various institutions, publishers, and funders. I was responsible for developing and implementing APIs, optimizing logics and flows, and managing the AWS infrastructure. also wrote and executed ingestion scripts to automate the data processing and management. Additionally, I created reports from different sources using xlsx and CSV, and was able to extract and analyze millions of lines of data. I further demonstrated my technical expertise by migrating the database from Postgres to MongoDB, ensuring seamless transition of millions of data points. Through my work on the Chorus project, I honed my skills in API development, optimization, cloud computing, data management, and reporting, and am confident in my ability to tackle complex challenges and deliver results.