SUMMARY

• Over 6+ years of IT experience in Sr. Software Quality Analyst and Tester with expertise in manual and automated testing for client - server and web-based applications.
• Excellent working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Have experience working in Agile/Scrum Methodology.
• Expertise in Black Box Testing, Positive, Negative, Data Driven Testing, Keyword driven testing, Modularity Driven Testing, Integration Testing, Regression Testing, Soap UI Testing, System Testing, and Functional Testing.
• Experienced in Functional testing, Performance testing, Integration testing, UAT testing, System testing, Regression testing, Black Box testing, SOAP Testing, Batch Testing and GUI Testing.
• Expert in writing System Test Plans, defining Test Cases, developing and maintaining Test strategies, RTM (requirements traceability matrix) and procedures according to the Business Specifications.
• Proficiency in Defect management, including Defect creation, tracking, and reporting using Industry standard Tools like HP Quality Center/ALM (Application Lifecycle Management) and interacting with development team in fixing bugs.
• Experience and competency using various test automation frameworks such as Data Driven Table Driven, Keyword Drive, Hybrid Automation Framework for QTP (Quick Test Professional)
• Worked on both Mainframe and Java Application Testing.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Job Scheduler
• Generates metrics on test execution, team delivery and identify process and operational improvement opportunities.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Strong knowledge of Structure Query Language (SQL) with experience in backend testing.
• Expert in SQL Testing ( Joins, Unions, Triggers, Procedures in Oracle & SQL server) & RDMS Concepts
• Executed SQL queries manually for back-end testing.
• QA Project Management, Schedule, Estimation, Tracking, Monitoring and control, Risk identification and Mitigation, Triaging, Status reporting
• Provided consulting on QA process improvement for the new business areas in establishing their QA team.
• Writes, revises, and verifies quality standards and test procedures for program design and product evaluation to ascertain quality of software.
• Tests program for validity of results, accuracy, reliability, and conformance to establishment standards.
• Experience in Configuration management & build management process using version control tools
• Extensive knowledge in Investment banking - Equities, Derivatives, Commodities, Fixed Income, FIX Protocol, Mutual Funds, Trade Workflow, Clearing &Settlement .
• Experienced in analyzing project requirements and designing software applications using The Unified Modeling Language (UML).
• Extensive experience in Defect Management life cycle - Raising and tracking the defect to closure.
• Experience in Configuration management & build management process using version control tools.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Flexible, hardworking, fast learner and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Languages: C, C++, TSQL, SQL, Java

Database: Oracle, SQL Server 2012/2008/2005, MS Access.

