Professional Summary

Twenty years comprehensive experience in analyzing systems user and business requirements developing Business and Systems requirements Solution documents, BRD, SRS, technical, functional and non-functional specifications, risk and gap analysis, use cases, UML, data mapping, UI, data elements, data catalogue, data model, Business Process Map and flows, Activity diagram, ECM, test scripts, test plans, test cases, Business Process Engineering Modeling, standards and processes for the large development and maintenance Web Enterprise, Credit Cards, Wealth Management, Fixed Income, Derivatives, Online Banking and Mobile Payment financial projects.

Senior Business Analyst/Business Systems Analyst

• Expert in Facilitating JAD sessions and workshops Vendor management experience

• Expert in Waterfall and Agile methodologies Expert in using advanced SQL

• Led all aspects of SDLC Certified Java Developer (MCSD)

• Proficient in data mapping and data warehouse Expert in all levels of testing

• Excellent communication and interpersonal skills; interact well with Stakeholders.

• Excellent organizational, facilitation, problem solving, negotiation, and analytical skills.

• Result oriented; highly motivated with a passion for developing efficient systems.

• Proven track record in project management; adapts well to change.

Professional Experience:

Manulife Financial June 2015 – November 2015 – Advisor data migration to Salesforce.com

Roles: Senior Business Analyst

Project: - Call Centre Desktop Conversion – data mapping

• Performed data analysis on Advisor data.

• Analyzed advisor data and business requirements to perform data mapping from advisor data to Salesforce.com

• Set up meetings and JAD sessions with business and technology to discuss the problems and issues

• Set up business rules for Salesforce data

• Performed data mapping from advisor to Salesforce environment.

• Elicited systems requirements from JAD session and documented SRS for Advisor data migration.

• Performed SIT testing.

Royal Bank October 2014 – June 2015 (on Contract)

Roles: Senior Business Systems Analyst

Projects: Online Banking and Mobile applications: New Development Commercial Card end to end Transformation, web interfaces, Loyalty Reward Program with TS2 and TLP; Personal banking retail, Automation of Credit Card System with TSYS for Change Request, Lost and Stolen Card, Set up Auto Pay, Product Change and Add Authorized.

• Conducted JAD sessions, workshops, and one-to-one interviews to elicit systems requirements for Online banking Personal Credit and Commercial Cards.

• Performed initial analysis for the current state and designed current and future Business process Map by utilizing multiple sources and systems.

• Facilitated all aspects of Systems Development Life Cycle (SDLC) and PMLC

• Acted as a liaison between business, technology and third party vendors to find out solutions, addressed issues and resolved it on time.

• Managed to implement multiple projects on schedule and budget negotiating solutions and implementation date with the third party vendors.

• Translated Business Requirements into Systems Requirements Specifications using use cases, data mapping, data catalogue, generated User Interface document, business rules, and Enterprise Content Management (ECM) using data architecture design.

• Facilitated systems requirements meetings and walkthroughs to obtain sign-offs and performed estimation and risk assessment using agile, end to end and Iteration Methodologies.

• Analyzed the current process and documented future state by recommending for automation and designed Business Process Mapping Flow for improvement for Retail products.

• Documented test strategies and reviewed test cases. Performed BAT and SIT testing. Analyzed problems and issues and solved it on time.

Environment: UNIX, Windows, GUI, SQL, Client Server, UML, Use Cases, XML, XSL, Visio, Java, Oracle, SharePoint, Word, Excel, Web Services and Power Point

CIBC April 1, 2013 – July 31, 2014 (On contract)

Roles: Senior Business Analyst – Card Product systems with TSYS, Debit and credit cards, collections, risk management, new Credit Card development, Product change, Chip Card Activation using ABM and POS, Windows 7 upgrade, Market risk, data management, Migration of call Centre applications and Mobile Payment applications

• Facilitated all aspect of SDLC and PMLC from initial of the project.

