SAILAJA TUMU

Phone: 682-***-**** Email: adbpvb@r.postjobfree.com

SUMMARY:

Over all 15 years of experience as Data Integration QA Analyst and Requirements Analyst in Healthcare Industry.

Have good experience in testing the web based testing and ETL testing by using Informatica & Data stage tools.

Good experience in testing the products by using XML & HL7 messages in Healthcare, Insurance and Pharmacy domains.

Worked in second line production support to fix the data correction issues in SQL by directly interacting with various clients.

Have experience in requirement gathering, coordinating between the team members, creating test plans and executing test scripts according to the business requirements in standard applications

Working knowledge of Data Warehouse concepts, applications and ETL.

EDUCATION: Master in Computer Science

EXPERIENCE:

Blue Cross Blue Shield Oct 19 – Till date

Richardson, TX

ETL QA Analyst

Well Being Management (WBM) is a project where there was need to provide targeted messaging to Retail Members. Messages need to be provided to retail member about new products and other specific messages to enrich their relationship with HCSC.

Responsibilities:

Involved in client meetings to gather the requirements

Creating test cases by using the source and target mappings

Wrote Hive queries to perform the source and target testing

Performed the validation of DDLs of the tables.

Loaded the data into the target table by using DataStage

Wrote complex queries to perform the data validation.

Validated the data in the flat files for Initial and Incremental loads.

Co-ordinated with business users during UAT.

Logged the defects in Jira

Environment: Big data, Hadoop, Hive, Spark, Kafka, Jira, Teradata, qTest 9.7, DataStage 11.5, Unix, Windows 7

Texas Health Resources July 16 – Sep 19

Dallas, TX

Data Integration QA Analyst

Patient Flow is a project which captures the entire patient data right from patient admission to discharges which will be used to build the patient admission and discharge dashboards.

Responsibilities:

Involved in client meetings to gather the requirements.

Creating test cases by using the source and target mappings

Developed ETL test scripts by using the Source to Target mappings.

Validated the data from source to target.

Worked on issues with migration of Data from development to QA-Test Environment

Testing various ETL processes for Data Quality

Involved in validating the Tableau reports

Involved in UAT meetings.

Executed automated test scripts by using QTP 9.1

Environment: Data Stage 11.5, Netezza, Teradata, Hbase, Hive, Kafka, HP Quality Center 12.5, Tableau, QTP 9.1, Unix, Windows 7.

Health Fitness May 15 – June 16

Dallas, TX

Data/Requirements Analyst

EIM – Data Warehousing is a project which will have all participants Eligibility, Biometrics, Medical and Pharmacy claims data of different clients. Incentive files will be generated from this warehouse and will be sent to the clients for different program participations.

Responsibilities:

Involved in client meetings to gather the requirements.

Create standard data mapping template for developers to exchange data with clients

Determining business impact level of data quality issues, and working with developers to correct data quality errors

Verifying the data between source system, the staging area and the data warehouse and other systems of data accuracy.

Involved in validating the data in the flat file.

Monitoring various standard package for any data discrepancies.

Environment: MS SQL Server, Oracle SQL Developer, PL/SQL, MS Word/Excel, Filezilla, Sharepoint

Texas Health Resources Nov 12 – Feb 2015

Arlington, TX

ETL QA Analyst

CBI (Clinical Business Intelligence) is an application which will capture the Patient Clinical, Medication, Labs and Billing data.

Responsibilities:

Involved in creation of Test plans, Test Strategy & Test Scenarios and Test Scripts by using the requirement documents.

Involved in reviewing the Business Requirement Document.

Involved in testing of clinical data in the back end by using the SQL queries and joins.

Involved in analysis of root cause of the defect.

Involved in testing of ICD9/10 coding data.

Prepared traceability matrix.

Prepared status report and send them to managers on weekly basis.

Involved in gathering of baseline data and communicate results to stake holders.

Logged the bugs into defect tracking tool and involved in the defect tracking meetings.

Environment: Data Stage 11.5, .Net, Aqua Data Studio 12.0.6, DB2, MSMQ, Cognos 10.0, Windows XP, Unix, HP ALM 11.0.

Hospital Corporation of America, Nov 10 – Oct 12

Nashville, TN

QA Analyst

PatientKeeper Patient Care Suite in an integrated web based clinical data application. It consists for two components. Patientkeeper Physician Portal and PatientKeeper Mobile Clinical Results. This application can be accessed on either type of platform, whether desktop computer or handheld device. This application is integration of GE RAD PACS, GE CV PACS,GE BAR(Billing & Revenue cycle Management) & FUJI ROSE.

Responsibilities:

Written test Plans, test Cases, Test scripts, test scenarios for the Q

Involve in testing of clinical rounding reports on mobile device and web portal which were developed in SQL server reporting services.

Involved in testing of integrated GE RAD PACS, GE CV PACS, GE billing & FUJI ROSE applications.

Involved in testing of Patient Keeper web application.

Involved in ICD-9, ICD-10 and Snomed coding systems.

Environment: Meditech 5.6/6.0,Mainframe,AS/400, ASP.Net,.Net 4.0 Framework, QTP 9.1, SQL Server 2008, SSRS, MS Visual Studio Team Foundation Server 2010, MSMQ, Android, iPhone OS 3.0, Blackberry, Windows XP.

Pearson Education Apr 10 – Oct 10

Upper Saddle River, NJ

Data QA Analyst

DIA is a data integration hub that supports integration of high data volumes from heterogeneous data sources in different formats, through various communication protocols, and accurately detects changes at the attributes level for reliable consumption by multiple consumer systems in a canonical message format. DIA is implementing the ETLD, Extract, Transform, Load, and Deliver architectural pattern for data integration. DIA uses guaranteed message delivery mechanism (JMS) to ensure reliable message delivery to various consumer systems using publish-subscribe model. Main Aim of this project is testing the Pearson Education website after data gets migrated.

Responsibilities:

Involved in creation of detailed test plan and test cases from the Business Requirements Document.

Involved in creation of test data by using the Business Requirement Document.

Involved in white box testing to test the maps.

Importing the maps to Informatica and extracting the data by running the sessions.

Involved in validation of transformations, aggregations and look ups.

Involved in creation of metadata database.

Involved in loading of data into database through UNIX.

Involved in testing of Online Information Exchange (ONIX) messages by using Altova XML spy.

Involved in validation of XMLs and XSDs.

Involved in testing of source and target data base count by using the T-SQL.

Involved in preparation of weekly status reports and status meetings.

Logged defects in defect tracking tool.

Environment: Java, Informatica 9.1,Oracle 11, PL/SQL, Cognos 8, Windows XP, Unix, Altova XML Spy, JSMQ, Exam XML, Bug Zilla, MS Visio.

NHS Hospitals, UK Jan 05 – Mar 10

Lorenzo Regional Care to i. Patient Manager Migration

Data Sr. Quality Engineer

LORENZO Regional Care Data Migration is a part of LORENZO Regional Care program for NHS, to migrate the data from legacy system to new system. The scope of Data Migration testing is based on end-to-end testing of Intermediate file formats identified in different work areas.

An Intermediate Flat File (IFF) file will be created by extracting the data using Informatica tool from the source data base (i. Patient Manager). The Data in the IFF file will be loaded into target (Lorenzo) by using the LDMS (Lorenzo Data Migration Studio) tool. Data Migration Testing involves validation of Intermediate file formats and intermediate Flat files. The validation of the same is done by using the Lorenzo Data Migration tool (LDMS) by running the migration process.

Responsibilities:

Created staging database by using metadata.

Validated Informatica mappings, workflows and extracted the data in flat files by using DTS.

Created and executed SSIS packages.

Verification of XML files, Source excels, Target Excels, Release Notes and Snapshot Documents.

Imported the metadata XMLs, DTRs (Data Retrievals) into LDMS and validated the XMLs as per the business logic.

Added indexes to the DTRs to increase the performance.

Validated the Lookups, Expressions and Validations as per the business logic in requirement specification.

Fixed data related issues in SQL server and cleared the transaction and audit log files.

Executed the packages to load the data into target database.

Performed the Database Validation and UI validation with the migrated data to check whether data is getting populated or not.

Environment: C#.Net, Informatica 9.1, .Net Framework, SQL Server2005/2008, Windows 2000/XP, MS Visual Studio 2005/2008, SSIS, IBM Rational Clear Quest 7.1.

Nuffield & NHS Hospitals, UK Sep 02 – Dec 04

i.PM (Patient Manager)

Quality Engineer

Patient Manager is basically Electronic patient medical record management system (EMR). Patient manager system provides a highly intelligent store for totally integrated information across all care settings in both the public and private sectors. i.PM supports acute care, community care, mental health and child health care. Integrated information access supports all those healthcare professionals involved in care delivery with the same accurate, timely information to enhance performance and improve communications. Specialized modules such as pharmacy management and booked admissions combine to provide integrated tools to improve information quality and access. Master patient index, Outpatient management, Clinic management, Accident & Emergency management, Pharmacy management, Electronic patient record management, Theatre department management are some of the major modules in i.PM. i. PM also contains Billing module which is divided into inpatient and outpatient billing.

Responsibilities:

Involved in customer support to analyze issues in backend by interacting directly with clients.

Involved in testing of Patient application administration, Clinical, Medical and Billing modules.

Involved in testing of Service Level Agreement releases.

Involved in testing of PDS & LRS web services manually.

Written Test cases for requirements for enhancements

Involved in testing of HL7 messages by using XML spy

Involved in testing of ICD-9 & ICD-10 coding systems.

Involved in testing of healthcare insurance claims 835 & 837.

Performed User Interface Testing, Integration Testing,System Testing & UAT.

Logging and keeping in track of defects.

Environment: VB, Mumps, SQL 2000, Oracle 8i/9i, MSMQ, Toad, Doors, Test Director, Windows, iAssist.

Contact this candidate