Uploaded File
add photo
Haribabu
haribabu.maddineni@gmail.com
620-704-4213
985 22nd Ave., Unit 206
Silvis, IL 61282
Business/Quality Data Analyst
11 years experience W2
2
Recommendations
Average rating
113
Profile views
Summary

  • Over 6+ years of professional work experience with an earned reputation for meeting demanding deadlines and delivering critical solutions on various levels of Quality Data Analyst in IT, Life Insurance and Healthcare Industries.
  • Involved in thorough study of Business Requirement documents and functional requirement specifications.
  • Participated in weekly meetings with Business Analysts, Development and QA team to discuss the milestones, progress and the issues.
  • Analyzed testing results and generated Business analyst daily status Reports and communicate with team for future priorities.
  • Exceptional problem solving, decision-making, strong interpersonal and communication skills.
  • Acquire data from primary or secondary data sources and maintain databases/data system
  • Excellent understanding of the Software Development Life Cycle (SDLC) with emphasis on Black Box testing, functional testing, GUI testing, system testing, regression testing, security testing. Skilled at building a strong team environment, and have ability to acclimatize to new technologies and situations with ease.
  • Was involved in writing the test plans, test cases, executing the test cases, linking the test cases with the requirements, logging the defects and tracking the defects.
  • Involved in writing complex SQL Queries for verifying the data in database and reports.
  • Experience in TFS, QC-ALM, QTP, HP-UFT, SELENIUM, WINIUM and AUTO IT
  • Performed the back-end testing to ensure data consistency on front-end by writing and executing SQL queries.
  • Experience testing migration of 4010 to 5010 EDI transactions and data mapping
  • Extensive experience in Healthcare/Claims adjudication with knowledge of ICD-9 & ICD-10
  • Used Quality Center as repository for requirement analysis, design test cases, Execute test cases, Bug tracking and reporting.
  • Performed End-to-End Testing manually and automation.
  • Experience on testing windows and Web based applications.

Experience
Business/Quality Data Analyst (SME)
Information Technology
Sep 2014 - present

Modern Woodmen of America is a member-owned fraternal financial services organization. Modern Woodmen's main product lines are life insurance, annuity and investment.

Responsibilities:
• Perform the business meeting to finalize the tasks for IT
• Extract the data from data base using IBM SQL Studio and SQL navigator tools validate the required information send the data claim process
• validate the Agent data, ability to analyze, translate, and define business requirements into system specifications for members
• Perform UFT and Selenium scripts for automation of web and windows applications testing
• Reading and understanding code, and performing code reviews throughout the software development lifecycle
• Creating test deliverables and performing testing
• Executing test scenarios, writing test scripts and tracking defects to ensure that application meet technical and business requirements
• Recommending improvements based on testing results
• Performing business analysis and utilizing knowledge of TFS for tasks and work management.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.

SQL Business Analysis Business Requirements Data Analysis Selenium EDI HIPAA MS TFS Compliance
Remove Skill
References
Average Rating

1 recommendation
Data Quality Analyst II
Information Technology
Jun 2013 - Sep 2014

BCBSFL provides healthcare benefit for individual, small and midsized businesses and large employers. Worked on a data conversion application, which loads EDI claims files into the document imaging system. Claims were received in ANSI X 12 837 format and were converted to the internal XML file format. Files were indexed and loaded into document imaging system. Testing procedures verified document images against claims management database.

