PAUL FREDRICK ELIE

*** ******* ********, ***********, ** L4A 7G4 H: 607-***-**** ad36ll@r.postjobfree.com

SUMMARY

14+ years of progressive Business Analyst, BSA and Business Process Re-engineering experience leading requirements and discovery sessions. This includes creating business and technology documentation to reengineer and enhanced financial applications; including business requirements, BPMN documentation, business cases, use cases, cost benefits analysis, risk analysis, gap analysis, process diagrams, workflow, data modeling and functional specifications documents.

Over 10 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, Canada

B.Sc. Computer Science

B.A Business Administration

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

Work Experience

Bank Of Montreal (DnA)-: TSBI/BSA Analyst. Remote-: Mar. Dec. 2022.

Elicited and documented functional requirements. Developed and implement the design specifications, by re-engineering the existing systems functions.

Captured data requirements, and other activities for data conversion/ reengineering HR workday reporting in the data warehoused.

Involved in defining the source to target data mappings, business rules and data definitions. Created new table, PDMs and DMM using power designer.

Involved in UAT validation and testing. Environment supported: Netezza & Hadoop tables, used SQL, script excel, SQL and XML for data interrogation.

Elite Class Development: Sr. Analyst Jan 2019- Oct 2021

Involved in the mapping of products data to be capture in transfer from acquired Iripana Dev. Corp. 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 processes and data workflows.

Assist in development and setup of the new US corporation div.

Involved in IST & UAT for these “Sprint” enhancements and releases.

CIBC Sr. Analyst AML & Sanctions : Sept. - Nov 2018

Elicited and captured functional requirements to implement AML DFS Part 504 regulatory requirements. 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. Update Navigant rules engine. Review and evaluate policies, procedures, processes and reporting required to support the established framework.

Confirmation of roles/responsibilities and oversight required to effectively support AML initiatives.

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

Royal Bank: - Senior Business Analyst Dec 2017 – July 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 processes required to sustain the third-party business model based on the existing bank risk model. Also, identify and implement on-boarding process and standards for third-party engagements /relationships based on KYC, due diligence and risk assessments.

Engaged data owners in defining business rules for inventory definition and extraction. Identify and extract existing security and access rights business rules and integrated them within Data Governance Framework model. Develop data migration process flows and prepare documentation describing the data verification and conversion process and approach.

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. Used MS Office tools (Access, Excel, Word, and Power Point) and Visio in project documentation

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

Involved in automation of Institutional and wholesale banking Personal trading, surveillance and monitoring processes through the implementation of the SunGard investment/trading compliance system. This provide for more effective control and monitoring of 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 processes and data workflows.

Involved in IST & UAT for these “Sprint” enhancements and releases. Developed and executed testing strategy, testing plan and test cases for each release.

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

M& T Bank Enterprise Data Office, Sr. Analyst. Buffalo, 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 Corp.

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 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 (Stress Model) reporting to Federal Reserve department.

Involved investigating and fixing production issues. Involved in UAT validation and testing of functional enhancements, environment ETL, and SQL script. Used excel, SQL and query tools for reporting & data.

Tech Mahindra / Scotia Bank: Business CRM Consultant March 2014 – July 2015

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

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.

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

HSBC Buffalo, New York: - 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 and system parameters.

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 Canada: - Senior 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/ data marts.

Engaged data Stewarts and data owners in defining business rules for automating of the data 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 an 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 modellers in translating business rules/requirements in developing conceptual /logical dimensional model and in normalizing model, including data mapping.

Used excel, SQL and query tools for data mapping, reporting and data validation.

Manulife: Sr. Business Analyst- Mutual Funds /401K April 2011 – June 2011

Responsible for analyzing and eliciting legal and regulatory requirements (BRD) for a new US wide 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 for all 50 states. Responsible for 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 supporting legal and regulatory reporting required for this release, including KYC, AML and Basel II reporting requirements.

CAASCO Corp: - 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 Dept.

Involved in several sprints defining business requirements for several major e-business projects, including several membership prices 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. Used lean methodology in solution designs and developing prototypes for illustrating system workflows.

Provided QA and UAT testing of for major production enhancement or upgrades. Implemented a new testing strategy. Created a new test bed, using Power Designer and SPIRA, to baseline and managed business requirements. Involved in the conversion of the online applications from Java script to .Net

Traders Corp: - Sr. Process Analyst - BPR (Change Management.) Mar- 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: Senior Business Analyst – Retail banking July 2007 -Jan 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): - Sr. Business Analyst July 2006 – Apr 2007

Provide requirement management (BRD & SRS) for BASEL II program at OSFI.

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

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.

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. 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. Used SQL and query tools for reporting and data validation.

TD Wealth Management: - Senior Business Analyst July 2005 – June 2006

Lead workshops & JAD sessions in capturing business processes and requirements (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 enhancements.

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 (DB2 & Oracle).

Contact this candidate