Robert Shawhan

*** ************ *****, ************, ** 27278

919-***-****, acvv71@r.postjobfree.com

www.graphpadpro.com

Summary of Experience

Senior IT Project Manager / Developer / DBA with over 15 years experience developing, customizing and supporting software applications. Currently working as an independent developer of iPad and iPhone applications.

Over 20+ years experience developing software applications (iOS / Oracle).

Over 15 years experience with Oracle 7/8/9/10/11/12.

Over 5 year iOS / Objective C / Swift development experience.

Designed and developed multiple Oracle database applications.

Expert in Database design of OLTP and DSS systems.

Skilled at working customers to analyze system requirements and specifications.

Expert in Oracle stored procedures, packages and triggers in PL/SQL.

Skilled in SQL Tuning using TOAD.

Designed and developed a suite of engineering design applications (GraphPad) for the iPad.

Computer Languages:

Oracle PL/SQL ERWin Oracle Express Perl MySQL

iOS 4,5,6,7,8,9 Swift 2.0 Objective C XCode CoreGraphics

CoreData MapKit StoreKit CFNetworking CoreLocation

Education & Certifications:

BS Mechanical Engineering, University of Texas at Austin, 1984.

Certified Oracle Professional Developer v6/6i - 1999

Certified Oracle Professional 9i DBA - 2007

Professional Experience:

INC Research, Inc.

Raleigh, North Carolina

Enterprise Data Modeler / Mobile Developer

October 2015 – February 2016

Worked in the Innovation and Architecture Group, developing prototypes and methodologies to be used throughout INC Research. Took the conceptual models developed by the Architecture team with the aid of all the business units and converting them into logical and physical models to be used throughout the organization. Worked closely with the technical managers for Oracle Clinical, Oracle E-Business Suite, and Saleforce systems, to name a few, while developing the enterprise models to document the source and target systems for all the critical information for the company.

In addition to my Modeling responsibilities, I also developed the INC Enterprise Overview iPhone App in Swift 2.0, a Business Intelligence tool for senior management to quickly view the status of all projects currently in work. This application used a CoreData persistence layer in conjunction with INC’s Enterprise Service Bus in order to get a near real time view of what was happening within the company. The application was modeled after INC’ Project Portal, and presented all the same information in an iPhone native format. The App displayed Graphs of project Financial, Study, and Enrollment data which was accomplish through Telerik’s iOS Charts and the deployment / VPN tunnel was handled using MobileIron. The App was delivered on time and was presented at INC’s Global Leadership Meeting by the CEO of INC Research in front of all of INC’s Executive Management team.

Sole Proprietor

Hillsborough, North Carolina

Software Developer – Apple / iOS 4/5/6/7

November 2010 - Present

Designed and developed GraphPad, a touch based engineering drawing application for the iPad. GraphPad has one of the best 2D dimensional drawing engines available on the iPad and is integrated with custom developed multipage business forms (labels, text fields, list fields, check boxes, signature fields & tables). GraphPad can be configured to meet any businesses specific forms requirements and is currently being used by CenTex Foundation Repair of Waco Texas, and the City of New York’s Department of Transportation as an integral part of their business process. GraphPad was developed in Objective C and has recently been upgraded to utilize a CoreData persistence layer for managing user generated libraries of geometry, images, and symbols. GraphPad is also designed to be integrated into a customer’s backend systems using their web services and a MapView displaying customer appointments.

More information on GraphPad including the Users Guide and videos can be found at:

www.robertshawhan.com.

GraphPad Blog is at:

acvv71@r.postjobfree.com

Fidelity Investments

Morrisville, NC

Contract Oracle Developer

August 2014 – January 2015

Designed and developed an Oracle Express Data Quality Dashboard for the Asset management Data Warehouse

Duties

Gathered requirements for the Data Quality Dashboard

Designed the database components (Tables, Packages, Procedures, etc)

Designed the Oracle Express (APEX) web pages

Participated in the development of both the database components and the APEX pages

Was given free reign to design a data quality dashboard for the Asset Management Data Warehouse team. Worked with business analysts and developers to design a solution, and co-authored all of the components, defining the general architecture of the solution and handing off details to less experienced developers. Represented the Data Quality Dashboard effort in all design and code reviews as well as provided demonstrations to users and management alike.

