We provide IT Staff Augmentation Services!

Epic Clarity/ Reporting Workbench Report Analyst And Tester Resume

3.00/5 (Submit Your Rating)

New Haven Ct New Haven, CT

PROFESSIONAL SUMMARY :

  • Six Plus Years of diverse experience in the field of Information technology with emphasis on Software Quality Assurance using manual and automated Testing with strong domain knowledge of retail, clinical, healthcare and hospital domains
  • Expertise in developing Software Test Plans, Test Case Design, Test Scripts based on Business Requirement Documents (BRD) and System Requirements documents
  • Experience in Software Smoke Testing, Sanity Testing, Regression Testing, Ad - hoc Testing, Integration Testing, User Acceptance Testing, cross browser testing across various releases and builds.
  • Performance, configuration and usability testing across various releases and builds using Test Director, QTP, Quality Center with financial, eCommerce, medical, pharmacy and retails domains.
  • Ability to apply technical expertise to organize and implement black-box test efforts and to analyze requirements for software design, development, and validation
  • Well Versed in GUI application testing, Back End testing, Database testing, Front-end testing, Functional Testing, System testing, Cross Browser Testing, on Client-server, stand alone, and web- based applications with multiple server domains.
  • Represent QA in all phases of product development including requirement, design, construction, testing, implementation, code reviews and support.
  • Strong experience working with various SDLC models like water fall, spiral, V-model, incremental and Agile and Scrum Techniques in conjunction with Testing life cycle to fit to adopted SDLS for the project.
  • Active role in requirements review, functional document review, Testing review and key resource for UAT phase and production roll-out
  • Expertise in QA Methodologies, Quality Assurance Life Cycle (QALC), Defect Management Life Cycle, Software Development Life Cycle (SDLC) methodologies
  • Ability to learn new technologies and challenging concepts quickly and implement them
  • Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment
  • Expertise in preparing Test Summary Reports, logging issues and Defect analysis reports.
  • Strong communication and interpersonal skills. Strong Team player and contribute towards the team goals.
  • Liaise with developers, business analysts, and user representatives in application design and document reviews
  • Ability to work productively and effectively in a team as well as individually

TECHNICAL SKILLS:

Testing Tools: Quality Center 9.x/10.x, Test Director 8.0, MANTIS, Rational ClearQuest, Rally

Reporting Tools: SAP Crystal Reports, Infoview Server

Clarity Modules: Inpatient, Optime, Ambulatory, Hospital Billing, Professional Billing and ADT

Report distribution Methodologies: Epic Crystal Integration, Business Objects Server

Report development tools: Chronicles Dictionary, Clarity Data Dictionary, Clarity Compass, Record Viewer

Languages: XML, HTML & DHTML, SQL, C

Databases: Oracle 8i/9i/10g, MS SQL-Server 2000, Access 97/2000, DreamWeaver

Internet Tools: FrontPage 2000, Visual Interdev

Operating Systems: Windows NT/2000/ME/XP, Unix

PROFESSIONAL EXPERIENCE:

Confidential, New Haven, CT

Epic Clarity/ Reporting Workbench Report Analyst and Tester

Responsibilities:

  • Built and tested numerous SCM( Sunrise Clinical Management) reports converted from the legacy database to EPIC clarity reports using SAP Crystal Report 2008.
  • Directly involved in the Key Performance Indicators( KPI) Dashboard project by automating the extraction of data from the clarity database and insertion of data into the reporting tables which were then used by the Business Objects experts in their universe to present a trending Dashboard to the Executives and Decision Support.
  • Wrote SQL Stored procedures for numerous different KPI Metrics from different modules like Average Length of Stay(Epic Care Inpatient), Patients that left the ED without being seen(ASAP), First Case Late Starts (OpTime),Study Turnaround Time (Cardiant), Barcoding Compliance (Willow Inpatient), Average Daily Revenue (Hospital Billing) etc.
  • Developed Test scripts to test various Customized reports for the Infection Control Department like Central Line Days, Foley Catheter Days, Ventilator Days, Patients under Isolation Orders, etc.
  • Actively involved in helping the Integrated Audit Team with their reporting needs for the integrated audits. Built numerous audit reports like Restraints order with Restraint Flow sheet data, Oxygen Orders with Oxygen Flow sheet data, Weight Orders with Weight flow sheet data, Pain Assessment, Skin Assessment with Braden Score, etc.
  • Extensively involved in writing sql queries over Clarity, Epic’s Relational Database, during the report development process. Well versed in using subqueries, Common Table Expression, functions, Stored procedures etc
  • Participated during Go Live at the command center for support for the Reporting Team troubleshooting the reports and addressing ad hoc report request.
  • Worked on Upgrading the existing reports to Denali ( EPIC 2012) and tested those reports for accuracy.
  • Actively involved in fulfilling the reporting needs from various end users arising due to transition from a legacy EHR system to EPIC .
  • Creation of various test scenarios for business rules execution.
  • Performing Backend Testing by developing and executing SQL queries for data validation.
  • Application verification using table checkpoint, standard checkpoint and text checkpoint.
  • Adding verification checkpoints for the validation of the functionality under stress conditions.
  • Prepare and present test status reports used for weekly project meetings and coordination with cross functional team.
  • Coordinating with development and business teams to help UAT process run smoothly.

Environment: Epic Crystal Integration, Business Objects Server, Chronicles Dictionary, Clarity Dictionary, Clarity Compass, Record Viewer, Inpatient, Optime, Ambulatory, Hospital Billing, Professional Billing and ADT

Confidential

Software Quality Assurance Engineer

Responsibilities:

  • Developed the Verification and Validation Test Protocols for each module analyzing the functional specification which in turn linked back to the software requirements and market requirements thus facilitating the traceability matrix.
  • Created Use Case from User stories, developed Test Protocols and linking them to various system requirements to test the higher lever requirements of the system. Executed the use case test protocols and prepared reports.
  • Participated in resolving issues arose from audits for the software team and communicated to ensure that the resolution meets the standards.
  • Releasing the written documents and new software through a change control process for revision control.
  • Executed the test protocols for the module level firmware through the Service User Interface and created test reports. Wherever manual test were not feasible automated tests were introduced.
  • Performed Ad-hoc testing on new issues for any software functionality requests and communicating with the developers to provide the feedback.
  • Logged and communicated all the anomalies identified during the execution of test protocols for quick resolution.
  • Worked in an Agile Software Development environment (two week Iterations). Participated in daily stand-ups communicating the daily progress and any impediments.
  • Participated in the Iteration planning meetings to prioritize the backlog and pulling up stories for the coming iteration and worked towards completing the target story for the iteration.
  • Participated in the Iteration Retrospective with a goal to better the next iteration than the past one by identifying points that could have been done better in the last iteration and setting a retrospective goal to better that in the next iteration.
  • Performed Software Quality Assurance tasks towards building a device according to the FDA Guidelines and regulations

Environment: Windows 2007

JANATA MARKET, Westborough, MA

QA Analyst

Responsibilities:

  • Review and analysis of Business Requirements, Technical Specifications and development of Test Plans and Test Cases depending upon the test scope and coverage.
  • Verification of XML data feeds stored in raw data format in temporary tables after receiving them with product information.
  • Verification of Web services end point communication between Web interface and Payment gateway system.
  • Creation of various test scenarios for business process flow and business rules execution.
  • Performing Smoke Testing, GUI Testing, Regression Testing, System Testing, Functional Testing, and Cross Browser Testing.
  • Performing Backend Testing by developing and executing SQL queries for data validation.
  • Creation and Maintenance of test data prior to test execution.
  • Execution of special test cases to test 3rd party payment gateway interface with pay pal and google check out and currency conversion methodologies.
  • Enhancing and executing test scripts for regression and Data Driven Testing using QTP.
  • Performing standard recording and low-level recording on application under test for depicting actions.
  • Creation and maintenance of test library of generic User-defined functions.
  • Creating data table and parameterizing the tests using the data driver wizard.
  • Application verification using table checkpoint, standard checkpoint and text checkpoint.
  • Adding verification checkpoints for the validation of the functionality under stress conditions.
  • Running multiple iterations of the script for unique set of data using parameterized action.
  • Identifying, logging and tracking defects using Test Director.
  • Testing and tracking defects by following defects lifecycle.
  • Prepare and present test status reports used for weekly project meetings and coordination with cross functional team.
  • Coordinating with development and business teams to help UAT process run smoothly.
  • Participating in discussions with development team to resolve bugs

Environment:Windows XP, UNIX, J2EE, Oracle10g, MYSQL, PHP, JavaScript, HP Quick Test Professional (QTP) 9.1, Quality Center, MS Excel, SOAP, Web Services, Payment GateWay API

Confidential, Manhattan, New York

QA Tester

Responsibilities:

  • Analyzed the requirement and functional specification documents to understand the business requirements.
  • Developed Test Case design documents andTest cases based on the business requirements document, functional specifications and technical specifications document.
  • Contributed to test strategy document.
  • Tested the application using different types of testing including smoke test, UI testing, Black box testing, System testing, SAT ( System Acceptance Testing), CIT ( Component Integration Testing), regression testing.
  • Part of the team member to help users in UAT testing.
  • Executed the test cases as per the test plan on incremental model.
  • Found and logged several critical defects and demonstrated the development team to reproduce the issue.
  • Attended the daily defect status meeting and followed complete defect life cycle process before closing the defects.
  • Prepared test data for the AUTas per the specifications of BRD.
  • Formulated methods to perform Positive and Negative Testing.
  • Executed the test case on various types of platforms like Windows NT, 95, XP etc.
  • Used the SQL queriesto fetch data for data validation and back-end testing and used internally developed web interface to fetch data from DB2 tables for data validation.
  • Involved in Functionality Testing on various work flow process and tested the web services on different communication end points.
  • Generated the Defect Metrics on weekly basis and review them with QA lead.

Environment:J2EE, Web Services (SOAP,WSDL), Quality Center tool, Bugzilla, Oracle 10g, Toad, MS Office 2003, Windows XP, Vista, Linux/Unix

Confidential, Madison, WI

QA Tester

Responsibilities:

  • Analyzed Business Requirements documents for iMAS and Nimble Design application.
  • Created mappings, VB scripts to export the data from Bugzilla to Quality Center.
  • Performed requirements review and manual test verification
  • Extensive of manual and automation testing for Java/J2EE Windows and Web based applications
  • Creating Test Run reports, Test Plans, Test Cases and Test Scenarios based on customer and product software requirements, Use cases and Functional Specifications in the Quality Center and Excel.
  • Conducted smoke test as soon as the version is released to ensure that the version is ready to test.
  • Performed System, Functional, Integration, Regression, Compatibility, GUI, UAT, End-to-End and Sanity testing for each Iteration
  • Used the SQL queries to perform the testing against the Oracle database.
  • Wrote defects using Quality Center tool and followed-up with developers, re-tested defects and ultimately closed said defects
  • Attended CCB (Change Control Board) meetings, participated in bug review meetings with the software development team throughout the testing phase
  • Worked with whole project team during go-live and production testing, problem resolution
  • Performed Multi-Browser testing with Fire Fox (3.5 and 3.0), IE7& IE8 and Safari for Windows and Mac
  • Performed Multi-OS testing with Windows XP/Vista/7, Linux 2.6 and Mac 10.6.
  • Created traceability of test cases to requirements, test metrics and participated in status meetings and reported the progress to the manager.
  • Tested the Web Services with consumer testing by writing special test cases for web services.
  • Extensive use of LINUX/UNIX commands to perform data comparisons.

Environment: Java/J2EE, JDBC, Servlets, JSP’s, Java Beans, Spring, JMS, Web Services (SOAP,WSDL), J2EE Design patterns, Tomcat Quality Center tool, Bugzilla, Oracle 10g, Virtual Machines, Toad, MS Office 2003, Windows XP, Vista and Windows 7, Linux/Unix and Mac 10.5 and 10.6 Operating systems

Confidential, Pearl River, NY

QA Tester

Responsibilities:

  • Understood Business Matrix and Functional specification as to how the warehouse, dealer and retail are interconnected.
  • Developed functional test cases for the GUI to see that the item ID, sending date, receiving date, requisition quantity matches with the database.
  • Performed Internal and external Peer Review.
  • Prepared Traceability matrix on the requirements and test cases to check quantity of items ordered, Items returned, Item code, defect description
  • Executed Test cases in Quality Center and logged Defects.
  • Performed cursory check as part of Entrance Criteria, on every build.
  • Performed Black Box testing on the Item Receipt Note, Material Return Note, and Retail Order Note.
  • Verified SQL/PL SQL stored procedure and performed White Box testing on the database.
  • Used extensive SQL commands to Query the database-using Benthic.
  • Researched on the bugs before discussing with the developers or team members.
  • Based on the Status of the bugs, if fixed, performed Regression testing and closed the bugs

Environment: VB, IIS, SQL Server 2000, Bugzilla, Toad, MS Office 2003, Windows XP.

Confidential, Dayton, OH

QA Tester

Responsibilities:

  • Developed Test plans like Master & detail test plan using the company standards, implemented the SDLC for the testing life cycle and followed the Standard processes in the application.
  • Conducted Functional, Integration, Regression and System testing.
  • Monitored requirements tracking process, Use Cases with Test director.
  • Developed detailed sub-system test plan including test procedures and test cases.
  • Listed the recommended testing strategies to be employed to test the critical areas of the module.
  • Analyzed the web site for broken and inaccessible links.
  • Also assisted performance test team in stress and performance testing of the web site.
  • Identified and helped in resolving application bugs and bottlenecks found during the tests.
  • Involved in writing SQL’s to populate and verify test data.
  • Executed Negative tests to ensure application meets the requirements.
  • Created Test Cases, Test Plans in Test Director and added related Test Scripts
  • Developed documentation of Testing Processes.
  • Preventing defects prior to heavy development.
  • Worked and participated in agile methodology with constant interactions with the team members.
  • Identified issues and entered as defects in LBT.
  • Efficiently coordinated with the offshore team for design as well as the testing.

Environment:.NET, ASP, IIS, Web Services (SOAP,WSDL), LBT(Lexis Bug tracking Tool), Oracle 9i, Toad, MS Office 2003,MSExcel, Windows XP/NT,

We'd love your feedback!