Frank Lobe, Developer in Toronto, ON, Canada
Frank is available for hire
Hire Frank

Frank Lobe

Verified Expert  in Engineering

Application Developer

Location
Toronto, ON, Canada
Toptal Member Since
June 27, 2023

Frank is a highly skilled database application developer with 17+ years of expertise in Progress 4GL/OpenEdge ABL. His proficiency extends to analysis and design. With a background in commerce and applied information technology, Frank excels in constructing expansive financial systems for the brokerage, mutual funds, and banking sectors. He has successfully worked on projects with budgets of up to $250 million, serving thousands of users and driving significant profits.

Portfolio

Rocket Pro TPO
Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development...
Constellation Portfolio+
Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development...
International Financial Data Services
Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development...

Experience

Availability

Full-time

Preferred Environment

OpenEdge, Jupyter Notebook, Visual Studio Code (VS Code)

The most amazing...

...project I've created is a new enhanced non-delegated correspondent lending channel that sits between wholesale and traditional non-delegated lending.

Work Experience

Senior Application Developer

2021 - 2022
Rocket Pro TPO
  • Developed the enhanced non-delegated correspondent lending channel, a groundbreaking product bridging the gap between wholesale lending and traditional non-delegated correspondent lending.
  • Led the comprehensive analysis to identify existing functionalities for leverage and areas requiring new or modified features.
  • Created a high-level architectural design for the project, providing a solid foundation for development.
  • Successfully modified the legacy Progress 4GL/OpenEdge ABL system, AMP, to accommodate various mortgage and application package types while complying with state-specific legislation.
  • Achieved seamless integration with middleware and the web front end using REST APIs.
  • Managed the entire project, involved in every aspect and stage from ideation to completion.
  • Successfully launched the product in all 50 states, contributing significantly to Rocket Mortgage's financial performance.
Technologies: Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development, Data Modeling, Financial Services, Unix, Progress 4GL, REST, XML, JSON, Middleware, Git, Mortgages, Systems Analysis, Solution Architecture, Software Design, Finance, Integration, Data Processing, Algorithms, Linux, REST APIs, API Integration

Senior Application Developer

2019 - 2019
Constellation Portfolio+
  • Engaged in system analysis and design of a Progress OpenEdge 4GL-based open banking application.
  • Converted business requirements related to loans, mortgages, term deposits, investments, and retail banking to technical specifications.
  • Created and modified REST APIs following business requirements and technical specifications.
Technologies: Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development, Data Modeling, Financial Services, Unix, Progress 4GL, REST, XML, JSON, Middleware, Systems Analysis, Solution Architecture, Software Design, Finance, Integration, Data Processing, Algorithms, REST APIs, API Integration

Senior Application Developer

2016 - 2019
International Financial Data Services
  • Developed a pioneering solution to reduce foreign exchange spreads on transactions, potentially saving millions of dollars by optimizing the timing of money movement.
  • Successfully integrated IFDS's legacy Progress OpenEdge ABL-based system, iFast, with Bank of America's Instinct system, enabling currency exchange at a transaction level based on market rates.
  • Created ECHO, a groundbreaking product that consolidated seven data feeds into a unified stream of information, providing traders with valuable insights into their next day's cash position.
  • Led the development of seven cutting-edge APIs for Sun Life, enhancing the capabilities of the existing web front end within the iFast system.
  • Ensured seamless integration of the APIs, significantly improving functionality, efficiency, and user experience for Sun Life's clients and stakeholders.
  • Successfully launched ECHO to hundreds of State Street clients, empowering them with enhanced visibility and predictive capabilities for cash management.
  • Contributed to the growth and success of IFDS, State Street, and Sun Life's technology ecosystems through innovative solutions and effective project management.
Technologies: Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development, Data Modeling, Financial Services, Anti-money Laundering (AML), Unix, Progress 4GL, Foreign Exchange (FX) Hedging, REST, XML, JSON, Middleware, Mutual Funds, Systems Analysis, Solution Architecture, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, Linux, REST APIs, API Integration

Senior Application Developer

2014 - 2015
B2B Bank
  • Handle the Progress 4GL OpenEdge-based back-office brokerage system (CPS) that B2B Bank had purchased from the multiple retirement services (MRS) division of Mackenzie Investments while navigating complex legacy systems.
  • Implemented Fundserv ESG 24 and 25 and was extensively involved with the transaction reconciliation file functionality.
  • Effectively utilized my technical skills and deep understanding of CPS to incorporate Fundserv functionalities seamlessly.
  • Integrated CANNEX for GIC products and created two archive solutions for historical information related to B2B Bank's integration of SIT and AGF.
