claessen.org

Paul Claessen

Data Architect / Database Administrator / Software Engineer

Austin, TX 78739 +1.512.745.3640 paul@claessen.org

Skills

Oracle
MySQL
Database Development
Database Administration
C / C++ / Pro*C
Java
PL/SQL
Python, Perl
Shell
JavaScript
XML
Windows, UNIX, Linux

Expertise

Performance Tuning
ETL Optimization
Data Architecture
Data Visualization

Education

MS Electrical Engineering New Mexico State University

Publications

Three-dimensional finite-difference bidomain modeling of homogeneous cardiac tissue on a data-parallel computer, IEEE Transactions on Biomedical Engineering
Three-dimensional parallel finite-difference bidomain modelling of cardiac tissue, Proceedings of 16th Annual International Conference of the IEEE Engineering in Medicine and Biology Society

Experience

Staff Developer

Nokia (Austin, TX) 2016 - Present

Architected, designed, and developed a large-scale customizable data mart solution for call center support, transforming unstructured data into a structure streamlined for optimal reporting.
Developed data mart solution for Oracle and subsequently ported to MariaDB, providing technology specific optimization for each.
Collaborate to provide reporting solutions through Jaspersoft technologies and maintain data mart schema.
Provide 3rd level tiered support for global data mart deployments.

Staff Developer

Alcatel-Lucent (acquired by Nokia) (Austin, Texas) 2009 - 2016

Architected, designed and developed a custom data mart solution for home device support with the necessary ETL for optimal reporting.
Provided reporting solutions through Crystal Reports and BIRT.
Contributed to home device support solution based on a Weblogic / Java architecture.
Played a primary role in selecting optimal free and open-source software (FOSS) libraries for use in the home device product while ensuring license compatibility between libraries and corporate commercial code.
Maintained ongoing development database installations, upgrades, patch applications while interfacing with Oracle Support on RDBMS specific issues.

Senior Developer

Motive, Inc. (acquired by Alcatel-Lucent) (Austin, Texas) 2006 - 2009

Finalized and put into production a data mart and reporting solution based on Cognos and PL/SQL for deployment on Solaris and Windows platforms and utilizing the Oracle RDBMS.
Managed development lifecycle including consistent dialogue with offshore test team.

Senior Data Architect

Harcourt Education (Austin, Texas) 2005 - 2006

Architected data structure for innovative XML-based authoring system that enabled efficient search and repurposing of content.
Developed standards around data structure definition for object, relational, and XML schema representations.
Collaborated with editors and publishers throughout the nationally distributed organization to identify gaps and bring about efficiencies in the data management lifecycle.
Spearheaded conversion effort of legacy content into XML through W3C Schema design and maintenance along with clear communication of expectations to offshore vendors.

Senior Information Architect

Assurant Employee Benefits (Kansas City, Kansas) 2003 - 2005

Designed and implemented data structures to enable the retrieval of enterprise information distributed across multiple platforms.
Led development groups involved in extracting enterprise data from disparate systems for use in an enterprise dynamic content publishing system.
Played a key role in shifting mindset from point-to-point interface to hub-and-spoke architecture.
Designed and developed a time tracking system, including GUI and physical database components.
Established and promoted standards for several key technologies and processes including XML and relational modeling.
Consulted with major internal projects to ensure adherence to architectural guidelines and alignment with stated strategic objectives.

Senior Oracle DBA / Developer

Accredo Health Incorporated (Overland Park, Kansas) 2002 - 2003

Developed major new modules for the existing RxHome enterprise system using Oracle Forms, Oracle Reports, and PL/SQL.
Designed Oracle Server triggers, tables, indexes, and constraints to ensure high performance and data integrity in support of the front-end user interface.

Senior Oracle DBA / Developer Consultant

Sprint (Overland Park, Kansas) 2002 - 2003

Created an automated data-driven loading, transformation, and filtering process for gathering ACD/IVR data from six call centers around the world into the Sprint Customer Care data warehouse.
Developed and implemented a phone number match algorithm for correlating data between separate Sprint PCS systems, enriching available information on each customer call.

Senior Oracle DBA / Developer Consultant

