Shawn Clark Email & Phone Number

Minneapolis, Mn, Us

• Responsible for the architectural oversight of 24 Global Salesforce Instances across 18 Operational Units, supporting over 30,000 Global Users• Developed CRMA analytics and security hub on Core360 governance instance, enabling COE to centrally monitor key metrics of org health, such as: security, license utilization, adoption rates, adherence to standards, and more. This intelligence ensures that Medtronic's Salesforce investment remains secure and is maximized to its full potential.• Conducted in-depth platform utilization and contract analysis, identified opportunities for the organization to save millions on unused or under utilized license. • Managed the migration to SSO with Multi-factor app authentication to all instances, insuring adherence to most secure authentication patterns• Developed a framework of excellence for regional instances by deploying 20 Salesforce Playbooks, which define standards and best practices on many key topics, including: DevOps, Security, Integration, Backup and Restore• Executed on many key Force.com technology rollouts including: Health Cloud, Experience Cloud, Lightning Dialer, CRMA, QUIP, Copado, Bitbucket, custom LWC/Aura/Apex, Salesforce Connect (Cross Org & OData 4.0), Integration (Platform Events, Legacy ETL, Zero ETL, API), and Data Cloud

Minneapolis, Mn, Us

• Lead Developer/Architect for Med Surg Regional Instance, managing 4 offshore developers, and running metadata review and release management for all User Stories within the Org• Build Integrations using Informatica ETL, as well as with Salesforce Connect (Cross-Org & Odata 4.0)• Delivered Innovative and award winning custom solutions using LWC, AURA, VF, Apex, Flows, and maybe other Code-based and Declarative solutions• Implemented Copado on MedSurg Instance, which would later be adopted as the Medtronic standard for DevOps CI/CD platform• Manged the migration from Salesforce Classic to Lightning and the rollout of SSO• Executed on multiple Org consolidations, mergers, and migrations required to handle acquired companies, divestitures, and re-orgs.

Minneapolis, Mn, Us

• Supported, Enhanced, and Expanded functionality of complex 6,500+ user Salesforce.com Org • Serve as Primary Technical Architect responsible for successful roll-out of Salesforce in LATAM • Develop infrastructure, documentation, and customizations required to support an Extended Delivery (EDM) development model for Salesforce• Supervised off-shore resources responsible for completion of Data Integration and Case management• Architected a series of integrations, objects, and applications using Informatica Cloud, Visualforce, Apex, LWC, Aura Lightning Components, Flows, External Objects, Cross Org connector, OData 4.0, Salesforce Connect, CRMA, Maps, Health Cloud, Quip, and other Force.com development tools to optimize and automate business processes.

Minneapolis, Mn, Us

Maintained, supported, and vastly improved the Varicent Sales Compensation applicationWorked closely with Business users to gather requirements, design, and develop technical solutions to handle complex sales commission requirementsLeveraged my advanced Business Intelligence background and skills to replace an outdated reporting system with a vastly improved and secured SSRS 2008 environmentUsed highly proficient SQL tuning skills to re-write several complex calculations, lowering nightly runtimes by over 50%.Developed complex SSIS packages to integrate Varicent with Salesforce.com and several other systemsRedesigned SQL Server to Oracle SSIS integration, improving transfer speed by 99%Developed detailed documentation and organization around technical processesServed as a mentor/trainer to developers in EMEA and the US, providing technical training sessions on topics such as: T-SQL scripting, SSIS, & SSRS

Brooklyn, Ny, Us

Work directly with CFO/CEO to identify business trends, opportunities, and areas of potential growthDesign and execute A/B Split testing to identify effective emailing campaigns and user preferencesDefine member cohorts to track, analyze, and compare spending habits of usersMaintain a secure and organized SQL Server Reporting Services dashboard, which empowersemployees to make quick and accurate business decisions based on meaningful KPI’sDevelop simplified, visual, and accurate reporting solutions using SSRSManage automated daily, weekly, and monthly metrics subscriptionsLeverage strong communication and business skills to translate business needs into reporting and engineering Provide end-user training to increase awareness, adoption, and understanding of available business intelligence solutionsAssist DBA/developers/QA by developing advanced T-SQL queries for custom data extracts, bug monitoring, solutions, serving as a liaison between developers and managementand detailed analysis of data quality

Enfield, Ct, Us

Provide 24/7 support for SQL Server 2000/2005 production and development databasesDevelop and automate key performance reporting metrics working directly with General ManagerGenerate complex ad hoc SQL queries to provide quick and accurate data extractsMaintain, configure, customize, and document Laboratory Information Management System Implemented well-planned disaster recovery policies and procedures for high availabilityDesign and maintain views, stored procedures, triggers, and indexesTroubleshoot performance issues using DTA, SQL Profiler traces, and PerfmonUtilize strong communication skills to translate business needs into technical solutionsProvide hardware/software support and training to internal users

Us

Assisted internal and external users with development and fine-tuning of custom SQL queries Designed and executed monthly update of Cognos CubePlanned and directed efficient group training sessions on using online reporting softwareGenerated custom reporting metrics for management using advanced Excel macros and functionsCreated multifaceted client queries using Sagent Design StudioPerformed extensive quality assurance testing on corporate dataFormulated intelligent solutions to a wide range of tech support issues