SUMMARY

• Oracle Certified with 13 years of experience as Oracle Applications Techno - Functional Consultant
• Extensive experience in Solution Design, Integration, Analysis, Development, Testing and post-production support for Oracle EBS Suite R11 & R12 version.
• Multiple full Life Cycle implementations, rollouts, upgrade and support projects from 11i to R12
• Experience with Oracle EBS Financials, Supply Chain (SCM) and Manufacturing modules.
• Expertise in Order to Cash (OTC) and Procure to Pay (P2P) business flows, have multiple Project experiences in working directly with business users to gather functional requirements and developing technical components
• Good Knowledge in Data Model of Order Management (OM), TCA Architecture, Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Warehouse Management (WMS) Modules, Financial Accounting Hub (FAH), OPM Inventory, WIP, BOM, Install Base, Service Contracts, HRMS, Benefits and Payroll Modules
• Technical Expertise in SQL, PL/SQL, Interfaces, Conversions, Extensions, Workflow, Unix Shell scripting, Discoverer 10g, Oracle Reports, Form Builder, Form Personalization, XMLP, XLIFF (XML Localization Interchange File Format), e-text Format Report Templates.
• Hands on experience in OAF Form Development and Customization.
• Hands on experience in building integrations using Web service (using SOAP, REST and JSON) and technologies like XML, XSD, XPATH, WSDL.
• Experience in XML transformation technologies like XQuery, XSLT etc.
• Good understanding in Oracle Fusion Middleware (SOA Suite 11g/12c, BPEL, ESB, BAM) technologies.
• Well versed with defect tracking tool such as HP Quality Center (QC), Clear Quest (CQ) and requirement tracking tool such as Project Portfolio Management (PPM) and migration tools like Kintana
• Worked with Oracle support to resolve seeded application issues. Created service requests (SRs) with oracle support and tracking them to closure.
• Experience in Onshore-Offshore Model Implementation and commitment to excellence proven by an outstanding career track
• Knowledge in OBIEE, ODI and Hyperion reporting tools

TECHNICAL SKILLS

Primary Skills: Oracle EBS Technical Development (RICEF Components), Interface (Inbound and Outbound), Conversions, Extensions, Forms, Form Personalization, Workflow builder, XML & Discoverer Reports

Packages (Incl ver): Oracle EBS 12.2.6, 12.1.3, 12.1.2, 11.5.10, 11.5.9

Modules: Oracle EBS Financials, Supply Chain (SCM) and Manufacturing Modules. Order Management (OM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), General Ledger (GL), SLA, Inventory (INV), OPM Inventory, Financial Accounting Hub (FAH), Fixed Assets (FA), Install Base (IB), Service Contracts, WIP, BOM, HRMS, Benefits, Payroll, Time and Attendance Modules

Operating Systems: Win 7, XP, 98, UNIX

Languages: Oracle SQL, PL/SQL, C, CPP, Java, UNIX Shell Scripting

Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, Forms, Reports, BI Publisher, Putty

Database: Oracle 12c, 10g, 9i, 8i

Configuration Tools: PPM Clear Case, Clear Quest, VSS, Kintana

Documentation: MD70, MD120, CV60, CV70

PROFESSIONAL EXPERIENCE

Confidential, Saint Petersburg FL

Oracle EBS Technical Consultant

Responsibilities:

• Involved in Implementation of Financial Accounting Hub (FAH) Module in R12 (12.2.6) version.
• Expertise in Financial Accounting Hub (FAH) and Sub-Ledger Accounting (XLA) data model.
• Developed Create Events Interface Integrating multiple source systems (for Computron and System JE), and Outbound Interfaces from FAH to Peoplesoft in accordance with functional designs.
• Developed integration from Hyperion DRM to EBS Chart of Accounts (COA) values, and Sync chart values mappings i.e. Legacy Chart Values and EBS Chart Values Mapping into FAH Custom Table.
• Developed Custom Create Accounting Wrapper program to handle Accounting errors and ensure Create Accounting does not complete in Error / Warning per business requirements.
• Developed Integrations using web services (using SOAP Protocol), Integrated Oracle EBS and PeopleSoft Combo edit rules (Integration Broker) to validate Cross-validation rules maintained in Peoplesoft, and sync CCID’s status as per combo edit rules maintained in PeopleSoft.
• Build custom OAF Page (COA Segment Mapping PG) to display and maintain the Refence Lookups for Chart Segment mappings.
• Involved in developing Web ADI programs for Manual Journals
• Involved in developing Custom Archive and Purge Program, which will Archive XLA and XXFAH Schema tables and Purge data from Standard and Custom Table.
• Involved in developing multiple BI Reports, Reconciliation Report, Suspense Report, Batch Control report, and FAH Rules Listing report.
• Work experience with Partition and Sub-Partition (List and Range Partition) custom tables
• Involved in end-to-end XLA module performance tuning, Including Create Accounting, Gather Schema Stats, CBO, Table Partitions, and Profiling SQL’s in the database.
• Work experience in Edition based (file system) environment, Release 12.2.6 on-wards is an editioned based version.
• Involved in developing Technical design documents, and Unit Test Scripts.
• Co-ordinate with offshore team for open clarifications/Issues raised by development team, propose & fix FD gaps identified during object reviews.

