Project Data

Alexander Desousa

Mississauga - Toronto Canada

BUSINESS ANALYST- KPI - IMPLEMNTATION ANALYST

PROFILE AND WORKING ATITUDE

Highly motivated to achieve the objectives and always savings and cost

conscious.

Analytical, Systematic, solutions focused, Results-oriented, Aptitude for

numbers, Project and task Oriented.

Languages: Fluent in Spanish, and French and basic Italian and German

. Currently taking Project Management courses at University of Toronto

to obtain certificate

. 12 yrs +. Experience in Finance, Treasury, Taxation and Reporting

. 8 yrs +. Experience in KPI, Scorecard, Statistical matrix, cost

tracing, budget, forecast models.

. 7 yrs. Credit Risk Management and Collection.

. 8 yrs. experience in Financial Systems implementation.

. 8 yrs. experience in Business Systems Analysis, Business Analysis,

Process Analysis and Project Management

. 8 yrs. experience in Gathering Business requirements, JAD Sessions,

Documenting BRD, SRS & Process Models

. 12 yrs +. Experience in Finance, Treasury, Taxation and Reporting.

. 7+ yrs. experience in QA and Testing, in addition to Data Warehousing

(Basel related)

. Highly analytical, systematic, solutions focused, results-oriented and

have an aptitude for numbers

Methods & Processes: SLDC, UML, Process Mapping, Business Requirements

Gathering, Business Cases, PMLC Methods, Use Case

Regulatory Reporting: Basel III NCR Reports, BCAR and AML - LCTR (Data

Elements gathering)

Financial Analysis

& Accounting Functions: Budget creation and analysis (Planned to

Actual), Analysis and comparison of financial ratios,

Scorecard and KPI, Financial projections and project cost

estimations, Consolidated financial reporting. Accrual

Journal entries for month end closing.

Financial & Business

Applications: SharePoint, Excel (Macro & Advanced), MS Project, MS

PowerPoint, MS Visio, HTML, MS Dynamics CRM, Mercury

Quality Testing (HPQC), Poseidon for UML & Requisite Pro.

Business Intelligence Crystal Reports, Business Object XI, Web-Focus MRE,

OLAP, Congo's Power Play, Avaya Reports, Brio BI, MS

Reporting Services.

ERP Systems: SAP FI-CO, CD, ACCPAC Sage GL, PeopleSoft Financial.

Other Financial

Systems: Great Plains, MS Navision, Business Vision, ISM, New-Star (Real

Estate), QuickBooks, Oracle Financial, Moody's RiskAnalyst

and Moody's RiskOrigine.

Databases &

Data Warehouse: Sybase, Oracle, SQL Server 2005-2008 Data-marts, ETL

documentation and Advanced MS Access, VBA.

PROFESSIONAL EXPERIENCE

Q A and Business Analyst (Contract)

09/2014 - 03/2015

Scotiabank - Global Risk management

. Involved in the Project to implementation, and integration of a

Moody's Web-based CRM for Corporate Credits Risk assessment and

adjudication.

. Writing functional and regression test in HPQC for post implementation

of the Creditors Risk assessment and Loan adjudication.

. Interpreting the BRD and EDD (Business and Design Documents) to write

the test cases.

. Writing test cases for the implementation of web based CRM credit Risk

application from Moody's. (RiskAnalyst and RiskOrigins Application)

. Ensuring that Moody's Application meets the requirements of Volcker

Rules.

. Verifying and validating all aspects of Spreading and Grading features

of both Moody's risk assessment applications.

Financial Business Analyst & Business Intelligence (Contract)

05/2014 - 08/2014

Bank of Montreal

. Gathering technical requirement for the documentation of Technical

system document (TSD).

. Gathering the specific data set from different sources to meet the

requirement of requirements of Volcker Rules (Dodd-Frank), AML and

other trading fraudulent activities.

. Documentation of technical requirements on data element for AML

