SUMMARY:

• Over 12 years of experience in diverse roles in Software Quality Assurance in Finance, Banking, Insurance, Ministry, Retail, SAP and Telecommunication industries on Web based, Client Sever, System, Data Warehouse and Mainframe Applications, FATCA, Confidential .
• 10 years of Functional test experience in creating Test Strategy, Test Plans, Test Scripts, Test Scenarios, Test completion Reports
• 10 years of expertise in SIT, UAT, BAT and creating Risk Management, Test Metrics and Traceability Matrix for test coverage
• 5+ years of independently QA software testing experience in a role for large, complex IT projects within a mixed environment
• 5 years of Experience in SQL scripting, good knowledge of ETL process and sound knowledge of UNIX commands
• 4+ years of experience communicate test results, errors or issues discovered during testing to appropriate parties
• 4+ years’ experience with developing and implementing test automation solutions
• Experience in testing mainframe applications developed using DB2, ISM, IMS, Confidential, C3, CICS, MVS, and VSAM
• Experience in managing QA initiatives and reviewing, analyzing business requirements and functional specifications
• Experience in RDBMS data models, data structures, business requirements and sys design documents to perform QA analysis tasks
• Experience in with Data Analysis using Excel (Macros) within the Financial or Banking industry
• Extensive hands on experience in conducting, Functional, Integration, System, and Regression Testing, penetration or security, performance, Production, and user acceptance testing
• Expert understanding of Test Management Lifecycle and Defect Management Lifecycle
• Experience in both manual and automated testing using Industry standard Test Tools like Mercury Suites, Rational Robot, Rational ReqPro, Silk Test and Project Management Methodologies like Waterfall, Agile, RUP Methodology and release process (ITIL)
• Experience in developing test scenarios, test cases, test scripts and test data, executing the tests and analyzing the test results, recording bug/defects and issuing and assigning preliminary severity level in a Defect Tracking System like HP Quality Center
• Experience using the following tools: Win XP, HP QC, IBM Rational tools, Apache JMeter, Oracle PL/SQL and MS Access,
• Highly motivated, organized, time management and results oriented with excellent interpersonal, communication and presentation skills with capability of adapting to new and fast changing technologies
• Assist, guide, mentor and providing leadership to more junior QA team members.
• Excellent analytical skills and problem - solving ability, team player, collaborative and self-starter, excellent oral and written skills

TECHNICAL SKILLS:

Languages: C/C++, VB, VBScript, Fox Pro, TSL, Web Base (UML, HTML & CSS, .NET, Java, J2EE, J2EE container (Application Server-Tomcat, JBoss, Weblogic, Websphere), AJAX (Java Script, XML), Shell Script

Database: SQL, PL/SQL, Oracle, DB2, IMS, Sybase, TOAD, Access 9X, SQL Server, Visualizer, DW, MDM and Lotus Notes

Financial: SAP FI/CO, POS, Telephone Banking (Call Center), Money Transfer, Brokerage (OSS ISM), Trading (Securities, Options)

ERP/CRM: SAP MM, SD, FI/CO, HR, CRM, SAP BASIS

Insurance: Internet Application, Call Center Application LI, CI, UW-Term 10, IRM-CARP, CHIRP, AD, IDT, HC

Operating System: Win Server, Active Directory, SQL and Exchange Server, IIS, Win-XP, IBM MVS, AIX, UNIX Solaris, Linux, RedHat

Hardware: IBM Z990, IBM 370/390, Intel-Base System, Telecommunications and Local Area Network

Applications: MS-Office 97/2000, Lotus Notes, CRS, Host, C3, CSA, SAP MM, SD, HR, CRM, BI, Agent Loyalty, OSS ISM and CPRM

Protocols/Services: TCP/IP, HTTP, ISDN, SNMP, SMTP, WINS, DHCP, DNS, IIS, STAMP, SOAP and RAS

Testing Tools: MQC, ALM, QTP, LoadRunner, QTP, Load Runner, PVCS, IBM Rational tools, Clear Case and Clear Quest, JIRA

Design Tools: MS-Visio, Erwin, Informatics, Cognos, Crystal Report, ITIL, MS Project 2000, Timberline, Primavera, and Auto CAD

PROFESSIONAL EXPERIENCE:

Senior QA Analyst

Confidential

Responsibilities:

• Participate in walkthroughs of SRS and BRD documents; prepare analyze, define, and translate specifications into testing requirements.
• Lead interaction with Business Analysts, Project Managers, and internal /external partners throughout the various phases of a project / business initiative.
• Lead and Involve in all areas of the development process, including creating test plan, software development, hardware development, system integration, procurement, qualification, and installation support for manufacturing.
• Develop workflow by using Visio; create test cases in the Excel and uploaded in to the ALM application.
• Author the test cases to ensure all business requirements were adequately covered; through data analysis identify continuous improvement opportunities within production test.
• Prepare and verify Test Cases in the MR Testing; executed test scenarios/scripts for functional, BAT, and UAT.
• Debug of solutions using design of experiments, tools ALM, and failure of Waterfall analysis methodologies.
• Work and coordinate with Offshore people.
• Provide the Manager with weekly status reports (ALM) on all testing risks/issues related to the project under test.

Environment : Material Management - MR-Material Replenishment, MR Project, Word, Excel, DB2, UNIX, Visio, Putty, SAP MM, Master Data Management, BI, Selenium, HP ALM

QA Analyst

Confidential

Responsibilities:

• Participated in walkthroughs of Software Requirements Specifications (SRS) and Business Requirements Definition (BRD) documents
• Led the functional test team and Business users ensuring all SIT, SYS testing has been performed and the results documented
• Prepared, analyzed, defined, and translated business and functional specifications into testing requirements
• Created test plans, Impact matrics, test execution schedule for the projects, exit report for the purpose of BAT Testing
• Prepared test cases ensuring all business requirements were adequately covered in the most efficient manner
• Participated in peer reviews of the test cases that are develope to ensure they fulfill the requirements
• Checked data for new and privious expiry date and CVC number after reissuing the card by utilize TSO mainframe application
• Created and validated Test Case for the Authorization using ICAU and WAUT - manualy override a declined authrization
• Created and validated Test Case for the AML, coverage of the insurance and final decision of the application in the Confidential
• Created and validated Test Cases for the Rewards and use Promo TLP application for the validation of the Rewards(points)
• Executed TLP test cases in the Confidential and checkd and validated into the Loyalty Agent application (Web base)
• Performed VBA Script to convert data files in to readable file and exported in to Excel file
• Created and validated Test Case for Consumer and Business Statements coverage for User Acceptance
• Prepared and verify Test Case in the Confidential for Term - Finance charge, credits or payments using Term calculation/ Script
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Assisted team manager with reports detailing progress against objectives and tracking responsibility

Environment : WebSphere Application Server, Confidential, TS2 (Transaction Management), TLP, Loyalty Agent , TSO/WCA, CSA, Embossing file, DB2, UNIX, IBM HTTP Server, VBA Screpting, WebSphere MQ, MS SharePoint 2007, Master Data Management, HP ALM, UFT/QTP

Sr. QA Analyst

Confidential

Responsibilities:

• Took an active role in all testing phases, receiving direction from the QA Test Manager and offering advice to the QA Test Manager
• Reviewed and provided feedback on high-level business requirements and testing documents
• Created test plans, test cases and traceability matrices based on complex Business Req. documents and system design documents.
• Prepared UAT test plans, test scenarios, and test execution schedule for the projects
• Prepared data conditioning according using Client Product Code to the test scenrios for the Consumer and Business Statements
• Attended in peer reviews of the test cases that were developed to ensure they fulfill the requirements
• Worked closely with business users during user acceptance testing (UAT)
• Applied functionality for charge off, bankruptcy, fraud, dispute, deceased, pdu, auth, returned check fee, auto payment
• Executed and validated test cases for the Diner regression , Consumer and Small Business using HOST Main Frame
• Documenting testing results and provided support to the end user, partner across IT
• Provided Test Manager with testing execution status, defect and issue that was found to be resolved
• Analyzed, used Agile methord, prepard BAT test plan and data conditioning for the TRIAD-Consumer US Collection project
• Executed test cases using Authorizations Decision Area-Authorizaton Strategies 2 and Collection Decision Area
• Responded to user questions regarding system behaviour and provide assistance during defect resolution
• Performed continuous review and analysis of test case priority vs. technical complexity
• Created defects, inform Manger and discussed with the developer to resolve issues
• Assisted team manager with reports detailing progress against objectives and tracking responsibility

Environment : Host, DB2, UNIX, Oracle 11G, IBM HTTP Server, JAVA, Confidential, CSA, MS SharePoint 2007, and HP ALM, UFT/QTP

Lead QA Analyst

Confidential

Responsibilities:

• Led and designed, development, execution and analysis of manual tests for functional, system, regression etc.
• Analyzed the Software Requirements Specifications (SRS) and Business Requirements Definition (BRD) documents
• Participated in walkthroughs of Software Requirements Specifications (SRS) and Business Requirements Definition (BRD) documents
• Prepared test strategy, test plans, test scenarios, test Matrics and test execution schedule for the projects
• Prepared test cases using Software Requirements Specifications (SRS) and Business Requirements Definition (BRD) documents
• Participated in peer reviews of the test cases that were developed to ensure they fulfill the requirements
• Created accounts using VBA Screpting for PEAR, NAOM, PEAR+NAOM, NAOM BAU Entity & Sole Proprietor
• Executed and validated test cases for the FATCA using HOST and Customer and Relationship Management Application (Web)
• Executed and validated test cases for the Customer and Relationship Management Application in SIT and BAT environment
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Executed test scenarios/scripts for functional, Regression, BAT and UAT testing for single ( Websphere) or multiple platforms
• Created defects to the concerned developer and discussed with the developer to resolve issues
• Performed complex queries and both component and system integration testing for ETL and BI reports
• Provided Manager with status departmental weekly reports on all testing risks/ issues related to the project under test

Environment : Host, C3, DB2, UNIX, Oracle 11G, IBM HTTP Server, ETL, IBM Runtime Environment, VBA Screpting, MS SharePoint, AIS- Automated Individual Scorecard, MDM, BI, WebSphere Application Server, JIRA, JEE Servers, HP ALM, UFT/QTP

Sr. QA Analyst

Confidential

Responsibilities:

• Participated in walkthroughs of Software Requirements Specifications (SRS) and Business Requirements Definition (BRD) documents
• Prepared, Analyzed, defined, and translate business and functional specifications into testing requirements
• Created test plans, Impact Matrics, test execution schedule for the projects, exit report for the purpose of BAT Testing
• Prepared test cases ensuring all business requirements were adequately covered in the most efficient manner
• Participated in peer reviews of the test cases that were developed to ensure they fulfill the requirements
• Created and validated Test Case for the Product Catalog using PIM MDM, Workflow, OMR
• Executed VBA Script for VISA application and verify data mapping in the ACS and status of the application in the ACAPS
• Created and validated Test Case for the AML, coverage of the insurance and final decision of the application in the Confidential
• Created and validated Test Cases for the Rewards and used Promo TLP application for the validation of the Rewards(points)
• Created and validatedTest Case for Consumer and Business Statements coverage for User Acceptance
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Tested ETL process, generated the report using Essbase Reports to compare and verify the recently data from source
• Prepared and verified Test Case in the Confidential for Term - Finance charge, credits or payments using Term calculation/ Script
• Executed test scenarios/scripts for functional, EIT and UAT testing for single ( Websphere) or multiple platforms
• Assisted team manager with reports detailing progress against objectives and tracking responsibility

Environment : WebSphere Application Server, Confidential, TS2 (Transaction Management), TLP, TSO, CSA, DB2, UNIX, IBM HTTP Server, IBM Runtime Environment, ETL,BI, Informatica, MS SharePoint 2007, MDM, JIRA, HP QC, UFT/QTP

Test Coordinator

Confidential

Responsibilities:

• Gathered, Analyzed Business and System requirements and detail design of the system
• Prepared test scenarios, test Matrics, risk assessment and test execution schedule for the projects
• Developed, document, and maintain test deliverables (test requirements, test cases, test procedures, defect logs, status reports, and test result summaries)
• Applies testing processes on the extracted data and developed and managed testing job through cognos solutions
• Tested whether ETLs are accessing and picking up right data from right source and transfer to the destination.
• Verified all data transformations are correct according to the business rules and DW is correctly populated with the transformed data
• Created coding, debugging and executing complex SQL statements, using joins (inner and outer, order by, group by, etc.) using Oracle database to verify data between SIT environment and UAT environment
• Tested the ETL that rejected records that don’t fulfill transformation rules and Error log generation
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Verified the cube to see that the data pickingup correctly from the source file, generate report and Ad-hoc report
• Tested to generated the report of the accounts using Essbase Reports to compare and verify the recently data from the DB2
• Executed test scenarios/scripts for functional, system integration and UAT testing for single or multiple platforms
• Created variences to the concerned developer and discussed with the developer to resolve issues

Environment : UNIX-TOAD, SQL,Oracle, EIT Server, DW, Informatica, Autosys, Weblogic, Hyperion /Essbase, HP QC, UFT/QTP

Lead QA Analyst

Confidential

Responsibilities:

• Analyzed Business and System requirements and detail design of the system
• Prepared test strategy, test plans, test scenarios, test Matrics and test execution schedule for the projects
• Created test cases according to the business requirements to cover for the BOAT project
• Maintained and ensuring change management procedures and standard for the SIT, SYS and UAT test cases are followed
• Verified that OMR are set up properly and function accoroding to the business requirements
• Fill up the VISA application using AACE, submitted the application and verified data mapping in the Confidential Systems
• Checked the Application status, coverage of the insurance and final decision of the application in the DB2
• Verified the status of the application using IASC and only approved application will go to the Confidential
• Increased the credit limit by using MMCL and verified the changes using WAGN on the Confidential
• Created transations using TSAI, MDE and verified the transation on the Confidential
• Created and Validated Test Case for the Authorization using ICAU and WAUT to process manula, override a declined a authorization
• Prepared and Verified Test Case in the Confidential for Term - Finance charge, credits or payments using Term calculation/ Script
• Executed test scenarios/scripts for functional, EIT and UAT testing for single or multiple platforms
• Created MRs to the concerned developer and discussed with the developer to resolve issues

Environment : UNIX, SQL, MVS, IMS, IBM- Confidential, TS2, TSO, TSAI, MDE, DB2, VBA Screpting , MS SharePoint 2007, EIT Server, AS400, HP-QC, UFT/QTP

Lead QA UAT ANALYST

Confidential

Responsibilities:

• Analyzed Business and System requirements and detail design of the system
• Created test microstrategy, test plans, Impact Matrics and test execution schedule for the projects
• Prepared test cases ensuring all business requirements were adequately covered in the most efficient manner
• Led the functional test team and Business users ensuring all SIT, SYS testing has been performed and the results documented
• Maintained change management procedures and standard for the EIT, SYS and UAT test cases are followed
• Participated in peer reviews of the test cases that were developed to ensure they fulfill the requirements
• Fill up the VISA application, submit the application and verify data mapping in the ACS Systems
• Verified the fraud, coverage of the insurance and final decision of the application in the RAWS
• Verified the status of the application in the ACAPS and only approved application will go to the Confidential
• Verified the expected result in the Confidential and create SQL queries to verify DB2 transaction and backend testing
• Created and Validated Test Case for the Authorization using ICAU and WAUT to process manula, override a declined a authorization
• Prepared and Verified Test Case in the Confidential for Term - Finance charge, credits or payments using Term calculation
• Executed test scenarios/scripts for functional, EIT and UAT testing for single ( Websphere) or multiple platforms
• Assisted project manager with reports detailing progress against objectives and tracking responsibility

Environment: TOAD, PL/SQL,VB, MVS, Confidential, JIRA, JCL, Websphere, Hyperion / Essbase, Cognos, Ad-hoc, Oracle 9i/8i, HP QC

Sr. QA ANALYST

Confidential

Responsibilities:

• Analyzed Business and System requirements and detail design of the system
• Created test plans, test strategy and test execution schedule for the projects
• Led and managed, facilitated review sessions of BAT QA documentation and sign-off of BAT documentation
• Prepared test cases ensuring all business requirements were adequately covered in the most efficient manner
• Ensuring change management procedures and standard for the SIT and UAT test cases are followed
• Created New Account Global Trading and compled stock transactions and wrote SQL queries on oracle to validate the transactions
• Verified the expected result using SQL queries in the DB2, Oracle by using Visualizer and created Stored procedures in PL/SQL
• Tested and generated the report of the accounts using Cognos Reports to verify the recently increased Credit limit from the DB2
• Executed test scenarios/scripts for functional, system integration testing for single or multiple platforms
• Conducted Walkthrough meetings with BA and Dev team to ensure coverage of all testing scenarios in the UAT Cases.
• Performed Functional testing and end-end Regression testing for STATS 2010 release.
• Used BO XI R3 to schedule, tested to generated the report and forcast using Essbase Reports and validate STATS reports with existing production data
• Escalated the defects and issues in UAT throughout different testing cycles and storing, maintaining and tracking them using QC

Environment : Oracle, JScript , VB, C#, JAVA, EIT Server, Websphere, SQL, MVS, IBM-IMS, IBM-OSS ISM, DB2, DB2 Vizualizer, Hyperion / Essbase, Cognos, AS400, eApp, bApp, CORE, C3, SOAP, IMS, DB2, .NET, HP QC, UNIX, MS SharePoint 2007, UFT/QTP

Lead/Sr. QA ANALYST

Confidential

Responsibilities:

• Gathered quality assurance requirements from project stakeholders and Analyzed Business and System requirements
• Led the team, ceated test plans, test strategy and ensured all required test resources are available for the projects
• Prepared test cases and uploaded in the JIRA ensuring all business requirements were adequately covered
• Participated in QM reviews of the test cases that were developed to ensure they fulfill the requirements.
• Executed test scenarios/scripts for functional, system integration testing for single or multiple platforms
• Participated in transitioning the test cases and scripts to UAT testing team and business areas in order to ensure a clear and complete understanding of the testing processes that were covered.
• Checked all information on the order should be capped and retained in eCommerce Engine as well as passed to SAP
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Prepared and Verified Test Case on EIT environment to generated the report and forcast using Essbase Reports
• Effectively communicates and builds rapport with team members, stakeholders and business partners using a variety of techniques and collaboration from initiation to close
• Created MRs to the concerned developer and discussed with the developer to resolve issues
• Provided Manager with status departmental weekly reports on all testing risks/ issues related to the project under test

Environment : UNIX, Oracle, JScript , Websphere, VB, C#, SQL, SOAP, Data Warehouse, ETL, Cognos, .NET, Hyperion / Essbase , HP-QC, SAP, DB2, Lotus Notes, IBM Rational tools, UNIX Server, WebService, Application Server and WinServer

Lead QA & UAT ANALYST

Confidential

Responsibilities:

• Gathered quality assurance requirements from project stakeholders
• Analyzed Business and System requirements and detail design of the system
• Led and followed established testing procedures, test microstrategy and standard for the IVR, SIT, UAT, PAT test cases
• Identified gaps in testing requirements and created traceability metric documents for SIT,UAT, BAT, PAT
• Created test plans and expected and actual test results for ETL processes, Oracle PL/SQL scripts and/or related applications
• Created and executed batch Jobs to generate Lead files customer’s profile in the DB2 and create Report or Marketing files
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Prepared Test Plan and Test Cases for the functional in the TestLink for the on line Call Center Insurance, UW Application
• Extracted lead files using VBA Screpting from the SFTP and saved it in to the DB2, Run the executable file and process the Fulfillment (WelcomeKits)
• Executed test scenarios/scripts for functional, Smoke, EIT , and UAT, BAT testing primarily for single or multiple platforms
• Provided Manager with status reports on all testing issues related to the project under test
• Verified the expected result in the DB2 by using Visualizer and used SQL queries to verify data in the Data Warehouse
• Worked closely with the development team and resolved the issue or all variances ensuring satisfactory resolution
• Verified test scenarios/scripts for functional, system integration and acceptance testing in the production environment

Environment : Oracle, JScript , JBoss, HP-QC, MS SharePoint 2007, SQL, PL/SQL, MVS, DW, Cognos , DB2 Visualizer, SAP and DB2

Lead TEST

Confidential

Responsibilities:

• Reviewed FDR and provided feedback and obtained clarifications during the planning stages Follow established testing
• Identified gaps in testing requirements, created traceability metric and risk assessment documents for SIT and UAT
• Created test plans(CETM) and test execution schedule for the multiple projects
• Prepared test cases ensuring all business requirements were adequately covered in the most efficient manner
• Created and executed batch files to generate customer’s profile from the ICBS (International Comprehensive Banking System)
• Executed test scenarios/scripts for functional IVR, SIT and UAT testing primarily for single or multiple platforms
• Verified the expected result in the ICBS and completed the request for the application by using CRS & Workflow in the back end
• Defined criteria for IVR, EIT, UAT testing, analyzed results of testing cycles and presented results
• Used view, Stored procedures in PL/SQL and created SQL queries to verify Oracle database tables as part of transaction
• Performed both component and system integration testing for ETL and BI reports
• Documented expected and actual test results for ETL processes
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Identified, assessed, log and monitored all variances ensuring satisfactory resolution prior to implementation
• Worked closely with Test Envirnment Managers to book envionrments for different level of testing, such as SIT and UAT test phases

Environment : UNIX, Oracle, JAVA, VB, Websphere, JScript , Batch files, .NET, SQL, PL/SQL, AS400, ICBS, MVS, IVR, TransUnion, Capstone, DB2, EIT Server, HP QC: QTP, Linux, SAP, ETL , Data Warehouse, cognos, ClearQuest

SAP Test Analyst

Confidential

Responsibilities:

• Prepared test plans, defined the scope, and schedules for testing business applications during the BA life cycle
• Configured AP, Vendor Groups/Number Ranges, Automatic Payment Program, Special Ledger Withholding Taxes, Check Settings
• Created, tested customer MD vendor data, accounts groups-payments and Dunning, maintenance document types number ranges
• Material Master MM - Reviewed and tested purchasing groups, purchase requisition, purchase orders, contracts, price determination process, material types, and valuation classes. Reconciled goods movement processing, goods issues, and goods receipts.Lead the system test team and effort, ensuring all system testing has been performed and the results documented
• Configured AP integrations to MM for various material movements (Automatic Account Assignments)
• Reviewed class diagrams to identify required technical test cases, executed test cases and documenting test results
• Worked with Project Manager(s) and System Testers to manage system defects and changes
• Identified test automation opportunities and designed reusable test automation scripts for regression testing
• Ensured change management procedures are followed and liaised with the lead architect(s) and development analysts
• Adhered to quality assurance guidelines and maintaining quality assurance on all deliverables
• Provided on-call support on an as-needed basis and performed Status reporting to the Project Manager(s) as required

Environment: Oracle, Java, JavaScript, C#, SQL, IVR, Crystal Report , Cognos , SAP MM, SD, FI/CO, HR, UNIX /Win 2000, HP QC