Summary
Overview
Work History
Education
Skills
Websites
Certification
Trailblazer Account
Timeline
Generic

Mohan Chandra Dronavalli

Farmers Branch

Summary

Dynamic Salesforce Administrator with extensive experience at CareFirst, adept at customizing Salesforce solutions to drive business impact. Proven expertise in Salesforce CPQ and agile methodologies, coupled with strong problem-solving skills. Successfully implemented complex workflows and data integrations, enhancing operational efficiency and user satisfaction across diverse teams. Skilled Salesforce Administrator with background in optimizing CRM workflows and improving data quality. Strong skill set includes Salesforce configuration, customization, and report generation. Noteworthy impact in previous roles through successful database management, user training, and system troubleshooting to increase operational efficiency. Known for exceptional problem-solving abilities and commitment to enhancing user experience.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Senior Salesforce Administrator

CareFirst, Blue cross Blue
10.2022 - Current
  • Involved in Salesforce Service Cloud Setup activities and customized applications according to the business needs
  • Developed Apex Classes and Triggers to implement business logic in the Salesforce platform
  • Utilized the SOAP and REST APIs to expose Salesforce org data to Enterprise applications
  • Worked on Service cloud to support the business requirement using various Salesforce.com Standard Objects
  • Including Accounts, Contacts, Cases, Tasks, and custom objects
  • Worked on Agile SCRUM Methodology that involves iterative development
  • Gathered requirements and prepared requirement documents and technical design documents to meet the business rules and worked with stakeholders and project teams to prioritize the collected requirements
  • Created various Custom Objects, Formula fields, Master-Detail, Lookup relationships, Tabs, validation rules
  • Created various Profiles, Roles, and Page Layouts and configured the Permissions based on the Organization hierarchy requirements
  • Created FSL setup for multi-level service territories that represent the regions where agents and technicians can work
  • FSL managed package and FSL mobile app
  • Designed and developed Custom validation rules, Approval Processes for automating business logic
  • Created Workflow rules and defined related tasks, email alerts, and field updates
  • Implemented Pick lists, Dependent Picklists, lookups, Master detail relationships, validation, and formula fields to the custom objects
  • Experience troubleshooting issues with Copado and implementing solutions to address them
  • Familiarity with other Salesforce DevOps tools and technologies, including Git, Jenkins, and Salesforce DX
  • Strong understanding of agile development methodologies and how they can be applied in a Copado-based DevOps environment
  • Demonstrated ability to document processes, procedures, and best practices related to Copado and Salesforce development in general
  • Familiarity with Salesforce security best practices and how they can be implemented and enforced through Copado
  • Data migration and update through Copado tool
  • Design, develop, debug
  • Improve, optimize, and troubleshoot complex system and custom tools using custom Apex code, unit tests, and triggers: the SFDC declarative interface: and utilizing Apache ANT deployments
  • Created email templates and inbound emails using Visual Force for clients and customers
  • Enabled Chatter for the Organization and to effectively communicate with the users in the Organization
  • Worked on Data Loader for loading the data from .csv files
  • Creating business documents for Salesforce.com applications and implementation guide
  • Implemented Salesforce.com web services client using Sales force web services API, Java, XML and WSDL
  • Developed several Custom Reports & Dashboards using report types
  • ENVIRONMENT: Saleforce.com, Service cloud, Force.com platform, Apex Classes, Chatter, Visual Force Pages, Controllers, Custom Objects, Custom Tabs, Email Services, Workflow & Approvals, Reports, Security Controls, Eclipse IDE, WSDL, Windows.

Senior Salesforce Administrator

