SUMMARY:

• 11+ years of IT experience in Software life cycle with Expertise designing, deploying automation framework and executing effective Test Methodologies; designing Test Strategies, Test Plans, Test Estimates, Pre/Post deployment plans and Test cases/Scripts on Web, Window, Mobile application, and Client Server applications developed on Java, mainframe,.NET platform, PEGA and BPM Tools.
• Created and Executed Functional, Integration, Regression, Business Process on various business domains including Banking’s (Consumer and Small Business, Core Banking and Deposits, Treasury, Online Banking, Mobile Banking, Cash Management, Home loan/Mortgage and Wholesale Banking)
• Extensive knowledge and experience across project (SDLC) life cycle using Waterfall, RUP, Agile Methodologies.
• Defined and implemented Process improvement techniques and guideline as a part of new technology implementation as well as make use of available tools to improve daily reporting activity.
• Designed and implemented QTP 11/ALM (QC)/SoapUI framework in such a way that manual tester can create, update and execute automation script.
• Designed and developed Reporting Tool for daily, weekly and monthly reports with analyzed summary and graphs as well as QA Testing Audit tools.
• Proven success in managing multiple projects simultaneously and Skilled at establishing project structure, schedules, communications and operations.
• Proficient at supervising day - to-day activity, Training and mentoring large project teams and knowledge sharing
• Creative thinker and analytical problem-solver with demonstrated ability to manage projects from planning through execution/completion under the pressure of fast-paced, time-sensitive environments
• Excellent leadership, friendly customer facing, communication, analytical, problem-solving, people management, interpersonal skills and ability to analyze business problems and identify solutions.
• Knowledge in client-side browser technologies using HTML, CSS, JavaScript and PHP.
• Knowledge in bug tracking tools - Firebug and IDE developer tool.
• Experience in working with open source tools Selenium WebDriver,QTP, TestNG, Eclipse and preparation of automation test framework.
• Experienced in implementing QA methodologies, Test Case Design, Test Tool Usage, Test Execution, Defect Management and Test management process
• Expertise in coding experience with Java and involved in white box testing.
• Experience testing in an AGILE development methodology.
• Strong experience in Requirements elicitation techniques - conducting user interviews and JAD sessions and managing the requirements.

TECHNICAL SKILLS:

Test Automation Tools: QTP, UFT, QC/ALM, Load Runner, Rational Functional Tester, SoapUI

RDBMS/DB: MS SQL, Oracle, MS Access, DB2, AS400 iSeries, IMS DB

Languages: C, C++, Java, .NET, SQL and PL/SQL, HTML, mainframes, COBOL

Scripting Languages: HTML, VB Script (Excel/Word Macro, .vbs), XML

Operating Systems: Windows 7, Vista, XP, UNIX

Defect Management Tools: QC, ALM, Bugzilla, Rational Clear Quest

Project Management Tools: Microsoft Project, SharePoint, Discovery

Workflow based Tools: PEGA, Appian and BPM

PROFESSIONAL EXPERIENCE:

Bank Of The West, San Ramon - CA

QA Lead /IT QA Analyst Sr

• Working as a IT QA Analyst for Cash Management Products and check processing banking application EDS Premier.
• Translate functional design into technical specifications such as program flow Analyzed system specifications and business requirements and helped create the detailed Test Cases.
• Understand the User requirement documents (Business and functional) in the fast pace project to deliver the required task
• Extensively used Remote Deposit Capture(EDS) application to capture images via desktop scanners
• Job entails preparation of 'Test Plans', 'Test Design Specification', setting up of complex test case scenarios, writing test scripts using HP Quality Center 11.0 and performing System, Functional, Black-Box, Regression, UAT and cross-browser testing
• Tested Web Portal application to convert paper-based deposits to electronic format for immediate and secure delivery to Bank of The West over the internet and external machines. It provides easy-to-use tools for creating, managing, and transmitting electronic deposits
• Job also include Test Evaluation, Verification & Validations of Actual Results vis-à-vis the desired results Sent daily status reports with any issues to both the Client as well as senior management
• Creating and maintaining Tests and Test Records, Defect Management, analyzed defect data, performed testing for product release, recommended process improvements, review test procedures, maintain strict adherence to client's prescribed testing guidelines, control processes and procedures
• Performed Database Integrity Testing by executing SQL statements.
• RDC Smart and RDCO converted and unconverted DDA deposits validation in Host and IPVision/Transaction Processing system tool
• RDC source data files and reports validation in various location/machines based reports and Web, SMART client, also setup merchant in Dashborad/Admin tool
• Designed and Developed test scripts in Selenium Webdriver using Java and TestNG framework.
• Maintained automated regression test cases.
• Actively participated in QA team meetings and discussions
• Sanity testing of every code drop with designed automated test suite.
• Performing Regression test suite for each code drop
• Refactoring the scripts as in needed.
• Development of Data driven testing.
• Cross browser testing by running the regression test suite in different browsers.
• RDC application requires testing of different types of Scanners and Drivers like TS 240, VisionX, Epson, TS 240, CX 30, Canon CR-55and 180 etc
• Involved in preparing Traceability matrix for 100% coverage of Requirements. . Used the defect-tracking feature of HP Quality Center to log and document defects. . Participated in Production support validations and testing during off and on business hours. .
• Proved success in managing multiple projects simultaneously with multiple resources and Skilled at establishing project structure, schedules, communications and operations.
• Involved in testing EDS application and performing deposit captures connected through Panini mIDeal for mobile and Tablet testing.