Environment: Oracle Applications R12.2.6 - Financial Accounting Hub (FAH), General Ledger (GL) and (SLA) Sub-Ledger Accounting, Oracle 11g, ODI, SQL, PL/SQL, UNIX Shell Scripting, TFS, M-Control, Red Gate (Schema Comparison Tool), Genesis, SOAP protocol, XML, XSD, XPATH, WSDL.

Confidential, Seattle WA

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• Involved in Implementation of a new fulfillment center for PRG2 (Prague, CZ), Design and development of Interfaces & XML reports within Oracle EBS - Including preparation of Technical design document, Installation document, and test scripts.
• AR Invoice Interface, AP Invoice Interface & Customer Interface (for Contra Cogs, Vendor Returns, and Return Vendor Returns Interface with VPS System Integration business processes)
• AR Invoice print reports (XML Reports for multiple batch sources/channels) and Modifying/Customization of BI print reports.
• Involved in supporting AR month end closure activities for global ledgers (8 Ledgers/OU’s) and working closely with AR super users across the Geographic’s by providing solutions for issues/defects that hamper the day-to-day work and effect period close process.
• Extensively worked on Account Receivables, Sub Ledger accounting & Create Accounting/Submit Accounting related issues.
• Increase the TPM (transactions per minute) for Auto-invoice import program from 3.5K to 10K, with the standard approach suggested by Oracle
• Customized OAF page (OrgTaxAttributePG.xml) to render and hide fields based on the ‘Show More Details’ button
• Worked on validation of extended View Object (VO) of Tax details to include additional field values in the Tax Organization region attributes.
• Involved in developing enhancement for AWS Revenue Recognition process, Confidential Custom solution that import AR invoices based on the Revenue Recognition flag.
• Supporting AR Module production defects by deploying data-fix for short term resolution and working with Dev team by providing the root-cause/resolutions for a long-term solution
• Involved in Customization for Oracle EBS Integrations with Confidential Systems (both upstream & downstream systems).
• Vendor Payable Systems (VPS), Vendor PO’s and Tax information integration with Oracle EBS.
• Vendor Central & S3 Uploads, Managing Vendor Invoice Print documents and Primary System for Vendor information
• Garter & Apian Applications, Custom Approval process integration with Oracle EBS.
• Involved in closing month close blocker (MCB) issues thus making month end closure process on-time with-in defined SLA’s.

Environment: Oracle Applications R12.1.3 - Account Receivables (AR), Account Payables (AP), Trading Community Architecture (TCA), General Ledger (GL) and Sub-Ledger Accounting, Oracle 11g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, OA Framework, JDeveloper, SVN Repository, Web EDI Integration, Workflow, Confidential Cloud (S3), Confidential Web Services (AWS), Confidential Vendor Processing System (VPS), Confidential Vendor Central System (VCS)

