John Johnson



Experience
Lead Application Developer QBE Regional Insurance 
Public Company; 1001-5000 employees; Insurance industry 

March 2008 – Present (1 year 2 months) 

PeopleSoft Application modification and design. Interface generation etc.
Component interface development. XML Publisher. Report/Interface
Modifications/development (App Engine, SQR, Peoplecode etc)

Lead Application Developer QBE Regional Insurance (Sun Prairie, WI) 
Hospital & Health Care industry 

2008 – Present (1 year) 

Sr Systems Analyst UW Hospitals and Clinics 
Public Company; 5001-10,000 employees; Hospital & Health Care industry 

February 2007 – March 2008 (1 year 2 months) 

- Responsible for system development within the HRMS and Financials PeopleSoft
application. Duties include: Interface creation, report modification, application
development, fit/gap analysis of new applications. Project management. Tools
used: App Engine, SQL, peoplecode, XML, HTML, javascript, SQR, Iscript
technology. General support for HRMS and Financials application. Recent projects:
Implemented Manager self-Service using NTLM and LDAP for authentication.
Incorporated custom leave accrual tables on View paystub pages. Reporting using
Peoplecode to XML (excel) as well as SQR to XML (excel). Created Automation of
automatic pay adjustments process for Nursing unions. Bundle Application for
HRMS. Access Database migration to Custom PeopleSoft (in process). Configuration
of Change assistant/ EMHub. Created search engine for custom Central supply
ordering catalog. Provided regular training presentations for team development.
(Tools Rel. 8.46.06)

Sr System Specialist City of Hope 
Non-Profit; 1001-5000 employees; Hospital & Health Care industry 

April 2006 – February 2007 ( 11 months) 

PeopleSoft- Sr. Systems Specialist- 
Responsible for: Analysis 
troubleshooting and design of the PeopleSoft environment. Responsible 
for New development and solution recommendations. Mentor for other 
Application support analysts. Upgrade analysis and retrofit of 
customizations (SQR, PeopleTools objects etc) for upgrade from 7.5 to 
8.3. Creation of benefit healthcare interfaces to Blue Cross, Cigna, 
Kaiser via SQR. Modifications to GL interfaces, confirmation 
statements and open enrollment forms. (Tools Rel 8.47.07)

Oracle Database Administrator City of Hope 
Non-Profit; 1001-5000 employees; Hospital & Health Care industry 

March 2003 – April 2005 (2 years 2 months) 

PeopleSoft- Oracle Database Administrator- Responsible for: data modeling, data
administration, database design, performance & tuning, and system security.
Tablespace Analysis extent management, Database exports and restore. Disaster
recovery. Application of regulatory(Tax) updates and patches 
to PeopleSoft, Oracle and Weblogic. Speed and growth Analysis of the 
PeopleSoft Database. PeopleBooks install with Verity search Creation 
of indexes, views and troubleshooting performance issues. Refresh of 
test and development databases with current production exports. Also 
responsible for Alert log analysis and problem determination. Database 
8.1.7.4 and 9i on AIX 5L RS/6000. Oracle 10g Sun Solaris. Performed Database
upgrades from 8.1.7 to 9i Application Server, Webserver, Process schedulers on
separate RS/6000.