from Oct 2020 to Present

Loblaw Companies Limited, Brampton ON

Loblaw Companies Limited is a Canadian retailer encompassing corporate and franchise supermarkets operating under 22 regional and market-segment banners, as well as pharmacies, banking and apparel.

• Led the migration of SAP Business Technology Platform (BTP) from the legacy NEO environment to the modern Cloud Foundry platform.
• Developed an SAP UI5 Fiori JavaScript web application using the MVC pattern to assist external vendors in sending cost changes to our finance team. This project spanned 4 months and resulted in saving a minimum of 40-50 hours a month for both vendors and internal employees combined. Additionally, the project significantly reduced miscommunication that used to occur through emails between vendors and internal employees. The SAP UI5 application connected with the SAP backend via an OData RESTful protocol.
• Develop, deploy, and maintain custom ABAP programs, reports, interfaces, and enhancements to support business processes within SAP ecosystem.
• Collaborate with functional teams to translate business requirements into technical specifications.
• Perform unit testing, integration testing, and user acceptance testing to verify the quality and reliability of developed solutions.
• Conduct performance tuning and optimization of ABAP programs and SAP table indexes to improve system performance and resources consumption.
• I am a member of the dev leads board tasked with safeguarding our SAP system from unnecessary customizations. As part of our duties, we review and conduct due diligence on newly developed programs, calling in developers to justify the business use case for any new objects introduced into the SAP ecosystem. Additionally, I suggest alternative solutions to developers, encouraging them to use out-of-the-box SAP functionalities as much as possible.
• Trained developers on syncing their custom SAP programs with Loblaw's GitLab repositories and instructed them on how to manage version control across GitLab branches.
• I have documented 177 processes, ranging from small to complex procedures, to serve as a go-to resource whenever the team needs a refresher on how to accomplish certain tasks.
• Utilize Robot Framework to automate approximately 10-15 weekly and monthly SAP BASIS tasks.

from Mar 2018 to Oct 2020

Loblaw Companies Limited, Brampton ON

Loblaw Companies Limited is a Canadian retailer encompassing corporate and franchise supermarkets operating under 22 regional and market-segment banners, as well as pharmacies, banking and apparel.

• Developed and maintained a diverse range of reports—over 150 in total—that are distributed to more than 100 employees across various supply chain departments, such as meat, produce, confectionery, grocery, apparels, and cosmetics departments. The frequency of report distribution varied, ranging from daily, weekly, bi-weekly, monthly, quarterly, and yearly. All reports were triggered by Windows Task Scheduler starting from 7AM to 5PM. These reports were generated using a mix of technologies such as Teradata, Oracle GoldenGate, Excel VBA, Access VBA, and SAS. Many of the custom reports involved extensive data manipulation, demand forecasting, inventory planning, and replenishment optimization.
• Created a Vendor Supply Chain Portal using Microsoft PowerApps Dynamics 365. This portal facilitated the interactions between vendors and Loblaw's internal supply chain team. Vendors used the portal to inform supply chain team which products to discontinue and suggested substitutes as well as vendors used the portal to propose new products. The development process included implementing entities, filters, authentication, and authorization via PowerApps.
• Managed two co-op summer interns, offering continual support and mentorship to assist them in completing their projects successfully.

from Sep 2017 to Mar 2018

Acklands-Grainger Inc, Markham ON

AGI is a company of over 2,600 dedicated team members working together to make it easier for our customers by providing proactive safety and operational solutions. As Canada’s largest distributor of industrial supplies, they offer the largest selection of in-stock brand-name products from the world’s top manufacturers and the largest exclusive private-label offering in the industry.

• Generated ad-hoc reports tailored to business needs, focusing on reducing overdue open orders.
• Collaborated closely with managers and peers to streamline the process of closing outstanding orders, enhancing operational efficiency.
• Produced daily and weekly standard reports for leaders and managers, facilitating data-driven decision-making in Order Management.
• Leveraged tools such as Teradata, Microsoft Access, SQL Server, and Excel Pivots to develop and deliver daily reports.

from Jan 2014 to Dec 2016

ERIS - Environmental Risk Information Services, Toronto ON

