Projects

| Blog | Technical Writer | Technical Analyst | Business Analyst | Admin Support | Projects | Sample Documents | Home |

Projects

Grant MacEwan University Jun 2019 – July 2020

Database / Application Developer

Edmonton, AB

Project Description: COSO Framework Database Developer (short term contract)

Develop a database to assist the college in the categorization of internal processes into the COSO Framework.

Workshopped design with stakeholders to ensure business needs were met.
Design database table structure according to a normalized data design.
Developed data input forms to make data entry easy and efficient.
Developed a one stop data management interface to ensure data integrity and ability to add audit data to entries.
Created a query engine that allows users with minimal database experience to build custom queries and export data to Excel for further data analysis.
Linked the database to a pre-existing spreadsheet form so that the data in the database can be reported by the COSO Framework standards.

Canadian Western Bank Jul 2017 – Nov 2017

Senior Reporting Analyst

Edmonton, AB

Project Description: Audit Data Reconciliation

Developing an extraction and transformation tool to retrieve accounts payable data from a variety of GLs, reverse engineer invoice data and attach appropriate amounts from tax GLs in order to allow for an audit to be conducted on the data.

Gathered requirements from stakeholders.
Developed complex Excel macros to extract data from the PMQA system and transform it into usable audit data.
Performed QA testing to ensure data was accurate and formatted appropriately.
Trained end users on how to use the tool and developed support documentation.

Project Description: Report Automation

Worked to automate a variety of reports, including quarterly financial statements and various financial analysis using Executive, PMQA and Excel.

Analyzed existing reports to determine how to best accomplish automation.
Worked with stakeholders to identify needs.
Developed complex Excel macros to transform data and present it in the desired fashion.
Performed QA testing with end users to ensure reporting was accurate and fulfilled customer needs.
Created support documentation for the reporting

Project Description: Budget Project Backfilled for permanent reporting analyst over vacation. Ensuring that the budget project was not impeded during this time. Completed two complex Excel projects which organized and drew data from a variety of other files and organized it to the budget needs.

Pleasant Solutions Jun 2015 – Feb 2016

Senior Business Analyst / Project Manager

Edmonton, AB

Project Description: VCHA JIRA / Confluence Implementation

Implementation of JIRA and Confluence as an issue ticketing, workflow and knowledge management system for the Vancouver Coastal Health Authority PMO Office.

Lead team of IT Professionals to implement JIRA and Confluence on a cloud-based server with restrictions to hosting due to health care regulations.
Worked with stakeholders to further define requirements during implementation.
Ensured cybersecurity concerns were addressed and procedures in place to minimize risk due to remote based roll out of application
Guided selection of further add-in features to better customize the out of the box software.
Ensured integration with existing access management systems.
Performed system testing and ensured all aspects worked to expectations.
Identified risks to project and suggested mitigation strategies
Provided delivery status updates with management.

Project Description: Mentor Group Vending Machine Project

Phase 2 development of touch screen vending machine software for Nestle.

Lead team developers to implement major improvements to touch screen vending products.
During critical points, assisted developers in researching solutions to issues that had been raised by updating the version of ASP .NET MVC that the project was being developed in.
Reviewed the system with stakeholders and gathered feedback and change requests.
Managed scope and negotiated for changes that fell out of scope as future work – providing estimates and managing expectations.

Project Description: Qikit Mobile Chat Application

Conduct feasibility study and develop business case for mobile application with a specialty keyboard for condensed phonetic English language and translation to normal English. Intended to be used as a tool for English as a second language training.

Performed research into the ability to create custom keyboards specifically for iOS including special characters, to translate from the condensed English to standard English on the fly and to create custom dictionaries for the condensed English language.
Developed feasibility and business case documentation.
Identified risks to project and suggested mitigation strategies
Created click thru of proposed application and created keyboard designs.
Gathered requirements, created use cases and system model

Enbridge Pipelines Inc. Dec 2017 – May 2019

Senior Business Analyst / Technical Writer

Edmonton, AB

Project Description: SCADA Replacement CMBR Documentation

Ensuring the business is ready for the change to the new SCADA system through a combination of communication and documentation.

Identified the scope of work for each assigned workstream by research and interviewing project managers and subject matter experts.
Gathered content for the documentation by interviewing subject matter experts and creating recordings of the interview to guide development of the documentation.
Applied previous IT expertise to identify best practices and keeping the big picture in mind while working on the details.
Within the Cybersecurity stream, contributed to the development of the Disaster Recovery Process – collaborating on the process flow, better defining the disaster scenarios and locating and/or writing the support processes for the plan.
Developed positive relationships with a variety of team members including management, technical staff and subject matter experts.
Developed the SCADA Replacement Project – Full Production Rollout 1 System Configuration plan which includes the system infrastructure requirements known at the time for all related Enbridge Systems/Infrastructure including PI, Leak Detection, and ICS Seg.
Produced technical and business documentation that is clear, concise and on target.
Received feedback from the SRP Director Mike Hall on the positive contribution my work product has made to the SCADA Replacement Project.
Received Stellar recognition from SCADA Technical Manager Darin Parsons for the SRP Disaster Recovery Plan – which passed the Corporate Cybersecurity tabletop exercise with no revisions.

TransAlta Utilities May 2016 – Feb 2017

Reliability Analyst

Wabamun, AB

Project Description: Restart Reliability Analysis

Analysis of data collected from power plant unit restarts to assist in identification of action items and improvements to the restart process. Worked on mapping and improving the restart reliability process.

Gathered data from restarts including actions taken by plant operators and key milestones in the restart process.
Identified issues during the restart process and presented them to a panel of plant managers and operators.
Delivered weekly and monthly reports for inclusion in executive level reporting.
Mapped the current restart reliability process.
Maintained Excel application for Restart Reliability Analysis
Gathered requirements for improvements to the process and designed future state of process.
Created gap analysis and presented this to plant managers and executives.
Documented all processes for creating reporting and set up SharePoint as a document management system.

Project Description: Turbine Test Compliance Form

Creation of a compliance form for testing that would both gather data for further analysis and produce the PDF form that was required for regulatory compliance.

Gathered, interpreted and verified business requirements for form, automation and data.
Designed form and tables for data collection.
Developed form using macros coded in VBA in Excel
Automated electronic signing process for form based on network login.
Automated creation and storage of PDF to SharePoint for regulatory compliance.

TELUS Communications Jun 2003 – Oct 2014

Business Analyst / Developer / BI Developer

Edmonton, AB

Project Description: LYNX Reporting Automation

Automation of all manual reporting into a Cognos cube where stakeholders will be able to access all reporting on demand.

Developed requirements for all reporting(excel) to be automated (COGNOS) including data sources, mappings, and formulas
Negotiated with stakeholders to reduce reports being produced by 50%
Redesigned reports to accommodate consolidation to reduce report count
Validated automated reporting against existing manually produced reporting
Participated in functional test planning and testing
Documented all new and modified mappings according to current standards

Project Description: HDM Troubleshooting Application

ETL and data analysis from the HDM Troubleshooting application to support agent adoption and project gating.

Develop requirements and technical specifications for data warehousing and reporting
Negotiated with application support team for access to application logs
Create and maintain ETL process to transform application logs as a useable data source
Develop mapping from new data source to existing LYNX data to verify accuracy of the data
ORACLE management and development: tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Developed methodology for agent reporting
Developed reporting for distribution to agent managers and project gating team in Excel
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation

Project Description: xVu Troubleshooting Application

ETL and data analysis from the xVu Troubleshooting application to support agent adoption and project gating.

Develop requirements and technical specifications for data warehousing and reporting
Negotiated with application support team for access to application data
Identified issues with the application through analysis of application data – missing agent entries
Create and maintain ETL process to transform application data
Develop mapping from new data source to existing LYNX data to verify accuracy of the data
ORACLE management and development: tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Developed methodology for agent reporting
Developed reporting for distribution to agent managers and project gating team in Excel
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation

Project Description: Tier II Test Queue Monitoring Reporting

Queue monitoring was a manual process performed by the Quality Assurance Agent for the Test team. This reporting (pulled through ORACLE jobs) was used by downstream partners as a predictive indicator of incoming workload. LYNX data accessible via databases were on a 24 hour delay and unsuitable for this reporting. Heavy manual overhead for this report was the driver for the project.

