PROFESSIONAL SUMMARY:

• Over 8+ years of experience in the IT industry as Oracle Apps Technical & Functional Consultant, mainly supporting and implementing Oracle ERP systems primarily using, PL/SQL, Oracle Forms and Reports, XML publisher and Oracle Applications.
• Involved in end - to-end cycle of project development using Aim Methodologies.
• Authored Functional specification Documents (MD50), Business Requirement Documents (BRDs), GAP Analysis, Solutions for the GAPs also dealing with Business Users on Training and Testing of the application.
• Strong experience in financial suite including General Ledger (GL), Account Receivables (AR), Account Payables (AP), Sub Ledger Accounting (SLA) and Order Management (OM).
• Good experience in creating Concurrent programs, forms, functions, Menus, Custom Responsibilities, Profile Options, Request Groups, Maintaining Users and customizing Key&Descriptive Flex fields.
• Created conversion programs in Supplier, Cash Management and Purchase Orders to migrate data from EBS 11.5.0 to EBS 12.1.3 using data links.
• Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
• Technically proficient in RICE (Reports, Interfaces, Conversions, and Extensions) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in upgrading to Oracle Apps 11.
• Customizing financial reports, such as income statements and balance sheets, based upon data in GL using FSG (Financial Statement Generator).
• Good understanding and working knowledge on ADOP and R12.1.3 coding standards.
• Good understanding of new R12.1.3 functionalities, like SLA (Sub Ledger Accounting), new Payment features, Ledger sets, TCA (Trading Community Architecture), MOAC (Multi Org Access Control).
• Extensive working knowledge in Oracle Master Data Management (MDM) (Product Data Hub (PDH) and Customer data hub (CDH))
• Worked as an Onsite Coordinator for the offshore Team, have been SPOC for ERP engagement.
• Expertise in Inventory, Purchasing, Order Management, Shipping, Advanced pricing and procurement modules with a very good understanding of the integration between the distribution and finance modules.
• Good understanding of financial applications, processes and supportedAR Invoices.
• Proficient in functional flow of Procure to Pay (P2P) cycles and knowledge in Order to Cash (O2C).
• Sound functional experience in Warehouse Management System (WMS), Supply Chain Management (SCM) including Order Management (OM), Shipping (WSH) and Inventory (INV), Oracle Applications Financials (AP, AR & GL), and self-service modules (iExpense, iProcurement, iSupplier).
• Expertise in SCM domain and laying out Blue prints for complex EBS solutions.
• Sound knowledge in JDEdward CNC Admin (System administration, Creating/managing environments and path codes, Applying ESUs/ASUs/ Updates and Service Pack upgrades, Manage EnterpriseOne Object Management Workbench (OMW), Object Configuration Management (OCM) and package builds/deployments, QSOFT and Allout security implementation/management, Server manager management), Technical (Report/Form design, retrofitting, Auto faxing, Jeform/Docpath designer)
• Work closely with sales management, legal and sales operations to ensure proper compliance with revenue recognition rules and guidelines.
• Review customer contracts and purchase orders to identify potential revenue recognition issues and ensure proper revenue treatment.
• Experience in using XML Publisher for reports generation.
• Created ADF Pages with Master Detail Tables, Master table Detail Form and Tree Tables.
• Expert in SQL, PL/SQL, Developer 10g (Forms 6i/9i/10g, Reports 6i/9i/10g), Workflow Builder 2.6, Shell Scripting etc.
• Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.
• Proficient in writing and tuning complex SQL statements.
• Knowledgeable in using Oracle utilities FNDLOAD.
• Attended Project Status Meetings, Pipeline Meetings, Code reviews and Inspection reviews.
• Excellent analytical, troubleshooting, communication and presentation skills.
• Excellent written and verbal communication skills, ability to perform under strict deadlines and pressure.

PROFESSIONAL EXPERIENCE:

Sr. Oracle Apps Techno Functional Consultant

Confidential, New Orleans, LA

Responsibilities:

