SUMMARY

• Above 7+ years of Technical/Functional Experience in Oracle Applications R12,11i, SQL, PL/SQL, Discoverer 4i, Oracle Reports Builder 10g & 6i and Oracle Forms Builder 10g &.
• As an Oracle EBS Consultant, have experience in Oracle E - Business Suite Application Release 11i & R12. R12 new features, technology stack, architecture tools and techniques including Sub-Ledger Accounting (SLA).
• Rich experience on the RICE components (Reports, Interfaces, Customization and Extensions of Oracle Applications 11i/R12) on Oracle Projects, Financials, SCM modules. 11i to R12 Upgrade of RICE/CEMLI components.
• Application Integration; developed interfaces between Oracle Apps and legacy systems.
• Extensively used API's in Data conversions/migrations, validate, error trapping, loading processes, Procurement process (P2P) and Sales process (O2C).
• Functional knowledge on Oracle Projects, Finance & SCM and worked with multiple projects, objectives and deadlines. Issues tracking and resolution management.
• Extensive experience in SQL, PL/SQL, Procedures, Functions, Packages and Triggers, Forms, Reports, XML Publisher, Conversions, Interfaces and Forms Personalization effectively to accomplish specific business validations.
• Experience in Financial Modules such as Account Payables (AP), General Ledger (GL), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Project Accounting (PA), Oracle Project Management (OPM), Oracle Internet Expenses (iExp), Oracle Time and Labor (OTL), Sub-Ledger Accounting (SLA), Trading Community Architecture (TCA), Cash Management (CM), iSupplier.
• Functional Responsibilities: Requirement Gatherings, Functional Gap Analysis, Configuration, Training End Users, Writing Training Guides.
• Experience working on end-to-end Procure to Pay (P2P) and knowledge of Order to Cash (OTC).
• Proficient in SQL and PL/SQL and experience working on RICE Components and experience in creating WEB ADI's to load data in to oracle upon business requirement.
• Knowledge of Setups. E.g. COA, Calendars, Currency Rates, Cross Validation Rules. And Ledgers
• Experience of developing conversion programs and Interfaces (Inbound & Outbound).
• Experience in using tools like SQL *Loader, Data Loader, FND LOAD and knowledge of Writing/Modifying UNIX Shell Scripts.
• Experience of writing Technical/functional specification documents using AIM Methodologies.
• Coordinated with Oracle support to resolve application issues, bugs and TAR/SR management, production support, bug fixing and enhancement.
• Coordinated and Planned with Various Teams for Release Roll Out plans and Maintenance Plans in Support Projects.
• Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS

ERP Applications: Oracle E-Business Suite 11i/ R12

Oracle Modules: Financials (AP, AR, GL, FA, CM), Project Accounting (PA), SCM (PO, INV, OM)

Primary Skills: Oracle EBS Technical Development (RICEF Components), Interface (Inbound and Outbound), Conversions, Extensions, Oracle Application Framework (OAF), Form Personalization, Workflow builder, XML Reports, Oracle Alerts and Business Events

Case Tools: TOAD, Oracle Forms Builder, Reports Builder, Workflow Builder

Programming Tools: PL/SQL, Oracle Packages, Triggers, Libraries

ETL Tools: Data Loader, SQL*Loader, SQL*Plus

Development: Developer 6i/9i/10g (Reports 6i, 9i,10g & Forms 6i, 9i, 10g), Oracle 9i, 10g, SQL, PUSQL, SQL* Loader, Shell Scripting, Work Flow, Oracle BI Publisher, OAF, Applications Object Library (AOL)

Methodology: SDLC with AIM & OUM

Database: Oracle 9i/10g/11g Upgrades 11.5.10.2 R12.1.3

Operating System: Red Hat Linux, UNIX, Windows, Mac

PROFESSIONAL EXPERIENCE

Sr. Oracle EBS Consultant

Confidential - Warwick, RI

Responsibilities:

• Involved and resolved end to end Procure to Pay (P2P) issues and worked on Implementation and upgradation including implementations in Oracle R12.
• Well versed with the understanding of Oracle R12 including Sub-Ledger Accounting (SLA), AGIS, FSG reporting.
• Worked as over all data migration lead from Responses legacy systems to Oracle EBS and various Financial Custom Report development for business user with the help of BI reporting.
• Involved in setup of GL and AP modules on production server, updating the test scripts.
• Created multiple invoice report templates like Draft Invoice report, AR Invoice detailed report, AR Invoice summary report, Direct Sale Invoice report etc.
• Created numerous Lookups: Payment terms, Pay Groups, Tax distribution accounts, etc. Also, prepared GL, Sys Admin configuration documents.
• Prepared configuration documents for HRMS, AP, AR, CM and AGIS.
• Created PL/SQL interface to book the Sales Order using Process Order API in Order Management.
• Provided interface with the security architecture team, the data center team and the ITA team.
• Wrote standard Integration test scripts for Oracle Financials, Order to Cash and Procure to Pay Modules.
• Designed and developed complex CEMLI to report lot expiration date as standard out of the box, generates lots during batch completion.
• Presented and trained the users on key process changes and new features of Oracle EBS Release 12 with documentation.
• Performed accounting activities such as preparing journal entries, checking supporting entries, account reconciliation, account reporting and/or cost accounting analysis.
• Configure the Assets system to Route Capital Assets through Projects/Grants modules as appropriate to record depreciation monthly.

