ZK

Zein Kassim

BI Analyst at Enterprise Service Solutions

Edmonton, Canada

Work Experience

  • BI AnalystFull Time

    Enterprise Service Solutions

    Jan 2023 - Present -2 yrs, 7 months

    Canada , Edmonton

    • Job Details:• Created a data model file using Power BI which serves as data source for new BI environment. • Drafted BI training manual, admin manual, data dictionary and JSON theme template for new BI environment. • Soft launch reports on employee competencies, interview, and training statistics for HR Team. • Launched dashboards for business coordinator, consulting, and project management teams. • Replaced existing reports on Access with Power BI that feature enhanced features and visualizations. • Introduced manage parameters feature from Power BI to develop a user workbench. • Experimenting with machine learning and ArcGIS to find leading indicators, areas of high profitability and factors for higher conversion rates. • Experimenting with Azure Foundry to implement AI solutions.
  • BI AnalystFull Time

    Clearstream Energy Services

    Jan 2020 - Dec 2022 -2 yrs, 11 months

    Canada , Edmonton

    • Job Details:• Assessed current reporting environment, source systems and data dictionary then created a project plan and strategy for company’s new BI environment. • Piloted high-level dashboards for Projects, Supply Chain Management, Human Resources and Accounts Receivables teams with record level security. • Created reports on IT ticket resolution, resolve and close rates from multiple data sources to retrieve historical data. • Drafted BI training manual, admin manual and BI architecture given new ERP and HRMS. This included a decision framework on which reporting tools to use and when. • Developed SSRS reports for newly developed Purchase Requisitions module. • Trained to implement a data warehouse using SSIS and basic training on IFS Report Designer, IFS Business Reporter and PeopleSoft Analytics (Cognos). • Implemented multiple bug fixes and application migrations to newer more reliable hardware. • Resolved tier 2 and 3 tickets for Microsoft Great Plains 2016, Bid2Win, ClearTrak and Syncrude Norms.
  • Business Intelligence Analyst – AX SupportFull Time

    ZCL Composites

    Jan 2017 - May 2019 -2 yrs, 4 months

    Canada , Edmonton

    • Job Details:• Created a dashboard to monitor IT Help Desk ticket volume, response, resolution time and user satisfaction. • Spearheaded strategy of data driven decisions by documenting and correcting current reporting, drafting data governance rules, and leading the BI Steering Committee. • Consolidated current BI environment using Tableau to become the single source of all reporting. • Handled multiple code deployments in production environment to introduce workflows for production orders, inventory cycle count, custom reports, Bill of Lading customizations and data controls. • Introduced process improvements every quarter to streamline operations such as generation of terms and conditions from AX with each invoice and unified business practices for payroll across subsidiaries. • Developed and implemented a replacement integration solution between AX and Docuware, a document management system used by AP team.
  • Data Reporting AnalystFull Time

    GFI Systems

    Aug 2014 - Oct 2016 -2 yrs, 1 month

    Canada , Edmonton

    • Job Details:• Produced monthly dashboards and other ad hoc reports for enterprise clients using Excel Power Pivot and, MySQL queries. • Fashioned an easy-to-use ROI model that monetized the benefits of using our platform to assist our sales team. • Created a data line optimization calculator and reconciliation tool that reduced operational cost by discovering unutilized data lines. • Used Logi Studio to create the new reporting platform for their new website and replace existing dashboards and reports mainly produced on Excel. • Experimented with machine learning technology to create advanced predictive analytics.
  • Education

    • Master's Degree in Economics

      University of Ottawa

      Jan 2012 - Jan 2014 - 2 yr

    • Bachelor's Degree in Economics

      University of South Carolina

      Jan 2000 - Jan 2004 - 4 yr

    Skills

    • SQL
    • Data Governance
    • Power BI
    • DAX
    • M-Query
    • Tableau
    • Python
    • Logi Studios

    Languages

    • English

      Fluent
    Share this Profile