SUMMARY

• Around 9 years of professional work experience in Datawarehouse and Software Testing, with good knowledge of Informatica and testing tools like Quick Test Pro, Win Runner, Test Director, Quality Center/HP ALM and Soap UI.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate - wide-ETL solution using Informatica PowerCenter 10.x/9.x/8.x
• Experience in Agile based - SCRUM project management methodologies.
• Good experience in various types of testing - Functional, Regression, System, Business testing, etc.
• Good understanding of ETL Test Processes and Test Methodologies.
• Understanding of mapping concept, transformations expressions, Joiners, Update strategy, and Source Qualifiers in Informatica.
• Extensive experience in Black Box Testing and various types of testing methods by using different testing tools with strong business understanding of Healthcare, Banking, Airline, Insurance & Telecom sectors.
• Expertise in Functional, Regression, System, Load, Back End and Integration testing using automated testing tools.
• Experience in requirements gathering, analyzing the requirements, test scenario creation, execution and test plan designing.
• Expertise in writing Test Plans, Test Cases, developing and maintaining Test scripts.
• Experienced in defining Testing Methodologies, Designing Test Plans and Test Cases, verifying and validating Web based applications and documentation based on standards for Software Development and effective QA implementation in all phases of SDLC.
• Expertise in Database testing with command in SQL/PL SQL and Databases like ORACLE and SQL Server using MS Query, Win SQL and T-SQL.
• UNIX, SQL scripts experience in Oracle 10g/9i database experience.
• Proficient in using HP Test Management tool Quality Center for Test Planning, Requirements Management, Defect Tracking and Reporting.
• Ability to work with both business and technical (IT) groups.

TECHNICAL SKILLS

Project Methodologies: Agile- SCRUM, Rational Unified Process, SDLC-Water Fall

Operating systems: Windows 7, Vista, XP, 2000/Professional, UNIX, Linux, Solaris

Databases: MS SQL Server, MS Access, Oracle 9i/10g/11g, IBM DB2

Testing tools: Informatica Power Center, Test Director, Rational Rose, QTP 9.5, Load Runner 9.2, SOAPUI, TOAD, Informatica Power Center, SQL Developer

Applications: Mozilla Firefox, Chrome & Netscape

Programming Languages: C, C++, SQL, Java, JSP, Web Services, XML, HTML

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Visio, MS Access

Business Intelligence: Crystal Reports, Informatica Power Center 8/9.X, Cognos 8

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

ETL Quality Assurance Analyst

Responsibilities:

• Responsible for creating/designing and documenting detailed test cases, scenarios based on the analysis of project plans, business requirements, and design specifications.
• All test cases were designed and executed in reference to the RTM (Requirement Traceability Matrix) created for a particular component to perform long term cpos and short term cpos.
• Responsible to identify the customers behavior when visiting the service center i.e. customer payment using milstar card or any other card.
• Coordinated with development team for defect analysis and performing regression Testing.
• Experience in managing private and cloud environments. Monitoring different services on cloud environment.
• Modified the existing test cases for the latest enhancements and executed test cases for Regression testing & UAT.
• Wrote SQL queries to extract data from the table to generate the customer data for milstar and non-milstar records.
• Validate the customer information using NoSQL database like Neo4J.
• Verify the data using hub visualization to identify the non-milstar customer information like phone number, address, customer post office number, etc.
• Executed testcases for tableau dashboards using Excel and HP Quality center and logged defects using HP quality center.
• Logging and tracking defects that include business impact and track testing progress along with attachment.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Created BI Reporting packages and dashboards utilizing data structure, localized data marts and external data sources.
• Experience working ETL concept such as 3NF, dimensional models, facts loads, join and data comparison across labels.
• Involved in making Hive tables, stacking information, composing hive inquiries using BigData.
• Involved in migrating tables from RDBMS into Hive tables using SQOOP and later generate visualizations using Tableau.
• Analyzed substantial data sets by running Hive queries

Environment: Quality Center, Windows XP, Informatica, Tableau, Green Plum, Oracle database, Neo4J, Regression Testing, End-to-End Testing, MS office Suite

Confidential, Catonsville, MD

ETL Quality Assurance Analyst

Responsibilities:

• Responsible for creating/designing and documenting detailed test cases, scenarios based on the analysis of project plans, business requirements, and design specifications.
• All test cases were designed and executed in reference to the RTM (Requirement Traceability Matrix) created for a particular component to perform software verification and validation of Clinical and Research trials.
• Created ETL test data for all ETL mapping rules to test functionality of Informatica.
• Took part in meetings with the Business Analysts and Developers for the improvements in the overall productivity and effectiveness of the QA and testing methodologies.
• Modified the existing test cases for the latest enhancements and executed test cases for Regression testing.
• Coordinated with development team for defect analysis and performing regression Testing.
• Created test data, executed test cases & test interfaces
• Developed and executed the test scripts to test migration using SQL and UNIX scripting.
• Logging and tracking defects that include business impact and track testing progress.
• Wrote and fine-tuned SQL scripts to verify the database updates, inserts and delete of the records and validate reports
• Written SQL queries in T-SQL to verify the data extraction from source to target database.
• Extensive experience with T-SQL in creating tables, implementing stored procedures, function, views.
• Wrote SQL queries to extract data from the table to verify the output data of the Reports.
• Participated in Walk through and Defect report meetings periodically
• Participated in daily status meetings of the team and provide updated status on defects & daily executions progress
• Involved in making Hive tables, stacking information, composing hive inquiries using Bigdata.

Environment: Quality Center, Windows XP, service now, Regression Testing, End-to-End Testing, MS office Suite

Confidential, McKinney TX

ETL Quality Assurance Analyst

Responsibilities:

• Developed Test Conditions from Business Requirements, Scope documents, High Level design documents in Test Conditions Expected Results (TCER) matrix.
• Analyzed the ETL design documents to understand the logic
• Assisted in Creating Detailed Timelines, Test Plans and Test Strategies for major releases and organized strategy review meetings.
• Established Traceability between the Requirements and the Tests in Traceability Matrix using Quality Center.
• Analyzed test Conditions and developed Manual Test Scripts for new Functionality test cases in QTP. Performed sophisticated Black Box Testing on the application.
• Imported and maintained existing manual test scripts and defects into Quality Center and Performed detailed script analysis to identify logical breakpoints in manual scripts.
• Prioritized, logged and reported defects using Quality Center.
• Preparing Test data to validate the ETL rules & transformations
• Conducted extensive Smoke Testing, Regression Testing and Sanity Testing on the application.
• Developed and maintained test data bed for manual test scripts.
• Performed detailed test results analysis after each test execution cycle and maintained Test results.
• Coordinated with On-shore and Offshore teams. Implemented Agile Methodology approach.
• Validated agent information using NoSQL like Neo4J.
• Provided proposals on proper escalating processes and procedures for quick defect resolution.
• Have experience in SQL and Data analysis Skills for capturing the data.
• Have good experience in Shell scripting in UNIX environment.
• Coordinated defect management calls between various teams (development, support and management) and participate in defect review calls with the development team.
• Developed plan to identify, track and manage all issues and risks associated with responsibility areas with the client management team.

Environment: Quality Center 11.0, Agile-Scrum, Windows XP, Junit, SQL Server, Neo4J, SOAP UI, IBM DB2, Unix, Oracle, MS Office Suite Manual Testing

Confidential, Lake Oswego, OR

Senior ETL Tester / Quality Assurance Analyst

Responsibilities:

• Involved in analyzing the business requirements created and executed Test cases.
• Wrote Test Plan and Test Cases by going through the LSDD (logical specification design Document and PSDD (Physical specification design document).
• Working under the Agile based SCRUM methodology implementation.
• Prepared test estimates for System integration testing and user-acceptance testing.
• Prepared the Test data and conducted test data walk through with business.
• Performed Input and output batch processing for the downstream (Region) and upstream process (KPEG)
• Have maintained test scripts in test scripts repository.
• Involved in System integration, User acceptance, Regression and workflow integration Testing.
• Wrote SQL queries & PL/SQL code on staging, ODS and Reporting Tables to validate the test data.
• Worked and understanding of historical data.
• Involved in developing Unit Test scenarios, test cases.
• Conducted daily status meeting with the business, onshore team and solution team
• Validated NoSQL queries using MongoDB.
• Reviewed test cases based on functional requirements and business requirement specifications.
• Created recovery scenarios for handling the unexpected error in the application.
• Cloning the production data using Test data management.
• Created manual test cases in HP QC/HP ALM for various user stories based on release and spirit plan.
• Worked on Quality Center to track the defect status. Conducted defect triage call between the testers, developers and business.
• Conducted system and integration testing, debugged the software errors and interacted with developers to resolve technical issues.
• Created and maintained test metrics from Test support and metrics (TSM) for product quality assessment.
• Creating and scheduling jobs in control-M to manage workflows for different components which include batch processing.

Environment: Quality Center 11.0, Agile-Scrum, Windows XP, Data warehousing, Informatica Power Center 9.0, SQL Server, SSIS, SOAP UI, IBM DB2, NoSQL, Unix, Oracle, MS Office Suite.

Confidential, Carrollton, Texas

Senior ETL Tester / Quality Assurance Analyst

Responsibilities:

• Involved in analyzing complex high-level business requirements, system specifications, understood business processes to determine test strategies.
• Design and wrote Test Cases by going through the mapping document.
• Working under the Agile based SCRUM methodology implementation.
• Worked on Team Foundation Server to track the defect status. Conducted defect triage call between the testers, developers and business.
• Configuring QTP Tool settings, object identification and globalizing the settings.
• Used Informatica Workflow Manager (Informatica 10.1.0) to create, Schedule, execute and Monitor Sessions, Batches/Worklets and Workflows.
• Extensively used Source, Target and Transformation shortcuts.
• Created Pre and Post session commands like created Stored Procedures to drop and recreate the indexes and keys of source and target tables.
• Extensively used Worklets and Mapplets which were reused across different releases.
• Creating Automation test plan and resources such as Object repositories, Function Libraries.
• Inserted verification checkpoints, synchronization points, and parameterized data using QTP.
• Developed Automated Test Scripts for Functional Testing using QTP.
• Created Test Traceability Matrix to ensure that all the requirements are covered by the test cases
• Wrote SQL queries & PL/SQL code on staging, ODS and Reporting Tables to validate the test data.
• Performed Web Services testing and Validated XML request/response data using SOAP UI.
• Conducted daily status meeting with the business, onshore team and solution team
• Created manual test cases in Team Foundation server for various user stories.
• Involved in development of SQL-queries/procedures for database/backend testing using SQL Developer
• Scheduled batches in Perfaware to run daily jobs.
• Involved in testing data mapping and conversion in a server-based data warehouse
• Performed regression testing against the various builds of the application
• Analyzing the Regression test results and reporting the results.
• Executed SQL queries within UNIX shell scripts in the UNIX environment
• Involved in Security testing for different LDAP roles.
• Used TFS to control versions of scripts and collaborate with the team
• Used T-SQL stored procedures to transfer data from OLTP, databases to staging area and finally transfer into data marts.

Environment: Team Foundation server (TFS), Agile-Scrum, Windows XP, Informatica Power Center 9.0, Data ware housing, Oracle SQL developer, SQL Server, SSIS, PL/SQL, UNIX, Quick Test Professional (QTP), Netezza, Perfaware, SOAP UI.

Confidential, Pleasanton, CA

Senior ETL Tester / Quality Assurance Analyst

Responsibilities:

• Involved in analyzing the business requirements created and executed Test cases.
• Wrote Test Plan and Test Cases by going through the LSDD (logical specification design Document and PSDD (Physical specification design document).
• Working under the Agile based SCRUM methodology implementation.
• Prepared test estimates for System integration testing and user-acceptance testing.
• Prepared the Test data and conducted test data walk through with business.
• Performed Input and output batch processing for the downstream (Region) and upstream process (KPEG)
• Have maintained test scripts in test scripts repository.
• Involved in System integration, User acceptance, Regression and workflow integration Testing.
• Wrote SQL queries & PL/SQL code on staging, ODS and Reporting Tables to validate the test data.
• Worked and understanding of historical data.
• Involved in developing Unit Test scenarios, test cases.
• Conducted daily status meeting with the business, onshore team and solution team
• Reviewed test cases based on functional requirements and business requirement specifications.
• Created recovery scenarios for handling the unexpected error in the application.
• Cloning the production data using Test data management.
• Created manual test cases in HP QC/HP ALM for various user stories based on release and spirit plan.
• Worked on Quality Center to track the defect status. Conducted defect triage call between the testers, developers and business.
• Conducted system and integration testing, debugged the software errors and interacted with developers to resolve technical issues.
• Created and maintained test metrics from Test support and metrics (TSM) for product quality assessment.

Environment: Quality Center 11.0, Agile-Scrum, Windows XP, Data warehousing, Informatica Power Center 9.0, SQL Server, SSIS, SOAP UI, IBM DB2, Unix, Oracle, MS Office Suite.

Confidential, Camp Hill, PA

Data warehouse Analyst

Responsibilities:

• Involved in analyzing the business requirements created and executed Test cases.
• Wrote Test Plan and Test Cases by going through the Design, Functional Requirements and User (Business) Requirements Documentation.
• Working under the Agile based SCRUM methodology implementation.
• Prepared the Test data for interpreting the Positive/negative/regression results.
• Created and maintained test matrices from available design documents and functional Specifications for product quality assessment.
• Have maintained test scripts in test scripts repository.
• Involved in Functional, Integration, System and Regression Testing.
• Wrote SQL queries & PL/SQL code on COT tables and Data Mart Staging Tables to validate the data results and documented
• Collaborated with other ETL experts in evaluating the efficacy of load processes and transactional data.
• Worked and understanding of dimensional model.
• Involved in developing and implementing customized Automation Framework.
• Involved in developing Unit Test cases.
• Reviewed test cases based on functional requirements and use cases specifications.
• Created recovery scenarios for handling the unexpected error in the application.
• Using SoapUI 3.5 to validate the Java SOAP Web Services in all environments.
• Extensively used SQL to perform data integrity test.
• Have experience in SQL and Data Analysis Skills for capturing the data.
• Worked on Quality Center to track the defect status. Experience in documenting test execution results, preparing test reports, and gathering and evaluating test metrics for reporting.
• Used Test Tracker/Test Director for the defect reporting and tracking.
• Have good experience in Shell scripting in UNIX environment connecting to different sandboxes.
• Generated reports using BI tools.
• Conducted system and integration testing, debugged the software errors and interacted with developers to resolve technical issues.

Environment: Quality Center 10.0, QTP 9.5, Agile-Scrum, Windows XP, Java/J2EE, WebSphere Commerce server, Informatica Power Center 9.x, Soap UI 3.5, SQL, IBM DB2, Unix, Oracle, BI, VISIO, MS Office Suite.

Confidential

QA/Data warehouse tester

Responsibilities:

• Interacted with Business Analysts, Users and Developers for collecting the Requirements in each phase of the product, to customize design and construct the application modules.
• Writing Test Plan, Test Strategy and designing Test Cases, executing the designed Test Cases and evaluating test results.
• Preparing Defect Management Report for all the testing phases in project.
• Used Quality Center to create and manage both manual and automated test cases.
• Wrote test cases and performed functional testing of the interface manually.
• Involved in Regression Testing and automated the scripts using QTP.
• Used GUI, Text, Bitmap checkpoints and synchronization statements extensively to customize the QTP Scripts.
• Created data driven script to be used with various data.
• Enhanced the script by inserting check points.
• Involved with negative testing and smoke testing.
• Responsible for analysis, reports and defect tracking using Quality Center.
• Defects encountered during the testing process were classified based on the severity and priority.
• Performed Back End testing on SQL Server to execute different complex queries.
• Actively attended meetings with fellow testers and other groups to evaluate the progress and Performance of the application.
• Involved in UAT phase with business owners.
• Participated in Walk through and review meetings.

Environment: Quick Test Pro, Quality Center, DHTML, SQL Server 2005, Visual SourceSafe, Windows XP, Java/J2EE, UNIX.