SUMMARY:

• 10 years of IT with 4 years of QA in a lead role and two years each of BI and Java development experience.
• Excellent experience in defining test methodologies, test approach and strategy, designing test plans and test cases, verifying and validating applications and documenting based on standards for software development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) including system, functional, integration and UAT testing.
• Hands on experience on TFS, HP ALM, Bugzilla, and JIRA for raising bugs, issues, tasks and creating user stories for project management using AGILE methodology.
• Strong data warehouse concepts with hands on PL/SQL experience for quality, injection, mining and testing of data.
• Strong hands on experience in manual and automated testing using Microsoft Test Manager, SOAPUI, Data Validation Option, DbFit and IBM Rational tools and performed defect reporting using defect tools such as HP ALM, Rally, Microsoft Test Manager, Team foundation server 2010, JIRA and Bugzilla.
• Collaborated with Infrastructure, database, development, testing teams and product owners for build deployment, test execution, test deliverables, status reporting to management and issue escalations to ensure data integrity and consistency.
• Coordinated testing activities with offshore team by having daily status calls to ensure that testing progress is on track and as per the schedule
• Worked on projects that use SCRUM, Kanban and Waterfall methodology for rapid application development.
• Presented live demonstration about features of Rational Performance Tester at Technical Conferences on behalf of IBM to various clients.
• Committed to excellence, self - motivator and team player with strong problem solving, debugging capabilities with excellent communication skills.

TECHNICAL SKILLS:

• Informatica PowerCenter 9.x
• Data Validation Option
• Netezza 7.x
• Hadoop 1.x
• DbFit
• SchemaSpy
• Oracle 11g
• GreenPlum 4.2
• PostgreSQL
• Kanban
• SCRUM and Waterfall methodology
• MS-SQL 2008R2/2008
• BIDS
• HP ALM
• ALM using Microsoft team foundation server 2010
• Salesforce
• SAS4.3
• Aginity
• pgAdmin
• DBVizualizer
• MS SQL server BI development studio (BIDS)
• PL/SQL
• Transact SQL
• SQL query analyzer
• MS SharePoint
• MS SQL server integration services (SSIS)
• Bloomberg
• Rational performance tester
• Rational functional tester
• HP Quality Center
• VersionOne
• Rally
• Bugzilla
• Jira
• Excel macros
• Power pivot
• Redgate data comparer and data generator
• DBSchema data generator
• SOAP UI
• Java
• JSP
• HTML
• CSS
• WebSphere application server
• WebSphere portal 6.x
• WebSphere content management 6.x
• Site Core
• Varden
• HPUX
• Unix
• Linux
• Windows server NT/XP/2000,
• Windows Vista

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Senior QA Engineer

• Solid data warehouse experience focused on Valuations data store, data marts and reporting needs.
• Defined and participated in functional, system, integration, regression and UAT phases of Software Test Life cycle (STLC).
• Assisted in UAT phase and coordinated with defect analysis and triage between product owner, business analysts and Dev team.
• Well versed with invoking Informatica workflows and UNIX command line along with excellent debugging skills for failures by drilling session logs and UNIX job logs.
• Performed complex validations of key Valuations algorithms such as Vehicle Match and Vin Repository.
• Automated test cases by using DbFit and collected QA metrics using stored procedures.
• Employed diagnostic techniques on ETL changes by probing the Workflows, Sessions, and Mappings to analyze changes.
• Possess intermediary UNIX skills for file manipulation and UNIX parsing.
• Attained conceptual knowledge of Valuations products such as VIMS, and supporting processes for pricing Valuations data from VSIP team.
• Generated DB documentation such as Entity Relationship, table, column and entity comments by configuring SchemaSpy for Netezza.

Environment: Informatica PowerCenter 9.x, Informatica Workflow Monitor/Manager 9.x, DbFit, Netezza, Linux, Rally, VersionOne, Bugzilla, SharePoint, Excel, Power Pivot, SchemaSpy.

Confidential, Burbank, CA

Test Architect

• Primary Lead for Disney’s Testing Center of Excellence Initiative for Customer Data Environment.
• Produced excellent defect reports and provided management with powerful dashboards on overall testing health, with pointers such as open, pending, hold, risk and project specific needs.
• Defined validation rules in Data Validation Options for validating the incremental and transformed data for accuracy and completeness as part of Test Automation for ETL testing.
• Architected Test scope and Documented Test Approach and Strategy for management review and approval along with TCERs and Test Cases.
• Modified source to target mappings and applied common transformations in PowerCenter Designer while acting as supplemental developer.
• Guided offshore resources with project onboarding and conducted handshake for executing the tests to provide 24/7 coverage to meet timelines.
• Proficient in creating SAS data sets and querying for data validation before loading to target tables.
• Reported everyday test progress with test metrics and defects to stakeholders in order to provide transparency and authored Test Closure Memo at the end of test completion.

