James C. Kennedy II

Phone 503-***-****

Email: ac3rv5@r.postjobfree.com

PROFESSIONAL EXPERIENCE

TECHNICAL SKILLS

> Software MS Office tools,

> Languages Oracle pl/sql, Postgres PGSQL,OOPL, Visual Basic, Unix tools, T- SQL

> Project Management Tools Jira, MS Project

> Databases Oracle 6-12, PostgreSQL, MS SQL Server

> Applications GIT, Stash, Jenkins, Oracle Apex, Crystal Reports, Business Objects, Informatica, Tidal,Datastage,Siebel

> Industries H ealth Care, Insurance, Retail,Domain Auctions

> Operating Systems U nix, MS Servers

> Methodologies A gile, W aterfall, Scrum, Software Development Life Cycle,K anban WORK EXPERIENCE

SURESCRIPTS LLC B EAVERTON, OREGON S R. DATABASE DEVELOPER A UG 2014 - PRESENT

PROJECT HIGHLIGHTS

ADDED ETL INFRASTRUCTURE TO AUTOMATICALLY CORRECT AND TRACK MISSING OR DELAYED DATA FROM THE SOURCE SYSTEMS.

ADDED FLEXIBLE AUTOMATED OPERATIONS SUPPORT NOTIFICATIONS

ADDED ETL LOGGING TO ALLOW ANALYSIS OF PERFORMANCE AT A LARGE AND FINE GRAIN.

ADDED DATA ERROR CAPTURE AND NOTIFICATION FOR UPSTREAM SYSTEMS

STEPPED INTO OTHER ROLES AS NEEDED TO GET TEAMWORK DONE.

OPERATIONAL ON CALL.

CONVERTED LARGE MS SQL SERVER T SQL CODE TO ORALCE PL/SQL - MIGRATION FROM MS SQL SERVER TO ORACLE EXADATA PLATFORM

Technical Environment Oracle RDBMS, GIT, MS SQL Server, IBM InfoSphere Datastage,Jira, Confluence, Hudson,HADOOP, Apex

NIKE B EAVERTON, OREGON S R. DATABASE DEVELOPER O CT 2013 - AUG 2014

PROJECT HIGHLIGHTS

ADDED NEW ETLS FOR COMMON FILE FORMAT FOR POS DATAWAREHOUSE SYSTEM. E NHANCED DATA QUALITY CHECKS. ENHANCED ERROR DETECTION AND IDENTIFICATION.

BUILT PARTITION MANAGEMENT FUNCTIONS FOR DATAWAREHOUSE SYSTEM. POS SYSTEM HAS SPECIFIC PARTITION AND SUBPARTITION REQUIREMENTS.

BUILT RETAIL CALENDAR GENERATOR FOR NRF CALENDARS AND NIKE SPECIFIC CALENDARS.

OPTIMIZED COGNOS SQL QUERIES.

BUILT ADMINISTRATIVE TOOLS TO EASE USER MANAGEMENT.

TECHNICAL ENVIRONMENT:O RACLE RDBMS,PYTHON,SQL LOADER, GIT Iovation Portland, Oregon S r. Database Developer May 2011 - Oct 2013

> Project Highlights

o Converted complex Oracle system with stored Procedures to PostgreSQL. L owered costs, improved customer satisfaction, improved reliability, and scalability.

Refactered DDL to take advantage of the differences between the two RDBMSS.

Maintained Oracle system with changes while developing the Postgresql one.

Systems ran in parallel before switching over.

The PostgreSQL Environment is active/active data centers vs Oracle with Datagauard. o Designed and implemented Monitor Database and processes for Reporting system in an active/active environment. P roactive alerts, pinpointing of issues, and historic process time monitoring decreased response time to potential issues with few false positives.

The queueing system did not guarantee delivery in the same order to the two data centers. Designed a system to detect messages that made it to one data center but not the other while keeping false alarms - out of order messages - to a minimum.

Implemented other monitors - historic process times, queue failure and sub-performance monitoring.

o On call rotation for production issues.

> Technical Environment C entos, Oracle RDBMS, PostgreSQL,Stash, GIT, Jira, Confluence,Oracle OEM,sqitch, pgtap,PagerDuty

Snapnames.com Portland, Oregon S r. Database Application Developer J anuary 2007 - April 2011

> Project Highlights

o Used Oracle Advanced Queueing to level OLTP workload. I mproving customer’s web experience. o Created internal support/reporting applications with Apex - D evelopers could concentrate their resources elsewhere enhanced Support and Management productivity and access to vital information. Enabled sales people to research comparables to increase sales. o Encapsulated business logic using Oracle’s object types and collections to separate service and presentation layers from schema changes. E nhanced Java Engineer’s Productivity. o Worked on “Buy it now” and “Make an offer” functionality. Added additional channels to sell domain names. E nhanced sellers appeal to our platform.

o Database side of for the workflow for customers to submit names for live auctions. Sales to review etc. I ncreased revenue and company competitiveness. o On Call Rotation

> Technical Environment O racle 10,11. Solaris x86, Centos. Subversion, pl/sql, Java, Oracle Apex, Oracle OEM, Oracle ASM, Oracle RAC.

Mentor Graphics W ilsonville, Oregon A pp. Developer Data Warehousing & Database Admin. J uly 2005 - January 2007

App. Developer & Database Admin. D ecember 2001 - July 2005

