SUMMARY:

• Over 9 years of experience in the field of Information technology with emphasis on Software Quality Assurance. Expertise in QA Methodologies, Quality Assurance Life Cycle (QALC) and involved in testing on Data Warehouse projects, Client/Server, Mainframe system, Automation of Web Based Applications(Selenium) and Business Intelligence Solutions.
• Excellent Experience in preparing Test Plan, Test Summary Reports, Test Cases and Test Scripts for Manual Testing based on the User Requirement Document and System Requirement documents for the Black Box, Functional, and System, Integration, Regression, UAT, Security, Load, Database, Smoke/Sanity and Usability testing.
• Extensive knowledge and experience of Selenium IDE, Selenium Web driver, Selenium Grid using Core Java and Python for developing automation scripts in Eclipse IDE
• Excellent Knowledge in OOPS (Object Oriented Programming System) concepts
• Excellent Experience in using ALM/Quality Center, QTP, Clear Quest, Clear Case, and JIRA.
• Used deployment tools like Jenkins/Dev Ops for the continuous integration.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Informatica.
• Experience in Data ETL Testing (Informatica 9.1), BI testing (Cognos 10) & Data Migration Testing.
• Experience in Mainframe system.
• Expertise in QA methodology and Software Development Life Cycle (SDLC).
• Experience in working with EDI HIPAA X12 Transactions (834, 837 I/P/D, 835, 820, 270 / 271, 276 / 277/277U, 278, 997) for both versions 4010A1 and 5010.
• Strong Working experience on different Software Development Methodology with respect to Water Fall to Agile models
• Experience in working with UNIX environment and Shell scripting.
• Good working knowledge in SQL and PL/SQL language with expertise in TOAD.
• Involved in validating reports developed in Cognos.
• Defect tracking, creating test summary reports and documentation of the results
• Experience in writing the SQL queries. Performed backend testing and data validation by writing SQL queries. Experience in working with UNIX.
• Experience in Verification and Validation and Embedded Software system projects in Automotive.
• Multitasking and prioritizing projects, as well as the ability to appropriately set & manage expectations.
• Create, review and maintain test data and test results documentation. Document and report software defects using specific tools.
• Able to work in fast passed environments, as part of a team, with minimal direction.
• Excellent written and Verbal communication & interpersonal skills
• High degree of initiative and ability to learn and adapt to new tools and technologies.

TECHNICAL SKILLS:

Operating Systems: Windows XP/ 2000/ NT/ 95, Linux Red Hat, Unix, MS - Dos, Mainframe

Languages: Cobol, C, Visual Basic 6.0,Java/J2EE

Automation Tools: Selenium 2.0, Selenium IDE, Web driver, QTP, Python

Database: Oracle 11i/9i/8i, SQL Server, DB2, MS Access, PL/SQL

Bug Tracking Tools: Quality Center, PVCS Tracker, Clear Quest, Jira

Languages: Java, ASP, XML, JavaScript, VB Script, TSL, Python Script

Office Applications: MS Office 2003/ XP/ 2000/ 97/ 95, Visual Basic For Applications (VBA)

EDI Standards: Spec Builder 6.2/7.0

Methodologies: Agile & Scrum, Rational Unified process, Waterfall

Others: CICS, JCL, VSAM, SPUFI, ISPF, FileAid, Xpediter, CAN

PROFESSIONAL EXPERIENCE:

Confidential, Watertown, MA

QA Analyst

Responsibilities:

• Reviewed the RTM(Requirements Traceability Matrix) and created the Test plan and test cases for all HIPAA EDI Transactions for Iteration Testing, Integration Testing and System Testing
• Involved in Manual Testing of the application.
• Reviewed the HIPAA 5010 documentation for HIPAA transactions and preparing the Test plan and Test cases
• Conducted functional, system, data and regression testing.
• Interacted with the Developers and BA for bug fixes and problem resolution
• Wrote SQL statements to extract data from Tables
• Worked with transactions and validated the data by using SQL.
• Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
• Involved in Bug Review meetings and participated in weekly meetings with management team.
• Provided testing results and weekly status reports to the QA Manager
• Using FTP we upload and download files for testing data
• Using Text pad to validate the data
• Performed Smoke, Integration, Functional, Regression, and System testing.
• Verified the Web screens against the mockups.
• Worked Extensively with Inbound 837I / 837P / 837D claim transactions for 5010
• Involved In loading the flat files into Oracle Database and involved in writing Complex SQL Queries.
• Involved in writing Complex SQL Queries using TOAD to validate the loads.
• Run the scheduling jobs to load USFHP Claims data from Legacy System to staging tables.
• Run SQL scripts to load USFHP Claims data from staging tables to ODS.
• Validated that all newly required USFHP claims data loaded into Oracle via an initial drop & load.
• Validated that all newly required USFHP claims data changes are incrementally loaded into Oracle via the incremental processing.
• Managed testing activities like ETL/ DWH Testing, Report Testing according to the testing schedules and scope. Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources/Targets.
• Responsible for testing all new and existing ETL data warehouse components. Run the ETL jobs to load data into Source to staging tables and verified the data after loading.
• Validated the data on web screens against the data points and database.
• Involved in Cognos report testing and validated the data.
• Maintained Metrics participated in weekly status updates showing the progress of the testing effort and open issues to be resolved.