DXC Technology
Dallas
10.2021 - 10.2022
  • DXC Technology is a Fortune 500 global IT services leader
  • Our more than 130,000 people in 70-plus countries are entrusted by our customers to deliver what matters most
  • We use the power of technology to deliver mission critical IT services across the Enterprise Technology Stack to drive business impact
  • DXC is an employer of choice with strong values, and fosters a culture of inclusion, belonging and corporate citizenship
  • Responsibilities:
  • Creating an application to maintain the details of the product from demand phase to production phase
  • Interacted with various business user groups for gathering the requirements, designed UML and use case diagrams
  • Configured & Designed Adoption Dashboard to keep an overview of Created reports, Logins and Users performance
  • Used Tabular, Summary and Matrix reports to create Standard reports and Custom reports
  • Created & maintained detailed documents on changes in Salesforce org
  • Facilitated effective & efficient use of platform by creating Visual Force pages as per business requirements
  • Developed custom salesforce queries classes, triggers, and Batch process with Apex
  • Implemented custom Validation rules, Formula Fields, Email Templates, Assignment Rules and AutoResponses for Cases and Leads
  • Designed various Email Templates like Custom, HTML and Visualforce, these Email Templates will be used to manually send emails through standard email interface or send emails through workflow rule email alerts and apex code
  • Configured Security Assertion Markup Language (SAML 2.0) For Salesforce in single Sign-on
  • Implemented Complex Workflow rules, Workflow Approvals, Flows, Process builder, Validation rules, email alerts and field updates for business process automation
  • Experience managing Salesforce development and release processes using Copado
  • Skilled in configuring Copado to automate continuous integration, testing, and deployment for Salesforce applications
  • Familiarity with Copado's key features, including its DevOps dashboard, release management tools, and change management workflows
  • Ability to collaborate effectively with development teams, business stakeholders, and Copado administrators to ensure successful project delivery
  • Used Force.com web service API for implementing WSDL in the application for access to data from external systems and web sites
  • Defined objects and Field Level Security for different profiles
  • Responsible for Requirements gathering, Analysis, Data Modeling and create design document
  • Participated in meetings with Business Users, Analysts & Managers to discuss the Business requirements
  • Created Apex Classes, Apex Triggers and Visualforce Pages for various functional needs in the application
  • Deployed Sandbox salesforce.com application into Production using Force.com IDE
  • Periodic deployments to the Production environment using change sets according to deployment schedules
  • Worked on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Territory Management, Reports and Dashboards
  • Created different workflow rules and Approvals, Email Templates to run the Territory and assignment rules
  • Designed and developed the Custom objects, Formula fields, validation rules, Page layouts, components to suit to the needs of the application
  • Created Many-to- Many relationships and created Junction objects to implement Roll-up Summary fields to aggregate data from child records on the parent
  • Environment: SFDC, Apex, Data Loader, Force.com, Import Wizard, Eclipse IDE plug-in, Snapshot Deployment Tool, Visual force Pages, XML, Triggers, Java, SOAP, WSDL & RESTful Web Service Controllers, Salesforce.com Platform, Apex language, Apex Custom Controllers.

Salesforce Administrator