Oracle EBS Consultant

Confidential - Omaha, NE

Responsibilities:

• Supported a production Oracle financial system, including modules HR, AR, GL, AP, CM and PO, with problems resolution, installations, and business solutions.
• Developed Common error handling report to capture errors in interface execution and will send mail to users.
• Responsible for the setups for purchasing (PO), Order Management (OM), Bill of Materials (BOM) with the SOX approval.
• Functional Consultant with focus on Requirement analysis, Functional Setups, Integration Testing, User Acceptance Testing & Key User Training's.
• Gathered requirements, Designed and Customized reports like RFQ report (PO), AP Invoice Report, Disputed Invoice Report, Automated Dunning letters and AP Trail Balance report.
• Developed AP Future Date Invoice Transactions Report. Developed reports for getting payables and receivables from Sub Ledger Accounting (SLA).
• Completed configuration of PO, BOM, WIP and Inventory setup of with custom components to meet these needs.
• Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application.
• Involvement in business requirement, GAP analysis, process mapping, solution design, configuration, Customizations, user training for Oracle EBS at Site level.
• Preparation of Test scripts, performing quality assurance testing, user testing on new implementation of Oracle treasury, cash management and payables
• Have run various test cases / scenarios using Unconstraint based planning, Supplier Scheduling from planned Orders, demonstration to IT and Business Teams.
• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans.
• Conducted UAT sessions with key users and Go Live with minimal issues in Post Production support.
• Provided custom extracts of sub ledger accounts balances as requested by the auditors.
• Rolled out Global Trade Management(GTM) to new Orgs in Oracle EBS system. Ensuring classification codes and setting up Shipping document sets for the new orgs.

Oracle EBS Consultant

Confidential - Chicago, IL

Responsibilities:

• Responsible for handling Production issues related to Financial Modules and Custom Applications and extensively participated in Month/Year End Closing Activities.
• Conducted client interviews to complete the business process analysis and to prepare the business requirements documents.
• Assisted in Month End Period Closing for Oracle Payables by completing transactions, reconciling AP to GL and Close AP current Period.
• Developed new SQL reports, customized and optimized existing ones in Accounts payables
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs)and conducted quality reviews of code developed by other development staff.
• Modified the supplier setups to make use of "Pay on Receipt Auto Invoice Program" to automatically create Invoices from PO receipt.
• Handled production issues for Invoices created from Purchase orders. Worked on invoice validation, created accounting, journal import and journal posting process.
• Worked on customer questionnaire tool project where the Configuration team will get the details in advance when the quote is created and approved.
• Setup Receipt Classes, Receipts Sources and Payment Methods and used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period.
• Provided adhoc-reporting data from business users during critical year-end, Month end process and cleared the Error Interface transactions.
• Responsible for handling Customized interfaces issues and monitored critical issue progress to avoid SLA violations and customer escalations.
• Co-ordinated with business users to complete the User Acceptance Testing and log the defects in the PPM client Tool.
• Identified and to implemented best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios.
• Extensive Disaster Recovery tests are conducted every year and documented Issue Resolutions.
• Assisted the Incident Management team to drive downs the number of incidents by identifying the root cause and performed Post Incident Review on major incidents.
• Followed Change management, release management processes to ensure quality during production migration.
• Gained knowledge on the Inbound and outbound applications and resolving cross application tickets.

Business Analyst

Confidential - St. Louis, MO

Responsibilities:

• Conducted internal requirement gathering sessions with the SMEs (Subject Matter Experts) to understand as is process and to-be process for new system on the external platform.
• Performed business analysis, which included orchestrating JAD sessions, arranging meeting with stakeholders to gather requirements, and writing use cases and test cases/scripts.
• Defined existing business process (BPM-Business Process Modeling) and identified the gap (Gap Analysis) between the existing & improved business process to redefine to process.
• Designed various workflow diagrams using BPM notations and created data mapping document from AS-IS and TO-BE processes.
• Worked closely with the GUI design team to model the screens which met user defined requirements and company standards.
• Worked in Business Process Modeling (BPM), Business Process Flow, and Business Analysis with Document and Records Management.
• Used Rational Unified Process (RUP) to define the development life cycle and created Use Case diagrams using UML.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss functional & non-functional requirements, test plan, resource utilization, and defect tracking strategies.
• Participated in meetings to discuss the alignment between the two different software development processes - waterfall model and agile method.
• Coordinated and communicated functional requirements of business unit and technical solutions with IT capability resources by designing and documenting basic functional specs.
• Software Analysis & Design, Gathering Functional and Business Requirements, Specifications, User Interface Specifications, Technical Design, Test Cases and Test Plans.
• Prepared and documented System Requirements and workflows for the Content Management Application tool and involved in GAP analysis, mapping, implementation, and testing.
• Created use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Performed testing activities (SIT and UAT) including construction of test plans and scripts.