Patricia A. Freeman
* ******** **** ***** ● Catonsville, MD 21228
443-***-**** ● *********@*********.***
PROFESSIONAL OVERVIEW
Led and participated on teams doing analysis, design, development, implementations (set-up, testing & training), enhancements and of Oracle Financials EBS: Accounts Payable (AP), Accounts Receivables (AR), Purchasing (PO), General Ledger (GL), Inventory (INV/MRP/BOM), Cash Management (CE) and Order Management (OM) Cash & Treasury, Credit-to-Cash, Procure-to-Pay, Travel and Expense, Financial Control & Reporting, Depot Repair some light exposure to AME and Projects; I have physically performed all the setup steps for each of these applications as well as setup for all four modules of Governance Risk & Controls (AACG, CCG, TCG & PCG). I have provided continuous enhancement and support of Oracle EBS application for various business divisions which required an understanding of business requirements and developing solutions by leveraging standard or customized functionality. I possess a strong techno-functional knowledge which ensured Oracle EBS solutions were configured to meet business requirements.
Oracle ERP Modules
Accounts Payable (AP), Accounts Receivables (AR), PO (Purchase Order), General Ledger (GL), Inventory (INV/MRP/BOM), Order Management (OM) and Cash Management (CE), Application Access Controls Governor (AACG), Compliance Controls Governor (CCG), Transaction Controls Governor (TCG) and Preventative Controls Governor (PCG), light exposure to Projects (PA). Experienced with Order-to-Cash (O2C), Purchasing-to-Payables (P2P) and Receivables-to-Cash (R2C).
Implementation
Countries
Applications
US (27), Canada, UK, Ireland, Singapore and Germany
Oracle 9.4, 10.0, 10.7, 11.0, 11.03, 12.1, 12.2, 12.2.4 implementations and upgrades; heavy experience
Structured Query Language (SQL); light experience
Governance Risk & Controls (GRC): CCG, AACG, TCG & PCG; heavy experience
User Productivity Kit (UPK); light experience
QueryBuilder; heavy experience
Oracle SQL Developer; moderate experience
Microsoft Products: Excel, Word, PowerPoint and Visio; heavy experience
SharePoint; moderate experience
Education
M.B.A. National University – Sacramento, CA – Finance
B.S. Tuskegee University – Tuskegee, AL – Life Sciences
PROFESSIONAL AND BUSINESS EXPERIENCE
Randstad Professionals: Baltimore, MD (Contract) June 2016 – June 2017
Oracle Analyst-Inventory Implementation & Process Re-Engineering
Elicited user requirements using interviews, analysis, requirements workshops, surveys and workflow analysis.
Critically evaluated information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details, abstract up from low-level information to a general understanding and distinguished user requests from underlying true needs.
Proactively communicated and collaborated to analyze information needs, gathered functional requirements.
Delivered business requirements mapping process flows, functional designs, test plans, training requirements and high-level project timeline for each assigned project.
Fully comprehended, articulated and documented existing complex, interdependent solutions across EBS and the system ecosystem by successfully engaging multiple initiatives simultaneously
Assessed short-term and long-term trade-offs and made solid recommendations to the business and technology teams.
Translated business requirements and technical requirements in to enduring solutions by mapping processes and adopted process improvement scenarios to matrixed team.
Drove solutions to complex business problems, advocated for scalable solutions.
Demonstrated a strong analytical and project management skills through a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements.
Assessed impact of system changes and ensure effective delivery of application functionality and integration.
Identified and advocated for opportunities to improve current procedures, processes and systems support development and execution of roll out strategies, cut-over/transition plans, end-user training and documentation.
Empowered end-users through instruction and functional knowledge transfer.
Patricia A. Freeman
4 Twilling Gate Court ● Catonsville, MD 21228
443-***-**** ● *********@*********.***
Served as business liaison to communicate requirements to the technical development team and facilitated detailed requirements with stakeholders during the development lifecycle for both onshore and offshore team members.
Partnered with onsite/offshore development and QA team members in all phases of project delivery, production enhancements and support.
In the absence of a formal GRC implementation made amendments to Oracle User Roles/Responsibilities so ITGC audit requirements were met.
Oracle Corporation/MICROS® Systems, Inc. – Columbia, Maryland September 1997 – August 2015
Oracle Application Analyst
Oracle Corporation purchased MICROS Systems, Inc. in June 2014; became a transitional contributor to develop methodology to bill 65+% expenses to customers related to Projects both in-process and new projects. This included being able to track, bill and report expenses for Installers for two Business Units (Restaurants and Hotels) to ensure appropriate expenses generated were properly billed to customers for 84 subsidiaries across the globe in local currencies. Obtained information from both Oracle’s iExpense and Projects applications to comparing it against the data from the online Travel Management Company (TMC) and American Express Corporate Card. Worked with each subsidiary to ensure appropriate billable expenses identified by the Installers were in turn billed in the local ERP via comparison and analysis of data coming from both Oracle’s iExpense and local ERPs. Normalized Supplier, Customers and Parts of worldwide MICROS subsidiaries in preparation for integration into Oracle’s ERP as a result of the acquisition in conformity with Oracle’s accepted naming conventions and accepted protocols.
GRC Manager & Oracle Implementation Manager – Columbia, Maryland September 2002 – June 2014
Ensured data from Legacy ERP Systems ticked-and-tied to the receiving ERP when acquisitions were made
Member of the Due Diligence Acquisition Team
Reduced overlapping policies, risks, and controls by streamlining the GRC process
Eliminated redundant tasks through the use of a single GRC initiative
Acted as GRC System Subject Matter Expert (SME) and provided training/support for internal stakeholders which included one-on-one training as well as classroom training environments
Performed all the setup steps for AP, AR, PO, GL, INV, MRP, BOM and OM as well as setup for all four modules of GRC (AACG, CCG, TCG & PCG)
Analyzed business challenges utilizing technical knowledge to formulate solutions to those challenges
Meet regulatory compliance and set-up/implemented control to reduce enterprise risk with GRC rules
Performed cross-enterprise risk-based modeling, analysis and treatment via GRC rules
Worked with IT staff to integrate both Oracle and non-Oracle business applications
Documented policies and procedures for migration and maintenance of established GRC system
Reviewed and worked with both Internal and External Audit to understand areas that needed to be addressed by GRC so appropriate rules and setup would be deployed and implemented
Documented GRC setup, tested rules & trained Business Owners on how to review and document findings
Gathered data from Business Units to create a consolidated and comprehensive view of GRC Compliance as well as provided efficient workflows and usability recommendations
Prioritized competing needs and meet established deadlines
Translated business needs into IT deliverables
Identified root cases and accountability for risk by tracking loss incidents and ownership in a GRC environment
Automated Segregation of Duties (SOD) enforcement across the enterprise applications, databases and custom solutions
Ensured Compliant User Provisioning across all systems with Oracle Application Methodology (AIM)
Enforced Best Practices Setup and reduced setup slippage so systems setup was monitored to ensure critical steps followed standard policy and change management procedures
Minimized time spent on monitoring false positives via internal knowledge of business controls and practices
Adjusted existing Oracle User Responsibilities/Roles to ensure defined GRC requirements and internal controls were made; conducting internal testing to confirm
Patricia A. Freeman
4 Twilling Gate Court ● Catonsville, MD 21228
443-***-**** ● *********@*********.***
Corporate Travel Manager – Columbia, Maryland September 2002 – June 2014
Determined business requirements for a Corporate Credit Card Program, Online Travel Management Program and Online Expense Reporting Program; along with the Controller of the Company selected Suppliers to fulfill these needs and then worked directly with the Suppliers to deploy programs and conduct training of users. We achieved and consistently maintained a 98% Online Adoption Rate of the use of the TMC
Managed Corporate Credit Card Program with less than one-half of 1% delinquency rate
Wrote and managed the Corporate Travel Policy
Represented and presented MICROS’ Travel-related, Corporate Credit Card and various Payables payment vehicles as MICROS was considered adoption and management “best-in-breed”
Oracle Application and Process Improvement Analyst – Columbia, Maryland September 2002 – June 2014
Member of the Steering Committee which was comprised of the Chief Financial Officer (CFO), Controller, Vice President of IT, Director of IT and Vice Presidents of Business Units (Restaurant and Hotel); the Steering Committee was responsible for identifying and approving projects (new and enhancements) for the corporation
Translated business requirements from the Business Community to the DBAs, Developers and DBAs on many projects including:
Purchasing Card (P-Card),
Buyer-Initiated Payment (BIP),
iExpenses,
Positive Pay
Wire Transfers
Automatic Clearing House (ACH) Payment automation
Deposit Invoicing
Customer Relationship Management (CRM)
Customer-facing web-front facing:
oStatements
oPayments
oAbility to e-mail copies of both Invoices & Credit Memos
Conversion Strategy(ies) for Parts, Customers, Suppliers, Purchase Orders from Legacy ERP systems
Third-party systems which included:
oBar-coding application integrated with Inventory
oService Contract billing system that integrated with Receivables
Resolved day-to-day issues related to production support
Worked with the Business Community to identify areas that could be improved whether through process improvement or the implementation/deployment/set-up of software
Worked with and lead teams(s) to identify areas for improvement and to accomplish those improvements
Participated in or corrected database process errors
Wrote SQL queries which were approved by the Business Unit and then conveyed to the IT Staff to develop .rtf reports and ultimately Concurrent Programs
Provided training via a variety of modalities including in person, screen share, written documentation, testing and UPK
Gathered needs requirements from acquired companies and subsidiaries to determine whether conversion to Oracle was appropriate
Made presentations to Senior Management of recommendations
Responsible for functional design, configuration change, setup, development, testing and implementation for on-going Oracle EBS production support
Collaborated and executed assigned tasks by addressing all aspects of new implementations, functionality enhancements, application updates, performance issues and maintenance activities.
Collaborated with other application and technical resources to resolve a problem or implementing a system change
Involved in and lead fit-gap analysis requirements
Documented implementation plans
Patricia A. Freeman
4 Twilling Gate Court ● Catonsville, MD 21228
443-***-**** ● *********@*********.***
EMEA Receivables Controller January 1999-January 2000
Managed EMEA subsidiaries in Israel, Italy, Portugal, Spain, Sweden, Norway, Finland, UK, Germany, France, Egypt, South Africa, Kenya and Ireland to more effectively collect receivables
Documented, tracked and reported performance to the EMEA Corporate Controller Corporate CFO and CEO/President
Negotiated with customers to pay down receivables balances
Receivables Specialist September 1997-January 1999
Collected assigned receivables accounts