Uploaded File
add photo
Tim
tms3612@gmail.com
954-892-9429
Coconut Creek, FL 33063
Data Warehouse Architecture Manager
20 years experience W2
0
Recommendations
Average rating
10
Profile views
Summary

  • A Seasoned Business Intelligence Professional with experience managing technical staff, guiding analysis, reporting, and processes improvements to facilitate better business decisions.
  • 15 years of experience working with data from entry to designing data warehouses and dashboards.
  • I bring a depth of knowledge and experience gained from working with Management and Stakeholders, managing staff, and providing data backed solutions on multiple projects.

Skills

  • Data Warehousing
  • Data Lakes
  • QA/QC
  • Dashboards
  • Oracle
  • SQL Server
  • Tableau
  • Crystal Reports
  • Cognos
  • QuickSight
  • Agile
  • Jira

Experience
Data Warehouse Architecture Manager
Oct 2019 - Oct 2019
  • Review requirements and design data storage and data warehouse for new applications
  • Design and implement ETL to import data to the cloud from multiple sources and formats
  • Work with developers to ensure that data collected through applications meet the needs for the designed reporting requirements
  • Create cloud based dashboards for business and customer facing portals
  • Project Manager for E-commerce site development
  • Design data collection templates to decrease the time needed to build e-commerce sites and to ensure all the necessary data is collected. This allows sites to be built with a consistent and replicable process
Data Warehousing ETL Project Management
Remove Skill
Business Intelligence Manager
Information Technology
Jan 2019 - Oct 2019
Deerfield Beach, FL
  • Managed the Business Intelligence Department responsible for the ingesting of more than 3 million daily transactions and the related amendments used for financial reporting and business analysis
  • Managed a multi-cultural staff of technical experts
  • Coordinated with other Departments to ensure that business needs are met efficiently and effectively
  • Worked with staff at the group level and one-on-one to identify issues and create solutions
  • Daily meetings with staff to ensure projects stayed on track and with stakeholders to provide updates
  • Developed a roadmap for software upgrades and business improvements for the BI Department
  • Worked with technical staff and implemented a plan to create a new data warehouse that allows a greater level of self-service for data requests and reports
  • Prioritize work requests to ensure priority work was completed and that all requests were tracked and completed as time and resources allowed through a continuous process of review and evaluation. Routinely tracked 50+ projects and requests • Managed multiple project using agile and waterfall methodology • Facilitated discussions between the technical staff and management to ensure that the technical staff is meeting the business needs and that any technical limitations are understood by management.
  • Routinely held meetings with management and users to identify and document needs, provide input, and offer suggestions for solutions to meet their needs effectively
  • Researched and reviewed alternative software for ETL, data management, reporting, dashboards, and analysis to improve the business.
  • Use SQL to query databases for ad hoc data requests and to validate the ETL process from source databases to the warehouse and analytics cubes.
  • Participated in the hiring and termination of staff
Agile Methodology Business Analysis Business Intelligence Data Warehousing ETL SQL Stakeholder Engagement Waterfall
Remove Skill
Senior Consultant EAM
Information Technology
Jun 2008 - Dec 2018
  • Managed data entry, ensured data consistency and conducted data QA/QC evaluations across multiple database platforms (Oracle, MS SQL Server, Access)
  • Database analysis to identify table relationships within third party databases and created relationship diagram for report writer
  • Software Administrator of a Computerized Maintenance Management Software (CMMS) used to track work orders, inventories and maintenance contracts
  • Developed reports and Key Performance Indicators within the CMMS for managers to assist with tracking work, to identify areas of concerns and areas for improvement for the maintenance department
  • Designed and implemented a data warehouse that pulled data from multiple databases. The new warehouse was used to evaluate data entry across various systems allowing the data to be automatically checked for accuracy and consistency.
  • The warehouse allowed reports and dashboards to be created using Power BI, eliminating the need for extensive SQL knowledge or access to the live data. • Provided support and reports for the evaluation of maintenance records, asset information, and current budgets to develop asset replacement plans for statewide facilities • Participated in project QA/QC Program development by providing information and support for all Departments and developing reports to facilitate the QA/QC of their processes
  • Developed project documentation to ensure consistent methods are used to complete work and for data entry for all departments
  • Lead contributor for developing a Facility Rating Program (FRP) to monitor the conditions of the Turnpike facility assets
  • Managed staff responsible for creating and maintaining reports generated from Department data sources.
  • Developed scope of work for multiple contracts and assist with the implementation and management of the contract with third-party vendors
  • Served as a Data Custodian for the statewide data governance program for FDOT
  • Developed and presented user training for CMMS software and reporting software
  • Provided user support for CMMS software and for reports
SQL SQL Server
Remove Skill
Cognos/Crystal BI Developer
Information Technology
Mar 2001 - Jun 2008
  • Developed all the reports created for management and field staff using Crystal Reports
  • Researched and implemented third party software to distribute the reports and allow them to be run on demand by staff.
  • Developed Inboxes used to monitor and manage the workflow.
  • Provided technical support for environmental issues and contract development.
  • Migrated all the reports from Crystal reports to Cognos reports.
  • Provided user support for reports
  • Participated in developing and updating the five year plan for the budget and work program for maintenance activities on an annual basis
BI Developer Cognos Crystal Reports Database Maintenance Technical Support
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Associate's in Database Development
Broward College 2015
Biology
Michigan State University 1993
Certifications
Microsoft Professional Program: Data Science
AWS Cloud Practitioner
Skills
SQL
2019
11
SQL Server
2018
10
BI Developer
2008
7
Cognos
2008
7
Crystal Reports
2008
7
Database Maintenance
2008
7
Technical Support
2008
7
Agile Methodology
2019
1
Business Analysis
2019
1
Business Intelligence
2019
1
Data Warehousing
2019
1
ETL
2019
1
JIRA
0
1
Oracle
0
1
Project Management
2019
1
Quality Assurance
0
1
Stakeholder Engagement
2019
1
Tableau
0
1
Waterfall
2019
1