Business Analyst

***********@*****.*** Mob: +1-289-***-**** Toronto, Canada

Professional Summary

oBusiness Analyst professional with 5+ years of professional experience in providing strategic insights, streamlining business processes.

o2+ years of experience developing Tableau Data visualization reports and dashboards and 2+ years of experience in extracting data from the server and other data visualizing soft wares e.g. EXCEL, SQL server etc.

oOver 4+ years of sound understanding of retail, commercial and small business banking activities and practices.

o3+ years of experience Liaising between ServiceNow application users and I.T (solution analyst) in the analysis, design, testing for application development to ensure optional operational performance that meet business needs.

oMotivated business analyst with over 5+ years of experience in the banking sector helping businesses manage their expenses and remain profitable by doing process analysis

oWork closely with business users, SMEs, project managers, accounts managers, end-users, quality assurance, sales and marketing, training and IT personnel for gathering requirements, analyzing processes and devising solutions for new and existing technical projects.

oParticipated in requirements workshops to identify business needs and requirements

oExcellent writing skills in preparing Business Requirements Documentations (BRDs), System Requirement Specifications (SRSs), functional specifications, defining project schedule, timeline and budgets and training technical and non-technical users.

oExpert in business process engineering, Agile methodology, Project Management Life Cycle (PMLC), system development life cycle (SDLC) including analysis, design, development, testing (test cases), test methodologies and implementation of software systems.

oStrong in MS Visio, MS Excel, SQL (SQL data manipulation and SQL Query)

oExperience working with Tableau Desktop and Tableau Server in Tableau\9.x and 10.x

oExpert in data-driven, user-friendly visualizations, using Tableau, those identify opportunities for process improvement, price negotiation, and inventory planning, budgeting & cost savings.

oProficient in requirements gathering brainstorming, identifying Key Performance Indicators (KPIs) for revenue growth, cost savings, project management, customer satisfaction and brand awareness etc.

Analytics Expertise Areas

• Business Analysis • Driving actions through analytics • Tableau Visualizations

• Project management & planning • Content analytics • Summarization & presentation

• Business Process Improvement • Cross functional collaboration • User Acceptance Testing (UAT)

• Data Integration & cleaning • Business Process • ServiceNow expertise

Professional Certificates & Trainings

•Tableau Desktop & Desktop Qualified Associate •IFC (Investment Funds of Canada) designation • CSC enrolled

Professional Experience

Scotiabank Canada

Business Analyst Nov 2017 to Present

Project: The scope of the project is to implement Lending Services Commercial reports and Dashboards from excel to Tableau enabling users to have new features and functionality previously unavailable. The data was extracted from the sources related to Credit due-diligence (CDD), KYC, Client identification due-diligence. Based on the Lending services mapping specification the request will be sent to SQL server, which interacts with source interfaces.

RESPONSIBILITIES:

oParticipated in weekly meetings, reviews, and user group meeting as well as communicated with stakeholders and business groups.

oConducted Business Requirements Gathering sessions in the form of questionnaires and business

scenarios with the end users, subject matter experts (SME), QA and the developers.

oPerformed gap analysis for client’s requirements, generated system workflows and gathered business requirements

oInvolved in reviewing process as-is to to-be and data sources form MS Excel for design, development, testing, and production rollover of reporting.

oImported and manipulated large data sets in databases and use different SQL functions under tight deadlines which included (UPDATE, JOINS, INSERT, DELETE etc.) commands.

oLead leadership meetings, including Directors, and the executive teams to understand general business trends by providing analytical insights through Tableau dashboards/ PowerPoint dashboard and bridged the gasping decision making.

oAnalyzed and documented the business requirements, meeting minutes, responses to questionnaires and got approval of the documents from the client in the form of sign off.

oDeveloped various use cases, workflow, screen mock-ups, and conversion requirements.

oServe as the key conduit to business users for requirements and analysis, and work with Solution Architects and the Architecture organization to define and manage requirements.

oResponds to and performs impact analysis on requests, expected to assist with estimates

oAct effectively as the technical speaker to the business project team, able to represent IS at all levels within the business stakeholder community

oDiagnose and resolve ServiceNow related questions to ensure the accuracy of business-critical processes. Interact with administrators, developers, and business system users in this effort.

oWork directly with end users to resolve support issues within ServiceNow.

oParticipated in the development of implementation strategies and plans with business units

