Mark B.

About Mark B.

I am a senior technical professional who accomplishes various IT goals both through data proficiency and technical acumen. I streamline reporting in organizations by unifying reporting in single platforms and making data for analysis available in user tools.I am particularly skilled in ad-hoc report generation through Excel, SQL, MS-SSRS, Crystal Reports, SAS, Power BI, Snowflake.Specialties: MS/DynamicsSQLMS-SSRSSAS

Experience

1. Business Intelligence Team Lead

   PCNA

   Feb 2018 — Present · New Kensington, PA, US

   Developer/Analyst on a corporate Master Data Management(MDM) solution using SQL Server 2017, Snowflake, SnapLogic as the ETL tool, and PowerBI to exploit the data for analysis and dashboards. Google Analytics 4 data is being pulled into Snowflake DW via federated application requiring service accounts to be enabled and tokens to be generated.Consolidated corporate reporting from Excel, Crystal Reports, SSRS into a single SSRS 2017 SSRS server.Assist Application Development team with enterprise applications using VB, Classic ASP, VB.net, and C#.net. I am often the SME on homegrown systems.Created corporate data warehouse in SQL Server 2014 using SSIS as the ETL Tool. SSAS used to create analysis cubes from the data warehouse. Source data is from Microsoft Dynamics GP and CRM, Infor Syteline, FDM4, QRRS, Provia WMS and the aforementioned homegrown systems.Point of contact for external vendor creating ML/AI algorithms that creates actionable data for sales team. Algorithms written in Python are deployed and adjusted internally by me.

Education

• University of Pittsburgh Joseph M. Katz Graduate School of Business

  MBA

• Pittsburgh Central Catholic HS

  Diploma, Academic

• Carnegie Mellon University

  BS, Information Systems