Summary

• With more than 6 years of extensive experience as IT Professional, actively participated in Quality Analyst and Functional Analyst roles in the field of Health insurance, Retail and Telecom industry.
• Excellent interpersonal skills with good written and verbal communication skills.
• Strong analytical, problem-solving and communication skills, with particular emphasis on clear, detailed Business Requirements and Functional Specifications.
• Strong organizational skills, ability to multitask and work in a dynamic and fast paced environment.
• Well Organized, highly self motivated with good leadership Qualities.
• Result and Schedule Oriented to consistently meet deadlines, Schedules and budgets.
• Experience with both technical and business domain.
• Experience with manual and automation testing tools and methodologies
• Expertise in interpreting User requirements, Develop test strategy, generated Test Plans, Test cases and executing test case to test the applications meet the requirement.
• Expertise in System Testing, Regression, User Acceptance testing (UAT), Stress Testing and Smoke testing.
• Experience in GUI, Web based, Web service architecture and Client / Server applications.
• Experience with Automation testing Mercury QTP 9.2 and HP Quick Test Professional 10.0 (QTP 10.0)
• Experience with Defect Tracking using Mercury Quality Center 9.2 and HP Quality Center 10.0
• Good Knowledge on various Healthcare insurance Products like PPO and HMO
• Experience in producing metrics on testing status and customization on Problem Report Dashboard
• Experience with data validation, data analysis and data mocking
• Experience in requirement gathering, creating Business Requirement Documents [BRD] and maintaining Requirement Traceability Matrix [RTM]
• Involved in testing Functional Test Cases and coordinated with Clients in testing End to End Test Cases.
• Experience in Providing Ball Park estimations on new requirements and in preparing Design Documents (High level Design and Low Level Design).
• Provided Technical Support to develop the requirement using PL/SQL and Java script.
• Experience in implementation the business requirement, working in Agile / Scrum Environments with good multitasking management.
• Excellent Knowledge of RDBMS Concepts having worked on MS SQL Server and Oracle PL/SQL
• Experience working with Java and related technologies like JDK 1.6, Apache web server / Tomcat servlet container, Apache Axis, JRule Engine and Active MQ for communication platform with MySQL for database standard.
• Worked on SQL queries using DB2 Query Management Facility (QMF) to ensure database updates done according to business requirement
• Prepared custom reports from DB2 data using QMF form panels
• Created XREF files using Fileaid.
• Worked with reports and UML presentations with MS Visio, Excel and Power point
• Expertise in Visual Basic 6.0, Excel VB Macros (VBA), VB scripting, Database SQL, File aid and QMF
• Proficient on other MS Office tools including Outlook, Excel, PowerPoint, Word, MS Project, Visio

PCMM Process Involvement

• Experience and ability to perform IT Product/ System Analysis, coordinate Business Development team, involved in procuring BS7799 standards for Information Security, currently expediting CMM & PCMM Level 5 procedures.
• Good practices in all phases of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirements gathering, Analysis/Design, Development, Testing, Implementation Business User Testing and Support/ Maintenance.
• Good practices in Team Management & Communication reduced the hidden rework costs of non-aligned business and IT specification.
• Expertise in Crisis Management, worked on Business Continuity Plan, Asset Register and Risk Management
• Experience in PDCA (Plan-Do-Check-Act) model of Information Security

Professional Certification

Academy for HealthCare Management -250 (AHM-250) Certified Professional

Awards

Rewarded by Centre Head (TATA Consultancy Services) for the active participation in procuring BS7799 standards for Information Security.
Health Insurance Portability and Accountability Act (HIPAA) Compliance Test Completed Successfully
Education

B.E (Electronics and Communication Engineering)

Technical Skills

Testing Tools

Mercury Quality center, HP Quick Test Professional 10, Load Runner

Testing Techniques

Functional Testing, Integration Testing, Regression Testing, End-to-End Testing, Stress Testing, Smoke Testing, Business User Testing, UAT.

Microsoft Tools:

MS Office (Word, Excel, Power point, Project 2000, VSS)

Database

Oracle 9i - PL/SQL, Stored Procedures, Packages, Triggers, SQL Query Handling, DB2 Query Management Facility, IMS, MS SQL Server 2000, MySQL

Visual Model Tools

MS Visio 2000

Modeling Language

UML

Web Service Techniques

SOA (Service Oriented Architecture), MQ Series, Message Broker, Apache AXIS

Internet Protocols and Technologies (Exposure)

TCP / IP, FTP, DNS, SSL, DSL, ISDN, TCP

Language Skills
(minimal)

Cobol, HTML, VB Script, Visual Basic6.0, Java Script, Java, JDK1.6, XML, XSD, PL/SQL, C/ C++, VB Macros with MS Excel and exposure to VB.net and Unix Shell Scripting

