Sign in

Data Sales

Frisco, TX
January 10, 2020

Contact this candidate


Mani Vajrala 805-***-****

Salesforce QA engineer with over 12 years of total IT experience and 6 years in Testing Salesforce Sales & Service Cloud applications both on Classic and Lightning Experience. Also have experience in Salesforce production support.

Extensive experience in testing Salesforce applications both in Classic as well as Lightning Experience.

Well versed with functional, integration and back-end testing

Self-motivated in analyzing problems and performing root cause analysis, and reporting findings back to Customer Care and Tier I

Subject Matter Expert and a go to person for multiple Salesforce projects and often trained other QA members for maintenance cycle, and provided support troubleshooting issues as needed

Experience working on custom objects, custom fields, pick list, page layouts, validation rules, custom tabs, custom reports, report folders, report extractions to various formats, snapshots, dashboards, and email generation according to application requirements

Experience in bulk data migration of various objects using Data Loader and Developer Workbench

Experience in implementing security and sharing model

Experience in querying Salesforce database using SOQL queries

Created several roles, profiles, email templates and page layouts

Created public groups and assign the user to the groups

Install Salesforce AppExchange apps

Familiar with Waterfall and Scrum/Agile projects

Have good interpersonal skills and analytical skills, with a focus on details. Have the ability to interact with people at different levels

Technical Skills

CRM: Salesforce, Data Loader, Email Templates, Workflows, Approval Processes, Reports & Dashboards, SOQL, Developer Workbench, Sales & Service Cloud, Zenkraft, Map Anything

Siebel 8.1/7.X/2000, Tools/Configuration, EIM

Operating Systems: Windows

Browsers: Firefox, Internet Explorer, Google Chrome, Safari

Methodologies: Waterfall, Scrum and Agile

Other Technologies: Oracle, SQL, Oracle e-business, MS SQL Server 7/ 2000, ODBC, HTML, FTP, HTTP, Windows and Linux,


Master’s Degree in Computer Application

Active Certifications

Salesforce Certified Administrator

Salesforce Certified Platform App Builder

Salesforce Certificate Verification

Work Experience

Essilor USA June 2017 – Dec 2019

Salesforce QA Lead

Participate in grooming sessions and reviewing user stories

Create Test Scripts based on the Business Requirements Specification documents

Build tests suites for regression and smoke testing

Provide accurate estimates for test design and execution work

Involve in reviewing test results and bug fixes after each deployment and update the test scripts as needed

Help business users in carrying out the User Acceptance Testing

Analyze requirements for clarity and discuss with BA and business on clarifications

Help the development team clarifying the production issues reproduction

Create users, profiles, permission sets, public groups and assign the users

Create and test different page layouts

Help the Zenkraft team to support and to the Salesforce application

Help the GPN system to support the Salesforce application

Help the developers to finding the root cause of the issue

Track all test cases and bugs in Jira

Test Salesforce application in Lightning Experience

Help resolve production issues, load data and create reports on demand basis

Alliance United Insurance and Top Finance, Chatsworth, CA Feb 2014 – June 2017

Salesforce QA Lead

Participate in design discussions for various Salesforce projects

Create several test cases, test strategies, upload them into Jira

Execute test cases and create bugs in Jira

Work with development team in resolving the issues

Work with business users in UAT

Was a go to person for Salesforce related issues

Help business with Salesforce production support

Manage users, roles, public groups, organization wide settings, role hierarchies

Manage resetting passwords, modifying data and create ad hoc reports

Manage data transfer and mapping between and other applications

Create several reports for different user profiles

Import and export data using Data Loader

Import data from excel sheets in to Leads, Accounts and Contacts using Data Loader

Use Data Loader and developer workbench for insert, update and bulk import or export of data. Used it to read, extract and load data from comma separated values CSV) file

Environment: Salesforce Service Cloud,, Data Loader, Reports, Custom Objects, Custom Tabs, Oracle EBS, Data Loader, Reports & Dashboards, SOQL, Sales & Service Cloud

Move Sales Inc., Westlake Village, CA Feb 2007 - Aug 2013

1. Salesforce Data Migration & Production Support, Move Sales

Collaborate with business in maintaining the existing Salesforce application and provide an ongoing support

Support trouble tickets via Service Desk Express

Analyze /resolve problems related to access control

Work on user management of creating users, assigned with appropriate profiles part of user onboarding; making necessary changes to user records during their leave of absence; inactivate user profiles part of termination process

Make changes to Role hierarchy to incorporate user changes in the organization

Define permission sets on ad-hoc basis to give additional access on a temporary basis

Create reports and dashboards as per business requirement

Validate system functionality during application upgrade

Create reports and provide necessary data to business and cross teams

Make necessary changes to data using Data Loader & Workbench

Create custom objects, custom fields, page layouts, Record Types, related lists, workflow rules, validation rules

Work on migrating the data for User, Account Share, Account Team, Account, Contact, Account & Contact Relationship, MLS, Task, Case, Case Comment, Product, Asset, Contract, Product Restriction Flags and Attachments

Interact with DBA’s, IT-Ops, Network & Storage engineers and Security teams to resolve any outstanding issues.

Work under tight project lines and ensure that the project is delivered on time with quality

Create data mapping documents for data migration objects, develop scripts to migrate the data on a one-time and daily basis. Write various SQL scripts to perform data migration and data verification

Work on Data Loader and developer workbench to perform various data migration activities.

Write numerous SOQL statements to extract and verification purposes

Environment: Salesforce Sales & Service cloud, Administration, Data Migration (Data Loader, Workbench, SOQL, SQL Server 2008) & Windows

2. ERP Technical Analyst, Siebel, Move Sales

Move Sales Inc., is a leader in online real estate. I joined Move in the initial Siebel implementation phase working on configuration and Data Migration. I was responsible for Data Migration (Accounts, Contacts, Activities, Assets and Agreements), Siebel configuration and Production Support.

Work independently on migrating the Accounts, Contacts, Activities, Assets, Asset Attributes, Agreements, Agreement Line Items, Agreement Line Item Attributes, Charges into Siebel from various sources.

Create Data Mapping documents for the above entities, use SQL Loader to load staging tables, write various SQLs to be used in the EIM process to massage the data, create IFB files and run EIM processes

Validate the results and make sure that data import issues are resolved. Work on optimizing the EIM process to load 15 Million records

Load the data multiple times in development, testing, training Mock and Production environments. Involved in all major production deployments (8 major releases )

Work with DBA in resolving database related issues during the data loads, tune the SQLs. Work with cross teams in leading the data migration effort. Write scripts to load the data into Siebel on a daily basis.

Perform the Root Cause Analysis (RCA) for the issues reported and document the changes needed as appropriate

Solve problems independently and provide appropriate workaround as appropriate

Work with cross team members in resolving the issues

Develop several SQLs to address the recurring issues until they are permanently fixed

Resolve integration issues coordinating with multiple teams

Write various SQLs to fix production support issues on a regular basis.

Multi-task to manage time effectively

Develop several SQLs on demand basis to generate reports and schedule them to run on a periodical basis.

Environment: Siebel Sales 8.1.X, Tools/Configuration, Assignment Manager, Workflows, EIM, SQL, Oracle 11gR2, Windows and Linux

Contact this candidate