Resume

Sign in

Data Analyst

Location:
Etobicoke, Ontario, Canada
Posted:
April 30, 2019

Contact this candidate

Resume:

PROFILE

**+ years IT experience primarily in the Financial and Banking sector as a Business and Systems Analyst.

Demonstrated deep skills and experience gained working with various complex computerized financial systems, and providing support/expertise/training to staff, suppliers and customers.

Demonstrated analytical, documentation and communication skills, able to develop good business relationships with internal and external clients, and able to work independently with minimum supervision.

Demonstrated proficiency in analyzing business needs of clients to help identify business problems and propose solutions.

Sound understanding, working experience and solid exposure to capital markets financial products (equity, OTC derivatives, options with pricing principles, futures, interest rate SWAP, FX (foreign exchange), fixed income trading, wealth management, financial models.

Demonstrated experience in software development life cycle (SDLC) methodology and practices, including Agile-SCRUM, CMMI, Waterfall methodologies and frameworks, using BABOK guide and recommendations.

Solid mathematical background (Quantitative Data analysis, Probability, Statistics, Random Processes).

Demonstrated ability to plan and work within deadlines, as well as multi-tasking in a fast-paced environment of constantly changing priorities.

Technical skills

Technologies and languages: PL/SQL, Oracle SQL Developer, UNIX, Perl, Python, C#, VB.NET, VBA, C++,

Java, UML, TOAD

BI/Analytics: SAS, SSMS, SSIS (ETL technology using Integration Services packages),

SSAS (OLAP Cubes), SSRS (Reporting Services), XML (XSLT, DTD, CSS, HTML)

Databases: Oracle, DB2, Netezza, SQL Server (installation, administration, T-SQL scripts, stored procedures)

Tools: Visual Studio 2010, Crystal Reports 8-11, Cognos (Report Studio), IBM Rational Modelling suite, HP QA, JIRA, TFS, Erwin

Environments: UNIX, Windows, IBM InfoSphere (MDM), IBM Data Studio, IBM Rational

Host on Demand

Desktop: MS-Office (Word, Excel, Access, Visio, Power Point), MS-Project, SharePoint 2007 (Expert in Excel and Access 2003- 2010 versions including Macros, Pivots & VBA, SQL queries, forms and reports, integration MS Access with MS Excel)

EMPLOYMENT HISTORY

Auto Case Financial, Toronto Oct 2018 to Apr 2019

Business Systems Consultant

Consulting in various methods and IT systems for large datasets processing. Set up, configuration and administration of Oracle and SQL Server databases, Oracle SQL developer tool. Assisted in creation of complicated PL/SQL, T-SQL queries and scripts for data analysis and reporting.

Provided consulting on various statistical methods of data analysis, statistics math and calculations using SAS.

Consulting in modern approach in market risk management based on sensitivity of underlying risk factors including interest rates, credit spreads, FX. Derivative math for Greek parameters (Delta, Gamma, Vega, Theta) calculations.

Consulting in tools and methods for big data storage, retreaval, analysis and management using non relational databases NoSQL (Hadoop, mongoDB) and Python programming language.

MS Office (Excel, VBA, Word, Outlook, Power Point)

Canadian Tire Corporation, Toronto May 2018 to Aug 2018

Sr. Business Systems/Data Analyst

Consulting with business subject matter experts for development requests, making recommendations for the business solution & process flow.

Documented requirements, prepared presentations to translate customer’s development request into technical terminology, including user stories, use cases and test cases.

Participated in the evaluation process with the development team in design sessions for prototyping the new system for the purpose of enhancing business processes, operations.

Provided project planning inputs, leadership and functional expertise for the development support, testing and implementation of business systems.

Built specifications and participated in formal procurement, including evaluating bids as a subject matter expert.

Provided analysis of integration activities between systems.

Agile/SCRUM methodology environment with every day short standup meetings.

Technical Environment: PeopleSoft 9.2, PeopleSoft Application Designer, Send Master, Oracle SQL

Developer, PL/SQL scripts, Oracle SQL queries and stored procedures, PeopleCode scripts, MS Office (Excel, VBA, Word, Outlook, Power Point), JIRA, Confluence.

Ontario Lottery and Gaming Corporation (OLG), Toronto May 2016 to Apr 2018

Sr. Business Analyst

Provided a comprehensive range of IT business analysis services for clients with diverse business and technology needs.

Prepared and advised on business analysis policies, processes, best practices and standards to promote consistent business analysis practice within the organization.

Assessed client’s business problems/opportunities and documented the business requirements to support the technology solution.

Gathered requirements during interaction with stakeholders.

Applied re-engineering concepts to promote business improvements through alternative, cost effective service delivery approaches.

Responsible for business modeling, Use Case modeling; conceptual and logical data modeling, process and data flow modeling, Use Case surveys, business rules definition and non-functional requirements definitions

Technical Environment: MS-Office (Word, Excel, Visio, Power Point), SQL Server

Bank of Nova Scotia, Toronto May 2015 to Dec 2015

Business Systems/Data Analyst, Customer MDM Solutions

Responsible for analysis of business systems, interface development, usability concepts, and industry requirements.

Supported data and functionalities migration to MDM using Agile framework.

Worked with stakeholders to interpret & understand requirements and transform them to user stories and system specifications.

Responsible for analysis, requirement gathering and designing of the business solution.

Involved in the brainstorming, feasibility analysis & validation with development, infrastructure and other IT team to deliver business/system solutions.

Used relationship management to provide support to business clients by mastering new and existing application platforms, ad hoc queries, data flow, troubleshooting, gap analysis between systems, doing root cause analysis and MIS.

Validated operational, system changes resulting from conversion legacy system projects/changes with Business Client & proactively monitor changes.

Designed the Financial System Logical Data Model (FSLDM) for MDM data integration, migration, mapping and reconciliation of large datasets.

Client needs interpretation, conceptual, logical, and physical data models design, entity relationships, and functional data structures in relation to the current business need evaluation, scope and required technical architecture documentation.

Responsible for the design, review & formulation of the test strategy, test plan, test cases and execution under data privacy, confidentiality and security needs.

Complex SQL queries and stored procedures design, testing, development support and implementation.

Reengineered the SAS legacy system for conversion to DB2.

Management of work of project team (BA, 2 Developers, Legacy System analyst)

Technical Environment: DB2, IBM Infosphere (MDM), DbVisualizer, IBM Data Studio, IBM Rational Host On-Demand, UNIX, iWay Data Migrator, TOAD, Erwin, MS Office (Outlook, Visio, Excel, Word, VBA), DB2 SQL queries and stored procedures, Java, XML Web Services (REST API, WSDL) testing, SAS.

SEARS Canada, Toronto Apr 2014 to Nov 2014

Sr. Business System Analyst/Data Modeler

Responsible for creating a data analysis solution with reliability, scalability and reusability in mind.

Provided data architect/data modeler support using logical and dimensional modelling technic to ensure business data requirements are realized in strategic architecture of the warehouse.

Translate business and data requirements into data models in support of Enterprise Data Models, Data Warehouse and Analytical systems.

Develop Data Warehouse Dimensional modelling constructs; Develop and maintain the Data Warehouse Perform rigorous data analysis and data discovery and data profiling.

Designed and maintained services for data movement, transformation and management of claim data from multiple source applications.

Followed MDM technology for source identification, data collection, data governance, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage and protection.

Created source to target mapping, including transformation rules. Maintain Data Mapping requirements and other Data Design artifacts that define technical data specifications and transformation rules;

Designed data flow, entity relationship, flowcharts diagrams.

Served as an expert resource on matters of multi-dimensional data model design in all phases of data warehouse and data mart development, implementation and development support, ensuring all design artifacts are maintained across multiple implementations.

Design of Financial System Logical Data Model (FSLDM) for Oracle to Netezza data integration and reconciliation.

Prepared user stories, test cases/test data (SIT, UAT/BAT) and conducted testing and documented test execution results.

Designed, developed, tested and implemented ETL packages.

Database and application tuning.

Provided management to junior business analysts and testers using Agile/SCRUM methodology.

Technical Environment: Oracle, TOAD, ERWIN, Netezza, Aginity Workbench, MS Office (Outlook, Visio, Excel, Word, VBA), DataStage, Netezza SQL queries and stored procedures

BMO Capital Markets Group, Toronto Nov 2013 to Apr 2014

Sr. Business System Analyst

Responsible for analysis of applicable business systems, interface development, usability concepts, and industry requirements.

Provided analysis of Basel III wholesales credit risk, interest risk and market risk parameters calculations, design of determination of the Asset Class, LGD, EAD, PD and other coefficients, bond and derivative math calculations.

Designed, developed and implemented validation procedures using business process mapping, reengineering approaches, BRD and SRS specifications.

Managed and executed risk data transformation, business analysis of discrepancies, data reconciliation and resolved data integrity issues.

Provided data certification, prototyping reports, and development credit risk reports.

Provided risk data aggregation and process improvement to follow initiatives of Basel III (BCBS 239) and OSFI regulatory requirements.

Provided analysis of counterparty risk mitigation using netting agreements and CCR exposure (Standardized Approach SA-CCR, BCBS 279 regulation).

Developed and supported design of SIT/UAT/BAT test cases and testing execution

Defined user procedures, evaluated alternative workflow solutions, developed conversion and implementation strategies and verified conversion, provided user documentation and user training

Provided post-implementation / operational support.

Performed the calculation and validation of integrity of End of month PL reports in compliance with Client Service Level Agreement (SLA). Business process optimization.

Technical Environment: Oracle, TOAD, TOAD Data Modeler, ERWIN, Oracle SQL queries, MS Office (Outlook, Visio, Excel, Word), SharePoint 2010, Oracle SQL queries and stored procedures

Temenos Canada Inc., Mississauga Apr 2012 to Oct 2013

Financial / Business Systems Analyst

Responsible for analysis of applicable business systems, interface development, usability concepts, and industry requirements in the Wealth Management domain.

Participated in all stages of SDLC and was responsible for analysis of current state and understanding the "to-be" (future state) processes and procedures according to the stakeholders’ and user requirements

Translated BRD requirements to SRS technical specifications using model-driven engineering and business process mapping approaches.

Capital market products management modules validation (bond, OTC derivatives math calculations).

Designed the data flow, entity relationship, flowcharts diagrams, User stories, Test plans and test cases creation based on business requirements and functional and regression specifications

Created SIT/UAT/BAT Test scripts and supported test case execution and incident tracking using PL/SQL scripts, SQL queries and HP QC.

Provided Financial, Sales Revenue, PL reports analysis, report prototyping, design and testing.

Provided traceability (matrix) and QA documentation maintenance.

Provided support to technical staff during stages of development and implementation of legal system conversion project.

Supported resolution of functional and data integrity problems, MDM issue investigations and solution implementation.

Assisted in integration and migrating current business applications to Wealth Management platform based on Internet/web technologies.

Analyzed and profiled client large datasets using SQL queries

Designed and implemented ETL processes to transfer securities trade data to WM Data Warehouse using SSIS tool

Provided analysis and design of existing and new BI applications (business objects, reports, dashboards, and business analytics).

Independently followed-up on issues with other departments, responded to enquiries raised by users and development team on business/functional requirements following Client Service Level Agreement (SLA).

Analysis of Basel Committee Principles of risk management (Liquidity risk, interest rate risk). Business process optimization and gap analysis between systems.

Acted as a Team lead on various stages of SDLC using Agile framework.

Technical Environment: HP QC, Oracle SQL Developer, Perl, UNIX, Fitnesse QA tool, SQL Server, SSIS, Excel Macros, SVN Tortoise, Java, Eclipse, XML, Web Services (REST API), PuTTY, FileZilla, PL/SQL and Python scripts, Oracle SQL queries and stored procedures, MS Office (Outlook, Visio, Excel, Word, PowerPoint, VBA), MS Project.

TD Bank, CSTS Risk Solution, Toronto Feb 2011 to Aug 2011

Sr. BSA/QA Analyst

Responsible for developing the test strategy and plans (SIT/UAT/BAT), test cases and executing testing of a Capital Market Fixed Income products.

Management of Interest Risk and Credit Risk modules of Corporate Lending and Collateral management application.

Provided user documentation, user training, and post implementation support.

Responsible for reviewing, analyzing and evaluating detailed business (BRD) requirements and functional (SRS) specifications, process flows and data.

Prototyped and designed user and regulatory credit exposure and credit risk reports.

Developed use cases, defined and documented user procedures and alternative workflow solutions evaluation.

Responsible for integrating the technical solution with business environment, recognizing systems design and data interdependencies and reusability applying Internet/web technologies.

Implemented procedures for data integrity, aggregation and correctness verification.

Assisted in the development of conversion and implementation strategies.

Conducted pre and post implementation reviews, ensuring all technical solutions have met business and QA requirements.

Acted as QA Testing Manager. Waterfall methodology.

Technical Environment: HP QC and JIRA test tools, SQL Server 2008, T-SQL queries and stored procedures, C#, Eclipse, MS Office (Outlook, Visio, Excel, Word, PowerPoint), SharePoint.

BMO Capital Markets Group, Toronto

Sr. Business System Analyst (Dec 2009 - Dec 2010)

Leadership role in all SDLC phases.

Responsible for business requirements gathering to configure and implement SunGuard’s IntelliMatch software solution for reconciliation of transactions, positions and accounts within assigned sector stakeholder organizations. Capital Market security finance product (fixed income instruments, bonds, repo, security borrowing and lending, OTC derivatives, FX options, interest rate swaps, credit derivatives) and sales revenue transactions reconciliation. Interface projects and problems thorough analysis and effective solutions proposal.

Assisted in analyzing needs for conversion of data from existing systems while creating processes to ensure high quality and effective conversions and implementation,

JAD sessions facilitation

Documentation of BRD and SRS

Contributed to and managed targets to maintain implementation plan for sector stakeholders.

Provided customization of vendor solution to accommodate users’ requirements

RFP development

Managed multiple test cycles including UAT and QA documentation.

Analyzed and designed data sources, data collection, data governance, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage and protection.

Provided large datasets analysis and profiling using SQL queries to extract data.

Supported relationship management and coordination with IT, Application Configuration Support Team and sector stakeholders on configuration and implementation of the iMatch solution, iMatch Administration, Information system management and Configuration support.

Designed, tested and implemented ETL processes to transfer data from various sources (Broadridge back-office processing system data, bank transactions and others) to iMatch Data Mart using VBA, C# and/or SSIS.

Analyzed requirements and designed BI objects (business objects, reports), designed and implemented Crystal Reports objects, migration of reports from Crystal Reports to Cognos.

Project management methodology approach was Waterfall and Agile.

Technical Environment: Crystal Reports 11, Cognos Report Studio, SQL Server 2008, SSIS, VB/VBA script, VB.NET, C#, C++, XML, SQL queries, MS Office (Outlook, Visio, Excel, Word, PowerPoint), SharePoint, MS Project, SQL queries and stored procedures.

Citi Cards Canada, Toronto Oct 2007 to Oct 2008

Sr. Business System Analyst/Data Architect

Provided project leadership of Financial Department IT projects and major initiatives.

Responsible for gathering application requirements using JAD sessions.

Responsible for the solution design analysis, including detailed data analysis and profiling using reengineering, model-driven and business process mapping requirements approaches, budgeting and tracking the project.

Responsible for conceptual, logical, and physical data models design, entity relationships, and functional data structures in relation to the current business needs evaluation, scope and required technical architecture documentation.

Provided technical support of Credit Cards accounting and reconciliation systems with appropriate customization and configuration for various end users.

Development and maintenance of documented business processes and flows.

Designed, tested (SIT/UAT/BAT) and implemented data transfer from various sources (ETL) to the custom reconciliation system.

Responsible for gathering and analyzing requirements to design BI applications (BRD, SRS, business objects, reports) using JAD sessions with stakeholders.

Responsible for analyzing and designing data sources, data collection, data governance, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage and protection.

Supported large datasets and reports prototyping using SQL, designed and developed various reports, including management and credit risk reports.

Supported and maintained existing transactions reconciliation processes, resolving issues.

Providing operational ongoing support after project implementation.

Developed practical manual and automated procedures to solve complex problems.

Responsible for identification, evaluation, development and implementation of re-engineering processes to improve efficiency and accuracy.

People management – planning, direction, controlling work of small team (junior BA, data analyst, developer)

Supported migration from PeopleSoft v.8 to v. 9 using an Agile methodology and approach.

Technical Environment: MS Access, SQL Server, Visio, MS Project, VBA, VB.NET, C#, C++, Java, Eclipse, ERWIN, PeopleSoft 9, NVision, Essbase Excel Add-in, MS Office (Outlook, Visio, Excel, Word, PowerPoint), MS Project, SQL queries and stored procedures.

RBC Dexia Investor Services, Toronto Feb 2007 to Jul 2007

Financial/Business System Analyst

Managed collection and compilation of internal and external large datasets and information, assessed and analyzed information relevant to objectives of the project.

Analyzed processes and identified opportunities for improvement or reengineering within Unitrax Mutual Fund Capital Market brokerage system, Mutual Fund Processing, GICs, Equity markets.

Developed and maintained standardized processes to facilitate implementation of Unitrax vs Oracle GL mutual funds, securities trade transactions reconciliation processes and ensure compliance & control.

Client needs interpretation, conceptual, logical, and physical data models design, entity relationships, and functional data structures in relation to the current business need evaluation, scope and required technical architecture documentation.

Created the prototype of transaction reconciliation system with designing of ETL processes and BI application (reports and dashboard data presentation).

Established that product controls and accounting integrity exist within product systems and process deliverables to align with corporate and regulatory guidelines/standards.

Extensive use of VBA and SQL to integrate MS Access, Excel and Oracle database.

Technical Environment: Unitrax, SQL, MS Office (MS Access, Outlook, Visio, Excel, Word, PowerPoint), VBA, XML, Oracle, UNIX.

TD Bank Financial Group, Toronto May 2006 to Dec 2006

Sr. Business Analyst/Project management

Responsible for planning, directing and managing the design, development and implementation of the Data Warehouse planning/forecasting occupancy expenses model of the Bank using model-driven requirements approach within SDLC.

Provided a cost/benefit analysis using ROI, NPV, IRR, and break even calculations.

Designed and implemented ETL processes to transfer data to occupancy Data Mart (SQL stored procedures), analysis and design of BI applications (business objects, reports, dashboards).

Supported interface projects and problems thorough analysis and effective solutions proposal.

Analyzed and designed large datasets, data collection, data governance, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage and protection following MDM technology.

Supported the gathering and documentation of application requirements via JAD sessions with stakeholders.

Defined project scope, objectives and key deliverables (BRD/SRS/SDS) including helping to prepare and executing the overall project plan.

Project approach was Waterfall.

Worked collaboratively with business units and technical teams.

Technical Environment: MS Office (MS Access, Outlook, Visio, Excel, Word, PowerPoint), MS Project, T-SQL queries and stored procedures, VB, SQL Server 2005, SSIS, DTS packages, SSRS, SSAS, ADO, Oracle Fixed Assets, Oracle Discoverer, VBA, Crystal Reports.

Coventree Capital Group Inc., Toronto Sep 2005 to Apr 2006

Implementation/Data Analyst

Supported implementation of Capital Market information system (Fixed income, Interest rate, SWAPs derivative products)

TD Bank Financial Group, Toronto Mar 2004 to Jun 2005

Sr. Financial Analyst

Fixed assets accounting transactions in Oracle Financial

Technical Environment: MS Office (MS Access, Outlook, Visio, Excel, Word, PowerPoint), T-SQL queries and stored procedures, SQL Server, Oracle Financial.

Ajilon Communication Canada, Toronto Jul 2003 to Feb 2004

Sr. Financial Analyst

Supported accounting transactions in People Soft AP, AR, Bank Payments modules

Open Access Limited, Toronto Jan 2001 to Mar 2003

Business System/Data Analyst

Supported Capital Market Mutual Funds management information system

Analysis, modelling, supporting existing data model, design validation processes

Accounting mutual fund and end of year tax transactions and reports

Technical Environment: MS Office (MS Access, Outlook, Visio, Excel, Word, PowerPoint, VBA), T-SQL queries and stored procedures, SQL Server.

EDUCATION AND PROFESSIONAL DEVELOPMENT

CGA Ontario Program 1999 to 2003

MSc (with Honors), PhD (Applied Math & Statistics)

State University of Physics and Technology, Moscow (Evaluated by York University).



Contact this candidate