SUMMARY

• Oracle specialist with 12+ years experience in Sr.Oracle EBS Financial Consultant in analysis, design, development, implementation and upgrade of using Oracle Apps R12,11i
• Oracle project delivery for clients such as Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Airline Industry, Sun Micro Systems, Su - kam, Confidential a Senior Oracle EBS consultant
• Extensive Functional and Technical expertise in Oracle Applications R12/11i in GL, AR, AP, PO, SLA, CM, FA, iExpenses, iReceivables, OM, INV and Property Manager modules in Multi-Org environment
• Hands-on involvement in business requirement collection, GAP analysis, process mapping, solution design, configuration, setups, workarounds and user training
• Delivered functional specifications for the new solution integration as a SME for Oracle EBS
• Conducted interactive session with key business stake holders while consulting on business processes and policies
• Extensive Industry Experience in implementing and testing Order-to-Cash (O2C) and Procure-to-Pay (P2P) Business Process flow
• Expertise in preparation of AIM Methodology Documents like RD20, BP80, BR100, MD50, MD70, TE40, CV40 and CV60
• Solid understanding of As-Is documentation and Business Process Mapping
• Ability to provide functional specifications for customizations and developments
• Participated in CRP/SIT/UAT problem solving sessions with essential team members
• Expertise in Design, Development and Customization of RICEW (Reports, Interface, Data Conversions and Extensions/Customization) and Discoverer using tools like PL/SQL, SQL, Oracle Forms 10g/6i, Oracle Reports 10g/6i, SQL Loader and XML/BI Publisher
• Experience engaging Oracle Support(TAR) to research and resolve issues
• Excellent analytical, problem solving, communication and interpersonal skills with the ability to interact with individuals and teams at all levels
• Capable of working in a fast paced, dynamic, team-oriented environment
• Clear written, oral presentation of ideas, proposals and concepts.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer

TECHNICAL SKILLS

Oracle EBS: Oracle Applications R12 and 11i

ERP Modules: GL, AR, AP, FA, CM, iReceivables, iExpenses, OM, INV, PO and Property Manager

Languages / ERP: SQL, PLSQL, Java, XML, HTML, Linux

Tools: TOAD, PUTTY, Win SCP, FTP, SVN, SQL * Loader, Data Loader, XML Publisher, Web ADI and discoverer, Oracle Forms and Reports 6i and 10g, OAF, Workflow and GL Wand

Database / RDBMS: Oracle 8i, 9i,10g,11g, 12c

Version/Testing control tools: SVN

PROFESSIONAL EXPERIENCE

Sr.Oracle EBS Finacial Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Analyzed, designed and documented GL, AP, CM, FA and SLA modules
• Documented BR100, MD50 and configured applications
• Closely worked and coordinated with the technical teams to deliver the solutions as per the functional designs and customizations
• Demonstrated solid problem-solving ability with unique combination of strong technical and functional skills and provided fast, efficient and accurate services
• Managed team work from production support to implementation conversion activities and functional design on emerged business-needed enhancements (configuration or customizations)
• Played instrumental role as Functional Lead in multiple multi-phased R12 projects successfully implemented Oracle Financials
• Trained key functional users through multiple training sessions on all financial modules in both corporate office and international locations such as US, Mexico, Trinidad and Canada
• Documented Business process JOB Aids
• Presented solid and unique problem-solving ability of fulfilling client's large complicated business requirements by utilizing both functional and technical tools/skills

Environment: Oracle Apps R12.2.2, GL, AR, FA, AP, SLA, AOL, Sysadmin, Oracle 11g, SQL Developer, SQL/PLSQL

Oracle EBS Consultant

Confidential, New York

Responsibilities:

• Responsible as a Oracle Consultant for Receivables (AR) and General Ledger(GL)
• Participated in CRP/SIT/UAT problem solving sessions with essential team members
• Coordinated with technical consultants and Oracle support team
• Setup and configured applications to support client requirements
• Involved in preparation MD050 (functional Design) document
• Collect requirement for customization and provide inputs to technical team
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components
• Involved in Registration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Coordinated with end users at all stages of implementation - CRPs, UAT, Go-Live, Support
• Provide training and documentation to Oracle-ERP end users
• Plan, develop and implement new Oracle-ERP related projects for improved, future system operation and enhancement.
• Experience engaging Oracle Support to research and resolve issues

