Justin Olgui Email & Phone Number

Burnaby, British Columbia, Canada

Vancouver, Canada Area

• Automated 10+ essential department processes saving 30+ hours/month using Excel VBA• Ensured data accuracy by integrating data validation checks, accessible to team members• Delivered ad hoc reporting on various prepaid programs, enabling management to make better informed decisions during contract negotiations• Reviewed and assessed Vancity’s credit card portfolio by conducting market analysis and assisting with financial modeling to support the business case for new products… Show more • Automated 10+ essential department processes saving 30+ hours/month using Excel VBA• Ensured data accuracy by integrating data validation checks, accessible to team members• Delivered ad hoc reporting on various prepaid programs, enabling management to make better informed decisions during contract negotiations• Reviewed and assessed Vancity’s credit card portfolio by conducting market analysis and assisting with financial modeling to support the business case for new products. (Visa Infinite, Visa Infinite Privilege, Visa Business) Show less

• Prepared customized reports through Power BI, providing greater business insights to management thus enabling a 43% reduction of card designs resulting in savings on production and storage costs• Developed an automated comprehensive card servicing tool with built-in data validation, eliminating hours of manual data entry and significantly reducing errors• Performed data clean-up and reconciliation in order to enable a successful conversion to new accounting software with superior… Show more • Prepared customized reports through Power BI, providing greater business insights to management thus enabling a 43% reduction of card designs resulting in savings on production and storage costs• Developed an automated comprehensive card servicing tool with built-in data validation, eliminating hours of manual data entry and significantly reducing errors• Performed data clean-up and reconciliation in order to enable a successful conversion to new accounting software with superior reporting Show less

• Analyzed and segmented 1000’s of changes identified by the business in the Product Backlog into 100+ clusters as per Scrum methodology• Collaborated and consulted with key stakeholders and developers to identify risks and opportunities resulting from the banking platform conversion to T24• Prepared qualitative and quantitative Impact Assessments in an Agile environment to inform management and provide specialized advice and recommendations

Data Analyst Nanodegree, Computer Programming

Intro To Programming Nanodegree, Computer Programming

Excel Vba And Excel Macros, Business/Office Automation/Technology/Data Entry

Sql Data Analysis, Data Modeling/Warehousing And Database Administration