SUMMARY

• Experience in IT as Quality Analyst, working on Client - Server, Web UI, API testing, and Database applications/ Technologies.
• Worked on Software Development Lifecycle (SDLC) methodologies including Agile, Waterfall and V-Model.
• Routinely involved in End to End testing, Web application automation testing, Backend testing, ETL testing.
• Experience in analyzing system requirements, Design and other documents to gain overall understanding of the applications to determine the appropriate level of testing required. As well as creating Test plans/Strategy and test cases based on requirements and design.
• Experience in troubleshooting environment issues with DBA, Enterprise Middleware teams.
• Experience in Agile methodology with daily scrum meetings and mitigation plans to resolve critical and high defects working closely with developers and Business and design teams.
• Have written PL/SQL Programs for Data migration, ETL testing.
• Experience working with Automation testing tools (CA LISA, Selenium web driver), ETL testing, backend testing and creating automation testing environment.
• Experience in editing, extracting and uploading burn down charts, work stream updates for different releases.
• Have experience on Web Services Testing using SOAP UI tool. Worked on automating some web services using CA LISA tool. Experience working on Service Virtualization.

TECHNICAL SKILLS

Tools: ALM, SharePoint, SSIS, SQL developer, TOAD, Teradata SQL assistance, Win-SCP, IBM Web Sphere, SOAP UI, CA LISA, TIBCO, PuTTY, RED HAT FUSE, Denodo 6.0, ELK (Elastic Search, Kibana), Selenium (IDE, WebDriver), Postman, Cucumber

Languages: VBScript, Java, SQL

Operating Systems: WINDOWS, UNIX, Mainframe

Databases: Oracle 10 g/11g/12c, Microsoft SQL Server, MS Access, DB2

Application Server: Web Sphere, Web Logic, Apache, IIS, CICS, SPUFI

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. Middleware Analyst

Responsibilities:

• Validated derived views with implemented logic in Denodo. Also, worked on interface view validation in VDP
• CWOW is agile SDLC project with 2 weeks’ Sprints. Participated in daily scrum calls with Project Manager, Dev team and business.
• Participated in planning meetings that occur after finishing every sprint. Team will go through what did we did good and what are the items we need to improve. Also, we added action items for next sprint
• Worked on Base views, derived views and interface views in Denodo
• Worked on REST services in Denodo by setting up properties using VDP
• Validated data from Denodo moved to Kafka topics and then to Elastic search
• Experience working on CI and CD using Jenkins with GIT repository
• Worked with Splunk indexes to verify logs as part of FUSE ESB testing
• Worked on FUSE ESB validating different inbound/outbound messages for different interfaces. Validated Camel SOA message logs for troubleshooting error messages.
• Worked on CWOW web application testing with selenium web driver.
• Worked on Denodo views testing using BDD framework.
• Worked on interfaces in different containers. Also, worked on different MQ’s for validation of data
• Considered important features like complex architecture and business logic, complexity of data, inconsistent and constantly expanding data in a DW, alterations in source databases while creating tests
• Worked on stored procedure java code for Denodo scheduler jobs for both full load and incremental data loads

Environment: Denodo 6.0, REST services, Java, SQL, Oracle, Micro services, Selenium web driver, RED HAT FUSE, AMQ, ELK, Splunk, Cucumber, Agile SDLC, SOAP UI, Postman, Swagger, Jira

Confidential, Wilmington, DE

QA Analyst

Responsibilities:

• Worked on CI testing using Jenkins on every build in SVN
• Worked on selenium integration with Jenkins to automate every build for the application under test
• Worked on LISA tool to automate different API’s in customer maintenance, Account services, Customer services
• Worked on API testing using Cucumber framework
• Worked on testing front end web applications in Cards and Retail team using Selenium
• Created new stories as part of 3 week Agile sprints. Worked on multiple stories are part of each sprint.
• Participated in daily scrum calls with business and Dev teams for daily updates
• Performed backend validation of DB by writing PL/SQL queries
• Created test steps for validating web service response using different filters and assertions.
• Used SSH command steps to search (used UNIX commands to search logs in server) and validate response logs.
• Worked on LISA to test services developed in Fusion framework. Created virtual services for AML, KYC profile API’s
• Worked on Originations and servicing API testing.
• Worked on AML, CDD, ADD type customer services API’s

Environment: SOAP UI, CA LISA, SQL, Java spring framework, Selenium, SVN, Agile SDLC, Jira, Cucumber

Confidential, Scottsdale, AZ

Denodo Consultant

Responsibilities:

• Worked on SOAP and WSDL service request and response files.
• Worked on creating virtual services using WSDL files, capturing request and response files and by recording live transactions between client application and the service.
• Worked with Denodo on creating derived views and did web services validation.
• Worked on integration testing Denodo with AMQ for different enrollment, membership changes messages
• Worked on Denodo scheduler jobs by configuring them using VDP tool.
• Worked on setting up multiple users with security settings in VDP tool. Also, worked on Denodo server setup for Denodo 5.5 and 6.0 versions
• Worked on 1 month sprints in Agile SDLC. Created different stories for functional testing, smoke testing and to automate test scripts
• Validation of ETL extract files from 13 source systems. Ran PL/SQL procedures manually to process scheduled jobs for CLOB data
• Worked on PL/SQL packages for different applications. Also, worked on testing different PL/SQL data types
• Analyzed application data using PL/SQL to identify ETL processes
• Tested different web services for Enrollment, Disenrollment and CAG changes using different end points in SOAP UI. Different services are used to maintain and navigate to MQ’s.
• Have written SQL queries and Joins to extract data from different tables using MS SQL server studio.
• Worked on Facets testing for different workflows in Medicare. Facets workflows like member changes, membership changes, Xref tables, and worked on Grp Class Plan changes.
• Tested ETL extracts by validating different enrollment/disenrollment fields. Tested reports underlying data layer. Followed Agile testing methodology where we have frequent code changes along with simultaneous testing.
• Worked on TFS for reporting project for managing requirements.

Environment: HPQC/ALM, SSMS, Windows server’08, UNIX, Oracle, SQL, SSRS, SSIS, ASP.NET, CA LISA, Denodo, Agile SDLC

Confidential, Lake Oswego, OR

Data Analyst

Responsibilities:

• Provided data for Confidential ’s like ACCUMS, COB, Finance, Automation, Paper Intake, CoFax paper claims, Training and Claims.
• Worked on testing web services for different claims using SOAP UI tool. Developers will provide different web services end points which are described in WSDL.
• Verified and tested Membership details and demographic details in different screens (MSMC, MSME, MSFE, and MSMD) online Main frame CICS system. Used 3 different CICS system
• Worked on loading high volume of data into different EPIC testing environments.
• Used WinSCP tool to load high volume of claim files into UNIX server. This will be used by tester to process EDI claims (837d, 837i, 834) in EPIC.
• Used Teradata tool to pull member demographic details and member coverage details data from EPIC database system Clarity.
• Experience with defining Metadata, reference data and data metrics. Worked on key data Metrics and building dash boards for Monthly reports on 3 different regions.
• Defining Metadata includes Membership details, Providers, Vendors. Metadata includes data of different work streams (Medicaid, ACCUMS, Finance, SRA, and POA).
• Worked on EPIC tool Unit testing for new code deployments in different EPIC instances using C#. New EPIC functionality is delivered as part of 2014 release.
• Worked on DB2 tables to extract membership details to load into EPIC testing instances.
• Worked on EPIC tool to assign Employer Groups to members depending on different Confidential ’s.

Environment: HPQC, Teradata SQL Assistance, Windows server’08, UNIX, Oracle, JAVA, IBM Web Sphere, WIN SCP, Mainframe, Citrix, Cofax

Confidential, Lake Oswego, OR

Sr. QA Analyst / Lead

Responsibilities:

• Responsible for Work Flow Integration testing of different TRC’s from CMS system to MBE system.
• Validation of XML files pulling using XML marker/SPY tool.
• Worked on creating virtual services using WSDL files, capturing request and response files and by recording live transactions between client application and the service.
• Used LISA workstation to monitor tests. Also, worked on creating test cases, test steps for web services testing.
• Performed web services testing using SOAP UI, by validated XML messages sent between client application and server, applied assertions to verify dynamic changes.
• Worked on multiple services with one LISA test case, which results in validating multiple web sessions.
• Used CA LISA as virtual web services when some services are down/no response.
• Worked on modifying config files for different services so that messages can flow between MQ’s.
• Have written SQL and Joins to extract data from different tables using TOAD.
• Worked on troubleshooting batch files from different interfaces. Ran batch jobs manually to troubleshoot automated batch job errors.
• Worked on troubleshooting virtual services by correcting port numbers issues and redeploying missing/wrong virtual service model file to be in sync with correct Virtual service image file.
• Also, verified errors in Inspection View and opening logs in long info
• Worked on SOAP and WSDL service request and response files.
• Worked on QTP Automation script to do regression testing. Written functions and enrollment scripts for PEP, a java based application.
• Involved in Templates for different test plans and check lists for SOA Testing.
• Did shakedown test and verified connections with different UNIX boxes with MQ’s. As part of this, worked on updating config version files for different WAS and WCS services.
• Responsible in writing VB Scripts for PEP (Pre-Enrollment Processing) Java based application.
• Worked with DBA, EIS teams in troubleshooting environments issues when doing shakedown testing for 8 different environments.

Environment: HPQC, XML, TOAD, Windows server’03, SOAP UI, UNIX, Oracle, JAVA, Market Prominence, Web Sphere, WIN SCP, Mainframe, QTP 11.0, CA LISA, TIBCO, Agile

Confidential, Sunnyvale, CA

QA Tester

Responsibilities:

• Reviewed functional and BRD documents for interface design and prepared test scripts.
• Written test scripts to ensure flow of existing and new items in Oracle EBS instances.
• Tested connectivity between legacy 11.5.9 instance and R12 target instance.
• Used HP Quality Center to track open defects and to log new defects.
• Performed functionality testing and SOAP UI scripts for web services testing.
• Worked on different Oracle forms (Items, ECO’s, and Pricing) to create test data and for SIT testing.
• Worked on Unit testing by defining different name spaces in C# for Web based application.
• Worked on E2E testing with PA team and prepared test scripts with new Items.
• Used SQL developer tool for ETL process. Mostly used to extract data from legacy system to migrate to new Oracle system.
• Worked on specific Metadata Repository Integration between tools.
• Worked on ETL process for Oracle forms.
• Tested conversion data from different instances to production in Oracle.

Environment: Java, Seibel, PeopleSoft, HP Quality Center, SFDC, Oracle 11i, SOAP UI

Confidential, Laurel, NJ

QA Engineer

Responsibilities:

• Interacting with business users, application developers and analyze the impact to the concerned applications and develop the test plan based on the above criteria.
• As a QA team member, responsible for planning & managing the IST test phase of a release. And assigning projects in the release and coordinate with developers & testers to create test cases, test data and setup.
• Coordinated between Wireless Air card system test and E2E IST to insure no duplication of effort in testing occurs and to have E2E IST include test case scenarios in their testing that cannot be covered in system test.
• Validating XML’s using SOAP UI, XML Marker tools.
• While Integrating Wireless Air card application to downstream and external applications linking through web services (in Service Oriented Architecture) conducted web services testing.
• Used comprehensive PL/SQL programs and queries as part of back end testing to extract data from various tables to compare the actual results from the application.
• Followed Agile software development process, Participate in daily scrum, Sprint panning, Sprint Review, Sprint Retrospective meetings.
• Verifying the front end and Backend Database of the Wireless Air card to check the required fields are updating in the DB.
• Backend and data bases impacts being tested by Querying Databases.
• Representing the E2E/ IST/ UAT/ Co-op Daily Release Calls from the Wireless Air card application.

Environment: ASP.NET, XML, SQL server 2008, Web Services, QTP, IBM Rational Clear Quest, SOAPUI, Unix

Confidential, Ashburn - VA

Test Analyst

Responsibilities:

• Responsible for developing and maintaining Application development test plan, scripts, and manual test cases for the application and documenting bugs.
• Experience with software change management and bug tracking system using Quality Center.
• Responsible for both manual and automation testing of .NET application.
• Worked in identifying Regression Test Cases which can be automated using systematic approach and doing Cost Benefit Analysis.
• Conducted defect triage meetings with development team for discussing bug fix status.
• Created test cases for ETL mappings and design documents
• Developed ETL test scripts based on technical specifications documents and Source to target mappings
• Used SOAP UI to test different web services.
• Used automation scripts for regression testing.
• Worked on Stress and load testing scenarios for high volume data.
• Wrote and executed SQL queries to perform back-end testing for data integrity and data verification.
• Defect Tracking using Quality Center and Administrating Quality Center for QA and development team.
• Post production testing based on role complexity and preparation of status reports after complete SIT.

Environment: Visual Studio.Net 2005, XML, SQL Server 2008, UNIX Windows 2000, JavaScript, Informatica