SUMMARY

• Have over fifteen years of experience in Software Quality Assurance, Requirement Analysis gathering, Design of Manual testing of various applications for Web - based, data-warehouse environments.
• Have over seven years of lead experience.
• Leading team interaction on effort, test approach, review, defect analysis and resolution.
• Actively participated in all the stages of the Project Life Cycle and was extensively involved in all dimensions of Functionality, Regression and Load testing.
• Expertise in Quality Analysis with strong knowledge of Software Development Life Cycle (SDLC) Software Testing Life Cycle (STLC) and AGILE Methodologies (Scrum model).
• Extensively worked as a QA Analyst in Web applications and Database Systems for different software domains.
• Tested WebServices /XML using SoapUI tool
• Expertise in Defect Tracking tools like ALM/Rally/JIRA
• Experience in Hadoop, Mainframe and Informatica coding for Datawarehousing applications with ETL concepts
• Expertise in Database Language like Bigdata Hadoop, Oracle/SQL/Teradata/DB2
• Experience in conducting System, Integration, Functional, User-Acceptance Testing (UAT) and improvement of QA Process
• Track the requirements using Requirements Traceability Matrix (RTM). Determine strategy for test case traceability and test coverage, including the creation of Software Test Specifications for all projects
• Good knowledge about Billing and Collaboration with Claims system in healthcare
• Extensive work experience in Designing Test plans, developing Test cases, generating and maintaining test scripts, analyzing bugs, interacting with other team members to debug the errors and etc.
• Working experience with SPARK, SCALA, JAVA and .NET applications.
• Execution of schedules using Control-M
• Experience in UNIX working environment
• Lead the testing review work of team members and providing valuable inputs to the team members in order to address the issue.
• Working knowledge of standalone applications used for Liner and Logistics moves and transportation systems.
• Experience in leading onsite and offshore team members.
• Lead the interaction with clients and business analysts representing the team in receiving inputs and passing on to team members and vice versa.
• Participated in the effort estimation of the tasks starting from requirement, including defect resolution and production deployment.
• Worked with customer credit and debit cards in financial domain. This includes card security, daily transactions and fraud protection.
• Good knowledge in scripts to perform functional, regression, integration and system testing.
• Anticipate error conditions and imagine likely failure scenarios with a high degree of coverage relative to real world scenarios and propose solutions for systemic defects affecting the total quality of the product
• Preparation of report and progress in the tasks to the manager and receive their feedback and pass it onto the team.
• Proven ability to support multiple projects, under tight deadlines, often with competing priorities and complexities.
• Strong understanding of Organizational structure, effective time management and have the ability to work in a team as well as independently.
• Effectively involved in defect tracking, reporting, reviewing and analyzing the test results and also writing test plans, test cases
• Monitor progress and communicate status, issues, and resolutions to all stakeholders and management through written and verbal reports
• Strong Analytical and Problem-solving skills.
• Good interpersonal and communication skills.

TECHNICAL SKILLS

Testing Tools: HP ALM, QA Complete, Rally, JIRA, SOAP UI, QTP 11.0

Development Tools: Spark, Ab-Initio, Informatica, Mainframes

Languages: Java, HTML, XML

Database Technologies: Bigdata Hadoop, SQL/Teradata/Oracle/DB2, Toad

Operating Systems: Windows (7, XP), UNIX

Auxiliary skills: Maximo, Tivoli, MS Office

Technologies/Domain: .Net, Java J2EE, Banking Finance, Insurance, Wireless, Document Management, Liner and Logistics, Transportation systems

Testing: Manual, Automated, White Box, Black Box, System Testing, Integration, Unit, Regression, Test Plan, Test Cases, Matrix, Datawarehousing/ETL Preparation, Performance Testing, Load Testing

Other tools: Cognos, Crystal Reports, Selenium, Load Runner

Other Skills: Writing functional specs, design and documents, unit test documents. Knowledge of SDLC (Software Development Life Cycle) and Defect Life Cycle, QA Methodologies

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Senior QA analyst

Responsibilities:

• Analyze the initiatives requirements to develop the test strategies and test case efficiently and effectively
• Ensure that acceptance criteria for tasks are refined and can trace back to test scripts
• Following Agile methodology to validate the data loaded through ETL designs.
• Active participation in Sprint planning, Grooming, Demo, Retrospective session.
• Creation and execution of test cases through JIRA.
• Creation of mock files/jsons for validating the requirements.
• Responsible for Automating the Validation Process for projects using Microsoft SQL Server, IBM Data Studio, TOAD for SQL, SSIS, SOAP API.
• AWS 53 File Manager and other tools such as PUTTY, FileZilla.
• Validating the SSIS packaging product through SQL.
• Validation the transactions through SOAP and REST API.
• Writing SQL Scripts to avoid manual validation process to improve quality efficiency.
• Make sure to meet the requirement traceability with the automation process for various domains and teams.
• Process the test data files using the S3 File Manager/ PUTTY tools
• Write SQL Queries to retrieve data from SQL database using Microsoft SQL Server database management tool to make sure file(s) being processed appropriately.
• Perform the requirement gap analysis to make sure existing functionality not breaking while adding new features with more complicated schemas and large file data processing
• Perform root cause analysis on defects and continuously enhance validation scripts and process to cover various use cases.
• Participate in daily stand ups and coordinate with the team members on a daily basis and aid as a mentor on technical aspects by directing them through WebEx sessions.
• Perform root cause analysis on defects and continuously enhance test cases to cover various use cases in Jira and Confluence.

Environment: JIRA, Microsoft SQL Server database, TOAD for SQL, SSIS, UNIX, Putty, FileZilla, WinScp, Soap UI, Confluence, AGILE, Notepad++, MS offices.

Confidential, Jacksonville, FL

Senior QA analyst

Responsibilities:

• Work closely with Business & System Analyst, Technical Architects to gather and validate requirements for Confidential Clinical Project
• Analyze the Clinical team initiatives requirements to develop the test strategies and test case efficiently and effectively
• Research automation feasibility for the optimal process by gathering existing requirements.
• Contribute to make sure all the requirements are covered in the architecture by doing Proof of concept.
• Ensure that acceptance criteria for tasks are refined and can trace back to test scripts and scenarios that communicate project objectives to both technical and non-technical stakeholders.
• Track the requirements using Requirements Traceability Matrix (RTM).
• Bigdata Hadoop Technology HIVE DB, SQL Development, IBM Data Studio, Spark-SQL
• Perform validation for Clinical transactions in Postgres DB.
• AWS S3 File Manager and other tools such as PUTTY, FileZilla.
• Validations performed on data landed through real time data pipeline through HDFS (Hadoop Distributed File System)
• Writing SQL Scripts to avoid manual validation process to improve quality efficiency.
• Automating Test Data Preparation for Complex Schema file(s) (JSON and XSDs) to which are received from Various Domains which is used in Clinical projects for Streaming and Batch Process thereby avoiding manual effort.
• Make sure to meet the requirement traceability with the automation process for various domains and teams for Clinical projects.
• Process the test data files using the S3 File Manager/ PUTTY tools
• Performs database validation using Hadoop to confirm data integrity.
• Write SQL Queries to retrieve data from SQL database using HIVE database management tool to make sure file(s) being processed appropriately.
• Preparation of test cases for the various elements of the data involving XMLs, EDI transactions, SOAPUI, Mainframe, Oracle and User Interface portions.
• Involved in WebServices Testing using SoapUI tool. Validated request and response XML
• Execution of Mainframe jobs through JCL. Experience with procedures, parameters, cobol.
• Perform the requirement gap analysis to make sure existing functionality not breaking while adding new features with more complicated schemas and large file data processing
• Review application code as defined by high-level requirements and coding standards by utilizing development techniques.
• Perform root cause analysis on defects and continuously enhance validation scripts and process to cover various use cases.
• Participate in status calls to coordinate with the team members on a daily basis and aid as a mentor on technical aspects by directing them through WebEx sessions.
• Perform root cause analysis on defects and continuously enhance test cases to cover various use cases in HP ALM / Rally.
• Review application code as defined by high-level requirements and coding standards by utilizing development techniques.
• Leading the QA team on effort, test approach, review, defect analysis and resolution.
• Provide regular updatesto theteam lead and project manager on project progress and outstanding issues.

Environment: HP ALM, IBM Data Studio for DB2, HIVE database, TOAD, SPARK-SQL, Scala, Postgres, Beeline, Mongo DB, SOAP UI, XML, Webservice testing, HDFS (Hadoop Distributed File System), Mainframes, UNIX, Putty, FileZilla, WinScp, Soap UI, Notepad++, MS offices.

Confidential, Jacksonville, FL

Senior Test Analyst

Responsibilities:

• Analyzing the requirements and tickets to develop the test strategy.
• Interaction with Business Analyst in reviewing the requirements that has been made in the use case.
• Preparation of test scenarios based on the requirements and functional Specifications in HP ALM.
• Preparation of artifacts like test plan, HLD, LLD, test cases.
• Preparation of test cases for the various elements of the data involving XMLs, EDI transactions, SOAPUI, Mainframe, Oracle and User Interface portions.
• Used complex SQL queries as part of back-end testing to validate the data.
• Involved in the Test Case walkthroughs, assessment meetings.
• Analyzing the logs created during testing.
• Creating of XMLs for the individual elements of the testing.
• Analyzing the success and failure messages created while executing the XML.
• Prepared and manipulated Test Data for various scenarios identified.
• Closely worked with all the various development teams involved for the various elements of the project.
• Analyze the data/messages received through XMLs, EDI transactions.
• Conducting daily defect calls involving testing and development teams to track the defects.
• Involved in system testing and UAT. Direct interaction with Business users during test scenario reviews and during UAT testing.
• Reported all the instability in the environments to the development team and coordinated in bringing them back to stable
• Leading the QA team on effort, test approach, review, defect analysis and resolution.
• Regular updation of progress of the team to manager.

