SUMMARY

• Over 7 plus years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation, and support.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Excellent documentation and Creation, Expertise in Test Plans creation, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensively worked in Linux/Unix/Windows environment.
• Involved in change data capture, batch process, store procedures, Scheduled job, triggers, views, batch process backend test testing using complex SQL/PLSQL scripting.
• Exposer to Hadoop, big data & cloud technologies.
• Exposer to Selenium and maintained test case for testing purpose
• Extensive experience in writing complex SQLQueries and PL/SQL scripts
• Performed Functional/System/Integration/Regression/GUI/Security/Smoke/UAT/adhoc/Performance/backend Testing.
• Experience in using QC/ RQM for test case management and defect tacking.
• Extensively used ETL methodology for supporting data extraction, transformations, and loading processing, in corporate - wide-ETL solutions using Informatica
• Tested several complex BI reports generated by Business Intelligence tools Cognos, Business Objects, Micro Strategy including dashboards, summary reports, master detailed, drill down and scorecards.
• EDI experience with a good understanding of X12 standards with 834, 835, 837 and Flat file formats.
• Tested various scenarios for Upstate /Downstate WMS call, Restful API, XML/JASON request and Response Using SOAP UI by creating Mock data based on the different test cases.
• Extensively tested middleware process like Eligibility Process/Payment Process, Batch error correction process and different kinds of Notices: Approval notices, Eligibility notices, payments.
• Extensive experience with Bug tracking tools like Quality Center, Test Director, Clear Quest, and Clear Case.
• Tested various applications based on C#, Java, C, C++, Java, .net, VBScript, JavaScript, XML, HTML
• Executed automated test scripts using QTP/RFT/Query Surge for Regression testing.
• Strong experience of interacting with developers to analyze the user requirements, functional specifications.
• Excellent communication, interpersonal, intuitive and analytical skills.
• Proven ability to work efficiently in both independent and team work environments
• Creation, distribution and walkthrough of test scenarios, test cases, test scripts and other documents surrounding testing activities and ensured that all testing activities and deliverables are conducted/ produced in compliance with company standards
• Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.

PROFESSIONAL EXPERIENCE

Sr. QA Test Engineer

Confidential, Rensselaer, NY

Responsibilities:

• System Analysis, validation, comparison according to the technical documentation, mapping documentation, to meet the business needs.
• Involved in the root analysis meeting, daily standup, gap analysis and Support on all the stages of system implementation and/or database related deployment and back-up and recovery plans.
• Frequently involved in database cloning, refresh, data masking, data analysis as business needs. Wrote various complex SQL queries for the mathematical and analytical purpose.
• Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Involved in formal and informal Peer Review meetings to better understand the business requirements so as to cover all the test scenarios.
• Involved in internal and external project discussion meetings that involve QA lead, managers, BA, a Client user, and development team.
• Writing the test cases for the various reports that include the SBM reports and 1095.
• Writing complex SQL queries report testing and Involved in Report Testing generated by Cognos and data validation on the back end.
• Analysis and review of the business requirements to create ROM, BOE, test plans and test cases
• EDI experience with a good understanding of X12 standards with 834, 835, 837 and Flat file formats.
• Tested the 834 transactions inbound and outbound files in test environment creating the mock data files.
• Wrote SQL queries and execute them for verification of data in the front end to the database.
• Reviewed the test cases with the business analyst and developers to verify all the business requirements are met.
• EDI mapping guides and creating test plans, test cases to ensure functional coverage
• Participated in the application walk-through and meetings.
• Involved in defect Triage meeting for the defect reviews and discussions with developer and teams.
• Executed manual test cases in RQM for the GUI, functional testing, End to End testing as well as regression testing.
• Linked the test cases to Development plan items on different project areas in Rational Quality Manager Jazz Server and in Rational Team Concert Jazz Server.
• Exported the test cases, test scenarios from MS Excel to RQM and executed them in different cycles with different browsers.
• Created test execution reports on RQM, defect reports in RTC. Daily updates on Requirement Traceability Matrix.
• Created Test plans and test cases and export Cognos report in different format .csv, excel HTML or pdf.
• Prepared deliverables including Test Plans, and Test results and defect reports on time.
• Documented the training documents on each release and the things to remember.

Sr. QA Test Engineer

Confidential, Rensselaer, NY

Responsibilities:

• Involved in developing test plan, created test cases for testing Data Mart based on the BRD
• Tracked the defects using RQM tool and generated defect summary reports.
• Used RQM to track and report system defects.
• Have used multiple advance SQL queries function such as join, union, alter, create, distinct and some other function to join different database in single query while executing the script
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse according to Business Rules.
• Performed various testing like Regression testing- testing, system testing, performance testing
• Performing extensive Back-end database validation by executing advanced SQL Queries in SQL developer for Oracle Database.
• Testing of checksum (CRC) and error handling for the flat files and relational tables loaded into the databases for all mappings.
• Escalation performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Tested the reports generated by Cognos, validated the data against Database.
• Read and verify the session log to verify data loads summary, data verification purposes like data truncation, data overflow, rejected errors, row counts and etc.,

Sr. QA Test Engineer

Confidential, Rensselaer, NY

