SUMMARY

• A highly motivated, extensive IT experienced in software Development Life Cycle (SDLC), Software quality assurance with manual and Automation testing using Selenium WebDriver, and certified Microsoft SQL Database Administrator with a total of more 15 + Years of diverse work experience related to IT focusing on quality assurance, data collection, data modeling, server installation and configuration, databases design and Administration, analysis and reporting.

TECHNICAL SKILLS

Platforms/Operating system: Windows Server 2003/2008/2008 R2/2012/ 2012R and 2016

Testing Tools: Selenium, LoadRunner, Quick Test Pro, JMeter

Bug Reporting Tools: Quality Center ALM, Test Director, ClearQuest, SBM, JiRA

RDBMS & Environments: Microsoft SQL Server Oracle, DB2 and MS Access, Windows, Linux/Unix

Database analysis Tools: SQL Profiler, SSMS, SSCM, SQL Data Tools (SSAS, SSIS (ETL), SSRS), Enterprise Manager, Window Performance Monitor, Database Tuning Advisor, SQL upgrade adviser, SQL Query Analyzer, Microsoft Clustering Services (MSCS), Windows Server Update Services (WSUS), Microsoft System Center Configuration Manager (SCCM)

Some Third - party tools: IDERA, Red Gate, Erwin, Splunk, SAP, AWD, DTCC, Bank Call

Programming and internet tool: D/HTML, XML, Java, Javascript, Visual studio

BI and Reporting Tool: SSIS, SSRS, SSAS, SPSS, MSTATc

Storage & Networking: DAS, SAN, NAS, LAN, WAN.

Database Language: T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Quality Assurance Analyst

Confidential

Responsibilities:

• Work with Business Analyst and programmer for Business and system requirements and ensured end to end functional, System, integration, Unit Test, structural, performance, load and regression testing for different application (Data warehouse (oracle and MS SQL database), Mainframes, Note Source, Companion tool, QC tool, DM Studio, Bene admin tool, TCH (Transaction Clearing House), CT web(Claim tracker) and more.
• Well experienced in testing different Payments and payment types like paper check, systematic payment, EFT (Electronic fund transfer) and DTCC settlement.
• Experienced in testing ACH (Automated clearing house), work with GIACT and PEP+. GIACT verification Services for real time verification and authorization of bank account and customer data, and Pep+ for different payment and financial transaction. And testing different bank code calls
• Experienced in software testing with both Manual and Automation testing strategy in various test stages, software Development Life Cycle (SDLC), Testing and Defect life cycle, defect or Bug tracking and Reporting,
• Use both waterfall and AGILE way of software development approaches and actively participated in all phases of testing life cycle. Followed AGILE methodology, created self - organizing team, plan, and attend different Agile and SCRUM meetings, report update for test statues and opened defects.
• Good experience with Test Director and Quality Center ALM, PVCS Version Manager, SBM, JiRA, Quality Center/ALM, JIRA and Team Track.
• Preparation and execution of detailed test strategy, test plan, and test Cases and generated detailed test reports on status, testing schedule, defects logging, monitoring progress, identifying, and implementing solutions.
• Experienced in Planning, designing data driven Automation testing frameworks and executing functional and regression testing Scenarios using Selenium Web Driver.
• Ample knowledge in Functional, GUI, Regression, Parallel, Negative, Load, Stress, System and User Acceptance Testing.
• Experience in using SAP or ERP (Enterprise Resource Planning‎) and Splunk application for analysis of log file and report, and MS SQL and Oracle database.
• Active role in Business requirements document development, functional document review, testing and reporting, and key resource for UAT phase and production roll-out.
• Knowledge of various testing and programming languages Java, Selenium, Java script, PL/ SQL, T-SQL etc.
• Ability to work in a fast paced, short timeline, team based environment.
• Mentored and trained team members in use testing tools and principles, leading the offshore and onshore QA Team.
• Excellent communication, interpersonal, higher technical and analytical skills with self-motivated team player.

Environment: HP ALM/ Quality Center JiRA, Agile Scrum, MS SQL, Oracle, SDLC/SBM, ServiceNow, Selenium, SAP, Splunk, Java, Mainframes, Note Source, Companion tool, QC tool, DM Studio, Bene admin tool, TCH, Claim tracker.

Quality Assurance Analyst

Confidential, Atlanta, GA

Responsibilities:

• Experience with software testing that includes WebSphere, Mainframe, IBM MQ, Web Services, API, open system, Data Warehouse, MS SQL and Oracle database backend systems, window, and UNIX client/server environment.
• Conducted gap Analysis with interacting cross-functional teams on quality processes and technology and identify potential pitfalls, risks, and issues.
• Well experienced in testing different Payments and payment types like paper check, systematic payment, EFT (Electronic fund transfer) and DTCC settlement.
• Experienced in testing ACH (Automated clearing house), work with GIACT and PEP+. GIACT verification Services for real time verification and authorization of bank account and customer data, and Pep+ for different payment and financial transaction. And testing different bank code calls
• Extensively worked with different platform, browser, and Client/Server applications, and played a key resource as Quality Analyst, Systems Analyst & Data Analyst during the entire project in SDLC
• Responsible for testing on payment processing and loan origination system, Mainframes system, Webservices, ServiceNow, call service, information management application, and experience in testing with IOS, Android, mobile, smart phones, and tablets applications.
• Worked with JIRA for defect tracking in AGILE way of application development life cycle and followed AGILE methodology and created self-organizing team.
• Work on CRM Interactive Voice Response (IVR) application, IVR outbound and Inbound calls testing. Extensively worked on Genesys Telecommunications framework in IVR.
• Created scripts selenium with java, CYARA, and QTP automating and executed functional and regression test suites.
• Strong skills in back-end testing using T-SQL and PL SQL queries to ensure data integrity and business rules.
• Capacity planning and documentation of all steps of SDLC, test strategies, test plan and cases, defect tracking and database resources.
• Experienced in application development from initial requirements gathering, systems design specification and documentation, installation and configuration of Servers, database design and administration.
• Developed test plan, strategy, test cases, process flow diagrams, Activity and Context Diagrams and maintained a traceability matrix for all requirements, and involved in planning of deployment and post-deployment strategies
• Prepared user training plans and provided end user training

Environment: CYARA, IVRMS Office, MS Visio, Agile Scrum, UML, Data warehouse, MS SQL, Oracle/DB2, SDLC, ServiceNow, Selenium, SAAS, JIRA

Quality Analyst and DBA

Confidential, HOUSTON, TX

Responsibilities:

• Responsible for database administrative support for MSSQL servers and databases on different environments
• Install and configure Server, upgrade, and migrate Microsoft SQL Server in clustered and non-clustered production environment.
• Experienced in planning and set up recovery strategies, backups and restore, disaster recovery mechanism and participate in disaster recovery framework for various environments.
• Experience in monitoring and troubleshooting database issues like Memory, CPU, I/O, Disk utilization, slow-running queries, blocking, deadlock and fragmentation.
• Hand on performance tuning and optimization of databases with SQL Profiler, Query Analyzer and Optimization, database Engine Tuning Advisor, Performance monitoring, Client/Server Connectivity and Database Consistency Checks.
• Implement database upgrade, refresh, and migrate tested changes to QA, Stage, and production environment. Use ETL (Extracting, Transforming and Loading of data) and BCP from Excel, Flat file, and different databases to Microsoft SQL Server, and test data store and transfer from different data warehouse.
• Assigned permissions to users and roles, administered secure authenticated logins, create and grant permission for users on various objects and supported columns level permission.
• Extensively performed Business and functional requirements verification, manual and automation testing, integration, Regression, user acceptance testing (UAT) and Risk Based testing.
• Involved in developing test strategy, test plans and cases to include prerequisites, detailed directions, and descriptions of the anticipated outcome and detailed designs in line with BRD and BRD walkthroughs.
• Testing Salesforce SAP or ERP (Enterprise Resource Planning‎) and Team Foundation Server (TFS) which provides source code management, reporting, requirements, and project management.
• Weekly Status meeting with Development and Management teams to discuss defect and test statues report.
• Utilize knowledge of Selenium with Java programming to create automation test scripts.
• Responsible for design automation test case and execution of data driven testing framework with Selenium.
• Involved in setting up standards framework and defining for keyword or data drive framework.

Environment: HP ALM/ Quality Center, SAP, SBM, Jira, HTML/XML, Java, Web Services, MS SQL, Oracle

Quality Analyst

Confidential

Responsibilities:

• Performed white box, black box, Smoke testing, regression, functional, integration, performance, and user acceptance testing (UAT) on the web-based application. and end-to end for testing different functionality and database mapping issues.
• Involved in creation of conditions and scenarios for the Use Cases and involve in converting Use Cases to Process Flow Diagrams.
• Responsible for testing remote deposit capture (RDC) for banking application and Lead Desktop Deposit (DTD) for deposits scenarios.
• Creation of test cases in Test Director and Coordinated testing resources and end-user testing activities including publishing report for testing statues, schedule, opened defect statues and defects logging.
• Responsible for testing DB2, mainframes and other application., and test the data stored in the oracle, DB2 and MS SQL database with the help of SQL queries.
• Share experience with the team to discuss on test statues, opened and resolved defects and business document review
• Mentored and trained other team members in use of tools and testing principles, and managed and testing resources.

Environment: Quality Center ALM, Jira, SOA, HTML, XML, JavaScript, Web Services, RDC, DTD, MS SQL, Oracle/DB2