William Luis
AeroLeads people directory · profile

William Luis Email & Phone Number

Business Analyst, Process Improvement, Data Analyst, Excel VBA Development, Business Support, Reporting
Location: Mississauga, Ontario, Canada 3 work roles
LinkedIn matched
✓ Verified July 2026 2 data sources Profile completeness 71%

Contact Signals

LinkedIn Profile matched
3 free lookups remaining · No credit card
Role
Business Analyst, Process Improvement, Data Analyst, Excel VBA Development, Business Support, Reporting
Location
Mississauga, Ontario, Canada

Who is William Luis? Overview

A concise factual answer block for searchers comparing this professional profile.

Quick answer

William Luis is listed as Business Analyst, Process Improvement, Data Analyst, Excel VBA Development, Business Support, Reporting based in Mississauga, Ontario, Canada. AeroLeads shows a matched LinkedIn profile for William Luis.

William Luis previously worked as Analyst, Corporate Credit Services, Global Wholesale Operations at Scotiabank and Business Analyst, General Account Operations, Investment Division at Manulife Financial.

Profile bio

About William Luis

An accomplished professional with 20 years of Financial Investment experience in Investment Operations’ roles within Capital Markets, possessing excellent analytical and investigative skills, with a focus on Reconciliations and Settlements.Thorough and precise with demonstrated innovative skills in creating and deploying EUC solutions (macros) using advanced level of MS Excel and VBA. An Excel power user, with proven skills in composing complex and effective nested formulas using multiple high-level functions.A highly motivated and detail-oriented collaborator with persuasive communication, decision-making, problem solving and interpersonal skills, coupled with an aptitude to effectively and quickly adapt to changing environments and initiatives along with a proven ability to consistently produce a high level of accuracy.

Listed skills include Portfolio Management, Capital Markets, Account Reconciliation, Back Office, and 43 others.

3 roles

William Luis work experience

A career timeline built from the work history available for this profile.

Analyst, Corporate Credit Services, Global Wholesale Operations

Toronto, Ontario, Canada

Administers instructions by Agents on participations and Customers on direct deals including verification of limit available, accuracy of calculations, and disbursement/application of funds.Ensures that terms and conditions of authorizations and/or loan documentation are being adhered to including pricing, term, and amount.Communicates with contacts including Agent Banks to resolve issues on a timely basis. Recognizes and ensures that all exceptions to policies and procedures are brought to the attention of management for resolution when required.Develops a solid knowledge of ACBS setup and transactional recording to ensure accuracy of accounting and business line dissemination.Work on multiple projects to implement solutions to business problems. monitoring progress against planned objectives and securing consensus and co-operation from users and senior management. Assists Team Leader and Manager in various team-related tasks such as follow up with team members on status and resolution of exception items as well as special project-related work.Author, develop and build EUC tools (macros), management reporting tools; analytical reports, metrics and dashboards using advanced Excel functions and VBA. Improve current processes by re-engineering or create as needed.

Jan 2018 - Nov 2019

Business Analyst, General Account Operations, Investment Division

250 Bloor Street East Toronto On M4W 1E5

Author, develop and build EUC tools (macros) using advanced Excel functions and VBA skills for multiple business functions, thereby effectively reducing/eliminating manual reconciliation time/work effort. Creation of these tools saved the reconciliation area more than 20 man hours a day.Using advanced Excel functions with VBA, analyze, manipulate and transform large, disparate, and system-incompatible data sets from counterparties into readable data for feed into the reconciliation engine.Ensure data completeness and accuracy. Identify and document ambiguities in data and arrive at resolution.Work with business partners in automation, production and delivery of periodic reports (daily, weekly, monthly, quarterly, semi-annual) to various teams and stakeholders. Ad hoc customized reports as requiredInteract with key stakeholders within multiple business functions to verify data delivered to the repositories. Work with business partners to identify opportunities for continuous improvement of internal business processes. Recommend changes for improvements and continuously provide updated solutions to key business processes, analytical reports, metrics and dashboards. Using advanced techniques, create graphic reports using pivot tables and charts using worksheet data, external data sources, multiple consolidation data and other pivot tables. Document changes and new processes and maintain business procedures to ensure compliance with audit and SOX/MAR. Adhere to documentation and controls to ensure no deficiencies in day-to-day operations.Support and aid in the implementation of systems and other enhancement projects with high level functional testing of applications and UAT to ensure smooth transition.Communicate with counter parties to resolve escalated incidents; FTP file delivery, Settlement issues; Trade, Cash and Holdings’ breaks.Research, analyze and map security identifiers (CUSIP, ISIN, SEDOL) across systems. Maintain cross-referencing/mapping tables.

Aug 2011 - Oct 2017

Assistant Vice President, Operations & It (Progressive Roles)

Kipco Asset Management Co. K.S.C. Closed

Al-Shaheed Tower Khalid Bin Waleed Street Sharq, Kuwait

Manage all aspects of back office operations; mainly responsible for the accurate, timely and complete trade captures and settlements of all capital market instruments bank using SWIFT and online banking portals.Author, develop and build EUC tools (macros) using advanced Excel functions and VBA, thereby effectively reducing/eliminating manual reconciliation time/work effort. Prepare end user guides and training materials.Design, develop and implement management reporting tools; analytical reports, metrics and dashboards.Review and analyze daily cash flows and large deal warnings. Communicate to PMs and compile necessary trade lists taking into account PM instructions, fund restrictions, client requirements and current cash levels.Coordinate trading positions with traders to analyse and measure risk exposures against compliance guidelines. Advise on risk exposures and be involved with trading, research, and portfolio management to mitigate risks.Review outstanding corporate actions and ensure timely response from Portfolio Managers. Track corporate actions and coordinate processes with direct reports in the collection of dividends and distribution.Supervise the consolidation of numerous bank, prime brokers and custodian accounts and prepare periodic reports such as cash flow, fees, dividend and interest earnings and expensesDirect and oversee various activities related to fund administration including calculation of the Net Asset Value, NAV Reporting, payments of funds’ expenses, trade settlement, reconciliation of daily and monthly broker statements and maintenance of funds’ books and records.Ensure completion of EoD processes including closing of daily tasks and reconciliation checks

Feb 1998 - Jul 2010
FAQ

Frequently asked questions about William Luis

Quick answers generated from the profile data available on this page.

What is William Luis's role at their current company?

William Luis is listed as Business Analyst, Process Improvement, Data Analyst, Excel VBA Development, Business Support, Reporting.

Where is William Luis based?

William Luis is based in Mississauga, Ontario, Canada.

What companies has William Luis worked for?

William Luis has worked for Scotiabank, Manulife Financial, and Kipco Asset Management Co. K.S.C. Closed.

How can I contact William Luis?

You can use AeroLeads to view verified contact signals for William Luis, including work email, phone, and LinkedIn data when available.

What skills is William Luis known for?

William Luis is listed with skills including Portfolio Management, Capital Markets, Account Reconciliation, Back Office, Settlement, Investments, Corporate Finance, and Management.

Find 750M verified contacts

Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.

People with similar names

Check these profiles if this is not the William Luis you were looking for.

View similar profiles