• In this project, the client is implementing OM, INV, PO, AP, AR, GL and Channel Revenue Management modules of oracle to streamline their business operations of distribution & transportation.
• Contributed in Implementing, Enhancing & Support for GE Energy - GAMS, Enhancements, Rollouts & Support for GEHC GECARS and GEHC - GBS projects using oracle SQL and PLSQL
• Contributed in Implementations, Enhancements and Rollout activities for different organizations, code Migration activities from one database to another database by Analyzing of the requirements provided by the business/end users, Coding and reviews, and issues resolution.
• Primarily responsible for all organizational needs that did not fit within one of the primary functions of the organization and Worked on Rollouts for multiple entities supporting existing functionality as well as implemented new changes.
• Accounts Receivable (AR) module in GLPROD is used for creating customer invoices, applying receipts for the money received from the customers.
• Implemented changes for GECARS outbound interface program to send the extract of all the open invoices for external customers and new external customer locations from GLPROD to GECARS (GE Core Accounts Receivable System), for several entities on daily basis.
• Constantly monitor and report on progress and issues of the project to all stakeholders and provided troubleshooting, primary support for day-to-day Production Support requirements and involved in month end, Quarter end, Yearend Period Closures activities.
• Created the new program to expand the tax rate in varying the decimal places that impact the EPRO and Oracle SCM.
• Designed, documented and developed staging tables, Conversion routines for converting Custom Object like Legacy Customer Mapping, Customer Segmentation and PO Price Details from legacy system (11i) to Oracle applications R12.1.3.
• Responsible for developing, enforcing, and training of the Oracle iProcurement Requisition application for procuring all indirect purchases
• Identify and upload approved product and service catalogs into iProcurement
• Create Blanket Purchase Agreements in iProcurement
• Ensures compliance of the Oracle iProcurement application
• Assists suppliers on purchase order issue resolution and new supplier setups
• Responsible for aged open Oracle iProcurement Purchase order resolution and closures and reducing invoice on holds over 30 days past due
• Developed Technical Documents (MD70) for various RICE objects as per RICE (Reports, Interfaces, Conversions, Extensions, Forms and Workflow) components design
• Bug Fixing and providing Support to RICE components.
• Experience in Developing API from ADF BC using Stored Procedures to update EBS Suite, Tandem
• Worked on multiple BI reports to achieve client requirement, developed a Custom XML Reports in Order Management (OM), Purchasing (PO), Payables (AP) and Inventory (INV), Fixed Assets (FA), TCA.
• Interaction, co-ordination and support various application teams which consume the MDM CR services.
• Developed PL/SQL Procedures for Customer interface using TCA in (R12.1.3) Accounts Receivables according to Client Requirements.
• Customized existing complex Forms according to the new enhancement requests from Business.
• Training and guidance to ELTP's On Process and Technical Knowledge.
• Turbine Status tracking OAF Page and Developed customer discount OAF Page.
• Preparing MD70 Technical documents for the CR's (change requests) received and maintains coding standards while development conferring to GE standards.
• Preparing TE20, supporting documents, and conducting Technical Review & Code Walk through for fixing the issues and also Test scripts design, Execution and review like UTS, UAT and STS using HP QC.
• Analyze and work for the resolution of technical issues related to financial application modules.
• Involved in outbound activities - Invoices/Customers extraction and validations.
• Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.

Environment: Oracle Applications EBS 11i, R12.1.3, TOAD, Oracle Reports10g, UNIX, PL/SQL Developer, Order to Cash (O2C), Procure to Pay(P2P), Enhancements, Support, BI/XML Publisher, Bursting, Forms, OAF, Version Control, QC tool, MD70, Performance Tuning, Test Cases preparation, RCA, HP Quality Center, WINSCP, MS-PowerPoint, Visio, SQL*PLUS, SQL*Loader, UTL FILE, Shell Script, Error-Handling, UNIX.

Sr. Oracle Apps Techno Functional Consultant

Confidential, Charlotte, NC

Responsibilities:

• Worked in Financials GL, AR, AP, GMS, PA, PO, INV &iexpenses.
• Providing the solution to the critical bugs in the Project Accounting and Grant Accounting
• Experienced in dealing with concepts of Revenue Management and Revenue Recognition like, COGS, Earned Revenue, Unearned revenue and Revenue adjustments
• Involved in up-gradation of applications from 11i to R12.1.3
• Customized the Standard Receipt Batch Form in Accounting Receivables.
• Setup the Write-Off limits in Account Receivables.
• Fixing the Over invoicing issues in Oracle Projects and Grant Accounting system.
• Fixing the Funding summary mismatch issues in Oracle Grants
• Created Revenue Source Report in General Ledger using XML Publisher
• Setup AR Transaction types, Payment terms, Auto Lockbox, Automatic receipts to test receipts workbench
• Customized the RXi report in R12.1.3 for the AR Unapplied and Unresolved Receipts Register.
• Developed BI/XML Publisher reports in R12.1.3.
• Customized the forms using the custom.pll and personalization.
• Integrate ADF applications with SOA web services by generating proxy stubs and Web Service Data controls.
• Creation of new application (e-credit card application -Custom OAF pages, Workflow Development - AP interface) the purpose of the project is to create an application (OAF train pages and total of 8OAF pages) using which employees can create credit card based purchase request and submit for approval.
• Creation of Hold Source Release Page: - Calling plsql packages from the OAF page to submit the concurrent request.
• Responsible for developing Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Optimize performance and tune inefficient SQL code/queries and Reports.
• Experience in Developing API from ADF BC using Stored Procedures to update EBS Suite.
• Designed and handled all the integrations pertaining to the MDM modules
• Responsible for course material development, job aids, training guides, UPK simulations, and other supporting materials to assist users with application, business process and policies
• Conducting requirements walk through to understand requirements properly and for getting required clarifications.
• Preparing solution design documents based on system requirement documents.
• Preparing technical design document based on system design documents.
• To ensure quality deliverables will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.
• To develop custom components like forms, reports and interfaces Workflow customizations as per the System Requirement Document and System Design Documents.

Environment: Oracle e-Business Suite 11.5.10, Oracle Data base 10g, Sun Solaris Platform

Special Software: Oracle Apps 11i, PL/SQL Developer, Toad, Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client,, MKS Integrity.

Sr. Oracle Apps Techno Functional Consultant

Confidential, Englewood, CO

Responsibilities:

• Design and develop RD020, MD050 and BR100 in SCM instance based on the new solution going forward.
• Involved in Manufacturing and SCM track enhancements, developments and issues mainly dealing with modules PTP, OM, INV, Property Manager, Advanced Pricing, BOM, WIP, Planning and Quality.
• Worked with Business Systems Analysts/Designers to identify and research new functionality required to meet business users' needs.
• Fixing the Over invoicing issues in Oracle Projects and Grant Accounting system.
• Fixing the Funding summary mismatch issues in Oracle Grants.
• Setup AR Transaction types, Payment terms, Auto Lockbox, Automatic receipts to test receipts workbench.
• Setting up banks, bank branches and bank accounts.
• Have personalized the OAF Forms for Attachment Functionality, where user can attach Receipts for iExpense at line level.
• Customized the RXi report in R12.1.3 for the AR Unapplied and Unresolved Receipts Register.
• Developed BI/XML Publisher reports in R12.1.3.
• Creating Oracle Fusion BI Reports and Analytics
• Build Custom Security to Fusion, which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• To analyze Business Requirement, provide solution using Oracle Apps E-Business Suite Checking the feasibility of the requirement, and prepare System requirement document (SRD).
• Developed customization of OTS Supplier Outbound Interface for SOA Integration Projects from ERP.
• Involved in Customizations, Enhancements, Modifications, Localizations of the ADF UI developed using ADF faces components.
• Prepared and executed the test scripts and test scenarios on R12 Oracle SCM and MFG modules.
• Troubleshooting of problems related to delivered Oracle E-Business solutions and interaction with business users. Provided techno-functional solution as needed.
• Conducting requirements walk through to understand requirements properly and for getting required clarifications. Preparing solution design documents based on system requirement documents.
• Preparing technical design document based on system design documents.
• To ensure quality deliverables will review design/code through walkthroughs within the team before giving to functional or user acceptance testing.
• Participate in Integrated and Independent Release schedule and publish the Release Calendar by suggesting environments to use for SIT/QA/UAT.
• Participate in Requirement analysis meetings and get a clarification on testing needs from QA and UAT.
• Provide QA Estimates including Functional and Automation Scope.
• Prepare Test Plan/Strategy and share the same with respective stakeholders for approval.
• Publish the QA/UAT Timelines and follow up on the environment readiness.
• Mapping Requirements to test cases upload the same in Quality Center.
• Daily status report on QA/UAT will be shared to all the stakeholders by coordinating with Functional and Automation QA teams.
• Follow up on defects resolution with the development/support teams.
• Leading the development of MDM standards and processes, and ensure proper SLAs are met.
• Escalate, if the defects resolutions are taking more than SLA's defined in Test Plan.
• Perform Health Checks on the environments, twice a week and resolve any environment related issues/defects.
• Maintained Known Error Data Base and published the same to respective Stakeholders.
• Provided QA Signoff, share the lessons learnt for each project signed off.

