SUMMARY

• Result - oriented expert, techno-functional Oracle EBS professional with 12+ years of rich experience, done #3 End to End successful fresh implementation, upgrade projects and done ‘3’ productions support projects, involved in gathering requirements, create design documents, development, customizing and implementation of Oracle Applications R12 and 11i Versions. Perform impact analysis for Oracle functionalities for the implementation.
• Experience in Setup and configuring Oracle eBS system (R11, R12, Cloud).
• Expert in Oracle Finance/SCM modules (AP, AR, GL, CM, PO, INV, iProc, OM, iSupplier, Supplier Scheduling, iExpense) also having good technical Exposure PLSQL, Form Personalization and GRC rules.
• Proficient in managing activities of Setup, Configure, Development, test and validate customization.
• Extensive experience in managing and executing the test life cycle and documentation.
• Expertise in RICE (Reports, Interfaces, Conversions, Extensions) Components.
• Develop solutions to leverage Oracle applications functionality based on the business requirement. Having expertise in Finance/SCM modules.
• Experience on Order to Cash, Record to Report and Procure to Pay cycles.
• Extensive experience in Oracle Configurations/setups for 11i, R12 E-Business Suite functional module setups profile options, flex-fields.
• Knowledge of PLSQL, backend database tables concerning All SCM and Finance modules.
• Extensively worked on Data Conversion, Migrations and Interface Programs (Outbound/Inbound).
• Worked with System Administrator and AOL modules for creating Concurrent Programs, Value sets, custom Menus and Responsibilities, Defining Descriptive Flex fields, Lookups and Custom Profile Options as per the requirements.
• Experience with Oracle’s development tools, including APIs, Open Interface, Business Events, Web ADI, OAF.
• Experience on Multi-Org and Multi-Currency implementation solutions.
• Strong abilities in authoring AIM documentation including Business Requirements (BR100), Conversion/mapping Documents (CV40), Functional Specs (MD50) and Technical Specs (MD70).
• Extensive experience in X Windows, UNIX shell scripts, PERL including a strong understanding of network programming and system programming in various UNIX flavors and Windows.
• Strong knowledge in forms Personalization and Customization.
• Worked extensively with development team members in resolving issues by creating Oracle SRs and obtaining one of the solutions using Oracle Support/METALINK
• Experienced in various stages of Project implementation. Involved in the complete SDLC and testing life cycle. Involved in Unit Testing, UAT, Performance Testing, Regression Testing and CRPs. Experienced in Production Support.
• Development of Technical Objects Packages, Functions, Procedures, Reports and Interfaces related to Financial Modules like Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Application Objects Library (AOL), iSupplier and System Administration.
• Experience on Setups related to Procure to Pay (P2P) and Order to Cash Management (O2C) Cycles.
• Extensively worked in Oracle back-end programming and Front-end development using tools like TOAD, PL/SQL, SQL*Plus, SQL*Loader, Oracle*Forms10g/6.0, Oracle*Reports 10g/6.0, XML Publisher.
• Experience in generating Standard, Discoverer6i/9i and XML publisher reports.
• Worked on Oracle Apps VCP practice (ASCP, APCC & Collection-Integration) for Rapid Planning, Collaborative planning.
• ASCP functional or technical knowledge - Understands both business advance planning processes and ASCP fundamentals to provide day-to-day support and multi-plant consulting for ASCP
• Responsible for Managing and coordinating test sessions like Conference Room Pilots (CRP) and User Acceptance Testing (UAT)

TECHNICAL SKILLS

Packages: E-Business Suite Oracle Applications Versions 11.5.3, 11.5.7, 11.5.8, 11.5.9, 11.5.10And R12.

ERP/Modules: Oracle Purchasing (PO), Oracle Order Management (ONT), Oracle Inventory (INV), Work in Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP), Costing, Shipping (WSH), Advance Pricing (QP), Oracle Receivables (AR), Oracle Payables (AP), General Ledger (GL), WMS, AMEiSupplier.

Processes: Order to Cash and Procure to Pay processes

