Business Analyst

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

Tammy J. Morrison

Business Analyst with 15+ years of IT experience in Documentation/Technical Writing (Architecture, Process, Procedures, Business and Regulatory documentation), Business Analysis, Database development and management (SQL server/TSQL, Oracle/PL*SQL, Access, MySQL), and Software such as SharePoint, JIRA, Confluence, Active Directory, Adobe Acrobat, Excel, and Visio.

SKILLS
• Training team members for using various programs and skills including Microsoft Office including Office 365, Google and Adobe

• Supported servers using Active Directory

• Experience developing training materials for existing and newly developed applications and processes

• Familiar with Microsoft Dynamics NAV

• Expertise in developing comprehensive reporting from multiple data sources using a variety of tools (Lavastorm, Cognos, Crystal Reports, Excel, custom software)

• In the top 15% of 239K LinkedIn members with SharePoint skills

• In the top 5% of 10M LinkedIn members with Microsoft Excel skills – including Pivot Tables, Pivot Charts, ODBC connections, advanced formulas and automation via VB code

• Experience with a variety of IT environments from small shops to enterprise level, Windows and Linux based software/hardware, local, remote and cloud hosted applications

• Experience with Cybersecurity and Disaster Recovery planning – process and procedure development, identifying roles and documenting key contacts

• Experience developing training materials for existing and newly developed applications and processes

• Agile development methodology, Model-Based Design, Iterative Software Development Life Cycle (SDLC) experience including Requirements, Specifications, Design, Verification, Testing/Integration as per the Software Development Life Cycle

• Proficiency with many large data integration, data mapping and ETL (extract-transform-load) projects

• Subject matter expert in business and data analysis

• Experienced in gathering the details required for documenting infrastructure architecture and creating comprehensive documentation such as System Configuration Plans

• Expertise in explaining complex technical concepts in terms that non-technical team members can understand easily

• Ability to understand current business processes and implement systems to improve efficiency of business processes and to conduct cost/benefit analysis

• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks. Strong background in support documentation

• Expertise in mapping and documenting complex business processes

• Experience with identifying risks, creating plans and procedures to standardize the Management of Change process and reduce the identified risks

• Ability to collaborate with peers in both, business and technical areas, to deliver optimal business process solutions, in line with corporate priorities.

• Experience in identifying risks to project deadlines and outcomes and planning solutions to mitigate those risks


CORE COMPETENCIES

  • ETL                         
  • Excel     
  • DB SQL scripts
  • Change Management
  • Technical Writing / Documentation
  • Requirement Gathering/Data Analysis          
  • SQL server, Oracle PL/SQL, DB2     
  • DB Normalization Data Modelling

TECHNICAL SKILLS

Programming (Years): SQL-Server/ TSQL(10Y), Oracle/PL/SQL(15Y), ETL(11Y), Lavastorm(7Y), Cognos (3Y), VBA(15Y), Crystal Report(3Y), C#(11Y), VB.NET(9Y), ASP.NET(10Y), ASP(15Y) XML/XSLT/Xpath(1Y), LDAP(4Y), SOLARIS(UNIX) admin/Scripts/cron jobs(11Y), HTML(15Y), JavaScript(15Y), PHP(4Y), VISIO(11Y), Adobe Acrobat(3Y), Excel Macros(15Y)

Methodologies (Years): Agile(2Y), SDLC(15Y), USE CASE(15Y), Kanban (2Y)

Systems/Tools: MS Visual Studio 2008/2005, Microsoft Report Builder, JIRA, Confluence, Microsoft SSRS, Power BI, SharePoint, Lavastorm, SQL Server/TSQL (2008/2005/2000/7), Oracle/PLSQL, MySQL, Access, OLEDB, ODBC, Cognos Reports, Crystal Reports, Excel, TOAD, PMQA, Executive, Active Directory, Balsamiq Wireframes


PROFESSIONAL TRAINING

2016    SAP – Orders, Work orders, PM Orders – Transalta Utilities

2014    Agile Methodology – TELUS

2014    KANBAN – TELUS

2013    Lean Thinking – TELUS

2010    ORACLE DBA Modules – TELUS

2001    Certified Lotus Notes Professional – Application Developer


EDUCATION

Certificate       PBSC – Computer Programming

Certificate       NAIT – System Technology

Certificate       Westerra – Graphic Communications Technology

WORK HISTORY

