Experience

• 

  Knowledgebase-it

  Sept 2001 - Dec 2002

  Developer
• 

  Pakistan international airlines

  Jan 2003 - Jan 2013

  B737 flight ops technical instructor/cbt developer
• 

  Solution management

  Apr 2013 - Dec 2013

  Business analyst

  Liaison with NZ / Australian clients for the newly developed reporting functionalities. Ostendo based customized scripting and report writing.Pivot and Analysis tools development.EDI - E-commerce website platform integration with conventional servers.Customized .NET (C#) application development to extend Ostendo’s functionality.Operational and financial data analysis.System implementation, training, support and development.

• 

  Merlot aero limited

  Jan 2014 - Jan 2015

  Database developer / merlot based db & reporting consultant

  Focal point for BI/reports development between stakeholders (internal developers, external report development companies and contractors).C#, SSRS based Merlot Aero reports development and management.Cloud based (Windows Azure) database administration and management.Ad-hoc scripting, database / query performance enhancement.Data provisioning and cleansing for new sites / customers.ETL process for monthly crew payroll generation encompassing variable allowances.DR (Disaster recovery) planning and exercise in Dev and UAT environment.Application and database upgrades in Azure environment.Code builds and deployments in Azure environment using TeamCity. Show less

• 

  Mercury nz

  Mar 2015 - Aug 2018

  Systems analyst

  SME (Subject-matter expert)1. Utility sector meter data management (Microsoft and Oracle), automation, analysis and reporting.2. Airline scheduling and reportingORACLE MDMS (Meter data management system), Oracle Utilities Analytics (OUA).Microsoft BI Stack, SSRS reporting, Power BI development experienceBI/reporting and dashboard projects requirement gathering and scope analysis.Smart KPIs/visualisation/dashboard development for business and senior management.Root cause analysis for complex business and technical issues.Development and deployment of execution plans and liaison with key stakeholders.Alternative solution for data collation and reporting - identification and recommendation.Automation of data collation from multiple heterogeneous data sources.Performance tuning of complex report queries.Legacy data collation and ETL packages conversions and support.Internal and external stakeholder (vendors and clients) communication management. Show less

• 

  2degrees

  Aug 2018 - Sept 2022

  Senior business intelligence analyst - finance
• 

  Air new zealand

  Oct 2022 - now

  Senior analytics engineer