PROFESSIONAL SUMMARY

• Experienced Lead/Senior Quality Assurance Analyst with 10 plus years of experience in the Information Technology industry, involving analysis, Manual and Automated testing of Client Server and Web applications
• Possess specific experience in the Mortgage, Regulatory, Work Management, Financial, Domain Registry, eCommerce, ePayment, Telecom and Manufacturing industries
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scenarios, Test Summary, and Project Readiness Review Reports
• Possess specific experience in developing schedules, providing level-of-effort, and managing environments and resources
• Experienced in scheduling meetings with internal and external teams to review artifacts and preparing meeting minutes
• Experienced in coordinating with business teams, development, DBA and change management teams on day-to-day to review project related issues, defects, and environment refresh and deployment activities
• Possess specific experience in performing data analysis, developing test scenarios and complex integrated business scenarios, creating execution sequence and data criteria
• Led QA teams during entire project testing cycles for multiple releases
• Led Disaster Recovery Testing as per the procedures defined in the company
• Possess specific experience performing testing including ETL, Reports, Batch Jobs, WebServices, Backend Frontend, Regression, Functional, Interface, White box, Integration, Independent Verification and Validation, End-to-end and User Acceptance Testing
• Defined and Implemented Processes and Procedures for QA Departments
• Possess specific experience in verifying and validating InfoPump/SQLServer/Abinitio ETL and Enterprise Data Warehouse Processes, and testing the Business Objects Reports
• Possess experience in testing the XML Request/Responses, XML messages between systems and Customer XML Notifications
• Possess experience in validating UNIX batch jobs and verifying the output files and reports
• Possess specific experience developing complex SQL queries to perform Backend Testing in Oracle, Informix, SQL Server and Sybase databases using TOAD, AquaDataStudio, SQLServer Enterprise Manager and JISQL tools
• Proficient in developing Shell Scripts and validating PERL scripts
• Possess specific experience performing Regression and Functional Testing using Quick Test Professional
• Proficient in QualityCenter for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking
• Proficient in Rational ClearQuest, Borland’s StarTeam and Merrant’s PVCS for Defect Tracking
• Possess specific experience in leading the QA team during entire project testing cycles
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels

TECHNICAL SKILLS

Operating System: HP/Solaris/AIX/Linux, Windows, Apple Macintosh
Database: Oracle 7.x/8.x/9i/10g/11g, Informix 9.4, Sybase, SQLServer 2000
Languages: COBOL, UNIX, PERL, Shell Script, PL/SQL, SQL, SQL*Plus
Business Intelligence: Business Objects
Software: QualityCenter, Quick Test Professional, StarTeam, ADC Singleview, XML, SQL*Loader, Java, Ajax, Oracle Financials, MSOffice, TOAD, Micro Strategy, Oracle Forms/Reports, VB, PVCS, EnterpriseManager, JISQL, Rational ClearQuest, Rational ClearCase, Rational RequisitePro, Altova XMLSpy, Solstice Integra, AquaDataStudio, Hummingbird, Misys SUMMIT, DOORS
Data Warehousing: Sybase, InfoPump ETL, SQLServer ETL, Abinitio ETL
Network Technologies: ISDN, TCP/IP, DNS, Frame Relay, ATM, VPN, MIP, VoIP

EXPERIENCE

Confidential Mae 09/09 -Present
Lead Quality Assurance Analyst

• Develop and execute Business Certification Test (BCT) test strategy, test plan and test cases for Home Affordable Modification Program (HAMP) IR2 system
• Review and analyze Design, Business Rules and Requirements, Functional Specifications, High Level Design, Data Model and Inbound and Outbound Schemas
• Prepare schedules, provide level-of-effort, and manage environments and resources plan for each release
• Provide status and escalate issues as necessary during DRB and CRB meetings
• Coordinate with business teams, development, DBA and change management on day-to-day to review project related issues, defects, and environment refresh and deployment activities
• Develop Test Summary, Project Readiness Review and Treasury decks and review internally and externally with business teams and execute the approval criteria
• Schedule meetings with internal and external teams to review artifacts and prepare meeting minutes.
• Modify project plans frequently with testing activities completion percentages and resources related.
• Identify risks and escalate them as necessary and provide mitigation criteria
• Coordinate and lead day-to-activities for business teams testing that include software and environments support, deployments, restore, planning, execution, and validation and maintain issues log and resolve issues in a timely manner.
• Perform data analysis, develop test scenarios and complex integrated business scenarios, create execution sequence and data criteria
• Create Requirements Traceability matrix using Quality Center
• Lead Batch Jobs Execution, restore and deployment activities
• Lead Autosys Calendar Testing, Outbound Interfaces validation, complex SQL scripts creation and validation of XML and CSV files.
• Lead ETL validations, complex SQL scripts creation and validation of various CSV, Excel and PDF Reports, and support automation of Reports
• Lead the validation of Business Rules and Schema errors using XSD, XML Request and Response files using Altova XMLSpy
• Lead data creation activities and create data sets using XML files using Altova XMLSpy
• Developed SQL queries using TOAD to validate integrity of data in Oracle Database
• Developed shell scripts that produce reports for Batch Jobs execution related information and to retrieve error messages from UNIX logs
• Develop and maintain execution of test cases in Quality Center
• Review requirements, functional specifications, and Business Data Dictionary in DOORS
• Maintain project related artifacts in ClearCase
• Create and maintain defect information in ClearQuest