Responsibilities:
• Provider and Members data, analyze results using statistical techniques and provide ongoing reports
• Extract the data from data base using IBM SQL Studio and SQL navigator tools validate the required information send the data claim process
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
• Acquire data from primary or secondary data sources and maintain databases/data system
• Reviewing and analyzing the BRD, FRD and Detail design documents, and understanding the SDLC methodology of the organization.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.
• Documenting the test plan, test cases, test scripts and expected results using Quality Center (for GUI testing, Functional testing, Data validation, Security testing, Compatibility testing, Performance testing)
• Preparation of test data for the positive and negative test cases.
• Conducting the walk thru of the test plan with the developers and design team
• Verified HIPAA compliant X 12 format for EDI transactions.
• Validated EDI files against ICD-9 compliance and cross walk ICD 9 - 10 and also ICD10 - 9
• Wrote test cases to check the formats of transaction requirement for 834/835,837,276/278.
• Experience in Testing HIPAA Gateway EDI Transactions. Experience in HIPAA transactions EDI 837 (Institutional/Professional), 835 (Payment Remittance Advice), 270 (Eligibility Request) / 271 (Eligibility Response), 276 (Claims Status Inquiry Request) / 277 (Claims Status Inquiry Response), 834 (Benefit Enrollment and Maintenance Transaction), 278 (Prior Authorization), 997 (Transaction Acknowledgement).
• Tested the EDI interfaces and X 12/EDI transactions (270, 271, 835,837 and 997).
• Backend testing by executing the SQL commands for data retrieval/verification, data updating and data insertion into the tables
• Prepared test matrix and test status reports to reflect the status of testing and bug fixes of the HP Quality Center.
• Used Quality Center to track the defects encountered during testing.
• Test cases are designed for the black box testing and perform boundary value analysis, decision table analysis for business rules, and state transition verification.
• Extensively used Quality Center for defect tracking and prioritizing defects and enhancement requests after base lining the requirements.
• Tested the database integrity by writing SQL queries
• Tested XML files using XML Spy.
• Involved in database testing by writing and executing SQL queries to validate that data is being populated in appropriate tables.
• Involved in manual testing of ETL components, SQL, PL/SQL blocks.
• Conducted and Attended review meetings, performed Walkthroughs with the developers and development team to set a hard-freeze date and gather input for creating the Test Plans and Test Specifications.

Environment: J2EE, Quality Center, DB2, Mainframe, SQL, Oracle, Microsoft, XML, HTML, MS-Excel, Web Services, Web Applications

SQL XML Data Analysis Oracle SDLC Data Conversion PL/SQL ETL Data Validation Backend Testing Black Box Testing Compatability Testing Database Testing Functional Testing EDI HIPAA HP QC Manual Testing Performance Testing Security Testing System Testing Test Case Preparation Test Planning WebServices BRD FRD Compliance DB2 Microsoft Excel 834 837
Remove Skill
Quality Analyst
Information Technology
Feb 2013 - Jun 2013

Involved in voluntary training on QA validation at IIS LLC, to gain professional experience. During the training period gained expert knowledge in the field of Software Development Life Cycle with emphasis on Quality Assurance using various tools such as Mercury Interactive tools under Windows and Unix Environments. The extensive software testing exposure includes the manual and automated testing of Client-Server, Multi-Tier, Stand-alone and Web-based applications with tools like Quick Test Professional. Gained experience in all forms of testing including Functional, Integration, Performance, and User Acceptance testing. Improvised excellent judgment skills during the extensive training period to identify areas of high risk critical business areas early in an application and prioritize tasks to focus testing effort in a fast paced environment. Developed excellent professional skills by working independently and as a part of the team in structured and unstructured environments.

Responsibilities:
• Formatting the Business Requirements and helping the technical lead to come up with the User Stories.
• Analyzed the project requirements, available resources and end user's expectation to determine the outline for the EPIC module.
• Created and Managed Test Plans Test Cases and Test Procedures.
• Performed Data Discovery, Data Profiling to validate the Data that was used in the project and helping Developers to create the tables according to the Data model.
• Attending Scrum meetings, Sprint retrospective meeting, Sprint Planning, Sprint Story Grooming meeting with Product owners and Scrum Managers.
• Managed Sprint Tasks, all the Scrum activities using Rally .
• Participating in Design sessions, code review sessions, and planning sessions with peers.
• Performing SQL Testing using complex SQL queries like Joins, Update, Insert and other SQL scripts.
• Performed Store Procedures testing using complex SQL queries and validate the Test Cases depending on the Data in the output.
• Verified cross-walk for understanding major changes from ICD-9 to ICD-10. Drafted the major changes that would appear in ICD-10 version.
• Verified the EDI raw data as per 5010 format.
• Performed Automation testing using Selenium Web driver, to validate the data in the tables and to perform end to end testing.
• Created test scripts to perform to run the Web services in Selenium and perform automation testing.
• Performed web services testing using Soap UI and REST using different assertion techniques.
• Performed SQL Testing, Data manipulation, Data Integration, Server Validation using SQL Server and Razor SQL.
• Validated Test Cases and Managed all the Defects using Rally testing tool.
• Performed ETL Testing using Informix tool and with Unix environment.
• Performed Regression Testing, Smoke Testing, Integration Testing, and User Acceptance Testing using the Test Cases created in Rally.
• Responsible for generating Test status Report for the Test Cases validated for SQL Queries constructed by SQL Server Database.

