Sr. Qa Analyst/technical Consultant Resume
MichigaN
EXPERIENCE SUMMARY:
- 25+ years of Professional IT experience including leadership, business analyst, project management, testing, deliverables, SDLC life cycle, and development.
- Expert knowledge in business requirements gathering, technical spec documentation, process engineering and software development life cycle (Agile/Scrum), including documentation, analysis, design, development, testing and implementation of software applications.
- In - depth knowledge of multiple testing methodologies, ETL, and various utilities, SQL and DB2 tables and TSO utilities.
- Hands on experience in writing SQL queries to query Database.
- Overall test process management; including originating test cases, writing test scripts, test case validation, test plan tracking/monitoring, status updates, and end to end test plan reporting.
- Management of Quality Center, including requirements gathering, test case upload, defect management resolution, identification of usability and process improvements at the completion of each project.
- Excellent communication, analytical, interpersonal, and presentation skills; expert at managing customer-defined business requirements and processes.
- Experience in collaborating with business groups to implement User Acceptance Testing.
TECHNICAL/SOFTWARE SKILLS
Databases: DB2, CICS, IMS, TSO/ISPF, SAP, MS Access, SQL Server(2008)
GUI/Tools: MS Project, Visio, Access, Windows, Microsoft office, SharePoint
Web Technologies: .NET, HTML, Java, XML, Cisco Jabber
Industry Standards: SDLC, AGILE & SCRUM, HIPAA, SOX, ISO
Platforms: COBOL and assembler (Hogan) CIS/IDS/CAMS/DDA/ODS/PAS
Defect Tracking: HP/ALM11 including Defect tracker, and Clear Quest
Testing Tools: HP ALM 11 Sprinter, Test Director, Quick Test Pro (QTP), SoapUI
WORK EXPERIENCE:
Confidential, Michigan
Sr. QA Analyst/Technical Consultant
Responsibilities:
- Modified and is no longer supported by vendor. The objective is to deploy a vendor-supported
- Solution to replace/change the current Confidential Card Management System and the corresponding Hogan
- Applications to support product enhancements. This will give Confidential to issue debit cards, close debit
- Cards and update debit card Personal Identification Numbers.
- The solution will also provide real time Web Banking enrollment, thereby greatly enhancing the customer experience.
- Identify the functional requirements using best practices.
- Develop and validate use cases and customer-defined business process modeling.
- Execute .NET SQL Server statements and queries that are configured to run SQL statements using Table adapters or command objects.
- Manage web application testing with web testing checklist, which includes;
- Functional spec documentation and testing
- Usability testing
- Interface testing
- Compatibility testing
- Performance testing
- Security testing
- Use Mainframe CICS regions and TSO for tools for manual testing. Use UMBRELLA for testing PCD’s. Maps, Activities, Data Groups, FPS and SPS tools for overall control of online navigation conversation programs and reporting.
- Use SoapUI application and framework to simplify the testing of web applications and web services. Documented test cases using a graphical user interface; executed either by using the graphical user interface or in an embedded fashion.
- Manage test data processes as input for test execution(s), using XML testing protocols.
- Lead a team of 5 QA members to deliver product on schedule and provide estimates to the technology manage.
- Identify and document defects early in a centralized software system, record defects in defect tracking software and quickly implement a resolution.
- Record test cases, passed the test-run execution, in ALM QC center.
- Set up automated test runs for Calendars (Daily, weekly, monthly or on a cycle).
- Documented all stages of the QA process and work with QA Leads/Managers to define & improve best practices in QA.
- Communicate regularly with project managers, team members and management.
- Coordinated database backup testing processes.
Confidential
Sr. QA Analyst/Technical Consultant
Responsibilities:
- Identify and manage functional requirements using best practices from the enterprise.
- Develop and validate use cases and customer-defined business process modeling.
- Execute Server statements and queries that are configured to run DB2/SQL statements.
- Lead a team of over 7 QA members to deliver product on schedule and provide estimates to the technology manage.
- Identify and document defects early in a centralized software systems, record defects in defect tracking software and quickly implement a resolution.
- Record test cases, passed the test-run execution, in ALM QC center.
- Set up automated test runs for Calendars (Daily, weekly, monthly or on a cycle).
- Documented all stages of the QA process and work with QA Leads/Managers to define & improve best practices in QA.
- Communicate regularly with project managers, team members and management.
- Coordinated database backup testing processes.
Confidential, Chandler, AZ
Senior QA Analyst and Test Engineer
Responsibilities:
- Analyzed business requirements and specification document of Wholesale QA’s Treasury solutions, ACH EDI, Wires, Lockbox, Swift, and other Treasury protocols.
- Worked closely with vendor SQA departments to ensure software vendor's compliance with SQA procedures.
- Adhered to Agile best practices including daily Scrums.
- Validated technical performance of components deployed/installed in the appropriate testing environment(s).
- Wrote and executed test plans, test scripts, strategies, reporting results, defects and designing test cases based on the business requirements using ALM link and other matrices.
- Used Test Track solution to manage the manual and automated testing.
- Executed manual test cases in the ALM/Test-lab, based on pre-defined scenarios and scripts.
- Used customer-defined QTP tool to execute automated test scripts.
- Executed SQL statements and queries.
- Managed technical requirements and test plan report for test execution.
- Identified defects, recorded defects in Clear Quest defect tracking software and communicated with the developers for resolution and tracking of issues, anomalies, and errors.
- Recorded all test case outcomes in ALM QC center.
- Executed test runs for Calendars (Daily, weekly, monthly or on a cycle).
- Prioritize defect(s) and documented process through resolution.
- Identified related areas to test based on delivered bug fixes and features.
- Used Defect/bug tracking tool, and client-defined associated processes.
- Responsible for identifying, logging, tracking and escalating bugs, verifying bug fixes, through regression testing, updating & maintaining related QA documentation and write bug reports.
- Worked with Mainframe technology(CICS), concepts and tools, in an environment with short development and release cycles.
- Provided guidance to junior team members in developing testing & technical skills.
- Documented all stages of the QA process and work with QA Leads/Managers to define & improve best practices in QA.
Confidential
Sr. QA Analyst/Technical Consultant
Responsibilities:
- Projects involved coding/testing and validation of CIS/CAMS II bank products within the banking core Hogan legacy system.
- Upgraded the client-defined data scrub to make data more accurate and consistent
- Identified and documented processes to eliminate duplicate records, correct misspellings and errors in names and addresses, unify descriptions, punctuation, syntax and other content issues.
- Documented and developed complex technical documentation including: scope of work, business requirements, technical and functional specifications and other technical project artifacts, manuals, technical presentations, technical materials.
- Integrated HOGAN Deposits application (DDA/TDA/CIS/ODS) in addition to third part and in-house systems. The CAMSII offers real-time posting of financial activity, supporting immediate debit and continuous risk management and minimizing batch processing.
- Worked with the Hogan batch-group, that extracts daily/weekly/monthly transaction activities and propagates many different DB2 tables.
- Performed heads down testing, worked with developers and technical operations and production support staff to isolate and solve abends/problems, and created necessary documentation.
- Wrote tests that work well in parallel for Selenium; each test needed to be concise and be able to run independently, grouped the tests by functionality, named/tagged test files for testing to be completed thoroughly and efficiently.
Confidential, Chandler, AZ
Senior QA Analyst and Test Engineer
Responsibilities:
- Developed, wrote, and executed test plans.
- Dynamically created test objects, using descriptive Programming.
- Wrote, maintained, and verified test cases.
- Developed test matrixes, identified test data and Use Case requirements.
- Worked closely with the Data Warehousing and ETL administration on managing the data for customer relationship management (DDA/CIS/CRM) and other applications.
- Black Box Testing including testing against large-scale database systems (MS SQL Server 2008 and Oracle).
- Tested web applications, writing SQL queries to identify and verify data used by code.
- Worked with relational database technology, concepts and tools, in an environment with short development and release cycles.
- Used Defect/bug tracking tool, and associated processes.
- Responsible for identifying, logging, tracking and escalating bugs, verifying bug fixes, through regression testing, updating & maintaining related QA documentation and write bug reports.
- Provided guidance to junior team members in developing testing & technical skills.
- Provided guidance on establishing & maintaining a library of automated tests.
- Documented all stages of the QA process and work with QA Leads/Director to define & improve best practices in QA.
- Worked with basic server administration, including server starts/stops, basic modifications to web server config. Files.
- Worked with Release Management process/methodology.
Confidential
Sr. QA Analyst/Technical Consultant
Responsibilities:
- Projects involved testing and validation of new CAMS2 upgrades within the banking core legacy system.
- Worked in .NET SQL Server.
- Performed heads down testing, worked with developers and technical operations to isolate and solve problems, and created necessary documentation.
Confidential, Chandler, AZ
Mainframe Senior QA Analyst and Test Engineer
Responsibilities:
- Tested the Conversion of the acquired Wachovia Financial CRM/Brokerage application(s) and the corresponding data to Confidential Bank, using COBOL and DB2 software (CIS/Hogan systems).
- As QA worked in close collaboration with business analyst, designers, and developers, from the project definition stage, through final development into production.
- Responsible for ensuring that all Confidential Financial applications including COBOL IMS and CICS batch and online programs performed according to the specification and without defects.
- Established QA Process, Test Approach, Defect tracking and Test Case naming convention.
- Set up Quality Center Projects and maintained users.
- Participated in high level business requirements, functional design, and technical design review sessions, focused on testing the conversion of the acquired Wachovia Financial CRM application(s) and the corresponding data to Confidential Bank CIS/Hogan systems.
- Created Master Test Plans.
- Created Test design document which cover test cases and SQL scripts for applicable business scenarios.
- Designed SOX testing requirements and mapping SOX controls, for all levels activities.
- Reviewed Test cases and Test scenarios with Business and Application development team.
- Established Defect tracking process before the beginning of testing with Test teams, Business and other users involved in different phases of testing.
- Prepared Test Data for the test case execution. The task included using extract and load processes to obtain data from the related IMS and DB2 database or tables using COBOL extracts, CICS batch file control, JCL coding, DB2 queries and or using ISPF screen panels and or using data mining procedures to extract data from various data-warehouses and combine the data together, for any specific scenarios during functional and or integration testing.
- Conducted testing- system integration testing, regression testing, and supported UAT.
- Executed test cases and SQL scripts for applicable business scenarios.
- Conducted daily and weekly defect status calls with relevant stakeholders.
- Responsible for communicating daily Testing status, Risks, Weekly Metrics and reporting to Business, Application and Project team at large.
- Guided and mentored team from a testing perspective to ensure delivery of the tested application.
Confidential, Scottsdale, AZ
Mainframe Senior QA Analyst and Test Engineer
Responsibilities:
- Tested and implemented complex Health Care Financial/CRM systems project(s) into production environment as well as Medicare Part D and Fulfillment processes .
- Responsible for ensuring that all Confidential Financial applications perform according to the business requirements specification and without defects.
- Established QA Process, Test Approach, Defect tracking and Test case naming convention.
- Set up Quality Center Projects and maintained users.
- Participated in technical design review sessions, focused on testing all Confidential Financial applications modified or customized based on business requirements.
- Created Master Test Plans.
- Created Test design document which covers test cases and SQL scripts for applicable business scenarios.
- Reviewed of Test cases and Test scenarios with Business and Application team.
- Established Defect tracking process before the beginning of testing with Test teams, Business and other users involved.
- Prepared Test Data for the test case execution. The task included using extract and load processes to obtain data from the related HIPPA-IMS and Confidential Financial system DB2 tables using COBOL extracts, JCL coding, DB2 queries and procedures to extract data from various data-warehouses during functional and or integration testing and set up data
- UAT testing.
- Conducted system integration testing with different group of business users and incorporated developers in the end-to-end testing process.
- Conducted SOX testing requirements and mapping SOX controls, for all level of Confidential Financial activities.
- Executed test cases and SQL scripts for applicable business scenarios.
- Reviewed testing documents produced by offshore testers.
- Prepared guidelines and checklists, oriented new testers on documentation, status reporting standards, execution methodology and tracking processes.
- Prepared test summary report with defect root cause analysis.
