Resume

Sign in

Data Analyst

Location:
Toronto, ON, Canada
Posted:
November 05, 2019

Contact this candidate

Resume:

PAUL FREDRICK ELIE

*** ******* ********, ***********, ** L4A 7G4 H: 905-***-**** adarja@r.postjobfree.com

Summary

9+ years of progressive Business Analyst and Business Process Re-engineering experience leading requirements and discovery sessions. This includes creating business and technology documentation to reengineer and enhanced financial and banking applications, such as developing/creating BPMN documents, technical requirements documents, business cases, use cases, cost benefits analysis, risk analysis, gap analysis, process diagrams, workflow and functional specifications documents.

Over 12 years of successful QA and UAT testing experience that includes, software development and application testing, test cases development and assessment; also writing and executing test scripts. In addition to 5+years of project management experiences.

Experience in developing requirements using different business analysis tools and methodology, including Agile, CASE tools, OO, UML, RUP and traditional waterfall methodology. Effective trainer/teacher in corporate settings for over 12 years, creating user training material

Education/Training/Certifications

Brock University, St. Catherine’s (1982), Canada

B.Sc. Computer Science

B.A Business Administration

Other Professional Activities: RIA / CMA Level 2/3, PMI- Member June 2004

Work Experience

Employment Gap: - Took leave of absent to attend to Personal business – part time 2018 – Present.

CIBC AML & Sanctions Sr. Analyst Sept. – Nov. 2018

Undertake investigative analysis with stakeholders to ensure monitoring, compliance and certification with regards to transactions monitoring and filtering required by DFS Regulations Part 504; this required completing the following deliverables:

Involved in enhancing and documenting the AML governance framework for monitoring and filtering program for PEPs.

Review and evaluate policies, procedures, processes and reporting required to support the established framework.

Confirmation of roles and responsibilities and oversight required to effectively support this AML initiative.

Analyze and document the updated CIF and base system transactions files used by the Navigant application used to support OFAC and PEPs filtering.

Review, analyze and document SWIFT transactions/ interfaces and feeds required as inputs to Navigant monitoring and filtering process.

Update Navigant rules engine.

Royal Bank Senior Business Analyst Jan 2018 –

•Involved in developing and implementing new international business model for third party suppliers risk compliance and regulatory governance. Elicited and document business requirements based on international regulatory requirements within an agile environment.

Identify and define to business processes (flow/swim lane diagrams), workflows and data flows required to sustain the third-party business model based on the existing bank risk model. Identify and implement on-boarding process and standards for third-party engagements /relationships based on KYC, due diligence and risk assessments.

Engaged data Stewarts and data owners in defining business rules for inventory definition and extraction. Involved in vetting and defining data elements required for regulatory and management reporting for new consolidated database: Developed and implemented new complex mappings. Identify transformations rules for moving data across platforms into the new data warehouse

Identify and extract existing security and access rights business rules and integrated them within Data Governance Framework model. Assisted in developing Current State Assessment and Risk scoring.

Involved in integrating and adapting other regulatory requirements for third-party relationships within the new third-party risk framework and processes. Including IROC, Dodd-Frank, AML and KYC regulations.

Scotiabank, Toronto, ON. (GBM) Compliance: - Sr. Analyst. August 2016 – Sept 2017

Involved in automation of Institutional and wholesale banking Personal trading and monitoring processes through the implementation of the SunGard investment/trading compliance system using Agile SDLC model. Allowing for the implementation of more effective controls to monitor compliance by employees, investment Advisers and Broker’s within Global Banking and Markets (GBM).

Participated in several sprints and discovery session to facilitate the elicitation and vetting of business needs and requirements. Involved in defining and implementing changes to business flow/swim lane diagrams, workflows and data flows.

Involved in IST & UAT for these “Sprint” enhancements and releases. Developed and executed testing strategy, testing plan and test cases for each release. Undertake investigative analysis to identify impacts on AML and Dodd- frank regulations and compliance.

Used SDLC, JIRA,MS Office tools (Access, Excel, Word, and Power Point) and Visio in project documentation and acceptance testing verification

M& T Bank Enterprise Data Office, Buffalo, NY Sr. Analyst. Sept 2015 –August 2016

Investigative review of current state to future state process assessment to rectify data gaps and assist in the mapping of products data been transfer from acquired Hudson City Bancorp to M&T Bank Corporation.

Define data extract plan, and the related conversion process, defining data requirements, and other activities for data conversion of Hudson City Bancorp to M&T Bank Corporation data warehoused. Involved in defining the source to target data mappings, business rules and data definitions. Responsible for defining the functional requirement documents for source to target interface

Eliciting and capture functional requirements for enhancements to CCAR Models and Schedules, including FR_Y-14A, FR_Y-14M, FR Y-14Q schedules, required for comprehensive Capital Analysis and review reporting to federal regulators.

Responsible for executing manual and automated processes for the validation and reconciliation of accounts balances and portfolios positions required in generating reporting for FR Y-14M FR-Y9C schedules and stress reporting to Federal Reserve department. Used SQL to query tables and validate schedules.

Involved investigating and fixing production issues. Involved in SDLC, UAT validation and testing of functional enhancements. Environment Teradata warehouse, ETL, and SQL script. Used excel and query tools for reporting and data validation. Developed and write SQL for ETL processes.

Tech Mahindra / Scotia Bank Toronto, ON Business Consultant CRM March 2014 – July 2015

Eliciting and capture business requirements for several major enhancements to Scotia’s CRM application.

Involved in defining and implementing changes to business processes and data workflows diagrams; this also included the creation and modifications of CRM screens and reports, building diagrams and screens mock-up and wireframe specifications.

Responsible for UAT, including the developing testing strategy, testing plan and test cases. Used Jira in the execution and monitoring of UAT test cases and results.

This deliverable also required rewriting the business system documentation for entire CRM application, including process flows and work flow document using the Wiki tool set.

Deliver enhanced Collections & Recovery control reporting aligned with product based.

HSBC Buffalo, NY: Sr. Business Analyst April 2013 – Jan 2014

Responsible for investigating, analyzing, and documenting business requirements, processes and functions for an AML, fraud and anti -terrorist regulatory monitoring system. This included capturing workflows, process documentation, dealing with logic problems and validating functional execution of system.

Created business and technical documentation enhanced AML/ Fraud application through dialogue with users, system investigations and the usage of business and system tools, including defining and modeling users profile and access rights. Provided direct support to AML investigators in weekly fine tuning of KYC and suspicious activity reporting, using watch lists screening, system parameters and selection criteria’s. Involved in the complete SDLC for this project.

Providing support to HSBC global compliance application in over 58 countries, by administering and implementing compliance monitoring solutions. Involved in implementing new application features for money laundering, including enhanced onboarding processes/ functionality for KYC/AML (for clients using Correspondent Bank, SWFT and Credit Card products/services).

Royal Bank, Toronto, ON Sr. Business System Analyst Aug 2011 – April 2012

Responsible for eliciting and documenting business requirement (BRD) and translating requirements and creating SRS documentation for an auto-purge system in the RBC Data warehouse, across data marts.

Engaged data Stewarts and data owners in defining business rules for automating of the warehouses purge.

Responsible for developing and executing QA test plan & strategy. Responsible for executing UAT and PIV

Responsible for confirmation and validation of business and functional requirements to implement a data warehouse to process and support retail banking applications, including deposits, savings, line of credit cards and other personal banking products, for RBC (USA) no-storefront banking environment. Involve in defining changes for AML and KYC in setting up the new back office banking environment

Developed and implemented complex mappings transformations rules for moving data from third part database to a new data warehouse. Assist data modelers in translating business rules/requirements in developing conceptual /logical dimensional model and in normalizing model, including data mapping. Developed and write SQL to query tables/ views and validate data. Involved in SDLC, Teradata warehouse, ETL, and SQL script. Used excel and query tools for reporting and data validation

