
Daniel Worden
Verified Expert in Engineering
Data Modeling Developer
Ladera Ranch, CA, United States
Toptal member since June 18, 2020
Dan has been providing data solutions for over 15 years with SQL Server and their product suite. He has been an architect for OLTP, ODS, DW and OLAP systems, has excellent data modeling and T-SQL skills, and provides simple and customized solutions for complex business requirements.
Portfolio
Experience
- SQL Server Management Studio (SSMS) - 15 years
- Data Warehouse Design - 8 years
- ETL - 8 years
- Data Warehousing - 8 years
- Data Modeling - 8 years
- SQL Server Integration Services (SSIS) - 6 years
- C# - 3 years
- SQL Server Analysis Services (SSAS) - 2 years
Availability
Preferred Environment
Visual Studio, Microsoft SQL Server
The most amazing...
...thing I've done is use concepts of multiple axes and intersection points to build a multi-dimensional rules engine for a sales compensation application module.
Work Experience
Database BI Architect
Artemetrx
- Led the data architecture for a SaaS healthcare and pharmaceutical analytics application, for pharmacy benefit managers. Designed ETL processes to populate the data warehouse. Implemented business rules and optimized processes for monthly processing of millions of healthcare claims for close to 100 clients. Created highly optimized stored procedures for the .NET front end.
ETL/DW Architect
Zodiac Aerospace
- Created ETL in a SSIS and data warehouse in Microsoft SQL Server using MS SQL 2012. Used partitioning and ColumnStore indexes.
- Handled all of Zodiac's more complicated ETL and DW modeling tasks, such as financial and manufacturing reporting.
- Used the SSIS Package class object in .NET to create dynamic packages on the fly, providing a dynamic framework to copy table data from ODS to remote sites.
- Built a profit and loss SSAS Cube, using some MDX.
- Provided frameworks for handling many of the ETL related support features (logging, scheduling, and configuration).
Architect, Data Warehouse/ETL
Carrington Holdings
- Worked extensively with SSIS in BIDS and T-SQL in Microsoft SQL Server 2008R2.
- Designed, developed, and maintained ETL for data import/exports for 10+ sub-companies of Carrington.
- Designed new data integration processes for new vendors.
- Designed star schema models the data warehouse.
- Took a project manager role on large IT initiatives, such as environment migrations and system upgrades.
Database Team Manager
Experian Consumer Direct
- Managed database projects on our SQL Server platform with over one million visitors, and millions of page views per day.
- Managed a team of ten in a fast-paced, tight timeline environment.
- Provided data management leadership and oversight for over 15 large projects per year at our $1 billion/year company. Oversaw smaller enhancements, production bug fixes, and emergency issues.
- Developed overall database department strategy and maintained road maps.
- Built relationships with other departments to understand struggles, maximize cooperation, meet goals, and manage resources.
Data Warehouse Architect
Experian Consumer Direct
- Supported the mobile app development for FreeCreditReport.com for iPhone and Android.
- Designed, developed, and documented the ETL process end-to-end from a high-level to allow quick on-boarding.
- Designed and modeled the database for a new star schema model to track all customer-related events.
- Reviewed and documented deficiencies in the data model for future enhancements and modifications.
- Administrated the Cognos BI application and designed models using Framework Manager.
Senior Technical Architect
Option One Mortgage
- Instrumental in designing the database architecture using SOA (service-oriented architecture) by integrating existing applications with third-party applications and external vendor web services.
- Modeled complex data structures including a sales compensation rules engine, mortgage origination database, Enterprise ID management, dataset versioning, re-queueing mechanisms, and centralized error and status tracking.
- Supervised and monitored the health of mission-critical Origination servers supporting web-facing and internal applications.
- Led projects aside from the standard application development projects, such as rules engine integration, middle tier XML processes, third party applications, outsourced projects, data extracts, and nightly processes.
- Participated in QA test plan meetings, load testing, and UAT and training environment configurations.
Experience
Two End-to-End Data Warehouse Projects
Sales Compensation Rules Engine
Education
B.Sc. Degree in Business Administation
San Diego State University - San Diego, CA
Skills
Tools
Microsoft Excel, Visual Studio, SSAS, Lawson M3, Visual Studio .NET
Languages
T-SQL (Transact-SQL), Stored Procedure, PowerBuilder, C#
Paradigms
ETL, Service-oriented Architecture (SOA)
Storage
Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
Frameworks
.NET, ASP.NET
Platforms
Windows
Other
Data Warehouse Design, Data Warehousing, Partitioning, Data Modeling, TIBCO, DAX, Cognos 10
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring