Mark Gorczyca Email & Phone Number

Boston, MA, US

• Served as “technical product owner” for agile teams responsible for analytic platform development projects
• Consolidated disparate backlogs from TFS, Smartsheet, and ServiceNow to a single JIRA backlog to facilitate grooming sessions with product owner
• Reviewed existing defect logs and performed rapid root cause analysis to fast-track resolution of all open critical defects within first 30 days of joining team
• Served as subject matter expert for legacy healthcare claims systems, data marts, and ETL processes
• Produced visual documentation of daily processes related to loading of data marts, processing of cubes/tabular models, and operational extracts built against data marts
• Developed proof of concept PowerBI reporting solution to replace OnBase native reporting solution for Provider/Member call center system

Atlanta, GA, US

• Performed assessment of HealthLink’s SQL Server based data platform following their lift and shift to Azure, produced list of recommendations to reduce cost, improve system performance and development process
• Reduced SQL Server core licensing spend by 50% through performance tuning while improving performance of all ETL processes. Critical confidence scoring algorithm job was reduced from 27-hour duration to 1.5 hours and.
• Led development team in project to rearchitect existing monolithic application data platform into isolated environments for ingestion and cleansing, applications, scheduled extracts and analytics to avoid database.
• Developed custom auditing/logging framework to support automated QA processes and analytics related to existing ETL systems
• Implemented new database backup to azure blob storage process to reduce storage retention costs associated with existing on-premise solution
• Implemented azure monitoring to proactively alert team members before scheduled database processes failed

Atlanta, Georgia, US

• Provided PowerBI Solution proof of concept which led to a yearlong data insights engagement for an Alpharetta based insurance industry client
• Developed SQL Server based data warehouse using a dimensional model to simplify client’s reporting efforts and reduce reporting load on their OLTP databases which was causing performance degradation in their application
• Migrated client’s PowerBI based data model to Azure Analysis Services tabular model to support increasing data footprint and improve performance of their Power BI reports/dashboards
• Implemented row-level security in tabular model to ensure users were restricted to only view appropriate data
• Collaborated with application engineering resources to expose the new Power BI solution through a PowerBI embedded interface within their web application.
• Migration of SSRS reports from OLTP sourced data to make use of the new data warehouse

Boston, MA, US

• Successfully led team to enhance Zelis’ existing BI Platform to store claims from additional healthcare claims platforms acquired through M&A
• Provided architectural direction to client for automation of manual processes and remediation of security concerns related to an existing PowerBI solution
• Resolved multiple DB/ETL/SSAS performance related bottlenecks exposed by tripling the data footprint of the existing data warehouse
• Delivered the Zelis Analytic Dashboard, a PowerBI reporting solution making use of a new on-premises SSAS Tabular model accessed through a PowerBI on-prem data gateway
• Refactored Zelis’ existing SSRS-based daily revenue reporting to make use of enhancements to their data model and cutting costs related to manual activities being performed daily to merge data from multiple platforms.

Boston, MA, US

• Evaluated BI Platform architecture/design upon engagement, generated $50,000 in savings by avoiding a planned hardware purchase through configuration and tuning of environment using 75% of the existing computing.
• Leveraged subscriptions/data-driven subscriptions to replace homegrown C#/VB solutions that generated scheduled reports for delivery
• Developed an automated SSRS subscription report with data sourced from multiple SSAS cubes to replace a complex MS Excel executive dashboard being generated manually each day. This saved four man-hours daily, allowed.
• Developed an executive scorecard that offered consolidated views of key financial metrics including revenue trends, cash receipts vs budget, realization rates, and cash projection by client
• Designed and developed provider count data mart storing periodic snapshot provider count data to support dashboards measuring PPO network health and churn
• Developed network data loading framework (SSIS/T-SQL) to process demographic and fee schedule data delivered by Dental PPO network partners in over fifty unique file formats and layouts. This system is supports a.

• Lead developer for Ross EPM (Enterprise Performance Management). EPM is CDC’s enterprise DW/BI solution for analytics based on the Ross ERP.
• Mentored three junior developers in Shanghai, China in development using the Microsoft BI stack and a third-party report viewer
• Redesigned the Inventory data mart and cube to improve performance of the solution and support better insight into our customers’ inventory activity
• Improved the design of the SSAS database solution following Microsoft best practices to allow for improved query response performance
• Served as sole resource in the US to assist support with customer incidents
• Assisted technical services with implementations of the product and customizations to the SSAS solution to meet customer needs

Mcdonough, GA, US

• Translated requirements for filtering questionable records received from our medical distributors’ trace sales files into an automated system that would exclude records and alert marketing data staff to review for.
• Responsible for the continuous enhancement of our overall BI solution in response to requests and feedback from users
• Sole administrator of our BI portal
• Provided models and guidance for the development of a new sales compensation program following sales force merger
• Trained executives, management and sales reps in effective use of the BI portal
• Worked closely with upper management to develop insights to more easily analyze their business using MDX, T-SQL and Reporting Services

Mcdonough, GA, US

• Internal project manager for implementation of OLAP - based Business Intelligence tool (BI Navigator) to replace our sales reporting software
• Gathered requirements and business rules from sales and marketing staff to model the sales analysis data mart and stored procedure logic for populating the data mart
• Mapped fact/dimensional data from over twenty data source groups including internal systems and trace sales data from multiple medical distributors into sales analysis data mart
• Supervised the Systems Analyst position
• Responsible for development, maintenance, and training for sales support tools
• Responsible for all ad hoc reporting for the sales and marketing departments using T-SQL, Visual Basic and Reporting Services

Mcdonough, GA, US

• Sole resource for resolution of all technical incidents for Encompass’ Executor2000/NET Distribution and Inventory Management System
• Help desk phone support for both end users and our cost management consultants who worked directly with customers
• Performed on-site installation of system and trained hospital/commercial laundry staff on PC and Palm hand-held software

Master Of Science, Management Information Systems

Bachelor Of Arts, Business Economics