Manulife & John Hancock, Toronto, ON. Sr. Business Analyst AML & Regulations Apr 2011 – June 2011

Responsible for analyzing and eliciting legal and regulatory requirements (BRD) for a new Mutual Fund/ 401k program. Including capturing business processes, workflows and systems interfaces.

Support the legal department in identifying and implementing new business entities and relationships to be established in launching new product. Identifying and documenting legal implication across all 50 states.

Including ensuring legal, compliance and regulatory procedures, contracts, and standards are identified and implemented. Involved with investigative analysis of issues and problems relate to implementing processes and requirements across project work streams. Responsible for reviewing, analyzing and documenting databases and platforms required to support legal and regulatory reporting required for this release, including KYC, AML and Basel II reporting requirements.

CAASCO Corp: Toronto, ON Senior Business Analyst E-Business. Oct 2008– Mar 2011

Developed and implemented major enhancements to e-business applications using agile project methodology, in building a new E-business Model. Eliciting and documenting business and functional requirements, in-addition translated business requirements into a system specification (SRS) documents.

Lead detail requirement phase identifying, tracking, escalating and/or resolving business systems issues. This also included defining and implementing a new security and access rights model for the online systems, with single sign-on features.

Project managed the implementation of a customized Monster.com HR package for HR department.

Involved in several discovery sessions and sprints defining business requirements for several major e-business projects, including several membership price changes, implemented PCI Data Security Standard across the company, outsourcing the online e-mailing process and several software packages. Provided 24 hours support for online web commerce portal

Responsible for investigation, analysis and documentation of use cases, business requirements and processes. Also Involved in capturing source to target data mappings, business rules and data definitions

Collaborated with IT in developing a logical & software architecture for e-Business & Corporate marketing department, using XML, Java C++, Java, SQL Server and RDBMS web portals and client server technology. Used lean methodology in solution designs and developing prototypes for illustrating system workflows.

Used JIRA and Agile SDLC model to implement projects releases. Provided QA and UAT testing of for production enhancement or upgrades.

Traders Corp: . Sr. Process Analyst - BPR (Change Management.) Mar. 2008- Sept 2008

Re-structuring and streamline of internal business processes. Responsible for reviewing and analyzing the Business Process Model and implementing require enhancements.

Analyze and document “As Is” process flows for main business areas through workshop and client interviews in each Canadian provincial office, using SIPOC and IDEF3 framework. Replaced the “As Is” model with parent company generic “To Be” process Flow Model - in areas Finance, Sales, Marketing and Production.

Conduct workshop with stakeholders and business unit representatives to clarify issues, confirm business processes, validate analysis results, and to obtain approval/signoff on pertinent documentation. Collaborated with IT in developing new logical & software architecture, investigating and define impact analysis for new infrastructure solutions within the Product design department - using SIPOC Diagram

CIBC: Toronto, ON. Senior Business Analyst – Retail Banking July 2007 – January 2008

Provided investigation, analysis, review, and documentation of business and functional requirements (BRD) for the development and conversion of the legacy Customer Information System into new state of the art portal solutions, using RADS, JAD’s, workshops and end-users interviews to design GUI interface and workflow.

Develop enhancement to the Customer Account information creation and maintenance process across all product lines. Validate data mapping and data validation required for the migration of the application to the new e-CIF system. Developed, enhanced and managed new/current business artifacts, including Used Cases, storyboard and wire frames, process flows, work flows, objects interaction diagrams required for the new Business Model using Rose, UML, XML and object orient tools. Support UAT testing of application.

Bank of Canada (OSFI) Toronto, ON Sr. Business Analyst July 2006 – Apr 2007

Provide requirement management (BRD & SRS) for BASEL II program at the Bank of Canada, OSFI.

