|
ERP
Undertook / performed myriad critical technical and functional
implementation and operation issues / tasks (particularly as an ERP
trouble-shooter) for a number of Oracle clients, including:
- performed OA management gap analysis and devised strategies for several decisions including in-house vs hosting for the system and OA staffing
- evaluated, interviewed and recommended prospective employees and consultants
- created extensive documentation for trouble-shooting and application to future projects,
- worked with DBA to plan strategies for archive/purge, disaster recovery and data warehousing,
- helped resolve many critical technical and functional issues
- resolved technical and functional problems
- created successful implementation completion plan subsequent to failed implementation by previous consultants
- reviewed and resolved various outstanding functional and technical issues relating to Workflow, Inventory, General Ledger, Purchasing, System Administration, Receivables, and Bills of Material,
- resolved complex legacy issues,
- diverse trouble-shooting independently, with on-site staff, other consultants and with Oracle Technical Support,
- applications system administrator,
- character-based/SC to NCA migration,
- system analysis, strategic planning and implementation for server migration,
- created Archive/Purge/Warehouse strategy (performed in test environments and documented for production environment).
- Information retrieval
Multi-org
- set up and tested add-on multi-org operating unit (modules INV, WIP, BOM, ENG, AP, AR, PA, PO, OM, GL, OTM, HRMS, separate legal entity, shared set of books),
- added new organization (sharing set of books with other organization) to existing 11.0 ERP structure and set up, tested and documented Receivables, Payables, Order Entry, Cash Management, Purchasing, Inventory, Bills of Material, Work In Process and Purchasing Related Work Flow,
- performed multi-org installation (beta 10.6) on existing system
- upgrade to multi-org 10.7 and 11
- extensive multi-org experience including system engineering planning for senior management (plans for mass globalization/consolidation of multiple international systems)
- Restructured underlying organizational hierarchy and added 160 organizations using 63 currencies within a complex reporting and multi-currency hierarchy
Back to TOC
Technical Areas
Reports
- created ad hoc SQLPlus reports and statements for user information and problem resolution
- trouble-shot and modified existing Bills of Material import
- ad hoc database manipulation for special legislative and agency upper management report requests. (Back to TechTOC)
Imports, Data Conversions & Interfaces (Internal & External)
- created, tested, tuned and documented Order Import and Inventory Item import strategies;
- tested and created specs for invoice import,
- Helped resolve existing issues relating to EDI, Tax Information Import, etc.
- mapped Bills of Material, Inventory Items, Pricing, Subinventories from Great Plains Dynamics legacy system to OA 11i.
- including existing issues relating to EDI and Tax Information Import created specs, tested and performed data conversion/import for Items (including cost and on-hand balances), Customers, and Receivables balances.
- created specifications and tested import of inventory items and quantities, customers, and purchase orders from legacy system (Fourth Shift, Grand Prairie, Great Plains, Excel, Access) (Back to TechTOC)
Workflow Modification
Concurrent Processes
- analyzed, scheduled, and documented critical Concurrent Processes,
- created concurrent processes to automate interfaces with ACH system for direct debit (external)
- created and tested concurrent process executables & related SQL & flexfields (Back to TechTOC)
Patches
- installed patches 10.4 to 11i
- created patch installation and testing plan,
- installed 42 mini-pack and one off patches in Test and Prod environments and trained onsite personnel in OA patch installation,
- analyzed and provided list of Patches necessary to bring OA up to acceptable level,
- deployed applications and database patches in all environments (Back to TechTOC)
Customizations
- tuned and revised existing customizations (forms, reports, executables)
- modified the FORTRAN State of Florida Box Culvert program to include metric calculations (Back to TechTOC)
Database Administration (Clones, Migrations, Separations)
- provided fundamental backup DBA support (DBO/DBA)
- split instances
- cloned production to secondary NT box
- provided plan and assisted in cloning Production OA instance to separate Unix box
- provided database administration including
- backups and backup scripts,
- restoration of corrupted datafiles and databases,
- copying databases,
- migration, cloning, splitting OA Test/Prod instances sharing a mutual home,
- writing and modifying initialization, configuration and control file creation scripts, profiles and shell scripts in UNIX and NT environments.
- assisted in Oracle database migration from Oracle 6.X – Motorola to Oracle 7.3 SUN Solaris;
- performed various database administration tasks as needed including analysis, development and implementation of role-based security systems, installation of tablespaces for new software
- Discoverer (Back to TechTOC)
Forms
- created new forms (Developer 2000), reports (Developer 2000 and SQLPlus) and interfaces (PL/SQL) to integrate with Applications. (Back to TechTOC)
LifeCycle
- reviewed and resolved outstanding installation issues (OA 11.0.3, WindowsNT 1 Hour Install, Production/Test on single box),
- identified and mapped multiple Web Server configuration structure and then repaired Self-Service Web Server,
- helped resolve miscellaneous technical issues.
- changed Inventory module from Shared to Full Installation,
- addressed Year2000 customization issues,
- designed, developed, modified and maintained the Oracle 7.3/SUN Solaris Unix/Oracle SQLFORMS Network Management System (NMS), SUNCOM Integrated Data Accounting and Order Entry System (SIDAOES), and related systems through coordination and support of all aspects of the software life cycle from design to development and reengineering.
- developed and documented standards and reusable components for RAD (Rapid Applications Development)
- designed, created and installed a standalone Microsoft Access/Oracle Developer 2000 data entry application interfaced with Oracle database for homebound employees.
- full software life cycle engineering including
- design, development and implementation of new database structures and applications,
- upgrade of existing applications with newer software development tool versions, modification and maintenance of older applications (Back to TechTOC)
Program Conversions
- converted and integrated the existing character-based NMS and SIDAOES systems, and created a GUI Windows/Windows95 interface using Oracle Developer/2000 (Back to TechTOC)
Upgrades
- assessed & performed applications upgrades (10.6 to 10.7, 10.7 CB to 10.7 NCA, 10.7 to 11.0, 10.7SC to 11i, 11.0 to 11i) (Back to TechTOC)
Archive Purge
- Identified, assessed and provided technical solutions in regard to archive/purge (Back to TechTOC)
Back to TOC
Functional Areas :
- set up and tested add-on multi-org operating unit (modules INV, WIP, BOM, ENG, AP, AR, PA, PO, OM, GL, OTM, HRMS, separate legal entity, shared set of books),
- added new organization (sharing set of books with other organization) to existing 11.0 ERP structure and set up, tested and documented Receivables, Payables, Order Entry, Cash Management, Purchasing, Inventory, Bills of Material, Work In Process and Purchasing Related Work Flow,
- set up Oracle 11 Inventory, Order Entry (including Drop Shipment), Purchasing and Receivables including Lockbox.
- set up and tested Internal Order Sourcing
- set up and tested Cross Company Project Accounting
- set up and tested Flexfields
- set up AutoInvoice, AutoReceipts, AutoReconciliation for Web Credit Card Payments from external system
- set up and tested additional pieces in OE and AR modules necessary for deposit/commitments, and recurring automatic payments.
- documented AR process from external interface to reconciliation,
- set up Inventory, corrected multi-org structure,
- wrote Inventory Documentation for further set up
- existing AR set up issues
Back to TOC
Techno-Functional:
- installed and set up Discoverer
- set up and tested Business Intelligence (multiple modules)
- set up and tested and implemented Timecards and Projects
- installed and tested Applications Desktop Integrator ADI (budgets and assets)
- installed, tested and created templates for Loftware label integration
- set up Oracle 11 Inventory, Order Entry (including Drop Shipment), Purchasing and Receivables including Lockbox.
- Worked with an integrated testing team on order and purchasing throughput under a tight go-live schedule,
- helped create customized solution for multiple warehousing and drop shipment,
- performed Human Resources, Receivables & general technical upgrade assessment (10.7SC to 11i).
Back to TOC
Management and Training
- managed legacy data import developer and user team
- lead and mentored super user team to test multi-org installation
- led information retrieval strategy groups
- led revenue recognition strategy groups
- created a company training plan for users of Oracle Applications including syllabi for 4 levels of Oracle Applications user classes, led the 1 st , 2 nd and 4 th level classes and trained the 3 rd level instructors
- trained Timecard, Discoverer, Business Intelligence and ADI users
- managed developers (on-site, off-site and off-shore) for custom report implementation.
- trained and mentored System Administrator and Database Administrator
- trained and led team of super users to test and approve multi-org
- as mentor, trained technical and functional users to set up and run processes in Production environment (as a forerunner solution to similar, upcoming company needs)
- held class for senior management explaining multiple organizations and multiple reporting currencies
- provided training in Discoverer and OA Administration.
- helped organize functional testing team and test plan for Production implementation,
- gave technical and functional lecture to company employees about the interrelation of Multi-Org, Global Accounting and Multiple Reporting Currencies as it pertains to their business.
- acted as mentor and trained DBA, System Administrator, OA System Administrator, OA Technical Support.
- trained onsite personnel in OA patch installation related problem solving strategies
- managed team including database administrator, developer, system administrator and functional superuser
- created training and orientation program for Oracle users.
- project team leader for technical and functional members of multi-org conversion team, migration team, upgrade team, maintenance team.
Back to TOC
|