Susmitha Addanki

To be a Software Quality Assurance Specialist at an Enterprise Level in an organisation having challenging assignments, which would help me leverage my experience, knowledge and skills for the consistent development of both the organisation and myself. Having nearly a decade of experience in the IT industry in Salesforce(Sales & Marketing Cloud) Testing, GUI Testing, Application Testing, Database Testing, ETL Testing, DWH Testing, API Testing, Cross Browser Testing and exposure in all processes of the SDLC, which includes Application/ ETL Requirements, Analysis, Designing, Testing and Maintenance.

Senior QA Consultant - Deloitte USI Consulting Private Limited - Hyderabad, India

(2015-02 - 2023-05)

• Worked in different sectors of the IT industry which includes, E-Commerce, Insurance, Payments and Life Sciences domains.
• Worked on ETL QA projects to validate data from file to table, table to table and table to file validations using SQL queries.
• Performed ETL standard testing activities like Count Validation, Duplicate Validation, Data Quality Checks, Data Profiling and Data Transformations.
• Performed Initial and Incremental data loads testing to validate SCD2 type - CDC data captures.
• Have experience leading a team of 15 members and delivering the QA work products with highest quality.
• Preparing and defining the process for the Test plan, Test strategy and several phases of testing cycles.
• Defining the test case authoring, review and defects life cycle plan documents for the team members.
• Assigning various tasks to the team members and discussing the teams tasks closure.
• Reporting the daily status to the higher team and highlighting the risks and suggesting the mitigations.
• Defining and creating process and Test cycles in the Test/ Defect Management tools (Jira, ALM, Bugzilla, Mantis, TestRail, Version One).
• Strong understanding of quality practices in agile development environments, including TDD (Test-Driven Development)
• Primary focus includes preparation of Test Cases, Executing Test Cases and tracking the defects to closure.
• Worked in Waterfall/Agile Methodology with offshore models.
• Performed in Regression/Functional/System/Integration/UAT Testing/ UI Testing.
• Able to perform as a Good Team lead and a Team Player and display good communication skills.
• Experience on Salesforce.com. CRM Application mainly with Leads, Contacts, Accounts, Cases, Campaign, Opportunities, Orders and Service entities.
• Hands-on testing experience with Journey Builder, Email Studio, Automation Studio, Contact Builder, Content Builder, and Data Extensions.
• Executed the Campaigns and Journeys as part of journey builder in Marketing Cloud Email Studio.
• Maintaining cordial relationships between cross functional teams like development, configuration management, program management, product managers etc.
• Validating Emails and Functionality of emails including the UI and content of the Emails using email testing tools for various devices and browsers.
• Creating tasks, attending Product backlog, Sprint planning and Review & Retrospective Meetings as part of Agile.
• Validated DWH tables that follow SCD Type 2 Schema.
• Performed Source to Target table validation.
• Validated Intake and Extract files induced to and generated from the system.
• Experience in writing SQL queries to execute against database tables to validate data and report testing.
• Worked on WCS applications such as WCS IBM management centre, Commerce accelerator, WCS Org Admin Console.
• Worked on SAP ERP system on E-Commerce business function.
• Experience with Manual ETL and Data warehouse Testing and have a rich understanding of ETL testing techniques and DWH concepts.
• Performed REST API Testing using Postman.
• Self-motivated, enthusiastic, planned and controlled to meet challenges.

Salesforce Marketing QA Lead - Deloitte

(2022-10 - 2023-05)

Client: Takeda Pharmaceuticals US Industry: Life Sciences and E-commerce

• Salesforce Marketing QA Lead for a team of 5 members.
• Preparing and designing the test plan document.
• Understanding the journeys and discussing with the Dev and BA to gather, analyse the requirements for writing the clear test cases.
• scheduling the KT sessions for new team members for both Dev and QA
• Identifying the tools needed for the QA team according to the requirements of the client.
• Preparing a guideline document for test case creation, defect creation and review for the team members.
• Assigning the tasks to the team according to their abilities and experience and Working with the team to make sure the tasks are closed.
• Estimating the capacity and the
• Sending weekly and daily QA status reports to the entire team including onshore and leadership.
• Also authoring, reviewing test cases and along with raising the defects for Sprint, SIT and Regression.
• Scheduling and attending the Defect review/Defect Triage calls, status calls and leadership meetings.
• Participate in Go- No-Go decisions meetings, influencing or suggesting decisions based on evidence provided resulting from test activities.
• Creating a list of milestones and checkpoints and setting measurable criteria to check the quality on a timely basis.
• Coordinating with the Dev Team, BA and Onshore for the closure of the tasks
• Hands-on testing experience with Journey Builder, Email Studio, Automation Studio, Contact Builder, Content Builder, and Data Extensions. As part of Campaign & Journey Validation, checking for proper audience and segmentation.
• Working on Testing the Journeys, Emails, Preference Centre, SMS as part of Marketing Cloud.
• Validating the UI parameters such as CTA’s, Images, Links and the content via email testing tools and also validating the Navigation from the emails to the Web or cloud pages.
• Validating the UI( User Interface) of Emails within the Salesforce Marketing cloud as well
• Performed Cross Browser and Cross Platform testing (Mobile device testing) by validating the email rendering across major email clients, browsers and devices.
• Tools: Jira - Test and Defect Management; Postman - Validating the responses using xml for some scenarios; Confluence - Documentation, Report; Salesforce CRM Database (Customer 360 Data Cloud), Salesforce Data Cloud (Data warehouse); Salesforce Data Loader: To perform bulk import of test data; Developer Console (Query Editor): Used to write SQL queries

Salesforce QA Test Lead - Deloitte

(2022-04 - 2022-10)

Client: Medtronics US Industry: Life Sciences and Technology

• Lead a Team of 7 for Salesforce Marketing QA Team.
• Started the project from the discovery Phase, where involved in identifying the process and tools required for the QA team.
• Was part of the team in laying down the entire release plan for the project which includes the preparation of timeline for sprint, SIT, regression, UAT and smoke, pre production test.
• Creating a list of milestones and checkpoints and setting measurable criteria to check the quality on a timely basis.
• Authoring, reviewing the test cases and raising and closing the defects.
• Sending out weekly and daily status reports to the stakeholders, team and leaders.
• Maintaining a healthy relationship between the teams in the projects and within the QA team.
• Creating tasks, assigning to the team and making sure about the closure of tasks on the kanban board.
• Created and maintained the Project, Test cycle and defect cycle in Jira.
• Scheduling and attending all the sprint meetings which includes, Product backlog, sprint planning, Sprint retrospective meeting and tracking the tasks created on the Kanban board/sprint board.
• Hands-on testing experience with Journey Builder, Email Studio, Automation Studio, Contact Builder, Content Builder, and Data Extensions.
• Testing includes the Journeys Builders, Emails, SMS, Preference centre as part of Marketing cloud.
• Testing Emails( Content, Functionality, UI and Navigation of Hyperlinks) on Various devices ( Resolutions) and Browsers ( resolutions) using Physical and Email testing Tools.
• Validating the localization and geo- specific content where ever needed
• Validating the UI(User Interface) of the Emails in the Salesforce as well the Salesforce Cloud Pages as well as across all the devices and Browsers.
• Performed Cross Browser and Cross Platform testing (Mobile device testing).
• Tools: Jira - User story and Requirement management; ALM - Test case and Defect management; Email on Acid / Litmus - Email testing, GUI Testing; Confluence - Documentation, Reports; Salesforce CRM Database (Customer 360 Data Cloud), Salesforce Data Cloud (Data warehouse); Salesforce Data Loader: To perform bulk import of test data; Developer Console (Query Editor): Used to write SQL queries; Postman - Validating the API responses for certain scenarios.

ETL Test Lead - Deloitte

(2021-09 - 2022-04)

Client: Sharecare

