Derek Ludwig Email & Phone Number

Morrisville, NC, US

Morrisville, NC, US

Morrisville, NC, US

• Enterprise Data WarehouseSenior Data Developer / Data Architect
• Lead architect on Premier Research's internal Data Warehouse and BI platforms
• Event based architecture is being used to integrate data into the Data Warehouse
• Design Qlik Sense dashboards for use across the entire organizationArchitecture: Azure SQL Database, Azure Automation, Azure Data Factory, Azure Data Lake, SSIS 2019, T-SQL, PL-SQL, XPath, XQuery, Qlik Sense

Research Triangle Park, NC, US

• Senior Data/BI Architect
• Develop and Execute on RTI's BI/Big Data Strategy
• Lead architect on RTI's Microsoft Azure environment(BI/Big Data focused)Architecture: MS SQL Server 2016, SSIS 2016, T-SQL, Azure Data Lakes, Azure Data Factory, Azure Analysis Services, Azure SQL Data Warehouse, Azure.

Research Triangle Park, NC, US

• Enterprise Data WarehouseSenior Data Architect
• Manage team of off-shore and on-shore resources
• Mentor junior staff
• Responsible for BI Demand management by working directly with key stakeholders throughout the company
• Lead architect on RTI's internal Data Warehouse and BI platforms
• Lead architect on all internal integration projectsArchitecture: MS SQL Server 2016, SSIS 2016, T-SQL, PL-SQL, Web Services, XML, XSLT

Research Triangle Park, NC, US

• Enterprise Data WarehouseData Architect
• Lead Architect in the development and implementation of an Enterprise Data Warehouse
• Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling, Conformed Dimensions
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate.
• Integrate data from Relational databases, Flat files, XML data sources, Web Services, OLAP cubes
• Perform data modeling, data source analysis, data sourcing specifications, ETL design & specification

Research Triangle Park, NC, US

• Application Design & IntegrationDesign Architect
• Lead Integration Architect on the following SaaS Implementation Projectso Salesforce.como CornerStone On Demando Concur Travel and Expenseo SciQuest (Procurement)o Deltek Costpointo Oracle Fusion HCM
• Created Sequence Diagrams to depict the flow of information between systems
• Responsible for the design of ETL packages to move data into and out of applications
• Responsible for the overall modeling of the data when incorporated into the EDW for adhoc analysis and reporting out of Cognos BI
• Responsible for the overall design how each system would be configured to meet the requirements of the company

Research Triangle Park, NC, US

• Budgeting & Forecasting Tool Senior Software Engineer / Lead Software Developer
• Lead Developer and Design Architect on a project to develop an OLAP based Cost to Complete/Proposal Budgeting application.
• Users have the ability to directly enter data into the application having revenue calculations execute on the fly.
• Use of IBM Cognos TM1’s API was used to develop the more complicated dynamic reports and templates.
• System interfaces with RTI’s accounting system, Costpoint, where all project, accounts, orgs and accounting rules are maintained.
• System mimics the real-time revenue calculations of Deltek Costpoint accounting system

• Founding member of an IT consulting firm providing application development, software engineering, and management consulting services. Lead architect of the firm’s flagship product, the Webenetics Portal, a.
• US Navy, NAWCAD / NAVAIR
• The Smithsonian Institution, National Air and Space Museum
• MCI Worldcom

US