SUMMARY:

• 14+ years of hands - on experience in Oracle EBusiness Suite Release 12, Oracle EBS Cloud and Release 11i & FMW technologies. Passionate to venture out in the field of Artificial Intelligence & Machine Learning.
• Possess a PGP certificate in Artificial Intelligence & Machine learning from The Confidential at Austin.
• Well versed with concepts in Supervised Learning, Ensemble Techniques, Feature selection, Model selection & Tuning, Unsupervised learning, Neural Networks, Computer Vision, Natural Language Processing.
• Working experience on Fusion middleware technologies Application Integration Architecture (AIA), Service Oriented Architecture (SOA), Oracle Service Bus (OSB) and Oracle Data Integrator (ODI), Oracle Business Activity Monitoring (BAM), Business Process Management (BPM) and Human Workflows. Has experience working on Oracle CPQ Cloud (Big Machines). Well versed in standards - BPEL, XML, XSD, XSLT, XPATH, XQUERY, WSDL, JSON, SOAP, REST
• Designed and delivered SOAP and REST services using OSB, ODI interfaces between systems for data transfer, SOA inbound and outbound interfaces
• Has international experience working at Confidential, Chicago and Abu Dhabi Investment Authority, Abu Dhabi
• Experience working on JDeveloper11g, JDeveloper12c and Weblogic server.
• Sound knowledge and project experience in OAF - Customizations, Extensions and Personalizations, BI Publisher Reports, Interfaces, Conversions, Oracle Workflows, SQL, PL/SQL, Forms Personalization, web ADI, Oracle Discoverer reports, On Demand standards, AME, Oracle Alerts, Oracle Application Express (APEX) and EBS Upgrade projects.
• Experience in designing and developing complex extensions, interfaces and FRICEW components.
• Working experience on various modules like Oracle Projects, HCM Suite that includes Core HR, SSHR, Oracle Time & Labor (OTL), Order management, Advanced Supply Chain Planning, Accounts Payable, Accounts Receivable, TeleSales, Trade Management and Financials and Manufacturing modules.
• Experienced in Bitbucket, WinCVS, HPQC, Tortoise SVN, Kintana and Clear Case tools for defect and code management.
• Delivered trainings on Oracle SOA, AIA, ODI, BAM, OAF and workflows.
• Handled small to medium sized teams.
• Worked in projects involving global rollouts spanning US, EMEA and APAC regions.
• Participated actively in firm level community events.

PROFESSIONAL SKILLS:

ERP: Oracle Applications R12.2.4 and R12, 11i

Framework: AIA, OA Framework

Oracle Technologies: SOA & BPEL, Oracle Service Bus (OSB), Oracle Data Integrator (ODI), AIA framework, Oracle Application Framework (OAF), BI Publisher, Oracle Reports 6i, SQL and PL/SQL, SQL Loader, Unix, Java, Discoverer 10g, Web ADI, Oracle Forms, OAF and Forms personalization and Workflows, Oracle CPQ Cloud (Big Machines) and Business Process Management (BPM)

Design Tools: JDeveloper 12c & 11g, TOAD, SQL Developer, SharePoint, WinCVS, HPQC, PMC, Tortoise SVN, Kintana and Clear Case

Tools: Jupyter Notebook, Google Colab

Languages: Python

Packages: Scikit Learn, Numpy, SciPy, Pandas, NLTK, BeautifulSoup, Matplotlib, Keras, Tensor Flow

Techniques: Data Visualization, Linear & Logistic Regression, Clustering, Classification, Supervised learning, Ensemble techniques, Feature selection, Model selection & Tuning, Unsupervised learning, Neural Networks, Computer Vision, Natural Language Processing

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Work with vendor systems to implement AIML models to perform trade classification for items. Project is challenging as the target trade codes are 2400+ for US with a huge item database and model tuning, algorithm selection is the key.
• Develop solutions for multiple applications like Bill of Materials, HR, Manufacturing modules etc., within Oracle e-Business Suite based on user requirements for Confidential products.
• Participate in analyzing, designing, developing, testing, implementing and maintaining application systems.
• Conduct user needs analysis, design and architect software applications, write and maintain software codes and related documentation within the Software Development Life Cycle (SDLC), and ensure that systems and software are secure and operational for all users.
• Develop and maintain software using the SDLC to plan, create, write, and test software applications. Maintain software codes specific to the Oracle's e-Business Suite including Oracle APEX, Oracle Forms, Oracle Reports, Oracle Workflow and Business Events, BI Publisher, JDeveloper, Oracle Applications Framework, and Oracle Java Technology Framework.
• Execute unit testing and exclusively support in Quality Assurance Testing, User Acceptance Testing, and Conference Room Pilot Testing of written and/or maintained software codes.
• Responsible for working with Oracle support to resolve issues, recommend and test Oracle patches, and troubleshoot production issues.
• Execute software development production turnover and work with other developers, analysts and business stakeholders in the creation of technical requirements from documented business requirements.