Technologies: Progress OpenEdge 4GL, OpenEdge ABL, APIs, OpenEdge, App Development, Data Modeling, Financial Services, Unix, Progress 4GL, REST, XML, Brokerage, Systems Analysis, Solution Architecture, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, AIX

Senior Consultant

2007 - 2009
Accenture
  • Led a transformative project for the Bank of Montreal, successfully integrating Norkom's advanced anti-money laundering solution into their existing systems.
  • Oversaw the solution's seamless integration across personal and commercial banking, capital markets, and Mastercard transaction flows.
  • Implemented advanced algorithms to scan transactions for suspicious patterns and behaviors associated with money laundering activities, specifically targeting international terrorists and criminal organizations.
  • Facilitated the prompt forwarding of identified profiles to international law enforcement and intelligence agencies for further investigation.
  • Managed the vendor relationship with Norkom, ensuring effective collaboration and successful solution implementation.
  • Successfully managed and coordinated nine distinct development, quality assurance, and user acceptance testing environments.
  • Led the implementation of upgrades across multiple data centers located throughout Canada, ensuring efficient and up-to-date operations.
Technologies: Anti-money Laundering (AML), Financial Services, Unix, REST, XML, Systems Analysis, Finance, Trading, Integration, Data Processing, Algorithms, Investments, AIX

Senior Application Developer

2006 - 2007
Constellation Financing Systems
  • Provided system analysis, design, and development of a Progress OpenEdge 4GL-based finance lease and loan application.
  • Developed functionality related to application credit scoring.
  • Created features associated with contract disposal.
Technologies: Progress OpenEdge 4GL, OpenEdge ABL, OpenEdge, App Development, Data Modeling, Financial Services, Unix, Progress 4GL, Systems Analysis, Solution Architecture, Software Design, Finance, Data Processing, Algorithms

Senior Application Developer

2003 - 2006
Mackenzie Investments
  • Led the development of an advanced defined contribution pension system on the CPS platform, powered by Progress 4GL/OpenEdge ABL.
  • Developed a reconciliation report within CPS that facilitated the efficient reconciliation of general ledger accounts.
  • Undertook a comprehensive rewrite of CPS's pre-authorized credit maintenance screens, enhancing the user experience and optimizing the system's structure.
  • Replaced the manual process by introducing an automated cheque reconciliation system within CPS, improving efficiency and accuracy.
  • Built functionality within CPS to capitalize on trading gains from trade reversals or corrections. By integrating this functionality, the system identified opportunities for increased profitability from favorable trade outcomes.
  • Designed and developed the dealer wholesale pricing platform, a new billing platform that allowed billing dealers directly instead of clients.
  • Orchestrated the successful transfer of assets from National Bank to MacKenzie Financial on behalf of Investor's Group, involving a substantial value of approximately $4.8 billion in cash and assets.
Technologies: Progress 4GL, OpenEdge ABL, OpenEdge, App Development, Data Modeling, Financial Services, Progress OpenEdge 4GL, Unix, Brokerage, Systems Analysis, Solution Architecture, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, AIX

Senior Application Developer

2001 - 2003
Dynamic Funds
  • Spearheaded Fundserv ESG help files implementation projects leading versions 11 through 14. All of these projects were implemented successfully and on time, including several areas of functionality that had failed in prior releases.
  • Played a key role in multiple Fundserv implementations, leading four projects. Successfully managed a team of developers and ensured smooth execution while navigating complex legacy systems.
  • Focused on important Fundserv files, such as order, settlement instruction, and transaction reconciliation files, demonstrating meticulous attention and expertise in these critical components, which formed the foundation of the Fundserv integration.
  • Effectively utilized my technical skills and deep understanding of Corfax. This enabled me to seamlessly incorporate Fundserv functionalities, resulting in efficient order processing, accurate settlement instructions, and transaction reconciliation.
  • Owned the downloading inventory records for back-end load transactions during the conversion to IFDS's system.
  • Contributed to system analysis, design, and development concerning resolving various defects.
