Developer Manager

Jonathan Paolicelli

SUMMARY

An information systems professional with over 25 years of experience in the analysis, design,

programming and implementation of computer business systems. An RDBMS modeler, designer

and administrator with over 20 years of experience.

EDUCATION

Iona College 1969 to 1974

New Rochelle, NY

Bachelor of Arts -- General Studies

Minors -- Math and Physics

LANGUAGES

T-SQL, PL/SQL, SQL (DDL, DML), REXX, PERL, JAVA

SOFTWARE

SQL SERVER (7.0, 2000, 2005, 2008) (DTS, T-SQL), ODBC - Open database Connectivity,

Oracle Enterprise Manager tool set (8i, 9i, 10g), PL/SQL, Oracle Forms, Oracle Reports (5),

Oracle Advanced Replication, DB2/2 DBA tools, Microsoft Visual SourceSafe, Microsoft Visual

Studio: Team Edition (2005, 2008), IBM Clear Quest (SCM), WinCVS, StarTeam 4.0, Business

Objects 5.0, MS IIS 5/6, Microsoft Excel, Microsoft Power Point, Microsoft Word, Microsoft

Publisher, Netscape for OS/2, MS FrontPage 98, Visualage 3.0 (Workframe, NMAKE, Visual

Builder, Data Access Builder, Compiler), Lotus AmiPro, Lotus Word Pro, Lotus 123, PVCS, OS/2

Presentation Manager, Information Presentation Facility, BookMaster GML

PLATFORMS

Windows Server (2000, 2003), Windows (Windows NT 4.0, 2000 Professional, XP Professional,

Windows 7 Ultimate), Linux (Red Hat 7.2), OS/2 (1.1 through 4.0), Windows (3.11), DOS (3.3

through 6.3)

DATABASE TOOL SETS

Oracle Enterprise Manager (8.x, 9.x, 10.x, 11.x), Quest TOAD Expert Suite (8.x, 9.x, 10.x,

11.x),Quest Spotlight on Oracle, Microsoft Enterprise Manager (2005, 2008), AllFusion - Erwin

(3.5, 4.x), Embarcadero (DBArtisan 8.x), Embarcadero (ERStudio 8.x), Idera (SQL Diagnostic

Manager), Microsoft Visual Studio Team Edition 2005/2008 for Database Professionals

CASE TOOLS

Kasevip for Presentation Manager, Visualage C/C++, VisPro C

DATABASES

Oracle Enterprise Edition (7.x, 8i, 9i, 10g), MS SQL Server (7, 2000, 2005, 2008), DB2/2 (pre-

UDB) OS/2, DB2 MVS, Watcom, MySQL, PostGres

SKILLS

Database Administrator, Data Modeler, Process Modeler, Database Architect, T-SQL

development, SQL/PLSQL development, Office System Architect, GUI design, implementation

and testing, Knowledge Engineer for Business Rules, Application Build Master

Work experience:

Sphere Technical Resources, Inc.

Raleigh, North Carolina

Client: CarQuest (GPI)

Consultant: DBA/DBA Developer/Performance Tunning 02/2012 to 02/2013

Engaged as an Oracle development DBA with a specific focus on performance tuning of the

enterprise data warehouse as well as other numerous operational databases. The data warehouse

currently amasses 3Tb of data; with in-place future accommodations for an expected 35% increase.

The system that has been in operation for several years, starting on Oracle 7.4, employs nightly,

incoming and outgoing ETL loads and 23x7 active user, ad hoc queries and scheduled reports. The

data warehouse (10g) was running on a Solaris Spark machine of a much earlier vintage with a

SAN utilizing VMAX and NFS storage devices/systems. The business plan stipulated a dual

migration of operating system and database version upgrade. I was solely responsible for effecting

the Oracle version upgrade that included preparatory sizing estimates for data structures, review of

several schemas objects for version upgrade fitness, adoption of the newest 11g RDBMS capabilities

and troubleshooting and updating database applications. This dual pronged migration was

completed over a 3 month period with zero down time for corporate users. The benefits of this

