Daniel Wilson - page *

Daniel Wilson

Greater Philadelphia

ad021v@r.postjobfree.com

linkedin.com/in/danielherbertwilson

Summary

Dan is an experienced IT professional with an extensive background in Data Architecture. Before moving into higher education at Temple University, Dan had a 25+ year career as a Data Architect in industry at companies including Siemens, AT&T, Bristol Myers Squibb, Unisys, Crayola, PPL Electric, Dun & Bradstreet, Ellucian, Accenture and Vanguard.

Typically, the first Data Architect in an organization, Dan advocates for the use of data governance and analytics. He puts into place processes and standards for improving quality and ensuring one version of the truth for enterprise data within the organization. And he leads the use of new data warehousing and business intelligence technologies to provide valuable insight into the organization’s data. He acts as a liaison to user departments for consistent and accurate data integration to formulate actionable metrics. Over the past 5+ years, Dan has been designing dashboards, visualizations and infographics using Tableau and Adobe Illustrator at Temple University. He co-leads the Temple Tableau User Group on the Tableau Community Forum. The group now has about 60 members from staff and administrative areas. He splits his time between working with users to model any new data brought into Temple’s data warehouse and publishing Tableau data sources for Tableau creators, as well as helping them with learning Tableau. The rest of his time he designs dashboards for Tableau viewers. Expertise includes:

• Data Architecture and Data Governance

• Data Visualization

• Data Modeling (Conceptual, Logical, Physical)

• Designing OLTP and Dimensional relational database schemas

• Data Integration

• SQL (complex queries, PL/SQL, T-SQL)

• SQL and DB Object performance tuning

• Database administration working with Oracle and MS SQL Server

• Installing, configuring, maintaining Oracle and SQL Server instances

• Architecting data warehouse and operational data store (including data visualizations/analytics, ETL/ELT, BI reporting,)

• Working with DW/BI vendors to evaluate tools, choosing technology directions and implementing solutions for clients

• Presenting at user conferences. Writing white papers justifying technology directions Daniel Wilson - page 2

Experience

Senior Data Modeler

Munich RE America

Nov 2022 - Present

• Responsible for creating a Common Insurance Model (Operational Data Store) and Semantic Layer for Data Operations. The purpose of the model is to combine and standardize data stores for a half dozen business units across all of Munich RE Specialty Insurance. Reports to the head of Data Architecture and Engineering. Uses the erwin database design tool and the target platform is an Azure Databricks Data Lakehouse.

Enterprise Data Warehouse Architect

Temple University

Nov 2013 – Nov 2022

• Leads all technical aspects of the data warehouse and works with departments across Temple University to model, develop, test, and implement complex mappings and workflows for multiple subject areas within the Banner ERP using Oracle Data Integrator and other technologies. Source systems include Oracle, SQL Server, MySQL, PostgreSQL, APIs and sequential files.

• The Enterprise Data Warehouse Architect is responsible for the technical architecture for the current and future state of the Data Warehouse.

• This position recommends/approves all custom modifications in the enterprise data warehouse and ensures alignment with the larger road map goals for Temple’s Data Warehouse.

• The Enterprise Data Warehouse Architect is a senior data analytics professional who can provide strategic thinking, leadership, and technical expertise in the development of the enterprise data warehouse.

• Temple uses Tableau and the IBM/Cognos software suite, and this position must possess a strong understanding of data warehousing concepts so that they can act as a liaison to the user departments for consistent and accurate data integration to formulate actionable metrics. Data Architect

Vanguard

Mar 2013 - Nov 2013 (9 months)

Data Modelling and Enterprise Metadata Management

Data Warehouse Architect

Genesis

Sep 2012 - Apr 2013 (8 months)

Developed standard process for implementing SSIS ETL packages. Implemented ETL to enable operational data to be pulled into the Genesis data warehouse from the newly acquired Sun Healthcare Systems. ERwin data modeling, developed Jaspersoft domain. Data Architect

Accenture

Daniel Wilson - page 3

Jun 2008 - Jul 2012 (4 years 2 months)

• Transformed Data Architect role into a role setting data management strategy for the software platform delivered by AFS.

• Accomplished this by becoming less hands on and mentoring developers in DB development, setting up processes for ensuring quality DB software development and implementation as well as making sure the DB solution was scalable.

• Provided Data Modeling, Database Administration and direction for Data Architecture for 4 teams of

.NET and J2EE developers, QC and delivery specialists. Set up and maintained development, test and demo database environments.

• Maintained SQL Server installation documentation for clients and SQL scripts for installing software product.

• Mentored a developer with ETL and BI/Reporting for project that used Pentaho Kettle, Analyzer and Jaspersoft to load a data mart and report on DoD Nuclear training.

• Performed data analysis using XMLSpy and by reverse engineering databases to facilitate integrating data from external systems.

• Mentored client DBAs with RDBMS install problems ensuring smooth client installs and upgrades.

• Used SQL Profiler for diagnosing deadlock issues to identify locking problems with poorly written applications, resolving critical defect issues at client sites.