Conducted workshops to identify requirements with Test Managers and QA Agents
Developed requirements and technical specifications for data and reporting
Identified ‘near to live’ data source and negotiated access
Create and maintain ETL process to pull necessary data set on specific schedule to support queue monitoring without affecting parent data source
ORACLE management and development: pivot tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Verified data accuracy against existing data source
Developed automated email reporting through construction of HTML content through a stored procedure and emailing directly from ORACLE server
Audited and tested performance with Test Managers and QA agents
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation
Followed change/release process

Project Description: Tier II Metric Generation and Portal Development

Agent metrics were being manually tracked by managers. Agents had no access to their metrics and no way of seeing their month over month progress. Tier II agents were not included in the standard metric tracking system as their metrics were very different from the frontline agents.

Conducted workshops to identify requirements with Test Managers
Developed requirements and technical specifications for data, KPIs, reporting, dashboard and portal
Create and maintain ETL process to pull data from legacy systems
ORACLE management and development: pivot tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Developed dashboard in C# ASP .NET, integration with access management, rights management for specific teams
Verified reporting accuracy against manual reporting generated by managers
Audited and tested performance with Test Managers and QA agents
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation
Followed change/release process

Project Description: Internal Server Support

Due to the needs of the department, several internal servers were maintained. These servers supported internal projects and housed reporting data for the Assure business unit. One Windows Server (upgraded over time to Windows Server 2012) which ran IIS to support the ASP .NET applications and two SOLARIS V120s on SOLARIS 7.

Provided change management notifications and roll back plans
Applied software updates and security updates as required
Ensured compliance with TELUS network security for Cybersecurity
Ensured server connectivity and up time
Managed server resources and access
Managed IIS website creation and support
Managed Active Directory for Windows server access
Completed hardware upgrades – hot swap drives, memory – as necessary

Project Description: ORACLE Server Migration

Prior to the migration, Assure shared space on an ORACLE server owned by another group. Due to this the ability to maintain the data warehouse that was desired was limited and the ability to bring new data sets into use was practically non-existent. Two SOLARIS V120 servers were acquired to support the data requirements of Assure.

Installed and configured ORACLE, setting up users and security
ORACLE management and development: tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Handled change management notifications, rollback plans
Created and managed processes to move existing data from shared server resource to sole use server resource
Created and maintained ETL process to pull necessary data from corporate data mart
Migrated existing jobs and reporting to new server

Project Description: Serval Ticketing System Upgrade and Maintenance

Serval was the backup ticket tracking system that would be put into use when LYNX was taken down during scheduled and unscheduled outages.

Maintained application, acting as Tier II/III support for it corporately
Developed requirements and technical specifications for redevelopment for additional workflows to be supported by the application
Conducted impact analysis on application to identify impacts of additional workflows on application performance
Audited existing code to enable changes to be made
SQL Server management and development: tables, views, job scheduling, stored procedures and indexing on SQL Server 2008
Implemented code changes using VBA ASP
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation

Project Description: Manual Bill Print Tool

Manual bill printing was a process that when a customer called in looking for copies of their bills, frontline agents would have to leave the queue and manually access another tool, print the bills and mail them. This process negatively affected call times and the customer experience. The tool created allowed centralization of the process to a team – improving the customer experience by tracking the bill requests and improving call times.

Conducted workshops and interviews with frontline users to gather business requirements
Developed requirements and technical specifications for application development
Developed use cases, data and workflow mapping for the application
ORACLE management and development: tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Developed application in VB ASP .NET, integration with access management, rights management for specific teams
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation
Followed change/release process and rollback planning

Project Description: ORT Order Modification Tracker

The Order Reconciliation Team modified orders to ensure a smooth customer experience by pro-actively correcting errors. They received a manual print out of orders to check and follow up. A tool was to be created to allow more automation in the process. Tool allowed for better tracking of orders modified by agents, allowing them to follow up based on specific intervals. Tool also supported agent metrics allowing productivity to be objectively measured.

Conducted workshops and interviews with frontline users to gather business requirements
Developed requirements and technical specifications for application development
Developed use cases, data and workflow mapping for the application
ORACLE management and development: tables, views, job scheduling, stored procedures and indexing on ORACLE 10g
Developed application in C# ASP .NET, integration with access management, rights management for specific teams
Participated in functional test planning and testing
Documented all new and modified mapping according to current standards
Wrote support documentation
Followed change/release process and rollback planning