. Source to target Data Mapping and ERD Design for a data warehouse for

compliance officers to monitor and detect illegal transaction in

capital market and monitor illegals activities as required by AML

regulators, using SAP Power Designer 16.5

Financial Business Analyst (Contract)

1/2014 - 05/2014

RBC Global Finance

. Updating the BRDs's in coordination with the Change request with users

and PMO.

. Documenting change request to the Congo's - TM1 enterprise planning

for planning, budgeting and forecasting Application

. Documenting changes to the Hierarchies of the chart of accounts for

business units (Capital Market, Wealth Mgnt)

. Testing and reconciling financial statement balances between the new

systems TM1 to olds system INEA

. Reviewing the financial formulas for the KPI and Scorecard in Congo's

TM1

. Testing and compering the Balance sheet and profit and Loss in INEA to

TM1

. Verifying and validating of each TM1 cube to the BRD specifications

and raising of defects in HPQC

. Documentation of requirement gathering (BRD and SRS)

Financial Business Analyst (Contract)

06/2013 - 12/2013

Liberty International Underwriters

. The creation of a Billing and Age of receivables in MS Access

application for Treasury.

. Assisting the treasury department in setting up a paperless

reconciliation process in SharePoint

. Improving the process to upload electronic invoices to SAP

. Gathering and Documenting requirement gathering (BRD and SRS)

. I participated in the Business continuity plans and disaster recovery

plans (Sunguard)

. Documenting procedures on how to run monthly reports

. Working with treasury to improve the optimize the capabilities of the

payment system in AS/ 400

QA and Financial Business Analyst (Contract)

10/2012 - 06/2013

RBC Technology Group

. Drafted and defined the HST project scope of work and work estimate

before starting the HST implementation.

. Conducted testing on the Implementation of harmonized Sales tax (HST)

for the province of PEI In SAP

. Created a future state chart, and HST calculation model before

implementation

. Developed the "Tax Code mapping models" for the GL in SAP Accounts

payable.

. Preparation of Test cases for UAT in HPQC.

QA Lead and Business Analyst (Contract)

05/2012 - 10/2012

Scotiabank - Global Risk management

. Tracking all the issues in HPQC on the incoming data feed from

Latin American to the Basel Data Warehouse

. Translating and reconciling the issues in Latin America to those in

Toronto on a daily basis by conference calls.

. Created NRC report and reports and KPI for PD EDA and LDG with

Cognos

. Explaining the business and technical requirements to the Latin

American team.

. Generating a weekly progress report on issues solved for the PMO.

. Conduct analysis on the data to assure that is in compliance with

Basel II BCAR and NCR requirements set by OSFI

Intermediate Risk Business Analyst (Contract)

01/2012 - 04/2012

TD Bank - Operation Risk management

. Building a data dictionary in compliance with enterprise data

standards for data Governance

. Developing and documenting the standardization and data inventory

data Governance

. The reviewing the quality of the over all annual operational risk

for several business units

. Ensuring of the proper implementation of control activities

. Assessing the control activities and ensure the proper mitigation

of risk are in place

. Assisting in the formulation and definition of operational risks,

risk drivers and control activities to mitigate the risks.

. Making of a data inventory on critical values to which get input in

Opera Risk Database

Intermediate Business Analyst (Contract)

04/2011 - 12/2011

Scotiabank - Global Risk management

. Data mapping of international (Mexico) data feed to Scotia Basel

Data Warehouse structure.

. Creation and documentation data mapping for new data feeds to the

data warehouse to comply Basel III

. Documenting the gathered requirements for the Data Warehouse

enhancement for Basel III

. Documentation of Gap Analysis and following with relevant

stakeholders

. Documentation of business rules to comply with Basel II BCAR and

NCR requirements.

. Assessment of the current risk reports from the data warehouse for

improvement (Crystal Report)

Financial Business Analyst - Report Analyst (Contract)

10/2010 - 04/2011

