Senior QA Analyst, Salesforce Certified, E2E Testing

SINDHU JAYAPALAN 917-***-**** *******.******@*****.***

Senior professional with 12 years of information technology experience specialized in software quality assurance and maintenance. Functionally competent and business oriented professional with strong leadership and client facing role across financial and retail business domains Profile Summary

• Managed and directed teams in delivering UI, System, Functional, Integration, End to End, UAT and Regression Testing which results in high quality web based applications and CRM applications (Salesforce)

• Strong QA and E2E experience in Service Cloud and Sales Cloud lightning platforms

• In depth knowledge on CRM business processes like Lead Management, Account Management, Contact Management, Beneficiary Management, Omni-Channel –Case routing, Payments and Loan disbursements

• Expertise in executing Test Estimates, Master Test Plan Preparation, Test Strategy, Test Scenario/Script Execution, Defect Triage management, Trial Rollout, Migration, Release and Hyper Care support

• Hands on experience in SQL Query writing, (Oracle and Vertica), API testing with Postman and SoapUI to test SOAP and Rest APIs

• Extensively worked on Agile projects, providing story point estimates, participating daily scrums, Sprint planning and Sprint Retrospective sessions

• Excellent team player to work in conjunction with Product owners, Business Analysts, Testers (QA), developers and other team members in validation and testing of complex projects

• Experience in ETL testing and database testing using Informatica and Oracle Data Integrator

• Possess Automation knowledge and experience in Service cloud automation for View policy

• Strong domain knowledge in Retail eCommerce and supply chain process with excellent product knowledge in Oracle Retail applications like Retail Merchandising, Pricing, Allocation, etc.

• Quick learner, proactive, Flexible, organized and adaptable to new environments with excellent communication, mentoring and interpersonal skills

Technical Skills

• Tools: Oracle UPK, Toad, PL/ SQL Developer, Balsamic, Eclipse, HP QC, ALM, JIRA, Putty, WINSCP, MS Visio, Top desk, Appworx, Subversion (SVN) and CVS, TFS, BitBucket, Perforce, Autosys, Servicenow, Sharepoint, TestNG, GitHub, SQUIRREL, Postman, SOAP UI

• Oracle Retail: Retek Merchandising System, Retail Pricing Management System, Retail Allocation, Retail Sales Audit, Invoice Matching and Store Inventory Management

• Databases & Reporting: Oracle, Vertica, Tableau

• Languages: Java, SQL, PL/SQL, HTML, XML

• Data warehousing & ETL & CRM: Oracle Data Integrator (ODI 11g), Informatica, Salesforce

• Certifications: Scrum Master, Salesforce Admin

• Domain Experience: Retail, Finance, Insurance

Professional Experience

New York Life Insurance, New Jersey Oct 2018 – Till date Salesforce Senior QA Analyst

• Leads Service Central team in NYL’s CRM platform to deliver the digital transformation projects in salesforce

• Responsible for providing estimates in each PI, coordinate E2E and API integration testing and execution with all other downstream legacy systems

• Perform complete regression and system testing for new product launches

• Support BA review meetings with business and UAT testing with Customer Service Representatives and record the feedback/issues faced

• Managed Client central E2E and integration Testing with 300+ test scenarios

• Managed Functional/Integration testing of a critical and significant NYL project-E-Signature with external partner Adobe to digitalize all forms handled by CSRs to customers- 70 forms across three different LOBs

• Interact with project stakeholders, sharing status reports, defect reports, project metrics, test closure reports etc.

• Review test results with Product Owner and feature Solutions Architect and report and communicate testing progress to business owners and delivery head

• Log defects in JIRA, collaborate with Salesforce developers to resolve defects, retest failed test scenarios, and close defects once remediated for all regular fixes by development team and hot fixes from Application Support team

• Participate/Conduct in agile team ceremonies including Sprint planning, daily standups, defect triage meetings, product demos and sprint retrospectives

• Involved in brainstorming sessions to understand the functionality and worked with developers to check the layouts, preparing the test data and assisted them in creating apex classes for sandbox migration in Salesforce CRM application

Mitchell Martin Inc. Bank Of America Merrill Lynch, New York Mar 2017 – Mar 2018 System Analyst/QA Analyst – Sales, Research & Capital Markets Technology (GBAM)

• Worked in MIFID II implementation, an European Union Legislation to unbundle the payment of research, execution and client consumption to provide more transparency to consumers by utilizing the existing touch points data along with the readership data, and research pricing business data from sales and research upstream systems by creating ETL scripts using Informatica and SQL in an agile/scrum environment

• Reviewing the requirements and user stories with the Business teams, and Sharing test status in daily standup meetings, sprint planning and sprint review meetings

• Coordinated with developers and BA team to understand the source-target mapping definitions and responsible for sending collated defect reports to the entire team

• Extensively involved in system testing and unit testing of custom developed scripts for MIFID using SQL by Calculating advisory cost, advisory revenue using the readership and touchpoint data in database by using SQL aggregate and analytical functions

• Developed SQL scripts to test the logic for touchpoints aggregated columns- 142 columns in single table

• Managed code release, migration and versioning management for ECP and MIFID2 in Oracle and Vertica

• Coordinated with offshore team, internal stakeholders and upstream/downstream systems for client consumption data feds to third party vendors and also for ad hoc reporting requests

• Release management: Organized offshore/onsite meetings to track progress, Status updates, Release approvals, Release Punch list review, Release execution with DBA team Logic Information Systems Inc., Minneapolis /Chennai Sept 2013 – May 2015 Team Lead/SME:

• Managed projects related to change initiatives impacting multiple business units, product lines, and business processes requiring cross-divisional coordination, communication, influence and negotiations

• Headed a team of 5 in Oracle UPK Testing (User Productivity Kit) to automate the testing process for multiple modules which involves test planning, creating, validating and identifying test scenarios, reviewing test scripts and test cases, guiding and assisting the team and clarifying test steps in terms of application functionality

• Subject matter expert for RPM and allocation systems – troubleshooting production issues for multiple retailers.

• Organized and delivered functional training programs in RPM, RMS and Allocations for clients and Global employees of Logic

• Tested integration interfaces in ETL tool Oracle Data Integrator to perform table to file transformations using knowledge modules

• Conceptualized and designed a global ticket tracker tool across all Logic clients

• Launched and structured the Centre of Excellence – Functional Oracle Retail Team

• Coordinated with global team in terms of creating a unified business analysis process across Logic Systems

• Trained and mentored resources in building Oracle Retail products and helped them understand the business functionality

Wipro Technologies, Bangalore, India Nov 2007 – Aug 2013 QA/ADSM Analyst: (WE Fashion/Media Saturn, Supervalu)

• Managed multiple global retailers (Ahold, WE Fashion, Morrison, Supervalu, Media Saturn) business system for Pricing and Allocation in flex delivery model

• Identify opportunities and implement process improvements (i.e., root cause analysis, technological assessments, etc.) to optimize performance.

• Hands on experience in manual exploratory testing and Performance testing for Retail Cost Change

• Single Point of contact and individual contributor for Functional testing in RPM - Calendar, Worksheets, Candidate Rules and Price Guides, Maintain Margin and competitive Price Strategy

• Executed system test cases for Item Maintenance, Product and Organization Hierarchy, Open To Buy, Cost Changes, Purchase Orders, Mass Cost Changes, Transfers and Replenishments in RMS 13.

• Developed and executed the integration test scripts for Emergency and Non-Emergency Price changes, Promotions and Clearances from Retail Systems to POS

• Developed and tested the UI for Personnel Automation Notification Administration in Adobe Flex technology

Education

Bachelor of Technology in Information Technology from Anna University, India, 2003–2007

Contact this candidate