Randy is available for hire
Hire RandyRandy Yu
Verified Expert in Engineering
Salesforce Architect and Developer
Location
Atlanta, GA, United States
Toptal Member Since
September 25, 2021
Randy is a 12x Salesforce certified heavy-duty developer and hands-on architect proficient in declarative data modeling, flows, processes, Marketing Cloud, Experience Cloud, and CPQ. He's an accomplished full-stack Salesforce programmer with expertise in LWC and Aura development, as well as server-side Apex, SOQL/SOSL programming, and SFDX CLI. Randy specializes in Salesforce ETL, data integration, and UI/UX design with LDS. He's a people person with superb communication skills.
Portfolio
New York Stock Exchange
Salesforce, Salesforce Apex, Aura, Lightning Components, Salesforce SOQL/SOSL...
Home Depot
Salesforce, JavaScript 6, Salesforce Apex, Aura, Lightning Components...
IBM
Salesforce, Salesforce Apex, Salesforce SOQL/SOSL, Aura...
Experience
Availability
Part-time
Preferred Environment
Salesforce DX, Salesforce SOQL/SOSL, Salesforce CPQ, Salesforce Apex, Aura, Lightning Components, Lightning Design System
The most amazing...
...projects I've delivered reliably are mission-critical Salesforce projects for clients like New York Stock Exchange, Home Depot, IBM, Google, and ICE.
Work Experience
Senior Salesforce Developer and Architect
2020 - 2021
New York Stock Exchange
- Managed full SDLC using agile and scrum methodologies with two-week sprints and iterative multi-phase projects with frequent product releases. Used Jira for sprint management and GitHub for source control. Communicated with business stakeholders.
- Wrote custom LWC components using SLDS CSS styling and async JavaScript ES6 programming with Promise. Accessed server-side Apex classes through imperative calls and wire adapters.
- Developed integrations using Apex callouts and REST web services to communicate with external systems hosted in Google GCP and AWS Virtual Private Cloud (VPC). Implemented OAuth2 authentication protocol with Bearer tokens.
- Conducted SOQL performance tuning with indexes and highly selective filters. Analyzed query plans used by Salesforce query optimizer. Replaced SOQL statements with SOSL in search contexts.
- Architected and coded an enterprise-wide Trigger Framework that allows multiple project teams to develop and deploy in the same org. Tackled trigger recursion issues.
- Identified and resolved data skews (lookup skews) and concurrent transactions to eliminate "too many SOQL queries: 101/201" errors and row-lock exceptions. Used "publish immediately" and "publish after commit" platform events to isolate transactions.
- Designed and coded asynchronous future methods, batchable, queueable, and schedulable jobs for bulk data processing. Utilized daisy-chaining to achieve near-real-time data synchronization.
- Worked within Salesforce governor limits, including per-transaction limits, async limits, thread concurrency limits, SOQL, and DML operation limits.
Technologies: Salesforce, Salesforce Apex, Aura, Lightning Components, Salesforce SOQL/SOSL, Lightning Design System, Salesforce DX, Salesforce CPQ, Field Service Lightning, Salesforce Sales Cloud, Salesforce Service Cloud, Salesforce Marketing Cloud
Senior Salesforce Developer and Architect
2019 - 2020
Home Depot
- Cleansed the codebase to prevent SOQL injection vulnerabilities. Advocated binding parameters and escapeSingleQuote method in dynamic SOQL statements.
- Called Salesforce Bulk API 2.0 both from external integrations (Java and MuleSoft) and from within Apex code to ingest or retrieve large quantity of records while circumventing SOQL and DML limits.
- Utilized SFDX unmanaged package, unlocked package, Ant Migration Tool, Workbench, and change sets for metadata deployment.
- Developed a custom Lightning component for CRM apps and community clouds with LWC, Aura, Apex, SOQL, and DML.
- Worked with SFDX projects in Visual Studio Code. Used SFDX CLI commands to create scratch orgs from the Dev Hub Org. Conducted source-centered development with Git local repository and Bitbucket remote repo.
Technologies: Salesforce, JavaScript 6, Salesforce Apex, Aura, Lightning Components, Lightning Design System, Salesforce Sales Cloud, Salesforce Service Cloud, Salesforce CPQ, Salesforce SOQL/SOSL, Field Service Lightning
Senior Salesforce Developer and Architect
2018 - 2019
IBM
- Designed UI and UX with custom CSS, SLDS, LWC, and Aura component libraries.
- Built customer and partner communities in Experience Builder, gaining knowledge on different types of community user licenses.
- Configured audiences, page variations, and component visibilities for different profiles, authenticated users, and guest users.
- Performed large-scale Salesforce data migrations utilizing MuleSoft and Java for Apple, Airbnb, Expedia, and Red Cross.
- Imported Salesforce CRM and community objects and maintained parent-child relationships like Lightning Knowledge articles with comments and files, chatter feeds and comments with attachments, and community users with matching contacts and accounts.
Technologies: Salesforce, Salesforce Apex, Salesforce SOQL/SOSL, Aura, Lightning Design System, Lightning Components, Salesforce DX, Salesforce CPQ, Salesforce Sales Cloud, Salesforce Service Cloud, Field Service Lightning, JavaScript 6
Senior Salesforce Developer and Architect
2012 - 2018
CoStar Real Estate Manager
- Implemented SAML-based federated SSO for communities. Set up handshake between Salesforce and clients' existing Identity Providers such as IBM Cloud Identity and Okta.
- Configured connected apps for OAuth 2.0 external clients that access Salesforce APIs with the client ID, client secret, and access token (bearer token).
- Coded Apex callouts and configured named credentials and auth providers for authentication by external OAuth 2.0 providers such as Google Cloud Platform.
- Engaged clients and project owners infrequent communications on requirement gathering and change management. Managed business stakeholders' expectations.
- Carved out significant effort in educating business owners to ensure executive buy-in of the Salesforce platform.
- Implemented MuleSoft data integrations for large client organizations such as Facebook, JP Morgan Chase, Citibank, Bank of America, and Coca-Cola.
- Provisioned users for community memberships through profiles and permission sets. Configured a community's sharing sets, share groups, and sharing rules. Assigned community managers and moderators.
- Worked with Lightning Data Service (LDS) to access back-end sObject records without custom Apex code.
Technologies: Salesforce, Salesforce Apex
Senior Software Engineer
2007 - 2012
PwC
- Developed an ASP.NET web app in C# with Web Forms and MVC, with SQL Server 2008 on the back end.
- Built a Java Spring Framework web application with Hibernate as a data access layer.
- Programmed in SQL using complex stored procedures and functions.
Technologies: Salesforce
Senior Java Developer
2002 - 2007
Hewlett Packard Enterprise
- Developed web application security vulnerability detection software, now called HP Fortify application security suite.
- Built an application that screens for vulnerabilities in websites using static code analysis and by launching a pre-determined set of penetration tests.
- Detected a broad range of hacking tactics, including SQL injection, cross-site scripting, and buffer overflow.
Technologies: Salesforce
Experience
NYSE Equity Market Real-time Data Service App
This is a mission-critical equity and fixed-income service Salesforce app used by floor traders, investment bank clients, internal electronic traders, and customer support center staff.
Spearheaded the rigorous business requirement gathering process through brainstorm sessions with internal and external trading partners. I created a technical design document that spelled out the out-of-the-box functionality configurations, as well as custom LWC components and Apex classes. During the implementation phase, I coded nightly and near-real-time Apex batch jobs for data synchronization with external systems. On the front end, I developed Lightning Web Components with Salesforce Lightning Design System CSS styling.
The app went through stringent QA testing and performance benchmarking. After that, a series of user acceptance tests were carried out with our primary business stakeholders. The project was completed on time, within budget, and exceeding the client's expectations.
Spearheaded the rigorous business requirement gathering process through brainstorm sessions with internal and external trading partners. I created a technical design document that spelled out the out-of-the-box functionality configurations, as well as custom LWC components and Apex classes. During the implementation phase, I coded nightly and near-real-time Apex batch jobs for data synchronization with external systems. On the front end, I developed Lightning Web Components with Salesforce Lightning Design System CSS styling.
The app went through stringent QA testing and performance benchmarking. After that, a series of user acceptance tests were carried out with our primary business stakeholders. The project was completed on time, within budget, and exceeding the client's expectations.
CPQ Sales Pipeline Salesforce Project with NYSE
I worked on declarative tasks, including data modeling, flows, and validation rules. My main job was on Apex, SOQL, SOSL, LWC (JavaScript ES6+), and Salesforce Lightning Design System CSS. I acted as a hands-on and heavy-duty Salesforce developer and architect for CPQ, Community Cloud, Marketing Cloud, Sales Cloud, and Service Cloud.
Skills
Languages
JavaScript 6, Java, CSS, Apex
Frameworks
Lightning Components
Tools
Salesforce DX, Lightning Design System, Salesforce Sales Cloud, Salesforce Marketing Cloud, Salesforce CPQ, Field Service Lightning
Platforms
Salesforce SOQL/SOSL, Salesforce, Amazon Web Services (AWS), Google Cloud Platform (GCP)
Other
Salesforce Apex, Aura, Salesforce Service Cloud, Customer Success, Communication, Team Leadership, IT Project Management
Paradigms
Agile Project Management
Storage
Microsoft SQL Server
Education
2010 - 2012
Master's Degree in Business Administration
Georgia Institute of Technology - Atlanta, GA
2001 - 2003
Master's Degree in Computer Science
Georgia Institute of Technology - Atlanta, GA
Certifications
DECEMBER 2021 - PRESENT
Salesforce Certified Marketing Cloud Email Specialist
Salesforce
DECEMBER 2021 - PRESENT
Salesforce Certified Marketing Cloud Administrator
Salesforce
NOVEMBER 2020 - PRESENT
Salesforce Certified Application Architect
Salesforce
SEPTEMBER 2020 - PRESENT
Salesforce Certified JavaScript Developer
Salesforce
JUNE 2020 - PRESENT
Salesforce Certified Platform Developer II
Salesforce
FEBRUARY 2020 - PRESENT
Salesforce Certified Platform Developer I
Salesforce
APRIL 2019 - PRESENT
Salesforce Certified Data Architecture and Management Designer
Salesforce
MARCH 2019 - PRESENT
Salesforce Certified Sharing and Visibility Designer
Salesforce
JANUARY 2019 - PRESENT
Salesforce Certified Community Cloud Consultant
Salesforce
DECEMBER 2018 - PRESENT
Salesforce Certified Administrator
Salesforce
DECEMBER 2018 - PRESENT
MuleSoft Certified Developer (Mule 4)
Salesforce
SEPTEMBER 2018 - PRESENT
Salesforce Certified Platform App Builder
Salesforce
MARCH 2018 - PRESENT
AWS Certified Solutions Architect
Amazon Web Services
MAY 2017 - PRESENT
Microsoft Certified Azure Developer
Microsoft
JULY 2015 - PRESENT
Certified Ethical Hacker (CEH)
CEH
JANUARY 2010 - PRESENT
Chartered Financial Analyst (CFA) Level 2
CFA
JANUARY 2006 - PRESENT
Project Management Professional (PMP)
Project Management Institute (PMI)
JANUARY 2005 - PRESENT
Microsoft Certified Solutions Developer
Microsoft