migration included:

• decreased storage requirements (despite increasing data volumes),

• deployment of a set of customized, scheduled maintenance jobs (table and index statistics

and partition management)

• decrements in query completion durations (ex. Several multi-hour durations are now

reduced by a minimum factor of 50% with one hour durations reduced to under an hour)

• all corporate reports and external data outflows are now completed within established

delivery windows; internal SLAs are now being met where they had been missed for

previous several months

Software Guidance & Assistance, Inc.

Tarrytown, New York

Client: Credit Suisse

Consultant: DBA/DBA Developer 03/2011 to 09/2011

Engaged as a DBA and database developer tasked with improving production database performance for

Credit Suisse, a multinational, financial services group. The production system comprises six, multi-

terabyte, Oracle databases located in three countries, linked via Oracle advanced replication with a

multitude of feeder and consumer systems. The daily processing load, although increasing by 245% in the

five months of my tenure there, a 26% decrease in processing time was realized. Additional plans and

systemic, programmatic paradigm shifts with physical model tuning and attending, maintenance

implementations and schedules, offered and approved, are slated for future implementation/adoption with

even greater levels of performance increases expected.

TEAM Information Systems, Inc.

St. Mary, Florida

Client: Progress Energy

Consultant: DBA/DBA Developer 06/2010 to 11/2010

Engaged as the lead Oracle (10g) database designer (logical/physical) and developer (operating on

Linux servers) at Progress Energy, a public electric power, utility company, located in Raleigh,

North Carolina. The project amounted to an in-house effort to replace a purchased, exceedingly

long-running, commercial ETL processing system. The new system processes 350GB of system data

a month (delivered as fixed format flat files) through two cube transformation operations,

performed by PLSQL packaged applications and stored in database tables; the data is then

extracted into fix-format, flat files that a downstream application consumes. The project was

successfully completed as a significant improvement in operational efficiencies new data

verifications (lacking in the 3rd system) with reporting.

Design and coding activities:

• Design Oracle External Table definitions populated by SQLLOADER import

• PL/SQL programming of stored procedures, utilizing 10g product packages and advanced

PL/SQL coding techniques to transform the external table data into cube-sliced (by appropriate

metric) data and stored into internal database tables.

• Collaborate with Linux developers writing batch modules for

lights-out scheduling of the monthly processing events.

Itron, Inc.

Raleigh, North Carolina

Data Architect/DBA/DB Developer 08/2009 to 04/16/2010

Itron is a leading technology provider to the global energy and water industries that manufactures

advanced metering devices that manage commercial and residential systems communicating over a mesh

network. Retained as the project, Senior Database Administrator (development) running on Windows and

AIX operating systems.

Design and coding activities:

• PL/SQL programming of stored procedures, utilizing 10g product packages and advanced

PL/SQL coding techniques to improve Cost Based Optimizer selection of indexes over full table

scans where predicate specifications were employing not-equal logic.

• Defining and implementing partitioned table (range) and partitioned index (range and hash) sets

in support of greater DML efficiencies realizing partition elimination and rapid verification of

declarative referential integrity constraints.

• Exhorting (to the development team) benefits of bind variable usage over embedded, literals in

DML statements.

• Design, code, test and deploy database upgrade scripts that

were capable to up-version all major and minor version

changes while retaining data.

Tasks Include:

• Assess current performance efficiencies (Oracle OEM tools and reports alongside Quest Toad and

Spotlight tools), design, test and implement solutions

• Identify and employ Oracle initialization parameters to tailor the particular instance to the

installation hardware (disk subsystem storage such as async_io, ) and available, physical memory

• Direct database support for the development, QA and direct customer support teams.

• Redesign existing schema (objects and programs) for optimal performance with large data sets

• Design new schema objects (tables, indexes, stored procedures, etc) in collaboration with

development personnel.

• Modifying pre-existing PLSQL objects to conform to best practices and performance profiles.

• Develop and deploy disaster recovery and normal maintenance procedures.

CC Intelligent Solutions, Inc