Testing Tools: Quality Center, Mercury Interactive Tools (Win Runner 7.6/7.2/6.0, Test Director 8.0/7.2/6.0, Load Runner 7.8, QTP (QuickTestPro), SOAP UI

Scripting Language: JavaScript, TSL, UNIX Shell Scripting, XML,HTTP, VB Script

QA Process Tool and Release Management Tool: Serena Team Track,PVCS Version Manager, TortoiseSVN

Browsers: Internet Explorer 4.0/5.0/6.0, Netscape Navigator 4.x

Operating Systems: Windows 9x/NT/2000/XP, UNIX, Solaris, Linux.

Server: Java Web Server, Tomcat, Apache, Microsoft SQL Server 2000.

Domain: Investment Banking, Healthcare, Automobile Insurance

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, California

QA Consultant

Responsibilities:

• Analyze the business requirements and functional specifications.
• Designing test plans and test cases.
• Manually conducted Front-end and Back-end testing.
• Performed Back-end testing to verify the integrity of the database and analyzed the server performance on Mainframe.
• Created test scripts for both Front-end JAVA/J2EE and XML environment and Back-end Testing Mainframe environment.
• Experience designing and implementing software in a shared services model with XML.
• Black Box, Gray Box and/or White Box Testing.
• Before the Load is accepted to test, have performed Soap UI when developing/discovering Web Service clients or implementations and need a tool to test them interactively and/or Create functional and load tests that can be run in a continuous integration environment.
• Experience with HP Quality Center / ALM from requirements to deployment to conduct Release specification, requirement, test planning, execution, and Defect reporting.
• Provides deep functional and technical application expertise on the ALM team.
• Stays up to date on ALM best practices and new technology developments.
• Worked closely in ALM/QC Requirements and Release Cycle Management, Creating and managing Test cases, Executing test cases and adding Defects
• Creates and presents ALM Architecture proposals to the EA team when incoming requirements propose a change in System Architecture or a new application.
• Worked and debugged UNIX Shell scripts during migration of applications.
• Performing Sanity, GUI, Functional and Regression, System Testing and Performance Testing
• Communicating with other team’s members (Development Team, Technical Support, Business Support) in order to resolve the issues
• Investigated software bugs and maintained reports, tracked defects and also interfaced with the programming team to resolve technical issues and ensuring data integrity and Quality.
• Involved in Production Test data validation, auditing and User Acceptance Test(UAT).
• Conduct user-acceptance testing as software is completed, working in tandem with the development team and appropriate business owners of the software
• Participated in project review meetings.
• Defects were tracked, reviewed and analyzed in HP Quality Center.
• Used source code version control system.

Confidential, Minneapolis, MN

QA Consultant

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• PerformedSmoke Testing, GUITesting, FunctionalTesting, Backend Testing, System Integration Testing, Sanity Testing,andUser Acceptance Testing (UAT).
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensive experience in database activities like data modeling, database design, development, database creation, implement database schema and maintenance, data transfer, documentation, availability, integrity, security.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created an SSIS package for reading multiple excel files from the source and added validation before loading into destination tables
• Created an SSIS package which can load multiple sheets in an excel work book dynamically.
• Did an end to end testing of the data in TEST and Production databases after loading the data.
• Created a store procedure which will validate the results and flags it up at the end.
• Used TF Send email task to capture and send the successful & failure emails to the end the users after the package executed.
• Created logging tables for each package in the process.
• Worked on flat files, excel files and csv files in the SSIS packages.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Done data validation for the SSRS reports.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks.
• Developed test plan with testing scenarios from theend user perspective for User AcceptanceTesting (UAT).
• Involved in testing the batch jobs according to the requirements.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Have tested reconcile and incremental ETL loads for the project.
• Worked with the defect tracking tool Serena for software bugs and maintained reports, tracked defects.
• Serena Team track for Automation and High level process, Team track can stream line, automate and tracked Issues/Defects, ITIL-based process, Change Request tracking and Unified Request Management.
• Used XML to test the server components and developed Unix Shell Scripts to assist in QA Testing.
• Automated Test Case scenarios using QuickTestPro
• Enhancing Test scripts using VB Script language.
• Parameterized test scripts for Data Driven, Table Driven, Keyword Drive, Hybridtesting in Quick Test Pro.
• Extensively used SQL Queries for interacting with the SQL Server database.
• Extensively wrote SQL Query to extract data from various database tables for testing purpose.
• Developed automated scripts using Quick Test Pro for regression testing.
• Tested data migration to ensure that integrity of data was not compromised.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: MS SQL Server Management Studio 2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Session log files, Flat files, XML, HP Quality Center, Serena, Web Services, Microsoft Visual source Safe.

Confidential, Detroit, MI

QA Analyst

Responsibilities:

• Validated the reports and files according to HIPAA X12 enforced standards.
• Created test cases for Accounts, Activities, Opportunities, Contacts, and Plans.
• Performed validation testing on the application navigation for various scenarios and reportedthe errors
• Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837
• Involved in testing maps and translated data
• Verified the relationship between accounts, contacts, opportunities, and activities
• Performed thin client testing for the remote users
• Performed custom tables testing to check if they are resolving the foreign key
• Validated the following: 837 (Healthcare Claims or Encounters),835 (Healthcare Claims payment/Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a healthplan)
• Participated in implementation meetings with clients and vendors to establishing an EDI partnership.
• Performed the requirement analysis, impact analysis and documented the requirements
• Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data setelements for designated record set
• Reviewed the Assessment Business Rules Comparison (BRC) document to identify any new,changed, or deleted data elements as a result of the 5010 transaction changes, implementationof additional HIPAA transactions, and ICD-10 changes
• Involved in full HIPAA compliance lifecycle from GAP analysis, mapping, implementationof EDI X12 transactions code sets version and translation of ICD-9 codes into ICD-10 codes
• Involved in enhancing the existing IVR applications to support multiple functionality
• Identified and addressed discontinuity between ICD-9 AND ICD-10
• Review requirements and understand technical recommendations and constraints, and developcomprehensive and accurate functional specifications, Data Mapping, and process flows
• Tested the application manually by executing Test Cases prior to Automation
• Interaction with the developers to report and correct bugs.
• Used JIRA as the Defect Tracking tool and updated the defect logs.
• Verified, fixed and reported issues in JIRA after DEV2QA phase.
• Conducted necessary testing and in-depth analysis to resolve any potential issues prior to rolling trading partners into the production environment
• Created Test Plan, that defines the test environment, phases of testing, entrance and exitCriteria into different phases of testing and resources required
• Identified, built and executed Test Cases and Test Sets for Functional, Error Handling, Navigationand Regression in Test Director

Environment: HP Quality center/ALM, .NET, Manual Testing, JIRA, WTX 8.1, Oracle 11i, Microsoft VisualSource Safe 2008, EDI ANSI X12 V4010/V5010, UNIX, Ultra Edit & Windows 2000,JAVA

Confidential

QA Analyst

Responsibilities:

• Involved in all phases of software development like as Analysis, Design, Coding and Testing.
• Played major role in Coding of application and testing.
• Developed Master Test Plans, Unit & Integration Level Test Plan, Code Quality Assurance
• (acceptance into System Testing) Test Plan, System Test Plan, System Quality Assurance
• & Acceptance Test Plan and Post Implementation Test Plan according to Requirements
• Specifications.
• Developed Base line scripts for complete testing.
• Conducted regression test to verify the errors against different builds.
• Debugging the application and interacting with QA Team and testing teams on a regular basis and help in maintaining the overall quality of the project.
• Converted the Business requirements into manual test Scripts.
• Developed Base line scripts for complete testing.
• Performed Integration testing, System testing, functionality testing (black box testing), GUI testing, Usability testing and trained the users to do User Acceptance Testing.

Environment: Windows, Visual Basic 5.0, Oracle 6i, WinRunner and TestDirector .

Confidential

QA Tester

Responsibilities:

• Developed test plans and scripts for manual testing of Oracle based applications.
• Involved in writing Requirement documents, design documents, test scenarios and test cases
• Involved in setting up the test environment.
• Verifying data source and data integrity using SQL.
• Performed back end testing of the application-using Oracle as database.
• Analyzed system requirements and developed Test Plan for System Testing.
• Interacted with developers and users to resolve critical and major bugs.

Environment: Windows NT, Oracle, Visual Basic, Crystal Reports, PL/SQL