IDE

Visual Studio, Visual Source Safe

OS

Windows 95/98/NT/2000/XP, Unix, Windows 2000/2003 Server, Z/OS, OS/390, Linux

Area of Expertise

Modeling Techniques

Use Case, Activity, Sequence, UML Class Diagram, UML Object Diagram, Object Role Model, Logical Role Model, Timing Diagram, Interaction overview diagram, System Use Cases, User Interface flow diagrams.

Functional design Document

Solution Design and Component Design Documents (High level and Low Level Design Document)

Project Leader Skills

As a Team Lead involved in Quality Service Models that include experience in :
Estimation on Resource requirement, Manage and Assign works to subordinates, Review & Analysis the business Requirements, Preparing Requirement Traceability Matrix Document (RTM), Code Review, Implementation and Software Quality Assurance plan QA. Problem Report Co-ordination for arriving at fix plan on the priority and severity of the defects in the application developed.

Crisis Management Skills

As a part of TCS Continuous Improvement Model involved in :
Identifying Mission critical Applications, Prepare and maintain Asset Register, Risk Management Documents and Business Continuity Plan (BCP)

Information Security Management

As a part of TCS Continuous Improvement Delivery Model involved in :
Ensuring that deliverables comply with security requirements, Audit for the License information for the List of client supplied software used in projects, Tracking of the Special Rights provided to the Associates and Ensuring ISM Quiz Compliance.

Professional Experience

Confidential,
Role: IT Consultant

Active Defense Platform appliance (ADP) shares intelligence between the security elements and enable intelligent
decision making concerning network’s security posture and automated threat response/defense.

• Involved in the Construction of Test Plan and Test Script.
• Participated in Design Walkthrough to Clients and involved in Requirement calls for better understanding of the Business Requirements.
• Performed testing of scripts on Active Defense Platform.
• Performed UI testing, report testing, testing on navigations on UI screen for various menu options on Tomcat Servlets.
• Prepared UAT test Plan and UAT test scripts by coordinate with clients.
• Validated log files for various actions performed on UI screens.
• Prepared Requirement Traceability Matrix to map Business Requirements with the Test Scripts constructed to make sure all the requirements are tested.
• Co-ordinated with offshore QA on automation test tool development to automate the test scripts

Environment:Windows 2000 (Dev), MAC, Bugzilla, Java, JDK1.6, Apache server, Tomcat Servlet, Apache AXIS, MySQL, JRule Engine, Active MQ, MS Excel, MS Word, Linux

IT Consultant
Role: IT Analyst - Quality Assurance

Present working with Informatic Technologies Inc, NJ on product maintenance and support for one of their product DPNet back office system.

• Involved in testing activity for tracking customer database and products and services offered via trading units.
• Reviewed the Test Results along with the Screen shots with the customer service division and Signoff.
• Reviewed test scripts and communicate with ODC unit India Office and NJ office.
• Involved in Code Review and coordinate with Developers to do Unit testing on Code and testing on GUI Application
• Co-ordinated with QA Manager on automation test tool development to automate the test scripts

Environment:Windows 2000 (Dev), HP Quick Test Pro, LoadRunner, MS Excel, MS Word, VB Scripting, VB6.0

Tata consultancy services (May06 – July09)

This is the upgrade of Claim check to version 8.5 where in the claim is vetted in the front end Claim check Screen itself before sending the claim details to MC Kesson engine for processing. This Project involves various Complex Database changes according to the type of Claims processed in Front end.

• Prepared Test Strategy Document and Requirement Traceability Matrix to ensure testing of the entire business requirement are covered.
• Represent QA Team for Design walkthrough and code walkthrough and provide feedback on the same
• Prepared the Test Plan explaining the scenarios to be covered in the test cases.
• Prepared Functional, Integration and Release Test Cases explaining the step by step process of testing the functionality
• Conducted Review of Test Strategy and Test Plan to Designer, Developers and Business Team to ensure the critical areas are covered in testing
• Mocked up the Data required for the testing in the various test Environments
• Processed Medical and Dental Claims using Green screens and TSO / ISPF environments.
• Processed In Network and Out of Network claims.
• Processed EDI medical claims for electronic claim processing using 837 and 226 formats.
• Tested the Complex Functional Test Scripts, Integration Test Scripts and Release Test Scripts in the Test Environment in three consecutive Cycles.
• Verified the Explanation of Benefits on claims (EOB) and Explanation of Payment (EOP) documents.
• Loaded the test results along with screen shots and tracked bugs using Tool HP Quality Centre 10.0
• Co-ordinate with Developers, Designers and SMEs to fix the bugs based on priority and Severity
• Reviewed the Test Results along with the Screen shots with the Business after testing completion and got their Signoff
• Prepared and Automated the Regression Test Scripts to ensure the new code has not broken the existing functionality using HP Quick Test Professional 10.0 (QTP 10.0).
• Tested bulk claims on RDE (Rapid data Entry) and pre pricing claims (PPN) to ensure functionality work good with bulk claims.
• Involved in Stress Testing and User Acceptance Testing
• Tested web service messages in SOAP (Simple Access Object Protocol) and XML formats sent between claim engines
• Worked on SQL queries using DB2 Query Management Facility (QMF) to ensure database updates done according to business requirement.
• Worked on File Aid, IMS and XPtr / Xnet to verify Explanation of Benefits and Explanation of Payments
• Loaded the test results along with screen shots and tracked bugs using Tool HP Quality Centre 10.0
• Initialize and conduct meetings with Designers and Developers to discuss on the fix for the bugs raised and come up with schedule for fix based on severity and priority
• Represent QA Team for Daily QA status meeting with Designer, QA Manager, Developers, SMEs to discuss on various milestones and the testing status.
• Reviewed the Test Results along with the Screen shots with the Business after testing completion and got their Signoff
• Provided Live support on Production check out, performed Smoke testing and extended support on solving the issues raised in production
• Facilitate Post-Mortem Meeting and preparing the report on Good Practice and Areas of improvements.
• Provided guidance to QA Team, provided training on Business / Domain Knowledge. Released understanding Documents on the Functionality, got Sign off from Clients on the Understanding

Environment:Z/OS, OS/390, Cobol, JCL, IMS, QMF, XPtr/Xnet, File Aid, Windows 2000 (Dev), Visual Studio .NET Framework, HP Quality Center 10.0, HP Quick Test Professional 10.0, LoadRunner, MS Excel, MS Word

This is Project where the accumulator limits are combined, thus both pharmacy and medical dollars are utilized to satisfy the limits. Claim information related to the application of dollars to those limits must be shared across the claim engines.

• Prepared Test Strategy Document and Requirement Traceability Matrix to ensure testing of the entire business requirement are covered.
• Prepared the Test Plan explaining the scenarios to be covered in the test cases.
• Represent QA Team for Design walkthrough and code walkthrough and provide feedback on the same
• Prepared Functional, Integration and Release Test Cases explaining the step by step process of testing the functionality
• Processed Medical and Dental Claims using Green screens and TSO / ISPF environments
• Processed In Network and Out of Network claims and verified Out of Pocket, Accumulator values updated corrected on claims based on Member plan and benefit options in Plan specs.
• Processed EDI medical claims for electronic claim processing using 837 and 226 formats.
• Worked on CAIP (Accumulator sharing application used for medical migration) for accumulator values adjustment verifications.
• Conducted Review of Test Strategy and Test Plan to Designer, Developers and Business Team to ensure the critical areas are covered in testing
• Mocked up the Data required for the testing in the various test Environments
• Tested the Complex Functional Test Scripts, Integration Test Scripts and Release Test Scripts in the Test Environment in three consecutive Cycles.
• Loaded the test results along with screen shots and tracked bugs using Tool HP Quality Centre 10.0
• Co-ordinate with Developers, Designers and SMEs to fix the bugs based on priority and Severity
• Reviewed the Test Results along with the Screen shots with the Business after testing completion and got their Signoff
• Prepared and Automated the Regression Test Scripts to ensure the new code has not broken the existing functionality using HP Quick Test Professional 10.0 (QTP 10.0).
• Tested web service messages in SOAP(Simple Access Object Protocol) and XML formats sent between claim engines
• Worked on SQL queries using DB2 Query Management Facility (QMF) to ensure database updates done according to business requirement.
• Prepared custom reports from DB2 data using QMF form panels, DB2 concepts and SQL.
• Created XREF files using Fileaid.
• Prepared and Tested End to End Scripts with Pharmacy Claim Engine to ensure proper sharing of the Accumulators happen according to member medical plans.
• Tested bulk claims on RDE (Rapid data Entry) and pre pricing claims (PPN) to ensure functionality work good with bulk claims.
• Involved in Stress Testing and User Acceptance Testing
• Verified the Explanation of Benefits on claims (EOB) and Explanation of Payment (EOP) documents.
• Prepared Metrics on the Testing to show progress of testing at various stages.
• Customized Visual Basic Macros for the Problem Request (PR) Dashboard and coordinated between Testing and Development team to fix the SLA dates based on priority of the defects.
• Customized PR Dashboard for upgraded version of Bug tracking tool from Mercury Quality Center 9.2 to HP Quality Center 10.0
• Represent QA Team for Daily QA meeting with Designers, SMEs, Developers, QA Manager to show daily progress of testing, Discuss on escalation of issues and on subsequent solutions
• Involved in Identifying scope of automating Regression scripts and automate using Loadrunner.
• Provided Live support on Production check out, performed Smoke Testing and extended support on solving the issues raised in production
• Facilitate Post-Mortem Meeting and preparing the report on Good Practice and Areas of improvements.
• Mentored and managed team of Junior QA. Released understanding Documents on the Functionality, got Sign off from Clients on the Understanding

