Senioe QA Engineer
Resume:
ARUNKUMAR VENKATRAMAN
**** **** ***** ******, *** 2107, San Jose, CA – 95134
*********.***********@*****.***
A graduate in Electrical & Electronics Engineering with strong experience in various Test Methodologies and Processes. Having been extensively involved in various User Acceptance Testing, Functional Testing and System Integration Testing for Financial, Human Resource and Automobile domain involving analyzing requirements, writing and executing test plans, designing test cases and procedures, preparing test data, setting up test environment, creating defect documentation, requirement traceability matrix and test summary reports.
ISTQB Certified Test Engineer with more than 9 years of QA experience in Black-box testing in BFSI, Automobile and HRM vertical
Managed teams of up to 15 QA Engineers
Exposure to Onsite-Offshore work model involving day to day activity planning, guidance, defect review and coaching
Good hands on knowledge of SDLC methodologies
Exhaustive experience Software testing processes - Test Initiation, Test Planning, Test Execution and Test Closure activities
Lead various Functional, User Acceptance Testing, System Integration projects involving Data Migration testing, Data Warehouse & ETL testing, Reporting and Business/Data Analytics projects and bringing them to successful closure
Acquired sound skills in testing methodology - Preparation of Effort Estimation, Test Plan, Test Scope document, Test Scripts, Data guidelines, Run plan, Day-Zero checklist and Test Execution involving End to End Defect Management
Facilitated Joint Application Development (JAD) Sessions to identify and analysis business needs and technological improvements by coordination with business users and IT teams
Involved in Gap-analysis to bridge the gap between the BRDs and FSDs, Impact Assessment and Risk Analysis
Developed quality assurance standards, processes, procedures and documentation templates
Expertise in using Test/Project Management tools like JIRA, Rally and HP Quality Center/ALM
Effectively projecting the Project/Program tracking to reflect clear Project/Program status to various stakeholders
Prepared various SOP documents streamlining critical procedures
End-to-End Defect Management – Logging defects, co-coordinating with the Business and development teams to track them to closure using Test Management tools like HP Quality Centre/ALM and Rally
Proficient in writing SQL queries and understanding SQL Tables, SQL Procedures and Data Schema.
Hands on experience in Data Warehouse testing, Cognos BI Reports testing and Salesforce CRM testing
Experience in ETL tools like Informatica PowerCenter and Sungard BDI
Highly responsible and reliable team leader with strong analytical problem solving skills and initiative in decision making
Exposure to Keyword driven approach in HP QTP
SUMMARY OF EXPERIENCE:
Tesla Motors Inc: Sr QA Engineer/QA Lead (Apr ‘14 till date)
ADP Inc.: Sr QA Engineer/QA Lead (Apr ‘13 – Mar ‘14)
Thinksoft Global Services: QA Lead, Business/IT Systems Analyst, Senior Test Engineer, Project Management
(Aug ‘06 – Mar ‘13)
Infosys Technologies Ltd: Software Engineer (Aug ‘05 – Feb ‘06)
TECHNICAL SKILLS
Platform
Mainframe, .NET, Web based Applications
Defect Tracking Tools
JIRA, Rally, HP Quality Center /ALM
Databases
SQL Server 2008/2012, Oracle 11g, 10g, 9i, MySQL
ETL and Reporting Tools
Informatica (PowerCenter 9.1), Sungard BDI,Cognos 8.0
MS Suite/ Project Tools
MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project
Operating Systems
Windows – 7, Vista, XP, NT, 2003, 2000, 98, Mac OS, iOS
Web Service Validation tools
SoapUI
Methodologies
Agile (Scrum based), Waterfall
CRM
Salesforce CRM
Domains
Manufacturing & Production, Human Resource Management, Mortgage, HELOC, Leasing, Cards& Payments, Core Banking, Insurance, Corporate Treasury
Certifications
ISTQB Foundation Level
DETAILED EXPERIENCE:
Tesla Motors Inc – Sales, Marketing and Services
Client : Tesla Motors Inc., Fremont, California
Environment : Web Application and Microsoft SSMS, Salesforce, Agile Model
Duration : Apr ‘14 to Jan ‘16
Role : Senior QA Engineer/QA Lead
Responsibilities:
Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing the test cases, test scripts
Worked with Business Analysts to define testing requirements to satisfy the business objectives
Efficiently managed multiple projects simultaneously under crunched timelines
Responsibilities include meeting the developers and client groups to determine performance requirements and goals and to determine test strategies that is based on requirements.
Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements
Collaborate with Business, Development Team to ensure effective project execution
Organize and attend review meetings and walkthroughs to understand the requirement documents and the application.
Trained team members to implement good testing practices and test methodologies
Extensively involved in Functional, Regression, User Acceptance, Interface System testing, Data Integrity, Compatibility and End to End Testing
Hands on experience in CRM Salesforce and ensure data correctness during handoff to various ERP systems
Data correctness check across DB and Salesforce
Validated dynamic data inserted to the Database using SOAPUI
Prepared Test Data for all the possible scenarios and validated the same across the Source Systems and Data Warehouse
Extensively used SQL queries on MS SSMS to validate data
Validated data flow from Source system to downstream systems
Experience in generating various Salesforce reports
Involved in Testing Change Requests (CRs) to enhance the existing code and various AD-hoc and Maintenance tickets
Coordinate with Development team and Business during Execution for defect resolution
Involved in Root Cause Analysis for the defects found
Prepared Process/Quick Reference documents detailing SOPs
Reported the daily Planning and Execution progress
End-to-End Defect Management using JIRA
Interviewed and hired QA Engineers
Conduct KT sessions on a frequent basis to all team members to facilitate cross module training
Automatic Data Processing (ADP) Inc., Analytics and Business Intelligence
Client : ADP Inc
Location : Roseland, New Jersey
Environment : Web Application, Oracle Server, Cognos Reports, Agile Model
Duration : Apr ‘13 to Mar ‘14
Role : Senior QA Engineer/QA Lead
Responsibilities:
Involved in Agile Planning wiz, Sprint Planning, Effort estimation
Actively participated in Sprint Review and Retroactive sessions
Involved in Backlog meetings to decide the tasks to be included in the following Sprint
Worked with Business users to understand the underlying logic of various Key Performance Indicators (KPIs) underlying reports for Data Analysis.
Create Tasks in Rally to highlight the QA activities involved against the User Stories as part of the Sprint
Preparation of Test Plan, Test cases, Test Data prior to commencing execution
Finalize the test environment needs to commence QA execution
Participate in daily Scrum Calls to highlight any bottlenecks encountered and review the defects raised to module owners
Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
SPOC to commence ETL workflows in Informatica and Data extraction requests
Extraction of test data from tables and loading of data into SQL tables.
Coordinate with Offshore team on a frequent basis for Daily activities planning, Status tracking and KT sessions
Good hands on testing experience in working with SQL Stored Procedures, views
Wrote several complex SQL queries for validating Cognos Reports
Single handedly worked on implementation of Security on ADP Analytics
Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping Document
Worked with business team to test the reports as part of UAT
Responsible for validating Cognos BI Reports and extracted data from various sources like Oracle DB, flat files and load them to Stage using Informatica PowerCenter
Tested various complex Web reports with multiple data providers and source systems
Responsible for preparing the technical specifications and Source to Target mappings
Involved in Data mapping specifications to create and execute detailed system test plans
Extensively used SQL programming on Toad to validate business rules
GE Corporate Treasury – Interest Rate Risk Management
Client : GE Corporate Treasury
Location : Stamford, CT
Environment : Oracle Server, Sungard BDI, Waterfall model
Duration : Sep ‘11 to Mar ‘13
Role : QA Team Lead
Responsibilities:
Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing the test cases, test scripts
Lead and managed multiple simultaneous projects
Facilitate Joint Application Design (JAD) sessions, review requirements and drill down to details. Work with key stakeholders from various departments to ensure ideal solution that meets all requirements.
Hands on experience in Onsite-Offshore model
Preparation of Master Test plan stating the strategy involved prior to execution commencement
Developed Test plan, Test cases, Day Zero checklist, as part of Test Planning phase to ensure smooth Test Execution
Analyzed the Business Requirements documents to break them down to testable components
Prepared and reviewed Test Plans and Test cases for various projects
Coordinate with Client, Development, Support and the offshore teams during both the planning and execution
Performed Smoke Testing and Execution on test cases as part of Functional and Regression Testing
Maintained and update test schedule and assigned tasks on a frequent basis
Finalize the test environment needs to commence QA execution
Initiate and monitor data loads during test execution using Informatica PowerCenter and Sungard BDI Conductor
Validation of Middleware (Tibco) to ensure data integrity
Maintain and manage Testware in HP ALM
Traceability Mapping of test cases/functionality to the defects logged in HP ALM
Track execution progress using built-in and Custom reports in HP ALM
Defect Reivew on a daily basis
End to End Defect management in HP ALM
Conduct Defect meeting between the Business and the Development team on a regular basis
Publish project status to stakeholders using MS Project 2010 on a regular basis to highlight the QA progress at a Program level
Responsible for offshore resource management based on the project needs
XL Insurance
Client : XL Insurance
Location : Hartford CT
Environment : Oracle Server, Informatica, Waterfall Model
Duration : Aug ‘11 to Aug ‘11
Role : QA Team Lead
Responsibilities:
Review of Testware prepared
Finalize the test environment needs to commence QA execution
Coordinate with Client, Development, Support and the offshore teams during both the planning and execution phase
Defects review during test execution
Extensive Defect Management in HP Quality Center
Chair and conduct Status and Defect calls
Attending Daily & Weekly status meetings with client and Program level
Track the execution progress on a daily basis and provide status report to the stake holders
Project Plan update and tracking using Microsoft Project 2010 at program level
Involved in various Adhoc QA execution activities
LBG – Starlight Migration GENESIS TS2 External MasterCard Build
Client : Lloyds Banking Group (LBG)
Location : London, United Kingdom
Environment : Mainframe Application [VisionPLUS 8.23, TS2], Waterfall model
Duration : Mar ‘08 to Jul ‘11
Role : QA Team Lead/Business Systems Analyst/Data Engineer
Responsibilities:
Lead a team of 15 Test Engineer (Onsite and Offshore) providing day to day planning and guidance
Efficiently managed multiple projects simultaneously under crunched timelines
Developed quality assurance standards, processes, procedures and documentation templates
Lead the team of 3 QA Engineers at Offshore to provide test data to Business units to facilitate their UAT projects based on the domain knowledge with near to zero bad data rating
Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing the test cases, test scripts
Worked with Business Analysts to define testing requirements to satisfy the business objectives
Created comprehensive test plans, test cases, automated scripts based on the System Requirements, Business and Technical Specifications
Prepared and reviewed Test Plans and Test cases for various projects
Extensively involved in Functional, Regression, User Acceptance, Interface System testing, Data Integrity and End to End Testing
Responsibilities include meeting with the developers and client groups to baseline the requirements and goals and to determine test strategies that is based on requirements.
Collaborate with Business, Development Team to ensure effective project execution
Trained team members to implement good testing practices and test methodologies
Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements
Finalize the test environment needs prior to commencement of execution
Conduct KT sessions on a frequent basis to all team members to facilitate cross module training
Involved in Testing Change Requests (CR) to enhance the existing code and various AD-hoc and Maintenance tickets
Attend review meetings and walkthroughs to understand the requirement documents and the application
Coordinate with Development team and Business during Execution for defect resolution
Involved in Root Cause Analysis for the defects found
Prepared Process/Quick Reference documents detailing SOPs
Extensive Defect Management in HP Quality Center
Responsible for managing the resource counts on the dynamic project requirements
Setup up Status meeting on a daily basis with Client to project the Execution progress
Prepared training presentations and provided application walk through to the Clients and Business users
Prepared Quality Management System (QMS) related documents such as Project Performance Report, Team Access Matrix, Customer Property Logs, Review Logs, and Time Sheet
GE Money – E-Service Probe Loans
Client : GE Money Bank
Location : Chennai, India
Environment : Mainframe Application [VisionPLUS 8.17], Waterfall model
Duration : Aug ‘06 to Feb ‘08
Role : IT Systems Analyst, QA Engineer
Responsibilities:
Documented As – Is process and To-Be Process to perform Gap Analysis
Documented business workflows in UML diagrams (Activity Diagrams) for the stakeholder review.
Worked directly with end-users to collect data, specified technical requirements and created Use case documentations and process maps to address sales, accounting, administrative and maintenance department needs.
Assisted in Validating business rules, process improvements, and UI designs with clients.
Performed complex analysis of the business requirements from the end user and used UML diagrams to convert them to System Specification Requirements.
As a liaison between the developers and end users, was instrumental in communicating user requirements and system requirements among the teams.
Facilitated collection of Functional Requirements from system users, and prepared Business Requirement documents.
Tracked and maintained Stakeholder requested enhancements and changes using Traceability Matrix.
Worked with the end-user application development team during JAD sessions to do a requirement walk through and reviewed the Business and Technical Requirements
Designed use cases and analyzed them to suggest improvement techniques
Preparation and Execution of testware based on the various Use Cases provided by the client
Extensive Defect Management in HP Quality Center
Co-ordination with the client and the development team on the defect raised and track them to closure
INFOSYS TECHNOLOGIES LTD – SOFTWARE ENGINEER AUG ‘05 TO FEB ‘06
Worked as a Software Engineer for Reebok under Retail vertical.
EDUCATION
Graduated with a First Class degree in Bachelor of Electrical & Electronics Engineering (BE, E&E) in 2005 from Visvesvaraya Technological University (VTU), Karnataka, India.
Contact this candidate