SUMMARY OF EXPERIENCE:

• Have 9+ years of professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Enterprise Data Warehousing (EDW), DataMart, Databases, Web services, Client - Server applications
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC). Experience in Agile, Scrum and Waterfall models of SDLC.
• Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Worked with Business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.
• Wrote complex SQL and PL/SQL queries to validate DataMart and Data warehouse Testing
• In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing
• Experienced in Integrating and coordinating testing activities into software development activities
• Worked with different RDBMS Oracle, SQL Server, Teradata, MySQL, IBM DB2 and their GUI utilities like SQL Loader, Oracle SQL developer, Teradata SQL Assistant, WinSQL to do transaction of data
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, Data Stage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, Cognos, Micro strategy, OBIEE, SSRS and Crystal Reports
• Served as a Data Warehouse Specialist in testing of an enterprise data warehouse/business intelligence application.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using Oracle, SQL Server and DB2.
• Working knowledge on various types of data feeds like: XML, DB2, Oracle and Flat files.
• Hands-on experience using defect Management Tools Quality Center,HP-ALM and Jira, Rally
• Excellent in writing SQL and PL/SQL queries and UNIX shell scripts to perform Backend testing
• 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
• Strong working experience in the Data Centric Testing, Data Analysis, Design and Development
• Supporting multiple projects, while maintaining strong quality and ability to meet deadlines
• Excellent analytical skills, documentation skills and presentation skills
• Self-starter and ability to present ideas in a concise, logical and well organized format

TECHNICAL EXPERTISE:

ETL Tools: Informatica 9.x/8.x, DATASTAGE, Ab Initio, SSIS

Testing Tools: Quality Center, ALM 11.0,Load Runner, QTP, Jira

Database: Oracle 9i/10g,11g, SQL Server 2008/2012, DB2, MS Access, Teradata 13.0,Netezza, 1010Data

BI /Reporting Tools: Cognos, OBIEE, Micro strategy, SSRS/SSAS, Qlik View

Job Scheduling Tools: Control M, Autosys

Languages: XML, SQL, UNIX Shell Scripting, PL SQL, T-SQL

SDLC/STLC: Agile, Scrum, Waterfall, V model.

Operating Systems: Windows XP, Window 2003, Windows 2007, Windows 8, Linux in Red Hat and UNIX (AIX).

PROFESSIONAL EXPERIENCE:

Confidential

Sr. QA Analyst 

Responsibilities: 

• Worked closely with Business Analysts and Developers to gather requirements in order to formulate the test plan. 
• Performed Black Box Testing of the application to better understand the functionality of the application. 
• Prepared Test cases according to the requirement. 
• Involved in creating test strategies, status reports and test timelines that clearly communicate to business owners the history of UAT testing activities and results.
• Defined the Scope of testing for User Acceptance Testing. Developed detailed test conditions. Supported documentation across extended testing team as directed by UAT Manger. 
• Created test plan and test cases for back end testing from the business requirement. 
• Created and executed SQL queries using Relational Database. 
• Used HP Quality Center to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
• Assisted the business analysis team in preparing the Functional Specifications document. 
• Prepared Test Plans and Test Cases based on the business requirements.
• Performed Functionality Testing of the application manually.
• Performed end to end testing manually.
• Performed SOA / Web Service testing using SoapUI.
• Involved in Back End testing using SQL Queries on Oracle Database.
• Created SQL queries within UNIX environment to automate the back end testing.
• Performed Security Testing by writing using Positive and Negative Testing approach to ensure appropriate user authentication.
• Performed Regression Testing after the defects have been fixed to ensure no further effect on other functionalities.
• Participated in Walkthroughs and Inspection meetings to review.

Environment: JAVA, ORACLE, Windows, UNIX/LINUX, MS Office, XML, HTML, SOAP UI, HP Quality Center, QTP, SQL. 

Confidential

Sr. QA Analyst/ ETL Tester

Responsibilities: 

• Attended application walk-through and reviewed Requirements to understand the scope of the project.
• Coordinated all QA activities and enhancements using Agile Methodology.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation.
• Prepared Test Plan wrote Test Cases and executed test scripts as well as tracked bugs and generated defect report using Quality Center (QC).
• Wrote ETL test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations- match aggregated data against staging tables and/or ODS, and Granularity of data is as per ETL specifications.
• Created the use cases, activity diagrams and sequence diagrams.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Tested InformaticaMapplets like Aggregator, Filter, Router, Ranks, Look Ups, Store procedures and Views.
• Performed ETL test task estimation, ETL test execution, Regression testing, ETL Functional testing, automated testing where possible. 
• Designed test case, test data and test automation, Tractability Matrix and Test Coverage reports.
• Performed Regression testing by executing the scripts developed with QTP. 
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan. 
• Designed various test Cases with different test conditions.
• Prepared the Data mapping specifications and documentation. 
• Loaded data into Oracle using SQL loader and validated data.
• Wrote SQL Queries and executed them using TOAD and SQL Editor.
• Performed System test, Workflow Integration Test, Acceptance testing and Regression testing activities in Test environment and Production support environment.
• Verified logs after running ETL jobs using Informatica. 
• Studied the feasibility of the reports by conducting the data analysis.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.

Environment: Informatica Power Mart 8.1, Erwin, MS Excel, TSQL,DCT SQL, PL/SQL, TOAD, Test Director, Visual Basic 6.0, Oracle 9i,Python, Windows 2000, Rational Rose. 

Confidential, NY

QA Analyst / Testing

Responsibilities: 

• Involved in this project as a QA Analyst in testing the project.
• Documented detailed Test Scenarios for Credit Rules and created both positive and negative test cases.
• Involved in the creation of test plan with QA lead and QA managers input.
• Prepared and Executed test cases for Functional, System-Integration, End to End, Regression testing and User Acceptance Testing.
• Involved in browser compatibility testing and regression testing.
• Executed manual test cases and identified the test cases to be automated. 
• Extensively used Quality Center for test planning, defect tracking and reporting. 
• Built automation regression testing suits based on test cases using quick test professional.
• Created actions and re-usable actions based on the test cases and executed regression testing suits.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end.
• Reported defects to the development team with proper priorities and severities and provided reports to the manager.
• Identified bottlenecks, and discussed the same with the business analysis team, developers and technical architects and attended meetings.

Environment: Oracle 11i, Microsoft Windows 2003 Server, Browsers - Safari, Chrome, Internet Explorer, Mozilla Firefox,QTP 9.0, Quality Center. 

Confidential

Backend Data Tester

Responsibilities:

• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database-using Stages to do the functionality.
• Created ETL test data for all ETL mapping rules to test the functionality of the DATASTAGE packages
• Did testing on multiple DATASTAGE packages for data validation and data conditioning.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team.
• Involved in testing all the reports that were generated through Microstrategy.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend datamart through SQL and also using excel for data comparison.
• Involved in end to end testing of the entire process flow starting from the source database to the target datamart to the reports by considering all possible scenarios.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Teradata, HP Quality Center 10, Microstrategy, Oracle 10g, DATASTAGE, SQL, SQL server Management Studio, UNIX, Shell scripting,

Confidential, Rocky Hill, CT

Quality Assurance Analyst/ ETL Tester

Responsibilities:

• Developed ETL Test Plans, Test Strategies and Test Cases.
• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Extensive testing on the Performance of the Stored Procedures in PL/SQL.
• Developed UNIX shell scripts to format the session log files and to extract the information from error logs.
• Used Datastage director for running the Datastage jobs and validated them.
• Involved in testing ETL and PL/SQL batches scheduled by using Autosys
• Tested UI Screens and Reports for cosmetic and data requirements.
• Involved in Usability Testing and coordinating with end users for giving Training on Web Based application.
• Defined and implemented verification and validation processes across the project and manage QA and regression testing environments. 
• Tested the web pages, user login pages according to the user security roles and requirements.
• Worked with business team to test thereports developed in Cognos.
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Tested OLAP cubes to verify and validate the functionality of the reports.
• Used Informatica Workflow Manager for session management, database connection management and scheduling of jobs. Created and Executed Automated Test Scripts.
• Monitored the performance of the reports.

Environment: Informatica Power Center, Ab Initio, Cognos, Oracle 9i, DB2, PL/SQL, Autosys, SQL*Plus, Quality center, Rational Clear Quest, UNIX, Shell Scripting, Windows XP