Song Lin

CIBC Trading Credit System (TRACS) Enhancement & FIS Adaptiv System Upgrade Enhanced CIBC TRACS system to deliver scalable, secure, high-performance enterprise reporting and trading solutions, integrating with vendor FIS systems and supporting critical business operations.. Developed and optimized backend services and APIs, including QueryStore API, GetTransactionAPI, and GetDealTransactionWWR API, improving system reliability and processing performance. Upgraded modules (e.g., ERSAccountExtract) to leverage MSAL libraries for enhanced security and performance. Vendor Upgrade of CIBC FIS Credit Risk Manager systems from 2015 version up to Current, including major upgrades of dataflow interfaces between CIBC and Vendor FIS systems. Lines of products include Forex, Equity, Exotic, ETD, IR products, IR Swaps, Commodity, SFT Products, Fixed Income, Static Data PPM, Transactions, etc Worked with the Snowflake cloud data platform for TRACS system including highly streamlined ELT workflows, advanced SQL operations, and  taking advantage of its seamless scalability. Applied AI-assisted coding tools (GitHub Copilot) for rapid prototyping, code generation, and peer code reviews, improving development efficiency while maintaining high-quality standards. Collaborated closely with Business Analysts (BAs) and QA teams in Agile/Scrum ceremonies (sprint planning, daily stand-ups, backlog grooming) to ensure timely delivery of features. Managed CI/CD pipelines using Azure DevOps and TFS, ensuring automated testing, version control, and seamless deployment across environments. Technologies Used: Microsoft Azure Cloud, Github Copilot AI tool, CI/CD Pipeline, TFS (Code Management), Autosys (Job Scheduling), .NET/C#, MS SQL Server (Complex Logic), XML/XSLT Extractor.

New Member Portal migration Project 1. Played key developer role in migrating old member portal to new member portal for member services. 2. Maintained and Enhanced old portal which is a multi-layer structure with jsp front-end, java middle-tier and oracle DB as back-end. 3. Developed various features of new member portal with technologies below: Angular as front-end, MongoDB and Elastic search as back-end, micro-service, Boomi as middle-tie. 4. Pioneered in member portal data migration(MongoDB), Data Exchange Router and Repository implementation(Message queues and pipelines configuration and setup in Azure Cloud), Member Related Initiative etc. 5. Redesigned member portal services front-end using low-code platform, prioritizing AODA compliance in the redesign. 6. Adopted Agile process for development work, including sprint planning, daily scrum stand-up, collaboration and pair programming with team members, etc. 7. Daily Meetup with various teams such as infrastructure support, database Support, Enterprise Architecture, Web security, QA testing and deployment team, 3rd party vendors, etc Technologies: Jsp/Java/OracleDB, C#/.Net, MongoDB/ElasticSearch, Javascript/Node.Js/microservice, Enterprise Architect(Sparx), Jira, Azure message queues, etc

Confirmations Space Capital Markets, GWRT Securities Group, Scotiabank, ON Facilitated the seamless integration of multiple trade products into the Confirmation-hub platform to revolutionize trade affirmation and confirmation procedures, with a strong emphasis on leveraging technology 1. Onboarded various trade products on Confirmation-hub platform to automate trade affirmation and confirmation processes. 2. Developed various features such as data import and mapping, trade view, Swift document generation, settlement instruction, matured trade chasers, regulatory message handling, data Model and smartComm etc. 3. Implemented new data processes to import trade data from elastic search repositories. Implemented various reconciliation and evaluation processes for various trades. Streamline Kafka data importing process. 4. Optimized powershell scripts, database sql/stored procedures, table indexing for better performance. 5. Worked closely with Business Analyst to gather information and find support from various business teams, groomed stories and tasks in Jira for each new spring, code check-in and deployment using Azure DevOps, flyway for database version control, shared developer tips and knowledge using confluence.

