Sowmya B Email & Phone Number

Texas, United States

Dallas Texas

Hyderabad Area, India

PZAZ Rehost Legacy system developed in Powerhouse is migrated to windows de-commissioning existing "Profit" applications. Oracle Database is upgraded from 10 to 12. As part of this project, around 90 jobs written in Powerhouse code is migrated using .NET and PL/SQLProject namePZAZ - Markel Corporation1. Handled OAR (Operational Accounting & Reporting),Claims, Disbursement, Underwriting, Finance (Billing & Collections) departments. OAR generally covers the data feed to Ledger and the generation of the data being fed to the State Farm as part of the Calendar Month Financial close.2. Participated in testing 90 jobs which includes Monthly, Daily and Adhoc jobs. Monthly and Daily jobs were scheduled in the database which triggers at specific times. Adhoc jobs were triggered through Centura UI3. Validated reports generated in current system with the reports generated from the power house code system. Jobs were complicated, and no documents were available from the client. Referred KT records given my SME.4. Given walk through to Business users as part of UAT testing.5. Activities include Test Scope/Strategy development, driving the test plan creation/execution, conducting reviews on the test documentation and overall testing process. 6. Logged the bugs in Jira and and classified the bugs based on the bug severity and Priority

Hyderabad Area, India

Project: Bank Of AmericaRoles & Responsibilities: • Created test plan and test summary documents according to SDLC standards• Tracked and managed defects in QC along with analyzing data and provided reports• Conducted end-to-end integration testing and assured software delivered met requirements and expectations• Documented detailed test cases while working in an Agile software development cycle.• Collaborated with BA and developer frequently for requirements clarification.• Actively participated in scrum calls and project meetings and discussions.

Chennai Area, India

Project: Bank Of AmericaRoles & Responsibilities: • Extensive experience of Database testing using SQL Server/DB2 UDB /IBM iSeries AS400/ Oracle.Worked extensively on Stand Alone/Web, server applications on Windows, Web and Reporting applications using HP/Mercury Interactive/Rally Tools in Mortgage and Banking domains with Automation and End to end testing• Collaborated with business analysts to clarify application requirements for the initiative.• Created trackers to maintain the work efforts by all the teams.• Coordinating with the Development team to judge the impact on the applications.• Prepare execution plan and test data for assigned work.• Followed procedures and standards set by the project. • Participated in the Work Group Meetings, Defect Review Calls and Delivery Production Certification Meetings.• Create test requirement survey and communicate test needs to Pipeline Management.• Experience in creating Test plans, Defining Test cases. Developing and maintaining Test Scripts, analyzing the results of scripts• Executing Scripts and Tracking Defects using “Defect tracking” Tools like HP ALM/ JIRA/Rally.

Hyderabad Area, India