Technologies: Progress 4GL, OpenEdge ABL, OpenEdge, App Development, Data Modeling, Financial Services, Progress OpenEdge 4GL, Unix, Mutual Funds, Systems Analysis, Solution Architecture, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, Solaris

Intermediate Application Developer

2000 - 2001
Mackenzie Investments
  • Led the development of a cutting-edge dealer agreement tracking system, leveraging the power of the Progress 4GL/OpenEdge ABL system, CPS.
  • Spearheaded a comprehensive revamp of the CCRA registered account reporting system, leveraging CPS as the platform.
  • Undertook a complete overhaul of the IRS compliance reporting system, transforming it from the ground up using CPS.
  • Embarked on the ambitious task of rewriting CPS's market value reporting system.
  • Developed innovative solutions to transform reporting and tracking processes with CPS and Progress 4GL/OpenEdge ABL.
Technologies: Progress 4GL, OpenEdge ABL, OpenEdge, App Development, Data Modeling, Financial Services, Progress OpenEdge 4GL, Unix, Brokerage, Systems Analysis, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, AIX

Intermediate Application Developer

1998 - 2000
International Financial Data Services
  • Developed a groundbreaking solution in collaboration with IFDS, leveraging the robust iFast system to ensure account holders' portfolios align with specific asset allocation strategies.
  • Implemented IPM on the Progress 4GL/OpenEdge ABL platform, enabling investors to subscribe to models and generate adjusting transactions to maintain the desired asset allocation.
  • Successfully spearheaded the project as a project lead, overseeing its execution from start to finish, ensuring its successful completion.
  • Introduced the Canadian Fundserv model to the European market, defining file data standards and implementing them within the iFast system.
  • Streamlined data transfer and automated critical functions like account reconciliation, order placement, transaction settlement, and accountholder information changes.
  • Fostered enhanced collaboration and information exchange between financial institutions, optimizing operational efficiency.
  • Developed processes to convert all currency-dependent data elements of accountholders from sovereign currencies to euros.
  • Implemented new user interface elements and robust business logical processes in the iFast system.
  • Ensured comprehensive coverage and accuracy in the currency conversion process, maintaining data integrity throughout the system-wide infrastructure.
Technologies: Progress 4GL, OpenEdge ABL, OpenEdge, App Development, Data Modeling, Financial Services, Progress OpenEdge 4GL, Unix, Mutual Funds, Systems Analysis, Software Design, Finance, Trading, Integration, Data Processing, Algorithms, Investments, HP-UX

Enhanced Non-delegated Correspondent Lending Channel

https://www.rocketprotpo.com/partner-with-us-assisted-corr/
The Enhanced Non-delegated Correspondent Lending Channel is a groundbreaking new product introduced by Rocket Pro TPO. It represents a complete transformation, developed from scratch, to bridge the gap between wholesale lending and traditional non-delegated correspondent lending.

The project commenced with a comprehensive analysis to identify existing functionalities that could be leveraged and areas that required new or modified features. A high-level architectural design was then formulated. The development phase encompassed changing the legacy Progress 4GL/OpenEdge ABL system, known as AMP, to accommodate all mortgage and application package types and adhere to state-specific legislation. Seamless integration with middleware and the web front end was successfully achieved using REST APIs.

Through meticulous effort, we successfully transformed this idea into a fully launched product across all 50 states. The impact of this innovative offering on Rocket Mortgage's financial performance has been substantial. I was intimately involved in every aspect and stage of this project, ensuring its success from inception to completion.

Bank of America Merrill Lynch Foreign Exchange

This pioneering product aimed to significantly reduce the foreign exchange spread on transactions by optimizing the timing of money movement. By bringing the movement of funds closer to the point of transaction finalization, the potential cost savings could reach millions of dollars, even for a single transaction.

This functionality was developed for IFDS, specifically for their legacy Progress OpenEdge ABL-based system, iFast. Transactions requiring foreign exchange were exported to an output file and subsequently imported into Bank of America's Instinct system. This approach enabled currency exchange at a transaction level, eliminating the reliance on a fixed exchange rate with a higher spread. The resulting exchange rates were seamlessly imported back into iFast, completing the process.

Through this innovative solution, we aimed to optimize the efficiency of foreign exchange transactions and unlock significant cost savings for IFDS. By integrating iFast with Bank of America's Instinct system, we ensured precise currency exchange rates based on transaction-specific market rates, eliminating the need for less favorable fixed rates.