International Brotherhood of Boilermakers (Kansas City, Kansas) 2002

Designed logical model and implemented physical data model to replace legacy system.
Installed dual-role monitoring system to enhance performance and prevent unauthorized access to critical business data.
Utilized Perl, shell scripting, SQL*Loader and UNIX utilities to create a repeatable process for scrubbing and loading the Oracle target system from the legacy Sybase system for a multimillion dollar pension database.
Improved application response time by 1000% by the redesign of SQL queries, tuning memory allocation, and implementation of optimal index design.
Managed project deliverables and handled capacity planning while reporting directly to the IT Director.
Maintained 99.99% database uptime and was available to respond to emergency situations on a 24x7 basis.
Migrated Oracle Applications on a VAX/VMS system to a Windows platform, including implementation of AP, AR, and GL with ongoing administration. Designed and implemented a redundant, automated backup and recovery process.

Data Quality Team Lead Consultant

Sprint (Overland Park, Kansas) 2001 - 2002

Implemented a Siebel Sales Force Automation solution with responsibility for maintaining the Siebel logical model and database objects.
Designed, developed, and implemented key components, including process to ensure that the most critical national accounts stayed up to date with account and assignment information.

Oracle DBA/Developer Consultant

Hewlett Packard Corporation (Palo Alto, CA) 1999 - 2001

Redesigned the Operational Data Store (ODS) for channel marketing financial incentive application.
Improved data integrity through automation and subsequent elimination of manual and redundant processes.
Redesigned an undocumented 50,000+ line dynamic PL/SQL, Pro*C loading application on an HP/UX platform. In the process, refactored code to certify the application as Y2K compliant.
Designed and implemented web-based reporting system for auditing financial incentive application based on HTML, JavaScript, Perl/CGI, Perl/DBD/DBI, and Apache.
Designed, implemented, and supported a web based research application for help desk and support personnel to quickly identify data relationships in the ODS. Supplemented the ODS with web based utilities designed to streamline processes that required manual intervention.
Administered Oracle databases to ensure an uninterrupted efficient production cycle through proactive tablespace management, performance tuning, and identification of potential bottlenecks.
Performed a full production migration to upgrade both Oracle and HP/UX.
Identified the need for and led migration from obsolete Oraperl to Perl DBD/DBI.
Assumed a support DBA role for several mission critical databases.

Senior Systems Analyst / DBA

The Dial Corporation (Scottsdale, AZ) 1998 - 1999

Developed interfaces from Electronic Data Interchange (EDI) to supply chain management systems using C, Pro*C, PL/SQL, and UNIX shell scripting.
Created database objects and administered database for support of EDI to Manugistics processing including tables, database links, storage management, performance tuning, and backup scheduling.
Performed integration and customization of Manugistics Supply Chain Management solution (Oracle Consumer Packaged Goods (CPG) suite) involving full life cycle software development.
Provided reporting and maintenance functionality for supply chain management systems utilizing Developer Reports and Forms.
Designed, developed, and automated outgoing interfaces from supply chain management to order processing and data warehouse systems.
Designed, developed, and implemented production system for maintaining purchase order information using Pro*C, Shell, and Oracle Forms and Reports.
Installed and maintained client/server supply chain management systems.

Lead Consulting Software Engineer

BPA Systems (later ClearOrbit and Take Solutions) (Mesa, AZ) 1994 - 1998

Full life-cycle software development covering requirements gathering, project proposal, design, prototyping, development, user acceptance testing, production cutover, and support of enterprise systems.
Operated in a project management role, meeting with client team leads to assess requirements and follow-up throughout the development life cycle.
Ensured customer satisfaction by providing 24x7 support.
On-site installation, development, customization, and administration of UNIX systems and applications for Radio Frequency (RF) data collection system.
Perl, C, and UNIX shell programming in UNIX and Windows environments for data collection applications.
Designed and developed Oracle / RF Data collection system interfaces to legacy AS/400 system.
Designed, developed, and implemented RF data collection system for data entry into Oracle using the C language coupled with a Paradox database.
UNIX and Windows systems administrator responsible for maintaining office productivity, local area networking, and backup scheduling.