Steven Henein

London, ON Cell: 403-***-**** Email: adhb9o@r.postjobfree.com LinkedIn www.linkedin.com/in/stevenhenein/

BUSINESS DATA ANALYST

Expert Business Data Analyst with over 15 years’ experience, working with all channels of business from IT to senior management, providing effective and detailed reports on trends derived from a variety of data sources. Expert in data mining, gathering, and presenting complex data to provide insight and requirements for many major projects. Extensive experience with Databases, a variety of Data Reporting/Research techniques, and Data Visualizations. These skills and techniques have allowed me to successfully analyze and create a variety of value-add solutions that help support major business decisions.

.

TECHNICAL SKILLS

Databases: SQL Server 2007, 2008 R2, 2012, 2014, 2016, Oracle, DB2, MySQL, Microsoft Access

Front End Reporting Tools: Microsoft Power BI, Power BI Report Builder, Power BI Workspace, Tableau 8.3, 9.X, Tableau Online, Tableau Reader, Excel, Cognos, SSRS, Performance Point, SAP Business Objects (Web Intelligence, Crystal Reports, Xcelsius, Visual Intelligence),

Work Item Tracking Tools: Jira, Azure Boards

G.I.S. Software: ArcView, ArcGIS 9.X,10.X ArcView Autodesk, GeoStation 5.0.1., IDRISI Kilimanjaro,

BUSINESS EXPERIENCE

SkyCap Financial August 2020 to October 2020

Data Analyst (Contract)

Accomplishments:

Enhanced current Financial and NSF dashboards by updating measures and calculated columns with accurate and efficient DAX code which corresponded to actual business requirements.

Created new dashboards reflecting daily loan activity which are updated daily.

Coordinated with IT partners to establish Power BI Online and associated Gateways for dashboards to be refreshed on a daily and in some cases, hourly basis.

Ontario Colleges Application Services (OCAS) Guelph, Ontario August 2019 to August 2020

Data Analyst

Accomplishments:

Principle Power BI Developer for OCAS Domestic Insights Project (Agile SDLC). These Dashboards provide insights on student application and enrolment actives across all 24 Ontario Colleges.

Created and maintained published Power BI Dashboards to Dev Environment Workspace for the OCAS Domestic Insights Project.

Created ad-hoc SQL reports delivered in Excel for C-suite and Client Services Office.

Created and maintained Internal Power BI Dashboards for PMO and Call Centre Services.

Attended DSI Advanced Modeling &Visualization Techniques for Power BI

Investigated and provided Business Rules to Data Engineers for the new International Insights Project. These business rules were used to aid in Vendor POC requirements.

Power BI development, SQL investigation and dataset creation for Major projects 70%, Power BI Dashboards and SQL reporting for Internal Business Groups 30%

Carfax Canada (an IHS Markit Company) London, Ontario January 2019 to April 2019

Business Data Analyst

Accomplishments:

Created a number of Power BI Dashboard outlying profit growth for Dealership Groups. The data mentioned is currently used by Sales teams to grow relationships with Dealership Partners.

Created Dashboards

Responsible for designing / developing, and publishing operational ad-hoc SQL reports, used by Product Teams and management to make informed decisions on direction.

Provided in-depth Data Quality research on Vehicle History Reports, Polk VIN decode data and Odometer readings to improve the output current and future products

Ad-hoc SQL Reporting for Business Groups 50%, SQL Analytics for Odometer and VIN integrity projects 30%, Power BI Dashboards for Marketing, Sales and Internal Stakeholder reporting 20%

Autodata Solutions, London, Ontario May 2018 to January 2019 Solution Analyst

.Accomplishments:

Successfully created Interactive dashboards for Autodata’s Responsive Compare platform analyzing users’ activities via customized Google Tags

Created a streamlined business process for a digital marketing campaign by promoting vehicles to key finance and lease clients across the U.S.

Created Business Requirement Documentation and Functional Requirements for various internal and client-based projects

Creating Functional Requirement documentation 40%, Creating UML diagrams for various projects 30%. Creating Power BI Dashboards surrounding Google Analytic metrics 30%

Conestoga College, Kitchener, Ontario May 2016 to May 2018 Contract Professor (Contract)

Accomplishments

Successfully taught the following courses: Android Development, Data Structures & Algorithms, Computer & Application Securities, System Developments & IT Concepts, Business Analysis, SDLC, UML, Non-Functional Testing Requirement, Computer System Design & Analysis, Advanced Databases, End User Design Principles

Class lecture preparation 50%, In class lecturing 30%, Assignment, and examination marking 20%