• Presented Disaster Recovery recommendations and configurations for Air Force client installs providing reliable backups for data in Afghanistan and at the Cyber Operations Center.

• Mentored developers with PL/SQL, T-SQL and SQL development used in data migration scripts for new software releases helping to give them a better foundation for their DB development skill set.

• Used OEM and SSMS to increase query performance by adding indexes and materialized or indexed views. Also mentored developers with their query development to help them write more efficient SQL. This enhanced system performance as well as improved developers’ DB skill sets. Data Architect

Radial Inc.

Aug 2007 - Jun 2008 (11 months)

• Broadened the Data Architect role from that of a data modeler to one which included database administration responsibilities. This improved quality of the SQL generated by the data modelers as well as helped facilitate communication for the DBAs in the Data Management team with other teams, i.e., security and development teams.

• Reviewed deletion of sensitive customer credit card information and recommended system changes to purge historic data. Worked with security specialists to ensure PCI Compliance of data for audits.

• Installed Oracle RAC environment providing DB environment for migration to new VERTEX sales tax application.

• Tuned data warehouse queries to make sure nightly ETL process completed in outage window. This ensured the online system was available in accordance with customer SLAs.

• Working with development created data model and DDL for implementation by DBAs minimizing production issues with upgrades due to miscommunication or differences between production and development environments.

Data Architect

Ellucian Higher Education Systems (formerly Sungard Higher Education) Nov 2000 - Aug 2007 (6 years 10 months)

Data Warehousing

Daniel Wilson - page 4

• First Data Architect at SunGard. Played a key role in starting a data warehousing/BI team to provide the first reporting solution for existing SunGard ERP customers. Set direction for Enterprise Data Warehouse architecture, ETL, and BI/Reporting.

• Designed the company’s first enterprise data warehouse product. Worked closely with functional analysts, users and domain experts to facilitate data modeling sessions.

• Presented EDW Data Architecture at annual SunGard Summit User conferences attended by over 5000 higher education professionals. This informed customer of the company’s technical direction of the warehouse before it was developed.

• The warehouse supported both operational and analytical reporting. It used the dimensional modeling methodology with detailed level information.

• Designed and led development of a metadata repository for the ODS and EDW products. ETL

• Evaluated ETL Tools (SAS Data warehouse, Cognos Decision Stream, among others) resulting in use of Oracle Warehouse Builder (OWB).

• Designed and developed prototype for loading star schemas using the Oracle Warehouse Builder ETL tool. This prototype became the model for ETL development for the EDW.

• Trained development and professional services staff in ETL. Business Intelligence/Reporting

• Evaluated BI reporting tools recommending Cognos 8, and Oracle Discoverer

• Developed Cognos 8 framework manager model, and Discoverer End User Layer (EUL). Worked with author and Oracle Ace to develop Discoverer training for clients. Regarded as the person most knowledgeable about reporting tools at SunGard.

• Responsible for installation guides for clients including reporting metadata generated by SQL and XSLT, installing Cognos and Discoverer and training professional services staff. Manager Data Warehousing

Dun & Bradstreet

1999 - 2000 (2 years)

Hands-on management of DBAs and ETL specialists. Performed database administration and data modeling responsibilities. Kept production data warehouses operational meeting customer SLAs. GIS Systems Integrator

PPL Corporation

1997 - 1998 (2 years)

Served as Oracle specialist on GIS project which converted engineering maps to computer based GIS system. Ensured data quality of converted engineering data. Database Administrator

Crayola

1990 - 1997 (8 years)

Performed Oracle database administration, development and data modeling. Upgraded 1-800-Crayola Consumer system to new releases of Oracle, different OS platforms and implemented new feature releases.

Daniel Wilson - page 5

Daniel Wilson - page 6

Education

Fox School of Business at Temple University

Graduate Certificate in Business Analytics, Business Analytics 2016 - 2019

Using a market-driven curriculum that links financial outcomes and profit-driven decisions, the Fox Business Analytics program explores data visualization, the fundamental concepts of data analysis and effective information communication, data mining and “big data”, methods for cleaning data, and strategic knowledge management. It is led by the Fox School’s world-renowned faculty. Lehigh University

Master's Degree, P.C. Rossin School of Engineering - Computer Science and Engineering

1992 – 1996

MS Computer Science - Computer Science and Engineering Penn State University

Bachelor's degree, Smeal College of Business - Quantitative Business Analysis 1979 - 1982

BS Quantitative Business Analysis

Penn State University

Bachelor's degree, Eberly College of Science - Computer Science 1979 - 1982

BS Computer Science

Licenses & Certifications

Tableau Desktop Specialist

Tableau Community Leader

Tableau Consumer Badge

Tableau Author

Dashboard Design: Visual Best Practices - Tableau

Build Visualizations and Dashboards - Tableau

How to Use Data Visualization to Make Better Decisions—Faster Skills

Data Architecture • SQL • Data Warehousing • Data Modeling • Business Intelligence • Agile Methodologies • Data Integration • SQL Server Integration Services (SSIS) • Enterprise Architecture • SDLC

Contact this candidate