SUMMARY:

• 15 years of Software Quality Assurance experience testing in different environments for Web based, Client Server based Enterprise applications.
• 8 years of experience as QA Lead with maximum team size of 10 members.
• Good familiarity with testing data warehousing and mainframe applications.
• Experience working in transportation, banking, airlines, telecom and retail industries.
• Strong knowledge of Software Development Life Cycle (SDLC) methodology
• Implemented high quality software through effective project management, process improvement, software quality practices and tools for defect prevention.
• Proficient in Functionality Testing, Regression Testing, UAT, PAT, Integration Testing, Infrastructure testing, GUI Testing, Backend Validation Testing, Data Driven and Non - Functional testing like performance testing, failover testing, and security testing
• Very strong experience in testing Retail POS and EMV functionality.
• Strong experience testing applications using SOA (Service Oriented Architecture).
• Strong experience in developing Test Strategy, Test Plans, Test cases and T est scripts using business requirements and design documents.
• Extensive experience following testing methodologies like Agile/Scrum, RUP and Waterfall.
• Leveraged relationships across other departments and maintained mutually beneficial professional relationship within and across teams and organization.
• Extensive experience in the Quality Assurance with Automated/Manual testing of Web based, Client/Server applications using Black Box and White Box testing techniques.
• Highly proficient in using HP Quality Center/HP ALM for testing related tasks and reports.
• Very strong knowledge of Defect Management processes and tools.
• Familiar with CMM methodology and ITIL concepts for best practices in the IT industry.
• Good experience working with TOAD, Query Analyzer and SQL Developer.
• Good knowledge of basic UNIX commands and Linux command line interface.
• Familiar with DevOps methodology and practices and CI/CD tool Jenkins
• Good understanding of concepts of Hadoop and Big Data
• Good understanding of Relational Database Management Systems.
• Proficient in SQL for testing database integrity writing complex queries, stored procedures using joins, create views. Detailed understanding of Master Data Management.
• Highly skilled, motivated player, outstanding organizational skills and excellent communication and Inter-personal skills

TECHNICAL SKILLS:

Tools: HP ALM 12.0, QTP 10.0, SOAP UI 4.5.1, Rational Clear Quest, JIRASiebel CRM 8.1.1, JMeter, CA R12 CMDB, GitHub

Operating Systems: RH Linux 7.1, UNIX, AIX 5.3, IBM Mainframes, AS/400, Windows 7

Languages: SQL

ETL Tools: Informatica Power Center 7.1/5.1.2

Web Technologies: J2EE, JSP, EJB, C# .Net 4.5

Application Servers: WAS 6.1, BEA WebLogic, webMethods 7.1.2

Databases: Oracle 11g, 12c, SQL Server 2008/2012, DB2, MySQL

MS Office Tools: SharePoint, Word, Excel, PowerPoint, Outlook, Project, Visio

Source Control Tools: Rational Clear Case, TFS, VSphere, Tivoli Storage Manager

Reporting Tools: SAP Business Objects 4.2

Training: SAP Basis; Pega PRPC

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Lead QA Analyst

Responsibilities:

• Project was implemented using Agile methodology in three weeks sprints
• Excellent understanding of ETL process and concepts.
• Reviewed the Source to Target Mapping (STM) document with all the business rules, data transformation rules, join conditions, de-dup logic for different tables.
• Validated database integrity and ETL process by running DataStage jobs and running queries against Oracle database using SQL Developer tool
• Tested the integration between MS CRM and web-based Compensation Payment application
• Worked with GitHub for version control and Jenkins for configuration and deployment

Environment: C# . Net 4.5, Oracle 11g, GitHub, JIRA, MS CRM, IBM DataStage, Jenkins

Confidential

Lead System Tester

Responsibilities:

• Led the testing and implementation effort for this initiative with great efficiency
• Worked closely with Project Manager, Business Analyst, Developers and End Users during all the phases of SDLC
• Analyzed the Business Requirements and Wireframes to come up with test cases and scenarios
• Created Test Strategy and Test Plan for the project documenting the strategy and testing tasks in addition to outlining the defect management process
• Tested the digital version of the application on iPad and other mobile devices
• End to end testing of the complete process from request to printing the receipt on wireless printer
• Tested the application integration with mainframe system of Ministry of Transportation

Environment: Java, SQL Server, MS SharePoint, HP ALM, iPad Pro, IBM Mainframes

Confidential

Program QA Lead

Responsibilities:

• Worked closely with different project teams to get the requirements based on functionality
• Good working knowledge of Function Point Analysis (FPA) for estimating test effort by calculating complexity of the system
• Assisted Senior QA Lead in resource allocation based on skill set and availability
• Developed Master Test Plan for the program incorporating the overall test strategy, risks, constraints, mitigation strategies, assumptions, test metrics and test design techniques
• Reviewed business, functional and technical requirements, solution architecture and system support documents and provided feedback
• Created test artifacts Test Plans, Test Strategies, Test Design documents based on the Requirements/ Functional Specifications as per ISO/IEC/IEEE 2
• MS SharePoint was used as documents repository and for managing approval workflows
• Worked on a cloud-based mobile application SafeTTC to be used by public for reporting different incidents. This involved testing on iOS and Android devices for its functionality and usability and was developed using Crashlytics
• Tested the upgrade of in-house developed .Net based Absence Management Systems with Oracle 12c database and BOE 4.2 reports
• Tested Commercial Off the Shelf (COTS) applications like IBM Maximo, Pathlore LMS
• Designed high level test scenarios based on the use cases and business specifications
• Created detailed test cases, mapped them to the requirements in MS Team Foundation Server
• Tested data migration after database upgrade from Oracle 10g to Oracle 12c
• Worked with Oracle Swingbench tool for database performance testing in conjunction with EMC SAN storage disks VNX 7600 and VNX 5700
• Conducted failover testing of the database and applications in between data centres to ensure high availability of critical applications
• Tested applications integrated with Active Directory and SharePoint systems
• Conducted UAT by working closely with business users and got the UAT signoff.
• Conducted performance testing by creating virtual users and analyze response times
• Worked closely with Change Management to ensure timely release to production
• Developed a Master QA Status Report with KPIs, Test Metrics and Dashboard for projects in progress and presented to the higher management

Environment: C# . Net 4.5, SQL Server 2012, MS SharePoint, MS TFS, Oracle 11g/12c, EMC VNX 7600, BOE 4.2, RH Linux 7.1, CA R12 CMDB, Oracle Swingbench

Confidential

QA Lead

Responsibilities:

• Worked closely with the project teams to get the requirements based on user stories.
• Agile methodology was followed for these projects.
• Designed high level test scenarios based on the use cases and business specifications.
• Created detailed test cases, mapped them to the requirements in HP ALM tool.
• Customized data based on business rules and parameters to ensure coverage of requirements.
• Participated in daily Standup meetings with the project team to discuss the tasks performed and bring up any roadblocks in performing the tasks.
• Worked with JIRA for sprint planning and executing tasks associated with User stories.
• Test execution, defect tracking and management were done using HP ALM.
• Tested the integration of the POS with Equity System which is the backend of this enterprise.
• Tested the various batch jobs from the Mainframe systems for Inventory Management.
• Worked closely with BA’s to identify the test scenarios and test execution.
• Good experience in gathering requirements from the dealers and documenting them.
• Provided production support to the stores for their applications and hardware issues.
• Validated the financial transactions from POS as per the ISO 8583 protocol
• Credit and debit card processing was testing as per the EMV functionality.
• Verified the new backup solution designed for data backup and recovery.
• Tested the backup and restore process using IBM Tivoli Server Manager.
• Validated the logs after data migration and every day backup.
• Tested the POS functionality for failover scenario by making one server offline and secondary server as Primary.
• Hands on experience in testing non-functional requirements including performance testing
• Monitored the servers and virtual machines using VMWare vSphere client

Environment: . Net, DB2, SQL Server, MS Office Suite, MS SharePoint, Windows XP, SQLHP ALM 11.0, JIRA, IBM Tivoli Storage Manager, Mainframes, vSphere client

Confidential

Sr. QA Analyst

Responsibilities:

• Work closely with the business teams to get the requirements.
• Agile methodology was followed for these projects.
• Customized data based on business rules and parameters to ensure coverage of requirements.
• Participated in daily Standup meetings with the project team to discuss the tasks performed and bring up any roadblocks in performing the tasks.
• Tested the integration of the website with sponsors like BMO, Shell, RONA, AMEX, etc.
• Tested the ETL process of files getting loaded into DW from other partners.
• Offers are sent in files which are processed by Informatica and then loaded into tables.
• Validated the data format and field level accuracy of the files.
• Tested large scale data migration between DB2 and MySQL.
• Validated the data migration from old legacy database to new database.
• Tested different web services used for update profile, update account balance, redemption.
• Used SOAP UI tool for testing the web services.
• Validated the XML for data validation and field accuracy.

Environment: Asp.Net , SOAP UI 4.5.1, DB2, Oracle, MySQL, Informatica Power CenterMS Office Suite, MS Sharepoint, Windows XP, SQL, HP ALM 11.0, QTP 10.0

Confidential

Sr. Web QA Analyst/Business Analyst

Responsibilities:

• Work closely with the business teams and about 12 partners to come up with the requirements.
• The different partners involved were Air Miles, Capital One Financial, ESSO, Delvinia.
• Tested different mainframe screens in various CICS regions.
• Performed different transactions on POS for various stores and accounts tiers to populate the points activity screen.
• Worked extensively with TSO mainframe screens to validate different functionality.
• Used SPUFI interfaced with DB2 database to extract data as required by test conditions.
• Customized data based on business rules and parameters to ensure coverage of requirements.
• Tested Points Transfer, Adjustments, Air Miles redemption, ESSO Exchange conversion from various screens and ensured quality product before implementation.
• Tested the integration of the website with various partners and the user interface of Confidential .
• Validated different rates and rules for transactions done with Confidential Mastercard and Private Label Credit Card (PLCC) a type of smart card where you put money and use it at Confidential Banners like Bay, Zellers, Home Outfitters and online stores.
• Validated the settlement reports from partners Capital One, Air Miles, ESSO.
• Transferred data files to partners with the transactions and received the same for validation.
• Validated the batch reports which were scheduled to run daily, weekly and monthly.

Environment: TSO/ISPF, COBOL, JCL, CICS, AS/400, MVS, Mainframes, SPUFI, Asp.Net , DB2, Team Foundation Server (TFS), MS Office Suite, Windows XP, SQL

Confidential

Sr.QA Analyst/UAT Coordinator

Responsibilities:

• Excellent understanding of ETL process and concepts.
• Reviewed the Source to Target Mapping(STM) document with all the business rules, data transformation rules, join conditions, de-dup logic for different tables.
• Created database tables required as per the data model and data definition logic.
• Developed complex SQL scripts with joins, functions and conditions for the tables using TOAD.
• Ensured the data-type mismatch is handled correctly by the ETL code in Informatica.
• Created the Referential Integrity scripts based on the data model made in ERWIN for testing the Parent/Child relationship between tables.
• Ran the SQL scripts in TOAD and analyzed for any failures. Modified the scripts and created defects in HP QC
• Worked on BIDW, Supply Chain system, Retail Pharmacy System, Optimum Online, Siebel CRM and Base 24 ePOS projects.
• Objective of the project was to convert the legacy systems into Siebel CRM application for better and faster service to the customers.
• Tested commercial off-the-shelf (COTS) POS application from PCMS Datafit.
• Very good understanding of Supply Chain process and Inventory Management Systems.
• Good experience in implementing EMV functionality.
• Tested the system for PCI compliant transaction methods.
• Conducted EFT certification testing with vendors like Incomm, and Moneris Solutions.
• ISO 8583 protocol format was used for financial transactions validation
• Merchandising and pricing was tested on IBM Mainframes based MMS system which integrated with the POS server.
• Worked with the accounting and billing departments for validating different reports.
• Conducted Infrastructure testing during the upgrade of NCR registers and Dell servers from IBM registers and servers.
• Worked with IBM MQ and Message Broker for sending down promotions and product files.
• Validated the transactions in XML files to troubleshoot issues.
• Coordinated the Production Acceptance Testing (PAT) during the release.
• Assisted in the Performance and operability testing of different systems involved.

Environment: Base 24 POS, J2EE, HP Quality Centre 10.0, WAS6.1, ERWIN, TOAD, MVS, Message Broker, MQ, Oracle EBS, Siebel CRM 8.1.1, AIX, DB2, ITIL v3, DB2, MMS.

Confidential, Weehawken, NJ

Sr QA Analyst

Responsibilities:

• The project was to develop a new product called Business TV build upon the existing backend system Odaptor. It is a Video on Demand product.
• Participated in daily Scrum meetings with the project team to discuss the tasks performed and bring up any roadblocks in performing the tasks.
• Tested the WSDL and XML messages in the SOA architecture using Parasoft SOA.
• Validated the registration, user accounts, comments posted, and other entries in the backend by executing SQL queries against the SQL Server 2005 database. Used TOAD for this task.
• Performance testing was done using JMeter by creating virtual users and analyze response times

Environment: Asp.Net, Adobe Flash/Flex, MS Visual Studio 2008, SharePoint, TOAD, WSDL Parasoft SOA, Webservices, APIs, XML, UNIX, ITIL v2.