Raleigh, North Carolina

Data Architect/DBA/DB Developer 11/2006 to 03/2009

For an Information Technology company as the sole data architect and team lead for the DBA and

database developer staff working on the company's two major offerings: cGov360 and FusionNet

applications.

cGov360 Corporate Filing Management Platform enables state government offices to efficiently

execute on its offerings both for back office personnel and web customers (general public). The system is

developed with an efficient layered design where the User Interface (UI) developed with ASP.NET, the

Data Layer (DL) developed with C# and the Data Store (DS) developed for both Microsoft SQL Server

2005 and Oracle (versions 9i and 10g) RDBMS.

FusionNet directly supports U.S. war fighters in overseas operational theaters. The persisted data storage

is housed in a Microsoft SQL Server 2005 DBMS on multiple, in-theater and stateside servers all

participating in a replication network that avails the war-fighter low latency data availability throughout

the command.

Design and coding activities:

• Design and deploy the logical (data relationships) and physical (schema objects) database models

• PL/SQL programming of stored procedures, utilizing 10g product packages and advanced

PL/SQL coding techniques to deliver customized, programmatic solutions; there was little adhoc

DML in the stack.

• Collaborate with C# development teams to serve as knowledgeable resource for the use of

application to database interfaces.

Tasks include:

• Review the existing data model, data flows and data architecture

with the stated goal of refactoring existing and developing new

logical and physical database structures and procedures for

greater efficiencies and added functionalities.

• Configure and administer the Progress, DataXtend replication

network operating over a high latency WAN network (FusionNet)

• Direct and mentor junior database developer staff in SQL Server

and Oracle best practices.

• Collaborate with application team members in determining problem

resolution and new functionality interoperability (C# and

TSQL/PLSQL)

• Collaborate with in-theater, Field Service Representatives in

determining application deployment, upgrade and problem resolution

activities in an access-restricted military network.

• Coordinating with Business Analysts, Application Architects,

Functional Leads and Developers for all layers of the

applications stack

• Designing and developing database schema objects, stored

procedures and packages (Oracle), High Availability and Disaster

Recovery plans for efficient and supportive database provisioning

and operations

Analysts International, Inc

Raleigh, North Carolina

Senior Consultant 01/2006 to 09/2006

For a multinational pharmaceutical company endeavoring to deliver a enterprise-wide solution to aid in

the development, capture, organization and reporting of preclinical methods and experimental results to

develop and deliver new drugs and therapies to the market within the guidelines and strictures of a

government regulated business space. The version one system, currently running with an Oracle 9i rdbms

with fourth quarter plans to migrate to 10g, incorporates web services (utilizing SOAP messaging

protocols), Windows Forms for desktop user interfaces coded in C#/.NET and complex MS Excel

spreadsheet technologies for the lab environment capture of development methods and testing results.

Design and coding activities:

• PL/SQL programming of stored procedures, utilizing 10g product packages and advanced

PL/SQL coding techniques to implement a robust and manageable implementation and control

interface to Oracle Advanced Replication used heavily in coordinating several corporate

databases and their application stacks.

•

Tasks include:

• Review the existing data model, data flows and data architecture

with the stated goal of a fundamental redesign to a scalable

enterprise solution. Meet with key pharmacological and chemical

research group personnel to determine current paradigms and future

requirements of both research and preclinical trial efforts to

bring products to market. Analysis and development of new data,

logical and physical models utilizing ERWin to produce ERD’s and

data dictionary work products.

• Migrate and incorporate legacy systems such as: Oracle databases

(8i) and other certified documentation management products into

the new system.

• Work with developer teams to troubleshoot existing function,

augment existing function, identify new feature function and

develop database objects (data models, physical models, stored

procedures and functions)

• Develop and implement phased promotion of development work

products through a verified system of development, testing,

validation and production databases

CODEX Consultant Services, Inc

Holly Springs, North Carolina

Senior Consultant 06/2005 to 12/2005

For a North Carolina State University endeavoring to organize a state wide Emergency Medical System

