SUMMARY:

• Over 8 Years of working experience in IT and nearly 6 Years in Business Analysis, System Analysis with extensive experience in the Manual Testing, Automation Testing, Web Testing which includes Functional, Regression Testing, System Integration and End to End testing of enterprise, web - based and standalone applications.
• Experience in creation and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques.
• Well Versed with System testing, Integration testing, Performance testing, Functional testing, Regression testing and User Acceptance Testing.
• Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete.
• Sound knowledge and exposure in working with the various relational databases like Oracle, DB2 and SQL Server etc.
• Experience with QA Methodology and QA Validations to ensure the Quality.
• Experience in data ware house tools like Informatica and Cognos as Reporting Tool
• Good knowledge in DBMS and RDBMS concepts.
• Good Experience Working Federal ( CMS) and State( MHBE, DPW) Clients
• Expertise in developing Test Strategy, Test Plan, Test Scenarios, Test Case Design, Test Reports using business/functional requirements for both manual and automated tests.
• Working with developers, business analysts, and user representatives in application design and document
• Solid Back-end testing experience in writing and executing SQL Queries.
• Experience on CLAIMS and HIPPA (270/271) standard testing and Working knowledge of Performance testing using Load Runner.
• Supported S508 Testing including developing test plan.
• Extensive Working Knowledge in the ETL Tool Informatica which includes components like Power Center, Designer, Workflow Manager, Workflow Monitor.
• Exposure to software development methodologies such as Iterative, Waterfall, Scrum, and Agile Methodology.
• Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Involved in developing test frameworks using automation tools like QTP (Quick Test Pro), Selenium IDE,SOAP UI in automating functional, Regression & UI test suite.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports Using COGNOS 8.4.1
• Experience with Gap Analysis to check the compatibility of existing systems with new business requirements
• Extensive experience in client/server and web application testing using black box Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Have hands-on on experience in other bug tracking tools like Bugzilla, JIRA, Atlassian tools
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS:

Reporting/OLAP: Cognos, Micro Strategy

Data warehousing: OLTP, OLAP, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snow Flake schema

Databases: Oracle, MS SQL Server, DB2 and MS Access

ETL Tools: Informatica (Power Center)

Languages: C, C++, SQL, VB Script, Gherkins

DB utilities: SQL Loader, SQL*Plus, Benthic, DB2 Visualizer

Testing Tools: Quality Center, ALM, JIRA, Confluence Bugzilla, QTP 11.0, UFT 12.0, SOAP UI, Cucumber, Selenium IDE, Rational DOORS 9.3

Operating Systems: Windows, Server/XP, NT, VISTA

Other tools: TOAD, SQL Assistance, Oracle Sql developer, IBM GENTRAN, BMC utilities on Mainframe, IBM Data Studio 3.2

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. QA Analyst/Lead

Responsibilities:

• Participated in all Confidential JAD, System related walkthroughs, Requirements Gathering walkthroughs, Demos and overviews sessions.
• Involve in complete SDLC where gathering requirements from users and developed technical design documents, involving in development phase, testing phase (creation and execution of Test Plans, User Stories, Test Scripts and Test Cases).
• Participated and Lead conducting daily scrum meetings.
• Participated in Peer reviews and Group Reviews on test case documents.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Identify test requirements from specifications, map test case requirements and design test coverage plan.
• Executed Regression and End to End scripts using Automation tools like Selenium IDE, Café.
• Supported CMS S508 Testing which includes creating Test Plan and provided Test data when needed.
• Develop, document and maintain functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts.
• Execute and evaluate manual or automated test cases and report test results.
• Hold and facilitate test plan/case reviews with cross-functional team members.
• Identify any potential quality issues per defined process and escalate potential quality issues immediately to management.
• Performed End to end testing, System testing, Functional testing, Smoke testing for Confidential AI and Confidential PIfor every releases.
• Supported UAT when MAC’s are testing.
• Reported bugs, tracking issues, Enhancements using JIRA and escalated the issues, risks in a timely manner.
• Involved in testing documentation including high level scenarios, Test Scripts, Contractor Test Guide, Provider Test Guide and Test Summary Reports using Atlassian Confluence.
• Ensure that validated deliverables meet functional and design specifications and requirements.

Environment: Windows, Atlassian JIRA, Confluence, Oracle Sql developer, MS Office 2010. Rational DOORS 9.3, Selenium IDE, CGI Café, Cucumber.