IHS Markit, Calgary, Alberta February 2014 to May 2016

Business Analyst – Canadian Information Operations (August 2015 to May 2016)

Accomplishments:

Created requirements that enhanced current Canadian Clientele CRM and provided heightened customer ticket data for detailed trend analysis using Tableau 9.2 environment.

Created weekly, monthly and quarterly reports on data quality analysis from enhanced CRM data

Created a comprehensive profile of IHS Canadian pipeline data for data enhancements

Created detailed dashboards on the data quality of the IHS PPDM database to finding and categorizing data busts.

Requirements gathering 40%, Business supported reporting & Dashboarding 40% Pipeline data GAP analysis 20%

Customer Solution Adviser II – International & US Markets (February 2014 to August 2015)

Accomplishments:

Published paper on a comprehensive workflow using IHS Enerdeq Bakken data, IHS Harmony and IHS Vantage. By identifying a practical workflow using these IHS products, sales groups were able to leverage the business case findings for product marketing

Produced a second co-authored paper on Super Fracking in the Marcellus using IHS Performance Evaluator

Customer data support 50% Research and writing papers for product marketing 50%

Dow AgroSciences, Calgary, Alberta December 2012 to December 2013

GIS Analyst (Contract)

Accomplishments:

Created GAP analysis of current business process for how business groups request data in both Tabular Reports and Spatial Maps, improving data request processes by providing data to business groups from one credible and dedicated data warehouse.

Gathered requirements from Product Managers, quantifying data need so that it could be represented spatially.

Worked with Data Analyst, arranging data and creating so that ArcGIS Shapefiles could be created.

Creating shapefile data based on market research data 50%, GAP analysis 25%, Spatial analytics & Data reporting 25%

Ideaca Knowledge Services, Calgary, Alberta March 2012 to December 2012

Business Intelligence Consultant (Contract)

Accomplishments:

Created Pre-sales Xcelsius RME demo used to sell functionality.

Generated Data Requirements Documentation for ETL packages, Data Warehouse, and Universe design.

Designed and Implemented Pre-Staging, Staging, and DW databases.

Built Front end Xcelsius dashboard for client use.

Gathered requirements for, designed, and Built Relational Database used to monitor portal usage information.

Created SSRS reports based on Portal Usage Relation Database.

Client Engagement & Requirements gathering 30%, Technical training on project specific technologies 60%, Project Development 30%

Alberta Energy Regulator (AER), Calgary, Alberta September 2008 to March 2012

Business Analyst – Solutions Delivery Services (November 2011 to March 2012)

Accomplishments:

Assessed Software Asset Management status and procedures determining software procurement and license maintenance status.

Investigated how software was procured, the various business and IT groups that are involved, and how the finance department kept their records up to date, identifying redundant license purchases business process improvements to prevent unnecessary license requests from the business,

Requirements gathering by way of investigating business usage of asset 60%, cataloging of the current asset management and streamlining AER Asset management 40%

Business Analyst – Applications Branch (September 2008 to November 2011)

Accomplishments:

Analyzed Application Audit data to create reports on the activities of application types. Identifying trends on applications types.

Customized a Spatial Data Browser for Routine Application Processors with detailed spatial data. Saving AER approximately $25K in annual 3rd party licensing costs

Customized an ArcMap solution for Non-Routine Applications. Improving well, pipeline & facility layers.

Created various BPMN process flow diagrams of various business processes in the Application Branch, identifying bottlenecks, redundancies and improved data quality requirements for unique business groups.

Organized system testing, and releases of in-house web-based application processing software - IAR 6. This resulted in a high success rate in the IAR 6 agile release cycles, minimizing deployment rollbacks.

Created test scenarios for business groups testing, reported results to IT & management groups.

Captured requirements for Business Continuity Planning and identified critical business process for worst-case scenarios during possible catastrophic events. Ensuring that in the case of critical system failure preventing the AER from issuing licenses for infrastructure, industry would not be impacted.

Facilitated meetings between key business & IT groups creating an internal Compliance Management System that managed regulatory audits on the activities of applicants within Alberta.

SQL Data reporting 30%, Spatial Data reporting 10%, Business process documentation 20%, Requirement gathering on audit and application data metrics 20%, Organizing and conducting UAT testing 20%

EDUCATION

University of Western Ontario London, Ontario

B.A., Geography

Graduated - 2006

University of Western Ontario London, Ontario

B.Sc., Computer Science

Graduated - 2003

PERSONAL INTERESTS/ACTIVITIES

Judo, Mountain Biking, Weightlifting, Archery

Contact this candidate