SUMMARY:

• 10 years of IT experience in Oracle Implementation, Customization, Development, Reporting, Data Conversion, Interfacing, Upgrade and Maintenance in Oracle Fusion Applications R9/R10/R11/R12 and Oracle Applications R12/11i in SCM, ASCP, Finance and HRMS using SQL, PL/SQL, Oracle 11g/10g/9i/8i, Forms 10g/6i, Reports 10g/6i, Discoverer 10g/4i, XML Publisher/BI Publisher, OAF and SQL Loader.
• Experience in major R12 Implementations, R12 Upgrade and 11i / R12 Production Support.
• Proficient in RICE items - Reports, Interface, Conversions, Extensions/Customization and production Support for Oracle modules: General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Fixed Assets (FA), Inventory (INV), Order Management (ONT), Shipping (WSH), Manufacturing Execution System (MES), Purchase Order (PO), Bill of Materials (BOM), Work In Progress (WIP) and Human Resources (HR).
• Good Knowledge in Order to Cash cycle (O2C), P2P cycle (Procure to Pay), and HRMS Modules.
• Experience in customizing Workflows using Oracle Workflow Builder 2.6.
• Experience in all phases of Software Development Life Cycle (SDLC) including Analysis, Specification, Development, Maintenance, Testing and Documentation.
• Proficient in System Administration, Application Object Library, TCA, Web ADI and XML Publisher.
• Extensive experience in registering Concurrent Programs, Form, Functions, Menus, Tables, developing Key and Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL) and System Administration in Oracle Applications.
• Strong knowledge in design and development of interfaces (inbound and outbound using API'S and open interfaces for integrating other applications with Oracle Applications.
• Expertise in Client Interaction, Requirement Gathering, Process walk through, Mapping, GAP Analysis and Technical Design documentation and Full lifecycle implementations, Upgrades and Production Support.
• Support of Production and Test instances for upgrade/regression/integration/User acceptance testing. Test Plan Preparation, Technical design and Coding, UAT, Production Migration and documentation in Oracle Applications
• Proficient with Discoverer & XML/BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experience in Discoverer Administration and User Edition for generating number of complex reports in Oracle Financials.
• Good knowledge in using performance-tuning utilities like EXPLAIN PLAN, SQL Trace and TKPROF.
• Experience in customizing existing OAF Screens, ADF screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Proficient at writing PL/SQL Scripts and other related tools and techniques on Oracle Database
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Triggers, SQL*Loader /UTL and FNDLOAD scripts.
• Experience in preparing technical documents like TE.020, MD.050, MD.070 and MD.120
• Excellent analytical, problem solving and communication skills with ability to be an effective team player and work under severe time constraints.

TECHNICAL SKILLS:

Oracle Fusion Applications: Oracle Fusion Applications, R9, R10, R11, R12, HCM, PPM, Financials and Procurement.

Oracle Applications: Oracle Applications R12/11i, OM, WSH, INV, PO, BOM, WIP, AP, AR, Core HR, SSHR, Payroll, TCA, AOL and System Administration.

RDBMS: Oracle 11g/10g/9i

Database Tools: Oracle Forms 10g/9i/6i, Oracle Reports 10g/9i/6i, JDeveloper 11.1.1.7, Oracle Discoverer 10g/4i, XML/BI Publisher, OAF, ADF, SOA, BPEL, Oracle Workflow 2.6.

Tools: & Utilities: TOAD, SQL Developer, PL/SQL Developer, VISIO, MS Office, PVCS.

Languages/Frameworks: SQL, PL/SQL, Java, HTML, XML, PERL and Shell Scripting.

Platform: UNIX, Linux, Windows XP, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Oracle Fusion Consultant

RESPONSIBILITIES:

• Involved in configuration of PaaS and web services, custom reports development in GL, FA, HCM and PPM modules using BI Publisher and OTBI.
• Developed custom financial reports in Hyperion using Financial Reporting Studio.
• Developed Interfaces, Reports and Web Services for the synchronization of absence data from Workday into Oracle Fusion via PaaS.
• Developed custom packages, procedures, functions, sequences, triggers, tables and views in Oracle PaaS.
• Developed custom job roles and duty roles and assigned to user accounts.
• Managed user security and web services across Oracle Fusion SaaS and PaaS for integration to third party applications.
• Developed Restful web services with security for integration between PaaS and Workday for Absence reconciliation and custom procedures to validate the data sent in web services.
• Integration of custom Confidential applications built in PaaS into Oracle Fusion using JWT token and customized the application menu to add the new screens.
• Dynamic layout creation and send reports from Oracle PaaS for Absence Reconciliation to the employees and managers on a schedule.
• Scheduled the pl/sql batch jobs in Confidential in PaaS.
• Customized the applications UI appearance to differentiate the instance and customized the default application logo.
• Setup and load Budgets into Oracle Fusion and built Hyperion reports against budgets data using FRS.
• Developed Balance Sheet report, Overhead report, Management accounts, P&L reports using Financial Reporting Studio.
• Development and unit testing of GL Cognos Trial Balance Report.
• Developed Contract Billing vs PO, Actuals vs Budget, Timesheet Summary, Unauthorized Invoices, Project Funding, Billing and Forecasting per Contract and Payroll vs Timecard report, Gross Profit by month to dynamically display the monthly data, Aggregated Gross Profit, Gross Profit Summary and Gross Profit detail report by Project for PPM using BI Publisher and OTBI.
• Developed reports with multiple parameters and dependent parameters to update dynamically based on the user logged into the application.
• Developed custom reports in Excel template to fix the Excel merge cell issue and provide the default features of Excel.
• Developed Matrix style cross-tab reports and multi tab custom reports using BI Publisher and Interactive layouts.
• Developed Approved Time Updates report, Missing Timecard report and Project Team Members reports in HCM using BI Publisher.
• Developed Project Team Member allocation integration to dynamically allocate or revoke Project Team member roles based on the setups maintained in FND Lookups.
• Migration of BPM rules and UI personalization.
• Automated the Missing Timecard report to send email to employees and their managers for missing timecards. Secured the report data using SQL queries based on the manager roles and Legal Entities assigned to the employee HR record.
• Developed CIP Asset analysis report.
• Performance enhancements to other custom reports taking long execution times.
• Developed Delegated approvals report to display Override approvals for purchasing approvals.
• Analyze and fix the performance issues for large amounts of data in OTBI.
• Unit testing and documentation of custom objects developed, version control into Oracle Developer Cloud and migration of custom objects into other instances respectively.
• Developed custom report to analyze system performance by listing long running processes in the background.
• Worked with Oracle Support on 24/7 SRs for troubleshooting and enhancement requests on existing bugs in Fusion.

ENVIRONMENT: Oracle Fusion Applications R11, R12, SaaS, PaaS, SQL, PL/SQL, OBIEE, OBIA, Smart View, HDL, FSM, FRS, BPM, OIM, SOAP UI, Web services, JIRA, Source Tree.

Confidential, RI

Oracle Fusion Consultant

RESPONSIBILITIES:

• Involved in requirements gathering.
• Involved in conversion of customers, Suppliers, Purchase Orders and Open Invoices data from legacy system to Oracle Fusion applications.
• Prepared proof of concepts for inbound and outbound integrations for the client.
• Automated inbound integrations to Fusion applications for General Ledger data for daily sales and inventory stock ledgers using web services.
• Automated the integration of expenses from third party application Concur to Fusion applications using web services.
• Automated integration of Purchase Orders data from Retail Management System and generated Purchase Orders from Fusion using web services.
• Create user accounts and manage user roles assigned and developed custom reports for audit purpose.
• Developed user account notification templates in Fusion.
• Developed custom roles according to business requirements.
• Created new AP Check template for US and Canada bank formats.
• Designed and configured to automatically create Positive Pay and ACH file payment process.
• Involved in automation of outbound integrations from Oracle Fusion for Chart of Accounts, Suppliers, Payment Terms and Customer Credit for credit checking purposes.
• Setup of SFTP server on Fusion to transfer files from Fusion to client server location.
• Developed multiple custom BI reports, Dashboards and Analytics in Oracle Fusion.
• Created custom roles and assigned privileges to the user.
• Created MD.050 for functional requirements, MD.070 for technical specification documents and CV.040 for conversions and field level mappings documents.
• Defined new scheduled processes and Job sets to run multiple jobs.
• Involved in providing super user training and performed system testing for upgrade from R9 to R10 and R10 to R11.
• Customized the application with logo and theme for the instance.
• Setup post clone activities after refresh from PROD to staging instances.
• Configured and customized Requisition and Purchase Order approvals and Journal approval processes.
• Customized Purchase Order and Requisition templates in the system.
• Worked with Oracle Support on 24/7 SRs for troubleshooting and enhancement requests on existing bugs in Fusion.

ENVIRONMENT: Oracle Fusion Applications R9, R10, R11, SQL, OBIEE, Smart View, Universal Content Management, APM (Authorization Policy Manager), BPM, OIM, SOAP UI, Web services.

Confidential, FL

Oracle EBS Techno-Functional Consultant

RESPONSIBILITIES:

• Involved in the Conversion of Vendors from legacy system into Oracle Applications.
• Developed conversions to load the data into Oracle database using SQL loader programs.
• Developed WebADI for uploading and downloading of data to custom tables and assigning the form function for the WebADI to Menu.
• Developed custom code for the various components across different modules in Oracle apps using SQL and PL/SQL.
• Customized AR Invoice Report.
• Customized new reports for Commercial invoice, packing list and PO print standard and release reports, Inventory Item out of stock report, large order, Back order summary and detail reports using Oracle Reports Builder 10g, BI Publisher and XML Data Template.
• Extensive Experience in OM API's for BPA Price break update, order creation and order-updating.
• Developed Generic Matrix form for order management and Clarifications form for customer support to send emails and faxes with attachments using Java mail to customers.
• Developed film positive process to print custom film imprints on the pens and job traveler report with the order details, components, operations and resources associated to the discrete job for printing the films.
• Implemented MOAC to access data from multiple organizations within the same responsibility.
• Used CUSTOM.pll to provide customizations to Oracle Application forms that are protected against patches and updates.
• Created util packages for order management and inventory modules.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Customized Order Header workflow process to close the Order Header after a specific time once Order line closes.
• Form Personalization done to seeded and custom forms as per client requirements.
• Created Sales orders using CTO items, Pick released and shipped the orders. Generated Invoice for the configured orders by submitting the Jobs.
• Created SQL*Loader control files for moving the data from flat files to staging tables.
• Created Tables, Views, and Grants, Synonyms, Sequences, Stored Procedures, functions and Packages as part of the Client Requirement.
• Worked on Journal Import Interface, Receivables auto invoice Interface, Customer Interface and Payables Open Interface and customized several other reports.
• Provided user training to the End Users on each component to be used at End user.
• Perform application tuning and performance monitoring.
• Worked on Order management, shipping and Discrete manufacturing modules.
• Developed alerts and distribution lists to monitor process activities.
• Created TE020s for Unit Test Cases, MD70s for technical design and MD120s with the migrations steps and procedures to migrate and install the CEMLI.
• Created install scripts in UNIX for creating the database objects and load scripts to load data to custom tables using sql loader.
• Created tar files to promote the CEMLI to other instances for Oracle OnDemand.
• Created SRs for Oracle OnDemand for migration of CEMLI.
• Involved in providing 24*7 on call Production support after go-live.

ENVIRONMENT: Oracle Applications 12.1.3 (AP, AR, GL, FA, BOM, PO, WIP, INV, ONT, OE, WSH, MES, AOL, SYSADMIN), Oracle 11g, PL/SQL, SQL, Forms 10g, Reports 10g, OAF, ADF, Workflow Builder 2.6.3.0.1, SourceSafe, SQL*Loader, BI Publisher, Putty, Filezilla, Windows XP and UNIX.

Confidential, FL

Oracle EBS Techno-Functional Consultant

RESPONSIBILITIES:

• Analyze and understand the Client requirements.
• Identify and de-commission redundant custom objects made obsolete by the Upgrade or no longer required by business.
• Prepared Technical design document MD 70 based on MD 50. Prepared CV 60 for conversions and prepared TE 20 and TE 40 for the test scripts.
• Developed new XML reports in place of RDF reports. Converted RDF reports to XML reports.
• Defined Shipping rules for the Mixed and Return orders.
• Used Custom.PLL to implement change in behavior of Standard Oracle Applications forms in and Developed new custom form as per the user Requirement.
• Involved in setup of Responsibility restriction to different organizations.
• Involved in enabling operating units for Concurrent programs submission.
• Responsible for setting up responsibilities and providing organizational access. Created catalog and ad-hoc requisitions.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers) for OAF Pages.
• Designed purchasing cycle to take care of generating requisition for raw materials, approval of requisitions, placing Purchase Order on the supplier, receiving the material in and finally making the payments.
• Defined transaction types, order modifiers, price lists, shipping parameters, picking rules and credit check rules.
• Invoice Generation for the eligible orders in Receivables and importing the data to GL.
• Developed XML reports to be fired at Pick releasing the order and Shipping the order.
• Defined Alerts for notifying the customer about the order status at each phase.
• Setup the New instance using FNDLOAD and create the Responsibilities, Menus, Concurrent Programs, Requests sets and Custom.pll, Custom Forms and Report Changes.
• Prepared controlled documentation throughout all the phases of the Upgrade project and maintained the versions of code and documents using PVCS.
• Responsible for conducting the complete cycle of testing in O2C (Order to Cash) and P2P (Procure to Pay) before go-live.
• Form Personalizations to various forms.
• Implemented MO Security Profile for API’s and reports.
• Conduct System / Integration tests on configured Oracle applications system and custom-built reports, interfaces, extensions, etc
• Set-up, facilitate and assist client in carrying out User Acceptance Testing (UAT), including assisting with creating and executing UAT test cases as requested.
• Bug fixing working extensively with Oracle for Service Requests.TAR resolution on demand & priority basis
• Handled Client requests and provided solutions. Resolved Support issues with Oracle On-Demand support for Order Management, Inventory, BOM, WIP, Purchase Order and Receivables.
• Defined and documented issue reporting, tracking and monitoring, resolution and escalation processes
• Planned detailed work break down structure to cover the delivery in time as required by Client.
• Documented all the work using AIM methodology and explained the new changes for the daily end to end users.

