Business Intelligence Power Bi

Robert Reitz

Senior SQL Developer and Business Intelligence Architect

St. Louis / Sullivan, MO *******@*****.*** 314-***-****

Professional Summary

Dynamic and results-driven Business Intelligence (BI) Architect with 27+ years of expertise in SQL Server development, administration, architecture and optimization. Proven track record in designing scalable data warehouses, EDWs, ETL pipelines, and advanced analytics solutions across cloud platforms including SQL Server, Oracle, Teradata, DB2, Azure, AWS, Snowflake and Databricks..

●Excels as Administrator and Developer in numerous BI tools like Power BI, SSIS, SSRS, Power Apps, and Power Automate, delivering dashboards and reports that provide data-driven decision-making and operational efficiency.

●27 years experience as SQL DBA, SQL Developer, Query and Index Optimization, Data Architecture, Data Warehouse and Data Mart Development and Migration with numerous systems including Microsoft SQL Server, Oracle, Teradata, MySQL, Postgresql, DB2, Azure, MongoDB, AWS, Google Workgroups and other database systems.

●Acted as Lead/Mentor/PM/Scrum Manager for full-cycle projects from requirements gathering to deployment, optimizing databases for performance (e.g., via indexing and query tuning), and mentoring teams to achieve award-winning results, including 2023 Top Developer Award at Centene.

●Security-focused leader with hands-on experience in CI/CD (GitHub, Jenkins, etc), Kubernetes and other virtual environments / Azure, AWS, GWS tenants, API integrations, and Agile methodologies, consistently delivering innovative solutions that reduce costs, enhance scalability, and boost stakeholder satisfaction.

Professional Experience

Senior Business Intelligence Architect

Data Directive (Self-Employed Contractor), Sullivan, MO

October 2024 – Present

●Delivered contract projects to private clients based in AI, Data Resources, Security, and on demand / self service reporting.

●Architected several data warehouses and ETL pipelines using Azure, SQL Server, SSIS, and Power BI, resulting in optimized reporting for clients.

●Served as equity advisor and mentor for startup Allysolutions.ai, bringing insights to data, security, and AI tech as well as CX and Marketing concepts.

●Worked with Ageninc AI as an AI Generalist to create many workflows using tools such as Twillio, ElevenLabs and other upcoming tools to create workflows and bots to enhance automations and pipelines to CRMs and Databases.

●Implemented AI based solutions that used API connections to various common CRMs.

●Implemented many code and no-code AI systems for simple call tasks as well as complex security driven CRM based voice/sms/FB/WA call center solutions.

●Streamlined client data extraction and integration processes, enabling faster insights and scalable analytics environments.

Senior Business Intelligence Architect

Centene Corporation, St. Louis, MO

August 2022 – October 2024

●Architected and maintained multiple Data Warehouses, Data Marts, and Data Lake Environments in SQL Server, as well as Database and EDW Teradata Environments. Also worked with Snowflake migrations.

● Performed a lot of stored procedure, trigger, optimization (query/Index) work to optimize performance.

●Engineered ETL processes using SSIS, Python and Control-M, integrating data from Azure, Oracle, Snowflake, and more, supporting claims adjudication, analytics, and provider experience.

●Developed 40+ Power BI dashboards and numerous Power Apps (canvas/model-driven) for feedback collection, FAQ systems, and mobile/desktop interfaces, integrating with Power BI for enhanced user engagement.

●Automated workflows with Power Automate for ETL instantiation, file management, notifications, and data stewardship approvals, improving efficiency by 30%.

●Managed Power BI gateways, Azure VMs, security, subscriptions, and migrations to Teradata/Snowflake/Databricks; led full project lifecycles including budgeting, prototyping, testing, and release.

●Optimized SQL/Teradata databases for performance; trained/mentored teams on SQL, DAX, MDX, SSIS, SSRS, and Power BI.

●Awarded 2023 Top Developer and Active Innovator in Centene's Spark Challenge for groundbreaking BI contributions.

Business Intelligence Architect

Electrical Components International, St. Louis, MO

August 2020 – August 2022

●Built and optimized data warehouses in SQL Server and Azure Hyperscale, implementing ETL via SSIS and Qlik Replicate for integrations with DB2 and Postgres.

●Migrated QlikView dashboards to Power BI and developed Numerous Power BI dashboards plus custom .NET/Java sites using Power BI Embedded.

●Configured Qlik Replicate for full load, CDC, and change store processes; managed clustering, replication, and upgrades from SQL 2017 to 2022 and to Azure Hyperscale.

●Led agile ceremonies (stand-ups, grooming, retrospectives) and full project lifecycles; trained teams on SQL, MDX, SSAS, SSIS, SSRS, Power BI, Qlik Replicate, Java, and .NET.

●Oversaw Power BI/Power Apps ecosystems, Azure security, and databases, ensuring robust performance and scalability.

Business Intelligence Architect

Maritz Motivation, St. Louis, MO

November 2016 – April 2020

●Designed data warehouses in SQL Server and Azure, with ETL processes via SSIS integrating Teradata, AWS, Oracle, DB2, and Sybase.

●Created Numerous Power BI dashboards, custom visuals using Java/Power BI SDK, and Power BI Embedded sites in .NET/Java.