SQL Automated Testing Test Case Preparation Test Planning Integration Testing Regression Testing Business Requirements Scrum Selenium Smoke Testing Quality Assurance ETL Testing Software Testing EDI WebServices Microsoft Excel REST SOAP SQL Server WebDriverIO
Remove Skill
QA Analyst
Chemicals/Pharmaceuticals
Jul 2009 - Dec 2012

Responsibilities:
• Studied at SDSU in a graduate program with chemistry major during which also worked on various projects involving complex testing procedures following STP's and SOP's as per the requirements.
• Created the detailed system test cases from the business requirements documents.
• Integration Test, User Acceptance Test under different environments.
• Reviewed vendor solution designs and assists in coordinating testing between vendor and client for product enhancements.
• Responsible for testing the entire functionality of the application.
• Tested the interface between database and the application.
• Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
• Tested the LPF generated from the 837 files using the File aid and Copybook.
• Unit Tested 837 (Institutional, Dental, and Professional), 835, 270/271, 276/277, 820, and 277U transactions with TSO, ISPF, and File Aid.
• Involved in Data mapping to/from legacy to FACETS that will be used to populate the oracle database.
• Good Understanding on FACETS application.
• Involved in processing claims in FACETS and validating the full cycle process to make sure the checks are generated and 835's are generated.
• Developed test scripts for Data Driven tests. Executed the test scripts and analyzed the results.
• SQL queries are used for backend testing on the UNIX platform.
• Participated in requirement walkthroughs and creation of test plan.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Involved in both Manual and Automated testing.
• Created and implemented functional tests using QTP and customized QTP scripts with VB scripts
• Involved in load testing end-to-end testing scenarios using large data files.
• Prepared QTP Automation Test Plan.
• Developed and executed automated scripts using QTP to ensure functionality of application.
• Performed Back End testing by executing SQL queries.
• Involved in ETL testing process as Extracting batch files, Transforming and Loading into database.
• Performed Integration testing, System testing and Regression testing.
• Interfacing with developers to resolve the technical issues. Environment: QTP, Fire fox, Windows XP, Oracle, MS-Project Server, Share Point, MS-Visio, SQL, JAVA, JSP, JavaScript, XML, FACETS, Windows 2000/NT/XP, IIS, JavaScript, UNIX, IIS.

SQL Automated Testing Test Case Preparation Test Planning Functional Testing Integration Testing Regression Testing System Testing Business Requirements Backend Testing Quality Assurance HP QTP ETL Testing Load Testing HIPAA Data Mapping 837 Java
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Chemistry
South Dakota State University, 2009 - 2011
Record has not been verified.
Skills
HIPAA
2021
7
SQL
2021
7
Business Requirements
2021
6
Compliance
2021
5
837
2014
4
Backend Testing
2014
4
Data Analysis
2021
4
EDI
2021
4
Functional Testing
2014
4
Gupta SQL Windows
2017
4
System Testing
2014
4
Test Case Preparation
2014
4
Test Planning
2014
4
Automated Testing
2013
3
Automation Engineer
2016
3
Data Mapping
2012
3
ETL Testing
2013
3
HP QTP
2012
3
Integration Testing
2013
3
Java
2012
3
Load Testing
2012
3
Quality Assurance
2013
3
Regression Testing
2013
3
Business Analysis
2021
2
MS TFS
2021
2
Selenium
2021
2
834
2014
1
Black Box Testing
2014
1
BRD
2014
1
Compatability Testing
2014
1
Data Conversion
2014
1
Data Validation
2014
1
Database Testing
2014
1
DB2
2014
1
ETL
2014
1
FRD
2014
1
HP QC
2014
1
Manual Testing
2014
1
Microsoft Excel
2014
1
Oracle
2014
1
Performance Testing
2014
1
PL/SQL
2014
1
SDLC
2014
1
Security Testing
2014
1
WebServices
2014
1
XML
2014
1
REST
2013
1
Scrum
2013
1
Smoke Testing
2013
1
SOAP
2013
1
Software Testing
2013
1
SQL Server
2013
1
WebDriverIO
2013
1
Languages
English, Fluent/Bilingual