Sr Quality Assurance Analyst(system Integration Tester) Resume
Washington, DC
SUMMARY:
- Over 12 Years Experience in Information Technology Industry in several roles such as Test Automation Developer, Onsite Offshore coordinator, Test Automation Lead, Business Intelligence Quality Assurance, ETL Informatica Developer.
- Excellent working knowledge of System Development Life Cycle SDLC, Software Testing Life Cycle STLC and Defect Life Cycle.
- Experienced in Functional testing, System testing, Application testing, Integration testing, Regression testing, Black Box testing, Smoke testing, UAT and GUI testing.
- Expertise in writing Test Plans, Test Strategy, Test cases, Test scripts, Defect status reports, Test Summary report, Requirement Traceability Matrix.
- Over 6 years Expertise in Automated testing using Test Automation tools like Cucumber, Ruby 1.9, Rspec, Watir, RAutomation
- Over 7 Years expertise in Test Automation using Quick Test Professional (QTP)
- Over 4 Years Experience in ETL processes using Informatica Power Center and Informatica Data Quality and IBM MDM
- Experience with creating Db2 extracts for Business Partners with ETL using Informatica Power center
- Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.
- Experience working closely with the project team in user story planning, user story development using Gherkin, and participating in retrospective meetings
- Excellent communication skills, an energetic and positive attitude, strong team skills and an ability to mentor and coach people in Ruby, Cucumber, and Gherkin
- Experience identifying areas for testing improvement and working with the teams to implement appropriate agile QA practices
- Experience facilitating communication between developers, Business Analysts and Automation resources, driving a shared understanding of the domain
- Experience with test automation in an agile development environment implementing ATDD with Ruby and Cucumber.
- Good exposure on Automation Frameworks Such as Data Driven, Keyword Driven, Library Architecture.
- Good knowledge of Test Management Tools and Defect Tracking Tools like HP Quality Center (ALM), Rational Test Manager
- Extensive interaction with developers, configuration management teams while handling production issues with development and business analyst teams.
- Expertise in applying sound software testing techniques and principles to reduce number of defects, improve quality and enhance business success.
- Self - starter, versatile team player, proactive and extremely detail-oriented with a proven capability of working under high pressure.
- Confident and comfortable with both independent and team work.
- Always keen to learn new technologies and look for advancement.
WORK EXPERIENCE:
Sr Quality Assurance Analyst(System Integration Tester)
Confidential, Washington, DC
Responsibilities:
- Creation the test cases as per the business requirements.
- Validation of the backend data against the Oracle database.
- Open defect as and when the test case doesn't meet the requirements.
- Strong hands on experience writing SQL queries for querying the database.
- Analyzing the business Requriements.
- Creation of RTM (Requirements Traceability Matrix) to make sure that each requirement drafted has an appropriated test case associated to that particular requirement.
- Hands on experience in creating and manipulating the data in XML.
- Report, keeping a track of the Incidents in the Clear Quest.
- Testing the business Rules application for the SNAP and TANF business functionality
- Testing the defects once the bugs are fixes.
- Experience with complex and large web based application testing using web- services and APIs.
Environment: IBM Curram, Oracle 11g, Toad,Unix, HP ALM 11.5, XML Spy, Sharepoint, Clear Quest 10 and MS VISIO.
Sr Quality Assurance Analyst (User Acceptance Tester UAT)/ Business Rules Author
Confidential
Responsibilities:
- Creation the test cases as per the business requirements.
- Validation of the backend data against the Oracle database.
- Open defect as and when the test case doesn't meet the requirements.
- Extensive hands on experience writing SQL queries for querying the database.
- Creation of RTM (Requirements Traceability Matrix) to make sure that each requirement drafted has an appropriated test case associated to that particular requirement.
- Creating and analyzing the Business Requirements that were drafted as per the client suggestions.
- Hands on experience in creating and manipulating the data in XML.
- Report, keeping a track of the Incidents in the Clear Quest.
- Testing the business Rules application on the RISK Engine side (Centralized Business Rules) based on the MISMO standards.
- Testing the defects once the bugs are fixes.
- Experience with complex and large web based application testing using web- services and APIs.
Environment: Java 7.0, Rule Admin, Adler,Oracle 11g, Toad,Red hat Linux, HP ALM 11.5, XML Spy, Doors, Clear Quest 10,SharePoint, and MS VISIO.
Sr Quality Assurance Analyst
Confidential
Responsibilities:
- Analyzing the Business requirements make changes to BR as per the business Inputs.
- Drafting of the test cases in HP ALM based on the BRD.
- Creation of the test data as per the scenario for all the methods actual/Actual, Schedule/schedule and net yield.
- Drafting the pictorial representation of the LPI Process using the MS Visio Tool.
- Validating of the test cases against the business requirements document to make sure there are no gaps.
- Validating the Incoming LPI Data elements validation using the SQL Language against the tables in MS SQL Server 2012 DB.
- Validating the test results against the MSSQL DB to make sure the data is being properly reflected in the DB tables.
- Testing various scenarios relating to the Incoming 14 elements.
- Hands on testing the application of the business Rules (Centralized Business Rules).
- Hands on testing the application in CDLF(Common Loan Data Format) which follows the MISMO standards
- Open the defects as and when the test case fails to meet the requirement specification.
- Testing of the claim related Information where the amounts are present for the appropriate claims.
- Creation of the Requirement traceability Matrix (RTM) to make sure there are no GAPS against the Functional requirements.
- Knowledge of Microsoft Visio to develop process diagrams.
Environment: Java 6.0, MS SQL Server 2012, Red hat Linux, HP ALM 11.5, Quality Center, Doors, SharePoint, MS VISIO.
Sr Quality Assurance Analyst (Support UAT)/ Business Data Analyst
Confidential
Responsibilities:
- Analyzing the Business requirements make changes to BR as per the business Inputs.
- Drafting of the test cases in HP ALM based on the BRD.
- Creation of the test data as per the scenario for all the methods actual/Actual, Schedule/schedule and net yield.
- Validating of the test cases against the business requirements document to make sure there are no gaps.
- Validating the test results against the Sybase DB to make sure the data is being properly reflected in the DB tables.
- Testing the Delinquency reporting cycle mechanism to make sure that the loan reported which is delinquent for 2 months can be active in the current cycle.
- Creation of the Requirement traceability Matrix (RTM).
- Testing the reporting methods based upon the Interest calculation like Interest payments.
- Testing of different loans ARM, FIXED and IO
Environment: Visual basic 7.0, HP ALM Quality Center 11.0, Sybase, Doors, SharePoint, Windows 9,MS Visio.
Sr Quality Assurance Analyst
Confidential, Herndon, VA
Responsibilities:
- Creation of Test cases based on the Solution specification document and Business requirements document.
- Map the test cases against the solution specification to verify there's a complete coverage.
- Validating the RTM (Requirements Traceability Matrix).
- Drafting and execution of the detail test cases related to the Monthly level details, Case level details and monthly home page details.
- Hands on expertise creating the SQL queries for validating against the DB to make sure the DB tables are updated successfully.
- Strong hands on implementation complex queries
- Verify the defects opened are retested and closed.
- Conduct the Defect Status calls to discuss the defect opened.
- Hands on writing the SQL queries and validation it against the Oracle Database.
- Followed the MISMO (Mortgage Industry standards organization) standards for the testing process.
- Hands on testing NOD and SI Monthly Home Page, Monthly Case Details and Case Level Details
- Hands on testing the SRDBS Home Page with all the External and Internal Analyst.
Environment: SRDBS User Interface,ASP.NET,C#.Net, Autosys, Mercury Quality Center 9,DOORS,SOAP UI, Clear Quest, SharePoint, Oracle 11 G, Toad,, Unix, VISIO 2010, Windows 7 OS,.
Sr User Acceptance testing Analyst/Business Rules Analyst Lead
Confidential, Woodlawn, MD
Responsibilities:
- Creation of test cases, test plan to reflect the business rules on Centers for Medicaid and Medicare.
- Developing of the Requirement traceability Matrix (RTM) to make sure there is coverage of the test cases for the requirements.
- Elicitation of Business Requirements and documenting the all the requirements.
- Extensively worked on creating the FRD (Functional Requirement Documentation), SDD (System Design Documentation).
- Extensively worked on creation of ICD (Interface Control Document) at the Enterprise Rule Service.
- Creating of the vocabulary for Business Object Model (BOM) which is used by various vertical applications related to MDM (Master Data Management).
- Conducting calls to know the status from the Off Shore team.
- Creation of Test Plan, Test Summary Report.
- Hands on experience in writing the rules in Rule Team Server (RTS).
- Writing the Test Cases for testing the Enterprise Rules related to Health Insurance Claim Account Number Resolution Service (HRS), BICEquate, RRBTOSSA and SSATORRB.
- Drafting of Test Cases at Validation Environment and User Acceptance Environment.
- Elicitation of the requirements and mining of the Business Rules in the ILog Jrules Repository.
- Worked on the claims 270,271,835 and 837I, P and D requirement gathering and testing of the edits functionality.
- Drafted the diagrammatic representation of UML, Sequence, Activity diagrams.
- Drafted the Use case for all the Services which are present at the Enterprise Level.
- Development of the ILog JRules Business Rules.
- Elicitation of the Business Rules Requirements and maintaining the Business Rules in the Business Rules Repository.
- Generating the Business Rules Report to analyze the Rule flow.
- Experience with building, maintaining test plans, test suites, executing E2E (end to end) test cases, managing defects and supported non technical users.
- Hands on testing the application of CBRS (Centralized business Rules) in the IBM Business Rules ILOG.
- Installation of the automation tool QTP.
- Hands on expertise creating the requirements for the DDD (Database Design Document).
- Strong hands on implementation procedure of SQL Server Integration Services (SSIS).
- Development of the Business Rule Language in the Business Object Model (BOM).
- Analyzing the Rules in WebSphere Operational Decision Center (WODM) Decision Center.
- Hands on experience in writing the rules in Rule Team Server (RTS).
- Hands on testing the web services using the SOAP UI Tool.
- Hands on experience in developing the language using the Business Rules Vocabulary.
- Preparation of XML Files which has HICAN (Health Insurance Claim Account Number) and associated Beni-Link Key.
- Testing the Rules in DVS (Decision Validation Services) which is in ILOG JRules.
- Developing of Test Cases in Mercury Quality Center.
- Hands on writing the SQL queries and validation it against the Oracle Database.
- Experience with large web based application testing using web- services and APIs.
- Drafted the diagrammatic representation of UML, Sequence, Activity diagrams.
- Validating the XML Files against the XML Schema.
- Hands on experience in creating JIRA Tickets.
- Writing SQL queries to retrieve data from Oracle Database.
- Environment: IBM ILog JRules 7.0, Mercury Quality Center 9, ALM, Sharepoint,MS Visio 2010, SOAP UI,QTP, WODM 8.0, SQL Server 2005,,ASP.NET,C#.net DVS (Data Validation Services), Linux, Informatica BIETL, Visio, Windows 7 OS,.
Sr Business Acceptance Testing Analyst/ UAT Analyst
Confidential, McLean, VA
Responsibilities:
- Interacted with Developers, discussing the requirement specifications provided by the analyst in the application.
- Involved in writing and implementation of, Various Test Cases and Test Scripts based on BRD (Business Rules Documentation).
- Developed the Scenarios of Various Rules related to Current Last Paid Installment Date, Loan Liquidation Code.
- Extensively Tested Rules related to Eligibility, Validation, Stipulation and Initialization Categories.
- Performed manual testing of the application using numerous Test Scripts.
- Preparation of Test Data using the XML Files for Scenarios related to Data Collection date, NPV Date.
- Developed Test Results report for various Workout Types HAMP, MOD24 and FMMOD.
- Writing SQL queries to retrieve data from Oracle Database.
- Strong experience in Data mapping, System Analysis.
- Extensively Worked on Preparation of Test Data using the XML Files for each Rule with a Specific Conditional Scenario.
- Conduct calls with the offshore team to discuss the status.
- Carried out Rules Testing which includes the Calculations relation to NPV (Net Present Value), Months Past Due Calculations.
- Gathered the requirements for all the accounting related to the amortization terms and Principle calculations.
- Strong understanding of the basics dealing with Access/Debts and derivative calculation related to the calculation of LTV.
- Testing the Graphical User Interface of Confidential .
- Successful in deriving the Complex Scenario (Rules related to Net Present Value (NPV Error Codes)).
- Interacting with the System Integration Testing Team (SIT) for Carrying the Optimization Rules of Confidential .
- Generated the XML Files for the Rules based Scenarios related to Contractual Payment Amounts and Principal Payments Amount.
- Hands on testing the application using the MISMO standards.
- Preparation of the Test Data using the XML Files and processed the files through a sequential algorithm using the rules engine Work flow Client.
- Executed the QTP Scripts which validates the data against the SIR Database.
- Hands on usage of basic UNIX commands.
- Hands on experience in creating JIRA Tickets.
- Hands on expertise creating the requirements for the DDD (Database Design Document).
- Strong hands on implementation procedure of SQL Server Integration Services (SSIS).
- Developed the XML Files for each Rule and validated against the XSD (XML SCHEMA).
- Gained strong hands on experience in using the Fannie Mae's Third Party Tool (SDMU Workflow Client).
- Strong hands on Testing of SOA Web Services (Service Oriented Architecture).
- Experience with building, maintaining test plans, test suites, executing E2E (end to end) test cases, UAT testing with V&V, managing defects and supported non technical users.
- Involved in writing the SQL Queries against the SIR Database which test each and every Rule related to different Calculation Purposes Pre-Qualification, Structuring-Trial and Structuring-Final.
- Environment: SQL Server 2005,ASP.NET,C#.NET, Rational Clear Quest 10,Altova XMLSPY, Oracle, QTP, Confidential Workflow Client (J2EE Utility),Unix, Mercury Quality Center 10.0, ALM, Doors, Visio 2005, Toad Tool.
Sr. Business Rules Analyst/ UAT Business Rules Analyst Lead
Confidential, Alexandria, VA
Responsibilities:
- Understanding and analyzing user requirements, business processes, gap analysis, data mapping, data process and business scenarios.
- Preparation of the test plan and the test scenarios for the flow of the Rule 15Ga-1 form.
- Creation of the UAT test cases for intake Information form for the EDGAR UI of SEC.
- Extensively tested forms related to ABS-15G initial Filling,
- Worked on the XML Files to Input the data.
- Gathering the requirements related to the amortization payments schedule and accounting of ledgers.
- Worked on Ongoing reports filed on FORM 10D.
- Defining the requirements in Business Rules language.
- Hands on expertise developing the SQL Server Integration Services Packages (SSIS).
- Defining the Business Rule workflow.
- Analyzing of the business Rules in the Rules Repository in IBM ILog JRules.
- Worked in the Capital Markets groups which deal with the vendor in the filing the ABS-15G Forms.
- Have strong Knowledge on Uniform Loan Delivery Datasets models.
- Drafted the diagrammatic representation of UML, Sequence, Activity diagrams.
Environment: ILog JRules, Mercury Quality Center9.0, Clear Quest, SQL Server 2005, SSIS, Doors, MS Visio 2003, Toad, XML Spy.
ETL QA Analyst/Business Rules Analyst
Confidential, Pittsburg, PA
Responsibilities:
- Interacted with Developers, discussing the requirement specifications provided by the analyst and also the discrepancies in the application.
- Involved in writing and implementation of Test Plans, Various Test Cases and Test Scripts based on functional specification and documented it for higher levels of management.
- Writing SQL queries to retrieve data from Oracle Database.
- Testing the Test data from EXCEL and XML.
- Development of the ILog JRules Business Rules.
- Elicitation of the Business Rules Requirements and maintaining the Business Rules in the Business Rules Repository.
- Generating the Business Rules Report to analyze the Rule flow.
- Development of the Business Rule Language in the Business Object Model (BOM).
- Testing the Rules in DVS (Data Validation Services) which is in ILOG JRules.
- Involved in testing the functionality of the Confidential loan Processing.
- Wrote SQL queries to verify the database updates, inserts and deletions etc., of the records, and validate reports.
- Worked on testing of the extraction, transformation and loading (ETL) at each stages using SSIS (SQL Server Integration Services).
- Involved in testing the screens of Confidential Customer Email Messaging.
- Hands on experience in creating JIRA Tickets.
- Performed Functional, System Integration Testing (SIT), User Accepting Testing (UAT) and Regression.
- Used Quality Centre for defect tracking and reports like test coverage matrix, defects report.
- Extensively involved in validating back end Database system (HOST) testing.
- Hands on testing the data that comes from Investment Accounting Departments.
- Involved in testing the Microsoft Office Sharepoint server (MOSS).
- Involved in developing VB Scripts.
- Involved in creating Test Components for Business Process Testing.
- Involved in Testing of SOA Web Services (Service Oriented Architecture).
- Involved in development of the Activity diagrams and process Flow diagrams.
- Involved in writing the SQL Queries against the Sybase Database.
- Hands on generating the SOAP Request and enabling the WSDL in Web Services.
- Worked on testing the Web Services of internal dept. of mutual financial.
- Hands on experience in testing XSD (XML SCHEMA).
- Involved in analyzing the Transaction time and Rendezvous attributes with graphs and reports.
Environment: .NET, Test Director 8.0,DB2,Soap UI, C#.Net, Rational Clear Quest, Rational Clear Case, Toad, Crystal Reports, JUnit, Toad, SQL Server 2005,QTP, ALM, Doors,HTTP, SOAPUI, ILog JRules,MSWord,Excell,DB2,XML,X-12, ORACLE 10g,MS VISIO 2007,TOAD, MVS/ESA.