SUMMARY

• Over 10+ years of experience in teh 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 teh GAPs also dealing with Business Users on Training and Testing of teh 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 noledge 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 noledge in Oracle Master Data Management (MDM) (Product Data Hub (PDH) and Customer data hub (CDH))
• Worked as an Onsite Coordinator for teh 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 teh integration between teh distribution and finance modules.
• Good understanding of financial applications, processes and supported AR Invoices.
• Proficient in functional flow of Procure to Pay (P2P) cycles and noledge 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 noledge in JD Edward CNC Admin (System administration, Creating/managing environments and path codes, Applying ESUs/ASUs/ Updates and Service Pack upgrades, Manage Enterprise One 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, LA

Responsibilities:

• In dis project, teh 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 teh requirements provided by teh business/end users, Coding and reviews, and issues resolution.
• Primarily responsible for all organizational needs that did not fit within one of teh primary functions of teh 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 teh money received from teh customers.
• Implemented changes for GECARS outbound interface program to send teh extract of all teh 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 teh 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 teh new program to expand teh tax rate in varying teh decimal places that impact teh 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 teh 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 teh 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 teh 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 teh 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 teh 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 teh issues and also Test scripts design, Execution and review like UTS, UAT and STS using HP QC.
• Analyze and work for teh 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 teh solution to teh critical bugs in teh 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 teh Standard Receipt Batch Form in Accounting Receivables.
• Setup teh Write-Off limits in Account Receivables.
• Fixing teh Over invoicing issues in Oracle Projects and Grant Accounting system.
• Fixing teh 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 teh RXi report in R12.1.3 for teh AR Unapplied and Unresolved Receipts Register.
• Developed BI/XML Publisher reports in R12.1.3.
• Customized teh forms using teh 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) teh purpose of teh 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 teh OAF page to submit teh 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 teh integrations pertaining to teh 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 teh team before giving to functional or user acceptance testing.
• To develop custom components like forms, reports and interfaces Workflow customizations as per teh 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 teh 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 teh Over invoicing issues in Oracle Projects and Grant Accounting system.
• Fixing teh 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 teh OAF Forms for Attachment Functionality, where user can attach Receipts for iExpense at line level.
• Customized teh RXi report in R12.1.3 for teh 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 teh feasibility of teh 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 teh ADF UI developed using ADF faces components.
• Prepared and executed teh 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 teh team before giving to functional or user acceptance testing.
• Participate in Integrated and Independent Release schedule and publish teh 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 teh same with respective stakeholders for approval.
• Publish teh QA/UAT Timelines and follow up on teh environment readiness.
• Mapping Requirements to test cases upload teh same in Quality Center.
• Daily status report on QA/UAT will be shared to all teh stakeholders by coordinating with Functional and Automation QA teams.
• Follow up on defects resolution with teh development/support teams.
• Leading teh development of MDM standards and processes, and ensure proper SLAs are met.
• Escalate, if teh defects resolutions are taking more TEMPthan SLA's defined in Test Plan.
• Perform Health Checks on teh environments, twice a week and resolve any environment related issues/defects.
• Maintained Known Error Data Base and published teh same to respective Stakeholders.
• Provided QA Signoff, share teh lessons learnt for each project signed off.

Environment: Oracle e-Business Suite 12.1.3, Oracle Data base 11g, Sun Solaris PlatformSpecial 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, 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 teh 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 teh PO interface tables and called teh Seeded import programs to populate teh 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 teh 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 ADF Bindings 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 teh 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 teh main setup steps, definitions and implementation issues.
• Configured teh Test Instance as per teh setup document.
• Prepared teh Functional Document required for teh business - Future Process module and Mapping design.
• Implemented teh Access control for teh users based on teh responsibility.
• Involved in CRP and UAT. Given training to End Users.
• Implemented Financial Modules in TEST, DEV Instances.
• Testing of setups was done in teh above instances.
• Authored BR100, TE040 and MD050 documents as per teh requirement.
• Providing teh user with relevant Test Scripts to test teh instances and halping 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 teh legacy to teh application.
• Done system integration testing with teh sub-ledgers to teh 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.