Confidential, Columbia, MD

Sr.QA Analyst/Tester

Responsibilities:

• Participated in Requirements walkthrough and Logical & Physical Data models walkthroughs for the NLR project.
• Participate in all CMS JAD, system related walkthroughs, Test case walkthroughs and overviews sessions.
• Participated in Peer reviews and Group Reviews on test case documents.
• Involved in the Logical Grouping of Test cases that were prepared by BA team.
• Performed Functional testing, Smoke testing After every Code Drop(Deployment)
• Performed End to end testing of all interfaces in almost all of the releases for the NLR Testing Project.
• Involved in Data setup activities for the NLR project for UAT Testing and Functional Testing.
• Involved in the Regression testing.
• Involve in complete SDLC where gathering requirements from users and developed technical design documents, involving in development phase, Testing phase(creation and execution of Test Plans, Test Scripts and Test Cases ) and data prep for UAT.
• Developed and maintain test cases and report test results.
• Created various testing documentation, including test cases, test scenarios, test metrics, defects, test summary reports, etc.
• Prepared sample test sets for Medicare XML files like D1, D4, D7, D8’s and Medicaid XML Files B6, B7, D16 and D18’s which involves in doing Payment for Providers.
• Involved in uploading and processing of XML Files through GENTRAN as Necessary.
• Involved in Preparing Daily Slide, Weekly Dashboard for Reporting Calls.
• Co-ordinated E2E Testing with PQRS, HPMS and State testing.
• Report Issues that Impact the team to the CMS Help Desk and follow up with Tickets raised.

Environment: Windows, Quality Center 10.0, ALM 11.0, QTP 11.0, UFT 12.0, IBM Data Studio 3.2.0 Client, Mainframes DB2, IBM DB2 BMC utility, IBM - Sterling Gentran, MS Office 2010. Rational DOORS 9.3

Confidential, Columbia, MD

Sr. QA Analyst/Tester

Responsibilities:

• Participated in Requirements walkthrough and Logical & Physical Data models walkthroughs for the NLR project.
• Participate in all CMS JAD, system related walkthroughs, Test case walkthroughs and overviews sessions.
• Involve in complete SDLC where gathering requirements from users and developed technical design documents, involving in development phase, Testing phase (creation and execution of Test Plans, Test Scripts and Test Cases) and data prep for UAT.
• Developed and maintain test cases and report test results.
• Created various testing documentation, including test cases, test scenarios, test metrics, defects, test summary reports, etc.
• Prepared sample test sets for Medicare XML files like D1, D4, D7, D8’s and Medicaid XML Files B6, B7, D16 and D18’s which involves in doing Payment for Providers.
• Involved in uploading and processing of XML Files through GENTRAN as Necessary.
• Write Queries for Testing DB2 Mainframes whether the valid data is loading into the data warehouse.
• Involved in Functional, End-to-End, Regression, and Smoke Testing tasks.
• Accessed, manipulated, and validated test data, validated test files contents and captured testing evidence files, and documented test results.
• Created testing defect reports in Quality Center and tracked them to resolution.
• Verifying data on backend DB2 Database by writing SQLs using BMC tools and verify reports on Micro Strategy.
• Involved in System testing, Smoke Testing, Integration testing, Performance testing, Functional testing, Regression testing and User Acceptance Testing.
• Verifying Payment, Registration and Attestation reports generated on Micro Strategy.
• Testing the critical backend process running on Mainframe and UNIX to generate payments for Eligible Providers and Eligible Hospitals for the incentive program (interacting with the MCS, FISS, PQRS and PFDC applications of CMS).
• Escalated the issues and risks in a timely manner.
• Conduct UAT and report test results.
• Automated the Regression Test cases using QTP.
• Keyword Driven and Data Driven Framework is been used for execute the Test cases in QTP.
• Worked with Business analysts to ensure that all requirements are timely and accurately tested.
• Reviewed work products and deliverables.

Environment: Windows, Quality Center 10.0, ALM 11.0, QTP 11.0, UFT 12.0, IBM Data Studio 3.2.0 Client, Mainframes DB2, IBM DB2 BMC utility, IBM - Sterling Gentran, MS Office 2010.

Confidential, Columbia, MD

Sr. QA Analyst/Tester