Involved in the development and confirmation of business rules for standardized Credit Risk in the Canadian financial market place. Liaison with financial institution in implementing OSFI business rules pertaining to Minimum Capital.

Lead detail requirement identification phase, including tracking, escalating and/or resolving business systems issues and interrogating and analyzing bank’s Corporate Loans exposures. Involved in review and assessment financial institutions risk rating models. Involved in the complete SDLC for this project, use SQL to extract data program queries.

Provide first level support to major Canadian Banks seeking clarification or changes to Basel II requirements and data submission/extraction. Provide support to internal and external users for return filed & generated reports. Support internal and external users in testing of all functionality in BASEL II regulatory program.

Developed reporting for monitoring and identifying liquidity risk amongst major banks. Used SQL in analyzing the data ported from the banks legacy system to OSFI data warehouse and mainframe environment. Involved in development of UAT testing and strategy. Testing and evaluating Basel II regulatory reporting identifying Trends and drifts in financial organization product classification and portfolios. Operating Platform: Teradata warehouse Crystal reporting, impromptu, Erwin on an ORACLE, UNIX & IBM

TD Wealth Management, Toronto, ON Senior Business Analyst July 2005 – June 2006

Lead workshops & JAD sessions in capturing business processes and requirements documents (BRD).

Facilitated functional requirements JAD sessions to identify enhancements and upgrades to Fixed Income. Led detail requirement phase identifying, tracking, escalating and/or resolving business systems issues. Including enhancements to business processes. Investigate and capture requirement to increase connectivity, product offering and type of trades from TD Waterhouse, discount brokerage, to the trade desk.

Undertook an investigative analysis and review of the fixed income products streams, including GICs (Mutual Funds, TFSA, RSPs and RIFs) and other TD Waterhouse investment products and services. Used root cause analysis workshop with end-users to identify solutions and enhancements to the applications.

• Project managed the Fixed Income ‘Options’ upgrade project, including setting timelines and milestones, interacting with vendor and business users; reporting on project status to business unit and manager. Operating platform: Use Cases, UML, Java script, COBOL, SQL, RDBMS (Oracle).

CIBC Cards Products, North York, ON Business Process Analyst April – July 2005

• Collaborated with IT in the development and implementation of major enhancement to the Credit Card application, real time online processes using RUP. Developed business and functional specifications of the Credit Card application for converting the reporting functions to a self-service business reporting model, using JAD’s, workshops and end-users interviews.

• Involved in reviewing and enhancing new and current used cases, work flows, objects interaction diagrams define new reporting Process. Collaborated with stakeholders to define process flow, work flow and business rules required in building and creating a prototype for reports generation Model. Also enhancing the process related to customers overdrawn limits and unresolved charges prior to those accounts charging off. Focusing on recovering money for the bank and helping customers make payment arrangements.

• Operating platform: UML, Java, J2EE, C++, Rational Rose, SQL, RDBMS DB2, IMS, Cobol 2, GDF

IBM Canada Ontario, Canada. Senior Business Analyst August 2004- May 2005

Lead requirements identification and documenting sessions, including tracking, escalating and/or resolving business systems issues. Collaborated with IT in developing logical & software architecture for new infrastructure solution for Sales department. Also, creation of a business case to gain funding.

Performed the functional and business analysis for enhancement to the Sales business Model for IBM worldwide. Required detailing business processes and requirements (BRD).

Redesign business functions to integrate with new data sources, database, definition of new business objects; Involved in data base design. Involved in defining the source to target data mappings, business rules and data definitions. Responsible for defining the key identifiers for each mapping/interface.

Responsible for defining the functional requirement documents for each source to target interface.

Used Requisite pro to baseline and manage business requirements.

TD Securities, Basel II Toronto, ON. Senior Analyst Feb 2004 – July 2004

is required for extracting data to upgrade the (Credit) Risk Corporate data warehouse. Validate data and confirm data to Basel II requirements/ specifications, using workshops and client one-on-one interview to determine business requirements, data flow and functional specifications.

