DevOps Engineer

• Apr 2021 - Present

Smart Technology Associate, Corporate Real Estate

• May 2020 - Aug 2020

• Collaborated with Agile development team to produce deliverables for stakeholders across RBC’s global enterprise.• Built Tableau portfolio and finance dashboards providing an overview of RBC’s real estate portfolio and associated expenditure.• Automated data ingestion from third-party vendors using Python and RBC APIs for analysis by RBC CRE.• Performed data analysis and forecasting for retail location fiscal expenditure and assisted with COVID-19 return to premises data analysis.• Performed quality assurance on data ingested to SQL server and wrote Python scripts to automate repetitive Excel procedures.• Elicited requirements for dashboards, data ingestion, and other deliverables from executives across RBC CRE

Business Intelligence Intern, Vendor Management

• May 2019 - Aug 2019

● Created SQL scripts using SQL Server Integration Services (SSIS) for the automated transposition and aggregation of data from csv and xlsx files to centralized SQL databases. ● Utilized data analysis tools such as Tableau and Qlik Sense to build dashboards utilized by vendors across RSA's extensive network of repair shops and brokers to monitor performance and billing.● Wrote Visual Basic scripts to automate aggregation of data for different vendors● Used SQL stored procedures to manipulate large data sets and type matching.● Handled sensitive information destined for offsite storage.● Streamlined process for sending documents to offsite storage● Retrieved requested claim files for audits and lawsuits● Recovered over $263,000 in double-billed invoices from vendors

Security Officer

• Jun 2018 - Sep 2018

● Worked in residential condominium as concierge● Conducted hourly patrols of premises● Responded to fire alarms and emergency situations● Worked in commercial setting guarding high value assets at the Samsung warehouse ● Worked in residential condominium as concierge● Conducted hourly patrols of premises● Responded to fire alarms and emergency situations● Worked in commercial setting guarding high value assets at the Samsung warehouse

Press Shop Technician

• May 2018 - Jun 2018

● Supported the assembly process of body panels and components for major automobile manufacturers such as Chrysler, Ford, GM, Honda, Toyota, and Volkswagen● Monitored product line and performed quality assurance checks to ensure product met standards● Trained in and abided by numerous safety standards and regulations in a manufacturing environment ● Supported the assembly process of body panels and components for major automobile manufacturers such as Chrysler, Ford, GM, Honda, Toyota, and Volkswagen● Monitored product line and performed quality assurance checks to ensure product met standards● Trained in and abided by numerous safety standards and regulations in a manufacturing environment