Gy Mehta Email & Phone Number

Designed and developed KPI dashboards to enhance data quality and generate insights for all applicable Suncor operating facilities

Calgary, Canada Area

• Led a team of two developers to design and develop a Data Quality Management System (DQMS) consisting of an SQL data warehouse along with SSIS for ETL processes and Power BI and SSRS for reporting.• Created data models including tables, views, indexes, queries and stored procedures• Performed exploratory data analysis on the imported data to identify cases where data completeness, correctness and consistency rules were violated• Developed several BI reports aggregating these results and allowing users to drill-down to the lowest level via several different categories (date, source document, error type, priority etc.)

Calgary, Canada / Long Harbour Nl

• Awarded runner-up at Fluor Calgary’s 2018 Innovation Unwrapped Event for automated reporting of procurement data – the automated reports now have become part of Fluor’s global template• Managed all aspects of automated report development for Procurement and Commissioning departments from understanding client needs, providing time and cost estimates, designing, developing, testing and maintaining reports, using SSRS, SSIS, Power BI• Demonstrated added value of automated reporting resulting in an increase in the Fluor Calgary office from a single report for a single project to dozens of reports for each Calgary project, including several high-visibility and critical reports

• Led award‐winning team that designed and developed an automated policy upload feature, which processes monthly batches of policy and claims data and inserts them into Temple’s policy management system (ISyCL) ‐ resulting in savings of 50 developer hours/month• Created new billing and cash subsystem processing thousands of monthly transactions – involved in every SDLC phase from gathering business requirements from the client to supporting any production issues

• Created, updated and executed functional and regression testing for several features of BlueCoat's Software Gateway including access logging, hardware support, content filtering and front panel• Assigned to the sustaining team – responsible for providing quick verification and reproduction of high priority bugs from patch releases