SUMMARY

• Over 10+ years of experience as a QA Automation Engineer, SDET, extensively worked on Manual, Automation, DevOps Testing of Web Client Server, Cloud (AWS), Mobile, API, Webservices applications
• Excellent knowledge and implementation skills in complete Software Development Life Cycle SDLC and Software Testing Life Cycle STLC
• Expertise in Manual and Automation Testing of Client/Server, Mobile, Web - based and Cloud (AWS)applications
• Excellent knowledge and implementation skills in complete Software Development Life Cycle SDLC and Software Testing Life Cycle STLC
• Automated couple of workflows using PowerShell. Involved in writing background jobs using PowerShell.
• Good Experience in Linux Bash scripting and following PEP Guidelines in Python.
• Migrating an entire oracle database to Big Query and using of power bi for reporting.
• Expertise in understanding Business Requirement Specifications, Functional Specifications and design documents and converting them into Test Scenarios
• Developed Mac OS X projects and frameworks using Swift
• Very keen in knowing newer techno stack that Google Cloud platform (GCP) adds.
• Experience in Agile methodology, worked very closely with Product owners in Agile and attended different Sprint Planning meeting, Scrum, Backlog grooming, Sprint Review and Retrospective
• Proven ability in designing and creating automation frameworks using Java, Selenium WebDriver, Junit, TestNG, Appium, Protractor, Jasmine, Maven, ANT, and Jenkins
• Has very strong exposure on Performance usingLoadRunner and JMeter
• Execution of automated test scripts usingJMeter based on business/functionalspecifications
• Experience of Creating, Modifying and Maintaining new and existing Automation Framework Models BDD/TDD/ATDD Hybrid, Keyword and Data Driven Frameworks
• Created Provider Contracts, Benefits, load Fee Schedules, assisted with provider contract mapping and aided in claims unit testing for QNXT 4.7 implementation.
• Developed financial models on BPC to facilitate financial, statistical, operational, and cost/benefit analysis
• Has mentored Users and IT Staff in Application development in Db2 Database Technologie
• Served as the lead PowerShell developer in hundreds of Windows based migration and automation projects
• Experience in Core Java, development by applying different concepts like OOPS concepts, Collections, Strings, Exception handling, Multithreading, and experience in Groovy and JavaScript
• Worked with DevOps, installing, configuring, and integrating Automation scripts on Continuous Integration tools (CI/CD) like Jenkins for nightly test suite execution and working on knowledge on testing and configuring Amazon Web services (AWS)
• Expert in developing Behavior Driven development (BDD/TDD/ATDD) by writing Gherkins using Cucumber and developed Scenarios, Scenario outlines, features and Step definitions and generating the cucumber reports
• Experience in GCP Cloud functions, Big Query.
• Experience in installation and administration of version control systems like GIT (Distributed Version Control), GitHub, SVN Version Control
• MS CRM Entity customization for business functionality implementation.
• Experience in automating Mobile applications using Appium
• Experience with automated AngularJS applications using Protractor, Jasmine
• Strong experience working with Unit Test Frameworks like TestNG, Junit, and Jasmine
• Experience in implementing the Page Object Model (POM) by creating element for each page object and reused all the objects in various scripts
• Developed and tested many features for dashboard using Ruby on Rails, Bootstrap, CSS JavaScript, and Spec
• Used regular expression fordynamic values in JMeter
• Experience in testing Web Services-SOA architecture, XML transactions, SOAP, HTTP, WSDL, and REST using various tools like SOAP UI/Ready API and selenium
• Can work parallelly in both GCP and Azure Clouds coherently.
• Automated Webservices by writing Groovy scripts and used assertions for data validation and performed data driven for validating different endpoints
• Expertise in HTML, CSS, HTTP, JavaScript, XML, AJAX, AngularJS, and jQuery
• Worked with Eclipse, Apache POI, Log 4J, ANT, HTTP client and Maven
• Performed Database/Backend testing by writing complex SQL Queries for data validation and integrity, good at writing complex Joins and knowledge in PL/SQL
• Worked with Selenium Grid/ Sauce labs for running multiple tests across different browsers, operating systems, and machines in parallel
• Worked on testing applications on different browsers like IE, Firefox, Android, Safari, and Chrome
• Experience include Unit testing, Functional testing, User Acceptance Testing, Integration testing, System testing, browser compatibility testing & Security testing of client/server and Web Base Applications
• Authored several scripts leveraging VMware’s PowerCLI and Windows PowerShell to aid with capacity planning and monitoring of the virtualization infrastructure.
• Designed front end and backend of the application utilizing Python on Django Web Framework.
• Expertise in using various defect-reporting and defect-tracking tools like JIRA, Rally, Bugzilla
• Experience in writing good quality object-oriented code for testing purposes by following industry standard java coding standards
• Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment
• Good analytical and communication skills and ability to work independently with minimal supervision and perform as part of a team

TECHNICAL SKILLS

Programming Languages/Scripting Languages: JDK, Java/J2EE, JavaScript, JSON, Cucumber, Gherkins, GCP

Test Frameworks/Tools: Selenium Web Driver/IDE, RC, Selenium Grid, TestNG, JIRA, Cucumber, SOAP UI, Postman, MS portal Azure, Junit, Mockito, Maven, Ant, JSON, AJAX, Eclipse

Web Technologies: HTML, XML, HTML 5.0, CSS3, Java script

Databases: Oracle 11g/12c/18c/19c, MySQL, DB2, SQL Server 2012/ 2019, Cassandra

Web Services: Restful API, SOAP UI

Frameworks: Junit, TestNG, Jenkins, X ray

Web-debugging tool: XPATH, Firebug, Fire path

Operating System: Windows XP/7/8/10/11, Maclin, Cloud

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

QA Automation Engineer (Lead)

Responsibilities:

• Responsible for applying advanced programming concepts to test framework and continuously evolve the framework based on the Java and Selenium Web driver versions that are released and involved in understanding new technologies like Map anything (for maps) and google APIs for validating maps in the Transact product
• Developed in both Objective-C and Swift.
• Engaged as the lead analyst for the Oracle Financial Service Analytics and the Fidelity Oracle information system
• Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.
• Experience in GCP Dataproc, GCS, Cloud functions, BigQuery.
• With using of Python OS module on UNIX environment, made job cloning and forking.
• Used cloud shell SDK in GCP to configure the services Data Proc, Storage, BigQuery
• Involved in developing Automation Test Framework which is a Hybrid Framework for Automating the Regression Test Suite for the Global and the Transact applications
• Involved in developing the test scripts for the Transact product for mobiles in Android and iOS platforms and performed the automation testing using Appium
• Extensively worked onJMeterto create Thread Groups and test Web Application for various loads on key business scenarios
• Partnered with project managers in the development and implementation of IAM solutions
• Experienced with event - driven and scheduled AWS Lambda functions to trigger events in variety of AWS resources using boto3 modules
• Prioritized issues, creating claims testing scenarios to validate and ensure that system implementations, conversions, contract and benefit builds/updates, fee schedules updates, etc., were functioning properly within QNXT system.
• Create the application in .NET framework, .NET core and implement logic using C# and OOPS concepts.
• Hands on experience in GCP services like EC2, S3, ELB, RDS, SQS, EBS, VPC, EBS, AMI, SNS, RDS, EBS, Cloud Watch, Cloud Trail, Cloud Formation GCP Config, Autoscaling, Cloud Front, IAM, R53.
• Implemented the modular and data-driven test automation methodologies within the test architecture framework.
• Used both the Keyword and Expert views using Ranorex tool, Selenium IDE/WebDriver
• Used Xcode 8 IDE, Swift 3, and the Apple XCUI/XCTest application testing framework to create a UI Automated Test framework with these objectives: easy to learn and use, high maintainability, compact code base. Created an automated test suite for a Flight routing feature of the flight application based on the new test automation frameworks (Apple XCUI and Confidential Coded UI).
• Reviewed business requirements and technical specification documents and Analyzed use cases, functional requirements to write detailed Test plans and Test cases.
• Involved in setting up configuring the testing environment with Eclipse, TestNG, Selenium WebDriver and Selenium Java client driver using BDD framework.
• Created various automated jobs in both SQL Server and C# which data pumps the Sevis data between the Internal system and Vendor Software.
• Worked on SAP S4 cloud integration with SaaS, on-premises systems and B2B(EDI) partners using SAP CPI
• Experience in moving data between GCP and Azure using Azure Data Factory.
• Supported management reporting and analysis on consolidated financials for close, forecast, and annual plan
• Developed test cases based on the requirements and identified different test methodologies on how to test the AUT (Application Under Test) using Object Oriented programming concepts with Java to automate test cases for Transact and Global Applications
• Responsible for test execution daily and maintain the test scripts up to date as the product changes and/or evolves
• Expertise in upgrading the ruby on rails versions
• Automated Angular JS application module using Protractor and Jasmine and created specs for various functional scenarios
• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments
• Wrote Python modules to extract/load asset data from the MySQL source database.
• Extensively used Selenium locators like XPath and CSS together with JavaScript Executor, robot class to locate challenging web contents/elements such as dynamic and invisible elements and pop ups as well as frames in the web application
• Involved in writing Feature File based on the BRD, Implemented Features, Scenarios, Scenario Outlines, Background, and Expected Results and Performed Behavior Driven Testing Using Cucumber with Java and Junit
• Created PowerShell scripts to constantly monitor the health of the Exchange messaging infrastructure and notify my teammates or myself in the event of a problem.
• Work related to downloading BigQuery data into pandas or Spark data frames for advanced ETL capabilities.
• Develop scenario based testing for theJMeter scripts.
• Serve as a resource knowledgeable of the end-to-end impacts of Claims Processing and QNXT Configuration throughout a Managed Care Organization (MCO)
• Responsible for end-to-end automated regression testing and monitored daily Jenkins job build
• Performed and validated Database Testing and Data Retrieval
• On daily basis used build tools like Maven (CD) and Jenkins (CI) to build and regress automated tests; documented and tracked defects and produced detailed reports using Jira.
• Executed the test plans on web and mobile (Apple & Android) as per requirements usingAppium tool.
• Developed automation script for Mobile Native applications (IOS, Android) usingAppium, Java.
• Test the successful application written to perform numerous administrative, maintenance, security, and other software updates of mobile devices (based on iOS and Android) in Appium.
• Tested web applications developed with CSS3, HTML5 and angular2.
• Responsible in executing Selenium test scripts on different browsers and checked for compatibility.
• Create, schedule and run the scenarios usingJMeterand generate necessary graphs.
• Created data-drivenautomation scripts for testing API Web Services using REST API.
• Tested request and response XML based web services interfaces using Soap API in Soap UI.
• Tested the application in highly dynamic environment with sprint team using Agile Methodology.
• Performed REST Web Services testing with Postman and Performed Security Testing for Employee login validations.
• Developed several Classes using C# and experienced in creating Assemblies and Name Spaces.
• Modified standard programs. Implemented OSS Notes during SAP Support pack upgrades using SPAU Transaction.
• Performed automation evaluation for the Ranorex autmation tool that involved using Recording Code modules
• UsedC#.NETto develop code for business and repository layer.
• Used Firebug to identify Elements by ID, Name, CSS, XPath, and Links on Web Pages.
• Used TFS as a project tracking tool/Defect tracking/Test case Management tool
• Involved in testing REST API services using REST Assured and tested both XML and JSON formats
• Used Junit Cucumber framework to drive with execution
• Used TestNG for executing the Regression test scripts
• Worked with offshore teams in EMEA(Europe) and APAC (Asia Pacific) regions.

