Senior Database / BI Developer
KEREM TAGA
TransUnion
Houston,TX
11
years of professional experience
1
Certification
Senior Database / BI Developer with 10+ years of experience delivering SQL Server, data warehousing, and business intelligence solutions across credit, healthcare, and insurance. Skilled in T-SQL, stored procedures, SSIS, SSRS, SSAS, Power BI, dimensional modeling, and SQL performance tuning, with recent work spanning Azure SQL, Microsoft Fabric, Databricks, and Azure Data Factory. Build reliable ETL/ELT pipelines, governed data marts, and reporting solutions with strong data quality, reconciliation, access controls, and production support. Partner with analysts, business stakeholders, and engineering teams to translate complex requirements into accurate, maintainable reporting and measurable operational improvements.
Work History
Senior Database / BI Developer
1 Year 2 Months- Designed SQL Server and Azure SQL reporting layers for credit and identity analytics, using reusable T-SQL views, stored procedures, and curated tables to make governed ADLS Gen2 and Delta Lake data accessible to BI and decisioning teams.
- Built incremental SQL and PySpark ETL/ELT workflows with MERGE logic, source-to-target reconciliation, and run-level audit logs, improving the accuracy and recoverability of daily reporting datasets.
- Standardized SQL and BI development through Git, Azure DevOps, reusable models, and deployment controls; optimized queries and data access patterns to improve report load performance by 25% while reducing compute usage.
- Coordinated Azure Data Factory, SQL, and Databricks dependencies using restartable pipelines, alerts, and exception handling, eliminating 20+ manual support hours per week and sustaining 99%+ on-time data delivery.
- Developed metadata-driven reporting assets and a searchable data catalog, documenting KPI definitions, source-to-target mappings, and data lineage so analysts could trace measures and investigate discrepancies.
- Produced governed SQL and Delta datasets for identity and fraud analysis, applying consistent transformation rules, historical snapshots, and versioned definitions across dashboards, analytical models, and scoring workflows.
- Designed Microsoft Fabric warehouses, lakehouses, and Power BI semantic models with OneLake shortcuts and Direct Lake, choosing SQL-based reporting or Databricks transformations according to workload and performance needs.
- Delivered validated reporting extracts and data marts across Azure and AWS, using Amazon S3, Glue, and Athena to support partner access while maintaining shared business rules, data contracts, and reconciliation controls.
- (Remote)
SQL / BI Developer III
4 Years 7 Months- Developed T-SQL stored procedures, views, functions, and reporting datasets for claims, eligibility, membership, and provider analytics in enterprise SQL Server environments spanning 200+ databases.
- Designed SQL reporting marts and optimized query patterns for high-volume claims and enrollment workloads, working with database operations teams on monitoring, availability, and recovery requirements for critical BI services.
- Tuned complex T-SQL and SSIS workloads using execution plans, indexes, statistics, and query rewrites, reducing critical nightly claims processing from hours to minutes within established reporting windows.
- Supported migration of reporting databases and ETL dependencies to Azure SQL Managed Instance and Azure Synapse, validating data, coordinating phased cutovers, and preserving downstream SSRS and Power BI report continuity.
- Built and maintained SSIS and Azure Data Factory pipelines for EDI 837, 834, and 835 feeds, implementing control totals, record-level validation, reject handling, and audit tables for reliable claims and eligibility reporting.
- Created reusable claims and eligibility data marts, collaborating with analysts to define business rules, source-to-target mappings, and reporting measures consumed by Power BI dashboards and ad hoc SQL analysis.
- Prepared governed healthcare datasets for partner reporting through Amazon S3, AWS Glue, and Athena, preserving consistent definitions, automated reconciliation, and traceable processing histories across environments.
- Applied HIPAA-aligned data controls including SQL Server encryption, row-level security, dynamic data masking, access reviews, and Microsoft Purview lineage to safeguard PHI in reporting workflows.
- (Remote)
SQL BI Developer II
2 Years 2 Months- Integrated clinical and revenue-cycle data from Epic Clarity and hospital scheduling systems into centralized SQL Server marts, giving facility and corporate teams a common reporting source instead of the separate extracts each individual site had maintained, a change that ended the recurring disagreements between facilities over whose census and volume numbers were correct.
- Designed star and snowflake schema data marts in SQL Server and SSAS with shared patient, encounter, provider, and payer dimensions, replacing the parallel reporting structures that individual service lines had each been building and maintaining alone.
- Built SSIS and Azure Data Factory packages integrating HL7 feeds and EMR extracts into the enterprise warehouse, with validation rules, reject handling, and source-to-target mappings documented for the support team that would take over ongoing operations, a handover that cut the volume of questions routed back to engineering during the months that followed each go-live cycle.
- Handled late-arriving clinical data in T-SQL, including encounters that were coded or corrected several days after discharge, so reporting stayed accurate as records changed instead of permanently freezing whatever information existed at initial load time.
- Delivered 70+ SSRS reports and Power BI dashboards across clinical quality, revenue cycle, and operations, partnering with stakeholders to define KPIs and regulatory measures before development began rather than reworking the logic after delivery, including length of stay, readmission, and claim denial measures that clinicians reviewed and formally signed off on first each cycle.
- Supported COVID-19 response reporting by rapidly building bed capacity, staffing, and testing dashboards, delivering daily refreshed operational visibility to executive leadership teams throughout peak surge periods when decisions were revisited hourly, which gave hospital administrators a single shared view of capacity and staffing across every facility instead of phone calls.
- Automated report distribution, refresh schedules, and job failure alerting across the reporting estate, eliminating 15+ manual hours per week and making executive-facing deliverables consistently ready before the morning leadership review instead of during it.
- Tuned T-SQL, DAX, and tabular models through indexing, partitioning, and aggregation strategies, cutting long-running report and query runtimes by more than 30% and keeping dashboards responsive as encounter volumes continued growing steadily, and moved the heaviest nightly refresh work outside of peak clinical hours so live reporting stayed responsive for staff on the floor.
- (Hybrid)
Data Analyst
3 Years 3 Months- Wrote the T-SQL behind recurring management reporting on policy, premium, and claims activity, giving underwriting and regional operations teams consistent numbers across their weekly and monthly review cycles rather than four competing manual extracts, then documented the business logic behind each measure so the analysts who inherited the reports could support them.
- Reconciled policy, claims, and premium data across source systems ahead of month-end close, catching mismatches such as duplicate records, missing policies, and incorrect classifications before any of them reached management and financial reporting, then documented the recurring causes so upstream teams could fix them at the source instead of at every monthly close.
- Partnered with actuarial and claims teams to define metric logic for loss ratio, retention, and claims severity, establishing shared definitions that ended the recurring disputes over which version of a given number was the correct one to bring into a meeting.
- Analyzed quote-to-bind conversion and policy retention across channels and segments, surfacing churn drivers that fed directly into pricing and marketing decisions and gave leadership a clearer view of exactly where premium was being lost each quarter, including gap between agent-written and direct-written business that nobody had been measuring consistently up to that point.
- Replaced manual spreadsheet processes with automated extracts and refresh routines built in SSIS, SQL Agent, and VBA, eliminating 15+ hours of repetitive analyst work per week and removing a recurring source of transcription and version error.
- Conducted segmentation and trend analysis on telematics and driving behavior data, supporting evaluation of usage-based insurance program performance and pricing across large policyholder populations spanning several states and rating territories, then flagged the specific driving behaviors that proved most predictive of loss for the pricing team to test in their own models.
- Performed root cause analysis on claims cost and cycle time outliers, translating findings into practical operational recommendations that leadership adopted to help reduce handling delays and shorten payout cycles across regional claims units, then built the recurring reporting that tracked whether the changes held over the several quarters that followed each rollout.
- Built statistical models in SQL, Excel, and Python to test hypotheses on pricing behavior, retention, and fraud indicators, then presented results to non-technical stakeholders in clear, decision-ready summaries they could act on without further translation.
- (On-site)
Education
Bachelor of Science - Computer Science
Skills
SQL & Database Development: SQL Server
Azure SQL Database
Azure SQL Managed Instance
T-SQL
stored procedures
views
functions
CTEs
window functions
query optimization
SQL Server Agent
BI & Reporting: Power BI
DAX
Power Query
SSRS
SSAS Tabular
paginated reports
semantic models
Direct Lake
KPI definitions
dashboards
drill-through
incremental refresh
Data Warehousing & Modeling: Azure Synapse Analytics
Microsoft Fabric Warehouse and Lakehouse
relational design
star and snowflake schemas
fact and dimension tables
conformed dimensions
slowly changing dimensions
ETL & Data Integration: SSIS
Azure Data Factory
Fabric Dataflows Gen2
Databricks Workflows
incremental ETL/ELT
CDC
SQL MERGE
EDI 837/834/835
HL7 and EMR extracts
source-to-target mappings
Cloud & Analytics Platforms: Microsoft Azure
Azure Databricks
Delta Lake
ADLS Gen2
OneLake
Amazon S3
AWS Glue
Amazon Athena
PySpark
Spark SQL
Performance & Reliability: Execution plan analysis
index and statistics tuning
query rewriting
table partitioning
SQL backup and recovery
Always On availability groups
log shipping
RTO/RPO
monitoring and alerting
Quality & Governance: Data validation
control totals
reconciliation
duplicate detection
audit logging
exception handling
Microsoft Purview
Unity Catalog
data lineage
row-level security
Programming & Automation: SQL
T-SQL
Python
PySpark
DAX
Power Query (M)
PowerShell
VBA
Git
Azure DevOps
CI/CD
automated refresh and deployment
AI & Advanced Analytics: Azure OpenAI
embeddings
semantic search
retrieval-augmented generation
MLflow
feature engineering
versioned analytical datasets
Security & Compliance: HIPAA/PHI-aware handling
FCRA
GLBA
Transparent Data Encryption
dynamic data masking
role-based access control
sensitivity labeling
access reviews
Delivery & Collaboration: Requirements gathering
stakeholder management
technical design
code reviews
UAT
production support
incident response
technical mentorship
Industry Experience: Credit and identity analytics
consumer decisioning
healthcare claims
membership
eligibility and providers
Epic Clarity
clinical quality
revenue cycle
insurance policy
premium
loss ratio
retention
telematics
Certification
- Microsoft Certified: Fabric Data Engineer Associate
- Microsoft Certified: Power BI Data Analyst Associate
- Databricks Certified: Data Analyst Associate
Timeline
Senior Database / BI Developer
TransUnion
09.2025 - CurrentRead More
SQL / BI Developer III
Blue Cross Blue Shield
02.2021 - 09.2025Read More
SQL BI Developer II
CHRISTUS Health
12.2018 - 02.2021Read More
Data Analyst
Progressive
09.2015 - 12.2018Read More
The University of Texas at Dallas
Bachelor of Science from Computer Science
Read More