SUMMARY:

• A highly experienced ‘ Senior QA Test Lead Engineer’ with Nineteen years of experience in Functional Testing, Data quality management in the Software Development industry and with a proven ability of mentoring and working with cross - functional teams located both on-shore and off-shore.
• A versatile team player, ambitious self-starter with strong analytical and problem-solving skills, I have worked in Agile/Scrum functional teams using Jira and Rally tools.
• Seven years’ experience with Agile methodology used in both Scrum and Kanban teams using Rally and Jira tools for project features and defect management.
• Seven years of experience in MS-SQL Server Integration Services (SSIS) ETL testing, Oracle & Vertica DB testing, SQL queries using Toad for Oracle, MicroStrategy Reports testing.
• Seven years of experience working with offshore teams (India and Europe) and assigning testing responsibilities and reporting the status to QA test execution to Business Directors and Vice-Presidents. Responsible for updating QA weekly status reports.
• Three years of Performance testing experience using HP LoadRunner 9.5 and testing financial credit-based web applications built using IBM WebSphere Application servers and Process servers.
• Solid experience working in Financial institutions and involved in System integration testing, Component functional testing of Loan Origination and Loan Maintenance systems.
• Experience in testing MicroStrategy and Tableau reports and Business Intelligence features.
• Experience in Functional Testing, System Integration Testing, Black Box Testing, white Box Testing, Performance Testing and Regression Testing
• Experience in writing extensive SQL Queries using Toad for Oracle, Toad Datapoint and MS SQL Server 2014 .
• Fostered Inclusive team environment at Confidential that stimulated dialogue and encouraged different opinions.
• Modified team behavior to adopt and attain management goals .

TECHNICAL SKILLS:

ETL and Reporting Testing tools: MS: SQL SSIS, Tableau and MicroStrategy Reporting Tools

Performance Test Tools: HP LoadRunner 9.5, Visual Studio 2010 Load Test

Defect Tracking Tools: HP Application Lifecycle Management 11.0, Microsoft Test Manager and Team Foundation Server (TFS), HP Quality Center 9.2, Merant PVCS Tracker 8.0

Application Servers: MS Windows Server 2008 R2, IBM WebSphere 6.1

Microsoft Technologies: ASP .Net 4.0, C # 4.0, MVC 3.0, COM/DCOM, MS Security, Web Services.

CRM/ERP: Siebel eMedia 7.5, Siebel Call Center 2000 (6.x)

Operating Systems: Windows 10, OS/400, Sun Solaris UNIX, Linux AS 3.0U5, Red hat Linux 6.2

RDBMS: Oracle 12c, MS SQL Server 2014, Vertica, DB2 7.x/8.x

Web Related languages: C#, JavaScript, VB Script, IIS, HTML, DHTML, XML

QA Management Tools: MS Test Manager 2010, DOORS 6.0 (Teleologic), Team Track 5.51

Change Management Tools: Merant (PVCS) Version Manager 8.0

Business Intelligence tools: MicroStrategy 9.x, Tableau 7.x, SAP Business Objects 11.x

Microservices, REST API: MuleSoft microservices, POSTMAN

PROFESSIONAL EXPERIENCE:

Sr. QA Team Lead

Confidential, Plano, TX

Responsibilities:

• Displayed Strong leadership and mentoring skills while managing a team of 5 to 7 QA Analysts (Offshore) and active communication within the Line of business (LOB) as well as Technology integration teams.
• Responsible for overseeing and coordination of essential project tasks such as Resource Cap plans, Daily MS SharePoint project QA updates, QA test metrics and onsite daily QA defect triage meetings.
• Responsible for ETL MS-SSIS Job scheduling, Logs validation, Data verification after night jobs execution.
• Responsible for providing daily project updates for Enterprise Event Data store (EEDS) Waterfall and Agile projects.
• Responsible for actively tracking potential roadblocks and proactively resolve all team issues with proper escalation to development and business teams .
• Active daily participation in Scrum meetings, implementation of Agile methodologies, updating offshore team members status and progress in Rally and Jira tools.
• Responsible for mentoring Offshore teams on business features and stories to be tested. Worked with Both Waterfall and Agile project testing teams.
• Experience with SOAP UI, Postman tools for API testing of REST web services Requests and Responses for Mortgage Servicing Platform (MSP) and collaborating with Black Knight Financial Services external vendors and MuleSoft microservices validation.
• Responsible for BI testing of Reports built using MicroStrategy and Tableau tools.
• Responsible for validation of Splunk logs and JSON formatting in log files for microservices validation.
• Strong analytical, administration and problem-solving skills and dedicated to maintaining Bank security and industry financial standards.