Environment: Oracle Apps R12.1.3, GL, AR, SLA, AOL, Sysadmin, Oracle 11g, SQL/PLSQL, Toad

Sr. consultant

Confidential, Dearborn, MI

Responsibilities:

• Reviewed and approved any configuration change documentation for Accounting Receivables (AR) and General Ledger (GL)
• Interacted with clients and end-users to resolve issues.
• Coordinated with developers to upload master data and open transactions
• Integration between Oracle ERP and third party/custom solutions
• Develop a Program for theAuto Invoice Interfaceto import Customer Invoices, Credit & Debit Memos in ReceivablesAR
• Designed and developedPayables InterfaceImport Programto load invoices from the legacy system into the Oracle Payables Base Tables
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40)
• Invoices are imported from the Excel sheets to the Oracle Database usingSQL *Loader
• Generated Order submission summary and Detail reports by email Report usingBI Publisher
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle R12 Application extensions
• Provide training and documentation to Oracle-ERP end users
• Experience engaging Oracle Support to research and resolve issues

Environment: Oracle Apps R12, AR, OM, AOL, Sysadmin, Linux, Data Loader, Oracle 11g, SQL, PLSQL

Sr. Oracle consultant

Confidential

Responsibilities:

• Reviewed and approved any configuration change documentation for General Ledger (GL), Cash Management (CM), Accounting Receivables (AR) and Accounting Payables (AP).
• Implementation of Oracle Property Manager including setup of Lease, space assignment, define Properties, Payment approvals, Export payments, payment options, payment terms, distribution set, payment format and banks
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle R12 Application extensions
• Establish data conversion routines and executed scripts to convertGL, APandFAdata from legacy systems
• Involved in code review, code migration and code testing
• Involved in preparation of various documents likeMD050, MD070(functional & Technical Design) documents.
• Coordinated with end users at all stages of implementation - CRPs, UAT, Go-Live, Support
• Provide training and documentation to Oracle-ERP end users
• Plan, develop and implement new Oracle-ERP related projects for improved, future system operation and enhancement.
• Extensive experience engaging Oracle Support to research and resolve issues

Environment: Oracle Apps R12, AR, OM, AOL, Sysadmin, Linux, TOAD, Data Loader. Oracle 9i, 10g, PL/SQL, Oracle Forms 10g, Reports 10g, Discoverer, MS-VSS (for source code control), Oracle BI/XML Publisher, TOAD, Webservices, API's, JDeveloper, Integrations to 3rd party applications

ORACLE Techno-functional Consultant

Confidential

Responsibilities:

• Technical Consultant to implement deliverables on several Oracle Application 11i implementations including legacy data conversions into financial modules, custom reporting using Oracle Reports, and custom real-time interfaces into financial modules.
• Worked on rebuilding the Interfaces and Customizations on Account Payables and Receivable modules
• Creation of various Oracle Alerts to inform users of certain events, or to send notifications.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Developed a custom program for GL Interface.
• Developed AR Invoices to load data about the Invoices from legacy system into oracle applications by writing SQL loader scripts and PL/SQL scripts.
• Developed Payables open interface import to load the data to the base tables
• Customized Customer Listing Summary in Receivables based on the requirements.
• Developed interface for Cross validation rules in GL Module.
• Developed an interface for monthly import of journal entries from legacy system by using the journal import interface provided by Oracle General Ledger.
• Involved in optimizing the performance of database objects
• Involved in setting up AP, AR and GL with the Functional Team.
• Prepared Functional designed document MD 50 and prepared Technical designed document MD 70 using Standards AIM

Environment: Oracle Apps R11i, GL, AP, AR, AOL, Sysadmin, Linux, TOAD, Data Loader. Oracle 9i, 10g, PL/SQL, Oracle Forms 10g, Reports 10g, OA Framework, Oracle BI/XML Publisher

SR.CONSULTANT

Confidential

Responsibilities:

