Joel Losch

Sr. Business Intelligence Developer

Audited data flows across 60+ interdependent databases and consolidated them into a unified, metadata-driven solution. Built a new SSIS data integration framework, improving reliability to 97% and reducing load times from days to hours.

SQL ServerT SQLSSISData IntegrationData ModelingGitTDESOC2AIQA validation

Data Architect

Led discovery on existing Salesforce data flows to evaluate a Snowflake-based pipeline architecture. The recommendation was tabled after cost analysis outweighed projected benefit.

SalesforceSnowflakeData ArchitectureDiscoveryCost Analysis

AVP / Senior Analytical Consultant

Wells Fargo

Reengineered the Impairments process, increasing automation and reducing processing time from weeks to minutes. Developed and stabilized BI reporting and analytical tools for financial operations.

BI ReportingData AnalysisAgileWaterfallTeam LeadershipFinancial AnalysisSQL

Database Developer

Reduced duplicated and missed fees during billing by rewriting key portions. Decreased development time from three months to three days by rewriting configuration tables.

SQL ServerT SQLSSISQuery OptimizationIndexingData Modeling

Business Intelligence Developer

Aetna

Resolved a critical data warehouse reload failure by rewriting claims processing logic to handle 100M+ records in batches. Developed and maintained SSIS packages to consolidate healthcare claims data from 60+ sources.

SQL ServerT SQLSSISData WarehouseHIPAAQuery OptimizationBatch Processing

Business Intelligence Developer | Database Administrator

Managed production database environments and maintained SSAS cubes. Implemented transactional replication, reducing nightly load processes from 8 to 2 and improving completion rate from 73% to 83%.

SQL ServerSSASReplicationDatabase AdministrationData WarehouseExcel

SQL Server Report Developer / Data Analyst

Developed SQL Server reports and performed data analysis.

SQL ServerReportingData Analysis