Scott Cameron Email & Phone Number

Canada

Oo

Cambridge, Ontario, Ca

Led the Data Management team, of 20+ people, through a significant company-wide transformation, ensuring that data assets and strategies were aligned with the organization's evolving goals and vision. Successfully migrated 200,000+ policies from legacy to new system and built a 2TB enterprise data warehouse and downstream processes.Strategic Realignment: Collaborated closely with the C-suite and senior management to realign the data strategy with the company's new mission and objectives. Played a pivotal role in defining how data could support the transformation's success.Seamless Data Integration: Led data integration initiatives to guarantee that data flowed seamlessly between existing legacy systems and new platforms introduced as part of the transformation.Data Quality Assurance: Enhanced data quality assurance processes to improve data accuracy and integrity. Implemented data cleansing and validation strategies to address data quality issues.Data-Driven Decision-Making: Ensured that data was readily available and relevant to decision-makers throughout the transformation. Developed and enhanced data reporting and analytics capabilities to support informed choices.Training and Skill Development: Identified gaps in data-related skills among employees and implemented training programs to equip them with the knowledge and tools they needed to excel in the transformed data environment.Regular Reporting: Regularly communicated the progress and impact of data initiatives to senior management and stakeholders. Provided data-driven insights to demonstrate how data supported the transformation's success and decision-making. Including KPIs and Monitoring.Cross-Functional Collaboration: Collaborated closely with other departments involved in the transformation, such as IT, finance, and marketing, to ensure that data supported and enhanced their activities. Facilitated cross-functional communication to drive better data utilization and outcomes.

Cambridge, Ontario, Ca

Directed a skilled data engineering team, responsible for designing and maintaining scalable data pipelines and architectures.Collaborated with cross-functional teams to define data requirements, implement data models, and deliver actionable insights.Architected and executed data integration solutions, including ETL processes and real-time data streaming, improving data quality and availability.Led data engineering best practices, ensuring adherence to data governance standards and industry compliance.Managed the migration of legacy data systems to cloud-based platforms, resulting in improved scalability and reduced operational costs.

Cambridge, Ontario, Ca

Designed and implemented complex ETL processes, extracting, transforming, and loading data from diverse sources into the data warehouse.Implemented data validation and cleansing procedures, ensuring data accuracy and reliability across the data lifecycle.Collaborated with data analysts to optimize data structures and schemas, improving query performance and reporting efficiency.Mentored and coached junior data engineers, fostering continuous learning and innovation within the data engineering team.

Cambridge, Ontario, Ca

Designed, developed, and maintained data pipelines to collect, transform, and load (ETL) data from diverse sources into the data warehouse.Implemented data integration solutions and optimized ETL processes, resulting in streamlined data flows and improved data accuracy.Collaborated with data scientists and analysts to provide clean and accessible data for advanced analytics and reporting.Ensured the performance, scalability, and reliability of data pipelines to support the organization's data needs.

Boston, Massachusetts, Us

A key player in the analytics department building systems and analytics used by health care organization to manage risk. • Handling multiple stages of development and working closely with clients to coordinate maintain and implement data transfer and management.• Integrate predictive models into database-backed environments, real-time query APIs, and existing modeling pipelines, considering computational and other constraints.• Write code to maintain and enhance data pipelines.• Real time• Design, develop and test systems that presents millions of records to current customers.• Understand and work with complex data structures in Tera bytes.• Work with internal data team to propose technical solutions to business problems.• Daily use of Python, Mysql/Aurora/Redshift, Bash scripting, Amazon Web Services (AWS), GIT

Burlington, Ontario, Ca

An integral part of a small team which designed, implemented and maintained an internet based technology data management solution. Job responsibilities included: programming, scripting, research, networking, database management, testing, issue management, code version control, documentation and customer support. • Research and problem-solved to create custom solutions for unique problems• Design and program backend modules and scripts to support the frontend (web interface) functionality• Create custom translators for allow 3rd party data to be used• Develop and implement solutions for unique networking problems (VPNs, networks and firewalls)• Design, implement and maintain the database to meet the needs of the application• Create and optimize SQL queries to maximize database throughput• Thoroughly and systematically test frontend and backend for proper behaviour• Write numerous internal documents on procedures, configuration and trouble shooting• Main contact and problem-solver for customer support • Debug and trouble shoot a wide variety of problems• Write countless custom scripts (Python) to perform a variety of functions

Burlington, Ontario, Ca

Worked on numerous projects to design and implement custom test sequences based on documentation provided by the customer. The tester machines are controlled by the test sequences to test and verify the functionality of the customer’s device.• Planned test sequence based on customer documentation• Programmed (C language) modules to test each constraint• Debugged written code• Interacted with customer to help debug customers device with any issues which occurred• Help customer verify the tester machines

Hamilton, On, Ca

User side software testing. Included finding bugs, reporting, troubleshooting and bug tracking.