Kamal Farran Email & Phone Number

Toronto, Ontario, Canada

• Coordinate with organizational teams to onboard and integrate data, intake forms and projects into Salesforce.
• Optimize data collection processes to ensure completeness, accuracy and reliability.
• Analyze data to extract valuable insights that can inform project teams, based on mission objectives and goals.

Toronto, Ontario, Canada

• Received a 2023 Q3 STAR Award for IT Operation Support contributions to Legal, Finance, and Regulatory Reporting applications.
• Investigated gaps in large datasets, revealing discrepancies caused by application limitations. Analyzed user interactions to identify and resolve issues, ensuring system stability and data accuracy.
• Addressed incomplete or ambiguous data by verifying dataset integrity, employing SQL scripts and data imputation. Consulted domain experts for thorough resolution and accuracy assurance.
• Provided L3 Support to Finance IT applications, reviewing server and application logs across Windows and Unix servers, analyzing data from SQL, Oracle, and Hive (HDFS) databases, and coordinating with both technical.
• Liaised with internal and external audit teams, to ensure adherence to data governance and access management regulations.

Toronto, Ontario, Canada

• Achieved an over 85% reduction in alerts generated by an ETL batch application through analysis of historical datasets, batch logs and alert patterns to devise a streamlined alerts schedule, and through collaborative.
• Received a 2019 Q3 Achievers Award for successfully suggesting an out-of-the-box solution to an urgent high-risk incident.
• Ensured data integrity by comparing with historical datasets, resolving discrepancies. Utilized SQL tools for analysis. Investigated data sources to address root causes of discrepancies, ensuring accuracy and.
• Provided Operations Support to a client-facing payments application, ensuring continuous operations, and coordinating with internal and external stakeholders to resolve operational, infrastructure or code-related.

Beirut District, Lebanon

• Acted as a direct liaison to executive stakeholders and compliance end-users at banking client sites, presented demos, gathered and documented Business requirements and translated them into technical specifications.
• Prioritized tasks by urgency and impact, ensuring critical deadlines are met. Broke down tasks, set realistic timelines, and communicated progress. Successfully managed multiple projects concurrently, meeting all.
• Mentored trainees through hands-on guidance and theoretical explanations during onboarding training and shadowing. Enhanced team performance and individual growth by fostering a supportive learning environment.

Beirut District, Lebanon

• Developed and tested AML, FATCA investigation and reporting, and risk-based analysis solutions. Identified data sources, and used statistical calculations, to process raw client, accounts, and transaction data to.
• Played a key role in doubling the company's client base through successful implementation of a FATCA investigation and reporting module, filling a market gap during the early years of FATCA rollout.
• Simplified complex data concepts for non-technical audiences using relatable analogies and clear language, emphasizing practical applications. Communicated with appropriate reports, graphs, and dashboards, converting.
• Modelled, created and maintained database schemas on IBM Informix, SQL and Oracle databases. Developed dynamic ETL processes to transform and load multisource data into a unified system format.

Beirut District, Lebanon

• Parametrized applications to work with both Informix and SQL servers, using Sybase PowerBuilder.
• Assisted in the development of banking applications, including a standalone web-based APR calculator using JavaScript and C#.NET.
• Assisted in the development of insurance and re-insurance programs covering policy/endorsement definition and reporting, and claims management.

Certificate, Data Analytics And Visualization

Bachelor'S Degree, Computer Engineering