Designing Resource Management Solutions (RMS) for Centers for Disease Control (CDC)

• Guided operations dashboard development for sales, invoice, call center data dashboard. Mentor staff on application usage and best practice for PBI service implementation. • Coordinated with Data Architect for SAP & Cisco data integrations to SQL Server Data Warehouse. • Assembled the data layer, logic layer, and presentation layer for optimal end user result. • Designed security process for Power BI Service for 2K+ employees.

• Provide guidance transitioning from Tableau to Power BI and provided best practice processes guidelines. Guide requirements for customer analytics portal and dashboards. Provide best practices for data integration, dashboard development, UI design, and Power BI Service administration.• Conducted Power BI training sessions for beginner & advanced data users along with one-on-one mentoring. • Optimize existing production data models and develop new models. • Implemented row level security (RLS) for Power BI integration for multiple external customer portals using embedded PBI dashboards. Define Snowflake tables/views for Power BI integration (TekPartners-client Sightline Payments, May 2, 2022 – Dec 31, 2022).• Developed Proof of Concept Power BI health assessment dashboard for a California based senior health care provider new to Power BI. Mentored IT staff on Power Bi Service admin (Confidential client, Feb 1, 2022 – April 29, 2022).

• Managing the team’s data integration of acquired affiliates companies into the Azure data warehouse and architecting the reporting solution communicating financial analysis for Smart Care for C-level executives and private equity ownership. Concurrently, architecting an analytics solution for upselling Smart Care organization. • Partnered with business units to re-energize business using new KPIs and dashboards to analyze & assist in overcoming post-Covid impact (GL sales returned from monthly $7.8M to $15.6M via combination organic growth and acquisitions); an increased focus on supply chain issues.• Established mentoring processes for power users and novices while implementing a teach the teacher model to drive analytic and self-service reporting processes. We also conducted one-on-one training utilizing hands-on web sessions with Power BI tools. Coached novice report developers to become quasi-expert Power BI Service administrators

• Established an organizational cloud-based Reporting & Analytics (Power BI) platform to leveraged multi-sourced data. Assisted business units in the creating KPIs and data driven processes to support business goals.• My team provided training/mentoring (structured and unstructured) for self-service report development and classroom style sessions to educate personnel how to source & utilize data to build their dashboards to augment trend analysis for improved business decision making processes. • We supported a new streaming business service (TPT Originals streaming from 0 to 29K viewers), based upon data analytics, and augmented significant growth in another streaming venture (Rewire streaming growth from 62K to 174K monthly users) and overall organizational operational efficiency from 13.4% to 16.6%.

• Designed analytics models for a dashboarding program. Establishing framework for data governance policy for large non-profit media firm.• Assessed organization BI system and developed migration plan to IBM Cloud Analytics and developed proof-of-concept prototype for business units. Conducted training program to help drive adoption of new analytics processes.• Designed/developed a commercial BI Assessment solution used to conduct organizational BI maturity assessments and develop road- maps as revenue generating service, $525K in first year.• Managed enterprise BI installation team and migration team process; migrating content from AIX to Windows platform.• Designed a dimensional logical and physical data models for BI reporting. Helped improve overall reporting performance; one report that required 38 execution hours was lowered to 3 minutes execution time. Established a metadata layer for managing security, business rules, querying, and reporting.• Conducted enterprise BI assessment in conjunction with establishing forward looking (5 year) BI roadmap. Troubleshoot organizational reporting process issues.• Managed enterprise BI installation team and BI Migration team, migrating content from AIX to Windows platform. Project manager upgrading client applications; OLAP and BI reporting systems. Optimized data reporting processes. Mentored and trained staff in BI best practices.• Implemented BI reporting system on AIX using Banner ERP database for soliciting alumni donations. Developed a training program/curriculum and conducted extensive teaching/mentoring classroom sessions for personnel on relative BI best practices and knowledge transfer for a major Twin Cities university.

• Incorporated an enterprise BI platform (IBM Cognos) and migrated existing departmental reporting (Oracle Hyperion, Excel ) to the new centralized enterprise reporting and analytics platform within 2-year plan and 18% below budget. Primary focus was operational support and sales analysis.• Managed a team that implemented and developed an analytics platform that scaled output 354% from 22,000 monthly to 78,000 monthly reports, dashboards, data extracts, and semantic models (IBM Analytics).• Hired, mentored, and managed staff of 3. Managed large projects implementing new or upgrade existing reporting & analytic platforms. Completed major projects on time within budget.