Deborah odia

Phone: +1-267-***-**** Lansdowne PA Email: advmlk@r.postjobfree.com

Summary

Over 8 years Experienced in the IT industry and a Salesforce professional with over 6 years of Salesforce experience is seeking to obtain a position as a Salesforce Administrator to utilize my knowledge, previous work experiences, and technical skills in Salesforce administration and configuration; business intelligence design and implementation, customization, training, support, development, data analysis, database design and development, data modeling, metric reporting and presentation; building custom business intelligence solutions using SQL Server, Power BI, Tableau, and advanced Excel; building integration components to transition data from one system to another (SSIS – ETL tool), integration with external systems via REST, SOAP, and Streaming APIs (Platform Events, PushTopic, and Data Capture Events); end-to-end implementation on Sales cloud, Service cloud, Health cloud with aura components, lightning web components, Visualforce combined with declarative methods – workflow rule, process builder, flow, data validation, and formula.

Technical Skills

Operating Systems: Windows Server (2016, 2012, 2008, 2003), Windows 10

Databases: SQL Server (2017, 2016, 2014, 2012, 2008 R2), MsSQL

Business Intelligence: Microsoft Power BI, Tableau, Office 365, Advanced Excel

Languages/UI: T-SQL, DAX, Apex, Java, JavaScript, HTML, XML, Visualforce, Lightning Web Components

Methodologies: Scrum, Agile, Waterfall

Development Tools: Visual Studio, VS Code, SFDX/CLI, JIRA, Workbench, Data Loader, Import Wizard

Application Lifecycle Management: Team Foundation Server (TFS) (2017, 2012, 2010), Git

Domains: Insurance, Health Care, Real Estate, Sales, and Financial Services

Professional Experience

Salesforce Admin/Consultant

ATBOD San Diego, CA (01/17 – Present)

Implemented BI solution framework for end-to-end business intelligence projects.

Worked closely with the development team to customize, develop, design and manage ongoing system solutions to meet the organization’s goals.

Customized various Salesforce.com Standard Objects – Leads, Account, Contact, Opportunity, Activities and custom objects.

Developed document working prototypes and workflow diagrams to facilitate better system understanding.

Imported and extracted data from various sources such as flat files and databases to build functional reports and dashboards using power BI/Tableau.

Created customized reports, views and dashboards to provide managers, sales reps, and marketers with metrics and performance indicators.

Imported data into Salesforce using data import wizard, data loader, Bulk API with Workbench and postman.

Created, delivered operational and strategic reports to clients using Tableau/Power BI which improved decision-making by over 80%.

Implemented Static and Dynamic RLS (Row-Level Security) in Power BI reports, ensuring the right users have the right level of access as determined by the business requirements.

Involved in gathering and analysis of business requirements and then effectively took part in sprint

planning to achieve the requirement.

• Analyzed the business process of client and then involved in creating the application and data model

required

for the requirement.

• Creates custom application, objects, tabs, fields with the custom functionality to efficiently meet the

business requirement.

• Defined lookup and master-detail relationships on the objects and created junction objects to establish

• connectivity among objects.

• Created reports, dashboards, and processes to continuously monitor data quality and integrity and

• assisting users with report design and management.

• Customized page layouts for Opportunity, Contacts, and Accounts depending upon user profiles and

created permission sets where necessary.

• Worked on Assigning creating Roles Hierarchy, Profiles and Security setup within the organization.

• Responsible for setting up Filed Level Security.

• Developed custom Workflows and Assignment Rules for case escalation.

• Implemented Field Level security for sensitive data holder fields.

• Implemented Salesforce automation using web-to-case forms, email-to-case, assignment rules,

automation and queues, auto response rules, escalation rules, chatter groups, person accounts,

cases and solutions.

• Created and used Email templates in HTML and Visualforce.

• Involved in end-to-end testing and gathering feedback from business users

• Involved in Working with Standard Salesforce features like Objects, Workflows, Record Types,

Page layouts, Workflow Rules, Case Assignment Rules, and Escalation rules, Validation rules, Profiles,

Roles, Reports and Dashboards etc.

Salesforce Admin/Business Analyst

African Market Places,Dubai (06/20 – 12/20)

Enhanced operational performance by over 75% by generating weekly, and monthly reports (in real-time) used by departments for operational and tactical decision making.

Imported data from different data sources – SQL server, flat files, and Salesforce via ETL tool to create functional reports, dashboards and analysis to solve complex business problems.

Implemented and managed Salesforce-to-Salesforce integration.

Designed and developed mappings to load data from flat file to SQL server tables for reporting purposes.

Created and managed custom fields, validations, workflows, approval process, objects and relationships, page layout, profile, roles and permissions, dashboards and reporting, sales processes, campaigns, record types, and applications.

Improved organization productivity by over 85% by implementing Single Sign-On (SSO).

Implemented data access control via field-level security, permission sets, role, sharing rules, permissions, and profiles.

Restricted user logins to the specified times of the day in order to deny access to confidential data outside of the official hours.

Responsible for analyzing business requirements and defining marketing CRM system specifications.

Enhanced operational performance by over 75% by generating weekly, and monthly reports (in real-time) used by departments for operational and tactical decision making.

Worked with varying business units to identify key performance indicators (KPI) and metrics required for reporting and analysis.

Managed and resolved support ticket submissions faster by setting up an effective case management system (Web-to-Case, Email-to-Case, Case Assignment, and Case Escalation rules).

Salesforce Admin/Business Analyst

Intelogik Solutions, Pune, India.

Work duration: April 2021-October 2021 ( Part time on contract)

Roles and Responsibilities:

Involved in SFDC application setup and customization to match the functional needs of the Company

Worked as Salesforce admin support governing user account creation, personal information setup, password reset, Roles & Profile creation, user group creation, updating company profile, Network access setup.

Involved in setting up field level access for each custom object created based on the user’s role within the organization.

Developed various Custom objects, Tabs, Entity-Relationship data model, validation rules, Components

Involved in the Data Transformation and Data Cleaning activities while transferring the data to the external system using Informatics on Demand.

Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.

Involved in field & page layout customization for the standard objects like Account, Contact, and Leads.

Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.

Defined lookup and master-detail relationships on the objects and created junction objects to

establish connectivity among objects.

Involved in security levels and privileges by customizing Salesforce.com Profiles and Roles.

Involved in customizing custom objects, tabs, fields, page layout as per the business need.

Integrated Email with Salesforce.com for mass E-mail management and designed various custom E-mail templates.

Maintained user roles, security, profiles, and workflow rules wherever necessary.

Education and Certifications

Education

Certifications

University Protestante de I’afrique de I’ouest

BSC – ACCOUNTING

KWARA STATE POLYTECHNIC

NATIONAL DIPLOMA

Salesforce Certified Administrator

Salesforce Certified PLATFORM 1 Developer

Salesforce Certified Community Cloud Consultant

Contact this candidate