Jeremy Lowell, Principal
26678 East Nova Place
Aurora, CO 80016
Aurora, CO 80016
Jeremy@DataRealized.com
(303) 249-0187
(303) 249-0187
Results-driven technology consultant with proven expertise in enterprise-class database solutions.
Founded Data Realized, LLC, to provide these services at the greatest possible value for Fortune 500 companies, universities, small businesses, and startups.
HIGHLIGHTS
- Reduced database support costs by 40% by implementing performance tuning and stability measures
- Maintained 99% uptime for core sales support systems during a 6-month period, resulting in two straight quarters of 120% sales to goal performance
- Provided analysis of system architecture and design that decreased load times by a factor of 6
- Implemented table partitioning (SQL Server 2000) on tables in excess of 500 GB, increasing load performance by more than 800% and report performance by more than 60%
- Developed roll-up procedures and custom reporting with direct client interface for top 10 clients
- Speaker on "SQL Server Internals" at Dev Connections in Las Vegas, NV, Fall 2008
- Speaker on "SQL 101 Track" for SSWUG's virtual conference, Spring 2009
EXPERIENCE
Database Architecture- Specialize in RDBMS technologies on Windows platform
- VLDB design, architecture, development, and performance tuning, using agile and waterfall methodologies
- Create data warehouses through in-depth data discovery and transformation to a common platform
- Build revenue-generating backend/databases for various product lines
- Solutions in SQL Server versions 6.5 to 2005, and advanced prep and analysis of SQL Server 2008
- Enterprise solution using SSRS 2005 and OLAP to replace more than 400 Seagate reports
- Horizontal partitions on tables in excess of 500 million records in SQL Server 2000
- Insurance rating and pricing engine for corporate financial division
- Requirements to satisfy CISP compliance, including automated tracing and storing
- Logical and physical data models to support specific needs in SQL Server and Oracle
- Data-flow process, linking mechanisms such as call tracker to accounting record for NAS calls
- Provide system analysis and recommendations; propose solutions to executives, management, and staff
- Discover and resolve glitches in Microsoft software that have resulted the development of hot fixes
- Maintain databases in excess of 1TB for performance, backup times, san architecture, and archiving data
- Author procedures and standards for RDBMS technologies, including best practices, performance metrics, naming conventions and change control processes
- Led team converting RDBMS solutions from Oracle, VAX and FoxPro to SQL Server
- Led team conceptualizing business needs and modeling software solutions
- Led significant database development projects including stored procedure development, DTS/SSIS development, data modeling, design, and architecture using various SQL Servers, Oracle 9i, and Oracle 10g
PAST AND PRESENT CLIENTELE
Attain Technologies
Avaya Communications
First Horizon Merchant
Home Buyers Warranty
Avaya Communications
First Horizon Merchant
Home Buyers Warranty
ICG Communications
Lucent
MCI
Norwest
Lucent
MCI
Norwest
NotionONE
Oxford International
Regis University
Oxford International
Regis University
StorePerform Technologies
Wells Fargo
WorldCom
Wells Fargo
WorldCom
TOOLS AND TERMINOLOGY
Tools
CVS
DB Pro
Enterprise Architect
DB Pro
Enterprise Architect
ErWin
Idera
RedGate
Idera
RedGate
Oracle
TFS
TFS
Toad
VSS
VSS
Visio
Zachman Framework
Zachman Framework
Relevant Technology
Clustering
Constraints
Data Architecture
Data Dictionary
Data Marts
Data Migration
Data Warehouse
Database Architecture
Design and Development
Constraints
Data Architecture
Data Dictionary
Data Marts
Data Migration
Data Warehouse
Database Architecture
Design and Development
Distributed Transactions
DSS
Linked Servers
Normalization
Notification Services
OLAP
OLTP
Partitioning
Performance Tuning
DSS
Linked Servers
Normalization
Notification Services
OLAP
OLTP
Partitioning
Performance Tuning
PL/SQL Development
Re-factoring
Replication
Reporting Services
San Configuration
Star Schemas
Stored Procedures Development
Synonyms
SQL Mail
Re-factoring
Replication
Reporting Services
San Configuration
Star Schemas
Stored Procedures Development
Synonyms
SQL Mail
SQL Server 6.5
SQL Server 7.0
SQL Server 2000
SQL Server 2005
SQL Server 2008
SSIS
Triggers
Troubleshooting
T-SQL Development
SQL Server 7.0
SQL Server 2000
SQL Server 2005
SQL Server 2008
SSIS
Triggers
Troubleshooting
T-SQL Development
AFFILIATIONS
Participating Member on Standards BodiesParticipating Member on I2PADS Joint FSTC/OMG Project
Member of the Finance Domain Task Force
DevConnections Speaker - Fall 2008
SSWUG Virtual Conference Speaker – Spring 2009
REFERENCES
Available upon request.