Eric Stephenson Email & Phone Number

Newark, De, Us

Plainsboro, New Jersey, Us

For a international life sciences medical healthcare company, designed a Jitterbit integration between Salesforce Territories & Microsoft SQL server. Documented & trained client support staff. - In Microsoft SQL server created fields, tables & views. Worked with Oracle Developer to ensure data was properly integrated between Oracle & SQL Server, so that combined data could be consumed by salesforce thru Jitterbit.- In Jitterbit connected SQL server & Salesforce. Created queries to Extract, Load & Transform data in source-to-target data mapping between 2 systems. Created script to query Active Territory Model from salesforce & used value in integration mapping. Created queries to restore backup & second Model to salesforce using script to substitute original SF ID for new territory ID. Created & migrated records between multi sandboxes.- In Salesforce, Determined solutions from root cause analysis for various load issues on Territory Management & related objects. Created cross reference table & flow to populate values.

Based on user feedback enhanced Attendance Tracker app for SalesForce AppExchange to:- Modified code to work with SalesForce Translation Workbench for all labels including on the Visual Force "update attendances" page so users can custom brand the managed package’s fields, tabs, record types and more.- Designed & developed features to enhance auto creation of “attendances” apex trigger, to use a related field, to control if the “present” checkbox field would be checked or unchecked.- Evaluated & determined Grid Buddy App as immediate alternative, until time permits to develop FieldSets in visual force; so user can add extra fields to the editable attendance grid. (EX: HR- hours present during week days, time in/out).- Updated customization guide with documentation for enhancements including customization for Time & Expense Management as some schools need to track daily student hours in class.- Built Visual Flow extension package to allow students to sign up register & enroll via a site.

- An Education, Training, Events & Media Company used Community, Lightning Sales & Service Cloud with large amounts of data.- Setup integration between Form Assembly & Salesforce using field mappings & integration connector. - For NovoEd Sync App, debugged OAuth integration & solution architected fixes. - Manually ran Batch Process using developer console for testing, use Workbench SOQL queries to find duplicate accounts & contacts created by integration, D&B, etc. - Used ServiceNow & Wrike for tracking issues, requirements discovery with stakeholders & providing ongoing support. Modified ServiceNow homepage & created reports on issues. - Test, found various issues, determined short/long term solutions. Issues like: records missing require lookup fields, records not being created due to process builder limit of 12 duplicate lookups in a batch, un bulkified code & batch process- Reduced 24 Process Builder nodes to single node using formulas to assign field values for Email–to-case Omni Channel routing to fix errors, optimize, & reduce complexity from a previous team. Combined several 1 node PBs to reduce Maximum CPU time & API time out for large data set & complex permission.- Evaluated Salesforce Health Check recommendations. - Practiced CI/CD & DevOps by releasing changesets from sandbox to live production. Prioritize & track road mapped backlog. Document AS-IS & TO-BE system changes - Trained users on Lighting reports & other features.

Rotterdam, Zuid-Holland, Nl

• Effectively doubled my heavy travel contract length at a large manufacturer, by proving my value to the replacement contracting company’s staff resulting in my competitors championing the need for my contract extension.• Mentored, trained, guided & worked with both clients & competitors.• Designed complex permissions on day of release when previous consults design failed. • Simplified migrations by designing salesforce as a data transformation tool.• Evaluated Salesforce Lightning limitations & made recommendations. • Used process builder to create working POCs with flexibility for modification & framework to store data, that could latter be replaced with permanent syntax coded solution to free up limited resources.

Teaneck, New Jersey, Us

• Set up Salesforce live chat agent & demo solution• Evaluated Salesforce Health cloud, determined solution to automate task creation on time line• Set up Salesforce Community Topics for Questions & Knowledge using Data Categories

Jp

