Summary

Accomplished and results driven professional with 6 plus yearsof professional experience as a Software QA Engineer/Analyst in reviewing product requirements, reviewing designs, creating test plans test cases,review and tested the reports, demonstrated ability to communicate and work with co-workers at all levels

• Strong skills inmanual and automated testingof web services, web applications on Windows and UNIX operating systems.
• Ability to work on Agile, SDLC, Scrum and challenging environments with focus on product delivery. Be consistent and committed to Quality goals.
• Actively involved in various phases of testing life cycle such as functional, regression, integration, system and User acceptance testing.
• Have clear understanding and experience with Data warehousing and Business Intelligence concepts including OBIEE, Cognos 8 BI, SAP Business Objects with emphasis on ETL and life cycle development using Informatica Power Center, Repository manager, Designer, Workflow Manager and Workflow Monitor.
• Proficient in using ALM Quality Center.
• Experience in UNIX Sun Solaris, basic shell scripts, Dimension modeling, and data warehouse concepts.
• Experience in testing financial, billing and Telecom applications.
• Experience in Oracle 9i/10g RDBMS, PL/SQL programming, SQL*PLUS.
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing the SQL queries on Oracle database.
• Experience with manual/black boxtesting, mobile testing, White box testing and automated functional and load testing of Web based Applications as part ofeCommerce applications.
• Performed GAP analysis of business rules, business and system process flows, ensuring accuracy and deadlines were met.
• Interfaced with business users to prepare and update Business process BPR and software system requirement SSR, created test cases and test scripts.
• Good knowledge ingame testing.
• Experience inETL processesconsisting ofdata sourcing, data transformation, mapping, conversionandloading.
• Experience in mapping analysis, test case preparation, test execution, defect reporting, and regression testing and final documentation.

TECHNICAL SKILLS

Language:

HTML, Core Java, Web Services, SQL, JavaScript , PHP,C, Python

Databases:

MS Access, Oracle10g 11g, DB2,Microsoft SQL, MySQL, PL/SQL

Operating Systems:

Windows 95/98/NT/XP, UNIX ,PuTTY

QA Tools:

Quality Center 8.2,9,9.5/10, QTP 10.0, LoadRunner, JIRA, Silk test , Bugzilla, Selenium IDE

Microsoft Applications:
Additional Skills

MS Word, Power point, Excel.
ETL Tool: Informatica 7.1/8.6,9.0,OLAP Tool: Business Objects 3.1 X, Cognos 8BI, Oracle Business Intelligence OBIEE11g, Raid SQL, Teradata, Word, PowerPoint, Visio, Sql Developer, Toad, Rapid SQL.

PROFESSIONAL EXPERIENCE

Description: Support site is a big web portal application, where customers get all the service and support for their product. Its offers multi- services along with maintaining the product related online help documents. The backend is SAP data provider.

Responsibilities:

• Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
• Utilized advanced MS Excel and database design to create test cases in mapping process.
• Provided specifications and instructions for Operations team to build QA and stage environments.
• Worked Test plan and Detailed Test case document.
• Extensively worked in HP Quality centre, maintained all the test cases.
• Worked in releases for every 2 months with bug fixing.

Environment:SAP, ALM Quality centre 11.0, Web services, Window, Linux, J2EE

Confidential, Emeryville ,CA
Web Application
QA Analyst May'12-Oct '12

Description: Online animation school that teaches students character animation skills. Animation Mentor is a distance learning school at which animation professionals teach character animation to students in over 50 countries.

Responsibilities:

• Involved end to end testing of complete web based site.
• Perform cross browser testing and file many bugs with detail issues.
• Reviewed business requirements and technical specifications.
• Performed positive and negative test scenarios including functional testing, GUI testing, system, integration testing, backend testing with SQL server database.
• Developed test plan for functional testing Student.animationmentor.com project.
• Performed testing on Cart Application and Credit card check, billing.