Environment: Quality Center, QTP, Win Runner, Business Objects, XML, TOAD, Visual Basic, Oracle, SQL, TIBCO BC3.5, Spec Builder 6.2, HIPAA, MS Excel, MS Word, Lotus Notes6.5, JAVA, ASP,SSL, Cognos, Informatica, Autosys, LDAP, TSO/IPF, JCL, DB2, SQL, and File-Aid.

Confidential, Washington DC, DC

Senior QA Analyst

Responsibilities:

• Developed test plans and review the test cases and test results
• Lead the test team in creating the test cases by using the Functional and Technical requirements.
• Performed integration, system, performance, regression testing.
• Wrote defect reports in ALM/Quality Center
• Documented meetings schedules and test artifacts in SharePoint.
• Participated in the design and implementation process for new and existing products, with a focus on understanding the product requirements to provide test plans and scripts.
• Used Rational Functional Tester for functional testing and regression testing
• Participated in status meetings to discuss about current progress of the work and the project.
• Test Plans were written based on User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and implemented into the iDesk Manager
• Performed Manual Testing, Sanity Testing, Smoke Testing, and User Acceptance Testing.
• Performed Functional and Regression testing using selenium
• Documented detailed Test plans and Test scripts and expected results in HP Quality Center and linked the test cases to the requirements.
• Managed testing activities like ETL/ DWH Testing, Report Testing according to the testing schedules and scope. Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources/Targets.
• Responsible for testing all new and existing ETL data warehouse components.
• Tested the web services using SOUP UP tool.
• Performed Backend Testing by using SQL/PLSQL statements for the purpose of database integrity/data validation using TOAD.
• Validated adhoc and standard reports in Cognos.
• Tested the Pipeline and Portfolio reports and validated against the Database.
• Performed Backend Testing by using SQL/PLSQL statements.
• Load data using Informatica and SQL Loader into Oracle tables.
• Run the ETL jobs to load data into Source to staging tables and verified the data after loading.
• Run the stored procedures to load data from staging to ODS tables and verified the data after loading.
• Coordinated with team for Modification Requests and Document Management requests.
• Actively participated in enhancement meetings focused on making the product more effective in real time scenario.

Environment: Oracle 11g, TOAD, SQL Server, MS Office, ALM/Quality Center, HTML, .NET, C#, Java, IIS Server, VB Script, Cognos 10, Informatica 9.1, Autosys, Unix, JIRA, Agile/Scrum project methodologies, Selenium IDE/WebDriver/Grid, Java, Eclipse, Python, IBM Rational Functional Tester.

FHPL Neosoft

QA Analyst

Responsibilities:

• Developed test plans and review with the project team.
• Effectively created Test Cases for both Positive and Negative scenarios for functional and Integration Testing
• Created Functional test cases from requirements specifications.
• Tested the provider registration functionality.
• Using provider portal, submitted claims using front end screens and validate the status and validated the payments.
• Login to the patient portal and verified the claims status and pre authorization status.
• Performed Database Testing and validation on databases using SQL Queries.
• Developed test plans and test cases for testing the various retail applications, in HP
• Executed Manual, Black box testing to verify the functionality to meet the business requirements.
• As senior QA user interface I was responsible for a global corporate online payment platform. I worked closely with java developers, and business teams.
• Mapped test cases with requirements and created traceability matrix in Excel sheet.
• Review test cases with System Analysts and Development team.
• Understanding requirements and Preparing test plan and getting signed off from PM and client.
• Executed the Test Cases for performing Smoke, Functional, Regression, System and Integration Testing
• Communicated the bugs, testing status and testing issues with project manager, QA team, developers during the status and defect review meetings
• Worked closely with development team while developing test cases and scripts, environment setup process, and defect reviewing, analyzing and resolving bugs
• Timely and efficient entering, tracking, maintaining and updating defect logs.

Environment: JAVA, JDBC, EJB, JavaScript, JSP, Servlets, Applets, Web logic, HTML, DHTML, Internet Explorer, Microsoft Office.

Western Union Neosoft

QA Analyst

Role & Responsibilities:

• Analyzed the Specifications and created Test Designs according to the functional requirements.
• Involved in creating Test Plans, Test Cases and Test Scripts.
• Categorized Severity Incidents Reports based on severity and interfaced with developers to resolve technical issues.
• Check the data for premium verification.
• Interacted with Team lead and developers while testing the application.
• Performed different types of testing, Functional, Integration, System, and Regression Testing.
• Validated the Informatica ETL jobs according to business requirement documents.
• Involved in running the ETL jobs from Informatica workflow manager.
• Documented the test cases for Functional and Regression Testing.
• Involved in validating the Cognos reports according to the functional specifications.
• Performed test management and bug reporting using Quality Center.

Environment: HP Quality Center, SQL Server 2008, Web Services, JavaScript, XML, Oracle, Windows NT, Informatica, Business Objects XI, SQL, PL/SQL, T-SQL, Remedy, Share Point