Daniel is available for hire
Hire DanielDaniel Worden
Verified Expert in Engineering
Data Modeling Developer
Location
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
Artemetrx
Microsoft SQL Server
Zodiac Aerospace
Lawson M3, SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server
Carrington Holdings
T-SQL (Transact-SQL), Microsoft SQL Server
Experience
Availability
Part-time
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
2017 - PRESENT
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.
Technologies: Microsoft SQL Server
ETL/DW Architect
2013 - PRESENT
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).
Technologies: Lawson M3, SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server
Architect, Data Warehouse/ETL
2012 - 2013
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.
Technologies: T-SQL (Transact-SQL), Microsoft SQL Server
Database Team Manager
2009 - 2012
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.
Technologies: Microsoft SQL Server
Data Warehouse Architect
2007 - 2009
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.
Technologies: Cognos 10, Microsoft SQL Server
Senior Technical Architect
2003 - 2007
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.
Technologies: .NET, PowerBuilder, TIBCO, Microsoft SQL Server
Experience
Two End-to-End Data Warehouse Projects
I worked on two data warehouse projects that were end-to-end projects, building out the data warehouse, ETL, and reporting environments.
Sales Compensation Rules Engine
Designed a rules engine for sales compensation. Used the concepts of multiple axes and intersection points to build the rules and logic, allowing just a few tables to manage a very complex multi-tiered rules engine.
Skills
Languages
T-SQL (Transact-SQL), Stored Procedure, PowerBuilder, C#
Tools
Microsoft Excel, Visual Studio, SSAS, Lawson M3, Visual Studio .NET
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)
Other
Data Warehouse Design, Data Warehousing, Partitioning, Data Modeling, TIBCO, DAX, Cognos 10
Frameworks
.NET, ASP.NET
Platforms
Windows
Education
1993 - 1995
B.Sc. Degree in Business Administation
San Diego State University - San Diego, CA
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring