SUMMARY

• Experience:14+years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Self - Motivated, Flexible to adapt to changing priorities and deadlines. Systematic and organized approach.
• Believe in Commitment to Excellence and Team Spirit.Multi-tasking projects Handling, Team handling, People management Capabilities.
• Excellent Presentation, Communication, Writing & Interpersonalskills.
• Extensive IT experience in various capacities including Analysis, design, development, Testing & implementation in client server environment using various S/W tools including Reporting Applications.
• Extensive experience in Actuate erd Pro, software quality assurance, Manual Testing, ETL Testing, Data Analysis, Data Migration Testing, SOA Testing, Web Method /API Testing using POSTMAN and Ready API, BI Report Testing, Big Data Hadoop Hive, HQL.
• Worked with large Databases in Testing and Production environments, Data warehousing and ETL process usingInformatica.
• Developed and designed Mappings usingInformatica ETL toolfor testing the data flow from Data Warehouse to data marts to compare data migration, data transformation & the totals at summary level.
• Good experience in working withonsite-offshoreteam model projects
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills, Object Oriented Programming and development knowledge. Good Exposure to database like Oracle, DB2, Teradata and MS SQL Server
• Good understanding of Reporting BI Tools like Actuate, Crystal report and ETL Tools like Informatica
• Involved in testing the Text Files, CSV Files, XML files, JSON Files and checked whether data is parsed and loaded to staging tables in Hadoop Hive using HQL
• Excellent Understanding and working experience in Agile Methodology, Waterfall Methodology
• Excellent experience in Quality Assurance, QA processed, Manual Testing, ETL Testing & Informatica DVO, POSTMAN, SOAP UI, Ready API, HP ALM Quality Center,Control-M
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Team Lead, Technical lead, Application developer, Application tester
• Executed software projects for Financial, Banking, Healthcare, Retail, Education, Insurance, Healthcare, credit Card and Telecom Domain
• Expertise in RDBMS backend testing for data validation and data integrity using SQL.
• Good experience onTeam Management, People Management, Estimation, Stakeholders communication for different projects.

TECHNICAL SKILLS

Languages: C++, VB

Databases: DB2, SQL Server 2008, 2010, 2012, My SQL, Oracle 8, 9i

Reporting Tools: Actuate erd pro, Actuate e spreadsheet, Crystal Report 11.0

Testing Tools: HP ALM Quality Center, JIRA,Informatica DVO, POSTMAN, SOAP UI, Ready API, AcceLQAutomation,Control-M

ETL: Informatica 8.5/9.1/9.6/10 , Informatica Cloud, Hadoop-Hive

Quality Assurance: Manual testing, Web Testing, ETL testingBackend testing, Data Testing, testing Processes, Informatica DVO, SOA TestingWeb Method/ API Testing, BI Report Testing Informatica Cloud/ SharePoint Cloud testing,CICD

PROFESSIONAL EXPERIENCE

Confidential

ETL DB QA Tester

Responsibilities:

• Create Automated testing framework for ETL Software Applications and Data Service Layer using Informatica, Informatica DVO for testing Data Warehouse, CSIM technology and integrations
• Create, design and develop strategy for ETL Validation, Data Validation, Backend Validation usingETL Automation tools and MS SQL Server database with XML, CSV and JSON
• Design, implement and execute Testing Strategy, Test Plans, Test Cases in Test Management using defect tracking tools JIRA
• Write Complex SQL queries and Stored Procedures against RDBMS to validate ETL processes
• Identify discrepancies/inconsistencies in ETL Data migration and Data Load through data Sources MSSQL Server database, XML, CSV, JSON files and perform root-cause analysis, bug prevention strategies, and quality measures.
• Work in Agile Software Development methodology, attend SCRUM meetings and implement new interfaces and integrations to third party systems

Environment: Informatica, Informatica DVO, SQL Server, XML, CSV, JSON, API, AGILE, Test Automation Framework, SCRUM, Web Services, SQL, JIRA,CICD, Control-M

Confidential

Sr. Software System Engineer Quality

Responsibilities:

• Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates
• Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
• Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.
• Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Developed and maintained Stored procedures, User Defined Functions, Indexes, Views, Tables,
• Identify discrepancies/inconsistencies and perform root-cause analysis as needed.
• Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.
• Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.
• Assist in the planning and facilitation of User Acceptance Testing as needed.
• Execute data validation process using SQL and ETL tools, and perform root cause analysis.
• Write SQL against relational databases to validate ETL processes and BI reports.

Environment: ASP.NET 4.5, .Net Framework 4.5, C#, Web Forms, Visual Studio 2015, HTML5, CSS3, JavaScript, JQuery, Bootstrap, Entity Frame Work 5.0, WCF, IIS 7.0, SQL Server, TFS, SSIS, Tortoise GIT.

Confidential

Sr. Software System Analyst Quality

Responsibilities:

• Lead the Agile test from planning and organization to execution and delivery.
• Work with Product Owner, Scrum Master and Agile Developer team to design Test strategy, Design Test Approach & Test Cases and Validation & Execution of test cases for Identifi Product
• Design the test approach, Test cases and Validate Web Services for EVH Portal, Microsites, Community portal using POSTMAN, SOAP UI Automation
• Perform comprehensive test planning activities, including developing effective test strategies.
• Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.
• Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.
• Participate in Various Agile ceremonies like Release planning, Sprint planning, Mid Sprint review, Sprint closure, Sprint retrospective & Demo.
• Design HQL,SQL DB artifacts used for Data & ETL Validation as well as BI Report validation
• Involved in testing the XML files, JSON Files and checked whether data is parsed and loaded to staging tables
• Create Web and Automation suite for testing API as well as Web Applications

Environment: Test planning, ETL Data testing,SQL Server 2016, AcceLQ Automation, POSTMAN,JIRA,MS VSTS, GitHub, Hive, HQL

Confidential, TX

Sr. DW/BI Quality Assurance Analyst

Responsibilities:

• Lead the test effort from planning and organization to execution and delivery.
• Work with business analysts and the development team to develop a testing culture. Drive adoption of unit testing, metrics to monitor code coverage, bug prevention strategies, and other quality measures.
• Analyze requirements to assess completeness and testability. Provide timely feedback and constructive recommendations to the Business Analyst.
• Perform comprehensive test planning activities, including developing effective test strategies.
• Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.
• Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.
• Identify discrepancies/inconsistencies and perform root-cause analysis as needed.
• Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.
• Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.
• Assist in the planning and facilitation of User Acceptance Testing as needed.
• Perform other job-related duties as assigned.
• Execute data validation process using SQL and ETL tools and perform root cause analysis.
• Write SQL against relational databases to validate ETL processes and BI reports.

Environment: Test planning, ETL testing, Informatica 10, SQL Server 2016, Cognos 10, HP ALM, Informatica Cloud, SharePoint Cloud and SQL

Confidential, Scottsdale, AZ

Sr. ETL API Tester

Responsibilities:

• Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates
• Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
• Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.
• Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality. .
• Tested ETL jobs as per business rules using ETL design document (Mapping Sheet)
• Created and Executed Test cases in Data Validator Option ( Informatica DVO)
• Created projects in Ready API, Tested Web Methods/ API using Postman and ReadyAPI
• Used HP QC to track Defects, analyze results and generate performance reports.
• Participated in updating the Requirements Traceability Matrix (RTM)
• Executed SQL Queries to verify the dataflow from the backend.
• Performed user acceptance testing (UAT), and integration testing.
• Worked on creating Test strategy, test plan and test scenario for E2E testing
• Executed E2E testing successfully handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica 9.1/9.6, SQL Server, Skybot, GoAnyWhere, Informatica DVO, My SQL, Hybris, PostMan, Ready API, Groovy Scripting

Confidential, Somerset NJ

Sr. DWBI ETL Tester

Responsibilities:

• Participated to created user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
• Participated in created of User Stories with Business users, and Developers.
• Developed a detailed Test Plan for the testing effort of the User Interface.
• Developed Test Cases based on the requirement documents.
• Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Performed Business Process mapping for new requirements.
• Tested ETL jobs as per business rules using ETL design document
• Used HP QC to track Defects, analyze results and generate performance reports.
• Participated in updating the Requirements Traceability Matrix (RTM)
• Executed SQL Queries to verify the dataflow from the backend.
• Performed user acceptance testing (UAT), and integration testing.
• Worked on creating Test strategy, test plan and test scenario for E2E testing
• Executed E2E testing successfully
• Worked as representative of IBM and handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Server, SQL

Confidential, Columbus, OH

Sr. DWBI ETL Tester

Responsibilities:

• Analysis of Requirement, Mapping document and create MTD, RTM and Test strategy document
• Developed a detailed Test Plan for the testing effort of the User Interface.
• Developed Test Cases based on the requirement documents.
• Tested ETL jobs as per business rules using ETL design document
• Executed the Test Scripts in TOAD
• Used HP QC to track Defects, analyze results and generate performance reports.
• Participated in updating the Requirements Traceability Matrix (RTM)
• Executed SQL Queries to verify the dataflow from the backend.
• Performed user acceptance testing (UAT), and integration testing.
• Worked on creating Test strategy, test plan and test scenario for E2E testing
• Worked as a member of UAT team

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Sever

Confidential, Phoenix, AZ

Actuate Developer and BI Report Tester

Responsibilities:

• Analysis of new requirements.
• Creating Design Documents based on the requirement.
• Developing Reports in Actuate erdpro and e spreadsheet with version 8.
• Integrating Main reports with Criteria reports.
• Preparing test cases for reports.
• Involved in Unit Testing and System Testing.
• Installation of Reports on Production Environment.
• Preparing detailed Test cases for report testing, data validation and look and feel changes
• Testing the reports for individual report flow and cross report flow
• Cross validation of report data with database values and validation of calculation

Environment: Actuate ERD Pro, Actuate e-Spreadsheets,DB2, HP Quality Center, Actuate iserver, Actuate Active Portal

Confidential

ETL BI Report Tester

Responsibilities:

• Analysis of new requirements.
• Creating Design Documents based on the requirement.
• Preparing test cases for reports.
• Prepare test strategy, MTD and test approach documents
• Preparing detailed Test cases for report testing, data validation and look and feel changes
• Testing the reports for individual report flow and cross report flow
• Cross validation of report data with database values and validation of calculations