NIVESH V. KOTIAN

Brampton, Ontario 613-***-**** adim4o@r.postjobfree.com linkedin.com/in/nivesh-kotian

BUSINESS ANALYST & PRODUCT ANALYST

Spearheads and implements strategic projects for Banking sector as Senior Business Analyst and Lead QA

Demonstrates proficiency in all aspects of the software development life cycle with end-to-end delivery

Is proficient in Agile based delivery projects with Scrum Certification from Scrum Alliance

Delivers retail and corporate banking expertise in Pricing & Billing Solutions, Rates & Fees, Offers & Rewards for top Canadian and US Banks (Bank of Montreal, Toronto Dominion Bank, CIBC & Scotia Bank)

Shares rich experience in implementing of ERP software solutions for Retail and Corporate banking sectors

Collaborates closely with business to define requirements, in-scope and out-of-scope items for projects

Leads development & grooming of user stories with business & technology partners

Strategizes cross-functionally with Scrum Master/Delivery teams to develop product backlog, sprint plan & release plan

Designs cutting-edge testing strategy by reviewing and writing test plans and test cases

Shows deep experience in all aspects of testing (Functional, Sanity, Regression, Smoke, System)

Establishes and manages first-rate communication plans for project deliverables with all the stakeholders

Executes top-notch data analysis using complex SQL in Postgres and Microsoft SQL Server, knowledge of SharePoint and Python, Postman

Skilled in software languages; JAVA, JavaScript, Selenium, TestNG; VMWare, Apache Tomcat, Eclipse, TeamCity, JMeter

Proficient in using Microsoft Word, PowerPoint, Excel, Access

Knowledge of SharePoint Online, Microsoft Power Apps, Data Visualization applications, Azure Cloud

Knowledge of REST APIs, JSON structures

CAREER OVERVIEW & HIGHLIGHTS

Accenture Inc., Toronto, Ontario June 2015 – Oct 2020

Business ANALYST, Client: PNC Bank (July 2019 – Oct 2020)

Created world-class Fit Gap documents and HLRD to articulate gaps prevalent in RRP Product as per requirements, which provided better insight for both teams and advanced comprehension of key missives and critical updates across business lines.

Proficiently created flowcharts and Process Flow Diagrams using MS Visio.

Delivered MVP scope successfully for 1 million+ customers batch load in just the first month batch run.

Validated data loading into RRP Tables for Customers, Accounts and transactions using SQL queries in Postgres

Provided first-rate support to Client QA for SIT/UAT cycles and analyzed impact to stakeholders, process, and customers to achieve stellar business results and identify and lead problem resolution to ensure customer needs were met and to stop charging fees.

Reviewed and understood banking (financial services) business requirements, functional and design specifications using MS Word, SharePoint, Excel to gain full understanding of deliverable, with active involvement with the QA Team for software testing.

Conducted sessions with Technical offshore team for development and maintenance of Azure Cloud Environment for deployment, execution of Test Scenarios and validation of test data.

Participated in Agile/Scrum Practices such as daily standup, sprint retrospective and review meetings to pioneer change management and assisted FSD, ISD and use case walkthrough sessions to translate business requirements to test scenarios.

BUSINESS ANALYST, Client: TD Bank (April 2019 – July 2019)

Identified changes to existing specifications and created new ones to meet customer requirements; implemented second database schema with 100K records loaded using ETL, documented and received sign off on BRD, ISD and TSD from TD stakeholders and developed test strategy/plan to outline the testing approaches.

Provided sessions to TD QA team to analyze DB tables and provide clarification where appropriate, successfully translating business requirements to comprehensive functional and technical specifications for ETL Processes.

Documented business requirements for ETL processes and for Integrations between TDBG4 and TDS-OTIL systems using Microsoft SharePoint, Word and PowerPoint.

Analyzed technical specification documents for TDGB4 to identify core Database tables needed for transposing data from TDBG4 schema to TDS-OBIL Schema.

Conducted brainstorming sessions with Business and Technology teams for specifications and solutioning with least impact to existing schema in production and wrote SQL queries and procedures with Dev Team to create mock Database setup of TDBG4 schema with right constraints.