UPS Supply Chain Solutions
Alpharetta
09.2019 - 09.2021
  • UPS Supply Chain Solutions offers a comprehensive portfolio of services to enhance customers'​business performance, including logistics and distribution, transportation and freight, consulting, customs brokerage, and international trade services
  • UPS provides the expertise and the scale to meet the total supply chain needs of customers worldwide, whether it requires the movement of goods, information, or funds
  • Responsibilities: -
  • Worked on Salesforce Sales Cloud, Community Cloud and Service Cloud
  • Worked with Sales Rep, Executives and Business unit by addressing their related issues on Salesforce queries
  • Integrated with various applications including ERP, Salesforce for Outlook, and Map Anything
  • Created multiple objects, opportunity record types, custom and standard fields, formula fields, validation rules and page layout
  • Created email templates and mail merge templates
  • Created profiles, roles, permission set, public groups
  • Implemented CPQ solution using Steelbrick CPQ and Contract Management (CLM) for various customers in industries
  • Involved in end-to-end testing and configuration enhancement for the Steelbrick CPQ
  • Setup, maintain and optimize Email marketing campaign utilizing Exact Target/Salesforce Marketing Cloud
  • Used Force.com platform for developing feature rich and user-friendly Visual force pages for enhancing Salesforce UI
  • Used SOQL, SOSL to select the data from Salesforce.com platform database
  • Experience in using the Force.com Explorer to browse data model schema, custom objects, fields, build and test SOQL queries
  • Worked on Steelbrick product configuration and price configuration with SDFC functionality
  • Worked on Steelbrick and salesforce integration for automating, quoting, contracting, and billing processes
  • Worked with campaign managers to develop automated email campaigns and developed emails that could utilize Pardot dynamic content systems
  • Configured List Views, Custom Reports & Dashboard
  • Administered and monitored the company's Salesforce sales cloud application by creating the workflows for automated lead routing, lead escalation and email alert
  • Work with Asset Management marketing team, internal staff, and production team to plan and execute
  • Development cycle
  • Involved in running scheduled jobs which includes running daily reports, dashboards, and batch classes
  • Created Single Sign-on certificates
  • Experienced in the sales cloud, Community Cloud by adding objects, Fields, Tabs, Reports, and Dashboards and migrate data into Salesforce
  • Expert level skills in migrating components from one Sandbox to another Sandbox using ANT, Jenkins, Change Sets
  • Managed the overall flow of Salesforce automation process and successfully enforced a smooth build and deployment through the aid of tools like Jenkins
  • Apache ANT migration tool
  • Involved in moving metadata changes to different salesforce environments using the Copado tool
  • Check or troubleshoot salesforce for outlook calendar sync issues
  • Worked with the Developer team and IT Team to inform about the Salesforce new release
  • Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports and Dashboards
  • Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages
  • Created Record Types on Opportunities and Custom Objects
  • Created Email Templates, Workflow, Tasks, Email Alerts, Field updates and Process Builder
  • Created test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations
  • Created and managed User Roles, Profiles, and Role Hierarchies, Public Groups, Security Controls and Shared
  • Settings
  • Customized Applications, Page Layouts, Lookup Fields, Standard Related Lists, Tabs, and defined dependent Picklists
  • Used Data Loader for insert, update and bulk import or export of data from Salesforce Objects
  • Used it to read
  • Extract and load data from comma separated value (CSV) files
  • Environment: Saleforce.com platform, Apex Language, Visual Force Pages, Custom Component, Custom Controllers, Workflow & Approvals, Copado, Custom Objects, Custom Tabs, Page Layouts, Email Services, Security Controls, HTML, Web Services, Reports, Sandbox.

Salesforce Administrator

CVS Health
Buffalo Grove
09.2018 - 08.2019
  • CVS Health is the leading health solutions company that delivers care in ways no one else can
  • We reach people in more ways and improve the health of communities across America through our local presence, digital channels and our nearly 300,000 dedicated colleagues – including more than 40,000 physicians, pharmacists, nurses and nurse practitioners
  • Wherever and whenever people need us, we help them with their health – whether that’s managing chronic diseases, staying compliant with their medications, or accessing affordable health and wellness services in the most convenient ways
  • We help people navigate the healthcare system – and their personal health care – by improving access, lowering costs and being a trusted partner for every meaningful moment of health
  • And we do it all with heart, each day
  • Responsibilities:
  • Collected and evaluated business requirements, functional specifications, project schedules, documentation and test plans for Salesforce project and Sales and Service cloud module
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
  • Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing setting
  • Responsible for enabling network-based security and organization-wide list of trusted IP addresses
  • Worked on various salesforce NPSP objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports
  • Maintained and customized Service Cloud application
  • Apply existing knowledge of Salesforce Sales Cloud and Service Cloud to provide direction resolution for application, database or technical problems as identified in a case
  • Administered and monitored the company's Salesforce CRM application using workflow management
  • Involved in the maintenance of the previous versions of the product by addressing bugs and client issues
  • Responsibilities include defining integration architecture, documenting technical requirements, and identifying success criteria
  • Perform any sandbox refreshments and activities related to those refreshments as appropriate
  • Research and stay current on security and maintenance related items by utilizing Trust.salesforce.com or other pertinent sites and or tools
  • Responsible for processing month-end renewals, staging pre-renewal activities and generating accounts receivable billings
  • In-depth understanding of Salesforce.com’s Sales Cloud, Service Cloud and Force.com product offerings and
  • Health Cloud experience
  • Responsible for deployments using Copado packages in onsite location
  • Worked on prioritizing tasks across all their patients’ needs with a health cloud
  • Mapped personal and professional caregiver networks with salesforce health cloud
  • Used health cloud to integrate data from EHRs, wearables and more
  • Perform data cleanup and data manipulation tasks using data loader and any other third-party applications
  • Run appropriate exception reports to maintain data integrity
  • Responsible for the creation of Salesforce cases for issue resolution when appropriate
  • Perform Audit Trail monitoring as needed
  • Actively research AppExchange applications and be able to perform analysis on AppExchange solutions
  • Perform the necessary installation and configuration of any AppExchange solutions
  • Customized page layouts for Opportunity, Contacts, and Accounts depending upon user roles, and groups
  • Involved in integrating web service with SalesForce.com to load Leads back and forth from Salesforce.com to Legacy and vice versa
  • Developed and configured various Reports and Report Folders for different user profiles based on the need in the organization
  • Responsible for creating Sharing rules among all the users in Different Roles and Subordinates
  • Responsible for creating Queues, Workflows rules and tasks to share and automate work to the users in the Queue
  • Created unit test cases and coordinated change requests to drive the business requirements during Integration and Testing stages
  • Environment: Salesforce, Force.com IDE, Apex language, Copado, Visual forces, Apex Data Loader, Force.com platform, data.com, SQL Server 2005, Quality Center.

