Pancratius Mukeh

About Pancratius Mukeh

I am a Data Engineering Consultant with 13 years of industry experience working with various industries and sectors. I have extensive experience in the following industries; Healthcare, Banking and Finance, Private Equity, Insurance and Hospitality. Some of the clients I have executed projects for include- Price Waterhouse Cooper (PwC)- United Health Group- Havenbrook Homes- First Guarantee Mortgage Company- Cicis Enterprises.I have extensive knowledge using Microsoft Business Intelligence Suite including SQL Server, Analysis Services Tabular Model, Integration Services and Data Warehousing, Reporting with Power BI Report Builder and Power BI Desktop. Also, I have implemented Healthcare Integration projects using HL7 and other healthcare programming languages with the integration tool Mirth Connect. I have implemented both bidirectional and unidirectional interfaces such as ADT, ORU, ORM, DFT and VXU.I have acquired and used the following skills in executing the various projects;SQL, DAX, Excel, Data Analysis, Data Warehousing (ETL), Requirement Gathering, Technical Documentation, Data validation, Database scripting, Data Integration, Data migration, Data visualization, Paginated report, Power Query, HL7, XML, XPATH, JavaScript.

Experience

1. Principal Data Analytics Consultant

   Bitlegence

   Mar 2018 — Present · Dallas-Fort Worth, TX, US

   Principal Data Analytics Consultant for PwCResponsible for writing SQL scripts, building SSAS Tabular Models and Power BI Leadership Dashboards for both Tax and Advisory Line of Services for Engagement Leaders throughout USA and Mexico- Utilized Azure Data Factory (ADF) to Extract and load data to SFTP sites- Built custom logic with Azure LogicApp- Created data models in SQL Server and SSAS Tabular Model- Created complex views to load Tabular cubes- Designed complex dashboards for Partners and Engagement Leaders across US and Mexico- Utilized TFS (Azure DevOps) for source control and Agile board- Implemented Azure Synapse Analytics Environment and trained team members.

Education

• Western Governors University

  Bachelor's degree

• University of Buea

  B.S., Accounting and Information Technology

  2001 — 2004

• Villanova University

  Certificate, Lean Six Sigma Green Belt

  2008 — 2008

• The University of Texas at Austin

  Graduate Certificate, Health Information Technology & Health Information Exchange

  2013 — 2013

• Collin College

  Certificate, Business Intelligence

  2012 — 2013

Skills

• Data Mining
• Vlookup
• Salesforce.com
• Cpt-4
• Microsoft Office
• Accountable Care Organizations
• Analytics
• Microsoft Excel
• Business Intelligence
• Healthcare Information Technology
• Business Analysis
• Xslt
• Access
• Microsoft Sql Server
• Tfs
• Health Information Exchange
• Business Development
• IT Management
• Icd-9 and Icd-10
• Meaning Use
• Powerview
• Databases
• Hl7
• Ehr
• Ssis
• IT Service Management
• Change Management
• Sharepoint
• Sharepoint Designer
• Ehr Implementation
• Financial Analysis
• Information Technology
• Analysis
• Data Analysis
• Emr
• Powerpivot
• Integration
• IT Strategy
• Management
• Process Improvement