Participated in Agile/Scrum Practices such as daily standup and sprint retrospective and review meetings to foster continuous improvement initiative.

BUSINESS ANALYST, Client: CIBC (July 2018 – March 2019)

Developed business cases into functional use cases for Scrum team and Business rules on Product UI Config for QA teams for execution of batch processes.

Delivered RRP ERP for CIBC 100 K waiver application and gained approval from businesses on Fit Gap documents to maintain transparency on product gaps and shortcomings, assisted Core Product Team in defining product roadmap.

Developed test strategy/plan to outline the testing approach, providing detailed test execution summary reports and logging defects in JIRA and tracking them for every release provided by Product Team.

Provided support to client QA for SIT/UAT cycles and participation in FSD, ISD and use case walkthrough sessions to translate business requirements to use cases.

Documented waiver rules hierarchy on Azure Cloud environments and secured approval from business stakeholders; collaborated with project manager and business sponsors to identify and ensure required resources were assigned to the project for successful delivery of requirements.

Assisted change management using Agile methodologies to implement incremental builds and performed backlog grooming in accordance with the PO and Dev Team to prioritize and collaborate work with Dev Team members.

BUSINESS ANALYST, Client: FIS-POC (April 2017 – July 2018)

Contributed to and participated in development of product, conducting UAT, and documenting all stories, issues, bugs. Assisted Dev Team for pre- production readiness with one-time scripts and maintained requirements traceability to keep tight control over evolving retail business requirements.

Provided outstanding support for system integration, performance, and user acceptance testing; reviewed and understood banking (financial services) business requirements and functional and design specifications to ensure full understanding of deliverable for Epp-PoC rules and rewards.

Manage Project documentation – Business and System Requirements, Use Cases, Process Flows, Traceability

Conducted gap analysis between expectation of clients and what systems did to determine deficit was documented; created business use cases and attained approval from the Business Team.

Executed backlog grooming and story prioritization, breaking down epics to stories. Shared insights and facilitated Scrum Meetings such as Daily Stand ups and Sprint retro and review sessions.

BUSINESS ANALYST, Client: Bank of Montreal (June 2015 – March 2017)

Maintained requirements traceability to keep tight control over evolving retail Business Requirements and documenting requirements as Agile User stories.

Engaged with Ui/UX team members to enhance UI

Contributed to the Product Team in product development, conducting UAT, and documenting all stories, issues and bugs.

Actively developed and maintained thorough documentation for User Interfaces using miRev G4 application required for Fee Transparency messages under rebate clawback scenarios for PPPC Customers.

Engaged Product Team to develop Azure Cloud system to deploy and execute test scenarios to replicate production environment

Documented requirements for Jasper ETL loading and report generation for BMO executive analysis.

Facilitated highly productive defect triage calls with clients and provided RCA (root cause analysis) of SIT/UAT defects based on priority and severity.

QUALITY ANALYST, Infosys Technologies Ltd., India June 2011 – September 2013

Following the SDLC process, use requirements documents to create testing strategy estimates, documenting test plans and objectives, assessing and identifying testing risks, and developing test scenarios and test cases

Develop, document and maintain test artifacts like test data, data validation and automated test scripts using Selenium WebDriver, primary language used for automation was JAVA

Assisted in developing and maintaining robust and effective Page Object Model Framework.

Implemented Maven for build management and implemented CI tool - Jenkins.

Implemented Selenium Grid for parallel testing on multi browser and OS combination.

Played an active role in the review of PRDs and Design Specifications for identifying issues and problems before entering QA.

Analyzing defects and providing root cause analysis (RCA) to client.

Performed functional and Regression Testing across various browsers (IE, Mozilla, Firefox)

EDUCATION & CERTIFICATION

Certified Scrum Master, Scrum Alliance

Certified Scrum Product Owner, Scrum Alliance

RPA Business Analysis Foundation & RPA Developer Foundation Certification, UiPath

Master of Engineering, Electrical & Computer Engineering (ECE), University of Ottawa

Bachelor of Engineering, Instrumentation, University of Mumbai

Contact this candidate