QE,Java,SQL.PLS,Bigdata,Web services testing
Resume:
Experience Summary
Over ** years of IT experience in Software Quality good experience to various programming such as Java, J22e, C#,web-services,sql,data-warehouse, CRM, client server and web-based applications.
• Excellent knowledge and implementation skills in complete Software Development Life Cycle
• Extensive experience in manual and automated testing using both block box and white box methodologies using agile and water fall process
• Good expertise in Object Oriented technologies like Java and J2EE
• Good expertise on automation test on Rest API using Java, TestNg frame works
• Good experience in test automation builds using CI Jenkins jobs and Jenkins pipelines
• Good experience in developed Selenium scripts and page-object frame work for UI test
• Good experience in build the setup and operations for OneOps cloud based environments
• Extensive experience in writing SQL queries on Oracle and SQL Server
• Good experience with SQL,TSQL,NOSQL,for data persisting and retrieval
• Good experience in testing Kafka messaging queues/topics and MaaS (message-as-service)
• Good experience test with JMS, TIBCO-ESB and MQ Series message systems
• Technical expertise in writing test plans, test cases, test scripts, test result summary reports, executing the plans and reproducing the defects with and without using the tools
• Good expertise in root cause analysis and problem solutions based on Impact and risk
• Good working with Web services testing like Restful and SOAP based
• Good experience working with Atlas-Confluence, JIRA, HP ALM to create test plans and bug tracking
• Production Support experience in handling tickets, batch jobs and system issues
• Good experience Mac, UNIX/Sun Solaris environments
• Good experience in GIT, MS TFS systems, industry standard source control management
• Production/UAT support and experience in handling tickets, batch jobs failures and system issues
• Has good experience in e-Commerce Financial, Telecom and Insurance applications
• A very good team player and excellent inter-personnel skills.
Technical Skills
Programming Languages Java1.8, J2EE. Rest-Service, C#, DotNet,
MS Visual Studio, TSQL, SQL,noSql
Automation Tools
TestNg, Spring-STS, git, Maven, Josn, XML, CI-Jenkins,
SOAPUI, Selenium2.0, XML,WSDL,NodeJS,JMeter
Applications Servers Tomcat, Apache Server, Web logic, web-sphere, IIS
Databases/ETL/BigData Oracle 11i, SQL Server2008, Cassandra, Apatch-Solr,
MangoDB,Hive queries, MS SSIS, Informatica,DB2
Operating System Mac OS,Windows 8/2003, UNIX, Linux, Citrix,Vmware,
Scrum/ Collaborative Tools Atlassian Jira, Confluence, HP ALM
Script Languages Java script, shell script, Perl script
Version Control Github, MS TFS, Nexus, Jenkins
WEB Josn,XML, DHTML, Ajax, SOAP, WSDL, XML Spy,
Education
• Master of Computer Applications (MCA) from Kakatiya University, India.
• Bachelors in Computer Science (B.Sc.) from Kakatiya University, India
Work Status
• Permanent Residence in USA.
Professional Experience: Walmart labs e-Commerce Sunnyvale CA June’13- Present
Sr QA Engineer
WalmartLabs help people around the world save money and live better anytime and anywhere in retail stores, online, and through their mobile devices.
Responsibilities
• Managed end-to-end integration testing involving both internal and external (third party) systems.
• Build and Implemented test automation framework (TestNg) for functional and integration testing using Java, spring and SOARI frameworks for automation for Cassandra, Kafka, MaaS for reduced testing time and increased efficiency and throughput of the QE team.
Managed automated build and release processes using continuous integration (Jenkins)
• Build the Test automation for rest web services, Cassandra, Solr
• Woking on Cart&Checkout and Logistics services functionality use cases validation
• Build the Test approaches and test plans and test date and documented on Confluences
• Build CI Jenkins jobs pipelines for Snapshots, release builds, deployment and test jobs
• Search Engine project for testing IQS app and Catalog Item Cassandra and Solar Data
• Woking on Big-Data-Catalog Search project for testing Cassandra and Solar Data
• QA activities including automation and build and deploy on cloud based OneOps servers
• Performed functional and integration US Market Current FE with IMS/MCSE migration project
• Integration/data migration testing using GGO process from Catalog to LM using SQl/PLSQL scripts.
• Preformed the unit/function testing for supply chain SC Scalability adopter functionally for migration
• Participated price match cash saving program test and build test approaches and tests
• Working in Walmart dot com and grocery product UI interface testing with agile environment
• Participated in Prod tickets validation and end to end testing
• Good experience in GIT or SCM systems, industry standard source control management
System (SCM) for repository maintenance
• Attended project status meeting and reported daily/weekly status
Environment Java1.8, J2EE, TestNg, GitHub, Maven, Jenkins, Spring, Restful Service, tomcat, Oracle10g, GGO. SQL, Oracle, DataStax, Cassandra, nosql,Solr,Mango DB, Hive queries, JMS/MaaS, Kafka messages, JMeter,Selenium 2.0, NoteJS, RestClinet, PostMan, Jira, MS office, MacOS
Wells Fargo, Concord, CA Feb ‘12 – June’13
SR QA Analyst
Wells Fargo Business Payroll Services: Opt Right Payroll Solutions offers Combine all customer payroll and
Banking needs under one roof
Responsibilities
• Analyzed and captured the test requirements form FRD and Business requirement documents
• Expertise prepare the system integration test plans, test matrix, test scenarios and result summary report
• Extensively involved prepare test plans, test scenarios and test cases for SQL scripts.
• Performed unit, functional, regression and system integration testing for BPS payroll applications and analysed the test results based on business rules and CR (change request)
• Extensively involved Data conversion using ETL process form EVO System to ‘OPT Right-Payroll System‘ using SSIS ETL selection tool and Data Transformations
• Finding and setup test data for end to end testing meet test execution criteria
• End to End Data mapping and Business rules validation using SQL and Automated Bulk SQL Script frame work
• Validated End to end data mappings with business rules form source to target databases using TSQL server2008 and Oracle10g DBs
• Extensively involved back-end API testing using SQL/PL SQL on Oracle and SQL Server
• Systems using SQL, XML data files validation using beyond compare and XML Spy
• Performed integration testing with batch jobs for regression testing
• Attended project status meetings and co ordination offshore QA team
Environment
C#,.NET, MS Visual Studio,Java, SOAP, WSDL, XSLD, JMS MQ Series, DHTML, Ajax, SQL-Server-2008, SIIS ETL-Conversion-Tool, TSQL, PLSQL, TIBCO ESB Message, MS-Office, FTP, shell-script, PuttyFTP Tools, Java script, ATM HP QC11.5, Windows XPP, Win-2003, UNIX
Bank of America Aurora Hills and San Jose CA Oct ’10 – Feb ‘12
Home loans AI- Artificial intelligence
Q.A. Engineer
Artificial intelligent department of BAC Home loan specializes in providing intelligent middle tire services such as automated under writing, property valuation, business rules, access to credit report and make automated decisions based on borrower information.
Responsibilities
• Developed and implanted system integration test plans, test matrix, test scenarios and result summary report under water fall and agile process
• Analysed and captured the test requirements form HLD and LLD and BRD documents
• Developed test plans, test cases and test matrix for SIT and CIT releases
• Develop and implemented Java automation test for Web Services test using TestNg and Para Soft SOUP UI tool
• Performed system integration testing for AI-CLUES with various Loan origination systems using Web services automation tools Para soft SOUP UI tools
• Extensively involved system, regression and End to end integration testing for AI Artificial intelligence decision making application like credit, price apical applications
• Extensively involved in end to end data mapping and data validation testing for LOS AI Application
• Performed install the AI QA builds in Windows and Sun Solaris servers for regression testing
• Extensively involved back-end API’s testing using SQL and PL SQL on Oracle and SQL Servers
• Integration testing for main frame systems using MQ Series queue massages
• Systems using SQL, XML data files validation using beyond compare and XML Spy
• Performed various batch jobs validation in QA environment
• Performed regression testing using internal ‘XMLDIFF’ tool for CLUES decisions
• Attended project status meetings and coordination offshore QA team
Environment
Java1.6, C#, DOTNET,AI Test tool- J2EE XML, MQ Series, Web Services, Para soft SOAPUI, XML Spy, Beyond compare, XMLDiff tool, SOAP tool, WSDL, JUnit, TestNg, ANT, Maven, LogMon, XSLT, FTP, TCP/IP, Oracle10g, SQL Server2008, Oracle11g, Informatica, BO reports, shell script, P HPQC 9.5,QTP 9.5, MS office 2007, Windows XPP, Win-2003, UNIX/Sun Solaris.
AT&T NIS, San Ramon CA July’08- Sept’10
Software Q.A. Engineer
Network Information Systems develops, deploys, maintains, supports and improves the operation of Network Business & Performance Systems
Responsibilities
• Analysed and captured the business and functional requirements as per the FRD, DDD, ICID documents
• Performed unit, system, regression, system integration and end to end testing for NIS applications on ESB- TIBCO interfaces like providers and consumers applications using web services under Agile environment
• Extensively involved functional, regression, integration and end to end integration testing for NIS applications using web services, Java API Service Bus (ESB) TIBCO system within a Service Oriented Architecture (SOA)
• Extensively involved in end to end data mapping and data validation testing for NIS Integration systems on Oracle 10g,SQl Servers Data base using SQL and PLSQL
• Good experience UNIX/Sun Solaris OS environment and install application rollback on QA labs
• Performed integration testing with Remedy (centralized ticketing system) for generate soft and hard alarm tickets, work orders flow validation.
• Worked and korn jobs (shell scripts) for data extraction test
• Participated UAT support in handling tickets, batch jobs failures and system issues
• Extensively involved in BO reports testing for Network performance systems and Fault Alarms on SQM and SPOT using SQL queries, PLSQL and batch jobs on Unix
• HP-QC for create test requirements, test cases, execution, report defects and traceability matrix
Performed and involved developed and executed Selenium scripts for regression testing
• Attended project status meeting and reported daily/weekly status and expertise prepare test plans and test result summary report
Environment
Java, J2EE, C++, TIBCO-EAB, Web Services, XML, AJAX, SOAPUI, WSDL, JUnit, TestNg, ANT, Selenium IDE, RC, FTP, Putty, Shell Script, Perl.Net, Oracle10g, SQL, SQLServer, Business Objects11.5, Remedy tools, Toad, Quality Center 9.5,QTP9.5, MS office 2007,Windows XPP, Win-2003,WM ware, SunSolaris10.x UNIX
TDC-The Doctors Company, Napa CA Mar’08- July’08
QA Analyst
The Nation one of the largest physician-owned medical malpractice insurer
Responsibilities
• Written test plans and test cases per the requirements
• Test on insurance claims process flow, batch payments and express payments
• Involved integration testing with policy engine systems
• Test Director for test planning, test execution and defect tracking
• Wrote complex SQL queries to check the data loads, data extraction in different stages and perform testing batch jobs and workflows (shell scripts)
Environment
Java, C#, XML,SQL, shell script, Oracle9i, .Net, PL/SQL, Toad, FTP, Citrix, TestDirector8.0, 6.0, MSOffice, Windows XP, UNIX.
Farmers Insurance Group, Simi Valley CA Aug’06- Mar’08
QA Analyst
The Farmers Insurance Group® of companies comprise the nation's third-largest personal lines property & casualty insurance group –Headquartered in Los Angeles and doing business in 41 states, these companies provide homeowners, auto, business and life insurance.
Responsibilities
• Written test approaches, test plans as per the requirements and corresponding to business rules
• Test on CRN Auto claims units, batch payments and express payments
• Extensively involved integration testing with Mainframe FACTS& APPS policy engine systems
• MFI interface Systems using EAI (SOA) MQ Queues Async test
• Web services/integration testing for main frame systems using MQ Series queue massages
• Test Director for test planning, test execution and defect tracking
• Performed check the data loads, data validation, data migration, data extraction in different stages using Informatica and SQL queries
• Performed the application load, performance of the application transaction and workflows
• Check the data loads from EIM tables to Siebel base tables using Siebel EIA (SOA)
• Wrote complex SQL queries to check the data loads, data extraction in different stages and perform testing batch jobs and workflows (shell scripts)
• Performed SQL queries using TOAD for data mapping from APPS to CRN and verifies the data elements.
Environment
Java, J2EE, C++, XML, MQ Series, shell script, Oracle9i, Siebel 6.0 Claim Insurance, Mainframe, CICS, COBOL, filenet, DB2, .Net, VB Script, Toad, FTP, Citrix, VMware, RDC, TestDirector8.0, Informatica 6.0,QTP 8.2,Load Runner 8.0,MSOffice, Windows XP, UNIX.
IPass
Redwood Shore, CA
Developer
Responsibilities:
• Performed white box testing using JUnit and Java API for iPass dialler update phone book products
• Performed, system, regression, integration and Client Front end API testing
• Written complex SQL queries to perform backend testing
Environment:
Java, XML, SOAP, Oracle 8i, JUnit, Shell Script, Perl, Java Script, Toad, Windows 2000/XP, Linux.
Contact this candidate