Gy Mehta

Senior Data Analyst & Business Intelligence Lead @ ReVisionz

About

Senior Data Analyst and Business Intelligence Lead with 12+ years of experience designing and delivering Power BI-centric analytics, data models, and reporting solutions in engineering and oil & gas industries. I specialize in turning fragmented and low-trust data into automated, reliable, and actionable insights that drive business decisions. I have led end-to-end solution design for high-profile projects, including asset data quality and reporting platforms, data migration frameworks, and enterprise-wide data quality management systems. My work combines strong technical skills—including SQL, Power BI, ETL/SSIS, DAX, data modeling, and automation—with close collaboration with stakeholders to ensure insights are meaningful, accurate, and easy to use. Notable achievements include standardizing KPIs across multiple facilities, delivering dashboards with executive-to-root-cause drill-downs, and automating processes so clients can operate and maintain solutions independently. I also have experience with formal data quality frameworks, including ISO 8000 standards, and have successfully managed projects with multiple internal and client stakeholders.

Country

City

Canada

Industry

Oil & Energy

Skill

Stakeholder Engagement, Visual Basic .NET (VB.NET), Documentation, DAX, Transact-SQL (T-SQL), Python (Programming Language), KPI Dashboards, KPI Reporting, Skills Analysis, Data Analysis, Microsoft Power BI, SQL, Extract, Transform, Load (ETL), Data Quality, SQL Server Integration Services (SSIS), Business Requirements, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Databases, PL/SQL

Experience

Senior Data Analyst & Business Intelligence Lead

ReVisionz

2021-8 - 2025-12 · 4 yrs 5 mos

• Delivered an end-to-end asset data quality and reporting platform supporting 40+ KPIs across multiple facilities. • Standardized KPIs and analyzed operational and engineering data to uncover issues and drive actionable insights. • Built automated SQL-based ETL pipelines and developed Power BI dashboards with drill-downs from executive summaries to root-cause detail. • Handover of fully automated solution to the client; adoption expanded from four to thirteen facilities. • Supported migration from legacy asset information management system (SPF) to SDx by designing a structured data validation and migration framework. • Developed SQL stored procedures and regex-based rules to identify and resolve missing, incorrect, duplicate, or non-compliant data. • Established a repeatable approach for large-scale data migration, positioning the client for future extensions.

Data Quality and Business Intelligence Lead

Fluor Corporation

2018-5 - 2021-1 · 2 yrs 9 mos

Calgary, Canada Area

• Designed and delivered the Data Quality Management System (DQMS) integrating 8–10 source systems with complex SSIS-based ETL pipelines and Power BI/SSRS reporting. • Standardized and validated engineering data, enabling generation of tens of thousands of validated files while identifying millions of data quality issues. • Led a small development team, collaborated with internal and client stakeholders, and ensured solutions were automated, scalable, and maintainable.

Business Intelligence and Automation Specialist

Fluor Corporation

2012-1 - 2018-5 · 6 yrs 5 mos

Calgary, Canada / Long Harbour NL

• Automated Construction and Turnover reporting using SQL, Power BI, and SSRS, replacing manual Excel workflows. • Designed dashboards, charts, tables, and drill-down reports for self-service analysis. • Delivered solutions across multiple projects, saving dozens of man-hours per project per week. • Built internal applications supporting Engineering, Procurement, Cost, and Contracts teams, achieving sustained productivity gains.

Software Developer

Munich Re

2008-9 - 2011-12 · 3 yrs 4 mos

• Led award-winning team to automate policy and claims data uploads, saving 50 developer hours/month. • Designed and developed a new billing and cash subsystem processing thousands of monthly transactions.

Software Test Engineer

Blue Coat Systems acquired by Symantec

2007-12 - 2008-6 · 7 mos

• Designed and executed functional and regression testing for BlueCoat’s Software Gateway features. • Collaborated with sustaining team to verify and resolve high-priority bugs in patch releases.