SUMMARY:

• 13 + years of work experience in IT Industry in analysis, design, development, and maintenance of various software applications in client - server environment. Experienced in manual testing, automated testing using tools like HP Unified Functional Tool, Selenium WebDriver (Java), Performance testing like HP Load Runner, Performance Center and API tools like SOAP UI and Postman and Big Data testing tools like Hive, Impala, Spark
• Experience with various components of application architecture including Web Tier, Application Tier and Database Tier
• Specialized in development of Project Estimations, Forecasting, Test Strategy, Test Plans, Test Cases, Test Data and Defects Management
• Experience in the process of testing and participation in both Waterfall and Agile Models environments in the Software Development Life Cycle.
• Experience in Systems, Functional, Integration, Manual, Automation, ETL, API, Big Data, User acceptance, Regression, User Interface, Performance and Database testing in a multi-tiered environment
• Identified scenarios for automation, enhancing, and customization and compiling automated HP UFT scripts and Selenium Web Driver (POM) and TestNG using Java
• Well versed with Core Java OOPS concept, Collections, Strings, Exception Handling and Multithreading
• Proficient in End to End - ETL Datawarehouse testing
• Experience working on languages like Java, XML, JSON, Python and Scala
• Experience in testing API using SOAP and REST services using SOAP UI and REST services
• Experience is testing both XML and JSON formats
• Creating Performance Scripts using HP Load Runner (HTTP/HTML Protocol, Siebel) and JMeter
• Experience with source version control tools such as GitHub and Jenkins
• Extensively worked in Oracle by using SQL Queries as well as wrote many Stored Procedures, Functions, and Packages & Triggers in PL/SQL for backend database testing.
• Working experience with defect tracking tools like HP ALM/Quality Center and Jira
• Ability to manage multiple projects as well as leading onshore/offshore team. Excellent communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential

Big Data QA Lead

Responsibilities:

• Understanding the Business area and the client's requirements.
• Performing and leading the testing activity on data lineage for Datawarehouse Project
• Worked as ETL QA Lead responsible for the requirements / ETL Analysis, ETL Testing of the flow and the logic for the Data warehouse project.
• Testing ingestion and processing of the data from the source to consumption layer
• Testing delta captures for incremental data loads
• Running Batch ETL jobs to process the data via data pipeline from flat files into HDFS
• Applying various types of Complex SQL Joins in Hue for Hive and Impala.
• Running Hive queries and HiveQL scripts with RegEx transformation to process the data and provide concentrated data sets within optimized time
• Executed Scala Programs for data validation and checking Business Transformation Rules.
• Checking Optimized Hive Tables with partitions to work seamlessly for queries against the HDFS data
• Testing performance improvement in query execution by partitioning and bucketing of the data in hive tables
• Executed and working python Scripts for testing automated generated CSV reports and validating the Business Transformations
• Performed UI and API testing using POSTMAN along with the other team members for downstream applications.
• Defining the goal for automated testing and determine which test cases to automate using Java in Page Object Model using Selenium Java Web Driver using languages like java/python building TestNG and Maven.
• Strong experience in defect root cause analysis and present defect metric to the client. Expertise in Agile process actively supports team for the process improvement using One Jira
• Managing the testing resources in onshore and offshore locations.

Environment: /Tools: Hadoop, Hive, Impala, Spark, One Jira, Azure SQL Developer, Ctrl M, Jenkins, test, Selenium Web Driver, Apache POI, Power BI, SAP Business Objects, TestNG, Sikuli, Eclipse 4, Pycharm 3

Confidential, MA

Automation Tester

Responsibilities:

• Gather or Analyze requirements or features what needs to be automated and implemented in Test Automation Architecture and framework
• Writing and refactoring automation Selenium WebDriver scripts using java language in eclipse IDE with underlying client’s framework using Page Object Model and Data Driven Framework running in various browsers like Firefox and Chrome
• Daily executing and creating the automation scripts using Selenium WebDriver which will be integrated with TestNG and Sikuli
• In case of any failed tests, triage or discuss with the developers to see if this is an issue in the code or environment or automation script
• Creating and executing JMeter scripts for performance testing
• Creating JMeter test plan with HTTP samplers and JDBC samplers
• Designing and scheduling the performance scenarios closely worked with development team. Monitoring test results and analyzing the performance testing results with the team and identifying performance bottlenecks
• Generate and validate Edwin Analytics IBM Cognos reports for school, districts, and state level users
• Reviewing or testing MCAS related Edwin Analytics IBM Cognos reports for new enhancements
• Effectively communicating with business partners, peers, and management

