SUMMARY

• I have 11+ years of experience in Information Technology with emphasis on Software Testing/Quality Assurance.
• Project Management experience in testing of standalone, (Data warehousing) DW Testing, Client Server and web based applications using Manual & Automation testing techniques and Tools and UAT in multiple industries including Banking & Finance, Communications and Network, Life Sciences, and Retail POS.
• 3 years as a QA Lead managing teams up to 20 members in size.
• Experienced people manager of on - shore and off-shore teams, including hiring, mentoring Extensive experience in SDLC process development and implementation Experienced.
• An accomplished Test Lead with understanding in Project management, Requirements definition, Software testing and Quality assurance in variety of industries.
• Extensive working experience in Sanity, Cross Browser, Cross Platform, Security, Black box, White box, Functionality, System, Unit, Integration, Front-End, GUI, Back-End, End-to-End, Parallel Testing, Recovery Testing, Compatibility Testing, Regression, Performance, Load, Stress, UAT, Acceptance & Configuration testing under SDLC, STLC.
• Methodologies used include Waterfall, Iterative, and Agile, Service Oriented Architecture (SOA), Rational Unified Process (RUP).
• I enjoy finding the defects during requirements phase, test case construction phase and in actual testing phase’s.
• I love to interact with people and finally make sure the applications are defect free for end users.
• Experience in subject matter expert (SME) and act as a point of contact for Functional and integration testing activities.
• Proven hands-on experience with Quality Assurance practices, including Test approach and Test Plan development, Test case & Test data review.
• Experience in a fast-paced Agile/ Scrum environment.
• Experience in ETL testing & having extensive knowledge on ETL processes.
• Experience in CRM Salesforce, Siebel Testing, Oracle Fusion and Apps.
• Expertise in testing E-commerce retail applications OMS (Order management system), POS (Point of Sale), CMC (Promotions creation) Experience in web services testing using SOAP UI
• Developed, maintained, reviewed and approved Validation Deliverables such as Central Validations plan, IQ, PQ, OQ Protocols, requirements, test scripts and summary reports.
• Reviewed and approved Requirements, Design Specifications and Test Scripts for compliance with SOPs and GMP guidelines.
• Reviewed and approved Change Controls for compliance with SOPs and guidelines.
• Experience in developing automation frameworks using Quickest Professional (QTP)
• Experience on Mobile Testing on both Android (2.x, 4.x), and IOS (IOS 6, IOS 7, IOS 8 versions), Windows 8
• Experience in Application life cycle tools(ALM,TFS, MTM, Rational Suite, JIRA, Bugzilla, PVCS, DRTT)
• Experienced in, Cost Benefit Analysis, organizing, facilitating and coordinating JAD sessions, weekly meetings, conference calls and other regular project meetings.
• Experience in SQL, PLSQL and data troubleshooting. Proficient in using any flavor of UNIX operating system by writing various UNIX commands.
• Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Proactive in engaging with clients to understand their perspectives and experiences.
• Keen ability to create, analyze, and report on Quality Metrics for distribution / discussion with clients, senior leaders and project teams.
• Created test documents like QA Status Report, QA Test Logs, Test sign-off, Maintain issue & defect databases.
• Knowledge on ETL tools like Informatica, Business Objects and Cognos, Micro Strategy, OBIEE.

TECHNICAL SKILLS

Tools: Salesforce, Siebel, TOAD, AUTOSYS

Testing Tools: QTP, Quality Center, Test Director, DRTT, Bugzilla, PVCS Tracker, Confidential & Confidential tools (TMT, RMT), Lotus SIR, JIRA

RDBMS: Oracle 9i, 10g

Languages: C, C++, Visual Basic, Java, HTML, and XML

Version Tools: Visual SourceSafe, SCME and CVS.

Utilities: MS Word, MS Excel, MS PowerPoint, Edit Plus, Putty, Shell Script, XML and MSPS,, Share point Portal, EMC Documentum, TeamTrack

Certifications: ISTQB, CSTE, PMP, ITIL

PROFESSIONAL EXPERIENCE

Confidential

Environment: Java Script, Site Catalyst, Jekins, Crashlytics, Enterprise GitHub, HTML, XML, Profile, SaaSy, Oracle, UNIX, QC, Oracle 11g/10g, Informatica, TSYS

Test Lead

Responsibilities:

• Be part of product analysis and PSI(potentially shippable increments) meetings and release planning to understand upcoming commitments/ accomplishments.
• Participate in grooming sessions to develop User Stories.
• Understanding the Business Requirements and verifying the functionalities to be covered in functional In Sprint Testing and Regression testing.
• Design and implement testing procedures to ensure functional and system stability for new and modified functionalities of the application.
• Identify the Test Data requirements and submit to the TDM team. Validate the Test Data once provided by TDM.
• Created SQL Queries to test the backend functionality of the application.
• Verify the implemented ETL code against the corresponding mapping document. Conirm the data loads from source files into the target tables.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Performed System Integration Testing End to End:- PBB and Credit Testing: PBB modules like Opening of clients,Accounts, Teller, Teller transfers, Funds Transfer, Cheques, deposits, withdrwals, Credit-Limits, Collateral, Loans and Deposits, some IBC modules like Swift Transfers, Clearing of Interbank Transfers and Cheque Deposits, Printing of Advices to Customers, Statements.
• Responsible for executing test cases for Smoke tests, functional tests and Regression tests on Android Phones (2.x, 4.x), Iphones (IOS 6, IOS 7, IOS 8 versions).
• Create and execute test cases using Quality Center, update the results and generate reports using Quality Center.
• Participate in Retrospections and provide feedback on current release, what went good and the improvements where can be implemented.

Confidential

Environment: SQL, PL/SQL, TOAD, Test Cases, Test Scripts, Test Plan, Traceability Matrix,Informatica Power Center (Power Center Designer, workflow manager, workflow monitor),QC, Erwin, QTP, HRMS, Oracle Fusion and Apps

BAT/UAT Lead

Responsibilities:

• Develop UAT test plan/strategy for overall BAT/UAT deliverables in the project including defining scopes of testing, risk analysis and prioritization of tasks based on schedule and available resources. Propose any changes to project teams to mitigate risks.
• Resource Planning & people management activities.
• Identifying training needs for the project’s team members, including process training needs; tracking and ensuring that team members are adequately trained for their role
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Created Plan and Test Cases.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data using AutoSys tool.
• Identifying duplicate records in the staging area before data gets processed.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for Oracle to write SQL queries for validating constraints, indexes.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Confidential

Environment: Java, JSP, Java Script, HTML, XML, C, C++, Oracle, UNIX, Quality Center, SFDC, Oracle Fusion and Apps

Test Lead

Responsibilities:

• Be a part of requirements gathering, product analysis and release planning.
• Prepare test plan and test cases for every release.
• Develop test plan/strategy for deliverables in the project including defining scopes of testing, risk analysis and prioritization of tasks based on schedule and available resources.
• Propose any changes to project teams to mitigate risks.
• Resource Planning & people management activities.
• Identifying training needs for the project’s team members, including process training needs; tracking and ensuring that team members are adequately trained for their role
• Create and execute test cases using Quality Center, update the results and generate reports using Quality Center.
• Work closely with the Business managers, Product manager and Dev Managers on planning the testing efforts and deliverable phases.
• Design and implement testing procedures to ensure functional and system stability for new and modified functionalities of the application.
• Participate in advocacy meeting with technical team, subject matter experts and project managers to develop a testing strategy and framework.
• Responsible for Coordinating with end user for the execution of the UAT.
• Responsible for writing and executing test cases for Smoke tests, Regression tests and functional tests
• Conducted defect review meetings to resolve defect issues
• Responsible for Project Communications, reviews, weekly and monthly status reports
• Perform Defect Prevention activities using CAR report.
• Preparing the weekly, Monthly and Release wise metrics and send to next level management.
• Conducted knowledge transfer / training. Provided user demos to the End Users.

Confidential

Environment: Siebel, Oracle, TOAD, Quality Center, Informatica, UNIX, AUTOSYS

Senior Test Engineer

Responsibilities:

• Understanding the Business Requirements and verifying the functionalities to be covered in functional and Regression testing.
• Created detailed test plans based on analysis of requirements and design documents.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Report and document defects working closely with developers to provide appropriate information to enable the defects to be resolved.
• Tested the DW / BI reports (OBIEE). Validated different types of reports and dashboards developed by Business Objects and OBIEE.
• Validated of Test scenarios with all test coverage and Validated Traceability Matrix as per functional specifications.

Confidential

Environment: Oracle 10g, Oracle Financials, Informatica 8.5, Java, Microsoft Visual Studio 2005/2008, SOAP, Windows XP, AIX 5.3, Caliber RM, C++, Business Objects, AUTOSYS, QC

Test Engineer

Responsibilities:

• Involved in complete software and Test Lifecycle activities - design, implementation and test execution
• Work with project team to understand customer requirements and participate in user acceptance testing with customers.
• Involved in writing Test Plans and executing functional test cases and system test cases. Created Test conditions, Test Scenarios and Test scripts using QC Tool
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Executed the Automation test scripts from Quality Center (QC).

Confidential

Environment: Java, JSP, Java Script, HTML, XML, C, C++, Oracle 9i, UNIX, TMT, RMT, Sablime, PVCS Tracker, Rational Test Manager, Rational Suite

Test Engineer

Responsibilities:

• Involved in complete software and Test Lifecycle activities - design, implementation and test execution.
• Planning and Tracking test activities and coordinate with Development team
• Involved in writing Test Plans and executing functional test cases and system test cases.
• Created Test conditions, Test Scenarios and Test scripts using TMT tool.
• Actively Involved in GUI Testing, Functional Testing and Regression Testing.
• Actively Involved data base testing.
• Create traceability matrix to ensure the mapping between requirement, test cases, defects and estimation