Environment: QuickTestProfessional, DOORS, File Exchange Hub, Synchrony, ETLS, BOXI, Calendar and JILs, Ablnitio, PL/SQL Packages, ClearCase, ClearQuest, QualityCenter, Shell Scripts, PERL, TOAD, Altova XMLSpy, Oracle, UNIX, AutoSys, Batch Jobs, JAVA, AJAX, J2EE, Weblogic

Confidential, formerly NASD 02/07 - Present
Lead/Senior Quality Assurance Analyst

• Developed and executed test strategies, test plans, test cases and test summary reports for Professional Certifications and Testing Organization System in accordance with SCRUMmethodology and FINRA Policies and Standards
• Reviewed and analyzed Requirements, Business Rules and Use Cases documents
• Attended Code and Testing Artifacts review meetings for each release
• Performed Regression, Functional, Database, Integration, Whitebox and End-to-end Testing manually
• Performed analysis on Production Change Requests, analyzed data requirements, created test scenarios and data criteria
• Led Disaster Recovery Testing as per the procedures defined in FINRA Application Disaster Recovery Plan and Database Restoration Policy
• Led projects by planning, preparing artifacts, executing the test strategy and closing.
• Led QA/UAT Environments Data and Filesystem Refresh Tasks and performed Sanity Testing
• Defined, modified, executed and implemented QA and Change Management processes and procedures
• Provided support during User Acceptance Testing
• Performed testing the functionality of various UNIX scripts, PERL scripts, and C/C++ executables
• Developed UNIX Shell Scripts to compare environments, validate user accounts, verify and validate the data in the files and databases.
• Developed complex SQL queries to perform database testing and validated the data in the Informix and Oracle databases using AquaDataStudio
• Validated connection pools, started and stopped Weblogic and performed testing on Web Services
• Involved in Single Sever Consolidation, SAN, Zones and Dev/QA Lab BuildOut and testing
• Validated Unix environments for Solaris and Oracle upgrades, validated Database Migration Scripts for Informix and Oracle
• Performed testing of user reports and validate the data against the databases
• Developed and maintained execution of test cases in QualityCenter
• Reviewed Requirements and Use Cases in DOORS
• Created and maintained defect information in PVCS and StarTeam

Environment: SCRUM Methodology, Shell Scripts, C, C++, VbScript, VB 6.0, Crystal Reports 6.0, DOORS 8.0, PVCS 7.5.1, C, SQL, Solaris UNIX, AquaDataStudio 4.7/6.0, Oracle 9i/10g, Informix 9.4, Java, JUnit, J2EE, Ajax, Autosys, Crontab, Jython, WebServices, VB, BEA Weblogic 7.x/8.1.6, Web Services, Eclipse SDK 3.3, Hummingbird FTP, Solaris 8/10, Sun OS 5.8, X-Windows, IE 6.0, Firefox 2.0, StarTeam 2005, QualityCenter 9.2, Ms-Office, Ms-Project

Confidential 01/07 – 08/07
Lead QA Analyst – Part Time

• Developed and executed test strategies, test plans, test cases and test summary reports for Intelligent Work Management System
• Led testing efforts during entire Software Development Life Cycle
• Analyzed requirements, performed data analysis, created test scenarios, data criteria, and Requirements Traceability Matrix
• Implemented Iterative Software Testing Methodology and QA Processes, defined and Implemented Defect Resolution and Workflow Processes
• Managed weekly Testing Status conference calls and Defect Resolution Meetings
• Performed testing of user reports and validated the reports data against the frontend and oracle database.

