OBJECTIVE

• Highly motivated software professional with around 10 years of experience in Design, Development, Testing, and Implementation in Oracle E - Business Suite environment 11i/R12 involving Implementations/upgrade/support and looking to work in a challenging environment where my Enterprise Resource Planning (ERP) skills can be put to best use to assist the organization in achieving its business objectives and professionally grow with it.

SUMMARY

• Having around 10 years of IT experience in Oracle Applications (11i (11.5.10), R12 (12.1.3)) and R12 (12.2) and complete Agile SDLC (gathering Business Requirements, Analysis, Design, Implementation and Testing) cycle.
• Hands-on experience in Application Implementation Methodology AIM and Application Object Library AOL .
• Around 5+ years of experience in Oracle APEX, Developed Oracle APEX applications in complete SDLC lifecycle.
• Defining cloud migration strategy from on premises to Oracle Cloud infrastructure. For ExaCS and IaaS (OCI)
• Expertise in developing the Technical Specifications & Module Design Documents.
• Extensive experience in Application Developer and System Administrator responsibilities.
• Involved in R12 end to end Implementation and Upgrade cycles.
• Hands on Experience on AR Auto Lock box and Auto Reconciliation process.
• Worked with Onshore/Offshore teams.
• Worked on Oracle Cloud modules.
• Hands on experience in Production Support Environment.
• Hands on experience on Oracle EBS and Sales force platforms integration.
• Responsible for implementation and support using Oracle ERP applications including SCM modules like Order Management, Inventory, Purchasing and financial modules like Accounts Receivable, TCA (Trading Community Architecture) Accounts Payable, Fixed Assets and General Ledger also on Service Contract, Advance Pricing and Quoting and Manufacturing modules like BOM, WI, INV.
• Good understanding of Organizational Structure.
• Hands on Experience on Oracle Crystal Reports.
• Extensively worked on Oracle ERP modules like GL, XLA, CM, AP, AR, FA, INV, OM, PO, QP, Shipping, HRMS, Payroll, AOL and Order to Cash (OTC)
• Worked on defining Menus and attaching forms to it.
• Worked on SVN (Sub version control), Rally, Clear quest, Quality center to check the tickets.
• Hands on experience on BPEL (SOA) file adapters and database adapters.
• Worked with oracle support, using Metalink, to resolve issues using knowledge base, SR/TAR.
• Hands on experience on SQL Tuning the complex queries using Explain Plan, TKPROF utilities and Trace Files.
• Strong Programming experience in developing Packages, Procedures, Functions, Cursors, Views, database triggers, interfaces and other database objects using PL/SQL and SQL*PLUS
• Worked as scrum master within our team and followed the agile life cycle for all over deliverables to production instance.
• Worked on service now for ticketing purposes and used GIT for version control and Flex deploy for migrations.
• Proficient in writing & tuning complex SQL statements.
• Extensive experience in customization of forms using Custom.pll forms Personalization, customization of reports, defining concurrent programs, defining value sets, defining profile options, and functional setups.
• Good working knowledge of RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) which involves working on Reports 6i/10g and SQL, PL/SQL packages and functions.
• Expertise on designing and implementing Oracle Alerts.
• Expertise on developing Oracle Forms 6i/10g and OA Framework (OAF), APEX.
• Developed Inbound and Outbound Interfaces.
• Experience working in Corporate Finance, Telecom, and Health domains.
• Performed Unit testing, Integration testing & User Acceptance testing of the Applications.
• Developed the Documentation Process of the application with end-user training.
• Strong Production Support experience in Order-2-Cash, Procure-2-Pay and Finance Processes.
• Experience with performance tuning, query optimizations.
• Used Explain Plan, TKPROF for query optimization.
• Well equipped with UNIX shell scripting & UNIX commands.
• Experience in Oracle Cloud Infrastructure (OCI) Migrating Oracle E Business Suite R12 to OCI (lift and Shift)
• Excellent all round team player with good interactive skills.
• Good understanding of TCA data model and APIs.
• Worked in Reimplementation from 11i to R12 environment.
• Flexible to learn advancements in the IT industry and deliver the goods.
• Accurately estimating and meeting the timelines in delivering the objects.
• Ability to understand the requirements and delegating it to the technical team members.
• Ability to learn and implement the setups needed for any module.
• Worked on OIC (Oracle Integration cloud) for GL journal import integration.
• Lead a team in offshore and delivered so many projects via Agile methodology.
• Used GIT for code version and bitbucket and flex deploy for code migrations from lower instances to Production instance.
• Worked as a scrum master within the team and delivered the projects on time.
• Part of 24/7 production support team and worked on high priority tickets.
• Good Confidential understanding the business requirements and providing technical inputs to the technical team.