> Project Highlights

o Identified and solved Siebel Call Center and Primus Knowledgebase performance problems, improving support personnel’s productivity.

o Designed Queue Viewer for support personnel to manage priority of outstanding support tickets - Helped large Global support organization maintain SLA and quickly identify priorities under a complex weighting system.

o Used tiered service level in Oracle RDBMS to isolate interactive users form batch. I mproved customer facing response time, and system responsiveness for support engineers with minimal impact on batch operation.

o Standard on call rotation of the DBA groups systems.

> Technical Environment O racle RDBMS, Siebel and Siebel tools. Primus Knowledgebase, Tidal Enterprise Scheduler. Fog Light, Visual Basic, Citrix, Sun Solaris, MS Server, MS SQL Server, Informatica, Business Objects, Alliance Instruments Vancouver, WA Application Developer November 2000 - December 2001

> Project Highlights

o Produced sampling algorithm to reduce temperature read time from 3 minutes to 18 seconds. 1 8 seconds was within the customer’s tolerance.

o Integrated Integri Application with LIS and PMS systems. I ncreased sales and reduced customer’s workload and reduced error rate.

> Technical Environment D elphi, Windows, Integri hardware. (leads for blood pressure cuff, temperature, EKG Leads)

First Insight Corp Hillsboro, MA App. Developer and Data Modeler J uly 2000-October 2001

> Project Highlights

o Data modeling for the application. Eye Dr. to Lab (B to B) for frame and lenses and contacts. Tracked orders in the process. Increased turn around for eye glasses o Produced pl/sql packages to monitor the system and Java applets to visually show the current state. Produced web pages to hold a dashboard of information about the state of the database. H elped project space and resource needs.

o

> Technical Environment O racle 8, MS SQL Server, MS WIndows, Solarias, Java. ASP Medicalogic Hillsboro, OR Productivity and Support Engineer August 1997 - July 2000 Installation, App. Engineer and Data Modeler November 1994 - August 1997

> Project Highlights

o Investigated, determined root cause, and identified fix. Critical performance issue. The issue prevented medical personnel from using the system for extended periods of time. The fix took 4 man hours and improved system performance 4 X. reduced system resource usage by two thirds. Afterwards medical personnel could successfully use the system. o Created web based knowledge tool. D ecreased call resolution time and increased consistency of response.

o Designed client and server installations. S implified Oracle RDBMS install and co-branding with HP. Increased our revenue and improved revenue recognition.

Allowed co-branding of our application.

Multiple language installation support.

Simplified Oracle DB install to allow non-technical personnel to install in an ambulatory care environment.

o Assisted Customer Support Engineers with incidents during 8 month post-release cycle. With the same staff incident load increased 16 fold. R etained customers and added brand Value. o Managed all Customer Escalation incidents to Engineering. Improved resolution time, reduced interruptions of Engineering Staff.

o Helped with performance issues. Did database modeling and design.

> Technical Environment N etware, MS NT Server, AIX, HPUX, Oracle 7 - 9, Toolbook, InstallShield, Visual Basic, DOS, C, PL/SQL .OOPL internal language

Watson Wyatt Stamford, CT - Wyatt Software L ake Oswego, OR Defined Benefit Pension Administration Systems. Internal Consultant, Software Engineer, Data Modeler, WYPEN, WYSCRIPT S eptember 1989 - November 1994

> Project Highlights

o Investigated, determined root cause, and identified fix. Critical performance issue. The issue was calculations for Defined Benefit Plans taking over 2 minutes, reduced to under 3 seconds. The analysis of the root cause led to the company wide changes that significantly improved the calculation performance for all customers.

o Enhanced and optimized the history object, written in C++. Pushed common functionality from script to C++. Improved the C++ annuity calculations from about 2.5 seconds to under half a second. Impacted implimenters work positively and improved system performance. o Using the OOPL language - WYSCRIPT- added easily configurable database auditing system. Once enough demand was identified moved the functionality into the C++ layer that called the DB drivers.

(pre-ODBC) Added product functionality and ease of implementation helped customer Pension Administration Systems company wide.

> Technical Environment N etware, MS NT Server, OS2,, Oracle 6 - 7, Toolbook, InstallShield, Visual Basic, DOS, C/C++, PL/SQL .OOPL internal language (WYSCRIPT), FORTRAN 77 Metrolplitian Life Insurance Co. New York, NY Personal Insurance Actuarial. Research, Software Engineer July 1983 - November 1989

> Project Highlights

o Modeled ending of Industrial Line of Insurance. Determine costs of a variety of alternatives to reduce escheating of assets to NY State.

o Wrote Fortran programs to create unisex Qs from ‘58 and ‘80 CSO tables for states which required unisex life insurance. A llowed us to quickly generate Qs for premium calculations.

> Technical Environment I BM 360, DOS, FORTRAN 77, REXX, APL, SuperCalc CERTIFICATIONS AND TRAINING

> Actuarial exams

o Calculus and Analytic Geometry,

o Probability and Statistics,

o Operations Research,

o Numerical Analysis.

> Siebel 7 developer training

> Oracle 8 training - new features.

> Took Jonathan Lewis’s course on Oracle optimization.

> Oracle RAC training.

> Informatica Training

> Datastage Training

EDUCATION

Northwestern University,Evanston, Il. BA 1981

Contact this candidate