SUMMARY:

• Proven expertise in Requirement Analysis, Manual, Automation Testing, Project Coordination, Client Interaction and User Acceptance Testing.
• Complete understanding of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC) including Integration/System Testing, Performance Testing, Regression Testing, Functional and User Acceptance Testing for web and windows applications.
• Experience in software testing process including Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Highly proficient in working with users to gather requirements through Joint Application Development (JAD) sessions and Use case walkthroughs and functional requirement sessions.
• Actively participated in Scrum calls, Sprint Planning, and Retrospectives. Involved in the Daily / Weekly Status meetings with the Business, Developers, Testers and Project Managers.
• Good understating Database concept of OLTP, OLAP system and DWH methodologies of Kimball & Inmon’s. Normalization and De - normalization techniques such as Star schema and Snowflake schema, FACT & Dimensions tables. Experienced in Data Profiling, Metadata validation and S2T mappings.
• Communicates well with both technical and non-technical co-workers and customers, effectively manages multiple projects at once with strong presentation and customer service skills
• Basic Understating of Big Data/ Hadoop Framework HDFS, MapReduce, Hive, PigLatin, HBase, Scoop.

TECHNICAL SKILLS:

Methodologies: Waterfall, V - Model, Rational Unified Process (RUP), Agile (Scrum), Kanban-Agile Lean Project

Business System Analysis Techniques: BPMN, Activity Diagram, Block Diagram BDP, FURPS, Root Case Analysis (5Whys), Pareto Analysis, System Use Case, JAD, Structured Walkthrough, Use-Case Analysis, UML, MS (Word, Excel, PowerPoint, Outlook), MS Project, SharePoint

Quality Assurance: Software Application Testing Life Cycle, Knowledge of automation tools, HP Quality Center - ALM, QTP, Soap UI, Sauce Lab, Selenium, Jira, Confluence

Performance Testing: JMeter, Load Runner

Database/DWH: OLTP, OLAP, DWH Concept Kimball, Inmon, Data Mart, Normalization, Denormalization, Star Schema, Fact & Dimension. Oracle 11/g/9i/8, Sql Server 2012, DB2, Teradata

ETL Tools: S2T Mapping, Data Profiling, Matadata Validation, Data Models, Erwin, Powerdesigner, Informatica PowerCenter, SSIS, Talend

Languages: SQL, PL/SQL, HTML, CSS, Java, Java Script, Linux, XML SQL, PL/SQL, HTML, CSS, Java, Java Script, Linux, XML

Project Management: PM Process & Knowledge Area, Project Charter, WBS, Critical Chain Path, Stakeholder Management

Agile Framework: Agile, User Stories, Product Backlog, Sprint Planning, Daily Scrum, Brundown chart, Retrospective

BigData/ Hadoop: HDFS, MapReduce, Hive, Pig, Hbase, Scoop, Zookeeper, Flume, CHD5

PROFESSIONAL EXPERIENCE:

Confidential

Software Quality Analyst

Responsibilities:

• Created and executed End to End Use test scenarios as part of User Acceptance Testing. Monitored defect tracker for UAT testing status displaying testing results and
• Assist in User Acceptance Test efforts; coordinate with business users for test data, test scenarios, outline testing plan, and manage test effort thru signoff
• Design, develop, and execute test cases using test plans and functional specifications
• Develop test plans from design and requirements documents, consolidates scenarios, test cases and other input contributed by other team members
• Participate in software requirement, specification, and design reviews.
• Process / Load Files in QA / Staging environment using FileZila.
• Data Profiling and Data Validation for Backend database testing SQL Server
• Develops test scenarios, test cases and defect tracking for manual and/or automated testing tools using JIRA and Confluence for Defect reporting, tracking and Test Case Execution.
• Testing Responsive Web application using Sauce Lab for multiple operating systems, Browsers and Devices such as smart phone, tablets, desktop etc.
• Involved in testing the Web Services and validating the WSDLS in SOAP UI, preparing the Request XMLs and validating the Request and Response XML in SOAP UI Editor
• Perform deliverables tracking and reporting as assigned. Monitors progress of testing efforts to ensure deadlines are met
• Performed ETL and Database testing, wrote SQL queries, SQL Loader scripts and executed stored procedures for validating data.
• Involved in writing SQL queries to validate test results in both front-end validation as well as back end validation.

Software QA Analyst / Lead QA

Responsibilities:

• Collaborated with Product Management, QA team and Development to produce proper design, acceptance criteria and test cases for each user story.
• Performed manual and automation testing and maintained documentation on different types of Testing viz. Positive, Negative, Functional, Regression, Integration, System, Compatibility testing for browsers, DB Testing, User-acceptance, Black Box.
• Responsible for defect tracking and reporting of defects found in testing, and owned defect resolution within the defined sprint.
• Involved in writing Sql queries to validate test results in both front end validation as well as back end validation.
• Performed ETL and Database testing, wrote SQL queries, SQL Loader scripts and executed stored procedures for validating data.
• Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project.
• Assisted in UAT, Defect Tracking and reporting

Software QA Analyst / Tester

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Identified the Test Cases and documented them in Quality Center.
• Participated in test plan and test cases review meetings.
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules.
• Tested Web services (SOAP and REST) using SOAP UI & HP Service Test and
• Followed Agile Testing Methodology for every release of project.

Environment: HP Quality Center 10, Quick Test Pro 10.0, ETL, SQL Server 2008 T-SQL and Windows 2008

Software QA Engineer / Tester

Responsibilities:

• Worked with Business users, Business system analyst and development team throughout the Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).
• Involved in Smoke, System and Regression Testing.
• Responsible for updating and maintaining the Quality Center for all the defects found during functional and regression testing and follow up the bug life cycle.
• Prepared testing data based on the use cases and extensively used SQL during backend testing.
• Involved in creating test cases and execution of test cases using Quality Center for creating, executing test cases and for reporting issues
• Involved in the Daily / Weekly Status meetings with the Business, Developers, Testers and Project Managers.
• Sending Daily / Weekly Status Reports to Test Managers, UAT Managers & Project Managers

Environment: HP QC, P/SQL. Oracle, HTML, CSS, Java Script. Windows.

Software QA Analyst/ Requirement Analyst

Responsibilities:

• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Developed Test Plans, Test Scenarios and Test Cases, Structured System Testing, software documentation from business, technical and functional requirement.
• Proficient understanding and demonstration knowledge of Medicaid, Medicare, EDI, ICD - 10, HIPAA 5010
• Created and executed manual and automated test scripts using established test requirements. Reviewed Functional Test Cases developed by the Team.
• Reported the bugs, Email notifications to the developers using Team share's problem tracking system, Team Track.
• Actively involved in the user acceptance testing (UAT), user interactive sessions and also with the Subject Matter Experts.
• Analyzed the Defect Reports and worked closely with Application Developers for resolution.

Environment: HP Quality Center, Oracle, P/SQL, XML, UNIX, JavaScript, HTML,