Steven W. Email & Phone Number

Montreal, Qc, Ca

Architect and manage end-to-end data pipelines, centralizing data from diverse client systems into AWS data warehousing solution (Redshift)Design and implement dimensional data models to enhance analytics capabilitiesManage multiple client projects by implementing tailored ELT solutions and ensuring seamless data ingestion and transformation across various systemsLeverage SQL and AWS Redshift ML for data analysis and machine learning, translating insights into actionable visualizations via Power BI to support decision-makingDesign and engineer scalable data architectures, optimizing data consolidation, storage, and retrieval using AWS servicesPerform comprehensive data quality assessments, ensuring high data reliability and consistency across client systems

Montreal, Quebec, Canada

Provide dragon boat coaching for local/corporate teams at various events across Quebec, Ontario, and the United States. Teach the fundamentals of paddling, and race strategies and address paddlers’ individual needs.

Montreal, Quebec, Canada

Lead and execute category management strategies through RFX sourcing approach for fuel products and services (Portfolio Annual Spend: $200M)Manage over 10 key relationships with suppliers and customers through the negotiation of long-term commercial and contractual agreements; monitor suppliers' performances while ensuring customers’ satisfaction through regular discussions with the stakeholdersManage CN's fuel budget of $1.5B through fuel price forecasting models by considering changes in volume consumption and market pricesCompile and analyze thousands of fuel purchasing transactions to track forecasted and actual monthly fuel consumption and derive CN's fuel productivityCollaborate with the Network Operations and Strategy teams to perform heat map analysis to identify fuel-efficient and cost-saving opportunities, resulting in annual savings of $3MBuild an authorization for expenditure (AFE) case by performing operational risk analysis and mitigation to optimize the fuel management system through capital infrastructure projects (Yard Expansion Project: $3M)Manage monthly fuel reconciliations with foreign railroads by analyzing thousands of train movements to determine net volume receivable and payable; implemented a Robot Process Automation (RPA) using Blue Prism for the reconciliation of train movements; reduced processing time by 50%Coach and mentor interns in performing business analysis and market research to assess CN’s RFX requirements and market trends, and evaluate bid proposals

Montreal, Quebec, Canada

Montreal, Quebec, Canada

Built financial reports using ETL with Excel Power Query as part of a contract spend tracking initiative to provide actionable insights to the Category teams, ensuring greater transparency of the procurement spending of the companyLed contracts migration activities from legacy systems to SAP Ariba and monitor all contracts through the implementation of several KPI tools to ensure business compliance; increased in contract signature compliance by 40% in 2 monthsLed a RPA project using Blue Prism to streamline 10 master data entry end-to-end processes; increased the efficiency of the team by eliminating non-value-added workImplemented procedural changes to support data governance tools to maintain robust processes and comply with procurement policies

Brampton, Ontario, Canada

Pioneered a weekly business report highlighting different KPIs about the rail operations by compiling and analyzing data from various sources using Access SQL, Excel, and VBA; presented findings and recommendations in the form of a dashboard to higher managementIncreased the efficiency and accuracy of the team’s reporting tools by automating the processes and debugging technical issues to meet business request changes with Access SQL and VBA; Reduced the processing time of daily tasks by 25%Conducted various data analyses by investigating business requests, interviewing across functional groups, and contributing to the recommendation and improvement of solutions on domestic transportation processes and technical procedures/tools; presented findings to higher management

Montreal, Quebec, Canada

Assist in the layout design of the new Montreal facilitySupport in conducting data gathering and analysis to support work measurement and operational planning activitiesParticipate in time study and operational improvement activitiesCreate operating plans based on data compilation, periodic audits and forecasts productions to provide the optimum cost-saving solutions

Place Vertu, 11200 Cavendish Blvd, Ville Saint-Laurent, Qc H4R 2J7

Serve customers by recommending and selling products suitable for their car repairsEnsure quality inventory control of products in storeAdjust products placements according to promotional sales and inventory controlSubmit inventory activities reports to management

1010 Chemin Herron, Montréal, Qc H9S 1B3

Greet and provide efficient welcoming service to guests on the phone and in person to ensure best customer experienceComplete administrative tasks (check-ins, check-outs, daily guests reports) with the use of an operating systemProcess guests’ account data, reservations, billings and paymentsAssist customers’ complaints in an effective and courteous manner by providing quick solutions

Dorval, Montreal, Quebec

Discharged inventory from trucks to palettes in a time constraintPut away the palettes at their appropriate sections in order to be sent to storesEnsured the exact number of inventory

Saint-Laurent, Montreal, Quebec

Maintained the tidiness of the supermarketMet the needs of customers and provide them a good shopping experience

Diploma, Data Science

A Data Science program where I develop the technical skills to perform thorough exploratory data analysis, apply machine learning.

Bachelor Of Engineering (B.Eng.), Industrial Engineering

Activities and Societies: Concordia Dragon Boat Club (VP Internal, Athlete) Member of the Institute of Co-operative Education- Industrial.

High School, Health Sciences

Activities and Societies: Descendants of the Dragon Dragon Boat Team Linguistic Exchange Program with Collège Jean-de-Brébeuf

High School, Health Sciences

Activities and Societies: Conventum Brébeuf 2007-2014