SUMMARY:

• A Strong IT business professional with over nine years of diverse experience in Information Technology with an emphasis on Software Quality Assurance.
• Having experience and worked with banking and finance, Retail, Insurance, healthcare, Derivatives & Forex etc.
• Excellent understanding of the Agile Software Development Life Cycle (SDLC), STLC and the role of Quality Assurance, RUP and Agile Methodologies, Agile PLM
• Technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Expertise in using Testing tools SOAP UI, QTP/UFT, and ALM/QUALITY CENTER.
• Tested applications based on Service Oriented Architecture (SOA)
• Good experience working with Claims Processing ITS, Subscriber/Member enrollment, Billing and Provider applications in FACETS.
• Very strong hands on experience in Black Box and White Box testing techniques using manual and automation test process and tools.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Experience testing mobile applications on iOS, Android and BBOS.
• Experience with Mobile application testing - iPhone, Android, Blackberry and feature phones using Simulator.
• Experienced as a POS tester and tested various POS testing modules
• Expert in working with JIRA, Microsoft Test Manage (MTM).
• Experience with Mobile application testing - iPhone, Android, Blackberry and feature phones Experience in Functional Testing, GUI, Regression, Smoke, System, Integration, Sanity, Black Box, User Acceptance Testing (UAT), End to End testing and Cross Browser testing of Client/Server, Web based & Mobile applications.
• Basic automation testing experience using LoadRunner, QTP/UFT.
• Knowledge in Application Life cycle Management (ALM).
• Hands on experience in SQL Server new features in test environment.
• Extensive testing experience with AS400 Mainframe Technology.
• Expertise in Oracle table data manipulation using SQL queries and UNIX commands.
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Experienced in validating source to target mappings, their implementations via ETL tools, and the testing processes involved in a data warehousing environment.
• Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Excellent in communication, presentation, and interpersonal skills. Good team player with the ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Testing Tools: UFT/QTP, Web Services, ITKO LISA, Selenium, Load Runner, SOPA UI, JIRA, TFS

Bug Reporting Tools: ALM/QUALITY CENTER, Bugzilla, JIRA, Test Director.

Databases: SQL, SB2MS SQL Server, Oracle, MS Access, DB2

Languages: C, C++, SQL, PL/SQL, .Net, JAVA, J2EE, JUnit, HTML

Query Tools: TOAD, MS SQL Server, My SQL, SharePoint 2010 and 2013.

Other Tools: MS Office Suite (word, Excel, Power point, Visio)

Web Browser: Internet Explorer, Netscape Navigator, Mozilla Firefox

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Sr. Quality Assurance Analyst/ POS Tester

Responsibilities:

• Analyzed the various Project related documents such as Business Requirement document and functional requirement documents, use cases documents.
• Analyzed test Plan and test strategies and developed test cases for manual testing.
• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application in an agile environment.
• Developed test cases to validate the POS transactions (coupons, deals, returns), including process and data flow, reports, and interfaces to stores system.
• Prepared automated scripts for Maintenance and Regression testing using UFT/QTP
• Involved in Cross platform and cross-browser functional, integration, and regression testing
• Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline document.
• Expertise in Bug tracking using Bug tracking Tools like JIRA.
• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using JIRA.
• Responsible for back-end testing/database testing, which was done using SQL queries.
• Experience in working with agile methodologies and active participant of SCRUM meetings.
• Generated automated test scripts for regression and stress testing in Windows platform.
• Generated data driven scripts for multi user access for product information module, using the Data pool.
• Updated database tables to manipulate data and to ensure that the new data is being transferred to POS when it is restarted.
• Worked in Agile Testing and participated meetings every day in iterative environment Created and maintained detailed test cases to perform various types of testing in Test Plan module of ALM Quality Center.
• Install, Configure, Maintain, Troubleshoot, and repair Desktop, Laptop and Printer Hardware at Various sites.
• Worked extensively using ISP (In Store Processor) POS terminals, GOT and Scanner in different modules such as Cash, Ordering, Inventory and POS.
• Performed validation tests to ensure that the developed functionality meets the
• Specifications Prior to UAT testing.
• Performed testing on Store Inventory functionalities and its integration with POS.
• Performed bug tracking, including submitting and assigning defects to the application developers using ALM Quality Center.
• Recorded and managed defects utilizing JIRA / ALM Quality Center.
• Participated in walk through and Status Meetings to monitor testing efforts during various testing cycles. Performed Database testing using SQL queries
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Responsible for generating weekly status report.
• Developed test procedures for the role based validations.

Environment: Windows, Agile, ALM Quality Center, MS Office, JIRA, MS Project POS, SQL, Services Oriented Architecture (SOA), XML, J2EE

Quality Analyst

Responsibilities:

• Participating in the requirements analysis and design meetings with DEV, BIZ team for Review and facilitate in requirement freezing.
• Involved in Daily Sprint standup meetings, Sprint Grooming, Sprint Planning, Sprint Review and Sprint Retrospective meetings.
• Responsible for testing web services both on the back end and also the consumers of the web services.
• Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, iOS etc.
• Web services Testing by SOAP UI tool.
• Executing the test cases (manual and automated) and reporting the bugs in Mingle and QC/ALM.
• Worked in all phases of SDLC and software development methodologies like Agile/Scrum, Waterfall etc.
• Involved in System, Functional, End-to-End, Regression, Integration, Black Box, and Ad-hoc, Risk based, Usability and accessibility testing.
• Used agile systems and strategies to provide quick and feasible solutions, based on agile system, to the organization
• Performed data driven testing and parameterization using UFT/QTP.
• Clearly documented and executed Test scripts in Microsoft Test manager
• Followed Agile Methodology to emphasize on real time communication over written documentation and to minimize risk by implementing software test effort in short time sprints or iterations.
• Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Done the API testing Using SOAP UI tool creating customers and Validate in Back end and front end systems
• Functionally validated Web Services delivered in SOAP XML format as provided in specification document
• Used Environmental variables to analyze the execution environment of UFT/QTP
• Experience with Microsoft Test Manager, Experience using Visual Studio Performance and Load testing tools.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Involved in evaluation of the QA issue tracking tool TFS and manage it for the whole QA team.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.
• Maintain the issues, QA logs and Follow up with Issue Owners to close the issues.
• Responsible for Daily Scrum/Standup meetings to discuss updates showing the progress of the testing effort and open issues to be resolved.
• Tested ASA app on different iOS versions.
• Tested Buy Online and Pickup in Store (BOPIS) functionality.
• Tested Credit, Gift Card tendering using cards stored in Passbook.
• Tested Credit, Debit and Gift Card transactions.
• Used SQL queries to access the database for Back-end testing.
• Worked with ETL group for understating mappings for dimensions and facts
• Performed Database Validation Testing and manipulations using SQL quires.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Wrote SQL queries to retrieve data from DB2 databases after data migration.
• Involved in preparing Test Plan and Test Cases based on business requirements.
• Work with Team members to organize data for Testing Web Services for various Client Products.
• Modified and Edited the XML to validate the SOAP UI Services.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Validated the Web Services (SOAP) both Request and Respond Messages.

Environment: Quality Center, UFT/QTP, ETL, Data Warehouse, Informatica, Cognos, DB2, Oracle, MS Office Suite, Java, UNIX, XML, SQL, J2EE, Lotus Notes, Restful Web Services, Etc

Quality Analyst

Responsibilities:

• Performed Functional, System, Security, and Regression & User Interface testing of software applications.
• Participated in daily stand-up meetings to provide QA estimates, testing progress and status of deliverables for the sprint.
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Written SQL queries for checking the Data Transactions and Database Integrity in Oracle.
• Also developed SQL scripts to run complex data integrity test cases and to extract data from the tables.
• Undertook the QA process improvement initiative to move towards standardizing the testing process.
• Prepared SQL queries to retrieve data from the Mainframe database.
• Involved in running Mainframe based CIMS and SOA batch jobs daily to generate daily billing and Service order completion for energy spending of customer Conducted Validations for different FACETS modules Providers, Claims and Membership
• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application in an agile environment.
• Performed “UAT” for 5010 and ICD 10 codes.
• Prepared Test plan and test case for EDI 834 - Members Enrollment.
• Analyzed the FACETS Requirements and conducted gap analysis.
• Involved in testing integration between .Net applications and SQL server where BizTalk being the integration layer
• Responsible for review of requirements from Business Functional Specifications and conducted code as well as application design walkthroughs with Business, development team and test team members respectively.
• Edit claims (EDI Claims) with UltraEdit.
• Tested the HIPAA EDI 837/834 transactions according to test scenarios and verify the data with FACETS on different modules.
• Worked on FACETS User Interface Modernization and Claims enhancements like ICD-10 enhancements etc.
• Gained an understanding of business requirements, current system operations/functionality and any proposed new requirements.
• Helping the Scrum Team understand the need for clear and concise Product Backlog items.
• Developed Test scenarios, Test Scripts and Test cases based on Requirements, Detail Specification Document’s and GAP documents using Rational Quality Manager.
• Used Test Lab module of Quality Center to perform test execution activities by creating various test sets.
• Facilitated all required Scrum Ceremonies while keeping projects on time and on budget Created and executed test plans and scripts to verify software functionality and adherence to business requirements.
• Documented and reported defects within established process and tracking systems using Quality Center.
• Developed Web Services scripts for a Web Service call sing SOAP
• Manually test each and every module of the application and verify against expected results.
• Good knowledge of ISO 9000, CMM Level standards, HL7 and ICD 9/10 code lists.
• Performed the functional testing of HL7 transaction XML format messages.
• Performed Sanity and Smoke Testing of the application manually after each build.
• Understand and develop Web Services test strategy for different services as part of SOA
• Worked with business users, business analysts and SMEs to understand different critical business processes.
• Tested HIPAA EDI Transactions and Code Sets Standards such as 820, 837/835, 270/271, 276/277 transactions.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.
• Extensively utilized Requirements, Test Plan, Test Lab and Defects Modules of Quality Center during STLC.
• Coordinated with the developers on Defects Status on a regular basis.
• Successfully created and executed complex SQL Queries on SQL Server Database using SQL Query Analyzer to verify and validate data.
• Responsible for testing backward compatibility on various proxies of web services
• Participate in various meeting and discussed Enhancement and Modification request.

