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 teh 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 teh 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, NY

Performance Test Lead

Responsibilities:

• Prepare teh 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 teh real user experience.
• Responsible for creating teh 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 teh load testing.
• Benchmark testing for teh application based on performance testing results.
• Prepare, populate control tables, Execute Informatica Workflows to complete Data Load for testing.
• Performed deployments to teh performance server based upon performance needs using Jenkins.
• Performed network and security design and teh implemented in teh 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 teh 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 teh client and application team based on teh 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 teh 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 teh 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 teh 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 teh scripts to make sure they have been executed correctly and meets teh 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 teh applications.
• Develop scenario-based testing for theJMeter scripts, to Create, schedule and run teh 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 teh project milestones and status to program manager.
• Responsible for driving ‘Defects Triage’ meetings, test cycle estimation and defects report consolidation.
• Provide teh 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 teh performance requirements and load test strategy
• Responsible for developing teh 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 teh automation scripts for authentication/security applications.
• Developed test scripts in VuGen using Web/http, Web Service, and Ajax protocols. Enhanced teh 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 teh tests.
• sed Performance Center to manage and execute teh 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 teh 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 teh databases, application and web servers at OS Application level for Performance bottlenecks while conducting Load, Stress, volume, and Memory tests.
• Developed Vugen scripts and teh LoadRunner Controller for execution.
• Enhanced Vuser scripts by introducing teh timer blocks, by parameterizing user ids to run teh script for multiple users.
• Manually correlated teh opportunity IDs, to save teh dynamically changing opportunity IDs into a parameter by going to teh body of teh server response in teh LoadRunner.
• Coordinated with teh DBAs to effectively monitor teh 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 teh package level.
• Used Performance Center to store all teh developed scripts and scenarios.
• Provide weekly updates to teh client and application team based on teh 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 teh 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 teh 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 teh Geneva Catalogued (Billing/Rating Tariff) Tables.
• Developed teh functionalities of teh 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 teh Geneva’s Business manager about teh 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