Mega Migration Project: Dynamics to Salesforce Cloud for DHS USICS

I’m pleased to announce that I’ve started as a Salesforce Admin & Junior Developer for many-month migration project for a rather DC-heavyweight client: US Department of Homeland Security’s US Immigration & Citizenship Services.

E-Verify – Put into Place in the late 80s to keep employers from hiring ineligible workers.

USICS consists of approximately 19,000 federal employees and contractors working at 223 offices around the world.

https://en.wikipedia.org/wiki/United_States_Citizenship_and_Immigration_Services

About 500 of them work in call 3 centers tending to the case management and efficient stewardship of the process of naturalization, and verifying that US citizens are legally authorized to work by virtue of that citizenship..

The E-Verify program I’m working on produces Employment Authorization Documents (EAD) for would-be employees seeking to prove that they can be hired legally. And Salesforce will be helping those call agents at every step of the way.

While I wait for my Public Trust Security Clearance

I can’t personally log in to any system with production data in it. So I spend my sprints vetting/validating field mapping documents, and getting into spirited and healthy debate about what real world situation is being modeled, and what are the best data types to use — you know the sameness-but-strongly-different fault line that often cleaves software targeting the same markets & domains. And then, I can that the results of our debate and appropriately tool the metadata of Salesforce to house first testing data, and then by the time there’s production data, I’ll have my Clearance.

That’s it for now.

Sleuthing Office 365 Sway Viewing

Screebsgit

In general, Office 365 Admin tools make me feel 7 feet tall. When I publish a Sway embed in WordPress, I get viewing notification emails from Azure Active Directory (AAD). I’m not surprised that the viewer is anonymous – requiring authentication would drive my “I’m outta here” bounce rate up.

If you want content viewed, don’t put up any more obstacles than are necessary.

Still, because the notification didn’t tell me which Sway was viewed, only the fact that there had been a Sway viewing — it wasn’t a perfectly satisfactory state of affairs. Until I happened to notice a link in the notification…

Search the Audit Log for this Item

ss of Azure Activity Audit
Clicking through on the audit log….

Here, where you get a link that identifies which Sway.

Security And Compliance Screenshot

So it looks like I need to hit the documentation and start building up a more robust if still imperfect analytics understanding.

ss
Click the image to visit the DOCS site. I know I will.

Trusty Apex Dataloader

A client of mine in Education Services is uploading a large amount of data published by NYS Department of Education about some 7,000 schools & hierarchical entities related (Districts, Charter Schools, Charter Operators) in NY State.

A few more similarly granular objects to go…

The ETL professional in me likes large numbers. But the SF Admin in me is wondering about a performance hit. Also, hoping to upload this to an Enterprise org I have with Einstein Analytics licenses for the soothing transformations when selecting subsets of the data. Stay tuned.

Einstein Analytics Data Import

We still have a few more child objects off the account to go, and I’m wondering if this is a good case for using Big Objects or an external data source. Suggestions welcome!