Daniel Wilson Email & Phone Number

Philadelphia, PA, US

Everything Tableau. Mostly designing and creating content, working with administrators at the college, but also managing our Tableau Cloud environment.

Princeton, New Jersey, US

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.

Philadelphia, Pennsylvania, US

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. The Enterprise Data Warehouse Architect is responsible for the technical architecture.

Valley Forge, PA, US

Data Modelling and Enterprise Metadata Management

Kennett Square, PA, US

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.

Dublin 2, IE

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

US

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

• 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.
• 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 customers of the company’s technical direction of the warehouse before it.
• The warehouse supported both operational and analytical reporting. It used the dimensional modeling methodology with detail 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).

Jacksonville, FL, US

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

Graduate Certificate, Business Analytics

Master'S Degree, P.C. Rossin School Of Engineering - Computer Science And Engineering

Bachelor'S Degree, Smeal College Of Business - Quantitative Business Analysis

Bachelor'S Degree, Eberly College Of Science - Computer Science