SUMMARY

• Over 17 years worked as a Software QA/UAT Tester and Business Analyst with extensive knowledge on entire SDLC/STLC.
• Experience in data analysis, software quality assurance of client/server and web - based applications and strong ability to troubleshoot complex systems.
• Experience and knowledge on various QA methodologies like Agile, Waterfall, Modified Waterfall.
• Have testing experience in manual, Smoke/Sanity, Functional, Black Box, White Box, Backend, GUI, Interface, Migration, Regression, Reports, Performance, Integration, End-to-End testing, SOA, UAT, SOX, Data validation for the software developed in Unix (Solaris, AIX, Confidential ), Linux, Mainframe, Exceed, Confidential, Sybase, DB2, Confidential, Vertica, MongoDB, HTML, XML, .Net, Java and C/C++.
• Have knowledge on Confidential, HIPAA privacy compliance rules, HL7, Medicare, Medicaid, SharePoint applications, WebEx, Skype, Sec 508 rules, IV&V, Data Modeling, Data profiling, NoSQL, AWS.
• Performed testing using the Test tools like ALM/Quality Center, CQ, JIRA, BLT, Capstone, BOXI, Xml Spy, PegaReach, WebTrak, Subversion, Confidential, Ms-TFS, Ms-Visio, BMC-Remedy and VMware, VDI.
• Have strong skills to create and maintain software test documents like Test Strategy, Test Plan, Test cases, test procedures and test scripts based on Use Cases, product specifications, Requirements, Design docs.
• Have experience in testing and supporting the issues found in Production.
• Co-ordinate with the business analysts and developers to resolve the defects based on requirements.
• Formulated and documented detailed test cases, test scenarios, recorded test results and provided test metrics to the program management and test management teams periodically and reviewed the progress.
• Have strong experience to understand the business requirements of various industries like Financial (Mortgage, Banking, Credit card), Telecommunications, Media Businesses ( Confidential ).
• Have strong testing experience on Data Warehouse/Data Mart applications.
• Having more than 10 years of experience in financial domain specializing on Credit Card, My Spending Report, Home Loan, Counterparty Credit Risk, Market Risk, ULDD, Pricing & Execution - WL, Securitization.
• Flexible and versatile to adapt to any new environment and any project.
• Ability to work under tight deadlines, on multiple projects simultaneously, translate high-level requirements and design into test cases and test scripts, and ability to work in cross-functional teams across multiple levels of organization.
• Possess excellent communication, presentation, analytical, issue finding, solving and learning skills.

TECHNICAL SKILLS

Operating Systems: AIX, Confidential -Unix, Solaris, Linux, MS-DOS, Mac, WINDOWS, Mainframe, ISPF

Databases: Confidential, Sybase, DB2, Confidential, SQL Server, Netezza, Vertica, MYSQL, MongoDB

Languages: SQL, T-SQL, PL/SQL, Shell Scripting, HTML, XML, XPATH, XSLT

Tools: /ETL ALM, ClearQuest, JIRA, Zephyr, iCART, BOXI, Anaplan, Capstone, Autosys, SoapUI, REST, IIS, AWS, AbInitio, Informatica, DataStage, Ms-Visio, Rapid SQL, TOAD, DB-Artisan, WinSQL, Confidential SQL Developer, WinSCP, VMware, VDI, AltovaXMLSpy, Confidential, PyCharm, PVCS Tracker, Anaplan, BPM, BMC-Remedy, WebTrak

PROFESSIONAL EXPERIENCE

Sr. DA/UAT Analyst

Confidential, VA

Responsibilities:

• Responsible to gather requirements from Business users/Stake holders
• Responsible to attend Business Requirements walk-thrus and analyze them
• Responsible to prepare LOE of the project.
• Responsible to write Test Strategy/ Test Plan
• Responsible to develop Test scenarios and Test cases
• Responsible to attend daily standup meetings and Project related meetings
• Extensively used Unix/Linux to load data from prod to test env. and mocked up as per testing needs
• Responsible to validate the data in Vertica target table with source xml/XML Spy loaded using Json files through MongoDB tool
• Performed Metadata validations comparing source data mapping file with Target table Vertica
• Performed testing on both Prod and NonProd (VDI- Virtual Desktop Infrastructure) environments
• Performed extensive Backend testing for validating test results with Rapid SQL/Vertica
• Wrote complex SQL queries to validate and compared the test results between Source and Target data.
• Extensively used Pivot tables through Excel to validate data
• Extensively used Excel to compare thousands of records of Legacy data (Hive) with Target data (Vertica)
• Extensively interacted with BAs/Developers and Business users to resolve the defects
• Ensure test case requirement Traceability Matrix - RTM
• Responsible to create Regression test suite after end of each project/Release
• Responsible to prepare Test Summary report
• Supported any issues raised in Production after project implementation

Environment: Vertica. XML/XMLSpy, Json/PyCharm, MongoDB Compass, Rapid SQL, Informatica, Autosys, UNIX, Linux, vi, Win SCP, Jira, VDI, SOA, MS-Visio, Confidential, Confidential Compare, Office 365

Sr. UAT Lead

Confidential, VA

Responsibilities:

• Responsible to gather requirements and understands prepare test scenarios
• Responsible create Test Plan/Strategy
• Responsible to create test cases and review with stakeholders.
• Issues will be entered into Issue Tracking system
• Responsible to review images generated from Express Lane tolls
• Responsible to interact with VDOT system to clear the pending Toll violations amount
• Responsible to initiate the Daily plan of UAT testing activity
• Responsible to conduct daily status calls after end of the daily testing
• Responsible to maintain Requirements Traceability Matrix
• Responsible to send daily status reports to across the teams

Environment: Confidential, SQL Developer, UNIX, Linux, vi, Win SCP, ALM, MS-Visio, SharePoint, Issue Tracker, Confidential Compare, BOS, WebEx, Office 365, Slack

Sr. UAT/Data Analyst

Confidential, VA

Responsibilities:

• Responsible to gather requirements from Business users/Stake holders
• Responsible to attend Business Requirements walk-thrus and analyze them
• Responsible to prepare LOE of the project.
• Responsible to write Test Strategy/ Test Plan
• Responsible to develop Test scenarios and Test cases
• Responsible to attend daily status meetings and Project related meetings
• Extensively used Unix to load data from prod to test env. and mocked up as per testing needs for data setup
• Responsible to review test cases within the team and with external teams
• Performed functional testing using Mainframe (TSO)
• Performed testing on both Prod and NonProd (VDI- Virtual Desktop Infrastructure) environments
• Performed extensive Backend testing for validating test results with Rapid SQL/DB2
• Performed extensive Integration and End2End testing
• Wrote complex SQL queries (Joins, Group By, Order By, Minus, Union) to validate the test results
• Performed reports testing and validated against Database
• Performed testing on Data Warehouse/ Data Mart applications using ETL scripts covered in Autosys jobs
• Experience in working SOA systems environment
• Extensively interacted with BAs/Developers and Business users to resolve the defects
• Ensure test case requirement Traceability Matrix - RTM
• Responsible to create Regression test suite after end of each project/Release
• Responsible to prepare Test Summary report
• Supported any issues raised in Production after project implementation

Environment: DB2, XML, XMLSpy, Sybase, Confidential, Rapid SQL, Mainframe, Informatica, Autosys, UNIX, Linux, vi, Win SCP, ALM, DOORS, VDI, Exceed, IIS, SOA, MS-Visio, Confidential, Confidential Compare, Office 365

Sr. UAT Analyst

Confidential, VA

Responsibilities:

• Responsible to gather requirements from Business users/Stake holders
• Responsible to attend Business Requirements meetings and analyze them
• Responsible to prepare LOE of the project
• Responsible to write Test plan/Test cases using Quality Center based on BR Doc
• Responsible to attend daily status meetings and Project related meetings
• Responsible to review test cases within the team and with external teams
• Performed functional testing in Agile environment
• Performed Data Sync testing, E2E Testing
• Performed Data Migration testing after data moved from Legacy application to new application.
• Performed Web services testing using SoapUI
• Prepared test data by importing data from Prod by running Unix/Autosys commands
• Extensively used complex SQL queries (Joins, Group By, Order By, Union) to validate large volume of data
• Communicate issues and status to Testing Manager in daily sprint calls
• Extensively interacting with BAs/Developers and Business users to resolve the defects
• Ensure test case requirement Traceability
• Responsible to provide Test data and information to Automation team
• Entered and tracked all defects through QC/ALM
• Supported any issues raised in Production after project implementation

Environment: Sybase, Confidential, QualityCenter, UNIX, Linux, Autosys Jobs, vi, IIS, Java/JDK, Agile, Subversion, WebLogic, Win XP/Win 8, MS-Project, SoapUI, MS-Visio, MS-Office

Sr. ETL Tester/Analyst

Confidential

Responsibilities:

• Responsible to write Test plan/Test cases using Quality Center based on user stories and Technical stories
• Performed testing in Agile environment
• Actively participate in Team’s Agile Scrum Methodology with regular Stand-up meetings, Scrum planning and Iteration Planning meetings
• Extensively used Unix commands and AUTOSYS jobs through Unix CLI which calls Ab Initio/ETL scripts for extracting data from source system and transforming into SQL Server
• Extensively used SQL queries (Minus and Union)/Scripts against Source to Target tables to validate the data with respect to Mapping sheet
• Performed testing both in QA and UAT environments
• Entered and tracked all defects through JIRA
• Extensively used Linux/Unix commands/scripts to perform backend validations
• Debug the log files to find the cause for failed Autosys jobs
• Track all Users Stories, Technical Stories, Defects and Production Support Requests in JIRA
• Mentor new team members in understanding the testing procedures in particular
• Supported any issues raised in Production after project implementation

Environment: SQL Server 2008, Sybase, XML, QualityCenter, JIRA, Unix, Linux, Autosys Jobs, Ab Initio, WinSCP, vi, I.E, IIS, Java/JDK, Agile Scrum, Weblogic, Win XP/Win 7, Ms-Visio, MS-Project, MS-Office

Sr. QA Analyst

Confidential, VA

Responsibilities:

• Reviewed the requirements, Technical specifications documents which were generated by DOORS tool.
• Responsible to write test cases using Quality Center, linked to the requirements, established Test Sets, and tracked through completion of testing
• Entered and tracked all defects through Clear Quest
• Extensively used ALTOVA XMLSpy tool for schema validation and edit xml file (MISMO 3.0 Standard)
• Extensively used XMLSpy tool to prepare xml test data files by filling borrower’s information like Fixed income, Monthly income, SSN, DOB, Address etc. to import into Loan delivery.
• Performed Desktop Underwriting (DU) through LD application
• Used Production data by importing from prod and analyze and mocked up as per testing needs
• Performed testing of transferring loans between the Pools and between the Commitments
• Extensively used UNIX (Solaris) commands and shell scripts to perform backend validations for Transmission testing after submitting the loans into two different LD releases 9.0/11.0.
• Used BMC Remedy to create tickets to modify the ‘CutOverDate’, ‘ArchiveModeDate’ for Customer transition testing
• Performed validations in the environment of TIBCO BPM tool
• Performed Data Persistence testing after importing loans to LD and taking DB snap shots before and after modification of loans and compared the results
• Performed Customer Transition testing on LD Legacy applications
• Performed archive process testing by running Unix scripts after submitting the loans
• Used AUTOSYS jobs of ETL (Ab Initio) through Unix CLI for which calls SQL scripts for extracting and transforming data into Sybase databases
• Extensively used SQL queries/Scripts against database to validate the test results
• Debug the failed importing files of xml
• Debug the log files to find the cause for failed Unix and Autosys jobs
• Responsible to perform functional, system, backend, interface, integration, Beta testing

Environment: XML/XmlSpy, Sybase, SQL, Sybase Query Tool, Quality Center, ClearQuest, Unix, Linux, Autosys Jobs, Ab Initio, WinSCP, vi, Subversion, TIBCO BPM, BMC-Remedy, Java/JDK, Weblogic, DOORS, Win XP, MS-Project, MS-Office

Confidential, VA

Senior QA Tester/Analyst

Responsibilities:

• Attended Project Walkthroughs and meetings of users
• Reviewed Business Requirements, Use Cases, Solutions Specs, Configuration Docs (GPP Configuration Matrix, User Roles and Entitlement Matrix) and created Test Scenarios and Test Cases for System, Integration and Regression testing.
• Responsible to write Test Scenarios and Test Cases for System, Integration and Regression based Report specifications doc for Report testing.
• Created wires with different accounts like MFO/CMO/SFO/FIN/CSH/ETS and used those accounts for testing at various Cut-Off times based on Fixed income.
• Performed validations in the environment of TIBCO BPM tool
• Entered and tracked all defects through Clear Quest
• Extensively written complex SQL queries/Scripts (Joins, Group By, Order By, Aliases etc.) using Toad against Confidential database to validate the test results of GPP application and GPP Reports
• Extensively used Unix (Solaris) commands/scripts for EOD and SOD jobs on daily basis
• Performed Reports testing with Business Objects Reporting tool BOXI
• Extensively used Quality Center for writing Test Cases and mapping them with Requirements and moving them to Test lab for execution
• Extensively used iCART/Clear Quest for entering and tracking defects
• Performed RTM (Requirement Traceability Matrix) after end of testing

Environment: Confidential, SQL, Toad, BOXI (Business Objects), Actimize Case Manager, QC, CQ, Unix Solaris, WinSCP, vi, LDAP, I.E, IIS, Java/JDK, ODBC, JDBC, TIBCO BPM, Weblogic, Websphere, DOORS, Windows XP, MS-Project, MS-Office

ETL Tester/Analyst

Confidential, CA

Responsibilities:

• Reviewed the requirements, wrote test cases using QualityCenter, mapped the requirements with Test Cases, established Test Sets, and tracked through completion of testing
• Extensively used Unix for Batch testing for the source files received for BK/FDR, Hogan, Powers, Billpay
• Extensively used AUTOSYS jobs through Unix CLI and UWCC for executing Autosys jobs which calls Ab Initio (ETL) scripts for extracting source data and transforming into Confidential database
• Extensively used SQL queries (Minus, Union)/Scripts against Source to Target tables to validate the data with respect to mapping sheet
• Executed test cases and validated the functionality on Backend by writing complex SQL queries (Joins, Order by, Group By, Aliases etc) against Source and Target tables of Confidential & Confidential databases
• Extensively worked on merging projects of Wachovia- Confidential and compared the results
• Extensively performed migration testing on new database server after code migration
• Validated alert messages/mails on different operating systems (Win7/XP/Vista and Mac OS) and different browsers (IE/FF/Safari) through VMware for FXOL project
• Performed Integration and End2End testing duly coordinating with other downstream systems
• Debug the log files to find the cause for failed jobs
• Entered and tracked all defects through ClearQuest

Environment: Confidential, Confidential, SQL, Confidential SQL Developer, QC, CQ, Hogan, Ab Initio, UWCC, Autosys, Unix, vi, Linux, Shell script, Java/JDK, Weblogic, VMware, Windows XP, Mac, MS-Office, IE/FF/Safari

Sr. QA Tester/QA Team Lead

Confidential, VA

Responsibilities:

• Attended walkthroughs of Use Cases and Requirements.
• Reviewed the requirements, wrote test cases using Quality Center, linked to the requirements, established Test Sets, and tracked through completion of testing.
• Performed extensively System, Interface, Integration, End2End, Regression and Implementation testing.
• Created Networx & Non-Networx Orders by using various networking & commercial products (ATM, FR, FRASI, PIP, USPL, VPWS, IDA, IDE, INP, EACS, BACS)
• Performed regression testing using QTP
• Performed backend validations on Sybase after submitting the Orders
• Created orders by choosing various Market Segments, Order Types, Options, various Access types DS0, DS1, DS3, OCn, Ethernet, various conditions like CPE, PVC, ESP
• Created orders (ATM, FR, FRASI, PIP, SIP, VOIP etc) using various Port Speeds, Port Types, Access Speeds
• As a Team Lead, responsible to assign the projects to the team members, Post the projects under test to Quality Center, performed RTM (map the req with Test Cases), review the Test Cases internally and externally, conduct the meetings with onshore/offshore teams to review the testing progress, prepare and send the daily testing progress reports
• Responsible for training and helping the newly assigned personnel in acclimating to the Testing Environment and Application process
• Entered and tracked all defects through Quality Center.

Environment: C++, J2EE, Sybase, IIS Web Server, WebLogic, Windows XP, Ms-Office, Ms-Visio, IE, QualityCenter, Products/Protocols (FTP, SSH, SMTP, SIP, SS7, HTTP, TCP/IP, IP, ATM, FR, PIP FRASI, VOIP, IPVPN)

Sr. QA Tester/Analyst

Confidential, VA

Responsibilities:

• Assured that all assigned campaigns meet QA entry and exit criteria prior to initiating campaign testing. This includes reviewing QAR for correctness and completeness.
• Prior to developing test cases performed pre-test reviews of applicable campaign requirements and design documents
• Responsible for preparing QA Test Strategy Documents, Test Plans, and User Acceptance Test Reports for assigned campaigns and wrote test cases using Quality Center, linked to the requirements, establishing Test Sets, and tracked through completion of testing
• Extensively used SQL scripts which call PL/SQL stored procedures to install/load the data into test environment
• Responsible for integration testing using Batch Load process which calls Unix shell scripts
• Performed QA Testing, entered and tracked all defects through the Bug Logging and Tracking system and provided clear and concise status reports of testing to the QA Manager
• Analyzed the LOG files for debugging after executing the scripts
• Responsible for Regression testing after fixing the defects

Environment: XML, C++, J2EE, Confidential -Unix, Linux, Shell Script, Perl, WinSCP, Putty, Sybase, Confidential, Netezza, WinSQL, DBArtisan, WebLogic, Apache, Windows XP, Ms-Office, Ms-VSS, IE, Netscape, WebTrak (Remedy), TAS, Quality Center, BLT, PegaReach, Confidential Client 6/7/8/9

QA Analyst

Confidential, VA

Responsibilities:

• Reviewed the requirements, wrote test cases using Test Director, mapped the requirements, established Test Sets, and tracked through completion of testing
• Extensively performed System, Interface, Integration, Regression and Implementation testing
• Used SAS for taking snapshots for Data validation before and after the Data load
• Extensively used complex queries in SQL (Joins, Group By, Order By) to validate the test results
• Prepared Test data based on positive and negative testing using TDG, vi editor and ISPF editor
• Responsible to execute Unix scripts/Batch jobs which calls the Ab Initio (ETL) scripts for performing BulkLoad process
• Performed migration testing on different DB servers and compared the test results
• Responsible for debugging the log files after executing the scripts
• Entered and tracked all defects in Clear Quest

Environment: Test Director, Clear Quest, Clear Case, HNC - Capstone BPM, AWS, TDG, SAS, Ab Initio, Confidential, SQL, PL/SQL, TOAD, Power Builder, UNIX, ISPF editor, vi editor, Shell script, IIS, Win2000/XP, Ms-Office