PROFESSIONAL SUMMARY

Around ** Years of professional IT Experience with Client/Server, Window based and Web-based N- tier architecture systems using Microsoft Technologies and Mainframe applications.

Experience in complete Software Development Life Cycle (SDLC) - Analysis, Design, Development, Deployment and Testing.

Interacted with Developers, Business analysts, Database team, Deployment team, and Release Management in an efficient and effective manner.

Extensive expertise in Functional, Usability, Integration, Regression, System testing, UAT, Security, End-To-End Testing.

Involved in Automated and manual testing of the applications.

Experience in Preparation of Automated Tests within the Keyword driven automation framework.

Extensive experience with Health care, Financial, State projects.

Well experienced in defining and identifying the Test Scenarios based on Requirements, Writing Test Plans and Test Cases for both Manual and Automation Testing and conducted reviews.

Extensive experience in MTM (Microsoft Test Manager) and TFS (Team Foundation Server).

Experience with security penetrating testing.

Developed Test Plans and Test Cases in Rational Test Manager.

Defect tracking using Rational Clear Quest, TFS, JIRA, QC and ALM.

Extensive experience in Backend Testing by Using complex SQL and PL/SQL queries and query analyzing tools.

Good Exposure Knowledge of advance SQL commands, including Joins, Unions, Case statements etc.

Extensive experience with methodologies like Waterfall, Agile, and Scrum.

Experience in handling various backend data sources like MS SQL Server 2000/2005/2008, MS Access, XML Data source, Oracle 9i/10g.

Experience working with Microsoft’s Data Warehousing Tool SSIS (SQL Server Integration Services) and SSRS.

Good exposure in interacting with the clients regarding new requirements, troubleshooting, complaints, suggestions etc.

Experienced in UML modeling, drawing Sequence Diagrams and Activity Diagrams using rational tools such as Rational Rose and Microsoft Visio.

Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.

Solid experience in Black box & White box Testing techniques.

Experience in Audit log testing buy using Splunk tool.

Extensive experience in working with ADA Compliance (Compliance Sheriff & JAWS)

Outstanding problem solving, strategic thinking and data analysis skills, strong focus on teamwork and achieving team goals, result oriented, fast learner, with excellent analytical and interpersonal skills and Excellent communication skills.

Results oriented, with an ability to work with aggressive timelines and deliverables and to see any assignment to successful completion within the established project schedule.

Quick learner, multi-tasker, workaholic, influencing individual and team player with excellent presentation skills and ability to prioritize and organize tasks independently.

Willingness to work in a highly dynamic environment and ready to take up any challenges.

Effective leadership skills with good written, verbal communication and presentation skills.

TECHNICAL SKILLS

Programming Languages

Windows XP. 2000, NT servers, UNIX, Unisys OS1100/OS2200, C#, VB.NET, HTML, SQL, PL/SQL, UML.

Server-side Technologies

Microsoft .NET Framework 2.0/3.5/4.0/4.5/4.6, ASP.NET, ADO.NET, C# Web Services, WCF, Web Forms, Silver light, XAML, WPF.

Web Technologies

ASP.Net, AJAX, HTML, CSS, VB Script, Java Script, JQuery, DHTML, Design Patterns, XML, Web Service, WSDL, VB Script, Tool Command Language (TCL), SQL, PL/SQL etc.

Databases

SQL Server 2005/2008/2012, Oracle 8i/9i, SSIS, SSRS, DB2, MS-Access.

Testing Procedures

Black Box Testing involving: System Testing, Functional Testing, Integration testing, Regression Testing, User Acceptance Testing (UAT), Security Testing, Smoke testing, Test automation, JAWS Testing, Load testing, and Security Penetrating testing

Testing Tools

Quality Center 9.0, MTM 2010/2012/2013, TFS (2010 to current), Win Runner, Load Runner, QTP 9.2/9.5, Rational Requisite Pro, Rational clear Quest, Rational Manual Tester (RMT), Test director, JIRA (defect tracking tool), JAWS

Methodologies

SDLC and Object-Oriented Design, Waterfall, Agile, scrum.

Operating Systems

Windows XP, 2000, Windows server 2003, MS DOS.

Tools

Visual Studio (2005 to 2019), TFS (2010 to current), MTM 2010/2012/2013, LINQ, Visual Source Safe, SVN, Visual Basic 6.0, Microsoft Visio, Rational Rose, Smart Draw, Word-Perfect, PowerPoint, MS Word, Project, Excel, Net Meeting, Web Ex Conference, Microsoft Share point 2010/2012/2013, 2013 office 365, & 2016 and Docushare.

Configuration Management

VSS (Visual SourceSafe 2005), TFS (2010 to current.)

Application Servers

IIS, Windows Server Management.

