SUMMARY:

• 9 years of IT experience in managing software testing efforts for Banking, Health Care and Wireless domain applications.
• Expertise in testing Data Warehousing jobs (Informatica, SSIS, DataStage) and applications, Business Intelligence reports (OBIEE, SSRS, Micro Strategy, Cognos), Java based applications, Quality Assurance and management, Risk, Compliance, Data management, Internal audit and Enterprise risk management projects and programs.
• Experience with testing various EDI transactions.
• Expertise testing health care related data like Claims, Medical, Risk, Prevention data. Experienced working with HIPAA, ICD9 and ICD10 codes, Health care Facets.
• Sound understanding in Software Development Life Cycle (SDLC), Project Management Life Cycle (PMLC), Rational Unified Process (RUP), Waterfall, Spiral, RAD, V Model and Agile models and iterative model and associated artifacts starting Business Case, ROI, Design, Test and Implement.
• Involved in the Process changes like Change Management (CM), Change Request (CR) and implementing industry best practices using tool like Clear Quest.
• Experienced in Test Life Cycle, Reviewing requirements using DOORS, Planning tests, Documentation, Execution and Defects
• Expert in planning and executing Smoke, Functional, Integration, Regression, User Acceptance Testing, Compatibility Testing for Java and .net based web application, Data Warehouse Application; UNIX based applications and Client Server applications.
• Experience testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys.
• Very good experience working with UNIX commands and UNIX Shell Scripting.
• ConfiguredTest Environment Management (TEM) for specificTest Cases, createdtest data, executedautomated or manual unit tests, document results and updateddefect - tracking systems.
• Experienced in writing detailed Test Plans, Test Strategy, Test Data Management Plan and maintained Test Readiness Reviews (TRR) for large releases, application enhancements, maintenance releases and defect fixes for various applications.
• Knowledge in creating Business Scenarios, Test Scenarios, Test Cases for System, Integration, Regression using HP Quality Center and User Acceptance Testing.
• Maintained and updated Requirements Traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness and Internal Audit (IA)
• Ability to independently develop, maintain and execute Test plans and Test scripts.
• Managed all testing artifacts in HP Quality Center, TFS (Team Foundation Server), utilized the same for test execution and reporting.
• Expert in writing Complex SQL quires for backend testing and created several queries on the fly for user specific requirements for trouble shooting day to day production issues to identify root cause.
• Experienced in analyzing Data Flow Diagram (DFD) and Data Model, Entity relation shop diagrams.
• Performed well under stress, working with multiple applications testing concurrently, coordinating QA activities with various teams and supported project management teams in release activities.
• Coordinated Release management for Application Maintenance Releases and Production Defects fixes.
• Ensured SDLC standards and application quality goals met by Quality Assurance Testing strategy.
• Excellent communication, coordination and interpersonal skills.
• Experienced in leading Software Testing projects and expert in coordinating testing effort between On Shore and off shore teams.

TECHNICAL SKILLS:

Methodologies: RUP, UML, Agile Modeling, SDLC model, Waterfall Model

Requirements tools: Rational Requisite Pro, DOORS

Data modeling and Design: ER Diagrams and MS VISIO, ERWIN

Languages: SQL, PLSQL, XML, T - SQL

Databases: Oracle11g, MS SQL Server 2012/2008/2005 , DB2, Teradata

T esting Tools: HP Quality Center / ALM, QTP, TFS, JIRA

Operating Systems: Windows 95/98/2000/XP, UNIX, Linux Defect

Management Tools: Rational Clear Quest and HP Quality Center / ALM

ETL Tools: Informatica, DataStage, SSIS

Reporting Tools: OBIEE5, Micro Strategy, Cognos, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge, NJ

Quality Analyst

Responsibilities:

• Participated daily Lead Team stand up meeting with management to provide daily status of team in terms of testing efforts, to escalate any blockage, and risk issues team is facing.
• Wrote Test Cases, and developed Test Conditions based on BRD, SRS, FDD and Use Case Documents.
• Reviewed Test Cases written by team to ensure quality of the test cases and to make sure the requirements are fully covered with all possible cases or scenario without duplicating the efforts.
• Uploaded all final test cases to ALM with excel add ins.
• Designed and Developed Test Cases and Test Scripts from SRDs, BRDs, TDD’s and documented them in ALM (Application Lifecycle Management).
• Involved in Regression testing using ALM, Siebel for Eligibility and Enrollment
• Wrote SQL queries in Toad for backend testing, Verification and Validation.
• Interacted with the developers daily to identify the root cause of the issue found in production and resolving the reported bugs by State or raised internally by team and various technical issues.
• Worked on HIPAA EDI 834 use cases and collaboration templates according business requirements.
• ConfiguredTest Environment Management (TEM) for specificTest Cases, createdtest data, executedautomated or manual unit tests, document results and updateddefect-tracking systems.
• Responsible for designing Test Steps, Requirement Mapping to Tests, Executing Tests manually, Defect Logging and Defect Reporting.
• Organized and attended walkthrough for the Technical Design Document with the Solution / Development team.
• Analysis of Business and Requirement Specifications. Designing Test Lab and formulation of Test Strategy, Test Plans and Test Cases in RQM for the Functional, Integration, end-to-end, Usability, Security and smoke testing.
• Expert understanding of the business process and verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• Performed cross platform and cross browser Testing.
• Raised defects and assigned to Development teams with appropriate severity levels.
• Worked closely with developers to resolve the technical issues to meet the dead lines.
• Conducted weekly batch testing to in corporate changes in new builds.
• Provided the management with test metrics, reports, and schedules.
• Participated in Daily/weekly status meetings, conducted walkthroughs, documented proceedings.

Environment: Siebel, ALM, Unified Functional Tester, JIRA, Oracle, PUTTY, MS-Office, Agile methodology.

Confidential, Rensselaer, NY

QA Tester

Responsibilities:

• Involved in requirements analysis, identification, and documentation of required system and functional testing efforts for all test scenarios (Positive and Negative).
• Involved in Cross Functional, End to End testing for 834 in different releases logged related defects and resolved them.
• Wrote complex queries on Oracle and DB2 database for data validation, tested the Java web interface application with the legacy Mainframe programs.
• Reviewed Use cases test critical areas of application.
• Created test cases for Smoke testing, System testing and Regression testing.
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Verified the application outputs like reports on the different browsers like Safari, IE, Chrome and Firefox.
• Various versions of the documents generated during the project were maintained and managed usingRational Clear Case.
• Testedthe final application forUsabilitytestingto verify whether all the User Requirements were catered to by the application
• Tested all HIPAA transactions for multi version support (4010 and 5010) and validating the database to file elements.
• Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility Transactions.
• Traced Requirements using Requirement Traceability Matrix.

Environment: Toad, SQL, PL/SQL, DB2, Autosys, Windows XP, QTP, SQL Server2005, Crystal Reports, Cognos, Rational Clear Quest, Rational Clear Case, MS Office, EDI.

Confidential, Bloomfield, CT

ETL Tester / Web QA Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level documents (BRD & FRS).
• Involved in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
• Analyzed customer and business needs to determine business and functional requirements.
• Gathered and documented business requirements for system gaps that require development in credit card project.
• ConfiguredTest Environment Management (TEM) for specificTest Cases, createdtest data, executedautomated or manual unit tests, document results and updateddefect-tracking systems.
• Participated in functional requirement reviews and code reviews.
• Analyzed existing business processes and provided recommendations for improvements and efficiencies in credit card project.
• Worked with Business Analyst and Developer to resolve the defects.
• Designed and developed Use Cases, Use Cases diagrams, Activity Diagrams, Sequence Diagrams.
• Extensively involved in testing the application developed in Agile Methodology and detailed designs.
• Analyzed the user/business requirements and functional specification documents.
• Analyzed and optimized the use cases and created the Test cases based on them for Change Requests.
• Have leaded small offshore team to develop Test Plan and Test Script.
• Validated the responses of web services by passing various requests using Soap UI.
• Parameterized the variable for test cases, test suites, projects by using Groovy script.
• Created different assertions in Soap UI for the request coverage, to confirm that all the expected parameters are coming in the response.
• Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
• Validated SSIS and SSRS packages according to business and functional specification documents.
• Validated the custom reports developed in Cognos Report studio, validated the adhoc reports in Cognos Query studio, and multi-dimensional cubes in Cognos Analysis studio.
• Have tested scheduler scenario on Autosys.
• Validated the Informatica workflows according to business requirement documents.
• Used Informatica workflow manager to run the workflows and workflow monitor to verify their status and logs.
• Widely experience in verify the log of ETL jobs.
• Validated the SSAS cubes for various dimensions.
• Validated the Data warehouse(DWH) Table structure part of ETL testing
• Execute batch processing and verify the ETL jobs status and data in database tables
• Validated parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Tested all the rules which implemented during ETL job move data from source to target Data Warehouse(DWH)
• Developed complex SQL queries to test ETL jobs source to target Data Warehouse(DWH)
• Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center.
• Created and executed different types of test cases for the Change Request and existing functionality of the application.
• Responsible for checking of data in database by writing and executing SQL statements.
• Extensively involved in testing the application developed in Agile Methodology
• Involved in meetings with Automation team for Development of Automation Scripts for Change requests to run the along with regression tests suites of business priorities on Loan Application.
• Involved in backend testing using UNIX commands.

