PROFESSIONAL SUMMARY:

• 5+ years of IT experience in Software Testing in Financial and Healthcare Domain.
• Certificate from Project team for better performance for Source and BI Reporting Projects.
• Experience with gathering information in situations from Business People and working with Developers to make them understand and testing based on the requirements.
• Well - versed with Software Development Life Cycle; extensive experience in writing test plans, test scenarios, test cases and test strategy fueling corrective actions and significant cost savings.
• Interested in learning Financial Concepts.
• Extensively worked on different types of testing such as functional testing, load testing, black box testing, white box testing, UAT, regression testing including BI report Testing, Negative Testing
• Huge QA experience working in environment with different types of Software Development Life Cycle and Software Testing Methodology (including Waterfall, Agile, Scrum)
• Experience with Selenium on JAVA platform for automation testing.
• Proficiency in analyzing data using SQL and My SQL; databases Oracle and SQL server .
• A good individual as well as a team player to work in conjunction with other DBA’s, testers, developers and other team members to create complex test scenarios and fixes.
• Expertise includes working closely with data governance team and Quality Control to maintain enterprise standards in Projects especially with various Test suites.
• Experience in Testing Tableau Dashboards
• Understanding of Oracle HCM. Trained to use Oracle HCM for HR functions and Data.
• Strong communication, issue identification, organizational, interpersonal, and presentation skills.
• Design and review of various documents including Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and testing documents.
• Coordinating with the developers in troubleshooting and fixing of the defect by providing them the defects accordingly.
• Having a good understanding of the Star Schema, Snow Flake Schema, OLAP and OLTP Data Models and how the data populates.
• Extensively used DMLs, DDLs, DCLs, and DRLs (Joins- Left join, Right join, nested selects, unions, etc.)
• Created and tested numerous functions, procedures, triggers, sequences, indexes, views and PL/SQL blocks as a part of Data warehousing testing.
• Extensively tested type 1, type 2, type 3 dimensions and facts and ODS populated by different source systems.
• Involved in project and development status meetings to understand the business requirements and the implementation of the business rules to have a smooth and successful testing phase.
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/analysis, design, and testing and production rollover.
• Desire to work in dynamic and challenging environments towards achieving company’s goals.

TECHNICAL EXPERTISE:

QA Tools: Bugzilla, Quality Center, JIRA, Selenium WebDriver

Databases: Oracle 10g, 11g, 8i/9i; SQL Server 8.0, Netezza

Other Tools: MS Access, MS Office Suite

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Safari, Firefox,, Internet Explorer, Google Chrome

Domain: Finance and Health care

PROFESSIONAL EXPERIENCE:

QA Tester

Confidential, Lexington, MA

Responsibilities:

• Worked on many Confidential projects including reports on Confidential Projects.
• Tried to Focus on Project Deliverables on time to the client.
• Worked with BA to gather information from the business related to the projects.
• Worked on Data source transfer projects which includes Data validation, tracking on reports with the source tables and application
• Validated the incremental load in the backend with the frontend application
• Logged bugs using Quality Center and worked with Developers in fixing those defects.
• Attended daily meetings with Project Managers, BSA, QA lead, Developers, Dev Lead and Managers.

Environment: SOA interface, eGate Interface, HL7 Messages, Oracle, HP Quality Center, JIRA, eCube Clinicals, eCube Financials, Chairside, Tableau, Outlook Office 365, Excel, Word, SQL Server.

QA Tester

Confidential, Lexington, MA

Responsibilities:

• Accommodating the usage of Oracle Exadata and Logi for Data Validation with Agile methodology
• Verified all components of Dashboards in detail using the business Logic.
• Used JIRA to maintain stories and logging defects.
• Attended scrum meetings to discuss the defects and project sprints components.
• Worked hard with Developers to fix those issues before new sprint gets ready for QA to test.
• Successfully delivered the project on time to business with no bugs after going live.
• Worked on Oracle HCM related to ESS where employees are able to access HCM system to update their information.

Environment: SQL Server, Oracle, JIRA, Confidential Reports, eCF Reports, Logi Dashboards, Outlook Office 365, Excel, Word, Tableau, HCM

QA tester

Confidential, Lexington, MA

Responsibilities:

• Written the test cases with the help of complicated mapping document
• Involved in generating Test cases for existing system to new system for different Levels of Business.
• Created complex Exadata queries for the test cases using views, stored Procedures, Indexes and user defined functions.
• Test execution for verifying data
• Finding the root cause of the issues for the solutions
• Responsible for reporting and tracking the bugs using Quality Center and for performing regression testing.
• Performed incremental load testing by adding new records and updating existing records in the source and verifying in the archive and target tables
• Performed testing in Production environment as well for Post prod checks before going live
• Attend scrum meetings, defect review meetings and work load status meetings.