Environment: Mainframes, Oracle, Toad, HP ALM, SharePoint, SOAP UI, Windows XP, EDI System Integration

Confidential, Jacksonville, FL

Senior Quality Analyst

Responsibilities:

• Analyzing the requirements and tickets to develop the test strategy.
• Involved Business & functional necessity documents and recognized test scenarios.
• Involved with projects which follow both Waterfall and Agile methodologies.
• Interaction with Business Analyst in reviewing the change requests and tickets that has been made in the use case.
• Review of test scenarios and test case created by the team members and providing feedback.
• Used comprehensive SQL queries as part of back-end testing to validate the data that appears on the UI.
• Involved in the Test Case walkthroughs, assessment meetings and test data preparation.
• Performed UI and database testing using SQL queries to check the data updates through manual scripts.
• Developed a Test cases based on functional Specifications in Quality Center
• Creating of XMLs using SOAP UI for UI screens testing purposes.
• Involved in working together with development team to resolve the difficulties during test execution.
• Conducting daily defect calls involving testing and development teams to track the defects. Contributed in regular status meetings to state any bugs, problems and risks
• Involved in providing valid inputs and testing for team’s dependent on data provided by us.
• Creation and validation of Mainframe files created with data for testing purposes.
• Involved in system testing and UAT. Direct interaction with Business users during test scenario reviews and during UAT testing.
• Active involvement in daily Sprints and status updates in Agile project.

Environment: Mainframes, Oracle, SQL, Quality Center, Java, JIRA, SharePoint, SOAP UI, Windows XP

Confidential, Jacksonville, FL

Technical Lead Data Analyst/QA analyst

Responsibilities:

• Analyzing the requirements and developing the test strategy.
• Involved Business & functional necessity documents and recognized test scenarios.
• Interaction with Business Analyst in reviewing the mapping document
• Review of HLD, LLD, test plan and test case done by the team members and providing feedback.
• Participated in implementing test-plans and test-cases built on high-leveled and detailed design.
• Usage of tools like Informatica and Teradata to check the data flow and validate them from source to destination
• Broadly done manual testing, constraints verification testing, and the functional testing.
• Used comprehensive Teradata queries as part of back-end testing to extract data (ETL process) from various tables to compare the actual results from the application.
• Developed a Test cases based on functional Specifications in Quality Center
• Involved in the Test Case walkthroughs, assessment meetings.
• Database Testing to identify the discrepancies in field mapping and Boundary Conditions
• Involved in the internal testing of the Informatica code in order to rectify the defects identified
• Involved in audit meetings and got an initiative to reach QA testing goals.
• Involved in the optimization of the queries using Teradata
• Contributed in regular status meetings to state any bugs, problems and risks
• Contribution to regular status meetings
• Regular meeting with the team members to discuss the progress and issues.
• Onsite/Offshore coordination in involving the team through all the phases of the project and communicate the requirements, changes and progress of day to day activities

Environment: Mainframes, Informatica, Teradata, UNIX, Quality Center, Sharepoint, Windows XP

Confidential

Technical Lead QA analyst

Responsibilities:

• Analyzing the requirements and developing the test strategy.
• Involved Business & functional necessity documents and recognized test scenarios.
• Requirement Analysis activity to establish a common understanding between the customer and the software project team that will address these requirements
• Lead the estimation of efforts and involve the team members for the same to fetch their input
• Test planning to strategize, plan and document the test cases from the high-level scenarios to ensure that all the requirements are exposed. Various Test Artifacts like Test Strategy, Master Test Plan, Test Cases and Traceability of test cases to Business Requirements Document, High/Low level Design documents are delivered
• Review of HLD, LLD, test plan and test case done by the team members and providing feedback.
• Testing activity to execute the identified test cases as per priority in the SIT, UAT Environments. Also perform sanity testing in various environments where the code gets promoted. Assignment of test cases in SIT, UAT environments to team members and tracking the same
• Executing manual test procedures, verification / validation test procedures
• Performed back end testing in SQL server for various submit functions of the application.
• Maintenance of separate task, defect, resolution and completion status for the team.
• Contributed in regular status meetings to state any bugs, problems and risks
• Reports would be generated at a periodic basis in order to show constant progress in the test execution
• Used Quick Test Pro to test web application
• Actively involved in sanity testing of the environments to ensure the environments are always stable
• Reported all the instability in the environments to the development team and coordinated in bringing them back to stable
• To document each and every completed/failed/pending test scenarios to improve quality
• Onsite/offshore coordination activity to communicate to offshore team about the project developments in a timely manner. Review of activities performed on a daily basis, documented artifacts, test artifacts

Environment: Windows XP, SharePoint, HP Quality Center, SQL, QTP