ENVIRONMENT: Oracle Application Suite 11.5.10/R12(OM, INV, PO, GL, AP, AR and FA), SQL, PL/SQL, TOAD, SQL*Loader, Workflow, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle 11g, XML Publisher, OAF, JDeveloper 11g, PVCS, HP Quality Center and Windows XP.

Confidential, NC

Oracle EBS Technical Consultant

RESPONSIBILITIES:

• Analyzed business requirements and performed gap analysis to map user requirements to R12 transactions utilizing Oracle’s AIM Methodology.
• Analyzed the Finance module and the flow of the payments.
• Analyzed the Customized Flow of Q2C (Quote to Cash) cycle, detailed functionality flow of OM to AR. Placing of an order till payments receive from its Customers. Gone through the functionality of QTC in detail. Gone through various interfaces/tools involved in the QTC process.
• Data replication from Order Management to install base and Service Contract.
• Developed triggers to update status of the service contract of the product in the Service contract instance.
• Prepared Technical design documents as per Client format and maintained review check list for each object for cross verification of Client standards.
• Developed PL/SQL code, Prepared Triggers to make the Lines Eligible for Export Screening.
• Developed inbound custom interface program to load Inventory data from external feeder system into MTL TRANSACTION INTERFACE table. Created SQL*Loader control files to load the staging table with external data and developed PL/SQL procedures to perform data validation prior to inserting data into interface tables.
• Developed PL/SQL Stored procedure and defined a concurrent program Validated Data Collection to retrieve data from the Trade collaborator instance after the screening of the orders to QTC/BV instances.
• Created new custom PL/SQL procedures to use BOM API to import information like Revisions, Bill Components and Substitute Components from legacy system and used API to update and delete existing BOM information in Oracle database
• Providing production support on Financials - monitoring day-today processes, ensuring timely fix of the production problems encountered, data fixes, facilitates in execution of the Month/Quarter/Year End batch processes & troubleshoot the issues for the business users and business analyst.
• Customizing already existing Forms by using Form Level Trigger, Item Level Trigger and Block Level Triggers in several modules such as GL, AR, AP, FA and OM.
• Documented Issues and its resolutions, Maintained Issue resolution tracker and uploaded into Knowledge forum as a reusable component to help the other team members.
• Developed DB Links to link the QTC/BV and TC databases.
• SQL and PLSQL program tuning for performance in global instance
• Process Order Open Interface setup to load sales order and integration with Accounts Receivables for Invoice creation.
• Worked on resolution towards the issues with customer addresses, party relationships and trading community architecture.
• Addressed many generic and project relates issues during Test cycle support.
• Performed Integration testing on OM to AR data flow. Prepared Unit Test Cases document
• Defined Alerts to send notification to the customer who has placed order from external system, that Sales order is imported to Oracle.
• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf.
• Extensively worked with cross flow team during issue resolution and prepared issue resolution documents, shared with team members.
• Prepared controlled documentation throughout all the phases of the Upgrade project and maintained the versions of code and documents using PVCS.

