SUMMARY

• Over 10+ years of diversified experience as Business System Analyst and Over 8+ years of experience in Financial and Credit card services at Confidential bank.
• Skills include Automated Testing on Client/ Server & Web applications, Data Analysis, Requirement Gathering and Business Analysis.
• Executed and created automation scripts including dynamic parameterization using data sheets, database tables and excel spreadsheets, checkpoints, HTML/XML DOM objects, java classes/objects and descriptive programming.
• Identifying objects of App using UI Automator tool for Android and Appium Inspector for iPhone.
• Experience in Test Automation using tools like QTP, Selenium, Cucumber, Maven, Jenkins, Gherkin.
• Expertise on TestingREST APIservices using SOAP UI/Postman.
• Created and maintained server - side integration tests, JSON documents, running with every build with Git, Jenkins.
• Extensively used UDF2 framework to design functional test using Selenium.
• Extensively used Business Process Testing (BPT) framework.
• Developed Appium Scripts for Native Android/IOS Apps using Java.
• Experience with creating Components to perform Business Process Tests.
• Extensive experience in writing Stored Procedures, Packages, Database Triggers using SQL.
• Used Jenkins for Continuous Integration (CI) and Maven as build development tool.
• Hands-on experience in AS400 with RPG programming, RS6000 with SQL programing and Visual Basic.
• Experience in designing Automation test cases using Selenium, Cucumber, TestNG, Gherkin scripting and execution.
• Experience with Total System Services (TSYS) for credit processing and handling transaction, rewards and awards.
• Implements Customer Content Management System (CMS) using SharePoint.
• Proficient in testing RDBMS such as Oracle, DB2, SQL and PL/SQL programming for testing data integrity.
• Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential DataStage with DB2 UDB, Oracle, SQL Server.
• Experience with SQL LOADER, SSIS, SSRS from loading the data from XML, Text file etc and inserted into the database.
• Extensive experience in Functional testing, Unit testing, Usability Testing, Integration testing, Regression testing, GUI testing, Back-end testing, User Interface (UI) Testing, Ad-hoc testing, White Box Testing, Gray Testing, Black Box Testing, System Testing, baseline, Installation, Performance and Build Verification Testing.
• Extensively used tools like Mercury Tools (QTP 11, Win Runner, Load Runner, ALM, Test Director)
• Tested Web Services call for their working and functioning and parsing XML documents.
• Extensively used Load Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario
• Experienced in RTM (Requirement Traceability Matrix) to know the status of the project.
• Responsible for Test cases, Test Plans, Test Reports, Executing Test Cases, Scripts
• Worked with Oracle PL/SQL Stored Procedures, Table Partitions, Triggers, SQL queries, SSIS, PL/SQL Packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts.

TECHNICAL SKILLS

Languages: VB, Gherkin, C#, Java, Java script, Web Services, J2EE, VB.NET, SQL, XML, SOAP, UNIX, TSYS, REST API

Database: Oracle 10g, MS SQL 2008, SQL LOADER, SSIS, SSRS, Toad

Testing Tools: Selenium, QTP, Jira, ALM, Postman, Eclipse, SoapUI, Appium, Jenkins, Maven, Bitbucket, GIT, SVN, HP Quality Center, Jmeter

Reporting Tools: Tableau, Business Objects.

Software Q/A & Testing: Standard & Procedures Development, SDLC, TestingTest Plan Design and Development

Methodology: Waterfall, Agile Scrum Methodology

Data Modeling Tools: Erwin, Visio.

GUI Servers: IIS, Web Logic, Tomcat

Operating Systems: Windows 10, Unix, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

Automation Test Engineer/BSA

Responsibilities:

• Provide Product Owner, Scrum Master, and Team Members knowledge and leadership regarding software quality processes, as well as process improvement.Automation experience creating and maintaining automation frameworks in Cucumber, VB Script, JavaScript.
• Experience with Automation Tools / frameworks - Jira, Confluence, Jenkins, Maven, TestNG, TestRail.
• Developed automated integration and smoke tests using modern tools including Selenium, SoapUI (web front-end and services)
• Partner with development to build page-objects for automation scripts using Selenium WebDriver, JAVA and TestNG early in Sprint cycle for quick turnaround.
• Design, Build and maintain macro scripting.
• Experience with Automation Tools / frameworks - Jira, Confluence, Jenkins, Maven, Bitbucket, TestNG and Eclipse.
• Experience in Java, VBScript, VBA and XML.
• Experience with calling RESTful API services and parsing JSON File.
• Experience in creating XPATH to locate web elements.
• Proficient in developing automated API and services test (REST, SOAP) using market tools such as REST-assured, Postman, and SoapUI.
• Participate in daily Scrum calls, reviewing Product Backlog, Sprint Backlog and Sprint Retrospective.
• Performed automated testing and maintain documentation on different types of Testing viz., Regression, Functional and Performance testing.
• Extensively used Business Process Testing (BPT) framework.
• Experience in designing Automation test cases using Selenium, Cucumber, TestNG, Gherkin scripting and execution.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Extensively used REST API to design utility macros in JIRA.
• Used TSYS mainframes, for posting payment transactions for the card member to get enrolled by posting the monthly fix pay amount.
• SQL LOADER loaded the data from any text file and inserted into the DB2.
• Extensively used Oracle, SQL queries to retrieve data from the databases.
• Tested Web Services calls used in the applications using SOAP UI.
• Optimized QTP/UFT scripts for Regression testing of the application with various data sources and data types.
• Experience testing under various application environments including web-based, client/server and AS400 based systems.
• Managed the overall testing effort, including coordination of testing personnel and test lab resources.
• Extensively used ALM and JIRA for Test Planning, Bug tracking, and Reporting.
• Expertise in writing SQL Queries and performing Database validation including data integrity and data validation.
• Analyzed the Data quality, Data validating, Data mapping to test data in SQL server.

Environment: Selenium, Jira, Confluence, Jenkins, Maven, Cucumber, Bitbucket, TestNG, UNIX, Windows, TSYS, Postman, Tableau, SoapUI, QTP 9.2, ALM, SQL Navigator 4.5, SQL Server 2008, Oracle 10g, Toad, J2EE, .NET Framework.

Confidential, Mechanicsburg PA

Automation Test Engineer/BSA

Responsibilities:

• Managing all verification and validation (V&V) activities for all Production modifications including projects, releases, and changes.
• Coordinating with other QA Leads, the Project Manager, Development Manager, and SQA.
• Created test plan, strategy and scripts for the .NET and web-based applications using AGILE methodology in Mercury Quality Centre 9.0.
• Performed testing across different browsers e.g. IE 6.0, IE 7.0, IE 8.0, Safari, FF.
• Performed end to end testing to validate whether card member is charged for the item redeemed and credited for the returned item.
• Hands-on experience in AS400 with RPG programming, RS6000 with SQL programming and Visual Basic.
• Used SQL to produce monthly reports, month to date reports, daily activity reports and reconciliation reports using SSRS.
• Assessing risk to quality based on results of V&V activities and making recommendations based on this assessment.
• Coordinate regression, system, integration, and API web services testing with Product Engineering and engineering team.
• Created SQL Queries against source table, target table and Distribution Tables.
• Performed Unit & Functional testing using JUnit (J2EE Env) &NUnit (.NET Env)
• Developed several FIFOs: developed system to automate record keeping and devised a system to publish the output from existing AS/400 application to company’s intranet.
• Integrated & deployed web-services using SoapUI.
• SQL LOADER loaded the data from any text file and inserted into the DB2.
• Wrote Test cases, Test Scripts and Test Scenario in Microsoft Excel, based on System Requirements Specifications (SRS) and Customer Requirements and then imported to Quality Center.
• Verified ETL transferred data from DB2 and Microsoft SQL tables to the Operational Data Store created in Oracle8i.
• Performed manual and automated testing and maintain documentation on different types of Testing viz., Regression, Integration, System, Performance, and Acceptance testing. Comprehensively reviewing the business requirements, specifications, systems design, and conceptual design documents
• Supporting the business in defining requirements and specifications and trace matrix.
• Made XPath Queries on the XML Document from WebServices calls.
• Understanding system functionality as it relates to the business requirements and specifications in order to define QA test objectives
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Assisting the business through the process by providing solutions and options for implementation of the business requirements.
• Tested the interfaces and participated in functional, integration and dataintegrity testing.
• Wrote PL/SQL Functions, Stored Procedures, Triggers, & Packages in Oracle.
• Developed PL/SQL procedures to match Prices between our Data warehouse and Daily Feeds.
• Performed regression testing of application for every new build released.
• Managed the overall testing effort, including coordination of testing personnel and test lab resources.
• Mapped the custom objects to the standard objects where necessary, and inserted Text checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Pro (QTP).
• Developed Requirements Traceability Matrix (RTM) to ensure adequate test coverage.

