PROFESSIONAL SUMMARY:

• 7+ years of diverse experience in Information Technology with an emphasis on Software Quality Assurance.
• 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, 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.
• Experience in testing Web Services and IVR applications (Touch Town, Power Speech)
• Expertise in working with various mobile devices such as Android, Blackberry, IPhone, tablets to perform browser compatibility and configuration testing.
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Expert in working with JIRA, Microsoft Test Manage (MTM).
• Experience with Mobile application testing  -  iPhone, Android, Blackberry and feature phones using Simulator "Device anywhere" “Perfecto”.
• 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).
• Exclusive experience in testing and development in SharePoint 2010.
• 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.
• Highly detail oriented, organized, analytical and efficient in approach
• 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:

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

Testing Tools:  Calabash, QTP, Quality Center, Bugzilla, LoadRunner, MTM, WinRunner, TestDirector, SOAP UI, JIRA,

Operating Systems:  Windows 7, Windows, Unix, Linux, Android, iOS & Mac

Web Technologies:  ASP, ASP.NET, HTML, DHTML, Java Script, VB Script, XML

Development Tools:  Visual Studio, Eclipse, TFS

Version Control Tools:  VSS 6.0, CVS, Team Foundation Server (TFS)

Others: SharePoint, MS Project Server

Mobile Devices:  Iphone, Ipad, HTC, Samsung android devices, Blackberry, Windows phone

Bug Reporting Tools:  Test Director, Quality center, Rational Clear Quest, Ab-Initio (ETL tool)

SDLC:  Waterfall, Agile, Spiral, RUP.

Business Applications:  Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook.

RDBMS:  SQL Server, Oracle.

Professional Experience:

Confidential, NJ

Sr.QA/Mobile Tester

Responsibilities:

• Participating in the requirements analysis and design meetings with DEV, BIZ team for Review and facilitate in requirement freezing
• Planning all the testing activities (Test Planning, Test Estimation and scheduling of QA activities, Test Strategy, Test Case Design, Requirements Traceability matrix, Review, execution and Reports) 
• Performed Mobile application testing - iPhone, Android, Blackberry and feature phones using Simulator "Device anywhere" "Perfecto".
• Responsible for analyzing system requirements and developing a test plan for the project based on SDLC. 
• Tested the UI of the end product on mobile, PC, Android and Apple platforms to ensure that language translation and currency conversions were displaying as required 
• Requested different versions of iOS, Android and Blackberry mobile devices 
• Worked on a E-Commerce Web-based application accessed by potential customers for all the different offerings
• Worked with java based applications and C++ simultaneously: iOS and Android 
• Planning and execution of Installation Testing, Smoke Testing, Functional Testing, Regression Testing, Integration Testing, System Testing, usability testing, Compatibility Testing, Performance Testing and security testing. 
• Executing the test cases (manual and automated) and reporting the bugs in Mingle and QC/ALM.
• Mentoring and Monitoring the QA Team, troubleshooting any technical problems. 
• Responsible for entire test automation process utilizing QTP (QuickTest Pro) and Perfecto Mobile for mobile apps.
• 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
• Develop and modify comprehensive test plans and test cases from business and functional requirements for POS/.Net applications and AS400/POIN
• Used SOAP UI for XML based Web Methods testing
• Modified and Edited the XML to validate the SOAP UI Services. 
• Collaborating with development team and project managers in test execution and communicating all the issues. 
• Sterling OMS Integration Testing (using Sterling API & XMLs) and Functional testing of the Pricing Module which deals with most complex calculations and business rules involved for Promotions, Offers and Discounts which had more than half of the total test cases, after optimization
• Generating project status reports/metrics and updating project plans and Tracking them. 
• Involved in testing the functionalities related to sales tracking, POS scanning, ordering forecast, adjustments, custom retail price and promotions in POS.
• Involved in Integration, Regression, Functional and End to End testing on Store and Merchandising application interfacing with POS. 
• Coordinating and leading the reviews and inspections and follow up on ongoing test activities. 
• Performing various types of testing which includes Positive Testing, Negative Testing, Functionality Testing, Regression Testing, User Acceptance Testing (UAT), and Integration Testing. 
• Conducting QA status/Defect triage conference calls with US clients and reporting the status to QA Manager. 
• Analyzed Business and functional requirements to derive test plans, test cases, procedures, and expected results for testing web enabled data warehouse applications. 
• Used SQL queries to retrieve data from Enterprise Data Warehouse (EDW)/Teradata and validate them, tested on the Mainframe for data validation.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems.
• Providing regular feedback/status on development and projects to Project Manager. 
• Involving in interviewing the new candidates for the project and providing training and mentoring support on all QA activities. 
• Performed Order management system (OMS) and its integrated system- API test
• Publishing the application in production for all platforms (Android, BlackBerry). 

Environment: Oracle 10G, Java, Asp.net, ALM/Quality Center, Quick Test Pro, HTML, UNIX, Web logic, Emulator like Device Anywhere, OMS, POS, perfecto mobile, Android SDK, Windows Mobile SDK, IOS, Blackberry OS, Android OS, VB Script, DHTML, and XML.

Confidential, Salt Lake City, UT

QA Tester

Responsibilities:  

• Analyzed Business Requirement Document ( BRD) prior to preparing the test cases for loan and mortgage underwriting module
• Wrote Test Cases for functionalities of the modules based on the requirements
• Interacted in Peer Review to verify the accuracy of the test cases against requirements.
• Created a Traceability Matrix to map test cases with requirements to ensure complete test coverage of functionalities for customer look up and loan approvals.
• Executed Smoke Testing of the application once deployed in testing environment as part of entrance Criteria of loan approvals, disbursements and payoffs.
• Used Black Box Testing to ensure that the loan and mortgage reports can be printed accurately for sales teams for forecasting and targets
• Design and develop enterprise or application architectures and RFI/RFP delivery solutions using SOA (Service Oriented Architecture), web services, DODAF (Department of Defense Architecture Framework), and segment architecture.
• Performed System Testing to review the system's ability to accept loan processing and decline unqualified loan applications.
• Engaged in UI Testing to test the usability, look and feel of the application based on the customer's specifications of loan and mortgage functionalities.
• Performed Functional Testing for the loan look up module by customer id code to search in different branch locations.
• Good exposure in Banking, Credit Card Services, Financial Services, Health Domain, Insurance, Merchandising and Retail Services Domain.
• Detected, logged, tracked and documented Defects using Clear Quest and followed up with developers till the defect got fixed. 
• Enhanced customer online experience by following the QA Process with online banking
•   Worked on  SOA - WebServices Technology, Validated Request and Response XML using SoapUI tool.
• Conducted Regression Testing after the defects were fixed to make sure other components of the application is still working properly. 
• Involved in creating Test plan, Test scenarios, Test scripts and executed Test cases for Internal and external transfer activity, Online Money Movement, Pay bills, Add Biller, Pop Money, Step up, Branding, Touch ID, Overdraft, Pricing and Agent Desktop.
• Tested web and client server architectures which using variety of programming languages, architectures, and standards like J2EE-Java, .net, n-tier architecture, and service oriented architecture (SOA ) and SaaS.
• Excellent Knowledge across various domains like Retail, BFSI,  Credit Card and Insurance 

Environment: Waterfall, Windows-7, Java, Oracle 10g, Quality Center-10.0, Toad- 9.0, Windows NT/XP, MS Visio, MS Word, Clear Quest, MS Excel, MS Access.

Confidential, Madison, WI

QA Analyst/Tester

Responsibilities:  

• Analyzing Business Requirements, Business rules and Technical Specifications
• Created test cases and test plans for testing the ETL processes and reports. 
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL and PL/SQL queries. 
• Analyzing EDI transaction Claims, Remittance, Claims Status, Member Eligibility, Functional acknowledgement, and Claim acknowledgement. 
• Performed testing to verify back-end database functionality of the application through SQL Queries
• Wrote and executed complex SQL queries including JOINS to validate Back-end data. 
• Designed Data warehouse ETL informatica test cases for source and target db validation.
• Developed and executed automated test scripts in ETL Informatica. 
• Reporting testing status to Project Management and Project Stakeholder resources 
• Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from bugs. Worked with Trizetto Facets  Modules like claims, member/subscriber and provider. 
• Wrote test plans to incorporate the testing needs of the data warehouse using HP ALM.
• Developing and maintaining Test Strategy and Test Plans across multi project fast paced environment.
• Providing draft Test Estimates and Test Schedules to the project team.
• Tested the Inbound / Outbound Interfaces to Facets and populated XML files. 
• Responsible for testing all new and existing ETL data warehouse components. 
• Ensuring a high level of quality in all testing deliverables, including conducting QA reviews. Identifying and reporting project risks logged against Clarity 
• System Integration testing for  Facets  core modules with external systems. Validated EDI Claim Process according to HIPAA compliance 
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Ability to manage change during the test process.
• Extensively involved in Defect tracking/observations, reviewing and analyzing and reporting test result using Quality Center.
• Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries 
• UNIX Log files and Error logs are reviewed & validate test data
• Worked with different data sources ranging from SCX files, flat files, and Hadoop, Vertica and SQL Server databases. 
• Assisted extensively on HIPAA EDI 837 (I & P), 835 and 820, 820s, 270/271 for different business users.
•   Created the Test Claims and adjudicated them to determine the members' payment in the Facets.  
• Tested various Business Objects Reports including Dashboards, Scorecards, Master Detailed, Grouped List & Cascade. 
• Communicated with Users, Managers and business analyst along with Team Leader for understanding the business and database flow.
• Administration of test control and statistics collection (i.e. problem reporting, defect tracking) in JIRA 
• Understood the data model represented in logical and physical enterprise data warehouse schemas 
• Created the Test Claims for Distributed Enrollment files in  Facets.  

Environment: DWH ETL Informatica, BI Business objects, SQL, XML, Web services, EDI, CPT, HIPPA, SQL Server, Hadoop, Vertica, TOAD, Db Visualizer, Putty, UNIX shell scripts, HP Quality Center/ALM, JIRA, Tableau.

Confidential, Detroit, MI

QA Analyst

Responsibilities:  

• Developing and maintaining Test Strategy and Test Plans across multi project fast paced environment
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Informatica Testing and designing of the flow and the logic for the Data warehouse project.
• Providing draft Test Estimates and Test Schedules to the project team. 
• Analyzed the Data warehouse ETL Informatica design documents to understand the logic
• Wrote and executed complex SQL queries including JOINS to validate Back-end data. Reporting testing status to Project Management and Project Stakeholder resources. 
• Responsible for leading a team of testers by providing Business understanding and inputs related to test strategy. 
• Performed testing to verify back-end database functionality of the application through SQL Queries 
• Involved in entire QA Life Cycle, which includes Designing and Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts. 
• Analyzed HIPAA EDI transactions in XML and X12 responses and amended the errors manually by data mapping.
• Used Data warehouse ETL Informatica Power Center Workflow Monitor to trigger master/stand-alone workflows. 
• Good experience in writing SQL in order to data validation in migration as part of backend testing 
• Developed, modified and debugged scripts in Automation frame work using QTP for future release 
• Involved in developing Unix Shell wrappers to run various Scripts
• Tested all the Data warehouse ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Involved in preparing and developing Test plans, Test Estimation Documents, Test Scenarios, and Test Cases
• Mentored and trained analysts in configuring provider contracts and configuring EDI transactions in the  QNXT  claims processing system.
• Involved system testing on EDI transaction 837, 835 for both inbound and out bound. 
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Worked with different data sources ranging from VSAM files, flat files, DB2, oracle and SQL Server databases.
• Communicated with Users, Managers and business analyst along with Team Leader for understanding the business and database flow. 
• Written several complex SQL queries & PL/SQ L stored procedures for validating Cognos Reports 
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Administration of test control and statistics collection (i.e. problem reporting, defect tracking) in Quality center
• Involved in claims submission and payment (remittance) retrievals by using ASCX12N 820 for the In- bound premium payments; ASC x12N 834 for the Inbound Enrollment and Maintenance; ASCX12 276/277 for the claims status enquiry and response; and ASC X12 835 for the Health care Claim Payment
• Validated the SQL server data against the  QNXT.  
• Used Claim Test Pro 4.44 to perform a claims payment system upgrade to a newer release.
• Developed plan for data feeds and data mappings with the use of HL7 for integration between various systems, to follow ICD 9/ICD 10 Code set and ANSI X12 5010 formats.
• xtensive experience in testing SQL Server and Oracle databases, involved in testing back end jobs using SQL queries.
• Supported onsite/offshore team coordination for all fast paced projects. 
• Experience in writing Macro's for validation of huge migration data & validation of reports exported to Excel using QTP
• Validated the reports and files according to HIPPA and HL7  enforced standards.
• Performed HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD 10 coding and HL7
• Responsible to ensure successful data load from several sources systems into appropriate targets. 
• Tested the Members/Provider/Claims Products in  QNXT 
• Validated and captured the error records generating from HEALTH suite error queue, worked and corrected in the EDI Enrollment & Claims errors in the Error Editor and the unworkable errors are routed to WMT to be fixed by Provider & Member's maintenance/Depts.
• Involved in validation from Medicare, Medicaid and other payers of government carriers.
• Tested the HIPPA EDI 837/835 transactions according to test scenarios and verify the data on different modules.
• Worked on  MMIS (Medicaid Management Information System ) for the Medicaid patients Enrollment and their eligibility
• Responsible to verify SQL's for the data validation transformations by guiding the team of testers
• Responsible for process the EDI 834 & 837 X12 transactions to XML files sent from the Trading Partners integrating between HEALTH suite inbound & outbound queues. These EDI files are processed the  EDI  Daemon & Pervasive Data integrating for mapping of the files
• Validate EDI Claim Process according to HIPAA compliance via QNXT . 
• Created and successfully delivered EDI 834, 837 & 278 inbound and outbound Detailed Mapping Document using the RAM HEALTH suite EDI Mapping Guide, Trading Partners Companion Guide and HIPAA Guides
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals.
• Reviewed Functional Requirements Specifications and documented Test-Scripts and executed Test Cases for MMIS Medicaid billing system functional areas such as Third Party Liability and Claims Front End
• Inject ADT and SIU type messages into HL7 interface engine to verify interface functionality. 
• Verifying all Communication Points in Orion interface are functioning as expected. 
• Populate patient Demographic information from  HL7  message and verify all the data is populating into application data base. 
• Process Insurance data from HL7 messages into Interface engine and verify mappings and application DB fields are populating relevant data
• Created and maintained sample HL7 messages for different source systems Web and Main frame, mapping doc. / CDSD and using  HL7  Editor Tool. 

