Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Akhil MANNE

Vancouver,Canada

Summary

Experienced Senior Business Analyst with 6+ years of success delivering data-driven solutions across public sector, healthcare, and enterprise environments. Skilled in requirements gathering, Power BI, SQL, and Agile delivery. PSM-certified, with a proven ability to translate complex needs into actionable insights, and lead cross-functional teams to measurable outcomes.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Business Analyst

Fraser Health
BC, CANADA
03.2023 - 07.2025
  • Integrated legacy systems using BizTalk and ESB principles, enabling seamless HL7, JSON, and XML data exchange to enhance interoperability.
  • Authored API contract documentation and interface specs to support scalable system integrations and accelerate developer onboarding.
  • Translated complex clinical workflows into clear technical specifications, aligning product, development, and testing teams.
  • Developed and deployed BizTalk orchestrations and C# components forHL7 integrations, enhancing system reliability.
  • Build integration workflows using Microsoft BizTalk, SQL Server, and C#, enabling seamless data exchange between enterprise healthcare applications.
  • Worked extensively with structured data formats (JSON, XML, HL7) for operational submissions and system integration. Applied advanced data modeling and mapping techniques to translate clinical processes into structured formats.
  • Managed end-to-end healthcare integration projects including client engagement, documentation, approvals, and multi- environment deployments.
  • Engaged developers and data architects to optimize API-based workflows and data exchange across legacy and cloud systems.
  • Utilized Azure DevOps for sprint planning, work tracking, and CI/CD automation, improving deployment efficiency.
  • Performed end-to-end API testing with Postman and SoapUI to validate data integrity and security.
  • Initiated exploratory use of Stylus Studio for HL7 parsing and mapping to support scalable healthcare integrations

Senior Business Analyst & Developer

HCL Technologies
Vancouver, BC
06.2022 - 12.2022
  • Designed and delivered Power BI dashboards connected to cloud-based data sources, incorporating Row-Level Security (RLS) and DAX measures to support dynamic, role-based reporting.
  • Supported Azure-based SQL Server environments with high availability(HA) and disaster recovery (DR) strategies to ensure business continuity.
  • Evaluated Stylus Studio and Apache Hop as mapping tools to enhance transparency and traceability in ETL processes. Developed data pipelines with Azure Data Factory (ADF) and performedETL orchestration using Blob Storage, SQL Server, and SSIS.
  • Executed large-scale data migration projects across SQL Server, AzureSQL, and Azure Storage, ensuring integrity, auditability, and minimal downtime through structured cutover planning.
  • Applied performance tuning and indexing strategies to optimize SQLServer and MySQL query execution. Designed internal/external tables and integrated data sources from AzureData Warehouse (ADW) environments.
  • Designed end-to-end data mapping strategies for structured formats (JSON, XML), streamlining cloud-based analytics pipelines.
  • Partnered with data architects and backend developers to architect scalable API workflows aligned with enterprise standards.
  • Collaborated on data governance initiatives, documenting lineage, transformation logic, and metadata across reporting assets

Business Analyst – Data & Platform Operations

Treez Inc
Vancouver, BC
02.2022 - 05.2022
  • Maintained synchronized development and production server environments, implementing regular data refresh strategies to ensure operational consistency and availability.
  • Led cross-functional stakeholder sessions and technology onboarding workshops, enhancing adoption of new tools and streamlining team productivity.
  • Collaborated with business users to define CRM-related use cases involving customer data, lead tracking, and activity logging in Salesforce.
  • Developed and published cloud-connected Power BI dashboards utilizing Power Query, DAX, and RLS, driving data visibility and business intelligence across the organization.
  • Gathered and documented business requirements for CRM workflows in Salesforce Lightning and Microsoft Dynamics 365, streamlining lead management and customer onboarding processes.
  • Conducted index tuning and SQL performance optimization to enhance system responsiveness and end-user experience for analytics and reporting platforms.
  • Monitored cloud operations via Google Cloud Platform (GCP) alert policies and metric rules, improving incident response for critical services.
  • Contributed to big data transformation efforts using Apache Spark, Scala, and Kafka, supporting transition from legacy Hadoop/MapReduce workflows to real-time streaming pipelines.
  • Collaborated with engineering and DevOps teams via GitHub, implementing CI/CD pipelines and enforcing version control standards to ensure smooth, auditable deployments.

Independent Projects & Learning

