Jonathan Joseph Nkomo

Develop interactive Power BI dashboards with row-level security and DAX-driven metrics, enabling real-time insights for cross-functional stakeholders.
Automate manual tasks using Power Automate, including data routing, email workflows, and SharePoint integration, reducing operational effort by up to 70.
Design and maintain Access database solutions for department-level tracking and reporting with relational integrity and user-friendly forms.
Act as SharePoint administrator and developer, creating document libraries, lists, permissions structures, and custom Power Apps integrations.
Write complex SQL queries for reporting, analysis, and ETL processes.
Optimized performance through indexing, query refactoring, and schema tuning.
Implement Microsoft Fabric components to unify data integration, governance, and analytics for streamlined data estate management.
Deliver advanced Excel reports using dynamic dashboards, Power Query, and Office Scripts/VBA for automation and reusability.
Engineered scalable workflow automation solutions across departments, aligning with business process improvements and reducing turnaround times.
Lead business process design efforts by mapping workflows, identifying bottlenecks, and translating requirements into technical blueprints.
Work with management, team leaders, and other stakeholders to develop reports, dashboards, and process automation.
Build robust ETL pipelines leveraging Power Query, dbt, dataflows, Azure Data Factory, Alteryx, and Fabric for ingesting, cleaning, and transforming multi-source datasets.
Design conceptual and logical data models to support analytics, BI reporting, and cloud-native architectures using industry best practices.
Create custom applications in Power Apps to enable data collection, approvals, and task management workflows integrated with Microsoft 365 services.
Develop Office automation solutions using VBA and Office Scripts, integrating Excel, Outlook, and SharePoint to drive end-to-end workflow automation.

Develop interactive Power BI dashboards with row-level security and DAX-driven metrics, automate manual tasks using Power Automate, design and maintain Access database solutions, act as SharePoint administrator and developer, write complex SQL queries, implement Microsoft Fabric components, deliver advanced Excel reports, engineer scalable workflow automation solutions, lead business process design efforts, build ETL pipelines, design data models, create custom applications in Power Apps, developed scalable work and deliver advanced Excel reports using dynamic dashboards.

Design and maintain advanced Excel reports, as well as dynamic Power BI dashboards with DAX measures and row-level security to deliver tailored insights.
Develop custom business applications using Power Apps (Canvas and Portal), integrated with SharePoint lists, Dataverse, and Power Automate for workflow automation.
Lead SharePoint site architecture and development, including list creation, permission management, and web-part customization for data collection and reporting.
Manage Office 365 and SharePoint administration, including user and group provisioning, access control, and compliance monitoring.
Create and manage users in Azure Active Directory, including Azure B2B guest user onboarding and cross-tenant collaboration setup.
Orchestrate secure file sharing through OneDrive for Business and SharePoint document libraries, ensuring appropriate access and version control.
Build and connect Microsoft Forms with Excel via OneDrive, SharePoint, and Power Automate to enable real-time data capture, reporting, and automated alerts for internal teams and clients.
Support the Dataverse schema design process and contribute to efficient data modeling for scalable Power Platform solutions.
Automate reporting workflows using Power Automate integrated with Power BI and MS Forms to deliver timely email alerts and analytics updates.
Assist in the creation of SharePoint workflows and site components to streamline collaboration and optimize operational efficiency.
Develop automation and data transformation scripts using Python, leveraging libraries such as Pandas and NumPy to build efficient ETL pipelines.
Created compelling data visualizations and exploratory analysis using Matplotlib, Seaborn, Plotly, and other visualization tools.
Designed and deployed interactive web dashboards in Streamlit, enabling real-time data exploration and user engagement.

Design and maintain advanced Excel reports, develop custom business applications using Power Apps, lead SharePoint site architecture and development, manage Office 365 and SharePoint administration, build and connect Microsoft Forms with Excel and Power Automate, support Dataverse schema design, automate reporting workflows, assist in the creation of SharePoint workflows, develop automation and data transformation scripts, create compelling data visualizations.

Manage end-to-end invoicing, including reconciliation of payments through accurate invoice-to-bank statement matching and journal entries.
Draft client contracts based on profile assessments on SharePoint, ensuring compliance with fiduciary standards.
Resolve clients and internal queries through email and telephone correspondence, maintaining high levels of service responsiveness.
Perform quality assurance reviews, collaborate with client executives, and ensured accuracy in documentation and reporting.
Designed and maintained Excel-based ledgers, contributing to internal controls, audit readiness, and compliance documentation.
Collaborated with the claims department to update and configure contracts and run client account statements to assess payments and resolve outstanding issues.
Reconcile client accounts and resolve submission issues in SharePoint, working directly with client-facing teams.
Compile actionable reports on rejected SharePoint submissions using Power Query, SharePoint connectors, and Pivot Tables, supporting strategic management decisions.
Conduct training on the Phoenix Accounting Application and guided teams through audit support documentation processes.
Partner with external auditors to supply audit evidence and validate financial transactions.
Contribute to the receipting team, executing journal entries, processing payments, and completing reconciliations with precision and timeliness.
Support the payments team to ensure end-to-end accuracy in the insurer payment cycle from invoice creation to final transaction posting.

Manage end-to-end invoicing, reconcile payments, draft client contracts, resolve queries, perform quality assurance reviews, design and maintain Excel-based ledgers, collaborate with claims department, reconcile client accounts, compile reports, conduct training, partner with external auditors, support payment cycles.