Languages: SQL, PL/SQL, C, C++, HTML, Java

Development Tools: Oracle Forms 4.5/6i, Oracle Reports 4.5/6i, Discoverer 6, XML PublisherOracle Workflow 2.6.3

Database: Oracle 8i/9i/10g

Operating System: Windows, SUN Solaris 2.5/5.6, UNIX, Linux

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle EBS Techno - Functional Consultant

Responsibilities:

• Involved in Customization of various Financials Modules (GL, AP, AR, PO, INV and OM). Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized standard AR Aging Report, Journal Entries Report, Billing History Report, and Invoice History Report using XML/BI Publisher.
• Implemented financial modules: Quoting, Order Management, Inventory, Accounts Receivables, TCA Release 12 of Oracle e-Business Suite.
• Performed all the setups for OM, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules.
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop Shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters.
• ATO & PTO Models, ATP Checking, Availability & Reservation
• Worked on the setups of the TCA Module - defining parties, accounts, party sites and account sites, contacts, contract points, relationships, etc.
• Wrote Procedures, Triggers and Functions as per the business requirements, designing the integration process and registered them as Concurrent Programs.
• Worked on the setups of the TCA - Defined Parties, Accounts, Party Sites, Account Sites, Contacts, Contact Points, Relationships (Reciprocal and Non-Reciprocal)
• Worked on cleansing of the TCA customer data and enriching of the data using Trillium and USPS Integration.
• Developed Daily Program to Reset Planning Attribute to 'Not Planned' to reduce the Planning Load.
• Automation of Planning releases for low value Stock Items.
• Implementing Blanket Purchase agreements, Blanket Releases, Sourcing rules and Approved Supplier lists. once the planner releases planned order from Planning board, it should create blanket releases automatically.
• Developed Discoverer Reports for Requisitions and Work orders interface errors to improve traceability of the Planner.
• Implemented Statistical Forecasting for all Stock Items and covered under planning to Reduce Stock outs of Stock Items.
• Analyzing the parameters involved in cycle counting, physical inventory and setup of ABC classes for teams to aid in implementation of counting methodology.
• Developed Item Catalogs, Pegging Reports to reduce too much Time Spent on Master Data Management by Planners.
• Provided assessment of improvements for Advanced Supply Chain Planning (ASCP), Supply Chain Planning, Inventory Optimization, ASL and Sourcing rule setup.
• Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
• Implementation of Credit Management and Collection for Design, Development, Enhancements & Custom Solution, transitioning from Oracle Advanced collections and Credit Management to FIS GET PAID. This includes Data Conversion Strategy, Solution validations and modifications accordingly.
• Developed UNIX shell scripts for EFT’s and sftp to transfer the files to banks.
• Developed PL/SQL package to insert customer information using TCA API. Implemented Auto Lock Box process.
• Defined various setups for the Purchasing module starting from defining of Approval Groups & Position Hierarchies, Jobs, Purchasing Control Options, Financial options and Document type, Line Types, expense accounting Rules, Requisition Templates and period closing process.
• Created UAT (User acceptance Test) Scenarios, MD50, BR100 docs and Follow up with business from time to time to know their changing needs and let them know the feasibility of proposed solution.
• Managing internal team, implementation partner, vendors and responsible for and Functional support for smooth and effective operations of Purchasing and Inventory business process
• Experienced in System administrator responsibility, which contains customizing the menus, adding new concurrent requests, registering the custom applications etc.
• Worked extensively in extending of Oracle Workflow, OAF extension and XML Publisher reporting.
• Designed and Developed the interface program to load the Invoices from a legacy system into Oracle Payables using SQL*Loader, PL/SQL package and Payables Open Interface Import Concurrent program.
• Developed a Conversion program to Import Requisitions into Oracle Purchasing using SQL*Loader, PL/SQL package and the Requisition Import concurrent program.
• Developed SQL scripts to transfer data from the Legacy system into the staging tables.
• Developed PL/SQL packages to validate and load the data into the Interface table.
• Defined Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type.

