It Oracle Finance Manager Resume
San Antonio, TX
SUMMARY
- 11 years of Industry experience wif extensive exposure to domains in ERP Oracle E - Business Suite Financial modules, Information Technology (IT), Finance (FIN) and about one year of experience in Oracle Cloud
- Completed Four full lifecycles of Oracle financial modules implementation including: requirements gathering analysis, CRP, UAT, solution design, module configuration, testing conversions and production support.
- Supporting the company's oracle enterprise applications, transactions flow and Business process improvement and changes.
- Experience in different types of Implementation, Upgrade, Development, Testing and support projects including functional set-ups, business process analysis, gap analysis and functional specifications
- Great experience working wif Asian, Latin and North America, EMEA countries localization/Statuary requirements and setups.
- Good knowledge of Procure to Pay (PTP), Order to Cash(OTC), Record to Report(RTR), INV to assets(ITA) Project to Asset (P2A) cycles.
- Good understanding of table structures/flows and ability to write SQL Select Queries and PLSQL Functions.
TECHNICAL SKILLS
Oracle E-Business Suite: General Ledger, Fixed Assets, Accounts Payables, Cash Management, Account Receivable, I-Receivable, Purchasing, I-expense, I-Payments, I-Procurement, Order management, Inventory, Cost management, System Admin, Oracle Projects, Asset Tracking, Oracle Install Base, Manufacturing, EBTax, Sub-ledger Accounting, Form Personalization, WebAdi, AGIS, FSG reports, other Financial reports etc.
Oracle Fusion: General Ledger, Account Payables, Fixed Asset
Database Tools & Utilities: Data Loader, TOAD, SQL Developer
Microsoft Suite: Excel, Power Point, Word, Pivot tables, Visio
PROFESSIONAL EXPERIENCE
Confidential, San Antonio TX
IT Oracle Finance Manager
Responsibilities:
- Managing a team of approximately 9 team members.
- Complete incharge of company’s IT finanace
- Improving companies current process including, Ledger Structure, COA structure, Revenue based on 606 and 605 standard, IT green belt & yellow belt projects
- Providing training to Super user and end user on new process and changes.
- Managing all IT issues and projects on daily basis
Confidential, Andover MA
Oracle Finance Business Analyst
Responsibilities:
- Implementing Oracle financial modules for China, Hong Kong, and Singapore countries.
- Supporting Order to Cash (O2C), Procure to Pay (P2P) and Record to report (R2R) related issues
- Writing many business design/changes/enhancement and requirement documents by using AIM methodologies.
- Implementing I-expense for China, Hong Kong, and Singapore.
- Closely working wif Super users for process changes and training on new features
- Closely working wif developers and Users for customizations (RICE items) and new/enhancement requests.
- Supporting all complex accounting related issues and new requirements by using Oracle SLA feature for Revenue, COGS, Assets, and all other accountings sources.
- Writing new process and design documents based on the requirements.
- Supporting China, Hong Kong and Singapore statuary requirements including HBS (Gloden Tax), HBSC bank Ifile format, Reports, and interfaces.
- Creating FSG reports based on the requirements
- Supporting all data mart related issues.
- Performing CRP sessions wif the user onsite and supporting UAT and Post Production support.
- Supporting Month End close
Environment: s: Oracle R12.1.3, Oracle Account Payables, Fixed assets, General Ledger, Account Receivable, Cash management, Cost Management, Purchasing, AGIS, Order Management, I-Expense, System Admin, Gloden Tax (EBS), Datamart, Hyperion
Confidential, Marlborough MA
Oracle Financial Consultant
Responsibilities:
- Supporting company’s Oracle enterprise applications. Possesses extensive experience wif Oracle financial applications and transaction flows and understanding of business and accounting processes working wif business user for all oracle applications and non-applications related issues
- Supporting all revenue and invoice related issue
- Writing user story, Design and process documents based on the requirement and closely working wif the developers for development.
- Writing and testing new CIP and GL reports
- Supporting Oracle Projects to Fixed asset(PTA) process
- Supporting production issues.
Environment: s: Oracle R12.2.2, Oracle Account Payables, Fixed assets, Oracle Projects, OBIEE, Discover report, General Ledger, Account Receivable, Cost Management
Confidential, Dallas, TX
Oracle Financial Business Analyst
Responsibilities:
- Providing immediate solution for all O2C, R2R and P2P cycle defects
- Closely working wif developers and Users for customizations (RICEWF items) and new/enhancement requests.
- Wrote many functional process/design documents based on the requirements like MD050, BR-100, AP322, TE040 and many more by using Oracle AIM methodology.
- Supporting all Euro currency related defects like Payments, Invoice, customer setups, Lockbox etc.
- Supporting Oracle project modules and related SR/defects.
- Supporting/Implemented automation of Revenue and COGS accounting entries by Sales Channels using SLA feature.
- Design many Reports, Interfaces and Extensions based on the requirements.
- Supporting OBIEE and FSG reports.
- Supporting end to end INV to Asset cycle.
- Writing new process and design documents based on the requirements.
- Supporting Account Receivables, Payables, Fixed assets, General Ledger, Order Management, Inventory, Purchasing, Cost management and Asset Tracking, Oracle Install Base modules.
- Implementing all oracle financial major features/modules like SLA, FGS, AGIS, IReceivable, Lockbox etc. based on the requirements
- Supporting all I-Receivable related defects and providing immediate solution.
- Supporting COGS and Revenue recognition issues.
- Supporting all Discover report, Blackline defects and providing training also
- Closely working wif offshore team developers for all kind of issues, Developments, and all other requests.
- Fit/Gap analysis on new requirements
- Performing CRP sessions
- Supporting UAT, SIT, and post production support.
- Heavily involved in Tax regime to rate flow (EBTax)
- Designing new RICEWF components
- Provide user training for new processes/features and designs.
- Month, Quarter, and Year end support
Environment: s: Oracle R12.1.3, Oracle Account Payables, Fixed assets, Account Receivables, General Ledger, Cash management, Purchasing, Order management, I-Receivable, System Admin, Cost Management, Sub-Ledger Accounting, Blackline, Discover report, AGIS, Concur, Hyperion
Confidential, Chicago, IL
Oracle financial Analyst
Responsibilities:
- Closely working wif super user for new/enhance requirements for new RICEWF items.
- Support Fixed asset conversion and AGIS setups
- Provide immediate solution for all I2R, R2R and Q2C cycle defects
- Reconciliation between Oracle financials and External systems
- Resolved issues on FA and GL interfaces
- Trained Super Users on GL, AP, AR, FA Modules
- Users training on new process and design
- Supporting all Payable invoice, Payments, Tax related issues.
- Writing new/change design documents and present to the business on customizations
- Supporting India localization.
- Month, Quarter, and Year end support
Environment: s: Oracle R12.1.3, Oracle Cloud Release 7 (11.1.7), Oracle Account Payables, Fixed assets, Account Receivables, General Ledger, Cash management, Purchasing, Order management, I-Receivable, System Admin, Sub-Ledger Accounting, Concur, Blackline, Inventory, Cost Management, Discover report, Hyperion
Confidential, Atlanta, GA
Oracle Fixed Assets Lead
Responsibilities:
- Lead FA Team of 12 resources
- Gatheird Requirement analysis for all financials modules in view of established processes under global design
- Performed FIT/GAP Analysis and CRP Sessions wif client
- Write and Execute Test Scripts.
- Documenting various workarounds dat can be used.
- Developed and designed many CRP demonstration documents, Requirements document, UAT scripts, Project scope, Risk and many other ppt documents by using MS office and oracle AIM methodology.
- Supported UAT and Pre-Post production support.
- Designed various interfaces, Reports, and Extensions wif other external applications like Buy to Pay (SSS).
- Assist the countries in preparation of data conversion
- End user training on AP, GL, and FA modules
- Mock close support and Month end reconciliation of sub-ledger modules
Environment: s: Oracle R11.5.10, Oracle R12, Oracle Account Payables, AGIS, Fixed assets, General Ledger, Cash management, Purchasing, Sub-Ledger Accounting
Confidential, Mountain View, CA
Oracle Financial Lead
Responsibilities:
- Implemented oracle more than 20 countries including US, Euro (Italy, France, Germany, Spain, Austria, Belgium), Asia (Philippines, Taiwan) and Latin (Mexico, Brazil, Costa Rica) countries based on the Global/Statutory requirements.
- Gatheird Requirement analysis for all financials modules in view of established processes under global design
- Wrote many process documents like MD050, AP322, RD020, BR100 and many more.
- Performed FIT/GAP Analysis and CRP Sessions wif client
- Write and Execute Test Scripts.
- Closely working wif the users for oracle projects related requirements.
- Directly working wif Hyperion analyst for any R2R related defects.
- Documenting various workarounds dat can be used.
- Closely working wif the users on Tax local and statuary requirements and supporting it.
- Designed various interfaces, Reports, and Extensions wif other external applications like Concur, Aperture, and Bloomberg etc.
- Defined many FSG reports based on the requirements and provided immediate solution on all ongoing issues.
- Provided solutions on the complex integration between Oracle Financials and various other external applications
- Understanding specific local requirements for RICEWF and wrote many Functional design, Training, and testing documents.
- Assist the countries in preparation of data conversion for AP, GL and FA modules
- Supported O2C, P2P and R2R cycles
- Actively involved in the implementation and support of the GL, AP, FA, SLA, AGIS, FSG and Cash Management modules for many countries.
- End user training on AP, GL, and FA modules
- Mock close support and Month end reconciliation of sub-ledger modules
- Reconciliation between Oracle financials and External systems
- Resolved issues on FA and GL interfaces
- Trained Super Users on GL, AP, AR, FA Modules
- Lead all my GL team More than 8 people
- Inspired by each team member to perform and produce their best
- Offered solutions to the top management regarding project-related queries.
Environment: s: Oracle 11.5.10, Oracle R 12.1.3, Oracle Account Payables, AGIS, Fixed assets, Account Receivables, General Ledger, Cash management, Purchasing, System Admin, Sub-Ledger Accounting, Concur, ADP, Discover report, Hyperion
Confidential, Houston, TX
Project Manager
Responsibilities:
- Managed a team of 13 Business analyst and consultants.
- Supporting O2C, R2R cycle related defects.
- Provided solution and design for Oracle and third party Financial Management System (FMS) wif responsibility for integration and reconciliation.
- Created various documents on setups, standard operating manuals and training Materials for Oracle GL, AP, and PO modules
- Conversion and reconciliation of assets.
- Heavily involved in pre-and post-production support on all financial modules GL, AP, CE, FA, and PO.
Environment: s: Oracle 11.5.10, Oracle R 12.1.3, Oracle Account Payables, AGIS, Fixed assets, General Ledger, Sub-Ledger Accounting, Concur, Discover report, Hyperion
Confidential, Tampa, FL
Fixed asset Analyst
Responsibilities:
- Initially started the project wif requirement gathering for Oracle Fixed asset module in view of established processes under global design
- Performed FIT/GAP Analysis and CRP Sessions wif client
- Wrote and Executed Test Scripts.
- Documented various workarounds dat can be used.
- Worked on Account Standardization.
- Prepared functional design documents (MD050) on customization and reviewed wif the client for approval.
- Supported UAT and Post production support.
- Implemented FA for LATAM countries and Supported data conversion
- Closely worked wif the Super user on customization and training.
- Production support including the ad-hoc reporting requirements and reconciliation of sub-ledgers to general ledgers using SQL.
- Month and quarter end support
Environment: s: Oracle R12, Oracle Account Payables, Fixed assets, AGIS, General Ledger, Purchasing, Sub-Ledger Accounting, Discover report
Confidential, San Francisco, CA
Oracle Business Analyst
Responsibilities:
- Post-Support Release 12.1.1 rollout implementation
- Established proper hierarchy of the business units for financial reporting
- Defined security rules and responsibilities to ensure SOX compliance
- Defined FSG Reports to consolidate the financial statements of 25 different companies
- Defined and Setup of GIS system and the required responsibilities for proper access of the same
- Defined the GCS for consolidation of 9 different Set of Books.
- Defined the recurring journal allocation formulas for allocation of various expenses across various business units
- Setup fixed assets module wif 91 asset books for 9 countries to meet the local statutory reporting of the countries, Local tax requirements, US GAAP requirements and US tax requirements
- Reconciled wif GL after data conversion
- Modified Fixed Assets workflow to ensure proper accounting required for reporting
Environment: s: Oracle R12, Oracle Account Payables, AGIS, Fixed assets, General Ledger, Purchasing, Sub-Ledger Accounting, Discover report