• Elicited business and systems requirements by facilitating workshops, JAD sessions with business partners, SME, stakeholders and technology for Mobile Phone Payment requirements, downloading applications and messages by working with vendors.

• Documented Systems requirements (SRD) using word.

• Performed BAT and SIT testing and analyzed issues and risks documented and solved it on time.

• Performed gap analysis, documented Business Requirements, business context diagram and Business Process Mapping.

• Translated business requirements into system Requirements solutions generated use cases, Data Elements, Data Mapping, from source (Mainframe copybook) to target (UNIX) Messages, UI document, Business Rules and Data Model and documented systems requirements document

• Utilized multiple sources and systems to performed User Interface documents and mapping.

• Performed data analysis on for new Card Product, switching products and reissuing

• Coordinated and performed multi projects activities and completed on time.

Environment: UNIX, Windows, .NET, GUI, SQL, Oracle, Client Server, UML, Use Cases, XML, Visio, Web Enterprise, RUP, J2EE, SharePoint, Word, Excel, Access, Power Point and Rational Clear Quest

BMO November 2011 – October 2012 (on Contract)

Roles: Technical Specialist Business Intelligence Consultant/ Business Systems Analyst

Projects: M&I conversion, Data Integration, data manipulation, M& I Integration – Debit card, saving and checking accounts and Credit cards (master cards), Salesforce.com, Mutual funds, RRSP, RRIF, RESP and Capital Markets.

• Elicited business requirements by conducting JAD sessions and workshops with business partners/stakeholders and SMEs for M&I and salesforce.com conversion and integration projects. Performed data profiling for the conversion M&I banking applications.

• Generated data mapping and data modeling using source (mainframe) and target data.

• Designed BRD, TSD and data mapping for data model, logical and physical data modeling, process modeling and ETL specifications using ECM.

• Performed data profiling, data analysis and extracted data from database using SQL/DB2

• Updated Metadata extracted data into staging area cleansing and transforming

• Documented test strategies, reviewed and updated test cases, performed BAT testing

Environment: UNIX, Windows, GUI, MS SQL, Oracle r12, AQT, DB2, UDB, JCL, Cobol, TSO/SPF, Client Server, UML, XML, Visio, Power Point, Web Services, SOAP, Ab initio, Mainframe, SharePoint, Word, and Excel

RIM July 2010 – July 2011(On Contract)

Roles: Senior Business Analyst/Test Specialist

Project: Carrier Requirements System – Integration and Development of data management of new carrier systems and Mobile applications, data analysis and data profiling. Migration of carriers systems.

• Analyzed and validated wireless Carriers data management applications and product specifications, developed detail analysis, business requirements documents, Business Context diagram and BPM for the new architecture design project for the carriers’ requirements system. Extracted data from database using SQL.

• Elicited mobile data request information for each carrier like Rogers, TELUS, Koodo, Vodafone, Bell and other service providers to document the requirements for each carrier.

• Facilitated daily meetings and all aspects of SDLC for new development carriers system, discussed problem and issues to solve it quickly using Agile Methodology. Participated change management meetings and provided recommendations.

• Facilitated JAD sessions, surveys, impact, gap analysis by set up meetings with CTM, SMEs, external clients and product Managers to gather requirements and resolve the issues and problems for Carrier requirements to ensure it fits RIM standards and compliances and recommended business solutions for the clients.

• Documented test plans, Implementation plan and test cases review to ensure all requirements were covered. Performed functional, Risk Based, SIT, BAT and regression testing.

Environment: MS SQL, .NET, Oracle R12, Wiki, Client Server, SharePoint, Java Script, Java, MS Office Suites 2007, UML, Visio, Power Point, HPQC, UNIX, MQ, XML, XSL, Dash boarding (BI tool)

RDM Corporation October 2008 – April 2010 (On Contract)

Roles: Senior Business Analyst – Enterprise applications - Data warehouse – GUI, Deposit cheques Conversion from legacy to Data warehouse and Mobile applications

