Andrew Nielsen

Director, Data Management and Analytics at Direct Travel
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Calgary, Alberta, Canada, CA
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Jessica Ly

Andrew is a fantastic ERP business partner who is detailed in his thought process and is extremely easy to work and get along with. Much of the Agresso and database knowledge I currently hold now is due to Andrew's patience, expertise and his ability to transfer knowledge in a concise and succinct manner. Many of the projects we worked on together were high priority and Andrew and his team were able to deliver in a timely manner, even on short deadlines. Troubleshooting and problem solving is definitely one of Andrew's strengths so we knew we could depend on him if anything went wrong. Overall, Andrew is a great team player who has sound technical knowledge and I would gladly recommend him for any future ERP/IT roles.

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Precalculus: Relations and Functions
    Coursera
    Jun, 2021
    - Nov, 2024
  • Microsoft Certified: Azure Fundamentals
    Microsoft
    Jun, 2020
    - Nov, 2024
  • MCSA: BI Reporting
    Microsoft
    Jun, 2019
    - Nov, 2024
  • MCSA: SQL 2016 Business Intelligence Development
    Microsoft
    May, 2019
    - Nov, 2024
  • Microsoft Certified Solutions Expert: Data Management and Analytics
    Microsoft
    Apr, 2019
    - Nov, 2024
  • MCSA: SQL 2016 Database Development
    Microsoft Certifications
    Jan, 2019
    - Nov, 2024
  • ITIL Foundations
    -
    May, 2016
    - Nov, 2024
  • I-Net+
    CompTIA
    Jan, 2001
    - Nov, 2024
  • MCDBA: SQL Server 2000
    Microsoft
    Jan, 2001
    - Nov, 2024
  • MCDBA: SQL Server 7
    Microsoft
    Jan, 2001
    - Nov, 2024
  • Network+
    CompTIA
    Jan, 2001
    - Nov, 2024
  • MCSE Windows NT 4
    Microsoft
    Jan, 2000
    - Nov, 2024
  • Sun Certified Programmer for Java 2 Platform
    Sun Microsystems
    Jan, 2000
    - Nov, 2024
  • A+ Certified
    CompTIA
    Jan, 1999
    - Nov, 2024
  • Microsoft Office 97 Master
    Microsoft
    Jan, 1998
    - Nov, 2024
  • Cisco Certified Network Associate (CCNA)
    Cisco
    Jan, 2002
    - Nov, 2024

Experience

  • Direct Travel
    • Travel Arrangements
    • 700 & Above Employee
    • Director, Data Management and Analytics
      • Nov 2022 - Present

    • Senior Program Manager
      • Jun 2019 - Nov 2022

      Managing Data Management & Analytics organization within ITThis includes managing 3-4 small teams of professionals: Data, BI, Report Development, and ERP Administration (just added 2022)I still work hands on in below areas ... ERP System - Architecture - Administration\implementation\development - Upgrades and updates - New instances\clients - Migrations - Technical support Data\Database Responsibilities - Database architecture - Database administration (SQL Server 2016, SQL Server 2017, SQL Server 2019, and Azure SQL) - Database design - Database development (SQL Server 2016, SQL Server 2017, SQL Server 2019, and Azure SQL) - Azure SQL database - Data architecture - Data Warehouse planning\development - Master Data Management (SQL: Server 2017 MDS, and SQL: Server 2019 MDS) - ETL using SSSIS Reporting Responsibilities - Excelerator report development - Special U4BW reporting tool - Paginated report development using SSRS, Agresso Report Creator (ARC), and Unit 4 XTRA. BI Responsibilities - BI semantic model creation (SSAS, Excel, Power BI) - Excel and Power BI dashboards\reportsI am primarily focused on ... - team management - architecture - security - acting as final support escalation point - backing up teams when they are short - project management for smaller projects and liasing with project managers for larger projects Show less

    • Senior ERP Systems & Data Architect
      • Oct 2018 - May 2019

      ERP Responsibilities - Unit 4 Business World (Agresso) and Central Command- Architecture- Administration\implementation\development- Upgrades and updates- Technical supportData\Database Responsibilities- Database architecture- Database administration (SQL Server 2016 and Azure SQL) - Database design- Database development (SQL Server 2016 and Azure SQL)- Data Warehouse planning\development- BI Semantic model creation (SSAS, Excel, Power BI)- Master Data Management (SQ: Server 2017 MDS)Reporting Responsibilities- Excelerator report development - Special U4BW reporting tool- BI Reporting via Excel and Power BI Show less

    • Agresso Developer
      • Jun 2016 - Sep 2018

      - Excelerator report development- Unit 4 Business World (Agresso) and Central Command administration\implementation\development- Unit 4 Business World (Agresso) and Central Command upgrades and updates- Unit 4 Business World (Agresso) and Central Command technical support- Database administration (SQL Server 2012 - 2016)- Database development (SQL Server 2012 - 2016)

  • Bantrel Co.
    • Canada
    • Engineering Services
    • 700 & Above Employee
    • Application Support Specialist
      • Jan 2006 - Mar 2016

      Support of Agresso (ERP): HR, Payroll, PCB, Security, and Application Server Agresso Upgrades (5.5.0 SP2, 5.6, 5.7 (Milestone 4), & smaller updates) Report development (Crystal, Agresso Report Creator, Agresso Excelerator, and ad-hoc Excel reports) Business\system process analysis & design Agresso module implementation: Payroll (Corporate, Building Trades (union), CLAC (union)), Salary Review, Self Service, and Timesheets Custom system process development including extracts, and imports. SQL Server database administration SQL Server development including data warehousing Show less

  • IBM Canada Ltd.
    • SQL Server DBA
      • May 2005 - Jan 2006

      Physical\production SQL Server DBA support Transitioned 30+ SQL Server 7/2000 instances onto new hardware housed with IBM Physical\production SQL Server DBA support Transitioned 30+ SQL Server 7/2000 instances onto new hardware housed with IBM

  • Bow Valley College
    • Canada
    • Higher Education
    • 700 & Above Employee
    • Systems Analyst 3
      • May 1999 - Apr 2005

      Support of Agresso (ERP): Education, Security, and Application Server Agresso Upgrades Report Development (Crystal, ad-hoc Excel) Business\system process analysis & design Agresso module implementation: Education Custom system process development including government reporting extracts. SQL Server database administration SQL Server development Custom application development: VB6, Access, Agresso VBA Support of Agresso (ERP): Education, Security, and Application Server Agresso Upgrades Report Development (Crystal, ad-hoc Excel) Business\system process analysis & design Agresso module implementation: Education Custom system process development including government reporting extracts. SQL Server database administration SQL Server development Custom application development: VB6, Access, Agresso VBA

Education

  • The University of Calgary
    Bachelor of Commerce (B.Com.), Management Information Systems, General
    1993 - 1998
  • Southern Alberta Institute of Technology
    Completed three SAIT continuing education certificates in development, Information Technology
    1999 - 2000
  • Mount Royal University
    Business Analysis Extension Certificate, Business Analysis
    2016 - 2019
  • Mount Royal University
    Project Management Extension Certificate, Project Management
    2016 - 2017
  • Southern Alberta Institute of Technology (SAIT)
    Business Intelligence Certificate of Achievement, Business Intelligence
    2018 - 2019

Community

You need to have a working account to view this content. Click here to join now