PROFESSIONAL SUMMARY:

• 10+ years of solid experience in Quality Assurance and Data Analysis of Various Business Applications in Client/Server environments, web - based Applications, Data Warehousing Solutions, ETL and Business Intelligence Solutions. Excellent knowledge on HealthCare Insurance, Banking and Financial - - Mortgage Loan Origination Systems - wireless (Telecom) and Airlines domain applications..
• Experience in implementing various QA methodologies involving preparing Test Plans, writing Test Cases and executing them.
• Exposure to Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification.
• Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Developed and maintained Test Matrix and Traceability Matrix.
• Involved in Testing and Analysis in Guidewire Billing center, Guidewire Policy Center and Guidewire Claim Center.
• Very strong in handling defect tracking and reporting process using ALM, Rational Clear Quest, Team Foundation Server- TFS, JIRA, Rally, Bugzilla.
• Tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Worked on Database Query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
• Extensive experience in writing complex SQL and PL/SQL scripts.
• Worked with different models such as Star and Snowflake and strong working knowledge in dimensional modeling.
• Experience in banking domain involving residential Mortgage and Loan Origination Systems.
• Solid knowledge on test management using HP Quality Center and maintained versioned objects using Rational Clear Case.
• Experienced with ETL tools like Informatica, SSIS, Datastage, and Ab Initio.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Used Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Experience working in a FACET environment and gained knowledge about various modules of a FACET system such as claims, membership and pre-pricing etc.
• Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7
• Experience worked on any requirement upgrade and/or change request while doing UAT.
• Experienced in testing Crystal, SSRS, Cognos and Business Objects, OBIEE Reports.
• Experience in Data Analysis, Data Validation, Data Verification, data profiling, identifying data mismatch and Good experience with data sources.
• Strong in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Knowledge on the phases of Agile methodology.
• 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

Testing 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, Dallas TX

Sr. QA Analyst

Responsibilities:

• Developed the complete Test documents involving Test Plan, Test Cases and Test Scripts by analyzing Business requirement documents and Use cases.
• Prepared Requirement Traceability Matrix (RTM) for test scenarios, tested Status reports and Test Sign off documents.
• Tested and Certified Label and involved in System, Functional, Regression testing and integration testing.
• Involved in test management and defect management using Team Foundation Server (TFS).
• Performed database (metadata) validation before loading the data into the target tables.
• Tracked and executed the User Acceptance Test cases (UAT) with respect to the requirements to determine the feature coverage.
• Wrote complex SQL queries using TOAD.
• Performed Backend database testing by executing the Group functions, complex Joins and sub-queries.
• 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.
• Configured Test Environment Management (TEM) for specific Test Cases, created test data, executed automated or manual unit tests, document results and updated defect-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.
• Created Test Cases in MTM and Logged all the activities in TFS.
• Used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Involved in validating the web services testing using the Soap UI.
• Involved in testing SSIS Packages, and in Data Migration.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with development team for closing a defect using Team Foundation Server.
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Have tested reconcile and incremental ETL loads for the project.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data Warehouse.
• Worked with Shell Scripts to extract data from different sources and set up jobs to load extracted data into databases in QA environment.

Environment:: Informatica 9.1, Oracle 11g, TOAD, SQL Plus, XML, TFS (Team Foundation Server), MS Visual Studio, MTM ( Microsoft Test Manager), Micro Strategy, AMTEL, EDI, Window 8 Server, PuTTy, HP ALM, Quality Center 10, ALM, Autosys, SQL Server 2008 R2, SSIS, SSRS, SSAS, Windows XP, UNIX

Confidential , Pleasanton, CA

Senior QA Analyst

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 using Rational Clear Case.
• Tested the final application for Usability testing to 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.
• Tested Business Requirement/ETL Mapping Rules/Reports against various GW functionalities/modules and data flows from UI to OLTP DB to Replication DB to Staging to Data Mart/EDW to Reports.
• Integration testing between the systems (Policy, Billing & Claims) to create test data/scenarios for ETL, BI and UAT Testing manually as well as by employing UFT.
• Performed Backend testing using SQL queries to compare and retrieve data by using Database Check points
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Involved with project backlogs and sprint backlogs.
• Extensively involved in System testing / Functional, Regression testing and Integration testing.
• Wrote Complex SQL queries and PL/SQL sub-programs to support the test case results, SQL performance tuning.
• Performed Negative testing using SSIS to find how the packaging performs when it encounters invalid and unexpected values.
• Worked on verification of ETL logs and reject/discard files for errors and reported them to development team.
• Attended review sessions with Data Analyst for any structural change (Due to incomplete Business requirement/granularity issues) and upgrade in the Data Mart solutions/Table solutions
• Tracked Defects, generating defect Reports in ALM/Quality Center based on Severity and Priority
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements.

Environment:: Informatica 9.1, Toad, SQL, PL/SQL, UFT, DB2, Oracle 11g, TOAD, XML, PuTTy, HP ALM, Quality Center 10, ALM, TFS (Team Foundation Server), Cognos, MS Visual Studio, EDI, Autosys, SQL Server 2008 R2, SSIS, SSRS, SSAS, Windows XP, UNIX, Doors.

Confidential, Salt Lake City, UT

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

Responsibilities:

• Implemented data sourcing project to meet data requirements of various data consumers like Capital Market, Electronic Trading, Credit Risk, Economic Capital, Operational Risk, Regulatory Capital and Market Risk business operations.
• Documented the end-to-end data lineage for all the BASEL Key Business Elements KBEs and pushed it periodically to IBM IIS metadata repository to support data governance and enterprise wide Metadata management.
• Established source-to-target mapping based on the above analysis and maintain the data lineage in MSSQL database.
• Excellent experience on Electronic trading platform for electronic Trading in credit markets for Rapid Price discovery, efficient trade execution and processing, broad range of securities and new issues.
• Worked with developers to gather information for a set of Development Plan templates documenting the service’s requirements, functional, and technical design Included SDLC documentation.
• Involved in development and implementation of new processes and systems in support of bank's Residential Mortgage Management business line.
• Extensively worked on Mortgage default functions, including collections, loss mitigation, short sale, foreclosure and bankruptcy.
• Tested all the ETL processes developed for fetching data from OLTP Systems to the target using complex SQL queries.
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.
• Reviewed unit test cases and test results and certified the code for Integration testing
• Created user acceptance testing documents and reviewed them with the customer.
• Involved in entering and tracking defects using Rational Clear Quest.
• Validated several SSIS and SSRS packages to verify that they are working according to BRS.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Done data validations for Business Objects reports.
• Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
• Involved in testing the reports and UI screens containing those reports.
• Assisted in promotion of Informatica code and UNIX Shell Scripts from UAT to production.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Involved in validating the web services testing using the Soap UI.
• Involved in testing SSIS Packages, and in Data Migration.
• Written several complex SQL queries for data verification and data quality checks.
• Utilized DOORS as a requirement repository (RTM) and synchronized with Quality Center
• Have tested reconcile and incremental ETL loads for the project.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data Warehouse.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands.

Environment: Oracle 9i, Toad, DB2, SQL, Ab Initio 2.12, PL/SQL, Business Objects XI, MS Visio, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, TIBCO, Remedy, SQL Server 2003/2005 SSIS, SSRS, HP Quality Center, UNIX, PuTTy, SQL Navigator

Confidential, Bloomfield, CT

ETL EDI 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.
• Configured Test Environment Management (TEM) for specific Test Cases, created test data, executed automated or manual unit tests, document results and updated defect-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, Seattle, WA

DWH Tester/ Data Migration QA/ Web UI Tester | Data Analyst

Responsibilities:

• Developed test Plans based on BRDs and Technical Specifications.
• 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, Seattle, WA

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

Responsibilities:

• Involved in Design and development of test plans based on high-level documents (BRD & FRS).
• 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 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 Data Stage 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