Sun Life Insurance Finance-IT Group

. Updating the monthly budget versus actual expenditure for several

for several projects & initiatives

. Evaluating current reporting process and presenting a proposal for

report improvement

. Designing and developing a consolidates reporting system with

advanced functions in excel and Ms Access

. Created and documented the new data mapping to the GL for the

centralized budget report

. Documentation of the new implemented process for all users and data

providers.

. Documentation of requirement gathering (BRD and SRS)

Intermediate Financial Business Analyst (Contract)

04/2010 - 08/2010

RBC Technology Group

. Managed the Implementation of harmonized Sales tax; (the province of

BC, Ontario and Nova Scotia)

. Developed Tax code mapping models to the Chart of Account (GL) in SAP

AP

. Created a future state chart, and HST calculation model before

implementation

. Conducted intensives testing and quality control processes with HPQC.

Business Financial Analyst Project Costing Analyst (Contract)

12/2009 - 03/2010

CML Medical

. Reported on the project expenditure rate by several categories.(

Expenditure Burn Rate)

. Monitoring project expenditure (Capex) with variance analysis, KPI and

Matrix and report to the PMO

. Maintain a cost tracking system in a database for Project expenditures

on fixed assets

. Monitoring the whole RIS-PAC equipment acquisition process from

purchase to delivery (SCM)

. Conducting Gap analysis of current reporting for improvement in the

reporting system

SAP Implementation Business Analyst (Contract)

09/2008 - 12/2009

CapGemini (Inergi) - Hydro One

. Running several GL and Financial Report with Nvision of PeopleSoft

Financial

. Assuring of data has been properly transferred from SAP AP to

PeopleSoft GL

. Audit and investigating for potential discrepancies in the target data

stage tables of the Data warehouse and FDM (Financial Data Mart)

. Running Cognos report for the chart of accounts reconciliation

. Maintain the excel Macro for the automated reconciliation system and

MS Access Macros

. Developing and Customizing reports with SAP BI-BW Business Objects

. Migrating reports from Cognos to Business Object report(BO)

environment

. Creating user manuals and guideline for SAP (ECC 6.0) FI-CO and PS

users

. Testing several reports and chart of accounts in the FI GL after the

SAP implementation (SDLC & PMLC)

Report Financial Analyst (Contract)

06/2008 - 08/2008

SOBEYS

. Developing Retail Budget Models with Khalix (Financial Software model)

. Extracting Financial Data from SAP FICO

Financial Report Analyst (Contract)

01/2008 - 05/2008

Strat Petroleum

. Contacting and prospecting potential investors all over North America

. Making investment presentation to prospective investors

. Developing Financial Forecast Models and Business proposals

. Responsible for all accounting functions including journal entries,

accruals of revenue and expenses and financial statements preparation

Report Analyst (Business Object)

10/2007 - 12/2007

ADP Canada

. Designing and Developing KPI reports and Scorecard with Business

Object from a SQL Server DW

. Responsible for smooth transition of set of report in to the new Web

version of Business Object XI

. Documenting of process for reporting procedures as required

Business System Analyst - Microsoft dynamics CRM (Contract)

07/2007 -

9/2007

Threshold Financial Technologies

. Working in the implementation of Microsoft Dynamics CRM

. Developing KPI reports for a Call center with AVAYA systems

. Developing Report to monitor ABM (ATM) machines with SQL Server Report

Services

ACCPAC Project Implementation Analyst (Contract)

05/2007

- 06/2007

Econo Rack (Manufacturing Company)

. Updated the monthly project implementation costing of the with actual

cost from several vendors Invoices by different phases of the project;

adhering to PMLC and SDLC methodologies

. Participated in Planning, architectural design, testing plan and

implementation for ACCPAC deployment.

. In charge of Data Transformation and setting up the suppliers and

vendors and their opening balances from the legacy systems (Business

Vision for DOS) to the new ACCPAC Sage.