Environment: Windows, Quality Center, SQL, QTP, Web logic, MS Office Suite, UNIX, Oracle, XML, FACETS, HL7, HIPAA, EDI, SOAP UI, UNIX, VISIO, SOA, Web Services, Etc.

Quality Assurance Analyst

Responsibilities:

• Analyzed Business Requirement Document and Technical Specifications Document to identify Test Scenarios and Test Procedures.
• Worked in Agile Testing and participated meetings every day in iterative environment.
• Involved in identifying high level objectives and scenarios.
• Responsible for Manual Testing and Automation Testing.
• Worked with different modules of ALM Quality Center such as Requirements, Test Plan, Test Lab, Defects and Dashboard module.
• Active involvement in Pre Sales, RFPs and Business cases, Market Analysis of Third Party ALM Capital Market Products
• Prepared various test reports from ALM Quality Center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Created test cases for various modules in MS Excel and exported them to ALM Quality Center for Test Case Management.
• Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, Financing Structure, Portfolio Analysis etc..
• Created and executed Unix Scripting to automate the QA& Database Functions
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Tested trade workflow E2E from initiation on the front end to Recordkeeping system.
• Developed automated test scripts to facilitate regression testing.
• Performed system and integration testing on Trader Application, where traders can enter, monitor, manage & optimize orders in listed and over-the-counter individual equities/stocks, Equity/stock options and fixed income securities. Also validated Traders ability to identify news or price-driven trading opportunities.
• Documented client information, data requirements and functional specifications
• Prepared positive and negative test cases with valid and invalid data
• Conducted system health tests and regression tests after every new build.
• Conducted reviews with clients and User Acceptance Testing teams
• Used SQL queries to validate the data between the backend and the front end
• Uncovered multiple issues related to the data population in the backend database.
• Prepared test scripts for automated testing using QTP.
• Performed Adhoc testing, Integration Testing, retesting, Regression Testing, Positive and Negative Testing on Trading Stocks, Options, Mutual Funds, Account Summary, Quotes, RDC and Transfers.
• Executed the Test Scripts in ALM Quality Center.
• Defects are logged using ALM Quality Center and follow up with Business and Developers to discuss about the issues.
• Actively participated in Walkthroughs and Daily status report meetings.

Environment: C#, .NET, QTP, Windows, SQL Server, Capital Market, Unix, ALM Quality Center, XML, UAT, HTTP.

Quality Analyst / Tester

Responsibilities:

• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developing maps, Analyzing, Trading Partner setup, Trouble Shooting, Software implementation, and using Company's application file to populate X12 transactions.
• Develop, coordinate and support Information Technology Division on all operational requirements of FACETS claims processing system and production management.
• Develop Business Requirements for all 5010 EDI transactions: 270, 270, 276, 277, 278, 820, 834, 835, 837i/o, and 837d and unsolicited transactions (271U, 277U).
• Developed various EDI documents for 837, 820, 270/271 and 835.
• Assistance in-migrating to a new EDI X12 850,810 maps in version 4030.
• Bug Reporting and Tracking using HP ALM/Quality Center.
• Used HP ALM /Quality Center documentation management and defect tracking.
• Strategized implementation of EDI 837 (I, D, P), 835, 277-U, 270/271, 276/277, 278, 820 and 834transactions for the HIPAA 5010 in compliance with the firms policies and evaluated the modified data manual.
• Followed the RUP methodology for the entire SDLC.
• Actively analyzed current business processes (Claims, Billing, Recipient eligibility and enrollment etc.) and worked with management to improve and implement enterprise solutions to ensure compliance
• Running queries against databases to verify the correctness of XML response
• Performed Web Service Testing experience using SOAP UI
• Tested the various Service Oriented Architectures (SOAs), REST service validation and spanning across various web services using SOAP and WSDL across various applications
• Ensured Use-Cases were consistent and covered all aspects of the Requirements document.
• Interacted with the developers to report and using HP ALM/Quality Center
• Conducted the defect report using HP ALM/ Quality Center
• Involved in project status meetings, QA review meeting, and System Test meeting.
• Coordinated and facilitated the execution of User Acceptance testing.
• Gathered requirements for impacted system and business areas for ICD-10 and their needs to embrace the changes