Environment: Oracle e-Business Suite 12.1.3, Oracle Data base 11g, Sun Solaris Platform,

Special Software: Oracle Apps R12.1.3, PL/SQL Developer, Toad, Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SSH client, MKS Integrity.

Oracle Apps Technical Consultant

Confidential, Plano, TX

Responsibilities:

• Migrated GL and AP custom interfaces and reports from 11i to R12.1.3.
• Primarily responsible for involving in Requirement Gathering, Gap analysis, Solution Design, Configuration ownership, which involves Oracle SCM Modules -Customer Master, Order Management, Return Orders
• Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger).
• Independently handle the deployment and support activities on Finance and SCM modules.
• Imported Legacy Journals data into GL using Journal import interface.
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Worked on R12 implementation and upgrades in oracle SCM and Manufacturing modules and on RICEF components.
• Support for Manufacturing & supply chain issues (Modules Includes BOM, ECO, Kanban Cards, WIP, MRP, costing, quality, PO, INV, OM, ASCP Module), Handling TARs with Oracle Support.
• Implementing enhancements like Outside Processing, Internal orders, advanced supply chain Planning, Order to cash flow, Procure to flow, demand to build flows,
• Created requisition to procure goods and service with supplier information, delivery instructions, multiple accounting distributions, and notes to buyers, approvers, and receivers.
• Created standard purchase order, BPA and blanket releases.
• Developed various reports as of the user specifications using XML/BI Publisher.
• Creating ADF task flows and regions and importing them in Webcenter Portal Application.
• • Integrating ADF model and ADF UI through ADFBindings layer.
• Conversant with both offshore and onsite development models.
• Involved in post-production support.
• Created UNIX shell scripts to automate interface programs on daily basis.
• Period close and production support.
• Year-End activities for General Ledger and provide support during realignment.

Environment: Oracle e-Business Suite 12.1.3, Oracle Database 11g, PL/SQL, Toad, Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, UNIX Shell Scripts.

Oracle Functional Consultant

Confidential

Responsibilities:

• Worked on the project by using AIM methodology.
• Involved in End-to-End implementation Life Cycle of Oracle Financial modules.
• Analyzed client's current business events and process based on client discussions.
• Implemented Security rules, Cross validation rules and values for Value sets.
• Configured Financial Options and Payable Options.
• Defined Payment terms, Distribution set Internal Bank account and Supplier Bank Account.
• Defined Corporate books, fixed assets categories, assets keys etc.
• Documented the main setup steps, definitions and implementation issues.
• Configured the Test Instance as per the setup document.
• Prepared the Functional Document required for the business - Future Process module and Mapping design.
• Implemented the Access control for the users based on the responsibility.
• Involved in CRP and UAT. Given training to End Users.
• Implemented Financial Modules in TEST, DEV Instances.
• Testing of setups was done in the above instances.
• Authored BR100, TE040 and MD050 documents as per the requirement.
• Providing the user with relevant Test Scripts to test the instances and helping them on functional issues.
• Implemented Financial Modules in PRE PROD and PROD instances and handing over of PROD instance to users.
• Uploaded supplier & customer details from the legacy to the application.
• Done system integration testing with the sub-ledgers to the general ledger.

Environment: Oracle Application 11.5.8/11.5.10.2 (GL, AP, AR, CM & FA), AME, AIM Documentation, Windows XP, TOAD, Rational Clear Case, Mercury Quality Center.