Technical Environment: Oracle Applications R12.2.4

Technology, Tools and modules: Oracle APEX, SQL, PL/SQL, Oracle Projects, HRMS, Payables, Purchasing, Bill of Materials and Manufacturing modules

Confidential, Chicago

Responsibilities:

• Conduct meetings with client SMEs and key stakeholders and understand the products and product hierarchies using Bill of Material (BOM) structures.
• Design the layout after performing attribute analysis.
• Create scripts to insert data into parts database.
• Analyze spare parts, internal options, sequencing, hyperlinks, country rules and configuration rules (constraints, recommendations, hiding and recommended item rules).
• Conduct review meetings with client SMEs to validate and get approvals after the product is configured in CPQ instance.

Technical Environment: Oracle CPQ Cloud (Big Machines)

Technology, Tools and modules: BML

Confidential, Chicago

Responsibilities:

• Designed and delivered REST service in OSB to fetch actual and committed costs of a project.
• Designed and delivered interfaces using OSB and ODI -
• Outbound interface in OSB to transfer depreciation files in Fixed Assets from Oracle EBS to other applications (MSIS) - Acquire to Retire process (ATR)
• Inbound interface in ODI for AR lease invoices from other applications to Oracle EBS AR - Bill to Collect process (BTC)
• Inbound interface in ODI for AP invoices to integrate Oracle EBS and BPM
• Inbound interface in ODI for interfacing Customer, Customer accounts and relationships from other applications to Oracle EBS TCA
• Outbound interface in ODI to export Cash sheet data from EBS to other applications
• Inbound interface in ODI to import GL journals from different legacy applications to Oracle GL - Book to Report process (BTR)
• Inbound interface in ODI to import master data such as Employees, Site and Location hierarchy between MDM applications and Oracle EBS HRMS
• Inbound interface in ODI to import store level plan data from legacy system into Oracle BI
• Inbound interface in ODI to import QCR data from restaurant back office system into Oracle BI
• Inbound interface in ODI to import real estate data from legacy real estate system into Oracle BI
• Designed multiple common objects that are used across the project -
• Common Exception Handling service (SOA & PL/SQL) using JMS queues and database adapters
• Database packages and tables
• ODI service to move incoming files
• Automated ODI interfaces using load plans and UNIX scripts
• Created SOA services to move files from one server to other using FTP adapters
• Created concurrent programs to move files from one server to other through UNIX scripts using SSH
• Designed interfaces to sync data between Primavera and Oracle EBS Cloud modules Purchasing, Payables and Projects to import Purchase Orders, Invoices and Project definitions respectively. This was done using AIA architecture and exposed WSDLs in Oracle EBS Cloud.
• Mentored and guided team members on SOA, ODI and OSB.
• Analyzed client’s business needs, performed the feasibility check, designed and implemented the solutions, effort estimate of the CRs, Enhancements etc.,
• Collated the status from the team and had driven status calls between offshore and onsite team.
• Managed Kintana packages to migrate SOA and PL/SQL interface components.
• Code management through Clear Case
• Defect management through HPQC and PMC
• Performed reviews, conducted status review meetings with client and key stakeholders

Technical Environment: Oracle Applications R12.1.3, Oracle EBS Cloud, Weblogic12c, Weblogic11g.

Technology, Tools and modules: JDeveloper 12c, JDeveloper 11g, SOA, OSB, ODI, SQL, PL/SQL, Oracle Projects, Fixed Assets, AR, AP, Kintana, HPQC, Clear Case, PMC

Confidential

Responsibilities:

• Designed and delivered interfaces using AIA
• Outbound interface to export Projects, Tasks/WBS data from Oracle EBS to Maximo
• Outbound interface to export Projects, Tasks/WBS data from Oracle EBS to IPMS
• Outbound interface to export Projects, Tasks/WBS data from Oracle EBS to iHUB
• Outbound interface to export Projects data from Oracle EBS to EcoSys
• Outbound interface to export tasks data from Oracle EBS to EcoSys
• Outbound interface to export Projects master data from Oracle EBS to EcoSys
• Inbound interface to create Budgets and forecasts for Projects
• Outbound interface to export purchase order details of employees from Oracle EBS to Offline Time Entry System (OTES)
• Outbound interface to export project details of employees from Oracle EBS to Offline Time Entry System (OTES)
• Worked on Core HR work structures - Data analysis for the setup of Job, Position and Grade KFFs, DFFs, Organization hierarchy, Security profiles, Fast Formulae, Assignments
• Worked on complex customization of workflow HRSSA
• Worked on contingent worker assignments in Oracle Time & Labor (OTL) module
• Designed and delivered complex business solutions in workflows like PO Approval workflow and AP Invoice Approval workflow etc.,
• Worked on creating multiple BAM dashboards for showing the status of incoming and outgoing data.
• Worked on BPM Suite 12c to create business processes using Business Rules, Human tasks etc.,
• Mentored and guided new team members
• Managed Kintana packages to migrate SOA, AIA and PL/SQL interface components.

Technical Environment: Oracle Applications R12.13, Oracle database 10g

Technology & Tools: JDeveloper 12c, JDeveloper 11g, SOA, AIA, SQL, PL/SQL, Oracle Projects, AP, HRMS, PO, Kintana, HPQC, Workflows, UNIX

Confidential

Responsibilities:

• Designed and delivered workflows -
• Customized COGS workflow as per the business requirements of client
• Customized Sales Order Header workflow as per the requirement
• Customized Requisition Account Generator workflow
• Customized Trade Management Claims Settlement workflow
• Developed a solution for interfacing Promotional claims between Trade Management module and Accounts Receivable module
• Designed and delivered Oracle Forms -
• Designed and personalized Telesales Form
• Developed Oracle Form for restricting items entered by customers on Sales Orders
• Designed and delivered BI Publisher reports -
• Created a new template for Dunning Letter
• Created a new template for Payment Confirmation Letter
• Developed Cancelled Orders Report in Order Management module in BI Publisher
• Developed Price Impact Analysis Report in BI Publisher to calculate inflate price of an item based on its change in actual price
• Prepared Technical Design documents, Unit test scripts & MD120.

Technical Environment: Oracle Applications R12.1.3, Oracle Database 10g

Technology, Tools and Modules: Oracle Forms, Form Personalization, Workflows, BI Publisher Reports, PL/SQL, Order Management, Trade Management, Telesales, AP

Confidential

Responsibilities:

• Personalized ‘Create Advanced Shipment’ OAF Page in iSupplier module to perform required business validations, changed item display tips and personalized the page to display and save dates to database as per date format required by the client
• Customized ‘Create Advanced Shipment’ OAF Page in iSupplier module to call ‘Receiving Transaction Processor’ concurrent program and other custom concurrent programs after performing all validations on the page
• Designed and delivered Web ADI -
• Created Web ADI for creating HR Locations for three different languages namely Chinese, Confidential and English
• Created Web ADI for updating HR Locations for three different languages namely Chinese, Confidential and English
• Designed and delivered concurrent programs -
• Developed concurrent program to close period of inventory organizations
• Developed concurrent program to take inventory snapshot once the period is closed

Technical Environment: Oracle Applications R12.1.2, Oracle Database 10g

Technology & Modules: OAF, SQL, PL/SQL, Web ADI

Confidential

Responsibilities:

• Worked at client site in Abu Dhabi as a team lead
• Upgraded about 90 objects out of total 700 objects in the project
• Upgraded database objects from 11. .1.2
• Upgraded objects include Discoverer reports, Forms, Reports, Workflows and other database objects like views, packages, functions, stored procedures and host files
• Prepared installation scripts to deploy CEMLIs
• Managed a team size of 4
• Co-ordination between client and offshore team
• Monitored team members’ work
• Involved in status reporting to client and offshore senior management

Technical Environment: Oracle Applications 11.5.10 and R12.1.2

