Bryant Ackerman

• Develop advanced SQL and Spark SQL validations to proactively detect anomalies and ensure data integrity within production pipelines.
• Conduct data quality assurance and validation to ensure reporting accuracy across healthcare workflows.
• Maintain and optimize Databricks-based ETL workflows using PySpark and distributed processing techniques.
• Support onboarding and implementation of new healthcare clients, ensuring accurate data integration and system configuration.

Tech Stack: SQL (T-SQL, Spark SQL), PySpark, Azure Databricks, SSIS, SQL Server Management Studio (SSMS), Azure, Python, Salesforce

• Designed and deployed automated Python ETL pipelines extracting data from AS400 and SQL Server environments.
• Reduced manual reporting effort by 80%, significantly improving efficiency and data reliability.
• Built SQL stored procedures and optimized queries supporting financial and risk reporting.
• Developed Power BI dashboards and self-service reporting tools enabling business users to independently explore performance data.

Tech Stack: Python (pandas, sqlalchemy, logging, openyxl), SQL Server, AS400, T-SQL, Power BI, Excel (Power Query, VBA), SharePoint, Azure Data Studio

• Owned maintenance and optimization of SQL Server databases supporting investigative and operational reporting.
• Built and maintained ETL processes powering Crystal Reports and Power BI dashboards.
• Refactored complex queries to improve report performance and reduce rendering time.
• Led onboarding of new staff, system access provisioning, training users on data systems and reporting tools.

Tech Stack:
SQL Server, T-SQL, Azure, Power BI, Crystal Reports, Python (pyautogui, win32com.client, openpyxl) , SSRS