tracking system with ties to the Federal Reporting System as the sole data modeler, database architect,

database developer and administrator for an Oracle 10g RDBMS. This new system incorporates web

services utilizing SOAP messaging protocols for desktop and handheld device user interfaces coded in

JAVA/J2EE for occasionally connected users.

Design and coding activities:

• PL/SQL programming of stored procedures, utilizing 10g product packages and advanced

PL/SQL coding techniques to improve the existing and to produce new stored procedures in

support of business functions.

Tasks included:

• Review the legacy data and physical models. Develop data, logical

and physical models using ERWin. Create and distribute ERD’s and

data dictionary work products to promote development team

understanding and migration efforts into the new system.

• Migrate and incorporate legacy systems databases (FoxPro, DB2/UDB,

and SQL Server 2000) into the new system.

• Render the Nationally defined XML document’s XSD into an Oracle,

OLTP database

• Create and administer phased implementation of system knowledge

domains into HyperSonic databases for JAVA development teams.

• Model repository for disparate data streams for incorporation into

the reporting Oracle warehouse

CODEX Consultant Services, Inc

Holly Springs, North Carolina

Senior Consultant 07/2004 to 05/2005

For a national insurance/reinsurance company that specializes in Commercial Auto (trucking and

commodities) insurance products as the sole data modeler, database architect, database developer and

administrator for MS SQL (v2000) RDBMS. The continuance of the preceding position.

TEKsystems

Raleigh, North Carolina

Senior Consultant 06/2003 to 06/2004

For a national insurance/reinsurance company that specializes in Commercial Auto (trucking and

commodities) insurance products as the sole data modeler, database architect, database developer and

administrator for MS SQL (v2000) RDBMS.

• Designed databases included:

• The data repository serving as the data and process hub between

the needs of the web-based application (J2EE) and the legacy

system (COBOL on an emulated IMS environment) used by company and

associated insurance agents to create and administer policies.

• The data repository for a web-based internal tracking system for

policy related paper work

• The data repository for a web-based ( .NET) electronic payment

system that provides oversight on incoming account payments.

Duties included:

• Review existing legacy 2-dimensional, data structures and craft

relational, logical and physical data constructs

• Analyze existing legacy data and process flows and re-engineer

them for their adaptation and inclusion into the new system

• Collaborate with the J2EE and .NET teams in the design of the

application’s data object model and database interaction methods

• Design and code all stored procedures, triggers. DTS packages and

utilities in the support of data movement between the J2EE and

legacy systems

• Design, code and deliver data mart-like reports to major stake

holders

• Provide emergency on-demand solutions for other SQL Server backed

applications as needed

• Mentor management, legacy and new employees on SQL Server

methodologies

Dach Consulting Corporation

Raleigh, North Carolina

Senior Consultant 02/2003 to 05/31/2003

For a garment industry, Product Lifecycle Management software company as the sole data modeler,

database designer, development DBA for MS SQL (v2000) and Oracle (v8.1.7, v9ir2) databases.

Databases are running on the MS Windows 2000/Server operating system. A twofold task involving:

support for legacy application issues and development of the company’s next generation, multi-

application, single sign-on suite of modules. The legacy application and the new suite are coded in the

C#/.NET and JAVA J2EE paradigms. The customer now enjoys a more performant legacy application.

The new development is proceeding as scheduled for an early summer release.

Duties included:

• Refactor to improve existing legacy application stored procedures

to address application bugs and concurrency issues;

• Develop, code and test new functions and stored procedures for

legacy application;

• Design and write installation scripts for the creation and base

population of the legacy database;

• Collaborate with knowledge experts and knowledge engineering team

to identify business requirements

• Establish and maintain a synergy with coding engineers by

identifying necessary database constructs and mentoring team in

best practices for application-database synergy;

• Design both the logical and physical models in support of a

modular installment of suite modules;

• Develop, code and test stored procedures, functions and triggers;

• TSQL utilities;

JLS Technical Staffing

Raleigh, North Carolina