Environment:SQL Server 2005, Apache, Cold fusion, Web services, Window, Bugzilla, Higher Reach Jenzabar

Confidential, San Francisco ,CA
WRTT - Master Data Mart
ETL Tester/QA Analyst Feb'11 - Apr'12

Description: Managing changes in the Master Data Mart as part of the merger efforts between Wells Fargo and Wachovia in the brokerage business. This highly visible data warehousing project represented an effort to provide a view into and interact with wealth data using a single OBI (Oracle Business Intelligence) Dashboard utilizing agile methodology. This dashboard provided flexible investment reporting functionality, views and client-facing reports, as well as integration of Risk Monitoring functionality and Risk Optics product information including brokerage, Private banking and Compensation.

Responsibilities:

• Participated in the requirement gathering of the various work streams by meeting with the Business user, base lining the details and documentation.
• Interacted with business analyst and developers in requirements analysis, design reviews, testing and documentation for application developed in Agile environment.
• Reviewed business requirements and technical specifications.
• Developed test plan for financial project such as Brokerage, Private Banking, Investment management as well on reporting functional domains and delivered the Quality products time to market.
• Ability to multitask as a result worked more then 3 projects at a time
• Utilized advanced MS Excel and database design to create test cases in mapping process.
• Provided specifications and instructions for Operations team to build QA and stage environments.
• Extensive experience in writing test plan for using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Good experience in Integration Testing to verify the required functionality of mapping (Session) in the environment specific to testing team.
• Identified test cases to ensure that correct numbers of rows (validated records) are transferred to the target from the source.
• Monitor production validation of monthly loads, daily loads and weekly loads.
• Monitored the Informatica workflows using Power Centre monitor. Checked session logs in case of aborted/failed sessions.
• Tracked defects using Jira and generated defect summary report.
• Maintained MDM standards and making sure the mappings and workflows are following MDM standards.
• Identified and logged the defects in Quality Canter. Participated in the Defect Review Meetings.
• Maintained and executedautomated Testscripts using QTP 10.0 as per the requirement
• Researched and troubleshoot customer data during all phases of ETL, starting with load and processing issues involving extracts, file formats, character sets and formatting issues and other data gaps.
• Deployed new builds and maintained the QA Environment.
• Extensively worked on SQL\'s to do positive and negative tests against informatica to compare the data.
• Automated the QA environment services monitoring script and data purge scrip on Linux environment and notify in email.
• Performed manual, functional testing, Integration testing and regression testing.
• Reviewed the docs from the Dev team and reported the bugs in JIRA.
• Organized bug review and task review to assign/ re-assign the tasks and their priorities meetings.

Environment:SQL Server 2005,DB2,Oracle 10g, MS Excel, OBIEE 11g, UNIX,JIRA, Toad. Informatica 9, Synsort, Quality Center 10, Embarcadero Rapid SQL 7.7.2

Confidential
Project: Web application
QA Engineer/BA Analyst Nov'09-Dec'10

Description: Bionovo is the founder of the biotechnology industry has been delivering on the promise of biotechnology for almost 15 years, using human genetic information to discover, develop, commercialize and manufacture biotherapeutics that address significant unmet medical needs. Bionovo is a drug discovery and development company focused on developing safe and effective drugs for the treatment of unmet medical needs in women's health and cancer.

Responsibilities:

• Developed Automation tests with Selenium for functional testing of Web Application.
• Defined QA strategy, test practices, and roadmap for Web applications.
• Created and developed test cases to test the web application called e-shopping and Client link management based on HTML, CSS, XML and JavaScript.
• Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
• Interacted with the Client to understand the functionality of the Application under test (AUI).
• Created test cases to test Web Application.
• Actively participated in Scrum meetings, reviews and developed test scenarios.
• Ran automated test cases on Selenium RC (IE7, Firefox 2.0X).
• Worked with client to establish and maintain a consistent test methodology and to resolve questions during the testing process. Served as a coordinator for all testing activities on a project.
• Worked on script preparation, execution within framework, around 3 web pages involved flex designs and Flex application testing was also carried out using selenium.
• In Regression phase, the project was automated using selenium, with developing a dynamic framework which could automate all the test cases.
• Full life cycle experience including requirement analysis, test strategy, test cases design, testing, release new version of product and End-to-end testing.
• The scope of testing included functionality, performance, GUI, usability, regression, builds acceptance, and localization.
• Tested individual components in Windows and LINUX/UNIX environments and the integration of the backend JAVA Services with the front end.
• Developed Methodology, Test Plans, Test Matrixes, Test Cases and Test scripts for functional testing using the Quality Center as a central repository for test assets during all levels of IT testing cycle.

Environment:Windows, Linux, JIRA, SQL, Selenium IDE,RC, JavaScript

Confidential, Florida
Project: e-Shop
QA Engineer Sep'07-Nov'09

Description:Consulting for Skoobit which is an online textbook rental company. Students rent textbooks typically by ordering online, and return books after the semester. This project includes Web-site with e-Shop based .The main challenges are transaction reliability and security, access rights, e-payment system, database correct performance.

Responsibilities:

• Analyzed the various automated testing tools available in the market to pick a tool according to the platform and application's testing requirements, resources and budget.
• Tested various features and functional areas of the application including Uploading, Downloading, Playing Movies, New Customer Registration, Billing, Credit Card Processing, and Shopping Cart.
• Worked with Q team to design test plan and test cases for User Acceptance testing (UAT).
• Experience in testing and writing various reports and Validation of the data by using SQL queries.
• Authored test cases in test lab, Quality Centre after the analysis of requirement/Use cases.
• Analyzed massive and highly complex data sets, performed black box testing and data manipulation using Exceland MS Access.
• Prepared Test Plans and developed test cases based on the requirements for various web applications.
• Involved in maintenance automated regression test scripts in VBScript.
• Parameterised the required fields to run in different environment using Data Driven in Quick test Professional.
• Created data driven test scripts, which retrieve the test data from an MS Access Database and use the data to automatically test the application.
• Performed GUI testing and Navigation Testing.
• Performed analysis based on the source systems and existing OLTP database systems.
• Validate the data using SQL queries (TOAD) extensively.
• Tested the applications for security like SQL Injection, LDAP Injection, URL tampering and cookie tampering.
• Worked with developers and designers on bug and issue resolution.
• Responsible for creating the User Manuals and Trouble shooting documents.

Environment: Apache, Win/NT/XP/98/95,MS Excel, MS Visio, INFORMATICA 7.1, Oracle 9i,MySQL, VBScript,IE 5.x, Firefox, Mozilla ,HTTP, QC 9.5

Confidential
Jan'06-Jun'07
Test Engineer:

Description: Smo is an extremely realistic sumo tournament game intended for mobile phone users. It supports a wide range of devices among the Symbian, Brew and J2ME handsets. SUMO allows choosing whether you wish to play in a single player or a multiplayer mode via Bluetooth.
Responsibilities :

• Tested network security routine and integral part of the system and network operations.
• Performed negative test cases for testing, network testing, setting response, memory handling, and battery for unauthorised hosts connected to the organization's network. Identify venerable services.
• Involved in generating SQL Reports.
• Involved in base line testing for the entire system.
• Tested the most important system first and Use caution when testing.
• Developed Test Cases and test plans for various modules.
• Created Silk Test scripts for acceptance and regression tests
• Maintained test scripts usingWinrunner 6.0.
• Responsible forunittesting, System testing, Web testing after every build.
• Regularly met with the developers to discuss issues and enhance the system.
• Documented the test results and provided oral and written analysis of the entire testing phase after its completion.

Environment: C++, HTML, JavaScript, IE 5.x, Netscape 4.x.IP,TCP/HTTP,ASP,.NET,QTP, Test Director 8.2

EDUCATION

BS, Electronics and Communication Engineering:
Visa Status: Permanent Resident