SUMMARY

• More than 18 years of experience in Information Technology with the focus on quality assurance and testing.
• Expertise with Object Oriented Programming techniques and sound knowledge of industry standards and software engineering processes.
• Experience with web/client server applications on multi - tier environments.
• Resourceful problem solver with ability to bring quick solution to challenging situations, recognized for efficiently drafting reports and preparing technical documentation.
• Created and designed an Automation Framework using different commercial tools like QTP, Test Partner and Test Complete.
• Experience with test environment setup, create test data and identify test cases for automation.
• Worked on requirement gathering and developing test plans.
• Managed and tracked test cases, test plan and defects using Quality Center/Test Director / PVCS Tracker.
• Knowledge of various protocols in LoadRunner. Worked on Client/Server and Middleware Protocols.
• Strong Object-oriented concepts and development skills in C, C++.
• Excellent programming skills with hands on experience in HTML, VBScript and Java Script.
• Experience writing and executing shell scripts from scratch and modifying existing ones.
• Quick learner with the ability to assimilate newer technologies and put in practice.
• Extensive knowledge of backend testing using SQL, PL/SQL, Stored Procedures and Triggers.
• Extensive experience in working with ETL tools like Informatica and SSIS
• Experience in working with different database SQL server, Sybase, Netezza, MS Access, Tandem

TECHNICAL SKILLS

Languages/Technologies: C, C++, Pro *C, Java, Shell Programming, Perl, Tcl, C#

Web Technologies: JSP, Java Script, CGI, HTML, XML

Packages: MS OFFICE, Adobe Photoshop, Flash and Macromedia Dream weaver

Database Systems: SQL Server 2005/2008, Netezza, MS Access

Platform: HP-UX, Sun Solaris, UNIX, Windows NT/2K/XP, Mainframe (COBOL)

Testing Tools: Mercury Quality Center/Test Director, WinRunner, Quick Test Pro, LoadRunner, Test Partner, Test Complete, Network Simulator

Version Control Tools: TFS, CVS, VSS

Web Programming: HTML, DHTML, XML, ASP, VBScript, Java Script, Perl/CGI, SoapUI

Defect Tracking Tools: Quality Center, BugZilla, Serena Team Track, Jira and PVCS Tracker

BI and ETL Tools: Informatica, MicroStrategy, Cognos, SSIS, SSRS and SSAS

Software Development Process: Waterfall, Agile-Scrum, Agile-Kanban

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr. Quality Assurance Engineer

Responsibilities:

• Prepare release level Test Strategy/Approach plan, co-ordinate release from planning to delivery
• Participate in Sprint planning, assign resources and provide Test Summary Results for the release
• Work with OnShore/Offshore Dev/QM
• Manage and prep test data and test environments
• Manage a team of 4 Onshore and 5 Offshore resources
• Write SQL queries for data validation, preparing test data and use them in an automated validation process
• Create SSIS packages to move data, apply business logic and use it for comparison with expected Vs actual results
• Run Scrum, remove dead locks and provide status to upper management

Environment: SQL, Visual Studio, HP-QC, Jira and Atlassian suite

Confidential, Santa Ana, CA

IT Lead QA

Responsibilities:

• Analyze requirements, participate in BRD review sessions and provide QA estimates for testing efforts
• Coordinate between Dev, BA and Release team and provide updates to Management
• Provide Risk analysis for different projects
• Arrange review and retrospection meetings, compile meeting notes and come up with a strategy / solution after each release
• Create Test Plan, Test cases and test strategy
• Manage a team of 3 on shore and 2 off shore resources and assign tasks to them for each release
• Use SQL queries for validations and configuration
• Perform black box and white box testing

Environment: Tandem, Cobol, HP Quality Center, SQL

Confidential, Costa Mesa, CA

Sr. SQA Analyst

Responsibilities:

• Provide level of effort for testing in QA and post production validation document
• Prepare Test cases, test data and validation SQL scripts per business requirements and functional specifications.
• Test ETLs developed in Informatica, SSIS or stored procedure
• Work directly with business users and developers to trouble shoot defects
• Validate reports and Cubes developed in Cognos
• Validate data on back end through SQL queries using SQL server 2008
• Test various Experian websites like FreeCreditReport.com, FreeCreditScore.com, CreditReport.com, CreditScore.com, ProtectMyId.com etc.
• Work with XML based request and response to validate APIs
• Test mobile apps for ProtectMyId and FreeCreditScroe.com for iOS and Android
• Create reusable and repeatable SQL/VB scripts to automate some part or full testing

Environment: Windows XP, VBScript, SQL Server 2008, MS-Office Suite, SSIS, Informatica, SSRS, Cognos, .Net, XML

Confidential, Irvine, CA

Lead. QA ENGINEER

Responsibilities:

• Participate in Sprint planning, Sprint health and Deployment meetings.
• Prepared Test cases, test data and SQL scripts as per the Business requirements and functional specifications.
• Created automation framework to automate Client server and Web based applications using Test Complete.
• Perform Web Services Testing using SoapUI
• Setup ETL workflows and test them. This includes work flows developed in C#, Informatica and SSIS (SQL Server Integration Services) and validating mapping created in Informatica
• Testing MicroStrategy reports used by Forecasting and vehicle valuations departments.
• Mentoring and helping other QA team members to get them up to the speed.
• Work directly with the Development team to troubleshoot defect related issues.
• Prepared defect reports and test metrics for walkthrough sessions to help and promote the application along with daily status and weekly status reports.
• Conducted backend tests on database server, application server and validate the actual results against the expected results sets.

Environment: Windows XP, .Net, XML, HTML, VBScript, SQL Server 2005/ 2008, Team Foundation Server, Red Gate SQL Data and SQL Compare, Automated QA - Test Complete, MS-Office Suite, Bugzilla, WPF, Netezza, VS2010, Informatica, SSIS, SSRS, XML

Confidential, Huntington Beach, CA

Sr. QA Engineer

Responsibilities:

• Participate in QA resource planning, Implementation and evaluation committees.
• Wrote test scripts and leverage expertise with QTP (VB Scripting) and Test Partner to develop adaptable generic scripts.
• Prepared Test Plans, test cases, and automation scripts as per the Business requirements and functional specifications.
• Work directly with the Development team to troubleshoot defect related issues.
• Prepared defect reports & test metrics for walkthrough sessions to help and Promote the application along with daily status and weekly status reports.
• Manage and Used PVCS tracker/Team foundation server for defect tracking.
• Conducted backend tests on database server, application server and validate the actual results against the expected results sets.
• Setup the test environment, create test data and identify the test cases for automation. Analyze the Change Requests and setup the Regression Test Sets.
• Coordinated with Project Managers, client representatives and business analysts.

Environment: QTP, Test Partner, Windows XP, .Net, XML, HTML, VBScript, SQL Server 2005, Team Foundation Server, BizTalk Server, MS-Office Suite

Confidential, Irvine, CA

Programmer Analyst

Responsibilities:

• Participate in planning, program development, and implementation and evaluation committees.
• Identified, analyzed, and documented defects in Quality Center.
• Prepared defect reports & test metrics for walkthrough sessions to help promote the application along with daily status and weekly status reports.
• Conducted backend tests on database server, application server and validate the actual results against the expected results sets.
• Installation of Mercury Products - QTP and LoadRunner.
• Generate scripts on LoadRunner to automate the application for load and performance testing.
• Developed HTTP VU Scripts to simulate performance using LoadRunner.
• Make effective use of Controller and Analyzer to monitor and analyze results.

Confidential

Assistant System Executive

Responsibilities:

• Member of the team to develop Physical Design Solution.
• Active Coding and developing solutions to meet business needs.
• Generated Unix scripts for connecting Presentation Layer to Data Layer

Environment: IBM AIX UNIX, Pro *C, Pro *Cobol, Oracle Report Writer