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