Pervasive-Intelligence, LLC - Scott Dempsey
Pervasive Intelligence - BI Consultant
CORPORATE EXPERIENCE
Descriptions of Prior Corporate Jobs
2001 - 2006
Senior Manager of development and operational teams
Ultimate Software
Weston, FL
Commercial software for HR, payroll, and benefits management
Provider of a top tier commercial payroll application that competed with Paychex and ADP. The solution technologies offered onsite client, secure cloud, service oriented architecture, business intelligence, and high availability. The software fully supported regulatory and security compliance for both state and federal. Our groups released 1-2 major enhancement releases per year and 6 regulatory releases. I was there during the company’s development methodology changing from waterfall to agile.
​
-
Developed a code generator solution database driven to include, system delivered data, release
configuration data, and asset management data
-
Managed 3 development teams (DBA, Install / Deployment, and QA Infrastructure teams)
-
Our team provided a flexible and secure infrastructure for a development staff of over 200 people in
addition to over 200 development and QA server resources
-
Our development infrastructure supported the complexities of parallel release path development and the
challenges of linear progression between them
-
Coordinated, executed, and managed well over 100 internal full application build and deploys yearly
-
Responsible for data model, database stored procedures, system delivered data, and development
infrastructure resources
-
Install and Deployment team responsible for application deployment system (i.e. new installs and upgrades)
and Release Configuration
-
QA Tech team responsible for managing the QA infrastructure system as well as build validation and
internal deployment
-
Lead for special projects involving analysts, other developers, customer support, hosted services, QA,
documentation, educational services, and IT
-
Knowledge management initiatives
-
Collaboration enabling infrastructure
-
Designed and developed ETL process for customer migration from a 3rd party application acquisition
-
1998 - 2000
Senior Oracle Database Administrator and DBA team lead
Metasolv Software (Acquired by Oracle)
Plano, TX
​Commercial software for provisioning telecommunications
​
The company’s software provided operational support system to facilitate the designing, provisioning, and activation of communications assets.
-
Administrator of over 30 Oracle databases (development infrastructure)
-
Responsible for data model integrity encompassing impacts to scalability and performance
-
Developed a code generator framework for handling complex database upgrades
-
Enabled cost saving maintenance and code reuse within a dynamic framework
-
Every upgrade step managed, audited, and recovery point aware
-
Upgrade scripts were platform independent (Unix, Linux, Windows) for reductions in development, QA, and maintenance costs facilitating portability
-
-
Developed solution to dynamically build system control database entries that solved historical failure points during upgrades which reduced customer pain points, support calls, and downtime
-
Subject Matter Expert on internationalization of the application
-
Developed customer facing solution to dynamically report on data model differences when commercially available solutions had not been readily available in the market
-
Developed nearly cost free solution to supporting Unix based customers’ needs during development via Linux that had never been previously utilized in development and testing environments
-
Acquired vendor certifications that saved the company $250K in annual licensing fees at the time
1997 - 1998
Senior Database Administrator
Source Services (Acquired by KForce)
Dallas, TX
National, multi-industry staffing placement agency
-
Provided high availability and continuity for 60+ production servers, physically located across USA
-
Managed continuous transactional replication from remote regional servers being pushed into the centralized corporate data warehouse located in Dallas used for strategic management reporting
-
Provided all aspects of database administration in a complex, distributed, in-house developed custom enterprise back office system
-
Responsible for consolidation metadata quality between enterprise staffing application and accounting/payroll software
1995 - 1997
Senior Database Administrator / Programmer / Developer
Bank One (Acquired by JPM)
Dallas, TX
Regional Bank subsidiary
​​
-
Skunk-works strategic reporting group within corporate finance and accounting department
-
Solutions supported planning and forecasting, FTE budgeting, CRM initiatives, Enterprise reporting
-
Our team originally developed what later became Oracle/Hyperion’s commercial DRM product
-
Analyst/Developer for executive management projects
-
Custom reporting targeting large balance fluctuations that upon initial release identified a banking balance error overlooked for months that was in the range of 9-12 digits (checking acct. number)
-
Business Performance reporting on specific bank assets and liabilities utilizing custom ETL from
production mainframe into relational database repository -
Key Member of national project to convert all state level reporting data into a national Master Reference Data standard to be loaded into Oracle/Hyperion Enterprise
-
-
Project lead over both in house and consultant developers to rewrite HR employee budgeting program
-
System Administrator of a national Accounting and Finance database system that I converted from legacy system into a more robust SQL system improving data quality and scalability
1994
Senior Engineer
Corporate Software Inc.
Dallas, TX
National staffing company covering major industries
​
-
Provided nation wide consulting support for Borland Paradox database software
-
National support covered all aspects from install to custom application programming
-
Developed, implemented, and maintained the in-house product support tracking database

