SUMMARY

• Over 10+ years of experience as an Oracle Applications Functional, Techno - Functional Consultant with experience in designing, developing, implementing supporting and Testing Oracle ERP P2P modules and O2C custom solutions.
• Strong experience in various versions of Oracle Applications such as R12, 11i. 有5个从需求收集到后期制作的全生命周期实施经验.
• Experience in Procure to Pay cycle Purchasing, Account Payables, Fixed Assets and System Administrator.
• Rich Experience in Order to Cash Cycle Order Management, inventory, Accounts Receivables, Cash Management, General Ledger and Trading Community Architecture.
• Proficient in the concepts of Multi-Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Good Knowledge in Revaluation, Translation and Consolidation process. 熟悉并理解R12模块的新概念，如分类账(SLA), Accounting Setup Manager, configuration of security controls using Multi-org Access Control, Data Access Sets, Definition Access Sets.
• Designed and implemented iProcurement. Tailored many web pages to accommodate business requirements. Developed new LOVs for the accounting structure. Prepared setup and test documents.
• 有建立电子商务税务模块的经验，以获取美国销售税和使用税以及EMEA增值税的要求.
• System administration skills include defining request groups, responsibilities, and users, 为用户设置配置文件选项和维护并发程序分配责任.
• Good knowledge on System administrator tasks like creating menu, function. 帮助开发团队执行系统管理任务，如注册可执行程序和并发程序
• 在系统管理职责中执行自定义，以创建新的配置文件选项，并使报告输出对所有用户可用.

TECHNICAL SKILLS

ERP Application: Oracle Release 12 and 11i Financials Modules covering General Ledger (GL), Report Manager, Accounts Payables (AP), Payments Setup Administrator (IBY), Accounts Receivables (AR), Revenue Manager, Fixed Assets (FA), Cash Management (CE), E-Business Tax (EBT) and also System Administrator.

Integration knowledge with: Supply Chain Modules covering Purchasing (PO), Inventory (INV), Order Management (OM) and Cost Management - SLA (R12).

Self Service Modules: iProcurement, iSupplier, iExpense

Tools: & Utilities: User Productivity Kit (UPK), Application Desktop Integrator (ADI), Web ADI, TOAD, Data Loader, Microsoft Office (Project, Visio, Excel, Word & Power Point.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Lead Oracle Apps Functional consultant

Responsibilities:

• Implementation of Oracle Financials 12.1.3. 负责配置采购、I-procurement、I-expense、I-supplier和Sourcing.
• Responsible for creating baseline document, Business requirements documents and functional specifications document.
• Perform System administrator task customizing the messages for PO modules. Changed sourcing email template messages in System administrator.
• Used Data loader scripts in Users and Responsibilities in System administrator. Responsible for configuring the AME approve rules.
• Developed custom solution for requisition approval. Upload imaged using bulk upload. Managed Team for 5 people. Worked on offshore Model.
• Performed production support activities for Australia and New Zealand.
• Automated Invoice Interface as a part of production support.

Confidential, Santa Clara, CA

Lead Oracle Apps Functional consultant

Responsibilities:

• Responsible for Consolidation implementation in GCS. Responsible for developing 180 Allocation rule. Implementation of Journal Approval.
• Create Cross validation Rules. Defined Revaluations and trained user on it. Trained users on translation, Consolidation and Data load.
• Create project plan for cut over activities. Managed in house team. 更新菜单和功能，为系统管理员职责中的职责.
• 更新了报告集，并为系统管理员中的自定义职责创建了新的报告集.
• Resolved production support tickets involving Journal Approval, Web ADI and Gl reports.
• Created change request documentation for production support tickets.

Confidential, Oklahoma City, OK

Oracle Payment SME

Responsibilities:

• Complete Oracle Payment Implementation requirement gathering to Testing. Involved New Year (2013) setup for all 21Federal DOT and non DOT agencies.
• Updating and validating BR100 documents for AP, PO, FA and AR. Worked on resolving KSN Issue in STG4 and RSNB instance.
• Created test cases and perform testing for complete P2P process. Registered new executable in System administrator module.

Confidential, Morgantown, WV

Oracle Apps Functional

Responsibilities:

• Implementation of Oracle Account Payables (AP) ver 12.1.3 and its integration with PO, CM and GL.
• Study of current business processes, 未来的业务流程，并确定差距和变通方法，以便提供一个集成的采购支付业务流程，以满足公司的业务需求.
• Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM. Log, view, access, monitor, 在线跟踪和关闭服务请求(SRs) - Oracle MetaLink和Oracle应用程序补丁管理.
• Budget control was used in AP implementation. 准备完整的会计结算周期程序，包括标准报告，以协调分账(PO), AP, and INV) with GL. Provide training in this topic to the key users.
• AP integration with PO, CE和GL模块在投入使用前经过了广泛的测试和验证(会计和预算控制).
• Perform Production Support Activities for all the procure to pay modules.
• Designed the Test Scripts and Test Scenarios for iProcurement and iSupplier Portal. Loaded Catalogs in to iProcurement (Buyer Hosted Catalog and Supplier Hosted Catalog).
• AP模块的设置、配置和实现涉及所有强制性和可选性步骤.
• 实现的目的是提取AP模块功能中可用的最大好处.
• Deliverables according with Oracle’s AIM including need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing.
• Wide analysis of the module functionality in order to avoid gaps. 当没有可用的功能性解决方案或变通方法时，它们会通过自定义处理.
• 标准化每个项目类别的结帐类型，在I-Procurement中设置批准限制.
• Set up profile options, favorite items/categories, requisition approval workflow, training users in requisition tracking and desktop receiving in I-Procurement.
• 定义用户职责，根据用户职责设置自定义菜单和请求集.
• Provided training and conducted practice and additional business requirements sessions.