Analysis of the accounting details of investments transactions, bonds, stocks, futures options etc., confirmation of origination and destination of transactions, also the data flow, process flow affecting the update and maintenance, of the Corporate Data warehouse and Corporate GL for over 16 Capital Market applications including online brokerage transactions.

Confirm and reconcile for accuracy and completeness the daily posting of end-of day “positions” to the bank’s GL and the corporate data warehouse for Corporate Loan, Equities, repos, FX and other Capital Markets products. Validate and confirm business requirement for enhancing and upgrading the FX application.

Identify gaps and risk for each Capital Market application, in their ability to provided mandatory BASEL II reporting and data export to OSFI. Used excel tables to capture and validate data extracts.

Testing, validation and confirmation of data contents of transaction files or tables and the data mapping and extraction process to the Data Warehouse, validating that the daily/monthly/ yearly criteria of Basel II reporting guidelines.

American Express, Projects Coordinator, Senior Business Analyst Aug 2003 – Dec 2003

Analyze and research and develop solutions for enhancing performance to critical online business transactions, for the card payment system. Evaluate and rebuild each transaction profile base on access level, access rights and access privileges. Support enhancement to card payment application.

Review, analyze and generate analysis and project reports on all major IT and Non- It projects to management.

Developed and documented functional and business specifications for the centralization of the Imaging process for Canada. Relocation of repository from Amex Canada to Phoenix USA. Operating Platform: RDBMS (Oracle/Sybase mainframe environment)

Bank of Montreal, Toronto, ON. Senior Business Analyst Feb 2002 – Aug 2003

Performed business and functional analysis for the creation of a reconciliation and validation system for Capital Market applications against the corporate General Ledger (Phase II). These processes include reconciliation of all application GL accounts feeds (such as equities, loans etc.) against /with the corporate GL. Identifying and reporting discrepancies or jumps in positions.

Facilitated workshops and JAD sessions to develop process flows, data flows, business requirement and functional specification for integrating several Capital Market applications into the new Reconciliation and validation Model. Developed new process to escalate reconciliation of variances.

Led initial current state to future state process assessment to identify business as usual process owners, IT systems, and operation location from end-to-end investment trading.

Developed functional specifications and system design with end-user & IT, proving regular reporting to project team. Develop testing strategy and testing matrices with test team. Define logical data model/schema to the Internet /client server base: Operating Platform: Crystal reporting, impromptu, C+ Java Paradox and Erwin on an ORACLE, UNIX & IBM

Ministry of Finance, Oshawa, ON. Sr. Business System Analyst March – Dec. 2001

Lead project team in gathering functional and business requirements, designing and developing of an Internet / intranet-based revenue collection application, to support electricity deregulation in Ontario.

Facilitated workshops and JAD session in designing and constructing business processes and data flows and documenting detail business requirements

Manage and control system development, functional and system specifications (SRS), data architecture and system design for the application. Create business prototype and functional requirements for application, based on information gathering sessions with clients and technical team members

Managed and directed the quality assurance team in the end- to- end testing of the application. Operating Platform: Erwin, Pro Metal, SQL, DB2 UDB, Visual Age Java and IBM Web Sphere, Sun Micro mainframe system RS6000 Unix platform.

Bank of Montreal, Toronto, ON. Senior Business Analyst (BPR) Aug 2000 – Feb 2001

Performed business and functional analysis for the creation of a reconciliation and validation system for Investment Banking applications with the corporate General Ledger (Phase I). This included the following functions; develop a transaction profile for individual trade transaction, including discount brokerage transaction process thru Investor Line. Ensure daily validation of posting to Trail balance for all capital market applications, Wall Street, Summit, ADP etc. This included building transactions profile flows for each investment product, such as, FX currency and options from Blotters of Wall Street to the Bank GL.



Contact this candidate