• Involved in complete SDLC where gathering requirements from users and developed technical design documents, involving in development phase, Testing phase(creation and execution of Test Plans, Test Scenarios and Test Cases ) and data prep for UAT.
• Maintained test scripts and test data repositories and development of quality assurance and testing procedures and standards;
• Offer a fully integrated Health Insurance Exchange (HIX) for all Medicaid / CHIP eligibility categories.
• Provide data and reports necessary to evaluate progress, make improvements, and comply with federal and State law.
• Involved in System testing, Smoke Testing, Integration testing, Performance testing, Functional testing, Regression testing and User Acceptance Testing.
• Involved in independent verification and validation, system test and user acceptance testing (UAT). Provide data and reports necessary to evaluate progress, make improvements, and comply with federal and State law.
• Involved in Testing HIPPA 270/271 Existing Medicaid Coverage.
• Testing of Web services using SOAP UI with FSDH.
• Participation in Design reviews with the Development Team.
• Worked with Business analysts to ensure that all requirements are timely and accurately tested.
• Worked on all State of Maryland CARES (Client Automatic Registration and Enrollment Systems) and CSES (Child support Enrollment Systems) Projects and implemented successfully.
• Ensured that all work included under the scope of their program is appropriately defined, tracked and Tested and provided reports to Test Manager
• Detailed analysis for the test requirements.
• Involved in Automation for preparing testing bed and test architecture.
• Managed Functional testing, Integration testing, and System testing. User Acceptance testing and Regression testing.
• Involved in testing documentation including Test Plans, Test Cases, Test Strategies, and Test Summary Reports.
• Defect Tracking and Clarifications using JIRA and Issue Tracking System.

Environment: Windows, Manual Testing, RQM, JIRA, DB2, MS-Project Plan, SOAP UI 4.5.1

Confidential, Camp Hill, PA

Data warehouse Tester

Responsibilities:

• Involved in gathering requirements and analysis for applications.
• Developed Test Plans, Test Cases, Test Scripts, used Informatica as an ETL Tool for Developing the Data Warehouse.
• Created Test Cases and mapped Test Cases to Requirements
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Execute batch processing and verify the jobs status and data in database tables
• Tracked the defects generated defect summary reports
• Modified Configuration file according to space constraints
• Wrote shell scripts to run PL/SQL programs and job scheduling.
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various tables in Data Marts
• Created triggers, PL/SQL stored procedures and responsible for SQL tuning.
• Involved in Database design using Erwin 7.3.
• Responsible for writing complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance of heavy volumes of data.
• Involved in testing Cube Reports, Adhoc Reports, and Dashboards.
• Development environment and hot fixed them in the QA, pre-prod and Prod environments, during the runs.
• Interacted with the third party vendors regarding data issues with incoming and outgoing daily data extract.
• Worked on Service Requests and Supported at all levels in Maintenance.
• Coordinated with the QA team and Operations (production) team while the code was being migrated across the servers.

Environment: Informatica Power Center 9.0.1/8.6.1/8.1.1, Oracle10g/11g, Flat Files, Batch script, Windows XP/NT, CVS, PL/SQL, Benthic (Golden32), Erwin 7.3, ATS, Cognos 8.4.1.

Confidential, Littleton, CO

ETL Tester

Responsibilities:

• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of the Informatica based ETL process.
• Participated in the requirements, design, and release readiness reviews.
• Created and maintained test documentation and test plans.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Responsible for the ETL build validation process on an ongoing basis and for the validation of any modifications to the reports before release to production.
• Involved in supporting the applications.
• Involved in process of enhancing the existing Informatica and bug fixing.
• Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Developed and fine-tuned PL/SQL stored procedures to increase the performance. Raised change requests, analyzed and coordinated resolution of program flaws for the Development environment and hot fixed them in pre-prod and Prod environments, during the runs.
• Was involved in the Design, Development and Unit Test of the ETL code as per the requirements.
• Created technical specifications to create the mappings according to the business specifications given.
• Transformed data to meet internal client’s system requirements and loaded data into Oracle platforms.
• Conducted test of web services calls in an integrated platform using tools.
• Developed solid test documentation and created and maintained comprehensive test plans and test cases.
• Analyzed software problems, provided clear defect reports and followed defect-tracking practices based on internal QA standards and processes.

Environment: Informatica Power Center 8.6.1, Oracle 9i/10g, SQL Server 2000/2005 Toad 8.5, UNIX - SUN- AIX, Flat files, PL/SQL, XML, Tidal, Business Objects XI