Daniel Wilson

Daniel Wilson Email and Phone Number

Data Architect | Data Modeler | Data Analyst | Business to Tech Liaison | Data Visualizer - Tableau Desktop Certified | Fox Business Analytics Certified @ Community College of Philadelphia
Daniel Wilson's Location
Greater Philadelphia, United States, United States
Daniel Wilson's Contact Details
About Daniel Wilson

I am an experienced IT professional with extensive background in Data Architecture.Before moving into higher education at Temple University, I had a 15+ 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, I advocate for the use of data governance and analytics. I put into place processes and standards for improving quality and ensuring one version of the truth for enterprise data within the organization. And I lead the use of new data warehousing and business intelligence technologies to provide valuable insight into the organization’s data. I act as a liaison to user departments for consistent and accurate data integration to formulate actionable metrics.Over the past 7+ years, I have been designing dashboards, visualizations and infographics using Tableau and Adobe Illustrator at Temple University. I co-led the Temple Tableau User Group which has about 60 members from staff and administrative areas.I work with users to model any new data brought into the data warehouse, publish Tableau data sources for Tableau creators, as well as help them learn Tableau. I also design dashboards for Tableau viewers.Expertise• Data Architecture & Data Governance (Data Stewardship, Metadata)• Data Visualization (Tableau)• Data Modeling (Conceptual, Logical, Physical)• Designing OLTP and Dimensional database schemas• Architecting data warehouses & operational data stores (data visualizations/analytics, ETL/ELT, & BI reporting) • Working with DW/BI vendors to evaluate tools, choosing technology directions, & implementing solutions for clients.• Presenting at user conferences. Writing white papers justifying technology directions• SQL (complex queries, Anaconda & Azure Databricks Notebooks, PL/SQL, T-SQL)• SQL and DB Object performance tuning• Data Integration • Database administration working with Oracle & MS SQL Server• Installing, configuring, maintaining Oracle & SQL Server instancesCore Competencies• Database Designo Data Modelingo Erwino SQL• Data Architectureo Enterprise Data o Metadata Management• Data Warehousing • Business Intelligenceo Tableau Desktop Specialist Certifiedo Data Visualizationo Power BIo Cognos • Business Analyticso Fox Business Analytics Certifiedo Oral Communicationo Presentationso Business to Tech Liaisono Business Analysiso Data Analysis o Statisticso Microsoft Office Specialist Certified – Excel

Daniel Wilson's Current Company Details
Community College of Philadelphia

Community College Of Philadelphia

View
Data Architect | Data Modeler | Data Analyst | Business to Tech Liaison | Data Visualizer - Tableau Desktop Certified | Fox Business Analytics Certified
Daniel Wilson Work Experience Details
  • Community College Of Philadelphia
    Senior Business (Tableau) Analyst
    Community College Of Philadelphia Apr 2024 - Present
    Philadelphia, Pa, Us
    Everything Tableau. Mostly designing and creating content, working with administrators at the college, but also managing our Tableau Cloud environment.
  • Munich Re Specialty Insurance
    Senior Data Modeler
    Munich Re Specialty Insurance Nov 2022 - Dec 2023
    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
  • Temple University
    Enterprise Data Warehouse Architect
    Temple University Nov 2013 - Apr 2023
    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.
  • Vanguard
    Data Architect
    Vanguard Mar 2013 - Nov 2013
    Valley Forge, Pa, Us
    Data Modelling and Enterprise Metadata Management
  • Genesis Healthcare
    Data Warehouse Architect
    Genesis Healthcare Sep 2012 - Apr 2013
    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.
  • Accenture Federal Services
    Data Architect
    Accenture Federal Services Jun 2008 - Jul 2012
    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.
  • Gsi Commerce- An Ebay Company
    Data Architect
    Gsi Commerce- An Ebay Company Aug 2007 - Jun 2008
    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.
  • Ellucian Higher Education Systems (Formerly Sungard Higher Education)
    Data Architect
    Ellucian Higher Education Systems (Formerly Sungard Higher Education) Nov 2000 - Aug 2007
    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.
  • Dun And Bradstreet
    Manager Data Warehousing
    Dun And Bradstreet 1999 - 2000
    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.

Daniel Wilson Education Details

  • Fox School Of Business At Temple University
    Fox School Of Business At Temple University
    Business Analytics
  • Lehigh University
    Lehigh University
    P.C. Rossin School Of Engineering - Computer Science And Engineering
  • Penn State University
    Penn State University
    Smeal College Of Business - Quantitative Business Analysis
  • Penn State University
    Penn State University
    Eberly College Of Science - Computer Science

Frequently Asked Questions about Daniel Wilson

What company does Daniel Wilson work for?

Daniel Wilson works for Community College Of Philadelphia

What is Daniel Wilson's role at the current company?

Daniel Wilson's current role is Data Architect | Data Modeler | Data Analyst | Business to Tech Liaison | Data Visualizer - Tableau Desktop Certified | Fox Business Analytics Certified.

What is Daniel Wilson's email address?

Daniel Wilson's email address is da****@****ple.edu

What is Daniel Wilson's direct phone number?

Daniel Wilson's direct phone number is +161021*****

What schools did Daniel Wilson attend?

Daniel Wilson attended Fox School Of Business At Temple University, Lehigh University, Penn State University, Penn State University.

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.