Database BI Architect
2017 - PRESENTArtemetrx- 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 ServerETL/DW Architect
2013 - PRESENTZodiac 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 ServerArchitect, Data Warehouse/ETL
2012 - 2013Carrington 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 ServerDatabase Team Manager
2009 - 2012Experian 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 ServerData Warehouse Architect
2007 - 2009Experian 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 ServerSenior Technical Architect
2003 - 2007Option 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
Daniel Worden
Data Warehouse Design Developer in Ladera Ranch, CA, United States
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.
Daniel is now available for hire
Portfolio
- ArtemetrxMicrosoft SQL Server
- Zodiac AerospaceLawson M3, SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server
- Carrington HoldingsT-SQL (Transact-SQL), Microsoft SQL Server
Experience
- SQL Server Management Studio 15 years
- Data Warehousing 8 years
- ETL 8 years
- Data Warehouse Design 8 years
- Data Modeling 8 years
- SQL Server Integration Services (SSIS) 6 years
- C# 3 years
- SQL Server Analysis Services (SSAS) 2 years
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.
Employment
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 .NETParadigms
ETL, Service-oriented Architecture (SOA)Storage
Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Management Studio, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)Other
Data Warehouse Design, Data Warehousing, Partitioning, Data Modeling, TIBCO, DAX, Cognos 10Frameworks
.NET, ASP.NETPlatforms
Windows
Education
- B.Sc. Degree in Business Administation1993 - 1995San Diego State University - San Diego, CA
