OBJECTIVE:

• To obtain a challenging position as a Software Quality Assurance Analyst and add value to a fast - paced technology company, by utilizing my proven Technical, Interpersonal, Analytical and Documentation skills, abilities and my diversified experience in software quality assurance, to ensure the company’s sustained growth and continued success.

SUMMARY

• 7 years ofexperience inmanual and automation testingonweb based, Client/Server and data warehousing applications.
• Performed planning and development of Test Plans, Test Cases and Test Scenario to meet product’s business requirements.
• Over 3 years of experience in software testing process whichTest Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Strong communication and interpersonal skills and proven ability to test with minimum software specifications.
• High proficiency in Scheduling and Managing resources and activities in QA Team. Ability to work in a team as well as independently.
• Expertise in Data warehouse and Data mart implementations including requirements gathering, planning, dimensional modeling using Star and Snow flake Schemas
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Good Experience on Selenium IDE and creating Scripts in selenium -RC by using Java
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Experience with Manual Testing using Quality center/Application Life Cycle Management (ALM).
• Tested the ETLInformaticsmappings and other ETL Processes (Data Warehouse Testing)
• Expert knowledge ofBusiness Analysis methodologiesanditerative Systems Development Life Cycle (SDLC);Agile, Scrum, Waterfall, etc.
• Extensively executed SQL queries on SQL Server and Oracle database in order to validate the data.
• Strong knowledge of usingSingle and Multiple protocols in Loadrunner Vugen like Web Http, WebSevices, Ajax Tru Client.
• Experience in working with open source toolsSelenium (Selenium IDE, Selenium RC, and Selenium Web Driver).
• Excellent working knowledge of Oracle 10g/9i, MS Office, TOAD & MS SQL Server 2000.
• Participated in UAT and wrote Test Cases for UAT.
• Experience in testing Web-based (Java, .Net applications), Mobile Testing, Data warehouse and Client-Server applications on different environments.
• Created various Scenarios using Load Runner Controller.
• Implemented Sanity Testing, Smoke Testing, White Box testing, Black Box Testing, GUI Testing, Functionality Testing, Positive and Negative Testing, System Testing, User Acceptance Testing (UAT) and Regression Testing of Web Based Applications and Client-Server Applications.
• Experience in Enterprise Defect tracking tools like HP Quality Center, JIRA
• Maintained the Requirements Traceability Matrix (RTM), Test Matrix and also performed Gap Analysis.
• Professional expertise in MS Office and MS Project.
• Ability to quickly understand and interpret business requirements.
• Participated in Walkthroughs and Inspection meetings to review Test scripts and results.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP, Windows NT/2000, UNIX

Testing Tools: ALM HP Quality Center, QTP, Load Runner and Selenium, SOAP UI

Mobile Devices OS: Apple iPhone SDK, Apple iOS (V4, V5), Android SDK (3.0, 4.0)

Reporting Tools: Quality Center, JIRA, MS Project Manager, COGNOS, INFORMATICA

Databases: Oracle, MS SQL Server, MS Access

Web Technologies: HTML, XML, JAVA Script, VB Script

MS Office Tools: MS Office, MS Visio, MS project

Programming Languages: C, C++, Java, SQL, VB, VC++

PROFESSIONAL EXPERIENCE

Confidential, McLean VA

Sr. EDI Analyst/QA

Responsibilities:

• Provided day-to-day guidance for the assigned team members on the enrolment reconciliation team.
• Identifying and solving customer information and processing problems
• Applying triage, research, collaboration, and technical knowledge to resolve transaction and processing issues.
• Responsible for conducting research, workflow investigations, business procedures and making recommendations.
• Supported development and implementation of case analysis work for reconciliation of data from the health insurance exchanges.
• Tested HIPAA specific EDI transactions for claims, member enrollment, billing transactions.
• Perform troubleshooting and resolve errors in 834 and 820 transactions for health insurance exchanges.
• Perform Root Cause Analysis.
• Tested the EDI transactions sets X12 820, 834 Enrollment.
• Worked on 834, 837 XML and X12 while testing the new functionality for commercial insurance.
• Identified and solved customer information and processing problems.
• Created detailed flows for EDI 820, 835, and 837. Covered all business scenarios and validations.
• Analyzed discrepancies in the eligibility reconciliation process for multiple stakeholders.
• Performed continuous process improvement of the reconciliation process.
• Provided content surrounding the transactions and the reconciliation process.
• Analysis of discrepancies in the eligibility reconciliation process for multiple stakeholders.
• Complete assigned casework for the various states for the tax reconciling on the 1095-A forms.
• Resolved few of the enrollment issues for policy start and end dates, APTC, SLCSP premium amounts.
• Review and monitor project activities to identify risks, issues and quality assurance concerns through participation in meetings, interviews and formal assessment tools.
• Provided content to and for collaboration with training staff on training stakeholders on triaging transactions and the reconciliation process.
• Address discrepancies in reconciliations
• Participated in testing and documentation of issues, case analysis documentation.
• Work with the technical and development team to resolve identified issues in a timely manner
• Review documented training material for accuracy and assist in end user training and support
• Employee is expected to undertake any additional duties as they are assigned by their Manager

Environment: FileZilla FTP, Windows 2000/XP/VISTA, Oracle SQL, Microsoft Office, XML Spy, Agile, Scrum.

Confidential, Jessup PA

Sr. QA Analyst

Responsibilities:

• Analyzed Business Requirements and prepared Test Plans
• Reviewed the Business & Functional Requirements and Solution Design Documents.
• Designed, scheduled and executed test plans within the predefined timeframe.
• Performed Functionality and Data driven testing manually.
• Designed, communicated, and enhanced QA/testing plans for the Application
• Executed SQL statements to check if the data integrity TEMPhas been maintained.
• Executed SQL statements to test the integration between application and database
• Performed negative and positive testing using SQL Queries
• Various tests like Smoke tests, functional tests, Integration tests, regression tests, and user acceptance tests were performed.
• Responsible for attaining HIPAA EDI validation from Medicare, Medicaid and other payers of government carriers.
• Done testing of consumer web portal for the enrollment of Medicare members.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Involved in Testing Web Services using SOAP UI.
• Used SQL queries and UNIX script to validate the data between the backend and the front end
• Conducted Backend testing writing extensive SQL queries.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Used HP ALM Quality Center11.0 and as the bug-reporting tool and testing tool.
• Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.
• Extensively used Load Runner for generating the automated test scripts.
• Developed Base line scripts in order to test the online transaction of the application.
• Analyzed User Requirements attended Change Request meetings to document changes and implemented procedures for test changes.
• Logged the defects using the defect module in QC.
• Customized Quality Center to suit the requirements of testing effort.
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC.

Environment: FACETS 5.1, HP Quality Center, Load Runner, SOAP UI, Service Now, Windows 2000/XP/VISTA, Oracle SQL, XML Spy, Agile, Scrum.

Confidential, San Francisco, CA

Sr. Quality Engineer

Responsibilities:

• Prepared Test Plan and Test Cases according the business requirements.
• Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.
• Experienced working with business analysts, developers, management and end users in a cross functional Agile Scrum team.
• PerformedFunctional,Negative,Positive, Integration,Regression,End to EndandUser Acceptance Testing.
• Involved in preparing QA sizing document and QA Sign Off document based on the Test Plan approved by the Project Manager, QA lead and developers.
• Developed test cases after analyzing the specifications document.
• Used HP ALM Quality Center11.0 and as the bug-reporting tool and testing tool.
• Writing test cases to test the Performance of the application manually.
• Conducted Functionality and Regression testing during the various phases of the application.
• Involving in writingSQL queriesandDatabase Checkpointsto verify data quality and calculations, reviews
• Execution of test scripts using Selenium.
• Worked with System Administrator closely in setting up QA and testing environment
• Involved in the gathering of Business Requirements, Functional and System Specification.
• Created Test cases and Test matrices for integration and system testing.
• Validated web services using SOAP UI.
• Worked on Test scenarios for GUI, Functionality, Security, Database and Regression Testing
• Performed usability testing and Back End Testing manually.
• Created Rendezvous points to create intense Virtual user load on the server, configured the scenarios before executing them in Load Runner.
• Prepared Test Cases, Vugen scripts, Load Test, Test Data, Execute test, validate results, Manage defects and report results
• Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server.
• Performing backend testing of the DB by writingPL/SQL queriesto test the integrity of the application and Oracle databases.
• Used Altova XML Spy for comparison of XML Files.
• Coordinating with Lead in gathering requirements, tasks and updates on the project.
• Created and executed Manual Test scripts to verify complex system requirements and database testing. Transaction Verified through Data Verification of Backend Database using SQL Queries
• Used various techniques like Ramp up, Ramp down, Transaction Point in Load Runner.
• Performed Manual Testing for Screen Navigation.
• Created and maintained test matrix and tractability matrix.
• Reported problems/bugs found using Quality Center
• Wrote Test scripts for the Data Integrity Testing and Back End Testing
• Conducted result analysis and interacted with developers to resolve bugs.
• Participated in the walkthroughs and project meetings.

Environment: HP Quality Center, Load Runner, SOAP UI, Selenium, Windows 2000/XP/VISTA, Oracle SQL, XML Spy, WebSphere Application Server, Agile, Scrum.

Confidential, Yonkers, NY

QA Analyst

Responsibilities:

• Responsible for the execution for the project life cycle, including requirements gathering, design, testing, implementation and documentation, as required.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using HP Quality Center.
• Customized Quality Center to suit the requirements of testing effort.
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC.
• Organized and conducted extensive JAD sessions with users to identify and understand requirements.
• Created documents dat incorporated both the technical and functional details.
• Initiated test plans, develop and execute test cases and scenarios; worked with users to develop specific acceptance criteria and prepare test exhibits.
• Performed Positive and Negative Testing Manually.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in ETL process testing using Informatica ETL tool.
• Provided reports and other documentation on projects to client and internal staffs, as needed.
• Created TEMPeffective Mapping Document to support interface mapping.
• Tested the ETL mappings from Source to Target.
• Maintained accurate eligibility records for individuals and/or assigned employer groups
• Authored test case scenarios in Excel spread sheet and export them into Quality Center.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Responsible for doing the gap analysis for the interfacing system.
• Tested the mapping and integrity of data populated in the database usingSQL scripts in SQL*plus.
• Performed validation usingPL/SQL,Worked withUNIX shellscripts extensively.
• Processed all enrollment, plan changes and disenrollment transactions
• Responded promptly to customer inquiries relating to members' eligibility status.
• Facilitated requirements gathering activities, including meeting with users to discuss System Task Requests (STRs),
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Wrote complex SQL queries to perform the Back End Testing of the Oracle database using SQL.
• Performed Security Testing on the application.
• Authored test case scenarios in Excel spread sheet and export them into Quality Center.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.

Environment: HP Quality Center, MS Office, Windows 2000/XP, Oracle, SQL, SQL*Plus, UNIX Oracle SQL, XML.

Confidential, Manhattan, NY

Sr. QA Analyst/Data Analyst

Responsibilities:

• Created documents dat incorporated both the technical and functional details.
• Defined data mapping rules and created source data for the Data stage ETL.
• Performed Unit, Integration, Smoke, Functional, Regression and system testing.
• Used Quality Centre for preparing the Test Plans and manual Test scripts.
• Reported Defects using Quality Centre.
• Used SQL queries and utilities to transfer data and databases between different Test environments dat are located on different Servers.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Worked on different claim types like COB (Benefit) claims, Q-care claims, & Medicare claims.
• Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Enrolled members through online screens and 834 Transactions to Facets.
• Modified the 834 file and tan checked if the eligibility enrollment is properly loaded onto Facets.
• Involved in testing the Pharmacy claims and Hospital Claims.
• Involved in testing the Medical and Dental claims.
• Checked database and with application queried result is being equal, SQL queries is being extensively used to check the data from the data base using Toad.
• Tested theMembers, Providers, Facets WorkflowandClaimsinFacets.
• Ability to work from functional Specifications to write test plans.
• Performed backend testing using SQL queries and verified data Integrity.
• Recommend opportunities for reuse of data models in new environments.
• Documented requirements using Use Case (UC) analysis for the development team. Also, stored the documentation in a common SharePoint Repository for version control.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems including Oracle and Teradata.
• Worked on Data Mapping to map Facets data to outbound eligibility extracts
• Wrote complex SQL queries to extract and validate the data from the Facets database
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards.
• Bug reporting using HPQC.
• Worked with the Developers and the Test Lead to verify theTest Cases.
• Designed and AnalyzedTest casedesign document basing on theFunctional Requirement Specificationsto implement through testing process.
• Functioned as a back-up for other Eligibility Analysts as needed, completing tasks timely and accurately.
• Entered numerous claims for testing purposes to ensure accurate and quality adjudication and implementation of business and operational requirements.
• Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer.
• Data mapping of project data elements to existing systems.
• Analyze data and perform gap analysis.
• Worked on Data Mapping to map Facets data to outbound eligibility extracts
• Wrote complex SQL queries to extract and validate the data from the Facets database

