Quality Assurance Marketing Cloud

PROFESSIONAL SUMMARY

Around **+ years of Quality Assurance experience in web and client/server applications, and 9+ Years of testing experience in Salesforce Sales, Service and Marketing cloud products.

Experience in all aspects of the SDLC, with specific focus on design, develop and testing on different software applications and different methodologies like Waterfall, Agile and Scrum.

Extensive experience in design, develop, Manual and Automated Testing of GUI and functional aspects of the Client-Server CRM systems and Web based Applications on multiple levels of SDLC.

Good understanding of requirements and Analyze use case diagrams and Business requirement documents in preparing the requirements, traceability matrix and in designing specifications and reviewing.

Responsible for documenting and developing test Plans, test cases and test scripts.

Performed Functional, GUI, Regression, End to End, User-acceptance, Back-End, Stress, Migration, System testing, Integration testing and UAT testing.

Organized the test scripts in Q-Test, JIRA, GUS, Mercury Quality Center for traceability and monitored test results, tracked defects in JIRA, Quality Center

Experienced in designing the scripts and test the REST and WEB services using the SOA/Postman tool/SOAPUI/REST Client

Have good knowledge in testing the EIM tables where data use to get from different source systems to Siebel system using ETL/Informatica tools.

Responsible for testing the EAI messages where the Siebel messages used to trigger the data to external databases.

Worked on X12N834 Enrollment/PCP information files including Benefits, Enrollments, adds, changes and terminations from external vendor to clients.

Performed GAP Analysis for HIPAA 4010 and 5010 EDI transactions to verify mapping to X12 format

Have good experience in Physical and logical data models of the relational databases in order to test the databases where data is correctly stored in the required fields.

Strong experience in Back-End testing using SQL queries

Create, Manage and Build email campaigns, Templates, Automations and Journeys with in Salesforce Marketing Cloud

Support on going salesforce marketing cloud operations which includes content development, configuration, QA testing.

Experienced in Team Foundation Server TFS for code check-ins, Shelvesets for code reviews, code mapping into local machines and Builds.

Extensively tested ETL Batch Interfaces testing between different application

Excellent communication, leadership, and interpersonal skills, able to work independently and team player

TECHNICAL EXPERIENCE

Testing Tools

Mercury Quality Center, Mercury Quick Test Pro, Rational Clear, JIRA, Data studio 2.0, SOA, GUS, Q-Test, Selenium, Postman, Rest client, SoapUI

Business Tools

INFORMATICA, TIBCO, Team Foundation Server (TFS), MDM 360, IDQ, IICS

Languages

C, C#, VB Script, Java 2.0, J2EE, and XML, HTML, JavaScript, Amp Script, Mainframe systems, USERIMS, TSO, EVT

CRM Skills

Siebel Sales, Siebel Marketing, Siebel Call Center, Salesforce service cloud, sales cloud, marketing cloud.

Database Skills

MS SQL server, Oracle 10g/9i, Sybase, MS Access, DB2, oracle SQL developer.

Operating System:

Windows, UNIX, MAC OS

Services

REST API, WEB services

EXPERIENCE

Employer: Strategic Staffing Solutions (Ameren) Jun 2023 to present

Senior Quality Assurance

Responsibilities:

Analyze the Business Requirements, Functional Specification and design test scripts, test cases and performed gap analysis for Ameren power and gas utilities applications for service and billing systems.

Worked closely with developers, business analysts, and stakeholders to understand business and technical requirements to derive the data requirements.

Responsible for testing Salesforce service cloud functionality of case management flows related to creating cases, customers, workflows, manage profile.

Responsible for doing integration testing between salesforce and Legacy system CSS (Customer Service System) on creating cases, Interaction, order creation and tasks

Responsible for integration testing between Web application and CRM application.

Used to validate data flow in Legacy system (CSS) application integrated with salesforce when any changes are made with respect to billing, workorder, communication, Interaction, customer details

Used to do the IVR phone testing integrated with salesforce application with different case types and subtypes.

used to test all production support tickets when needed.

Responsible for creating and running automation tests created in Provar.

responsible for writing test cases in Zypher integrated with Jira and create test cycles for every release.

Responsible for doing system testing, Integration testing, End to End testing, regression testing and re-testing the fixed bugs.

Coordinates testing activities for basic / less complex projects which may require interaction with business clients and / or offshore resources to ensure requirements are achieved.

Worked in Agile and Scrum methodologies environment.

CO-ordinating with business users and help in testing the UAT test cases and preparing test data

Lead the QA testing for the assigned project and effectively interact with all levels of management.

Responsible for weekly status attend the meetings showing progress and analyze feature risk analysis and report to project team members.

Environment: Salesforce Service Cloud, C#.Net, Salesforce, Jira, CSS, IVR, Provar, Qtest, SQL Server, Visio, ServiceNow,

Employer: KAR Auction Services- Carmel-IN May 2019 to May 2023

Senior Quality Engineer

Responsibilities:

Analyze the Business Requirements, Functional Specification and design test scripts, test cases and performed gap analysis.

Worked closely with cross-functional team members (Developers, other testers and end-users) to understand business and technical requirements to derive the data requirements.

Responsible for testing of all modules in Salesforce objects, campaigns, touchpoints, purchases, cases, funnel automations, custom meta data.

Responsible for testing the Batch jobs, workflows, Custom objects, custom meta objects, external objects, validation rules, and page layouts

Responsible for testing the salesforce application Ipad and mobile in IOS and Android systems.

Responsible for creating automation test scripts for salesforce application using TESTIM software.

Responsible for validating email campaigns, journeys, and automation workflows in Salesforce Marketing Cloud - journey Builder, Automation Studio using data in Data extensions.

Responsible for executing test scripts, including setting up the test journey and verifying the test results for success

Experience in testing the email using the Email on Acid platform for Desktop, mobile and Ipad in different operating systems.

Co-ordinate between Onsite, Offshore teams and other project teams for smooth delivery to production.

Experience in testing the Salesforce integrated with MDM application, Informatica, IDQ, MDM (Master Data Management), Informatica tools, Analyst, MDM 360, Oracle SQL Developer

Responsible for testing the ETL Informatica mappings, workflows, IDQ and 360 application if the data is moved from end-to-end testing. And then imported into

Responsible for doing integration testing systems included,360 MDM UI, IBM-MQ, IICS to salesforce application.

Responsible for doing the REST API services testing in Postman, smart bear SoapUI

Identified the data scenarios and extensively used SQL queries for data verification as backend testing.

Responsible for doing system testing, Integration testing, End to End testing, regression testing and re-testing the fixed bugs.

Experience in using the salesforce Query studio

Responsible for writing SQL Queries for data Verification using SELECT, JOINS, UPDATE, INSERT

CO-ordinating with business users and help in testing the UAT test cases and preparing test data

Lead the QA testing and effectively interact with all levels of management.

Responsible for weekly status attend the meetings showing progress and analyze feature risk analysis and report to project team members.

Environment: Quality Center 10.0, Oracle SQL Developer, IICS, Informatica ETL, IBM-MQ queues, Snowflake, ServiceNow, Postman, salesforce Marketing Cloud, Salesforce, Smart bear SoapUI, MDM 360, IDQ, DevOps.

Employer: Salesforce- Indianapolis-IN Sep 2013 to April 2019

Senior QA

Project synopsis:

Salesforce Marketing cloud is an email marketing and interactive marketing provider. It is a permission-based email Marketing, Mobile Marketing and Social media marketing. Where Interactive Marketing Hub is used for creating a Interactions to send the Email, SMS to the subscribers automatically when the subscribers fall into the Journey.

The Projects and Expertise in applications within the marketing cloud Applications.

Journey Builder Core

Journey Builder Integration with salesforce

Journey Builder Integration with Email

Journey Builder Integration with audience Builder

Journey Builder Integration with Mobile, SMS, Cloud pages

Contacts, Automation studio

Responsibilities:

Analyzed the business requirements and convert them to detail technical test scenarios .

Responsible for creating Test Plan and write Test Cases for different types of scenarios based on business logic.

Responsible for leading Team of Testers, be hands-on and help the team in Testing.

Review Test Cases with the Developers, Product managers to verify if there are any gaps or missing requirements that are not covered.

Prepared detailed Test Scenarios and cases for functional, Integration,GUI and REST Services API and UAT

Performed REST Services routes testing using Postman/SOA tool that are used to get the data from the data bases.

Actively Involved in sprint ceremonies to groom the stories, Understand the Requirements and identify what went wrong and what went right for each sprint In Review and Retrospection meeting

Collaborated with all stakeholders in the quality assurance and development process.

Be responsible for Business requirements functional design, process design ( including scenario design, customer Journeys )

Responsible for doing UAT testing once the functional testing and feature freeze is completed in UAT environment.

Responsible for Investigating the production issues and troubleshoot by looking at the C# code, databases accordingly.

Worked as a hybrid engineer where need to fix the bugs and stories and troubleshoot the issue in C# code environment .

Experienced in performing Automated testing using Test Manager/ruby for the regression suite.

Create, Manage and Build email campaigns, Templates, Automations and Journeys with in Salesforce Marketing Cloud

Demo the product to stakeholders at end of the scrum for the features completed.

Responsible for Preparing, reviewing and maintaining the Regression Suit .

Tested and debugged code sections and adapted to meet the needs of clients.

Contributed in the Technical Discussion of the Team Like Code Reviews and Unit testing and Attend the daily project status meeting and the scrum meeting.

Involved in Backend testing using SQL Queries for Data Validation in database to validate the Journey success or failure or any issues to troubleshoot.

Have experience in testing the salesforce application integrated with marketing cloud application in journey Builder project.

Have Experience with Elastic Search and kafka to write data into the database tables. CO-ordinating with business users and help in testing the UAT test cases and peparing test data and help in testing END to END UAT test cases.

Used JIRA/GUS to log the Defects and tracking the defects and documented as part of testing.

Responsible for giving the weekly updated on the status of the testing and report the blockers that are stopping us to continue further testing.

Worked and communicated with the development team in order to fix the open issues.

Environment: C#.NET, JIRA, Quality Center, 9.0, GUS, Microsoft SQL Server Management Studio, SOA Tool, Postman, TFS, Collaborator, Selenium, Test Manager, salesforce, Elastic Search, Kafka, Javascript, Salesforce, Postman, SoapUI

Employer: Astir Services DBA-Sysnet Technology Solutions Oct 2010 to Sep 2013.

Client: Florida Blue (Blue cross Blue Shield of Florida) – Jacksonville-Florida

Role: Senior Quality Analyst

Responsibilities:

Analyze and understand the deliverables within SDLC using agile and scrum methodologies.

Responsible for analyzing and reviewing copies of the project specification, business requirements documents that comprise the CRM applications.

Responsible for design, developing the test scripts, test plans to verify data integrity, functionality and adherence to business requirements.

Coordinate/Assist with Business analyst with technical/process and scheduling test cases/scenario reviews, work between the staff, internal and external QA integration teams, and the client development and management teams and third party vendors.

Responsible for Implementation of critical business capabilities for client related group enrollment, maintenance application.

Responsible for doing system testing, Integration testing, End to End testing, regression testing and re-testing the fixed bugs.

Responsible for Doing UAT functional and business use cases testing in UAT environment

Develop and executing of Scripts, defect logging and Bug tracking through an interface with Mercury Quality Center, JIRA and used HP screen recorder for defects.

Coordinate deployments on a shared environment with other QA groups participating in the project.

Involved in the upgrades to versions changes and system enhancements.

Responsible for assisting the development team to create and maintain programs for daily service requests.

Perform Integration and End to End Testing between application and external application/data Sources

Identify/work with development on the creation of test data and test strategy needed for execution and work with development team to resolve defects and any environment issues.

Utilize the business communication skills to interact with vendors, programmers and managements.

Troubleshoot the issues with Data Integrity and business functionality and reporting the gaps to business.

Functional expertise in Healthcare Insurance sales, Enrollment and Billing, Email marketing services projects.

Understanding of RDBMS systems (Siebel) and SQL.

Responsible for validating Mainframe reports in the EVT and data sets in TSO.

Experience in CRM Siebel application used for sales systems integrated with mainframe system as legacy and web based application for vendor system.

Responsible for communicating with third party vendors for loading the flat files and maintenance, follow ups, review of the requirements.

Did data analysis for various version changes of EDI messages on different sub-systems.

Performed comparative analysis and gap analysis to identify variation in the process as per HIPAA X12 4010 and 5010 guidelines to incorporate updates as per 5010 guidelines and verify mapping to X12 format

Report test status to Manager and client management and used to report weekly status, attend the meetings showing progress and future testing efforts.

Environment: Siebel 8.0, Java, J2EE, JSP Server, Mercury Quality Center 10.0, DB2, Data studio 2.0, HP screen recorder, XML, HTML, MS Office 2010, EAS, Mainframe systems, USERIMS, TSO, EVT, C#, ASP.Net, SQL server, Windows XP professional, Oracle 10g/9i, Sybase, MS Access, DB2, SQA Server 2000/2005/2008, XML, HTML, REST, JIRA, SOA tool.

Employer: Alpine Systems INC Oct 2009 to Sep 2010

Client: Monster.com- Maynard-MA

Role: Senior Quality Analyst

Responsibilities:

Analyze the Business Requirements Document (BRD), Functional Specification as per SDLC and design test scripts, test plan and performed gap analysis.

Worked closely with cross-functional team members (Developers, other testers and end-users) to understand business and technical requirements to derive the data requirements.

Experience with CRM application (Siebel), Web application and Mainframes systems.

Responsible for documenting the use case SRS documentation of the business process.

Responsible for Communicating the offshore team and check the status.

Worked on designing the requirements and testing the different projects related to sales, order management and Products and pricing for different countries.

Identified the data scenarios and extensively used SQL queries for data verification as backend testing.

Responsible for doing system testing, Integration testing, End to End testing, regression testing and re-testing the fixed bugs.

Understanding the Object oriented programing concepts and Multi browser testing experience.

Responsible for writing SQL Queries for data Verification.

Worked on many SQL statements like SELECT, JOINS, UPDATE,INSERT

Used to run and develop the automated scripts for regression testing once the manual test cases are passed.

Responsible for assisting UAT testing and doing multi browser testing using IE, Firefox, Chrome.

Experienced in Data Validations for the Unicode data in Siebel Application by verifying weather the data is correctly shown in Siebel fields and database.

Responsible for weekly status attend the meetings showing progress and future Testing efforts.

Environment: Mercury Quality Center 10.0, DB2, Data studio 2.0, HP screen recorder, XML, HTML, UNIX, MS Office 2010, Mainframe systems, USERIMS, TSO, EVT, JCL, C#.NET 3.0, ASP.Net 3.0, Windows XP professional, Oracle 10g/9i, SQL Server, Sybase, MS Access, DB2, Siebel CRM 8.0, Java, J2EE, JSP Server.

Employer: Fortune Technologies INC. Dec 2007 to Sep 2009.

Client: Capital Group of companies- Los Angles -CA

Role: QA Assurance

Responsibilities:

Responsible for Analyze, design and develop client software applications.

Analyze and develop the Business Requirement Document (BRD), Functional Specification Documents and physical Data Model (PDM) as per SDLC.

Designed, developed and testing the CRM systems and web applications projects related to Sales application, transformation of data using EAI and Informatica tool to ODS databases.

Developed test cases, test plans for Interface testing (Data Integration, migration, functional) scripts in Quality Center 9.0 based on Design specifications and requirements.

Responsible for reviewing the ETL Mapping sheets contains information of source and destination tables including every column and their look-up reference tables.

Lead and mentoring the onsite and offshore team.

Worked with the OLAP and OLTP systems and SQL Queries for data Verification

Responsible for developing/testing the sales agent application used for selling the production using the software skills like Java, J2EE, JSB.

Extensively used SQL Queries on data bases for Data Verification using SELECT, JOINS, UPDATE, INSERT statements.

Responsible for testing the Interfaces from different legacy systems to ODS database.

Used to verify the XML messages sent by Siebel to verify weather the data sent by Siebel is correct or not.

Responsible for testing the transformations of the ETL Processes (Extract, Transform and Load) to load data in the Data warehouse and created test data for testing an do test documentation.

As Part of ETL testing responsible for doing the Source to target data is validated and Staging data is validated.

Responsible for running the Autosys jobs using the UNIX commands

Involved in developing the automated scripts and maintenance of the scripts.

Validate the data of the current business applications and log the defects/bugs in Quality center and retest as part of regression testing using multi browser.

Report weekly test status report to Manager regarding the progress of the project and escalate the issue to the related higher management.

Environment: Java, J2EE, JSP Server, Mercury Quality Center 10.0, DB2, MS Office 2010, XML, HTML, Siebel CRM, EAI, TIBCO, ESB, EJB, Informatica, TOAD, C#.NET 3.0, ASP.Net 3.0, Windows XP professional, Oracle 10g/9i, Sybase, MS Access, DB2.

Education:

Master in Computer science (Kakatiya University) Warangal, Telangana, India

Bachelors in computer Science ( Kakatiya University), Warangal, Telangana, India

Contact this candidate