14 Stevens Dr Newmarket, NH 03857

(603) 292-5508 Home (603) 767-5270 Cell jarekio@comcast.net

James R. K. O'Connor

Experience

May 2005 to Present Principal Consultant, Oracle Consulting Provide on site support and development for clients such as: Advo, Citigroup, Department of Energy, Department of the Navy, State of Maine, State Street Bank, Office Deport, Interpharma (Asia), Dunn & Bradstreet and Dell (US & UK). Assess reporting evironment then created Best Practices report tailored for client’s environment. Provide reporting services and best practices in developing reports for Oracle Reports, BI Publisher, Oracle Discoverer and Oracle Discoverer Administrator against Oracle Financials and client’s home grown systems. Provide interface development to move and massage data between desparate systems using PL/SQL. Provide training to clients in the use of Oracle Reporting products. January 2005 to May 2005, Goodrich, Danbury, CT Independent Software Consultant Designed and created custom reports using Oracle Reports for support of conversion from corporate legacy system to Oracle ERP. Reports covered financial modules such as GL, Payables, Receivables, Project Contracts, Order Management and Manufacturing. Registered reports and stored procedures in Concurrent Manager that is part of Oracle Applications 11i. Created value sets in Oracle Applications 11i to support variable choices used in reporting Created stored procedures using PL/SQL for support of custom processes. Worked with Oracle Alerts to support custom processes. October 2004 to December 2004, Adecco (Banknorth, Lewiston, ME) Associate Consultant Established reporting environment for new bank teller electronic journal system (Encore) running on Oracle 10g. Recommended best practices to client as learned from past experiences. Created new End User Layer (EUL) for Oracle Discoverer version 9. Created views, business, areas and reports. For more complex reports, developed reports using Oracle Reports 10g. Used PL/SQL to develop complex functions used in reporting. July 2004 to October 2004, Bearing Point (3i Implant Innovations, Palm Beach Gardens, FL) Software Consultant · Converting Oracle Discoverer reports from version 3i to version 4i. Included in this conversion of Oracle Order Entry system to Oracle Order Management system. Changes in architecture has caused in most cases, a rewrite of the reports. · Changed folders in the Administration version of Discoverer to point to new objects and reconstruct joins. · Modified views to reflect architect changes in tables and their relationships. · Constructed Discoverer reports using custom business areas as well as Noetix views. · Researched problems using MetaLink as well as opening up TAR’s. · Used the many facilities of Toad to work with Oracle objects. March 2004 to May 2004, Adecco, Associate Consultant · Provided modifications and construction of extracts for software the transportation system (Rockblocks) used by the corporate office of Timberland in Stratham, NH. · Created views for ad hoc reports using SQL and performance tuned when necessary. Predominantly used Oracle PL/SQL for extracts to and from disparate systems. Created and modified Oracle triggers. Worked on a custom subsystem of Rockblocks using Oracle Reports and Oracle Forms. Provided extracts for Cognos. · Used the many facilities of Toad to work with Oracle objects October 2003 March 2004, Independent Consultant · General Oracle work that includes Oracle Reports 6i, Oracle Forms 6i, Oracle Forms, Korn shell scripts, Oracle Discoverer, interfaces, conversion, triggers, Oracle Alerts, Oracle applications 11i setting flex fields, PL/SQL, TOAD, programming, performance tuning and reporting. Performed modifications and reporting for a transportation software system. · General COBOL mainframe work that includes, conversions, interfaces, setting up of JCL job stream, testing, debugging, maintenance and source control. April 1999 to October 2003, Liberty Mutual Portsmouth, NH Senior Software Engineer § Converted mainframe Payroll System/HRMS to Oracle Payroll/HRMS. § Develop reports using Oracle Reports 6i and Discoverer 4i (administrator and user). § Upgraded Discoverer 3i to 4i. § Develop interfaces between disparate systems. § Possess strong skills in SQL, PL/SQL, TOAD and triggers. § Tuned SQL in reporting and interfaces that have dramatically cut time from hours to seconds. § Work with the facilities of Oracle Applications 11i that include and not limited to: Oracle Alerts, setting up requests and requests sets for Concurrent Manager, setting up Descriptive Flex Fields and setting up responsibilities to run the requests. § Possess UNIX skills to move around file system, write korn shell scripts, ftp, rcp, editing and miscellaneous UNIX commands. § Write extraction programs in Cobol to interface with Oracle Payroll/HRMS § Maintain existing DB2 Cobol programs. § Communicated with business clients and peers to produce reporting, W2’s, 1099’s, payroll checks, internal and external interfaces.

March 1998 – April 1999, The Computer Merchant, Norwell, MA Software Consultant Associate § Converted all HRMS systems Cobol programs to make them Y2K compliant. § Technology used in the Y2K conversion includes but not limited to: SAS, flat files, VSAM files, DB2, Endevor used for version control, File Aid, Xpediter and JCL. § Documented and implemented changes. There were no Y2K problems when going live with the changes

January 1993 – February 1998 NH Dept. of Health & Human Services

Concord, NH

Analyst/Programmer

§ Maintained public Assistance System for the State of New Hampshire. Provided off hours on call coverage.

§ Worked with Deloitte and Touche in converting the legacy system to client/server.

§ Technology used but not limited to: GCOS8 and time sharing utilities, IDS-II, JCL, Cobol, DB2, ISPF, CICS, Intertest, Endevor, PowerBuilder and Netwise.

May 1987 – January 1993, Portsmouth Naval Shipyard, Portsmouth, NH

Analyst/Programmer

§ Maintained software systems to support submarine modernization.

§ Maintained batch online software systems that includes but not limited to the following technologies: GCOS8, TP8, IDSII, GCOS8 time-sharing utilities, UTL8, UTL2 and Cobol.

§ Communicated with business clients, operation staff and peers. Provide off hours on call support.

Education and Training

Franklin Pierce College, Franklin, NH § Bachelor of Science in Computer Science. § Graduated with 3.75 GPA New Hampshire Technical Institute, Concord, NH § Associate in Electrical Engineer Technology Oracle Education § Oracle Warehouse Builder § Relational Database Design § Discoverer for Users § Discoverer for Administrators § SQL Performance Tuning § Building Reports for the Internet (6i) § Oracle Forms for Oracle Applications 11i Miscellaneous Training § Dale Carnegie § PowerBuilder § Managing Multiple Projects with Multiple Priorities § Dealing with Difficult People