ZK
Zein Kassim
BI Analyst at Enterprise Service Solutions
Edmonton, CanadaWork 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 OttawaJan 2012 - Jan 2014 - 2 yr
Bachelor's Degree in Economics
University of South CarolinaJan 2000 - Jan 2004 - 4 yr
Languages
English
Fluent