Application Development Manager
2021 - 2022Accenture- Led the design and development of analytical data processing system to identify ineligible loans in the COVID-19 relief loan program to support issuing demand letters.
- Designed an approach for identifying and resolving discrepancies among five interconnected data sets, each potentially with data quality issues, to confirm the completeness of over $40 billion of loan data and the correctness of key details.
- Supported business investigations of customer-facing issues with detailed and accurate stories of customer and system activity based on broad analytical querying of the database.
Technologies: Azure SQL, Excel Expert, Excel VBA, SQL, Data Analysis, Data Analytics, Git, Source Control Management, Code Review, Analytics, Database Schema Design, Databases, Microsoft Excel, Microsoft SQL Server, SQL Stored Procedures, Data Engineering, Data Profiling, Data Cleansing, Azure, Azure Data FactoryApplication Development Associate Manager
2014 - 2021Accenture- Built valuable systems for major clients, including Bank of Montreal, CIBC, Government of Canada, and Royal Bank of Canada, as part of Accenture from 2017 onwards and as part of Verax Solutions from 2014 until our 2017 acquisition by Accenture.
- Managed projects that included over $40 billion COVID-19 relief program, bank-wide regulatory reporting systems liquidity risk, asset and liability management, CDIC resolution plan, and online banking system improvements.
- Provided extensive, detailed feedback on specifications for loan application and approval processing, catching issues that would have resulted in data integrity issues, faulty system behavior relative to business expectations, and performance issues.
- Developed T-SQL stored procedures, functions, and data models to implement complex loan application intake and approval processing business logic with correctness, performance, and traceability.
- Supported business and operations stakeholders by providing custom data extracts and by providing precise and detailed explanations of non-obvious issues with and interactions within business logic, and ultimately implementing fixes to requirements.
- Collaborated with other technical team members providing code reviews and mentorship on effective coding, troubleshooting, and resolving logic and performance issues. Facilitated clear and effective communication with the business team.
- Developed practices for effective source code, environment, and release management. These practices resulted in fast and reliable deployments and effortless reproduction of the production environment for developers to reproduce potential defects.
- Built modular, configurable, maintainable, and usable software for managing large data processing batches. The software allowed operations team members to diagnose and fix issues and implement small changes strictly through configuration.
- Managed and developed databases and software using metadata and code generation, facilitating significant building functionality with less time and effort while working within the client's technical and operational constraints.
- Performed process improvements and tool development, reducing manual effort, including test execution, test data analysis, and reference data management. This work allowed the business team to focus on their work rather than low-level details.
Technologies: .NET, Oracle Database, SQL, Azure SQL, SQL Server 2016, Excel Expert, Excel VBA, Git, Microsoft Team Foundation Server, Source Control Management, Code Review, Parsers, Python, ETL, PostgreSQL, Data Analysis, Data Analytics, Analytics, Database Schema Design, Databases, Oracle, Microsoft Excel, Microsoft SQL Server, JavaScript, SQL Stored Procedures, Microsoft Access, SaaS, Data Engineering, Data Profiling, Data Cleansing, CSV File Processing, CSV Export, CSV Import, Azure, Azure Data FactorySoftware Programmer
2013 - 2014Systems Logic- Helped save a bad software deployment, an intractable database deadlocks, by recommending MVCC Snapshot isolation be enabled.
- Fixed numerous performance problems by profiling and fixing application code and fixing database issues, including row-by-row processing, missing indexes, and query optimization.
- Developed features and maintained a warehouse management system.
Technologies: SQL, SQL Server 2008, .NET, JavaScript, HTML, CSS, Windows Forms (WinForms), Excel Expert, Parsers, Subversion (SVN), Data Analysis, Data Analytics, Source Control Management, Analytics, Database Schema Design, Databases, Microsoft Excel, Microsoft SQL Server, SQL Stored Procedures, SaaS, CSV File Processing, CSV Export, CSV ImportDevelopment Coordinator and Analyst
2012 - 2013Powerconsumer- Implemented and designed algorithms for reducing energy costs subject to operational constraints and quantified cost savings of each scenario.
- Designed and built a database tracking the electricity market and customer usage data.
- Created data entry and import tools for the electricity market and customer usage database.
Technologies: .NET, SQL, SQL Server 2008, Windows Forms (WinForms), Microsoft Access, Excel Expert, Git, Data Analysis, Data Analytics, Source Control Management, Analytics, Database Schema Design, Databases, Microsoft Excel, Microsoft SQL Server, SQL Stored Procedures, CSV File Processing, CSV Export, CSV ImportDeveloper, Tester, and Analyst
2008 - 2011Freelance Clients- Developed a web application for tracking and managing engineering drawings at a small, local hydroelectric company. Worked directly with the end user, a civil engineer, from requirements elicitation to acceptance.
- Developed a web application for breaking down and explaining electricity bills. Worked directly with stakeholders, the president of an energy consumer advocacy group, from requirements elicitation to acceptance.
- Supported an engineering group at a large electricity transmission company in managing grid protection and control equipment and settings across Ontario. Performed UAT testing, custom data extracts, and custom MS Access application.
Technologies: .NET, Java, JavaScript, HTML, CSS, Apache Derby, Microsoft SQL Server, Git, Excel Expert, Visual Basic for Applications (VBA), Excel VBA, Microsoft Access, SQL, Data Analysis, Data Analytics, Analytics, Database Schema Design, Databases, Microsoft Excel, SQL Stored Procedures, CSV File Processing, CSV Export, CSV Import