Project: CPA, PPA, MIT, SWA, Treatment Attributes, Admissions, HD Admin and orders, Ancillary Admin and Orders

Environment: Oracle, Netezza Aginity, HP Quality Center, eCube Clinicals, eCube Financials, Chairside

QA tester

Confidential, Lexington, MA

Responsibilities:

• Written the test cases with the help of BRD document
• Executed testing using Netezza Aginity and Excel and compared long list of data using ExamDiff tool and exported the test cases to HP Quality Center.
• Performed incremental load testing and worked in QA and development environment to test incremental load data using eCube Clinicals tool.
• Performed Data validation using views created and the source tables in Backend, User Interface and functional testing for the Dashboard testing.
• Worked with other team members on Performance testing
• Exported and executed HP Quality Center and then logged and reported defects to the developers using HP Quality Center.
• Worked with the development team in fixing the dashboard defects to meet the business requirements.
• Very Well versed with Entry/Exit Criteria.
• Attended Scrum review meetings, defect review meetings and Dashboard status meetings.
• Hosted Test cases review meetings to present test cases in front of the whole project team.
• Worked with Project Managers, Director and all the lead of the projects to complete the project on time and presented testing results to the business.

Tech. Environment: Informatica, Netezza, Tableau, eCube Clinicals, HP Quality Center, Outlook Office 365, Excel, Word, ExamDiff.

QA tester

Confidential, Lexington, MA

Responsibilities:

• Written the UI and functional test cases with the help of BRD document
• Executed testing using Netezza Aginity in Excel and exported the test cases to HP Quality Center.
• Logged defects in the HP Quality Center and worked with Developers to fix them and retested them and closed the defects.
• Develop Test plans and Use cases.
• Performed incremental load testing and worked in QA and development environment to test incremental load data by entering new patients in eCube Financials and treated patients in Chairside. Verified in backend as well as in dashboards.
• Wrote data validation test cases for tableau dashboards with the help of the calculation document.
• Performed Data validation and User Interface testing for the Dashboard testing.
• Worked with other team members on Performance testing
• Executed test cases for tableau dashboards using Excel and HP Quality Center and logged defects using HP Quality Center.
• Worked with the development team in fixing the dashboard defects to meet the business requirements.
• Responsible for communication and co-ordination with the business people, Business Analyst and the Project Managers for the successful completion of the project.
• Attended Scrum review meetings, defect review meetings and Dashboard status meetings.
• Attended several walk through meeting with the Business Analysts, project managers and developers and provided feedback accordingly.
• Hosted review meetings to present test cases and testing results in front of the whole project team and the Business people.

Tech. Environment: Informatica, Netezza, Tableau, eCube Financials, HP Quality Center, Outlook Office 365, Excel, Word.

QA tester

Confidential, Lexington, MA

Responsibilities:

• Written the backend test cases with the help of mapping document and also found defects in mapping doc and asked developers to fix the same.
• Created test cases for tableau dashboards with the help of the calculation document and the requirement document for functional, data validation and User Interface.
• Executed testing using Oracle and exported the test cases to HP Quality Center.
• Logged found defects in the HP Quality Center, retested them and Perform Regression Testing for fixed defects.
• Performed incremental load testing and worked in QA and development environment to test incremental load data.
• Performed Data validation and User Interface testing for the Dashboard testing.
• Worked with other team members on Performance testing
• Executed test cases for tableau dashboards using Excel and HP Quality Center and logged defects using HP Quality Center.
• Actively participate in regular QA team meetings to discuss SQA testing process and suggest improvements to the application design and features for faster and easy testing.
• Attended Scrum review meetings, defect review meetings and Dashboard status meetings.
• Worked with Project Managers, Director and all the lead of the projects to complete the project on time.
• Walkthrough with Business and the whole team to present the test cases and the testing results

Tech. Environment: Informatica, Netezza, Tableau, HP Quality Center, Outlook Office 365, Excel, Word

QA tester

Confidential, Lexington, MA

Responsibilities:

• Created test cases for the backend using mapping document (source to target and target to views)
• Prepared Test plans and reviewed requirement documents and suggested for any improvements.
• Developed testcases for dashboards using BRD and the mapping document.
• Reported defects and worked on it through Quality Center and performed regression testing at each stage of defects fixed.
• Testing application in Selenium tool using IDE and WebDriver. Executed Test cases in Selenium using JAVA
• Presented testing results to the whole team and provided sign off on testing after the team’s approval.
• Participate in the identification and implementation of continuous improvement in process and standards for the entire team.

Tech. Environment: Informatica, Netezza, Oracle, Tableau, HP Quality Center, Outlook Office 365, Excel, Word, Selenium, JAVA