Chris Selig Email & Phone Number

Calgary, AB, CA

Calgary, Alberta, Canada

Helps individuals/companies combine, manage and analyze their data to gain new insights and create more efficient reporting capabilities. Development of both Spotfire and Power BI dashboards/reports for clients, provided training to end users, and developed ETL processes using KNIME as well as used other software (i.e. R) to solve business problems.- Using.

Business Intelligence (BI) and Analytics Freelancer. Helps individuals/companies combine, manage and analyze their data to gain new insights and create more efficient reporting capabilities. Some tools used: Power BI, R, Google Data Studio, Google Analytics and Balsamiq.- Created a Power BI dashboard to visualize SurveyMonkey customer satisfaction data..

• Helped businesses gather and understand their data, using tools like Power BI, R, Python, Excel, and Power Automate. Architect solutions for clients
• Using Power Automate, developed a flow that saved 10 hours a month by using AI to save and extract information from PDF files. For the first time information could be consolidated and analyzed.
• Created a project management template that collected project forecasts and exported to a database to allow detailed reporting for leaders.

Calgary, Canada Area

Calgary, Alberta, Canada

• Provide training and ongoing support for self service business intelligence and developed reports/dashboards
• 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

• 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.

• Tasked to develop more efficient processes, and a database so data analysis and visualization can be performed to gather insights into the business.
• 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.
• 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 will help focus.
• Created a self-service, dashboard using Power BI that allowed various levels of management an easy way to track their team’s compliance by training type.
• Developed a business process map in Microsoft Visio to show the relationships between all files/processes currently in use.

• 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 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.
• 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.
• Worked with functional department heads and senior management to produce annual budgets exceeding $160 million and forecast models on a business segment basis.

• 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.

Analytics For Data Science, Data Science

- Cluster Analysis: Using R, learned hierarchical, kmeans, finite mixed models and other algorithms. Forecasting Analytics: Using R, time.

Certificate, Business Intelligence And Analytics

Data Preparation and Dimensional Modeling. Software Used: SSMS, SSAS, SSIS, Power BI Relational Database Fundamentals. Software Used: SQL.

Master Of Business Administration - Mba, Masters Of Business Administration (Mba), Finance Concentration

Bachelor Of Arts - Ba, Bachelor Of Arts (Ba); Economics Major