Michael Johnson
26024 Stone Court, Westlake, OH 44145
Cell: [Send email to request phone number] 89-8367 Home: [Send email to request phone number] 99-2926
Email: [Send email using form at bottom]
OVERVIEW OF QUALIFICATIONS
• Over 19 years of Oracle ERP implementation and Oracle Application Development
and consulting experience in major industry sectors. Oracle Applications
experience with all Financial modules, plus more in Manufacturing, Order
Management and Distribution. An expert in Oracle Applications development.
• Certificated instructor and teach a wide variety of technologies, both Oracle
and non-Oracle.
• Perform custom development, modifications, interfaces and conversions for the
Oracle Applications. Use predefined open interfaces as well as custom APIs for
converting data or interfacing between modules.
• Perform development using Oracle Forms, Oracle Reports, SQL, PL/SQL and
Workflow Builder.
• Vast experience in database objects programming, such as packages, procedures,
functions and triggers.
• Perform project management and provide technical leadership to projects.
• Expert level experience and knowledge in Oracle’s Application Object Library.
• Oracle Application expertise ranges from Release 6.9 to 11i (11.5.10).
Limited exposure to R12.
PROFESSIONAL WORK EXPERIENCE
Position: Developer/Technical Team Lead, Brodart, Williamsport, PA
Duration: November 2003 to Present
• Developed Oracle functionality using Oracle Forms, Oracle Reports, SQL,
PL/SQL, database triggers, packages, procedures, functions and SQL*Loader.
• Technical team lead overseeing all client and contract developers.
Implemented development standards and infrastructure to support development, code
reviews and testing procedures.
• Created conversion programs for converting legacy data into the Oracle
Applications (GL, AP, AR, FA, JTF, PO, BOM, INV and HR), as well as real-time and
batch interfaces between Oracle and legacy systems.
• Created custom enhancements to the Oracle Applications.
• Created a high visibility form-based process that allowed the users to enter
and apply receipts across multiple operating units for their centralized payment
processing facility.
• Created custom pricing rules for use by Order Management and iStore.
• Enhanced standard Oracle 1099 process to allow the company to process 1099s
across multiple operating units for combined tax reporting.
• Enhanced standard Oracle AR Statement processing to allow the company to
process across multiple operating units. Additionally. Enhanced standard Cash
Reconciliation programs to allow for bank reconciliation across multiple
operating units.
• Created a card catalog printing system that allowed Brodart to print a variety
of required cards and labels from their bibliographic database for libraries.
• Trained the client’s IT staff in areas of the Oracle Applications and
development using Oracle Tools (forms, reports, SQL, etc). Trained the client on
use of programmatic installation of custom code using scripts and APIs.
Position: Technical Project Manager/Developer, ADVO, Inc, Windsor, CT
Duration: October 2002 to November 2003
• Technical project manager for the implementation of, and custom development,
for a full Oracle Applications 11i (11.5.8/11.5.9) implementation (all modules
Financials, CRM and Manufacturing).
• Managed project team consisting of over 100 developers and functional
consultants. Multi-million dollar budget.
• Created project infrastructure, communications plan, staffing plan, and
implementation plan.
• Created development infrastructure to include instance management, patching
strategy, development standards, development and test procedures, source code
control system, and code migration procedures,
• Estimated all development efforts as a result of gap analyses.
• Drove solutioning for technical detailed designs and architected solutions for
implementation.
• Managed conversions, development of interfaces, reports and extensions.
Converted data and interface modules using custom and predefined APIs.
• Architected and designed majority of all development work.
• Designed and developed numerous forms, reports, packages and procedures for
extensions to the Oracle Applications.
• Conducted design and code reviews for all development items.
• Modules included GL, AP, AR, FA, PO, CRM, OE, ONT, OKC, BOM, WIP, HR and FND.
Position: Developer, TMP Worldwide (Monster.com), Milwaukee, WI
Duration: March-2002 to October 2002
• Wrote technical design specifications and functional design specifications for
data conversions from Legacy systems into the Oracle Applications 11i.
• Developed data conversion programs/process for Suppliers, Customers,
Employees, AP Invoices, AR Invoices, AR Receipts and General Ledger balances and
details. Used custom and predefined APIs for converting data. Open interfaces
used where possible, otherwise developed validation routines to ensure data
followed Oracle guidelines prior to insertion. Used custom and predefined APIs
for interfacing.
• Created common toolbox application which included a customization to the
custom library. This toolbox allowed forms customizations based on data being
entered into a form, rather than implementing code changes in the custom library.
This feature was later implemented by Oracle in what today is known as Forms
Personalizations.
Position: Developer/Technical Team Lead, Automotive Finance Corporation,
Indianapolis, IN
Duration: December 1999 to March 2002
• Project consisted of implementing Oracle Financials with a custom billing
system.
• Developed numerous reports in Oracle Reports to run as concurrent programs.
Some reports designed to extract data from the Oracle Applications, some from
custom billing system, some combining the two systems.
• Modified the custom library to perform table-oriented modifications to forms
versus modifying the custom library every time. More than 20 major
customizations to the form were made possible without modifying a single form or
changing code in the custom library.
• Trained permanent staff in the use of Oracle technologies, including Oracle
Reports, Oracle Applications table structures and the use of the Oracle
Application Object Library.
• Open interfaces used where possible, otherwise developed validation routines
to ensure data followed Oracle guidelines prior to insertion. Used custom and
predefined APIs.
• Created Oracle Technical Tracking Application to track and manage
deliverables, such as development items, defects, help desk calls, testing
workflow, etc. Application consisted of several forms and reports and was run as
a module within the Oracle Applications.
Position: Developer/Project Manager, Lorain County Auditor, Lorain, OH
Duration: August 1999 to Jan 2000 (part time and concurrent with another
client)
• Performed upgrade of Oracle Applications from Release 9.4 to 10.7. Migrated
from MVS to NT environment.
• Created custom extension to the Oracle Applications to manage government
warrants, a government accounting function specific to Payables checks.
Extension included forms, reports and PL/SQL code.
• Managed this government implementation of Oracle.
• Trained the users in the new 10.7 functionality.
Position: Developer, Eaton Corporation, Cleveland, OH
Duration: June 1997 to November 1999
• Oracle Applications developer and development team lead.
• Developed custom reports using Oracle Reports.
• Developed reports and capability to print both letter and legal sized
documents from the Oracle Applications (something that the Oracle Applications
could not do). Reports were developed and integrated within the Oracle
Application Object Library (to be run as concurrent programs within the Apps).
• Modified the custom library to add customizations to forms without modifying
the actual forms.
• Designed and developed complete sub-system to handle corporation specific
purchasing policies.
Position: Project Manager, Southwestern Bell Mobile Systems, Dallas, TX
Duration: December 1996 to June 1997
• Project manager for implementation of the Oracle Applications, which was
already in progress.
• I was able to get the project back on track and managed the remainder of the
implementation.
• Smaller size/scope project and staff.
Position: Project Manager, Tupperware Corporation, Orlando, FL
Duration: February 1995 to December 1996
• Project manager and development team lead for implementation of Oracle
Financials. Client committed to the implementation with a Big-5 firm. I
subcontracted to SHL Systemhouse when they could not implement the Applications.
Implementation was for the entire US and Canada infrastructures.
• This was the biggest success of my career. Prior to my arrival, the client
was very unhappy with the IT provider (SHL). Under the auspices of SHL, I came
in, proved myself, established the proper framework and methodology for the
project, communicated with client on a frequent basis and, within a short time,
won over the client. This project was successful and the Finance portion (my
project) was implemented in record time.
• I coordinated with client counterpart and created project timeline and
implemented the Oracle Applications.
• Performed data conversion from Legacy systems.
• Developed numerous reports using SQLReportWriter, RPT and Crystal Reports.
Position: Developer, Unocal, Sugarland, TX
Duration: January 1995 to February 1995
• Designed and developed extensions to the Oracle Applications, which later
became the foundation for the Oracle Energy Applications.
Position: Developer, Torch Energy Advisors, Houston, TX
Duration: January 1995
• Minor assignment to create an interface for importing paid AP invoices into
the Oracle Payables system from a legacy system.
Position: Developer, Weatherford, Houston, TX
Duration: September 1994 to January 1995
• Designed and developed reports, forms and custom enhancements to the Oracle
Applications.
• Performed data conversions from Legacy systems (GL, AP, AR, RA, FA).
Position: Developer, Smith International, Houston, TX
Duration: December 1993 to September 1994
• Performed data conversions into the Oracle Applications from legacy systems
(GL, AP, AR and FA).
• Developed extensions to the Oracle Applications, primarily for reports and
custom check printing solutions.
Position: Developer/Trainer, CRS Sirrine, Houston, TX
Duration: May 1992 to November 1993
• Created custom billing program and integrated it with the Oracle Applications.
Billing application included numerous forms and reports, as well as a myriad of
SQL code for processing.
Position: Senior Oracle Financials Consultant, Savant Systems, Houston, TX
Duration: July 1991 to May 1992
• Provided project leadership and management skills.
• Provided development services using SQL*Forms, SQL*Report, SQL*Plus and
PL/SQL.
• Designed and developed applications under Oracle’s Application Object
Library.
• Developed and implemented data conversion utilities.
• Modules of expertise included Oracle AP, GL, AR, RA, FA, PO, and OE.
• Developed implementation plans for Oracle Financials.
• Provided business accounting procedures and principles regarding AP, GL and
purchasing efforts.
• Provided background technical information on Oracle Financials.
• Provided full range of classes on Oracle Financials and tools.
• Major clients included Houston Metropolitan Transit Authority, Compaq Computer
Corporation, ARCO International Oil and Gas, the Environment Protection Agency
and British Petroleum America.
• Subcontracted to Oracle Corporation for development and training.
Position: Oracle Financials Developer, Marathon Oil Company, Hou, TX and
Damascus, Syria
Duration: November 1989 to July 1991
• Project leader and assistant project leader for internationally located oil
exploration and produc¬tion offices.
• Posi¬tion included the development, maintenance and enhancement of petro¬leum
financial applications and utilities.
• Provided installa¬tion, training and support for com¬mercially available PC
based applica¬tions.
• Developed new and modified existing applications using Oracle and “C”.
• Created and maintained user and technical manuals for these applications.
• Oracle applica¬tions involved the use of SQL*Plus, SQL*Forms and SQL*Report.
• Novell Netware 286 and 386, Novell Access Server, OS/2 Requester, Oracle
Server for Net¬ware and remote bridges used in network opera¬tions.
• Oracle Financials included General Led¬ger, Accounts Payable, Fixed Assets and
Purchas¬ing.
• New systems developed included Joint Venture Billing systems, AFE Reporting
systems, Expatriate and National Payroll systems, Cost Allocation systems and
Foreign Customs Reporting systems.
• Traveled internationally to upgrade systems and applications, as well as train
and support users, sys¬tem administrators and pro¬gramming staffs.
• Designed, installed, supported and maintained Local and Wide Area Networks,
which in¬cluded remote bridg¬ing, multiple servers and distributed databases.
• Performed Novell network system admin¬istration.
• Job require¬ments in¬cluded performing as Computer Services Supervisor in
inter¬national field offices when the perma¬nent supervisor was out of the
country for extended periods.
Position: Systems Analyst/Programmer, OmniVision, San Diego, CA
Duration: May 1989 to November 1989
• Designed, devel¬oped and installed software applications for the Federal
Government and the private sector using a myriad of programming languages,
primarily FoxBase, Informix and Oracle.
• Analyzed, reviewed and modified exist¬ing software applications. Applications
included Legal Systems Management, Real-Time Outfitting Manage¬ment Informa¬tion
System (RO¬MIS) for new construction and major overhaul of Naval vessels,
relational database manage¬ment systems and ac¬counting and inventory systems.
• Monitored all programming projects and ensured projects were com¬pleted within
appropriate time frames.
• Trained programming staff.
• Analyzed, devel¬oped and re¬viewed systems using bar¬code readers and
scan¬ners for inventory and electronic point of sale systems.
Position: Marine, United States Marine Corps, Worldwide
Duration: February 1981 to April 1989
• Various duties while serving abroad for eight years.
• Volunteer instructor and program evaluator for Computer Train¬ing Center for
the Phys¬ically Chal¬lenged, San Diego State University - 1989.
• Traveled extensively overseas.
EDUCATION / OTHER
• Enrolled, M.S. Professional Aeronautics, Embry-Riddle Aeronautical University,
Daytona Beach, FL
• B.S. Computer Science, National University, San Diego, California: 1988
• A.S. Computer Science, San Diego State University, San Diego California: 1985
• HS Diploma, Houston Christian School, Houston, Texas: 1979
• Certificate, TEFL, Teacher of English as a Foreign Language, International
TEFL Teacher Training, 2005
• Certificates, Oracle Training Courses, Oracle Corporation, Houston, Texas:
1990-2005
• Introduction to Oracle for Developers • Introduction to Oracle
Applications
• Oracle Applications System Administration • Setup and Using Oracle
General Ledger
• Oracle General Ledger: A Technical Perspective • Setup and Using
Oracle Receivables
• Oracle Receivables: A Technical Perspective • Setup and Using Oracle
Assets
• Oracle Assets: A Technical Perspective • Setup and Using Oracle
Purchasing
• Oracle Purchasing: A Technical Perspective • Setup and Using Oracle
Payables
• Oracle Payables: A Technical Perspective • Setup and Using Oracle
Revenue Accounting
• Oracle Revenue Accounting: A Tech. Perspective • Defining Flexfields
• Setup and Using Oracle Alert • Setup and Using Oracle Work in
Process
• Oracle Work in Process: A Technical Perspective • Setup and Using
Oracle Engineering
• Setup and Using Oracle Inventory • Oracle Inventory: A Technical
Perspective
• Setup and Using Oracle Order Entry • Develop w/Oracle Application
Object Library
• Develop Reports w/Reportwriter 1.1 • Setup and Using Oracle Bills of
Material
• Oracle Database Architecture Version 6 • Oracle Database
Administration Version 6
• Implement Oracle Server for OS/2 • Oracle Reports 2.5
• Oracle Financials Technical Workshop • Oracle BAP Product Features &
Positioning
• Oracle BAP Sales and Licensing • Oracle Discoverer 10g: Creating
Queries & Reports
• Certificate, Oracle Financials Master (Application User), Oracle Corporation,
Houston, Texas: 1990
• Certificate, Oracle Financials Master (Applications Developer), Oracle
Corporation, Houston, Texas: 1993
• Completed, SCUBA School, SEAL Training Center, Naval Station, Coronado,
California: 1981
• Completed, Parachutist School, 1st ReconBn, 1st MarDiv, Camp Pendleton,
California: 1981
• Completed, Basic Infantry Course, Infantry Training School, MCB, Camp
Pendleton, California: 1981
• Graduated, U.S. Marine Corps Recruit Training, MCRD, San Diego, California:
1981
• Completed, FAA Airframe/Powerplant Mechanic Crs, Houston Community College,
Houston, Texas: 1980
CITATIONS/AWARDS
• Navy Commendation Medal w/Gold Star: 1985,1989 • SCUBA Badge: 1983
• Navy Achievement Med¬al: 1984 • Good Conduct Medal: 1985, 1988
• USMC Overseas Service Ribbon: 1988 • Parachutist Badge: 1983
• Expert Rifle Badge w/awards: 1982, 1984 • Sea Service Deployment Ribbon:
1984
• Expert Pistol Badge w/awards: 1983, 1984
|