Environment: HP Quality Center, Windows 2000/XP, Oracle SQL, QL server SSIS, SQL server SSRS,PL/SQL, Toad,XML, XSD, XML Spy XML/HTML

Confidential, St. Louis, MO

Software Quality Analyst

Responsibilities:

• Developed and execute test cases, test scenarios and followed-up defects.
• Involved in preparing test plans and test cases based on system and business requirements.
• Prepared the Test Plan and Test Cases based on the functional specifications.
• Created and Maintained test Requirements in Quality Center
• Experience in Provisioning and Unprovisioning Modem.
• Extensive knowledge in troubleshooting modems.
• Used Apache Axis utility to generate client for Web Services, executed Web Services using Eclipse Java IDE and SOAP UI.
• Documented defects in JIRA General Access (JRA) and helped DIA team & developers to identify the performance issues and modules to be fixed.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Implemented system tests of STB hardware, STB software, audio / video test resources, conditional access, and security.
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using PVCS tracker, QC and Rally.
• Prepared Test Plans and Test Cases for both positive and negative scenarios and mapped to testing requirements in Quality Center.
• Record and run tests usingQTP.
• Installed, configured SOAP UI to test web services using WSDL file given by Development team.
• SQL Query testing for Address Book and Cisco IPMA testing.
• Extensive Knowledge and experience in Mobile Application Testing.
• Installed and Validated the applications on Apple ( iPhone) Android Family ( Samsung, LG, HTC)
• Studied User Requirement Specifications (URS) and converted them to Functional Requirement Specifications (FRS) and Software Requirement Specifications (SRS) for application modules.
• Used Quality center to import test data, keywords, and test cases.
• Performed Positive and Negative testing manually.
• PerformedMobile Testingand Automated Mobile Simulator using QTP
• Performed Usability, Functionality, regression, positive and negative Adhoc, Interruption, VIP, API, STB(Motorola vip 1200), VOD functionality,Network testing(wifi, 3G, Offline Mode), DVR, provision-testing (U 0),Master a/c as well as sub a/c.
• Conducted STB end-to-end system integration testing using digital video broadcast system comprised of video encoders, multiplexers, conditional access module, and video-on-demand server to validate new or upgraded features and/or functions prior to full deployment
• Bug reporting, tracking and documentation on the Bug tracking System using Quality Center.
• Analyzed the results of manual and automated tests.
• Performed GUI/ Usability Testing.
• Participated in daily defect tracking conference calls with developers and DIA team.
• Participated in requirement walkthroughs and creation of test plan.
• Conducted Gap Analysis to ensure all Business Requirements were covered by test cases.
• Performed Sanity Testing and Smoke Testing.
• Interfacing with developers to resolve the technical issues.
• Attend meeting with Marketers to perform Usability Testing.
• Developed strong working relationships with key business and IT decision Makers
• Responsible for coordinating, facilitating, troubleshooting, and maintaining the overall integrity of the production environment.

Environment: HP Quality Center, SOAP UI, JIRA, Android (All Devise), Windows 2000/XP, Oracle SQL, XML/HTML, iOS4/5, Android 2.2, Black Berry OS 7.0, HTC (evo, google), Tablet editions (iPad, Samsung Galaxy), Windows based OS smart devices