Brenda Hogan Email & Phone Number

Austin, Tx, Us

Austin, Tx, Us

Rockville, Md, Us

Oracle Cloud Implementations

Aberdeen, Gb

• Supported multiple Clients involved in Manufacturing (industrial and finished goods), Services and Retail in the US as well as worldwide. • Adjusted to clients environment regarding development standards and methodology including Waterfall and Agile. • Team projects: o Oracle EBS upgrades including upgrading to version 12 with the structural changes. o Implementing new modules including Inventory, Purchasing, AP, Order management and AR. • Technical documentation of o Existing applications, o Updates to existing applications and documentation, o New customizations and processes, o Migration instructions. • Oracle EBS support diagnosing and correcting issues, including creating Oracle Service Requests. • XML/BI Publisher reports for multiple modules with PDF and Excel output. • AP check process improvements reducing the check processing runs for the users. • Marketing Customer, Order and item data extract and FTP to a 3rd party server. • APEX interface diagnostic reports for external processing and Oracle standard interface errors. • APEX inbound rest services and outbound API interfaces passing Purchase Orders and updating Inventory information utilizing JSON file formats. • APEX forms updating Oracle ship sets and dates via Oracle APIs. • ADI interfaces updating Inventory Recipe setup.

Kerrville, Texas, Us

• Process improvements to include version control, Oracle documentation processing and Agile processes. Created the MD035 Development Standards document for the team.• Multiple integrations with 3 party on premise and cloud based systems:• FEDEX integration for shipping for multiple accounts.• Order management, Inventory Management with Weblinc (BVAccel) website interface.• Accounts Payable and GL interface with Lucernex Lease management.• Inventory and Planning interfaces with Ortems Scheduling.• GXS (Open Text) VAN implementation to allow for third party wholesale trading• GXS (Open Text) BizMapper implementation and mappings for inbound and outbound Oracle documents. Mappings include 810, 812, 816, 820, 846, 850, 856, 860, 870 and 997.• APEX report creation and enhancements to support departments throughout the company including Distribution Center, Retail, Planning, Accounts Payable and Accounts Receivable.• Implement Lockbox to process Inbound 820 (remittance advice).• Multiple interfaces with wholesale suppliers via E-commerce EDI solution• Order management (replenishment and drop ship), Inventory and Accounts Receivable interfaces with Dillard's• Order management (replenishment and drop ship), Inventory, Accounts Receivables • Team member of Oracle EBS upgrade to release 12.2.4.• Team member of the implementation of Oracle Demantra and ASCP.

• Implementation of Oracle Daily Business Intelligence for Financials and HRMS.• Customized reports for multiple clients on various modules.• Performed custom training on Discoverer Plus, Discoverer Viewer, Discoverer Administrator, PLSQL, Oracle Reports, Daily Business Intelligence• Administrated Discover (4.1 and 10g) end user layer and created reports on several v11.5 and v12 Oracle Applications.• Designed and managed an customization to extract and transfer Purchase Order information from Oracle to legacy system• Designed and developed interface from oracle to an external system to transfer supplier information.• Custom Oracle Forms and Reports for a Hazardous Waste System• Custom Oracle Forms and Reports for a Pharmaceutical Testing Organization• Custom Safety implementation from the database architecture to custom Discoverer reporting.• Development of Rice objects on Oracle Implementation projects.• XML templates, applied to Oracle Reports.• Created Sql*Plus scripts that created a HTML output using Cascading Style Sheets.

• PL/SQL development and tuning on terabyte size databases• Worked with team on release management and version control

• Short Term Assignment: Texas Parks and Wildlife• Oracle Forms, Reports, and PL/SQL database development with Oracle Financial PO and custom HR/Payroll solutions.

• Assignment: Maximus in partnership with Accenture as the Texas Access Alliance• Oracle Forms and PL/SQL database object development• Managed defect and enhancement request distribution• Analyzed requests and created functional technical requirements for approval• Created design standards documentation to enhance the look and feel of the system

Us

• Implementation of new customer including conversion of the data and set up to suit the needs of the client• Assisted Account Management in supporting new customer after go-live. Second line of support for incoming software issues, finding the source of the issues and recommending solutions• Analysis and design documentation for new enhancements and existing features including management overviews, technical specifications, and user documentation. Ensuring that new enhancements are in the best interest of current and future customers as well as the advancement of the software• Presentation of new features and enhancements to Client Management for approval• Assist users and co-workers with their understanding of the system, relational database, and SQL scripting• Acceptance testing for client including creation of test plans, execution of the test, data analysis, resulting call entry, and tracking

• Design, development, testing and implementation of modules and enhancements to production payroll system. Comprehensive project analysis including its effect on current customer base, Partners and performance optimization. Database objects used in design include tables, triggers, packages, functions, procedures and libraries. • Project Management of Conversions including primary contact with clients, needs analysis, scheduling, data restructuring, training and support throughout the installation process. Streamlined the installation process allowing for more installations and increased growth. • Trained users as well as super-users of the system.• Maintain product source code, customer specific code, updates and interim releases to clients. Created technical product documentation including upgrade installation instructions, training documents, user documentation and conversion questionnaires.

• Assignment: Pedernales Electric Coop, Johnson City, Texas• Managed the Quality Assurance Team which consisted of the Coops Users and Technology department• Quality Assurance Acceptance testing software from the software company (Envision) as well as in-house developers• Deciphered the nature of defects, reporting to the developers or the software company and installing patches then retesting prior to installation in the production environment• Created and maintained SQL scripts for data manipulation and analyzing system process completion and accuracy• Developed solutions for the Cooperative’s end users in the form of SQL scripts, Oracle Developer forms and reports• Maintained Testing Oracle 8 Database including refreshing test data with live backup data to closely replicate the current production system and performance

• Designed, developed, tested, and administered an integrated, fully functional Oracle 6 database with a v2.3 forms interface for a multi-department service business. Modules included multi-users, interactive dispatching, accounts receivable and collections, accounts payable, warehouse inventory management, payroll, human resources, lead tracking, marketing, and menus. Using this software, the company grew from two to nine million dollars. Designed standardized reports using SQL Reports and SQL Plus. Managed, designed, and implemented migration of this system from Oracle v2.3 Forms on SCO UNIX operating system to Oracle Forms v5 on Windows NT• Managed all general and accounting activities for a nine million dollar business• Well-versed in standard business practices, insurance, tax reporting, general ledger, accounts receivable, accounts payable, payroll and State/Federal reporting, human resources, purchasing, warehouse management, sales, and marketing.

Architecture / Architectural Engineering

Computer Information / Accounting