Home

Sanujeet Mahapatra - Senior Dell Boomi Integration Developer/Architect

[email protected]

Location: ofallon, Missouri, USA

Relocation: REMOTE

Visa: H1B

Sanujeet Mahapatra Summary: Over 16+ years of experience in IT Professional as Oracle Apps ERP Technical consultant with experience on Integration Development as Dell Boomi Developer/Architect and Oracle SOA/OIC. Collaborating with cross-functional development teams to gather business requirements and translate them into efficient business intelligence solutions. As BizOps team, have provided support to Oracle apps development and DevOps activities (GitHub, pipelines, etc.) in agile environment. Designed, developed, and customized RICEWF components OAF, ADF, BI Publisher, Workflow, Interfaces, Conversions, Unix Shell Scripts, APEX, SQL Loader. Prepared interface and conversion programs in Oracle Manufacturing (Requisitions, Order Management (OM) Purchase Orders (PO) and Items (INV)), Finance Modules (AP and FA). Proficiency in object-oriented programming languages like Java and Procedural Languages like PL/SQL and scripting languages like JavaScript, groovy script and Unix shell. Designing and implementing database structures, including tables, indexes, and views Developing and optimizing PL/SQL code for data manipulation, validation, and reporting Performance tuning and query optimization to enhance database performance. Troubleshooting and resolving database-related issues and errors. Conducting unit testing and debugging to ensure the functionality and accuracy of PL/SQL code. Participating in database design reviews and providing recommendations for enhancements Worked extensively on REST web-services using iPaas, Java, PL/SQL, SOA, ADF, SOAP and APEX. Have done Development (in 11i, R12), Customizations (in 11i, R12), Upgrade CEMLI Retrofit estimation, Upgradation. Extensive experience in Oracle objects with a depth knowledge of Azure Dev Ops, Configuration Management, Build & Release Management. Developed MD70 and MD 120. Expertise in transforming 40 Oracle SOA B2B processes and 16 Advance-Oracle, 22 Oracle-Azure ETL flows and numerous integrations with AWS S3, AWS using Boomi as iPaas. Expertise in Oracle Integrated SOA Gateway, API Gateway and API Management Expertise in writing best practices incorporating reusability, access-based folder structure, micro process bases web services, naming convention. This was adopted by the IT at the organization level. Knowledge in API management and API-Key based authentication to expose On-Prem and Cloud data to external entities. Proficiency in ETL involving millions of records and look into performance tuning aspects. Expertise in using various connectors like Mail, Database, FTP, Oracle EBS, Amazon S3, Web Services Server and HTTP Client. Expertise in various industry standard integration design patterns like app-driven, Event-Driven, Publish-Subscribe, etc. Expertise in designing and developing ERP applications in Finance, Supply chain, HCM and HRSS modules. Strength in using various JDeveloper tools (OAF, ADF) to develop custom applications and customize Oracle Apps products. Source control, versioning and maintenance using tools like Jeera, PVCS, Bitbucket, PPM, Jenkins, etc. Knowledge in creating integrations using Oracle SOA Suite and OIC as iPAAS. Education: B. Tech, College of Engineering and Technology, Biju Pattanaik University of Technology Computer Science and Engineering, 2003 To 2007. Certification: Boomi Development and Application Architecture. Boomi Professional Integration Developer. Boomi Professional API Design. Boomi Associate Master Data Hub Developer. Boomi Associate Integration Developer. Boomi Profession API Management. Oracle OCI Foundation. Oracle OIC. Professional Experience: Client: Mastercard, O Fallon, MO Duration: January 2004 Present Role: Senior Oracle EBS and Integration Technical Consultant Responsibilities: Work with the Oracle Finance Development team for various developments with Oracle ERP interfaces and integrations. Develop and customize objects and reports in various finance modules like AP, AR and GL. Use various Oracle Tech stacks like XML Publisher, OAF and programming languages like PL/SQL and JAVA to do development. Prepare unit test scripts, code quality checks, code migration documents and paperwork for peer-review. Developed common frameworks like exception handling, alerts, email notifications, etc., to be re-used across the organization. Documented templates like technical specification and requirements gathering. Lead the integration team to transform various FTP based data transfer and interface/conversions to more real-time and decoupled ETL processes. Incorporated Boomi Oracle EBS enterprise connector to invoke Oracle Integrated SOA Gateway APIs and PLSQL packages with collection as parameters. Wrote best practices incorporating reusability, access-based folder structure, micro process bases web services, naming convention. This was adopted by the IT at the organization level. Do performance tuning of PL/SQL objects. Environment: Oracle apps finance, PL/SQL, Java, XML, JSON, SOA, Boomi Client: Helena Agri, Collierville, TN Duration: June 2020 December 2023 Role: Senior Oracle EBS and Integration Technical Consultant Description: Build APIs using Boomi Integration platform to integrate with different systems like ADP (Workforce Management System), Advanced (POS), Azure (Power BI). Develop and customize Oracle applications (Fixed Assets, Buyer Work Center, etc.). Responsibilities: Designed and Developed applications to auto-create Purchase Orders from CSV files stored in AWS S3 bucket. Created interfaces for inventory transactions for different transaction types from the PoS (Advanced) system to Oracle. Worked on creating AR Receipts importing from third parties using Boomi iPaas integration processes. Streamlined FA mass retirement process. Designed organization level restructuring involving various on-prem and cloud systems like Oracle ERP, Azure SQL Server, Advanced, etc. and cloud infrastructures like AWS and Azure. Lead the team to transform 40 Oracle SOA B2B processes and 16 Advanced-Oracle, 22 Oracle-Azure ETL flows and numerous integrations with AWS S3, AWS using Boomi and OIC as iPaas. Used Boomi EDI to connect to B2B trading partners. Worked in OIC instance setup, FTP, SOAP and REST adapters. Developed inbound interface using OIC to import inventory transactions from Advance PoS to Oracle. Streamlined data flow from Azure Blob Storage to SQL Server using Azure Data Factory (Pipeline). Incorporated Boomi Oracle EBS enterprise connector to invoke Oracle Integrated SOA Gateway APIs and PLSQL packages with collection as parameters. Wrote best practices incorporating reusability, access-based folder structure, micro process bases web services, naming convention. This was adopted by the IT at the organization level. Worked on API management and incorporated API-Key based authentication for the APIs exposed to applications hosted on Azure. Worked on Boomi Connectors like Mail, Database, FTP, Oracle EBS, Amazon S3, Web Services Server and HTTP Client. Build pipelines to synchronize Data Warehouse (MS SQL server) with Oracle database. Worked on multi accounts (Dev, UAT, Prod) platform and moved the packages components across environments. Used tools like Web ADI and BI templates for reporting needs. Used Java SDK to retrieve invoice PDF files from S3 to be downloaded in Oracle applications through BPEL Java Embedding. Worked on SOA Suite 12c to incorporate AQ adapter and Synchronous BPEL Process in SOA Composite. Environment: OAF, Workflow, Boomi, Oracle SOA, PL/SQL, API Gateway, Azure Data Factory, Jeera, SQL Server, Boomi, OIC Client: Sherwin Williams, Cleveland OH Duration: September 2019 May 2020 Role: Sr Oracle EBS/SOA Technical Consultant Responsibilities: Worked on Procurement to pay cycle (iProcurement, Purchase Order customizations, Payment Process). Customized I Supplier, iProcurement and Purchase Orders in Buyer Work Center (BWC) and Pricing. Created interface programs to import Requisition and PO data from legacy systems. Used ADF to achieve different changes in JSF and Managed Beans (POJOs) to the existing Custom application. Exposed ADF Application Module as REST web-services. Used DBMS scheduler for DB based job scheduling. Worked on APEX report to provide users a Purchase Orders dashboard. Designed ETL from Oracle database to Azure SQL server. Transferred millions of data from source to destination using scheduled processes every day. Transformed processes from Atom based distributed system to Molecule based. Used Boomi MDH to maintain DB golden records involving Oracle on-prem and Azure systems. Used database connector to make JDBC connection to Oracle database and retrieve data to be sent to different servers using FTP. Worked on API Gateway to set up authentication broker with Oauth 2.0. Created Boomi APIs and exposed it to be consumed by different business systems. Used Oracle SOA for B2B needs, invoke SOAP and RESTful web services and other integration needs. Developing integration and web-services using Oracle SOA Suite. Used different adapters like File and DB to address interface and conversion requirements. Used SOA and REST adapters to invoke SOAP and RESTful web services. Used snap logic to streamline the ETL pipelines between ERP and PowerBI. Environment: OA Framework, BI Publisher, Boomi, Oracle SOA, PL/SQL, API Gateway Client: USP, Rockville MD Duration: December 2018 September 2019 Role: Sr Oracle EBS Technical Consultant Responsibilities: Designed the solution in upgrading the custom applications and customizations to R12 Supply chain modules. Created PL SQL APIs to be invoked from OAF AM and CO Implementation files using callable interfaces. Created XML Publisher reports and integrated with OAF using XDO Helper. Maintained versions of codes of different objects in OAF, Reports, and PLSQL and shell scripts. Migrated the necessary files to production along with maintaining MD70 and MD120. Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project. Actively resolved post Go-live code bugs and performance issues. Environment: OA Framework, XML Publisher, Oracle SOA, PL/SQL, Oracle apps SCM Client: Network Rail, United Kingdom Duration: October 2017 December 2018 Role: Sr Oracle EBS Technical Consultant Responsibilities: Gathered requirements from the SMEs and Users. Discussed the feasibility and viability with the Functional counterparts and Project management. Contributed to the preparation of DSD, MD 50 and MD 70. Played key role in build design and development. Developed Application web pages using OAF, reports using XML Publisher and integrated with Workflow. Worked on SOA Suite composite applications using BPEL, Business Rule and DB Adapter. Integrated OAF with BI Publisher using XDO Template Helper Utility to seamlessly download Search results in form of a BI Publisher Report. Embedded OAF regions with workflow notifications for a better look and feel. Incorporated attachments on the self-service Web User Interfaces. Used OAF features including exception handling, OA Dialog Page, PPR, Event Handling, etc. Used ADF to write Java snippets which were exposed as web-services. Built rich user interfaces using ADF integrated with Oracle apps custom application. Built SOA composites and monitored the SOA processes from EM Console. Used Oracle SOA to integrate different trading partners with Oracle. Invoke PL SQL APIs using callable interface. Environment: OAF, ADF, Java, Oracle SQL, PL/SQL, Jenkins, Shell Scripts, (JDeveloper 10g), Jeera, Oracle Workflow Client: CoreLogic, India Duration: October 2013 October 2017 Role: Oracle EBS Technical Consultant Responsibilities: Did gap analysis and effort estimation. Designed the solution in upgrading the custom applications and customizations to R12. Worked on GL Journals using GL_INTERFACE table and Journal Import program in 11.5.10 and 12.1.3. Provide service enablement capability (SOAP and REST services) for custom integration interfaces within Oracle E-Business Suite. Did necessary development/Customization to incorporate the changes in R12. Created PL SQL APIs to be invoked from OAF AM and CO Implementation files using callable interfaces. Created BI Publisher reports and integrated with OAF using XDO Helper. Maintained versions of codes of different objects in OAF, Reports, and PLSQL and shell scripts. Used different built in features like Dependent LOV, PPR, H-grid, etc. Migrated the necessary files to production along with maintaining MD70 and MD120. Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project. Actively resolved post Go-live code bugs and performance issues. Environment and Skills: OAF, Java, Oracle SQL, PL/SQL, Shell Scripts, (JDeveloper 10g), Service Contracts, Quoting, General Ledger (GL) Client: ADEC-Abu Dhabi Education Council, UAE: Duration: June 2012 February 2013 Role: Oracle EBS Technical consultant Responsibilities: Implementation project with customizations. Involved in Analysis of distinct phases of SDLC. Created self-service applications using OA Framework and PL/SQL. Used Oracle Workflow to manage the approval system and notifications. Work with developers to understand impacts of branches and code merges Taking care of Release of Implementation and CRs during go-live. Environment: OAF (JDeveloper 9i), Java, Oracle SQL, PL/SQL Client: Oracle Corporation, India Duration: December 2011 July 2012 Role: Oracle EBS Technical Consultant Responsibilities: Listing all the standard and custom OAF objects in the EBS application along with the customizations done on standard objects. Extracting the custom documents from the Meta data services using JDR_UTILS APIs. Took help of Oracle Config Snapshot to list the environment level differences (Pages remaining unmodified/Changed/Deprecated/Removed). Listing JTF based JSPs and filtering for the custom files. Processing all custom java files for need of reimplementation in pristine environment. Estimating the effort needed for replicating the old customizations in new instance. Environment: Oracle SQL, PL/SQL, Shell Scripts Client: VMWare, India Duration: July 2010 December 2011 Role: Oracle EBS Technical Consultant Responsibilities: Analyzing the functional document and creating the technical design document. Substituting AM, VO, EO to change the business logic. Extending Controller and Personalizing OAF Pages. Integration of custom development to the standard applications. Moving the developed codes to the test and production instances using WinSCP. Creating different PL/SQL packages to be called from java codes using callable interface. Building Discover reports and modifying existing ones. Creating TAR and migrating the customizations through third party tools like PPM. Updating the technical documents after complete development of the component. Designing the code migration documents which will be used by the DBA to migrate the code in production. Environment: SQL Script, Developer6i, Oracle 9i; OAF (JDeveloper), PL SQL, WinSCP, iProcurement, I Expenses and I Supplier Client: COE Duration: January 2010 July 2010 Role: Technical Consultant (Oracle ADF) Responsibilities: Designing and creating rich ADF pages (implementing ADF faces). Used ADF business component entity object, view object and application module to address data services and Binding UI components to data. Created ADF bounded task flows. Developing the pl-SQL packages used for handling complex functionality. Developed ADF DVT components like line, bar and area graphs. Used various ADF layout components like panel stretch layout, panel group layout, panel collection, panel boxes and panel tabbed layout. Did web services development based on SOA and orchestration using BPEL. Environment: ADF (JDeveloper), PL SQL, Java Client: OCBC, Singapore Duration: January 2009 January 2010 Role: Oracle EBS Technical Consultant Client: CISCO, India Duration: June 2007 January 2009 Role: Oracle EBS Technical Consultant Keywords: user interface access management business intelligence sthree database information technology golang purchase order trade national microsoft procedural language Arkansas Colorado Maryland Missouri Ohio Tennessee