Faris Ally Email & Phone Number

Mississauga, Ontario, Canada

• Migrates data of insurance agencies from a variety of systems into a format compatible with the company's flagship product • Developed advanced SQL code to manipulate and analyze large datasets, enhancing the precision and quality of our data migrations• Completed over 10 database migrations for one of the company’s largest clients, accommodating all custom requests and ensuring on-time delivery• Review and modify our master ETL code to troubleshoot issues and identify opportunities for design improvement • Executed comprehensive testing of the ETL process migration onto Google Cloud Platform (GCP), ensuring data migrates as expected and identifying any issues• Communicate effectively with data leads and project managers to ensure that all due dates are met and identify any roadblocks ahead of time

Toronto, Ontario, Canada

• Responsible for designing reports using MSSQL Server and Excel which were used by the VPs of the AML department on a daily basis• Automated the process for selecting quality control samples from our database resulting in ongoing savings in time and money for the company• Responsible for maintaining accurate data to populate several reports which were seen by senior management including the Chief Risk Officer of CIBC

Mississauga, Ontario, Canada

• Tested applications thoroughly to identify any defects or issues, and raised these defects using JIRA/Confluence with the appropriate workers or teams• Worked on multiple different projects within our Agile team and assisted multiple team members with testing activities• Learned about accessibility testing and how to assure the best possible experience for people with disabilities