Environment: Iterative QA Methodology, SQL, UNIX, Toad 7.0, Oracle 9i/10g, Java, J2EE, Ajax, BEA Weblogic 8.1.6, Solaris 8, IE 6.0, Firefox 1.5, IE 6.0, IE 7.0, BugsWeb, Ms-Office

Confidential 01/06 – 12/06
Senior QA Analyst

• Developed and executed test plans, test cases and test summary reports for Collateral Management System and SummitDebts Entry Booking and Tracking Systems (DEBTS) for Finance and Portfolio Technology (FAPT) Technical Testing Services (FTTS) in accordance with SOX compliance and established Rational Unified Processes and Enterprise Level Systems ImplementationFramework (ELSIF) Policies and Standards
• Performed Regression, Functional, System, Database, Interface, Integration and End-to-end Testing manually
• Validated Treasury Front, Middle and Back Office functions, Collateral Outgoing and Incoming Transactions
• Verified and validated the Setup and Functionality of SUMMIT Security Access Layer and Business User Roles
• Validated functions of various Callable and Non-Callable Securities and Derivatives such as Bonds, Swaps, Swaptions and Cap/Floors in SUMMITapplication
• Generated SUMMIT reports using UNIX batch jobs and validated them in Unix against application and Sybase database
• Generated Collateral User Reports in Business Objects and validated data against the application frontend and Oracle database
• Performed testing on SOX Compliance Login and Monitoring and Change Password requirements
• Validated XML Messages using XSDs in Altova XMLSpy, validated data in XML Outgoing and Incoming Messages in Application UNIX logs, Messaging Hub, Application Frontend and the Oracle Database
• Validated System Subscriptions, Filters and Configuration Settings in Messaging ESB Hub
• Created and executed test cases for Duplicate, Out-of-order, Out-of-sequence, Business Exceptions and Negative Scenarios using Solstice Integra Message Injection Tool with JMS, FILE and SQL Adapters and Protocols
• Validated contents of Hub Wrapper, Message Business Event and PayloadXMLs in Messaging Hub System Queues, Application UNIX Logs and System Frontend
• Created and verified the Business Exceptions Pages that will be sent to Sender and Consumer Systems Pagers as per the NetCool requirements
• Managed daily testing status call, generated daily/weekly status reports, and developed metrics
• Provided training and support to Business Users during User Acceptance Testing

Environment:MiSys SUMMIT, RUP, SunSolaris UNIX, Shell Scripts, Oracle 9.2.0.7, Sybase, X-Windows, C++, JAVA, JSP, EJB, J2EE, XML, IDML, HTML, Windows XP, BEA WebLogic 8.1, TOAD 8.5, SharePoint 2.0, TestDirector 8.0, QualityCenter 8.2, Altova XMLSpy 2006, Solstice Integra 5.1, Business Objects 6.1, JMS, ESB, Messaging Hub, QuickTestProfessional 8.2, Rational ClearQuest, Rational ClearCase, JISQL 2.0, Rational RequisitePro 8.25, RM Sync

Confidential 05/05 – 12/05
Senior QA Analyst

• Developed and executed test plans, test cases and test reports for Customer Console applications in accordance with Verisign Naming and Directory Services Test and QA Process
• Performed testing of Registrations, Updates, Deletes, Syncs and Grace Period operations and EPP Commands for Domain, Contact and Host in Live and Offline modes
• Performed Database, Integration, Functional and End-to-end Testing manually
• Performed Automated Testing of Validation Rules and Regression Testing using Quick Test Professional
• Verified, added and modified the CRONTAB entries
• Monitored and restarted servers and clusters in WebLogic Console and deployed configuration changes
• Installed and verified Application and Database software builds in QA Environment as per Release Notes
• Created test data using XML input files, executed UNIX batch jobs, verified UNIX log files, validated output data in oracle databases and destination systems
• Executed SQLServer DTS Packages to generate and loaded SalesActivity data using UNIX Loader Scripts and validated the data in fulfillment databases
• Performed testing of Database ReportDriver, Configuration Files, SQL Scripts, Daily and Monthly Finance and Registrar Reports using PERL, XML, UNIX and Oracle

Environment:AIX 5.0, LINUX 2.4.9, WindowsXP, Shell Scripts, PERL Scripts, JAVA, JSP, EJB, J2EE, XML, HTML, Windows, BEA Web Logic 8.1, IIS, ASP, VB 6.0, SQLServer 2000, TOAD 7.6, Oracle 9.2.0.5, IE, Borland StarTeam 6.0, Quick Test Professional 8.2, TestDirector 8.0

