SUMMARY:

25 years of functional accounting and accounting systems experience. Over 18 years of experience as an Oracle Finance Functional Analyst using Oracle 11i and R12 within a Financial Information Systems group. Very strong SQL, problem solving and project management skills with emphasis on systems process, set ups, scheduling, audit response and compliance. Excellent written, verbal and presentation skills.

CORE COMPETENCIES/AREAS OF EXPERTISE INCLUDE:

• Project Management
• User Management
• Ad Hoc Reporting
• Regression Testing
• SOD Compliance
• Data Response - Audit
• SQL Duplicate AP
• SQL for 1099 issuance
• AP duplicate payments
• Web ADI
• Stat Entries
• Conversion/Data Clean
• SQL
• FSG Reports
• COA Maintenance
• Auto Accounting
• GRC
• Oracle General Ledger
• Security Rules
• Oracle Projects
• Master Data Maintenance

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle Business Analyst

Responsibilities:

• Technical and functional Accounts Payable support
• Test and implement Concur Expense Report EDI upload
• Assist with desk top procedures for Accounts Payable staff
• Assist with report development in OBIEE
• Develop month end procedures for new shared service center in Houston

Confidential, Houston, TX

Senior Oracle Business Analyst

Responsibilities:

• Provided technical and functional support for the core Oracle finance modules (AR, GL, AP, PO, PA) with heavy emphasis on Oracle Projects. Responsibilities ranged from functional user support to technical research and troubleshooting which included working closely with our DBA team and communicating with Oracle support via Metalink.
• Year-end account roll forward/reconciliation.
• Master Data Maintenance steering committee. Involved with Supplier clean up using Data Loader.
• Applied 1099 update patch and generated 1099’s for Accounts Payables department.
• Primary and first responder for all finance user issues. Managed numerous business process projects.
• System administration duties included user set-up and maintenance, set up and define responsibilities and report sets, COA maintenance, calendars, currency rates, cross-validation rules, and security rules. Also responsible for scheduling and maintaining all automated processes.
• Communicated all major system news to user community.
• Oracle GL and Projects annual budgeting.
• Sole support for Oracle WEB ADI process and issues.
• Created, maintained and documented month end close procedure.
• Managed and responsible for month end processing including communication and coordination with over 800 users, opening and closing of periods and immediate ad hoc reporting to assist the accounting and finance teams.
• Developed and maintained custom invoicing reports.
• Developed and maintained electronic invoice formats for upload into customer accounting systems.
• Developed and maintained all FSG accounting reports and all WEB ADI templates.
• Performed and maintained quarterly Oracle security review.
• Initiated, developed and maintained role-based security in Oracle 11i working with Internal Audit, the CFO and Controller to ensure proper segregation of duties based on the employee’s role. Continued Oracle security review utilizing GRC in R12 environment.
• Reimplementation project from 11i to R12.
• Responsible for all audit responses involving system data utilized SQL to gather and verify data before releasing to client or audit team.
• Project Manager for all regression testing from 2008 thru 2016. Duties included user communication, weekly update meetings, cutover plan, acceptance testing, contingency plans, presentation to management for review of significant issues and maintenance of all project documents.
• Excellent SQL skills especially with the following modules: AR, AP, PO, PA, HR, GL
• Developed and wrote complicated SQL scripts to assist accounting and finance with research or to resolve a reporting gap. One example is a Project Margin Report which listed detail for each expenditure associated with a project and tied to both General Ledger and Projects. More examples include a group of scripts written which are used each month end close and can quickly show the exact GL, Project and Event entries booked during a specific time frame. These scripts greatly decreased trial balance reconciliation time on the last day of close and were later turned into reports for the entire company’s use.
• Developed and wrote SQL for all Accounting, HR and Finance metrics.
• Managed a cross-functional Oracle user group meeting every two weeks for 9 years. This meeting built effective and beneficial relationships between Finance Information Systems, Accounting, and Human Resources.

Confidential, Houston, TX

Oracle Functional Consultant

Responsibilities:

• Worked at client locations including Harris County Tax Office, EGL Global Logistics and Confidential (hired permanent at Confidential ).
• Project scope included interface reconciliation, heavy use of PL/SQL Developer, Oracle Financials, and process improvement.
• Also responsible for calculating financial accruals based on reconciliation results.

Confidential

Senior Manager of Accounting Systems, Houston, TX

Responsibilities:

• Managed the implementation of Oracle Applications R11.02, 11.03 (GL, AP, PO, Fixed Assets, and Applications Desktop Integrator) for Outsourcing Division.
• Defined requirements and established implementation plans; prepared and monitored work plans; delegated work assignments to team members and external consultants; made recommendations and advised project status to senior management; coordinated end-user communication and training; coordinated and conducted testing (CRP, UAT, Unit, Integration); coordinated functional conversion efforts for migration of legacy data; gathered functional specifications for custom interfaces of legacy system to Oracle General Ledger.
• General Ledger Super User for Oracle 11i CRM project.
• Developed and maintained all ADI accounting and budget templates.
• Provided functional support for GL, FA and ADI.
• Extensive ADI troubleshooting and support.
• System administration functions.
• Developed and maintained cross-validation rules, account hierarchies and security rules.
• Provided ongoing training to end users.