SUMMARY:

• Over 7+years of experience in the software IT industry in Software Development, Quality Assurance and Testing (SDLC/STLC).
• More than 9+years of experience in Software Manual and Automation Testing, IT Support within the environment of ERP, CRM, Data warehousing, Mainframe, Web - based and Client-Server application.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Extensively used HP Quality Center, Rational Clear Quest and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• More than 4+years of experience in Software Development activities within the environment of Oracle, SQL Server, Informatica and Mainframe.
• Excellent knowledge of User Interface (Web & Windows), Database, Reports, System architecture concepts.
• Proficient in Data Analysis, System Analysis, Business Requirement Gathering, Data Modeling, Expert and comfortable working on various databases: SQL Server, Oracle, and Mainframe DB2.
• Experience in working in various Testing methodologies Waterfall, Agile and Scrum models.
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snow flake) of data warehouse using Erwin.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience includes testing of applications which use integrated database using Informatica, DataStage, Oracle, SQL Server and DB2.
• Extensively used Informatica to load data from Flat Files, Mainframe and SAP to Oracle and SQL server databases. 
• Experience in Business Intelligence testing in various reports using Cognos, OBIEE and Tableau.
• Excellent knowledge in Data Warehousing concepts. Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Tested ETL applications/subject areas in EDW in relational databases and flat files using Informatica/Datastage.
• Tested UNIX shell scripts written for ETL Processes to schedule workflows on Tivoli, Autosys, UC4 schedulers.
• Strong understanding of QA Process, Procedures, Test activities and deliverables in each phase in STLC. Expert in Reviewing and Analyzing Business Requirements, Functional and Technical Specifications.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Comprehensive knowledge of database management systems, SQL Queries, and UNIX. Built complex SQL queries and used them to perform Back End Testing.
• Experience in Back End Testing for Data validation, accuracy for Data Migration and conversions.
• Expert in developing Test cases using QC/CQ for Data warehouse, Client, Web, Database, Mainframe and SAP applications.
• Experience in database programming such as SQL, Oracle, PL/SQL, T-SQL and MS Access. Experience in Back end Testing for data integrity, correctness, data type and data size
• Experience using web based technologies like XSLT, XML, Java, VB Script. Hands on experience using WSDL, SOAP, XML and XSD and Unix Commands
• Expert in using Quality Center, Clear Quest and JIRA for Test case management, defect management and Project Management.
• Expert in performing Unit, Smoke, Functional, System Integration, Regression, End to End System Testing, Security, Compatibility and User Acceptance Testing
• A self-starter with proven problem solving and ability to work in a dynamic fast faced environment. Excellent negotiation, coordination and Interpersonal skills with cross geo teams.
• Flexible and adopt new processes that need for the project and organization needs. Experience working with onsite/offshore model with clients.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. ETL QA Analyst

Responsibilities:

• Working as lead QA consultant as part of Business Intelligence Data Validation team (IM Department).
• Review and understand the Business Requirements Specification Documents (BRD), Requirement Traceability Matrix (RTM), High Level Design documents (HLD) and Source to Target Mapping Documents (STM) in order to identify the test requirements. Expertise in Data analysis, Data modelling, Database design, Data migration, and Business intelligence solutions.
• Interacts with Solution Architect, Data Architect, Project Delivery Lead, business analyst (BA), design lead (DL), Technical Lead(TL), data modular(DM) to completely understand the business, functional and technical requirements
• Prepare Testing Estimates and updated Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional, technical requirements and test scenarios.
• Prepare all test strategies, test plans, test scenarios, test cases, and data requirements for SIT/UAT test executions and sharing it across the stakeholders prior to the test execution.
• Perform system integration testing (SIT), user acceptance testing (UAT), end to end testing (E2E) and Performance testing (PT) of the entire process flow starting from the source data feeds to the target enterprise data warehouse (EDW) by considering all possible scenarios.
• Perform data/reports validations that include testing of source data for data completeness and correctness in EDW according to the business requirements.
• Write complex SQL queries for checking the counts and for validating the data at field level.
• Extensively involving in running batch jobs using Batch Tivoli workload scheduler from UNIX server for loading the test data from source to the target (Inbound) and vice versa (Outbound).
• Complete responsible for all QA deliverables that includes writing, executing and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing, reports testing and data migration, maintaining all the test cases and defects in IBM Rational Clear Quest (RCQ) for all the projects from QA stand point of view.
• Primary point of contact for the projects from testing stand point of view for escalations and lead the bug triage meetings. Also, organize status meetings and send status reports on daily/weekly basis.
• Ensures content and structure of all testing documents are documented and maintained in QA SharePoint. Also, conducting daily Scrum Stand-ups for QA updates and defect status.
• Extensively working knowledge on Membership, Claims subject areas within EDW and claim/membership data marts (CDM/MDM).

Environment: Informatica Power Center 9.5, Oracle 11g/10g, SQL, PL/SQL, Shell Scripting, IBM Tivoli Scheduler, Ab Initio Co >Op 3.2/3.1, GDE 3.2/3.1.

Confidential, Columbia, MD

Senior QA/ Test Analyst

Responsibilities:

• Understanding/Reviewing of business requirements (BRD) and data models from the Business Analyst and Data Analyst provided.
• Reviewing the technical documentations such as HLD, TDD, lineage (STM) document and data load strategy and provide QA comments.
• Validating and profiling the data from different DB sources such as EBS and MMB data through Informatics Data Analyst and SQL to prepare business user test cases in order to support UAT.
• Performed block box testing for Salesforce (CRM), Oracle APPS (EBS), Mastermind(MMB) and Tableau reports (data visualization reports)
• Involved in testing of all ETL mappings according to the loads for Stage, DW and Reporting (Super Marts). Also, involved in testing of SCD1, 2 mappings for the required dimension tables in sales mart subject area for small business and oracle R12 upgrade projects.
• Creating Test Plan, Testing Strategies and Test cases for testing of historical Load, incremental Load and One time updates/purging from source MMB/EBS to EDW and uploading test cases into QC for SIT/UAT.
• Providing approval for deploying code through Deployment groups and promoting the code from DEV to QA environments.
• Performing system Integration testing (SIT), regression testing (RT), performance testing (PT) and providing support me to user Acceptance testing (UAT) based on data load strategies such as a) 1900 load b) One time load, c) Type 1 SCD load and d) Type 2 SCD load (Historical and Incremental data loads).
• Testing of newly scheduling the jobs in Tidal for the daily/weekly/monthly Informatica data load jobs and escalating the issues for any scheduled jobs failures to the concerned teams to get it resolved within SLA.
• Performing extensive Back-end database validation by executing advanced SQL Queries in SQL developer for Oracle Database. Testing of checksum (CRC) and error handling for the flat files and relational tables loaded into the databases for all mappings.
• Escalation performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Read and verify the session log to verify data loads summary, data verification purposes like data truncation, data overflow, rejected errors, row counts and etc.,
• Defects were Tracked, Retested, Deferred, Closed using HP Quality centre (ALM). Discussing the issues/concerns/defects in daily defect status call with BA, DA, Tech lead and Developer for open defects follow up and resolutions.
• Sharing and reviewing the UAT results with BA and obtaining sign off/approval for code migration in PROD.
• Prior to code deployment in production, reviewing the technical design documents, run books, deployment tracker and cut-over plans with PROD support team and providing our feedback/review comments from QA prospective.
• Contributing in other meetings like daily/weekly status meetings to discuss the progress of testing and BRD/HLD review meetings.
• Created and maintained each project’s test plans, testing strategies, test cases, test results and other QA related documentation in Jira.

Environment: Informatica Power Center 9.5.1, IDQ Informatica Developer Tool 9.5, Oracle 11g, MS SQL Server, Teradata, Quest Toad 12, HP QC 9.1

Confidential, Baltimore, MD

ETL QA Tester

Responsibilities:

• Worked as QA Lead between Catamaran PBM and Cigna healthcare. Extensively worked to test and implement the pharmacy claims (Reclaim) migration projects for commercial/finance system between Catamaran and Cigna.
• Reviewed the Business Requirements Specification Documents (BRD), High Level Design documents (HLD), Technical Design Documents (TDD) and Source to Target Mapping Documents (STM) in order to prepare the testing strategy, testing scenarios, the SIT/UAT test cases and test data requirements.
• Interacts with Solution architect, Business analyst (BA), Technical Lead (TL), data modular (DM) and developers to completely understand the business/functional/non-functional requirements/assumptions/risks/constraints/dependencies/ABC (audit balancing and control) process/restarts and recovery mechanism/data backup and data refresh strategies and etc.,
• Prepared/Reviewed Testing Estimates, Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional, technical requirements and test scenarios.
• Prepared/reviewed the test strategies, test plans, high level test scenarios, test cases, SQLs for each test case and test data requirements for SIT/UAT/RT test executions and shared it across the stakeholders prior to the test execution.
• Performed system integration testing (SIT), user acceptance testing (UAT and regression testing (RT) from the source system (Argus) to the target enterprise data warehouse (EDW).
• Built very complex SQL queries across multiple source/code mapping lookup tables and performed table and data (Table Structure, Checksum, Record count and field level data validation) validations, and ETL validations very effectively that include testing of source data for data completeness and data correctness & testing of the ETL process that loaded the data into target database after performing all the transformations according to the business requirements (ETL transformation logics).
• Primary point of contact for the QA team for issues, escalations, lead the bug triage meetings, and issue resolutions to upper management (Joint Integration Project Delivery/QA Managers).
• Ensured content and structure of all testing documents / artifacts are documented and maintained in QA SharePoint. Also, conducted daily Scrum Stand-ups for QA updates and defect status.
• Co-ordinated with Cigna QA teams in identifying the source data for testing, building test data in source platform, and data migration.
• Updating and reviewing test execution plans (mop) with both internal/external parties on weekly basis to meet the deadline without having schedule slippage and maintain the accuracy of the project.
• As an ETL QA Lead, Serves as a mentor to QA testers and QA analysts by training, assisting with complex testing scenarios/test cases/SQL queries and issues guidance for less experienced team members.

Environment: Informatica Power Center 9.5.1, IDQ Informatica Developer Tool 9.5, Oracle 11g, MS SQL Server, Teradata, Quest Toad 12, HP QC 9.1

Confidential, Hunt Valley, MD

ETL QA Tester

Responsibilities:

• Worked as ETL Test Lead as part of Business Intelligence Data Validation team (IM Department) and successfully delivered over 15 major projects and over 25 DQ (Data Quality) tickets.
• Analysed and reviewed the Business Requirements Specification Documents (BRD), Requirement Traceability Matrix (RTM), High Level Design documents (HLD) and Source to Target Mapping Documents (STM) in order to identify the test requirements. Expertise in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
• Interacting with Solution Architect, Data Architect, Project Delivery Lead, business analyst (BA), design lead (DL), Technical Lead(TL), data modular(DM) to completely understand the business, functional and technical requirements
• Prepared Testing Estimates and updated Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional, technical requirements and test scenarios.
• Preparing all test strategies, test plans, test scenarios, test cases, and data requirements for SIT/UAT test executions and sharing it across the stakeholder’s prior tothe test execution.
• Performed system integration testing (SIT), user acceptance testing (UAT), end to end testing (E2E) and Performance testing (PT) of the entire process flow starting from the source data feeds to the target enterprise data warehouse (EDW) by considering all possible scenarios.
• Performed Data and ETL validations that include testing of source data for data completeness and data correctness & testing the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Wrote complex SQL queries for checking the counts and for validating the data at field level.
• Extensively involved in running the Informatica workflows using Batch Tivoli workload scheduler from UNIX server for loading the test data from source to the target (Inbound) and vice versa (Outbound).
• Complete responsible for all QA deliverables that includes writing, executing and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing, ETL code and data migration, maintaining all the test cases and defects in IBM Rational Clear Quest (RCQ) for all the projects from QA stand point of view.
• Primary point of contact for the QA team for escalations and lead the bug triage meetings. Also, organize status meetings and send status reports on daily/weekly basis.
• Ensured content and structure of all testing documents / artifacts are documented and maintained in QA SharePoint. Also, conducting daily Scrum Stand-ups for QA updates and defect status.
• Extensively worked on Medical Claims, Provider, Lab and Membership subject areas within EDW and claim and membership data marts (CDM/MDM).
• Extensively involved in testing the Cognos reports (about 400 reports) for membership renewal and claim processes as a user of Sales and Agent.

Environment: Informatica Power Center 9.5, Oracle 11g/10g, SQL, PL/SQL, Shell Scripting, IBM Tivoli Scheduler, Ab Initio Co >Op 3.2/3.1, GDE 3.2/3.1.