SUMMARY

• Over 8 Years of diverse experience in Quality Assurance Manual testing with expertise in requirements gathering, analysis, design, application testing & Quality Assurance of Web based applications.
• Experience in Data Warehousing technology in building and managing various data warehouse/ Data marts using Informatica and Teradata products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
• Good experience in both Manual and Automated testing of Object Oriented, Client - Server, Web based and N-Tier complex large scale applications.
• Strong Expertise in SDLC and Testing Lifecycle Methodologies like Agile Models, Rational Unified Process (RUP).
• Experienced in manual testing and automated testing using Test Suite like QTP, Quality Center.
• Strong in analyzing Business Requirements and specifications and development of Test Plans, Test Scripts, Test Cases and their execution.
• Experience with Agile and Waterfall methodologies
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Performed data validation for Teradata Mload script and OLE Load for loading data into Teradata from various sources.
• Extensively involved in Developing Stored Procedures, Functions and Triggers using T-SQL
• Highly skilled in managing system diagnostics and fully automotive troubleshooting activities
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Experience with mobile and wireless connectivity architecture would be preferred.
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, and Marine.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Customized the QTP test as per the test Case by using the VB-Script
• Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
• Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
• Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Depth noledge of Defect management tools and Bug Reporting Tools including Quality Center.
• Experience in Functional Testing, Data Driven Testing, Load Testing and Validating WSDL using SOAPUI.
• Experience in VB Scripting, Groovy Scripting and SQL Queries in Backend Testing
• Good experience in Error Log file check, to no Process Status using Unix
• Excellent interpersonal and communication skill. Good documentation and process management skills with ability to effectively understand the business requirement to develop a quality product.

TECHNICAL SKILLS

Testing Tools: QTP, Quality Center, Test Director, Testlink

Bug Reporting Tools: Quality Center, IBM Rational clear Quest and Trac

Programming Languages: Java, C++, HTML, HTTP, MS FrontPage, XML JavaScript, SQL, Shell.

Software Packages: MS Office XP Suite

Data Bases: Oracle, Teradata, DB2, MS SQL Server

Operating Systems: Windows NT/2000/XP/Vista/7, Unix and Linux.

PROFESSIONAL EXPERIENCE

Confidential, Westchester, PA

Sr. QA Analyst

Responsibilities:

• Worked extensively with business users on requirements gathering, analysis and documentation.
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Involved in Smoke, Functional, Integration, System, E2E, Regression, UAT Test Execution and Management.
• Reviewed/Prepared test documents including TDD/RDD, UAT Test Plans, Test Scripts, Use Cases and all project artifacts.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• End to End regression and functional testing of all system components of the application and identifying test scripts for UAT.
• Experienced in Test schedule planning, Batch Test Scheduling and Execution.
• Wrote T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Insured dat Production Control Staff was up-to-date on Control-M procedures and software use.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology me.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming.
• Aggregation and automated AML checking for the eligible data against SDN/Blocked Persons lists and other information
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures
• Maintained and updated FTP set up using Control-M for Production.
• Ensured the timely delivery of different testing milestones with Batch Testing, Key word driven testing, Hybrid testing, functional driven testing.
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Able to create complex JIRA workflows including project workflows, screen schemes, permission scheme and notification schemes in JIRA.
• Develop and maintain system for organizing and tracking execution of test plans in JIRA.

Environment: Teradata, Informatica Power Center, Quality Center, Windows NT, Business Objects, Oracle 8i, SQL Server, Python, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD, Websphere, Control M, JIRA.

Confidential, Chattanooga, TN

Sr. QA Analyst

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing
• Participated in Regression testing after each build.
• Extensively worked in agile environment, with daily scrum meeting, stand up meetings, presentations and review
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Datastage.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Developed the integrated development life cycle by integrating Rational Requisite Pro, Rational Quality Manager and Rational Requirements Composer (RRC) with Rational Team Concert.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Loading Flat file Data into database tables using Unix Shell scripts.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Validated Business Objects Reports and Universes against Datawarehouse/Data mart Database by writing SQL Queries
• Performed data quality analysis using advanced SQL skills.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.
• Validated data in between source and target after running Mappings in the Datastage.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints
• Tested and validated the Business Objects reports by running similar SQL queries against the source system (s)

Environment: Quality Center/ALM (HP Application Lifecycle Management 11.0), SQL Server 2012, UNIX, Oracle 11g, Teradata, Datastage, SQL, PL/SQL, Teradata SQL Assistant, Oracle 10g, SAP BO, Agile, MS Office, Teradata 12, Business Objects XIR4, Cognos, DB2, XML, HTML, Windows and Unix, Shell Scripting.

Confidential, CA

Sr.QA Analyst

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Involved in Data Extraction from Teradata and Flat Files using sql assistant
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Worked in an Agile technology with Scrum
• Written several UNIX scripts for invoking data reconciliation
• Reported bugs and tracked defects using Quality Center
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QTP QuickTest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology me.e. backward navigation from target to source.
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Tested Cognos reports to check whether they are generated as per the company standards
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center, Teradata, Cognos 7 Series, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server, Agile, SQL, PL/SQL, Unix, SQL*Plus, Quality Center, TOAD and Shell Scripting.

Confidential, Thousandoaks, CA.

QA Analyst

Responsibilities:

• Designed, developed test cases and coded automation scripts to test end-to-end applications as per Business Requirements.
• Involved in the end-to-end testing using QTP and responsible for the Quality-Assurance of dis application.
• Documented test cases corresponding to business rules and other operating conditions and generated the Daily Test reports about Test status and Defects summary.
• Used programming language (Microsoft's VBScript) to test the web-based applications in HP-QTP (QuickTest Pro) tool for Automation testing.
• Created test cases and performed load testing in Soap UI to test the web-services.
• Extensively tested for complex logical, positive, negative testing.
• Created several test scripts using QTP, which includes data-driven tests and batch tests
• Performed Record and play back method In QTP.
• Customized Automation Framework using Data driven framework, and Functional testing by writing VBScripts in keyword driven framework of QTP.
• Worked on Test Cases to validate the XML SOAP response.
• Performed Load testing using SOAPUI tool.
• Performed extensive backend testing to ensure data integrity using SQL developer.
• Maintained test cases and defects using Quality Center and Clear Quest.

Environment: QTP 9.0,ETL, SQL Server, SSRS, SSIS, HP Quality center 9.0, SoapUI, Rational Clear Quest, Java, Firefox, Safari, IE, UNIX, Windows, HTML.

Confidential

QA Tester

Responsibilities:

• Analyzed user business requirements, functional specs and assisted QA Team lead in writing the Test Plan.
• Involving in functional, system and user acceptance testing.
• Wrote Detail Test cases for automation and used WinRunner to automate.
• Used Test Director for Test Management and Maintained the Test Cases and Test Scripts.
• Executed test cases and documented bugs found during the process of testing.
• Involved in tracking defects, preparing bug profile and send them to the team lead.
• Wrote SQL Queries to extract data from the Tables.
• Tested application at module level and system level for the quality of the software.
• Wrote the documentation and updated the same as on when the functionality changes.

Environment: Test Director, UNIX, SQL Server, Power Builder, Windows NT, MS-Excel.