Environment: Java, Selenium Web Driver, Salesforce, Cucumber, Protractor, Jasmine, REST API, Junit, TestNG, HTML, CSS, JavaScript, Angular JS, Jenkins, SQL, Salesforce, Appium, JIRA, TFS

Confidential, Jersey City, NJ

Sr.QA Tester/QA Analyst

Responsibilities:

• Analyzed business requirements document, functional specifications document to prepare Test plan and Test cases
• Involved in Test design discussion to come up with efficient test approach with limited test cases along with critical boundary value test scenarios
• Designed multiple remediation MQ projects as per the Confidential internal standards
• Configured WMQ, setup up of Queues Managers, Queues and Channels
• Analyzing data for client’s migration to Company’s software(iMPACT) on AS400 platform
• Involved in Test case review for quality testing and defect free product deliverable
• Written test cases along with test cases execution
• Implemented Bash, Perl, Python scripting to automate many day-to-day tasks.
• Created BigQuery authorized views for row level security or exposing the data to other teams.
• Experience in writing automation scripts in KIF framework for iOS apps.
• Developing new apis as per the business requirement.
• Create PowerShell scripts for server Installs/ad-hoc business reports. Developed various complex modules using ASP .NET, AJAX and C#.
• Thoroughly understand health plan’s environment and how QNXT software can be used to increase efficiencies, cost effectiveness and quality care.
• Utilized Windows PowerShell to create a master table of contents page for the desktop support knowledge base, allowing for expedited troubleshooting and research of reoccurring desk side issues.
• Provided support in the performance testing using JMeter
• Support and Administer SQL replication for DB2 on Z/OS environment
• Developed re-usable function using Junit for the Test Automation.
• Set up Jenkins, GitHub, and Maven to work together and provide a smooth continuous integration system. Used Maven as a build automation tool for JAVA projects.
• Used cloud shell SDK in GCP to configure the services Data Proc, Storage, BigQuery
• Implementing the apis with restfull webservice and interacting with third party apis.
• Developed automation test scripts using Selenium Web Driver, TestNG and Junit
• Performed web service testing analyzing restful API requirements specifications, write and automation test cases SoapUI Pro / Readapt.
• Developed Groovy scripts for data validation against Cassandra database and JSON or XML outputs in Ready API.
• Created MQ Series objects on local and remote MQ servers
• Championed data center migration from on premise to GCP and migrated data warehouse from Teradata to Google big query and data visualization using Tableau.
• Implemented Selenium test cases to follow Cucumber Gherkin scripts (feature files) for Behavior Driven Development
• Used CRM MUI packs to implement language specific customizations.
• Performed month end closing, journal entries, reconciliation, financial statements, budgeting, and variance analysis
• Designed database Model, APIs and Views utilizing Python to build an interactive web - based application.
• Involved in building database Model, APIs and Views utilizing Python, to build an interactive web- based solution.
• Created scripts using Windows PowerShell to automate Identity Lifecycle Management, including, but not limited to, the creation, managing and decommissioning of user accounts.
• Developed rehydration scripts by using ansible to automate rehydration of AWS instances every 3 months once. Rehydration scripts are developed by using ansible, python and shell script.
• Cucumber was used for the entire regression testing and functional testing withSeleniumas primary tool to identify the Test Scenarios, Test Cases and Test conditions
• Designed and developed Acceptance Test Driven Development (ATDD) test cases
• Performed compatibility testing on Safari, Chrome, Firefox, IE, Opera
• Designed and implemented system health Monitor tool for Message center project using HTML, Shell Script and JavaScript.
• Deployed the message flows Applications to process the MQ based requests
• Analyzed and manipulated data with RLM (RPGLE, RPG Free format, CLP, CLLE) package on AS400 platform
• Worked on building dashboards in Tableau with ODBC connections from different sources like Big Query/ presto SQL engine.
• Implemented test cases using Test Driven Development (TDD)
• Used Eclipse IDE for writing test cases and debugging the scripts
• Experience in Groovy and JavaScript
• Securing MQ Series objects at different level like SSL and OAM authentication
• Short contract assisting Confidential iOS Mobile App test team transition from Java/Appium to Swift/XCode.
• Configured the CA APM monitoring and alert mechanisms for MQ objects
• Researched and reported defects and logged them into JIRA bug tracking system
• Written test cases using TestNG and used CSS, Path techniques to find out the static and dynamic elements in web application
• Reported software defects inJiraand interacted with the developers to resolve technical issues.
• Assist in the implementation of product and eCommerce price promotions
• Update product metadata within eCommerce systems in support of marketing initiatives
• Developed manual test cases and automation script for Mobile Native applications (IOS, Android) using Appium, Java.
• Performed the Mobile Testing for Mobile App of Client, identify the Mobile Platform like IOS, Android by using Appium.
• Used and implemented Java OOP concepts like Inheritance, Abstraction, Encapsulation, Polymorphism etc.
• Writing test scripts to testREST APIsusingRest AssuredandCucumber usingfeature files and step definitions.
• Develop and deploy the outcome using spark and Scala code in Hadoop cluster running on GCP.
• Worked on database testing especially withmongo DB.
• Extensively used Java Collection Framework and implemented Array List, Set, Map Collection objects
• Extensively used advanced For loop statements for looping and processing the multiple data objects
• Have come up with SQL queries for validating certain UI updates in the database and test data preparation
• Worked on several python packages like NumPy, Matplotlib, Beautiful Soup, Pickle, PySide, SciPy, wxPython, PyTables etc.
• Worked withCucumber, feature files and step definitions forRest Assured API framework.
• Performed web services (REST) testing with SOAP UI and sometimes Postman
• Create, schedule and run the scenarios using JMeter and generate necessary graphs Extensively worked on JMeter to create Thread Groups and test Web Application
• Used Rest Assured client API to connect to Rest API for implementing test Automation framework
• Designed and developed REST API Webs Services and tested thoroughly using Automation Scripts
• Validate the application UI through developer tool and debug to find out certain JavaScript issues and validate the AJAX call request and response

Environment: Java, J2ee, Selenium Web Driver, TestNG, Junit, Cucumber, SOAP UI, JavaScript, HTML, Postman, Eclipse, XPATH, JDK, Java, J2ee, Collection Framework, OOP’s Concepts, REST API, Rest-Assured, SOAP, WSDL, HTML, Agile, Scrum, Azure, GIT, GitHub, SQL, Oracle, ATDD, Jira, TDD, Jenkins, DevOps, CI/CD, Maven, BDD, Tomcat Server, SQL Developer, Cloud.

Confidential, Detroit, MI

SDET

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with developers and QAteam
• Used Selenium Grid to run test cases in multiple browsers and Platforms
• Responsible for implementation of Hybrid Test Automation Framework, Page Object Model using Selenium WebDriver, TestNG and Maven and Java
• Integrated Automation scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for nightly batch run of the Script
• Write a program to download a SQL Dump from there equipment maintenance site and then load it in GCS bucket.
• On the other side load this SQL dump from GCS bucket to MYSQL (hosted in Google cloud SQL) and load the Data from MYSQL to Big query using Python, Scala, spark and Dataproc.
• Experienced in AutomatingRest API’susing Rest AssuredFramework, TestNG, Java andJson Path.
• Used multimachine to perform load testing on AWS lambda.
• Strong working experience in writingPL/SQLqueries to extract data from oracle database andNOSQLqueries fromMongoData Base.
• Worked on MQ client and MQ server configurations
• Analyzing and manipulating data with RLM (RPGLE, RPG Free format, CLP, CLLE) package on AS400 platform.
• Setting up VPCs in the Google Cloud (GCP) and linked to on-premises VPN’s using IPsec
• Developed test code in Java language using Eclipse, IDE and TestNG framework
• Implemented the ATDD approach and developed the cucumber automation framework with Ruby
• The entire Ruby scripting done using Cucumber Framework Wrote and executed SQL queries to verify the data updates to various tables and ensure data integrity
• Wrote scripts for testing using Ruby in cucumber framework
• Prepared the functional test cases using test design techniques data validation concepts Equivalence partitioning, boundary value analysis
• Worked on startup scripts to auto start the QMGRs
• Created the MQ Connection factories and channel tab file for JAVA applications to connect MQ objects
• Fundamental understanding of eCommerce, Social Media, SEM, SEO and direct response marketing
• Performed compatibility testing using Sauce Labs cloud integration
• Developed few test cases for applications implemented in Ruby language
• Executing the test cases and implemented Functional, Integration, GUI Testing, Regression Testing, Sanity, and User Acceptance Testing (UAT).
• Developed SQL Queries to query Database to test the back end of the application.
• Effectively managed the testing process using HP Mercury Quality Centre to manage the requirement and test case and have clear traceability between them.
• Document the defects using the HP Mercury Quality Centre and track them to completion by communicating and coordinating with the development as well as support groups.
• Responsible for System Integration Testing and UAT Testing Defect Review and tracking to closure.
• Coordinated with the onshore and offshore resources.
• Set up the test environment and was responsible for the migration between the Development Environment and Testing Environment.
• Created and executed test cases to test SAS products of GE integrated with base applications for rewards and marketing reports
• Prepared test data document and Involved in generation of bug and test case execution reports
• Strong experience with SOA architecture, which include Soap and Restful Web Services Testing
• Performed web services testing with SOAP UI by validating request and response for XML, JSon files
• Performed data driven testing by using JDBC and Groovy script as a data source in SOAP UI and configured SQL queries to fetch data from the Oracle database
• Performed code migration to Azure DevOpsGit.
• Performed UI and Functional testing on Android and iOS devices(smart phones, tablets) using Katalon Studio.
• Experience in Simulating Mobile Application Testing with APPIUM for Android Platform and IOS Simulator for IOS platform.
• Analyzed data for client’s migration to Company’s software(iMPACT) on AS400 platform.
• Developed automation scripts for Mobile Native applications oniOSandAndroidplatforms usingAppiumandJava.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Worked on Project Management tool finding and reporting the bugs - JIRA
• Automated infrastructure provisioning on Microsoft Azure using Terraform and Ansible.
• Created Regression Document to track and report testing activities during each phase of testing, including testing results, test case coverage, required resources, logged defects and their status, performance baselines

