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• Implemented calculation groups in existing SSAS Tabular model to eliminate the need for repetitive time series calculations throughout model to simplify maintenance and reduce future development time• Reviewed Unit/QA test plans with development team for all project backlog items/user stories leading to an immediate improvement in the quality of releases

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 was returned to nightly schedule• 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 contention issues• 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 by hand

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 resources to achieve desired performance• 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 for early morning delivery, and removed human error.• 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 client data integration product worth $1.3M annually• Staffed and managed department of two permanent employees and two long term contract employees. Responsible for $500,000+ annual HR budget• Developed standard ETL framework (SSIS/T-SQL) and documentation for loading CMS Medicare data and other industry standard data into our transactional system• Assist team members and Application Development team with performance tuning of queries and stored procedures through SQL Server execution plan analysis• Change Control Board member, responsible for change management process in production environments

• 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• Development of standard dashboards delivered with the product using the Targit OLAP viewer• Reviewed undocumented areas of the data warehouse and SSAS databases and translated code into end user documentation• Lead developer and architect for RFM (Ross Financial Management). RFM is CDC’s solution for Financial Reporting, Analysis, and Budgeting using IBM’s Clarity Systems for Financial Reporting and Budgeting.• Designed and developed integration with IBM’s Cube Manager product for arranging hierarchical relationships between dimension members (such as a Chart of Accounts)• Designed and developed financial data mart and Reporting, Budgeting, and GL Analysis cubes that employed “near” real-time reporting and cube write back for budgeting• Designed and developed SSIS solution to populate the financial data mart and dynamically modify the Reporting, Budgeting and GL Analysis cube structures based on the customer GL Structure and changes made to the Chart of Accounts (through SSIS/VB and AMO)• Assisted technical services and consultants with MDX queries used in financial report development using IBM’s Clarity Studio to improve report rendering performance

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 cleansing before loading into the data warehouse• 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