Responsibilities:

• Created a test plan, test cases, test scripts by analyzing the Functional design document and Data Validation Document.
• Performed Black box testing, Ad hoc testing, Smoke testing, Functional testing, Integration testing, Regression testing in a Testing environment
• Verified data load, transformation into data warehouse without any data loss or truncation as prescribed and expected time frames to confirm improved performance and scalability.
• Extensively used SSMS to write complex SQL queries and Responsible for testing Initial and daily loads of SSIS packages
• Participated in the creation, distribution and walkthrough of test cases, scripts and corresponding testing activities ensuring deliverables are conducted/ produced in compliance with company standards.
• Prepared Test Scenarios by creating Mock data based on the different test cases and extensive DATA validation using SQL queries and back-end testing.
• Involved in Report Testing generated by Cognos and data validation on the back end.
• Involved in formal and informal Peer Review meetings to better understand the business requirements so as to cover all the test scenarios.
• Involved in internal and external project discussion meetings that involve QA lead, BA, Client user, and development team.
• Writing complex SQL queries report testing
• Analysis of the business requirements to create test plans and test cases
• Created test scripts for manual testing in RQM using the functional design document.
• Created the test data for the positive and negative testing for functional and regression testing.
• Created End to End test plans and test cases with the test data.
• Created the CSV files for locating in FTP server and loading into the staging database for validation of CHIP and Medicaid data using CHIP/Medicaid template.
• Loaded Qualified Health Plans (QHPs) using the SERFF templates and running them into SOAPUI.
• Creating and processing of the Individual and Ancillary Provider Network Data files(PNDS), Cost Sharing Reduction(CSR) files, CHIP Rates, Quality rating, Plan Benefits files on CSV format with the positive and negative data for both positive and negative testing
• Extensively used ETL methodology for supporting data extraction, transformations, and loading processing, in corporate-wide-ETL solutions using Informatica
• Verified the loaded data for CHIP/Medicaid, Qualified Health Plans in the database using Toad for DB2 4.7
• Wrote SQL queries and execute them for verification of data in the front end to the database.
• Reviewed the test cases with the business analyst and developers to verify all the business requirements are met.
• Participated in the application walk-through and meetings.
• Involved in defect Triage meeting for the defect reviews and discussions with developer and teams.
• Executed manual test cases in RQM for the GUI, functional testing, End to End testing as well as regression testing.
• Created defects in Rational Team Concert, linked the test cases to Development plan items on different project areas in Rational Quality Manager Jazz Server and in Rational Team Concert Jazz Server.
• Exported the test cases, test scenarios from MS Excel to RQM and executed them in different cycles with different browsers.
• Created test execution reports (TER) on RQM, defect reports in RTC.
• Daily updates on Requirement Traceability Matrix, Defect matrix

QA Test Engineer

Confidential, Albany, NY

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing rational tools.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Rational testing tool RQM based on the Functional Specifications.
• Executed Test Cases using positive and negative data in RQM and reported results and defects using Rational Team Concert RTC tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability.
• Expertise with System Testing, Functional Testing, Regression Testing, End to End testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation.
• Involved in identifying the defects and developed Defect Tracking report using RTC which involved Bug life cycle.
• Provided daily and weekly status reports.

Quality Assurance Analyst

Confidential

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing
• Performed extensive manual testing on critical functionalities of the application.
• Involved in project requirements analysis, writing test specifications, formulating test plan, executing test cases & keeping track of the defects logged (Using Rational Clear Quest).
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Written SQL queries to validate Business Objects reports according to the system requirements.
• Prepare defect reports and tracked the defects in Clear Quest
• Understanding the business process; manage testing activities.
• Formulate the Test Strategy, Designing, System Plan and Validations.
• Involved in life cycle testing, functionality testing, regression testing, performance testing, volume testing.
• Written SQL/Shell scripts to perform data integrity testing and validation of logs.
• Performed system test following the standard guidelines provided in the design documents.
• Identified bottlenecks in the network and database servers while performing volume testing of the application.
• Done Cognos Reports testing which includes data validation and cosmetic validation.
• Created and Executed System Test cases and User Acceptance Test cases for the application.
• Interacted with developers for resolving Change Request issues.
• Tested the application manually for its GUI objects and their functionality and reported the bugs.
• Performed extensive manual testing of the entire application suite.
• Developed Test Data and individual test cases to satisfy positive and negative testing.
• Analyzed the functional requirements and the master test plan.
• Created Test Cases for various forms of the application manually.
• Performed Functional Testing, Black Box Testing, and Regression Testing.
• Involved in the submission of bugs through modification reports and frequent review of MR by conducting meetings during the development phase.
• Involved in Bug Reporting and Documentation of the whole testing process.
• Performed Data Driven Tests to validate the same scenario with different test data
• Validated Database using Database checkpoints and TSL Statements
• Used Test Director for defect logging and test management

Environment: ETL Informatica, Business Objects, TOAD, SQL, PL/SQL, Quality Center, QTP, Excel, Pivot, Oracle, Java, MS SQL Server, MVS, VSAM Files, Flat Files, XML Files, WinSQL, DB2, Excel, Business Objects and UNIX.