Environment: Selenium WebDriver, TestNG, Appium, REST API, Azure, Eclipse, Jenkins, CI/CD, Cucumber, SOAP UI, Jira, Java, SQL Server, TOAD, UNIX, HTML, Cloud, Firebug, Eclipse, SVN

Confidential, TX

QA Analyst

Responsibilities:

• Drive the completion and complete alignment of system design from business requirements and architectural design.
• Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
• Designed testing approach for ETL process in the Credit Data Provisioning Enterprise Data Warehouse (CDP). Ensure consistent and effective communication among all parties.
• Proactively identify and resolve issues by working with all portfolio teams
• Automating the manual test cases using Selenium WebDriver, using JAVA.
• Involved in the Debugging & Performance Tuning of the Informatica mappings.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Extensively involved in developing Web interface using JSP, JSP Standard Tag Libraries (JSTL) using Struts Framework.
• Used Java Messaging Services (JMS) for reliable and asynchronous exchange of messages.
• Used XML Web Services using SOAP to transfer the amount to other applications that are remote and global to different financial institutions.
• Designed and developed the Struts Validators, Controller Classes and Javabean components.
• Designed and Developed Stored Procedures, Triggers in Oracle to cater the needs for the entire application.
• Developed complex SQL queries for extracting data from the database.
• Worked on the Multi-Threading and JAVA Collections API for handling the data objects between the business layers and the front end.
• Involved in consuming SOAP based web services using JAX-WS.
• Used SoapUI for testing the Web Services and Apache Ant for the build process.
• Good experience in implementation of Internationalization (i18n) in web applications with Struts along with JSPs and Servlets
• Developed front-end content using JSP, HTML, CSS, JSTL and Struts Tag libraries.
• Developed Action form beans to map the form elements and used Validation framework for validating the user input data, extending Struts components.
• Used WebSphere as an application server in developing the project.
• Interacted with the database using Oracle 10g for data retrieval and maintenance.
• Involved in writing build scripts using ANT
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their lifetime and time required to update the scripts.
• ConfiguringTestNGFramework to execute Selenium scripts.
• Written smoke test cases in Quality Center and modified them when they are automated.
• Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
• Developed small applications with Teradata at the backend.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Used BDD framework withCucumber, Javaand created future files with scenario and scenario outline files.
• Conducted quality assurance reviews and developed test plan and test scripts in SQL to validate data warehouse designed to process agency management systems.
• Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
• Scheduled and monitored transformation processes using Informatica Work Flow Manager
• Managed Scope and change throughout the SDLC process of the product.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducted Black Box Testing on the application and validated the data flow in the application.
• Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system
• Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2008.
• Manually tested the whole application before going for automated testing.
• Involved in testing require version of the application into web application using XML web services.
• UAT testing is performed along with call center managers to make sure that the application meets their requirements.