Environment: DWH ETL Informatica, BI Cognos, SQL, ICD, HL7,PL/SQL, SOAP UI,QNXT, XML, Web services, HIPPA, EDI, GDE, ETL, Oracle 11g, Claims Test Pro, MMIS, TOAD, QTP, HIPPA, Unix, HP Quality Center/ALM .

Confidential, Madison, WI

QA Analyst

Responsibilities:  

• Leading and managing teams. Guiding, helping and providing required inputs to offshore team members to understand the application by coordinating the work with Onsite Subject Matter Experts.
• Involved in Smoke Testing, Regression Testing and User Acceptance Testing. 
• Responsible for developing key testing work products like Master Test Plan, System Test Plan, Test Report and Detailed Test Plan based on risks and acceptance criteria agreed with the Client.
• Assisting in validating system functionality by creating and executing end-to-end functionality tests at the system level
• Adopted BPT (Business Process Testing ) Framework to design the test cases and implemented successfully.
• Analyzing and verifying test results, providing status and progress reports using Quality Cente
• Ensure the project issues and risks are resolved on time
• Conducted Validations for different  FACETS  modules Providers, Claims and Membership  
• Updating and Tracking defects in Quality Centre and Jira. Working through defect life cycle and work with defect management in support of defect tracking, prioritizing and impact analysis.
• Track the testing and reporting activities like test summary report, test case coverage, required resources, defects summary.
• Involving in stringent reviews of Test Cases to ensure high quality deliverables.
• Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluating the impact of proposed changes in rules and regulations.
• Worked in Relinking Claims with the Policy Administration systems (PAS).  
• Ensuring all the deliverables are on time and delivered with Quality to the Client and adhering to agreed SLOs and SLAs with the Client
• Involved in UAT Testing Activities

