Avijit Mishra

• Spearheaded 30+ UAT test scenarios under the guidance of the Test Champion
• Represented the LTQ stream in Defect Triage Calls, ensuring effective communication and resolution of issues
• Executed UAT scenarios for business users, providing support and guidance throughout the process
• Served as the Subject Matter Expert for the newly developed module, DCW, offering expertise and insight into its functionality

Responsible for gathering requirements, initiating business discussions, data analysis and reporting.
Coordinating with business and client to understand their requirements and propose feasible solution.
Translate the business requirements into Software Requirement Specification and Mapping Documents
Coordinating with the Developers, Testers for providing the walkthrough of the scope changes through
Software requirement specification and mapping documents.
Working on preparing the functional/non-functional requirements package.
Guiding the technical team for data mock-up and integration.
Conducting the Post Implementation Verification for the projects worked upon.
Walkthrough of the proposed and implemented scope to the business users.
Providing extensive support for users during User Acceptance Testing.
Performing extensive Data Integrity Testing by executing SQL Statements.

• Responsible for gathering requirements, initiating business discussions, data analysis and reporting
• Coordinating with business and client to understand their requirements and propose feasible solution
• Coordinating with the Developers, Testers for providing the walkthrough of the scope changes through Software requirement specification and mapping documents
• Working on preparing the functional/non-functional requirements package
• Guiding the technical team for data mock up and integration
• Conducting the Post Implementation Verification for the projects worked upon
• Walkthrough of the proposed and implemented scope to the business users
• Providing extensive support for users during User Acceptance Testing

• Interaction with Business owners after their research and spadework for breakouts is completed
• Transforming their research and spade work notes/diagram into conceptual designs from business objectives to deliver software and applications according to specifications for usability and functionality
• Documenting business process and standard operating procedure with help of respective business owners

• Identified and resolved variances to bring LOBs data in line with requirements
• Drafted technical documents such as deviation reports, testing protocol and trend analyses
• Determined root cause of deviations and non-conforming results and implemented appropriate corrective and preventive actions throughout product development process
• Liaised between quality control and other departments providing project updates and consultation
• Responsibility of mentoring and coaching and managing team of 5 members
• Requirement elicitation and leading defect triage calls across teams
• Participating in calls where crucial decisions were taken with senior and key stakeholders
• Reviewing test artifacts prepared by team members
• Point of Contact from testing desk for co-ordination of testing activities

• Participating in Sprint Review Planning Session
• Participating in Sprint Retrospective Meeting at end of each Sprint
• Understanding Logical flow of Application from Business Knowledge
• Self-review & IQA review for Test cases and Test execution reports
• Preparing daily status report and sharing with onshore counterparts
• Estimating efforts in Jira for resources in team for items planned in Sprint
• Produced test strategy document for portfolios under test
• Leading defect management calls
• Reviewing reconciliation reports for portfolios and comparing it with quarter end regulatory reports
• Visualizing validated/reconciled reports on Qlik dashboard using drill down functions
• Coordinating weekly meeting with Onsite team for assisting in UAT support
• Reviewed bug reports and error logs, translating data into digestible reports for senior leadership personnel
• Gathered data on integration issues and vulnerabilities and reported all findings
• Collaborated with developers and product owners to stay current on product features and intended functionality
• Operated under Agile and Scrum frameworks to complete releases every 4 weeks and well-organized sprints

• Introduced Traceability matrix in project to find requirements flaws and ensured that team adheres to this process
• Client interaction for refining Defect Management Process with respect to HP-ALM11
• Assisted Architecture team in carrying out POCs' for better throughput
• Preparing test plan and test approach document
• Validating data flow from source to target and analyzing for any valid record drop using Toad (Oracle) for validation
• Preparation of functional scenarios through help of source to target mapping
• Handling complex transformation logic using SQL
• Enhanced and reconstructed SQL automation queries resulting in 30-40%increased efficiency for business end-users
• Coordinating weekly meetings with Onsite team for assisting in UAT support
• Lead weekly connect calls with client

• Performed PoC on data masking using TCSL proprietary tools for the customer in virtual private network mode
• Providing de-sensitized data for Siebel and CRM Applications
• Understanding the sensitive field types i.e., PII field categories
• Understanding the privacy regulation rules
• Understanding the different methods of data masking techniques
• Applying the in-built masking rules for PII fields, defining application-level constraints
• Creation of fake but realistic and masked data as per the requirements
• Generating the database loader scripts and loading the masked data in customer’s application
• Validating masked data by executing the business applications

• Responsible for Production environment health check and regression for basic functionality run
• Managing all virtual instances created under cloud environment comprising base OS, firewall, Network connectivity and functional testing
• Involved in executing on CLI (Command Line Interference) tool to verify creation of instance, images, storage, IP and different offerings of cloud
• Identify various scenarios for functional & negative testing
• Importing Test Cases in RQM (Rational Quality Manager)
• Executed backward compatibility test cases and regression test cases
• Acted as point of contact for status and communication reporting due to dispersed geographic teams

• Developed test scripts utilizing comprehensive business requirements, functional documentation, and processes
• Involved in analysis and posting defects in bug tracker
• Performed Load Testing on some modules (where traffic flow was high) to check concurrency of users on networking site
• Effort analysis for automated testing and manual testing
• Deciding strategy and methodology for automated testing
• Verifying points during play of games
• Evaluated and recommended test automation tools and determined suitability with various testing tools like Automation Anywhere 5.0, Neo load 3.0