Salesforce Admin & Data Cloud Consultant

Stephanie Rausch

Asheville, NC 828-***-**** ad8odi@r.postjobfree.com

SUMMARY

Salesforce Admin & Data Cloud Consultant known for transforming complex challenges into actionable business strategies that drive customer success and improve operational efficiency. PROFESSIONAL EXPERIENCE

Salesforce Data Analyst May - Aug 2024

Health Data Movers, Remote www.healthdatamovers.com

• Collaborate with Myriad Genetics data reconciliation team and data stewards as a Contractor for a data migration project.

• Analyze, de-dupe, and reconcile clinic location and provider data to prepare for EMR system location mapping.

• Recommend automations and process improvements to reduce manual workload by 30% (~40 hrs/mo). i.e. VLOOKUP to combine data, APIs to import data, Excel Office Script and Automate for repetitive tasks.

• Customize Salesforce reports to improve the reconciliation of account data in one view vs. multiple record views.

• Improve training documentation (including graphics) to ensure consistent processes and adherence to workflow rules.

• Coordinate with Staff to train new contractors and join the Data Clean Up Crew to improve and ensure data quality. Salesforce Administrator, Data Cloud Consultant, Tech Coordinator 2021 - 2023 Green Built Alliance, Asheville, NC www.greenbuilt.org

• Provide technical leadership in the selection and application of data management tools to connect a website CMS and Tableau to a Salesforce CRM (NPSP, Sales Cloud, Service Cloud, Program Management, Data Cloud) via API.

• Transform business operations and streamline operational efficiency by 50% using Salesforce to clean, import, & centralize data, improve reporting, track fundraising campaigns, and automate manual repetitive processes with Flow.

• Eliminate client paperwork by customizing Salesforce Mobile App for off-site digital data entry and DocuSign capability.

• Establish best practices for security and procedural protocols of logins, Google Workspace, and staff turnover.

• Improve Volunteer membership by 500% through improved Website SEO strategies, incentives, and local partnerships.

• Maintain data integrity through customized user profiles, rules and permissions, and detailed training documentation.

• Customize lightning page layouts, record types, opportunities, dashboards, campaigns & program engagements.

• Setup Web-to-Lead forms with lead assignment rules and List View Queues customized for different Programs.

• Combine 4 complex websites and fragmented marketing efforts into 3 key marketing messages on 1 website.

• Encourage pull vs. push semantics and Website/Email analytics to facilitate data-based decision marketing initiatives.

• Ingest profile/engagement data into Data Cloud to eliminate Anonymous data and unify profiles by 49%, test data quality, and deliver actionable customized marketing strategies through calculated insights and segmentation.

• Create Tableau visualizations of key data within interactive charts to improve & prepare for AI data-driven insights. Owner, Project Manager, Web Designer/Developer, Business Coach & Presenter 2008 - 2021 Evolv LLC, Asheville, NC www.evolv.com (domain sold)

• Provide strategic website consultation and project management for hundreds of website/enewsletter clients.

• Collaborate with well-known local non-profits, artists, business leaders to large scale member-based Associations.

• Implement all marketing, accounting, and management of 1-5 employees for evolv.com with 1st page Google results.

• Develop the UX of Data.gov (v1) for President Barack Obama’s administration through Phase One Consulting.

• Provide project management of clients and staff for a digital marketing partner called HighRoad Solutions.

• Present, coach, and train businesses on SEO & digital marketing for Mountain BizWorks, SCORE, and conferences.

• Facilitate and craft an Enterprise Architecture plan for Wolfe Inc and FEAC Institute using the Zachman Framework to centralize data with backups, define critical business gaps & measurable expected outcomes with detailed documentation. Creative Director, Project Manager 2005 - 2007

CommPartners LLC, Columbia, MD & Missoula, MT www.commpartners.com

• Gather client requirements, make recommendations, & manage projects for large association-based clients.

• Lead a team of 5 employees and utilize SalesForce to track communication and project initiatives with clients.

• Design and develop hundreds of enewsletters with extensive testing and troubleshooting multiple email services. EDUCATION

Salesforce Admin Certificate (April 2024)

Data Cloud Consultant Certificate (Nov 2023)

Enterprise Architecture Course - completed, FEAC Institute Certificate in Graphic & Digital Design, Maryland Institute College of Art (MICA) Bachelor of Science in Mathematics Secondary Education, University of Maryland at College Park SKILLS

• Salesforce Expertise: Salesforce Admin, Data Cloud, Sales & Service Cloud, NPSP, Flow, Dashboards, Lightning App Builder, Data Loader & Data Import Wizard, Program Management, Mobile App, Volunteer App, Gcal Sync