Remote
Vancouver, BC
03.2021 - 12.2021
  • Initiated hands-on learning in machine learning and generative AI using Google Cloud Vertex AI, Generative AI SDK, and prompt design best practices, completing labs on prompt engineering, responsible AI, and Python-based model deployment.
  • Developed prototype applications leveraging LLM APIs for text summarization, intent classification, and enterprise conversational agents (chatbots, smart reporting tools).
  • Applied vector search and embedding-based retrieval techniques to enable scalable LLM-powered solutions.
  • Built full-stack CRUD applications with MySQL, Hibernate, and front-end templating frameworks.
  • Developed a web app using Spring Boot and React to monitor GitHub repo stats, build status, and productivity metrics aligned with DORA principles; deployed on AWS EC2 with CI/CD pipelines via GitHub Actions.
  • Explored cloud deployment with AWS EC2, AWS Lambda, and AWS S3, focusing on continuous deployment and serverless architectures.
  • Gained hands-on experience with Git version control, Docker containerization, Kubernetes orchestration, and CI/CD pipelines.
  • Performed performance tuning of Java applications, focusing on JVM optimizations and database query improvements.

Programmer Analyst

Cognizant Technology Solutions
, India
07.2016 - 12.2018
  • Delivered end-to-end BI solutions using Power BI, SSRS, Qlik Sense, and T-SQL, enabling strategic reporting and actionable insights across business units.
  • Collaborated with global clients (e.g., UPS) to gather reporting requirements, define KPIs, and translate analytical needs into scalable dashboards and visualizations.
    Built interactive Power BI dashboards with drill-downs, slicers, KPIs, and DAX-based custom measures, enhancing leadership decision-making.
    Designed and published Excel-based dashboards using Power Pivot, Power Query, and Excel Power View, integrating data from SQL and flat files for operational reporting.
  • Conducted gap analyses and stakeholder interviews to streamline reporting processes and eliminate manual tasks through automation and consolidation.
  • Supported data extraction and validation using advanced Excel functions (VLOOKUP, INDEX/MATCH, pivot tables, array formulas) and SQL queries.
  • Facilitated UAT planning, test case design, and execution to ensure accurate business rule implementation and data integrity.
  • Documented reporting logic, technical specifications, and process flows in Confluence and SharePoint, enhancing cross-team knowledge sharing.
  • Scheduled, maintained, and secured production and parameterized reports via SSRS, ensuring timely delivery and compliance with business SLAs.

Education

Masters - Business Administration

New York Institute of Technology
01.2021

Skills

  • Business Analysis & Agile Tools:
    JIRA, Confluence, Azure DevOps (Boards, Pipelines), Git, Agile (Scrum), Requirement Gathering, UAT, SDLC, Workflow Mapping, Stakeholder Engagement
  • Data Analysis & Business Intelligence:
    Power BI, Tableau, QlikView, SSRS, Excel Power View, SharePoint Integration, DAX, Dashboard Development
  • ETL & Data Integration:
    SSIS, Azure Data Factory (ADF), SQL Server Data Tools (SSDT), SQL Profiler, SQL Server Agent, Data Pipelines
  • Integration & API Technologies:
    REST APIs, OpenAPI/Swagger, JSON, XML, Postman, SoapUI, BizTalk, MuleSoft (learning)
  • Generative AI & Cloud AI Tools:
    Google Cloud Vertex AI, Generative AI Studio, Prompt Engineering, Responsible AI, GenAI SDK (Python), Prompt Tuning, Cloud Storage
  • Programming & Development:
    Java, Python, JavaScript, REST API Development, Microservices Awareness
  • DevOps & Source Control:
    Git, Azure DevOps, Jenkins (basic), CI/CD Pipelines, Docker (basic)
  • Monitoring & Productivity Tools:
    Visual Studio (2017–2022), Business Intelligence Development Studio (BIDS), SQL Query Analyzer, Salesforce (Lightning and Classic), Microsoft Dynamics 365, HubSpot (Basic)

Certification

Professional Scrum master 1 - PSM 1

Timeline

Senior Business Analyst

Fraser Health
03.2023 - 07.2025

Senior Business Analyst & Developer

HCL Technologies
06.2022 - 12.2022

Business Analyst – Data & Platform Operations

Treez Inc
02.2022 - 05.2022

Independent Projects & Learning

Remote
03.2021 - 12.2021

Programmer Analyst

Cognizant Technology Solutions
07.2016 - 12.2018

Masters - Business Administration

New York Institute of Technology
Akhil MANNE