TECHNICAL SKILLS

ERP: Oracle Applications EBS 11i, R12 11.5.10, 12.1.3

Databases: Oracle Database 8i, 9i, 11g, No Sql

Languages: SQL, PL/SQL, Java, HTML, XML, Python

ERP Processes: Order-2-Cash (O2C), Procure-2-Pay (P2P), Drop Ship, Finance

Oracle Modules: General Ledger, Payables, Receivables, Cash Management, Fixed Assets, Inventory, Order Management, Advanced Pricing, Purchase Order, Shipping and AOL

Tools: Developer 2000, Discoverer, XML Publisher, RDF reportsForms Builder, workflow Builder, ODI (Oracle Data Integrator),OIC (Oracle Integration cloud)

Development Tools: TOAD, SQL*Plus, SQL*Developer

Operating System: Windows NT, UNIX

PROFESSIONAL EXPERIENCE

Environment: Oracle EBS (11i/R12.1.3), Procure-2-Pay, Order to Cash (O2C), Procure to pay(P2P) Oracle Forms, Oracle R.I.C.E, Oracle A.I.M, Alerts, Oracle SQL, Oracle PL/SQL, OM, PO, AR, AP TOAD, SQL*Developer, UNIX, Shell Scripting, WINDOWS XP, ODI(12.2.1.3), Oracle API’s

Confidential, Denver, CO

Oracle Cloud EBS Applications Engineer

Responsibilities:

• Working in Confidential Electronics, Inc. as an Oracle Applications Engineer on Oracle EBS B2B Projects (11i).
• Actively worked on R12 upgrade from 11i.
• Worked on Outbound Price Catalog (OB 832) (B2B) project implementation to onboard the old and new FTP customers from Web methods to ODI route.
• Worked on Oracle APEX Form Design and setups to onboard the old and new customers in Outbound Price Catalog (B2B) process.
• Worked in agile development and SDLC processes.
• Worked on XML Publisher report to send the list of price catalogs sent to the customers on a weekly basis.
• Integration between Oracle ERP Cloud and Workday HCM, Sales force and SailPoint
• Development of a significant number of FRS, SmartView and OTBI reports
• Customization of BI Publisher templates for checks, positive pay and Confidential payment files
• Executing data conversion for customers, suppliers, open AR transactions, GL balances, budgets and fixed assets using Oracle FBDI and ADFDI template
• Hands on experience on Oracle EBS Functional processes which includes EBS Design, Setups, and Form Personalization’s.
• Implemented Oracle finance cloud module and Procurement cloud modules and provided production support. Also trained users to use the cloud platform.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Developed end to end Apex form to store supplier’s information to onboard b2b reports and trigger the ODI job from the apex form to send the report via ftp.
• Worked on developing and supporting ODI reports.
• Worked on Oracle cloud implementation, migration from Oracle EBS and onboard product lines
• Onboard resellers into Reseller Cloud.
• Worked on ODI data models, mappings, packages, procedure, ODISFTP utilities and worked on data conversions.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Worked on Inbound PO (IBPO) or (IB850), Outbound PO Acknowledgement (OBPO Ack) or (OB855), Outbound PO ASN (OBASN) or (OB856) and Outbound AR Invoice (OB810) interfaces.
• Load the cleanseddata into oracle cloud using File based data imports (FBDI) and ADF DI.
• Worked on Sql loader and control files to load the data into custom tables for reporting purposes.
• Actively working on ODI to integrate Confidential transactions with outside vendors/Customers and 3rd party systems.
• Worked on suppliers import into oracle cloud using FBDI (File based Data import)
• Worked on source to data warehouse (target) data mapping in ODI, also sent files from target data warehouse to source systems such as (Eloqua, Salesforce, Everstring, etc) via FTP, SFTP and Email.
• Worked on ODI integration to pull the Quote and Contract Renewals from iAsset Database (3rd Party system) in to Confidential and worked with BI teams to generate XML and BI reports with this data.
• Worked on integrating Confidential sphere customization with Azure team to exchange the files through cloud.
• Worked on FBDI, ADF-DI, SOAP/RESTWebServices in Oracle ERPCloud
• Worked on XML/BI publisher reports for outbound price catalog weekly customer/vendor count.
• Designed and built OAF form to enter Outbound Price catalog customer and FTP information.
• Worked on Custom oracle forms to onboard new partners for EDI transactions.
• Understand business requirements and prepare MD.070/Technical document for enhancements to existing extensions.
• Built the Functional and Technical Design documentation.
• Extensively used OIC (Oracle integration cloud) to implement so many projects.
• Worked on Order management Standard and custom Workflows.
• Worked on oracle cloud applications and hands on experience on oracle SaaS.
• Worked on ODI (Oracle Data Integrator 12c) Sales Cut Off project to upload the data file into the EBS system for business purpose.
• Worked on ODI Outbound Price Catalog Design and support.
• Implemented and enhanced different Knowledge Modules in mappings for loading and integrating the data from sources to targets.
• Hands on experience on Oracle cloud infrastructure (OCI).
• Working closely with Informatica team for performing mapping and data loading which is same as ODI tool.
• Worked on Order to cash and Procure to pay modules.
• Worked on Oracle Sales Order form Personalization as a part of factoring project to factor orders from both Quick sales order form and Order Organizer.
• Worked on IBPO OAF workbench to process the Sales Order transactions
• Worked on creating Oracle Alerts to monitor the performance of the interfaces and provided continues support to the business.
• Involved in development, unit and integration testing, preparation of test scripts and scenarios for System testing.
• Worked on Reseller onboarding cloud implementation in oracle finance and OM modules.
• Involved in development activities including analysis, design, coding, data migration and testing for production and development environments.
• Worked on Outbound AR Invoice interfaces (OB810) to successfully transmit the invoices to the Customers during failure and continuous monitored the transactions as a part of Daily/Monthly/Yearly process.
• Involved in developing new B2B interfaces, customization of existing B2B interfaces to meet the business/client requirements.
• Working experience on closely working with Resellers/Customers and Suppliers/Vendors implementation, Production support to improve the business systems.
• Working on GIT version control and Flex deploy for production deployments and other pre prod deployments.
• Worked on analyzing and fixing EDI XML generated CLOB data in B2B interfaces.
• Maintained high standards of coding and involved in PLSQL Tuning and query optimizations.
• Involved in customization projects to enhance the performance of the EBS system.
• Performed Unit testing/B2B Integration testing and involved in the functional testing of the applications.
• Implemented APEX 19 for APEX Office Printing (AOP). Implemented summary, interactive report and detailed reports.
• Worked on oracle sql loader to load the data in the staging tables via concurrent job.
• Increased performance of loads by applying proper indexes, analyzing master tables and explain plans to check cost.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 12c.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Worked on data warehouse database system to load the tables from ODI for iAsset project.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator ODI .
• Created SQL scripts for sourcing data, including creating tables, Materialized views, stored procedures, and loading data into the tables.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 19.
• Used Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load into Oracle data warehouse
• Developed and implemented different item types auto complete, resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 19.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Optimal utilization of object-reusability features like reusable transformations, Mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i, 10g,11g OAF, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, INV, AP, CM, GL, PO, TOAD, SQL*Developer, UNIX, Shell ScriptingODI, WINDOWS XP, SQL LOADER, Explain Plan, TKPROF, Oracle API’s

Confidential, Miami, FL

Software Engineer

Responsibilities:

• Working in Confidential as an Oracle Applications Techno Functional Consultant (EBS R12 (12.1.3).
• Worked on Reimplementation from 11i to R12 in Financial Modules.
• Worked on Bank Statement Loader Inbound Interface to load the data files from Royal Bank of Scotland (RBS) into Oracle Cash Management (AP).
• Worked on Remediation from 11i to R12 for AP Invoice creation, which is an Inbound Interface from PODF (Third party system) to Oracle Accounts Payables and send notifications the users using SOA services.
• Developed and implemented different item types resizable text area, data picker, number field, and new rich-text editor using Oracle APEX
• Experience in configuring ODI Agent in ETL on UNIX server and creating new agents and test them in ODI 12c.
• Extensive DW experience using Oracle Data Integrator (ODI), Configured and setupODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and Implemented ODI 12c mapping to load multiple target tables.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse using ODI 12c.
• Used Oracle APEX 5.0 for designing application structure.
• Created SQL scripts for sourcing data, including creating tables, Materialized views, stored procedures, and loading data into the tables.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Worked on open source technologies and integrated with ODI(Oracle data integrated)
• Imported Invoices from Order Management via Auto Invoice Interface
• Converted RDF reports to XML reports.
• Designed and developed various RICEW components in R12.
• Worked on Pay on Receipt program in Accounts Payables.
• Worked on Payment Pipeline Process in Oracle Payments module which includes Inbound/Outbound Interfaces along with the custom Forms (10g/11g) and XML reports to handle the payments information.
• Involved in Sales Order Acknowledgement Report in Order Management (OM) of Order to Cash (OTC) Cycle.
• Developed and implemented different item types auto complete, resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.
• Good understanding on Workflow Approval process in OTL (Time & Labor).
• Worked on both External (IBY) and Internal Banks (CE) tables in Accounts Payables (AP).
• Involved in creation of new payrolls and data migration by using Open Interfaces.
• Worked on Custom Positive Pay Report for BOFA and US Bank to send the .txt files, to match with the actual check information before making a payment to the supplier.
• Migrated Outbound Interface from 11i to R12 and made changes as per R12 standards to extract the PO and Receipts information from Oracle to COSTA (Italy based operating unit for Carnival).
• Worked on Explain plan and TKPROF utilities for query optimizations.
• Worked on Purchasing and Receipts interfaces (Both Inbound and Outbound interfaces) from other operating units.
• Very good knowledge on AWS, Docker and Kubernetes and some of the Devops tools.
• Used Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting and provide various brand level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Worked on Check printing for payments to be made to suppliers, as per the Operating unit specifications.
• Worked on Oracle Crystal Reports to extract data from AP and AR modules.
• Tracked all client and Oracle Support activity related to Service Request (SR) issues and documented it in the client issue tracking system (Clear Quest) as well as the project implementation logs.
• Developed several BI XML Reports, OA Framework pages (OAF), Custom Forms and Workflows in different modules.
• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Designed & developed the One-time Unix Shell migration scripts using FND Load scripts to test the migration from Development instance to Test to Production Instances.
• Thoroughly Unit tested all the developed technical objects.
• Worked on Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Maintained high standards of coding and involved in PLSQL Tuning and query optimizations.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70, BR100using Application Implementation Methodology (AIM).
• Designed the Technical Document Specification (TDS) to document all the Technical components.

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i, 10g, 11g, OAF, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, ALC(Asset Life Cycle), OM, INV, AP, GL, PO, XLA, TOAD, SQL*Developer, UNIX, Shell Scripting, WINDOWS XP, WEB ADI, SQL LOADER, Oracle API’s

Confidential, Bothell, WA

Programmer Analyst

Responsibilities:

• Working in Confidential &T as an Oracle Applications Technical Consultant.
• Developed interfaces in OM and Inventory as a part of ALC (Asset Life Cycle, a custom application in Confidential &T to track Assets) in R12.
• Developed WEB ADI (Desk top integrator) to upload data from excel sheet to oracle lookups using oracle API’s.
• Developed few Custom Forms (11g) in OM, Inventory and Purchasing.
• Converted RDF reports to BI XML reports.
• Worked in Oracle Applications EBS R12 (12.1.3).
• Developed a custom OAF page to create ShipTo and BillTo addresses for a Sales order called from the Standard Sales Order Create form.
• Worked on AOL by attaching custom forms 11g to the AR menus and also worked on Exclude menu options to hide the custom form from other responsibilities.
• Tracked all client and Oracle Support activity related to Service Request (SR) issues and documented it in the client issue tracking system (Clear Quest) as well as the project implementation logs.
• Worked on Oracle XLA (Sub ledger) to create Journals.
• Development of new (Finance and HRMS) reports using Reports 10g.
• Developed the various business areas by using the XML for Service contracts and service request modules.
• Worked on Explain plan and TKPROF utilities for query optimizations.
• Created New Custom Business Area in XML for the Benefits, HR and Payroll also created some custom report for the client based on the requirement.
• Designed & developed the Inbound and Outbound Interface Programs to do settlements and other business requirements in Oracle ERP from other Database services.
• Developed several BI XML Reports, OA Framework pages (OAF), Custom Forms and Workflows in different modules.
• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Personalized the standard and custom forms.
• Worked on Oracle Alerts to send Email, based on some changes in the custom table.
• Hands on Experience in R12 production support.
• Worked intensely on customer import from third party system and updating them in ALC (Asset Life Cycle) to interface them into another third party system CATS using TCA API’s in AR.
• Workflow Customization
• Seeded OM Workflows are copied and customized to create Ship only Workflow.
• Workflow notification for Sales Order will be triggered Confidential the launch of Sales Order “Book” event and an email notification is sent to the concerned.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Recommended, Designed, Developed and documented various types of reports which are very use full to the business in Order process, Inventory and Shipping using Oracle report/BI Publisher with Bar code.
• Run the Invoice Inbound Program (INI), an E-Commerce interface program to import supplier invoices into Oracle Payables for manual and or electronic payments
• Designed & developed the One-time data migration scripts FND Load scripts.
• Analyzed the recommended patches and worked with OOD (Oracle on Demand) team and tested all the patches, in DEV and TEST instances on application performance and functionality.
• Developed ALC OAF page to maintain Confidential &T wireless and wire line customer information separately.
• Customized OM, Inventory forms using forms personalization.
• Configuration of Auto Invoice process to import invoices from Order Management to Accounts Receivables.
• Responsible for period closing activities, Internal - training and Client meetings
• Developed Crystal reports for the End users and worked in support environment.
• Developed a custom workflow to notify PO change information to the users.
• Worked on Configuring and Customizing OTL time card layouts for ATT users. Imported Invoices from Order Management via Auto Invoice Interface
• Thoroughly Unit tested all the developed technical objects.
• Prepared Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70, BR100using Application Implementation Methodology (AIM).
• Designed the Technical Document Specification (TDS) for Service Items module and Product related module.

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i, 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, HRMS, TOAD, SQL*Developer, oracle APIs, UNIX, Shell Scripting, WINDOWS XP.

Confidential, Dallas/Fort Worth, TX

Programmer Analyst

Responsibilities:

• Working in DFW as an Oracle Applications Technical Consultant in oracle EBS R12.
• Converted RDF reports to XML reports.
• Developed DFW AR custom Report to show contact list which are existing in oracle by choosing self-service role to give the access to i receivables module.
• Customized D/FW AP Trail balance report.
• Customized several AP reports according to user specifications.
• Personalized the supplier’s bank details page and invoice work bench page as per user requirements.
• Involved in end to end implementation in Accounts Payable module.
• Hands on experience in AP Check printing.
• Calculated payroll using predefined fast formulas in HRMS.
• Worked on TCA Customer and Supplier modeling.
• Worked on AR Auto Lock box and Auto Reconciliation.
• Setup Suppliers, Supplier Sites, Banks (Both IBY and CE), Bank Accounts and documents.
• Worked on D/FW Printed Requisitions report after migrating from 11i to R12.
• Worked on building relationship between TCA Customer accounts and have one account to pay for another.
• Developed D/FW Payables Open Interface Import Custom report from Payables Open Interface Import.
• Worked on D/FW Printed Requisitions Report.
• Developed XML Reports, OA Framework pages (OAF), Custom Forms and Workflows in different modules.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70, BR100using Application Implementation Methodology (AIM).
• Working on Business process flow billing to Oracle Projects to Receivables to GL and periods closing.
• Designed accounting reports, as per to business requirements and generated XML reports like Invoice, Summary and detail reports.
• Worked on Upgrade from 11i to R12.

Environment: Oracle EBS R12(12.1.3), Oracle Apps 11.5.10, Procure-2-Pay, Oracle Forms 6i, 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, TOAD, SQL*Developer, Java APIs, UNIX, Shell, PERL Scripting, WINDOWS XP, Microsoft Visual 6.0

Confidential, North Wales, PA

Oracle Developer

Responsibilities:

• Working in Confidential as an Oracle Applications Technical Consultant in oracle applications EBS.
• Developed AR Customer License Custom Form (used zoom and Attachment functionalities) for the customer service department to insert and update the customer license information.
• Developed AR Customer License Custom XML Report to send Emails to the Customers whose License is about to expire using XML Bursting.
• Developed EDMS Custom form in OPM Module which allows user to enter plant code and batch number related data.
• Worked in manufacturing module to develop Custom Forms and XML reports in BOM and WIP.
• Provided extended support during AR, AP and GL period closing for every month end.
• Worked on Audit trial to track the information on Customer tables.
• Developed few Custom Forms in AP.
• Used standard Oracle OE ORDER PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System.
• Used standard Oracle OE HOLDS PUB API to apply/release holds on the sales order created in Order to Cash (OTC) Cycle.
• Developed the Custom reports using Reports 10g as per the client requirements in OM module
• Customers are maintained using the Trading Community Architecture (TCA).
• Activating Descriptive flex fields (DFF) to capture additional information for the client not available in standard Oracle forms, set up Suppliers and Banks for AP use.
• Converted RDF reports to XML reports.
• Developed Oracle Workflows for customer License Database and involved in production support.
• Worked on 11i to R12 upgrade support.
• Worked on AOL by attaching custom forms to the AR menus and also worked on Exclude menu options to hide the custom form from other responsibilities.
• Created Service Contracts and submit the contract for approval.
• Developed Custom AR Transaction Form along with the mapping form.
• Developed AR Conversions Process from the legacy systems to Oracle Apps using BPEL (SOA).
• Designed & developed the Inbound and Outbound Interface Programs to do settlements and other business requirements in Oracle ERP from other Database services.
• Developed Confidential AP Rebate Approval Form (OA Framework) OAF pages and worked on some customizations.
• Implemented TCA Architecture for customers in Accounts Receivable module.
• Worked on payroll run concurrent program in HRMS.
• Developed Customer License OA Framework (OAF) page to add the excluded list of customers in to the custom table.
• Developed several XML Reports, OA Framework pages (OAF), Custom Forms and Workflows in different modules.
• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Personalized the standard and custom forms.
• Worked on Oracle Alerts to send Email, based on some changes in the custom table.
• Registered Forms, Reports, PL/SQL Packages, and UNIX Shell Scripting with AOL with parameters & incompatibilities.
• Recommended, Designed, Developed and documented various types of reports which are very use full to the business in Order process, Inventory and Shipping using Oracle report/BI Publisher with Bar code.
• Customized OM, Inventory forms using forms personalization. Configuration of Auto Invoice process to import invoices from Order Management to Accounts Receivables.
• Enter Credit Memo and Debit memo related to an original invoice: Credit Memos may be entered manually in Accounts Receivable to adjust a customer’s account balance.
• Manually Enter Customer Receipts, Enter Quick-Cash Receipt Batch, Mass Apply Receipts to Consolidated Invoices
• Thoroughly Unit tested all the developed technical objects.
• Wrote Control Files for SQL Loading to facilitate uploading of data from legacy system to the new system.
• Properly documented all the developed objects with MD0.50, MD0.70 and BP0.70, BR100using Application Implementation Methodology (AIM).
• Designed the Technical Document Specification (TDS) for Service Items module and Product related module.
• Designed & developed the One-time data migration scripts using FND Load scripts.