Confidential, Boston, MA

Oracle EBS Techno - Functional Consultant

Responsibilities:

• Implemented BOTH pay to globally in Confidential (STT) for US and CAN OU’s.
• Closely coordination with AMEX on their requirement.
• Involved in CEMLI Design and development of financial modules (GL, AP, AR, PO, PNG) as per the custom needs.
• Integrate the web-service to SOAP tool.
• Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
• Worked on the setups of OM, TCA, Advance Pricing, Shipping, Credit and Collections, AR, AP, PO and INV modules
• Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• As a part of the implementation and support attended all meetings and decision making of data folder (Inbound/Outbound) creation for Conversions and interfaces.
• Wrote custom programs using API's to load the vendor and customer data into oracle from side system.
• Involved in all CEMLI validation meetings with implementers after UAT, made changes suggested by county and school functional users.
• Also helped in development of AR conversion process to Implementation (AST) team after UAT changes before go-live.
• Trained functional users to show how to run the concurrent programs and supported based on daily need.
• As a part of enhancement wrote custom packages and AME rules, workflows for interface SR's and wrote a logic for project & task split lines for PA.
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages.
• Implemented AP Invoice import through Payables Open Interface Import Program
• Assisting functional changes in AP/AR and to make it understand the oracle functionality to users and employees.
• Designed and developed Technical & unit testing documents for the CEMLI's worked on and supported daily based issues.
• Worked on Journal Interface, Disasters, and budget interface Programs in GL reviewed Journal Import Execution, corrected Journal Import Data and initiated posting.
• Developed fully customized reports in AP (Remittance advice, Check), AR (Invoice, Credit Memo, Aging Buckets reports (collector/account), Statement of Accounts-print Statement etc).
• Worked on Booked Order, transactional detail, and OM to AR tie-back reports using XML Publisher and developed Order import Interface Program.
• Worked on ADP GL Interface program to load the data into GL open interface and bank recon load interface programs to load the data into bank statement interface tables (CE).
• Developed Reports in Sales Online and used APIs to load customers into the AR module.
• Developed a standard import program in OM for standard and manual orders.
• Provided Technical Design for all the main OA pages developed for Total Compensation Statement
• Embedding OA Framework region in a notification
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages.
• Entered transactions like Regular Orders, Inter Company Invoicing, Regular invoicing, and Invoicing with Rules in Order Management (OM).
• Implemented AP Invoice import through Payables Open Interface Import Program

Environment: Oracle Applications R12.2.3 (AP, AR, GL, OM, INV, PO, iProcurement, iExpense), Oracle 11g, UNIX, Developer Suite10g, Workflow 2.6, XML Publisher, Discoverer 10g, SQL/ PL/SQL, SQL*Plus, TOAD.

Confidential, Boston, MA

Oracle Application Techno - Functional Analyst

Responsibilities:

• Developed and customized Financial Modules (AP, CM, GL, AR, PO, OM), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
• Developed PL/SQL package procedures and triggers, alerts and concurrent programs for SOAP/WSDL synchronous and asynchronous transactions.
• Authored AIM documentation as of when required, including Technical and Functional Specs.
• Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for E-business applications.
• Gathering Business Requirements and setting up Business Processes within the modules (AP, AR, PO, GL, INV). Developed Technical MD70 specification using Functional MD50 document for application customizations and enhancements.
• Created Planning Category for the planned items to streamline view in ASCP Workbench.
• Developed Planning Item for each Main Item for ASCP
• Involved in the upgrade of the system from 12.0.6 to 12.2.4.
• Performed technical analysis of as various patches required for the upgrade. Worked on upgrading various customizations as per the changes in the new release. Also involved in post upgrade support.
• Involved in downloading various types of data like Concurrent Programs, Value Sets, Request Sets, and Menus etc. from Development instance and then uploading them into Production instance using FNDLOAD.
• Created Staging tables to load legacy data, generated Control files and SQL*Loader scripts and registered them as concurrent program for data loading into the staging tables.
• Created PLSQL procedures for validating the data in the staging table before loading into interface tables. Incorporated multiple business specific validations in the PLSQL packages.
• Developed and customized existing forms and reports using Oracle Developer tools.
• Created discoverer reports that cover business requirements for analytical data on all modules (AR, AP, GL, INV, OM, iEXP, iSupplier, iProcurement)
• Worked on workflow customizations like PO Requisition Approval to customize approval list based on categories (facilities, fleet, and finance); PO Create Document to auto-create PO for catalog items after approval of requisition and customized ‘Create and Approve Purchase Order or Release’ process to prevent non- catalog items from PO Auto-creation process. Account Generator to generate charge account in iProcurement& Purchasing based on the mapping process.
• As a part of the support team, involved in supporting the Production instance of Oracle Application System, which also included troubleshooting functional and technical issues and providing solutions.
• Customized XML Publisher/BI Publisher reports like Printed Purchase Order report, Invoice’s report, Check Printing, Sales Order Acknowledgement and Bill of Lading and Packing Slip Reports.
• Designed and developed Order Import Program and Price List Import using Price List APIs, Purchase Order Import and Vendor Import.
• Supporting the production system and handling day-to-day issues.
• Responsible for writing data conversion routines (APIs, Open Interfaces) to load data information from legacy system to Oracle Apps.
• Developed UNIX scripts for formatting data received from the billing system for it to be mapped and interfaced into AR.
• Worked with Oracle support using the Service Request Process (creating SRs) to get resolutions on the bugs encountered in Oracle Applications system.
• Configure Oracle R12 FA, AR, AP AND EB-Tax, Receivables, Cash Management, Subledger Accounting, Advance Collections and Bill Presentment Architecture as part of product support team to include integration with Vertex and the TCA setups.
• Responsible for design and development of the BI Publisher Reports in various modules like Accounts Receivables, General Ledger, Property Manager, iExpense etc
• Worked on Auto Lockbox interface between Bank of America and Account Receivable module for automatically processing receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.
• Performing the setups for OM, WIP, ASCP, BOM, PO and INV modules.

Environment: Oracle Applications R12.2.5 (AP, AR, GL, OM, INV, PO, iProcurement), Oracle 11g, UNIX, Developer Suite10g, Workflow 2.6, XML Publisher, Discoverer 10g, SQL/ PL/SQL, SQL*Plus, TOAD.

Confidential, Dallas, TX

Oracle Applications Techno - Functional Consultant

Responsibilities:

• Worked on the staging R12 Apps environment to convert AP suppliers and AP Open Invoices from 11i to TCA Model and AP of R12.
• Automate approval rules in credit management.
• Automate approvals for iExpense
• Configuring the Punchout catalog involving the catalog setup, data mapping (Category & UOM mapping between supplier and iProc categories & UOM), and Opening ports on the firewall.
• Setting up of Manage Self Service, Work-flow Approval and AME Approval setups.
• Performed application support in single and multi-Org environment for Oracle Financials (Purchasing (PO), Accounts Payables (AP), and iExpense and iProcurement modules).
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Involved in reviewing the Objects. Migrated objects into Oracle Apps EBS R12.
• Customized menus, added new concurrent requests, registered the custom applications; value sets etc. using System Administrator Module.
• Developed Concurrent Programs to interface Customer data from Legacy Systems to AR.
• Designed and developed code to generate XML files for Out-bound extract and report generation using PLSQL and registered as Concurrent program.
• Involved in developing Integration Test Scripts and Documenting End-User Training Materials for project-Accounting and Fixed Assets and Performing Integration Test.
• Provided Post Implementation Support for Project-Accounting and Fixed Assets modules.
• Developed the Items Import program, which does all the necessary validations before populating interface tables of Inventory Module.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per the business requirements.
• Loading Catalogs into iProcurement. Actively participated in the implementation of Punch-out.
• Workflow customizations in Purchasing Module i.e. PO Requisition Approval and PO Approval.
• Customization of Order Management Workflow for Sales Order Approval.
• Worked on AR Transaction Distributions Report using Discoverer.
• Production deployment, Post-production support.
• Developed Various Reports in GL, AP and AR and customized them using XML Publisher.
• Developed XML/BI Publisher reports for standard purchase order with 2-Way 3-Way- 4-Way Matching Customer aging report.
• SOA Enable Interfaces using weblogic 10.3. System integrations originally developed as flat file, pipe delimited batch processes enabled as real time, SOAP endpoints.
• Configuring Oracle iSupplier Portal user interface
• Implementing supplier user registration for iSupplier
• Worked on the Email notification program to notify the users on recent customer creation failure in Accounts Receivables using Workflow Builder.
• Involved in writing the mapping and process Documents of Journal Import in GL and Invoice Interface in AP, for daily interfaces from the Legacy Mainframes System.
• Designed and developed an Interface between web-based Order Management systems to Oracle Order Management for creation of sales order which involved development of a UNIX shell script, which calls SQL Loader program to load data into custom staging tables and check for uniqueness of the files in UNIX directory to avoid duplicate data.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked on Meta link to raise and track Service Requests to Oracle.
• Rectified the errors in the log file and loaded the data into the interface tables using SQL*Loader.
• Prepared Deployment documents for moving custom developed reports and forms from the development instance to production after code testing.
• Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.