Technical Writer
Auvik Networks – Edmonton, AB (Remote)
April 2022 to current
– Analyzing deficencies in current documentation
– Developing the Internal Knowledge base for Auvik which will be cross-functional for all departments.
– Strategizing how to rapidly reinforce the technical Knowledge Base
– Writing effective technical documentation for the Auvik Knowledge Base
– Working with SMEs for the Auvik Network system
– Supporting continued development of the training system for Auvik users
– Develop changes to the existing Knowledge Base to improve the user experience
– Cross training other teams in technical writing
– Designing and creating storyboards for video development
– Editing documents to ensure proper flow, voice and technical accuracy
– Coding HTML, CSS, Handlebars and Javascript to customize Zendesk Knowledge Base

Business Analyst
Government of Alberta – Edmonton, AB
January 2022 to March 2022
– Identifying inefficiencies in business and Quality Assurance processes within Alberta Student Aid and laying the groundwork for improvements.
– Creating PowerPoint presentations for stakeholder engagement
– Interviewing stakeholders for current functions within Student Aid
– Making recommendations based on a gap analysis of functions

Reporting Analyst
DSL Ltd. – Edmonton, AB
July 2021 to August 2021
– Building an accurate Operations Report using Microsoft Report Builder and Microsoft SSRS with data from Microsoft Dynamics NAV and other systems
– Using Power BI to produce internal reports on an internal website
– Creating self-reporting tools for various areas of the business

Database Developer
Grant MacEwan College – Edmonton, AB
June 2019 to June 2020
– Designed data table structure for COSO framework database to optimize relational data and reporting
– Created easy to use forms for data entry
– Created data management interface to allow for ease of access to data
Implemented a query engine that allows a non-technical resource to build a query without understanding query language and export the results to Excel
– Automated the completion of an Excel from the database to support the COSO categorization of processes

Senior Business Analyst/Technical Writer
Enbridge – Edmonton, AB
December 2017 to May 2019
– Working with subject matter experts and project managers to develop scope of work documentation for various project streams.
– Developing detailed technical and business documentation for the new SCADA system.
– Creating a comprehensive process map of the disaster recovery process for the new SCADA system and compiling and creating all the documentation to support the process.
– Created and managed Microsoft SharePoint site for the SCADA Replacement Project for the documentation developed for the project
– Received ‘Stellar’ recognition from SCADA Technical Manager for my work in developing the Disaster Recovery Plan for the SCADA Replacement Project Production Pilot
– Documenting the System Configuration Plan for the SCADA Replacement Project System 1
– Compiling information to create job aides to support SCADA Integration and SRSS Report Design.

Senior Reporting Analyst
Canadian Western Bank – Edmonton, AB
July 2017 to November 2017
– Developed detailed accurate financial reporting using PMQA/Excel and Executive.
– Established rapport with all levels of team from VPs to Accounting staff.
– Created advanced Excel macros to automate both budget functions and audit functions.

Reliability Analyst
TransAlta Utilities – Duffield, AB
May 2016 to February 2017
– Mapped the Restart Reliability process and developed process improvements based on feedback from the business and management
– Redesigned and developed an automated data gathering form which automated data gathering and supported compliance reporting with the automated generation of the required testing reports
– Completed investigation, analysis and reporting on unit restarts of both the Keephills and Sundance generating stations
– Produced monthly reporting for both the Sundance and Keephills plants for distribution to senior management
– Supported the Production Analyst on daily reporting tasks and data maintenance

Senior Business Analyst
Pleasant Solutions – Edmonton, AB
June 2015 to February 2016
– Project manager for the Vancouver Coastal Health JIRA Implementation, ensuring that the tracking system was configured to surpass their requirements and acting as a liaison between our company and their senior management.
– Led teams of developers and IT experts to exceed targets and dynamically solve problems.
– Developed detailed requirements for custom software projects for a variety of industries including Oil and Gas, Health Care in both the private and public sector.
– Researching and developed recommendations for clients to provide comprehensive solutions.
– Mentoring new business analysts to assist them in developing their skill sets in order to ensure their success and the success of their projects.

Business Analyst II
TELUS CE Enablement – Edmonton, AB
2012 to 2014
– Subject Matter Expert for the CE LNR Operations team reporting needs and acting as Single Point of Contact to support the Operations managers, Team managers and agents
– Developing the business requirements for all LYNX reporting being supported in CE so that an automated self-serve version can be deployed for our stakeholders.
– Analysis of data streams from new applications for usage reporting, completing data validation and report design in order to support adoption of the tools into the frontline business processes.
– Facilitate monthly meetings with Ops stakeholders in LNR to support a good working relationship with downstream partners.