Environment: /Tools: Java, Selenium Java Web Driver, APACHE POI, JMeter, Eclipse, TestNG, Auto IT, Sikuli, HP Load Runner, IBM Rational Performance Tool and Rational Team Concert

Confidential, Boston

Big Data QA Analyst

Responsibilities:

• Creating Test Plans and Test Strategies for testing scenarios in Agile environment
• Attending Daily Stand Up and Agile related Meetings
• Collaborates and communicates with management, internal and outsourced development partners regarding test status, project progress, and issue resolution.
• Performing database testing on the data as it gets transformed from the source data to the target data after being processed through the MapReduce algorithm and other ETL transformations.
• Involved in ETL Mapping Design and Performance tuning to load mapping process.
• Identify all Elements, Categories and DataMart (Persistent and Transient), calculation logics or complex joins which need to be setup in Confidential .
• Experience in Map Reduce programming model for analyzing the data stored in HDFS.
• Experience in validation of Map Reduce codes as per business requirements.
• Worked on Autosys, Unix, Hadoop, Hive, Impala and shell scripting for big data testing. Leading the team for the same.
• Performing and leading the testing activity on data lineage.
• Performed and lead the testing effort on multi data base testing like SQL server, Tera data and Hadoop.
• Testing different types of heterogeneous data like structured data, semi structured data and unstructured data. It can process data extremely quickly due parallel processing of data
• Worked on Putty/winscp for checking the logs/exceptions
• Design POM framework from scratch to test Confidential UI using Selenium Web Driver using Java for Backend Automation
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Developed Java Code using Eclipse IDE for Backend Automation
• Working on API Testing using POSTMAN

Environment: HP ALM, HP Quality Center and Confidential Internal UI and Rational Team Concert, Eclipse, Selenium Web Driver Java, GitHub, Postman, Eclipse IDE, Squirrel, SQL Developer, Putty, winscp

Confidential

Automation/Performance Tester

Responsibilities:

• Recording and Correlating Vugen scripts using Siebel, Web HTTP/HTML and Web Services Protocol in HP Load Runner
• Creating the standard library C functions
• Creating dynamic data manual correlations and reading various custom functions. Parameterization of test data load
• Creating and executing JMeter scripts for load testing.
• Create Test Plan with HTTP Samplers and JDBC Samplers in JMeter
• Parameterizing scripts using CSV Data Set Config. Embedding various assertions in the JMeter scripts. Implementing various Listeners to evaluate results
• Designing and Scheduling the Performance Scenarios Closely worked with DEV Team on Wily Interscope monitoring team during the test executions and analysis.
• Good understanding of Java concepts like garbage collection, multithreading etc.
• Creating Automation Scripts for Web Services for Online Applications.
• • Designing the Keyword Framework and executing the Daily Smoke Tests in UFT for testing Confidential card web site

Environment: HP ALM, HP Quality Center, JIRA, HP UFT 12.02, SOAP UI, Java, Web Services, Net, Oracle, Siebel., HP Load Runner 12.50, HP Performance Center 12.01, CA Wily

Confidential, Florida

Senior Quality Analyst

Responsibilities:

• Reviewing the requirements document with Business Analyst and Developer
• Analyzing Business Requirements for creating and reviewing test ware - Test Strategy, Test Plans, Test Scenarios and Test Cases
• Writing the Test Plan, Test Cases, Test Execution and Status Report
• Plan the tests including selecting test approaches, estimating the time, acquiring resources, defining test levels, cycles, and planning incident management.
• Initiate the specification, preparation, implementation and executing of tests, monitor the test result and check the exit criteria
• Performed Component testing, Functionality testing, Integration testing, Data validation testing, Regression testing and UAT
• Executing the Data Driven Framework Smoke Tests in QTP for regression

Environment: HP ALM, HP Quality Center, QTP 10, SOAP UI, Java, Web Services, Net, Oracle, Siebel, HP Load Runner12, HP Performance Center

Confidential, Downtown, IL

QA Analyst

Responsibilities:

• Reviewing the requirements document with Business Analyst.
• Requesting the test data for the releases.
• Writing the Test Plan, Test Execution and status reports.
• Writing the test cases, executing the test scripts, logging the defects and reporting the status on the projects.
• Logging into Host environment and validating the data.
• Writing different SQL queries for data validation through Netezza
• Executing the test cases
• Executing the test cases using SAP Business Objects
• Data Validations from Source to Landing and Landing to Staging.
• Writing SQL Joins and Complex queries.

