SUMMARY

• Highly - dedicated, enthusiastic professional having 9+ years of experience in Information Technology Project Life cycle and QA testing life cycle both as a QA Tester and QA lead across domains: Healthcare Insurance (HIPPA, ICD9/10), Financial (Retail Banking, Fraud, Legal and Compliance) and Ohio Benefits Integrated Eligibility- ABMS (LTC Medicaid, TANF, SNAP), Interface, BI Cognos ETL Reporting.
• Skilled on both Manual and Automation Testing on Agile and Waterfall models on various platforms like Mainframes, Web UI’s, SQL, BI Cognos-ETL Reporting, Interfaces with extensive usage of Test Management Tools - ALM, RTC, RQM, Automation Tools - QTP, Ruby Cucumber, JAVA Selenium, Watir, Gherkin.
• With 5+ years of experience as a QA Lead, currently working as QA Test Lead for BI Cognos Reports and ETL Testing with 5+ years of experience in analyzing technical requirements or designs as well as developing, implementing, and documenting effective test plans, test cases or scripts for Cognos BI products and ETL Reports. Capable of performing automation, unit, integration, regression and user acceptance testing as well as Cognos troubleshooting and enhancement functions. Possess excellent communication, analytical, problem-solving, team-working, multi-tasking and organizational skills.
• Possess 9+ years of experience in Information Technology in Project Life cycle and QA testing life cycle.
• Quality Assurance: Reviewing and converting functional requirement specifications to build the testing life cycle, including design and documentation of test plans, test cases, test scripts, test data creation and executing the test scripts, writing training guides, training end users and production support.
• 4+ years of QA Lead experience: Daily Task Allocation, Monitoring the Recourses progress, Generating resource’s daily execution report and present to Clients and stake holders,Attend the Daily Standups, Defect Triage calls and make sure issues are addressed.Coordinate between Client, BA and Dev resolve design gaps.
• Experience in Assembly, Functional, System, Regression, Exploratory, GUI, End to End and UAT testing.
• Documentation of the KT plan and provide knowledge transfer to new resources in the team.
• Experience in Boundary Value Analysis, Equivalence Partitioning and Use Case Design Techniques
• Experience in sanity and smoke testing of builds and accepting/rejecting them as required.
• Experience in ensuring test environment is ready with all the systems access approvals secured and preparation of Test data without having to waste any time before the execution commences.
• Experience in creating, publishing, presenting and securing approvals of Test plan from all the stakeholders.
• Experience in Change Management, Risk and Issue Management and Configuration Management.
• Experience in working with Business and Development teams to coordinate & schedule testing efforts and resolve issues
• Working closely with support teams and deployment of the applications and providing necessary handover to support teams during pre-post production implementations.
• Experienced in building effective winning/successful relationships with development/testing/support teams.
• Experience in ALM, ClearQuest, Rational tools, Atlas, JIRA test management tools
• Good experience in project planning, scheduling, estimation, resource and work allocation, risk identification and mitigation plan, product delivery and communication.
• Experience in visiting the client side and provide the KT to the end user in person as well as have the real-time exposure about the customers’ needs and troubleshooting their issues.
• Contributed in preparation of artifacts such as Initiation Deck, Project Management Plan, RTM, Review Logs.
• Good working Knowledge of Onshore-Offshore Testing Processes
• Real-time working experience as UAT tester
• Strong SQL skills

TECHNICAL SKILLS

Tools: BI: Cognos, ETL, Ruby, Cucumber, Gherkin, Selenium, HP ALM (Quality Center), RQM,RTC, JIRA, QTP

Databases: Oracle SQL Server

Operating System: MS DOS, Windows, MAC OS

Others: SOAPUI, Putty, WinSCP, Hexawise, SQL

Web Applications: .NET, Java

Programming Languages: C, C++, VB, Java, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Functional and BI Cognos QA and Test Lead

Tools: used - BI Cognos for Reports, ETL, RQM, RTC, DB SQL, Interfaces

Responsibilities:

• As an Ohio Benefits Worker Portal and Self-Service Portal UI tester,
• Was involved in creating automation test scripts using Ruby Cucumber - Selenium covering various cases which can arise in real time and ensuring that the application is behaving properly with various possible situations.
• Validated the components created by my team members and integrating them before delivering it to the clients in Agile.
• Was responsible for the quality of the work done by team.
• Involved in Functional Testing of MITS AID codes changes, Eligibility Determinations (EDBC) Rules, Notice of Actions (NOA) validation.
• As an Ohio Benefits Interface Tester, involved in Ohio Benefits Realtime and Inbound & Outbound Interface Testing
• Partner Testing to verify the outbound and Inbound file data is matching.
• Responsible for running Interface batches via Putty.
• As Ohio Benefits BI Cognos - ETL Reporting Tester and Test Lead,
• Validate the BI Cognos Report’s Summary/Detail Extracts which were based on ETL data and make sure source and target data integrity is maintained.
• Developed the Master Test Plan, Test cases and Complex SQL queries in Oracle DB to validate the data pulled in from ODS and compared with Ohio Benefits Database to satisfy the Business/Technical mapping rules.
• Create a regression suit to validate the report’s existing functionality not adversely affected by new code enhancements.
• Mocked test data to satisfy all business requirements.
• Proactively coordinated with Dev team focusing on Data Quality issues, Transformation Rules, problems, Incremental data loads that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Validated ETL test data for all transformation rules and covered all the scenarios required for implementing business logic in SIT and tracked the scenarios in IBM rational Tools like RQM, RRC and for Defect management in RTC.
• Involved in Performance/Load testing for the Reports full feed in Prod Replica Env to make sure After Go-Live, we don’t have performance issues.
• Was involved in full SDLC/STLC right from discussions of detailed design with BAs, Code design with Dev to test data creation for testing and creation of functional and technical documentation on daily basis.
• Participated in requirement gathering and Defect Management, Resolution and Reporting.
• Developed UAT test cases for business users and worked closely with users to execute UAT test cases and participated in Go/No-Go meetings.
• Supported Regression activities like maintaining regression suite and working with regression team to analyze testing impacts with cross functional teams and building a regression scope document and reviewed with the SME’s.
• Lead the UAT meetings to co-ordinate with users and consolidate the UAT status.
• Involved in root cause analysis of SIT and UAT defects and assigning it to appropriate teams and triaging the defects based on the criticality.
• Involved in PROD checkout and regression testing of the End-2-End system includes Data Acquisition, Integration and Publication/Provisioning.
• Validated the Reconciliation and recirculation and reprocessing logics of Acquisition and Integration.
• Generated the Quality metrics/Dashboards for the project/module level to report to management.
• Prepared the release notes and the project closure artifacts to include the quality standards.
• Maintain the regression suite to accommodate new scripts for next release.

Environment: /Tools: ABMS, Curam, BI Cognos, Selenium, Ruby Cucumber, Core Java/J2EE, PL/SQL, SQL, Jenkins, SOAP UI, XML, HTML, RTC, RQM, MS Excel, MS Word, Agile, SQL Server, BDD, GIT, ANT, Junit, Informatica.

Confidential, Dublin, Ohio

QA Lead

Tools: used - SOAPUI, HPALM, SQL Server, QTP, TOAD

Responsibilities:

• Convert Functional Design Documents in to Test Scripts and secure approvals from BA.
• Identify, track, and accurately report defects found using Rational Quality manger.
• Performed data accuracy, data validation and data integrity testing by querying the database using SQL queries to check the data table on server.
• Conduct backend testing using SQL queries to validate data for database.
• Perform Sanity Testing as soon as the build is released.
• Perform Assembly and system testing.
• Maintain the regression suite to accommodate new scripts for next release.
• Work closely with the BA and developers.
• Create scripts, generate the Test Data and execute in ALM.
• Use SOAPUI to test the portals
• Used Hexawise (or) Pairwise tool to optimize the test bed
• Preparing Status Report, Summary Test Report and Readiness Matrix
• Managing Traceability Matrix and updating Corresponding Scripts accordingly
• Participating in the team meetings to discuss about the various issues
• Hands on experience on Atlas and JIRA tool
• Execute the automated scripts in QTP and debug the issues

Environment: /Tools: HP ALM 11, Oracle ODI, Oracle Warehouse Builder, Microsoft Project, MS Office Suite, SOAP UI, Putty for UNIX, WinSCP, TOAD, JIRA, SharePoint.

Confidential

QA Tester

Tools: used – HPALM, Mainframes CICS, COBOL

Responsibilities:

• Analyzing the DSS requirement and creating HLTO (High Level Test Plan) & DTP (Detailed Test Plan).
• Presenting Internal and External DTP walkthroughs with client for their approval.
• Mock Data Setup Preparation in Mainframes CICS Screen and validate the results
• Automated the Mainframes CICS Screen which prefills the claim processing input fields so that test data creation time is drastically reduced.
• Test Management tool tracking via HP QC/ALM.
• Reporting the daily status with Management
• Co-ordinate with Onshore team for issue analysis and progress
• Post Prod Deployment Support.
• Train the new members and provide training to the members across all the modules.