Environment: Quality Center, UAT, SDLC, RUP, SQL, UML, JAD/RAD, MS Visio, MS Project, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Oracle, Rational RequisitePro, Web Based Application (IIS)

QA Analyst

Responsibilities:

• Acted as point of contact from QA team to Project Management, Development, Business Analyst and Business User teams.
• Created ETL Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Extensive testing on the Performance of the Stored Procedures in PL/SQL.
• Created Detailed Test Plan, Test Approach, Test Matrix, Test Strategy documents based on the information gathered through business requirements and design/application walkthroughs.
• Prepared a package of Process Flow diagrams to document the existing system and used UML notations for Object Oriented Design and Documentation.
• Responsible for identifying gaps in the software between core functionality and user defined requirements.
• Used Quality Center bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
• Involved in Usability Testing and coordinating with end users for giving Training on Web Based application.
• Created User Acceptance Test Cases based on new Business Processes that will be added to the existing application.
• Worked with clients to generate IVR Call Flow diagrams (VISIO), report needs and suggested improvements in order to build IVR test plan.
• Exported Manual test cases into Quality Center and maintained the same in the Test Plan module.
• Created and maintained Requirement Traceability Matrix(RTM) to ensure the requirement coverage
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Have good experience in Guidewire - Billing Center product
• Performed test case assignments in Test Lab modules of Quality Center.
• Detected, reported and tracked defects using Quality Center.
• Performed backend testing for data validation using SQL Queries.
• Functionally validated Web services delivered in SOAP XML format as provided in specification document
• Coordinated with Business Users and Development for setting up Test Environment, Test Data and Backend Interfaces.
• Tested the web pages, user login pages according to the user security roles and requirements.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues
• Assist and guide project teams to implement and document standards, procedures, artifacts, and plans consistent with QA and Test deliverables for the project team.
• Analyzed test progress and send weekly progress reports to the Project Manager
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.

Environment: Guidewire Policy Center and Guidewire Claim Center SQL Server, MS Visio, QTP, Quality Center, SOAP UI, MS Excel, MS Access, UNIX, MS Office 2000

QA Tester

Responsibilities:

• Implemented a uniform QA process for dev team, business members and test team to follow.
• Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.
• Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
• Participated in Business Analysis, Requirement review and Technical Specs Inspection.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Expert in writing test scripts manually.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Provided test team status reports on weekly basis to the project manager.
• Created, updated and maintained the Traceability Matrix mapping the requirements
• Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
• Used HP Service Test for XML based Web Methods testing
• Actively participated Agile and scrum meetings, review and developed test scenarios.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Reviewed Functional and Integration requirements.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Performing Multiple rounds of Test Execution using HP Service Test across various releases of services
• Conducted Functionality testing during various phases of the application using QTP.
• Performed Regression Testing by generating QTP scripts based on the business process.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Participated in building automation test scripts based on BPT module of Quality Center.
• Performed Database testing using SQL queries
• Manually performed Backend testing of the application for SQL-Server perform ad-hoc tests to uncover defects and log them.
• Used HP Service Test for WSDL files validation in Web Services testing
• Conducted Regression testing on new builds/versions.
• Run all automated tests in TDD
• Active participant in defining the automation framework (keyword, hybrid) with business users.
• Performed Smoke testing of the application manually after each build.
• Performed rigorous manual testing before a release.
• Used input/output parameter in Web Service Method and operations on HP Service Test
• Conducted Bug review meeting to discuss resolution of issues
• Developed Test scenarios, Test Scripts and Test cases based on Requirements.
• Involved in coordinating with developers and business owners.
• Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.
• Performed Automation testing using QTP.
• Reported difference when confirmed as issues in Quality Center from SME’s.
• Performed backend testing using SQL queries to validate data.
• Detected, reported and tracked defects using Quality Center.
• Conducted the defect report in Quality Center.
• Interacted with the developers to report and using Quality Center.

Environment: VB Scripting, Websphere, Quality Center, QTP, MS SQL Server, Java, Web Services, XML, SOAP UI, TOAD, J2EE, XML, HTML, Etc.