Quality Assurance Data Analysis

ALLA BARANOVA

*** ****** ***** ***: 848-***-****

North Brunswick, NJ 08902 Email: *******@*****.***

SUMMARY

Reporting and data analysis, designing, creating, publishing and managing reports and dashboards. Perform complex data analysis based on internal and external user and customer requests using a strong background in computer programming (mainframe, client/server, and web-based platforms). Setup and configure customer settings within business applications Hands-on experience in analysis, design, development, testing and implementation of applications using SQL Management Studio.

PROFESSIONAL EXPERIENCE

2012 - Present HUDSON REGIONAL HOSPITAL (former MEADOWLANDS HOSPITAL MEDICAL CENTER)

IT Analyst /Report Writer Secaucus, NJ

Analyze, design, validate, and support existing reports and create new for all Hospital departments.

Make sure all daily reports are updated on the Hospital intranet page and Tableau application.

Maintain data integrity and ongoing quality control of delivered reports by using Microsoft SQL Server Management Studio, KB SQL, Tableau and NPR report writer tools.

Assess reporting results through data investigation, analysis, and evaluation. Created Barcode on patient’s labels and registration face sheets.

Track issues found during UAT and throughout QA lifecycle

Supported Kronos Workforce Central application during update to the new version. Upload/updating employee’s data and control employee’s access.

Work closely with all levels of end users, including executive level staff for quickly developing reports, which are used for strategic business decisions.

Participate on IT team rotating help desk on call support.

Helping users to resolve issues with multiple applications and update employee’s access.

2008 – 2012 MED-LINK COMPUTER SCIENCES, LLC Bloomfield, NJ

Quality Assurance Analyst

Testing client/server application that supports patient demographics, account payments transactions, insurance information and claim payment guidelines.

Responsible for assisting account managers and support through the generation and analysis of new uploads.

Reports validation and evaluation using Microsoft SQL Server Management Studio.

2003 – 2008 CONFIDENT CARE CORP. Perth Amboy, NJ

Quality Assurance Analyst

Primary duties include daily maintenance, troubleshooting and liaison with programming staff regarding bug fixing and new functionality requests. Responsible for operational support of client/server applications designed for Customer Service and Human Resources.

2000 – 2001 UNITED HEALTHCARE CORPORATION Somerset, NJ

Sr. Quality Assurance Analyst

Supported Provider’s Systems (Uniprise) through Quality Control system testing of industry leading provider database.

Performed QA test procedures in a CICS/3270 IBM mainframe environment, client/server and Intranet; Provided QA support and Performed testing on both test and production servers on the Contract Management System (CMS) Internet initiative; Created online (Intranet) help pages.

Created explicit QA test plans for functional and regression testing. Prepared and executed SQL queries to ensure database integrity.

Implemented an automated regression-testing tool (Compuware’s QA Hiperstation). ISPF TSO commands used for modifications of recorded scripts. Conducted training sessions for Business Analysts and Project Managers.

COMPUTER LEGACY SYSTEMS, INC. Springfield, NJ

Quality Assurance Consultant 1998 - 2000

Involved in testing of the new Asset Management System that ran on UNIX and Windows NT platforms. Created new account/portfolio, master records for any security type; input trades and performed necessary accounting and reporting. The system had interfaces with major data vendors, brokers/dealers, and custodians. System’s WEB component allowed receiving files, querying and updating data through the corporate Intranet and Internet. Wrote Test Cases and test scripts for performing stress tests on application.

Participated in all aspects of conversion and testing of the client/server Policy Processing System that replaced a mainframe-based application utilizing COBOL, VSAM, DB2, and CICS. The new system utilized C, Visual Basic, and ORACLE database. Conducted Regression testing using SQA Robot; Analyzed conversion programs that extract data from VSAM files and DB2 tables for transfer to an ORACLE database; prepared various queries and reports using SQL.

Performed multiple assignments related to Year 2000 remediation including analysis, coding, testing, and documentation; 20XX future date testing; Analyzed copybooks, record layouts, CICS maps, JCL decks, and COBOL programs to locate date elements that had double digit century field.

SKILLS

Languages: COBOL/COBOL-2, CICS, JCL, SQL, Visual Basic 5.0/6.0, C, HTML, VB Script

QA Tools: WinRunner, Test Director, SQA Suite, SQA Robot, QA/Hiperstation, QA Partner

EDUCATION

1998 CHUBB INSTITUTE Jersey City, NJ

Diploma in Computer Programming

1984 POLY TECHNICAL INSTITUTE Tashkent, Uzbekistan

BS in Mechanical Engineering; Minor in Computer Science

Contact this candidate