Confidential, Los Angeles CA

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• Working as Senior Oracle EBS Applications Developer for Oracle R12 deployment for new projects / enhancements and Production Support.
• Involved in Design & Development of Auto-reship project (Auto-reship is a Regular shipment of a product based on original order supported by automatic payment), Read JSON format data file and process Order Import by using Standard API’s, and Create Auto-reship Shipment based on the Original order shipment confirmation.
• Involved in developing the integration of PayPal payment method, Developed AR Receipts Interface, and Created Manual Receipt Batch for Open AR Invoices related to PayPal payment method type.
• Involved in development for Inbound Order Import Process (for multiple 3rd Party Systems, Sample Orders, and Win-back/Promotions Order Imports) using Oracle API’s and Interface tables.
• Developed Interface to update Customer Headers, Sites and Site Use Attributes (DFF) Columns and Standard Columns by using standard API’s for a specific Customer account which has 2000 plus active sites.
• Developed Interface in Inventory module using Standard APIs for Item Assignment update.
• Involved in development of Custom pll for Quick Sales Order Form and Customer Care Order Entry Form
• Developed Form Personalization’s in Order Management (OM) module to Enable / Disable Standard Fields, Push Buttons, and functionality to restrict users not to add a New Order Line in Quick Sales Order form for Order Source
• Involved in development of complex reports like Gross Sales Report, Tax Reports (1099 Pre-printed material) XML Report, and Supporting XML Bursting reports.
• Involved in developing PL/SQL Stored procedure programs Ex: Demantra prerequisite update scripts (Demand Class Code update), Adhoc Data load programs to custom tables using SQL Loader for reporting purpose, Update Incorrect customer address for eligible Open Orders, etc.
• Involved in development of UNIX and Java Concurrent Programs to handle the GPG & PGP file encryption process as part of PCI Compliance (One of the Effective way to handle customers credit card information, which stores in the external source data files)
• Developed multiple Oracle Alerts (Periodic Alerts) to report Interface errors to users, and to notify daily 3rd Party Order feed status.
• Involved in Supporting EDI Outbound Invoice (810) and Inbound Orders (850)
• Prepared change request documentation and unit test plans. Performed unit testing and system integration testing. Preparation of technical design document, Installation documents and test scripts

Environment: Oracle Applications R12.1.2 - Order Management (OM), Account Receivables (AR), General Ledger (GL), Inventory (INV), WMS, Oracle Alerts, XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, Custom pll, Silver pop, UTL FILE package, EDI Gateway, Java, JSON.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in developing and customization Payment process requests (PPR) for ACH (e-text), Check (RTF) and Positive pay (e-text), SEPA (XSLT) Template as per requirements.
• Involved in Complex Integrations (Up-stream and Down-Stream) with EBS, Integrating AP and AR Modules.
• Involved in development of AR Invoice Interface, AR Auto-lock Interface, Journal Import Interface, Bank Statements Inbound Interfaces as per business requirement (MD050).
• Involved in developing custom enhancements for Financial Accounting Hub (FAH) for legacy (3rd party systems) journal processing and events creation.
• Involved in supporting FAH module from legacy data processing to GL period close process and streamlining performance issues related to FAH data.
• Developed Integration using SOAP web-service to load daily currency rates from Bank.
• Developed common utility UNIX shell script to automate oracle job scheduling and file transfer process.
• Developed multiple reports in MLS formats using XLIFF (XML Localization Interchange File Formats).
• Developed/Customized multiple XML reports in General Ledger, Receivables and Payables Module according to the functional designs.
• Customized Standard AP Trail Balance report as per the business requirement.
• Customized Standard Summary VAT, Purchase VAT and Sales VAT Register Reports, Good understanding in Global VAT tax requirements.
• Involved in post-production support and development of Change Requests / Enhancements with high quality turn around.

Environment: Oracle Applications R12 - General Ledger (GL), Sub-Ledger Accounting (SLA), Account Payables (AP), Account Receivables (AR), XML Reports, Oracle 11g/10g, SQL, PL/SQL, Workflow Builder, SQL Loader, Unix Shell Scripting, SOAP services (using UTL HTTP protocol), e-text Template, XLIFF Templates.

Confidential, Pittsburgh PA

Lead Oracle Applications Technical Consultant

Responsibilities:

• Worked as a Senior System Analyst for Oracle R12.1.3 deployment for Purchasing (PO), Account Payables (AP), Enterprise Asset Management (eAM), Inventory (INV), HRMS & Payroll modules (for 3 different phases of the Project)
• Lead the design and development of Integration between Enterprise asset management (eAM) and Purchasing (PO) Modules
• Involved in development of complex RICEF objects in accordance with technical development standards.
• Involved in development of below Conversions and Interfaces,
• Purchase Requisitions Conversion.
• On-Hand Quantity Conversion
• Maintenance Route Conversion, data used to extract from US Steel legacy system called Passport and load Route Maintenance data to Oracle EBS.
• HR People data conversion for around 8K employees, Extract the data from Legacy source system called BIMS (Benefit Information Management System) and load the data to Oracle EBS.
• Employee Assignments data conversion for US Steel Active and Canadian Active Employees (8K Active Employees, 75K Retirees, CA Active 2K and CA Retiree of 15K records) data files to Oracle EBS.
• Developed Form Personalization/Customizations
• In the Move Order form, whenever user select an item from LOV, it will validate if the item is on Open Blanket agreement, and then display a custom message.
• Form to Default WO Title and Planner Code in the Task Requirements
• Disable OK button on Purchase Requisition form when it is launched and Enable the Action Menu to launch the route Information (Custom Form) and enter all the mandatory Information in the form and then Enable OK button to Process.
• Involved in customization of Putaway form, Form is used to view what needs to be put away and indicate where the goods are being putaway with the ability to process the movement from the form.
• Developed multiple XML reports from Scratch and Customized standard reports as per the business requirements
• Work Order Purchasing Traceability report - Report is used to track the material requirements for a single Work order and display the material Information linked to the Work Order, Move Order and Purchase Requisition
• Min Max Planning Report - Customized seeded report to include the demand and availability related to WIP Move Orders, Parameters and Output remains unchanged, Change is in the Calculation of Supply, Demand and Availability at the Item/Sub-inventory level.
• Putaway Report - Material Management will run the report to Identify Items that have been received and are in stage delivery sub-inventory
• Fixed Asset Ledger Report - Report contains fixed asset information which is used for Accounting and Tax Department.
• Development multiple enhancements & bug-fixes in OAF View Object extensions, Controller Object Extensions, and OAF Personalization’s as per the requirement.
• Customization of Standard Workflow (POAPPRV), whenever there is a change in promise date or quantity on a PO and Promise date is greater than need by date, the Original Move Order and Work Order will be updated and send a notification to the Requester/Planner
• Involved in customization of Standard Workflow (POSCHORD), Business Requirement is when the requestor associated to a PO with a pending change request should not receive a notification of the pending promise date change.
• Involved in supporting the new item request (NIR) approval process using Standard Workflow (ENGCHMGT), workflow will be invoked from Oracle New Item Request Page upon submission of an NIR. A notification is sent to the group listed in the order defined in the workflow (using standard functionality) to approve / reject / request more information
• Involved in developing the Extension to handle situation where there is a change in the requested date and/or in the quantity on a Move Order. Integration sub sequential documents - Move Order, Work Order, Purchase Requisition and/or Purchase Order will always be updated to reflect any changes in requested date and/or quantity
• Involved in fixing performance issues raised due to custom code, Fixed performance issues in UAT (User Acceptance Test Phase) and PT (Product Test Phase), and worked with oracle support team through Service Requests (SR’s) on seeded performance Issues
• Involved in Post Production Support, and timely resolution of incidents based on the estimate agreed date/ time and delivering Change Requests with high quality turn around.
• Involved in Assembly testing & Product testing phase to make sure custom solution has at most bug free, by testing all the possible test cases scenarios.
• Involved in end-to-end object reviews (Technical design, coding & UTP scripts) for new development, change request and Post-production defects (i.e. for all the code artifact’s which are eligible for Prod deployment)
• Co-ordinate with onshore/offshore team for open clarifications/Issues raised by development team, propose & fix FD gaps identified during object reviews.
• Identified areas of Improvements, suggest strategies and changes wherever applicable to work products, processes and development standards, in-order to mitigate gaps and thereby improving overall quality and efficiency of process.
• Identified most common errors in development team and conducted CAR (Casual Analysis Report) sessions, to educate the team on the Issues to make sure they are not repeating in next time
• Actively Involved in Pre-and Post-go-live activities, involved in go-live deployment activities for all the 3 phases in the project

Environment: Oracle Applications R12.1.3 - Enterprise Application Management (eAM), Purchasing (PO), Account Payables (AP), Order Management (OM), TCA Architecture, Account Receivables (AR), WIP, BOM, HRMS, Benefits and Payroll Modules, XML Reports, Oracle 11g/10g, SQL, PL/SQL, Forms, Workflow Builder, SQL Loader, Unix Shell Scripting, Form Personalization, Custom pll, UTL FILE Package, OBIEE, Informatica, VSS, ADM Methodology, HP Clear case, Clear Quest

