09/06/2022 updated


100 % available
BI Analyst/ Report Developer, Business Intelligence Analyst/Microsoft Power BI Developer
Canada
Canada
Bachelor of Computer ScienceMicrosoft AccessComputer-Aided DesignMicrosoft WindowsBusiness IntelligenceDatabasesSAP Crystal ReportsData As A ServicesData IntegrationExtract Transform Load (ETL)Data ModelingLinuxIBM Cognos Business IntelligenceJasperReportsMicrosoft SQL ServersMySQL
Crystal Report XI, Tableau, SAP, Web Intelligence, MS Power BI, QlikView/QlikSense, Windows, Solaris, Linux Data Integration, ETL, SAP Business Objects, SAP Data Services/BODS, Tableau Prep, Microsoft Power BI, Oracle, Web Data Integrator (ODI), Intelligence, Crystal Reports, Qlik Sense, QlikView, Oracle Reports, Yellowfin, BIRT, MS SQL Server, Reporting Services, Cognos, Jaspersoft, SAS, Lumira, Flex, SAP HANA, Microsoft SQL Server, Access, Xcelsius MySQL, Frameworks, Angular, ReactJS, NODE.JS, NET, fixed format, CAD, reporting tools, dynamic reports, data model, Xcelsius, Web Intelligence Reporting, Power BI, Trac, database, computer-based training, Swift, SQL Server database, reporting, Teradata database, SAP BOE Universe, Universe, SAP Desktop Intelligence/Web Intelligence, Business Objects, SDK 6.5, Visual Basic
Experience
Professional experience10+ years
Languages
EnglishNative speaker
Project history
To report on consistent time stamp data from the CAD system. To deliver dashboards and reports focused on the
time stamp analysis subject area using Business Intelligence best practices of integrating data from the appropriate
sources into one centralized view. Using the Web Intelligence and Dashboard reporting tools, produce the
required dynamic reports/dashboards as well as offer ad-hoc reporting capabilities that have not existed
previously.
* Identified the reporting measures needed using the industry standard KPI's.
* Profiled the existing CAD and Fire Data (Incidents and call times) and with the understanding of the data,
modeled the appropriate data mart to satisfy the reporting requirements.
* Interviewed various stakeholders and business users, analyzed business user needs, and translated them
into proper technical requirements.
* Produced report requirements analysis, target data model specification and BO Universe documentation.
Designed and developed data mart, ETL and Universe.
* Lead the development of Web Intelligence reports and dashboards.
* Designed and implemented Web Intelligence Reports such as HRFE Incident Detail Report to show how
long it took to respond to a fire
* Designed and implemented Xcelsius dashboard to display HRFE Time Stamp KPI's
* Liaison with SMEs, and business users to understand business workflow and reporting needs then worked
with the BIDS team to map the data
* Created project timelines and weekly status reports
* Successfully trained City of Halifax employee on Web Intelligence Reporting and Xcelsius dashboards
time stamp analysis subject area using Business Intelligence best practices of integrating data from the appropriate
sources into one centralized view. Using the Web Intelligence and Dashboard reporting tools, produce the
required dynamic reports/dashboards as well as offer ad-hoc reporting capabilities that have not existed
previously.
* Identified the reporting measures needed using the industry standard KPI's.
* Profiled the existing CAD and Fire Data (Incidents and call times) and with the understanding of the data,
modeled the appropriate data mart to satisfy the reporting requirements.
* Interviewed various stakeholders and business users, analyzed business user needs, and translated them
into proper technical requirements.
* Produced report requirements analysis, target data model specification and BO Universe documentation.
Designed and developed data mart, ETL and Universe.
* Lead the development of Web Intelligence reports and dashboards.
* Designed and implemented Web Intelligence Reports such as HRFE Incident Detail Report to show how
long it took to respond to a fire
* Designed and implemented Xcelsius dashboard to display HRFE Time Stamp KPI's
* Liaison with SMEs, and business users to understand business workflow and reporting needs then worked
with the BIDS team to map the data
* Created project timelines and weekly status reports
* Successfully trained City of Halifax employee on Web Intelligence Reporting and Xcelsius dashboards
Assisted Fenkell in the creation or reports and dashboards for the Vehi-Trac software program
* Designed and implemented complex MS Power BI Reports and dashboards such as real-time trend reports
of inspection data to prevent damages
* Liaison with SMEs, and business users to understand business workflow and reporting needs then worked
with the IT resources (DBs and ETL developer) to map the data which included developing the
transformation rules to extract the data from source system and place in reporting database
* Managed project timelines to insure project stayed on time and on budget
* Created weekly status reports and lead weekly meetings with president and director of global claims and
services
* Held online workshops to train the business users and IT staff on MS Power BI reports and dashboards
* Created documentation for training, change management and data dictionaries
* Continued supporting project after go live.
* Tracked and managed issue list
* Used reporting tools to track issues and worked with customer to prioritize issues. Issues were then
reviewed to determine if there were data issues with source system, business work flow were end users
were inputting bad data or ETL issues or reporting logic issue. Interfaced with ETL Resources and other IT
resources to correct these issues.
* Designed and implemented complex MS Power BI Reports and dashboards such as real-time trend reports
of inspection data to prevent damages
* Liaison with SMEs, and business users to understand business workflow and reporting needs then worked
with the IT resources (DBs and ETL developer) to map the data which included developing the
transformation rules to extract the data from source system and place in reporting database
* Managed project timelines to insure project stayed on time and on budget
* Created weekly status reports and lead weekly meetings with president and director of global claims and
services
* Held online workshops to train the business users and IT staff on MS Power BI reports and dashboards
* Created documentation for training, change management and data dictionaries
* Continued supporting project after go live.
* Tracked and managed issue list
* Used reporting tools to track issues and worked with customer to prioritize issues. Issues were then
reviewed to determine if there were data issues with source system, business work flow were end users
were inputting bad data or ETL issues or reporting logic issue. Interfaced with ETL Resources and other IT
resources to correct these issues.
Lead the creation of new Crystal Reports and Xcelsius dashboards.
* Organized meetings with stakeholders to gather business requirements, create task backlog, scope/size
tasks, prioritize tasks and allocate BI resources
* Designed and implemented complex Web Intelligence reports such as Sales evaluation report with drill
down capability to track sales over a period of time with measures including Revenue, Volume, Cost of
Goods Sold, Margin, etc.
* Creation of data-rich Xcelsius dashboards such as the Sales status dashboard provided a view of regional
sales, progress towards regional sales targets and overall revenue growth for the current year
* Creation of Web Intelligence training manuals and computer-based training using Freelife's own data
helped users stay more engaged during the training sessions
* Documented Universe objects and created database data dictionary
* Organized meetings with stakeholders to gather business requirements, create task backlog, scope/size
tasks, prioritize tasks and allocate BI resources
* Designed and implemented complex Web Intelligence reports such as Sales evaluation report with drill
down capability to track sales over a period of time with measures including Revenue, Volume, Cost of
Goods Sold, Margin, etc.
* Creation of data-rich Xcelsius dashboards such as the Sales status dashboard provided a view of regional
sales, progress towards regional sales targets and overall revenue growth for the current year
* Creation of Web Intelligence training manuals and computer-based training using Freelife's own data
helped users stay more engaged during the training sessions
* Documented Universe objects and created database data dictionary