●Managed Office 365 Power stack (Power BI, Power Apps), Azure resources, clustering, replication, and upgrades from SQL 2008 to 2017.

●Directed agile processes and full project lifecycles; optimized databases and trained teams on SQL, MDX, SSAS, SSIS, SSRS, Power BI, Java, and .NET.

Business Intelligence Tech Lead

MaritzCX, St. Louis, MO

July 2014 – November 2016

●Developed data warehouses in SQL Server/Azure with SSIS ETL for multi-source integrations; built SSRS reports, dashboards, and MDX-based cubes.

●Converted SQL datastores/cubes to Hadoop; designed SharePoint web parts/dashboards and custom .NET presentations.

●Managed Azure setups, clustering, replication, and upgrades from SQL 2005/2008 to 2014; led agile teams and full project lifecycles.

●Trained/mentored on SQL, MDX, SSAS, SSIS, SSRS, and .NET.

Business Intelligence Tech Lead

Ameren, St. Louis, MO

January 2013 – June 2014 (Consultant)

●Architected data warehouses in SQL Server, Oracle, and Teradata with ETL via .NET, SSIS, and Informatica; developed SSRS/OBIEE reports and dashboards.

●Converted Oracle assets to Teradata; managed SSRS servers company-wide and SharePoint dashboards.

●Led full project lifecycles, optimizations, and training on DataMart/SSRS; customized reports in MS Dynamics ERP.

Earlier Roles (1992–2013)

●Biomedical Systems: Led BI initiatives, ETL from Oracle, SharePoint integrations, and RightFax API workflows.

●US Bank: Architected BizTalk/.NET solutions, ETL, SSRS dashboards; managed clustering and upgrades.

●Realtime Results: Handled multi-TB SQL administration, BizTalk imports, RESTful services, and SharePoint BI.

●Coventry Health Insurance: Designed Benefit Express DW, Oracle-to-SQL conversions, and BI for Cognos/BO.

●Joyce Meyer Ministries: Implemented DW, ETL, SharePoint BI, and trained on SQL maintenance.

●Oakwood Systems Group: Managed BI projects with .NET, SQL, ProClarity, BizTalk; architected DWs.

●Mercy Health Plans: Built .NET/SQL apps, advised on architecture, optimized large DBs.

●Apex Systems – RehabCare: Managed dev environments, backups, and SQL upgrades.

●Data Directive (Owner): Led .NET/SQL web apps, data conversions, e-commerce.

●Delta Dental: Managed DB upgrades/migrations to SAN, optimizations.

●Data Experts: Built .NET sites, converted FoxPro/Access to SQL.

●American Gourmet: Administered DBs, e-commerce sites, Crystal Reports.

●Lutheran Church Extension Fund: Managed imaging/accounting DBs, Oracle imports, Crystal Reports.

●Inforizons: Maintained large DBs, backups, advised on security.

●Digital Solutions Laboratories: Led web/e-commerce dev, replication/clustering.

●Advanced Computers, Crestwood Missouri - Owner and CEO.

Skills

Databases & Cloud: SQL Server (all versions to 2017/Azure), Teradata, Snowflake, Databricks, Data Lakes/Lakehouse, Oracle, DB2, Sybase, PostgreSQL, MySQL, AWS, Azure (VMs, Sites, Security, Hyperscale).

BI & Reporting Tools: Power BI (Dashboards, Embedded, Gateway, Custom Visuals), SSRS, SSAS (Cubes, MDX), SSIS, ADF, Qlik Replicate/View, Control-M, OBIEE, Tableau, Cognos, Business Objects, Crystal Reports, Telerik.

Development & Automation: T-SQL, PL/SQL, CLR, .NET (C#, VB), Java, Power Apps (Canvas/Model), Power Automate, BizTalk, REST/WCF Services, HTML/DHTML, PHP, PERL, CI/CD.

Methodologies & Tools: Agile (Stand-ups, Grooming, Retros), CI/CD (GitHub), Kubernetes, API Integrations, ETL Custom Apps, Data Modeling (ER/Studio, ERWin, Visio), SharePoint, Dynamics ERP/AX, ProClarity, Performance Point.

OS & Admin: Windows/Server, Linux, Networking (NT, DNS, IIS), Clustering, Replication, Backup/DR, Tuning/Optimization.

Certifications

●Microsoft Certified Technology Specialist – SQL Server (MCP ID# 3729050).

●Training: SQL Admin/Dev, Crystal/SSRS, Oracle, Networking (CNA), .NET, DTS/SSIS/SSRS/SSAS, Power BI (2016/2018), Azure/Hyperscale (2020), OBIEE (2014).

Education

●Lindbergh High School.

●Wave Technologies (1996–1998): SQL Admin/Dev, Crystal Reports/SSRS, Oracle Dev, Networking (CNA), .NET Dev.

●Microsoft St. Louis: Various courses (DTS 1998, SSIS/SSRS 2004, SSAS 2006, Power BI 2016/2018, Azure 2020, OBIEE 2014).

Professional Affiliations

●Co-Lead, St. Louis Power BI Users Group.

●Member: SQL Server Professionals, St. Louis SQL Server Users Group, St. Louis BI Users Group.

Contact this candidate