Environment: Java, Business Object, Quick Test Pro 8.2, Mercury Quality Center, J2EE, UNIX, XML, Sybase, SQL, PL/SQL, Oracle9i, MS Vision. MS Office, Quality Center 9.0, QTP, Crystal Report, Quick Test.

Confidential, CA

QA Tester

Responsibilities:

• Document the defects using the HP Mercury Quality Centre and track them to completion by communicating and coordinating with the development as well as support groups.
• Responsible for System Integration Testing and UAT Testing Defect Review and tracking to closure.
• Coordinated with the onshore and offshore resources.
• Set up the test environment and was responsible for the migration between the Development Environment and Testing Environment.
• Created and executed test cases to test SAS products of GE integrated with base applications for rewards and marketing reports.
• Designed and Developed UAT Regression automation script and Automation of functional testing framework for all modules using Selenium and WebDriver.
• Reviewed Project Artifacts, analyzed Requirements, designed the test plan and provided a weekly status report that includes testing metrics, test logs, and tests summary reports.
• Conducted walkthrough meetings with SDLC team to understand the functionality, risk, and operations management of the application.
• Validated Requirements Traceability Matrix (RTM) and Users Requirement documents to prepare SIT test plan and test scenarios.
• Created test data for QTP scripts, used external data sources and excel sheets to import test data.
• Executing the test cases and implemented Functional, Integration, GUI Testing, Regression Testing, Sanity, and User Acceptance Testing (UAT).
• Developed SQL Queries to query Database to test the back end of the application.
• Effectively managed the testing process using HP Mercury Quality Centre to manage the requirement and test case and have clear traceability between them.
• Worked on testing SOAP-based web services and API using SOAPUI.
• Conducted manual and automated testing for functional and non-functional test cases.

Environment: Quality Center, QTP, UAT, Java, Oracle 11g, SQL Server 2005/2008, MYSQL.