Senior Power BI Consultant - Atlantis Consulting Group
(2026-01)
For client: VetStrategy
- Working with the Business Intelligence Team to develop and enhance organizational Power BI Reports and Dashboards, Workspace App, and enabling data-driven reporting to gauge performance of their Veterinary Hospitals and Clinics across Canada for their Operations, HR and Financial departments.
- Preparing complex datasets (semantic models) utilizing SQL Queries, CTEs, Views on Oracle database, Azure Data Flows and Fabric ETL Pipelines, supporting robust Fact and Dimensional Data Models for advanced analytics.
- Analyzing data and operational requirements and implementing enhancements in existing Power BI Reports for various clientele of VetStrategy.
- Assisting the Business Intelligence Team in implementing transition from Basic Premium capacity to Fabric Capacity for the organization's Power BI Platform.
Senior Power BI Developer - Bounteous Inc.
(2023-10 - 2026-01)
For client: Morgan Stanley
- Worked with the Information Protection Department to develop organizational Power BI Reports and Dashboards, Workspace App, and enabling data-driven tracking of Sensitivity Labels applied throughout all the Firm Documents using Microsoft Purview Information Protection Scanner.
- Prepared multiple fact and dimensional semantic models utilizing SQL MQTs, Views, CTEs on IBM DB2 database, Splunk queries and SPARQL Queries on Stardog Knowledge Graph to predict high-risk data leakage patterns on file sensitivity behaviors using the data from Microsoft Purview Information Protection Scanner.
- Authored sophisticated DAX measures and Power Query transformations to ensure precision in statistical forecasting and metrics tracking.
- Successfully deployed 7 organizational-scale Power BI Reports for the Information Management department which are helping them to gain actionable insights and save multi-million USD in lawsuits caused due to leakage of sensitive information.
- Designed a pathway for an automated Power BI Deployment Pipeline leveraging PowerShell (BIDataOps) scripts via Azure REST API, GitHub for Version Controlling using Microsoft Visual Studio Code.
Power BI Support Engineer - York Digital Consulting
(2022-11 - 2023-10)
For client: CAAT Pension Plan
- Collaborated with the Data Management Team to develop and maintain organizational Power BI Reports and Dashboards, fulfilling diverse analytical requirements from internal stakeholders.
- Architected and prepared Semantic Models in Power BI using Fact and Dimensional Table Structure, optimizing performance for large historical pension datasets.
- Optimized few existing Power BI Reports, to save on average 40% of refresh time for its Semantic Models, by using advanced BI tools like Performance Analyzer, Tabular Editor, Measure Killer and my extensive knowledge of how Vertipaq Engine functions.
- Assisted Data Warehousing team in extracting crucial data from Oracle Database, using Informatica ETL and ensuring data availability for reporting and analysis.
Lead Analyst – Power BI and Automation Developer - AllState Solutions Pvt Ltd.
(2021-12 - 2022-10)
- Developed, maintained, and significantly enhanced Microsoft Power BI Reports for IT Analytics Vendor data, providing critical insights for Vendor Management Operations.
- Identified automation opportunities and developed combination of workflow and app using Microsoft Power Automate and Power Apps, with SharePoint as a backend, streamlining contract renewal services. This helped the department to save around 300 man-hours per year, which was earlier spent on this manual process by humans.
- Executed complex Star Schema data modeling and applied advanced data transformation logic using DAX queries and Power Query to secure statistical integrity across reports.
- Deployed reports to Premium Workspace via CI/CD pipelines and enforced Row Level Security (RLS) for governed data access.
Data Analyst – Power BI Developer - Tata Consultancy Services (TCS)
(2021-08 - 2021-12)
Responsibilities for a Central Europe based BFSI client – Zurich Insurance
- Collaborated extensively with Database Administrators to design an optimized Star Schema Data Model using Azure SQL Database, DAX queries and Power Query transformations, ensuring data accuracy and enabling robust calculations.
- Translated client requirements into impactful Microsoft Power BI Reports, integrating various business intelligence functionalities to deliver desired insights.
- Published Power BI reports to client's Premium Workspace via CI/CD pipeline deployment and implemented Row Level Security (RLS) for controlled data access.
- Within a short span of 4 months, I developed a working Power BI Report for client's Agile Adoption Technology. This helped TCS extend the Project Scope and secure a long contract of 2 more years with the client.
Data Analyst – ML and Power BI Developer - Tata Consultancy Services (TCS)
(2017-09 - 2021-07)
Responsibilities for various clients of TCS-Digitate partnership - ignio™
- Analyzed and transformed complex raw data from around 16-17 diverse client data sources, preparing it for machine learning application using TCS-Digitate Neural Automation Software: ignio™.
- Executed advanced Data transformations using KNIME Analytics Platform, Advanced Excel, Power Query and DAX.
- Leveraged transformed data within ignio™-Cognitive Procurement module for supervised and unsupervised learning, generating critical clusters and patterns from historical data to identify profound insights.
- Applied generated patterns from ignio™ to perform accurate predictions on live data, enabling proactive business decisions.
- Presented the insights and predictions through interactive Microsoft Power BI Reports, providing clients with dynamic data exploration capabilities.
Network Design Engineer - Tata Consultancy Services (TCS)
(2015-03 - 2017-08)
Responsibilities for a US based Telecom client – COMCAST
- Studied the network connection requirements provided by sales team and prepared Network Designs using Microsoft Visio and Amdocs Service Designer (ASD) tools, which were further used by Network Configuration team for service installation on the actual client site.
- Judged the usage of appropriate networking devices for providing network service using these Network Designs.
- Promoted as a Quality Analyst for Design Engineering Team after 1.9 years of my role as a Network Design Engineer, where my responsibility was to check and mark mistakes in the designs created by Design Team and help them to improve their quality of work by suggesting solutions for minimizing defects. This reduced the defects in the team's work by around 60%.
IT Manager - Knowledge Consortium of Gujarat, Dept. of Education of Gujarat Govt. (KCG) - Ahmedabad, Gujarat
(2014-07 - 2015-02)
- Handled Network Management of the entire KCG campus (spread in 9 acres) comprising of nearly 100 workstations in 5 buildings of the campus.
- Managed Admin Panel of organization website - www.kcg.gujarat.gov.in and maintained the KCG E-Journal – www.kcgjournal.org using JavaScript and HTML coding.
- Carried out government tendering process for purchasing IT related equipments in KCG.
