*Update 5:45 PM pacific:*
We are still seeing slowness in our testing so we are not able to confirm
that the issue has been fully resolved. However, with Umesh's help we now
have a backup plan for getting the data loaded tomorrow morning to meet the
payroll team's 8am pst deadline.
The next update email will be at 5:30 am Pacific tomorrow morning.
Thanks,
Monica
On Mon, Nov 25, 2024 at 3:17 PM Monica Johnston <johnstonm@thekey.com>
wrote:
> *Update 2 PM pacific: **We believe that we have identified the root cause
> of the slowness and resolved it but need to do a test first to confirm.
> That test will be done this afternoon once we have sent all the files to
> Netsuite. Our goal is to confirm that this is resolved today so that there
> will be no impact to payroll tomorrow morning.*
>
> *Analytics Portal / Tableau Reports: *All Tableau and Analytics Portal
> reports have been refreshed
>
> *Billing: *Almost all of the files have been sent to Netsuite.
>
> *Payroll: *Today's data updates have been pushed to Workday.
>
> Thanks,
> Monica
>
> On Mon, Nov 25, 2024 at 12:07 PM Monica Johnston <johnstonm@thekey.com>
> wrote:
>
>> Update 11 AM pacific: We have finished loading the data from Wellsky. The
>> team is working on researching the root cause and we have engaged with our
>> Google partner SHI to try and get a permanent fix for the slowness.
>>
>> *Analytics Portal / Tableau Reports: *Reports are currently refreshing.
>> ETA is 2-3 hours.
>>
>> *Billing: *Netsuite files are being generated now.
>>
>> *Payroll: *Today's data updates have been pushed to Workday. *There is a
>> big risk here for a delay to payroll if we have the same issue tomorrow
>> morning.*
>>
>> On Mon, Nov 25, 2024 at 9:31 AM Monica Johnston <johnstonm@thekey.com>
>> wrote:
>>
>>> We have not yet finished loading the Wellsky data into the data lake.
>>> Our download of the data ran longer than usual today and we are
>>> investigating the root cause. There is no ETA yet.
>>>
>>> *What is the Impact?*
>>>
>>> *Analytics Portal / Tableau Reports: *SoCs, billed hours, revenue,
>>> active client / caregiver counts and other numbers related to Clearcare
>>> will still reflect yesterday's totals.
>>>
>>> *Billing: *Data related to any shifts that may have been finalized
>>> yesterday has not yet been sent to Netsuite.
>>>
>>> *Payroll:* Data related to any shifts that may have been finalized
>>> yesterday has not yet been sent to Workday.
>>>
>>> We will keep you updated.
>>>
>>> Thanks,
>>> Monica
>>>
>>> BCC: Executive team, Sales Leadership, Regional Directors, Tableau
>>> Desktop Users, Payroll Notifications, Billing Alerts, Marketing Dept,
>>> General Managers, BDCorp
>>>
>>>
>>> --
>>> Monica Johnston
>>> Director, Data Platform and Services
>>>
>>> johnstonm@thekey.com <https://brand.thekey.com/esg/johnstonm@thekey.com>
>>> (602) 501-7890
>>> TheKey.com <https://www.thekey.com/>
>>> [image: TheKey] <https://homecareassistance.com/>
>>>
>>