David A Johnson Email & Phone Number

Saint Paul, MN, US

Mclean, Virginia, US

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

Hudson, WI, US

• 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.

Las Vegas, Nevada, US

• 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.
• 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.
• 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.

St Paul, Minnesota, US

• 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.
• 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.
• 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.

Saint Paul, MN, US

• 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.
• 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.

• 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.
• 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.
• Conducted enterprise BI assessment in conjunction with establishing forward looking (5 year) BI roadmap. Troubleshoot organizational reporting process issues.

Chanhassen, MN, US

• 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%.
• 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.

Mba, Management Information Systems, Organizational Productivity, And Strategic Management

Bs, International Business, Marketing