Technology & Modules: Oracle Discoverer, Forms, Reports, SQL, PL/SQL and workflows

Confidential

Responsibilities:

• Designed and delivered Interfaces -
• Designed and implemented HR Grades interface
• Designed and implemented HR Addresses interface
• Designed and implemented HR Grades interface for Delta load
• Designed and implemented HR Addresses interface for Delta load

Technical Environment: Oracle Applications R12

Technology & Modules: SQL, PL/SQL, HRMS

Confidential

Responsibilities:

• Personalized, customized and fixed issues in the following custom Oracle Application Framework pages in General Ledger module
• Self Service GL Search Journal page
• Self Service GL Create Journal page
• Self Service GL Update Journal page
• Self Service GL Confirmation Journal page
• Self Service GL Cancel Journal page
• Self Service GL Accounting Department Mass Approval page
• Self Service GL Accounting Department Modification page
• Self Service GL Recurring Journal selection page
• Self Service GL Approval & Slip submission result page
• Provided support and fixed issues in the following custom concurrent programs in General Ledger Module
• Transfer Approval Journal slips to GL
• Purge Self Service GL Journals
• Import GL Journal Slips from uploaded file
• Provided support and fixed issues in the following custom workflow in General Ledger module
• Approval Workflow for Division Approval Process
• Approval Workflow for Accounting Department Approval Process
• Personalized, customized and fixed issues in the following custom Oracle Application Framework pages in Accounts Receivable module
• Self Service Search AR Invoice Slip page
• Self Service Create AR Invoice Slip page
• Self Service Update AR Invoice Slip page
• Self Service Confirmation AR Invoice Slip page
• Self Service Cancel AR Invoice Slip page
• Self Service AR Accounting Department Mass Approval page
• Self Service AR Accounting Department Modification page
• Self Service AR Approval & Slip submission result page
• Provided support and fixed issues in the following custom concurrent programs in Accounts Receivable Module
• Transfer Approval AR Invoice Slips to AR
• Purge Self Service AR Invoice Slips
• Import AR Invoice Slips from uploaded file
• AR Cash Application by consolidated invoice
• AR Lockbox to cash application streamline process
• Provided support and fixed issues in the following custom workflow in Accounts Receivable module
• Approval Workflow for Division Approval Process
• Approval Workflow for Accounting Department Approval Process
• Personalized, customized and fixed issues in the following custom Oracle Application Framework pages in Accounts Payable module
• Self Service Search AP Invoice Slip page
• Self Service Create AP Invoice Slip page
• Self Service Update AP Invoice Slip page
• Self Service Confirmation AP Invoice Slip page
• Self Service Cancel AP Invoice Slip page
• Self Service AP Accounting Department Mass Approval page
• Self Service AP Accounting Department Modification page
• Self Service AP Approval & Slip submission result page
• Provided support and fixed issues in the following custom concurrent programs in Accounts Payable Module
• Transfer Approval AP Invoice Slips to AP
• Purge Self Service AP Invoice Slips transactions
• Import AP Invoice Slip from CSV file to AP
• Provided support and fixed issues in the following custom workflow in Accounts Payable module
• Approval Workflow for Division Approval Process
• Approval Workflow for Accounting Department Approval Process
• Created the following patches and more in Oracle Metalink support to fix the issues raised by clients in the objects mentioned above
• 8739643, 8741049, 8781109, 8870319, 8947403, 9075686, 9244255, 9295529, 9337689, 9358952, 9382253, 9407014, 9448412, 9582162, 9590828, 9793863

Technical Environment: Oracle Applications R12

Technology & Modules: SQL, PL/SQL, OAF, OAF Personalization, Workflows

Confidential

Responsibilities:

• Responsible for understanding the functional requirements, writing the technical design document, coding, unit testing and UAT Support issues.
• Designed and developed Oracle Form for scheduling a batch of concurrent programs, request sets sequentially as desired by the client
• Designed and developed Oracle Form for monitoring scheduled concurrent programs using CRM JTF grid and used timers to refresh the form
• Developed database objects like packages, views, functions and stored procedures to achieve the above-mentioned functionality
• Provided support and fixed issues in AP, AR and HRMS interfaces

Technical Environment: Oracle Applications 11i

Technology & Modules: Oracle Forms, CRM JTF objects, SQL, PL/SQL, AP, AR and HRMS