Confidential

Oracle Apps Functional

Responsibilities:

• Implementation and support of Oracle Applications R12. 在I-Procurement中建立信息模板、公开清单和费用报销规则.
• Standardized receiving, expense receiving and returns in I-Procurement.
• Performed System Administration tasks such as setting up custom responsibilities, function /menu exclusions, updating user profiles iSupplier & Core, setup DFFs/Value Sets/Values etc.
• Testing modules’ setup for inconsistencies. 执行与客户沟通的任务，以管理测试数据，并确保其满足客户的需求.
• Customizations using oracle client extensions. 执行缺陷跟踪和识别手动测试需求的职责.
• Assisting in developing and testing software applications. Provided Training & Conducted Practice & Additional Business Requirements sessions.
• 通过响应紧急请求，每天为生产环境和用户提供支持
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.

Confidential

Oracle Apps Functional

Responsibilities:

• Work with an offshore team in India. Upgrade Assessment of current business process in R12 (GL, AR and Cash Management).
• Impact analysis in current business process due upgrade changes/enhancements. Business process mapping with all standard and customized modules.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• 通过响应紧急请求，每天为生产环境和用户提供支持.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems. Post go-live support.

Confidential

Oracle Apps Functional

Responsibilities:

• 分析当前业务流程并定义Oracle应用程序中的新流程.
• Business requirements gathering, mapping, gap identification and workarounds.
• Responsible to trainee IT personal and implementers within modules of ASCP, OPM, Inventory and Quality Management (Process Manufacturing).
• Data conversion mapping and support to technical team for requirements.
• Business processes definitions to be implemented within new environment.
• 定义自定义流程，以便在月底有待定的预测以供规划. BR100 and MP050 documentation.
• 环境配置和场景准备，文档和概念证明. Setup, Test and training on Internal Sales Orders functionality.
• Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable. Organizations configuration to allow ISO between them.
• Inventory Plan configuration for OPM functionality.
• OPM内的批处理配方和配方配置，允许ASCP和自定义代码创建批处理以驱动生产计划.
• Quality Specification configuration and QC business definitions.
• ASCP采购规则配置允许ATP和OM的SO调度过程根据客户站点的区域定义“来源”计算
• Patching and bug research, implementation requests, test and delivery. Task and Cutover listing.
• Diagram and nightly routings (Planning) definition and documentation. Post Go-live production support.

Confidential

Oracle Apps Functional

Responsibilities:

• 根据财务和供应链模块在11i (FAH)中的优先级，解决用户每天报告的问题, PO, AP, FA, GL, OM, INV and AR).
• Involved in developing two interface programs and reports for FA. Generating the Asset Keys automatically.
• 参与了几个在月底运行的程序的性能调优，以进行整合.
• Writing and testing the unit test cases to test all the flows.
• Work with Oracle on Service Requests. Creating a Supplier Bank Audit Report.
• Involved and headed the team in coming up with the new and latest standards for coding, development and testing.

Confidential

Functional

Responsibilities:

• Defined the Accounting Flex-field, Segments and Value sets.
• 定义所有图书的职责，并将职责附加到每一套图书上.
• Defined Currency, calendar and Period types. Loaded the accounts using the Data loader
• Defined the Consolidation Mappings. Defined the Legal Entities for all the Subsidiary companies
• Defined Parent accounts and entered Child ranges for rollups.
• 定义汇总规则，使用FSG为资产负债表开发行集和列集.
• 定义业务组和操作单元，并分配业务组的配置文件选项.
• Mapped individual Subsidiary Chart of Accounts to Consolidated COA.
• Transferred Balances from the Subsidiary sets of books to the parent sets of Books.
• Posted Journals created by subsidiary data transfer in Consolidated Set of Books.
• Defined Segment Rules and Rollup Rules using the Consolidation Workbench.
• Created FSG Consolidation Balance sheet, Income statement and reports.
• 制定整合过程的培训指南，培训用户如何处理整合过程.
• Process of Intercompany transactions.
• Developed Weekly and monthly Status reports.

Confidential

Functional

Responsibilities:

• Gathered the requirements for GL/AR/AP/CM and FA
• Defined Suppliers and AP invoice Profile options.
• Define Receipt Batch sources and created Transaction batch source in AR.
• Defined Tax Codes, Tax names and groups in AP.
• Setup Credit card Expense mapping and Data file download.
• Setup Supplier sites, Matching Tolerances and Distribution Sets in AP
• Setup Bank Accounts and Payment Terms in AP.
• Updated county, Territory information and assigned flexible address formats AR
• Translated, Loaded and Validate converted Asset. Loaded Balances to Production.
• Document all the Setups in BR 100 Template for GL/AR/AP and FA
• Set up the application in both Test and In production instance For AR/AP/FA/GL/CM.
• Executed the Test Scripts for GL/AP/AR/CM and FA.
• Conducted and documented current and future Business Processes for GL/AP/AR/FA/CM.
• Wrote Test Scripts to test processes for CRP 1, CRP2 and UAT.
• Documented and distributed Weekly and Monthly status reports.
• Developed Navigation Document and basic transactional guidelines for End-users.

Confidential

Functional

Responsibilities:

• 与财务超级用户一起确定哪些历史数据要转换并加载到新GL系统中.
• 在WEB ADI中开发了自定义电子表格，用于将历史数据输入Oracle GL的上传过程.
• 使用Web ADI创建布局和映射，以便将GL历史数据加载到生产系统中.
• 对总账余额和交易的历史数据转换进行对账.
• 翻译欧洲套书，并确保第一次结束关闭及时发生.
• Loaded GL Historical data to 11.5.10 using Web ADI.
• Worked as primary liaison between Business users and technical staff, lead problem resolution process by working with Oracle Support team by creating TARs.
• Designed the MD.050 design document for the AR invoice Print.

Confidential

Functional

Responsibilities:

• Created test plans, performed system testing, and worked with end users on all facets of the customer record for AR
• Production Support of Oracle AR/GL/AP
• Collection, analysis and consolidation of users reporting requirements.
• 协助财务用户完成月末应收/总帐/应收帐款的处理并解决日常问题.
• Development of reports using FSG.

Confidential

Functional

Responsibilities:

• 作为定义的一部分，完成了总账/AP/应收/CM的问卷调查，并记录了当前和未来的业务流程
• Held COA workshops, gathered the data for Chart Design.
• Designed the COA and mapped Old COA to the New COA.
• Combined COA of six companies to a consolidated COA
• Set up GL Sets of Books for Jamaica and Barbados in Dev, Test and Production Environment. Defined the Accounting Key Flex
• 创建宏，使用Data Loader将COA加载到系统，并将COA加载到GL.
• Defined Row set, Column Sets Using FSG.
• Defined the Set of Books, Currency and the Transaction Calendar in GL
• Defined the Recurring journals, Journal sources and Journal Categories GL
• Defined Budgets and Budget organizations.
• Setup matching tolerance and distribution sets AP.
• Define Banks, bank Accounts, Banks transmissions details and Payment Terms.
• Opened AP accounting period and Defined Withholding tax certificates and exceptions.
• Defined the format for the invoice Aging Report AP.
• Define tax codes and withholding tax groups for use automatic withholding tax AP.
• Defined US 1099 income tax regions AP and AP invoice Profile Option.
• Define customers Define Receipt Batch source and created the transaction batch source
• Defined AR system Options, Setup Tax names, Groups and Expense Reports templates.
• Prepared the Test Data, Test Scripts, executed the testing and documented the results.
• Defined Cross validation rules, Segments and Value sets.
• Created Summary accounts and defined automatic posting criteria.