Environment: Java, Java script, Struts framework, EJB, PL/SQL Developer, Oracle10g and SQL Server 2008, JSP, TSO, ISPF, DB2, Mainframes, SOAP UI, iTKO LISA,, Guide Application Suite (Policy Center AUTO & Billing Center), Microsoft Project 2007, Microsoft Office Suite (Outlook, Excel, Word, Visio)

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Worked through complete QA Life Cycle and also used QA in Agile Project Methodology.
• Created the User Stories (Requirements), verified the code in development, tested the code in test and worked with the users in all phases.
• Created Agile DTP, Test Summaries at Sprint level and also Release level.
• Analyzed the user requirements and interacted with system architects, developers and business users
• Designed, maintained and executed Automated Integration framework of API/Web Services across multiple test and production environments using  SOA  test.  
• Provided ETL process testing using Ab Initio.
• Tested the transformation and load process (ETL) for Loan Servicing and Data Warehouse from their legacy systems using Ab Initio and provided technical support and hands-on mentoring in the use of Ab Initio
• Extensively used MS SQL Server's Query Analyzer to verify ETL process and end to end testing of the Source data with the Target data. 
• Performed White Box testing . 
• Used Unix Shell scripts to perform the testing on Ab Initio Graphs. 
• Worked on Oracle PL/SQL to run various, complex queries. 
• Developed test plans, test cases, and test script using the Test Director. 
• Executed the Regression test suite scripts in the database.
• Performed functionality, regression and Data Driven testing for various data.
• Tested the data in web-based application TITAN on Internet Explorer browser.
• Attended Change Request meetings to document changes and implemented Procedures to test changes.
• Prepared test cases to test the backend Database by retrieving the data for the tables using SQL.
• Reported the bugs, emailed notifications to the developers using the Test Director.
• Participated in walk troughs and defect report meetings periodically.

Environment : Java, HTML, XML, VB Script, UNIX, Test Director, ClearCase,, Oracle, MS-SQL Server, Web Logic, Ab Initio.

Confidential, Alpharetta, GA

QA Analyst

Responsibilities:  

• Analyzed Business Requirements, Functional Requirement & High level Design documents.
• Designing the IST/ B2C Test plan based on process flow, HLD and use cases. 
• Designed & developed the test cases and Participated in Project Document walkthrough and Review Test Cases in PM meetings. 
• Performed Integration, System testing, sanity/Smoke testing and End-to-End testing, Regression t est to ensure the application is working as expected.
• Involved in preparation of data request based on the project requirements (Business Requirements, Functional Requirements, Application Design Document) for various applications like WirelessAnalysis, Extensively worked on different  Confidential  technologies like GSM, UMTS.
• Involved in data creation for UAT team .
• Coordinated with engineering team on daily basis for data/usage creation. 
• Created test data using Vision billing systems based on the project requirements. 
• Performed regression testing of application for each release and CR Testing.
• Extensively involved in both Positive and Negative Testing and written Test Cases. 
• Worked Closely with UAT Teams and crosschecked the functionality. 
• Developed Manual test cases for Positive, Negative, Functional and Performance Testing.
• Reported the defects to the development team by using defect-Management tools like Web Track .
• Retested the Reported defects once the Developer resolves the issue in application for every release and once it is passed will close the defect in QC.
• Involved in validating the Web Services related to Customer, Account and Transaction Management using the SOAP UI.
• Involved in loading and validating the WSDLS in SOAP UI and preparing the Request XMLs
• Involved in validating the Request and Response XML in SOAP UI Editor
• Involved in API testing -Postman rest client-xml, json.
• Performed extensive SQL queries for validating data against Source and Target systems
• Involved in executing different Shell Scripts to validate the batch job's and also involved in validating the audit logs and Error logs on UNIX servers.
• Involved in using various UNIX commands for file validations.
• Involved in testing of parental control features on Different Hand Sets
• Extensively worked on Build verification and validations make sure it works fine
• Attended the daily status meetings with the QA team and weekly meetings with the Business Analyst and review the Defects with development team & Users. 

Environment: Java, HTML, XML, PL/SQL, Oracle, TOAD, AS/400, UNIX, MS-Access2003, Java Servlets, Jakarta Strut, Tiles, Log4J, Eclipse, Harvest, Web services, Web logic, CSS, JavaScript, Windows XP, SOAP UI.