We provide IT Staff Augmentation Services!

Sr Qa Analyst/production Support Data Analyst Resume

SUMMARY

  • Innovative Analyst with more than 8 years of diverse experience in the field of IT analysis, application systems analysis, software validation & process re - engineering of Internet, Intranet and Client-Server applications.
  • Dynamic and Assertive team player with strong commitment.
  • Possess excellent verbal and written skills complimenting a strong Quality Assurance and Business analysis background with excellent interpersonal and problem-solving skills.
  • Over 8 years of effective analytical experience in IT and various business units/organizations.
  • Highly customer focused to understand and respond to clients business needs.
  • Effective analytical skills to accurately analyze information.
  • Effective in make sound business decisions by making strategic data-related decisions by analyzing, manipulating, tracking, internally managing and reporting data.
  • Work with developers, analysts and consultants during the root cause analysis, support and maintenance phases to ensure that acceptability criteria are being met and to manage scope and change requests
  • Thorough understanding of the SDLC model and its relevant phases.
  • Implemented and experienced in various QA methodologies.
  • Planning and Development of Test cases, Test plans, Test scenarios to meet the products business requirements.
  • Well versed in testing Client/Server, Web based Internet, Extranet and Intranet and Stand Alone Applications.
  • Formulated numerous Test Plans and Test Cases by coordinating with respective individuals.
  • Web Testing including Sanity Testing, Smoke Testing, Parallel Testing, GUI Testing, Functionality Testing, Performance Testing, Positive and Negative Testing, Security Testing, Stress Testing, Integration Testing, System Testing, Load Testing and Regression Testing of Web Based Applications and Client-Server Applications using Mercury Tools.
  • Executed and updated SQL scripts for Manual Back-End Testing.
  • Experienced in Test Environment Set up.
  • Strong skills in UNIX and writing SQL queries.
  • Involved in maintaining the test matrix and traceability matrix.
  • Bug reporting with Rational Clear Quest and Mercury Quality Center.
  • Excellent Communication and Documentation skills.

PROFESSIONAL EXPERIENCE

Confidential

Sr QA Analyst/Production Support Data Analyst

Responsibilities:

  • Improved Production Processes and increased distribution center efficiency
  • Relied upon to resolve and identify Business and Quality Assurance and other issues.
  • Worked on data mapping for bring data from source system and reside in target system
  • Resolved Production issues efficiently.
  • Analyzed data/workflows, defined the scope, and performed GAP analysis.
  • Provided update to management on testing status and some other related issues
  • Participated in Risk Management to help determine best use of development and testing resources.
  • Worked closely with the Developers and Business Teams in the review and modification of product specifications.
  • Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
  • Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
  • Participated in Risk Management to help determine best use of development and testing resources.
  • Extensively used SQL statements to query the database for data validation according to the data mapping document and defined data conversion logics.
  • Worked on preparing interfaces between local system and Client system.
  • Managed extracting, loading, testing, and publishing health-care production data files submitted by various insurance company clients to secure ftp sites on monthly basis. The large data files are thoroughly analyzed, transformed, tested, and submitted back to the associated client in the form of Output Files.
  • Created and modified SQL Server Integration Service (SSIS) packages to migrate submitted data files from its .csv format into the client’s SQL server 2012 databases.
  • Reconciled data tables once they are successfully loaded to the targeted SQL Server database by writing SQL scripts to make sure that control totals match between source files and staging tables.
  • Responsible for data Quality Assurance by analyzing, diagnosing and resolving system errors, job stoppages as well as maintaining a data quality program, analyzing current production processes and recommending improvements.
  • Processed SQL Quality Assurance scripts on each Commercial and Medicare health care data per service year then provided a report of QA findings.
  • Performed full documentation for each phase of monthly production cycle to each line of business along with QA and client publishing documentation for better transparency.

Environment: ICD9 And ICD10, Six Sigma, Share point, SQL Server, ETL, Stored Procedures, SISS,SSRS,SAS Scoring, Dashboards, Ultra Edit, Tableau, MS Visio, SQL Server management studio

Confidential

Sr Business Technical Analyst/Quality Assurance Analyst

Responsibilities:

  • Created Vision document, Supplementary Specs and Use cases and uploaded them on SharePoint site and in Req Pro.
  • Analyzed, elicited, and documented requirements according to the SDLC using Waterfall.
  • Gathered business requirements with various investment stakeholders across various business lines to understand and document the business needs for complex data modifications.
  • Prepared high level business requirement document and facilitated the customers in defining the high-level functional requirements and needs.
  • Interacted with customers to get better understanding of issues.
  • Conducted Joint Application Sessions (JAD) with the business users to gather requirements.
  • Efficiently managed multiple projects with competing deadlines .
  • Resolved Production issues efficiently
  • Analyzed and documented complex business processes- in multiple forms such as Business Requirements Documentation (BRD), Functional Requirements Documentation (FSD), Technical Documentation, Process Flowcharts using Visio.
  • Created test plan and test cases for backend testing from the business requirements to match the project's initiatives. Created and executed detailed test cases with step by step procedure and expected results.
  • Worked with Project Manager to quantify return on investment, including quality and efficiency gains, to assist in prioritization of projects
  • Worked closely with development team to ensure that all data needed is captured.
  • Worked with offshore team as required
  • Worked on electronic claims processing(ECP).
  • Conducted mentoring session with the new hire.
  • Completed Peer reviews for Vision, Supplementary specifications with Business Lead..
  • Supported Corporate and interim Releases for backend and frontend systems.
  • Actively participated in status report meetings and interacted with developers to discuss the technical issues.
  • Conducted walkthroughs and defect meetings periodically to assess the status of the testing process and discuss areas.
  • Created SQL scripts to run radar to find production claims for test data using Teradata SQL
  • Analyzed the Data Movement between systems and validated the data according to business requirements.
  • Extensively used SQL statements to query the database for data validation according to the data mapping document and defined data conversion logics using Teradata.
  • Followed Workgroup for Electronic Data Interchange standards for testing that need to comply with the HIPAA guidelines.
  • Conducted UAT by following HIPPA Guidelines.
  • Tested the HIPAA EDI transactions 834, 837/835, 276/277 according to the requirement scenarios.
  • Involved in implementation of HIPAA EDI Transactions ( 835/837/276)
  • Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Summary Report, Weekly Status Reports .
  • Used Rational Quality Manager to manage the entire process to upload Test Cases, Test Scripts.
  • Perform Back-end and front-end testing and by designing and constructing test cases, test data and test execution.
  • Verify defects and Perform database functional, integration and regression testing as needed to minimize defects.
  • Responsible for gathering requirements from the Subject Matter Expert. (SME).
  • Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
  • Worked on Health information exchange(HIX)project and tested all requirements using SOAP UI.
  • Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
  • Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
  • Worked closely with the Developers and Business Teams in the review and modification of product specifications.
  • Used Rational Clear Quest to log the defects.
  • Carried out and oversee test execution for Business scenario, User acceptance and Regression testing.
  • Assisted UAT team by validating specific functionalities during User Acceptance Test (UAT)

Environment: ICD9 And ICD10, Sharepoint, Teradata SQL, SOAP UI, HIPAA 4010 & 5010,Use Cases, HIX, Rational Clear Quest, Rational Quality Manger, Rational Req Pro, X12, EDI, ECP, OCR, ALG, ELIGIBILITY,OSCAR, Adjustment, Finalization, PRE and POST Enrollment, History Update

Confidential

QA Analyst

Responsibilities:

  • Created test plan and test cases for backend testing from the business requirements to match the project's initiatives. Created and executed detailed test cases with step by step procedure and expected result.
  • Created and Executed advanced SQL queries using relational database and Dimensional Model concepts on Oracle database using TOAD 8.5 and SQL developer to test the integrity of the data content, ETL processes and reports for Confidential BlueCross BlueShield Products.
  • Validation of member’s data from Facets to EDW.
  • Analyzed data/workflows, defined the scope, and performed GAP analysis.
  • Worked on Facets in flow and Out Flow of data.
  • Actively participated in status report meetings and interacted with developers to discuss the technical issues.
  • Conducted walkthroughs and defect meetings periodically to assess the status of the testing process and discuss areas.
  • Analyzed the Data Movement between systems and validated the data according to business requirements.
  • Followed Workgroup for Electronic Data Interchange standards for testing that need to comply with the HIPAA guidelines.
  • Conducted UAT by following HIPPA Guidelines.
  • Perform Back-end testing by designing and constructing test cases, test data and test execution.
  • Verify defects and Perform database functional, integration and regression testing as needed to minimize defects.
  • Responsible for gathering requirements from the Subject Matter Expert. (SME).
  • Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
  • Used HP Quality Center to manage the entire process and log in defects.
  • Provided update to management on testing status and some other issues
  • Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Assisted UAT team by validating specific functionalities during User Acceptance Test (UAT)

Environment: Windows Xp, MS office, Facet4.3.1, Facet4.5 Oracle, MS-Access, Mercury Quality Center, Verisk, TOAD, Oracle, UNIX, SQL Developer, SharePoint, Informatica

Confidential, Pleasanton, CA

Mainframe Tester

Responsibilities:

  • Worked with Business Analyst and QA Lead in reviewing and analyzing the business requirements Documents and functional requirements.
  • Prepared Test Scenarios based on business requirements and business rules for mainframe application.
  • Wrote Test Cases according to the scenarios.
  • Prepared Test claims according to the scenarios and Test cases
  • Scanned Paper Claims in Cardiff and sent to the IFILE.
  • Worked with IFILE team to convert 837 in CFF(Common File Format) using DI(Data Interchange)
  • Executed test cases in OCPS (Outside Control Processing System) according to our test scenarios and expected results.
  • Verified the claims from IFILE to OCPS(Outside Control Processing system) after adjudication.
  • Verified adjudicated claims in Diamond for KSPEC and PSPEC.
  • Manually adjudicated the Professional claims as well as Institutional claims in mainframe application.
  • Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
  • Good understanding of Health Insurance portability and accountability act (HIPPA).
  • Found errors reported defects, determined repair priorities, did regression testing and close by using Mercury Quality Center.
  • Authored Test cases for HIPAA EDI Transactions 270/271, 276/277,837/835.
  • Tested HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
  • Good Knowledge of understanding Diamond.
  • Sent claims to the Diamond for KSPEC and PSPEC.
  • Responsible for Performing Integration Testing.
  • Rewrote test cases according to the PSDD (Physical Solution Design Document) and executed them in mainframe.
  • Verified Claims in IFILE after adjudication.
  • Responsible for performing User Acceptance Testing.

Environment: Oracle, DB2, Windows Xp, TSO, JCL, CICS, IBM 390, Z/OS, XML,SPUFI, TSO/ISPF, Mercury Quality Center, OCPS, IFILE, OCR, DI, Diamond

Hire Now