Environment:Z/OS, OS/390, Cobol, JCL, IMS, QMF, DB2, File aid, XPtr / Xnet, Visual Basic 6.0, Visual Studio .NET Framework, Windows 2000 (Dev), HP Quality Center 10.0, HP Quick Test Professional 10.0, LoadRunner, MS Excel, MS Word

This is testing Support for the Various Medical and Dental Claims between Johnson & Johnson and Cigna.

• Prepared Test Strategy Document and Requirement Traceability Matrix to ensure testing of the entire business requirement are covered.
• Co-ordinate with QA Manager to prepare test estimates, Resource planning and Schedule planning for each phase
• Prepared the Test Plan explaining the scenarios to be covered in the test cases.
• Attend Requirement and Specification walkthrough representing QA Team
• Prepared Functional, Integration and Release Test Cases explaining the step by step process of testing the functionality
• Loaded scripts in Test Director using Mercury Quality Center.
• Conducted Review of Test Strategy and Test Plan to Designer, Developers and Business Team to ensure the critical areas are covered in testing
• Tested the Complex Functional Test Scripts, Integration Test Scripts and Release Test Scripts in the Test Environment in three consecutive Cycles.
• Processed Medical and Dental Claims using Green screens and TSO / ISPF environments
• Worked on Plan specs to validate member plan with benefit options and worked on Family and Individual Deductibles, Out of pocket and Life time maximum values in Plan specs.
• Processed EDI medical claims for electronic claim processing using 837 and 226 formats
• Verified the Explanation of Benefits on claims (EOB) and Explanation of Payment (EOP) documents.
• Reviewed the Test Results along with the Screen shots with the Business and got their Signoff
• Prepared and automated the Regression Test Scripts to ensure the new code has not broken the existing functionality using Mercury Quick Test Professional 9.2 (QTP 9.2).
• Tested bulk claims on RDE (Rapid data Entry) and pre pricing claims (PPN) to ensure functionality work good with bulk claims.
• Involved in Stress Testing and User Acceptance Testing
• Worked on SQL queries using DB2 Query Management Facility (QMF) to ensure database updates done according to business requirement.
• Represent QA Team for Daily QA meeting with Designers, SMEs, Developers, QA Manager to show daily progress of testing, Discuss on escalation of issues and on subsequent solutions
• Prepared Metrics on the Testing to show progress of testing at various stages.
• Facilitate Post-Mortem Meeting and preparing the report on Good Practice and Areas of improvements.
• Co-ordinate with QA Manager on automation test tool development to automate the regression test scripts

Environment:Z/OS, OS/390, COBOL, JCL, IMS, QMF, Windows 2000 (Dev), Visual Studio .NET Framework, Mercury Quick Test Professional 9.2, LoadRunner, MS Excel, MS Word

Tata consultancy services (Nov05 – April06)

The Homescan is Consumer Web Panel development Project which is used to trap the Customer Survey Results. The Customers are given the Scanner to Scan the UPS Codes present on the Product Commodity. The Results obtained through Homescan Survey are stored in database which is used for Analysis on Purchasing Patterns and Product Usage of all the Grocery and Retail Products.

• Prepared Test Strategy Document and Requirement Traceability Matrix to ensure testing of the entire business requirement are covered.
• Prepared the Test Plan explaining the scenarios to be covered in the test cases.
• Prepared Functional, Integration and Release Test Cases explaining the step by step process of testing the functionality
• Loaded scripts in Test Director using Mercury Quality Centre
• Conducted Review of Test Strategy and Test Plan to Designer, Developers and Business Team to ensure the critical areas are covered in testing
• Mocked up the Data required for the testing in the various test Environments
• Tested the Complex Functional Test Scripts and Integration Test Scripts in the Test Environment in three consecutive Cycles.
• Reviewed the Test Results along with the Screen shots with the Business and got their Signoff
• Constructed and Automated Regression Test Scripts using Mercury Quick Test Professional 9.2 (QTP 9.2)
• Prepared Metrics on the Testing to show progress of testing at various stages.
• Co-ordinate with QA Manager on Resource planning
• Provided guidance to Junior testers on the testing methodologies
• Co-ordinate with Developers to fix the bugs faster based on Priority and Severity of the bugs.

Environment: Sybase, SQL, Java, Java Script, HTML, UNIX, VB Macros, MS Excel, Microsoft Power Point