Lead Oracle Financials Functional Resume
San Francisco, CA
SUMMARY:
- 14+ years of professional experience in Oracle Financials Functional.
- Demonstrated high level of expertise in General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Cash Management (CM), Fixed Assets (FA), AGIS, SLA, iExpenses and E - Business Tax (EBT).
- Completed in Oracle Cloud Financial.
- Sound knowledge and experience on other modules like Purchasing, Inventory, Advanced Collections, Order Management, Alerts and System Administration.
- Excellent problem solving, communication, analytical, interpersonal & leadership skills.
- Worked on multi-country and multi-currency environments.
- Expert in functional analysis, Gap analysis, Business Process Re-Engineering and interacted with client consulting companies for streamlining the business processes.
- Worked as Team Lead and “Functional Consultant” in various Implementations, Upgrades, Product development and Maintenance projects.
- Expertise includes team supervision, providing guidance and assistance to developers, helping users to resolve process related issues and code walk through.
- Strong skill and knowledge in handling backend database using TOAD and SQL Developer.
- Well versed with AIM methodology of Oracle Implementation.
- Experience in AGILE Methodology and experience in writing user stories.
- Experience in various industries like Social Banking, Manufacturing, Marine, Pharmaceutical and Social networking.
- Interpersonal skills, self-motivation, and quick adaption to new applications and technologies.
ERP (ORACLE APPLICATIONS) PROFICIENCY:
- Oracle General Ledger
- Oracle Accounts Receivables
- Oracle Accounts Payables
- Oracle Fixed Assets
- Oracle Cash Management
- Sub-Ledger Accounting (SLA)
- Oracle E-Business Tax
- Oracle iExpenses
- Oracle Project Accounting
TECHNICAL SKILLS:
Tools: TOAD, SQL Developer, Data Loader, WebEx, Blue Jeans, MS Visio
Languages: SQL
ERP: Oracle Applications 11i/R12, Web ADI, Discoverer
RDBMS: Oracle and SQL Server
Operating Systems: Windows XP/95/98/Vista/7/8, MS-DOS, UNIX
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
Lead Oracle Financials Functional
Environment: Oracle Applications 12.1.3
Responsibilities:
- Conduct meetings with multi country users for requirements gathering
- Writing user stories as per Agile methodology
- Configure Oracle R12 to meet business requirements
- Conduct IT Test, CRP and UAT sessions on new country rollouts
- Coordinating with technical consultants and business users for customizations
- Monitoring scheduled jobs in Oracle Applications
- Working on French localizations
- Supporting consolidation users for monthly and quarterly period close
- Prepare BR100 setup documents on Oracle R12 functionalities
- Coordinate with DBAs to apply patches
- Documenting recurring production issues
- Working with SOX Control teams like Internal Audit and external audits with PWC
- Work with Oracle Support and resolve product related issues
- Working with Financial Controllers of multiple countries
- Provide quality documentation, status updates and support
Confidential, Sunnyvale, CA
Senior Oracle Financials Functional
Environment: Oracle Applications 12.1.3
Responsibilities:
- Conduct requirements gathering sessions
- Configure Oracle R12 to meet business requirements
- Conduct CRP and UAT sessions for R12 Implementation
- Involved in the solution design
- Tracking issues in the bug tracking system
- Develop manuals and train business users on Oracle R12
- Developing customizations as per the requirement of the business.
- Preparing setup documents on Oracle R12 functionalities
- Coordinating with Oracle Support for bug patches
- Testing standard and custom reports
- Provide quality documentation and support
- Resolving issues raised by users
Confidential, Sacramento, CA
Senior Oracle Financials Functional
Environment: Oracle Applications 12.1.3
Responsibilities:
- Conduct meetings with end users for requirements gathering
- Configure Oracle R12 to meet business requirements
- Conduct IT Test, CRP and UAT sessions for R12 Upgrade
- Identify R12 new features to eliminate existing customizations
- Scheduled PA nightly jobs in Oracle Projects.
- Interfaced Labor Cost and Burden Cost from Projects to GL
- Configured SLA to display AP and AR sub-ledger details to GL journal line
- Develop manuals and train business users on Oracle R12
- Resolve month-end closing issues for end users
- Prepare BR100 setup documents on Oracle R12 functionalities
- Coordinate with DBAs to apply patches
- Testing the custom reports
- Work with Oracle Support and resolve product related issues
- Provide quality documentation, status updates and support
Confidential, San Francisco, CA
Lead Oracle Financials Functional
Environment: Oracle Applications 12.1.3
Responsibilities:
- Done Payment setups for Check printing and ACH formats for Comerica and US Banks.
- Configured Lockbox functionality for AR Receipts.
- Configured Ledgers, Legal Entities and assigned Balancing segments.
- Loaded GL balances using Web ADI.
- Configured Customer and Supplier associations in AGIS and created intercompany transactions among Legal Entities.
- Worked on Revenue Recognition functionality.
- Developed test scripts and coordinated with end users.
- Worked SLA configurations by modifying Account derivation rules and Journal line types.
- Conducted client meetings and involved the solution design.
- Worked on Wells Fargo and Amex Check printing and ACH payment formats.
- Coordinated with banks for transmission of files to bank servers.
- Worked on Report Manager and Account Hierarchy Manager Functionalities.
- Raised SRs and coordinated with Oracle on Demand.
Confidential, San Francisco, CA
Senior Oracle Financials Functional
Environment: Oracle Applications 12.1.3
Responsibilities:
- Worked on Wells Fargo and Amex Check printing and ACH payment formats.
- Worked on Report Manager, Account Hierarchy Manager and Repository Management functionalities.
- Prepared test scripts (TE40s) and testing of the functionality in the system.
- Tested custom objects testing and interacted with technical consultants.
- Prepared manuals and the users on R12 functionality.
- Attended client meetings and conducting Net meeting sessions.
- Prepared BR100 Setup documents for R12 new functionality.
- Coordinated with DBA for patching and cloning of instances.
- Coordinated with Oracle Support for patches and product related issues.
- Conducted IT Test, CRP sessions with the IT Staff and business users.
Confidential, Atlanta, GA
Lead Oracle Financials Functional
Environment: Oracle Applications 11i
Responsibilities:
- Did Requirement Gathering and prepared Business Requirement Documents (BRD).
- Prepared Solution Design Document (MD200) for each technical component.
- Prepared MoMs and shared with team members.
- Maintenance of Project Issues Log for reporting to the client and conducted meetings with the client.
- Provided functional inputs and follow up of technical components with the Team.
- Attended client meetings and conducted Net meeting sessions.
- Configured Lockbox for Wells Fargo bank and provided assistance to technical team.
- Configured check printing and bank outbound transmission for SunTrust bank.
- Did setups for GL, AP and AR modules and prepared setup documents(BR100).
- Coordinated with DBA for scheduling the instances for CRP and UAT.
- Created custom lookups for mapping between Gators and Oracle systems.
- Attended queries of technical consultants.
- Provided solutions on specific revenue recognition requirements.
- Tested the system and provided to the business users.
Confidential, Fremont, CA
Lead Oracle Financials Functional Consultant
Environment: Oracle Applications 12.0.6
Responsibilities:
- Maintenance of Issues Log for reporting the status of the issues and conducted issue status meetings with users on weekly basis.
- Diagnosed root cause analysis of the support issues observed to avoid reoccurrence of such issues in the future.
- Attended user requests over phone and conducted WebEx sessions.
- Configured AP/AR Netting functionality.
- Resolved Refund related issues for the users.
- Configured generation of multiple payment transmission files for single payment batch.
- Performed period closing process by reviewing the period close exception report from general ledger in addition to other exceptions reports generated from sub ledgers.
- Analyzed the patches to be applied and coordinating with DBA.
- Tested Discoverer reports and delivered to the Finance.
- Prepared documentation for the custom objects as per AIM Methodology.
Confidential
Oracle Functional Consultant
Environment: Oracle Applications 11i to 12.0.6 Apr
Responsibilities:
- Prepared Functionality/change document for new features in R12 and prepared Impact Analysis document.
- Prepared test scripts (TE40s) on GL, AP, AR, CM and FA modules.
- Application Support and troubleshooting of issues in R12 upgraded system on Oracle Financial modules.
- Maintenance of Issues Log for reporting the status of the issues and conducted issue status meetings on weekly basis.
- Raised SRs and followed up with Oracle Support.
- Defined intercompany accounts and done setup for global consolidation.
- Did setup for centralized payments in Payments module.
- Provided end-user on R12 new functionalities.
- Estimation and follow up of team members for the completion of tasks.
- Prepared documentation for the custom objects as per AIM Methodology.
Confidential
Onsite-Oracle Functional Consultant
Environment: Oracle Applications 11.5.10 Aug
Responsibilities:
- Oracle Functional Consultant.