SUMMARY:

• A Technically adept professional with 7 + years of dual background experience in Business Analysis and Quality Assurance, with particular expertise in requirement gathering, analysis, Relational database design, and Reporting.
• 7 years of Experience in analyzing/validating wide range of web - based applications such as Decision Engine, Telecom Commissions, E-commerce, Retail, Banking, E-Learning, Mobile application, Content Management & HR industry domains
• 4 + years of solid experience in Relational database analysis, writing Complex SQL queries for MS SQL Server databases and solid experience in ETL (Data Migration) Testing using SQL automation scripts.
• 2 + year of Hands on experience in writing and executing automated VB testing scripts primarily with Quick Test Pro (QTP 11), UFT12.52
• Experience in Report generation and Extraction of Data using SQL queries and Experience in using Excel and Visual Basic
• Analyzed Requirements, performed Prototype Design and Developed Database design and ER diagram using Oracle designer; Solid experience in using Varicent tool, Winscp and FileZilla.
• Experienced in developing test strategy and plan, writing test cases, executing testing operations, and evaluating results based on requirements
• Managed requirements, test cases, defects using Testing Tool TFS, Quality Center 12.53; Generated test case reports in QC using tables, graphs, data presentation, etc.
• Used Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests
• Developed Use Case, Context and Process Flow diagrams using Star UML and Visio

TECHNICAL SKILLS:

Methodologies: RAD, Agile/Scrum, Waterfall

Automated Testing: Quick Test Professional (QTP11), UFT 12.52

Databases: Oracle 11g, MS SQL Server 2012,SQL Azure

Workflow: MS Excel, MS Word, MS PowerPoint

Tracking: TFS, Quality Center 12.53

Languages: C, C++, Java, VB, VB Script, SQL, HTML

Use Case: Star UML, MS Visio

Database Design: Oracle Designer, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Responsibilities:

• Did Functional Analysis for BCS, IPDM applications and came up with different test case scenarios and tracked those test cases in QC.
• Designed and executed complex SQL scripts for corresponding test cases to evaluate product quality.
• Performed integration and backend testing by writing SQL Scripts
• Created automated test scripts for 90 test cases (Minimum 40 steps each) where I created own functions for different scenarios using UFT 12.52 and VB Scripting Language.
• Made use of existing functional libraries for some scenarios; Attached the test data file and shared object repository with each test case. Stored the test scripts in ALM.
• Used Data table for parameterization; Used Shared object repository for the common objects used by all test cases; Used Local OR for objects used by specific test case.
• Did some workarounds in Object identification by using Mandatory, Assistive properties, Smart Identification, Ordinal Identifier, regular expression as many objects in the application are not identified by UFT
• Used descriptive programming for creating some functions to bypass the OR usage.

Confidential

Responsibilities:

• Involved in Functional analysis by reviewing the Business Requirement Documentation
• Run and did the troubleshooting for 1200 automated test cases which were written in XACML/RPC format in the test client.
• Did the below troubleshooting if it failed:1) The expected result given in XACML test case might be wrong 2) The actual Decision Engine result might be wrong 3) It might be test data error.

Confidential

Responsibilities:

• Analyzed the Confidential Solution Definition document and came up with different test case scenarios and tracked those test cases in QC.
• Validated these test cases in five Environments (Testing, General production, financial production, and Financial Recovery disaster
• Validated if the Confidential routes the file from producer to the correct consumer with the expected file format using the right protocol in right O/S.
• Validated the partnership setup done by the Dev team which determines the file routing.
• Did the below troubleshooting if the file didn’t reach the consumer, 1)Partnership setup done in Confidential (2)If partnership was right, then analyzed Confidential
• Sent test cases execution report using tables, graphs, data presentation, etc.

Confidential

Responsibilities:

• Learnt ATG UFT Functions and got the overview of the functions (Purpose of the functions and the parameters to be passed).
• Understood the code logic for all ATG functions
• Participated in ATG production runs and learnt to create Driver file, Data file, Environmentvariable.txt and Results file.

Environment: SQL Server 2012, Quality Center, TFS, UFT, .Net, Windows XP

Confidential, Bellevue, WA

QAT/UAT Analyst

Responsibilities:

• Reviewed solution business requirements and functional and technical design documentation to gain a thorough understanding of the testing requirements.
• Developed test plans, test cases to test and validate product requirements.
• Designed and executed complex SQL scripts for corresponding test cases to evaluate product quality.
• Performed integration and backend testing by writing SQL Scripts;
• Configured the testing environment appropriately and Set up the correct test data according to the test scenarios such as Base compensation, Spiff commissions, Modifiers.
• Inserted the test data in Varicent Commission tool.
• Verified the test results with the expected result after Varicent calculation is finished.
• Debugged the Varicent tool to know which Calc Component failed if result mismatched.
• Logged the Defects using Quality Center and followed up on arising issues
• Wrote QC test scripts for all the test scenarios in Excel and uploaded them in QC.
• Wrote Automation SQL script using business rules to compare the expected Spiff commission with Actual Paying commission. Debugged the Varicent Calc, Spiff Setup if any difference.
• Sent DSR (Daily Status Report) to the Sr Management for the Spiff Commission comparing Expected to Actual Spiff Count, Sum and reported the difference.
• Handled a complex B2B SCF individually (SCF -Quota, Attainment, Commission base, Payout proration during mid-month title change) & came up with test scenarios and executed all the scenarios with data setup and coordinated with the cross functional team (Business and Development). The project went successful and reduced lot of payout impacts on B2B commissions system.
• Performed Integration testing by receiving data from Adapter and exported those files to the ECS Varicent server using FileZilla and tested all the scenarios related to Adapter Data issues.
• Tested 30 SCFs for B2B, Retail Modules of ECS and used SharePoint to co-ordinate with other teams.
• Involved in writing and testing QC scripts for Universe project which replaces the existing upstream systems(Samson-Prepaid, RPX-Postpaid) and Universe becomes the one single system which gets all prepaid and postpaid transactions through it and I also involved in writing Data migration test scripts for universe where all new transactions will come through Universe and the old transaction are migrated to Universe and reached ECS for the commission's calculation and this project is first implemented in Grey market.

Environment: SQL Server 2012, Quality Center, TFS, .Net, Windows XP

Confidential, Redmond, WA

QAT Analyst

Responsibilities:

• Tracked defects using TFS; and contributed to writing/executing test cases for database testing.
• Wrote ETL (Data Migration) Test Specifications; Performed Data Migration testing such as data to data validation and data mappings using SQL Queries.
• Tested all Staging ETLs for data to data validation, data type (length and type) validation.
• Wrote Automation SQL Test Scripts for ETLs based on the new system’s business rules.
• Performed functional, smoke, sanity, End-to-End and regression testing.
• Performed End-to-End testing that involves testing Source UI & DB with Destination UI&DB.
• Involved in View and Stored Procedure testing; Generated Database Scripts - Table, Load, Alter and Drop Scripts; ;Checked data flow among tables and verifying data flow between UI and database.
• Pinpointed multiple application defects and deficiencies in functional flow and assisted in defining solutions.
• Flashed the Test Device using the latest test image (Blue) using FFU Tool.
• Downloaded the Application Xap files in both Test (Blue) and Reference (Apollo GDR2) Devices using AppCompatAssistant Tool.
• Read the description and requirements of each app using the WP AppCompat Online tool.
• Executed different test scenarios such as install, launch, tombstone, and SIP etc using specific memory and resolution on both the devices and involved in LCT test pass by running Pandora, Pinterest in back.
• Updated the results in WP AppCompat Online tool and reported the bug using Product studio.
• Found Call Stack when the application is crashed and attached it with the bug; Involved in trouble shooting the issues dealt with SD card; Involved in Performance testing using different scenarios and involved in UIF bugs.
• Prepared Master bug report and Initiated Test pass kick off and sent bug report to the offsite Team manager which includes number of apps tests done by each tester and their bug count and Mentored junior test members when they joined the project.

Environment: SQL Server 2012, Oracle 11g, TFS, .Net, Windows XP, SQL Azure

Confidential, Phoenix, AZ

Quality Assurance Analyst Intern

Responsibilities:

• Played central role in intensive effort to automate hundreds of test scripts for screens within AJACS web-based application; used QTP and VB Script to convert from manual scripts.
• Used Quality Center (QC) to manage defect flow.
• Contributed to analysis of system features, creation of test plans and cases, and import/export of data from Excel to QTP.
• Parameterized fixed values in checkpoint statements and created data tables for parameters in QTP.

Environment: SQL Server 2012, Toad, QC, QTP, .Net, Windows XP

Confidential, Mesa,AZ

Quality Assurance Analyst Intern

Responsibilities:

• Developed test plan, cases, and scripts for the web based application; performed black box, white box, smoke, regression, and functional testing; and conducted automated testing using WatiN; Used Team Foundation Server (TFS) to manage defect flow
• Worked with complex transactions and validated database using SQL; managed traceability between user requirements and test cases; tested user interface inconsistency and application functionality.
• Completed .Net course at Paradise Valley Community College, Phoenix, Az.

Environment: SQL, WatiN, Oracle 9i, TFS, Toad, .Net, Windows XP.

Confidential, Troy, MI

Requirement and Te sting Analyst

Responsibilities:

• Partnered with business leads, developers, and testers to create requirements tree; participated in requirements analysis.
• Performed Database design, Prototype Design and prepared Functional specification and mapped individual test scripts accordingly.
• Used TFS to record, detail, and assign bugs to concerned developers; Suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Wrote SQL queries for reporting purposes and to test database’s transactional integrity.
• Documented existing Check Acceptance module; developed context diagram, use case diagram, and functional requirements for tool used in reconciling daily sales with bank activity.
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams.

Environment: Windows NT/XP/2000, SQL Server 2005, TFS, MS Office Suite, .Net, VISIO, Star UML, QTP