Protocols and Standards

SOA, SOAP, JDBC, HTTP, HTTP/SSL, TCP/IP, FTP, FTP/SSL

EDUCATION:

Master’s in Computers – M.C.A, India

Bachelor’s in Science - B.S.E, India

AUTHORIZED TO WORK:

US Citizen

CERTIFICATIONS:

Certification for CB CONVERSION CIMS AND AFS

ISTQB certified Tester- ISEB ISTQB Foundation Certificate in Software Testing.

HP0-M 31 Q C 10.0 Certified Professional from HP.

PROFESSIONAL EXPERIENCE:

Client: Commonwealth of PA, Harrisburg, PA. Apr’ 2012 – Present

Position: Senior QA Analyst (Lead)

Environment: MTM, CQ, SQL, NET, C#, HTML, TCP/IP, WSDL, Load runner, QTP, XML, HTML, DHTML and MS Office tools etc.

Project Details: Pennsylvania’s Enterprise to Link information for Children across Networks (PELICAN)

The Pennsylvania’s Enterprise to Link Information for Children Across Networks (PELICAN) project is the Department of Public Welfare’s initiative to design and develop a system that will integrate the Department’s childcare programs under a single management information system; the Child Care Works (CCW) System.

The Online Attendance Tracking initiative is intended to enhance the PELICAN Provider Self Service management for facilitating the online option for submission of monthly attendance information regarding subsidized childcare children.

Roles & Responsibilities:

Review Project scope and identify impact for in scope applications and business areas

Understand and follow Project Test Strategy, including scope of testing, execution schedule, and dependencies

Understand and identify risk, issues, for the testing scope related to their work area

Participate as needed in Project specific testing activities

Work with assigned test leads and provide guidance for definition of test scenarios applicable to the Project scope

Prepare test objectives for test coverage and validation

Participate in knowledge transfer session and validate their test objectives through cross team review

Create test scenarios (detailed steps and expected behavior) and upload to test management tools

Ensure that correct bi-directional traceability is established for linking test cases with the business requirements

Identify and setup test data needed to support test case execution

Scheduled and ran Batch Jobs for ST (System Testing).

Performed database integrity check using SQL software performed functional and System Testing.

Identify test environment readiness for Project test execution

Develop entry and exit criteria for Project test execution

Conducted integration, functional, Validation, regression testing.

Prepare business matrix, regression test matrix, spoke test, Load test matrix and Automation test matrix

Execute test cases and create defects for failed scenarios following the project standards and testing best practices

Ensure that correct traceability is established for linking defects with the test cases

Consolidate Test execution status and report out progress to Test Leads

Provide UAT support and explain tested functionality to the UAT testers as applicable

Participate in defect triage and confirm that the defined defect management process is followed

Escalate issues and risks to Test Leads and Managers, and provide remediation ideas

Develop Project test execution summary based on test execution results

Assist with its finalization of test closure activities such as lesson learnt, defect / execution trends

Client: Blue Cross Blue Shield, MI. Feb’ 2011 – Apr’ 2012

Position: Lead QA Analyst/Senior System Analyst

Environment: NASCO, TPX, Windows, IE and Netscape, HIPAA Validate, EDIFECS 5.1, QNXT Connect from Risotto, NASCO Claims Adjudication, COBOL, JCL, VSAM, MVS, DB2, XPEDITOR, File-aid, Claim Check from BFAST, HP Quality Center, Clear Quest, etc.

Project Details: International Classification of Diseases (ICD-10)

The NASCO ICD-10 program is in response to the Federal Regulation. Mandate requiring the adoption of ICD-10 Diagnosis (CM) and Surgical Procedure Codes (PCS) on HIPAA transactions for services on and after October 1, 2013.Any claim with a date of service or a discharge date on and after October 1, 2013 must contain ICD-10 codes. Any claim with a date of service or a discharge date on or prior to September 30, 2013 will continue to contain ICD-9 codes.

Roles & Responsibilities:

•Involved in business process assessment, requirements gathering and elicitation, gap analysis, and impact analysis of ICD10 workgroup and JAD sessions.

•Create business requirement document (BRD) and technical requirement document (TRD), detailed design specifications and other artifacts for ICD10.

•Involve in forward and backward mapping for ICD 9 to ICD10 migration with General equivalence Mappings (GEM).

•Conduct ICD 9 to ICD 10 cross walk for 837 professional, institutional, dental, and other impacted HIPAA transactions.

•Communicate regularly with project stakeholders, department heads, and PMO to provide status updates.

•Develop several test cases for functional, system, regression and user acceptance tests in Quality Center.

•Involved in Quality Assurance. Involved in all six-level comprehensive test procedures (which includes unit and integration tests), participate in PLOG status and defect report meetings.