ECHO Cash Prediction

ECHO was a groundbreaking product designed to consolidate seven separate data feeds into a unified stream of information. This consolidated data feed served as a valuable resource for a new web application, accessible through a REST API. The primary objective was to equip traders with invaluable insights into their anticipated cash position for the following day.

Working on behalf of IFDS, we undertook this project for State Street, leveraging a legacy Progress OpenEdge ABL system. By harnessing the power of this system, we successfully developed ECHO, a robust solution that met and exceeded the project's requirements.

ECHO was launched to hundreds of State Street's esteemed clients following a meticulous development process. Its successful implementation has empowered traders with enhanced visibility and predictive capabilities regarding their cash position, enabling them to make informed decisions confidently.

The completion of this product stands as a testament to our commitment to delivering innovative solutions that drive value for our clients. We are proud to have played a pivotal role in the development and launch of ECHO, which has garnered positive feedback and adoption from State Street's extensive client base.

Sun Life APIs

On behalf of IFDS, I spearheaded the development of seven cutting-edge APIs for Sun Life. This transformational initiative took place within the framework of iFast, a legacy Progress 4GL/OpenEdge ABL system. The primary focus was to augment the capabilities of the existing web front end by introducing these powerful APIs.

The development process entailed meticulous planning and execution to ensure seamless integration of the new APIs with the iFast system. Leveraging my expertise and deep understanding of the legacy infrastructure, I successfully designed and implemented these APIs, unlocking a host of advanced functionalities.

The impact of these APIs on the web front end was truly remarkable. They brought about a significant enhancement, empowering users with broader capabilities, increased efficiency, and improved user experience. Sun Life's clients and stakeholders have leveraged these enriched features to make more informed decisions and streamline operations.

The successful development and deployment of these seven APIs represent a noteworthy accomplishment. I am proud to have played a pivotal role in this project, contributing to the growth and success of Sun Life's technology ecosystem.

Fundserv Help File Implementation

I spearheaded multiple Fundserv implementations for various clients, assuming the lead role in four of them. I successfully led a team of six to seven developers, ensuring seamless execution.

My involvement spanned all existing Fundserv files, focusing on the order, settlement instruction, and transaction reconciliation files. These critical components required meticulous attention and expertise, as they formed the backbone of the Fundserv integration.

Operating within the confines of three legacy Progress 4GL/OpenEdge ABL systems, specifically at Dynamic, MacKenzie Financial, and B2B Bank, I effectively leveraged my technical prowess and in-depth understanding of the systems. This allowed for smoothly incorporating Fundserv functionalities, enabling efficient order processing, accurate settlement instructions, and seamless transaction reconciliation.

I take great pride in my contributions to these projects, navigating complex legacy systems and ensuring the successful adoption of Fundserv at Dynamic, MacKenzie Financial, and B2B Bank. My role as a lead developer has allowed me to make a meaningful impact, collaborating with a talented team to achieve exceptional results.

Norkom Anti-money Laundering Implementation

I had the privilege of leading a transformative project for the Bank of Montreal, which seamlessly integrates Norkom's state-of-the-art anti-money laundering solution into their existing systems. This encompassed personal and commercial banking, capital markets, and Mastercard transaction flows.

The Norkom anti-money laundering solution was pivotal in scrutinizing transactions for potential money laundering activities. Its advanced algorithms meticulously scanned for suspicious patterns and behaviors, explicitly targeting activities associated with international terrorist and criminal organizations. Upon detection, the identified profiles were promptly forwarded to various international law enforcement and intelligence agencies for further investigation.

As a senior technical specialist, I shouldered overseeing the vendor relationship with Norkom. I managed nine distinct development, quality assurance, and user acceptance testing environments. Furthermore, I spearheaded the implementation of upgrades across multiple data centers located throughout Canada.

Investor's Group Migration

Investor's Group underwent a significant transfer of their custodial function from National Bank to MacKenzie Financial. The initial phase of this transition involved the development of a new billing platform, as Investor's Group operated on a distinct billing model. These crucial modifications were implemented within the framework of CPS, a legacy Progress 4GL/OpenEdge ABL-based application.

On June 10, 2005, a momentous milestone was achieved as all assets belonging to Investor's Group were successfully transferred from National Bank to MRS. This transfer encompassed a substantial value of approximately 4.8 billion dollars in cash and assets. As the sole individual responsible for executing this complex movement, I meticulously orchestrated the seamless transfer of these positions.

