Daniel Worden, Data Warehouse Design Developer in Ladera Ranch, CA, United States
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

Location

Ladera Ranch, CA, United States

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

  • 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, 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

  • B.Sc. Degree in Business Administation
    1993 - 1995
    San Diego State University - San Diego, CA

To view more profiles

Join Toptal
Share it with others