R.Kupcunas Resume

Resume of  Richard Kupcunas

 

 

 

 

Richard 'Rick' Kupcunas

 

Firm:

RKupcunas@Deloitte.com

Director

 

Personal:

Rick@Kupcunas.com

 

 

 

 

Deloitte Consulting LLP

 

Home:

+(00) 1.817.859.1047

Suite 800

 

US Cell:

+(00) 1.214.335.1062

2200 Ross Avenue

 

Client Office:

+(00) 1 512 542 8082

Dallas, Texas 75201

 

Office:

+(00) 1 214 840 1770

USA

 

Fax:

+(00) 1 866 634 5129

Deloitte Consulting; Aug 2003 - Present

Competency Director - Oracle Architecture, Infrastructure and Technology

RELEVANT EXPERIENCE (with Deloitte)

Mr. Richard Wm. Kupcunas is a Director within Deloitte Consulting's Technology/Oracle practice. Recognized as the technology and knowledge leader with respect to Oracle database, infrastructure, integration and application server technologies... using these technologies he has continued to address our client's problems and deliver true business solutions.

His experience includes over 26 years of system/application development dedicated to all phases of a system's lifecycle.  Over the past years, Rick has been dedicated to the implementation, tuning and optimization of large-scale Oracle production databases as well as the management of numerous Oracle e-Business and PeopleSoft implementations.  Responsibilities include coordination, design, construction, implementation, tuning, benchmarking and the population of applications of all sizes - specializing in very large database (VLDB) design, ERP implementations and internet-based applications. Post-production support tasks have involved the tuning and optimization of the database, as well as operating system, application, and process tuning to yield the optimum performance for the end-user.

Rick has extensive experience designing technical architectures using traditional software engineering, CASE development tools and several well-proven system life cycle methodologies. His experience includes MVS, VMS, UNIX, Linux, NT and PC network systems and he has worked in a variety of client/server, web-based and distributed environments in recent years. In addition, he has been involved in numerous engagements that involved the selection of the server, database, network, and application package to best serve the client's needs.

Rick has worked in both a leadership and technical position creating innovative solutions by applying technical expertise in application construction and tuning, system administration, database administration, data modeling, benchmarking and overall system enhancements. His abilities include project definition, project management and all deliverables associated with a system's life cycle.

Rick's background include single and multi-processor UNIX, Linux, MVS and VAX systems as well as numerous various Microsoft Windows systems, using a variety of popular network protocols. During his tenure, he has specialized in the development, tuning and optimizing of many Oracle applications—some applications exceeding a 300 terabytes in size. He has been involved in the tuning of decision support, ERP, CRM, and custom applications, as well as numerous data warehouse applications from an Oracle database, system administration, and process engineering perspective.  Rick has also worked with other relational databases such as Ingres, IBM's DB2, SQL*Server and Sybase.

He has experience in providing services and products for many business areas including telecommunication, accounting, utilities, consumer business, financial, investments, HMO and hospitals, manufacturing (chemical, automotive, high-tech and pharmaceutical), banking, insurance, engineering, energy exploration and production, software development, Public Sector and product development

Corning - PRISM Project - Corning, NY

Description: Corning Incorporated currently has twenty-four of its business units live on separate, independent instances of PeopleSoft SCM Version 8.0. These applications support Corning Incorporated's business operations on a global basis, with major centers of operation in the Americas, Europe and Asia.

Over the course of approximately the next three years, Corning Incorporated intends to upgrade and consolidate the twenty-four independent PeopleSoft Supply Chain 8.0 instances on to a single instance of PeopleSoft Supply Chain 9.0, including the standardization of business processes and configurations, and the introduction of a new internal infrastructure environment to host the new instance.

Initial phase of the project was to design an infrastructure environment that will enable Corning Incorporated to build the future infrastructure/hosting environment for Corning's global PeopleSoft solution.

Role: Rick's primary role was that as the lead technical architecture to design, procure, and define the projects ultimate infrastructure platform. As technical lead for all technical components of the project; this role included being the lead architect of the system, coordination and administration of the various servers, coordination and administration of the various software components and infrastructure testing of the application once implemented. Significant portion of Rick's responsibilities dealt with the definition of the architecture platform which will support the upgrade environment. 

Working with various vendors, performing sizing activities and evaluating the hardware options it was recommended that Corning leverage Oracle's engineered solutions specifically two Exadata and two Exalogic racks.  System was architected to be 99.999% available with redundant connected via a high-speed infiniband network; all aspects of the application's architecture were considered from performance to cost to long-term ROI. 

Rick's responsibilities included:

  • Manager of eight technical resources to define the proposed architecture
  • Managed a highly-technical, deliverables based project; some deliverables generated were:
    • Technical environment design
    • Capacity and sizing recommendations
    • Backup & Recovery Specifications
    • High-availability Strategy and Design
    • Interfacing System Requirements
    • Data Archiving and Purging Strategy
    • Formal Bill of Material Specifications (w/negotiated hardware pricing)
  • Coordinate of upgrade of PeopleSoft from 8.0 to 9.1 for supply chain; upgraded to PeopleTools 8.52
  • Definition of interface and RICE standards
  • Performed POC comparing HP servers to Exadata/Exalogic server

Lead architect responsible for the implementation and coordination of the Exadata/Exalogic servers, installation of the PeopleSoft environment as well as the building of the Reporting environment using Oracle's GoldenGate technology

Oracle Products used in the solution

  • Oracle Exadata v2
  • Oracle Exalogic v2
    • Oracle Exalogic Elastic Cloud Software
    • Oracle Coherence
    • Oracle Traffic Director (OTD)
  • PeopleSoft FSCM 9.1 with PeopleTools 8.52
    • PeopleSoft Supply Chain
    • PeopleSoft Data Archive Manager (DAM)
  • Oracle RDBMS 11gR2
    • Data Guard
    • Advanced Compression
    • Partitioning
    • Real Application Clustering (RAC)
    • Oracle Grid Control
    • Oracle Enterprise Manager 12c
  • Oracle GoldenGate
  • Oracle Enterprise Linux (OEL)

Environment: Oracle Exadata and Exalogic servers running OEL 5.7; GoldenGate; Oracle 11gR2 RDBMS

Application: Oracle PeopleSoft 8.0/PeopleTools 8.17 upgraded to PeopleSoft 9.1/PeopleTools 8.52

State of Texas - Project One - Austin, TX

ProjectONE is a groundbreaking effort that will create the foundation for a single set of books for Texas government. The many benefits to the state include the following:

  • One destination for real-time reliable information,
  • A "single source of truth" reducing conflicting data, and
  • Better tracking and standardization of financial information.ProjectONE is led by the Texas Comptroller of Public Accounts and encompasses other initiatives to integrate data and processes into more cohesive and standardized systems for the highest levels of efficiency.