• Technical Skills: Tableau, Tableau Prep (ETL), HTML/CSS, APIs, ANSI SQL, LucidChart, Jira, WordPress, Membership/LMS systems, SEO, Adobe (Photoshop, Illustrator, Acrobat), Microsoft Office, Google Workspace

• Leadership & Management Skills: Excellent verbal and written communicator with the ability to translate technical information into layman’s terms, self-starter, ability to multi-task and adapt to changes quickly, positive “can-do” attitude, extremely detail-oriented and graphically talented, strong Project Manager, inspiring Presenter, Meeting Facilitator, Partnership Collaborator

• Analytical Skills: Data Analysis, Gap Analysis, Documentation & Procedural improvements, Requirements Gathering, Reporting, Enterprise Architecture Frameworks and diagrams including Operational Models, Activity Models, Systems Scenario Sequence Diagram, Data Contextual Models, Data Logical Models, ERD (Entity Relationship Diagrams), Business Node Connectivity Chart, Systems Comparison Matrix.

• Languages: Intermediate German

LEADERSHIP & EXTRACURRICULAR EXPERIENCE

Energy Savers Network Board Member

10x State Champion and Top 5 Nationally ranked in Track & Field and Cross Country during High School. Student-Athlete at Penn State and University of Maryland for two years. Founder and leader of S.E.A.M (Students Educating About Mind-Control) at University of Maryland College Park. Runway model, soccer player, painter, gardener, wood artisan, carpenter, hiker, mentor, and homesteader. 10+ years of Volunteerism as Citizens’ Climate Lobby Chapter Leader for Western NC.

– Provided the strategic vision for the WNC District that encouraged two House Representatives to join the Conservative Climate Caucus and to cosponsor several bipartisan legislations.

– Written several Opinion Editorials and presented to multiple Rotary and other business interest groups.

– Co-Lead a national Brewery Climate Declaration initiative that secured over 200 brewery endorsements

– Secured 100+ climate endorsements from farmers, solar companies, realtors, and a variety of other businesses.

– Met with City Council members in seven WNC towns to encourage adoption of Climate Action Plans; two were successful in 2023 while five more are in progress for 2024.

– Planned and led multiple face to face lobby meetings and a Farm Tour with 3 Congressmen in-district and Washington DC.

– Led volunteer recruitment and engagement for our Chapter and for the Grasstops Engagement National Action Team. Stephanie Rausch

Asheville, NC 828-***-**** ad8odi@r.postjobfree.com

Dear Hiring Manager,

I am grateful for the opportunity to apply for your Salesforce Admin or Data Cloud position. As a strategic creative thinker, patient listener, and effective communicator I have a unique ability to break down complex issues into innovative elegant solutions that are sustainable, scalable, and effective. For most of my career, I have spent consulting with clients on the intricacies of Web Development, UX, and Digital Marketing to small and medium-sized business owners through my business Evolv LLC. However, my time spent strategizing AND implementing these solutions helped me to realize the value of business analytics tools like Salesforce, Data Cloud, and Tableau as well as Enterprise Architecture principles. I am humbled by the many diverse job opportunities (small and large) that have taught me the valuable lessons I needed to learn. As a business owner for 10+ years I learned how to manage employees, clients, with standardized procedures and comprehensive training documentation. In my last two roles at Green Built Alliance and Health Data Movers, I transitioned to Salesforce-oriented roles focused on improving efficiency and business processes through centralized data systems, workflow automations, ensuring data quality, and detailed training documentation. In many cases, this required cleaning and reconciling old data, customizing page layouts and record types, utilizing dashboards and reports to confirm data discrepancies, setting up consistent structures/workflows, and transitioning staff from manual to digital or automated data entry using Mobile Apps, Flows, or Excel Automate tools. However, during these large transitions I learned that having a change management strategy with clear vision, benefits analysis, and proper training is key for successful adoption. My most memorable work experience was working for Phase One Consulting Group (acquired by Accenture) as a subcontracted UX designer. During the first 90 days of President Obama’s Administration, we had to implement the first iteration of Data.gov to centralize government data into a public searchable online database. My drive and genuine interest in solving business problems has enabled me to thrive in most environments, and I owe a lot of my inspiration and insights to my Enterprise Architecture training and owning a business for many years. Because of these experiences I adapt to change very easily and am most inspired by teams that embrace innovational change. If you give me the opportunity to join your company/organization, I promise to help your business make data-driven decisions that drive innovative growth and improve customer satisfaction. Sincerely,

Stephanie Rausch

Contact this candidate