Satish Gairola

Client : SAXO BANK

• Saxo Bank – CRM onboarding tool (Migration testing)
• Responsible for onboarding the potential clients into Saxo bank system
• Validation on client creation process using multiple methods like using MS CRM, webservices etc
• Active participation in business requirements meetings
• Running the defect triaging meetings
• ETL testing.

Client : Goldman Sachs

• First Affirmative is the leading advisor network serving the responsible investment community
• Folio Financial’s technology, tools, and the new investment opportunities they bring to the table will enable us to widen the scope of possibilities for responsible investors, now and into the future
• Folio Financial’s Digital Wealth Platform (DWP)— a modern, digital wealth management platform that is leading the next evolution of digital advice
• With Robo advice Folio is providing more personalized advice to investor directly aligned to their goals and preferences
• At the same time, the impact of recent societal events will force advisory firms to adopt digital practices
• Analyzing and translating functional specifications into testing requirements
• Involved in the SIT, UAT, Sanity, Mobile, API, Functional/Manual, Database, and Regression testing
• Coordinating with Onsite team
• Test case Designing
• Test case Execution
• Daily and weekly Status Reporting
• Daily status call with client about project status
• Execution of Test Cases and Created Test Data manually in JIRA
• Defect Logging, tracking of defects, Defect Management in the JIRA
• Involved in Functional, Integration, Regression, Ad-hoc testing, Sanity testing and Peer Reviews.

• Sonata is new wealth management application suite for investment and policy administration
• It provides a single solution with coverage for life insurance, trust, pension/annuity, group superannuation/pension and UK wrap, ISA, JISA and GIA
• Sonata incorporates more than 15 years of comprehensive product functionality found in Talisman combined with the benefits of modern technology architecture
• It is a comprehensive end-to-end solution including web access, workflow and business intelligence
• Sonata also incorporates SonataWeb, a real-time front end online solution for advisers providing real-time quotation and policy application
• Working knowledge on Corporate Action, Distribution, ETI assets, Disinvestment, Transfers, Re-registration, Switch, and Advisor
• Analyzing and translating functional specifications into testing requirements
• Involved in the SIT, UAT, Sanity, Functional/Manual, Database, and Regression testing
• Coordinating with Onsite team
• Test case Designing
• Test case Execution
• Daily and weekly Status Reporting
• Daily status call with client about project status
• Execution of Test Cases and Created Test Data manually in JIRA
• Defect Logging, tracking of defects, Defect Management in the JIRA
• Involved in Functional, Integration, Regression, Ad-hoc testing, Sanity testing and Peer Reviews
• Worked on Selenium Automation tool
• SOAP UI for web service testing
• Sending the DSR (Daily Status Report) to the Onsite team
• Liaise with functional & technical consultants in Requirements Analysis & scope identification, and guide solution development from conceptualization to implementation
• Analyze Business Requirements and translating business requirements to create FSD for the reference of development and testing team
• Conduct workflow, process diagram and gap analysis to derive the solution
• Determine the required implementation estimates using WBS(Work Breakdown Structure)
• Create requirements traceability matrix and prioritize requirements, create use cases, assess and validate developed solution against business requirements
• Acting as a liaison between the technical, business, testing groups to provide them with required specifications/documentation and to resolve any issues in between
• Developed smoke testing suite for pre-release testing & closely function with the team that is responsible for Smoke Testing Builds (before shipped to client) to evaluate the exit criterion
• Supported as well as coordinated User Acceptance Testing (UAT) and System Integration Testing (SIT) for production defects and new requirements
• Rendering support to client UAT cycle by triaging the client defects, estimating the defect fixes, conduct impact assessment, negotiating on defect priority if required and collaborating with scrum masters/development team to get them fixed
• Manage Dashboards to track client and acceptance issues and publish reports to stakeholders on daily basis
• Prepare release notes for the client & conduct functional demos for the product team and business consultants
• Supervising the different aspects of project like knowledge sharing of product; conducting detailed discussions with client’s Business Analyst, Test Team and Operations Team to understand their business and share knowledge on organizational product.

• Risk Dashboard tab in BMD is having all FA’s data who is having Risk metrics
• This risk is divided into two parts account level and FA level
• Here we are verifying the FA’s data and their revenue
• Being a ETL/Database tester our task is to validate the source and target table
• As part of this release I undergone with many type of testing smoke (table existence), function (record validation in source and target) testing
• I also involved in creating the SSIS packages and Loading data into target table (SQL server)
• Responsibilities/Contributions: Understanding business requirements, functional specification documents and decomposing them into testable functions
• Working with BA’s and SME’s to get the required documents and finalize the scope of our testing
• Preparation of Test Scenarios, Test Scripts, Traceability Matrix, Test Data
• Test Execution: UI testing, matching reporting table and UI with the help of SQL server, matching Teradata view records with staging table of Risk Dashboard
• Defect Management and tracking: Defects Review, Co-ordination with the onsite offshore teams (Business, Application team) during execution, Participation in Defect Meetings, Planning for retesting defects
• Preparation of Test Plan, Weekly Status Report, Execution Report.

• Support SIT/UAT Testing for CITI Bank APAC region through ITO Singapore
• I was involved as QA Test engineer for banking portfolio (Cards)
• Understanding business requirements, functional specification documents and decomposing them into testable functions
• Working with BA’s and SME’s to get the required documents and finalize the scope of our testing
• Preparation of Test Scenarios, Test Scripts, Traceability Matrix, Test Data
• Test Execution: Manual testing of Mainframe (Vision Plus) and Front-End Applications (Eclipse and CI)
• Defect Management and tracking: Defects Review, Co-ordination with the onsite offshore teams (Business, Application team) during execution, Participation in Defect Meetings, Planning for retesting defects
• Preparation of Weekly Status Report, Execution Report
• Helped the team to resolve any queries during designing and execution by coordinating with business and development team
• Attended War rooms with application team for issues which are blocking execution.