Post Job Free

Resume

Sign in

Qa Analyst Data

Location:
Jacksonville, FL
Posted:
October 04, 2021

Contact this candidate

Resume:

Murlidharan Venkataraman Balasubramanian 904-***-****

Senior QA Analyst adowta@r.postjobfree.com

https://www.linkedin.com/in/murlidharan-vb-7a115616/

Objective:

A challenging position in a dynamic organization with a potential for career growth and achieve excellence in the horizon of Quality through personal endeavors and teamwork.

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

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

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

EDUCATION:

Bachelor of Mechanical Engineering

WORK EXPERIENCE:

Florida Blue June 2016 - present

Jacksonville, FL

Senior QA analyst

Worked as a senior QA analyst in Florida Blue. Working on the data-warehouse application Information Management for Clinical data applications. This project involves the complete end-to-end testing for new and existing schedules for the centralized sales platform for Florida Blue. The project is carried over a hybrid model of Agile and Waterfall. Requirements are present as User Stories in JIRA and SRS. The code is developed over Spark platform and deployed through UNIX. The schedules are run through Control-M and the backend validation done through Big Data Hadoop. The test cases and defects are maintained in HP ALM/JIRA.

Responsibilities:

Leading the QA team on effort, test approach, review, defect analysis and resolution.

Work closely with Business & System Analyst, Technical Architects to gather and validate requirements for Florida Blue 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).

Perform validation for Clinical transactions in Bigdata Hadoop Technology HIVE DB, SQL Development, IBM Data Studio, Spark-SQL, 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 UAT testing coordinating with business partners and teams involved. Facilitate UAT test cases, test data set up, perform testing, report bugs during UAT cycle.

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 / JIRA.

Review application code as defined by high-level requirements and coding standards by utilizing development techniques.

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, AGILE, JIRA, Confluence, WinScp, Soap UI, Notepad++, MS offices.

CSX Corporation, Jacksonville, FL June 2014 - June 2016

Senior Test Analyst

Railroad Transportation Domain - Interchange Measurements

Responsibilities:

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.

Prepared and manipulated Test Data for various scenarios identified.

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.

Leading the QA team on effort, test approach, review, defect analysis and resolution.

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

Florida Blue, Jacksonville, FL Nov 2012 – June 2014

Senior Quality Analyst

Health Insurance domain - Enrollment, Billing, Finance, Fulfillment & Reporting capabilities for over 65.

Responsibilities:

Used comprehensive SQL queries as part of back end testing to validate the data that appears on the UI.

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.

Lead for QA team. Effort estimates, project status, daily reviews with team.

Involved in system testing and UAT. Direct interaction with Business users during test scenario reviews and during UAT testing.

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

Bank of America, Chennai, India & Jacksonville, FL Oct 2004 – Nov 2012

Technical Lead Data Analyst/QA analyst

Banking domain - Global Corporate Investment Banking

Responsibilities:

Team lead onsite QA

Usage of tools like Informatica and Teradata to check the data flow and validate them from source to destination

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.

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



Contact this candidate