My second internship came at the end of my sophomore year and was with First National Bank of Omaha which is one of the largest privately owned banks in the world. My role with them was development regarding ETL and data transformation, particularly between SQL, Informatica, and Salesforce.
The team that I worked on was responsible for data loads into Salesforce, which acted as the primary CRM for the company. Every night, tens of millions of records would be upserted into our Salesforce records.
I wrote several workflows and mappings that transformed, filtered, or mitigated security issues within the data.
This gave me a fantastic look into how enterprise data is handled, as well as how change management happens in a large organization.
FNBO had rigorous testing in place to ensure that production changes were vetted before being deployed to users.
One of my favorite projects that I worked on was the nullification of credit card numbers that were input into insecure forms.
I used Apex, Salesforce's Java-based language, to scan each form and check for any valid credit cards via the Luhn Algorithm ↗. If the numbers were valid, I used Regex to remove the first eight characters and then pass that last four into our database.
To ensure that my changes were without fault, I created over forty unit tests which provided 100% code coverage. These tests checked for possible security issues and failure points.
