SUMMARY

• 8+ years of IT industry experience with a proven skill in the field Software Testing.
• Efficient with EDIFECS tools, X - Engine, Spec builder, Transaction Management
• Proficiency with Rational Enterprise Suite (RequisitePro, Rational Rose, ClearCase, ClearQuest) in support of the RUP.
• Experienced in performance testing, worked on load runner.
• Solid Experience in documentation of User Requirements, as well as organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions.
• Possess strong knowledge of healthcare terminology and extensive experience working on healthcare projects. Specialized experience in healthcare insurance domain. Profound understanding of insurance policies like HMO and PPO and proven experience with HIPPA 4010 EDI transaction codes such as 270/271(inquire/response health care benefits),276/277(Claim status), 834(Benefit enrollment), 835(Payment/remittance advice),837(Health care claim)
• Good knowledge of SOX, EDI/HIPAA and Facets.
• Performed data stage designing, extracting data packages, transforming and loading data packages, stored procedures, process design and implementation.
• Experienced working with x12 version 5010 transactions and ICD -10-CM and ICD-10-PCS Code set changes analysis, design and migration strategy.
• Have good knowledge of HIPPA 4010 /5010 versions.
• Experience of QMF and SPUFI in extracting the queries.
• Expertise in COBOL, CICS, DB2, VSAM, JCL, File Manager, QMF, SPUFI and File-Aid.
• Strong experience in Mainframe Batch Cycles & Online Real-time Processing.
• Expertise technically with database development and data warehousing concept/tools.
• Worked in the performance tuning of the programs, ETL Procedures and processes.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Experienced in conducting training sessions for users.
• Experienced in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis
• Experienced in testing applications developed using PL/SQL, Java, J2EE, HTML, XML, ASP, Visual basic and C/C++.
• Experienced in writing test queries/scripts for data analysis and QA report testing
• Extensive experience in writing and executing complex SQL queries using TOAD 9.0.1 to validate data within SQL Server 2007 database.
• Experienced in Object Oriented Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case development using UML methodology
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Expertise in the management of User Request Change, and handle User Conflicts
• Ability to organize, document and track changes and defects by Traceability Matrix, using Rational Requisite Pro, Clear Quest, Clear Case

TECHNICAL SKILLS

Database: Oracle 9i, MS SQL Server

Operating Systems: Windows 95/98/00/XP and NT

Languages: SQL, Informatica

Web Technologies: Microsoft FrontpageMultimedia: Adobe InDesign, RoboHelp, FrameMaker, SnagIt, Epic Editor

Change Management Tools: Rational Clear Quest, Test Director, PVCS,FileNet

Methodologies: RUP, CMM, UML, Agile Methodology

Testing Tools: Mercury Test Director

Version Control Tools: PVCS, Rational Clear Case

Project Management Tools: Microsoft Office (Microsoft Word, Microsoft PowerPoint, Microsoft Excel), Microsoft P Project, MS Visio, Microsoft Publisher

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr QA - Onsite

Responsibilities:

• Worked on HIPPA2 Remediation project, Surescripts Certification 10.6 upgrade, PA eligibility transaction verifications. SmartPA (Prior Authorization for patients), Cyberaccess Application 10.1, 10.2, 10.3 Releases, TCM - Rules testing using Test case management.
• Currently working on ICD9 - ICD10 project meetings to have an action plan for the team to work on following requirement gathering, development, testing timelines and deliverables.
• Closely worked with development team to enhance and standardize the ETL Process to load underlying system that supports UI.
• Working as team lead handling 5 offshore QA team from different states and managing them to accomplish tasks given day to day.
• Hands on experience in manual testing of the application on mainframes for claims processing.
• Good experience in working in Agile and Waterfall environments.
• Lead the creation, preparation, and conduct of QUALITY ASSURANCE/verification reviews of software development artifacts
• Technical expertise in testing data using ETL tool.
• Tested all HIPAA transactions for multi version support (4010 and 5010) and validating the database to file elements.
• Developing and executes test plans and test scripts, executes planned sequences of test cases and recording test results
• Performed Smoke, Integration, functional, Regression, and system testing.
• Tracking validation of requirements writes issue/problem reports, maintaining and enhances existing test cases.
• Recording the results in Quality center Microsoft test manager tool and Excel sheets.
• Focused mainly on testing a set of requirements (that is expected to move to production as a Production Release) to ensure that the release is meeting user expectations.
• Worked Extensively with Inbound 837 I and 837 P, 835s (Out bounds) claims processing systems and XML validations.
• Worked collaboratively with BI and ETL resources to design and develop effective solution.
• Provides fundamental metrics to test management personnel, reports on defects detected
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components.
• Experience on DSS Decision Support Systems applications, directly responsible for the Extraction, Transformation and Load ETL of data from Legacy Systems using Informatica and testing them.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, and scheduling the Workflows and Sessions in Informatica.
• Monitoring and testing the data load from one database to other and validating the results and generating reports.
• SQL queries were used to retrieve data from tables and to perform back end testing.
• Experience using SQL queries to test the Backend applications and database
• Used Date warehousing for the arrangement of customer data.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) verified the functionality coverage
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.

Confidential, Watertown, MA

Sr QA - Onsite

Responsibilities:

• Involved in creating test cases for Web Portal migration project for Providers from current ALUI to Amisys application Written and executed test cases for Amisys 3.1 version of the Provider Application module.
• Created and Selected test data for Providers using HP-Reflectionsoftware along with Amisys Application.
• Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
• Responsible for designing, developing test plans use cases and executing test scripts.
• Performed Smoke, Integration, functional, Regression, and system testing.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Transactions focused on were 270,271, 834, 835, and 837.
• Worked Extensively with Inbound 837 I and 837 P, 835s(Out bounds) claims processing systems
• Worked collaboratively with BI and ETL resources to design and develop effective solution.
• Experienced with high-volume load processing into Data warehouse database.
• Prepared and Created Test Cases /Test Data according to 5010 Business requirements.
• Tested all HIPAA transactions for multi version support (4010 and 5010) and validating the database to file elements.
• Agile methodology: After launching the product at the end of each stage. I ensured bugs were caught and Eliminated at the end of each cycle. In Agile Methodology after the product is processed in each stage, i worked on changes that required without rewriting the entire program again.
• Involved in the development of web platform for online transactions through E-commerce.
• Functional Testing: Participated in functional testing applications and systems developed for external customers (mainly international companies) of various sectors. Created test scenarios Scripting - writing, running and improving automated test scripts.
• Load and Performance testing: Worked on Load performance testing activities for all eDiscovery applications.
• User Acceptance Testing (UAT): Focused mainly on testing a set of requirements (that is expected to move to production as a Production Release) to ensure that the release is meeting user expectations.
• Used Quality Center to execute test cases that we received from gatherings with the business.
• Familiar with features like test plan, test lab, defects, requirements in quality center tool.
• Worked on Exporting data from Excel sheet to Quality center in order to test the data manually.
• Facilitated meetings with the business during UAT.
• Created test bed and test data for claims.
• Regression testing: Worked on rerunning test cases from existing test suites to build confidence that software changes have no unintended side-effects. The “ideal” process done was to create an extensive test suite and run it after each and every change done in the testing process.
• Developed scripts to automate performance testing of systems and execute load testing of systems under tight timelines.
• Implemented Data ware house strategies to build the enterprise architecture.
• Worked with other data analysts in creating and maintaining Data functional design documents.
• Responsible for database designing, system analysis, and overall system.
• Documented a detailed Gap analysis for financial management systems (FMS) and EDW systems.
• Closely worked with development team to enhance and standardize the ETL Process to load underlying system that supports UI.
• Modifying JCL's accordingly to run the required tests submitting the batch jobs
• SIEBEL CRM: I have written scripts on application level.
• I have been resolving by navigating to server configuration administration in SIEBEL CRM.
• Worked on Mercury products methods, MACT Regulation, sampling, quality assurance
• Have good knowledge on Mercury products MACT(Maximum Achievable Control Technology
• Use of QMF and SPUFI in extracting the queries.
• Used File Manager to edit the datasets.
• Worked in front end testing by starting up building medium to large scale database driven websites
• Designing the web technology. I have also worked in defect rainsing in quality centre where after executing the test cases if there are any defect they were raised in the defects.
• Changes to necessary JCL’s, PROC’s were done to test the programs concerned with the project.
• Worked with batch jobs, monitoring and scheduling jobs using JCL
• Executed UNIX Shell scripts to enable and disable the environments
• Hands on experience in manual testing of the application on mainframes for claims processing.
• Created Requirements v/s Test Case Matrix in Excel Spread Sheet template and HP Quality Center 9.0
• Developed the Reports for Manager Using Crystal Reports.
• Participated in user acceptance testing for the UDD application.

Environment: Quality Center, z/OS, IBM Mainframe, TSO/ISPF, JCL, XML, File Manager, UNIX, JAVA, J2EE, AJAX, JavaScript, DB2,Oracle 10g, HTML, COBOL, Putty, Ultra Edit, MS Office, shell scripts, Microsoft Excel, MS Word, Internet Explorer, Microsoft outlook, Office communicator.

Confidential, Ohio

Sr. QA Specialist

Responsibilities:

• Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
• Responsible for designing, developing test plans use cases and executing test scripts.
• Performed Smoke, Integration, functional, Regression, and system testing.
• Involved in performance testing with load runner.
• Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Involved in requirement gathering and analysis.
• Involved in preparing Test Plans, test cases and test conditions.
• SQL queries were used to retrieve data from tables and to perform back end testing.
• Executed test cases manually to verify actual results against expected results.
• Performed GUI, Functional and regression testing using Win Runner.
• Conducted stress and Performance testing using Load Runner.
• Involved in creation and preprocessing of the Usage as per the requirements.
• Involved in issuing of service orders as per the requirements for new connections and changing class of services and Adding Users.
• Communicated with project manager and application team to know if there are any changes in requirements with in the release.
• Coordinating with the PM and with developers in validation process to get the expected results accurately.
• Coordinated with planning team to complete all the projects with in the release time.
• Analyzed error messages and investigated the defects.
• Created the Test Scripts for performance testing using Load runner.
• Maintained requirements, Test plans, Test cases and defects in Test Director.
• Participated in the team meeting to discuss issues arising out of testing.
• Participated in status meetings to provide status updates on the tests.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Experience working with FDA regulatory process and standards.
• Transactions focused on were 270,271, 834, 835, and 837.
• Worked Extensively with Inbound 837 I and 837 P, 835s(Out bounds) claims processing systems
• Experience in documenting Electronic Medical records submitted for audits to the Department of Federal Drug and ensuring that the Part 11 is met with all the necessary rules as established by the FDA.
• Extensively used the MVS utilities like File-Aid, QMF and DB2 Load for scheduling the jobs.
• Used Claridy tool to verify mapping to X12 format.
• Modifying JCL's accordingly to run the required tests submitting the batch jobs
• Base-line and Regression tests were scheduled and performed on every Release and build.
• Use of QMF and SPUFI in extracting the queries and File Aid to edit Data sets
• Extensively involved in real time testing.
• Review FTP processing jobs using with Core FTP Lite tool.
• Extensively involved entire Reference subsystem with COBOL and JCL jobs.
• Extensively involved in Reference Interface (In bound and out bound) testing.
• Used IBM Mainframes- CICS, ISPF, File Aid, IMS, and TSO for mapping Datasets and fields.
• Worked on JCL to run the batch during the end of the business day
• Used Quality Center for preparing the test plans and manual test scripts.
• Worked extensively with Quality Center for requirements, Preparing Test cases, Executing, Defect openings and closings.
• Involved In loading the flat files into Oracle Database and involved in writing Complex SQL Queries.
• Involved in generating Reports using Oracle Report Builder and testing the reports using Oracle Run Time.
• Involved in writing Complex SQL Queries using TOAD to validate the loads for Caremark and DEA.\
• Involved in writing UNIX shell scripts.
• Executed a whole bunch of PL/SQL code including stored procedures, functions and triggers using TOAD.

ENVIRONMENT: S: Cobol, CICS, EDI X12N 4010, Sybase Paper Free HIPAA Toolkit, DB2, TSO/ISPF, JCL, Visual Basic, ASP, Java Script, VB Script, XML, SQL, MS Access, UNIX, Oracle Run Time, IAS Web server, Web logic, BEA Tuxedo, Windows95/98/NT/2000/XP and Internet Explorer.

Confidential

Data Analyst

Responsibilities:

• Studied and assessed the clients systems and business processes. Developed project plans and managed scope.
• Established a business Analysis methodology around the Rational Unified Process.
• Assisted in building a business analysis process model using Rational Rose and Visio.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement
• Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
• Integrated RequisitePro with ClearQuest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests
• Managed all the requirements in RequisitePro, making requirements available to all team members.
• Used SQL Plus and Toad to create, query and verify test data for backend testing.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Experience using SQL queries to test the Backend applications and database
• Used Date warehousing for the arrangement of customer data.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) verified the functionality coverage.

Environment: SQL, Rational Requisite Pro, Rational Rose, UML, SQL, MS-Office, MS Project, MS Visio, Test Director.