Environment: HP ALM, Oracle 11g, AS 400 IBM iSeries DW, Informatica Power Center 9.5, SQL Server 2012, SSIS, SSRS, SSAS, Autosys 11, Toad 10.0,WinSCP, Cognos 10, Soap UI, UNIX, DB Visualizer 10.0, VB Script, Windows Web Services, SQL, PL/SQL, Java, XML

Confidential, Salt Lake City, UT

ETL / DWH / Web Interface / BI QA Analyst / Data Analyst

Responsibilities:

• Reviewed business requirements (BRD), application requirements (SRS), Use Cases, System Module Specification, System Interface Specification, System architecture diagram.
• Also reviewed data flow diagram, data model to better understand cube/dimension presentation.
• Prepared test data/mock data for identified scenarios, submitted remedy ticket/ work order # to coordinate with DBA’s to migrate production data into System Integration Testing environment.
• Created quality assurance readiness review document and reviewed with stakeholders and project management teams before test execution.
• Created test cases for Smoke testing, System testing, Functional testing, Regression testing and User Acceptance Testing.
• Assisted in System and User Acceptance Test Plan for Mortgage Application release 081,082 and 091.
• Created System test scenarios and User acceptance test scenarios to test all mortgage application releases.
• Proficient using QMO ( Quality Management Office).
• Used QMO to organize and conduct the quality assurance of software.
• Used QMO to organize the process, define the areas that need improvement and recommend changes that will ensure success when a product is launched.
• Assisted load testing team with functional scenarios of the final mortgage application.
• Stored and managed test cases in HP Quality Center for multiple releases, baseline and used for Regression testing and System testing.
• Verified the application outputs like reports on the different browsers like Safari, IE, Chrome and Firefox.
• Validated the rest, soap web services using Soap UI.
• Validated the Envelope, Encoding rules, and communication styles in the response of web services using Soap UI.
• Tested the customer service application supporting tips for the different browsers.
• Tested the customer service application functionality and modules, roles and responsibilities.
• Created Regression test sets in Quality Center Test Lab module and executed the same for Regression testing.
• ETL - Data extraction process, transformation and loading from PeopleSoft GL.
• Used Informatica workflow manager to schedule and execute the workflows, Informatica workflow Monitor to identify the status and to verify the session and workflow logs.
• Validated PL/SQL Packages, Procedures, and Functions by writing PL/SQL functions and Anonymous blocks.
• Tracked, logged, and drove defects to resolution, enhancements using Rational Clear Quest and taken care that the defect life cycle was followed.
• Validated reports generated by reporting tool.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Validated PL/SQL, UNIX, ETL batch jobs scheduled using Autosys.
• Utilized DOORS as a requirement repository (RTM) and synchronized with Quality Center
• Created test status reports throughout the testing life cycle using quality center, reports and graphs, test case execution data and communicated to stake holder project management team.
• Validated Customer facing and Ad hoc reports developed in Oracle OBIEE.
• Trained business users in various occasions about application enhancement quality assurance tools such as rational clear quest, quality center and QA industry best practices.
• Logged and drove defects to resolution using rational clear quest for multiple releases.

Environment: HP Quality Center 10, DOORS, Informatica Power Center 8.6, Agile, OBIEE Reports, Oracle 11g, Toad, Autosys, MS Office, Rational Clear Quest, MS Visio, MS Project, XML, SQL, PL/SQL, UNIX, Putty, Soap UI.

Confidential, Miramar,FL

ETL / DWH / BI QA Analyst / Web Tester / Data Analyst

Responsibilities:

• Reviewed requirements document such as BRD, DMS and design document and other artifacts to better understand the process, its underlying data.
• Actively reviewed business requirement to identify ambiguous and unclear requirements, worked with clarify those items.
• Utilized and managed the requirements from DOORS.
• Created detailed test cases independently to test web application created using java for internal and external purpose.
• Used CAST to convert the datatypes in Teradata.
• Involved in testing the functionality of Ab Initio ETL graphs based on data mapping requirements and Entity relationship diagrams.
• Conducted Smoke testing, Regression testing, System testing, and End to end testing and User Acceptance Testing.
• Responsible in testing Initial and daily loads of ETL Ab Initio graphs.
• Written SQL queries to validate Ab Initio graphs and transformations.
• Debugged and scheduled Ab Initio ETL Jobs/Mappings and monitored error logs.
• Validated Autosys batch schedule jobs which schedule PL/SQL, ETL jobs.
• Performed cross browser testing for this web application with Safari, Opera, Chrome, Firefox, Internet Explorer and Mobile browsers (different versions).
• Validated various Micro Strategy reports which are of tabular format, Cross tab format, ad hoc reports.
• Coordinated with business analyst and business users to conduct user acceptance testing.
• Customized critical test cases for business user execution during the UAT.
• Created test case result document for all the testing.
• Validated XML files as part of system testing and compared the data with database.
• Identified defects in system testing, end to end testing, regression testing logged these defects using Rational Clear Quest with proper severity and priority and performed defect life cycle.
• Worked with automation team to develop automation regression testing framework and automation regression testing QTP scripts.
• Performed database testing using SQL queries with joins, unions, arithmetic and aggregate functions.
• Extracted requirement for enhancements using DOORS.
• Created test status reports, summary reports and communicated accurate progress to stakeholders.

Environment: HP Quality Center 10, Teradata, Toad, SQL, PL/SQL, Autosys, Windows XP, SQL Server 2008, Micro Strategy, Ab Initio, Rational Clear Quest, Microsoft SharePoint, Unix Scripts, Unix, Agile

Confidential, Denver, CO

ETL QA Analyst / UAT Tester / Back end Tester / Data Migration

Responsibilities:

• Reviewed Business, Systems, Design and Technical specification and identified gaps and ambiguous points, coordinated with respective team to fix the gaps.
• Defined testing activities for three major releases with concurrent monthly maintenance releases.
• Created Test data analysis from the Functional, System and Design specification.
• Interacted with Business Users, BA, Dev teams to understand the business process and technical flows and created detailed End-to-End test cases based on the processes and business flows.
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS
• Created Requirements Traceability Matrix (RTM) for test coverage analysis and test completeness
• Reviewed Use cases test critical areas of application.
• Created test cases for Smoke testing, System testing and Regression testing.
• Created Risk Assessment matrix document based on defects identified and risks associated in system/production environment.
• Incorporated Integration within System Test plans, which adequately exercise functioning of the system and its various components.
• Validated various DataStage jobs according to Business Requirements and Functional Specifications.
• Created manual Test cases and utilized QTP to automate test scripts for Regression Testing.
• Integrated the Automation test scripts in Quality Center and created baselines.
• Wrote queries on Oracle and DB2 database for data validation, tested the Java web interface application with the legacy Mainframe programs.
• Validated various Cognos reports for data quality and lay outs.
• Involved in validating various Informatica workflows, mappings, tasks.
• Extensively developed SQL Queries using Rapid SQL to test the business process of financial accounting modules to PeopleSoft.
• Created RTM between Quality Center and DOORS
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Manage defects through Rational Clear Quest Defect Tracking. Assign defect priority, analyze follow up and retest defects over builds.

Environment: Microsoft-TFS, DataStage, Oracle 9i, Toad, SQL, PL/SQL, DB2, CDW, PeopleSoft (GL, AP and AR), Autosys, Windows XP, QTP, SQL Server2005, Crystal Reports, Cognos, Rational Clear Quest, Rational Clear Case, MS Office, VISIO and Project