•Validate Claim Process according to HIPPA compliance.

•Extensively worked on editing the claims to suit the test scenario in HEHK during the testing process.

•Downloading claims from production to MO and claims adjudication in NASCO HEHK.

•Open & assign defects to Technical team for the failed test cases in CQ and maintain the defect/Triage log.

•Involved Business & Technical Business teams for the Daily status defect triage calls to discuss on open action items/defects for the closure.

•Coordinate with Technical team for the fix deployment to re-test the failed cases.

•Preparation of Cycle end & Level end reports at the end of execution cycle.

•Hands on experience on clearing suspended claims in NASCO through EEC (NASCO Error correction screen.)

•Involved in training, guiding and assigning responsibilities for team of 5.

Client: Commonwealth of PA (UCMS-DLI), IBM, Harrisburg, PA Oct’ 2010 – Feb’ 2011

Position: Senior QA Analyst

Environment: Rational Clear Quest, RMT, RFT, Rational Clear Case, Microsoft Outlook, MS Office, Mainframe (DB2, CICS, JCL, VSAM), Oracle 9i, SQL, UNIX, Internet Explorer, QTP, Java, Windows XP/NT/98/2000.

Project Details: Unemployment compensation moderation System (UCMS)

The department of labor and Industry and IBM began working together starting in July 2006 to replace the antiquated UC legacy systems (mainframe applications). The current technology needs to be replaced, as IT maintenance and support costs continue to rise for the dated system. In addition, the older technology does not fully support the business needs of today’s UC environment. The new system is referred to as UCMS (Unemployment Compensation Modernization System.)

Roles & Responsibilities:

•Involved in analyzing the Business requirements in Rational Requisite pro and System specifications to understand the Application.

•Preparation of Test Plan, Traceability Matrix and Planning Test Schedules.

•Used Rational Test Manager to prepare Test Cases.

•Reported and managed software defects using Rational Clear Quest and interacted with the developers to resolve technical issues.

•Coordinated for Batch Jobs scheduling for ST (System Testing) Team.

•User Interface testing was done to validate so that the navigation of the application properly reflects business functions and requirements, including window-to-window, screen-to-screen, image-to-image, field-to-field and use of access methods.

•Executing test cases on test regions and validating functionality of the new fix.

•Validating that the test data is identified and is available in test regions.

•Modified and maintained the already existing test plans, test cases and scripts to leverage the automation team effort during the regression testing.

•Conducting regression testing and Build Certification using QTP Scripts, verifying no new defects were caused by production fixes.

•Involved in creating QTP Script using checkpoints, output values and functions.

•Executed SQL queries to perform Backend testing.

•Tested the application from the backend level from SQL Query Analyzer in SQL Server.

•Wrote SQL queries to fetch data from Oracle Database and to validate the data created in backend.

•Identified application errors and interacted with developers to resolve technical issues.

•Updated the bug tracking system with the results of testing and filed defect reports for failed test cases.