Confidential 11/01 - 07/03 and 08/04 - 05/05
Lead/Senior QA Analyst

• Developed and executed test plans and test cases for e-Commerce applications verisignwebsites.com, networksolutions.com, quickbookswebsitesolutions.com, excel.ezsitedesigner.com, mycomputer.com and E-Mail applications
• Performed Functional, Integration, Regression, System, Backend, Frontend, Failover and End-to-end testing of the applications on IE/Netscape/AOL browsers and Windows/Macintosh platforms
• Validated information such as customer, credit card, pricing, order, invoice, billing, domain, web site, hosting, and email in the ImageCafe, Enterprise, ADC Singleview databases and in the billing and order fulfillment UNIX logs
• Responsible for creating test data and validating XML templates against the customer email notifications, and validated batch jobs
• Performed testing of new ADC SingleView system migrated from existing BARS billing system
• Responsible for Integration testing of ImageCafé application with 3rd party tools (mycomputer.com, quickbooks.com and multycity.com) and Storefront web sites with AOL partner

Environment: Sun Solaris UNIX, Shell Scripts, JAVA, JSP, EJB, J2EE, XML, HTML, JHTML, Windows, Macintosh, BEA Web Logic, Jscript, TOAD 7.6/8.0, Oracle 8.1.6/9i, ADC SingleView, IE, Netscape, AOL browsers and TestDirector 7.5/8.0

Confidential 08/03 - 08/04
Lead QA Analyst

• Participated in the development of test strategy, test plans, test cases and test execution of ePayment Portal System for Arlington County
• Responsible for integration, system, functional, regression, end-to-end and user acceptance testing
• Performed testing of Parking, Real Estate, Personal Property and Utilities input interfaces, validated ETL processes, eCheck and Credit Card payment processes
• Developed SQL queries to verify business logic and source systems data in lookup tables, commerce server catalog staging and destination tables, verify customer, bills, payment, transaction, vehicle registration and billing details in ePayment portal database tables
• Validated format and data in the eCheck and Credit Card output interface files.
• Tested email notifications and on-line administrative queries/reports

Environment: WindowsXP, ASP, .NET, SQLServer 2000, ETL, SQLServer EnterpriseManager, Microsoft Commerce Server, MsOffice, MsAccess

Confidential 01/00 - 11/01
QA Analyst

• Participated in the development of test strategy, test plan, test cases, audit reports using SDLC templates and test execution for Concert Data Warehouse (CDW) system integration with Datamarts and conformed to IT System Development Methodology Policies and Standards
• Responsible for Interface, Integration, System, Functional and End-to-end Testing of CDW interfaces with source/downstream systems to validate data/features of Concert services Frame Relay, ATM, MIP, and VoIP
• Performed testing of InfoPump ETL processes and validated the source data in the CDW source tables against the source systems
• Performed analysis and prepared test data, and validated data in the CDW atomic and downstream tables
• Validated Order Entry, Concert and Cisco Provisioning, Trouble Management, Network Performance Analysis Management, Customer Reporting, eCommerce and eService systems in regards to CDW integration
• Developed UNIX scripts to validate variable length UNIX flat files, developed SQL queries to validate data in Sybase, Oracle and SQL Server databases and validated reports data in Multi-dimensional Micro Strategy database

Environment:SybaseData Warehouse, ETL, Oracle 7.3/8i, HP-UNIX, InfoPump ETL, TOAD, Sun Solaris UNIX, Micro Strategy, ASP, PVCS 6.7, SQL Server 2000, TestDirector 7.5, Networking Technologies

Confidential 08/98 - 12/99
Data Analyst

• Performed analysis of data requirements from multiple source systems and data cleansing activities for conversion of legacy systems to the Oracle Financial Applications
• Developed and executed UNIX shell scripts to verify and modify the data in fixed length flat files
• Developed SQL queries for ad-hoc querying of General Ledger, Account Payables, Purchase Order, Inventory and Account Receivables modules of an Oracle Financials database
• Developed presentations on GL and AR modules and provided training to end users

Environment: Mainframe,HP-UNIX,JAVA,Oracle 8.0, Oracle Financials 10.6/11.0, Windows, Oracle Developer 2000, Pro-COBOL, Shell Scripts, SQL Loader, SQL, WinRunner 6.0, TestDirector 6.0

EDUCATION

Bachelor of Science, Engineering, Confidential
Post Graduate Diploma, Computer Applications, Confidential
PVCS Version Manager Administration Training
Sun Solaris UNIX Administration Training
Project Management Professional Training