Derek Wood

Derek Wood Email and Phone Number

Senior Data Solutions Architect @ SMX
Arlington, VA, US
Derek Wood's Location
Arlington, Virginia, United States, United States
About Derek Wood

A dedicated, seasoned, and team-oriented IT/Business Intelligence professional with fifteen years of experience in data-mart, data warehouse, ETL, reporting, and data presentation for both the financial and health-care sectors. An excellent communicator with superior project management and leadership skills who excels in a fast paced, innovative team environment.Specialties: Business intelligence, multi-dimensional data modeling (star schema), ETL

Derek Wood's Current Company Details
SMX

Smx

View
Senior Data Solutions Architect
Arlington, VA, US
Website:
smxtech.com
Employees:
1852
Derek Wood Work Experience Details
  • Smx
    Senior Data Solutions Architect
    Smx
    Arlington, Va, Us
  • Smx
    Senior Solutions Architect
    Smx May 2016 - Present
    Arlington, Va
    • Gathered requirements, architected, designed, and developed data-warehouse data models.• Designed solutions for various components. All deployed on AWS cloud. • Designed and developed Python Extract Transformation and Load (ETL) / ELT code and SQL scripts to load the data-warehouse and data-marts.• Designed and developed an open-source Python library to encapsulate common ETL and ELT loading patterns (for example upsert functionality). See https://bietl.dev/ for details.• Developed an open-source framework to load and validate configuration files to help prevent failures part-way through a load sequence.• Implemented Amazon Redshift data warehouse. Migrating from previous Microsoft SQL Server warehouse. Brought load times down to one tenth of previous implementation.• Developed Python code for a web-services data access API using Python, FastAPI and DynamoDB.• Deployed MicroStrategy environments in an AWS Cloud environment. Developed MicroStrategy schema, attributes, metrics, datasets, dashboards, and dossiers to support data analysis needs of PEPFAR internal users and public website users.• Led the strategic direction for the Data Warehouse team.• Helped with Approval to Operate (ATO) attestations and documentation.
  • Superlative Technologies
    Business Intelligence Architect
    Superlative Technologies Jan 2013 - May 2016
    Arlington, Va
  • Wyle Information Systems
    Business Intelligence Architect
    Wyle Information Systems Aug 2010 - Dec 2012
  • Freddie Mac
    Business Intelligence Architect
    Freddie Mac Apr 1998 - Jul 2010
    Established Business Intelligence architectural direction for numerous large projects. Analyzed the reporting requirements and conducted interviews with a variety of data consumer groups to develop the business dimensional model. Worked extensively with business partners to learn the business domains, resulting in the creation of business models that met current requirements and supported future direction. Designed physical snowflake schema tables. Developed business rules based on the reporting requirements and in-depth analysis of the data flows and storage models of source systems. Utilized various techniques, such as elaborated business scenarios and process flows, to present complex business concepts back to the business to ensure that the business rules created, and data elements captured and reported on, were both accurate and meaningful. Designed, developed, and implemented MicroStrategy schemas and ETL jobs to load numerous data-marts.
  • Inova Health Systems
    Programmer Analyst
    Inova Health Systems Jan 1993 - Apr 1998
    Led three software developers on the clinical data warehouse project. Coordinated efforts of other department personnel, consultants, and Inova’s development partner. Created and maintained project plans. Collected, analyzed, and documented user requirements. Designed, developed, tested, maintained, and documented the data warehouse workstation (client/server) tool using Borland Delphi and ODBC. Instrumental in the design of the data warehouse database structure. Designed, developed, and tested C++ code and SQL scripts to cleanse and load data into the data warehouse. Designed and implemented a multidimensional reporting system using MicroStrategy’s DSS Agent tool.

Derek Wood Skills

Data Warehousing Business Intelligence Data Modeling Etl Data Integration Enterprise Architecture Sql Data Warehouse Architecture Microstrategy Olap Requirements Analysis Integration Data Architecture Data Marts Business Analysis Sdlc Databases Obiee Financial Reporting Oracle Sql

Derek Wood Education Details

Frequently Asked Questions about Derek Wood

What company does Derek Wood work for?

Derek Wood works for Smx

What is Derek Wood's role at the current company?

Derek Wood's current role is Senior Data Solutions Architect.

What is Derek Wood's email address?

Derek Wood's email address is de****@****ail.com

What is Derek Wood's direct phone number?

Derek Wood's direct phone number is +170356*****

What schools did Derek Wood attend?

Derek Wood attended George Mason University.

What skills is Derek Wood known for?

Derek Wood has skills like Data Warehousing, Business Intelligence, Data Modeling, Etl, Data Integration, Enterprise Architecture, Sql, Data Warehouse Architecture, Microstrategy, Olap, Requirements Analysis, Integration.

Not the Derek Wood you were looking for?

  • Derek Wood

    Editor In Chief Of Theraffinity | Disabled Entrepreneur | Mental Health Advocate | Mistake Maker | Cho Of Alertgem
    Denver Metropolitan Area
  • 2
    theguestcheck.com, theguestcheck.com

    4 +130399XXXXX

  • Derek Wood

    Greater Minneapolis-St. Paul Area
  • Derek Wood

    Director Of Operations
    Missouri City, Tx
  • Derek Wood

    Chief Legal Officer At Context Capital Partners
    Greater Philadelphia
    5
    yahoo.com, yahoo.com, cs.com, yahoo.com, contextcp.com

    2 1570879XXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.