SUMMARY

• Motivated professional possessing strong communication, critical thinking, and analytical skills. Excellent team and relationship building within the enterprise and with third - party business partners with strong project management and team leadership.
• 8 years' experience in the IT industry as a Functional Database tester in Healthcare, Insurance and Banking Domain.
• ETL Tester having solid experience with data models identification target mapping and testing schemas. Possesses extensive knowledge of transformation rules verification processes and data sample comparisons. Is highly analytical and detail-oriented and has an associate degree in Information Technology along with six years of ETL Tester experience.
• Expertise in USA Health Care Domain.
• Thorough knowledge of the Agile and Waterfall SLDC models and methodologies
• Excellent skills of problem solving and Bug Tracking using HP Quality Center/ALM, JIRA
• Testing ETL (Extract, Transform and Load) applications for supporting data warehouse, data integration and business reporting systems.
• Adapting ETL Testing processes to accommodate changes in source systems and new business requirements.
• Performed ETL (Extract, Transform and Load) testing for various modules on FACETS.
• Testing the functionality of Informatica workflow and its transformations used in the underlying mappings.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs
• To check the data completeness (I.e. ensuring if the projected data is getting loaded to the target without any truncation and data loss),
• Perform technical reviews, data validations & end 2 end testing for ETL objects
• Experience in designing, developing, and normalizing database and conducting Backend testing by executing SQL queries
• Ability to operate in self-sufficient manner and identify the right time to raise queries or concerns.
• Proficient in creating manual test cases from requirements, design, specifications, and process flow diagrams
• Experience in the different modules of the ALM/HP Quality Center (QC) such as the Requirements, Test Plan, and Test Lab, Defects modules
• PerformedPositive Testing, Negative Testing, Integrated Testing, System Testing, and Regression Testing
• Experience on testing various modules of FACETS like Subscriber/Member, Groups, Enrollment,Claims, Provider and Utilization Management
• Strong knowledge of EDI Claims, member enrollment, and billing transactions
• Experience with HIPAA EDI transaction codes such as 270/271(inquire/response health care benefits), 276/277 (Claim status), 834 (Benefit enrollment), 835 (Payment/remittance advice) and 837 (Health care claim)
• Strong in Problem Analysis and Resolution skills, effective time management skills and ability to meet deadlines.
• Excellent communication skills to interact with business users, business analysts, developers and the QA team
• 6 Years of extensive work experience in Functional testing, Integration testing, Database, EDI testing, and EDI Formats of 270,276,835,820,834 using Edifecs tool.
• Ensured proper traceability between test cases and requirement documentation and tracked test execution to ensure timely delivery of test deliverables. Involved in defect triage, scrum meeting, sprint planning & prepare bug report document.
• Expertise in business requirement analysis, providing estimations, creating test plan, preparing RTMs, preparing scenarios, designing test cases, peer review of the test cases, test data preparation, test execution in ALM, defect tracking in JIRA, and test summary report preparation.
• Involved in various stages of SDLC of unit testing, smoke testing Functional, Regression, SIT, end to end testing and UAT before the product is deployed to production.

TECHNICAL SKILLS

• Defect triage
• ALM
• MS SQL Server studio
• RTM
• EDI Testing (Healthcare transactions)
• Functional Database Testing
• Regression
• Mainframe
• Healthcare domain
• Informatica power point and monitor
• Facets
• Oracle(SQL)
• Jira
• Scrum meeting
• Retesting
• Tidal Scheduler
• DX console
• Database testing
• Estimations, Delivery and Reporting
• Requirement Gathering and analysis
• EDI, Soap UI
• MS SQL Server
• Informatica
• Middleware
• Agile
• Manual test case preparation
• Team management
• Sprint planning

PROFESSIONAL EXPERIENCE

Confidential

Sr Quality Analyst

Responsibilities:

• Assigned tasks, reviewed performance and devised improvement plans or corrections.
• Maintained constructive team environment through effective mediation of disputes between associates and application of motivational techniques.
• Produced documentation, status reports and presentations.
• Reported test findings to development personnel, advising staff on efficacy of subsequent remediation attempts.
• Attended meetings with quality assurance, developers, and project managers to assess scope and sequence of project.
• Applied Agile Delivery methods to simplify testing process decisions through iterative development.
• Ensured test plans and test cases are defined, documented, executed, and tracked to ensure updated versions and enhancements of existing applications satisfy business requirements
• As QA lead took responsibility for the Requirements Analysis, Designing and Testing of the flow and the logic for the project.
• Ensured proper traceability between test cases and requirement documentation
• Tracked test execution to planned test schedule to ensure timely delivery of testing deliverables
• Ensured software reports are documented, maintained, and monitored.
• Ensured the design and execution of both automated and manual test scripts
• Interacted with both business and systems personnel to ensure functional and operational needs of the business are met.
• Interacted with offshore personnel to ensure daily test activities and deliverables are met.
• Ensured close adherence to the systems development lifecycle processes and associated documentation
• Continuously monitored QA test environments to confirm environment is in proper order to support testing activities.
• Lead all daily Triage calls for technology projects within the Compliance & Client Reporting unit
• Executed SQL queries for manual backend testing and data mining.
• Verified data transformation loads from upstream sources against business rules.
• Prepare Status report and send to the manager on Daily and Weekly Basis.

Confidential

Test Analyst

Responsibilities:

• Creation of the test plan to include the scope, timelines, test environment, etc.
• Analyzed Business Requirements & specifications to understand the application
• Created several Test Cases and Test Conditions for testing various Claims, Membership, Billing and Provider reports.
• Worked on requesting new ID cards using XML files.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing
• Manually created the data in Facets Front end for the execution.
• Extracting the data from the Facets Backend using Oracle(SQL)
• Discussions and stand up calls with the business group to understand the requirements.
• Preparation of test cases and their execution.
• Conducted Validations for different FACETS modules Providers, Claims and Membership
• Involved in the defect triage calls with respective stakeholders.
• Preparing test results and test closure activities.
• Sending WSR and daily status mails to stakeholders.
• Tracking of execution and defect statuses and reporting the same to the stakeholders.
• Involved in vendor testing as part of integration activities where extracts were sent to the vendors which was highly critical.