Professional Summary

Dynamic Senior IT professional with over 15 years of experience in software engineering, data modeling, and business intelligence. Specializing in designing and developing BI reports and dashboards using Microsoft Power BI and SQL Server. Proven expertise in Cognizant/Trizetto Facets within the health insurance domain. Adept at working under pressure, managing shifting priorities, and delivering enterprise-level solutions using SDLC methodologies.

Skills & Expertise

Business Intelligence

Power BI (cloud and on-premises)
PBIRS, report and dashboard development
SQL Server, stored procedures, data modeling

Health & Software

Cognizant/Trizetto Facets, HIPAA, CMS compliance
SDLC methodologies, DevOps, Agile/Scrum
Certified Scrum Master

Additional Competencies Requirements elicitation, systems analysis, performance tuning, technical documentation, stakeholder communication.

Professional Experience

Senior Business Consultant II - Product Strategy, Sparq Holdings

06/2020 - 12/2024

Developed and maintained Power BI reports and dashboards to support client business strategies, improving data visibility and decision-making by **60%**.
Designed and implemented stored procedures in SQL Server for new business requirements, ensuring seamless integration with Cognizant/Trizetto Facets systems.
Authored detailed technical documentation and release notes for new BI features, enhancing stakeholder understanding and system adoption.
Reverse-engineered Salesforce database interactions to support a customer-facing portal, **reducing resolution times** through optimized data flows.

Senior Data Analyst / Scrum Master, Cambia Health Solutions

03/2019 - 06/2021

Led a team of six in developing BI solutions using Power BI and SQL Server, **automating internal data requests** and improving operational efficiency.
Designed and modeled data structures, integrating with Cognizant/Trizetto Facets to ensure compliance with **HIPAA and CMS regulations**.
Acted as Scrum Master, facilitating Agile processes and maintaining technical documentation for enterprise reporting solutions.

Business Systems Analyst IV, Cambia Health Solutions

03/2013 - 08/2019

Served as Subject Matter Expert for the IT pharmacy data warehouse, leveraging Cognizant/Trizetto Facets for data modeling and ETL processes.
Developed and maintained Power BI reports and dashboards, **automating manual data extracts** and improving data consistency.
Conducted performance tuning and code audits to maintain data transformation integrity.

Education & Professional Development

Master of Business Administration (MBA)

Willamette University — 12/2021

BA, Information Technology

University of Phoenix — 12/2007

Associate, Software Application Programming

ITT Technical Institute — Graduation Salutatorian, Highest Honors

Certified Scrum Master & Data Science Certificate

Scrum Alliance / Stanford University via Coursera

Career Highlights

**Increased Productivity**: Launched a local data operations system, improving service platform productivity by **60%** using Power BI and SQL Server.
**Data Transformation**: Achieved **100% transformation** of metadata and relational databases, streamlining data processes and reporting accuracy.
**Agile Leadership**: Successfully led cross-functional teams as a Scrum Master, delivering complex BI projects on time and within scope.
**Customer Service Improvement**: Reverse-engineered database schemas, updating data models and metadata, **reducing call volumes by 65%**.

JOSLYNN SMITH