Environment: Windows 7 client, Toad for Oracle 11.x, HP ALM 11.x, Rally 2015.2, Jira, SOAP UI, Postman, SOA, Tableau 7.x, MS SharePoint, MS Office 2013, ETL SSIS, Splunk logs, MuleSoft microservices, HP-UFT, Selenium Web Driver.

QA Lead Analyst

Confidential, Dallas, TX

Responsibilities:

• Responsible for Traceability matrix, Business requirements analysis and Test plan and Test case documentation.
• Responsible for test planning and coordination between AHA business partners and technical teams for extensive test coverage of Business requirements.
• Responsible for Test execution and defect tracking using Bugzilla tool.
• Management of Data migration testing from Oracle 10g to 12c.
• Managing defects in Test environment & performing root cause analysis.
• Planning and coordinating UAT (User Acceptance Testing) test cases and maintaining communication with management, testers, development, and stakeholders on project status.
• Management of project testing schedule & quality of deliverables.
• Experience in working in a collaborative team-oriented environment.

Environment: Windows 7 client, Java/J2EE, HTML, CVS, Bugzilla, Jira, Oracle ATG, MS SharePoint, MS Visual Studio 2010, MS Office 2010, Internet Explorer 11.0, Chrome 44.x, Firefox 40.x, Safari browsers.

QA Engineer

Confidential, Addison, TX

Responsibilities:

• Strong leadership and communication skills while managing a team of 5 QA Analysts (Offshore and Onsite) and communicated within the Business as well as Technology teams.
• Responsible for overseeing and coordination of essential project tasks such as Resource Level of Effort (LOE), QA test status, QA test metrics and QA resource allocation assessments.
• Responsible for providing daily project updates, actively tracking potential roadblocks and proactively resolve all team issues with proper escalation when needed.
• Responsible for Extraction, Transformation and Loading (ETL) test using Microsoft SQL Server Integration Services 2012 (SSIS) during conversion of Home Mortgage Loan Fulfillment Replacement System.
• Independent QA management of 15 ETL’s for Oracle data migration project.
• Responsible for SSIS ETL package and Oracle Database testing using Toad for Oracle 11g Xpert tool.
• Implementation of Agile methodologies, Scrum, Data Driven testing and mentoring Offshore/onsite teams on Automation tools using HP UFT.
• Experience with SOAP UI to test the web services Requests and Responses for Mortgage Fulfillment system
• Strong experience with execution of nightly Batch jobs testing in Linux system.
• Extensive experience in test data extraction and data preparation for use of offshore teams
• Experience in testing SSIS packages with Error Handling and logs verification.
• Experience validating the data at each transformation - source tables, staging tables, loading tables and finally destination tables/views --using the data mapping files and data dictionaries.
• Strong analytical, administration and problem-solving skills and dedicated to maintaining high quality standards.

Environment: Windows 7 client, MS-SQL Server Integration Services (SSIS) 2012, Toad for Oracle 11, Oracle 11g,Datawarehouse, HP Application Lifecycle Management (ALM) 11.x, MicroStrategy Reports, SOAP UI, Red Hat Linux 6.2 , HP- Unified Functional Testing 11.x , MS SharePoint, MS Visual Studio 2010, MS Office 2010, Internet Explorer 9.0

SENIOR QA ENGINEER

Confidential, Addison, TX

Responsibilities:

• Responsible for hands on implementation of Agile software methodology in the QA department in Dallas and India office.
• 2 years of experience using MTM tool for Agile implementation, daily standup SCRUM meeting and ceremonies.
• Responsible for writing User stories in Microsoft Team Foundation Server 2010 (TFS) and using MS- Test Manager for Test Cases Repository and Defects management.
• Responsible for systems integration testing of web-based C# and MVC Accounting reconciliation and Journal entry application with SAP ERP applications.
• Experience with execution of Batch testing framework-based jobs
• Responsible for daily Scrum meeting with engineers, testers and document writers in Indian office to coordinate progress of tasks in each Iteration
• Responsible for running Installers to complete Manual Installation of web-based application using IIS, Database server, report server.

Environment: Windows 7 client, SQL Server 2008 R2 and 2005, ASP .NET 4.0, MVC 3.0, Internet Explorer 9.0, MS Test Manager 2010, Team Foundation Server 2010, Visual Studio 2010, MS Office 2010, Internet Information Services ( IIS) 7.5 in Microsoft Windows Server 2008 R2, Intellicus Report server, Agile, SCRUM methodology