Environment: EDS Premier Web Client/Smart Client, SQL Server,Appian, Web Direct, Oracle developer, ALM 11, Java,net, Web services, Online Banking, Host QW3270,IPVision, Mobile

Confidential, Fremont - CA

Sr.Systems Analyst QA/QA Lead

• Working as a Sr. Test Executioner for BPM based Wholesale banking application called Cornerstone.
• Translate functional design into technical specifications such as program flow Analyzed system specifications and business requirements and helped create the detailed Test Cases.
• Created Test Cases to check the functionality of Cornerstone in Agile environment based on the story points playback wise.
• Used IBM BPM portal to test the web App for the PODD/CODD workflows in Cornerstone
• Exported Test Cases using Mercury Excel add-in into Quality Center and converted them into Test in each Playback back and sent for review at the end of the iteration
• Executed test scripts developed with Quality Center to perform functional testing on the securities business reporting application.
• Sent daily status reports with any issues to both the Client as well as senior management
• Tested in the Integration environment prior to the QA environment in playbacks and SIT.
• Performed Database Integrity Testing by executing SQL statements.
• Developed and executed Selenium web driver Test Scripts for Testing the Functionality, Regression, and workflows navigations.
• Conducted Discussions and meetings with designers to understand the application and the overall functionality of the system.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Oracle database.
• Prepared weekly and monthly status reports for managerial reference and lead a team of 6 resources.
• Developed complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Attended everyday stand up meetings (walkthroughs/ inspections) for reviewing the testing process with the QA team, Developers, operations and management.
• Extensive mobile testing performed to verify all the work flow based testing.
• Designed and Developed test scripts in Selenium Webdriver using Java and TestNG framework.
• Maintained automated regression test cases.
• Actively participated in QA team meetings and discussions
• Sanity testing of every code drop with designed automated test suite.
• Performing Regression test suite for each code drop

Environment: Agile/IBM BMP Web Client/Server, BPM ODM and SQL Server, Soap UI, Enterprise Architect, Oracle developer HP Service Test, ALM 11, ETL, Excel Macros, ALM OTA, XML, SQL, Oracle 11g, Ms Office, Windows 7/XP, Selenium, Rest API’s, Test NG, Mobile.

Confidential, Texas

QA Analyst - QTP/QC (Automation)

• Translate functional design into technical specifications such as program flow Analyzed system specifications and business requirements and helped create the detailed Test Plan.
• Created Test Cases to check the functionality of LAS Applications.
• Used iSeries AS400 and DB Visualizer, TOAD to import and export SQL data, store it in tables.
• Worked as QA Manual and Automation engineer on Confidential Deposits Application where I was involved with creating QTP scripts for end to end business process testing.
• Executed and developed SQL queries on Oracle database (PL/SQL) for backend testing and perform data analysis.
• Created Test Estimates along with Traceability Matrix to trace requirement with test cases and created Test cases for automated regression testing.
• Designed Checkpoints using QTP to validate actual results, if they are matches with the expected results.
• Prepared executive summary sheet for manager review on testing activities as well as release status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Used QTP as regression testing tool and developed VB scripts for different Methods and Properties using Descriptive Programming.
• Defined and implemented Process improvement techniques and guideline as a part of new technology implementation as well as make use of available tools to improve daily reporting activity.
• Designed Macros to create Requirement Traceability Matrix (RTM) from data stored in ALM Database (i.e. SQL).
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Excellent Knowledge of Database Systems - Oracle 10g, SQL server, DB2 and Data ware house concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Extensive SQL querying on Staging,Datawarehouse andDataMarts
• Participated in creating QA Testing process & standards and Best Practices to be used across the QA within Confidential organization.
• Designed Macros to create Requirement Traceability Matrix (RTM) and Execute QC/QTP script using OTA (Open Test Architecture).
• Performed Data Driven Tests with positive and negative data sets using QTP as well as used reusable actions and external actions in QTP to avoid the repeatability.

Environment: iSeries, BOA Web Client/Server, AS400, HTML, Java, QC, QTP, VB Script, XML, SQL, PLSQL, Oracle,PEGA, Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), TOAD, SQL and PL/SQL, Web Services.

Confidential - California

QA Analyst- QTP/QC (Manual and Automation)