This achievement highlights my unwavering commitment and expertise in handling complex financial operations. Through meticulous planning, diligent execution, and careful attention to detail, I ensured the smooth transition of assets from National Bank to MRS on behalf of Investor's Group. This accomplishment underscores my ability to navigate high-value transactions with precision and confidence.

Investment Portfolio Modelling

Investment Portfolio Modelling (IPM) marked a groundbreaking addition to UBS's product lineup, developed in collaboration with IFDS. This innovative solution was built upon the robust Progress 4GL/OpenEdge ABL-based system, iFast. The primary objective of IPM was to ensure that account holders' portfolios adhered to a specific asset allocation strategy crafted by professional portfolio managers.

Investors had the opportunity to subscribe to a particular model that aligned with their investment objectives. If their portfolio deviated from the desired asset allocation by a predetermined percentage, IPM generated adjusting transactions to realign the portfolio with the target allocation.

This project was particularly significant, marking my first experience as a project lead. Taking on this role, I embraced overseeing the project's successful execution from inception to completion.

Through meticulous planning, effective collaboration with stakeholders, and comprehensive management of the development process, IPM was brought to life.

Broker Interface System

The broker interface system aimed to introduce the Canadian Fundserv information exchange model to the European market. This ambitious project revolved around defining and implementing file data standards within the iFast system, built on the reliable Progress 4GL/OpenEdge ABL platform.

The key focus of this endeavor was to facilitate seamless data transfer between financial institutions, automating essential functions such as account reconciliation, order placement, transaction settlement, and accountholder information changes. By establishing standardized file data definitions, we ensured compatibility and interoperability across various participants in the financial ecosystem.

We successfully manifested these data standards within the iFast system through meticulous planning and collaboration. This integration streamlined and automated critical processes, reducing manual effort, minimizing errors, and optimizing operational efficiency for all stakeholders involved.

Implementing the broker interface system fostered enhanced collaboration and information exchange between financial institutions.

Introduction of the Euro Currency

I undertook a critical responsibility of developing processes to convert all currency-dependent data elements of accountholders from their previous sovereign currencies to euro. This intricate task encompassed implementing new user interface elements and designing robust business logical processes. The entire conversion was executed seamlessly across the system-wide infrastructure of iFast, a dependable Progress 4GL/OpenEdge ABL platform.

To accomplish this goal, I meticulously analyzed and mapped all currency-dependent data elements, ensuring comprehensive coverage across the system. By integrating new user interface elements, we provided a seamless and intuitive experience for users to interact with the converted euro currency. Simultaneously, I developed and implemented logical business processes to handle currency conversion efficiently and accurately.

The conversion from sovereign currencies to euro presented a unique challenge, requiring a deep understanding of currency exchange rates and intricate financial calculations. With expertise in technical and financial domains, I navigated this complexity, ensuring precision in the conversion process and maintaining data integrity.

Transaction Cancellation and Correction

This project was initiated to leverage trading gains that arise from trade reversals or corrections. This valuable functionality was developed within the framework of CPS, a robust Progress 4GL/OpenEdge ABL system.

The primary objective was to capitalize on opportunities when trade reversals or corrections led to financial gains. By implementing this functionality, we created a streamlined process within CPS to identify and capture these gains, maximizing the overall trading performance.

Through meticulous design and development, we integrated the necessary mechanisms within CPS to detect trade reversals or corrections that resulted in favorable outcomes. This involved comprehensive data analysis, algorithmic calculations, and effective risk management strategies to seize these trading gains.

The successful implementation of this functionality within CPS unlocked the potential for increased profitability and improved trading outcomes. By capitalizing on trade reversals or corrections that generated gains, we enhanced the overall performance of the trading operations, maximizing returns for the organization.

Cheque Reconciliation

The cheque reconciliation system revolutionized manually reconciling cheques by introducing a new, automated system. This innovative solution involved the implementation of a data file reader, which received files from the client directly. The received information was then meticulously compared to the existing cheque records within the CPS system, built on the powerful Progress 4GL/OpenEdge ABL platform.

By replacing the manual reconciliation process, we significantly improved efficiency and accuracy. The new system seamlessly extracted and parsed the data file, seamlessly comparing the existing cheque records. This automated approach reduced the risk of human errors and expedited the reconciliation process, saving valuable time and resources for the organization.