ENVIRONMENT: Oracle Application R12 (OM, AR, INV, BOM, GL, PO and AP), Workflow, Oracle 10g, SQL, PL/SQL, TOAD, SSH/FTP, PVCS, Dollar Universe (collection of programs scripted in UNIX), XML Publisher, HP Quality Center, Windows XP

Confidential, CT

Oracle EBS Technical Consultant

RESPONSIBILITIES:

• Analyzed business requirements and performed gap analysis to map user requirements to 11i transactions utilizing Oracle’s AIM Methodology.
• Prepared technical design documents MD 70 for interfaces, CV.60 for conversions as per Client format and maintained review check list for each object for cross verification with Client standards
• Prepared TE 20 and TE 40 as per Client format and maintained review check list for each object for cross verification of Client standards
• Developed Critical Payroll XML reports in all the possible output formats like Excel, PDF and RTF
• Developed XML Payroll reports for the user reconciliation purpose. Reports like Gross to Net comparison report - Element basis as well Employee basis reports using PL/SQL code and GTT table’s concept as to handle session based data.
• Developed HR letters like Appointment letters for various categories of Contract staff using XML Publisher
• Developed Pick slip reports and Shipping reports using XML publisher for reconciliation purpose with Excel and PDF output
• Defined Purchase order approval hierarchy groups using workflow and AME
• Form Personalizing for Employee form in HR, Sales Order form in OM and Purchase order form in PO
• Developed Alerts which fires to the respective person when the employee completes the probation period
• Form personalization of forms in Core HR module.
• Customized the menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.
• Involved in migrating master and transactions data by using PL/SQL procedures to validate data in pre-staging table and importing data to base tables through APIs for OM, PO, AP, AR and HRMS Modules
• Tuned existing custom On Hand Inventory report queries in INV to increase performance of the report.
• Developed interface program to Upload data into interface tables from Legacy System and Used SQL * Loader to upload data from Flat Files to Pre- interface table and wrote PL/ SQL Procedures for all the business validations
• Developed Crystal Reports by connecting to Oracle database using views. Created view on multiple tables using joins.
• Implement Oracle standard Archive/Purge Processes to clear old data
• Code Movement and Version Maintenance using Kintana and PVCS
• Bug Fixing and updating the status through Oracle Siebel Service Request tool
• Developed Interface and Conversion programs to interface external systems applications data files to Oracle Application modules using UTL FILE, PL/SQL and Unix shell scripts
• Worked on various inbound & outbound interfaces for OM, PO, INV and HR modules
• Built custom screens for the Benefits to show Employees and Assignment history, leave information using OAF
• Maintaining/supporting end user issues for the Order to Cash(O2C) Cycle and Procure to Pay cycle
• Conduct System / Integration tests on configured Oracle applications system and custom-built reports, interfaces, extensions, etc. Extensively worked with cross flow team during Integration testing and prepared issue resolution documents, shared with team members
• Provide Post Production support after go-live for the SCM, Financial and HR modules