Environment: SAP Business Objects, Netezza Database, HP Quality center, Host environment, Agnity, SQL Queries, Egain (Vendor)

Confidential

QA LEAD

Responsibilities:

• Reviewing the requirements document with Business Analyst and Developer.
• Attending Code Delivery Meeting Request new data for the releases
• Requesting the test data for the releases.
• Writing the Test Plan, Test Execution and status reports.
• Executing some UNIX scripts for regression and batch testing.
• Writing the test cases, executing the test scripts, logging the defects and reporting the status on the projects.
• Attending the Code Walk through meetings.
• Logging into mainframes, viewing the structures on the tables, changing some data for testing purposes, executing the batch processes and validate the data in the tables
• Validating the content using the templates.
• Writing different SQL queries for data validation.

Environment: Mainframe, UNIX, Toad for DB2, TSYS, Portal Website, SQL queries, Informatics, HP Quality Center

Confidential, Newark, Delaware

QA Tester/analyst

Responsibilities:

• Preparing the test accts using C3 or TSYS screens. Writing the test cases for end to end to validation.
• Developing Test Plans, Test Cases and Test Scripts.
• Extensively working in Oracle/ Teradata by using SQL Queries as well as wrote many Stored Procs, Functions, and Packages & Triggers in PL/SQL for backend database testing.
• Preparing the test accts and validation them in TSYS Screens or C3 Screens.
• Installing the tar from the developer
• Comparing the SQL scripts and jar scripts
• Reviewing the Functional Designs documents, attending the meetings, executing the scripts in QC, logging the defects and following up with developers.
• Running the process in UNIX, checking the logs and validating the data, performing end to end testing.
• Validating the production data.
• Writing the SAS programs to export data and for data validation.
• Writing Shell Scripts in UNIX .

Environment : SQL queries, SQL Developer, UNIX, C, C++, SAS, Tivoli, HP Quality Center

Confidential, Newark, Delaware

QA Tester/analyst

Responsibilities:

• Worked on POE(Product Offer Engine) - Setting up Associate Banks, Source Template, Pricing Template and updating the Promotion Templates
• Associated with FM team mainly testing the new money and Cash Credit Line
• Applying promos, new money offers through MBNAIS and applying various transactions through dart net.
• Requesting rate letters benefit kit and clarity commitment and reopen letters. Applying lost /stolen status on the account
• Executing the scripts for ICVT Bulk tool in order to validate interest charge calculations
• Validating the ASR, and printed statements for the updated pricing changes.
• Reporting the test execution status and defect updates to the team lead
• Involved in preparing data for dispute validation

Environment: TSYS, MBNAIS, HP Quality Center, Front End Applications

Confidential, Newark, Delaware

Business Analyst / Quality Analyst

Responsibilities:

• Gathering the business requirements for launching new credit cards
• Designing the process flows using MS-Visio Coordinated with development engineers and prepared test plans and endured functionality of all applications.
• Developed SQL Queries to query the database to test the back end process of the application.
• Created test cases for incentive plans and automated them using Quick Test Pro.
• Writing Data Driven Tests to validate the same scenario with different Test Data Performed tests on various features of Agile development process/Sprint testing.
• Observed all test and identified defects in tracking systems.
• Attending stand - up meeting and reporting the progress daily basis to the project owner.
• Involved in post-production validation

Environment: MS Visio, HP Quality Center, HP QTP 10, MBNAIS, TSYS, First Data (Vendor)

Confidential, Newark, Delaware

QA Tester/analyst

Responsibilities:

• Developed Test Plan, Test Cases and Test scripts in test plan manager of Test Director.
• Worked on business cards validation using TSYS
• Created Traceability matrix between Requirements and Test cases
• Preparing the data for Trigger Testing and Telephone testing
• Created test cases to check the html pages (web page), hypertext links, images, Java applets and tables.
• Conducted Integration testing, functional testing, system testing.
• Setting up data in order to process payments for a third party vendor.
• Processing payments to myeasypayments.com
• Discussing on End - to- End Payment Scenarios with Business and Technology
• Performed Component testing, Functionality Testing, Integration Testing, Data validation testing, Regression Testing, UAT.

Environment: TSYS, MBNAIS, HP Quality Center, Front End Applications