SUMMARY:

• Over 11+ years of consulting experience on Oracle Applications (EBS R12/11i) and Oracle technologies. 
• Strong experience in functional analysis, technical development, and implementation setups for Oracle EBS R12 and 11i modules: Order Management, Fixed Assets, General Ledger, Account Payables, Account Receivables, Oracle Purchasing, Financial Accounting Hub (FAH) Order Management. 
• Experience in Functional setups for Interfaces, Conversions in Financial Accounting Hub (FAH), General Ledger, Accounts Payables and Accounts Receivables modules and Supply chain Modules. 
• Strong experience in Manufacturing, Procurement and Supply Chain modules of Oracle EBS working with Discrete, Distributions and Process Manufacturing Clients 
• High expertise in Oracle Financials : AR, AP, Financial Accounting Hub (FAH), GL | Oracle Supply Chain Management (SCM): Purchasing, Inventory, Order Management. 
• Oracle Certified in R12 iProcurement. 
• Technical Expertise in application development using JDeveloper, OA Framework, OBIEE, OBIA, BI Publisher, Discoverer, Oracle PL/SQL, Oracle Forms and Reports.
• Hands on experience in designing and configuring Oracle EBS; Hire to Retire, Source to Pay, Quote to Cash, Demand to Build business processes 
• Good Understanding of RICEW (Reports, Conversions, Interfaces, Extensions, Workflows) Technical components
• Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL
• Led/Worked on various Oracle Applications Implementation, Re - Implementation, upgrade, support and rollout projects which includes RICEW/CEMLI components development with R11i/R12i releases of EBS ( Oracle E-Business Solutions). 
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70) 
• Competent with Project Accounting, Project Billing, Project Costing, Project Management, Project Resource Management, Supply Chain (OM, PO), Inventory (INV, BOM, WIP), Shipping and WMS (WSH), Finance (AP, AR, GL), Enterprise Asset Management (eAM), Oracle Process Manufacturing (OPM) Modules and knowledge in OTL, HRMS and HCM modules. 
• Experienced to Prepare Query Feedback Forms, Unit Test Plans, and performing testing with Test logs and participated in Peer reviews, Technical reviews for deliveries with the client.

TECHNICAL SKILLS:

ERP Application: Oracle e-Business … R12.1.3) 

ERP Modules OM, INV, PO, BOM, WIP, AP, AR, GL, eAM, OPM, CRM, Alerts, Projects Accounting, Project Billing, and Project Costing, Project Management, and Project Resource Management. 

ERP Business Flows Order to Cash (O2C), Procure to Pay(P2P) 

Methodologies AIM( Oracle ), GIEA(Cummins) 

Languages SQL, PL/SQL, Shell Scripting, Core Java 

Database Oracle …  

Operating Systems Windows NT, Unix, Linux Versioning Tools VSS, SVN  Tools/Utilities Workflow Builder, SQL * Loader, Developer 2000, SQL * Plus, Putty, SQL Developer, PL SQL Developer, Reports 6i/10g, Forms 6i/10g, Forms Personalization, BI Publisher and XML Publisher, TKPROF and QTP

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Oracle EBS Techno Functional Consultant

