Welding Services Inc Upgrade to 11 5 10

Welding Services Inc. Upgrade to 11. 5. 10 April 15, 2005 Presenters: Doss Kuppuswamy – Project Lead, Welding Services Chris Romac – Project Lead, TITAN Technology Partners Paul Frangoulis – Project Manager, TITAN Technology Partners Page: 1

What you will get from this Presentation Ø Review project strategy that led to the successful migration at Welding Services, Inc. o o o Oracle Application upgrade from R 11. 0. 3 to R 11. 5. 10. Hardware and operating system change from NT to UNIX (Sun Solaris). Database upgrade to 9 i. Ø Review functional and technical successes and challenges, training, and approach to global rollout. Ø The project was completed in 12 weeks, on time and on budget. Ø This was one of the first migrations to R 11. 5. 10 in the country. Ø Specific applications include General Ledger, Payables, Purchasing, Project Costing, Inventory, and BOM. Page: 2

Welding Services , Inc. (WSI) Company Background Ø Established in 1978 to respond to the aggressive buildup of power plants in North America. Ø WSI first introduced advanced tooling technology (in the form of automated orbital welding equipment operated by the company’s specialized field craftsmen) to the nuclear construction industry. Ø By the mid-1980 s, WSI had developed specialized equipment for repairing steam generators, pressurized water reactors, and various other pressure parts, as well as highly automated tooling for other nuclear-related repair work. In 1984 and 1985, in an effort to expand diversify the business, WSI targeted refinery/petrochemical, fossilfueled electric utilities, waste-to-energy plants, and pulp and paper facilities, effectively expanding the reach of WSI’s engineered solutions and specialized capabilities. In 1989, the company relocated to a larger facility in order to accommodate the demands of its growing business. In 2002, the company relocated once again to its new 175, 000 square-foot technology center. Ø The significant potential in the technologies and service capabilities of Welding Services, Inc. was recognized by First Reserve Corporation (USA), a leading private equity investment firm focused on opportunities in the energy industry. Its acquisition of WSI in 2002, and the creation of a parent organization, Aquilex Services Corp. , set the stage for accelerated growth in both resources and service capabilities. Ø Over the past decade, WSI has continued to refine and expand the original premise of providing advanced tooling technologies and a highly specialized craft workforce to serve the needs of its clients. Over the same period, WSI’s Repair Technologies business unit has developed, implemented, and now continues to offer, as part of day-to-day operations, over 30 engineered tooling solutions that are applicable to a wide range of industries. Ø Today, Welding Services, Inc. is one of the largest specialty mechanical maintenance contractors in the world, providing field and shop maintenance services to power, nuclear, chemical, pulp and paper, and similar heavy industries. With domestic and international sales offices and shop locations, WSI can quickly respond to emergency repair situations or efficiently respond to scheduled contract maintenance requirements. WSI solutions automate routine, tedious, and quality-critical maintenance practices, substantially improving the quality of repairs, the productivity and safety of personnel, and the performance longevity of repairs and upgrades. Page: 3

TITAN Technology Partners Company Background Ø TITAN is headquartered in Charlotte, NC, and is focused on Oracle and Strategy solutions. Ø TITAN Technology Partners is a full-service IT outsourcing consulting firm which provides: o o Ø Strategy Enterprise Professional Services Enterprise Managed Services IT Outsourcing The core of TITAN's Value Proposition is: o o o TITAN TITAN Leads with Strategy Emphasizes Speed to Value (S 2 V) Delivers a Superior IT Outsourcing Model Specializes in ERP Solutions Delivers High-Quality Solutions through our Quality Framework(TM) Empowers Excellence as an Employee-Owned Company Ø TITAN's S 2 V (Speed to Value) approach focuses on delivering tangible business results rapidly, then extending and maximizing your IT investment over the entire solution life-cycle. Ø Clients can leverage our Oracle Solutions Center with all Oracle applications running. Ø Our vision is to offer an unmatched value proposition by being the best at providing business solutions and managed services for our clients. Page: 4

Project Objectives Ø Overall Objectives o o o Ø Technical Objectives o o Ø Get WSI on a supported Oracle platform as quickly and inexpensively as possible. Provide the ability to deploy new features now available. No change to business processes, no additional modules. Improve backup procedures, improve system performance if possible. Determine and note process improvements as project unfolds. Minimize impact to business users and (already overloaded) IT staff. Upgrade from R 11. 0. 3 to R 11. 5. 10. Upgrade database to latest version of 9 i. Change hardware and operating system from NT to UNIX (Sun Solaris). Install Veritas Net. Backup and activate main stream features. Sidebars o o Recent WSI reductions in staff. New CFO who had a negative IT experience with previous company. Page: 5

Applications Upgraded Ø Application modules upgraded to R 11 i. 10 included: o o o o o Ø General Ledger Payables Receivables Fixed Assets Purchasing Inventory Project Accounting BOM ADI The following localizations will also be migrated: o o Ø Oracle Oracle Oracle Europe Netherlands Technology and Database o o o Sun Solaris V 880 (sized appropriately for Oracle 11 i applications and data) partitioned to support multiple instances Oracle DB 9 i (transactional volume to support approximately 50 users) Two (2) instances of the Oracle applications will be migrated: Development and Production Page: 6

Project Challenges Ø Moving from R 11. 0. 3 to R 11. 5. 10 was a 6 year Technology leap Ø Concern over R 11. 5. 10 - This was one of the first R 11. 5. 10 upgrades Ø Complexity due to Platform move from NT to UNIX Ø Amount of planned time for migration had to be 48 -72 hours to avoid shutting down the business Ø Migration of custom reports and programs Ø Bad data Ø Creating proper test scripts Ø Ramping up key users on changes from R 11. 0. 3 to R 11. 5. 10 Ø Noetix 5. 3 (reporting) wasn’t certified against 11. 5. 10 until February 2005 Ø Oracle Apps was interfacing with multiple VB programs and one program in PERL Ø Meeting Project Budget and timeline Ø Communication and training with European team Ø Working through the year-end holidays Page: 7

How we did it Page: 8

How we did it 1. Migrated Oracle application from 11. 03 to Oracle 11. 5. 10 (completed 4 Test runs) 2. Upgraded Oracle e. Business Suite database to 9 i 3. Migrated from NT to Unix, Sun Solaris 4. Installed new Unix OS onto two (2) new servers and conducted re-sizing 5. Developed hot and cold backup strategy 6. Developed scripts for backup execution 7. Installed Veritas Net. Backup on two (2) servers 8. Installed Veritas Data Base Addition For Oracle 9. Provided training on features of new release for functional users 10. Non-Oracle customizations were handled by WSI 11. Noetix was Upgraded to 5. 4 prior to Go-Live Page: 9

Key Issues Ø Oracle TAR Summary Ø Total Number of TARS opened over 13 Week Project Page: 10

Major Issues Ø TAR /Application Setups o o o o Ø Data issues with Shared HR tables Netherlands Foreign/Domestic Payment Localization Cost Rollup in Inventory Project Streamline Processes Project Credit Memos against converted invoices Printer Configurations Pop-Up Blocker issues Customization Migration o o o Migration of All Package extensions went well - Followed Accepted Customization Procedures Custom SQL Loader Routines updated to handle new Interface requirements PO Report required Developer to migrate specific customization to new 11. 5. 10 Report as opposed to migrating 11. 0. 3 Customized report to 11. 5. 10 Page: 11

Lessons Learned Ø Make sure you have executive sponsorship for project Ø It takes both functional and technical experience Ø TUMS is great! Ø Watch those custom reports and programs Ø Involve every business group effected Ø Plan well Ø You can’t test too much – repeat upgrade at least 3 times Ø Get your timing down by repeating the upgrade Ø Oracle application Quality level has improved more then we expected Ø Make sure you have the knowledge transfer from the consultants Ø Liked the Fixed Price option for migration from TITAN Page: 12

Some of the Benefits Ø No need for frequent System Reboot Ø No more hanging toolbar Ø In the latest application release for any future rollouts Ø Better search capabilities in Projects screens Ø Notification feature for concurrent report completion Page: 13

What’s Next Ø We have already begun to leverage new features with existing applications and now have access to additional applications as justification warrants Page: 14

Questions ? Page: 15