Environment: Oracle Applications 11.5.10.2 (GL, AR, AP, OM, INV, PO, iProcurement), Oracle 9i, UNIX, Discoverer 4i, XML Publisher, Workflow 2.6, SQL, PL/SQL, Developer 6i, SQL* Loader, SQL Developer.

Confidential, Las Vegas, NV

Oracle Applications Techno - Functional Consultant

Responsibilities:

• Worked on various financial modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Verified the OBIEE Dash boards, reports, sort, filters, and pivot tables.
• Development of reports using OBIEE (using Administration, Publisher. Answers and Presentation Services)
• Successfully activated the first PunchOut catalogs for HD stores
• Involved in customizing Oracle order submission process in iStore according to the business requirements.
• Configuring Oracle iSupplier Portal user interface, user's, responsibilities
• Troubleshooting of the Order Management (OM) and Inventory (INV) modules within Oracle Applications.
• Creating, reviewing and updating BR100, MD50, MD70 specifications by using AIM methodology.
• Support Design, Development and Implementation of Custom Forms, Reports and Interfaces.
• Interaction with business users and application expert for ongoing customization requirements.
• Monitoring and updating helpdesk tickets related to development and customization.
• Migrating critical RICE components and after testing and performance evaluation.
• Performance tuning for forms, reports and critical queries in production system.
• Created new End User Layer (EUL) for Oracle Discoverer version 10g. Created business areas and folders based on SQL codes and Views. Administered security of Oracle application users and Responsibilities through Discoverer Administrator.
• Developed simple to Complex worksheets, pivot reports using Discoverer Plus and shared the workbooks with users and responsibilities.
• Customized the existing form with descriptive flex fields.
• Customized standard GL reports like Journal Entry report, Account Analysis Report, Accounts Hierarchy Report as per business needs.
• Designed and developed Custom Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables and PL/SQL block for complete validation of data.
• Involved in design, development, testing, implementing, various reports using Oracle Discoverer and Oracle Reports.
• Complete technical evaluation and testing the Procure to Pay customizations.
• Generating huge volumes for Purchase Order using tools like data loader and SQL Loader.
• Debugging custom RICE components and troubleshooting the performance issues.
• Worked on Migration of process from servers to different upgraded servers.
• Used AOL & Sys Admin to register new reports, procedures, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Worked on Order Import APIs to load the orders from legacy system into OM.
• Customized workflow for customer credit check in order entry process of Oracle Order Management.
• Writing MD-070 documents for technical developments for Oracle Implementation.
• Creating and customizing forms to search property and customer records based on several condition criteria.
• Involved in setups of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Developed custom interface programs to Import Sales Orders for Multi-Org, Inter-Company Data Transaction. This transaction takes Purchase order from one org and imports to another org as Sales Order.
• Developed ad-hoc SQL queries to obtain specific information as per requirements.
• Detailed AIM documentation for all the setup and steps for Application Object Library.

Environment: Oracle Applications R12.0.4 (AR, OM, GL, AP, AOL, and PO), Oracle 10g, SUN SOLARIS, SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator, Developer 10g, Workflow Builder 2.6, Discoverer 10g, XML Publisher.

Confidential

Oracle Applications Techno - Functional Consultant

Responsibilities:

• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR, which is not provided by standard API's.
• Communication from legacy to Oracle applications were established through IBM MQ series using data contracts, which were signed off for both parties integrating the applications.
• Designed and developed the Reconciliation process for GL module.
• Performed Standard Functionality testing in AR, AP, GL, FA, Cash Management, iExpense, E-Business Tax and Sub Ledger Accounting
• Written an API for Converting the Invoice Payments (AP) and was convert all the Historical Invoice Payment History into Production.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Strong Oracle RICE development experience in all AP, AR, GL, PO, INV and OM Modules.
• Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
• Prepared Technical Specification (MD70) documents.
• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Customized Account Payables (AP) Accounting and Reconciliation reports like Payables Accounting Entries Report, Accounts Payable Trial Balance Report, Payables Account Analysis Report, Payables Accounting Entries Report, Payables Accounting Process Report, Period Close Exceptions Report, Posted Invoice Register, Posted Payment Register, and Unaccounted Transactions Report.
• Designed XML Templates, XML publisher reports. These are configured to generate output in PDF formats.
• Responsible for customizing Workflow for orders by adding custom holds customers and added payment terms for the customers.
• Performed system administration functions such as creation of users, Responsibilities and Menus and Functions.

Environment: Oracle Applications - AP, AR, GL, OM, PO, INV, Service Contracts, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, Java.

Confidential

Oracle Applications Techno - Functional Consultant

Responsibilities:

• Developed Item Interface to load the Items data from legacy system into Oracle Applications by running standard API.
• Performed PO conversion, which involved developing a custom wrapper to validate and load the PO data into purchasing interface tables and then populating the oracle base tables through standard PO interface program.
• Converted the data from legacy systems into 11i.Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of AP.
• Developed custom interface programs for validating and inserting the On-Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Involved in AR Open Invoices Interface by writing a custom wrapper to validate and load the data from staging tables into AR interface tables.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, updating shipping attributes, updating the Freight costs by calling an API.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Performed System Administrator tasks, which involved creation of Users, Responsibilities, and assigning Responsibilities to Users.
• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40 and CV 60.
• Defined payment terms, Locations, Invoice Approvals and setting up Bank Account information in Oracle Financials AP.
• Worked on workflow in creating messages and sending notifications in PO module.
• Customized various standard reports in PO, INV, OM, AP and created new reports as per business requirements, using Oracle reports.
• Developed XML Reports in various modules based on existing Oracle reports.
• Created and extended various AMs, VOs and EOs as per the requirement.
• Involved in understanding the functionality flow of complete life cycle of Order to Cash to the users, which includes defining and setting various objects pertaining to the modules.

Environment: Oracle Applications 11i (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, Workflow 2.6.3, Discoverer6i.

Confidential

Oracle Developer

Responsibilities:

• Analysis of defects logged by client, worked on debugging the problem.
• Preparing IID and detailed investigation documents for issues logged.
• Code development, impact analysis of fix, unit test case preparation and unit testing.
• Handle the release management for the project.
• Involved in support activities like data configurations, data patch, etc.
• Worked on preparing business understanding documents and FRS for new enhancements.
• Actively participated in development of major enhancements like new line of business, implementing new state for existing line of business.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements.
• Created and/or modified SQL stored procedures whenever required for change requests/enhancements
• Conducted presentations for review.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization

Environment: Oracle 10g, Oracle application server, SQL Developer, Toad, Unix/Windows XP, Agile