Ontario Teacher’s Pension Plan, Toronto, ON, Platform and Shared Services Develop/enhance/replace various applications to improve Enterprise IT efficiencies and keep technologies current. 1. Developed an ElasticSearch NEST-based EnterpriseLog API client to replace costly Active Space technologies, enhancing performance while reducing expenses. 2. Implemented the OTPP Enterprise logging system using ELK (Elasticsearch, Logstash, Kibana) technologies, including configuring messaging queues, Filebeat, and Logstash pipelines for log processing and Elasticsearch setup. 3. Created an SSIS Log provider client application for seamless integration with Filebeat and Logstash, ensuring backward compatibility. 4. Transferred the OTPP Enterprise Email Service from Tibco BW to a .NET WCF application hosted on IIS. Moved the system to the Azure Cloud platform and implemented Azure Functions for enhanced functionality. 5. Redesigned member portal services using OutSystems low-code platform, prioritizing AODA compliance in the redesign. 6. Established CI/CD pipelines with Jenkins, PowerShell scripting, Docker containers, and Azure Cloud Services for streamlined deployment. 7. Conducted weekly Agile/Scrum planning using Confluence and Jira, with Git/GitHub for code version control.

1. Implemented Infrastructure change of Cairo Currency Application from 3-tier to 4-tier application, split Middle tier into Web tier for user interface, and App tier for business logic and database access. 2. Re-factored the client’s legacy portal application with React and Redux; applied concepts include Redux Thunk, reducers, action generators and selectors; unit tested code with Jest. 3. Upgraded application .net framework from .net 4.0 to .net 4.5.2 and database from sql server 2008 to sql server 2016 4. Developed new deployment Powershell script to accommodate infrastructure change. 5. Created new deployment document providing step-by-step instruction for Operational Support team to deploy application to multiple environments. 6. Worked closely with Project Architect, Business Analyst, testing and deployment team. Followed SDLC approach from understanding architectural design document, to detail implementation, to testing and deployment.

1. Collaborated closely with stakeholders to refine requirements in response to evolving business needs. 2. Developed a loss mitigation tool within the in-house debt management system "Genesys," incorporating mortgage refinancing capabilities. Implemented intricate eligibility and refinancing calculations aligned with GRM (Global Risk Management) business requirements. 3. Created the in-house debt collection system "Agency Tracker," optimizing the account agency assignment process for heightened collection efficiency, reduced manpower, and improved data accuracy. Implemented accessible reports for swift commission payments to external agencies. 4. Enhanced the "Property Tracker" application to meet new business requirements and seamlessly integrated it with the "Agency Tracker," consolidating both into a unified web application for improved business activity management. Revamped the web application UI using modern JavaScript technology with the Angular framework. 5. Facilitated the transfer of data from OLTP to OLAP systems using SSIS as the ETL tool. Generated comprehensive reports using SSRS/Power BI for effective business visualization and monitoring purposes.

Enterprise Application developer (See Accomplishments)

• Developed a database system for mail processing, which reduced man-power by 30% and increased the department revenue by 15%. • Analyzed, designed and implemented a complex database system to integrate all processing activities by functions. • Provided data archiving, service report generating, centralized billing, job order processing, and automated processing of all functions using one system. • Provided user support and training to all department employees and provided documentation for all systems. • Managed and implemented database installation, upgrades, maintenance, backup system and enhancements. Technical environment: Windows XP Professional, MS Excel, MS Access 2000, MS SQL server 2000, Visual Basic;

• Provided technical support to a Local area network system with 150 users in 4 departments • Performed Windows systems setup, software installation, hardware configuration, and network system maintenance. • Provided on-site support to other departments. Tasks include LAN system maintenance on daily basis, operating systems and application software installation, computing environment configuration, software/hardware trouble shooting and upgrade, data backup and recovery, network system and desktop maintenance, etc. • Helped develop and maintain the website of the Department of Facilities. Technical environment: Windows NT/2000/XP, MS Office, Lotus Notes, Norton anti-virus software, PC anywhere, MS Access,

Developed a sophisticated database system for mail processing and billing purposes for department and greatly improved the department operation.