Daniel Wilson Email & Phone Number

Philadelphia, Pa, Us

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 the target platform is an Azure Databricks Data Lakehouse

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 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 has to 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.

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 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. Utilized Oracle and SQL Server.• 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.

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 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 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 architecture, ETL, and BI/Reporting.Data Warehouse Architecture • 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 was developed.• 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). • 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.

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