• Worked on customizing PO Approval workflow to run back-end concurrent program whenever a new PO/Blanket PO/revised/change order PO's, has been created. 
• Analyzed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12
• Personalization and Extension of OAF pages in various modules. 
• Created multiple Complex OAF Pages for Purchasing, Order Management, and iExpense which included Partial page rendering functionality 
• Worked on customizing PO confirms Receipts workflow replacing requester notification and removing not received button from the notification. 
• Customized GL Trial Balance report, convert to excel format and csv to reduce the file size and place the file in ftp folder using shell script and generating multiple outputs files based on number of records 
• Worked on HRMS Updating person information in base data using API. 
• Worked on Po Output for Communication Template changes and create a new template for Agreement PO. 
• Create Oracle alert to send email to ADP when Purchase Orders are cancelled in Oracle EBS . Sync up additional objects which are modified in R11 to R12 up gradation. 
• Fixing post-production issues. 
• Creation of new plans, jobs, position, grades, payrolls, interfaces, Rates, Benefit Structure, Premiums, Coverage, Eligibility, Plan Types, Options, Life Events, Literatures, Extracts, Quick Codes, Global Values, Rule creations and Rule enhancement (Fast Formulas) in HRMS. 
• Development of new (finance and hr) reports using Reports 10g (Xml publisher, rdf Reports 10g

Confidential, Los Angeles, CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Participated in the gathering business requirements from business users and diverse business groups. 
• Assisted in the design of functional specifications documents for diverse business groups. 
• Involved in Super User meetings to gather specific business requirements for setting up the modules. 
• Participated in meetings and identifying diverse business requirements for business groups 
• Documented changes within financial application for diverse business units. 
• Worked in the analysis of P2P data (Requisitions, Purchase Orders, Receipts, Invoices, Expense Reports, Credit card& P-card setup, bank accounts and diverse payment system) across business groups 
• Identifying the requirements from User & developed functional specs for the General ledger, Account payables, Account Receivables, Cash Management, Fixed Assets and Cash Management, I-Expenses. 
• Designed diverse business process flows using MS Visio for diverse business units.
• Designed functional specifications document for diverse financial requirements based on AIM Methodology. 
• Participated in the design of technical specification document for diverse requirements. 
• Analyzed financial data from diverse legacy systems and documented changes as per the requirements. 
• Worked with closely with the project manager in the design of project plan and diverse project activities. 
• Worked in the setup and configuration of ledgers, Cross validation Rules, Data Access Sets, and diverse segments within the accounting structure. 
• Assisted in the tracking financial data across diverse sub-ledgers into Sub-ledger Accounting engine. 

Confidential, Pasadena, CA

Oracle EBS Functional Consultant

Responsibilities;

• Supporting solving Day-to-Day End-User problems. 
• Issues rose due to the Oracle bugs, Raise SR and coordinate with the Oracle team and provide the fix or the work around and move it to the production system.
• Enabling Key Flex field and Descriptive Flex field. 
• Handling situations for run time problems and suggesting the work around. 
• Interacting with technical consultants and user for resolving issues. 
• Setup iExpense to enable project expense reports, Setup auto accounting for iExpenses related expense types, and expense templates. 
• Co coordinating with all finance user, understanding their requirements & explaining the same to the respective functional & technical team members to make the changes or new development of reports, customization etc. 
• Involved in some activities for Oracle System Administration module such as registering the Users and assigning responsibilities & creating new responsibilities and defining the required system profile options. 
• Business process analysis and requirement gathering for new customization, report development. 
• Conducted UAT and training for end users and production support. 
• Support for Month end closures.
• Testing the functionality of new enhancements for new entitles in R12. 

Confidential

Oracle EBS Developer

Responsibilities:

• Responsible for gathering the requirements for RICE objects and designed the CV40s, MD50s, CV60s, and MD70s and helped the business to identify the right solution. 
• Mapped the business requirements to Oracle Applications, Design solutions. 
• Designed and Developed the Open Invoice Conversion from Legacy to Oracle eBS . 
• Worked with Onshore and developed technical designs for GL COA Segment Value Sets Extract ( Oracle GL to Concur) and AP Open Invoices Conversion. 
• Designed and Developed Auto-Confirm Payment Batch for the Payment Batches formatted for the CHECKS. 
• Added the text to cash and other expenses page using OAF Personalization. 
• Designed and Developed Custom Supplier Confirmed Receivable Process (Custom Tables, Forms, Reports, Payables Interface, XML Bursting Process) 
• Defined value sets, key Flex field segments and roll-up groups with security and cross validation rules and Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet. 
• Developed the Electronic Billing and Consolidated Invoice Reports for AR. 
• Wrote TE20s for UAT testing and assisted in Integration testing, tracked the issues and resolved the issues. 
• Used Kintana for migrating code to all instances. 
• Involved in Integration test and developed TE40s. 
• Designed Configured and Developed AP Invoices Conversion and got succeeded with 99.8% accuracy in Production. 
• Worked on Complex Roll Forward Report which was a combination of 3 report

Confidential

Oracle EBS Developer

Responsibilities:

• Experience with Upgrade of Oracle Applications from 11.0.3 to R12. 
• Customization of 11i to R12 Account Detail Report to work as required. 
• Experience with RICE Components testing and modify from 11.0.3 to R12. 
• Custom data migration from 11.0.3 to R12. 
• Experience with different instances Custom Priority Objects migrating scripts, and Testing.
• Experience with Creating Technical Design Documents (i.e. DS-140, MD-070, CV-060 and MD-120) for Customization Objects