Environment: Informatica PowerCenter 9.x, Informatica Workflow Monitor 9.x,Data Validation Option, GreenPlum, pgAdmin, DBvizualier, HPUNIX, Linux, SAS EG, Tableau, Acxiom, JIRA

Confidential, Los Angeles, CA

QA Lead

• Responsible for implementing IT department’s quality assurance strategy including but not limited to configuration management, change management, ETL data dictionary definitions, ETL data conformity and integrity.
• Identified ETL data inconsistencies by writing regression suites for everyday data loads.
• Assisted business units in data analysis by providing data trends from quality perspective both for ETL data warehouse and cube analysis.
• Lead QA offshore team by providing test outlines, business need and review of test cases and test results.
• Acted as supplemental ETL developer and provided overnight support for critical ETL processes.
• Proficient with data loading from different sources for testing purposes into load and stage tables and running DTS/SSIS jobs and Informatica sessions to verify data in fact and dimension tables.
• Testing of data for accuracy, completeness and quality both from SQL query analyzer and reports.
• Used Coded UI, Data compare and data testing features of Team foundation server to test web applications and data.
• Used SOAPUI to test web services for an in house configuration management application.
• Hands on experience on installing and implementing Microsoft Test Manager and Team Foundation server for test case management, defect tracking and application lifecycle management.
• Created custom test reports from TFS to review the overall status of testing.

Environment: Informatica PowerCenter 9.x, Informatica Workflow Monitor 9.x, MS SQL Server 2008, SQL Server Integration Services, Team Foundation Server 2012, SharePoint, Salesforce, Varden CMS, Site Core CMS, Jira, Rational Performance Tester, Rational Functional Tester, Rational Robots.

Confidential, Houston, TX

Sr. QA Analyst

• Reviewed Business requirements, IT Design documents and prepared Test Plans for all assigned project releases.
• Participated in Functional specification review meetings with Business Analysts for discussion of test plans.
• Created detailed positive and negative test cases for functional, system integration and Regression testing.
• Performed Ad-hoc testing in Development and Release Management environments and reported the Issues to the Business Analyst team.
• Prepared test data for the created test scenarios and executed them using OnTime.
• Simulated Loads using Rational Performance Tester and wrote custom Java code to handle the dynamic UI changes.
• Created and used Test Matrix and Traceability Matrix
• Used Clear Quest for bug tracking purposes.
• Performed Back end testing in Oracle using SQL.
• Reported testing status to the Manager on daily basis.
• Used Agile and SCRUM methodologies for software testing and development.

Environment: Rational Performance Tester, Clear Quest, Oracle9i, J2EE, TOAD, SQL, XML, Windows XP, UNIX, OnTime and Clear Case

Confidential, Santa Monica, CA

Sr. QA Analyst/ Onsite Coordinator

• Participated in Functional specifications review meetings with the business team.
• Analyzed Business Requirements and created test cases from BRD and use case documents.
• Created test plans and participated in the test plan reviews.
• Responsible for creating and execution of test cases for LPM and Broker Web applications.
• Performed Functional, Regression, Integration and User Acceptance Testing.
• Prepared test data as per the test scenarios documented in the test case.
• Performed back-end testing and validated the flow from front end to back end.
• Used SOAP application to validate the inputs and outputs of web service calls.
• Used of Rational Performance tester for user load simulation.
• Analyzed load tests using Tivoli performance viewer to identify bottle necks in application and network.
• Utilized ADS for data validation and performed End-End testing manually
• Mentored new team members in getting established and peer reviewed the test cases.
• Led a team of 4 resources in testing the Broker Web application
• Coordinated with Offshore team during the test case development and test execution phase.
• Transferred application knowledge to the offshore team

Environment: Rational Performance Tester, Clear Quest, DB2, Aqua Data Studio (ADS), SQL, XML, Windows XP, UNIX, and Clear Case

Confidential, Brea, CA

QA Tester

• Identified the test requirements based on user requirements and design specifications using Quality Center.
• Involved in writing test plan, test cases.
• Attended project review meetings and discussed issues including the progress of the project with development, project teams and business groups.
• Coordinated with testing meetings (Ex: Status updates, action items, open issues, prioritizing errors and communicate the priorities).
• Maintained all the scripts and Test Cases in Quality Center.
• Performed negative testing to find how the functions performed when system encountered invalid, unexpected values.
• Used Quality Center to run regression suits.
• Have done Smoke test for all the forms for the reviews with the client.
• Have done Regression testing after all the defects are fixed.

Environment: Quality Center, java, SQL Server, Windows 2003/Xp, Manual Testing.