HARI SHANKAR

USA, Knoxville, Tennessee-***** Phone: +1-865-***-****

Holding H1B Visa E-mail: ad1l4a@r.postjobfree.com

OBJECTIVE

Seeking employment to meaningfully contribute to the organizational goal along with work satisfaction and career growth

Summary:

I have over 11 years of experience in software testing, including more than 6 years of ETL/DWH/Database/SQL testing and the rest as functional testing, web application testing, quality analysis and UAT. I have strong knowledge of BI-Clinical along with measure processing and working as BIC SME.

Work closely with the business, product owner, and stack holders to gather and understand the requirements

Good exposure on value-based care, Payer and Providers workflow in the Healthcare domain (US Healthcare)

Good exposure to MIPS program in Healthcare, CMS submission – Individual & Group submissions

Good understanding of Healthcare claims data, claims processing, pre-authorization, revenue cycle management

Knowledge of Healthcare standards and Medical coding guidelines like CPT, ICD-10 coding, HCPCS coding

Experience with Tableau reporting, Congo’s tool along with Azure DevOps

Having working experience with Agile (Scrum) methodology

Well acquainted with the Software Development Life Cycle (SDLC) and the Software Testing Life Cycle (STLC)

Worked on the Bugzilla defect tracking tool the Quality Center (ALM), Zephyr, JIRA and Azure DevOps

Involved in business requirement discussions, scrum, RCA and defect triage meetings

Experience in the role of Scrum Master and involvement in project estimation and planning

Involved in resource planning, estimations, billing, and work allocations, as well as team management experience

Work History:

Presently associated with CitiusTech Pvt Ltd as QA Lead from Sep 2019 (H1B Visa)

Associated with L&T Infotech Pvt Ltd as Senior Test Analyst from March 2015 to Sep 2019

Associated with Kewaltech soln. as Senior Test Analyst from March 2014 to March 2015

Associated with Magnasoft Consulting India Pvt Ltd as Test Analyst from Nov 2011 to Feb 2014

Education:

B.Tech from ICFAI University, Dehradun in Computer Science (2007-11) with 75.0%

Technical Skills:

Certification: ISTQB Certified

Testing : ETL/DWH Testing (Informatica Testing), Manual/Functional Testing, End-to-End Testing, Cognos Reporting Tool (8.4), Tableau, Report/data migration testing

Databases: SSMS, Oracle, MySQL

ETL Tool: Informatica, Cognos, Tableau

Defect Tracking Tool: Azure DevOps, Bugzilla 4.0, Quality Centre (QC 11.0), JIRA

Test Management Tool: Quality Centre (QC 11.0), JIRA, Azure DevOps

Professional Experience

Project 1: Team Health – US (Oct 19 to till)

Employer: CitiusTech Pvt Ltd

Client: US Client

Environment: Java/J2EE, SSMS, Talend Data Integration, AWS-S3, EC2, Redshift, Azure DevOps

Role: Senior Test Lead/QA Manager (Location- TN, USA)

Description: Project involved working with a web-based management system that had primary goal to support MIPS (Merit-based Incentive Payment System) initiative at Team Health, where the end goal was to facilitate reporting of the TeamHealth physician’s yearly data to CMS for annual benefits of US Clinicians, Patients, etc. As part of this program, the team was responsible for enhancing and developing various supporting applications along with maintaining, ETL, DB and measures processing with the help of the bi-clinical rule engine.

Responsibilities:

Performed implementation of the BI-Clinical solution for the client. Worked as an SME for BI-Clinical with TeamHealth

Involved in the functional study of the application along with BI-Clinical measure processing and validation for EC and GPRO data

Involved in CMS submission – Individual and Group submission

Involved in claims data creation and its processing

Involved in requirements analysis, identifying test scenarios and conversion of test scenarios into test cases

Prepared and ran SQL queries to validate source and target data

Managed report generation with the help of tableau reporting tool

Handled project tracking, team handling, onboarding, and training new team members, and driving client calls

Implemented Agile methodology and played the role of scrum master

Worked with the on-site business associate to discuss and understand requirements to create a test strategy and test plan

Involved in sprint planning, effort estimation, scrum meetings, sprint retrospectives, and defect triage meetings

Shared project status report to PL’s/ DL’s

Performed RCA, proposed, and fixed the issues in the case of SQL agent job failures

Helped the client/onsite BA during UAT and production deployment

Interacted with the BA and development teams to resolve the issues

Worked as Lead for the ETL QA and BIC team

Guided and mentored on-boarded new engineers, also responsible for BIC sessions with the business team along with CT internal team

Project 2: Wide Orbit Digital Hub - Viacom (From Jan 17 to Sep 19)

Employer: L&T Infotech Pvt Ltd

Client: Viacom US Client

Environment: Java/J2EE, Informatica 8.6, Oracle 10g, Unix, Quality Centre, JIRA

Role: Team Lead

Description: WODH is a Digital Order management system that manages the entire ad sales cycle from opportunity and order to invoice and analysis. It provides perfect solutions for publishers with multiple ad servers, outlets and properties, who need to track orders, order lines and traffic across multiple systems. Sales, ad ops and finance can unite on a single solution to simplify complex workflows, increase efficiency and drive revenue growth. We are also using ETL process to validate the data.