• Analyzed the requirements\artifacts and prepared a clarification document whenever necessary.
• Prepared test plan and test cases in Team Foundation Server (TFS) with respect to the requirements\artifacts.
• Wrote SQL test scripts using SSMS that validates the sources along with transformations applied as per the requirement to target tables.
• Wrote SQL test scripts using SSMS to validate reports generated using SQL Server Reporting Services (SSRS).
• Executed\Ran the jobs designed using SQL Server Agent available in SQL Server Management Studio (SSMS).
• Applied ETL testing techniques such as, Source to Target Count testing, Source to Target data testing, Duplicate Data Check testing, Data Transformation testing, Data Quality testing, Incremental testing.
• Validated structure of the newly created target tables by checking for columns, column data types, constraints, etc.
• Identified defects and reported the same to the development team using Team Foundation Service and JIRA and retested the same once fixed.
• Reported work progress to the team in daily status calls, emails and scrum meetings.
• Prepared Exit document for each requirement as a sign off to the product owner.
• In addition to the above, was an active participant in conducting training for newcomers into the team and teams in different projects on SQL Server and ETL testing procedures.
• Tools: SQL Server; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS); JIRA.

Salesforce QA Tester - Deloitte

(2019-03 - 2021-09)

Client: Google Vector, US

• Was a co-lead for a team of 7 members for the Salesforce Sales QA Team.
• Worked on GCP Cloud, Sales Cloud as part of Google and Salesforce.
• As part of testing, tested Leads and Opportunities, Validating GCP cloud pages.
• Well versed in analysing CRM business processes that include Campaign management, Lead Management, Role Hierarchy, Account Management and Case Management.
• Tested Salesforce standard Objects( Campaigns, Accounts, Contact, Opportunity) and Custom Objects, Page Layouts, Field validations and its access to the user based on defined Profile.
• Authoring, reviewing of the test cases for Sprint, Regression and SIT.
• Was part of Sales and as well as Marketing team as part of salesforce.
• Analysis of the Regression suite for all the existing and new functional flows.
• Unit Testing and Solution testing of the developed test scripts across all country affiliates on various environments.
• Review of the test scripts for the correct functional flow and provide the feedback according to the requirement.
• Following the Agile process, from creating and to tracking the closure of the tasks on the sprint/ Kanban Board.
• Making sure the SIT test cases are written and tested with the proper flow covering all the interfaces.
• Making sure the test data is created correctly so that there are no invalid test data defects created.
• Coordination with clients on resolving issues to set up the automation environment for Final Build testing.
• Analysis of the test script changes to the Regression suite after every release.
• Performed UI (User Interface) testing by doing Cross Browser and Cross Platform testing (Mobile device testing).
• Validating the Emails for the Content and UI.
• Tools: Salesforce Tracker - userstories, test cases and defects; Database testing - Microsoft SQL Server; Postman- API testing; Salesforce CRM Database (Customer 360 Data Cloud), Salesforce Data Cloud (Data warehouse); Salesforce Data Loader: To perform bulk import of test data; Developer Console (Query Editor): Used to write SQL queries.

Hybris QA Tester/ Co- lead - Deloitte

(2018-04 - 2019-03)

Client: Magic Leap, USA Industry: Technology and E-Commerce

• Preparation and setting up the Test data for the smooth execution of test cases.
• Test execution of Integration, Regression, and E2E Test Cases.
• Reporting Status on daily status meeting with Onshore.
• Coordinating in UAT scripts execution and UAT defects verification.
• Working closely with the development team/functional team to meet the criteria for successful launch of the application.
• Maintaining test results & reporting defects to the concerned team members.
• Storefront testing and testing in the Hybris Back Office administration or HAC(Hybris Administration Console).
• Extensive knowledge of the Order management and pricing of the products.
• Worked on Suggestion and Promotions of the products.
• Testing the Site/ Home, PLP, PDP, Cart, order summary, Order Detail pages
• Testing Carousels, Recommendation, Promotions, Prices as part of Hybris.
• Validation the emails( Content, Functionality, UI, Hyperlinks ) for all the Transactional, Promotional emails, Survey email, Welcome Emails.
• Performed Globalization and Localization testing to validate different Languages( French, Chinese, Spanish.. etc) and Currency is reflecting according to user selection
• Performed basic accessibility testing by using screen readers and Magnifiers.
• Performed Cross Browser and Cross Platform testing and Device Testing(Mobile/Tablet/Ipad).
• Tools: TestRail - Test cases; Jira - Userstories and Defects; Postman - API Testing; Confluence - Documentation, Reports; Hybris, BackOffice, HAC, Storefront.

ETL and DWH Tester - Deloitte

(2015-02 - 2018-04)

Client: Illumina, INC Industry: Life Sciences and E-commerce

• Tested the Application which is a part of Order Management process for B2B and B2C customers developed using AdobeExperience Manager(AEM) and WebSphere Commerce(WCS)
• Joined the team in Design Phase so helped the Functional Team in Writing User stories.
• Prepared the Visio process flows for the user stories.
• Handled query log/ RAID log to get clarification on functionality with Onshore.
• After the Build Phase started working as a QA Tester, Writing test cases/scenarios.
• Preparation and setting up the Test data for the smooth execution of test cases.
• Involved in Functional sessions for User Stories clarifications every sprint.
• Providing functional clarifications in the user stories to the QA team members by acting as a Functional go-to person.
• Module Owner for major modules in ETP (Customer Master, Material Master, Check out and flows, Marketing & Merchandise, Globalize, Catalog & Product Management)
• Test execution of Compatibility, Regression, E2E Test Cases and also the owner of data Migration.
• Getting the new team members on-boarded with the required Knowledge Transfer (informal) and the help with the right test data/right contacts to speed up on the project.
• Test Data gathering from different teams (SAP, onshore) for test execution.
• Second POC for Smoke test reporting after every build on different environments-QA, Production, Staging.
• Coordinating in UAT scripts execution and UAT defects verification.
• Working closely with the development team/functional team to meet the criteria for successful launch of the application.
• Maintaining test results & reporting defects to the concerned team members.
• Reporting Status on daily status meetings with business.
• Functional Role on the project, understanding requirements and helping team members understand and implement them.
• Performed Database testing for validating the data transfer from one database to another data warehouse tables using SQL queries.
• Applied ETL testing techniques such as, Source to Target Count testing, Source to Target data testing, Duplicate Data Check testing, Data Transformation testing, Data Quality testing, Incremental testing.
• Performed SCD2 tables verification and validation.
• Performed verification of Snowflake schema tables created.
• Worked on WCS applications such as WCS IBM management centre, Commerce accelerator, WCS Org Admin Console.
• Worked on SAP ERP to validate the data transfer and data validation.
• Wrote SQL to validate data in reports shared to the clients.
• Validated SQL Jobs to ensure the Extract reports are generated in desired formats.
• Validated Dimension and Fact tables.
• Validated database definitions to ensure that tables are created as per design document.
• Involved in Data Quality activities to analyse and share the Data discrepancies in the existing application to the Business to bring a Data remediation for the misalignments and helping in standardising the Global KPI reports.
• Validation the emails( Content, Functionality, UI, Hyperlinks ) for all the Transactional, Promotional emails, Survey email, Welcome Emails.
• Performed Globalization and Localization testing to validate different Languages( French, Chinese.. etc) and Currency is reflecting according to user selection both on emails and Web.
• Email validation is done on Different mobiles and Browsers (Physical , Email tools)
• Performed Cross Browser and Cross Platform testing and Device Testing(Mobile/Tablet/Ipad).
• Performed basic accessibility testing by using screen readers and Magnifiers.
• Tools: HP ALM - Test cases and defects; Jira - Defects; Version One -User stories; Postman - API Testing; Application: SAP ERP, Salesforce.com/SFDC CRM, IBM WCS; Database - Microsoft SQL Server; Confluence - Documentation, Reports, RAID logs.

Software Engineer - Genpact Pvt Ltd. - Hyderabad, India

(2012-09 - 2015-02)

Client: Genworth. Role: Test Engineer, Supporting the offshore team for the below responsibilities and providing the project updates to client and onsite team whenever required.

• Identifying requirements and Conditions of Satisfaction.
• Designing test scenarios and test cases
• Uploading test cases into ALM and Preparing test set for execution
• Execution and Defect Logging in ALM.
• Interacting with Developers for assisting them in the Identification, Simulation, Resolving and Tracking of problem events.
• Pulling out report, Consolidated Defect report and reporting to the team
• Defect Retesting and Involved in review and Defect Triage Meetings.
• Performed Cross Browser and Cross Platform testing (Mobile device testing).
• Tools: ALM - User stories and Defect life cycle; Database - Microsoft SQL Server

Bachelor’s degree - Electrical Engineering - Geethanjali College of Engineering & Technology (2008 - 2012)