SUMMARY

• Over 13+ years of professional QA experience and working as Lead with strong expertise in Performance/Load/Stress testing, Automation and Manual testing.
• Solid experience in Web services testing, UI testing and application security testing.
• Good experience in Automation using HP QTP/UFT, Selenium IDE, Performance Testing using several protocols likeWeb HTTP/HTML, AdobeFlex, AMF,Web Services, Citrix and Database applications, Client/Server - browser-based and Middleware application environments.
• Hands on Monitoring the Resource usage of Web Servers, App Servers, Database Server using different types of monitoring tools during Performance testing.
• Performed System Testing includingFunctional, User Acceptance, End to End, UAT Regression and also performedautomationandPerformanceTesting using software testing tools such as QTP, LoadRunner, JMeter and test management tools like Quality Center, ALM, JIRA.
• Good experience in Defect Test Management Life Cycle, Defects severity, priority assignment, creating Master Test Strategy documents, Test Planning, Test cases preparation, Test cases Execution, Defect Management.
• Proficient in Various RDBMS like Oracle 11/10G, Teradata v 11, DB2 UDB, Sybase ASE, IBM DB2, MS SQL Server, MS Access, PL/SQL, Python, Unix Shell Scripts, Data warehouse testing verifying and validating the ETL Mappings, Audit Trail, Slowly changing Dimensions, Stored Procedures, and OLAP Reports testing and BI Dashboards testing.
• Performed Data Analysis, heavy data Profiling using custom SQL queries and PL/SQL packages, designed Data validation routines using precise SQL (Analytic functions, Aggregate, In-line views), Join predicates, PL/SQL, Ad-hoc summary reports using OLAP functions and Oracle Analytical functions.
• Have good expertise in maintaining Test Matrix and Requirement Tractability Metrics RTM.
• Strong aptitude in implementing Performance Standards and Testing Methodologies for Large Enterprise GUI and Web Applications using Use Case Documents, Functional Specifications and Business Requirements.
• Good Team player possessing good inter-personal, strong analytical and problem-solving skills, communication skills, presentation skills, committed to deliver quality results on time.

TECHNICAL SKILLS

Test Management Suite / QA: HP ALM, Rally, HP QC, Rational Clear Quest, Mercury Test Director, JIRA

Automation Testing Tools: QTP 8.2/9.x, Selenium, LoadRunner8.x/9. x/11.x, SoapUI Pro 4.x, JMeter 3.3

Protocols: HTTP, HTTPS, SOAP, .Net, Web Services, Flex, TCP/IP, and MQ Series

Languages: UNIX Shell scripts, Python 2.x, Java, JavaScript. C, Perl, VB, VB.net, SQL, PL/SQL, HTML, Java Script, Dreamweaver, FLASH 5.

RDBMS: Teradata 15/13, Oracle 11/10G,Sybase ASE 12.5, DB2 UDB, MS SQL Server, MS Access

Data Warehouse: Informatica Power center 9.x/8.x, Ab Initio GDE (1.13), SSIS Tableau, SAP Business Objects XI, IBM Cognosv8, QlikView v 11, Actuate, SSRS

Software Engineering Methodologies: Agile, Waterfall.

Domains/Verticals: Banking, Finance, Healthcare, Telecom

PROFESSIONAL EXPERIENCE

Confidential

Performance Test Lead

Responsibilities:

• Prepare the Performance Test Plan and Test Scripts HTTP HTML // Click Script Protocol, software documentation from business, technical and functional requirement.
• Creation of Performance Test Data and scenarios based on the real user experience.
• Responsible for creating the performance test plan, test strategy document, managing performance test scheduling and logistics, after reviewing and verifying performance requirements. Includes analysis, reporting and presenting performance test results to stakeholders.
• Created and performed webservices testing scenarios using SOAP UI Pro.
• Executed Load Runner/JMeter scenarios based on complex business scenarios with different monitors for Stress testing, Scalability testing, Failover testing, and Load testing.
• Monitoring of Web Server//Application server Database Server and Reporting of issues found during the load testing.
• Benchmark testing for the application based on performance testing results.
• Prepare, populate control tables, Execute Informatica Workflows to complete Data Load for testing.
• Performed deployments to the performance server based upon performance needs using Jenkins.
• Performed network and security design and the implemented in the performance test environments.
• Performed Volume, Performance, Load and Stress testing using Load Runner.
• Extensively worked onJMeterto create Thread Groups and test Web Application for various loads on key business scenarios.
• Developed Performance test cases and verified actual results with expected results.
• Reviewed the Performance Test Designs with QA team members and technical analysts.
• Performed Integration, System, and Functional testing Under Peak Load as per requirements.
• Provide weekly updates to the client and application team based on the test results and analysis.

