Stewart Scott Email and Phone Number
Stewart Scott work email
- Valid
- Valid
Stewart Scott personal email
Self-directed and driven technology professional with comprehensive accomplishments applying data analytics and data visualization to ensure success and achieve goals. Known as an innovative thinker with strong SQL and business acumen. Demonstrated success developing and executing plans across complex data sets. Recognized for maximizing performance by implementing appropriate data mining strategies through analysis of details to gain understanding of the data structures, databases, relationships and business needs. Highly organized, creative problem solver who excels at producing business value by applying data analytics best practices to challenging problems.✤✤✤ Accomplishments ✤✤✤✔ Lead the evaluation, selection, implementation and management of Sisense. Managed 30+ corporate Sisense reports, the ETL pipelines and data models, the reports portal, license usage and the availability and technical support of the BI platform.✔ Transformed operational reporting processes from manual Excel based reports to data visualization tools which resulted in a 98% reduction in manual reporting hours by automating SQL queries.✔ Spearheaded the development of 50+ corporate QlikSense reports and data visualizations which delivered business insights and enabled senior leadership to proactively monitor quality metrics and KPIs of 100+ service technicians✤✤✤ Expertise ✤✤✤⚐ Business Intelligence, Data Analysis, Data Modeling, Extract, Transform, Load (ETL), Testing, Business Analysis, Requirements Analysis, Project Management, Operational Reporting, Documentation, Pivot Tables✤✤✤ Technology ✤✤✤⚐ Analytics/Visualization: Qlik, Sisense, Tableau, PowerBI, Google Data Studio⚐ Software: MS SQL Server, Visual Studio, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Salesforce, Visio, Teams, Zoom⚐ Programming: SQL, MySQL, PL/SQL, Bash, Shell, HTML, PHP, CSS⚐ Microsoft Suite. MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Project, MS Access, Operating Systems. Windows, Red Hat Enterprise Linux (RHEL), Ubuntu, CentOS⚐ Project Management. Agile, Waterfall
Cheo
View- Website:
- cheo.on.ca
- Employees:
- 1502
-
Business Systems AnalystCheo Jun 2023 - PresentOttawa, Ontario, Canada
-
Business Systems AnalystCheo -- Children'S Hospital Of Eastern Ontario Feb 2021 - Jun 2023Ottawa, Ontario, Canada
-
Business System AnalystCombat Networks Nov 2018 - Mar 2020Ottawa, 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 -
Business Intelligence DeveloperHewlett Packard Enterprise Jun 2015 - Oct 2018Ottawa, 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 -
System AdministratorAbbott Mar 2014 - May 2015Ottawa, 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 -
Junior Technical SpecialistCanadian International Development Agency May 2013 - Aug 2013Reporting 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.
Stewart Scott Skills
Stewart Scott Education Details
-
Computer Programming -
Golf Course Operation And Grounds Management
Frequently Asked Questions about Stewart Scott
What company does Stewart Scott work for?
Stewart Scott works for Cheo
What is Stewart Scott's role at the current company?
Stewart Scott's current role is Business Systems Analyst at CHEO -- Children's Hospital of Eastern Ontario.
What is Stewart Scott's email address?
Stewart Scott's email address is stewart.scott@hp.com
What schools did Stewart Scott attend?
Stewart Scott attended Algonquin College Of Applied Arts And Technology, Georgian College.
What are some of Stewart Scott's interests?
Stewart Scott has interest in Civil Rights And Social Action, Education, Poverty Alleviation, Science And Technology, Disaster And Humanitarian Relief, Human Rights, Animal Welfare, Health.
What skills is Stewart Scott known for?
Stewart Scott has skills like Windows 7, Testing, Software Development, Databases, Business Intelligence, Microsoft Access, Qlik Sense, Data Analysis, Project Management, Analytical Skills, Business Analysis, Requirements Analysis.
Who are Stewart Scott's colleagues?
Stewart Scott's colleagues are Rebekah Dube, Hoey Lynda, Melissa Galvao, Taylor Bearss, Mckinley Townsend, Chantal Blatti, Mackenzie Peirce.
Not the Stewart Scott you were looking for?
-
1live.ca1 +130690XXXXX
-
Stewart Scott
Toronto, On2gmail.com, iiroc.ca -
2lastminute.com, bcaa.com -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial