Matt Floyd Email & Phone Number

Detroit, Michigan, Us

Detroit, Michigan, Us

Santa Clara, California, Us

Business Intelligence Architect (Microsoft SQL Server Analysis Services, Reporting Services, Integration Services, Excel Services, Tableau Desktop/Server), SAP HANA, SQL Server Database Development• Launched (as EDW Technical Lead and BI Lead Architect) automated HR weekly EDW load and reporting, thus saving the company 40 people hours per week. • Architected a context aware security SSRS solution to provide managers access to their employees performance/compensation information.• Designed SSAS HR Analytics cube to track compensation, performance and retention metrics. Used dynamic security to provide each executive access to their own organization’s data.• Developed SAP HANA POC cube for End of Day Inventory Reporting.• Developed automated Excel based Factory Operations reporting.• Designed framework to check Data Quality of EDW fields using dynamic SQL stored procedures.• Developed SSAS cubes for Supply Chain to report End of Day inventory levels, Ship Plan, Billings, Backlog, and Material Reserves. Excel Detail drill through capability replaced 80 legacy SSRS reports.• Designed production and non-production SSAS environment to process and synchronize cubes.• Reduced SSAS cube development time by transitioning all production and non-production cubes to use 1 parameter driven SSIS package.• Developed over 40 Tableau dashboard/reports for Supply Chain to build confidence in Trusted Data solution and to report on EDW Operations.• Lead 9 member BI team of local and offshore developers.• Administered 30 prod/non-prod servers (SSAS/SSIS/SSRS/MDS/Tableau).• Developed SharePoint site template and setup sites for each functional area.• Coordinated with business and technical users to write functional specs for each reporting project.• Trained business users in Self Service BI (EDW querying, Tableau development, Excel reporting).

Round Rock, Texas, Us

• Supported Pricing Optimization project by upgrading existing SQL 2000 DTS packages to new SQL Server 2008 R2 SSIS packages• Developed SQL Server Analysis Services Developer Kit to establish coding standards and provide FAQ for EBI SSAS development projects.• Created SSAS usage reporting using the Excel 2010 PowerPivot add in which tracked all users/queries to over 25 SSAS servers and monitored CPU usage, free memory and free disk space for those servers.• Trained SSAS cube developers to enhance cube processing/query performance.

Round Rock, Texas, Us

• Developed Global Quality datamart to load all service records (systems, calls, incidents, dispatches)• Designed Quality SSAS 2008 cube and reduced processing time by 80 % through table and cube partitioning and performance improvements.• Upgraded 159 SSRS reports to new SSRS 2008 R2 environment.

Round Rock, Texas, Us

• Reduced time to load month end close data to ORCA Hyperion Essbase system by 90%.• Improved Accounts Payable Dashboard (SQL 2000/2005) uptime by reducing unnecessary jobs, rewriting ETL code and upgrading all Office Web Component reports.

Round Rock, Texas, Us

• Tracked ROI of $ multi-billion advertising budget by developing automated weekly OLAP reporting used by Consumer Marketing. • Automated weekly marketing lists (outbound telemarketing, direct mail, and email campaigns) to offer extended warranty to customers contributing over $50 million FY2007 revenue. • Recognized by Michael Dell for helping design first PC recycling program.• Automated daily financial/LOB reporting to track over $150 million FY2007 revenue generated through coupon campaigns.

Santa Clara, Ca, Us

Built and tested semiconductor manufacturing equipment.

Monitored 3 AS/400 servers and ensured production jobs finished on time. Assisted programmers with troubleshooting errant programs. Developed internal databases in RBASE.

Randolph Afb, Tx, Us

Maintained ground satellite communications terminal by troubleshooting and repairing all electrical and mechanical equipment. Developed internal databases in Foxbase/Foxpro.