Avitha

Ph #:408-***-****

Email:acrvol@r.postjobfree.com

Summary:

Over 8+ years of diversified experience in Banking/Mortgage, Health Care and Manufacturing industries,Consulting, Vast knowledge of Software Development Life Cycle & its methodologies,

Expert in Quality Assurance testing of Web Based and Client/Server applications.

Expert in using the Agile/Scrum, RUP and Waterfall testing lifecycle Methodologies

Experienced in Developing, Reviewing, and Executing Test Scenarios, and Test Cases/Scripts.

Proficient in using Mainframe application (TSYS_ Total Systems), VTS (Visa Simulator) and MC (Master Card Simulator) for credit cards authorization.

Experience in manual testing process and in creating automation test environment using Quick Test Pro (QTP), Load runner, Agile ALM (Quality Centre) applications, SOAPUI, Quality Center .

Expertise in test strategy design based on the various types of testing including unit, integration, function, system, usability (UI),End to End, security, load, stress, capacity, performance testing and post implementation testing.

Performed manual and automated test procedures for functional and performance testing, load and stress testing, scalability and compatibility testing, and usability testing of GUI and Web based applications.

Strong knowledge of SQL and database

Advanced in Microsoft office (Word, Excel, Power Point, Outlook, Project& Visio)

Proficient in SQL query and testing RDBMS such as Teradata SQL Assistant, SQL Server for data validation.

Experience in Business Intelligence in generating various reports using Micro Strategy, Cognos and Business Objects

Experience in bug reporting and bug tracking using management tools such as Quality Center and communicated recorded problems to the responsible QA or development personnel.

Adept in using testing tools like Test Director, HP Quality Center, ALM to write and maintain Test scripts

Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.

Strong Skills in using Integration, Functional, Regression, End to End, Ad Hoc and UAT Testing.

Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame

Experience in Dimensional Data Modeling using Star and Snow Flake Schema.

Automated and scheduled the Informatica jobs using UNIX Shell Scripting.

Experience in all phases of Software Development life cycle.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile

Application: Mainframe (TSYS), VTS (VISA Simulator), MC Simulator

Testing Tools: Mercury/HP's Interactive Quick Test Pro, Load Runner,( HTTP Watch), SOAP UI,

Watij Pega.

Bug Reporting: Test Director/Quality Center 10, ALM 11,Jira, Rally, Clear Quest

Application Servers: Web Logic, Web Sphere, IIS, Apache

Data warehousing Tools: Informatica Power Center 8.x/7.x/6.x, Power Exchange, Informatica Data Quality, IBM Data Stage 7x, Ab Initio

Databases: SQL Server 2008, Oracle 10g/9i/8i, Teradata v2r6, DB2, Sybase, Oracle

CRM Package

Languages: C/C++, .NET, JAVA, VB, SQL, PL/SQL.

Database Utilities: BTEQ, Fast Load, Multiload, Fast Export, TPump, TOAD 8.0/7.1, SQL*Plus,

SQL*Loader, SQL NavigatorSQL Server 2008, Oracle 10g/9i/8i, Teradata v2r6, DB2, Sybase, Oracle

CRM Packag

Scripting Languages:Shell Scripting, Shell, C Shell, Bourne Shell, Bash

Professional Experiences:

United States Patent and Trademark office, Alexandria,VA Aug 2014-till date

Role: QA Manager/Sr. Quality Analyst

The United States Patent and Trademark Office (PTO or USPTO) is an agency in the U.S. Department of Commerce that issues patents to inventors and businesses for their inventions, and trademark registration for product and intellectual property identification.

Working on manual testing and for functional usability testing of GUI and Web based applications knows as TMNG Internal (Trademark Next Generation ).

Tested in different types of testing including unit, integration, function, system, usability (UI),End to End, security, load, stress, capacity, performance testing and post implementation testing

Migration of TRAM(Old version of TMNGI) web application to TMNG (Trademark Next Generation).Testing on data migration using SQL query. Validating and verifying the data.

Worked intensively on production support.

Working on Java based web application called as TMNGI.

Assigning the Task, raising the Defects, Assigning the defects to the developer, Retesting the defects and closing them or reopening them if not fixed in Rally.

Worked on creating executing Test scripts.

Verifying the test data by writing complex SQL Query’s using Joins,Conditions and Functions.

Involved in Test plan and written Test Scripts and executed them.

Environment : Rally, SQl server 2012, Test complete, Java .

Transaction Network Services Inc, Clifton park,NY Aug 2013-July2014

Role: Automation /UAT tester Lead

TNS delivers managed communications solutions to service providers and enterprises on a global scale. Thousands of companies from the retail, banking, financial markets

Extensively interacted with Business Analyst and the management teams to understand the requirements and report the status of the testing efforts on their applications

Working on .NET Frameworks and MS Windows by creating B2B merchants.

Performed Security testing and execute automated tests scripts.

Working on with a continuous integration server on which the automated tests developed were run regularly against the current build.

Attended daily SCRUM meeting and SCRUM of SCRUM meetings for each sprint.

Test Plans and wrote Test Cases and Executed Test Cases using manual testing methodology.

Weekly meeting with the management team and share the Status Report on the weekly basis.

Performed Smoke testing, Information Security testing Positive testing, Negative testing, Configuration testing, Batch testing, Security testing, Integration testing and User Interface testing for PEGA

Prepared system testing plans, test cases, and accurate test estimates as a regular part of your role

Used Defect Management Tools (Rally),RUP handled the exceptions using recovery scenario manager in QTPQTP has a unique feature called Smart Object Identification/recognition. QTP generally identifies an object by matching its test object and run time object properties.

Automated Functional Tests with running the scripts in QTP

Checked the data flow through the front end to backend and used SQL queries o extract the data and validated the output results from the database.

Used test complete for Functional testing and Unit testing

create and perform advanced White Box, Test Automation, or Performance Testing duties for System, Integration or Regression Testing activities on projects, including execution suites, defect logs, and reporting results.

Automated test scripts in test complete is run independently also by integrating into keyword tests to make your keyword-driven testing more powerful and flexible.

Test Complete provides various checkpoints that helped in easily validating the applications behavior also checkpoints can be added while recording and editing your automated tests

Worked with Agile ALM applications and Team Foundation Server (TFS)

Environment: Rally,PEGA,Teradata SQL Assistant,, Test complete, Agile Methodology, Microsoft Excel, Macro, SQL, MS Window, Putty, RUP, Quality Centre

JPMorgan Chase, Wilmington,DE Aug2012– Aug 2013 Role: UAT tester Lead

Projects:

Re-Issue

Over limit & Delinquent Decline

Fraud Authorization

Control Zones

Mobile Testing

Credit Risks Authorization Decision Engine (ADE) structure and flow makes Credit and Fraud Authorization decisions to Approve, Decline, and Grant Additional Credit above the Credit limit or hold below the Credit Limit based on the customer profile. It also decides the suspected fraud authorization to Decline or Approve or Queue. This application enables to deploy the Credit probability to improve the credit decision and deploy new strategy flow and robust econ evaluation. It impacts 52MM/month benefits on top of initial Rule set release.

Responsibilities:

Involved in all aspects of the software development life cycle

Designed test cases and test in JAVA based system.

performed testing of web services, Web UI and batch jobs

Prepared Test Cases and developed Test Matrix for various scenarios.

Authorized different accounts in the mainframe application TSYS (Mainframe), VTS and verified the actual results in the database.

Used different screens like IAGI, ICAU, IRSS, WFRD, WACZ, MAGI, IAPH, IACH, MPTI in TSYS to select and check the account for conditioning and executing.

Used ICAU screen for credit purchases through TSYS.

Handled the exceptions using recovery scenario manager in QTP

QTP has a unique feature called Smart Object Identification/recognition. QTP generally identifies an object by matching its test object and run time object properties.

QTP may fail to recognize the dynamic objects whose properties change during run time, Core Banking

Derogatory Status of the account is checked in the IASC screen and also conditioned as per the criteria using different screens.

Validate Credit Cards Authorizations by using TSYS Screens and Teradata for Backend testing.

Performed Stress, Negative, Positive, Regression, Functional, backend testing, Web based development experience and UAT testing.

Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements in the Quality Center.

Created and work with database using QTP scripts.

Checked the data flow through the front end to backend and used SQL queries in the Teradata SQL Assistant, to extract the data and validated the output results from the database.

Validated the load of data to the environment using SQL queries and Validating the log files after the process run.

Checked the data flow through the front end to backend and used SQL queries o extract the data and validated the output results from the database.

Created a Regression Test Suite which can be progressively updated for new release of the application.

Updated the Test Scripts for Regression build based on the enhancements to the application.

Involved in the post implementation testing in the production region.

Used Quality center for maintaining and reporting the defects to the assigned developer.

Prioritized bugs according to severity level described.

Triggered and Tracked Defects in the Quality Center.

Performed the final validation of the test scripts against updated BRD and BRE versions before release and QTP and Test Automation

Weekly meeting with the management team and share the Status Report on the weekly basis

Good SQL knowledge and able to create and work with database using QTP scripts.

In-depth knowledge of quality management methodologies, principles, metrics and tool

Solid organizational skills with proven ability to multi-task, handle multiple assignments simultaneously, and effectively bring discussions and issues to closure

Solid project management skills, including ability to coordinate, negotiate, schedule and communicate with all levels of staff

Checked the data flow through the front end to backend and used SQL queries o extract the data and validated the output results from the database.

Used test complete for Functional testing and Unit testing

Automated test scripts in test complete is run independently also by integrating into keyword tests to make your keyword-driven testing more powerful and flexible.

Hands-on experience reviewing test documentation including strategies, plans, cases, scripts and results

Environment: Quality Center, Java, Mainframe (Total Systems (TSYS)), Teradata SQL Assistant, VTS (Visa Simulator), Master Card Simulator, Agile Methodology, Microsoft Excel, Macro, SQL, Windows XP,

Idaho Department of Health and Welfare,Boise, ID Nov2010-July2012

Role: QA /Cognos Developer

IDHW deal with complex social, economic and individual issues, often helping people in crisis situations. Our programs are designed to strengthen families and promote self-reliance. Last year, we served almost 340,000 people, one out of every four Idahoans.

The project was migrating cognos 8.4 V reports to OBIEE 11V and also back-end testing on a Oracle 11 database migration project

Responsibilities:

Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

Participated in business requirement walkthrough, design walk through and analyzed business requirements.

Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as manual test scripts.

Tested complex ETL mappings and sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Checked the data flow through the front end to backend and used SQL queries o extract the data and validated the output results from the database.

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Worked on HTTP watch for load testing

Designed and developed the Framework Manager Models and Published into server for further use in the report authoring process.

Built models containing namespaces, level hierarchies, query subjects, query items and members from scratch as well as from imported metadata.

Designed & developed reports using Report Studio, created ad-hoc reports using Query Studio and helped business user in creating Analysis reports using Analysis Studio.

Used Drill-up/down and Drill through functionalities to give a detailed and analytical report. Applied Cascading Prompts functionality in runtime for narrowing the final results for better understanding of the requirement.

Implemented Data level, Object level and Package level security in Framework manager

Environment: Informatica Power Center 8.1/7.1/7.0/6.1/6.2.1/5.1, Cognos 8.4v, SQL, Unix, Shell scripting, Windows XP, Oracle

Booz Allen Hamilton, Herndon, VA Apr2009-Oct2010 Role Sr. ETL/SQL/BI Backend/Database Tester

BAH is an American consulting firm, with 80 other offices throughout the United States. It is recognized as one of the most prestigious technology consulting firms in the world Developed, documented and maintained Test Strategy, Test Plan & Testing approach. I was involved in testing the application whether the correct data according to the rules and regulations are updated in the RADAR application by automation and manual testing.

Responsibilities:

Extensively written several Test Scripts to compare source and target database.

Analyzed the requirements and wrote simple to complex queries to test the requirements.

Performed Dry Run on the test scripts before System Integration Testing.

Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing

Validated data from source to stage and stage to target database.

Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.

Worked on Informatica workflow monitor to create and execute workflows

Performed record count from source to target database

Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.

Extensively worked with flat files and Excel sheet data sources. Wrote scripts to convert Excel to flat files.

In the process of data migration, migrated data from an Oracle data source to Teradata.

Prepared test/Seed data for various positive and negative testing scenarios.

Performed tests to check whether there is any loss of data during data loads

Tested reports daily, weekly, monthly based reports

Involved in RDBMS Programming Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming.

Tested Micro Strategy reports and written test cases using HP Quality Center.

Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.

Extensively worked on Quality center to execute a bunch of test scripts.

Logged the defects found in quality center while execution of test scripts

Tracked the bad records present in the table.

Tested all the reports by running queries against the warehouse-using TOAD.

Also compared those queries with the Micro Strategy SQL engine generated queries.

Validated the data present from flat files to database

Wrote complex SQL queries using Teradata SQL assistant and toad for various testing purpose

Developed test/QA environment using Informatica.

Created mappings and executed workflows using Informatica power center

Tested Daily, Weekly, Biweekly and Monthly data loads.

Tested the layout of the table from the database to the data model.

Environment: Teradata SQL assistant 13.0, Micro Strategy, Toad for Oracle10g, Informatica Power Center 8.6.1, MS Excel, Erwin Data Modeler, SQL loader, Quality Center, Cobol Files, SAM Files, UNIX, Business Rules Repository GUI(BRR), Business Process Application GUI(BPA), Data Quality Monitor GUI (DQM)

Milguard Manufacturing,Tacoma,WA Jul2008-Mar2009

ETL/ BI/database Tester/ DWH QA

Responsibilities:

Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.

Responsible for data validation testing using SQL and executing testing on data Warehousing projects.

Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.

Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Used Micro Strategy tool reporting and data analysis of data stored in relational database, multi-dimensional and flat files.

Developed and Tested UNIX shell scripts to move source files to archive directory.

Involved in extensive data validation using SQL queries and back-end testing

Used HP Quality Center for test scripts creation, execution, test coverage and defect tracking

Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.

Used standard testing techniques to test the data validity before deploying the Micro Strategy Reports to Users.

Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Promoted Unix/Informatica application releases from development to QA and to UAT environments

Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.

Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.

Tested ETL Packages, Scripts from development to QA environment.

Plan tests with Quality Center (Design Steps and Run Tests) and also prepared detailed documentation with Screen Shots

Tested the reports using Micro Strategy functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.

Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.

Tested whether the reports developed in Micro Strategy are as per company standards.

Developed test reports and participated in testing prioritization and archived test results and user signoff.

Involved in extensive data validation using SQL queries and back-end testing

Used SQL Server Management Studio for Querying SQL Server 2008 databases.

Strong Informatica and data loading experience.

Written complex SQL queries to validate the data against the target based on ETL mapping specifications.

Used Tidal scheduler for composing and executing the jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.6.1), UNIX, Micro Strategy, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Server 2008, Oracle 10g, MS Excel, HP Quality Center, TOAD, Win SQL, Teradata SQL Assistant, XML Spy 2010, XM L Files, MVS, JCL, COBOL II, Copy Books, VSAM Files, CSV Files

Avon Technologies, Hyd, INDIA Jan 2006-May2008

QA Analyst

Responsibilities:

Performed manual testing of the application interacted with developers to discuss the technical problems.

Involved in project coordination and implemented QA methodology.

Created detailed test cases, test plans, Test Strategy documents and maintained them in Test Director.

Manually executed the test cases and recorded the Pass/ Fail Results

Created test logs and test summary reports using Microsoft Word/Excel.

Performed regression testing and identified software errors and interacted with developers to resolve technical issues.

Checked the data flow through the front end to backend and used SQL queries o extract the data and validated the output results from the database

Responsible for the delivery and ensuring quality of the deliverables

Responsible for reporting to the team leader for day-to-day activities and status.

Education:

Bachelor of Engineering, OU, India 2006.

Master’s in Business Administration,USA 2012.

Contact this candidate