Ben Ferguson Email & Phone Number

Vancouver, Bc, Ca

Vancouver, British Columbia, Canada

Vancouver, Canada Area

Developed ETLs and database objects for an Enterprise Data Warehouse.Collaborated in EDW design and development standards.Designed and developed a Sales Data Mart, utilising EDW objects. The design patterns created are being used for other data mart projects.Assisted analysts and students with SQL queries and administration (SQL Server and Oracle).Developed a data import system that would allow secure and auditable SQL Server queries for a patient survey project.Redesigned a… Show more Developed ETLs and database objects for an Enterprise Data Warehouse.Collaborated in EDW design and development standards.Designed and developed a Sales Data Mart, utilising EDW objects. The design patterns created are being used for other data mart projects.Assisted analysts and students with SQL queries and administration (SQL Server and Oracle).Developed a data import system that would allow secure and auditable SQL Server queries for a patient survey project.Redesigned a clinic fee reporting system to exclude tax and shipping from fee calculations, leading to savings of over $8000 per month. Acted as Release Manager, holding responsibility over source control, change management, and code deployment.Primary support for any and all SQL Server, EDW and ETL issues. Show less

Vancouver, Canada Area

Maintained and developed reports for various databases. Acted as DBA for all SQL Server environments within the Flight Centre domain. Built an SSIS and TSQL-based system that provided the lowest-cost fares to various destinations on a display board at select retail locations. Designed and developed an Enterprise Data Warehouse for Canada, and set standards for development for other nations.Ran ad-hoc queries and built ad-hoc Excel reports as needed by business… Show more Maintained and developed reports for various databases. Acted as DBA for all SQL Server environments within the Flight Centre domain. Built an SSIS and TSQL-based system that provided the lowest-cost fares to various destinations on a display board at select retail locations. Designed and developed an Enterprise Data Warehouse for Canada, and set standards for development for other nations.Ran ad-hoc queries and built ad-hoc Excel reports as needed by business users.Performed Business Analysis duties in gathering requirements and setting expectations to business users. Designed and created specs for a large number of Enterprise Data Warehouse objects and ETL methods. Deployed and tested code in development and integration environments. Was primary point-of-contact for any and all report or report-related issues. Hired, trained and managed Jr-level developers. Show less

Developed and managed ETLs, administrated SQL Server systems (SQL Server, SSIS and SSAS, 2008 and 2012 versions), designed and developed SSRS reports, managed analytics software; OLAP Cubes and minor assistance with SAS. Ran ad-hoc queries and built ad-hoc Excel reports as needed by business users.Performed Business Analysis duties in gathering requirements and setting expectations to business users, and translating those requirements to an off-shore development team… Show more Developed and managed ETLs, administrated SQL Server systems (SQL Server, SSIS and SSAS, 2008 and 2012 versions), designed and developed SSRS reports, managed analytics software; OLAP Cubes and minor assistance with SAS. Ran ad-hoc queries and built ad-hoc Excel reports as needed by business users.Performed Business Analysis duties in gathering requirements and setting expectations to business users, and translating those requirements to an off-shore development team. Designed and created specs for a large number of Enterprise Data Warehouse objects and ETL methods. Deployed and tested code in development and integration environments. Acted as primary point-of-contact for any ETL or DW issues. Show less

Victoria, Bc

Managed and coached level 1 Helpdesk team, wrote and updated training documentation, handled call escalations, leased with other IT teams

Victoria, British Columbia

Troubleshooted technical issues with front line retail staff, documented new issues, interfaced with other IT departments for resolutions