We ensured that the data file reader integrated seamlessly with the CPS system through meticulous design and development, leveraging its capabilities to perform comprehensive and accurate cheque reconciliations. The enhanced system allowed for swift identification of discrepancies and discrepancies between the received data and existing cheque records, enabling prompt resolution and maintaining accurate financial records.

Pre-authorized Credit Maintenance

I undertook the significant task of completely rewriting the pre-authorized credit maintenance screens within the CPS system, powered by Progress 4GL/OpenEdge ABL. This ambitious project involved a comprehensive overhaul to enhance the user experience and optimize the underlying structure.

To achieve these objectives, I leveraged Progress's advanced user interface components and adopted a more modern and efficient object-oriented, event-driven architecture. Through meticulous planning and development, I transformed the existing screens into a sleek, intuitive interface that maximized user usability and productivity.

By utilizing Progress's user interface components, I introduced a visually appealing and interactive design, improving the overall aesthetic and usability of the pre-authorized credit maintenance screens. This modernization significantly enhanced the user experience, empowering users to navigate and interact with the system more effectively.

In addition to the visual improvements, adopting an object-oriented, event-driven structure brought numerous benefits. This approach improved code organization, modularity, and easier system maintenance.

General Ledger Reconciliation

I developed a comprehensive report within the CPS system, powered by Progress 4GL/OpenEdge ABL, to enable users to reconcile general ledger accounts efficiently. This report served as a valuable tool in ensuring accurate financial records and facilitating the reconciliation process.

I designed the report with meticulous attention to detail to provide users with clear and concise information regarding their general ledger accounts. By leveraging the capabilities of Progress 4GL/OpenEdge ABL, I created a robust and intuitive report that presented relevant data in a user-friendly format.

The reconciliation report empowered users to compare and verify the transactions recorded in their general ledger accounts. The report facilitated a streamlined reconciliation process by presenting essential information such as account balances, transaction details, and related data. Users could quickly identify discrepancies or inconsistencies, enabling them to take prompt corrective action.

By utilizing the capabilities of the CPS system, I ensured seamless integration and efficient generation of the reconciliation report.

Market Value Reporting System

I undertook the extensive task of completely rewriting the market value reporting system within CPS, a powerful Progress 4GL/OpenEdge ABL-based system. This ambitious project aimed to enhance the reporting system's accuracy, efficiency, and functionality.

Through meticulous planning and development, I revamped the market value reporting system from the ground up, leveraging the advanced features and capabilities of Progress 4GL/OpenEdge ABL. This rewrite involved redesigning the underlying architecture, optimizing data processing algorithms, and implementing a more intuitive user interface.

By adopting modern coding practices and adhering to industry best practices, I ensured that the rewritten market value reporting system was more robust, scalable, and maintainable. The revamped architecture facilitated streamlined data retrieval, processing, and presentation, resulting in faster and more accurate reporting. Furthermore, I focused on enhancing the user experience by introducing a more intuitive and user-friendly interface.

IRS Compliance Reporting

I undertook a complete overhaul of the IRS compliance reporting system, revamping it from the ground up. This transformational initiative was executed on the CPS system, a powerful platform based on Progress 4GL/OpenEdge ABL.

During the rewriting process, I applied my database application development and analysis expertise to enhance the system's functionality and performance. The new system incorporated modern user interface components, leveraging the capabilities of Progress's user interface technologies. I also implemented an object-oriented, event-driven structure to improve the system's efficiency and maintainability.

By reimagining the IRS compliance reporting system, I ensured it adhered to the latest regulatory requirements and industry best practices. The rewritten system met the specific needs of IRS compliance and provided a seamless user experience for generating accurate and timely reports.

I successfully delivered a robust and efficient IRS compliance reporting system through meticulous planning, rigorous coding, and thorough testing.

CCRA-registered Account Reporting

I embarked on a comprehensive revamp of the CCRA registered account reporting system, undertaking a complete rewrite to elevate its capabilities and performance. This transformational initiative was carried out on the CPS system, a robust platform built on Progress 4GL/OpenEdge ABL.

Throughout the rewriting process, I harnessed my expertise in database application development and analysis to enhance the system's functionalities and optimize efficiency. By leveraging the power of Progress's advanced user interface components, I revamped the user interface to deliver a seamless and intuitive experience for generating CCRA-registered account reports.