Senior QA ENGINEER

Confidential, Plano, TX

Responsibilities:

• Responsible for Performance testing of Deallink - Java based web application using HP LoadRunner 9.5.
• Used LoadRunner Http/Html protocol to build test scripts and data wizard to get data from Oracle 10g database for the parameterized fields. Executed 10 to 12 scripts and verified log files on IBM WebSphere Application servers and process servers. Executed SQL scripts to verify validity of database records created during performance testing.
• Prepared Performance Latency reports after successful load tests which were submitted to DBA team, IT Directors and Executive leadership teams before new servers and applications were deployed to Production.
• Latency reports included number of users, iterations , number of transactions and documents created in one-hour, average transaction response time, standard deviation and latency duration for each script.
• Responsible for fixing and execution of automation scripts (Quick Test Pro 9.5) for each Regression test cycle and creation of test execution reports in Quality Center 9.2
• Responsible for Functional and System Integration testing of Siebel CRM system, Java based Deallink and Oracle Forms based Daybreak system.
• Responsible for following IT Audit processes like software development life cycle (SDLC) while working with Project Managers, Business analysts, Software developers, and UAT teams.

Environment: Windows XP, J2EE, XML, IMB WebSphere 6.1, Siebel 6.2, Oracle 10g, Internet Explorer 7.0, Business Objects 11 (BOXI), SQL Navigator 5.0, HP Quality Center 9.2, HP LoadRunner 9.5., Quick Test Professional (QTP) 9.2., PVCS Tracker 8.0

QA ANALYST

Confidential, Plano, TX

Responsibilities:

• Fully involved in Functional and System Integration testing of Vehicle Inventory Processing System (VIPS)- a .MS .NET application built on MS SQL Server 2005 database.
• Extensively used Mercury Quality Center (Test Director 8.2) for writing Requirements, Test Plans, Test Scripts, and Defect Tracking.
• Solid hands on testing writing SQL queries using Query Analyzer of SQL Server 2005 and testing SQL Stored Procedures.
• Solid testing with Real time XML messages, XML attributes and database validation.
• Coordinated defect management within QA team and assisted QA Manager in prioritization and scheduling of QA projects and workload

Environment: Microsoft VB ASP .Net 2.0, VB .Net, CSharp, JavaScript, XML, XSLT, SQL Server 2005, MS XP, Internet Explorer 7.0, Firefox 2.0, Subversion, Mercury Quality Center 8.2, Mercury Quick Test Pro 8.x

QA ANALYST

Confidential, New Providence, NJ

Responsibilities:

• Two years’ Experience in handling off-shore QA teams in Onsite/Offshore model.
• Analyzed the Functional and Business requirements, prepared Test Plans, Test-cases and QA Test strategy for Siebel configuration and Integration management.
• Tested the Siebel Order Management (Seibel eMedia 7.5) application which involved eConfigurator, Web-templates, Product and Pricing, creating Quotes, Orders, Assets along with Billing and Invoicing system which involved integration of Siebel Enterprise system with 6 legacy systems (Visual Basic, Web, COBOL applications)
• Tested the Oracle 9i Advanced Queuing (OAQ) middleware used by Siebel system to integrate with legacy systems.
• Responsible for data mapping, configuration, reconciliation and accuracy of the data loads and production of extracts, queries and reports to support data loads.
• Responsible for weekly Siebel code promotions to both QA test environments including SRF, Business services, Work-flow processes, Workflow policies, Class Administration, Importing Products and Pricelists, generate Triggers, load Web-templates etc.
• Used SQL Navigator 4.5 to run SQL scripts, packages to load Accounts, Contacts, and Activity data from text-based flat-files into Siebel EIM tables and ran the EIM process using ifb files to load EIM data into Siebel base tables.
• Tested the Siebel Sizing Process which was to automate the modify functionality in the ABO cycle which involved creation of delta quote, delta order and promoting the delta order to the Asset and finally send the changes to the downstream legacy systems.

Environment: Siebel eMedia 7.5 /6.x, Windows NT/XP, Oracle 9 i , Internet Explorer 6.0, Sun-Solaris 5.8, Red-hat Linux AS 3.0U5, Merant Version Manager 8.0, Merant Tracker 8.0, Tidal scheduler 5.0, SQL Navigator 4.5, Penguinet 2.23