Environment: UNIX, Windows, TSYS, Rapid SQL 7.6, SQL Loader, SQLServer, SSIS, SSRS and SSAS, JUnit, NUnit, SoapUI, Crystal Reports, Erwin 4.1, QTP 9.2 and HP Quality Center 9.2, SQL Navigator 4.5, SQL Server 2008, Xml Spyware, Oracle 10g, Toad, J2EE, .NET Framework.

Confidential, PA

Test Engineer/BA

Responsibilities:

• Used Rational Unified Process (RUP)/UML to make an Object Oriented model for the application and used UML/Rational Rose for creating the Use Cases, Activity Diagrams, Class diagrams, Sequence diagrams, Process Flows etc.
• Involved in writing Test Plans, Test cases and developing Test scripts using Test Director.
• Designed ETL process as per the requirements and documented ETL process using MS VISIO.
• Demonstrated the ETL process Design with Business Analyst and Technical Lead. Preparation of design guidelines for ETL process development using DataStage Enterprise edition Parallel Extender, PL/SQL, SQL and Shell scripts.
• Implemented the logical Data Stage connections across the platform.
• Performed manual and automated testing and maintain documentation on different types of Testing viz., Regression, Integration, System, Performance, and Acceptance testing.
• Ability to build and execute SQL Queries on AS400 DB.
• Created test plan, strategy and scripts for the .NET and web based applications using AGILE methodology in Mercury Quality Centre 9.0.
• Participated in agile/scrum process - scrum team meetings with developers.
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• Used Serena Team Track for defect management and reporting.
• Extensively used Oracle, SQL and DB2 queries to retrieve data from the databases.
• Experience testing under various application environments including web-based, client/server and AS400 based systems.
• Verified ETL transferred data from DB2 and Microsoft SQL tables to the Operational Data Store created in Oracle8i. Also, created test data for end to end process.
• Running jobs, backups, disaster recovery, printing reports and user assistance in an IBM i5 AS400 environment.
• Tested the design, develop software systems using Java / J2EE, Web Services, HTML, Java Script, SQL Server 2005, XML, Crystal Reports,
• Estimate, initialize, manage, monitor and control and close project according to Requirement guidelines.
• Developed and wrote UNIX Shell scripts for Batch jobs using Control-M.
• Developed PL/SQL procedures to match Prices between our Data warehouse and Daily Feeds.
• Wrote PL/SQL queries to verify data’s in the Oracle 10g database.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.

Environment: SoapUI, NUnit, JUnit, BMC Remedy 7.1, Actuate Reports, TSYS, Quality Test Professional, AS 400, Quality Center, Load Runner 8.0, SQL Server 2005, Oracle 9i, J2EE, Unix.