Confidential

Senior Oracle Applications Technical Consultant

Responsibilities:

• Worked at Client location, involved in requirements gathering, Client discussions, Knowledge sharing and production support.
• Involved in the Interface scope of work and acted as key point of contact to offshore development team.
• Involved in developing complex objects in accordance with technical development standards and best practices.
• Involved in design and development of conversions
• Customer Conversion
• AR Invoice Conversion
• AR Receipts Conversion
• Involved in reviewing team deliverables i.e. Technical Design documents, build artifacts, Unit Test plan and Installation guide, and suggest the best practice methods for a quality deliverable.
• Involved in Functional clarification meeting and ensured the gaps are not trickled down to Functional design documents.
• Involved in designing the prototype, preparing MD 50 specification based on the BRD (business requirement document), MD 60 technical specification, Unit Test cases document, coding and Unit Testing.
• Work with DBA team and cross functional application teams for application change control and system performance Issues
• Involved in Post Production support
• Identify and Purpose best practice methods, Coding standards, Standard for documentations.
• Involve in daily and weekly meetings with onsite coordinator to discuss project status.
• Scheduled and participated in weekly client status call and updated with the project status.
• Timely resolution of incidents based on the estimate and agreed date/ time and delivering Objects with High Quality.
• Provide support for business-critical application problems and issues.
• Involved in deployment activities and supported for PT migrations and go-live migrations.

Environment: Oracle Applications R11.5.10 - Order Management (OM), Account Receivables (AR), TCA Architecture, BI/XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Form Personalization, Discoverer reports, AIM Methodology, Winscp tool

Confidential, Santa Monica, CA

Senior Oracle Applications Technical Consultant

Responsibilities:

• Involved in Interface & Extensions scope for the project
• Mentor the team, and ensure the work assigned to Interface team in delivered on time with quality turnaround.
• Involved in developing Inbound and Outbound Interfaces in Financial modules.
• Customer Conversion
• Receipt Confirmation Outbound Interface
• PO Acknowledge Inbound Interface
• Expected PO Inbound Interface
• Receipt Confirmation Inbound Interface
• Involved in all the dry runs and ensured deployment scripts are created in sequence by identifying the migration dependent artifacts.
• Involved in customization/modifying existing Oracle forms, Added Pay terms by removing Order Type column in the Custom Pick Release form.
• Preparation of technical design document, MD120 and test scripts
• Unit testing of the objects and support the onsite during Integration testing
• Involved in code and documentation review.
• Involved in Dry run and code deployment activities.
• Acted as Point of contact for the Tools used in the project.
• Involved in providing daily status and weekly status reports to onshore and offshore leadership.

Environment: Oracle Applications R11 - Purchasing (PO), Account Payables (AP), Order Management (OM), Account Receivables (AR), Inventory (INV) and WIP Modules, BI/XML Reports, Oracle 11g/10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Forms 10g, Form Personalization, Kintena, VSS

Confidential, Boston, MA

Oracle Applications Technical Consultant

Responsibilities:

• Worked at client location as end-user facing role, and Involved in developing Interfaces and Extractions in Payroll Module
• Time and Attendance Interface
• Corporate Financial Accounting Interface
• Store Time Attendance Extraction
• Outlook Soft Payroll Extraction
• Incorporated the Change Requests as per business requirement
• Involved in Post production support and fixed multiple Oracle Workflow related defects.
• Preparation of technical designing document and Test script document
• Project Point of contact for Citrix access tools

Environment: Oracle Applications R11 - HRMS, Time and Attendance Modules, Oracle Reports, Oracle 10g, SQL, PL/SQL, Oracle Alerts, SQL Loader, UNIX Shell Scripting, Citrix tools.

Confidential, Costa Mesa, CA

Oracle Applications Technical Consultant

Responsibilities:

• Involved in Fit Gap Analysis for entire scope of delivery
• Developed High Complex Discoverer 10g Reports, Including Drill-down, Detail, Summary format report
• Developed/Customized Financial Statement Generator (FSG) reports, Account Analysis reports using Oracle RDF reports.
• Involved in Customization of GL Trial Balance report.
• Journal Import: Developed a package for GL Interface that validates and imports journals to General Ledger.
• Developed SQL script to extract and delete un-posted journal data for a given set of book id and period name.
• Developed SQL script to generate reverse journal report for a given period.
• Analyzed General Ledger Major Book Report to debug the usage of “related document” column and based on the details developed a script to track the related AP invoice from GL Journals.
• Troubleshoot and resolved issues regarding accounting events balancing at the month-end processing.
• Customized general ledger trial balance, supplier sub ledger by account standard report as per the business requirements
• Involved in developing and Customization of Oracle Reports
• Timely resolution of incidents based on the estimate and agreed date/ time and delivering Objects with High Quality
• Preparation of technical design documents, unit test scripts and Installation documents.

Environment: Oracle Applications R11 General Ledger (GL), Purchasing (PO), Account Payables (AP), Discoverer Reports, Oracle BI/XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Clear Quest

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Design and Development Interface using BPEL Process Manager AP Invoice Inbound Interface
• Involved in development Interface using ESB PO Outbound Interface
• Involved in test development of File, FTP, Database, and Oracle Applications Adapters
• Involved in writing Stored Procedures (PL/SQL) to test the DB adapter
• Taken multiple sessions on BPEL and other SOA technology components in the organization.

Environment: SOA 10g (BPEL, ESB and BAM Components), Oracle Applications R11 - General Ledger(GL), Purchasing (PO), Account Payables (AP), Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, XML, XSD, XPATH, WSDL, UDDI, BPEL, BAM, ESB Components.

Confidential, San Jose, CA

Oracle Applications Technical Consultant

Responsibilities:

• Involved in developing Conversions and Extractions
• Customer Items & Cross reference Extraction
• Customer Items & Cross reference Conversion
• Involved in developing Install Base Extraction
• Involved in developing Install Base Conversion
• Involved in Developing multiple XML Reports as per client requirement
• Involved in updating/modifying the standard documents which was provided by client team.
• Helping and guiding junior resources in the team
• Reviewing peer’s technical designs and the code and suggest best practice methods where ever necessary and required. Preparation of technical design documents
• Involved in deployment activities during go-live period
• Involved in Knowledge transition and post-production support.

Environment: Oracle Applications R11 - Install Base (IB), Service Contracts, Order Management (OM), XML Reports, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Migration of HR Data Using Standard API’s
• Developed plug-in payroll formulas which calculate the custom requirement logic and re-used as the formula in SQL scripts and Discoverer reports.
• Customization of reports in RDF, and XML Publisher for Business Documents.
• Developed HRMS Letter Generation Reports (Templates)
• Developed Delimiter Report for Fixed Assets data (Convert into Excel Format)
• Involved in fixing Oracle (Custom) forms Issues in Purchasing Responsibility.
• Involved in feasible analysis for PO approval (POAPPRV) Standard workflow as per business requirement.
• Developed and Customization of new reports in Purchasing and Fixed Assets as per Client Requirement
• Responsible for moving code to the production.
• System Integration Testing(SIT)and Sanity checking
• Preparation of technical design documents, Unit test scripts and Installation documents.

Environment: Oracle Applications R11 - HRMS, Fixed Assets (FA), Purchasing (PO), RDF and XML Reports, Discoverer Reports, Oracle 9i/10g, SQL, PL/SQL, MS Tools, Oracle API’s

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Involved in developing of all the Stores Ledger Reports (Oracle reports) belonging to the three different Sites.
• Developed Invoice Reports (Pre-printed Invoice)
• Customized Purchase order (line locations) seeded form as per the customer requirement.
• Involved in Developing Various OPM Inventory Reports- REP Reports
• Customization and Developing of reports in Purchasing and Accounts Payables, Inventory and OPM Inventory as per Requirement.
• Developed SQL Script to extract comma separated file of applied receipts
• Developed PL/SQL script to release AP invoice holds when corresponding AR invoice is cleared.
• Customized standard Oracle Consolidated Billing Invoice Report with additional IND specific field changes and tax logic.
• Developed AR Transaction Interface which validates transaction information and loads the transaction into AR seeded tables.
• Developed PL/SQL Stored Procedure Executable Reports.

Environment: Oracle Applications R11- OPM Inventory (OPM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), Oracle Reports, Oracle 9i/10g, SQL, PL/SQL, Data Loader