Researched Salesforce 1 mobile app & made recommendations for Mobile Optimization. Maintain documentation by building upon & recommending the continued use of existing documentation of previous team mates, rather than starting over. Used Field Trip App to determine percentage fields use, collaborate with stakeholders to determine field meaning & usefulness.Create Actions Buttons for quick updates & record creation, by using fewer fields & Default Values for hidden fields. Based on mobile user feedback, guided developer to reuse backend Apex Classes & build new frontend mobile friendly Visual force to bring existing desktop features on mobile. All required fields & most used fields moved to top section, lesser used field moved to lower sections. Removed unused related list & fields.Created workflow rules using multi picklist values to update hidden fields to reduce fields on page & maintain existing integration. Used Process Builder to create related custom objects based on user picklist selections. To handle deleted related record without using a trigger, recommended redesign to replaced 3 workflow rules; with 1 complex field update workflow rule.Improved transparency for Channel Deal Registrations, enabled insight to channel health, and streamlined several internal processes relating to managing Deals. Reached out to stakeholders to validate & architect less complicated integration using leads, to avoid a number of issues that kept the project on back log for years. Leads avoids the need to map different products & Accounts in different systems; so that, if approved a Lead conversion would allow user to choose an equivalent Account & add Product. Reduced queries by CAT products into a single large field & used formulas to pull user data to lead, Since a Lead only needs to be approved, Outbound Messages handle integration updates of few lead fields, while remaining read only fields are updated by Sharepoint thru the API.

Somerset, Nj, Us

Working with a Global Real estate Client that is on-boarding & migrating 1000+ users from several different departments and locations, using complex permission structure and sharing•Advised for architectural decisions with Salesforce.com, Informatica, Data Loader and other ETL integration tools for automated migration strategy from large variety of systems. (Previously the company grew through acquisitions and Brokers can buy their own software like excel, Outlook, ACT, Salesforce, and anything else) Created POC (Proof Of Concept) batch processes using Data Loader command line (CLIQ tool), for scheduling export for backup & data warehouse. Recommend concatenating errors and unmapped fields in the large area field (description) in an effort to bring on 1000+ users from multi systems within salesforce field creation limitation and keep the org use able for all.•Researched and enhanced code to allow user to get around permission structure as part of an effort to clean up data. (Apex code can ignore permission structure)•Offered support, advice and recommendations, worked as part of a team, gathered requirements, interviewed users, streamlined onboarding process,•Determined sharing permission impacts for new & existing users. Recommended & enhanced manual sharing architecture of previous consulting company by introducing automated sharing permissions by first (for accounts, contact, opps) using Account Teams (No limit) and as needed second (Leads and other objects) combing sharing rules (limited to 500) with Public groups.•Determined how to handle domain knowledge members & non members sharing using Public Groups

Paris, France, Fr

Worked on a Financial Insurance project with a large team onsite & offsite, multi integrations, with lots of rules that needed to be validated without saving:- Helped client to understand & minimize risk. Recommended apps to improve SalesForce. Researched features & made recommendations. - Mentored team members and shared knowledge on SalesForce uses. Recommend best practices and solutions to both clients and team. Recommended a team member to perform a tasks. Reached out to team members to be included in scheduled discussions as needed.- Pushed for use of standard features to speed up design (in SF adding a table creates the CRUD pages, so drag and drop can be used to quickly edit page layouts). Convinced clients Leads to champion the use of standard features and screen shots for quickly understanding design change possibilities, so developers could focus on functionality instead of look and feel. Used standard features to mock up proposed solutions to demo before requesting development.- Looked into future requirements, which resulted in a discovery that required re-scoping, due to the SalesForce out-of-the-box feature not fitting the actual need. Discovered ripple effect, hidden by visual force, where system looked as if it was functioning properly but actually not storing data in correct fields.-Recommended Delaware's Blue Collar training program, which is a dollar for dollar match on training cost to save a lot of money on training call center staff.

As an analyst gathered requirements and brake them up in to use cases at function level so that several developers could "code blindly". Designed data base relation and frame work in language independent, leaving only syntax for the developers to figure out.Trained user on how to use the system I designed.Pushed for thylaksoft to save cost and time by adopting the use of package software, instead of building everything from scratch.Pushed for government projects using salesforce.With salesforce and force.com, it was often easier to customize myself then to pass on work to the development team, and simplified documentation could be used, and developer are still used when integration and non salesforce development.