Summary:

• Around 7 years of IT experience in managing software testing efforts for Banking, Financial, 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.
• Extensively done Data Centric Testing data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data
• 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 , waterfall 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 ClearQuest.
• 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.
• 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
• 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 Testi ng projects and expert in coordinating testing effort between Onshore and Offshore teams.

Technical Skillset:

Work Experience:

Confidential

Sr. ETL /DWH Tester

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.
• Validated the Informatica workflows according to business requirement documents.
• Used Informatica workflow monitor to verify workflow status and logs.
• Participated in functional requirement reviews and code reviews.
• Analyzed existing business processes and provided recommendations for improvements and efficiencies in credit card project.
• Involved in validating various batch jobs scheduled using Autosys.
• Involved in Data centric testing using various approaches such as checksum approach to discover errors, identifying records with MD5
• 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 and optimized the use cases and created the Test cases based on them for Change Requests.
• Have led small offshore team to develop Test Plan and Test Script
• 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.
• Have tested scheduler scenario on Autosys.
• Validated the SSAS cubes for various dimensions.
• Validated the Data Warehouse DWH Table structure part of ETL testing
• Executed batch processing and verify the ETL jobs status and data in database tables
• Validated parameter-driven ETL processes to map source systems to target data warehouse with Informatica complete source system profiling.
• Tested all the rules implemented during ETL job and data move from source to target Data Warehouse DWH
• Developed complex SQL queries to test ETL jobs from 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 data in database by writing and executing SQL statements.
• Involved in meetings with Automation team for Development of Automation Scripts for Change requests to run along with regression tests suites of business priorities on Loan/Mortgage Application.
• Involved in backend testing using UNIX commands.
• Used MicroStrategy Web to offer interactive reporting to the end users
• Validated various MicroStrategy reports such as ad hoc, grids, graphs.

Environment: HP Quality Center ALM, Oracle 11g, Informatica Power Center 9.1, SQL Server 2012, SSIS, SSRS, SSAS, Autosys 10.0, Toad 10.0, WinSCP, MicroStrategy 9, Putty, Informatica Web Services, SQL, PL/SQL, Java, XML

Confidential

Sr. ETL/BI QA Analyst

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing Business requirement documents, Technical and functional design documents, Use cases.
• Prepared Requirement Traceability Matrix RTM , Test Status reports and Test Sign off documents.
• Involved in validating claims, enrollments, and membership.
• Validated reports for specific and aggregation accumulation data.
• Extensively involved in System testing / Functional, Regression testing and Integration testing.
• Prepared Test Cases for system testing and uploaded them into HP Quality Center linked the test cases to the business requirements.
• Ran the manual test cases from Quality Center Test Lab.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Performed Database metadata validation before loading the data in to the target tables.
• Performed Data Validation by testing the delta/daily and reconcile/data loads.
• Created SQL compare statements to validate Actual results with the Expected Results.
• Tracked and executed the User Acceptance Test Cases UAT with respect to the requirements to determine the feature coverage.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data moving from different sources to target using Informatica data validation option DVO .
• Provided support for Technical Integration and Prod Control teams for execution of ETL mappings.
• Written several complex SQL queries for validating Business Objects Reports.
• Extensively tested Business Objects reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Estimated level of effort LOE for testing effort and reported to Test Leads.
• 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.
• Used Rational Clear Quest for defect management.
• Ensured quality products delivered and installed as specified in the statement of work SOW .
• Reviewing the test activities through daily stand-up meetings.

Environment:: Informatica 9.1/ 8.6, Informatica Data Validation Option DVO , SQL, PL/SQL, Remedy, DB2, Oracle 11g, TOAD, Rational Clear Quest, Rational Clear Case, Doors, Soap UI, Web Services, Oracle SQL Developer, XML, PuTTy, VB Script, Quality Center 10, QTP, Agile, Business Objects XI, Autosys, SQL Server 2005, Windows XP, UNIX

Confidential

ETL / DWH / BI QA Analyst / Web Tester

Responsibilities:

• Involved in meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
• Used TOAD to develop and execute test scripts in SQL, to validate the test cases.
• Involved in reviewing test scenarios, test cases and test results for Data Warehouse/ETL testing.
• Prepared Requirements Traceability Metrics RTM , positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Involved in testing the Autosys Batch programs, UI screens.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA's.
• Extensively used Rational Clear Quest to track defects and managed them.
• Validated various Ab Initio Graphs according to business requirement documents.
• Extensively tested several Business Objects reports for data quality, fonts, headers, footers, and cosmetics.
• Validated the cardinality of joins and data integrity on the business objects universe.
• Conducted user acceptance testing UAT to validate that the developed application meets the business requirements.
• Extensively involved in testing the ETL process from different data sources SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Oracle database as per the data models.
• Used Autosys for scheduling the ETL mappings, PL/SQL subprograms.
• Written Test Cases for ETL to compare Source and Target database systems.
• Mocked test data to test all the scenarios and test cases planned.
• Used UNIX commands for file management placing inbound files for ETL and retrieving outbound files and log files from UNIX environment.
• Written several complex SQL queries for data verification and data quality checks.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process, issues and lessons learned for future references.
• Reviewed the test activities through daily Agile Software development stand-up meetings.

Environment: Ab Initio 2.13, Teradata V2R6, Teradata SQL Assistant, SQL, Business Objects XI, Clear Case, Clear Quest, RequisitePro, HP Quality Center, SharePoint, Web Logic, Oracle 10g, Data Flux, Fiddler, SQL Server 2008, DB2, PL/SQL, UNIX, Putty, Flat files, Session Logs, Rally, Remedy, Windows XP.

Confidential

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

• 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 layouts.
• 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.
• Involved in validating various Informatica workflows, mappings, and 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 ClearQuest 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 ClearQuest, Rational Clear Case, MS Office, VISIO and Project

Confidential

ETL / Report / Backend tester / Data Migration

Responsibilities:

• Worked extensively with the business analyst to gather business requirements functional and non-functional in terms of SRS and facilitate technical meetings.
• Coordinated with the development team during the implementation phase.
• Tested the Integration points of the web portal system.
• Wrote SQL queries to pull data from the existing database for testing the web-processing Suite.
• Validated Informatica ETL workflows according to Business requirement documents and Data mapping specifications.
• Wrote Test cases and Test scenarios for manual testing and Automation needs.
• Conducted Data Driven testing to conduct backend testing.
• Validated Business Objects reports for the cosmetics and data presented on them.
• Coordinated with the UAT lead for conducting UAT testing, Integration, Black box testing.
• 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.
• Defects, which would enhance the usability of the application, were logged using HP Quality Center.
• Created Test Traceability Matrix TTM rosters and UAT Test checklists for all the test cases.

Environment: SQL, Oracle 9i, Toad, PL/SQL, DB2, Informatica, Windows XP, Java, Business Objects, J2EE, Java Scripts, MS VISIO, MS Excel, Word