CHRONOLOGICAL SUMMARY of Experience

Oracle Techno Fuctional Consultant

Confidential

• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents BR100 and other design documents as MD050
• Reviewed functional requirements related to Oracle payroll, HRMS, I-Recruitment, Time Labor, and Manager and Employee Self-Service
• Design and develop system enhancements, interfaces and integrations across multiple systems after R12 upgrade in P2P and C2C modules
• Data migration activities of Core HR/Payroll through conversion scripts like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc
• Creation of new payrolls and data migration by using Open Interfaces.
• Creation of Rates, Benefit Structure, Premiums, Coverage, Eligibility, Plan Types, Options, Life Events, Literatures, Extracts, Quick Codes, Global Values, Rule creations and Rule enhancement Fast Formulas .
• Defining New Users ,Creating Responsibilities and assign responsibilities to the Users
• Compared the payroll run results from the 11i payroll to the R12 payroll identifying and resolving any discrepancies found in the validation.
• Assisted in reformatting of payroll checks using the Payroll Archive check style
• Establish data conversion routines and executed scripts to convert GL,PA, AP and FA data from legacy systems
• Established new procedures for AP, PO, GL and FA, SLA modules.
• Responsible for design, development of reports across various modules using XML/BI Publisher.
• Customized the Master/Detail budget report in GL and the Discounts Available
• Involved in design and development of AP check register and AP Cash Forecast reports to create visibility of cash flows to business users
• Design and development of AP Supplier Conversions Vendors, Vendor Sites and Vendor Contacts and Invoice Conversions using AP Interface Tables, PL/SQL packages, API's
• Design and development of custom payables transfer to GL batch process
• Involved in customizing Standard PO Import Program, PO Requisition Import program to import requisitions into oracle applications.
• Setups and customizations for High Volume Order Processing, Drop Shipment, Internal Sales Order
• and resolving issues in Order Management ,Credit Card Settlement through Cash reconciliation
• Import Sales Order data from legacy system into staging tables and populated Oracle base tables with the sales order data.

Environment: Oracle Apps R12 HRMS,AP, PO, FA,GL,SLA,AR, OM Oracle 10g Database, PL/SQL Developer, TOAD, SQL Navigator, Oracle Reports 10g,Oracle Forms 10g, UNIX Shell scripting, XML/BI Publisher , Workflow Builder.

Oracle Techno Fuctional Consultant

Confidential

• Updated functional ,technical design documents for development and customizations for upgrading and new implementation to R12
• Good Experience in implementing OracleHRMS, Order-to-Cash and Procure-to-Pay Business Process and oracle pricing flows
• Ensured accurate processing of all payroll transactions including payroll reversals, balance adjustments, costing processes, and quickpays.
• Validated payroll run results.
• Validated data from PeopleSoft and GlobalView to ensure that all data transferred accurately.
• DevelopedcustomXML report to direct deposit and payroll checks.
• Performed balance adjustments to correct missing mid-year payroll balances
• Developed ZOOM functionality that pops up appropriate form based on the user and modified CUSTOM.PLL to activate zoom
• Used Forms Personalization created a special trigger in user screen requirement
• Design, development unit and functional testing of developed components in PA,OM,AR,AP,GL, PO,SLA,INV modules
• Created end-user documentation to record process for recording taxable and non-taxable moving expenses.
• Worked on Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed custom Oracle Reports that include Sales Order Acknowledgement, Packing Slip Reports, Invoice Payment Summary Report, Payables Expenditure Report, Inventory Moves Report
• Worked on the Supplier Open Interface Import, Supplier Sites Open Interface Import and Supplier Site Contacts Open Interface Import processes in Oracle Payables to create new Suppliers, new Supplier Sites and new Supplier Site Contacts respectively.
• Developed AP Positive pay Extract Report in Oracle Payables which will extract the US transactions from source systems and sent to bank.
• Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher.
• Extensive Experience in OM API's like order creation, order updating and pricing
• Customer cum order interface designed for a brand new customer who is coming with an order.
• Set up and customization of Sales order holds using PL/SQL stored procedures, workflow modification, messages
• Gathering requirements for lockbox interface, designing the lockbox bank file format, setting up the functional setup for lockbox, designing the PNC National bank interface validations for the lockbox load.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Developed various complex custom forms like Inventory position detail form , Requisition import fail for drop ship sales order form
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.

Environment: Oracle Apps R12 HRMS,AP,GL,FA,AR,SLA,OM , Oracle 10g Database, PL/SQL Developer, TOAD, SQL Navigator, Oracle Reports 10g,Oracle Forms 10g, UNIX Shell scripting, XML/BI Publisher , Workflow Builder.

Oracle Applications Technical Consultant

Confidential

• Requirements gathering for the Interface and reports through interaction with functional team and business users.
• Expertise in Creating and managing customers Using TCA Trading Community Architecture in AR module.
• Created PTO accrual plans, researched issues related to International and ex-pat employees Human Resource information, and provided application expertise to end-users.
• Analyzed employee information to identify employees with incorrect or incomplete processes.
• Prepared journal vouchers to correct any discrepancies or retroactive changes, which posted to the general ledger.
• Transmitted electronically all payroll ACH files, verifying receipt and accuracy of these files.
• Developed Customer Invoice Report, Purchase Order Report using XML/BI Publisher.
• Involved in Reports Generation and Customization using Reports 10g.
• Calculated daily special payments and applicable federal and state taxes.
• Audited personnel financial records to ascertain proper credit and debit of pay and entitlements.
• Customized the standard AR Invoice History Report using Reports 10g.
• Customized AR Aging reports in Accounts Receivable AR using Reports 10g.
• Used SQL Loader and UTL FILE Packages for data conversion and interfaces.
• Developed PL/SQL procedure to load all legacy system Items into Oracle Inventory with Open Item interface. Import and validation were performed using PL/SQL package
• Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.
• Developed custom PL/SQL conversion program for validation and loading GL Balances using Oracle Standard GL Interface program.
• Defined the descriptive flex fields and key flex fields.
• Worked on Auto Lockbox Open Interface for automatic processing of receipts in AR module of Apps based on electronic bank statement data.
• Developed PL/SQL Package to check data in the auto lockbox tables for compatibility with receivables and transfer the data into Quick Cash tables for the application receipts to the corresponding open transaction update customer's balances.
• Involved in Customer Conversion from legacy system into Accounts Receivables AR by using Customers Interface.
• Worked on the Auto Invoice Interface to load legacy invoices into AR.
• Created Trigger on AR PAYMENTS INTERFACE ALL to generate receipt number automatically.
• Created cash receipt usingCreate cash API for the payment received in the form of check or cash.
• Experience in extracting data from oracle applications 11i and migrated the data into oracle application E-Business suite R12 using oracle APIs.
• Designed and developed Custom Check Request form in Account Payables using Forms 10g
• Developed various reports like PO Print Report, Invoice Printing and Attachment Report and Credit Memo Report in Reports 10g.
• Implementation of business specific custom programs by writing PL/SQL stored procedures.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Applications.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context and modified CUSTOM.PLL to activate zoom

Environment: Oracle Apps R12 HRMS,AR,GL,AP PO, FA , Oracle 10g Database, PL/SQL Developer, TOAD, SQL Navigator, Oracle Reports 10g,Oracle Forms 10g, UNIX Shell scripting, XML/BI Publisher 5.6.3.

Oracle Applications Technical Consultant

Confidential

• This project was an implementation of R12 from 11i which includes implementation and customizing the Oracle applications 12.1.3 .
• Discussed with users to gather Business Requirements and to develop a model to implement the system with 'Order to Cash' and 'Procure to Pay' cycles.
• Created new reports as per business requirements and customized XML publisher report for AR Invoice in the client specified layout
• Customized the Oracle PA account generator workflow.
• Modified standard Transaction Control extension to mark transactions for capitalized development project as non-capitalizable when they are charged outside of the technical feasibility date and after the general availability date associated with the project.
• Customized standard Oracle reports as per the business requirements order by item report, order/invoice detail report.
• Worked on setting up of Customer site/ Install base information for customers.
• Developed and integrated Interface Programs for porting Legacy Data into Oracle Database besides using SQL Loader as a tool. Worked with various Interface tables of AP, GL, AR.
• Modified standard Projects Draft Invoice Auto-Approval workflow Extension to send a report to the Project manager and a specified set of users for all the draft invoices that are not auto-approved.
• Prepared design documents for Migrating legacy Customer information to TCA model in Apps using TCAAPI's.
• Migrated legacy Customer information to Trading Community Architecture TCA model in Apps using TCAAPI's for Customer Online.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed PL/SQL package and procedures to load order data from external system to OM interface tables.
• Worked extensively in Design Development of extension forms with Forms 10g, to enhance the functionality as per user's requirement.
• Worked on the Auto Invoice program. This program imported the invoices, debit memo, credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program.
• Worked on customization of custom.pll to open the extension forms, through Zoom button Standard gateway provided by oracle for extension forms.
• Involved in design of custom tables, views, multi-org views for the extensions functionality.
• Experienced in RDBMS in Client/Server environment involving design, development and testing of application software using Oracle 8i/9i/10g.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Registered various forms, reports, PL/SQL packages, Request Sets and Tables.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents.

Environment: Oracle Applications R12 HRMS,GL, AP, AR, OM, INV, PO, BOM , Oracle 11g, Forms 10g, Reports 10g, PL/SQL.