SUMMARY:

• Over 6years of comprehensive experience in the field of Information Technology as Senior ETL QA Analyst, Senior QA Analyst & Data warehouse Test Analyst covering different areas of Testing.
• Good understanding of the Software Development Life Cycle, Software Testing Life Cycle and Bug Life Cycle methodologies with working knowledge on AGILE, SCRUM methodology and waterfall.
• Experience in Manual and Automated Testing using Selenium Web - driver (core Java).
• Experience in creating Test Scenarios, Test Cases and Test Scripts through hands on designing test cases covering all test conditions and eliminating redundancy / duplications.
• Experience in SQL to extract the needed Test data.
• Used Visual Studio Team Foundation server 2013 (TFS) to monitor work, code, build and test phases of the team.
• Updated the tasks from to-do to done in TFS as sprint progresses every day.
• Experience in Designing, Developing, Executing and Generate Reports using Application life cycle management MTM and HP (ALM)/QC.
• Experience in defect tracking tool Bugzilla.
• Experience in interacting with business analysts, developers, technical support teams and helping them in base lining the requirement specifications.
• Experience in maintaining support documents, QA Sign off Documents and maintaining Status Reports.
• Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of requirements.
• Hands on experience on GUI, Functional, Integration, Regression, System, User Acceptance, Smoke, Sanity, Performance, Compatibility, Security, Database Testing and Cross Browser Testing.
• Hands on experience on working with huge data using Excel Mapping / Excel Pivots / SQL queries.
• Good knowledge on data warehouse concept, ETL lifecycle, BI reports and writing complex SQL query.
• Experience in creating X-path to find dynamic objects.
• Knowledge of Core Java concept.
• Experience in writing Generic Scripts and Project Specific Scripts.
• Knowledge on Web Service Testing using SoapUI.
• Worked on applications developed for Healthcare, Insurance and Retail industries.
• Used Requirement Management Tools like Visual Source Safe (VSS).

TECHNICAL SKILLS:

Testing Tool: QC/ALM, Postman, SoapUI, Rally, Jira, Clear Quest, Doors, QTP,TOAD, SQLDeveloper,Informatica, OBIEE,SharePoint

Programming Languages: .NET, SQL/PL-SQL, HTML, DHTML, Perl, PHP, Java, XML, CSS. Json

Databases: Oracle, DB2, SQL Server, Teradata, Vertica.

Operating Systems: Windows, Linux. Winscp

Packages: MS Office (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE:

Confidential, VA

ETL Tester (Manual Testing)

Responsibilities:

• Created Test plan & Script, Defect Management Templates; Created Initial test plan and developed test cases and test scripts manually.
• Used Quality center to store all testing results, metrics, created Test Cases, and Reporting.
• Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.
• Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.
• Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
• Prepared meeting notes on daily execution/highlight of the project and send out the reports to managements.
• Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Wrote Structure Query Language (SQL) queries to check proper data population in application table and for data verification to perform Backend Testing against Oracle Database.
• Provided weekly status updates showing the progress of the Automation testing effort and open issues to be resolved.
• Updating tasks in version-one and proving all the evidence documents in time before the end of iteration.
• Reviewing the evidence for Completed regression, positive, negative, integration and functional testing to produce a bug free product

Environment: SoapUI, HP-ALM, Rapid-SQL, XML-SPY, WinScp, Jenkins, Putty, Notepad++, Ms-Office LINUX.

Confidential, NY

QA Analyst (Manual Testing)

Responsibilities:

• Developing test scripts for execution using functional design document and unit design documents for New York Health Exchange (NY-HX) for very complex and large web based application (portal).
• Building and maintaining test scenarios, test cases, defects, test scripts and Traceability Matrix.
• Development of expected entry/exit criteria into test cases.
• Prepared Test Schedules, Test data and Detailed test scripts according to the Release schedule.
• Used Visual Studio Team Foundation server 2013 (TFS) to monitor work, code, build and test phases of the team.
• Updated the tasks from to-do to done in TFS as sprint progresses every day.
• Review test cases, monitor quality of the test cases and upload the test cases into MTM.
• Defect logging using MTM and retesting of defect fixes.
• Worked closely with DOH users and UAT Testers.
• Documenting the test procedures and issues.
• Conduct Smoke, Black box, Functional, Negative testing for release and Enhancements.
• Verification of notice generation for various eligibility results and plan selection at database level.
• Developing various eligibility scenarios.
• Production support to perform regression testing and test defect fixes.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Java, Data studio 3.1, MS Office, TFS, MTM, Web-sphere, SQL Server, DB2LUW, Windows7.

Confidential, WI

ETL Tester

Responsibilities:

• Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Developed high level ETL test matrix based on business requirements, ETL functional and ETL technical specifications, and development standards for assigned projects/applications
• Created test cases based on test matrix including test data preparation for Data Completeness, Data Transformation, Data Quality, Performance and scalability
• Created SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
• Performed data quality analysis using advanced SQL skills
• Executed ETL Test Cases and ETL Test Scenarios
• Perform testing on Execute Package Task, Conditional Split, Data flow, and Derived column, Look Up and Merge Join Transformation and Task
• Executed Quality ETL Test Plans and ETL Test Cases to verify reliability, accuracy and Compatibility of application
• Extensive SQL querying on Staging, Data warehouse and Data Marts
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing.
• Tracked and reported the issues to project team and management during test cycles.
• Updated and maintained existing ETL test Matrix and ETL test cases based on code changes and enhancements to assigned applications

Environment: MS Access, Informatica 9.6, SQL, PL/SQL, Autosys, Flat Files, OBIEE 11.1/10, Mercury Quality Center, Oracle 10g, 11g, HP Quality Center/ALM, Jira

Confidential

ETL/QA Tester

Responsibilities:

• Wrote the SQL queries for landing table, staging tables and Masters table validate the data results
• Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting.
• Load the test cases in the ALM under test plan and execute the test cases in the test lab
• Create task, update the task and input actual work
• Reviewed Informatica mappings and run the job in workflow manager and to check in the workflow monitor to validate
• Extensively used Informatica power center for extraction, transformation and loading process
• Write the test cases and update as per the design documents and follow the mapping doc for the system Integration region
• Write SQL queries to validate that actual test results match with expected results
• Responsible for monitoring data for porting to current versions
• Checked the reports for any naming inconsistencies and to improve user readability
• Identify the complete test scenario for report testing and ETL testing.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source
• Performed backend database testing by writing SQL scripts to verify data integrity
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• Involved in all testing phases: Smoke Testing, Functional Testing, System Testing, Performance Testing, Regression Testing, Integration Testing, and Quality Assurance Testing
• Involved in validating the aggregate table based on the rollup process documented in the data mapping
• Assisted in creating test data and test cases and execute function system tests as needed.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing

Environment: Informatica 10.0 SQL, PL/SQL, Flat Files, Csv file, Text file, UNIX, Winscp, ALM, Rally, Oracle 10g, 11g and ESP work station.

Confidential

QA Analyst (Manual Testing)

Responsibilities:

• Review the entire flow of application to have knowledge on the functional flows
• Understanding the requirement documents like BDD, UCD etc.
• Involved in Test Case design-Identifying Test Scenarios & Test cases.
• Involved in GUI Testing, Functional, Positive, Negative, Re-Testing, Regression Testing and Sanity Testing.
• Reporting and tracking of Bugs using Bugzilla.
• Involved in preparation RTM.
• Participated in weekly meetings, monthly meetings etc.

Environment: Java, Bugzilla, VB, MS SQL Server and DB2, Windows XP.