SUMMARY:

• Certified scrum master having 9 years of experience with ETL Testing, Guidewire CC testing, Siebel and Salesforce applications.
• Currently working with Guidewire claim center application in claims with Client - ‘ Confidential ’ since last 3 years.
• Had earlier experience of 6 years in multiple ETL testing projects based on File to DB, DB to DB, DB to Mosaic Data systems and DB to outbound files testing using Datastage ETL tool.
• Worked on testing Siebel Loyalty application integration with different external/internal systems like CHUB, Sabre and Mosaic (outbound reporting).
• Has very good working experience in writing SQL queries, Tivoli scheduler testing and database testing.
• Worked on UNIX shell scripts testing.
• Involved in design and execution of test cases using HP Quality Canter and Rally.
• Performed sanity testing, Functional testing and regression testing using agile sprint methodology.
• Participated in test case review, scrum meetings and triage meetings.
• Interaction with the clients for requirements gathering, status reporting.
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC).
• Attended trainings on QTP and Selenium.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Performed portfolios of clients and assignments and key client relationship, develop and deliver services and value charters
• Experience leading test teams, escalating defect meetings, defect triage, setting targets, etc.
• Effective Time Management Skills and consistent ability to meet client deadline.
• Assisted the Project Manager Plan, Coordinate, and Monitor project levels of performance and activities to ensure project completion.
• Excellent project planning, design and management skills.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with excellent communication skills and ability to lead, manage and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Test Tracking Tools: HPALM, Rally

Databases: Oracle 10g,11g,12c

Major Role: ETL Tester (Datastage), Guidewire Claim Center Tester

Applications: Guidewire Claim center, Salesforce and Siebel Applications. Expertise knowledge on Guidewire claim center application.Good experience on IBM Datastage (ETL tool) and Tivoli workload scheduler.

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Currently working with Guidewire claim center application in Confidential .
• Also worked on Policy center application and worked on state rollouts from Legacy to guidewire applications.
• Worked on the Data migration testing using Informatica from Legacy application to Guidewire applications.
• Taken care of data load testing in Guidewire application.
• Successfully implemented multiple claims state rollouts from legacy to Guidewire claim center application with minimum defect leakage.
• Worked on the Legacy workers compensation application integration with Guidewire claim center application.
• Extensively worked on multiple integrations between Guidewire and Salesforce/Pega applications.
• Handled successfully integration testing of multiple vendor applications with Guidewire claim center.
• Setup meeting with Business team and all stakeholders to understand the business need and convert to technical integration.
• Prepared the QA execution cycle at sprint level as well as for regression and E2E phases
• Worked extensively on SOAPUI for testing XML on policy coverages testing.
• Worked with Splunk during SOAPUI testing.
• Worked on SQL during data migration testing.
• Reviewed test cases prepared by the team
• Defect review with all stakeholders.
• Conducted Daily status meeting with the client business team
• Prepared an UAT test strategy for conducting User Acceptance testing
• Setup all the SIT, UAT and production users with appropriate Profile and permission sets
• Managed testing for all the users from profile perspective
• Conduct JAR, JAD meetings with stake holders

Confidential

ETL Tester responsibilities:

• As a Batch ETL tester, worked on various batch ETL jobs, which interact with modules like accrual/redemption management, airline error queues testing, partner memberships testing, tier management testing, and revenue model testing. Also worked extensively on external partner setup testing and on-target implementations.
• Also played a prominent role in identifying the root causes of Batch interfaces failure in Production, Stage and lower environments by doing the code level analysis.
• Worked on end-to-end testing activities before go live like stabilization testing, Batch volume testing and performance testing of Batch ETL streams
• Ensuring the data integrity between multiple inbound interfaces and the destination Siebel application.
• As an outbound feed tester, involved in testing with zero defect leakage for daily delta updated transactions, member enrollments, and their respective accruals and redemptions.
• Was involved in, Capturing all the project activities like reviews, coding, and validation; Collect test metrics and Project closure reports; Conduct Retrospective meeting, capturing inputs and suggestions from business. Also involved in test management Activities like preparation of Weekly status reports, Test Plan and Test Estimates.
• Preparing queries on the requirements and maintaining clarification tracker.
• Involved in discussing the requirements within the Team.
• Preparation of Test strategy and System Test Plan.
• Also worked as part of development team for designing the lookups, transformers and all designer stages as per the functionality requirement.
• As part of development team, worked on preparation of pre and post sql queries during etl job design.
• Prepared and deployed IFB jobs scripts to migrate the data from EIM interface tables to Siebel base tables.

Confidential

Database/Migration Testing. responsibilities:

• Participate in Iteration Planning meeting and Understanding the user story requirements in Rally.
• Worked with customers in gathering business requirements for data migration needs
• Carried out stage tables validations to check column-to-column data comparison using data migration mapping document.
• Validated the sample data sets by preparing the sql queries to validate the data before (source database) and after (destination database) migration.
• Post data migration validated the functionality of the application.
• Monitoring and Tracking Tasks of Team activities and guiding them.
• Coordinating with Onsite and Offshore for project deliverables and issues.
• Coordinating with team to estimate the test cases for each requirement.
• Design and Execution of test cases.
• Involving in doing Review of the test cases.
• Update and execute the regression pack as per the latest release requirements.
• Defects Reporting, tracking, reviewing and analyzing the defects using quality center and Rally.
• Training and Mentoring new team members.
• Supervise the execution process and generate daily and weekly test reports.

Biogen Idec

Siebel Functional Tester

Responsibilities:

• Simple Forms provides an intuitive HTML interface for collecting data into Oracle Clinical directly from patients over the internet.
• Maintained, Reviewed and Updated documentation for Simple Forms up to version 2.3.8
• Wrote functional requirements, traceability matrix, test case objectives and test cases for each version of Simple Forms
• Performed Ad hoc testing on different functionalities of Simple Forms
• Created screen mock ups for different functionalities as per requirements
• Designed and developed validation protocols to ensure system performs as intended and according to design
• Updated Oracle Clinical Study databases with new objects as per testing requirements
• Forms submitted using Simple Forms into Oracle Clinical were verified in Oracle Clinical
• Created Test Case setup data for Simple Forms QA/Validation run
• Lead Validation effort for Simple Forms
• Created Test Results Reports and Summaries for Validation run
• Created user guide for Simple Forms
• Interacted with stakeholders on a periodic basis during various stages of development and testing
• Wrote functional requirements, traceability matrix, test case objectives and test cases for browser compatibility of Simple Forms
• Cross browser testing of Simple Forms across IE, Firefox in windows and Opera on Mac
• Continues QA testing and validation work during different releases

Confidential

Database tester

Responsibilities:

• Analyzing the functional requirements.
• Preparing queries on the requirements and maintaining clarification tracker.
• Involved in discussing the requirements within the Team.
• Preparation of System Test Plan.
• Responsible for work allocation & reporting.
• Design and Execution of test cases
• Prepared sql queries as per the functional requirements.
• Involving in doing Review of the test cases.
• Monitoring and Tracking Tasks of Team activities and guiding them.
• Responsible for sending daily and weekly test reports.