Brian Cohen

About Brian Cohen

My Focus: Engineer data transformations and processes that catch errors early to mitigate risk and ensure data integrity. Deliver savings by building custom database tools in lieu of costly software purchases. Dive deep with advanced T-SQL for urgent batch development and critical ad hoc work.My passion for data started early, way back in 1984 with AppleWorks on my Apple IIc. Today, I work in HealthTech, often with the Grateful Dead playing and a super-sweet cat keeping me company.You can visit bricohen.com for dangerously safe-for-work helpfulness. This includes links to my book,\"Real SQL Queries,\" and my \"Surreal SQL\" YouTube channel, which showcases some of the most creative and unusual uses of SQL you\'ll ever see.

Experience

1. Sr Business Systems Process Engineer

   Healthesystems

   May 2016 — Present · Tampa, FL, US

   Built a SQL-driven framework that audits pharmacy transaction billables before invoice finalization, generating significant weekly savings.• Designed a SQL-based solution that connects pharmacists with claimants, analyzes clinical patterns, and tracks outcomes, resulting in new revenue.• Enhanced business prospects by developing an RFP dataset analysis tool to evaluate sample transactions and model scenarios for precise billable and payable estimates.• Delivered high-priority projects using advanced T-SQL for ad hoc queries and complex batch data transformations.• Created stored procedures to maintain historical data from reference tables, enabling retrospective queries without temporal tables.• Replaced manual Excel-based processes with a database-driven workflow, saving thousands of hours and improving data integrity.• Earned the 2023 Core Value Award for Innovation in Business.

Education

• University of South Florida

  Bachelor of Arts, Economics

Skills

• Array Formulas
• Online Advertising
• Sql Report Writing
• T-Sql Stored Procedures
• Email Marketing
• Data Modeling
• Ssis
• Data Import/Export
• Problem Solving
• Business Intelligence
• Agile Methodologies
• Transact-Sql (T-Sql)
• Scenario Analysis
• Sql Server Integration Services (Ssis)
• Database Development
• Online Marketing
• Marketing
• Database Analysis
• Kpi Reports
• Sql Server Management Studio
• Agile & Waterfall Methodologies
• Business Analysis
• Digital Marketing
• Vba
• Report Writing
• Microsoft Office
• Databases
• Ms Excel Pivot Tables
• Microsoft Excel
• T-Sql
• Data Mining
• Roi Optimization
• Performance Dashboards
• Analysis
• Tableau
• Power Bi
• Market Research
• Microsoft Access
• Paid Media
• Microsoft Sql Server