Creed Smith Email & Phone Number

Salt Lake City, Ut, Us

American Fork, Ut, Us

• Promoted to Sr. Business Operations & Analytics Architect to design and implement strategic and impactful data solutionsutilizing ETL tools (e.g., SQL & Python) for internal executive stakeholders as well as key Domo customers and prospects.• Led internal project teams to execute on strategic objectives owned by the Chief Analytics Officer.• Advised and mentored consulting teams on advanced technical architecture and implementation strategies on keycustomer accounts.• Product owner and lead sales consultant responsible for driving functional and UX dev requirements for Domo’sOKR product offering, Domo Goals.

American Fork, Ut, Us

· Promoted to the most senior consultant in the department, responsible for supporting the consulting team in all aspects of consulting engagements.· Created advanced data pipeline processes using Domo’s API connector framework, MySQL, and Redshift to import, transform, integrate, and visualize customer data coming from many source systems.· Provided formal training to entire consulting department on advanced, cutting-edge Domo functionality.· Acted as primary consultant assigned to resolve significant customer escalations requiring in-depth customer relationship building as well as technical and strategic architecture decisions.· Chief data architect and system administrator on several major COVID-19 projects including the deployment of a data command center and case investigation application for the State of Iowa, as well as a vaccination operations software solution for several states across the US.· Recognized as the 2020 consulting MVP for consistently achieving a 100% consulting CSAT score in addition to being the highest revenue-contributing consultant in the department.· Received the 2020 “Blue Rooster” Employee of the Year award for making significant contributions on several of the company’s most complex and strategic projects.

American Fork, Ut, Us

· Promoted to Manager to lead, coach, and inspire a team of six consultants with diverse backgrounds and skillsets.· Collaborate with Sales, Engineering, Support, and Client Services Leadership teams to ensure project success and timely resolution of escalations. · Provide pre-sales support and scoping for all new consulting projects, working with new clients to create solution roadmaps.· Recruit and interview consulting candidates.· Provide training and mentoring to new managers.

American Fork, Ut, Us

· Promoted to Principal Consultant & Team Lead to inspire consulting excellence across the Consulting organization, leading by example and utilizing radical candor to provide coaching and mentoring to members of the consulting team.· Member of various special project teams tasked with improving Domo’s product offerings and internal processes.· Frequently recognized by Executive Leadership for significant contributions on critical customer accounts.

American Fork, Ut, Us

American Fork, Ut, Us

· Hybrid business/technical consultant responsible for all aspects of consulting engagements including project scope and management as well as architecture and implementation of end-to-end Enterprise business intelligence solutions.· Created advanced ETL processes using Domo’s API connector framework, MySQL, and Redshift to import, transform, integrate, and visualize customer data coming from many source systems.· Quickly became a trusted and top-performing consultant and chosen to train and advise both technical and business consultants on data integration and transformation best practices.

I provide support for various companies' I.T. processes and business initiatives on an as-needed basis.Clients include:• C.R. England• G.E. Healthcare• Preferred CFO/SnapLock Industries• Continuum iCare• ShipEx TruckingSpecialties include:• SQL Server database administration/system maintenance• Business Intelligence development and training (including C#, SQL Server Integration Services, Reporting Services, and Analysis Services)• VBA development in Excel and Access

Salt Lake City, Utah, Us

• Administration of SAP Business Planning and Consolidation (BPC) 7.5 budget system, supporting the entire Health Sciences and University campus departments’ annual $1.5B budget• Worked closely with end users to resolve issues, provide training, and implement change requests; gained rapport with users and quickly became a trusted and respected resource• Documented, audited, and optimized several key BPC processes, resulting in increased performance and accuracy• Integrated new data from the U of U Data Warehouse into BPC system to increase functionality• Developed Business Intelligence Solutions using BusinessObjects Web Intelligence

Salt Lake City, Utah, Us

• Promoted to Corporate DBA to assist in ensuring integrity, availability, and performance of all departmental and enterprise SQL Server databases supporting over 1,200 end users• Created/monitored backup and ETL processes, activity logs, and log shipping processes to ensure peak performance and availability of production servers• Designed and created fuel transaction data warehouse and OLAP cube to enable analysis of fuel costs• Provided T-SQL and SQL Server Reporting Services training to employees in a structured classroom environment• Advised Business Analysts and Software Developers to ensure SQL processes are designed correctly and efficiently• Consistently recognized for going above and beyond to assist internal customers with requests related to performance monitoring, query optimization, and guidance regarding T-SQL, SSRS, and SSAS best practices

Salt Lake City, Utah, Us

• Supported Operations with SQL analysis and SSRS report development• Worked closely with management stakeholders to develop next-generation freight profitability model using T-SQL stored procedures and functions• Created and managed departmental SQL Server databases and Integration Services ETL processes to consolidate data from various source systems such as AS400 (DB2), Excel spreadsheets, and ftp • Quickly developed an effective cross-functional network to solve problems more efficiently

• Part of a three member team responsible for designing and establishing a new data warehouse and OLAP cube for the Product Engineering division of Family History• Developed automated Integration Services packages to extract, transform, and load data from various sources including Oracle, PostgreSQL, SOAP web services, and flat files over the internet• Created SQL scripts to transform raw, normalized data into de-normalized fact and dimension tables • Utilized SQL Server Analysis Services and MDX to develop OLAP cube functionality and custom measure groups •Developed dynamic scorecards and dashboards with Reporting Services, Excel, PerformancePoint, and SharePoint• Trained Product Engineering staff on report development technology and best practices• Worked closely with support personnel to ensure post-contract sustainability

San Jose, California, Us

• Frequently recognized for exemplary performance and classified as "Top Talent" within the Finance organization• Regularly provided advanced pricing and fiscal analysis which supported Symantec's executive Strategic Pricing Committee• Acted as Project Manager for a company-wide initiative to reduce the complexity of Enterprise SKUs and price lists by 70%• Collaborated with the Renewals teams from Americas, APJ, and EMEA regions to centralize Enterprise product renewal rate methodology and reporting• Designed advanced SQL queries, stored procedures, and functions to support reporting processes• Managed several SQL Server databases and Integration Services ETL jobs• Validated and updated legacy reports from Excel and Access and migrated them to Microsoft Reporting Services resulting in increased efficiency and visibility of metrics• Designed and developed tools for three major processes using MS Access, VBA, and SQL Server Stored Procedures which resulted in approximately 80% reduction in work time for each process

• Development, implementation, and maintenance of operational tools which streamline various job functions within the company• Critical review of existing processes to ensure quality, value, and efficiency• Prepared monthly performance and statistical trending reports for management• Created ad-hoc reports utilizing SQL, Access, and Excel• Provided technical training and support to members of the department • Worked monthly with Accounting and Treasury to reconcile corporate travel expense account• Maintained department staffing model and business continuity plan• Appointed as chief department contact for handling of corporate issues

• Created processes to audit payoff transactions which resulted in over $890,000 in savings for the company in 2005• Automated duties by implementing Excel macros, SQL and Access queries, and system processing scripts• Advised on all issues relating to paid-in-full mortgage refunds• Worked with Cashiering, Accounts Payable, and Treasury to ensure proper movement of mortgagor refunds• Developed automation programs for other departments to increase productivity and reduce errors• Sent over 79,000 refunds to borrowers in 2005 with 100% compliance• As a result of increased efficiency, helped alleviate department workload by acquiring additional duties from other team members

Monroe, La, Us

Bs, Business Information Systems

Sql Server 2005 Integration Services Certificate

As, Business