OBJECTIVE

• Has over 15 years of IT experience, including over 11 years of experience in Software Testing/Quality Assurance and 4 years in SSRS and SSIS of Client - Server and Web-based applications using automated tools, manual testing and SQL Server Reports.

TECHNICAL SKILLS

Test Management: Automation Tools Win Runner, Quick Test Pro and Test director, Mercury Quality Center, Q-test

Defect Tracking: Clear Quest and Clear Case, Jira

Test Techniques: Manual testing, Automated Testing, Database Testing., API

Test Types System Testing: Functional Testing, Integration Testing, Regression Testing, UAT

Languages and Specifications: VB, Access, JavaScript, SQA Basic, TSL,SQL, PL/SQL, Net, XML Python, Selenium, VB script

Databases / Data Access Technologies: Oracle 10g, SQL Server, MS SQL Server 2005 MS - Access, SSIS, SSRS.

Office Communication: MS Word, MS Excel, Power Point, MS Office Outlook. SharePoint, TFS.

Source code control: Bit Bucket, Bamboo.

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

SR Automation Analyst

Responsibilities:

• Assists various teams to set up, create and maintain test scripts
• Creates and maintains automated test scripts using Selenium and C#, Rest-Sharp, Postman and Hammer IVR tool.
• Maintains and Updates the Automation scripts for UI and API Chat bot on live engage projects(HR, IT, OLB, Life Line, Mobile and Empower)
• Documents policies and procedures related to test automation
• Works closely with DevOps to ensure full integration of automation scripts for the CI/ CD Pipeline
• Automates and validates Watson and SOE functionality using JAVA Eclipse and schedule through Bamboo.
• Reports weekly and monthly automation metrics.
• Creates test cases by requirements in HP ALM test management tool.
• Performs End to End regression testing on new functionality.
• Prepares conditional test records and test data from the data lake (Impale/Hive) to perform regression/performance testing.
• Prepares test execution pass/fail reports in HP management tool
• Maps Automation test cases to Q-test (contact center application)
• Creates Test Data from Impala/Hive through Sql queries and conditioned the data prior to manual/automation testing.
• Maintains Source code in Source Tree (Bit Bucket, GIT).
• Schedules scripts in bamboo to run on weekly basis and send test results report to the team.
• Automates Reggie 6 AM daily monitoring call through hammer and Chat bot monitoring through bamboo.
• Executes and validates the response plan scripts in the production after the deployment.
• Uses Scrum Agile Methodology attended (Daily standup’s, PI planning, Backlog and retrospective) meetings.
• Creates stories in Jira (Epic, Spike and Feature)
• Writes SQL queries to pull data from the Reggie logs.
• Creates and updates the testing process and documents in confluence page.
• Builds and automates Power BI reports for pass/fail test execution and published in Dashboard.
• Creates Stored Procedures in SQL to pull data from Data Lake and scheduling data refresh in SQL side.
• Helps integrate automation test results from the Regions Automation Framework to a Test Management Tool (Q-test/ DevOps). This reporting helps the development team identify software bug that require fixes.
• Validates speech to text and text to speech by using nuance tool for Reggie and Q-test is used to analyze the calls, input transcript, output transcripts are calculated the accuracy of the ML drift validation.
• Validates and Automates Cards report using RPA (foxtrot tool).
• Develops Python bases analysis of production level customer input text into N-grams and analyzed the millions of text in few hours to improve the Reggie conversation.
• Assists with User Accepting Testing and Performance testing teams.

Confidential, Birmingham, AL

Automation Testing Lead / Programmer Analyst

Responsibilities:

• Self-starter in the current role and identify the appropriate tools for the test automation according to the Archer application requirements.
• Performed Proof of Concept on the GRC Application with Selenium/WebDriver code without any prior knowledge or training.
• Identified offshore resources and hired with required skilled set.
• Managing four automation offshore resources.
• Developed and executed test plans and Test cases stored in QTest management tool
• Defined automation test strategy/test plan for web test automation using C#.net and selenium.
• Designed the test cases and planned the test data required for executing test cases.
• Designed and implemented the overall automation framework by using Selenium C#/WebDriver methods and TestNG.
• Trained offshore team members on Automation Framework.
• Provided continuous maintenance and development of bug fixes and patch sets of the framework.
• Scheduled the Regression scripts in Bamboo to run on the daily basis.
• Estimation of Automation Test Efforts, Test Planning, Tracking and Control maintained in MS Project Planner.
• Working in Agile Development and created stories/points in Jira.
• Executed Automation scripts on new upgrade/build.
• Scheduled Performance testing and Penetration testing.
• Managing testing activities, test deliverables and task allocations.
• Perform Product support and cars request on daily basis.
• Perform End to End testing on new functionality.
• Prepared conditional test records and test data to perform regression/smoke testing.
• Prepared test execution pass/fail reports in Q-Test management tool.
• Mapped Automation test cases to Q-test.
• Maintained Source code in Source Tree (Bit Bucket).

Confidential, Birmingham, AL

Business System Analyst

Responsibilities:

• Involved in creating Test Plans and prepared Test Cases based on Business Requirements,
• Technical Specifications and General Design Documents.
• Performed Functional, Regression, Smoke, Exploratory, and Sanity testing
• Verified Mainframe Host for all the Platform and Teller transaction updates.
• Performed Validation Testing for all the new products that were introduced in the Bank.
• Worked closely with team members, designers, and the development team to resolve any defects and functional issues.
• Developed Data and Keyword driven Framework, functional libraries, recovery scenarios using VB scripts in UFT/QTP
• Conducted Manual Testing on the system, prepared and managed test cases using HP ALM
• Used ALM as the test repository and used it for executing the test cases and scripts logging,
• Coordinated with the development team for defect verification and used Jira for defect logging.
• Tracked, verified, and logged Defects for resolution in a timely manner consistent with project deadlines.
• Verified the data in mainframe to match the Teller Application after the transaction process.
• Developed SSIS ETL packages to meet data flow needs.
• Planned designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data
• Retrieved and performed Data Validation Checks during Staging, and then loaded the data.
• Developed the Teller scripts using Automated Testing Tool (UFT with VB script).
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services.

Confidential, Birmingham, AL

Sql Reporting Analyst

Responsibilities:

• Created test cases for User Stories/business Use Cases to ensure proper data acceptance, processing, and retrieval and appropriate implementation of the business rules.
• Created ad-hoc reports for customer service, claims, and for physician billing.
• Created UI test cases to verify the layout of the screens and to check all objects, links, colors, and default values, Functional test cases for Field validation, Tab validation and Error messages
• Involved in Functional Testing and Regression Testing by executing test cases manually for multiple iterations (Agile methodology)/builds
• Involved in Integration Testing of GUI screen components, to ensure that the correct screens are called, Black-box Testing/System Testing to verify the application by interacting application via GUI screens and analyzing the output results.
• Provided documentation & technical support in SQL, SSRS, and ACCESS Reports to clients in creating Columnar, Cross tab Form and Label
• Reported consisting of report variables and simple or complex derived fields
• Developed SQL scripts to verify data loads from Drug Interactions using SSIS.
• Managed and performed the report writing process for Physician billing. Run ad-hoc, weekly, monthly, quarterly, and yearly report on financial and health care claims data.
• Involved in Database Testing, executing test cases to confirm that information entered by the user at the screen level makes it to the database, in the proper way, and that when database calls are made from the screen, the proper data is returned to the user.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created user defined functions in SSRS using VB script.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Creating Test Execution Summary/Report after each testing cycle and used Microsoft Share Point for Tracking Bugs, User Stores and Tasks, Visual Source safe to maintain versions of documents like Test Summary.

Confidential, Birmingham, AL

QA Analyst

Responsibilities:

• Designed Test Plans, which describes the features and functions to be tested according to SDM/CMM level framework.
• Designed Test Plans, which describes the features and functions to be tested according to SDM/CMM level framework.
• Prepared Test Data for positive and negative test scenarios for functional testing as documented in the test plan.
• Setup and configured SIT (system integration test) environment to test Integration, Regression and End-to-End testing.
• Used Test Director to plan tests, manage test assets, create and run manual and external scripts to check GUI and functional features of the AUT.
• Used QTP and Win runner to automate manual Test scripts for browser testing
• Performed System, Integration, Regression and End to End testing for application version releases.
• Performed the Back-End Integration testing to ensure data consistency on front-end by writing and executing SQL queries on the database
• Submitted the defects by logon to Scarab and Test director generated unique ticket number to those defects.
• Created user defined function libraries to enhance the maintainability and reusability of the scripts using Win Runner
• Created final test report to the tested application with test exit criteria follow-ups
• Prepared the test matrix reports for the executed test cases
• Re-tested the resolved issues
• Updated and managed defects report in Test director and scarab