• Analyzed product requirements, gathered information by researching, performing impact analysis, facilitated meetings with business and technology, developed BRD, Business Context Diagram and BPM, SRS, functional specifications, test data, test strategies and test scripts by interviewing architects, analysts, clients and management for Web based applications using BI reporting, ECM, data mapping, data modeling, ETL scripts, UML and Activity Diagram and scanner for the bar code and web based front-end applications for US banks using Agile Methodology.

• Generated BI reporting using SQL server for clients billing information.

• Elicited Remote Deposit Capture information to design BRD and SRD for depositing checks using Android and IPhone smartphone by capturing photos using Agile methodology.

• Analyzed data and manipulated using different data from interfaces.

• Coordinated project and testing activities. Performed BAT and functional testing

Environment: ASP.NET 3.5, HTTP/S, Client Server, GUI, BizTalk, SQL Server 2008, Web Services, Visio, J2EE, Java Script, Java, SOAP, Oracle, SharePoint, XML, C#, MS Office Suite, IIS, HPQC and Power Point.

Royal Bank Nov 2007 – August 2008 (On Contract)

Roles: Business Analyst - Web enterprise – DDA, Deposits, Credit Risk, Mutual Funds, RRSP, RESP, RRIF, Capital Market, Fixed income, Derivatives, Credit Risk, and GIC batch and online transaction. Migration of DDA, Deposits, B2B and payment applications.

• Documented business requirements and Software design documents, gathered information by interviewing analysts, stakeholders, users. Developed test scenarios Translated business requirements into functional, technical and user interfaces specifications using Business Context Diagram and Business Process Mapping.

• Documented test plans, test strategies, operational documentation and use cases

• Performed functional, BAT and SIT testing.

• Coordinated releases and facilitated meetings for mapping project. Worked with developers to resolve the problems and issues and helped out on testing for each phases for new development of B2B.

Environment: SQL, GUI, Java, JavaScript, Webs here, Excel, Word, Oracle R12, DB2, SOAP, Visio, Power Point, SharePoint, Mainframe, TSO/JCL and IMS DB

Merak Systems Corporation May 2007 – Nov 2007 (on Contract)

Roles: Senior Business Analyst/QA Lead

Project: - myAFSC enhancements – New Development of the Eforms project – Enterprise web based front-end applications using Data Warehouse for Alberta Agricorp.

• Analyzed design packages, performed impact analysis, risk assessment, documented business requirements and use cases documents, project planning, PIV and execution, test plans, test cases, and test scripts using Visio and Power Point by facilitating daily meeting

• Generated web design mocks, reviewed wireframes for user interfaces screens.

• Designed data mapping, participated Metadata creation, data profiling and ETL.

• Coordinated test activities. Designed test plan, test cases and implementation plan.

• Performed BAT, System, end to end and Systems integration testing.

Environment: Data Warehouse, Java, .NET, C#, Load Runner, SOA, Object modeling, SQL, Oracle R10, SOAP, UML, GUI, XML, Web Services, J2EE, ERD, SQL Server, and Agile Methodology

Sun Life Financial July 2006 – April 2007 (On contract)

Roles: Senior Business Systems Analyst/Software Test Specialist – Life Insurance/Investments – Ingenium 6.3 term life and administration, new business and Individual Life systems and Wealth Management, Fixed Income and equities

• Analyzed Scope Charter participated data gathering, JAD sessions developed business requirements, SRS, functional, and technical specifications, use cases, test scenarios, test suites, and detailed test plans for web based segregated and mutual funds applications using XML, Performed data analysis. Worked on Individual life Insurance and Segregated Funds for the new business Ingenium 6.3. Set up Life insurance test cases, funds for redemption, purchases, adjustments and fees calculations for the web based Ingenium applications on GUI

• Performed functional, system, BAT and regression testing and provide coordination, defect management, reporting on testing using Test Directory.

