Arun K. Email and Phone Number

First Project:• Establish a connection with objects from Salesforce Environment.• Use CSV files to create new datasets to be used on the Dataflow and Dashboards.• Create a Dataflow with connected objects and create new fields upon necessity within dataflow.• Create a dataflow that provides a snapshot of the data on daily basis.• Create daylight savings time difference and multiple time zone time conversion on dataflow.• Use the datasets created to build components and widgets on the dashboard.• Build multiple dashboard pages, added toggle functionality for easier navigation between pages.• Schedule the dataflow at an interval which does not overlap with existing Dataflows to reduce the run time.• To create lenses and Dashboard components using the datasets created from dataflow and store them on Apps which are accessible by various groups as per necessity. Second Project:• Consolidate multiple existing dataflows into one dataflow.• Create new security predicates for each dataset so that the end users have access to limited records.• Create Date/Time conversion from GMT into EST for consistent reporting purpose.• Created new Dataflow, Datasets, and Queries• Created advance level widgets using custom SAQL queries combining multiple datasets.• Recommended changes on Salesforce side to have uniformity in the record.• Successfully conducted Knowledge Transfer to the current IT team to troubleshoot any issues.

• Establish a connection with objects from Salesforce Environment .• Create a Dataflow with connected objects and create new fields upon necessity within dataflow.• Use the datasets created to build components and widgets on the dashboard.• Build multiple dashboard pages, added toggle functionality for easier navigation between pages.• Schedule the dataflow at an interval which does not overlap with existing Dataflows to reduce the run time.• To create lenses and Dashboard components using the datasets created from dataflow and store them on Apps which are accessible by various groups only.

On Salesforce:• To create new fields/objects as required on the Environment.• To create custom report type to create reports into Native Salesforce Env• To create Native Salesforce reports using the report types• To create process builder to fill/update the fields on the salesforce.• To create workflow rule to fill/update the fields and the salesforce.• To create Dashboard and components on Salesforce Lightning Env using the reports created• To create a new tab and components on Lightning page On Einstein Analytics:• Create a connect with salesforce and with marketing cloud to access different data.• Send the data from social studio into salesforce to be used for Einstein Dashboard.• Create Multiple Dataflow and Datasets which later would be used to create dashboards and components.• To create lenses and Dashboard components using the datasets created from dataflow and store them on Apps which are accessible by various groups only.• To filter out records while building dataflow which are not relevant to the dashboard page that we are creating.• To show various revenue trend for various Area and Accounts and include a functionality to be able to take actions in other words drill down on a record to its salesforce record page.• To custom bind all the datasets for easy use of global filters across all dashboard pages and unbind some filters to work on only one page• To use standard OOTB period filters which is user friendly and bind with all the widgets from all datasets.• To write SAQL to bind multiple datasets for smooth operation of the dashboard.• To add custom widget filters like Top 10 Growers and Decliners, product revenue and Total Accounts that added value from a functionality point of view.• To Created various Native Salesforce reports to do a data validation.

• To Develop Einstein Data Flow which connects with salesforce, marketing cloud and data queries using MuleSoft connector.• To create lenses and Dashboard components using the datasets created from dataflow and store them on Apps which are accessible by various group of users.• To create a formula field that calculated the revenue in company currency using the provided exchange rates.• To work on POC of the dashboard using a CSV files while another team work on the MuleSoft connector• To review the Data Mapping Traceability Matrix and determine the source of data to feed on our dashboard.• To add a global filter on the dashboard that works throughout many pages and at the same time customize certain filters to only work on certain pages.• To create a dashboard that shows revenues on different currencies from different country and summarizes the revenue in one company wide accepted currency.• To provide the status on shipments details, what are the planned order amount, the status of the orders.• To provide a visualization which shows the trend on the growing/declining revenue and take actions from the dashboard. • To provide a visualization which shows the trend on the growing declining orders and opportunities and take actions from the dashboard.• To provide the revenue, order, and opportunity status on an item level detail with accuracy• Created and reviewed documentation required for production release and support.