Environment: HP ALM, Unix, JIRA, Tableau, Web Services, Selenium, LoadRunner, JMeter, Java Script, XML, Jenkins, Adobe Flex, AJAX, Jscript, MS Office Tools, Java, SOAPUI, HTML, DHTML, WebLogic 10.x, HP Performance Manager

Confidential, Minneapolis, MN

Performance Tester/ DWH /Automation

Responsibilities:

• Identify the functional & Technical requirements in UI/DWH/Reports streams for MIDE, test environment, data adequacy in non-production environments, public data ingestion for distance and cost of living indices.
• Leading a team of 8+ members and responsible for developing test strategies with test engineers, developers and database team members, test planning, estimation, test cases allocation, defects review and closure, daily scrums with onsite/offshore teams.
• Understand the business requirements, participating in JAD sessions with client Business/Technical teams, study requirements and design specifications to prepare test plan document, test coverage planning, test plan walkthrough, present DQ strategy and outcomes to business/IT stakeholders for approval.
• Responsible for Data analysis, Data profiling, Data quality fit-gap analysis, business rules, data mapping specifications, DQ testing tool, precise SQL queries to test source to target data, DQ results dashboard and testing approach to test engineers.
• Prepare UI/web application test plan, prepare test cases for UI/UX design, prototype validation, field level data validation, data security, SQL injection, penetration testing and reviewed product user training manual.
• Prepare technical, business meta data catalogue for Data governance using Collibra, critical business elements standardizations, technical mapping document for source to target data transformation rules.
• Prepare Data Quality Testing Strategy, Test Suite Design, Test cases documents at subject area level, Fact/Dimension/ Look up reference tables, business rules validations, dashboards validation and integration testing.
• Created Data Quality routines to check Referential Integrity, Atomic level data validation, Range validation, Metadata consistency, Audit columns validation in Source/Stage/Target tables in DEV and SIT environments.
• Developed Advanced TERADATA SQL queries to perform Source Data Vs Target Data Load.
• Validated the data correctness in Wachovia Systems and Confidential Home Mortgage systems to adhere business requirements.
• Good hands on experience in testing applications that are built on technologies like JAVA, Web Services, IBM MQ & WESB.
• Test SAP business objects reports, data filters, data refresh, Universe validation and reports publishing methods.
• Developed Vuser Scripts using LoadRunner Web HTTP/HTML protocols based on user workflows.
• Developed and maintained stress as well as load test scripts along with business cases for HMDA applications.
• Validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Analyzed results using LoadRunner Analysis tool.
• Responsible for analyzing application and components behavior with heavier loads.
• Monitored test execution, host machines, database servers, web servers using LoadRunner monitors.
• Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.
• Good experience in using APM toolDynatracein monitoring business transaction across all tiers (web/app/DB) of the applications.
• Develop scenario-based testing for theJMeter scripts, to Create, schedule and run the scenarios usingJMeterand generate necessary graphs.
• Extensively worked onJMeterto create Thread Groups and test Web Application for various loads on key business scenarios.
• Active participation in all levels of Development Life Cycle for MIDE, Agile experience from Requirement Analysis to User Acceptance Testing, communicate the project milestones and status to program manager.
• Responsible for driving ‘Defects Triage’ meetings, test cycle estimation and defects report consolidation.
• Provide the team with technical leadership on Data Integration testing, Industry best practices, Defect metrics reporting.

Environment: IBM Rational Clear case, Ab initio, Teradata 15/13, Oracle 10G, TOAD, Teradata BTEQ, Fast Load, MLoad, SQL Developer, SAP Business Objects, Unix, HP ALM, Harvest, SVN, JMeter, LoadRunner, SoapUI, Linux, JIRA, AGILE

Confidential, Roseland, NJ

Performance Test Engineer

Responsibilities:

• Worked with Business Analyst and application teams to discuss the performance requirements and load test strategy
• Responsible for developing the performance Test Plans and Load Test Strategies.
• Developed Vuser scripts using Web HTTP/HTML, Siebel Web, .Net, Winsock, Web Services, Microsoft .Net, Java, ODBC and Oracle NCA.
• Created customized LoadRunner VuGen scripts at API level with manual correlation, user defined functions, development libraries classes and methods, and error handling.
• Used HP's Load Runner to develop the automation scripts for authentication/security applications.
• Developed test scripts in VuGen using Web/http, Web Service, and Ajax protocols. Enhanced the scripts by adding checkpoints, functions in C Language, transactions, created parameters, and performed manual correlation to develop robust scripts.
• Implemented IP Spoofing techniques to simulate unique users' requests while running the tests. sed Performance Center to manage and execute the performance test.
• Ran Load, Stress, Soak, and Fail over test for verities of security applications.
• Ran break point tests to measure server threshold and endurance tests to determine the presence of memory leaks.
• Used SoapUI Pro to perform Web Service test.
• Enhanced Vuser scripts by adding correlations, parameters, condition controls, and checking/validation functions
• Used SiteScope and Introscope to monitor the databases, application and web servers at OS Application level for Performance bottlenecks while conducting Load, Stress, volume, and Memory tests.
• Developed Vugen scripts and the LoadRunner Controller for execution.
• Enhanced Vuser scripts by introducing the timer blocks, by parameterizing user ids to run the script for multiple users.
• Manually correlated the opportunity IDs, to save the dynamically changing opportunity IDs into a parameter by going to the body of the server response in the LoadRunner.
• Coordinated with the DBAs to effectively monitor the performance of test databases and help in instructing export/import of specific data tables and schemas relevant to testing
• Parameterized date values to simulate end-to-end processing in a production-like environment.
• Conducted result analysis and communicated technical issues with developers and architects.
• Used diagnostic tools to monitor performance slowness at the package level.
• Used Performance Center to store all the developed scripts and scenarios.
• Provide weekly updates to the client and application team based on the test results and analysis.

Environment: Load Runner9.52/11.0, Windows server 2003/XP, Quality Center, Oracle, SQL Server, XML, Adobe Flex, AJAX, Jscript, web services, UNIX, MS Office Tools, RTC, Java, SOAPUI, HTML, DHTML, WebLogic 10.x, ALM, Wily, HP Performance Manager, Dynatrace.

BI/DW QA

Responsibilities:

• Understand the functional & Technical requirements for CDW project.
• Requirements Analysis, formalize testing requirements, Prepare testing solutions to CDW requirements.
• Analyze, prepare test cases, test data upload from CDW gateway UI, simulate duplicate loads and alerts workflow.
• Prepare Data Quality Testing Strategy, Test Suite Design, Test cases documents for Source level, Subject Area level, Integrated Testing.
• Assign, Review, create test cases using precise SQLs in ORACLE, SQL Server, Sybase Databases to perform Data profiling, data quality checks.
• Assign, Create, Review Source to staging quality validation test cases and validate the results are matching with expected results.
• Assign, Create, Review test cases for Staging to ODS tables data flow and validate column-by-column transformation rules, data retention, data archival, meta data consistency, duplicate run, orphan records, referential integrity using SQL Server SQL queries.
• Create, Execute Test cases to validate QlikView Dashboard, Chart Objects, Sheet controls, List of QVW files, Data Validation and QV reload jobs.
• Create Shell scripts to compare source files, duplicate records,QlikView Refresh, Email notification.
• Create ANSI-SQL, parametric SQL commands to reuse across QA, SIT, UAT environments.
• Defect management, create defects, review defects and assign it to developers, clarify not-an-issue related, re-testing, re-assign based on test results.
• Track Defect metrics, Generate Defect management Report for management reporting.
• Lead QA testing, Co-ordinate Onsite/Offshore QA team to track progress on milestones.

Environment: Mercury Test Director, TOAD for Data Analysts, MS SQL Server, Sybase ASE 12.5, SSIS SQL Server Integration Services, SSRS SQL Server Reporting Services, Oracle 10G, HL7 Feeds, Unix Shell Scripts, Aqua Data Studio v4.2, Business Objects XiR2, QlikView v11, PVCS.

Confidential

Software Engineer

Responsibilities:

• Developed GCAT library stored procedures using PL/SQL to cache the Geneva Catalogued (Billing/Rating Tariff) Tables.
• Developed the functionalities of the modules viz., PR write, PR Complete, MI Write and MI complete in Oracle and hold functional ownership on these modules.
• Developed Java classes, Oracle stored procedures to store values into Bill formatter tables.
• Developed Pro-C routines to get Bill Formatter data from source files.
• Developed Shell scripts for prepare data files, monitor active processes threshold, notify job execution status.
• Report to the Geneva’s Business manager about the change requests and work progress.

Environment: Java, Oracle8i, Visual basic, Crystal Reports, Shell Scripts, HP-Unix, Sun Solaris, Windows, DDD, Bunyan, PL/SQL, CM Synergy, Telecom