Vicki Scott-Reid Email and Phone Number

• Managed and optimized the reporting platform, ensuring seamless operation and timely updates to meet evolving business needs.• Established an on-premises Power BI platform, enabling secure and efficient data analysis and visualization within the organization.• Designed and developed an advanced Inventory Dashboard in Power BI, incorporating complex data visualizations and interactive features to enhance inventory management and decision-making.• Reviewed and enhanced SQL Server… Show more • Managed and optimized the reporting platform, ensuring seamless operation and timely updates to meet evolving business needs.• Established an on-premises Power BI platform, enabling secure and efficient data analysis and visualization within the organization.• Designed and developed an advanced Inventory Dashboard in Power BI, incorporating complex data visualizations and interactive features to enhance inventory management and decision-making.• Reviewed and enhanced SQL Server performance, implementing best practices and optimizations to improve query execution times and overall system efficiency.• Authored and optimized complex SQL queries and database objects, including stored procedures and functions, to effectively pull, manage, and analyze large datasets. Show less

Enterprise Business Intelligence and Data Analytics Project to help modernize and secure Power BI Service by maintaining and improving Reports, data models, Datasets, Dashboards, and the general Power BI Service through governance and strategic development and enhancement of the overall service.• Optimized Performance: Reduced report processing times by up to 85% by enhancing data models, DAX formulas, and calculations, notably decreasing a key report's processing time from 3.5 hours to… Show more Enterprise Business Intelligence and Data Analytics Project to help modernize and secure Power BI Service by maintaining and improving Reports, data models, Datasets, Dashboards, and the general Power BI Service through governance and strategic development and enhancement of the overall service.• Optimized Performance: Reduced report processing times by up to 85% by enhancing data models, DAX formulas, and calculations, notably decreasing a key report's processing time from 3.5 hours to under 5 minutes. • Dashboard Development: Designed and transformed multiple dashboards, including upgrading a Boat Safety dashboard from Excel to a visual analysis platform, and creating Lakehouse reports for the FedVAX project, utilizing advanced visualizations and analytical tools.• Dataflows & Datasets: Spearheaded the creation of Dataflows and Shared Datasets to streamline data collection from Oracle and Dynamics, eliminating data silos, improving refresh speeds, and optimizing capacity.• Governance & Training: Established and formalized governance structures for Power BI, including comprehensive documentation and training programs. Mentored employees on governance, architecture, and technical development of Power BI reports. • KPI Implementation: Defined performance measures and KPIs, implementing metrics to assess and enhance analytical processes, ensuring alignment with Transport Canada’s goals. • Power BI Service Management: Optimized and managed the Power BI Service environment, improving system responsiveness by 30% through governance and security enhancements.• Tool Development: Developed BI content including reports, dashboards, and PowerShell scripts for monitoring Power BI Enterprise Platform. Introduced tools like Power BI Helper to improve report efficiency and created reusable templates.• SQL & Dashboard Integration: Integrated SQL and Power BI to track ITSM and Azure DevOps work items, enhancing data accessibility and operational insights. Show less

The project is to set up a reporting data warehouse from multiple sources of data including Azure, pdf, JSON, Excel, etc. and display those results on the Power BI platform for various users. Tasks Performed•Modelled, created mock ups, designed, and implemented a data warehouse to merge data sets from varying sources. This included creating a staging area for transforming flat data into useful fact and dimension tables for dashboards and Power BI reporting.•Analyzed business… Show more The project is to set up a reporting data warehouse from multiple sources of data including Azure, pdf, JSON, Excel, etc. and display those results on the Power BI platform for various users. Tasks Performed•Modelled, created mock ups, designed, and implemented a data warehouse to merge data sets from varying sources. This included creating a staging area for transforming flat data into useful fact and dimension tables for dashboards and Power BI reporting.•Analyzed business requirements for understanding the functional workflow of information from source systems to destination systems to identify data and decision flows.•Created OLAP MDX cube from data for reporting.• Created complex paginated profitability report with multiple filters and layers including fuzzy matching and slow changing dimension historical tables. •Created and designed complicated time intelligent Power BI Sales and Inventory dashboards from the data and reports with DAX calculations. •Created and wrote functional SSIS data transformations from FTP for up-to-date data reporting inventory amounts and shipping costs from various vendors, helping with business requirements Show less

• Brought in as part of a reporting team to create a series of financial reports for the Commercial Section. This involved being part of a multi-tiered team of IT, Business and Executive while using the Agile philosophy for guidance and structure. This Project also used the Vault philosophy for structuring and modelling the data• Consulted, Advised and created the required data for the data warehouse.• Created and developed complex reports based on business requirements i.e.. Investor… Show more • Brought in as part of a reporting team to create a series of financial reports for the Commercial Section. This involved being part of a multi-tiered team of IT, Business and Executive while using the Agile philosophy for guidance and structure. This Project also used the Vault philosophy for structuring and modelling the data• Consulted, Advised and created the required data for the data warehouse.• Created and developed complex reports based on business requirements i.e.. Investor weekly and monthly reports. • Future proofed reports by creating reusable functions and procedures for the base of the reports, as well as allowing historical review of data where required. • Responsible for identifying, isolating and reporting of flaws in data, system performance issues and data bottlenecks. • Setup development platform for the warehouse as well as involved in the process for moving Warehouse structure to QA for business analysis. • Created technical SOPs for all reports created as well as definitions for help files. • Designed, developed and implemented a data repository (data warehouse) to support reporting of historical data, projections, trending and other analytics. The data warehouse was comprised of data from multiple sources (SQL, Excel, text) • Created a deliverable interactive warehouse via SSRS and SSIS that ran through, development, QA and final production. • Created SSIS packages and SSRS reports for the business unit to automate and streamline existing manual tasks as well as to improve reporting capabilities.• Automated Equifax upload and download of data to create reports for mortgage renewals. • Analyzed and developed new reporting methods to facilitate faster and more accurate reporting.• Consulted with IT Governance Committee to advise and discuss the best practices for MCAP going forward and to support a larger initiative to centralize all data in the company and allow the business units the ability to report on their data. Show less

• Set up a data warehouse to pull information in from varying sources for reporting purpose. • Created SSIS packages to access the data from an outside source. Transformed data and outputted to tables for reporting

• Designed, developed and tested financial and sales reports in Crystal in accordance with company specifications.• Optimised and amended current reports as per user specifications.

• Developed and designed SSRS reports for a new release of companies Project Portfolio Management (PPM) System.• Amended and improved existing reports as well as developed and designed new financial and executive reports as per specification. • Developed and designed complex stored procedures and functions to source reports. • Developed complex expressions in SSRS to format and filter reports.• Successfully worked closely with the QA team, other developers and the DBA to ensure… Show more • Developed and designed SSRS reports for a new release of companies Project Portfolio Management (PPM) System.• Amended and improved existing reports as well as developed and designed new financial and executive reports as per specification. • Developed and designed complex stored procedures and functions to source reports. • Developed complex expressions in SSRS to format and filter reports.• Successfully worked closely with the QA team, other developers and the DBA to ensure optimal performance of reports. Show less

• Creation of financial composite reporting system for the automotive industry. Creation and development of the pilot for this project which landed substantial contracts for the company with 2 major car manufacturers in the UK which also drew attention of other major car manufacturers in the UK.• Creation and development of calculations for reports consisting of complex functions, cursors, data mining and stored procedures. Furthermore, included a complex averaging stored procedure to… Show more • Creation of financial composite reporting system for the automotive industry. Creation and development of the pilot for this project which landed substantial contracts for the company with 2 major car manufacturers in the UK which also drew attention of other major car manufacturers in the UK.• Creation and development of calculations for reports consisting of complex functions, cursors, data mining and stored procedures. Furthermore, included a complex averaging stored procedure to produce various averages such as Top 50 and Bottom 25.• Developed stored procedures, functions and views for the output of composite reports into web based Logi XML reports.• Creation and development of SQL reports’ reporting structure which include financial and composite reports for existing and new clients.• Creation of data transfer to mine information from Excel worksheets to dump into database tables for calculations.• Creation of SSIS from web database to reporting database.• Maintenance of existing crystal web reporting system. This included the setup of Balance Sheets, Profit and Loss and various other financial and sales reports. Furthermore, the creation and development of miscellaneous crystal reports on demand. Show less

• Redevelopment and improvement of existing program.• Upgrade VB.net 2005 and SQL 2005 Format.• Move of system to new server.• Move of existing reports from Crystal 10 to Crystal XI.• Creation of new Financial and Sales Reports.

• Creation and development of a customer service database with VB.net 2005 Front end and SQL 2005 back end. Purpose of the program to eliminate several other programs and link with the VOIP system to log and track customer service representatives actions.• Creation of system logging and complex security measures for use with new system.• Development of Email and Task Facility to incorporate into the call centre system developed.• Advised on improvement and development of current… Show more • Creation and development of a customer service database with VB.net 2005 Front end and SQL 2005 back end. Purpose of the program to eliminate several other programs and link with the VOIP system to log and track customer service representatives actions.• Creation of system logging and complex security measures for use with new system.• Development of Email and Task Facility to incorporate into the call centre system developed.• Advised on improvement and development of current and future reporting requirements.• Developed and designed unionized queries and reports that connected three separate parts of the database together.• Created DTS and reports that integrates external databases to existing databases.• Implemented improvements on existing reports that allow for a more accurate flow of information.• Organized reporting system and developed a reporting authorization and log system.• Created DTS reports for the upload of information into new accounting system.• Developed and designed forecast table and created queries and reports to draw on this information for monthly and yearly reporting.• Advised and organized the IT improvements in the company to ensure future capabilities. Show less

• Primary responsibilities include the creation, development and maintenance of software solutions and the primary IT authority within the company.• Designed and developed sales and marketing database (VB.net, SQL) for the marketing arm of the company.• Created Auto-Fax and e-mail software for the new sales and marketing database.• Designed and created training manuals for software solutions.• Provided comprehensive training for software solutions.• Developed and tested new… Show more • Primary responsibilities include the creation, development and maintenance of software solutions and the primary IT authority within the company.• Designed and developed sales and marketing database (VB.net, SQL) for the marketing arm of the company.• Created Auto-Fax and e-mail software for the new sales and marketing database.• Designed and created training manuals for software solutions.• Provided comprehensive training for software solutions.• Developed and tested new financial reporting system using VB.net, Crystal Reports and SQL.• Developed and tested DTS from sales and marketing program to communicate with Sage accounting system.• Designed and developed financial and marketing reports.• Designed and developed a forecasting and Sales database. • Designed and developed labor forecasting database. • In 2004 aided in the successful acquisition and merger of the RMO section of the business. Show less

From the billing perspective dealt with the implementation and launch of Satellite internet in Canada. Set up and designed reportsLiased with various departments including the setup of the DirecPC call centre. Oversaw 2 other employees in the day-to-day running of the billing section for DirecPC