SUMMARY

• 9 + years of rich experience in Software Quality Assurance Testing on different Databases, Client/Servers, Web Based and Data Warehousing applications on UNIX and Windows platforms in united states.
• Excellent Testing experience in diversified domains like Health Care, Banking, Financial and Insurance.
• Experience in all phases of Software Development Life Cycle (SDLC) includes Analysis, Design, Development, Testing and Implementation.
• Extensive experience in different Test Methodologies like Agile - SCRUM and Waterfall Methodologies.
• Strong experience in different types of testing that includes Integration, System, Functionality, Smoke, Regression and Performance Testing.
• Extensive experience in preparing Test Plan, Test Cases, Test Scenarios, Test Scripts, Test Reports, Test Summaries and Documentation for Manual and Automated Tests.
• Strong Experience in using various defect tracking tools for testing applications effectively, thoroughly with Test Director, Quality Center, ALM, Jira and ClearQuest at the fastest.
• Strong working noledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Extensive experience with web content management system SDL Tridion
• Extensive experience with tag management system Ensighten
• Excellent testing experience with GUIDEWIRE Studio 7.0
• Extensive testing experience with various SOAs (Service Oriented Architectures) spanning across various web services using SOAP and WSDL for various applications using SOAP UI.
• Hands on experience in testing SharePoint 2010 intranet portal
• Familiarity with testing SSRS Reports, SharePoint Solutions and testing web dashboards
• Worked extensively in testing of Workday integrations Using Core Connector, Workday Studio, EIB, and Document Transformation as part of a full life cycle implementation project.
• Possess sound noledge on Workday HCM, Benefits, Time and Absence, Compensation, Talent, Recruiting and Payroll processing.
• Extensive experience in working with ETL tools like Informatica, Data Stage for Data Extraction, transformation and load.
• Excellent hands on experience diversified databases like Oracle, SQL Server, Teradata, Netezza, Sybase, MS Access and other databases.
• Experience in writing complex SQL, T-SQL and PL/SQL statements.
• Detailed oriented and strong Interpersonal skills.

TECHNICAL SKILLS

Testing Tools: Quality Center 8.2/9.2, ALM 11/12.2, Jira 4.0/6.0, Test Director 7.5/8.0, Load Runner 9.51 and ClearQuest 7.0, Team Foundation Server (TFS) and Microsoft Test Manager (MTM)

Automation Tools: Ruby Cucumber, Selenium Web Driver and QTP

RDBMS: Oracle, DB2, Netezza, Teradata and SQL Server

Management Systems: Ensighten and SDL Tridion 2011/2013

ETL/BI Tools: Informatica Power Center 6x/7x/8x/9x, Datastage 7x, Business Objects and Cognos

Development Tools/Tools/Softwares: DbVisualizer 4.3, WinSQL, Toad, Erwin, WS-FTP Pro, MS Office 2003/2007/2010/2013 and Office 365, Hummingbird V8.0, Putty, Sharepoint server 2010, Workday and Mulesoft

Browsers/Devices: IE 8/9/10/11, Chrome, Firefox, Safari, iPhone 6, iPad Air, iPad Mini and Samsung S4

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Senior QA Analyst

Responsibilities:

• Worked with HR IT team to understand the platform tools and technology, understand data sources and WORKDAY application portfolio. me has done document analysis and reviewed requirements from Client teams.
• Created Test cases in Excel and uploading those test cases into JIRA for Integration testing.
• Worked with WORKDAY Business Analysts and Integration teams to review test cases for testing.
• Worked on various modules such as Core HR, Benefits, Time and Absence, Payroll, Recruiting, Talent and Compensation.
• Used Atlassian JIRA for User Story management, wrote Sub-tasks for QA work items, wrote test cases for test scenarios based on Acceptance Criteria as defined in JIRA.
• Performed functional testing, Acceptance testing and UI testing of Workday application after web-services confirmation, performed data validation and data migration testing of users from legacy system.
• Actively participated in Agile standup meetings every day and attending Sprint planning & Retro meetings with team.
• Validating XML files for the integrations generated by Mulesoft (Inbound integrations) and Workday (Outbound Integrations).
• Expert in doing settlements for Payments loaded into Workday
• Creating test data for the integrations and launching the integrations manually from workday
• Worked with different file formats (HIPPA, .dat, .xml, .txt, tab delimited and JSON) for different Integrations.
• Used POSTMAN tool for Web service testing to run the Jobs.
• Involving with Developers to place the files & change the files in SFTP folder for QA
• Logged Defects in JIRA whenever any testing scenarios are not met according to the expected results, participated in defect triage meetings with HR IT team, QA management and updated on defect status daily.
• Using MYSQL for Mulesoft Database, SQL Server for Guidewire Claim center Database
• Coordinating with QA team to collect the status and share with the team every day
• Working with Guidewire Claim center team for claim status sending back to PNC bank
• Working with different teams (Guidewire, EDW, etc.…) for different integrations.
• Involved in Workday upgrade version 30 validation.

Environment: JIRA, Confluence, Workday 29/30, SQL Server 2012, Windows, MySQL, Mulesoft 4.0, Postman and Guidewire.

Confidential, Columbus, OH

Sr QA Analyst

Responsibilities:

• Reviewing the story cards and related requirement documents like Story Cards, BRD’s, UE Specifications, mockups and Prototypes
• Testingvarious functionality usingGuidewire Claims center JSON Edge APIto create, save and update claim information across different LOBs like Auto and Property
• Defined System Integration Test / End to End test strategy for Self-services project considering various integrations, application functionality, JSON Edge API web services calls interfaced with theCore Guidewire Claim center functionality
• Test planning theGuidewire JSON Edge JSON API orchestration callsrelated to claim creation, claim updation, claim submission, getClaimDetail, getClaimSummaries, determineEligibleServices etc.
• Testingthe end to end test flowsthe Guidewire Claim center JSON Edge APIis interfaced with Direct Growth Service internet application to receive and save claims in Guidewire Claims Center and further process claim operations and financial transactions and validation of claim’s data across different integrations - Both Internal and external to client.
• Executing of Automation Scripts in Ruby Cucumber and Selenium Web driver
• Testing different analytics tags like Google Analytics, Maxymiser, Visual IQ/TAPAD, Floodlight and Sunday Sky tags displayed correctly on application pages
• Validating the META TAGS (custom dimensions, custom metrics and events) are picked up and passed to GOOGLE ANALYTICS for web applications
• Testing onmousedown parameters using Fiddler/Developer Tools
• Testing WebTrends Scenario Analytics Parameters using Browser developer tools
• Creating page tests to perform regression testing using Ensighten Inform
• Used Google Analytics Reporting to analyze the reports and site activity
• Preparing, executing test cased and log defects using Quality center/ALM
• Created web content in test environments using SDL Tridion tool based on the requirements in the story cards
• Verified CSS and functionality of the web pages and make sure it matches with UE specs and Prototypes
• Setup/Configure devices and update the web browsers to latest versions upon arrival for testing
• Testing different applications in iOS, Android devices and multiple web browsers according to the company standards
• Tested nationwide responsive applications and make sure they met ADA compliant.
• Imparted training to new recruited in the team on SDL Tridion tool (Content Management system)
• Installed, configured SOAP UI to test web services using WSDL file
• Used SOAP UI to test Web Services running on WebLogic Server.
• Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup halp to new team members.
• Tested of Web Services using web services client generated using SOAP UI to track request and response SOAP Messages
• Data is tested efficiently by writing complex SQL queries against the Source and Target databases by using Web services retrieves and dispositions
• Conducted testing at all stages such as unit, functional, regression, performance, smoke, Regression as well coordinated UAT (user acceptance testing) and pushes to Production.
• Supported Implementation Validation for bi-weekly releases.

Environment: Ensighten, Fiddler, SDL Tridion 2011/2013, Quality Center 9.2/, ALM 11/12.2, MS Office 2010/2013, SOAP UI 4.0, XML, XSD, WSDL, Teradata, Oracle 10g/11g, Unix, Windows 7/Windows server 2012, JavaScript, HTML, CSS, C#.NET, Java and WebLogic Application Server 11g, GUIDEWIRE Studio 7.0, Jason Edge API, Cucumber 1.3.19, Jruby 1.7.22-p551 and RubyMine 2016.3.1

Confidential, Columbus, OH

QA Analyst

Responsibilities:

• Review System Requirements documents and Design Documents and written test cases
• Test and validate the functional Test Cases based on mapping document.
• Prepared test data based on Business requirements (positive and negative).
• Prepared test Data for the Initial, Incremental (Daily Inserts and Updates) and historical Load testing and validate.
• Prepared the 1% sample data (Test Data) based on production data for the Initial and Incremental load test.
• Data is tested efficiently at each level of ETL process by writing complex SQL queries against the Source and Target.
• Test the data based on the Dimensional Model Diagram.
• Validate the data from OLTP (Multiple source systems) to OLAP (Data warehouse/Data Marts).
• Write Macro’s in Excel.
• Test and validate the Business Objects and Cognos reports.
• Test and validate various data sources in ETL like CSV flat files and different RDBMS.
• Worked on UNIX shell scripts to test the data in the Source tables and the Data warehouse tables.
• Problem is debugged and analyzed efficiently and defects are raised through Quality Center.
• Work closely with Developers and other team members in resolving the issues and understanding the functionality for future reference.
• Test and validate the referential Integrity between the tables.
• Logged defects using Jira.
• Validate Informatica Mappings, update processes, Control Loads, and scheduling mechanism.
• Verified user management and access management scenarios like adding/deleting users, types of user permissions and pages that can be accessed for SharePoint project.
• Verified custom functionality for SharePoint application pages
• Perform GUI testing to test and validate look and feel of the SharePoint site

Environment: Informatica 8.X/9.X, Oracle 10g, Netezza 4.5.4, Jira 4.0, Windows XP, Sun Solaris 2.7, Business Objects, MS-FTP Pro, MS Excel, MS Word, SQL Navigator, Toad, WinSQL, SQL, PL/SQL, Quality Center 9.2 and SharePoint server 2010.

Confidential, Colegeville, PA

QA Analyst

Responsibilities:

• Reviewing Functional Requirement documents and Design Documents.
• Designing of Automated Scripts using QTP 9.1.
• Managed the completed testing process in Test Director.
• Verified CSS and functionality of the web pages and make sure it matches with UE specs and Prototypes
• Testing different applications in multiple web browsers according to the company standards
• Writing code snippets/ scripts for both UI based & non UI Based applications.
• Executed various types of tests Example: Web services, M-Queue Calls & Web Based Scenarios.
• Monitoring the performance of servers to identify performance bottlenecks.
• Execution & Monitoring Client & Server level metrics Reporting Performance metrics & signoff from Clients.

Environment: HTML, Java Script, Oracle 10g, SQL Server 2005, Windows XP/2003, Sun Solaris 2.7, Cognos, MS office, Toad, SQL, PL/SQL, Load Runner 9.51, Test Director 8 and QTP 9.1.