Reliance Home Comfort
- Map, clean and wrangle Progress 4GL database to an SQL platform
- Clean and merge data from different sources
- Transform docx to pdf (using API) and re-create deleted files (VBA)
- Loan Financing, Financial Reporting
Strategic Information Technology
- Loans, Mortgages, Term Deposits, Investments, RRSPs
- Code BCTESG Module for BC
- Work on debug backlog
- Progress 4GL/ABL
Long & McQuade
- Progress 4GL, ABL, OpenEdge Development
- Data analysis for Sales and Customer Reports
- Exception and data inconsistency reporting, pattern analysis
- Document Business Processes
Capital G Bank Limited (Bermuda)
- Support off-shore banking system dealing with mortgages, deposits and loans using Progress 4GL
- Debugging and dealing with system issues
- Business Process improvement recommendation
Bravepoint Inc. (USA)
- Support company that has manufacturing facilities in Europe, North and South America, and in Asia, Order Processing and Supply Chain (MFG/PRO)
- Interface with Marketing department to decide what data was available and needed for analysis and reporting
- Developed and integrated Access CRM system to work with the MFG/PRO ERP system using Progress 4GL
- Sales Analysis and Reporting
Platform Computing Inc.
- Designed, implemented and maintain customized applications
- Progress 4GLto Excel and Access interface Deal with changing data from the SAP system (ETL)
- Create queries and reports, including exceptions reports and Excel attachments
- Handle yearly changing data processing and output requirements
- Interface with Crystal Reports 8 and SAP
L.V. Lomas Ltd.
- Data mining/Business Intelligence and information requests for Sales Forecasting, Pricing, Costing, Inventory, and Marketing
- Design Logical Data Model for new systems and re-development
- Import and export data to and from web site, uploads to bank (EFT) and Lotus Notes, EDI
- Create reports for sales reps and managers than allow drill-down analysis
- Various government agency compliance and tax auditing reports
Teknion Furniture
- Prototyping and implementation of Special Pricing System which included data from external system with changing content and format using Progress 4GL
- Data Analysis to help design rules for Sales Competitions, which changed on a yearly basis and required modified or new applications
- Analyzed, designed and implemented various modules to deal with Teknion specific needs for returns and warehousing
- Interface to use Excel for Marketing Analysis, Sales Forecasting and Tracking