Quintiles

RTP North Carolina

Information Architect

May 2012 – January 2013

Duties

Responsible for all Oracle Database object design

Developed the interface document for the developers

Interpreted business requirements and use cases

Worked in a large team of developers, business analysts and architects on a Content Server 10 document management system for the training of both internal and external portal users. Worked closely with the Content Server, portal and java developers to design the system, develop the Oracle ERD and interface documentation, as well as create the Oracle database objects (tables, indexes, views, materialized views, packages and procedures) for the project.

Credit Suisse

RTP North Carolina

Principal Systems Engineer

April 2010 – November 2010

Duties

Supervise ETL re-write from custom Unix & PL/SQL scripts to Informatica.

Coordinate Data warehouse enhancements.

Hired in to support the legacy data warehouse for private banking and the conversion of its custom ETL scripts written in Unix and PL/SQL to Informatica. Attempted to implement Oracle best practices, process control, and clean up the data warehouse data model based upon Kimbal’s design methodology.

Oracle Corporation - Consulting

100% Travel

Principal Consultant

April 2009 – April 2010

Duties

Perform technical presentations and training classes on Oracle Pharmaceutical Applications.

Worked with Development on the Oracle Clinical 4.6 Flexible Studies enhancement.

Prototyped the FDA’s Adverse Events Reporting (FAERS) BI solution using Discoverer.

Worked as a principal technical consultant for the Health Sciences Global Business unit. Worked as part of a team of developers on the Oracle Clinical 4.6 release, developing the PL/SQL internal routines that process flexible studies as well as unit tests for the batch loading algorithms. Upon completion of Oracle Clinical 4.6, moved on the FDA FAERS project and developed a prototype data warehouse for Oracle AERS (Adverse Events Reporting System) developing validated reports in Oracle Reports 10g and an adhoc query capability in Discoverer. Trained junior developers in Oracle Reports10g and the integration of custom reports with AERS and developed the System Technical Documentation for the FAERS custom reporting capabilities.

\

Fidelity Investments

Morrisville, NC

Principal Business Analyst

April 2007 – December 2008

Duties

Managed multiple small track (<150k) projects

Developed custom Forms and Reports to support Oracle Advanced Benefits.

Developed an automated account management application for Oracle E-Business Suite users.

Worked in a cross functional capacity, managing small teams of developers and DBAs to create customizations to Oracle Advanced Benefits (OAB). Designed and developed custom Forms and Reports, code reviewed PL/SQL for junior developers, and analyzed issues with OAB. Developed an application that completely automates the provisioning and maintaining Oracle E-Business users in Oracle Forms, PL/SQL, and Perl. The custom provisioning system not only provided considerable cost savings for Fidelity ($250k annual savings), but also provided additional flexibility to the business group.

INC Research

Raleigh, NC

Sr. Oracle Consultant

June 2005 – April 2006

Duties

Developed Applications in Forms 6i/9i and Reports6i/9i

Provided technical support to the Clinical Trials Systems (Oracle Clinical, AERS, TMS, Discoverer)

Developed and managed System Changes to all CTMS systems.

Developed and managed standards for setting up Clinical Trials.

Defined TMS Dictionary Integration / Loading Process.

Technical architect and lead developer on multiple implementations including: Internal and External study access via Discoverer, 21 CFR Part 11 compliant automated account and study access management for Oracle Clinical, TMS & Discoverer, study setup migration, and GLIB migration tool to name a few. Implemented Oracle Discoverer as a Business Intelligence tool for managing Clinical trials. Also developed reporting tables and extract/summarization procedures in PL/SQL for use in Business Intelligence. Wrote multiple work instructions to document process improvement, taught process and technology classes to junior staff members, and participated in strategic planning, software/hardware evaluations and vendor negotiations.

This resume covers only the last 10 years of my 30+ years of experience. In addition to the work listed above, I have 10 more years experience in software development varying from Business Analysis, Project Management, Oracle Development and Unix support as well as 10 years experience as an Aerospace Engineer working on projects including the Space Shuttle Main Engines for Rocketdyne, Titan stage I & II Engines for Aerojet, and the F-18 E/F Super Hornet Airframe for Northrup-Gruman.

References upon Request.

Contact this candidate