Responsibilities:

Handled a team of 6 members for WODH and TRAM/JIGSAW.

Performed smoke testing, functional testing, database testing, regression testing, layout testing & front-end testing for various modules

Involved in requirements analysis, identifying test scenarios and conversion of test scenarios into test cases

Directly coordinated with Dev team and BA to resolve the issue on priority

Performed data validation with the help of queries and perform end to end and UAT testing

Worked on BI reporting tool Cognos

Involved in test plan and test lab preparation and execution of test cases with defect log, retest and close in Jira

Involved in scrum meetings, defect triage meetings and daily Scrum call

Project 3: Banking and Finance Domain Project (From March 15 to Dec-16)

Employer: L&T Infotech Pvt Ltd

Client: South African Clients

Environment: Java/J2EE, Informatica 8.6, Oracle 10g, UNIX, Quality Centre

Role: Senior Test Analyst

Description: The application was aimed at banks and customers. Bank Admin and Customer admin login were required to access the application. Customers could log in to an application and initiate payments, collections, able to view balances and statements. This enabled the client to get Pay Alerts with transaction alerts.

Responsibilities:

Performed Smoke testing, functional testing, database testing, regression testing and UAT testing for various modules

Involved in the functional study of the application along with test case creation

Ran the Jobs/Workflow for the ETL process and prepared SQL queries to compare data

Verified the data in the target database after the ETL process

Performed column data mapping between source & target database

Prepared test data for testing along with defect analysis and reporting in QC

Interactions with BA & Dev teams to resolve the issues

Project 4: Customer Service Application for Arroweye Solutions (ASI) (From March 14 to March 15)

Client: Cardways, Client Borders, Urban Bank, eBay, Amazon, USA.

Environment: Informatica 8.6, Jscript, VBScript, Oracle 10g, UNIX, Toad, Quality Centre

Role: Senior Test Engineer/Senior QA Engineer

Description: This Application/Website is only for corporate customers, Customer/Admin login is required to access this application. Client comes to our end only for purchasing the product with/without personalization (greeting gift card or gift card with bi-fold letter carrier or eCerts) and we transfer the items purchased to the client’s shopping cart.

Users can personalize cards using photos from their Cardways photos account.

Responsibilities:

Involved in the functional study of the application

Performed column data mapping between source & target database

Performed functional testing, database testing, regression testing & UAT testing for various modules

Ran the Jobs/Workflow for the ETL process and prepared SQL queries to validate source and target data

Prepared test data for testing and design & Executed test cases

Defect analysis and report in QC along with the daily testing status report

Interacted with BA & Dev teams to resolve the issues

Project 5: Northstar (From Nov 11 to Feb 2014)

Client: Schools, Sical, CCD

Environment: Informatica 8.6, Oracle 10g, Windows, UNIX, Toad, Quality Centre

Role: Test Engineer

Description: Northstar is an integrated child and school bus tracking and monitoring solution that ensure children’s safety and security while they travel to school and back. It had the following features:

Web-based tracking, monitoring, alerting and reporting with 99.9% availability and uptime services during school hours

A state-of-the-art "school bus black box" with sensors that work in real-time

A manned "Command Center" that monitors school buses and children during school hours

Instant alerts of times of arrival, delays, accidents, and breakdowns over 5-second SMSs with automatic voice call alerts

Automatic attendance both inside the bus and at school gates

Responsibilities:

Conducted Smoke Testing, Functional Testing, Integration Testing, extensive Regression Testing etc. on the application

Involved in data validation using SQL Queries

Designed & Executed test data along with test cases

Involved in maintaining Test Cases, defect analysis, and reports in QC

Reviewed Test cases and updated the review comments

Technical Skills

ETL

Hands-on experience in working with ETL/Informatica Tool/SSIS

Having working experience on Interfaces of Informatica/SSIS

Working experience with BI Reporting tools- Cognos, Tableau

Good Knowledge of Mapping

Good Knowledge of Data Ware House

SQL

•Good understanding of RDBMS concepts

•Good Knowledge of writing Complex Queries SQL Queries

•Ability to write Joins, Sub queries, Grouping Functions

•Aware of different types of Joins

Functional Testing

Proficient and extensive Knowledge of Functional testing

Strong in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)

Thorough knowledge in Functionality Testing, Integration Testing, System Testing, Compatibility Testing, Regression Testing, Accessibility Testing, Usability Testing, Smoke and Ad-hoc Testing, Black Box Testing, System Testing

Strong knowledge of Test Plan, Test Case, Test Case Review Template

Extensive Knowledge of writing Test scenarios, Test cases

Preparing Requirement Traceability Matrix for Test cases and Requirements

Strong in testing tracking tools like Bugzilla

Agile Methodology

Very good knowledge of the Agile Development Model-Scrum method

Actively involved in Sprint Planning Meeting

Involve in Daily Scrum Meetings

Involve in Sprint Retrospect Meeting

Awards/ Professional Certifications/Training

ISTQB – ISTQB Foundation Level Professional, Year 2016

Agile Fundamentals Level Certification

Shot out by the client for excellent work

Best Performer Award by Client at On-Site Location

Best Performer Award (viz. Star Award) in CitiusTech and L&T Infotech

Awarded the Pat on the Back Award in L&T Infotech

Contact this candidate