SIMON GORTON

Fairfax, VA 22033
Job Function
Information Technology
Experienced Information Technology professional with a background in Oracle Applications and Middleware Administration (WebLogic). Well versed in Oracle Technology- 12c, R12 and others including Oracle Applications-EBS: ERP & CRM. Extensively involved with technical environments as a Developer and DBA. Consulted on more than fifty installs, conversions, and upgrades. Adapts quickly to new project responsibilities and effectively applies skills to complex assignments. Diligent, resourceful, detail-oriented team player who works well both as an individual and in group settings.
 

Work Experience

    • Oracle Database Designer/Oracle Applications Consultant
    • Oracle Technology Consulting // Jan '96 - Present
    • 1996 - Present Oracle Technology Consulting (OTC) Oracle Database Designer/Oracle Applications Consultant Over fourteen years working with clients on oracle applications and database design. Areas of expertise includes Oracle 10g, Oracle Forms and Reports 6i+, Oracle 11i & R12 ERP: Federal Financials, Payables, Receivables, General Ledger, Assets (FA), Purchasing (Purchases Orders/Procurement), Order Management, Projects, Inventory, Cost Management, Cash Management and Budgeting. Client projects: • Client Confidential: Aided in the implementation of R12 e-Business Suite. Provided support as an application developer and database administrator. Aided in migration and upgrade of R12.1.1 to R12.1.3. Worked with Oracle Virtual Box to create Red Hat Enterprise Linux (RHEL5) and Oracle Enterprise Linux (EL) images for testing and deployment environments. Developed various scripts in support of system maintenance. Responsible for data migration from CostPoint to R12 e-Business Suite. Aided in configuration and integration of ERP and CRM modules (HCM, Payroll, Projects and Supply Chain (Order Management, Pricing, Inventory, Accounts Receivable). • Department of Transportation, Federal Aviation Administration (FAA). Provided Functional and Technical support for the Fixed Assets Division. Primary modules in use included: Fixed Assets, Oracle Projects, Oracle Payables, HR, and FedAdmin. Tools used included: Oracle Forms and Reports, Data Warehousing, OBIEE(BI Publisher), Oracle Discoverer Plus and Oracle Discoverer Administrator, Quest Toad, ISQL, SAS, and ERWIN for data modeling. Responsible for building Excess Property Database (EPDb) extension and associated data warehouse design. Designed and built Unix scripts to facilitate data insertion and update of the database. • Department of Health and Human Services (DHHS), United Financial Management System (UFMS). Installed and configured Oracle e-Business suite application products. UFMS implementation installed Oracle Applications (e-Business Suite). Worked in the following modules including A/P, A/R, Purchasing, General Ledger, Budget Execution, and Projects. Also designed Computer Based Training (CBTs) to educate personnel at the Food and Drug Administration (FDA) and National Institutes of Health (NIH), Centers for Disease Control (CDC) and other DHHS agencies. Responsible for helping to integrate CBTs into the application environment. Aided with configuration management. Responsible for designing UNIX script(s) transform data and execute file transmissions to US Treasury. • Programmed Oracle databases in support of the District Of Columbia Superior Court (DCSC). Primary responsibilities included programming and application design and support for the Criminal Division. Duties included interfacing with federal and local agencies such as JUSTIS, CSOSA, Metropolitan Police (MPD) and others. Oracle products included Oracle Database Server, Oracle Application Server, JDeveloper, Oracle Forms and Reports, Oracle Data Warehouse, Oracle Warehouse Builder, Data Guard, and Oracle Streams. Accomplishments also included helping to implement Forms and JDeveloper applications utilizing various data sources mentioned above. Utilized Oracle Designer for data modeling. • Department of Justice, United States Trustees. Programmed databases in support of the Bankruptcy Courts. Products included Oracle 8i Server, Oracle 8i Client, Oracle Application Server (9iAS), and Oracle Applications 11i, Oracle 6i Forms, MS Access and MS FoxPro. Access and FoxPro used as SQL tools. Primary application under development: FICS (Fee Information Collection System). FICS is receivables and fixed assets extension. Responsibilities included technical support and application building (FICS Help Desk). Purpose of FICS database is to bill debtors and report on financial data provided to the bankruptcy courts. Information gathered used to generate Chapter 11 fees due from debtors. Responsible for transfer of debtor statistics from regions to national database for the bankruptcy courts. • Defense Contractor: Designed custom Oracle interface to facilitate updating of various database components. Tools were OMAR, Oracle 8i, Oracle 9i, JDeveloper, Oracle Forms and Reports, Oracle Designer along with Oracle 11i modules/applets. Closeout database design allowed detailed tracking of "1431" contracts. These are contracts that are ready to be closed. Tested finished product on functional side of Oracle Financials which aided in the close out of government contracts. Modules and applets used included browser-based utilities/interfaces. Full life cycle project from design to implementation. • International Telecom: Aided in upgrade of Oracle Applications 11i version 10.7 to 11.5. Included installing/configuring the following modules: General Ledger, Payables, Purchasing, Inventory, Fixed Assets and Cost Management. Oracle Workflow was used to set up critical paths used in the design of the system. Modified Forms and Reports as needed to track assets through Oracle Fixed Assets. Responsible for tracking data through the inventory module to fixed assets (FA). Set up and automated serial numbering to track assets. Overall system was used to aid in completion of worldwide communications network for GlobalOne and France Telecom. TOAD used as a development tool. • Mortgage Reseller: Designed and managed databases with the purpose of allowing staff access to current information regarding vendor contracts while doing business off-site. Programmed and designed a JAVA based reporting system for this purpose. Responsible for designing and building front end application and back end database objects. Designed and built Unix scripts to facilitate data insertion and update of the database. This was an interactive database capable of being updated on demand. Other tools used included Oracle Workflow, MS SQL Server, and MS Access. Full life cycle project from design to implementation. • Service Organization: Team Lead responsible for two projects that allowed staff to gain access to most current data in Oracle databases from field offices. Chamber and Requisitions databases. Front end was designed using TOAD and Oracle Forms/Reports. A Java applet was also used in some instances. Purpose was to allow field sales personnel access to up to date sales information. Chamber database reported current sales and commissions to field sales staff and telemarketing management. Requisitions database linked several systems downloading purchase orders to office supply vendors. This database automated a previously manual system of office supply requisitions. Other tools used in this project included TOAD. • Process Manufacturing: Managed databases for the three oracle subsystems at paper mill. These were the work order management system, payroll, and the General Ledger/Human resources module for Oracle Financials. Tables were reconciled weekly and monthly as these costs represented over $40 million and represented the largest budgeted expense at the mill. Payroll was reconciled as this dataflow was then transferred out of the work order management system (standard costing system) to Ceridian. Payroll data was charged and summary data was transferred back to St. Laurent updating the general ledger. This routine was performed weekly. Aided in management of cost centers helping personnel when needed. Responsible for maintaining the standard costing system (including allocations and rates), adjusting accounting journals and ledgers. Managed the work order management system that ran on an Oracle platform. Developed the database to report on spending within the 44 mechanical and electrical cost centers within the mill.

       ...More
    • Baker Equipment Engineering
    • Jan '95 - Dec '95
    • 1995 - 1995 Baker Equipment Engineering Controller Managed the G/L; aided in management of accounting staff; aided in financial closings; reconciled balance sheet accounts such as pre-paids, inventory and fixed assets. Responsible for payment of sales taxes and reconciliation of bank accounts (corp. and field offices). Acted as liaison for company audits by accounting firms, lenders, and government agencies. Aided in conversion of aged DEC computer system to one utilizing the UNIX with the QAD integrated manufacturing package utilizing an oracle platform.
       ...More
    • Chief Accountant
    • Lambert Point Docks // Jan '92 - Dec '94
    • 1992 - 1994 Lambert Point Docks Chief Accountant Responsible for closings and preparing internal and external reports for NS. Managed accounting staff and interacted with department heads in performance of daily and periodical financial duties. Aided in financial system computer conversion (Wang).
       ...More
    • Accounting/Database Consultant
    • Hover, Incorporated // Jan '86 - Dec '91
    • 1986 - 1991 Hover, Incorporated Accounting/Database Consultant Accountant and Financial Consultant, responsibilities included G/L, A/R, A/P, Payroll, Inventory, and Budgeting. Experienced in computer use of spreadsheets and databases. Client projects included installation of computerized accounting and financial management systems, and costing of a utility vehicle prototype in development and production.
       ...More
    • Oracle Database Designer/Oracle Applications Consultant
    • Strategic Global Systems (SGS)
    • Currently working with various clients on WebLogic, Oracle Applications Database Design.  Areas of expertise includes Oracle 10g/11g/12c, Oracle Forms and Reports 6i+, Oracle 11i & R12 ERP: Federal Financials, Payables, Receivables, General Ledger, Assets (FA), Purchasing (Purchases Orders/Procurement), Order Management, Projects, Inventory, Cost Management, Cash Management and Budgeting. 

       ...More
 

Education

    • Master's Degree // Computer Science and Accounting AACSB
    • Old Dominion University
    • Bachelor's Degree
    • Old Dominion University
 

Timeline

'17
'14
'11
'08
'05
'02
'99
'96
'93
'90
'87
Oracle Database Designer/Oracle Applications Consultant
Oracle Technology Consulting
Oracle Database Designer/Oracle Applications Consultant
Strategic Global Systems (SGS)
Baker Equipment Engineering
Chief Accountant
Lambert Point Docks
Accounting/Database Consultant
Hover, Incorporated
 

Skills

Learning
Intermediate
Advanced
Expert
 

Keywords

A/p A/r Access Accounting Accounts Receivable Application Design Application Server Aviation Aviation Administration Back End Bankruptcy Budget Budgeting Buying/procurement Cash Cash Management Ceridian Change Management Clients Collection Computer Based Training Configuration Management Contracts Cost Management Costpoint Credit Crm Data Migration Data Modeling Data Warehouse
Browse Jobs