The resulting system will provide the model for the tools to shine the brightest light on the state's finances, give decision-makers seamless access to state data and allow the state to make better use of the data at its fingertips. It will also reduce intensive manual effort in key business processes such as asset management and procurement while improving inter-departmental and inter-agency communication.

Role: My primary role was the project's technical lead for all technical components of the project; this role included being the lead architect of the system, coordination and administration of the various servers, coordination and administration of the various software components and lead of the RICEW (development) team. Significant portion of my responsibilities dealt with upgrade and retrofit of custom software into a PeopleSoft 9.1 environment, coordination of custom development objects and the tuning, optimizing and streaming the online component of the application. 

My responsibilities included:

  • Coordinate of upgrade of PeopleSoft from 8.3 to 9.1 for HCM; 9.0 to 9.1 for financial; both upgraded to PeopleTools 8.52
  • Review database code, tune appropriately and identify performance issues within existing application (non-Oracle system)
  • RICE development – functional and technical specifications, cod and unit test and performance testing
  • Devise architecture and infrastructure strategy to improve the systems expected user load and deliver the required service level agreements (SLAs)
  • Managed a team of twenty-two technical development resources as well as a team of six testers
  • Knowledge of PeopleSoft and how to design, implement and perform the gap analysis to perform the necessary tasks within PeopleSoft Financials 9.1

Texas SmartBuy - Austin, TX

TxSmartBuy project was developed by the Sate to control the purchasing and procurement of products within a centralized state-wide ordering system.  TxSmartBuy is an online ordering system from the Texas Comptroller of Public Accounts (CPA) that offers enhanced searching and ordering functionality to state and local government purchasers to place orders against current State of Texas term and TXMAS contracts. Accessing both internal and external (aka punch-out) vendors, users of the system are able to access over 800 vendors catalog and procure items at negotiated prices.  Benefits of the system allows users to:

  • Easily search and browse contractor e-catalogs for price and product information
  • Vendors are selected via the user's geographical region
  • Use comparison tools to review price and product details side by side for best value
  • Select and purchase items via an online shopping cart
  • Contractors receive purchase orders immediately
  • Items selected are automatically updated within the ordering procurement system (Oracle eBusiness 11i)
  • The key business objectives for the SmartBuy program were:
  • Consolidated financial data, improved tracking, reporting and controls
  • Reduction of manual processes and reconciliation between systems
  • Streamlined purchasing process, reduced cash cycle
  • Improved inventory control, cost reductions and reduced procurement costs to the State
  • Better spend control and management of tax payer dollars by monitoring purchases as well as offering lower negotiated prices to the end-useRole: My primary role was the project's technical lead for all technical components of the project; this role included being the lead architect of the system, coordination and administration of the various servers, coordination and administration of the various software components and lead of the RICEW (development) team. Significant portion of my responsibilities dealt with coordination of third party products (Vinimaya) and the tuning, optimizing and streaming the online component of the application.  End-user access was via the Vinimaya search engine which is a java based application which queried catalog data within an Oracle 10g database.  Once entered, the order was then transferred to iProcurement where the transaction was posted within an Oracle eBusiness 11.5.10 application and fed to other applications within the Texas Online application.

My responsibilities included:

  • Review database code, tune appropriately and identify performance issues within existing application (non-Oracle system)
  • Devise architecture and infrastructure strategy to improve the systems expected user load and deliver the required service level agreements (SLAs)
  • Implement and streamline catalog upload and maintenance functionality; modified search criteria to use to Oracle Text to enhance query performance and functionality
  • Lead the enhancements to an existing Oracle eBusiness Application – some code developed onsite some offshore by third party vendors (Vinimaya)
  • Managed a team of eight technical development resources as well as a team of six testers
  • Able to work with a small software vendor, State of Texas resources and NIC (who manage the servers)
  • Knowledge and ability to design and implement a promotion process for both Vinimaya and Oracle eBusiness
  • Knowledge of Oracle iProcurement and how to design, implement and perform the gap analysis to perform the necessary tasks within Oracle eBusiness
  • Able to coordinate enhancements, keep costs to a minimum, satisfy the client's requests and address application issues

SUN Microsystems - Santa Clara, CA

Created functional automation and performance testing strategies for the project.  These strategies outlined the approach and tasks required to develop and conduct successful testing solutions.   In addition, crafted test plans, project work plans, defect and issue management strategies, and also deployed QA Center of Excellence for the client.  Demonstrated leadership skills by providing guidance, mentorship, and motivation to the team members. Under my leadership, the team was able to meet every major milestone and deliver quality results conforming to the client's requirements and expectations. The team developed over 121 Mercury BPT Test Plans and Load Runner scripts, conducted over 20 functional automation and performance tests, and identified functional issues and performance bottlenecks.  Identified over 265 production go-live issues that had to be addressed prior to our production implementation.  Developed a strong working relationship with the client by providing sound advises on the functional automation and performance testing subjects (functional automation and performance testing strategies, planning, execution/control, and deliverables), demonstration of technical capabilities, and responding to client's requests with a sense of urgency and delivery upon promised.  Facilitated defect management, performance testing, integration testing, and UAT testing sessions.  Analyzed defects and issues to provide sound advice and resolutions.  Managed a cross functional team of manual testers, automation engineers, functional specialists, and performance tuning specialists. 

Builder Cabinet Group/Masco - Adrian, MI

Deloitte was engaged to assist Builder Cabinet Group (BCG) in the delivery of their Oracle ERP transformation project to support the company's strategy of cross selling across multiple trades/product lines, inventory control, effective scheduling and tracking of resources, process standardization and shared services implementation across 5 manufacturing locations in USA. The Oracle implementation covers numerous ERP modules, including Financials, Order Management, Quoting, Configurator, Inventory, BOM, WIP, Cost, Procurement, iProcurement, Incentive Compensation, Configurator, custom scheduling and dispatch module, custom data collection applications (Intelliquote).

Role: BCG's technology domain comprised of various disparate systems along with a host of technology components adopted over the years with a spaghetti web of point-to-point integrations and custom development.

The key business objectives for the BCG program were:

  • Consolidated financial data, improved tracking, reporting and controls
  • Reduction of manual processes and reconciliation between systems
  • Streamlined purchasing process, reduced cash cycle
  • Improved warehouse productivity, consolidated orders, exception management, and reduced inventory costs
  • Improved manufacturing plant utilization and productivity
  • Improved job tracking, reconciliation, and increased profit

Primary role was the project's technical lead for all technical components of the project; this role included being the lead architect of the system, coordination and administration of the various servers, coordination and administration of the various software which include the Oracle eBusiness Suite R12, Oracle 10g database, Oracle 10.1.3 Application Server, Demantra, OTM, MSCA, Rightfax, as well as the management of our 300+ custom RICE components. Responsible for application testing, performance testing of the environment, streamlining of existing workflows,  optimization and tuning of both the custom and Oracle delivered functionality

