Darren Kowitt Email & Phone Number

Legacy MySQL Mobile Sales Rep App Migration to Salesforce Maps and Partner Community.Evaluated legacy use cases and data model in MySQL,, determined which tables needed to be migrated in their entirety, partially or not at all, and developed Salesforce schema and data transformations to get test data set into User Acceptance Testing sandbox using Skyvia Synchronizations and Replications.

Washington, District Of Columbia, Us

Advised applicants to top MBA programs on school selection, career visioning and the art of self-presentation in application materials.

Tampa, Florida, Us

Project 1: Behavioral Health Network Provider Onboarding Process Reengineering. Form Assembly SME.Project 2: Lead Process Implementation in 1,600 seat Health Care (but not Health Cloud) org using manifest-package-based AzureDevOps CI/CD.

New York, New York, Us

Tasked with converting ad hoc period-specific Dashboards and Reports into a scalable, filterable set of dashboards for Senior Leadership & Board audiences, this project required understanding how data has been historically logged and used, developing interim analytics assets utilizing the current schema and proposing schema changes to optimize staff usage and reporting.

Austin, Texas, Us

Provided end-to-end consulting services for clients seeking to enhance their Salesforce orgs or migrating from Raiser's Edge to Salesforce, NGO Connect to NPSP and NPSP 2.x to 3.x and EDA Higher Education and K-12. Experienced in working with Pardot and Marketing Cloud specialists to troubleshoot integration issues.Used these Platform Tools for metadata tooling & migration:SFDX & Visual Studio CodePostmanChange SetsWorkbenchFlowDoc HerokuUsed Apex Data Loader and Dataloader.io for Insert, Upsert & Delete JobsUsed MS Access with SF Connector for data manipulation & ETLPower Salesforce Flow developer for complex business logic, and experienced in using flow trigger explorer to develop Upon Create and Upon Update 'hub flows' that use decision logic to call sub-flows for actions that change data. Sophisticated and judicious expertise in adding capabilities from Unofficial SF.com. to meet client requirements.Expert in using Dynamic Related Lists and Dynamic Forms to create app- and profile-specific highly articulated & tailored Lightning Record Pages to support users in executing upon their responsibilities.Experienced in integrating with key NPSP ecosystem vendors such as Zapier, Classy, FormStack, Form Assembly, Form Titan, Wealth Engine, IATS, Blackthorne Events and Twilio.Experienced in Discovery & Requirements Gathering, Solution Development, Validation and UAT using Full, Partial Copy and Developer Pro sandboxes. Implemented Salesforce Partner SDOs for Sales Demonstrations. Key Projects IncludeNational Kidney Foundation NGOC to NPSP Migration (15 month project for 225 seat org with 1.7 million constituents)Kirkwood Community College EDA & Student Success Hub Implementation & IntegrationVGH Foundation Data Skew & Flow Automation OptimizationBRIC Raiser's Edge to Salesforce NPSP MigrationBrother Rice School NPSP 2.x Household to NPSP 3.x

Washington, District Of Columbia, Us

Certified Salesforce Administrator & Platform App Builder; Podio Developer implementing custom schema enhancements, automations and integrations viia Salesforce Flow, Apex triggers & classes, Globiflow and code-less integration platforms such as Zapier, Integromat and Workato.

Costa Mesa, California, Us

Implemented a notification system for ancillary sales process staff, whose roles did not justify the expense of a full Salesforce license. These staff were originally represented as values in the Lead Source picklist. Created a custom object to represent these staff in automations in Salesforce Flow and Power Automate. Any update to a lead with a lead source value in this set would trigger automations that presented the change and notified the ancillary staff member. Version 1 used a Chatter Free licenses and a collaboration group, but limitations in the functionality of Chatter Free lead us to implement the system in SharePoint using the Salesforce connector to monitor the Lead History table for new rows, then copy the lead data to a SharePoint list in a Private M365 Group and then send an email via Outlook/Exchange to invite the user to inspect the change.

Ortenberg, Baden-Wuerttemberg, De

• Leapfrogged from Cirrus insight email synchronization to Einstein Activity Capture.Product, Opp-Line Item & Quote Line-Item Hierarchy Automations Project• Product2 Table had 1,800 entries. Main configurable product offering: 15 advanced biochemical sample readers ranging in price from $8,000 to $95,000. Developed hierarchy grouping complex product offering of advanced biotech laboratory instruments (the core offering units ranged from $8,000 to $95,000 and these that have many configurations, replacement parts, and consumables.• Used Magic Mover to convert and archive 25,000 notes and attachments to Modern Notes & Salesforce Files.• Deployed MyDomain, guest user access and other release updates as required by Salesforce.• Security Enhancement Project• Org originally had 12 users with high security risk system permissions, and no 2-Factory Authentication.• User Perm Comparator and Permission Helper to define two baseline profiles for all users. Service needed its own so as to be able to share an organization-wide email address, • Hubspot Lead Integration & Rep Governance Project• Developed Process Builder and Flow Builder flows to take raw lead data from Hubspot and run assignment rules on leads.• Troubleshot integration problems and presented findings to Hubspot team in Germany. Deck here.• Worked with stakeholders to develop requirements for sales rep service level expectations and implemented dereliction automations when reps were not living up to their responsibilities.• Reps would receive a dereliction warning email 1 business day and 2 business days after being assigned a lead. After 3 business days, the VP of Sales would get a custom notification about the behaviorservice@bmglabtech.com.• Worked with senior stakeholders to develop permission set groups to grant least privilege access needed by specialized or senior staff.

Summit, Ms, Us

Grapevine, Texas, Us

Fernwood , Mississippi, Us

Provided Outsourced Salesforce Admin Services to a Manufacturer Advanced Organic Building Materisals.Ported pricing from Excel sheet to Salesforce-enabled flow automations.Implemented approval processes for Quote governance.Configured Einstein ActionsCreated channel-specific price books with appropriate discounts and volume assumptions to justify the discounts.Tailred Quote PDFs to be on-brandCreated custom metadata for use in calculating cost of goods based upon injection molding volumesVetted QuickBooks integration offerings

Producing data migration mappings after debating with my colleagues about the requirements and the design choices between origin fields and how Salesforce might best instantiate the data. Then, after agreement is reached, defining objects, page layouts, lightning record pages, app pages and flows to conforn on a biweekly agile spring.

El Segundo, Ca, Us

Outsourced Salesforce Administrator experienced in large-scale data migration for for-profit enterprises and Salesforce Non-Profit Edition stand-up engagements.

Minato-Ku, Tokyo, Jp

Conducted social media strategy and CRM strategy workshops with the founder to create a framework for for evaluating social media campaign effectiveness, and tracking leads resulting from said efforts.Drafted fresh web-copy for a re-branded re-launch of the company's English-language site.

Collated prospective donor information from Executive Director's files.Performed ETL on data for standardization and import into Salesforce.Implemented workflows to streamline data entry and management.Integrated Salesforce.com NPE with ConstantContact for constituent communications.Conducted training as needed to staff during Salesforce.com stand-up and TJC launch gala.

Evaluated historical usage of system to serve as a point of departure for taking Salesforce.com tenant to the next level. Facilitated "blue sky" Salesforce.com platform potential use cases & visioning so as to develop an agile system road-map. Identified and trialed AppExchange offerings to meet needs identified in the history & visioning. Partial list includes LinkedIn, RedHot News, Skuid, Former Positions, Field Trip & Smartsheet Project Management.Created custom fields and objects to align the database more closely with the CEO's evolving vision. Created record-type schema to support user page layouts that are streamlined to use cases associated with that user role. Furthermore, enhanced the field groupings & related list display properties in SysAdmin "comprehensive" page layouts designed to facilitate SysAdmin tasks & troubleshooting. Implemented role and hierarchy-based sharing policies.Created demonstration materials for Salesforce.com Content, Content Deliveries and a demonstration case to show how Chatter participation will benefit the organization . Set up non-licensed staff with Chatter Free licenses.The company uses a license server to authenticate users as to: Product & version License term (time-bounded or perpetual) Installed node properties Trial v. PaidLicenses and other customer-specific documentation (consulting proposals, deliverables & T&E documentation, etc.) were stored in a DropBox directory that was “human maintained” – i.e. subject to mis-spellings, mis-filings, and other errors that invariably accumulate around the margins. Undertook data exploration and creative spelunking to match licences to appropriate records in Salesforce (Accounts, Primary User = Contact, and Invoices).

Washington, District Of Columbia, Us

Migrated alumni club data from locally stored spreadsheets to the Salesforce.com and Google Apps cloud. Tested various vendor offerings for additional fucntionality (email campaign analysis; geocoding of residential and employer data; online collaboration among volunteers; hosted video of club events so as to spur membership and create publishing value).Also developed live event programming ideas and sourced professors from Columbia to lecture or to moderate panels with subject matter specialists of varying views. Organized panels onMBAs in GovernmentMBAs in Government ContractingGovernment Relations: Career & Citizen PerspectivesHow to Work with An Executive RecuiterThe 2008 Crash: What the Mortgage Data was SayingThe F(e)iner Points of LeadershipWhy Do Good People Do Bad Things?Developed fundraising strategies and met with alumni according to a moves management program to advance the club's agenda.

Las Vegas, Nevada, Us

Taking clients through a coaching methodology that helps them to discern for themselves their reasons for applying to a top-tier MBA program, followed by helping them to craft essays & other application materials that effectively convey this self-awareness to the Admissions Committees in question.

St. Louis, Missouri, Us

Coached clients on how to develop an MBA Gameplan and applications strategy for the portfolio of business schools to which they applyTranslated that game plan into strategically sound approaches to responding to each school's different essay question configurationHarvested suitable anecdotes from clients and ranked them in terms of fit with strategy and mediagenic/halo effectsEvaluated early drafts to offer structural sequencing of argument, followed by sentence and word-level edits so that the final product was both measured in tone, vivid and free from self-serving arguments

Washington, Dc, Us

Analyzed a large scale improper payments recovery simulation run in a Treasury Offset Program “sandbox” database environment that sought to match debts owed by citizens to various state agencies within a portfolio of pilot states and federally funded state social programs servicing various vulnerable populationsThe Sandbox sought matches on Taxpayer Identification Numbers (TIN) between approximately 44MM federal payments totaling over $115 BB and a debt portfolio with an aggregate value not far shy of $400MM spread across about 325,000 constituent debtsAnalyzed summary aggregate data for the $300MM+ worth of debts submitted by pilot states and the results of the simulation, which ran prospective IRS refund and OPM and a select subset of Social Security payments against the debts in the pilot portfolio (all of which had been certified so as to address due process concerns)Used basic statistical analysis techniques, coupled with select attributes of debts that matched against a payment, to model intermediate state changes in the composition of the pilot portfolio, to look for trends and to posit hypotheses as explanationsDeveloped end-to-end process maps for from state agencies submitting debts through database match processConducted sensitivity analyses under various strictures and relaxations of policies to assess the impact on potential collection yields that such policy changes --- ultimately to be used in crafting new legislation – might have on various social-services beneficiary populationsUsed difference between one annual tax refund payment and 12 monthly OPM and SSA support payments to devise dynamic portfolio segments and to model the by-month and by-year histograms of how long it would take each debt not extinguished by its first matching offset to be paid in full.

Washington, Dc, Us

Developed business case justification, end user use cases, test use cases and testing kits for integrating data feeds, ETL and initial load-up for multidirectional sync feeds between legacy contact database with 100MM constituents and advocacy and online fundraising platforms with 10MM constituents.Developed custom objects and workflows in Salesforce.com so as to skirt the API call limits & time outs of reporting within the web interface and yet extract multiple columns and objects within a 7MM row advocacy constituent table. Used Apex Dataloader (22) and CRM Fusion People Importer for mass upload, up-sert, deletion and extracts across various ad-hoc ETL processes.Devised testing plans to validate the critical break/fix had been repaired, and went to vendor for testing sessions within the SAAS firewall, developing recommendations in response to data malformations found, and iteratively moving testing results to acceptable cost/benefit levels.Surveyed multi-channel business users to development functional requirements for integrated campaign planning and business intelligence platform in MicroStrategy. Documented findings in both Visio and integrated with 7 level Enterprise Architecture maintained in MetaStorm ProVision 6.2Ran quarterly feeds of c-4 fundraising from Convio Online Marketing for export into Merkle Money Maker. ~$1MM across 40,000 small transactions.Developed internal support bureau processes to centralize Education & Outreach' webinar efforts on the On24 platform, and developed requirement for developing feeds from the On24 DataMart to AARP Insight pscyhographic DB (Netezza)Used MS Access coupled with string-to-hexadecimal function to identify unique SFIDs in two legacy segments of 2.4MM rows for deletion so as to reduce cloud computing expenses.Developed MS Access modeling tool to identify and categorize error types in a mass of 100,000 errors from initial loading.

Monitor the organization's finances, membership marketing activities, and preparation of the form 990.Attend monthly board meetings and implement financial decisions reached therein.

Washington, Dc, Us

Providing outsourced DBA services and a remediation plan to unlock Raiser's Edge's full capabilities for supporting a moves-management-system-based high-touch philanthropy program at an organization whose strengths are direct mail, direct response TV and web/social networking.

Conducted a strategic review of the operations and funding model of Capital Partners for Education a DC-area non-profit (mission: CPE changes lives. Capital Partners for Education helps students attend private high school and go to college. We know our students can achieve great things — once the right doors are opened. We can help — by providing mentoring, academic support, and enrichment opportunities. A central part of our students’ success is a concerned and active CPE community of parents, mentors, schools, alumni, and donors.) Built model for backing strategic recommendations vis-a-vis funding and expanding into Charter Schools in DC>

Work with the Fund's board to maximize revenue and devise managerially actionable reporting sctructures for tracking individual giving and corporate/foundation relations programs.

Washington, District Of Columbia, Us

Maintaining the donorbase and developing segmentation strategies to deliver more revenue from donor need insights.

Innsbruck, Tirol, At

Developed a Campaign/Appeal/Fund coding schema to remedy ad hoc coding that hindered like-to-like year-over-year comparisons.Coded time normalized reporting to analyze face-to-face contributions as a function of relationship length (versus absolute date)Identified pattern of face-to-face donors who withdrew early and used this evidence to secure refund from face-to-face fundraising vendor

New York, Us

Consultant to the Director of Planned Giving ProgramDeveloped integrated MSAccess-Word automated system for campaign reply processing of 130,000 piece planned giving mailings with over 400 replies. Integrated system with PGCalc charitable annuity software to automate the process of creating annuity proposals for donors.System shortened response processing from 10 to 2 minutes per inquiry, generated accountability with time-stamping and by-user QA, and reduced reporting time from 4 days to instantaneously

• Business Development: Closed deals and ensured successful transition between project phases & contracts. Personally closed $180,000 in contracts.• Customized statements of work for client projects, and coordinated with client-side legal department to obtain client-side signatures.• Performed project & system scoping, functional requirements documentation and functionality prioritization.• Engagement Team Leader for New York Presbyterian Hospital/Perioperative Services

Mba, Marketing

B.A., History

469 Badges, Https://Trailblazer.Me/Id/Dkowitt