ENVIRONMENT: Oracle Applications Suite 11i (Core HR, SSHR, Payroll, OM, INV, PO, BOM, WIP, AOL), SQL, PL/SQL, TOAD, Workflow, XML Publisher, Workflow, Alerts, Oracle 10g, JDeveloper, OAF, Unix, Windows XP, PVCS, Kintana, Psftp, Putty.

Confidential, TX

Oracle EBS Technical Consultant

RESPONSIBILITIES:

• Developed Custom Reports in Inventory and Order Management modules as per the user requirements
• Developed Move Order Actual Receipts error report to provide error details of move orders in Inbound staging table
• Customized reports like company income statement, company balance sheet and trial balance reports for GL module
• Customized various reports in AP Module including the following: Supplier Payment History Report (AP), Account Payable Trial Balance Report (AP) and Invoice Aging Report (AP)
• Customized many reports such as Recurring Invoice Report, Payment Schedule Report in AP, provided the users with detailed vendor reports on existing vendors
• Developed summary report to provide details of receipt confirmations in PO and Inter-Org Transfer with XML Publisher
• Involved in developing new DFF’s, Value Sets and Values for supporting the reports developed
• Registration of customized reports through creation of concurrent executables, concurrent programs, and assigning to the request group.
• Involved in development of custom objects for third party integration with Oracle Applications
• Worked on prevention of Back Order of deliveries based on business rules for an Inbound Interface
• Worked on Cycle Count Outbound Interface for providing data file for third party application
• Interacted with business users for setting up Auto-Lockbox process
• Worked on Error Handling System in storing all the errors that occur during interfacing and loading
• Developed trigger to pull delivery data required to be sent to third party application as ship request
• Developed an Interface program for Inventory Adjustments
• Imported data from Legacy systems into temporary tables in account payables and successfully designed and implemented Payables Interface
• Experience with SQL*Loader, UTL FILE, Oracle Export and Import utilities.
• Involved in customization of the Purchase Order workflow, which include addition of events, notifications, and functions
• Workflow customization for Order Management. Reporting for shipping distribution and order statuses which were used for month-end closing
• Worked in the support role, performed the responsibility of system administration tasks like creating users, setting up the user profile etc.
• Used CUSTOM.pll to provide customizations to Oracle Application forms that are protected against patches and updates.
• Worked with Oracle Trading Community Architecture API’s for customer interface and Auto invoice purge program to purge the successfully processed rows from interface tables.
• Dealt with registering / defining of custom applications, tables, forms, reports, concurrent requests, standard report submission etc and also with profile options, defining of application users and responsibilities.

ENVIRONMENT: Oracle Apps 11.5.10 Modules: (OM, WSH, OTA, GL, AP, AR, PO, INV), Oracle 9i, Reports 10g, Forms 10g, Discoverer 10g, XML Publisher, Workflow Builder, SQL*Loader, Toad, UNIX, PL/SQL