Employing an object-oriented, event-driven structure, I meticulously designed and implemented the new system, ensuring its adherence to the latest CCRA regulations and industry standards. The rewritten system not only improved the accuracy and reliability of the reports but also significantly enhanced the overall performance and maintainability.

I successfully delivered a robust CCRA-registered account reporting system through meticulous planning, rigorous coding, and comprehensive testing.

Dealer Agreement Tracking

I spearheaded the development of a cutting-edge system designed to streamline the tracking of dealer agreements. Leveraging the capabilities of the Progress 4GL/OpenEdge ABL system, CPS, I crafted a robust solution that revolutionized how dealer agreements were managed.

Through meticulous planning and meticulous attention to detail, I engineered a user-friendly interface that simplified the process of inputting, updating, and retrieving dealer agreement data. By harnessing the power of CPS, I ensured seamless integration and optimal performance of the tracking system.

This innovative solution provided organizations a centralized platform to monitor and manage their dealer agreements effectively. It enabled real-time tracking of key information, such as contract terms, compliance requirements, and performance metrics, fostering transparency and accountability in dealer relationships.

Furthermore, I implemented advanced reporting functionalities within the system, allowing users to generate insightful reports and analytics on dealer agreement performance. This empowered organizations to make data-driven decisions, optimize their dealer networks, and drive business growth.

Defined Contribution Pension System

I led the development of an advanced defined contribution pension system, leveraging the power of the Progress 4GL/OpenEdge ABL system, CPS. This transformative project aimed to revolutionize how pension contributions were managed and administered.

With a deep understanding of pension regulations and industry best practices, I meticulously designed and implemented a comprehensive system that catered to defined contribution pension plans. The system incorporated robust features and functionalities to automate and streamline various aspects of pension management.

Through CPS, I developed an intuitive user interface that allowed administrators to effortlessly input and track pension contributions, monitor investment performance, and generate accurate reports. The system seamlessly integrated with external financial institutions and custodians, ensuring smooth data exchange and accurate reconciliation of pension transactions.

I also implemented sophisticated calculation engines within the system to handle complex pension calculations, such as employer matching contributions, vesting schedules, and investment returns. This ensured the accurate and timely processing of pension-related transactions and benefits.

Credit Card Default Analysis

https://www.kaggle.com/code/franklobe/credit-card-default-analysis
This Kaggle notebook consists of a comprehensive demonstration of utilizing classification machine learning algorithms from the scikit-learn library to accurately predict the probability of credit card default. The prediction is based on an array of informative features, including credit limit, age, billing amounts, payment amounts, gender, education, and relationship status. Exploring this notebook will allow valuable insights into the implementation and effectiveness of these algorithms for credit risk assessment.

Electricity Usage Clustering

https://www.kaggle.com/code/franklobe/electricity-usage-clustering
This Kaggle notebook explores the application of clustering techniques to segment clients into distinct groups based on their usage patterns. The goal is to identify low, medium, and high-usage clusters, enabling the identification of high-profit clients and gaining deeper insights into their usage behavior.

The dataset utilized in this analysis comprises three primary data elements: Client, Time, and Usage. Client and Time serve as dimensions, while Usage represents a fact table. This arrangement allows for a comprehensive examination of data both horizontally across clients and vertically across time.

The time segments are explored using various time aggregations, including 15-minute intervals, hourly periods, weekdays, and months to provide a comprehensive analysis. Moreover, a year-over-year comparison is presented to identify significant changes or trends.

Financial Time Series

https://www.kaggle.com/code/franklobe/financial-time-series
This Kaggle notebook delves into time series analysis by exploring the price histories of prominent companies such as Facebook, Amazon, IBM, and 3M. The notebook focuses on several crucial aspects, including the correlation of returns, trend analysis, seasonality exploration, stationarity assessment, and autocorrelation investigation.

Python Django

https://github.com/FrankLobe/Django
In this Python Django example, I transformed my resume into a dynamic and interactive website powered by Python's Django framework. This website consists of eight views (certification, contact, cover letter, education, employment, experience, index, and skill), along with associated models and templates. Content is database-driven. A form has been included to collect contact information and customize content by job type.

TypeScript Project

https://github.com/FrankLobe/TypeScript
In this TypeScript example, I transformed my resume into a dynamic and interactive website powered by TypeScript and JavaScript. This website has eight views: certification, contact, cover letter, education, employment, experience, index, and skill. It also has associated models and templates. It is content is database-driven. A form has been included to collect contact information and customize content by job type.