Environmental Risk Information Service Ltd. (ERIS) is North America’s provider of property related environmental risk information. ERIS delivers accurate, affordable, on-demand research services for property related data and reference materials. The ERIS system electronically accesses federal, provincial, and private sector databases containing millions of current and historical environment records to identify potential environmental threats on Canadian properties.

• Used ad-hoc SQL queries to analyze and optimize structured and unstructured environmental data from government agencies and fit them into ERIS' enterprise data warehouse (EDW).
• Designed and implemented PL/SQL programs within Oracle Developer tool to catch data errors and data integrity issues.
• Created, managed, reviewed, and simplified Standard Operating Procedures (SOPs).
• Developed complex and comprehensive web scraping programs with Ruby to legally extract publicly available environmental data from federal and provincial government websites.
• Onboarded and trained new team members about ERIS data infrastructure.

from Feb 2013 to Nov 2013

Centennial College

Designed and created a sophisticated relational database for a web job portal system named College Cornerstone, enabling employers to engage with college students participating in co-op programs.

I took charge of a startup idea initiated by an Information and Communication Technology (ICT) professor. Broke down the idea into achievable user stories through Pivotal Tracker tool. My core responsibilities included requirements gathering, database design, database implementation, and project management. By engaging in the project, I kickstarted the database design process, prepared all necessary hand-sketched wireframes and prepared SQL queries for web pages. My initiative inspired technical students to participate in the project, leading to its successful delivery by summer 2023. The project was completed within a span of 5 months.

Furthermore, I created the Entity Relationship Diagram (ERD) using Crow's Foot notation in MS Visio and implemented the database design with MySQL, and the team developed the web portal using Yii PHP framework.

from Jan 2008 to Dec 2011

G.M. Applied Technologies Canada Inc.

GMATechs specializes in importing and exporting fiber-optics for commercial sites and they offer telecommunication consultancy services to businesses in the Middle Eastern MENA region. My responsibility involved creating an online presence for GMATechs and converting manual paper-based procedures into digital processes.

• As a business and technical analyst, my role involved gathering requirements for developing the company's Windows desktop application, Supplier Relationship Management (SRM). This application aimed to streamline various day-to-day tasks, including creating and managing suppliers, processing orders, generating PDF invoices, tracking inventory, and producing shipping labels. The technical aspects involved designing an OLTP relational database using Microsoft SQL Server 2008, while the desktop application was developed using C# on the .NET Framework 3.5 in Visual Studio 2008.
• Implemented a three-tier architecture (presentation layer, business layer, and data access layer) for the desktop application.
• Constructed SQL reporting services with SQL Server Reporting Services (SSRS) to facilitate informed business decisions.
• Managed and coordinated the construction of the company's digital footprint.

from Jan 2014 to Dec 2016

Memorial University of Newfoundland

from Jan 2012 to Dec 2013

Centennial College, Toronto ON

The Software Engineering Technology program in Centennial College has met the national technology accreditation requirements established by the Canadian Council of Technicians and Technologists (CCTT) and, as such, has received national accreditation status by the Canadian Technology Accreditation Board (CTAB). The holder of the Software Engineering Technology advanced diploma is recognized as a Certified Engineering Technologist.

from 2009 to 2010

Centennial College, Toronto ON

Linux Professional Institute (LPI)

• First, Break All The Rules by Don Clifton
• Mastering Business Systems Analysis (Trond Frantzen)
• Atomic Habits by James Clear
• Ask and It is Given by Esther and Jerry Hicks
• Biogeometry Signatures by Dr. Ibrahim Kaim
• Outwitting the Devil by Napoleon Hill
• The 5 Love Languages by Gary Chapman
• Database Systems: Design, Implementation, and Management (Coronel/Morris/ROB)
• Database Design Pattern: Role-Based Security (Yukon College)
• Data Modeler's Workbench (Steve Hoberman)
• Scale: Seven Proven Principles to Grow Your Business and Get Your Life Back
• Head First Design Patterns (Elisabeth Freeman, Eric Freeman, Bates, Sierra, and Robson).
• A fan of Y Combinator
• Designing Data-Intensive Applications by Martin Kleppmann (I haven't read it yet. Its in My Wish List)
• Time Travel: Through Consciousness and Advanced Technology by Frederick Dodson (I haven't read it yet. Its in My Wish List)