SUMMARY

• Around 10 years of IT experience in Oracle Implementation, Customization, Development, Reporting, Data Conversion, Interfacing, Upgrade and Maintenance in 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), Advanced Supply Chain Planning (ASCP), Demantra 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 noledge 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 noledge 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 Applications: Oracle Applications R12/11i, OM, WSH, INV, PO, BOM, WIP, AP, AR, VCP, ASCP, Demantra, 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, OAF, ADF, HTML, XML, C, C++, PERL and Shell Scripting.

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

PROFESSIONAL EXPERIENCE

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 updation.
• 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.
• Developed custom solutions for iExpense and iProcurement module.
• OAF personalization for self-service modules: iExpenses, iProcurement, and iSupplier.
• 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, 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.
• Prepared MS power point to brief the Business requirement and solution in the Client meetings and Prepared flow chart diagrams using MS VISIO to brief the business process.
• 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.
• Implemented the latest Patches by raising the SR with Oracle.
• 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 unitsfor 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 halp 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 TEMPhas 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.
• Added an SIT’s for adding the education and qualification details
• 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

Confidential, Cleveland, OH

Oracle EBS Technical Consultant

Responsibilities:

• Converted Order Detail Report, Credit Order Summary Report, and Orders by Item Report in Order management from report 6i to XML publisher.
• Customization of Standard Purchase order screen.
• Developed assign buyer to PO requisition extension to assign buyer to requisition line based on purchase order category.
• Involved in granting access and task privileges to the new users in Oracle Applications.
• Developed AP GRNI Report, Escheatable Checks report, Period to date Transaction Report, GL Intransit Orders report, AR Partial Paid Transaction Report in XML Publisher.
• Created multi-layout report to hide/show columns based on the profile options of the user who is running the program.
• Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc. Created Request Groups for reports.
• Developed Scripts and registered them as concurrent programs for various business requirements.
• Created value sets and profile options to pass parameters to concurrent programs.
• Raising Oracle TAR's and worked for solving the problems.
• Concurrent Programs Scheduling and monitoring for daily process, Month and Year end.
• Imported the GL journals using Web ADI and exported the same to EBS using ADI.
• Developed custom pages for various EBS Modules using OAF and Performed personalization using OAF
• Worked on CO extension using OAF in HRMS self-service page.
• Performed EO based VO Extension using OAF.
• Performed VO Extension for adding Employee Address Region using OAF.
• Worked on Controller class (CO) extension using OAF.
• Tuned SQL statements using HINTS and appropriate indexing and Re-organizations of tables to improve the performance.
• Developed Vendor conversion program to import all vendors' information from legacy system.
• Involved in writing data load scripts to load lock box data in to payment interface tables and validations .Also developed 6 different lock box reports to identify the errors and correct them and reprocess failed lock box records.
• Developed custom AP invoice interface validation program to do additional validation while importing invoices from third parties to meet the business requirement and also build invoice interface audit report to track the change in legacy imported invoice at interface level.
• Worked on iSupplier implementation and developed new reports.
• Developed automatic emailer program by using shell script.
• Provided production support on Core HR, Payroll and SSHR - 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.

Environment: Oracle Applications 11.5.10, Oracle Financials, AP, AR, GL, iReceivables, HRMS, OAF, JDeveloper, Oracle, Web ADI, UNIX, SQL and TOAD.

Confidential

Junior Technical Developer

Responsibilities:

• Design and develop various Forms and Reports using Forms6i/Reports6i as per the client requirement.
• Developed Oracle Stored Procedures, Database triggers for automated data updates.
• Analyzed existing database and prepared requirements to generate reports.
• Interacted with the business users to prepare report requirements.
• Design and develop Coding to calculate total Salary for each employee and design like input design to enter each employee information, status and address.
• Created Record Group and attach to require attribute
• Involved in preparation of technical documentation.
• Developed stored procedures, Functions, queries, triggers, rollback scripts using SQL and PL/SQL which are used in the business logic
• Wrote large and complex PL/SQL procedures and functions to efficiently perform complex business logic to summarize data.
• Developed Crystal reports connecting to Oracle Database as per the business requirements.
• Developed Parameterized Crystal Reports as per the user requirements.
• Planned for backup and recovery of database information
• Managed primary database structures (table spaces) and primary objects (table, views, indexes)
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges using TOAD.
• Developed forms using Form builder to in corporate client requirements like Bank details in the form. Allows user to enter, update and save his/her account details.
• Developed Reports using Report builder to generate reports displaying details of the customers holding account with Bank of GHANA on year basis.
• Wrote Procedures and Functions using Dynamic SQL and also wrote complex SQL queries using joins, sub queries and correlated sub queries
• Created tables and materialized views, Troubleshooting performance issues and bugs within packages.

Environment: SQL, PL-SQL, SQL Plus, Forms, Reports, XML Publisher, Putty, Winscp 3, FTP, Windows XP and UNIX