Hari Resume
Hari Resume
SUMMARY:
Software Quality Assurance, Business Analysis, Test management tools administration and
testing with 18 Years of IT experience, specializing in Win Runner, QTP, Load Runner,
Rational Clear Quest and Quality Center / ALM.
Extensive knowledge of Win runner 7.5, QTP 8.2, 9.0,10,11, Load runner 8.2,9.5, Test
director 8.1, Quality Center 9.0,9.2,10.0, ALM, Visual Basic 6.0, ASP 3.0, COM /DCOM, IIS,
HTML 4.0, Cascading Style Sheets, Crystal Reports 9.0 and XI, VBScript, VB.Net, JavaScript,
C, C++, ActiveX, ADO, RDO and Adobe Photoshop 5.5.
Experience in HP Quality Center / HP ALM Site Administration that includes installation,
configuration, Domain/Projects creation, user Administration, user training and
troubleshooting user Issues for new and existing/on-going Projects Management, Test
Planning and co-ordination for Execution, Test execution status / summary & defects
reporting and managing Metrics development using HP ALM Dashboard.
Experience in migrating projects and users from one version of ALM to upgraded version.
Experience in integration of Quality Center, ALM with any other requirements management
tools or any defect tracking tools.
Expert in different types of testing which includes Smoke, Black Box, White Box, Backend,
Integration, System, Regression and User Acceptance testing (UAT) in Client-Server and
Web-based applications.
Experience in Manual and Automated testing on Client-Server and Web-based applications.
Specialized in user requirement analysis, documenting test plans, test cases and execution
of test cases to verify application functionality against the business requirements with
manual testing and using automation testing tools.
Experience in writing and executing simple to complex SQL Queries required for
Database/Backend Testing.
Experience in Data warehouse testing. Extensively used ETL methodology for testing and
support of data extraction, transformations and loading processing in a corporate-wide-ETL
Solutions using Informatica.
Extensive experience in testing and implementing Extraction, Transformation and Loading
of data from multiple sources into Data warehouse.
Hands on experience in section 508 Compliance testing.
Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and
identifying data mismatch.
Hands on experience in web services testing using Soap UI.
Experience in Health Care Provider, Group, subscriber and validation of HealthCare claims
billing (professional, institutional and dental claims) and 837/835 claims processing
(remittance advice or payment) adjudications using QNXT (Trizetto Portal Product), Facets
and NASCO.
Hands on Experience in Product development, Health care, Finance and Utility domains.
Good experience with Federal Government domains. Worked for Federal Government
client’s Social security administration (SSA), Centers for Medicare & Medicaid Services
(CMS) and United States Department of Health and Human Services (HHS)
Hands on experience on creating SQL, PL/SQL queries to run the Database testing.
Strong experience in testing of Client-Server, Network and Web-based applications.
Experience in entire software development life cycle (SDLC) And Testing life cycle (STLC).
Experience in Universe creation using SQL, PL/SQL Queries to develop Business
Intelligence reports using Business Objects and Crystal Reports.
Good understanding of Database Management Systems (Oracle, SQL Server and DB2).
Team player, self-starter and multitasker with good communication skills. Able to adapt to
new environments and learn new technologies quickly.
TECHNICAL SKILLSET:
TESTING TOOLS: Win Runner 7.5, QTP 8.2, 9.0, 10, 11, UFT, Load Runner 8.2,
9.5, Test Director 8.1 and Quality Center 9.0, 9.2, 10.0, ALM
11.5, 12, HP PPM.
DATABASES: Oracle v7.x, v8i, v9i, 10g, 11g, 12 C DB2, Teradata, SQL
Server 7.0,2000 and MS Access 97/2000.
DATABASE TOOLS: SQL Loader, DB Visualizer, SQL Plus, Toad, SQL Developer and
Squirrel.
LANGUAGES: C, C++, Java, VB.Net, VD Script, SQL, PL/SQL
DATA MODEL Facets 4.3, Facets 4.5, Facets 4.71
APPLICATION SERVERS: Microsoft IIS, Web Logic, Web Sphere and JBOSS
WEB SERVERS: Apache, IIS.
TECHNOLOGIES: Client-Server, OOD and OOP, 3-Tier Architecture,
N-Tier Architecture, ActiveX, COM, DCOM, ADO, DAO, RDO,
ODBC, and OLEDB.
ETL TOOLS: Informatica, Business Objects, Crystal Reports.
PROTOCOLS: HTTP, HTTPS, FTP, SOAP, and TCP/IP.
OPERATING SYSTEMS: Sun Solaris 8, Linux 7.0, UNIX, MS-DOS, Windows 95/98, and
Windows NT /2000.
HARDWARE: IBM-PC, SUN SPARC.
PROFESSIONAL EXPERIENCE
HHS (Deloitte) – Washington, DC JAN’ 2021- Present
Test Lead & Micro Focus ALM Octane SME
Projects: Oracle EBS Test Automation for P2P / G-Invoicing / OFSPO Cloud Modernization
Environment: Windows, Oracle EBS, ServiceNow, JIRA, Microsoft Office O365 suite,
Micro Focus ALM 17.01, UFT One 15.01, Load Runner, GitLab, MS Office, Java,
JavaScript, Jenkins, Visio, SharePoint, SOAP UI, UNIX.
Environment: Windows, Oracle 10g,11G,12C, MS SQL Server, Micro Focus ALM, 12,15,
UFT, Honeywell, Yukon, CCB Customer Care & Billing, TIBCO, Java, .Net, SOAP UI, Team
Foundation Server, GitHub, Business Objects, Informatica Power center, MS Office, MS
Visio, SharePoint, Oracle SQL Developer, PowerPoint, UNIX.
Responsibilities:
Responsible for gathering Business requirements and System design details from SMEs,
Technical Lead and created functional requirements documents.
Responsible to create and maintain required deliverables: Test Plan, Test Cases, and
Test data - Manual & Automated, Test Execution, Test Results Reporting, Bug
Tracking and Resolution.
Performed Smoke, System, Regression, End-To End testing for each release on
SIT(QA) and Stage environments and sing off those test cases.
Performed User Acceptance testing along with the business users for Smart Energy
savings, two-way pilot project implementation and Peak Rewards Mobile applications.
Created Requirements Traceability Matrix to ensure that all the requirements are covered
by the test cases.
Responsible for daily Enrolment Errors handling report generation using Honeywell, Yukon
and CCB (Customer Care & Billing) systems & Enrolment Errors root cause analysis and
Errors resolution.
Created Move in / Move out scenarios in CCB to start / stop utility services to test customer
contacts and Alerts.
Retrieved customer details from CCB Control Central using Person name, Account number
and Premise id to access any customer account to work on pending To Do’s
Verified CCB has all customers data migrated after CCB upgrade.
Involved in two-way pilot project implementation and tested Wi-Fi connected
thermostats daily & weekly thermostat schedules, summer Overrides details in BGE web
site and backend database.
Created Universes to get various Business Objects reports and tested those reports.
Conducted test execution status and defect Triage meetings with Project manager,
developers and testers.
Involved in Web Services implementation & Web Service testing using Soap UI and
used Web Services for program / Device installations, program update, remove and replace
transactions.
Responsible to create SQL, PL/SQL queries for data validation, data mapping and
performed data base testing.
Responsible to validate daily customer update files from the vendor – Honeywell against
existing database.
Participated in test environment setup activity that facilities, test tools and scripts are in
place to perform testing effort successfully.
Performed Unit, System, Regression and User Acceptance testing for each Release.
Created Automation scripts using QTP /UFT, design and develop Automation framework
doing proof of concept, estimation and planning automation activities.
Working closely with the project managers, business analysts, developers and QA
resources to ensure testing issues are resolved and fixed.
Responsible to provide Application support for Micro Focus ALM Administration.
Created and Managed ALM Domain, Projects, managed user administration
Created ALM Project Templates and Customized Project Workflow to configure each
module as per the client business requirements.
Designed each module as per the business needs to add required values to various fields
through Workflow Customization to achieve maximum utilization of the ALM functionality.
Created User groups to give required access to each module by user group.
Conducted meetings with project managers and ALM user group to document their needs
to Customize and configure each module for better test management with ALM.
Configured email alerts and rules through ALM Customization and assigned Email
Alerts to required user groups for defects status changes.
Created ALM excel Templates, ALM MAP for exporting business requirements and test
cases from Excel sheet to ALM and provided training to the ALM users on this exporting
activity.
Conducting test execution status and defect Triage meetings with developers and testers.
Configured weekly, monthly testing status reports, graphs in the ALM
Dashboard.
Environment: Windows, Mainframe, Oracle 10g, MS SQL Server, HP ALM 11.5, HP UFT,
Performance Center, Java, JavaScript, jQuery, AngularJS, DB2, Micro Strategy, Squirrel,
JAWS, Section 508, SOAP UI, SharePoint, Informatica Power center, MS Office, Agile,
Scrum, PowerPoint, Putty, HOD, UNIX and SQL developer.
Responsibilities:
Responsible for gathering requirements from SME and created requirements in HP ALM
Created test plan, test cases and prepared test data for test execution.
Participating in requirements & test case walkthroughs with team members to make
sure all scope items were covered by requirements and test cases.
Responsible for HP ALM Project Administration, created and managed user groups &
ALM Module access permissions and assigned test execution effort to responsible testers.
Customized ALM Project Workflow with adding new fields values like payment types,
program types, and stakeholders to populate in ALM requirements and other modules.
Created ALM excel templates, ALM Map and upload requirements, test cases and
test data into HP ALM.
Conducted training sessions to train business analysts & testers on using ALM Excel
templates to upload requirements, test cases and test data into HP ALM.
Linked all test cases to proper requirements in HP ALM and created requirements
traceability matrix to ensure that all requirements are covered by the test cases.
Performing Unit, Integration, System, Regression, End to End and User
Acceptance testing.
Responsible for unit testing along with developers prior to each code drop to find and
issues before code deployment.
Responsible regression testing up on defects resolution to make sure that the new code
resolved existing problems and do not introduce any problems in other areas of the
system.
Created virtual users using Performance Center and performed Load testing for CMS Portal
Performing End to End testing for all applicable user roles such as CMS CM, CMS RO user
role etc, which access the CMS Accountable Care Organization ACO-OS Portal.
Performed Section 508 Compliance testing.
Performed Accessibility testing for multiple browsers using JAWS.
Executed assigned test cases for each code drop and documented test execution results
by creating test evidence files with all screen prints including data base proof and
uploaded test evidence files in to HP ALM test run for all assigned test case.
Participating in scrum meetings with functional manager and team members to update
status & work allocation and outstanding issues resolutions.
Tested Medicare Shared Savings Program Accountable Care Organization Portal - ACO-OS
events calendar module & Reports i.e., Program Reports and Management Reports after
jQuery upgrade to make sure all functionalities and reports were working as expected.
Worked with Data Warehousing developers to design mapping to move data from source to
target database.
Created SQL, PL/SQL queries for data validation and performed data base testing.
Identified test automation scope and developed Automation framework and executed
automated test scripts using HP UFT
Developed Automation test scripts using VB script and HP UFT for Micro
Strategy reports testing.
Performed browser compatibility testing for CMS Accountable Care Organization Portal
using various browsers i.e., Internet Explorer 8.0, Internet Explorer 9.0, Google Chrome,
Mozilla Firefox and Safari.
Managed testing tea, that involved in work allocation, planning and reporting activities.
Participated in test execution status and defect Triage meetings with developers and
testers.
Responsible to Configure and generate weekly, monthly test execution status and
Defects Reports (Excel reports, HTML reports and Graphs) in HP ALM Dashboard.
CMS Engaged QSSI for testing Affordable Care Act application developed by Northrop Grumman
and I worked as Sr. Test Engineer and involved in Accountable Care Organizations (ACO)
And Physician Value modules testing including Quality Resource User Reports (QRURs) using
Micro Strategy Web Platform.
.
Affordable Care Act- Accountable Care Organizations ACO:
Affordable Care Act calls for the establishment of the Medicare Shared Savings Program (MSSP) to
support the development of Accountable Care Organizations (ACOs) The MSSP is a new approach
to the delivery of health care aimed at reducing fragmentation, improving population health, and
lowering overall growth in expenditures by Promoting accountability for the care of Medicare FFS
beneficiaries, Improving coordination of care for services provided under Medicare Parts A and B
and Encouraging investment in infrastructure and redesigned care processes.
Affordable Care Act- Physician Value / Quality Resource User Reports (QRURs):
The business purpose of Physician Value (PV) Program is to support initiatives that will carry out
the Medicare Physician Value mandates within the ACA. The functional purpose of PQRS-PV is to
allow Group Practice users to register for the Physician Quality Reporting System, to elect Quality
Tearing for the Physician Value Program and for Individual Eligible Professionals users to select
Reporting Mechanism for Administrative Claims reporting for PQRS payment adjustment. Reports
are generated to evaluate the Quality of services provided by Health care organizations based on
the Quality & Cost composite scores in order to release the funds based on the value based
payment method.
Responsibilities:
Analyzed user requirement documents and software requirements specification document
(SRS) and prepared System test plan by dividing the application into manageable units.
Responsible for gathering requirements from SME and Technical Lead and created
functional requirements.
Responsible for writing the Test Plan, Test Cases and Test data based on the
Functional and technical Specifications.
Created detailed test cases, test data and reviewed with the developers and finalized the
test cases.
Tested Medicare Shared Savings Program Accountable Care Organization Portal - ACO-OS
Reports i.e., Program Reports and Management Reports.
Tested Program Reports and Management Reports for all applicable user roles.
Performed field validations, Front-end and Back-end validations for Physician Value
application’s Registration Module and tested all Registration Module functionalities as per
the business requirements.
Created PV PQRS Registration system end user roles using CMS IACS system.
Registered every applicable user role in Physician Value Registration system and tested
every user roles with End to End test scenarios during Registration and after Registration
including confirmation emails and Alerts from the CMS system.
Tested Quality and Resource User Reports (QRUR) as an Individual and Group
Practice user roles using Micro Strategy Web Platform.
Performed Web Service testing using Soap UI and Validated the Response data with
Request data.
Created Soap UI training document to train CMS end users for User Acceptance Testing.
Worked with Data Warehousing developers to design mapping to move data from
source to target database.
Created test cases and test data for ETL mappings and tested daily data loads.
Performed browser compatibility testing for Physician Value Registration process using
various browsers i.e., Internet Explorer 8.0, Internet Explorer 9.0, Google Chrome, Mozilla
Firefox and Safari.
Performed Section 508 Compliance testing.
Performed Accessibility testing for multiple browsers using JAWS.
Conduct Peer Reviews and requirements / test cases walkthroughs with team members.
Performed Unit, integration, System, validation, Regression and User
Acceptance testing for PV PQRS Registration system.
Performed End to End testing for each user role i.e. CMS Admin, Group Security Official,
Group Rep, Helpdesk Tier 1 and 2 with all QRUR reports.
Inserted values into the database using CMS HOD client to manipulate the QRUR report
with several scenarios and generated QRUR report using Micro Strategy tool and
performed data validation.
Responsible for HP ALM Administration, created and managed user groups and assigned
test execution effort to responsible testers. Customized Quality Center Project Workflow
with adding new fields in HP Quality Center for reporting purpose.
Prepared HP ALM training documents, PowerPoint presentations and provided HP ALM
training to new users for all modules.
Successfully implemented Automation Frameworks (Data driven, Keyword driven &
Modular) using QTP 11.
Created Automation scripts using QTP and automated PV Registration process test cases.
Created and loaded multiple sets of test data in to QTP data table and executed with
automation scripts and performed results analysis.
Executed the test cases and documented test execution results by creating Test Evidence
Files with all screen prints along with data base proof as expected results and uploaded
Test Evidence Files in to CMS / QSSI Share Point and HP Quality Center for all assigned test
case.
Monitor the Test Execution progress and manage the issues during Test execution phases
Identify and document defects when performing test execution.
Retested the defect fixes following the defect life cycle.
Developed SQL, PL/SQL queries to validate data validation and performed data
base testing.
Created Requirements Traceability Matrix to ensure that all the requirements are
covered by the test cases.
Linked all test cases to the related Requirements in HP ALM and created RTM reports.
Performed performance testing by creating virtual users using Load Runner.
Created several applicable user roles for Physician Value Registration using IACS system
and performed User Acceptance testing along with CMS users.
Participated in review meetings during the entire testing process.
Support full Software Development Life Cycle (SDLC) with understanding of various
technologies and platforms such SOA (Service Oriented Architecture).
Worked closely with the project managers, business analysts, developers and QA resources
to ensure testing issues are resolved and fixed.
Prepared test execution metrics and reported daily status to the management.
Conducted test execution status and defect Triage meetings with developers and testers.
Used HP Quality Center for Test management and defect management purpose.
Configured weekly, monthly test execution status and Defects Reports (i.e. Excel reports,
HTML reports and Graphs) in HP ALM Dashboard.
Environment: Windows, Mainframe, Oracle 10g, MS SQL Server 2005, DB2, HP Quality
Center 10, HP ALM, QTP, Load Runner, JAWS, Section 508, MS Project, Visio, Share
point, UNIX, Java, JavaScript, SOAP UI, XML, MS Office, PowerPoint and TOAD.
Responsibilities:
Responsible for gathering requirements from SME and Technical Lead and revalidate with
the business needs.
Reviewed Use Cases and Involved in development of Test Plan, test schedules, test
cases based on high-level process flow diagrams and designs.
Reviewed Business Requirements, Functional and Technical specifications and created
functional Requirements.
Based on Technical and Functional Specifications created Test Cases, Test data in Excel
and uploaded them into HP ALM.
Performed the Unit, System, Regression and User Acceptance testing.
Involved in preparation of Test strategy document that defines the test environment,
phases of testing, entrance and exit criteria into different phases of testing.
Responsible to provide HP ALM Project Administration support.
Created HP ALM Excel Template for loading Requirements and test cases into ALM directly.
Prepared HP ALM best practices and error handling documents and shared with all users to
improve the tool usage.
Developed Requirements Traceability Matrix to ensure that all the requirements are
covered by the test cases.
Performed Section 508 Compliance Testing.
Participated in the test environment setup and in ensuring that the facilities, test tools and
scripts are in place to successful performing the required testing effort.
Planned, coordinated, and monitored project levels of performance and activities to ensure
project completion before or On-Schedule.
Created Automation scripts using QTP, design and develop Automation framework
doing proof of concept, estimation and planning automation activities.
Extensive use of Descriptive programming, function libraries and shared object repositories
Working closely with the project managers, business analysts, developers and QA
resources to ensure testing issues are resolved and fixed.
Performed Database integrity testing by executing SQL, PL/SQL statements.
Participated in various meetings and discussed Enhancement and Modification Request
issues.
Conducted test execution status and defect Triage meetings with developers and testers.
Prepared weekly, monthly status/defects report and graphs using HP ALM Dashboard.
Responsibilities:
Responsible to provide Application support for HP Quality Center Site Administration.
Created and customized Projects, New users, User Groups of Quality center, and provided
Quality Center training to new users.
Customized Quality Center Project Workflow as per the client’s business requirement
Managed Quality Center site connections and license usage for all QC projects and provided
help desk support to QC users to resolve issues.
Conduct progress meetings to resolve technical/non-technical issues with HP Quality Center
Prepared Quality Center training documents, PowerPoint presentations and provided Quality
Center training to new users for all QC modules.
Manage QC users in projects and provided support to Quality Center users to resolve issues.
Involved in upgrading and configuring HP Quality Center 9.2 to 10.0 migrations.
Responsible to monitor all application logs for errors with HP Quality Center.
Providing detail structure to Test Plan tree and access to the Test case developers to write
their test plans.
Responsible to create and maintain required deliverables: Test Plan, Test Cases, and Test data
- Manual & Automated, Test Execution, Test Results Reporting, Bug Tracking and Resolution.
Created Test Plan and Test Cases based on business requirements.
Wrote Test Cases in Excel based on Technical and Functional Specifications and uploaded
them into HP Quality Center.
Involved in data validation after every account migrated in to NASCO system.
Involved in all Large Group accounts Institutional, Professional and dental claims testing.
Performed web-based Care First’s Claims Processing application testing with valid and invalid
test data.
Developed various script modules using VBSCRIPT in QTP for automation. Used various
checkpoints, synchronization points and developed various data-driven tests using Quick Test
Professional.
Queried the DB2 database in Mainframes for Proper data validation in both source system
and target system.
Performed data analysis using Excel for validating data correctness
Executed test cases and found errors. Reported defects, coordinated with developers and
business analysts. Determined repair priorities.
Performed extensive regression testing to ensure that there is no impact due to the code
changes.
Prepared test summary reports after end of every release. Uploaded validation documents in
to share point web site for further review.
Wrote extensive SQL, PL/SQL queries for performing database testing.
Directly worked with the development team to resolve problems and provide technical content
for product documentation.
Lead the team for the NASCO Large Group Migration project
Performed User Acceptance Testing of NASCO Large Group Migration.
Performed extensive benefits and eligibility validations, data validation and claims validation
as per the HIPPA guidelines for NASCO Large group migration.
Configured following reports, weekly, monthly status, defects reports and graphs in HP
Quality Center Dashboard.
Environment: Windows 2003 Servers, HP Quality Center 9.2, 10, QTP 9.2, MYSQL, SQL
2000, Oracle 9i, 10g, Mainframe, DB2, VBScript, JavaScript, C, C++, Informatica Power
center 8.5, Apache, PL/SQL, Teradata, SQL Server 2000, Flat files, Visio, PowerPoint,
XML, SOAP, UNIX, Shell Scripting and Toad.
Responsibilities:
Provided Application support for Quality Center Site Administration and provided technical
guidance to engineers and team management.
Site Administration---Configured application servers, Created Domain, Projects, users,
monitored all application logs for errors, monitored the Microsoft SQL database, responded to
reported issues, performed application administrative functions including but not limited to
creating new projects, performed all upgrades and enhancements and Customized Quality
Center projects as directed.
Involved in Bugzilla - Quality Center integration: Created Bridge between Bugzilla and Quality
Center to import Bugzilla defects data in to Quality Center.
Worked as a Quality Center administrator and worked with Mercury Team on integration
Mercury and non-Mercury products with Quality Center.
Analyzed the legacy defect tracking tools, its fields and its functionality.
Created and customized field values in Quality Center Requirements, Test Plan, Test Lab and
defects modules
Experience in implementing LOG files to debug Test Director, Quality Center and SQL trace for
DB checkpoints.
Experienced in setting parameters for Site Config and in developing and using API(s).
Extracting the data from different databases (SQL Server, Mysql and Oracle) using complex
queries.
Created Stored Procedures and functions to retrieve the data from various data bases.
Performed script Migration from development to testing and testing to production systems.
Performed web based front end application testing with valid and invalid test data.
Performed tasks of executing, scheduling and validating the sessions in Informatica
Workflow manager.
Created Entity Relation diagram for data base analysis and performed Database Testing
using SQL and PL/SQL Queries.
Created Requirements, test plan, test cases and performed test execution during various
phases of the product life cycle.
Executed SQL queries to check whether the database was updated as per the inputs provided
by the user. Extracted data from numerous Teradata data tables and performed backend
testing.
Developed automation script using QTP to perform Regression testing for each release.
Developed automated scripts using QTP for Functional testing and Data driven testing.
Enhanced QTP Scripts using different Checkpoints, Parameterization, Regular expressions,
Environmental variables, User defined functions, User messages, Warnings and used Recovery
scenarios for Error handling.
Generated weekly, monthly status reports from Quality Center 9.2 database.
EDUCATION:
Bachelor of Engineering from Andhra University – Vizag, India
REFERENCES:
Available on request.