Qa Lead Sql Server
Resume:
Celine Soloman
Sr QA Lead
**************@*****.***
Summary
Result focused and customer-oriented QA Lead with professional expertise in test strategy, test planning, estimation, leading testing efforts for large/complex projects
18+ years of IT experience with different domains like Banking, Claim Processing, Life Science, Insurance, Retail, Debit/Credit card processing and Healthcare.
Strong understanding of QA principles, process, use cases and SDLC – Agile, Kanban and Waterfall
Proven ability to lead large/complex testing projects from initial through implementation with testing team (both onsite, offshore)
Extensive working experience in testing Cloud, Web, Windows, IOS applications with Manual (API, Functional, Smoke, System, Regression and black box testing) and Automated testing (UFT/QTP, Telerik Test Studio). Strong experience in SQL testing (SQL Server, Oracle, MS access) and testing SSIS jobs. Working experience in JIRA, Quality Center, Postman, SOAP UI tools
Experience
Employer: Peovident Bank
Senior Qulity Assurance Analyst, Iselin, NJ Oct 2023 – Till Date
Project: Sales Force
Responsibilities:
Responsible for creating test strategies,test cases as per requirement specification and business rules
Collaborated with multiple teams for integration testing and helped other teams when they need and responsible for preparing the RCA document for the defects
Analyse the complexity and provide the estimate in sprint planning session
Using SOAP UI tested the webservice methods for each release
Experience in writing queries to validate the backend
Collaborate with UAT team and assisting during UAT testing cycle
Prepared and shared the weekly status report including defects and testing sttaus
Employer: Fiserv Inc.,
Qulity Assurance Engineer, Parsippany, NJ Apr 2019 – Oct 2023
Project: Dovetail Payment Solutions
Environment: Java/J2EE, Struts, JSP, JMS, Weblogic, Oracle, Jquery, XML, Windows 7, Webservices, SOAP
Responsibilities:
Responsible for creating test strategies and test cases as per requirement specification and business rules
Collaborated with multiple teams for integration testing and helped other teams when they need
Analyse the complexity and provide the estimate in sprint planning session
Processing Incoming and Outgoing CT/DD messages via Clearings, ISO, Webservice and Manual Payment
As per requirement created different types of Incoming and Outgoing CT/DD messages (pain001, pacs008, SWIFT, USACH, Fedwire)
Using SOAP UI tested the webservice methods for each release
Using JIRA, created the defects and test cases (Zyphyr plugin). Monitor the defects created by different teams and share the report to the management team on Monthly basis
Responsible for doing the RCA (Root Cause Analysis) of the defects
Experience in testing the backend by writing queries to validate
Shared the payment application knowledge with new team members and helped the other team for the webservice testing
Experience in preparing the KT document for other team members as well as Clients for the new functionality
Employer : Cyber Think
Senior QA Lead at ConnectiveRx, Whippany, NJ Nov 2016 – Mar 2019
Project: PMP/CMP/Client Projects
Environment: .Net, SQL Server 2012, SQL Server 2016, JIRA, SOAP/Postman, SSIS, Windows 7, Cloud
Responsibilities:
Managing and leading onsite and offshore team, delivering 8-10 projects in a monthly release schedule.
Coordinated resource allocations, created work assignments for team, maintained timelines / milestones, and ensured compliance with quality standards.
Participate in requirement gathering meeting, release planning meeting and allocate work accordingly based on priority.
Responsible for creating the test plan/approach, test schedule, execution plan, defect management process and status report (including metrics) to management. Well versed with JIRA on creating requirements and Defect tracking. Co-ordinate with vendors for testing the new client programs go-live on scheduled date.
Testing different types of files received from different vendors (LASH, EDI) and import the patient / Physician / Practice enrollments along with claims.
Performed end to end testing from claims entry to claims payment & communication. Testing the SSIS job to import & export the data from different sources to the system.
Executed SQL scripts to validate data which flows to the claim processors with the actual data in the Database & Performed data migration testing.
Worked in Agile environment & executed regression test suite after each release. All the new epic, story, bug created and tracked in JIRA
Tested all the APIs by using SOAP/Postman.
Prepare & sharing the status report to the project team regularly. Total Test management for the Project and tracking activities to completion and managing Issues and Risk that occur during the Pre and Post Upgrade testing
Employer : IDExcel
QA Lead at T-Mobile, Parsippany, NJ Nov 2015 – Nov 2016
Project: GrandCentral/OneConsole
Environment: .Net, SQL Server 2014, Fiddler, QTP 12, VB Script, HP ALM, JIRA, TFS, SOAP, Windows 7
Responsibilities:
Manage, review, and analyze the testing of both UAT teams, collect status from both on-site & offshore
Well versed with JIRA on creating requirements and Defect tracking
Manage, Maintain & Contribute Multiple Projects and Documentation based on the ICE Methodologies.
Reviewed Test coverage document by analyzing the requirements and deriving Test scenarios and Traceability matrix.
Lead System Integration Test activities including creating Test Strategies, Test Plans, Test Cases and project test executions for highly complicated applications.
Prepared Automation Regression Script Suite with Reusable Scripts, Function Library, Test Data Repository. Parameterized the scripts, connect DB, handle errors and create checkpoints using QTP.
Migrated ALM test cases to JIRA. All the new epic, story, bug created and tracked in JIRA. Train the team to fix minor issues in the automation test suite.
Worked in Agile environment & executed automation test suite after each release.
Emphasis on the documentation and tracking of all test results was high, thus maintained the Microsoft SharePoint as a common repository for documenting.
Tested the APIs by using SOAP
Prepared and shared the status report to the project team on weekly basis
Employer : Cognizant Technology Solutions
QA Lead May 2010 – May 2015
Clients: MetLife Insurance, Novartis Pharmaceuticals Corporation
Project: Disability Client Specific/Concur Travel and Expenses, Veeva Concur Integration, MUTAP
Environment: Java, J2EE, .Net, DB2, Oracle, QTP 10, VB Script, HP ALM/QC, Citrix, Windows 7, IOS
Responsibilities:
Lead System Integration Test activities including creating Test Strategies, Test Plans, Test Cases and project test executions for highly complicated applications.
Primary Responsibilities included Business Analysis, Test Architecture and Document Management and Vendor Management.
Performed testing Estimations. Reviewed Test coverage document by analyzing the requirements and deriving Test scenarios and Traceability matrix.
Created automated test suite for Smoke and Regression test cases using QTP.
Worked closely with Veeva and Concur third party teams.
Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing and batch testing done for both mobile device and web version.
Attended status calls and prepared and shared the status report to the project team on daily basis.
Manage, Maintain & Contribute Multiple Projects and Documentation based on the ICE Methodologies.
Reviewed Test coverage document by analyzing the requirements and deriving Test scenarios and Traceability matrix.
Trained junior and intermediate team members.
Closely interacted with product management and development teams to assure most effective project execution.
Employer : Sunfix Technologies
QA Automation Engineer Oct 2017 – Apr 2010
Clients: Home Depot and TSYS Atlanta, GA
Project: Inventory Management System / Prepaid Card Processing
Environment: QTP10, QC 9.2, Windows Mobile on Motorola Symbol devices, C#, SQL Server, UML, Java, J2EE, JBoss4, VSS, Oracle, UNIX, VSS
Responsibilities:
Developed detailed Test Plan and Test Cases and created automation test suite for smoke and regression test cases. Ran the automation suite from Quality Center and analyze the test results.
Prepared QTP Automation Regression Script Suite with Reusable Scripts, Object Repository, Function Library and Test Data Repository.
Created Functions in QTP to read flat file, parse the file, compare and verify if the data is written according to the correct format.
Written SQL Queries for Backend Testing and also involved in Batch Process Testing.
Executed the UNIX commands and check the logs.
Utilized the Web Services to automate the API calls and to send SOAP request over the http protocol.
Entered the bugs in a tracker system JIRA, which is used for defect tracking.
Involved in version management of source code using VSS.
Prepared the Test Summary report in a customized form.
Employer : Isoft, Chennai, India
QA Analyst Nov 2005 – Aug 2006
Project: Lorenzo
Environment: QTP 8.2, QC, .Net, Oracle, Windows NT/2000
Responsibilities:
Translates software requirements and functional specifications into test requirements.
Developed Test Plan, Test Cases and created test suite with automated tool QTP.
Involved in Smoke, Integration testing, System testing and regression testing.
Entered the bugs in a tracker system, which is maintained in a database using Quality Center.
Prepared Test Summary Report.
Employer : Seerock IT Solutions, Chennai, India
QA Tester Feb 2004 – Oct 2005
Project: Admin Asset, Swiping Management Information System
Environment: VB6, SQL Server 6.5, Crystal Reports 7.5, VBA Coding, COM, VSS, Windows NT/2000
Responsibilities:
Created Test scenarios and test cases. Prepared data for function, GUI and Database testing and executed the test cases
Extensively worked on the data validation, manipulation and updating the tables
Entered the bugs in a bug tracker system
Contact this candidate