SUMMARY

• Quality Assurance professional with over 8 years of IT experience with focus on Healthcare, Finance (Mortgage), Power & Utility, Supply Chain Planning and Property and Casualty Insurance domains.
• Experience as Test Lead leading both onshore and offshore sprint testing teams.
• Experience in handling Agile and Scrum meetings, which includes Sprint Planning, Daily Scrums or Standups, Sprint Check - In, Sprint Review & Retrospective.
• Experience on Waterfall, V-Model, and Agile methodologies Worked in agile management methodologies - Able to handle Projects for QA activities, known for high-quality deliverables that meet or exceed timeline. Agile processes with sprint planning and execution.
• Experienced in creating Test Cases, Test Scenarios, Traceability Matrix and Test Scripts for testing process. ETL testing from source to target data flow.
• Experience to understand & translate business requirements into test scenarios, traceability matrix & test cases.
• Expertise in taking the functional requirements & convert the use case into test case by adding specific data to a scenario.
• Expert in handling and leading User Acceptance Testing (UAT), Integration Testing and System Testing.
• Incident Triage and Daily Incident & Problem Management meetings.
• Experience in the entire Software Development Lifecycle (SDLC), STLC (Software Testing Life Cycle) and Defect Life cycle from requirements gathering to releasing to production.
• Experience in testing with Web based application, SOAP UI using XML, SQL and Data bases.
• Experience in backend testing, querying database and writing SQL queries.
• Experience in testing using ETL tool Informatica Power Center.
• Experience in using bug-tracking tools like HP ALM, Quality center and Test director.
• Experience in Defect Management Guidelines, Test Execution process, High-level Schedule including timelines, Test tools, Status Reporting, Defect Metrics, Quality checkpoint & Risks.
• Experience in working with Interactive Voice Response (IVR).
• Experience & exposure in coordinating role to determine the business & test team members for the roles, plans & tasks.
• Actively communicating with software development teams and other organizations to ensure their needs are being met and to resolve technical issues.
• Ability to work in tight schedules and efficient in meeting deadlines.
• Provided Training to end users for using the application installed on Client side.
• Ability to learn new technologies and challenging concepts quickly and implement them.
• A resourceful, fast learner with a proven ability to work in a fast paced and rapidly changing environment including the capacity to handle pressure coordinating multiple tasks in a project environment.

TECHNICAL SKILLS

Testing Tools: Quality Center 9.0 and above, HP ALM, Test director, TFS, Jira, Bugzilla, Clear Quest, Service now

Database Tool: Oracle 11g/10g/9i/8i, DB2 UDB, Ms-Access, SQL, TOAD, DB Visualizer, PLSQL Developer, SAS DataFlux, Erwin, ETL Tool Informatica Power Center 9.1/8.6

Tools: Internet Explorer, Google Chrome, MS Office, MS Visio, SQL*Loader, MS Project, Putty, ALM

Methodology: Agile, Scrum, Water fall, V-Model

Legacy: Facets, Mainframe

Operating Systems: Windows 95/98/2000/NT/2003, UNIX (LINUX, Solaris, AIX, HPUX)

Protocols: HTTP, FTP, sFTP, SOAP

PROFESSIONAL EXPERIENCE

Confidential, Rancho Cordova, CA

Sr. QA Analyst

Responsibilities:

• Analyze the User/Business requirements, Functional specs and create the Test Plans, Test cases for Functional and UAT testing.
• Coordinate with the business analysts, developers and discussed issues in interpreting the requirements.
• Actively participate in Functional, System Integration, End-to-End, Regression, and UAT testing.
• Generate the execution results and sent it across to the team, by way of gathering and analyzing the Test Metrics for reporting.
• Actively participate in the complete Test Set design and Execution.
• Test the interface data transmission using the SOAP UI over Hypertext Transfer Protocol, Secure (HTTPS) and Web Services Definition Language (WSDL).
• Testing the Security of the application using both Positive and Negative scenarios.
• Status reporting on the daily and weekly basis to Project Manager.
• Experience in Verification of Functionality of GUI Applications as well as backend testing of the Application.
• Used different joins on the tables to retrieve information from different tables in the database to check the database on a regular basis using SQL queries.
• Participate in other test planning meetings and submitted test metrics to the management on a weekly
• Worked with Production Support team to help diagnose any post implementation issues, fix bugs and support the production process on a daily basis.
• Using ALM for bug tracking and reporting followed up with the development team to verify bug fixes, and update bug status.
• Involved in Mobile Apps Testing (iOS and Android).
• Conduct Cross-browser testing with Internet Explorer, Mozilla Firefox, Google Chrome and Safari
• Attend project meetings, release meetings, and QA status meetings.

Environment: Oracle, XML, SOAPUI, HP ALM, JConsole, Web Services, Linux, Jira, WSDL, Service now, Jenkins.

Confidential, Portland, OR

Sr. QA Analyst

Responsibilities:

• Analyzed the Business requirements / Features, Epics, and User Stories.
• Planned the schedule, Create, and review the sequence of QA activities, Estimate the activities, and consolidate the effort estimation for the identified tasks.
• Created Quality Plan, Test Scenarios, Test Cases, execute test cases, track issues to closure.
• Prepared the QA Effort estimate for the identified User stories and Change requests.
• Wrote SQL queries to compare the data between Facets and IBM DataStage.
• Coordinate between the Business team, Facets team, Integration QA team, Database team to ensure that the issues are addressed on time.
• Monitor & track the test execution to identify the risks and issues to be addressed pro-actively.
• Ensure that the Rally is updated with current progress.
• Coordinate the SIT and UAT Defect triage meetings with the required stakeholders.
• Prepare the Defect Causal Analysis for SIT and UAT Defects.
• Analyze the Production incidents and assign the Incidents to appropriate team/ person.
• Document the corrective and preventive actions as part of continuous process improvement.

Environment: IBM Datastage, Oracle, HP ALM, Pitney Bowes.

Confidential, Pleasanton, CA

QA Lead / Onsite Project Lead

Responsibilities:

• Understanding the requirement by analyzing Business requirement document, detailed design document,and Feature brief document and discussing with the business people of the client.
• Involved in Project Management activities like reporting and mail communication. Provide technical assistance in identifying, evaluating, designing and specifying systems and procedures that are cost effective, efficient and meet business requirements and CORE goals
• Worked with ETL group for understating ETL tool Informatica power center, sources systems including SQL Server, Oracle, Teradata, and Flat Files Offer business support, define business requirements and analyze project impacts
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data.
• Involved in writing and implementation of the test plan and developed test cases and Test scripts in Quality Center (ALM).
• Testing (SIT) all Kaiser Regions and attending meetings with the client, closely working with developers, business teams.
• Provided excellent support for ad-hoc work and on-call support.
• Effective communication with different regions teams and dealing with issues candidly.
• Reviewed the test cases for completeness and correctness.
• Understand the Flow of Execution, executing the functional test cases.
• Perform test execution on different test environments. Perform Backend and Functional Testing.
• Upgrading from MSSQLServer2012 to MSSQLServer2014
• Coordinate with the development team to resolve issues related to build releases, defects, etc.
• Providing suggestions on improving testing areas (testing process & testing of s/w)
• Following up the issues with the QA team. Bug Verification and retesting.
• Attended status meetings and provided astatus report. Provide technical expertise on data modeling, data warehousing, and data
• Validated and Verified XML files for KP.org process.
• Experienced in tested Web Services module.
• Used MS SQL Server Management studio for creating and executing SQL Queries
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2
• Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports
• User acceptance testing was done and finally signed off the project.
• Investigated and fixed problems encountered in the production environment on a day-to-day basis.
• Identified and recommended training required for the testing effort
• Detailed analysis of mapping business logic and issue management for related source systems.

Environment: ETL tool Informatica Power Center 8.6/9.5, Data Profiler, SQL, TFS, SQL Server 2005/2008, XML, Web Services, TOAD 9.2, Jira, Quality Center 9.1, Quality Center (ALM), Service now, Toad for Oracle 11g, AUTOSYS, DB2, Sql Server Management Studio, Microsoft Office.

Confidential, Des Moines, IA

SQA Analyst

Responsibilities:

• As an SQA Analyst developed test plan & test procedures for Mainframe & Web-based applications based on functional requirements, analyze and validate results from procedure executions and performed regression and functional software testing
• Reviewed and translated the system requirements into system test elements like modular test scenarios, scripts and test cases for the Selling system components like Loan Modification, Modify Loan, Evaluate Loan and others using Quality Center.
• In coordination with System Analyst, Project Manager and Business Analyst reviewed and suggested updates to Business Requirement documentation for Mortgage procurement system.
• Created aTraceability Matrix to ensure that all the requirements are covered by the test cases.
• Developing Test Plan, Test scenarios, Test cases, Test Scripts, and Traceability Matrix.
• Performing System Integration Testing, Functionality, GUI and Security Testing.
• Involved in Daily status meetings.
• Performing back end testing by executing SQL queries.
• Create and execute SQL queries to fetch data from Oracle database to validate the UI Data.
• Involved in the documentation of the whole QA process.
• Validated XML response and request using XML transaction viewer.
• Ensure that all projects were delivered on time and were in accordance with company guidelines and specifications
• Coordinated with developers and analysts for gathering requirement and documented in the test strategy.
• Quality Center (ALM) for analyzed, documented Test strategy, tracking and bug reporting.

Environment: HP ALM, Quality Center 9.1, MS Office, MS SQL Server, Java, Oracle 11g, Mainframe (MSP), XML Viewer, Web services, SOAP UI.

Confidential, Las Vegas, NV

Sr. QA Consultant

Responsibilities:

• Reviewed and analyzed the Business Requirement Documents and Technical requirement documents.
• Participated in writing High-levelTest plans, Unit test plans, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results
• Developed detailed Testing Methodologies, Test Matrices, Test cases, and Test Procedures.
• Writing test cases to test the functionality of the application manually and using Quality Center.
• During testing, errors were Entered, Tracked, reported, and Analyzed using Quality Center.
• Created the Execution result sheet, Execution plan, Completion report documents for Functional testing.
• Worked with Developers, Business analysts and Project managers to determine requirements (H/W specs, Test Cases, Test Data).
• Also took part in the daily standup meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail.
• Manually performed functional, Integration, System, Customer Production / Issue Fix Testing and Regression testing.
• Manage browser page testing that included testing the properties of the objects on the Web Page, input forms, field validations etc.
• Manage Cross Browser Testing using Firefox, Safari, Opera and Internet Explorer with different Browser Versions
• Performed Support & Maintenance Testing for Customer CSR’s.
• Involved in the process of Knowledge Transfer and Training to the client-side employees and thus helped they understand the complete end-to-end testing scenarios.
• Discussed issues on various bugs and attached screen shots of defective screens using Quality Center.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• Analyzed and helped in modifying the use cases using MS Visio and created the Test cases based on them.
• Used TOAD for SQL Query from Oracle database.

Environment: IBM Maximo 7.5, P6, Business Objects 4.0, Java, J2EE, Oracle 11g, Toad, SQL Developer, Web Logic Server, Windows 2003/2008, ETL tool Informatica Power Center 9.1., Quality Center 9.0

Confidential, Milpitas, CA

QA Analyst

Responsibilities:

• Developing atest plan and test strategy.
• Review of the test cases written for unit and integration level.
• Integrating the test scripts written for an individual unit.
• Developer scenarios to help find out the bottlenecks of resources and capacities in Confidential supply chain.
• Monitor daily Supply Chain Planner and Factory Planner workflow for fill rate report.
• Writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Performed data validation testing writing SQL queries.
• Participate in Bug review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and Oracle stored procedures to meet business requirements.
• Programmed shell scripting, run batch jobs.
• Testing and monitoring Informatica Mappings for data transfer from SAP to MDM to ODS.
• Analyze and write detailed specifications and Test Requirements using Test Director.
• Writing Test scripts and functions wherever necessary for various units of the business modules.
• Worked with the Production Support team to help diagnose any post-implementation issues, fix bugs and support the production process on a need basis.
• Effective coordination between the development team and testing team.
• Monitoring Data Loads and the whole production workflow.

Environment: ETL tool Informatica Power Center 8.6, Windows XP/7, SAP, i2 SCP, PL/SQL developer, Unix, Oracle Database, SQL, MS Office, Putty, MS Visio, GECS, CPS.

Confidential, Indianapolis, IN

Data Analyst

Responsibilities:

• Understanding the data structure and organization oftheLiberty Mutual agency system to successfully integrate it with Safeco agency system.
• Assisting in the implementation of QA processes to ensure the correctness of data flowing through each stage of the Informatica based ETL process.
• Testing and debugging Informatica mappings and associated scripts.
• Participating in the requirements, design, and release readiness reviews.
• Creating and maintaining test documentation and test plans.
• Working with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Analyzing the transactional data in DB2, SQL and other source systems using Data Profiler.
• Used (DataFlux) dfPower Studio to examine the structure, completeness, suitability, and relationships of Information Assets.
• Worked on Data Standardization, Data inconsistencies and eliminated data reduplication.
• Built transformations, configured servers and established connections to various sources and targets.
• Reviewing of work delivered by the team to ensure quality standards and completeness of requirements.
• Wrote queries for data extracts and data sweeps in DB2 as per the client requirements.
• Works on scheduling allocating work, tracking and ensuring on-time completion of work.
• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Responsible for providing weekly offshore status updates.

Environment: ETL tool Informatica Power Center 8.6, Informatica Analyst 9, Informatica Developer, DB2, Mainframe, SAS DataFlux 8, HP Quality Center, Toad 9, DB Visualizer, MS Access