Professional Summary:
A dynamic IT professional with 7+ years of rich experience in the arenas of Software Quality Assurance. Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle, Teradata and ETL. Well domain knowledge in Auto insurance, Health insurance, Telecom, Retail and Financial. Extensive experience in reviewing and analyzing Business Requirements and writing detailed Test Plans, Test Cases, and Test Scripts Experience includes the testing of Client/Server, ETL, SOA and WEB applications using Manual and automated testing tools like Selenium, Quality center, Rational Suit, Load Runner and Quick Test Professional. Experience on Test management tools like TMS, Quality Center and Test Director. Expertise in implementing RUP (Rational Unified Processes), Agile and SCRUM Methodology by analyzing requirement specifications and responsible for developing Test Objective, strategies, Scope, Test procedures and Test Matrices. Extensive experience in conducting different kinds of tests such as Integration, Regression, Functional, System Testing, Black Box, UAT and Sanity Testing. Experience in working with scenarios related to Banking, and finance Web portal applications Experience in leading the testing effort for Mainframe, COBOL, java, J2EE, .NET applications. Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc. Sound knowledge of java application testing, quality centre, and mainframe application testing Extensive knowledge of mainframe tools and techniques as well as Unit regression testing Comprehensive knowledge of mainframe programming, test plan, regression testing, and techniques Extensive expertise in Business Intelligence and Enterprise Application Integration. Expertise in Back end database testing with database Oracle, DB2, and SQL Server. Proficient in executing SQL queries and strong in security backend testing. Excellent Scripting Knowledge of Mercury’s “TSL” for Win Runner, and VB Script for QTP. Excellent working knowledge of designing and implementation of QA test strategy and Test plans manually and automated test solutions for client/server, ETL, SOA Process, ERP and Web applications. Knowledge in testing SOA Architecture, Web Services, UDDI, Network protocols (VOIP, TCP/IP) and IVR system testing. Well in testing of the web services using the SOAPUI and PARASOFT SOA testing tool. Worked with the build/release management teams to validate the system setup and configurations at pre-deployment stage. Experience on Object Oriented Programming (OOP) like C#.NET, Java, using Eclipse, Visual Studio Team Systems e and Visual studio with Back end as Oracle and SQL Server. Good verbal and written communication skills. EDUCATION:
Bachelor of Technology Technical Skills:
Testing Tools
Selenium, QTP, Win Runner, and Load Runner
Defect Tracking Tools
Quality Center, Test Director Rational Clear Quest, JIRA and Bugzilla, Run Test Run
Project Methodologies
Rational Unified Process, OOD, UML, SDLC, Waterfall, Agile
Languages
C, C++, JAVA, J2EE, JSP
ERP
Siebel 8.0
Health Care Tools
FACETS
Data Base
Oracle9i/10g, SQL Server, DB2
Scripting Language
VB Script, JAVA Script, HTML, DHTML, UML and XML
Operating Systems
Windows 2000, 2003, XP, Home, Vista and UNIX
Protocols
TCP/IP, HTTP and HTPS
Application Servers
Web Services, Web Logic and Web Sphere
Version Manager
Visual SourceSafe, PCVS and Clear Case
Browsers
Internet Explorer, Nets Cape Navigator, Mozilla Fire Fox, VMware
Others
MS Office, MS Excel, Visio and Adobe, Microsoft Visual Studio2005 and 2008
Professional Experience:
Client: Confidential,Chattanooga, TN Aug’12 – Till Date
Role: Sr. QA Automation Tester
Key Responsibilities:
Interpret application architectures and identify areas for automation. Actively involved in automating test cases using QTP Parameterized test scripts in QTP to pass data from different data sources like Excel spreadsheets, XML files and database. Performed data-driven testing by developing data-driven tests to validate the same test with multiple sets of test data. Developed complex VB Script Functions and Keywords as part of automation framework. Created Shared Object Repositories, Re-usable Actions, Recovery Scenarios and User Defined Functions that can be used in other Automation Scripts. Prepared Automation Test Strategy and assist the Testing Team with on-going Automation Test Execution from Quality Center. Design and implement the best practices and ensure that new code uses our framework and coding practices Used data-driven testing and database accessing techniques during automation scripts development Created and maintained automated tests using QTP by coding in VB Script. Developed custom QTP function libraries (like Object Oriented Functions, Database Functions, and Utilities etc). These functions are application independent and platform independent that can be used across multiple projects. Developed a comprehensive Automation Regression Suite that is executed at the end of each sprint. Test Execution and Scheduling from Quality Center. The test execution is unattended with no manual intervention. Execution of smoke tests on each build using QTP and reporting the results to management Performed integration testing & data validations using QTP for various interfaces. Performed database testing to test data migration from different test environments. Test data mappings and changes as per the requirements. Developed utility scripts in QTP to export data from different database tables to Excel. Developed workarounds for many of QTP challenges by writing VB Script functions. Environment: Quality Center 11.0, Quick Test Professional 11.0, FACETS, Genesis, oracle 10g, Visual Studio, ASP.NET, HTML, C++, VB.Net, JavaScript, IE, web sphere, web services, UNIX, LINUX, and Windows2000.
Client: Confidential,Cincinnati, OH Feb’12 – July’12 Role: Sr. QA Automation Tester
This Project involves creation of automation framework using selenium and testing, supporting more than 10 agile testers in creation of automation test scripts and execution. We used selenium IDE, selenium RC, selenium Web driver and selenium GRID to execute scripts on multiple platforms and multiple browsers.
Key Responsibilities:
Reviewed and Analyzed the System Requirement Specs and understand the control flow of the whole system. Follow the Agile methodology due to the continuous change of requirements. Performed Ad-hoc/Exploratory testing prior to automate the testing on the application. Developed re-useable code to share functionality with different tests, thereby providing easy to maintain. Created functional automation scripts using open source tools selenium(selenium RC, Grid) Actively participated in writing Test Plan and Test cases and creation of automation framework. Participated in peer reviews of all the documents and Test Cases Worked with deployment team to create nightly automation regression execution builds. Trained and helped other testers on selenium tools. Created test scripts (Selenium) to monitor response time in development phase. Changed my roles based on agile testing needs.( manual testing, automation, load testing) As a tester, I ensured that daily automated regression testing is running & completing successfully. Worked closely with the developers within the scrum team. Tested web services using SoapUI. Used selenium RC,IDE and web driver ,Java and Selenium Grid to create nightly automation scripts Created selenium automation scripts in Java. Involved in creation of automation framework using selenium. Configured Selenium RC and Selenium GRID on CART machines. Supporting agile testers in creation of test scripts. Common approach for cross platform and cross browser testing. Experience building and maintaining a Selenium Regression test suite. Involved in Tool Evaluation Process. Reviewed the Selenium Scripts developed by the team members Used Excel to create data driven and keyword driven scripts. Involved in setting up the Testing lab for the Automation system. Framework to be reused for future versions of the project. Written shell scripts to execute test scripts on batch process. Environment: Quality Center 9.0, Selenium 2.21.0 Selenium IDE, Selenium RC, Selenium Web Driver, Eclipse, Jasper, JACOB, AutoLtX, REST, Quick Test Professional 8.0, Load Runner 9.50, oracle 9i, JUNIT, ASP.NET, HTML, , JavaScript, IE, web sphere, web services, UNIX, LINUX, and Windows2000.
Client: Confidential,Minneapolis OCT 10 – Jan 12
Role: Sr. QA Engineer
RX Transport: RX Transport (DR. Transport) is the graphical interface (GUI) for ticketing for national repair. Primary users are the call center operations technicians in Century Link national repair centers. I worked with other applications OTTO, NECT, NGSA, DCT and ICL.
Key Responsibilities:
Analyzed and reviewed business requirement documents (BRD’s) and system requirement specification documents and functional design documents. Involved in performing day to day testing of product updates and releases Responsible for creating or setting up any test data that is required for every release by coordinating with 10 different backend systems. Automation of the job flow and scheduling the jobs in Control-M Actively participated in writing Test Plan and Test cases Participated in peer reviews of all the documents and Test Cases Tracking software defects and routing them to the right person/team found in the applications while testing. Main contact between Development team, Business Analyst Team and our offshore resource Well versed in covering all the test scenarios because of the strong Domain Knowledge Conducted database testing using SQL queries Used Quality Center for organizing test requirement documents, test plans, test scripts, and defects Interacted with Developers and Business Analyst regarding requirements, test scenarios and defects Used Mercury Load Runner Controller for simulating multiple Vusers for performing load test Well versed, working knowledge of Voice over Internet Protocol (VOIP) and TCP , IP configuration and of Session Initiation Protocol (SIP) testing in multi-node LAN AND WAN environment. Assigned responsibilities of testing functionalities of IVR systems,VOIP and prepare test scripts to support the testing process Performed the tasks of speech quality analysis and speech path verification under the guidelines of senior IVR tester Using set top boxes monitoring the speed control and verify the logs. Performed responsibilities of integrating network in IVR systems as required Working on several different projects simultaneously Coordinated with Team Lead/PM/Business Analysts for QA Sign off for Test Cases/Test Plan. Participated in review meetings and daily status meetings during the testing process Extensively involved in manual functional testing. Created use case scenarios and documented work flow and business process Delivering project Technical Demos to clients and participating in business calls During the Beta Cycle worked with the END Users (in the PHEONIX, DES MOSINES, SALT LAKE CITY call centers) on daily basis for any issues faced by them and train them on the application. Participated in the User Acceptance Testing with the clients for every release Environment: Caliber (Requirements Management Tool), Quality Center 10, Knowledge Q, Bus tester, SOAP, Load Runner 9.52, SSH/PUTTY, Drools (For generating the flows), Tibco Bus Services, J-Meter, Toad, Oracle 10G, VOIP,SIP, Set top box(STB),Control M, MicroStrategy, Unix Shell Scripting, DB2, IVR Systems, database, QSDP.
Confidential,Richfield, MN JAN ‘10-SEP ‘10
Role: Sr. QA Engineer
Best Buy for business is an internal body of best buy which deals with government and private insurance partners like state farm, HSBC settlements .Prices for the skus, from the fulfillment partners will be loaded every day into the database. The system handles Data load, in store shipping issues and maintains data to be used for running Daily Reports which is very critical for the decision making and strategy planning by the top level management.
Key Responsibilities:
Analyzed and reviewed BRD, SRS, FRS, TRS documents to design quality test cases. Involved in generating Requirements Traceability Matrix (RTM) for functional requirements. Participated in peer reviews of all the documents and Test Cases. Involved in executing test cases manually and reported defects using Quality Center. Effectively interacted with business analyst and technical team in providing clear solutions to requirements. Designed test cases using Test Plan in Quality Center and mapped with requirements. Involved in execution of test cases using Test Lab in Quality Center and linked the detected defect with requirements and test cases. Generated test scripts using Quick Test Professional to check the functionality of the system. Involved in unit, integration, system testing of the application using Visual Studio Team System. Used Microsoft Visual Studio Team System (Team Test Load agent) for load testing using MOSS 2007 and the results were stored in the Team Foundation Server warehouse, and which can be linked to builds and performance testing using Performance centre, can be tracked over the lifetime of a project. Linked detected defects during automation to requirements and test scripts using Quality Center. Actively participated in status meetings to report issues. Generated scripts using Load Runner to measure the performance of the system. Performed web testing using Quick Test Professional to check the compatibility, reliability, and scalability of the application in different browsers. Used selenium RC,IDE and web driver ,Java and Selenium Grid to create nightly automation scripts Created selenium automation scripts in Java. Involved in creation of automation framework using selenium. Configured Selenium RC and Selenium GRID on CART machines. Involved in system and User Acceptance Testing. Documented test procedure documents and test results using Quality Center. Performed gap analysis by comparing actual result with expected result. Conducted database validation using SQL queries. Closely interacted with clients, developers, and system engineers to identify application defects, reviews, and follow ups. Environment: Quality Center 9.0, Selenium IDE, Selenium RC, Quick Test Professional 8.0, Load Runner 9.50, oracle 9i, JUNIT, Visual Studio, ASP.NET, Perl, HTML, C++, IIS, VB.Net, JavaScript, IE, web sphere, web services, UNIX, LINUX, and Windows2000.
Confidential,Florida SEP ‘08-DEC ‘09
Role: ETL QA Tester
Project: Automated Financial Systems (AFS) is a major Commercial Loan Systems in Citibank. It is an online processing system but handles batch processing when necessary. Level III allows the design and delivery of new loan products to maximize the profit potential and processes and reports on both currentand future obligations.On each obligation,earnings methods are provided for both interest and fees. Multiple accruals of interest and fees can alsobe done on various balances.The system calculates and reports on all non-refundable fees that are amortized over the life of the obligation. Various methodsPayments, waivers and Reversals are provided. Being a Test Lead involved AFS Module Deliverables.
Key Responsibilities:
Involved in requirement analysis and documentation of functional specs. Identified Test Scenarios for required system and functional testing. Provided support in the preparation of Test Plan specifying an overview of testing approach, testing strategy, and scope. Developed Test Cases as per to the Requirement Specifications. Responsible for testing all new and existing ETL data warehouse components. Experienced at testing ETL\'s and flat file data transfers without relying on a GUI layer Worked with the components of Data Warehousing like components model, ETL tools. Tested Abinitio graphs for File to Table and Table to file conversions required for EBCIDIC format and XML files. Maintained the Requirement Traceability Matrix using Mercury Quality Center. Executed test cases and test scripts manually and using automation tools. Performed Functional, Regression and Integration testing. Involved in unit, integration, system testing of the application using Visual Studio Team System Used QTP and RAID automation tools for Functional, Regression and Data Driven testing. Used SQL tools such as SQL Query Analyzer for creating SQL queries to verify the integrity of the data. Performed extensive back-end testing and database auditing using SQL Server. Used Quality Center as a release management tool. Provided production support for the releases. Used Mercury Quality Center and JIRA to house all test documentation, report/track all issues and defects. Provided clear concise feedback to development team on recurring errors both on an individual and team basis. Environment: QTP, Load Runner, Quality Center, Cognos8BI, SQLServer2005, .Net, COBOL, JCL, CICS, DB2, Rumba, QC8.2, VSS, Windows Vista/XP and Informatica Power Center 7.1.2.
Confidential,Sterling, VA AUG‘07-SEP ‘08 Role: QA Engineer
KPHCBS processes billing details for very large customers who like to have their invoices in their specific formats. It handles about 30 products like HMO, PPO etc. serviced by KP subsystems - KPHCS Reporting system, Billing Statistics Database, Claims and Payments. Also creates Daily, weekly and Monthly Detail/Summary Reports. Also feed the data to financial data warehouse and Data Marts for Analysis & reporting.
Key Responsibilities:
Created Data extracts from Auto Adjudicated Claims. Attending walkthroughs with SA’s and BA’s for scope and approach of the project initiatives. Created DB2 /SQL queries in QMF and File-Aid for data analysis and result checking. Analyzing Business Requirement documents and Functional Specification documents. Communicating release test requirements to User Acceptance Test team. Creating a comprehensive test plan and writing test cases. Quality Center for Test Planning and execution and to create a structured workflow of Test Cases. Executing the test cases with positive and negative data. Providing status reports to Release Manager. Checking for the user Interface of the application like the tab sequence, field data acceptance. Checking the database by writing the SQL Queries to check whether data is correctly storing in the data base or not. Checking the database catalog to get the information about the data type of the fields. Regression testing to see the major functionality of the application is Unchanged with code fixes etc. Doing Quality Assurance documentation, streamlined processes and reporting technical problems to technical team. Developed test scripts for GUI applications using Win Runner and automated test scripts for the regression test. Developed and maintained test data matrix, test case library and reported test status to test manager Checking back for the coverage of the business requirements. Creating and Executing of the system test plan to check the dependencies between the screens. Communicating errors to release managers and Re-testing the errors. Environment: SAP, JAVA, Oracle 9i/10g, PL/SQL, TOAD, Business Objects, MS-SQL server, DB2, JCL, QMF, File-Aid, Crystal Reports, Windows-2000, EPIC, Quality Center.
Confidential,IL Aug ‘06-Jul ‘07
Role: QA Tester
Allstate insurance has an agency web portal from the agency web portal we apply for the new proposal. Once submitting to the Allstate insurance, we need to verify the proposal is properly mapped to Allstate insurance is e-commerce web Application and once it is there on Allstate insurance web portal we need to verify all the data is mapped to the respective fields in the web application and need to verify the premium amount for that policy.
Key Responsibilities:
Reviewed and Analyzed the System Requirement Specs and understand the control flow of the whole system. Follow the Agile methodology due to the continuous change of requirements. Performed Ad-hoc/Exploratory testing prior to automate the testing on the application. Developed re-useable code to share functionality with different tests, thereby providing easy to maintain. Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web applications with Quick Test Pro. Administration and Automation framework implantation in QTP Excellent Descriptive Programming Knowledge in VB Script for QTP writing the functions from scratch. Develop all required test plans for each release of the software product. Performed Business Processes Testing (BPT) for typical Functionality. Review and approve test cases written by other QC staff members prior to execution Ensure thorough and documented traceability from test cases to design / requirements Write, present/distribute and maintain testing documentation; including release notes, release forms and other necessary testing reports Execute test plans against new software development, including functional testing, regression for the continuous change of price and discounts for different states and performance testing activities. Involved in database testing in writing the queries in SQL server in SQL Enterprise Manger. Developed and executed SQL queries to verify the data Integrity. Interacted with Database Developers during testing, isolated at different levels of Database Testing. Coordinate all quality control defect management and root cause analysis activities. Work with Professional Services to identify defects in products in the pre-production or production environment and posted in the team foundation server(TFS) When identifying defects, make recommendations to prevent future similar defects. Analyze defects looking for and documenting patterns to identify commonality. Assist Sr. Quality Control Test Manager in measuring the effectiveness of the testing effort by tracking trends in defects, requirements, test cases and recommending changes to continuously improve the quality control / testing process Perform the functional testing of web services using soap scope. Build and maintain the Quality Control environment(s) of installed on various desktop computers. Configure, maintain and control all test tools; including Quality Center, Quick Test Professional. Function as the lead tester / mentor for Automation and other assigned testing projects. Create the test environment for the all the flavors of windows and Mac operating system Provide expert analysis and acquisition of testing tools for the Quality Control team. Effectively communicate test considerations, defects, process initiatives, and general status of projects to the Quality Control staff, functional management and executive management. Perform Load and Stress Test By creating V users using Load Runner Used Quality center to log defects and generate defect reports and graphs. Perform the UAT and Implementation testing of the application. Actively participated in enhancement meetings focused at making the application more reliable. Monitored Quality Center to close the bugs/cases as and when developers fixed the bugs. Environment: Quality Center 9.0, QTP 8.2,TFS, Load Runner 9.0, JIRA, .Net Framework 1.1 ASP.NET,C#.NET, AJAX, XML, ,PHP,HTML,CSS, SQL Server 2005, SSIS, SSRS, SSAS MS Excel, UNIX, Windows XP, MAC OS and MS office.
Privacy Policy