• Onsite in Singapore during implementation of OM, INV, GL and AR.
• As an Oracle APPS techno-functional lead, provided support for the product
• Provided solutions for issues raised by users
• Performed data segregation and archived solutions
• Mentored team members and enabled their delivery capabilities

Environment: Oracle Apps 11i, OM, AR, GL, AP, AR, FA, AOL, Sysadmin, Data Loader. Oracle 9i, 10g, PL/SQL, Oracle Forms 10g, Reports 10g, OA Framework, Oracle BI/XML Publisher, TOAD

CONSULTANT

Confidential

Responsibilities:

• On-Site Development, customization of reports in Receivables, Payables, GL
• Data conversion to transfer the data from legacy system to Oracle Receivables using SQL*Loader
• Modification of Oracle Apps standard reports and creation of any new reports
• AR and AP Interface
• Preparing Test cases, Testing and debugging
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Providing Post-Development Support at Client Site
• AR: Consolidated Invoice Register, Debtors Outstanding Statement Report, and Voucher Printing Report
• AP: Bank/Cash Payment Voucher, Voucher Printing, Check Printing, and Creditors Outstanding Statement
• Auto Invoice Setup: Defining of the Invoice Source, Grouping and Line
• Descriptive Flex fields: Identifying and defining the requirements

Environment: Oracle Apps 11i, Receivables and Payables, TOAD, SQL, PL/SQL, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher

CONSULTANT

Confidential

Responsibilities:

• On-site development and customization of reports in Receivables, Payables
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Involved in 24X7 production support, activities. Responsible for leading process Improvements, enhancements and customizations
• Involved in creation of Concurrent programs and Value sets
• Designed and developed Procedures, Functions and Packages using Oracle tools with application standards
• Involved in Enabling and Creation of Descriptive Flex Fields and Value sets
• Ensuring on-time delivery of objects
• Preparing Test cases, Testing and debugging
• AR: Involved in development and testing of interface program and Reports, AR Interface Program (Inbound), Sales Register Outbound Interface, Debtors Outstanding Statement Report (Dynamic buckets)
• AP: Development and testing of interface program and Reports, AP Interface Program(Inbound), Purchase Register Outbound Interface, Creditors Outstanding Statement Report (Dynamic Buckets), Check and Remittance Advice Report
• OM: Development and testing of interface programs, Reports, FGI and RMI Stock Availability Outbound Interface, Customer, Export and Internal Sales Order (ISO), Invoice Reports
• PO: Development and testing of Reports, Standard Purchase Order Report
• Return to Vendor Invoice Report.

Environment: Oracle Apps 11i, Receivables and Payables, TOAD, SQL, PL/SQL, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher

CONSULTANT

Confidential

Responsibilities:

• On Site Development and customization of reports in Receivables, Payables
• Preparing Test cases, Testing and debugging
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Responsible for technical solution design of components
• Ensuring on-time delivery of objects, extensive coordination with End-user
• Involved in creation of Concurrent programs and Value sets
• Involved in Enabling and Creation of Descriptive Flex Fields and Value sets
• Providing Post-Development Support at Client Site
• AR: Involved in development and testing of interface program and Reports, Domestic Invoice, Delivery Challan for OSP Items, Sales Register Outbound Interface, Debtors Outstanding Statement Report (Dynamic buckets)
• AP: Involved in development and testing of interface program and Reports, Purchase Register Outbound Interface, Creditors Outstanding Statement Report (Dynamic Buckets), Check and Remittance Advice Report, Cash and Bank Book
• OM: Development and testing of interface program and Reports, FG,RM and WIP Outbound Interface, Customer, Export and Internal Sales Order Invoice Reports
• PO: Involved in development and testing of Reports, Standard Purchase Order Report
• Return To Vendor (RTV) Invoice Report

Environment: Oracle Apps 11i, Receivables and Payables, TOAD, SQL, PL/SQL, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher

CONSULTANT

Confidential

Responsibilities:

• Off-shore development and customization of reports in Receivables and Order Management
• Development of Interfaces for Receivables
• Preparing Testing and debugging
• Preparing Technical documents (MD 70s)
• Providing Post-Development Support
• AR: Development of Invoice Report and Packing list Report

Environment: Oracle Apps 11i, Receivables and Payables, TOAD, SQL, PL/SQL, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher