Katelyn Langlois Email & Phone Number

Ottawa, Ontario, Canada

Montreal, Quebec, Canada

• Transformed the invoice processing workflow by developing a highly efficient end-to-end user application using Python. Implemented advanced OCR text recognition capabilities to seamlessly handle over 300 weekly scanned.
• Crafted several highly efficient Excel upload templates, incorporating advanced Excel techniques and VBA, to seamlessly match financial codes with raw data. This meticulous approach contributed to a remarkable.
• Pioneered the development of an unprecedented company-wide profitability analysis. This ground-breaking initiative provided upper management with invaluable insights, enabling them to draw new conclusions and make.

• Directed strategic upskilling of incoming colleagues through the design and delivery of high-value training activities on a range of topics.
• Automated reoccurring reports reducing time required to prepare these reports by 85%+, helping management to make important decisions faster.

Ottawa, Ontario, Canada

• Prepared ad-hoc reports used in key decision making by senior executives.
• Collaborated with several teams to deliver insightful reporting to executive leadership with visualizations, dashboards and data models created using advance excel techniques.
• Utilized web scraping techniques to extract and organize competitor data.

Ottawa, Canada Area

• This position involved providing assistance with background research, data entry, file management and reporting in support of the International Strategic Plan. Highlights include:
• Collaborated with colleagues to create, update, and maintain several data sets which now act as a foundation for better data practices.
• Utilized various methods to collect and analyze information, such as: - constructed an algorithm in R to optimize the collection of thousands of data points; - retrieved and interpreted data from various internal and.
• Communicated with colleagues on how to update and use existing data sets through the creation of various guidelines and workflow diagrams.

Carleton Place

• Initially hired on as a summer student, originally tasked with utilizing Adobe InDesign software to develop dozens of fillable electronic forms, along with other general administrative work. Hired on permanent.
• Performed data cleaning to generate bi-weekly payroll and quarterly sick leave reports for management; reports were presented to HR to support their decision-making practices.
• Created an online employee satisfaction survey, analyzed the results, and produced a statistical report; the report was used by the executive director to facilitate changes in the association.
• Researched and compiled necessary information to successfully produce the publication for the 2019 Annual General Meeting distributed to company executives.

Kanata, Ontario

• Provided one-on-one attention to students, while maintaining overall focus on the entire group; creating higher engagement in student learning and quick response to questions.
• Created custom lesson plans based on student’s course objectives; allowing students to better understand their strengths and areas for improvement.

Ottawa, Canada Area

Initially hired with large group of summer students, during the ETFO work-to-rule campaign, to enter over 600,000 grades into a CRM software and update thousands of paper documents. While re-typing comment sections, I noticed a slowed performance among the student group and suggested the use of a scanner and OCR software, to management. I was then.