In addition, the team leveraged several database technologies offered by Oracle:

  • Oracle eBusiness Suite Release 12
  • Able to use the full features of the Oracle 10g database
  • Implemented Oracle Real Application (RAC) technology for high availability and increased throughput
  • Oracle's Grid technology to manage the network
  • Oracle Automated Storage Manager (ASM) to manage the storage requirements of the system
  • Oracle Data Guard for replication of the database to our disaster recovery environment
  • Implemented Oracle's cluster technology to distribute the load among multiple application servers
  • Oracle's OID, OIM and SSO technologies for the provisioning of users

MASCO Contractor Services - Daytona Beach, FL

For Masco Contractor Services (MCS), served as lead Oracle e-Business Technology Lead responsible for all technical tasks such as Oracle eBusiness architecture, infrastructure, application technical support, hardware/software installation, configuration, patching and development lead of all RICE (Report, Interface, Conversion and Extensions.  Acted a lead advisor with respect to all Oracle eBusiness issues such as release planning, system optimization, project management, and client interfacing.

  • Configured numerous Oracle e-Business Environments for preliminary testing and configuration.
  • Coordinated well over 250 different RICE components from designs through development through testing
  • Optimized the existing systems to support the development, testing and production environments throughout the United States.
  • Created numerous documents for discussion purposes around patching, migration, security, optimization and overall system support.
  • Managed worldwide team with resources in India (R10), Florida and remote locations throughout the United States.

Diebold - North Canton, OH

For Diebold, served as lead Oracle e-Business Technician responsible for all technical tasks such as Oracle eBusiness technical support, hardware/software installation, configuration, patching and deployment.  Acted a lead advisor with respect to all Oracle eBusiness issues such as release planning, system optimization, project management, and client interfacing.

  • System consisted of a single 1.5 Terabyte database hosted on a single HP-8420 24-way server; four Linux Red Hat Application servers load Balanced using F5's Big IP load balancing appliances.
  • Configured numerous Oracle e-Business Environments for preliminary testing and configuration.
  • Optimized the existing systems to support the development, testing and production environments to support Europe, Middle East and Africa operations.
  • Created numerous documents for discussion purposes around patching, migration, security, optimization and overall system support.
  • Managed worldwide team with resources in India (R10), Tulsa and North Canton, Ohio.
  • Coordinated patching activities for client's monthly outage; client allowed a single 24-hour patching window which required patching single database tier and four application tiers.

UK-NHS - Leeds, England, Great Britain

United Kingdom's National Health Services, NPfIT, the biggest Information Technology project in British history, is to provide electronic patient-care records, appointment-booking, broadband access and more, by linking every National Health Service (NHS) site in England. It involves 270+ health trusts, 18,000 sites, 28,000 hospital doctors, over 30,000 general practitioners, and 50m potential patients. Already contracts worth over £6 billion have been placed.

Contributions:

  • Participated in the development of and adherence to DBMS standards firm wide; managing the Oracle 9.2.0.4 to 9.2.0.6 database upgrade, coordinating the Oracle 9.2.06 to Oracle 10gR2 upgrade effort -  required a significant amount of Oracle expertise in that we had several databases in excess of  25 Terabytes
  • Implemented Oracle Discoverer as an inexpensive way to view information rather then costly custom solutions
  • Significant enhancement of programme structure, processes and life cycle methodology; Implemented a predictable, realistic and budget conscious delivery capability where teams and individuals have and understand their accountabilities; Established robust programme processes to support continuous and sustainable change.
  • Defining programme wide SDLC processes with clear quality gates and supporting artifacts to provide traceability, rigor and predictability to programme delivery; Defined key programme wide processes for planning, reporting, risk and issue management, change control and quality; Detailed Acceptance and Assembly processes developed to package 'releases' and make deployment more predictable and reliable.
  • Created new Requirements Management function acknowledging the need to understand and elaborate the customers' requirements, first and foremost, before designing or developing the system. Reorganized teams to place 'business focused' Functional Lead on each team within Requirements Management to shift focus from only technology to a balanced view of business requirements followed by technical modeling. One of the initial outcomes was the establishment of formal requirements for authentication, therefore a means to demonstrate that the system does/does not meet requirements.
  • Established the Technical Directorate (TD) which has increased the focus of the programme on architecting the system appropriately. The new TD provided a consistently defined technical architecture and a higher degree of certainty on costs as we architect a system that meets requirements. As an example of a key technical architecture change that will have a dramatic impact, the TD has identified, run a successful proof of solution, and led the deployment for the addition of XML and SSL hardware accelerators that will avoid millions of pounds being spent on additional Sun servers to enable the messaging component  to scale.
  • Improved capture of business volumetric and business assumptions (e.g., rollout schedules) to model level of system usage and provide Technical Directorate with input for capacity planning.
  • Improved Operations through proactive availability, performance, and capacity management; implemented more robust Change review/ control and Problem Management processes to improve mean time to repair (MTTR), reduce recovery times, and increase service availability; piloted 'Service Owner' (single point of accountability for a service product) concept within several sub-systems to address availability issues in Production resulting in improved availability & performance; set-up SWAT teams to resolve high priority system issues to improve problem resolution, recovery times, availability and performance.
  • Implemented improvements around financial management included: a tighter control on costs and other financial management processes; baselining of cost to complete infrastructure and service management costs and identification of areas we can reduce costs and increase our level of service

United States Marine Corp - Washington, DC

For the Unites States Marine Corps (USMC) developed a prototype logistical system using Oracle's eBusiness Suite (11.5.10) as the foundation of the application.  Once operational the Oracle system will be used by 7,500 Marines around the world in environments ranging from U.S. bases to foreign theaters of war; in subsequent phases, it will expand across the entire Corps. Lead all technical components of the scoping, planning, design, and construction of the system which was eventually previewed by the Corps.

  • Sized, priced and procured the required hardware platform to accommodate the initial installation of Oracle 11.5.10 e-Business suite.
  • Configured two Dell 6420 Linux 11i servers to support the USMC application; servers were designed to be mobile so that the primary and secondary servers could follow a battalion as the forces advanced within a theater of operation. 
  • Implemented and configured Oracle's mobile supply technology to allow the upload/download of information using both Palm and Window-CE clients.  These devices were designed to allow the warfighter to request supplies without being connected to the centralized server.
  • Responsible for the patching of the application, database and operating system. Loading ancillary software such as PVCS, WinRunner and Oracle Developer.
  • Conducted comprehensive benchmark tests to ensure that the existing hardware would support the required user and transaction load.  Performed additional test to ensure the hardware would support various physical tests and that the hardened case is capable of supporting the portable server environment.
  • Lead architecture responsible for numerous RICE components; led a team of six resources in which we integrated Oracle Portal into the Oracle eBusiness Applications as well as several Reports (5), Interfaces (3), Conversions (2) and Extensions (6).

ACCO Office Supplies - Chicago, IL

For ACCO (Global manufacturer and distributor of office products), served as lead Oracle e-Business Technician responsible for all technical tasks such as hardware/software installation, configuration and deployment.  Performed hardware tasks such as server sizing, assisting with selection, procurement, installation and configuration of the operational servers. 

Served as lead DBA responsible for the installation, configuration and maintenance of several (as many as 11 at one time) Oracle 11.5.9 e-Business environments  Responsible for managing both on onsite and offsite development team which created 170 custom deliverables for ACCO.  Performed software tasks such coordinating our custom software implementation strategy, version control, backup&recovery, patching (application and migration), software migration, UNIX system administration, Oracle e-Business administration and managing our custom software standards.

  • Sized the required hardware platform to accommodate the initial installation of Oracle 11.5.9 e-Business suite with the ability to support General Ledger (GL), Payables (AP), Receivables (AR), Inventory (INV), Shipping/Receiving, Order Management (ONT), Trade Management, Warehouse Management (WMS), HRMS and payroll.
  • Configured two HP-8410 HP-UX 11i servers to support ACCO's initial development environment; later, these environments were migrated to internal ACCO supported servers.  Once migrated, the application consisted of 4-HP rp8420's each with eight processors and 16 GBytes of memory.  These servers were connected to an EMC Symmetric containing 2+ terabytes of physical storage.
  • Devised and managed the instance strategy for the implementation of ACCO's Oracle e-Business suite of products.  Devised mechanism and procedures to perform the clone of the existing production environment upon demand (<4 hr turnaround).
  • Responsible for the patching of the application, database and operating system.
  • Responsible for all Oracle 11.5.9 e-Business system administration tasks such as registration of executables, program and request set definitions; creation of application value sets, creation and management of user as well as custom responsibilities; managing profile/configurations; concurrent manager tuning as well as starting/stopping the application when requested.
  • Upgraded the DBMS technology stack to 9.2.0.5 from the delivered 8.1.7.4.
  • Conducted comprehensive benchmark tests to ensure that the existing hardware would support the required user and transaction load.
  • Managed team of technical resources located in Mumbai, India (known as XD or extended delivery).  Had as many as 45 developers assisting with the construction of numerous RICE components; once developed the code was received by the onsite team which reviewed, implemented and tested the code developed by the offshore developed code.
  • Lead architecture responsible for RICE components – R eports (49), Interfaces (37), Conversions (28) and E xtensions (24).

HNTB Architecture - Kansas City, MO

For HNTB (Engineering and Architecture firm), served as lead Oracle e-Business Technician responsible for all technical tasks such as hardware/software installation, configuration and deployment.  Performed hardware tasks such as hardware sizing, assisting with selection, procurement, installation and configuration.  Performed software tasks such as version control, patch release, installation strategy, backup & recovery, patching and custom software standards.

  • Sized the required hardware platform to accommodate the initial installation of Oracle 11.5.8 e-Business suite with the ability to scale to handle add-on modules such as Oracle Projects, Human Resources and Customer Relationship Management (CRM).
  • Coordinated the installation of Red Hat's Advance Server Linux software with the appropriate patch set level.
  • Devised instance strategy for the implementation of Oracle's e-Business Financial (AP, GL, AR, AM, HRMS, iExpense) modules
  • Configured Oracle e-Business Vision Environment for preliminary testing and configuration.
  • Create naming conventions of the file systems, custom code and database instances to conform to OFA standards.
  • Created documents for discussion purposes around Patch and Migration Strategy
  • Created a list of patches to be applied once the base 11.5.8 installation has been performed; verified the list with the OCS team lead.  Applied close to 55 patches to the initial environment; once validated this environment was our baseline to build all subsequent environments using Oracle's Rapid Clone.
  • Upgraded the DBMS technology stack to 9.2.0.3 from the delivered version of 8.1.7.
  • Created hot backup scripts to backup the Oracle Application databases
  • Created the custom application top (location of custom code) within the CLS1 environment
  • Documented the Developer 6i Installation Procedures
  • Lead architecture responsible for RICE components – R eports (37), Interfaces (27), Conversions (18) and E xtensions (7).

Thermos - Chicago, IL

For Thermos, served as lead Oracle Application DBA performing database administrative tasks, patch management, resolution of technical issues and various responsibilities required by the client.

  • Worked closely with Oracle's e-Business Online (EBSO) to configure the development and integration environments.
  • Managed the implementation of patches required to support the financial (AP, AR, AX, CE, CN, FA, GL, GP, PA, PO, RG), manufacturing (BOM, ENG, INV, MRP, MSC, OM, WIP, WSH) and CRM components utilizing Oracle 11i (11.5.7) e-Business suite.
  • System ran on a Quad-Compaq Server leveraging Red Hat's Linux Advanced Server 2.1
  • Tuned, configured and managed the concurrent managers
  • Performed DBA activities (reorganizations, space management, backup and recovery, etc) on the development servers.
  • Designed, configured and implemented several conversion routines to convert Thermos' existing legacy information using the Oracle supplied APIs.
  • Performed patch maintenance, application and verified O/S upgrades as required.
  • Performed several environment clones to support development efforts.
  • Created a comprehensive CPG (Consumer Package Group) portal to track several key performance indicators based upon the client's requirements.
  • Leveraged Oracle's Application Server (Oracle9iAS) version 9.0.2
  • Implemented numerous patches so we can incorporate the Oracle's latest functionality include the latest portal development kit (PDK), Oracle Balanced Scorecard (OBSC vs. 4.8.3), Oracle Discoverer (version 4i) as well as patches to required to link the portal directly into Thermos' e-Business Application.

Technology Solutions Company; January 1998 - Aug 2003

Dallas Technical Group; Technology Architecture Group

Technical Director

RELEVANT EXPERIENCE (with TSC)

RCN Cable - Princeton, NJ

  • Created a comprehensive ASP (Application Service Provider) implementation for the support of RCN's PeopleSoft HRMS and Oracle Financial Application.
  • DBA/Application manager for PeopleSoft HRMS application.  PeopleSoft 7.5+ using an Oracle 8.0.5 database on a multi-partitioned Sun E10000 server.
  • Configured the PeopleSoft Application Servers (Tuxedo), Web Application Server and the procedures for installing the software on the client's desktop.
  • DBA supporting an Oracle Financial 10.7 application.  Leveraged an Oracle 7.3.4 database (upgraded to 8i) on a seperate Sun E10000 server; managed a second server which housed five test instances for testing and upgrade purposes.Applied numerous patches to support the Oracle Application.
  • Configured and tested several database scenerios; tuned, optimized and configured database creation.  Implemented several procedures to streamline the nornmal DBA tasks, identify inefficient processes and streamline multiple operational procedures.
  • Responsible for the installation and configuration of the Sun equipment, creation of several Oracle 8i databases, PeopleSoft, Tuxedo and other software packages.
  • Conducted comprehensive benchmark/stress tests to identify performance problems, process flow  bottlenecks and inefficient transactions.
  • Tuned RCN's provisioning application for the installation of underground wires as well as the installation of services.  Tuned applications in Arbor, Kenan, Clarify and other telephony packages.
  • Mentored the RCN staff to ensured that the database would not encounter problems once the systems was fully operational.

McGraw-Hill Publishing - Columbus, OH

  • Technical architecture responsibilities for the sucessful implementation of a new intranet application to track the sales within the corporation.
  • System was a "home-grown" Java based application developed for McGraw-Hill's sole use.
  • Utalized Oracle 8.0.6; Oracle's partitioning and Oracle's ConText Cartridge.  Numerous implementation problems were overcome including performance limitations, fine tuning the ConText option and establishing database administration guidelines.
  • System consisted of 500 Gbytes of storage operating in a Sun environment; utalized two-Sun 4500 as the database server leveraging Veritas' HA First Watch to ensure the system was available 7x24.
  • Configured and tested several database scenerios; tuned, optimized and configured database creation.  Worked extensively with the Oracle Support in tuning the ConText option and achieved superior performance once the software was configured correctly.
  • Responsible for the installation and configuration of the Sun equipment, creation of several Oracle 8.0.6 databases and the successful deployment of Veritas' High-Availability software.
  • Created backup and recovery procedures using Oracle's RMAN with Legato; installed scripts which dynamically queried an Oracle database and performed the appropriate backup procedures.
  • Mentored the McGraw-Hill staff to ensured that the database would not encounter problems once the system was fully operational.

Tandy Information Systems - Fort Worth, TX

  • Coordinated the database conversions of GL, AP, HR/PY, AM and AR components of the PeopleSoft application.
  • Lead technical architect responsible for the technical, benchmark and hardware/software coordination of Tandy's PeopleSoft Application.
  • Managed several Oracle DBAs (4+), Tuxedo/PeopleSoft Administrator, several technical specialists and had access to 12 PeopleSoft developers.
  • Responsible for the successful implementation of PeopleSoft's Payroll, Human Resource, Asset Management, Accounts Payable and General Ledger.
  • Go to person with regards to tuning, configuration, reorgs and data transfer processes.
  • Configured the hardware architecture: Three HP-5000  each containing 16 CPU's leveraging HP-UX 11.0 (64-bit architecture) as the database servers.  One server represented the online (OLTP) components of the PeopleSoft application that housed a single Oracle 8.0.6 database engine.  The other server represented the reporting server; this server contained an Oracle 8.0.5.1 that accessed up to 24 months of historical information.
  • Each server was served by an HP "K" class machine which contained BEA's Tuxedo middleware.  Separate application server were leverage to accommodate failover, give the ability to start multiple Tuxedo servers and isolate the middleware activity from that of the database.
  • Each database was connected to a separate EMC frame, which was configured with the appropriate RAID configuration.
  • Created a reporting server database which was used to generate the daily and month-end reports.  Had to develope complex routines to replicate the data from the OLTP application and store the data within the data warehouse.  Involved the creation of many replication routines, PL/SQL logic and shell scripts to manipulate the data.
  • Coordinated and executed several benchmark tests to stress the online, batch, replication and reporting query performance.
  • Implemented and coordinated the use of Mercury's LoadRunner software to replicate the activity of 800 concurrent users accesses the PeopleSoft application in a three-tier architecture.
  • Tuned several inefficient PeopleSoft queries to achieve optimum performance.  Adding indexes, reconfiguring the datafile placement, tuning the Oracle kernel, rewriting SQL and performing other database activities made gains.
  • Coordinated the integration of Partitioning within the PeopleSoft Application within the OLTP and the Reporting Server Environmnet.
  • Documented the Oracle DBA procedures (tasks, configuration, RAID implementation), Tuxedo configuration, change control application and other architectural deliverables.

Benchmark Electronics - Angleton, TX

  • Assumed technical architecture responsibilities for the coordination of several production databases to support the implementation of the Baan application.
  • System consisted of 500 Gbytes of storage operating in a Sun environment; utalized a Sun 6500 as the database server, Sun 5500 as the NFS server and several smaller Sun 450's as the application servers.
  • Configured and tested several database scenerios; tuned, optimized and configured database creation.
  • Responsible for the installation and configuration of the Sun equipment, creation of several Oracle 7.3.4 databases and the successful deployment of Veritas' High-Availability software.
  • Created backup and recovery procedures; installed scripts which dynamically queried an Oracle database and performed the appropriate backup procedures.
  • Ensured that the database was failover capable from an operational and procedural standpoint.

Blandin Paper Company - Grand Rapids, MN

  • Technical architect responsibile for the coordination of several production databases to support the implementation of the Baan application.
  • System consisted of 20 Gbytes of storage operating in a DEC Alpha Cluster environment.
  • Configured and tested several database scenerios; tuned, optimized and configured database creation.
  • Responsible for the successful deployment of automated backup and recovery procedures; installed scripts which dynamically queried an Oracle database and performed the appropriate backup procedures.
  • Ensured that the database was failover capable from an operational and procedural standpoint.

Miscellaneous Tuning/DBA Engagements:

  • Internet Shopping Network - Sunnyvale, CA
    • Oracle 8.0.5 DBA on Sun E450 servers; monitored go-live PeopleSoft application for performance related; proposed architecture changes to support the implementation of the RETEK/PeopleSoft Application
    • Worked with current ISN staff and made recommendations to improve administration once all systems are live.
    • Recommended System, Database, Network, Operating System and backup procedures
  • Jitney-Jungle Food Stores  - Jackson, MS
    • Oracle 7.3.4 DBA on IBM AIX servers; monitored live PeopleSoft application for performance related
    • Immediately improved performance by tuning the SGA, adding indexes and manipulating the order in which batch programs are invoked.
    • Established Database, Operating System and backup procedures
  • Alliant Distributors (subsidiary of Kraft)  - Phoenix, AZ
    • Technician assigned to the PeopleSoft HR upgrade project; migrate PeopleSoft HR 5.02 to 7.01 database.
    • Oracle 7.3.4 DBA on HP UX 10.2 servers; coordinated and monitored the upgrade process to ensure the process operated efficiently.
    • Once live, monitored and improved the PeopleSoft application by tuning inefficient SQL statements within the PeopleSoft application.
    • Installed procedures to accommodate backups, password management and other mission-critical related issues.

BSG ALLIANCE/IT; Feb. 1997 - Jan. 1998

Dallas resource Center

Senior Technical Specialist

Senior Technical Specialist Consultant; involved in the planning, integration, implementation and tuning of Oracle environments for several key BSG projects.  Involved in key database decisions which will ensure the success of the applications once BSG relinquishes control to the client.  Main source of Oracle expertise within the entire corporation; performed numerous installations (NT, UNIX and VMS) as well as several 2-5 day tuning enagements to improve the performance of problem databases within BSG/Alliance IT.

RELEVANT EXPERIENCE (with BSG Alliance)

S2 Systems, Inc. - Dallas, TX

  • Lead developer of the S2, CRM release 3.0 project.  This system is being developed in a client/server environment using PowerBuilder, BluePrint, C, and UNIX/PERL scripts on an Informix database running on a NT Stratus RADIO box.  The project is the third phase for the CRM product.
  • CRM "Marketing Database" is a data warehouse software package that is currently marketed to retailers.  A retailer feeds point of sale (POS) data into the CRM system, and CRM provides easy to use screens to view the retailer's customer shopping data.  The system is based on concepts of Customer Relationship Marketing, a.k.a. one-to-one marketing.
  • BSG has partnered with S2 to design and build the CRM product, and has been involved throughout all phases (including installation and beta site support.)  BSG is also a channel partner for CRM, and is licensed to sell the product to our customers and prospective customers.
  • During the project responsibilities for:
    • gathering and documenting system technical requirements;
    • preparing the Technical Architecture requirements deliverable for CRM release 3.0
    • maintaining the logical data model in Erwin;
    • preparing estimates for the design/development/testing of the CRM batch modules
    • preparing detailed design specifications for the CRM batch modules;
    • ensuring software is compatable on Informix, Oracle, MSS, Sybase and DB2;
    • ensuring software operates on both NT and Unix platforms (leveraged the use of Perl and MKS);
    • communicating system design approach to client team resources and client management;
    • developing CRM batch modules (the most complex modules);
    • designing and implementing a method for performance benchmarking the batch modules;
    • overseeing the integration of the client API into CRM batch modules;
    • unit testing CRM batch modules;
    • assisting and mentoring team members (both client and BSG).

Northern Indiana Power Service Corporation (NIPSCO) -  Merrillville, IN

  • Senior technical advisor responsible for the implementation of a data warehouse to maintain existing and future clients. Main function of system is to grow the customer base once deregulation occurs within the power (electric, gas and water) industry. System was originally implemented on a DB2 v2 database but the performance required a more powerful and efficient Oracle database.
  • Created the mechanism to populate the Oracle 7.3.2 database; process involved extracting data from and IBM mainframe DB2 v2 database, transmitting data to an IBM AIX 4.2 UNIX server, scrubbing the information via 'C' routines and uploading the data using SQL*Loader.
  • Acted as senior DBA of the project; created the data model, table/index definitions (DDL), installation of all Oracle software, creating several databases using the most current Oracle features such as partitioned views, read-only tablespaces, parallel query to name a few.
  • Load process involved creating nearly 20 scrubber routines, writing over 50 thousand lines of code, and finally, developing UNIX shell scripts to automate the entire load process.
  • Once completed, the scrubber process operated with transaction rates of 450,000+ transactions per minute and loader rates in excess of 250,000 records per minute.
  • Responsible for the interface between InfoQuery and the database, includes the installation of SQL*Net v2, creating roles, users and database security practices. 
  • Performed post-production database tuning by reviewing the database's SQL statements as well as database and O/S review - achieved database transaction rates of 2-5 seconds where as on the DB2 system the transactions were taking between 2-4 hours.
  • Developed backup and recovery strategy utilizing UNIX scripts to perform hot backups, cold backups, DDL exports and database restores by reading a parameter file which indicated the backup type to be performed.
  • Developed database, DBA, sys admin, 'C' code, walk through and backup documentation for NIPSCO as a corporation.

McKesson Corporation - San Francisco, CA

  • Reviewed data model, infrastructure and database configuration of Oracle7 load process to analyze sales and purchases for the entire corporation.
  • Documented findings and presented them to the project's management since load times were in excess of 40+ hours.
  • Technical lead responsible for fine tuning and optimizing the Oracle load process; reviewed SQL code, load programs and operating system parameters to achieve the most efficient load process possible.
  • Reduced the load process to 12-15 hours; well within the customer's required timeframe.
  • On-call DBA resource to review problems within the UNIX (Sun Solaris) and NT databases for all BSG projects operating at the McKesson's world headquarters.

Miscellaneous Tuning/DBA Engagements:

  • The Energy Authority;  Jacksonville, FL
    • Oracle 7.3.2 DBA; installed two NT database servers which held four database instances.
    • Reviewed data model; recommended implementation strategy and rollout schedule.
    • Lead Oracle consultant with respect to database, utilities and load mechanisms.
    • Established Database and NT procedures
  • British Columbia Power - PowerEx Project;  Vancouver, BC
    • Oracle 7.3.2 DBA; installed and configured several applications on an HP NT 4.0 Server
    • Tuning SQL statements
    • Established Database and NT procedures
  • Edision Power - Nucleus Project; Los Angeles, CA
    • Oracle 7.3.2 DBA; installed and configured the database as well as the Nucleus application on an Compaq Server using Win-NT 4.0
    • Established Database and NT procedures

ORACLE CORPORATION; Apr. 1995 - Feb. 1997

South Central Consulting Group

•Principal Consultant

Principal Consultant; dedicated to the tuning and optimization of large scale production databases.  Specializing in the construction of decision support/executive information systems.  Functions include, but not limited to, design, construction, implementation, tuning, benchmarking and populating of databases of all sizes - specializing in very large database (VLDB) design. Post-production support tasks involve the tuning and optimizing of the databases, operating system and the application as a whole to yield the optimum performance for the end-user.

RELEVANT EXPERIENCE (with Oracle Consulting)

Consumer Credit Association (CCA) - Houston, TX

  • Architecture Engineer responsible for the integrity, population and loading of a massive database to performing credit reporting services.  Created well over half-a-million lines of code to populate and extract information with performance being the prime objective.
  • Team leader of a large team (7+ people) to build, load and populate a massive credit reporting system with data received from over 3500 external contributors. Responsible for team development, creating technical specifications, assisting with the writing of 'C' and PL/SQL logic, database design, and lead architect for the data load portion of the project.
  • Technical lead to give guidance and technical assistance with code/logic.  Coding tasks include C, PL/SQL, Forms 4.5, Oracle Case (Designer 2000K) and Oracle DBA responsible for the construct of the data load portion of the Trade Load process.
  • Expected size once implemented will be 1.3+ terabytes in size operating on two Pyramid Nile servers; consisting of 450 tables, over 900 indexes and will support 500 (or more) users.
  • System utilized Designer 2000, Developer 2000, 'C', Tuxedo and PL/SQL for the development environment. Served as the CASE DBA, DBA and technical lead for the entire project.
  • Designed the initial database schema including table partitioning algorithm, stripping strategy and population mechanism of the database.
  • Conversion team lead; responsible for creating 'c' routines to manipulate incoming trade data and build 12 different flat-files.  Once build, flat-files were loading via direct path SQL*Loader.  Creating routines to tie a consumer to their respective trade information once loaded into the database.  Achieved rates of 4,500+ transactions per minutes per process; by leveraging 20 concurrent processes we were able to obtain a throughput of nearly 100,000 transactions per minute.  Daily processing rates are in excess of 20 MM per day.
  • Performed post-delivery benchmark activities to improve overall performance; found (and corrected) deficiencies with respect to indexes, constraints and stored procedures.  During benchmark activities found an Oracle kernel 'bug' that required recoding on the part of Oracle Consulting - once recoded we were able to improve the performance of the entire system by 400% (improved rates from 256 TPM to 1,257 TPM).
  • Sole Oracle consultant to maintain the source code delivered by the trade load effort; delivered source code to the client (excluding documentation), comprehensive set of documentation and conducted turnover JAD/education seminars.

Hoechst/Celanese - Dallas, TX

  • Properly configured two HP-9000 (K class) machines; configured OS parameters, disk stripping, created backup and recovery procedures.
  • Created default .profile, .cshrc and .login shell scripts; scripts properly establish the user's environmental variables by a series of prompts.
  • Installed the Oracle Software to support current and future development projects following OFA standards
  • Created five database on the two machines to support current and future development projects. Once created, configured the databases to support four (4) applications in EACH instance.
  • Configured the multi-threaded server, SQL*Net, Parallel Server and Query Options, and the auto-startup/auto-shutdown logic for the database servers (and listeners) on both the test and production machines.
  • Created a comprehensive refresh process to copy from the mainframe to the HP machines via a nightly batch process.
  • Created a comprehensive manual to define standards/procedures for the entire environment.
  • Installed DBA scripts to be ran nightly to monitor the system and ALL database instances for potential problems with respect to extents, space, fragmentation and system statistic. Added to cron to automatically submit the three dba audit jobs; scripts evaluated the databases for potential problems and generate a daily report everyday at 6:00 a.m.
  • Created two fully comprehensive scripts to manage the promotion of source into and out of SCCS; the process involved the creation of UNIX script which prompts the user which in turns will reserve, promote and unreserve objects any one of five separate development environments (to be used by the application developer).

Southwestern Bell Corporation - St.Louis, MO

  • Reviewed for the SBC MIS staff the AIN/SMS automated switch system for inefficiencies.  Analyzed over 250 'C' modules, embedded dynamic SQL, Tuxedo interfaces and online specifications. 
  • Documented changes necessary to allow a daily throughput of 10,000 trxns/day.
  • Performed an in-depth tuning engagement to improve the AIN/SMS response time (reduced response time by 85%); recommend appropriate backup and recovery procedures; designed and created a more efficient database instance utilizing proper stripping algorithm, separation of datafiles, optimized redo logs (using raw devices), recommended appropriate datafile sizes.

Dallas Semiconductor - Dallas, TX

  • Installed Oracle's Data Query Decision Support Tool to extract information from their corporate data warehouse to generate ad-hoc reports, graphs and data files for the corporation's sales, marketing and executive staff.
  • Tuned the sales information decision support system to handle an anticipated load of 30 people.  Created required indexes, restripping of tables, monitored system performance and sized the Oracle database appropriately.
  • Conducted several classes to teach the staff at Dallas Semiconductor how to use the DQ4 toolset.  Participants ranged from the clerical staff to the CEO and CIO of Dallas Semiconductor.
  • Designed and populated several key tables which will be used within the Sales and Salesman information Warehouse.  Created several Entity Relationship Diagrams (ERDs) to map the existing OLTP system to that of a large scale decision support system.

Mastercard International - St. Louis, MO

  • Assisted with the loading of a large full-scale database which contained all of MasterCard International's worldwide credit card transactions.  System utilized a AT&T teradata machine using parallel technology; once implemented the total amount of data processed and stored will near 1.5-2.0 terabytes in size.
  • Developed with the staff of Mastercard International an algorithm for the backup and recovery of four (4) different databases that were present for the information Windows project.
  • Created 'C' routines which would take flat file data from the mainframe and transform the information into a format which could easily be loaded into an Oracle database.  Process involved the acquiring of system keys from dimension data ('C' code), loading the data into the database using SQL*Loader, aggregation routines to consolidate like rows (embedded 'C' code with dynamic SQL) and replication logic to copy the data to the respective database. Processed six (6) feeds of 5-11 million records each per day in a required window of 4-6 hours.

Unisys/Boatman's Bank - St. Louis, MO

  • Tuned existing data warehouse applications; instrumental in the design and implementation of a new warehouse to track ATM information/transaction; rolled-out initial warehouse to Boatmen's CIO, MIS director and technical staff.
  • Implemented logic to capture the system generated SQL, tune the inefficient SQL statements and ensure the database's integrity while loading information. Taught Boatman DBA's the procedures to ensure that database is properly tuned to accommodate the anticipated load.
  • Resolved Boatman's performance problems by tuning the database, properly building indices and correcting system generated SQL statements.  Reduced the average response time from 11+ hours to less then 10 seconds per transaction.
  • Reviewed Boatman's credit card data warehouse system for performance bottlenecks, identified potential application problems with respect to data loads, backups, data refreshes and ad-hoc queries designed by Unisys.

Southwestern Bell Yellow Pages - St.Louis, MO

  • Created benchmark scripts to monitor the performance of an Oracle 7.1.4 database under various conditions.  Scripts were created to monitor and report the system's performance on both a DEC OpenVMS and UNIX operating system.
  • Assisted SouthWestern Bells staff in the preliminary design of a large scale data warehouse project which will contain all Yellow Page information within the SouthWestern Bell network.  Once implemented the system will be approximately 1.2-1.5 terabytes in size.

Wolf Creek Nuclear Power - Burlington, KS

  • Implemented logic to properly maintain the database's integrity, capture and review the systems SQL.  Implemented procedures to properly maintain database integrity, monitor space usage and the procedures on how to identify and correct inefficient SQL statements.  Taught Wolf Creeks DBA's how  to ensure the database is properly tuned to accommodate the anticipated load.
  • Identified potential problems and made recommendations to solve Wolf Creek's long term problems.
  • Resolved application performance problems by tuning the database, properly identify and build indices and how to write efficient Visual Basic SQL statements.  Average response time was reduced from minutes to sub-second response times.

DSC Corporation - Plano, TX

  • Installed routines that were used by DSC employees to identify, tune and correct inefficient code generated by the client's ad-hoc tools.
  • Assisted in the identification of system bottlenecks with respect to database availability, performance, backup recovery and overall application tuning items.

ELECTRONIC DATA SYSTEMS (EDS); Dec. 1985-Apr. 1995

HMO, Hospitals and Pharmaceuticals

•Senior Systems Engineer

Advanced/Senior Systems Engineer; specializing in client/server application development, database development, database tuning, systemapplication run time improvements (RTI), capacity planning and customer support. RTI expert; have had tremendous success improving client/server transaction response times by making changes to the application code, database redesign, database tuning, modifications to customer work flows and significant logic changes.

Have worked in a leadership and technical position creating innovative solutions by applying technical expertise in application construction and tuning, system administration, database administration, data modeling, benchmarking and overall system enhancements. Abilities include project definition, project management and all deliverables associated with a system's life cycle.

Extensive experience in the construction, design, development and tuning of relational database systems from both a client and server perspective.  Experienced in the design and development of technical solutions to support the medical industry.  Areas of expertise include hospital medical record systems, HMO/PPO claim processing and the pharmaceutical and medical device industries.

RELEVANT EXPERIENCE (with EDS)

Dun and Bradstreet /EDS HealthCare, Plano, TX - Methodist Hospital

  • Designed, constructed and implemented a comprehensive decision support system to support  the research and reporting the quality of the Methodist Hospital Medical Plan (MPLAN) Network of Indianapolis, Indiana.
  • Led a team of six system engineers, one database administrator and one system administrator.
  • Used Texas Instrument's IEF product to create the data model and DDL.
  • Created a large database (25 Gig) which stored four years of medical claim, invoice and consumer information for the entire HMO. 
  • The server was designed using Oracle's 7.1.4 database on a DEC Alpha 3000 machine; users accessed the data using Pilot Lightship's software via SQL*NET.
  • Majority of system was created using Oracle's PL/SQL; remaining portion of system was designed using ANSI C.  Heavily used AWK and SED UNIX utilities to manipulate data.

Dun and Bradstreet /EDS HealthCare, Plano, TX - compete™

  • Created a massive executive decision support system (data warehouse); which was roughly 750 Gigabytes in size.
  • System consisted of two parallel HP-9000 series mini-computers, each having four processors, 756 Megabyte of memory, running HP-UX operating system which access Oracle's 7.0.16 RDBMS.
  • Once loaded, the data warehouse contained 75 million claim transactions as well as Hospital, HMO and PPO information for EVERY healthcare corporation in the United States.
  • Served as a team leader on several key data source initiatives.
  • Designed data models, data loads, data integrity and data access paths for the acquisition of healthcare data.
  • Performed Database Admin activities such as creating database tables, instances and referential integrity scripts.
  • Used Visual Basic and Object Master as the ODBC to access the data via SQL*NET.
  • Performed hardware/software benchmarks to determine the appropriate hardware configuration for our sales initiatives.
  • Primary responsibility was to tune the database, improve response time, and optimize the database's performance.
  • Researched and corrected any data idiosyncrasies using PL/SQL, AWK, SED and 'C' programs.

Axion Pharmaceuticals, San Francisco, CA

  • Created an integrated network of third party pharmaceutical hardware and software.
  • Designed interfaces to facilitate the electronic transfer of data; 'C' code was developed to which accessed a FairCom C-Tree database.
  • Installed and configured SCO UNIX on several Compaq 486 PCs.
  • Created communication device drivers, routines to download/upload data.
  • Creation of screens to start/stop device drive deamons.
  • Creation of routines to send/receive information between DOS and UNIX platforms.
  • Created user, installation and operational documentation.

LifeScan (a subsidiary of Johnson & Johnson), Milpitas, CA

  • Designed and developed a fully integrated Customer and Product Quality Service (CPQS) System. The CPQS system maintained a database of customer sales and transaction records, both for customer relations purposes and to comply with federal regulations (FDA).
  • System was designed as a true client/server environment utilizing Macintosh's System 7.0 software as the client, accessing an Oracle 7.0 database via 'C' code (having embedded SQL) as the server and using  iTRAN's Tuxedo as the TP monitor.
  • Created the data model using Oracle Case; coded approximately 25% of the backend server code.
  • Coordinated the conversion of LifeScan's existing information using Oracle's PL/SQL (procedural language); coordinated the design, coding, implementation, execution and acquired customer's signoff prior to implementation.
  • Led a team of five system engineers which assisted in the conversion of the customer's existing information.
  • Converted roughly 1.3 million demographic records, 1.5 million customer transactions and 100,000 quality assurance (QA) and reliability engineering (RE) records.
  • Identified and resolved numerous system performance problems; worked closely with customers to ensure that the system performed up to their expectations.
  • Resolved many post-implementation problems dealing with both data and system problems using all of Oracle's 7.0 tools.
  • Produced numerous ad-hoc reports and special database queries to support  LifeScan's daily business practices; used Oracle's Data Browser, PL/SQL, Oracle Forms, and Oracle Report Utilities

HMO and Hospitals Division of EDS, Plano, TX

  • Delivered a fully integrate client/server environment to support Harvard Community Health Plan's InterPractice Systems (IPS).
  • Developed screens using JYACC's JAM 6.0 as the client, ACMS as the TP monitor and embedded SQL via COBOL source code as the server which accessed an Ingres database.
  • RTI expert; authorized to make extensive changes to the application code, database redesign, database tuning, modifications to customer work flows and significant logic changes.
  • Reduced GUI application response time from 9+ seconds to nearly 2.5 seconds; NPT response time was reduced from 6 seconds to 1.5 seconds.
  • Eliminated all of IPS' production deadlock and time-out problems; were occurring as frequent as 15 per day.
  • Created interfaces with third party vendors to process lab results.
  • Technical lead for benchmark activities within IPS; fulfilled performance analysis of the IPS system under various scenarios.
  • Evaluated several hardware, network and DBMS configurations to meet IPS' needs; evaluated the IPS system using Ingres, Oracle and Sybase on Sun's Solaris and  Digital's VAX systems in both a distributed and centralized network.
  • Mentor of team; taught several classes on performance tuning, database access methods and proper coding techniques.
  • Designed and implemented a series of screens which performed staff maintenance functions for the clinical staff at Harvard Community Health Plan (HCHP).
  • Evaluated and recommended a preferred automated testing tool.
  • Installed and reviewed seven different software packages on both the PC and Macintosh platforms; recommended a single package based upon price, repeatability, training, error analysis, and accuracy.
  • Converted the IPS system from a VMS/ACMS system to a UNIX/Tuxedo system so that it will be POSIX compliant; required for certification to operate on all platforms.

Commercial Insurance (CISD), Plano, TX

  • Major contributor to the EDS*PAC (Property and Casualty) system as an SE and lead SE; major contributor to the business design, coding, testing and implementation of the Billing and Collections subsystems.
  • Coded on-line, deferred and batch prcoesses(COBOL/CICS/IMS).
  • Taught classes on IMS and VSAM database access methods; Served as a mentor to several SE's with respect to coding, JCL, scheduling and production support.
  • Served in a consulting capacity to other teams/projects; focused mainly on RTI, CICS, JCL reengineering and database tuning.
  • Delivered a comprehensive rating subsystem to compute automobile rates using statistical modeling.

GM's CPC Engineering; Troy, MI

  • Installed Engineering Workstations, Forte boards, printers, controllers and 450+ IBM PC's with software.
  • Became knowledgeable in 50+ different software packages, printers, CAD/CAM, dumb terminals, cellular phones and lap-top computers

 

If you wish to download a MS-Word version of resume click here...

[Home] [Professional] [Vacations] [All About  Rick]

Have a question or comment... please email me at Rick@Kupcunas.com