Philant Technologies

About me

I am a Microsoft Power Platform developer and data professional with a background in statistics and data analytics. I design business applications, automate workflows, and build data-driven solutions that help teams replace manual and legacy processes with systems that are secure, maintainable, and easy to use.

Portrait of Patrick S. Mensah wearing a navy suit and light blue tie

Background and education

My path into technology runs through mathematics and data. I studied Mathematics Education in Ghana, Statistics at Rutgers University, and Biostatistics at the New Jersey Institute of Technology. That training taught me to work carefully with structured data, to ask what the numbers actually show, and to explain results clearly. I bring those habits to every application I design.

  • M.S. in Biostatistics
    New Jersey Institute of Technology, New Jersey, May 2022
  • B.A. in Statistics
    Rutgers University, New Brunswick, New Jersey, January 2020
  • B.Ed. in Mathematics
    University for Development Studies, Ghana, May 2015

Professional journey

I began in operations, using system data and reports to find bottlenecks and supporting the testing and rollout of technology-enabled processes. Seeing where tools fell short led me to build the solutions myself. I moved into data analysis and Power Platform development, creating model-driven apps, Power Apps, and cloud flows on Dataverse, working with SharePoint, and using Power BI, SQL, Python, and R for reporting and analysis.

A recurring focus has been modernization: replacing legacy InfoPath and SharePoint-based solutions and migrating their data to Dataverse and other platforms, including moving a system off Oracle. Along the way I have given technical guidance on Power Platform architecture, security, and application lifecycle management, and I have trained colleagues to adopt the tools.

How I work

I start with the business process and the data behind it. I work with stakeholders to gather requirements, model the data so it can be secured and reported on, then build and test applications and automation in separate environments before release. I pay attention to security, lifecycle management, and the people who will use the solution, including training and support after launch.

Professional interests

The areas I enjoy most are where business processes, data, and technology meet.

  • Microsoft Power Platform development

    Building applications and automation with Power Apps, Power Automate, Power Pages, and Power Fx.

  • Business application development

    Turning requirements into model-driven and canvas apps that people can use without friction.

  • Workflow automation and process optimization

    Replacing manual hand-offs with approvals, notifications, and integrations that run reliably.

  • Dataverse and Dynamics 365

    Data modeling, security, and business logic on the platform behind customer engagement and custom business apps.

  • Data analytics and business intelligence

    Using SQL, Python, R, Power Query, and Power BI to turn data into decisions.

  • Enterprise application modernization

    Moving legacy applications to modern, maintainable platforms without losing the business logic that matters.

  • SharePoint solutions and legacy migration

    Working with SharePoint and legacy InfoPath applications, and migrating their data safely.

  • Cloud technologies and digital transformation

    Using Azure and Microsoft 365 services to connect systems and modernize how work gets done.

  • Practical AI in business solutions

    Exploring where AI Builder and other AI capabilities add real value to everyday business processes.

Experience

Data Analyst 2 / Power Platform Developer

New York State Office of Information Technology Services. May 2026 to present

  • Design, develop, and deploy enterprise applications with Model-Driven Apps, Power Apps, Dataverse, Power Automate, and Power Pages, replacing legacy InfoPath and SharePoint-based solutions.
  • Design Dataverse data models, tables, relationships, business rules, calculated columns, and Business Process Flows for complex agency workflows.
  • Extend applications with custom pages, Power Fx components, JavaScript web resources, and client-side form scripts.
  • Build Power Automate cloud flows for approvals, notifications, document generation, and integrations across Microsoft 365.
  • Configure Dataverse security (business units, security roles, field security, teams) and design SharePoint permission models.
  • Take part in solution lifecycle management: packaging, environment deployment, version control, testing, and releases with Azure DevOps.

AI Platform Engineer (Contract)

Eliassen Group. July 2026 to August 2026

  • Served as technical advisor to the Director of Emerging Technology on Power Platform architecture, security, governance, and enterprise application implementation.
  • Designed Dataverse security architecture, including security roles, business units, teams, and access controls, with Microsoft Entra ID security groups for centralized access management.
  • Supported development of an AI platform using Code Apps and its readiness for production deployment.
  • Designed and supported ALM across Development, Test, and Production environments, including controlled promotion of solutions.
  • Provided guidance on governance, environment strategy, security, and deployment practices ahead of go-live.

Data Analyst / Power Platform Developer

New York Department of State. October 2023 to May 2026

  • Architected and developed the Fiscal Contract Manager, a Model-Driven App on Dataverse that automates procurement, contract management, voucher processing, and financial tracking and replaces manual Excel-based processes.
  • Led the modernization of legacy SharePoint and InfoPath business applications with Power Platform solutions.
  • Led the replatforming of the Fiscal Revenue System from Oracle to Microsoft Power Platform.
  • Led the migration of the Division of Community Services SharePoint-based applications to Dataverse and Model-Driven Apps.
  • Built Power Automate flows for approvals, notifications, document management, and data synchronization across Dataverse, SharePoint, and Microsoft 365.
  • Automated statewide data collection and reporting with ArcGIS Survey123, XLSForms, Power Automate, SharePoint, and Power BI.
  • Partnered with Internal Audit on analytical solutions using Power Query, SQL, Python, and R for compliance reviews, fraud detection, and operational reporting.
  • Delivered training and user support on Power Platform, Power Query, and Microsoft 365 to increase adoption across business units.

Area Manager

Amazon. June 2021 to October 2023

  • Managed technology-enabled operations in a high-volume distribution environment and used operational data and reports to find bottlenecks and performance gaps.
  • Supported testing and User Acceptance Testing for system and process changes, documenting results and confirming that solutions met operational needs.
  • Gathered requirements from frontline teams and management, and supported rollout, training, and documentation for new processes.
  • Led teams of 50 to 100 associates in a highly automated environment.

Career goals and philosophy

To become a solution architect and technical leader, building innovative technology solutions that drive digital transformation and solve complex business problems. I believe in using technology, continuous learning, and collaboration to create secure, practical, and sustainable solutions that deliver meaningful impact.

Currently learning

Exploring AI-enabled solutions on the Power Platform, including Code Apps and AI Builder, and how governance, security, and ALM practices apply to them.

Download resume (PDF) · Skills and certifications · Get in touch