MOHAN RAJAVELU

Experience

• 

  Qatalys

  May 2006 - Sept 2011

  Assistant Manager - Quality

  Responsibilities as Assistant Manager – Quality:=======================================• Hire, train, and supervise software quality assurance staff members and report team status to QA Manager.• Develop BRD for new requirement and Update Technical Specification according to new enhancement.• Prepare Test Plan, Test Strategies, High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Status, Product Configuration Guides, Feature Matrix, Test Checklist & Client Profile documents as based on Client’s Work Orders (Change Requests)• Conduct frequent Knowledge Transfer session to Development Team.• Conduct internal weekly meetings in offshore teams to discuss all features, technical functional workflows of project.• Design, develop and implement 'Test Automation' solutions using the QTP automation tool.• Find Load Testing scenarios, Automate and execute them using LoadRunner testing tool.• Performs System, EndtoEnd, UAT testing and report the issue in VersionOne Defect Tracking Tool.• Perform preliminary testing in Production environment.Responsibilities as Team Lead:==========================• Create Interim Build releases for iterative testing using Microsoft Project Management Plan.• Prepare High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Report documents based on Client’s requirement.• Participate in Weekly Client Project Meeting and report about the current Project Testing Activity status.• Perform Sanity Testing on product’s major workflows.• Prepare Test Plan, Test Strategies, High, Medium & Low Level Scenarios, System Test Cases, Requirement Traceability Matrix, Test Checklist, Test Status, Product Configuration Guides, Feature Matrix, Test Checklist & Client Profile documents as based on Client’s Work Orders (Change Requests)ent Leads. Show less

• 

  Eversight | Making Vision a Reality

  Oct 2011 - Dec 2017

  Responsibilities as Quality Assurance - Supervisor=========================================• Participate in software requirements analysis during Sprint planning. Identify test resources, estimate test effort and define test schedule in TFS.• Design, develop and implement 'Test Automation' solutions using the Selenium Test Automation tool.• Develop SQL Query + add it in test suite to support and minimize test execution time.• Write Selenium Test Script as needed, Review Selenium Test and Execute Selenium Test. Analyze automation test report + create bug for fix.• Get release approval from Program Director, QA Manager and Product Owner, send final release notification to all end client.• Build QA and UAT environment, update configuration and complete smoke testing before giving it to client.• Collect testing signoff from all testers and create Test Completion Report for production release.• Develop Test Plan, Test Suite and Review Test Cases in Microsoft Test Manager.• Track and report testing activities, test result, test case coverage.• Prepare validation plan for each release and maintain in MTM. Show less • Participate in software requirements analysis during Sprint planning. Identify test resources, estimate test effort and define test schedule in TFS.• Design, develop and implement 'Test Automation' solutions using the Selenium Test Automation tool.• Develop SQL Query + add it in test suite to support and minimize test execution time.• Develop Test Plan, Test Suite and Review Test Cases in Microsoft Test Manager.• Maintain FDA and EBAA validation project.• Track and report testing activities, test result, test case coverage.• Prepare validation plan for each release and maintain in MTM.• Handle project maintenance by fixing minor Store Procedure, CS, SSRS, Crystal Reports changes.• Create Template Database new clients. interact with clients, collect reference and lookup data, analyze & insert data in to Template Database.• Independently write SQL queries to pull data from production and data warehouse databases for analysis. Show less

  • Quality Assurance Supervisor

    Nov 2015 - Dec 2017

  • Sr QA Engineer / Technical Customer Support Lead

    Oct 2011 - Oct 2015
• 

  Statline - A Division of MTF

  Jan 2018 - Jan 2019

  System Analyst / SDLC Project and Data Migration

  Responsibilities as System Analyst======================• Involve in software merge process. Identify gaps between two application functionality, create Database GAP analysis report.• Stage and validate 15 Eversight client to Statline, apply and validate various Web Services (XML/SOAP &REST API’s).• Execute Automation Test using Selenium Web driver with core Java and TestNG framework using eclipse as IDE.• Worked in Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle. • Validate UNOS web services to upload and import mapping in SOAPUI, analyze graphs and reports to check performance delays, network delays, CPU performance, I/O delays, database locking and other issues at the database server.• Track and report sprint team velocity.• Prepare validation plan for each release and maintain in MTM; including proof of validation for audit purpose.• Implement SOP in each release and get release signoff from Program Director and QA Director.• Validate Data Integrity and Data Migration when new functionality is introduced.• Validate database functions, procedure and triggers on need basis.• Validate data whenever data merge happens either Database to Database or Data Table to Table. • Test webservices using XML SoapUI automation tool and Database techniques.• Configure necessary hardware and operating environments as needed to complete assigned testing and support needs.• Coordinate with developer, identify impact scenario and provide automation test script for impact regression testing. • Maintain build version using Jenkin. • Lead testing tasks and ensures issues are tracked, reported and resolved in a timely manner, Identify critical issues with ease. • Test Suite and Review Test Cases in Microsoft Test Manager.• Develop SQL queries to ease test execution process.Environment: SQL, SSMS, ETL, SoupUI, Microsoft Test Manager and Lab Center, Jenkin, TFS, XML, EDI, EBAA, HIPAA. Show less

• 

  Wells Fargo

  Feb 2019 - Dec 2020

  Data Analytical Lead
• 

  First Republic

  Jan 2021 - Apr 2021

  ETL Data Lead
• 

  Quicken Loans

  May 2021 - Feb 2022

  Quality Engineer - Cloud ELT Lead
• 

  MS2 Software

  Mar 2022 - Feb 2024

  Lead Data Qa / BA

  Achievements:• Successfully ran Daily Standup within 30min; it includes Status Update, Sprint Exception Discussion and Sprint Sidebar discussion. • Complete Sprint Planning within 1hr, Sprint Review in 1hr, Backlog Refinement in 1hr and Retrospective in an hour following 15-member meeting.• I am the one QA man resource to assure smooth STLC, Scrum and CI/CD process.• Release daily changes to production after Daily Test. I am capable of handling Unit Test Errors and Deployment errors without any technical assistance. Show less

• 

  Sunresys Technologies Inc

  Oct 2024 - now

  Sr. Big Data Tester

  Source data validation:Transformation logic testing:Target data validation: Data quality checks: Data reconciliation testing: Constraint checks: Data profiling: Integration testing:Test case design and execution: Defect logging and tracking: Reporting and communication: Performance testing: Assessing the efficiency and scalability of the ETL process to ensure it can handle large data volumes within acceptable timeframes.