Stewart Scott Email & Phone Number

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

Ottawa, Canada Area

• Lead the implementation of Sisense, a business intelligence & analytics platform, by gaining buy in from business stakeholders to cultivate a data informed culture and discover insights that drive action through self-serve automated dashboards and reports• Performed Sisense software installation on Windows server; tested and applied software upgrades• Utilized Sisense data management tools to integrate and extract data from SQL Server database using advanced SQL queries to create Star and Snowflake data models• Developed scheduled dashboards and reports, using Sisense, to track internal metrics and KPIs• Worked cross-functionally to develop custom dashboards to analyze complex financial and sales data• Maintained CRM and BI user accounts and permissions • Installed and configured 3rd party tools (CData) to establish data connection between BI and QuickBooks• Optimized productivity by 98% by installing, troubleshooting and configuring SQL Server Reporting Services (SSRS) to automate internal and external reporting and meet business user requirements• Utilized Visual Studio to develop corporate branded SSRS reporting templates, created scalable SQL queries and stored procedures to collect and transform data • Gathered user requirements and developed new workflows in CRM system• Deployed inclusive CRM data quality reports to ensure high quality data within the system• Developed advanced SQL queries to clean data and improve quality of CRM system• Identified user issues and resolved with a 100% success rate• Scheduled weekly after-hours downtime to update product and pricing in CRM database; developed testing to ensure consistency and accuracy• Provided CRM and BI training to business users• Developed and maintained CRM and BI how-to documentation and user guides• Created service accounts using Active Directory to utilize SQL Server Agent for automation of CRM database backups and report scheduling

Ottawa, Canada Area

● Synthesized current business intelligence data, using SQL and QlikSense into a strategic business planning dashboard to inform leadership of key business decisions; lead to improved productivity by 40% ● Administered technician accounts and skills in Salesforce● Lead weekly team huddles to review performance, resolve blockers and improve processes● Collaborated closely with Solution Center, Onsite Coordination, Supply Chain and Service Delivery to optimize efficiencies and reduce costs● Compiled metrics into MS PowerPoint slides for Quarterly Business Review presentations● Team ranked #1 in North America for adoption of support tool OKRs; utilized data to highlight and eliminate blockers and challenges● Operationalized data processes by providing leadership automated self-serve QlikSense dashboards to proactively track team metrics and analyze KPIs of 100+ service technicians across Canada ● Automated manual data preparation processes using SQL to minimize errors and reduce efforts by 98%● Increased service response times by over 50% by deep diving trend reports and communicating areas of process improvement to leadership, thus improving CSAT and Net Promotor Scores (NPS) ● Created customer reports and dashboards using Salesforce (SFDC), MS Access and MS Excel, utilizing VLookups and PivotTables to manipulate data

Ottawa, Canada Area

• Worked cross-functionally in the successful deployment and ongoing management of MasterControl (QMS), by configuring system settings, creating user accounts, scheduling server tasks and ensuring that environments conform to high availability, performance and capacity• Managed 24/7/365 technical support and administration of Dev, QA and Production environments for QAD (ERP), MasterControl (QMS), iPurchase and RedHat Enterprise Linux• Maintained and ran bash shell scripts to perform purging and archiving of ERP database• Managed RedHat users, groups and permissions; audited weekly logs for unauthorized login• Enforced corporate file security by changed permissions, ownership of files and directories on RedHat servers• Provided excellent and expedient technical and system support to over 1500 distributed users• Diagnosed and resolved 100% of all ITSM service request tickets as per pre-defined SLA’s• Performed daily system monitoring, including verifying the availability of server resources, systems and key processes• Participated and supported change management activities and other off-hour tasks as needed• Reviewed system and application logs and verified completion of automated jobs• Developed and maintained shell scripts and cronjobs which maintained various log files• Managed RedHat users, groups and permissions; audited weekly logs for unauthorized login• Prepared monthly RedHat security audit reports• Installed RedHat patches using YUM commands• Planned and performed migration of QAD databases across RedHat servers• Performed user account re-certification on an annual basis for enterprise systems• Escalated to and worked with vendor (MasterControl) to resolve mission critical impacts• Coordinated with vendor (MasterControl) to perform system enhancements• Extensively worked with cross-functionally with Business, Database and Network teams to support and improve system environments

Reporting to the Quality Control and IT Security team leads, responsible for the day-to-day supervision of the network and quality of applications.• Conducted daily risk and network threat reports from anti-virus (Symantec) and web-filter (BlueCoat) scans, where results were transformed into metrics and forwarded to IT management, for the purpose of monitoring and analyzing critical activities.• Deployed Microsoft updates to devices using the Windows Server Update Services (WSUS) console.• Installed and configured Kali Linux OS on penetration testing workstations.• Assisted with penetration testing using the Burp Suite platform.• Developed User Acceptance Testing (UAT) test cases for SAP processes.• Created automated processes for web application testing, as well as MS Office Suite 2007 in preparation of Windows 7 deployment.

Diploma, Computer Programming

Golf Course Operation And Grounds Management