CHRIS SELIG, MBA-
Calgary, AB
https://ca.linkedin.com/in/chris-selig
www.bidamia.ca
-
BUSINESS INTELLIGENCE DEVELOPER
Efficient problem-solving business intelligence developer skilled in interpretation, gathering requirements,
analysis, modelling, and data visualization. Advanced proficiency in Power BI, Spotfire, Excel, R, and SQL with a
keen desire to continuously learn technical skills. Ability to interact and effectively communicate with people of
diverse backgrounds.
Business Intelligence | Analytics | Dashboard Design | Data Analysis | Exploratory Analysis
PROFESSIONAL EXPERIENCE
BUSINESS INTELLIGENCE DEVELOPER (CONTRACTOR), Calgary, AB
2018 - Present
Business Intelligence Developer
Development of both Spotfire and Power BI dashboards/reports for clients, as well as provided training to end
users
Client: Husky Energy
• Developed Spotfire dashboards for various levels of management, including the CIO to show the status of
the project portfolio
•
Developed a Spotfire report to reconcile SAP financials data with manually maintained data
Client: Devon Energy
•
Provided training sessions for Power BI to various groups within Canada and the US
•
Used R programming language to develop custom visuals within Power BI
•
Provided training sessions on Visualization theory and best practices
•
Facilitated gathering requirements meetings with stakeholders so I could develop Power BI reports
WESTERN FINANCIAL GROUP, Calgary, AB
2017 - 2017
Business Intelligence Analyst
Develop self-service business intelligence and analytics solutions for branches and executive leadership.
Software used: Cognos Report Studio/Query Studio, Excel, R, Spotfire
• Developed an analysis report in Spotfire that allowed management to understand the change in active
policies versus the change in revenue for the brokerage.
•
Developed an automated Excel/VBA/SQL based model to forecast both revenues and expenses for the
branch offices. The model used a weighted average method to forecast revenue, and significantly reduced
time to forecast.
•
Developed a Tibco Spotfire based analysis dashboard for executives to show how changes in policy counts
related to changes in revenue.
•
Developed Cognos Report Studio report to help transition and track 14,000 customers as they move to a
new product. Report also ensured key customers were being contacted about product changes.
GARDAWORLD, Calgary, AB
2016 - 2017
Data Analyst
Tasked to develop more efficient processes, and a database so data analysis and visualization can be
performed to gather insights into the business. Software used: Excel, Power BI, R
CHRIS SELIG, MBA
-
2 | Page
•
Developed a Power BI training analysis dashboard that visualized various metrics and analytics on the
training completed in the region, airports and individual screening officers. As well, for the first time,
visualized the statistics for each training specialist including time spent training, what training was provided
and when.
•
Through R statistical software, developed an analysis to quantify, and visualize the errors related to data
submission from the divisions. Information was never quantified nor visualized before, and helped focus
training initiatives.
•
Created a self-service, dashboard using Power BI that allowed various levels of management an easy way
to track their team’s training compliance by training type.
CONOCOPHILLIPS CANADA, Calgary, AB
-
Business Analyst
Developed automated tools and dashboards for co-workers and management to provide insight into operating
expenditures. Provided commentary on assigned operation expenditures.
•
Reduced errors and turnaround time of manually maintained Excel dashboard by replacing with automated
Spotfire dashboard, which provided management with on demand access to financials.
•
Developed financial analysis dashboard in Spotfire that flagged accounting coding errors through vendor
agreement comparison against invoiced general ledger accounts.
•
Reduced operating expenditures forecast time from 6 hours to 30 minutes through development of an Excel
based data model that retrieved data from one database, layered on inputs selected by end user, then
exported forecast. Reduced load time and increased the data analysis quality and story.
•
Analyzed, interpreted, and reported to management monthly and quarterly variances and trends between
budgets, actual and prior results and developed projections and forecasts.
•
Through collaboration with supervisor and other stake holders, developed an Excel based planning data
model that used VBA and SQL to extract data from Oracle for various scenarios, and compiled into
numerous presentation ready visualizations. The model’s efficiency provided more time for better data
analysis and storyboarding, which was greatly appreciated by management.
•
Reduced data compilation time from 3+ hours to 5 minutes through the development of an Excel based
data model that used VBA and SQL to extract data from an Oracle database. Result was greater quality
commentary because more time could be spent on data analysis.
Business Analyst - Systems
Monitored, maintained, and validated the Essbase database financial accounting system. Provided customer
service for the end users in the forecast and planning departments and developed efficient Excel models.
•
Reduced Essbase database turnaround time from 5 days to 2 hours through automation of the Excel data
models.
•
Reduced data submission times from 1 day to 15 minutes through development of an automated Excel
model that used VBA to extract data from databases.
•
Significantly reduced database load errors by end users through streamlined Excel data load templates.
•
Trained finance members on correct Essbase processes which significantly reduced data load errors.
Transactional Analyst/Non – Operated Joint Venture Analyst
Ensured company was invoiced correctly under the Joint Operating Agreement, service agreements, and leases,
as well as vendor account reconciliation, and liaised with vendors.
•
Built an Access database to cross reference invoice cost centers to the active cost centers in the
accounting system (SAP), which significantly reduced cost center errors on invoices.
CHRIS SELIG, MBA
-
EDUCATION
Certificate in Business Intelligence and Analytics (in progress), University of Calgary, AB, 2019
Masters of Business Administration (MBA), Finance, Dalhousie University, Halifax, NS
Bachelor of Arts (BA), Economics, Acadia University, Wolfville, NS
PROFESSIONAL DEVELOPMENT
Data Science For Business With R: HR Analytics, Business Science University, 2018
Gathering Requirements for BI Projects, University of Calgary, 2018
Data Preparation and Dimensional Modeling, University of Calgary, 2018
Statistics with R – Probability and Data, Coursera, 2017
Fundamentals of Visualization with Tableau, Coursera, 2017
Regression Models with R, Coursera, 2017
Statistical Inference with R, Coursera, 2017
Exploratory Data Analysis with R, Coursera, 2016
Getting and Cleaning Data with R, Coursera, 2016
Querying With Transact-SQL (T-SQL), Microsoft Virtual Academy, 2016
Introduction to R, Big Data University, 2016
Intermediate R, DataCamp, 2016
Intro to Python for Data Science, DataCamp, 2016
Data Science Fundamentals Course, Big Data University, 2016
Data Science Methodology Course, Big Data University, 2016
Analyzing and Visualizing Data with Excel, edX, 2016
Analyzing and Visualizing Data with Power BI, edX, 2016
Excel Modelling Excellence Course, ConocoPhillips, 2015
VOLUNTEER EXPERIENCE
Mentor, ConocoPhillips,-
Pen Pal, Connaught School, 2014 -2015
3 | Page
