Ojitech Inc. brings 40+ years of technology expertise to your organization — from Power BI dashboards and SharePoint applications to end-to-end workflow automation. Now extending into AI prompt engineering and Microsoft Copilot, helping organizations navigate the intersection of Power Platform and artificial intelligence. Serving enterprise and government clients worldwide, with international field experience, Secret clearance, and bilingual capability.
From data storytelling to automated workflows, Ojitech Inc. delivers practical Microsoft 365 solutions that improve operational visibility, governance, and decision-making.
Interactive executive dashboards, semantic data models, DAX measures, and Power Query/M transformations. We turn raw operational and financial data into clear, actionable insights for leadership teams.
Metadata-driven document libraries, SharePoint Lists, permissions-aware solution design, and seamless integration with Power Apps, Power Automate, and Power BI for scalable business applications.
Canvas apps with multi-step forms, dynamic validation, role-based UX, and responsive screen logic — purpose-built for intake, request management, scheduling, and administrative review workflows.
Approval and routing workflows, automated notifications, data-quality checks, refresh orchestration, and repeatable process automation using Microsoft 365 connectors and exception-handling patterns.
Dataverse-aware design, SQL Server and Azure SQL integration, Excel/VBA automation, JSON/XML transformations, and API-ready integration patterns within Microsoft 365 governance frameworks.
User training, adoption support, technical documentation, and post-UAT enhancements — ensuring your teams can confidently own and evolve the solutions we deliver together.
From prompt engineering to Microsoft Copilot deployment and AI-driven workflow design, Ojitech Inc. helps organizations navigate the shift to artificial intelligence — practically, securely, and with measurable business impact.
Design, test, and refine prompts for Claude, ChatGPT, Microsoft Copilot, and other LLMs. Ojitech delivers structured prompt frameworks that produce consistent, accurate, and business-ready outputs — tailored to your specific workflows and quality standards.
Deploy and configure Microsoft 365 Copilot across your organization — including Copilot in Teams, Outlook, Word, and Power Platform. We guide your adoption strategy, training, and governance policies to maximize ROI on your Microsoft AI investment.
Combine AI capabilities with Power Automate, Power Apps, and SharePoint to automate repetitive decisions, classification tasks, and document processing. We design hybrid human-AI workflows that reduce manual effort and improve accuracy.
Evaluate your organization's data quality, process maturity, and governance posture before committing to AI adoption. Ojitech delivers a structured assessment and prioritized roadmap — identifying the highest-value AI opportunities and the risks to address first.
Guide your organization through every phase of AI adoption — from executive alignment and change management to pilot projects, staff upskilling, and sustained governance. Ojitech ensures AI tools become embedded, trusted, and effective across your teams — not just launched and forgotten.
Decades of enterprise work built on Excel, VBA, and macros. Ojitech Inc. specializes in assessing those solutions and migrating them to modern, maintainable, and scalable Microsoft Power Platform equivalents — preserving your business logic while unlocking collaboration, automation, and real-time reporting.
Audit your existing Excel workbooks, VBA code, macros, and MS Query connections. Document the business logic, data flows, and user workflows embedded in legacy tools — so nothing gets lost in translation.
Map legacy components to their modern equivalents. Define MVP scope, phased migration approach, data migration strategy, and governance considerations before a single line changes — reducing risk and stakeholder surprises.
Replace fragile macro-driven processes with robust Power Automate flows — scheduled runs, event-triggered actions, approval chains, and error handling that works across the organization without a local Excel session.
Rebuild static, manually refreshed Excel reports as live Power BI dashboards with scheduled refresh, DAX measures, and drill-through — accessible to stakeholders across the organization without sending a file.
Transform complex Excel-based intake forms, trackers, and data-entry workbooks into structured Power Apps canvas applications with validation, role-based access, and SharePoint or Dataverse as the data layer.
Run parallel operation during cutover, train end-users on the new tools, document the replacement solutions, and provide post-migration support — so your team feels confident leaving the old tools behind.
Purpose-built utilities for business automation are in active development. These tools will help teams assess legacy environments, map business processes, and accelerate adoption of AI and modern Microsoft platforms — available soon.
Visually document and analyze business processes to identify automation opportunities, bottlenecks, and candidates for AI-assisted decisions.
Scan Excel workbooks, VBA modules, and macros to surface complexity, dependencies, and migration priorities for modernization projects.
A curated, tested library of business-ready prompts for Claude, ChatGPT, and Microsoft Copilot — organized by function, role, and use case.
Contact us to be notified when tools become available.
Real deliverables built for structured, regulated, and enterprise environments.
Over four decades delivering technology solutions — most recently focused on Microsoft Power Platform and data intelligence for federal government clients.
Design and deliver Power BI, SharePoint Online, Power Apps, and Power Automate solutions supporting project intake, request workflows, approvals, scheduling, executive reporting, and portfolio governance. Build dashboards and reporting models using Power Query/M, DAX, and structured data models across project, financial, schedule, risk, and stakeholder data. Collaborate with architecture, PMO, executive reporting, and business teams.
Supported the development and evaluation of advanced AI training datasets covering Microsoft Office, Microsoft 365, Power BI, Power Query, VBA, Power Apps, SharePoint, and Microsoft Copilot. Created and refined complex prompts and evaluation criteria to improve AI reasoning, coding assistance, and business productivity use cases — ensuring technically accurate, context-aware, and high-quality model responses. Hands-on experience with leading AI platforms including Microsoft Copilot, Claude (Anthropic), and ChatGPT (OpenAI).
Delivered operational reporting and process automation solutions for business teams using Power BI, Power Automate, Excel, and SharePoint Online. Automated communications and data-quality checks, supported requirements clarification, and improved consistency of recurring reporting processes.
Built reporting, automation, and data-processing solutions using Excel/VBA, XML, and Microsoft tools in support of regulated operational teams. Documented solutions, trained users, resolved production issues, and supported continuous improvement.
Validated expertise backed by active Microsoft certifications and decades of hands-on enterprise delivery.
The tools and platforms that power our solutions — all within the Microsoft 365 and Power Platform ecosystem.
Ojitech Inc. is a Kingston, Ontario-based consulting firm delivering enterprise Microsoft 365 and Power Platform solutions for government and corporate clients across Canada. Founded by Germain Piquette, the firm draws on 40+ years of hands-on software delivery experience.
With an active Secret-level security clearance and a proven track record at Shared Services Canada, the Department of National Defence, and the Canadian Nuclear Safety Commission, Ojitech Inc. understands the unique demands of structured federal delivery environments — governance, documentation, UAT, and stakeholder collaboration included.
Services are available in both English and French, supporting bilingual organizations and clients worldwide.
Before specializing in enterprise Microsoft solutions, Germain worked in challenging international environments — delivering technology projects with limited infrastructure, diverse teams, and demanding stakeholder expectations. That experience built an ability to adapt quickly, communicate across cultural contexts, and deliver results regardless of the environment.
Technology work in one of the world's most challenging operating environments — demanding flexibility, resourcefulness, and cross-cultural communication.
Delivered solutions in a Francophone African context, navigating infrastructure constraints and building trust with local stakeholders.
Worked in South America's only English-speaking country, bridging Caribbean and South American business cultures with technology delivery.
Ready to discuss your Power BI, SharePoint, or Power Platform needs? Reach out directly or fill in the form and Germain will respond within one business day.
Kingston, Ontario, Canada
Available remotely — worldwide
Secret clearance — available for federal government engagements