Senior Consultant 07/2002 to 12/2002

For an early stage company creating informatics products and databases for research chemists who

design, synthesize and characterize novel molecules as the sole data modeler, database designer,

development and production DBA for MS SQL (v7, v2000) and Oracle (v8.1.7, v9ir2) databases.

Databases are running on MS Windows 2000, Linux (RedHat 7.3) and HP-UX (v11) operating systems.

Design and coding activities:

• PL/SQL programming of stored procedures, utilizing 8i/9i product packages and advanced

PL/SQL coding techniques to improve Cost Based Optimizer selection of indexes over full table

scans where predicate specifications were employing not-equal logic.

• Defining and implementing partitioned table (range) and partitioned index (range and hash) sets

in support of greater DML efficiencies realizing partition elimination and rapid verification of

declarative referential integrity constraints.

Duties included:

• Write PL/SQL and java stored procedures, functions and triggers;

• PERL utilities;

• Identifying and writing custom ETL scripts for the incorporation

of disparate sources of data (flat files, SD files, MOL files,

customer databases);

• Utilize Oracle Migration Workbench utility to migrate MS Access

databases (schema and data) to Oracle 9i;

• Craft and implement Oracle Advanced Replication to capture

customer production data for inclusion into product tool/database;

• Design logical and physical database models in support of product,

java application team;

• Provide guidance and mentoring of coding team in best practices

for database interface;

• Installation of database work products at customer sites;

• Write desk procedure manuals for customer, DBA professionals;

• Monitor and tune database instances for optimum performance.

Interactive Cable, Inc.

Raleigh, North Carolina

Senior Consultant 06/2001 to 08/2001 and 01/2002 to 03/2002

For a fortune 500 advertising company as the sole data modeler, database designer, database developer

tasked with creating a series of prototypes to address the business management needs for client accounts

and personnel tracking activities. Technologies used included: Oracle (8.1.7) as the RDBMS, Oracle

Forms (6i) and Reports (6i), Oracle Repository (6i), Oracle Diagnostic and Performance packs (2.2),

ErWin (3.5.2) as the data modeling tool and logical/physical design tool, Microsoft Terminal Services,

Windows 2000 professional. Customer has accepted work products and implementation is pending budget

approvals.

Design and coding activities:

• PL/SQL programming of stored procedures, utilizing 8i product packages and advanced PL/SQL

coding techniques to improve Cost Based Optimizer selection of indexes over full table scans

where predicate specifications were employing not-equal logic.

• Defining and implementing partitioned table (range) and partitioned index (range and hash) sets

in support of greater DML efficiencies realizing partition elimination and rapid verification of

declarative referential integrity constraints.

Duties included:

• Analyze office workflow and dataflow

• Design logical/physical database

• Prototype management and user GUI utilizing Oracle Forms

• Prototype custom reports on workflows and client account

statuses utilizing Oracle Reports

Oxford Group

Raleigh, North Carolina

Senior Consultant 02/2001 to 04/2001

Questra Corporation

Raleigh, North Carolina

Senior Consultant 13/2000 to 02/2001

NeoNova Network Services (Digitel Corporation)

Raleigh, North Carolina

Systems Consultant (Model/Design/Code) 03/1999 to 03/2000

Analysts International Corp.

Raleigh, North Carolina

Systems Consultant (Model/Design/Code) 02/1998 to 03/1999

Analysts International Corp.

Raleigh, North Carolina

Systems Consultant (Model/Design/Code) 11/1997 to 02/1998

DMR TRECOM Business Systems, Inc.

NY, NY

Senior Technical Consultant (Model/Design/Code) 07/1992 to 09/1997

AGS Information Systems, Inc.

Wappingers Falls, NY

Consultant (Design/Coding) 11/1989 to 12/1990

United Technologies Corp, Control Systems

East Granby, CT

FICS Technical Support Specialist, Engineering Group 08/1980 to 11/1989

PROFESSIONAL MEMBERSHIPS

Oracle Certified Partner Network, Microsoft Developer Network

Contact this candidate