Salesforce Data

Suma K 615-***-****

*********@*****.***

Professional Summary

Around 8+ years of experience in IT with 3+ years of experience as a Salesforce Analyst in salesforce.com.

Developed clear business requirements to ensure the delivery of new products as per desired business objectives

Strong functional and technical skills in understanding business processes, eliciting requirements, creating operational workflows, outlining business rules and documenting findings in business-centric documents.

Ability to collaborate effectively, influence others, and in building superior cross-functional relationships

Experienced in participating in all phases of the Software Testing like analyzing System Requirements, Test Strategy, Test Planning, Test Case Design and Test execution

Exposure to tabular and multi-dimensional modeling in addition to the development of the Enterprise Data Warehouse

Work experience in leading the Onsite - offshore teams effectively.

Advanced MS Excel skills - creating and using pivot tables, formulas - VLOOKUP’s, HLOOKUP’s, external

connections.

Designed and developed interactive dashboards and reports. Created and maintained documentation of processes, reports, applications, and procedures as per organization policy.

Creation of Objects and Fields in Salesforce.

Experience in creating detailed process documentation and deployment process on issues for

future Follow ups.

Salesforce Certified Developer.

Salesforce Certified Administrator.

Involved in salesforce.com Application Setup activities and customized the apps to match the functional needs

Hands on Experience in creating Custom Objects, Custom fields, Page layouts, Custom Tabs,

Reports and various other components as per the client and application requirements.

Understanding in Profiles/Roles and Sharing Rules, Users, Page Layouts, Email Services, Approvals, Reports, Dashboards, Tasks and actions.

Team player with excellent interpersonal and communicational skills, ability to learn and adapt to new

technologies and experience in successfully implementing new technologies in the projects.

Commitment to excellence proven by an outstanding career track.

Strong communication, organizational and interpersonal competencies along with detail

oriented and problem solving skills in the technology arena

Self-sufficient, flexible, self-directed, self-motivated and a good team player capable of

managing multi-tasking and a fast learner by adapting to the conditions

Interact daily with business units and business owners to understand business processes and key

requirements, proactively work to resolve client issues.

Proficient in analyzing and translating business requirements to technical requirements and

architecture.

Skills

Analytical and Critical thinking Requirements Gathering Excel - Data Analysis

Business Analysis Manual/Unit Testing Agile & SDLC Methodology

Report generation Salesforce.com Data Analytics and BI

Technical Skills

Databases

ORACLE, MS SQL-Server, My SQL

Platforms

Windows/UNIX

CRM Technologies

Salesforce.com

Salesforce tools and Technologies

Workflow, Approvals, Validation rules, Process Builder, Reports, Dashboards, Force.com Data Loader, Migration tool

Technologies

HTML, CSS, JavaScript, SQL, PLSQL, XML

Operating System

Windows 9x/NT/XP/Vista/2003/2000, Mac.

Ticketing System/Tools

Remedy, Accurate (Carphone Warehouse internal tool), JIRA, TOAD

BI Tools

Power BI

Certifications

Salesforce Platform Developer 1 certified professional

Salesforce Certified Administrator (ADM 201) professional

Attended Salesforce Admin Workshop organized by Salesforce.com at Salesforce office.

SEED certified professional in Testing.

Completed Oracle certification in SQL

Login soft certified professional in CMM Level 3.

Work summary

Client:Asurion, Nashville, TN

Salesforce Analyst Feb 2016 – Mar 2019

Roles and Responsibilities:

Responsible for requirement gathering

Created Custom Objects and defined lookup and master-detail relationships on the objects and created junction objects to establish many-to-many relationship among objects.

Designed the Custom objects, Custom tabs, Validation rules, Auto-Response Rules, Page layouts, to suit to the needs of the application

Worked on standard objects like Accounts, Contacts, Leads, Campaigns, Reports, Cases (case management) and Opportunities.

Worked on dashboards to view reports and give permission to access the reports.

Involved in salesforce.com Application Setup activities and customized the apps to match the functional needs

Worked with On-site and Off-shore teams for Development and Testing.

Configured test environment for specific test cases, created test data, executed automated or manual unit tests, documented results and updated defect tracking systems

Worked on user access to the information on the accounts.

Worked on solving the case issues by the user for managing the Salesforce application the user is working on.

Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

Provided production assistance after project implementation.

Providing Technical assistance based on the functional requirement.

Worked on user access to the information on the various objects in Salesforce.

Creation of Objects and Fields in Salesforce.

Tech Mahindra, Dec 2009-Jan 2013

Client: Talk Talk, UK

SQL Developer

Roles and Responsibilities:

Responsible for the delivery and maintenance of business reports and project management of data capture processes, works closely with the Group’s Strategy and Business Planning Team

Worked closely SCRUM team to create test cases to ensure coverage of all areas of the product/feature(s).

Designed & created Test Cases depending on the business requirement documents in HP ALM and executed them and analyzed the results

Understanding the client Requirements, projects Functionalities

Delivering reporting using Excel and internal data sources

Writing SQL queries to import data from SQL server databases into excel to automate the reporting process

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Determined user/business/functional requirements. Created vision, scope, and use case documents;

business process models, use case diagrams, activity diagrams, and state chart diagrams.

Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).

Worked on end to end application packaging Life cycle beginning with requirement analysis to deployment.

Gathered data for monthly metrics and audits.

Create complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and

Statements for Applications by using T-SQL.

Code DDL / DML Triggers as per company standards.

Involve in Code Review, unit testing, Integration testing, and version maintenance.

Coding, debugging, Integration testing and deployment.

.

Client: Carphone Warehouse, UK.

Roles and Responsibilities:

Created ad-hoc reports to support timely business decisions, service evaluation.

Lead the design and development of actionable metrics and reports across a cross-functional team of stakeholders

Involved in Scheduling the Reports to run on daily and weekly basis in Report Manager

Hand on experience in maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints.

Designed & created the Test Cases based on the Business requirements

Customer facing role – reporting and presenting information to customers, including Account managers, Program Managers, Technology Solution Managers etc.

Performed Functional, Smoke, Negative, Positive, Boundary and Regression Testing.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.

Login Soft, Hyderabad, India, Jul 2007-Oct 2009

Client: Cater Expert, USA.

Data Analyst

Roles and Responsibilities:

Developed and performed system testing and fixes defects identified during testing and re-executes unit tests to validate results

Developed integration, system test plans for the entire system encompassing various critical functional modules.

Created Table, Clustered, Non-Clustered Indexes and constraints to the frequently used tables in

application.

Proposed and prioritized changes to reporting by creating additional metrics & processes based on business needs

Requested refreshes pre or post restore activities (e.g. data loads). Develops and tests database scripts, stored procedures, triggers, functions, SSIS packages, and other back-end processes to support system integration and ETL (Extract, Transform, Load) to facilitate the creation and population of the Enterprise Data Warehouse

Scheduled and managed jobs on MS SQL Server and manage database security with respect to User access, roles, and privileges.

Designed database schema structures, procedures, triggers to enhance the revenue critical systems

Developed complex reports and provided to business people for further analysis. Responsible for make

changes in application according to business logic.

Involved in Development, Support and Maintenance.

Analysis of the requirement.

To maintain quality of the project as per the standards

Ensuring timely deliveries of work requests.

Status reporting on the module to Manager.

Resolving problem tickets along with enhancements.

Contact this candidate