Senior Data & Business Intelligence Professional

20+ years turning
data into decisions.

I design and deliver BI solutions that scale — from terabyte data marts and ETL pipelines to Power BI dashboards and self-service analytics that drive measurable outcomes.

See my work Get in touch
20+ Years Experience
Power BI Certified Analyst
SQL Server 2000 → 2022
Azure Cloud + DevOps
Scroll
About

Analytics built on
integrity & craft.

I'm a Senior Data & BI professional based in Jeffersonville, Indiana, with 20+ years of experience delivering enterprise-scale analytics solutions. Through my firm Asadris / Symphonic Software, I architect complete data layers — SQL Server, SSIS, Azure Data Factory, Power BI — for clients across healthcare, financial services, scientific research, and nonprofit sectors.

My background spans the full BI stack: terabyte-scale data marts at Wells Fargo, enterprise reporting architecture at Eurofins Scientific, Azure-hosted SaaS platforms, and KPI systems with direct compliance implications. I've served as DBA, ETL architect, .NET developer, and lead BI analyst — I understand how every layer fits together.

I hold the Microsoft Certified Power BI Data Analyst Associate credential, Azure Data Fundamentals, and the Google Data Analytics Professional Certificate. Available for freelance and contract engagements.

Core tools
SQL Server Power BI SSIS Azure SSRS T-SQL
Specialties
Data Warehouse Design ETL Architecture KPI Reporting Dashboard Design Compliance BI
Also experienced in
Tableau C# / .NET Python R Crystal Reports PostgreSQL
Certifications
Power BI Data Analyst Associate Azure Data Fundamentals Google Data Analytics MCP: SQL Server
Skills & Tools

Full-stack analytics,
end to end.

From raw schema design to polished executive dashboard — I work across the entire analytics lifecycle.

01 / DATABASE
SQL Server 2000–2022
Full DBA expertise across 20+ years — schema design, stored procedures, query optimization, migrations, backup strategy, and multi-instance administration. Also PostgreSQL, SQL Azure, and Access.
02 / VISUALIZATION
Power BI, SSRS & Tableau
Microsoft Certified Power BI Data Analyst. Delivered self-service dashboards, KPI architectures, and executive drill-down reports across enterprise environments. Deep DAX and report server administration.
03 / ETL & INTEGRATION
SSIS, ADF & Pipelines
Designed and managed hundreds of ETL packages using SSIS, Azure Data Factory, DTS, and Pentaho. Built pipelines integrating SQL Server, Access, XML, REST APIs, Excel, and legacy FoxPro sources.
04 / CLOUD
Microsoft Azure
Azure-certified. Architected and deployed Azure-hosted SaaS applications with SQL Azure, Azure Data Factory, and Azure DevOps. Full SDLC from on-premise development through staged Azure promotion.
05 / DEVELOPMENT
T-SQL, C# & .NET
Full-stack capability — T-SQL, stored procedures, C#, ASP.NET, VB.NET, and XML. Stress-tested terabyte-scale databases to millisecond response times. Advanced Excel including Power Query and Power Pivot.
06 / PRACTICE
Agile, Git & Documentation
Agile/Scrum/Kanban via Azure DevOps and TFS. Six Sigma/Lean reporting, ITIL documentation, and full SDLC management. Experienced formal trainer for T-SQL, SQL Server, and BI tools.
Selected Work

Projects that solve
real problems.

A selection of analytics projects spanning enterprise BI, nonprofit operations, and portfolio case studies.

01
Asadris / Symphonic Software — SaaS BI Platform
As Founder & Full-Stack BI Developer, architected multiple Azure-hosted SaaS applications with complete data layers: SQL Server 2022, SSIS pipelines, Azure Data Factory flows, and Power BI / SSRS / Crystal Reports stacks. Stress-tested to terabyte scale with millisecond response targets.
Azure SQL Server 2022 SSIS / ADF Power BI SSRS
↗
02
Wells Fargo — Enterprise KPI & Compliance BI
Led BI development for legal/regulatory KPI reporting tied directly to compliance obligations. Co-led the full rebuild of the Servicing Acquisitions system post-WaMu acquisition. Contributed to a terabyte-scale data mart for Servicing Acquisitions and the S.A.F.E. division. Received two Team Excellence Awards.
SQL Server SSIS / DTS Business Objects C# Compliance Reporting
↗
03
Serenity House Analytics System
End-to-end analytics for a nonprofit halfway house — operational and warehouse databases, Power BI dashboards for bed availability and financial reporting, and a synthetic data generator modeling 150+ participants over 3 years with cluster-driven behavioral realism.
SQL Server Power BI Python Synthetic Data Nonprofit
↗
04
Cyclistic Bike-Share Capstone
Google Data Analytics Certification capstone — a multi-tool portfolio showcase analyzing 12 months of ride data across Power BI, R, and Python in a single GitHub repository. Features full DAX modeling, Haversine distance calculations, and a five-phase analysis plan.
Power BI / DAX R Python GitHub Google Certificate
↗
Contact

Let's work
together.

Open to freelance, contract, and full-time BI roles. Especially interested in data-driven organizations in healthcare, finance, and the nonprofit sector.

Email peterkodez@gmail.com Phone 812-920-9948 LinkedIn linkedin.com/in/yourprofile GitHub github.com/yourusername