Rojalin Mohapatra
Senior QA Analyst
adodcs@r.postjobfree.com
Mobile: 416-***-****
mailto:adodcs@r.postjobfree.com
Professional Summary:
●Having 10 Years of experience in Software Quality Assurance & Testing across Banking, Financial and Retail domains
●Well experienced in implementation through Agile Methodology, attended regular SCRUM meeting and bi-weekly sprint planning and sprint review/retrospective call.
●Significant knowledge and experience in Securities Trading (Equities, Options)
●Stronghold of software development/test life cycle (SDLC/STLC) specifically in Waterfall and Agile methodologies
●End to End Trade life cycle through to clearing & settlement (Strong focus on Equity & Options)
●Capital Markets – Securities: Stocks, FX, Fixed Income,Options and Futures.
●Trading Order Entry / Routing / management systems – RBC’s Trade Link & Fidessa
●Knowledge of FIX protocol and Risk management.
●Expertise in performing backend data validation after ETL process and validate the completeness, integrity and accuracy of data using sql queries.
●Worked on oracle Hyperion for budgeting and forecasting and reporting on Tableau dashboard and Power BI.
●Expertise in writing UFT automation scripts using VB Script. Well versed with handling dynamic web elements in UFT using Regular expression and identifying the object properties using object spy.
●Working knowledge in Selenium webdriver.
●Has extensive experience in Agile tools like JIRA and Confluence
●Experience on HP ALM and its all modules like Management, Dashboard, Requirements, Testing and Defects.
●Very good knowledge of Oracle and SQL Server systems, including the ability to prepare and execute the queries required for reporting.
●Experience in Developing Test Strategy, Test Plan, Test Cases and generating Test Reports for both manual and Automated tests.
●Run the regression suites for every new release and update the scripts for all new enhancements.
●Participated in defect management process, track and retest defects found during testing until fixed.
●Performed Smoke testing, Functional testing, Regression testing, Integration testing, ad-hoc testing and black box testing for improving product quality.
●Performed review and analysis of functional requirements and test plan design documentation. Attended requirements and design meetings.
●Excellent interpersonal skills, a good Team Player, and a very fast learner.
●Excellent leadership qualities and communication (oral, written, presentation) skills and can also work independently as and when required.
Employment Summary:
CIBC Since Sep 2020 to till date
Position Senior QA Analyst
Project Simplii
Project Synopsis:
Responsibilities:
Test Execution – Functional & Regression testing
Creating the test data and executing the scripts
Create monthly and quarterly reports using excel macro.
Maintaining and enhancing the codes.
Creating new scripts for the new requirement.
Defect entry and management through JIRA
Review functional and integration test cases with Developers, Support and Product Management
Preparing Test Plan and come up with testing timelines which align with Business Requirements
Executing and Enhancement of Regression package to ensure that the changes to the application do not negatively impact existing functionality.
Track and prepare the report of testing activities like test results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
Publish the Daily and Weekly Status reports and Dashboards
Rogers Communications Canada Since Jan 2020 to August 2020
Position Senior QA Analyst
Project BI APPs
Project Synopsis:
Hyperion Planning
Oracle Hyperion planning is a centralized, Excel and Web-based planning, budgeting and forecasting solution that integrates financial and operational planning processes and improves business predictability.
The tool is intended to make user life easier; this will be enabled to respective users for data entry through an intuitive web interface which will reduce the data preparation and consolidation effort required each month.
Responsibilities:
Was working as functional consultant to Analyse the requirements and understanding the designs to come up if any gap and follow up with dev to understand and lose the gaps.
Design and write detailed test cases, partnering with Business Analyst.
Review functional and integration test cases with developers and business.
Test data preparation and data mock up as required for the report logic if real data not available.
Report level validation in power BI and Tableau dashboard.
Involved in end to end testing.
Executing the test cases and discuss the defects on daily stand up call.
Executing and updating of Regression package to ensure that the changes to the application do not negatively impact existing functionality.
Ontario Teachers Pension Plan (OTPP) Since April 2019to Dec 2019
Position Senior QA Analyst
Project Legal Compliance Solution
Project Synopsis:
TDC (Trade Desk Compliance)
Trade Desk Compliance function is introduced by OTPP to monitor the regulatory rules, requirements and changes affecting trading to protect the integrity and reputation of the Fund and prevent trading violations from occurring based on OTPP trading activity.
-Cache and de-normalised data to achieve optimal reporting performance.
-Apply business data transformation logic.
-Snapshot the result data for report Viewing, Approving and Publishing.
Responsibilities:
Analysing the functional specs and understanding the data mapping from source to target table and discussing with Data BA for any clarification.
Understanding the solution architects to come up if any Gap and follow up with Dev to close the gaps.
Preparing the sql queries based on the transformation logic on source table and compare the results with target table.
Preparing Test Plan and come up with testing timelines which align with Business Requirement.
Design and write detailed test cases, partnering with Business Analyst.
Review functional and integration test cases with Developers and Data BA for test data.
Test data preparation and data mockup as required for the report logic if real data not available.
Order entry through Charles River as part of integration testing.
Report data validation in Power BI.
Test Execution through ALM on functional testing for full coverage.
Executing and updating of Regression package to ensure that the changes to the application do not negatively impact other existing functionality.
Defect entry and management through JIRA
Prepare the report of testing activities like test summary report, required resources, defects discovered and their status, performance baselines etc.
Royal Bank of Canada (RBC) since July 2016 to April 2019
Position Senior QA Analyst
Project RFM (RBC Flow Monitor) & NEXTGEN
Project Synopsis:
RFM (RBC Flow Monitor)
RFM is a front office management system which is mainly used to manage Equities and derivative orders from different clients. It is an integrated suite of functional applications that manage and automate the front and middle office business flows for sell side firms trading equities in US and Canadian markets.
NEXTGEN
It’s an order management system introduced by RBC for their Electronic and manual trading flow. In this legacy system Log generation done in Unix Server. It handles manual orders from front office application as well as electronic orders from different client simulators and sources like Verifix, Fidessa, Portware etc.
It is developed for both US and Canada region.
Nextgen has the different risk validations, over fill handling and GTC/GTD order handling.
Responsibilities:
Analyzing all the requirements for the base changes and the project changes, and come up with Impact Analysis, Gap Analysis and follow up with the Project Management Team to close the gaps.
Design Test plans and write detailed test cases, partnering with Business Analysts and Production Support teams
Was involved in Front office application testing using manual order, client order via verifix US/CA Fidessa and Portware.
Verifying the risk checks in database and compare in the UI.
Comparing the data loaded in target table are the expected results from the source table after running the ETL jobs.
For smart order routing, orders were routed to Thor, Thor was routing order to different US and CA exchange.
Test Execution – Functional & Regression testing
Execute automation regression suite for each release and adding the new functionality to the regression suite using UFT.
Maintaining and enhancing the codes.
Defect entry and management through JIRA
Review functional and integration test cases with Developers, Support and Product Management
Preparing Test Plan and come up with testing timelines which align with Business Requirements
Executing and Enhancement of Regression package to ensure that the changes to the application do not negatively impact existing functionality.
Track and prepare the report of testing activities like test results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
Publish the Daily and Weekly Status reports and Dashboards
Daiwa Capital Markets Hong Kong Limited since Sep 2012 to Nov 2015
Position QA Analyst
Project Daiwa Capital Markets
Project Synopsis:
Daiwa Capital Markets Hong Kong Limited, which has been operating at the business central of Hong Kong since 1970, is regulated by the Securities & Futures Commission. It provides regional coverage to an established international client base, maximizing client opportunities through the utilization of the resources and network of Daiwa Securities Group Inc.
Responsibilities:
Working as Team member in a team of 5 involved in various activities as mentioned below.
Requirement study/analysis, Understanding Logical flow of the Application
Design Test cases as per the requirements
Test Execution – Functional testing / Regression testing
Working on SQL queries
Defect entry and management through Jira
Retesting after defect fix
Solution Environment: Fidessa
Was involved in Front office testing using manual order agency and house or client order via Verifix
Routing order to AMMA or Bluebox and getting execution using Hong Kong test exchange.
When order routed to BlueBox using different strategy such as VWAP / TWAP /Iceberg, based on the different strategy parameter BlueBox route to exchange on different route
For smart order routing, orders were routed to AMMA with SOR option, AMMA was routing order to different Japanese exchange.
Based on the different SOR technique such as sending small quantity to different exchange (Tokyo, Osaka etc).
Cancelling order from Tokyo and routing to Osaka based on the availability of the liquidity.
Green Object Pvt. Ltd since June 2011 to Aug 2012
Position QA Analyst
Project GreenVeg - ERP
Project Synopsis:
Green Object Pvt. Ltd. is the leading Suppliers of Vegetable. They specialize in supplying vegetables and fruits to leading Hotels, Restaurants, and Canteens. They are specialists in this field and can consistently deliver top quality fruits and vegetables at competitive prices. Their products are sourced carefully and they aim to meet the needs of all our customers, however large or small your business is.
This application is an ERP Suite to manage Green Object’s day to day transactions with their clients. It would be basically a web-based enterprise application which would act as an interface between Green Object and its Clients. This application would be capable of handling Company Inventory, Purchase Orders, Sales Orders, Customers, Client Billings, Company Accounts and MIS Reports. Through this application itself clients can place their orders. This application would comprise of 3 modules i.e., Admin, Staff and Client (Hotels / Caterers / Restaurants / Retailers).
Responsibilities:
Reviewed Business and Functional requirements of the application.
Participated in identifying the Test scenarios and designing the Test cases with QA Team.
Performed Functional, Regression, UAT and Browser compatibility testing of the application.
Comparing the source and target data after the batch job runs.
Verifying the meta data, data completeness and data quality in target table.
Coordinate, document test results and report defects found during all testing iterations using HP QC
Attend meetings to discuss the severity of the found defects, communicate testing status to the testing team, Project Manager and Business Analysts.
Environment: Windows 7, .NET, Oracle, Toad, HP Quality Center 10, QTP Report progress to the stakeholders at regular status meetings.
Education:
Bachelor of Technology with specialisation in Electronics and Telecommunication from Biju Patnaik University of Technology, Rourkela, India.
Technology:
Below is a list of important hardware, software products, tools and methods that I have worked with.
COMPUTER SYSTEMS
PROGRAMMING LANGUAGES/DATABASES
SPECIAL SOFTWARE
Windows 98/XP, 2000, Vista, 7, Linux
MS Word, Excel, PowerPoint, Open office
PL SQL developer,
Unix Shell Script,
C,
Toad
Java Script,
VB Script,
Oracle
Fidessa,
Fidessa Traders Workbench (FTW),
Verifix,
Fix Protocol
JIRA,
UFT,
Selenium webdriver,
HP ALM,
Oracle Hyperion
Power BI, Tableau dashboard