• Preparing the Test Plan, Test Scenarios, Test Cases, Test Scripts and Executing the test scripts and Data conditioning for Deposits related Initiatives.
• Perform functional and Regression testing for Deposits related Initiatives.
• Preparing the Requirement Traceability Matrix for Deposits related initiatives.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Reporting the Defect through bug tracking tool like Quality Center.
• Resolve incidents related to Deposits application.
• Provide continuous support to offshore during the Deposits testing cycles.
• Validated Banking Dollar and Non-Dollar Transactions on COIN and File-Aid IMS DB after batch.
• Performed White Box testing to test DBLOG or RTRLOG using COBOL copylibs in QWS3270 and troubleshoot Message queues for various types of transactions.
• Validated fee related changes and validated Master file and Batch Journal after the Batch refresh.
• Perform Impact Analysis on the areas that are being enhanced for customization and provide a report to my client on the areas that require technical changes during the enhancements are done.
• Worked on more than 30 releases and each release with 1-3 projects .Also worked on critical projects like Early Penalty Withdrawals(CD/IRA),What my Balance projects, Overdraft protection fee changes, CA -Model Deposits Conversion.
• Coordinate with related systems to ensure that the end to end interfaces are in place for Deposits online and batch applications.
• Validate all kinds of deposits dollar transaction on account level (Memo, Prior, Current) Transactions, Holds, Stops .Card Level - ATM/POS transaction authorizations. Non-Dollar - New customer, Account, Card setup and Account/Card maintenance like address change etc.
• Validate the OLB online banking deposit, transfer transactions in OLB and COIN.
• Manage the capacity planning based on the project estimates.
• Plan, Estimate and Manage the delivery program for all the releases.
• Involved in developing QTP automation regression suite, Execution of the automated test scripts. Created the Application Area for QTP/QC (Object Repository, Function Libraries, and Recovery scenarios).
• Involved in writing Use Cases, UAT Plans and UAT cases from Business.
• Requirements.
• Develop and execute test strategies, test plans, test scheduling and estimations using Testing Center of Excellence methodologies.
• Manage and Track the areas related to productivity improvement and present the statistics to the client.
• Experience with security authentication testing on online Banking and working with Risk Based Fraud and Case management team.
• Attend project meetings with the client and come up with proof-of-concept for performing the testing activities.
• Monitor the project plan to provide the status on the program to the client, on daily/weekly basis.
• Monitor and validate General ledger(GL) reports
• Review the functional to technical design specifications such as application flow diagrams, and ensure that the translated technical specifications are properly converted to appropriate program code.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes for Deposits applications.
• Perform structured application code reviews and walkthroughs as needed for Deposits application initiatives.
• Attended war room calls with the development team and other Stakeholders.
• SME for the entire Deposits team, which helped the team in quick knowledge gaining and getting the team complete their work on time.
• Validated Non RSA channels for various transfer, holds and withdrawal transactions performed like VRU, LEAN through GMM middleware API’s.
• Executed UNIX Commands on the backend to check the application server log files.
• Involved in automation test planning and implementing the automation framework using QTP
• Automation of the identified Test Cases using Quick Test Professional (QTP)
• Manage Induction program for the new resources and their Knowledge Transition activities.
• Analyze the strengths and weakness of the team and then set up objectives/goals for them accordingly.

Environment: Mainframe, CIS, ISPF commands, SPUFI, DB2, Emulator-QWS3270, IMS DB and COIN, RSA MQ’s, TSO, JIRA, Online Banking, Mobile Banking VRU, Teller LEAN, ATM and POS, Webservices-GMM(OAG), Reports

Confidential

Quality Assurance - Test Engineer/Test Executioner (Manual and Automation)

• Translate functional design into technical specifications such as program flow diagrams, and translate technical specifications into program code.
• Participate in defining the technical architecture and coding standards.
• Preparing the Test Plan, Test Scenarios, Test Cases, Test Scripts and Executing the test scripts for Customer Information System(CIS) related Initiatives both online and Batch.
• Perform functional and Regression testing for CIS related Initiatives.
• Preparing the Requirement Traceability Matrix for CIS related initiatives.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Reporting the Defect through bug tracking tool like Quality Center.
• Resolve incidents related to CIS application.
• Provide continuous support to offshore during the CIS testing cycles.
• Follow procedures and standards set by the project.
• Perform structured application code reviews and walkthroughs as needed.
• Involved in developing QTP automation regression suite, Execution of the automated test scripts and raising defects if any.
• Performed back-end testing by writing SQL queries.
• Experience in writing Data Driven Test scripts in WinRunner for Regression suite.
• Executed UNIX Commands on the backend to check the application server log files.
• Created Test Estimates along with Traceability Matrix to trace requirement with test cases and created Test cases for manual and automated regression testing.
• Performed Data Driven Tests with positive and negative data sets using Winrunner as well as used reusable actions and external actions to avoid the repeatability.
• Worked with synchronization points and database checkpoints in testing the web application.
• Created Vuser Scripts for Load testing including Parameterization, correlation, verification, and Transaction.
• Used Test Director as defect management and defect tracking tool
• Trained manual tester for automation and created documentation for the same.
• Involved in environment set up with developer and created Test dataset for scenario execution.

Environment: SQL Server 2000, ASP, Test Director, MS Share Point, Rational Tools Suites, Winrunner 8.0, Load Runner 8.0 and, Mainframe, Siebel and DB2