oDocumented and provided knowledge transfer to the rest of the project team for all solutions

ENVIRONMENT : Tableau Desktop 9.x 10.x, Tableau Server, Oracle SQL Server, SQL Scripting MS Excel

UAT, MS Excel, MS Word, MS Power Point, Netscape, Firefox, MS- Outlook, Balasmiq, ServiceNow.

CIBC Canada

Business Analyst Apr 2016 - Nov 2017

Project: The scope of the project is to Migrate mutual funds, investments and lending reports and Dashboards from SAP BO/Excel to Tableau enabling users to have new features and functionality previously unavailable. CIBC wanted a better way to integrate, analyze and exploit data to improve financial performance.

RESPONSIBILITIES:

oGathered requirements from the business users & understanding the functionality and business rules

oCreated Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping.

oWorked creating both functional and Technical specifications per client requirements

oParticipated in creating star schema models as per user specifications.

oAssisted in extraction of data tables with custom queries using SQL to analyze and manipulate data for custom database analysis including updating the delegated list.

oPrepared functional design document, requirement document and technical design document.

oAnalyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.

oCreated Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.

oGathered and documented client requirements, business needs and project objectives, via feedback sessions and client meetings.

oMonitors daily the ticket queue in ServiceNow and drives the tickets of his/her area to completion.

oInteract with the business users in the relevant functional areas and understands their business processes, current pain points and the business requirements to provide proper analysis and issue resolution.

oCoordinate the implementation and maintenance of automated workflows using ServiceNow Orchestration

oDesigned and implemented user set- up, end user training materials and testing procedures.

oConducted User Acceptance Testing (UAT) of the developed applications along with the end-users.

oAnalyzed large amounts of data efficiently to interpret statistical analyzes.

oReported bugs and interacted with the software development team to resolve issues.

ENVIRONMENT : Tableau Desktop 8.x 9.x Tableau Server, Oracle SQL Server, SQL Scripting MS Excel

MS Excel, MS Word, MS Power Point, Netscape, Firefox, MS- Outlook, Balasmiq, ServiceNow

TD Canada Trust

Business Analyst Jun 2014 – Apr 2016

Project: The client used Excel as Reporting System that served the Reporting and Analysis needs for all of Fraud strategy and Insight departments. The project goal was to convert Reports and Dashboards from Excel to Tableau or Business Intelligence, thereby enabling users to have new features and functionality previously unavailable. Designed, developed, enhanced around 40 dashboards and 28 reports using Tableau Desktop.

RESPONSIBILITIES:

oDesigned and prepares technical specifications and assist in project artifact documentation in business requirement documents functional specs flow charts and system architectures source to target mappings

oParticipated in project planning sessions with project managers, stakeholders to analyze business requirements and outline the proposed solution

oConducted current state analysis on existing reporting systems, documented gaps and developed future state and solution approach

oAssist the senior management in completing critical processes such as quarterly and annual Loss Estimate planning.

oDesign and prepare technical specifications and assist in project artifact documentation in business requirement documents functional specs flow charts and system architectures source to target mappings

oLead business initiatives including brainstorming on new functionality for current systems

oGathered and documented the requirements that were critical to the business mission and used those requirements to design application software using a Use Case

oConducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement

oCreated use case scenarios and documents workflow and business process

oPrepared user stories to create compelling dashboards to deliver actionable insights

oBuild complex custom reports for end-user scenarios

oDevelopment of new/enhanced reporting systems, policies, procedures and address known deficiencies.

oDevelop queries using SQL for data extraction including manipulating dataset for specified reporting needs and ad hoc analysis,

ENVIRONMENT: Oracle SQL Server, SQL Scripting MS Excel, MS Excel, MS Word, MS Power Point, Netscape, Firefox, MS- Outlook, Balasmiq

Tools & Technologies

Data Analytics & Reporting Tableau Desktop & Server,

Enterprise Systems JIRA and Balasmiq and ServiceNow

Office Applications MS Excel, PowerPoint, Word, Access

Programming Language SQL

Databases Microsoft SQL Server, MySQL

Statistical Techniques Correlation, Forecasting, Time Series, Moving Averages, Linear Regression

Education

Bachelors of Arts: Economics

York University, North York, ON, Canada

2013 – 2014

Bachelors of Business Administration (hons): Finance

Lahore School of Economics, Lahore, Punjab, PK

2006 – 2010

Contact this candidate