. Responsible for validation, and testing of data being transferred to

the new system (Batch Processing)

Financial Analyst (Business Object Development) (Contract)

12/2006 - 1/31/2007

AUTODESK, Inc. (An Architect (Autocad) and visual animation software

company)

. Designing Report from the data warehouse for Capex expenditure using

Business Object (BI Tool)

. Generating several report on Sales and cost of sales and generating

several reports on product analysis

. Data mapping to the GL profit center and cost center.

. Generating specific reports to monitor the performance and ROI of

sales and marketing efforts on several products

Business System Analyst (Contract)

07/2006 -11 /2006

RBC - BASEL II US and International Investments (Caribbean Market),

Toronto, ON

Achievement: The successful completion BAT Testing on time with the minimum

level of defects.

. Documentation of Test cases and Test steps for Credit Risk Data

Warehouse

. Running BAT Process and Queries for the successful implementation of

Basel Data Warehouse

. Running BAT with Mercury Quality Center Testing Software and updates

to Requisite Pro.

. Running queries to test the integrity of the ETL process before data

lands in Data Warehouse

. Data mapping and documentation from Source to target on several

Capital Market products (Swaps)

Business Analyst - (Contract)) Finance and Enterprise Technology Solution

12/2005 - 06/2006

TORONTO DOMINION BANK SECURITIES - FINANCE AND TECHNOLOGY DEPT, Toronto, ON

Achievement: The completion of documentation of business functional

requirement, concept proposal, projected financial statements, Activity

process flow, inter-face mock-up demo for three major projects such as a

tax recovery (GST-ITC) application, experience with PeopleSoft.

Working for TD Securities, assisting the Project Manager on three main

Projects, Sales Tax Recovery, Compliance Reporting and e-mail alert, all

the project are strictly followed by the PMO methodologies and standards

(including PMLC).

. Documented the BRD (SRS) for the IT solution with detailed financial

estimates on the over all cost of the project by category and project

phases in order to acquire the proper funding.

. In charge of data gathering the business requirements and designing an

IT solution (database) to streamline, automate and maximize the tax

recovery of sales tax credit (GST-ITC) for all departments.

. Business and Solution Modelling with the use of Process Flow charts

and USE Cases

. Provided process and interface solution to streamline the compliance

reporting system and the centralized Issue log for the compliance

department in accordance with SOX 404, and OSFI guidelines

Business Systems Analyst (CONTRACT) Credit and Risk Management Department -

Basel II 7/2005- 11/2005

CANADIAN IMPERIAL BANK OF COMMERCE (CIBC) Toronto, ON

Achievement: The completion of documentation for Reconciliation procedures

GL to the Credit Risk Data warehouse.

. In charge of data gathering from a data risk management warehousing to

reconcile the several financial products to GL Reconciliation of

Financial GL to the Credit Risk Data warehouse and Documentation of

reconciliation process

. Data mapping and documentation on asset securitization

. Documentation on Asset securitization (Categorization of assets

classes with level of risk exposures)

. Running Ad hoc queries using SQL (Toad and Oracle)

Business Report Analyst (Contract) - Operation, Sales and Marketing

Department 5/2003- 7/2005

HEWLETT PACKARD, Mississauga, ON

Achievement: The completion and presentations of a proposal (Business Case)

for the implementation and integration of two main data bases to increase

the accuracy of reporting and to increase the reporting timing process and

the successful integration of Sales and inventory reporting system.

. Wrote the Business Case with a Cost Benefit Analysis to streamline

the reporting process.

. Initiated, performed business analysis, and built the business case

(business and process modeling) to integrate HP and Compaq

Inventory data into a centralized Oracle database reducing report-

processing times.

. Project managed the centralization and migration of two databases

into one Oracle data warehouse.

. Provided finance, sales and marketing departments with customized

reports.

. Extracted and converted financial data into useable format from SAP

R/3 and Oracle using SQL, Toad for Oracle, Access, OLAP for SQL