Environment: Java, Oracle, DB2, SQL, GUI, XML, HPQC, TSO/ISPF, JCL, Microsoft Office and Visio

Manu Life Financial - May 2005 – April 2006 (On contract)

Roles: Senior UAT/Regression Analyst – Maritime Project – conversion and integration on Maritime Integration Project – Mutual and segregated funds and Locked-in investments

• Analyzed business requirements and developed detailed test plans, test cases and test data for UAT and Regression testing for Segregated and Mutual funds for the Maritime Integration and conversion project, RRIF calculation, RRSP, LIF and Segregated funds using IFAST (GUI)

• Coordinated all testing activities and Participated project from beginning to end (SDLC)

• Set up funds data and performed BAT and regression testing and analyzed issues and assigned to appropriate team member.

International Financial Data Services September 2004 – May 2005 (On contract)

Roles: Application Quality Management Analyst/Business Analyst – Wealth Management, Capital Markets

• Coordinated project activities, developed business requirements, functional specifications, systems requirements for Mutual and segregated funds, RRSP, RESP, GIC, Capital Markets, RRIF, Electronic fund transfers, Transfer Agency, Fixed Income, Market Risk, Credit Risk, LRIF, Exchanges and FundServ for IFDS clients. Performed all levels of testing including BAT and end to end testing. Identified issues and problems and direct to analyze to resolve it.

• Communicated with external vendors and clients to solve the issues

Environment: UNIX commands, UNIX Shell Scripting, PVCS, Test Director, MS Office Suites, Progress, SQL, GUI, Web technologies, FundServ, IFAST and Agile Methodology

IBM Canada Ltd. August 2003 – August 2004

Roles: Senior Programmer Analyst/Systems Analyst – Mainframe applications (on contract) – banking system

• Analyzed business requirements for banking applications, participated in data gathering and documented systems design specifications, BRD and functional specifications. Enhanced and modified online and batch banking applications for T5 and financial statements. Changed name and address segments using Waterfall Methodology.

• Performed BAT and SIT testing using IMS DB, DB2, COBOL, Access, Office suites.

Aviva Group Canada Ltd. October 2002 – June 2003 (on Contract)

Roles: Senior Programmer Analyst – Property & Casualty

• Investigated and analyzed business requirements for Property and Casualty Policy admin, underwriting vendor applications, dealt with third party vendors (HUON) to gather the requirements. participated in data gathering, conceptual design, developed system design, use cases and technical specifications using UML, Visio, and Excel

• Coordinated project activities, estimates, developed and documented use cases, risk and impacts for Property and Casualty applications

Environment: OOP, OOD, GUI, SQL, DB2, Java, SOAP, Java Script, J2EE, SharePoint, Visio, Web Sphere, XML, MQ Series, Huon, COBOL, MS office Suites and Waterfall Methodology.

Bank of Montreal January 2002 – August 2002 (On Contract)

Roles: Senior Programmer Analyst- Business Analyst – Development of Master Card and features

Lutheran Life Insurance Society of Canada January 2001 – January 2002 (on contract)

Roles: Senior Systems Analyst Project: Ingenium upgrades from CAPSIL, new business, life insurance and Segregated funds.

Project: Ingenium System upgrades to 5.4 from CAPSIL, Individual and Segregated fund System, new business and underwriting and generated reports using SAS.

Cooperator - 1996 – 2000 Senior Systems Analyst - Property and Casualty development from Mainframe to Web Service.

Education

• CBAP certification – In progress

• PMP certification - In progress

• Ab initio courses and Micro Strategy certification – 2012 (BI tools)

• Conestoga College – Systems Analysis and System design new architecture – 2007

• Trios College of Information Technology April 2000 – April 2001

• Desktop and Distributed Application Developer Diploma

• Certificate: Microsoft Certified Solution Developer (MCSD) and (MCP)

University of Waterloo

• Math and Computer Science

Contact this candidate