Salesforce Administrator

Scottline HealthCare
Houston
08.2016 - 08.2018
  • Used field level security along with page layouts to manage access to certain fields
  • Used field level security along with page layouts to manage access to certain fields
  • Involved in design, development, planning, testing, and integration of Salesforce cloud services
  • Integration with external systems using SOAP, REST, Bulk APIs
  • Integration of Salesforce Cloud with other AppExchange applications
  • Configured and maintained Salesforce.com based on business requirements
  • Worked on salesforce CPQ (Steelbrick)advanced approval rules and designed the feasible solution for consolidating all the rules based on the region and subregion metadata types
  • Performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com (SFDC) and using other Platform based technologies like Visual Force and Force.com API
  • Performed CPQ(Steelbrick) related configuration for product setup, approval matrices, approval rules, process builders and flows
  • Generated Revenue recognition status automatically with Steel brick CPQ(Steelbrick)
  • Deployment automation using CI/CD process for deployments using Force.com Migration Tool
  • Used Sales Cloud in Preparing and getting approval of design, functional and technical specifications from business
  • Used Platform based technologies like Visual force to provide UI to the custom objects
  • Used HTML tags, Frames and CSS (Cascading Style Sheets) to maintain uniformity in the Web page
  • Used Salesforce Lightning Components for building customized components replacing the existing one
  • Using JavaScript on the client side and Apex on the server side
  • Developed Apex classes, Visual Force Controllers and Extensions based on requirements
  • Developed applications visually using custom-built Lightning components
  • Worked with SOQL, SOSL queries to interact with the database in Apex transactions
  • Environment:
  • Salesforce, Force.com IDE, Apex language, Copado, Visualforce, Apex Data Loader, Force.com platform, data.com, SQL Server 2005, Quality Center.

SAS Programmer

Nyccos Software Solutions
Hyderabad
01.2010 - 12.2014
  • Nyccos Software Solutions provides a wide spectrum of software solutions
  • Nyccos develops and implements innovative software solutions to Healthcare, Medical, Hospital management solutions, Healthcare insurance, Pharmacy, and pharmaceutical companies
  • Nyccos also helps to develop product development and business solutions
  • Responsibilities:
  • Assisted and developed SAS programming and analysis support for Phase clinical
  • Used Dynamic Data Exchange (DDE) for importing and exporting of data from and into SAS, MS Access, and Excel
  • Performed Data Cleaning and Validation using SAS data step and SA S procedures
  • Produced summaries and statistics using PROC MEANS, PROC SUMMARY, PROC FREQ, PROC ANNOVA and PROC UNIVARIATE
  • Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets
  • And/or ASCII files by using Set and Merge for generating Reports and Graphs
  • Generated tables, reports, listings, and graphs including Patient Demography and Characteristics, Adverse Events, Laboratory etc
  • According to Statistical Analysis Plan (SAP) using PROC REPORT, PROC GPLOT for clinical Study Reports in compliance with 21 Code of Federal Regulations (21 CFR Part 11), ICH-GCP guidelines
  • Worked closely with Manager, Statistician in analyzing datasets and studying populations in electronic databases
  • Assisted in the development of Statistical Analysis Plans, reviewing study protocols and reports
  • Provided outputs for the Clinical Study Report (CSR)
  • Analyzed Adverse Event (AE) data using PROC FREQ
  • Created complex and reusable Macros and extensively used existing Macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation
  • Tested and debugged existing macros
  • Extensively used Data _Null_ and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and
  • Transpose for producing ad-hoc and customized reports and external files
  • Analyzed Adverse Event (AE) data using PROC FREQ
  • Created CRTs with datasets in Transport File Formats and Data Definition Tables for NDA submissions to FDA
  • Worked with CDISC data models including SDTM, ADAM
  • Develop new or modify SAS programs to load data from the source and create study-specific datasets, which are used as source datasets for report generating programs
  • Cross-Validated SAS programs authored by other SAS programmers as a part of QA (Quality Assurance) analysis
  • Used SAS ODS to create HTML, RTF and PDF output files in the process of producing reports.

Education

Master’s - computer and Information Technology

University of the Cumberland’s
KY, USA
01.2019

Master’s - computer science

Silicon Valley University
San Jose, CA, USA
01.2016

Bachelor of Technology - Pharmacy

Acharya Nagarjuna University
INDIA
01.2008

Skills

  • CRM Salesforcecom Administration
  • Users
  • Roles and Profiles
  • Standard Objects
  • Custom Objects
  • Custom Fields
  • Custom labels
  • Custom Settings
  • Custom Metadata
  • Email Alerts
  • Case Management
  • Reports
  • Dashboards
  • Analytic Snapshots
  • Assignment Rules
  • Escalation Rules
  • Import Wizard
  • Workflow Rules
  • Approval Process
  • Validation Rules
  • Sharing Rules
  • OMNI Channel
  • Portals
  • Salesforce CPQ
  • DocuSign
  • Field Service Lightning
  • Sandbox Configuration and Management
  • Sandbox Refreshments
  • Data Scrubbing
  • Deployments
  • Lightning Experience
  • Lightning Component Framework
  • Lightning App Builder
  • Lightning Connect
  • Lightning Flow
  • Lightning Process Builder
  • Lightning Flow Builder
  • Lightning Schema Builder
  • ETL/Integration Tools
  • Data Loader
  • Salesforce Inspector
  • Informatica Data Loader
  • Copado

  • Salesforce Developer Console
  • Eclipse
  • Microsoft VS Code
  • Salesforce DX
  • Version Control Tools
  • Git
  • Subversion
  • SDLC
  • Agile Methodology
  • Scrum
  • Waterfall
  • Operating Systems
  • Mac OS
  • Windows 10
  • Windows 8
  • Windows XP
  • LINUX

Certification

  • Salesforce.com Certified Force.com Administrator
  • Salesforce.com Certified Force.com developer

Trailblazer Account

https://trailblazer.me/id/mohanchandra

Timeline

Senior Salesforce Administrator

CareFirst, Blue cross Blue
10.2022 - Current

Senior Salesforce Administrator

DXC Technology
10.2021 - 10.2022

Salesforce Administrator

UPS Supply Chain Solutions
09.2019 - 09.2021

Salesforce Administrator

CVS Health
09.2018 - 08.2019

Salesforce Administrator

Scottline HealthCare
08.2016 - 08.2018

SAS Programmer

Nyccos Software Solutions
01.2010 - 12.2014

Master’s - computer and Information Technology

University of the Cumberland’s

Master’s - computer science

Silicon Valley University

Bachelor of Technology - Pharmacy

Acharya Nagarjuna University

Similar Profiles

CREATE PROFILE
Mohan Chandra Dronavalli