•Executed all kind of Scenarios for User Acceptance Testing (UAT.

•Involved in automation and manual testing of the application.

•Involved in training, guiding and assigning responsibilities for team of 3.

Client: National City, Cleveland -OH, Aug’ 2009 – Oct’ 2010

Position: Senior QA Analyst

Environment: Rational Clear Quest, RMT, Rational Clear Case, Oracle 9i, SQL, UNIX, Internet Explorer, QTP, Java, Windows XP/NT/98/2000, Microsoft Outlook, MS Office

Project Details:

The purpose of the Consult NC– Information Management project is to replace the existing GIR application with a new and more robust Information management solution for our clients. The expected load on the IM system will be significantly more than on the existing system and the user experience and response time are expected to improve.

Roles & Responsibilities:

•Involved in analyzing the Business requirements in Rational Requisite Pro and System specifications to understand the Application.

•Developed system test strategy to validate end-to-end processing for each of the business processes that are part of the new platform.

•Developed Risk analysis document and assisted project manager in project plan.

•Created test cases, test scripts and executed them.

•Analyzed test data requirements and established process to create test data required to support testing

•Preparation of Test Plan, Traceability Matrix and Planning Test Schedules.

•Modified and maintained the already existing test plans, test cases and scripts to leverage the automation team effort during the regression testing

•Used Rational Test Manager to prepare Test Cases.

•Involved in creating and maintain QTP Scripts.

•Used Regular expressions in QTP to validate pop ups windows.

•Conducted functional, GUI and regression tests.

•Identified application defects and interacted with developers to resolve technical issues.

•Defect Tracking done using Clear Quest.

•Executing test cases on test regions and validating functionality of the new fix.

•Validating that the test data is identified and is available in test regions

•Tested the Prime View application on different browsers.

•Developed XML test files based on XML schema.

•Validated various Business Processes through Web Services (WSDL) using BPEL.

•Tested and Validated Complex Web services, SOA Applications, SOA Interfaces, WSDL Files and Tested SOAP Files

•Validated the SOAP messages.

•Validated the protocols (TCP/IP, HTTP and HTTPS)

•Maintained the Defects using Defect Tracking System in Clear Quest

•Ensured that data integrity is maintained between various table and databases while real-time transactions are executed

•Developed Complex SQL queries to retrieve the data from various tables and to test the database

•Performed User Acceptance Testing on behalf of End Users

•Participated in project review meetings.

•Participated in all reviews with Business owners to get sign off before release.

•Participated in Floor walk to help the customer service representatives.

Client: DLI, Deloitte, Harrisburg, PA Oct’ 2008 – Aug’ 2009

Position: QA Analyst

Environment: Quality Center, QTP, Rational Requisite pro, Rational Clear Quest, .NET, Web sphere 6.1, Oracle 10g, Web Services, Apache

Project Details: Common workforce Deployment System (CWDS)

The project Comprehensive Workforce Development System (CWDS) is being developed and implemented by Deloitte Consulting LLP for Commonwealth of Pennsylvania. It is a web-based application to build an integrated 'one-stop" and case management system aimed at supporting Pennsylvania's workforce development needs. CWDS supports the workforce development strategy by creating a more market driven system in administration and finance, targeting and streamlining of funds, and increasing accountability

Roles & Responsibilities:

•Involved in analyzing the Business requirements in Rational Requisite Pro and System specifications to understand the Application.

•Developed system test strategy to validate end-to-end processing for each of the business processes that are part of the new platform.

•Developed Risk analysis document and assisted project manager in project plan.

•Created test cases, test scripts and executed them.

•Analyzed test data requirements and established process to create test data required to support testing

•Preparation of Test Plan, Traceability Matrix and Planning Test Schedules.

•Modified and maintained the already existing test plans, test cases and scripts to leverage the automation team effort during the regression testing

•Identified application defects and interacted with developers to resolve technical issues.

•Executing test cases on test regions and validating functionality of the new fix.

•Validating that the test data is identified and is available in test regions

•Tested the Prime View application on different browsers.

•Performed User Acceptance Testing on behalf of End Users

•Participated in project review meetings.

•Participated in all reviews with Business owners to get sign off before release.

•Participated in Floor walk to help the customer service representatives.

Client: CIGNA Healthcare, Philadelphia, PA Dec’ 2007 – Oct’ 2008

Position: QA Analyst

Environment: QC, IBM Mainframe, JCL, COBOL, CICS, VSAM, ENDEVOR, FACETS, Manual Testing, TSO/ISPF, SQL Server 2005, Oracle 9i, DB2, MS Office, MS project, Unix, Windows 2000/XP

Project Details:

CIGNA offers a very wide variety of healthcare plans that are intended to help employees get healthy and stay healthy. Various programs exist to cover medical, dental, and vision needs. Cigna offers a basic medical care programs called CIGNA Choice Fund. This plan makes available a Health Savings Account (HSA) for the consumer. There are several modules involved in Choice fund like: Set up the HSA account, Medical Plan Coverage, Pay medical bills. Test the claims processing applications as well.

Roles & Responsibilities:

•Analyzed System specifications, business requirements for full understanding of the business.

•Developed detailed Test Plan for System Testing based on SRD and BRD.

•Involved in development of Test Plan and Test Specifications as per clients, business requirements to ensure HIPAA compliance.

•Validate Claim Process according to HIPPA compliance.

•Tested HIPPA regulations in Facets HIPPA privacy module.

•Manually performed User Acceptance Testing of FACETS implementation.

•Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.

•Ensured all Provider applications involving testing the agreements and contracts for Professional providers (Common Practitioner), Hospital Providers (Facilities), Ancillary Providers (Ambulatory Services) and Non-Participant Providers

•Gathered and documented business requirements from Trading Partners, user groups and Agents via workshops, interviews and surveys.

•Worked in close collaboration with the Project Manager and business users to gather, analyze and document the functional requirements for the project.

•Worked with Benefit file components using Benefit file Inquiry and Maintenance application

•Performed Functional, Regression, User Acceptance and System Test of the Application.

•Written SQL queries to access the data in the Mainframe DB2 database to execute back-end testing.

•Involved in cross browsing testing of the application on various Browsers to ensure that it functions similarly on all browsers.

•Used Quality Center to execute Batch scripts and as a repository to store scripts for reuse.

•Logged and tracked bugs using Quality Center.

•Reported and tracked testing progress in the bug tracking system Quality Center.

•Performed backend testing in the database to validated correct tables and data is getting updated and inserted.

Contact this candidate