Server (Analysis Service) and Excel pivot tables.

. Audited raw data and management reports ensuring adherence to

quality standards in the reporting process.

. Prepared reports on HP partners and its several distribution

channels

. Documentation of requirement gathering (BRD and SRS)

Additional Accounting Financial Experience (1990 to 2003)

Journal entries for month end closing, Intercompany reconciliation and Bank

reconciliation, Accounting System Implementation and creation of new Chart

of account and GL mapping, Preparing financial consolidations of several

companies, Tax Reporting, Financial Report Analyst with

Public works Canada Federal Government (Funding and Budget

department),Sport-Mate Manufacturing(Accounting),Lavalife (Accounting &

Treasury),Montero Manufacturing(Accounting),Imperial Travel

Agency(Accounting and Treasury),John Davis CA Firm (Accounting, Audit,

Reporting, Sys Implementations), Essex Capital(Accounting, Treasury

functions, IDA regulatory reporting on capital reserves ),

VerdiRock(Accounting, Budgeting, Tax Reporting, System

Implementation),Rogers(Reporting, Data Warehouse, CRM, KPI,

Scorecard),Direct Energy(Reporting Data Warehouse, CRM, KPI, Scorecard).

Teaching - March 1999 to Aug 1999

Teaching night classes on Microsoft Access database and Simply Accounting

at Alta Data Training Academy

Volunteer work - 2002 to 2005

Chairman of the Finance committee for La-Paz Co-op mainly in charge of the

approval and presentation of the annual budget. I worked with the auditors

at year- end. I developed and provided recommendations on internal control

and cost control processed. I chaired the monthly financial meetings. I

conducted in depth financial analysis. I monitored the actual versus budget

and provided recommendations on variance. I conducted and delegated

investigation on budget variances. I participated in the documentation of

procedures, risk management and internal controls to the Board of

Directors.

Membership

The Institute of Internal Auditors (IIA)

International Institute of Business Analysis (IIBS)

Association of Financial Professionals (AFP)

EDUCATION

Finance-Accounting-Audit

. Project Management certificate -- University of Toronto

(In Progress)

. FP&A Certification Program (In Progress) Association for

Financial Professionals (In Progress)

. Canadian Securities Course Certification - CSI-IDA

2005

. Economic Analysis Certificate - Ryerson University

2000

. Accounting Diploma - Seneca College

1996

.

Six Sigma - Process Improvement -Quality and Risk Assessment

. Lean SIX Sigma - Green Belt -- Sixth Dimension Learning

2013

. Business Analysis Certification (CBAP Preparation) IIBS

Institute 2010

. SIX Sigma - Green Belt Certification -- Quality Training.net

2010

. ISO 9001 Internal Audit certification by Quality Training.net

2009

. ERM Certification (SOX, CoBIT, COSO II and ISO 17799) - MLC

College 2007

. UML Methodologies Seneca College

2005

. Systems Analysis Diploma - Toronto School of Business

1997

MIS - Data Analysis - Data warehouse

. SAP CRM - ERP SysTEk

2013

. Business Object (SAP B)I Certificate - IIBS Institute

2012

. Data Warehouse and BI (Cognos & Crystal Report) Certificate -

High Tech Institute 2012

. SAS (Statistical Analysis Software - Data analysis - Metro

College 2011

. INFORMATICA-Power center 8-Toronto College

2011

. Crystal Report Design I - by SAP Education

2009

. Financial Management with SAP-FICO ERP Implementation - MLC

College 2008

. SQL Server 2000 Database Design certificate - High Tech

Institute 2008

. Cognos Powerplay - Toronto College

2005

. E-Commerce Certificate - NTG Software Training Institute

2003

. Oracle DBA Prep Certificate - NTG Software Training Institute

2002

. Visual Basic Certificate - SouthSoft

2001

. UNIX Sun Solaris - Xincon Technology School

1999

Contact this candidate