Node.js, Express.js and MongoDB

https://github.com/FrankLobe/NodeJS
In this Node.js example, I transformed my resume into a dynamic and interactive website powered by Node.js and Express.js on the back end. This website has eight views (certification, contact, cover letter, education, employment, experience, index, and skill). Content is database-driven from MongoDB. A form has been included to collect contact information and customize content by job type.

React Project

https://github.com/FrankLobe/ReactJS
In this React example, I transformed my resume into a dynamic and interactive website powered by React. This website has eight views: certification, contact, cover letter, education, employment, experience, index, and skill. The content is database-driven from MongoDB. A form has been included to collect contact information and customize content by job type.

Angular Project

https://github.com/FrankLobe/Angular
In this Angular example, I transformed my resume into a dynamic and interactive website powered by Angular. This website has eight views: certification, contact, cover letter, education, employment, experience, index, and skill. The content is database-driven from MongoDB. A form has been included to collect contact information and customize content by job type.

NextJS Project

https://github.com/FrankLobe/NextJS
In this NextJS example, I transformed my resume into a dynamic and interactive website powered by NextJS. This website has eight views: certification, contact, cover letter, education, employment, experience, index, and skill. The content is database-driven from MongoDB. A form has been included to collect contact information and customize content by job type.

React Native Project

https://github.com/FrankLobe/ReactNative
In this React Native example, I transformed my resume into a dynamic and interactive mobile application powered by React Native. This website has eight views: certification, contact, cover letter, education, employment, experience, home, and skill. The content is database-driven from Google Firebase Firestore using a Google Cloud function REST end-point. A form has been included to collect contact information and customize content by job type.
1997 - 1998

Postgraduate Diploma in Applied Information Technology

Information Technology Institute (ITI) - Toronto, Ontario, Canada

1992 - 1996

Bachelor's Degree in Commerce (Finance)

York University - Toronto, Ontario, Canada

APRIL 2024 - PRESENT

React Native – The Practical Guide [2024]

Udemy

FEBRUARY 2024 - PRESENT

Next.js 14 & React - The Complete Guide

Udemy

NOVEMBER 2023 - PRESENT

Angular – The Complete Guide (2023 Edition)

Udemy

NOVEMBER 2023 - PRESENT

Modern React with Redux

Udemy

OCTOBER 2023 - PRESENT

NodeJS - The Complete Guide (MVC, REST APIs, GraphQL, Deno)

Udemy

SEPTEMBER 2023 - PRESENT

Understanding TypeScript

Udemy

SEPTEMBER 2023 - PRESENT

ES6 Javascript: The Complete Developer's Guide

Udemy

SEPTEMBER 2023 - PRESENT

Asynchronous JavaScript: Promises, Callbacks, Async, Await

Udemy

SEPTEMBER 2023 - PRESENT

Object-oriented Programming in JavaScript

Udemy

SEPTEMBER 2023 - PRESENT

JavaScript Basics for Beginners

Udemy

SEPTEMBER 2023 - PRESENT

Python Django - The Practical Guide

Udemy

AUGUST 2023 - PRESENT

The Complete Python Bootcamp From Zero to Hero in Python

Udemy

Languages

OpenEdge ABL, XML, Python, HTML, CSS, JavaScript, JavaScript 6, TypeScript

Tools

OpenEdge, Progress 4GL, Git, Seaborn, StatsModels, JSX

Other

APIs, Progress OpenEdge 4GL, Systems Analysis, Solution Architecture, Software Design, Finance, Trading, Integration, Data Modeling, Financial Services, Middleware, Brokerage, Mutual Funds, API Integration, Anti-money Laundering (AML), Foreign Exchange (FX) Hedging, Mortgages, Data Processing, Algorithms, Investments

Libraries/APIs

REST APIs, Scikit-learn, Matplotlib, NumPy, Pandas, SciPy, Node.js, React

Paradigms

REST, App Development

Platforms

Unix, Linux, HP-UX, AIX, Solaris, Visual Studio Code (VS Code), Firebase

Storage

JSON, IBM Db2, MongoDB, Cloud Firestore

Frameworks

Django, Bootstrap, Django REST Framework, Express.js, Angular, Next.js, React Native

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring