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 populations The 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 debts Analyzed 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 explanations Developed end-to-end process maps for from state agencies submitting debts through database match process Conducted 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 populations Used 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.
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.2 Ran 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.
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.
Maintaining the donorbase and developing segmentation strategies to deliver more revenue from donor need insights.
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
 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
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 on MBAs in Government MBAs in Government Contracting Government Relations: Career & Citizen Perspectives How to Work with An Executive Recuiter The 2008 Crash: What the Mortgage Data was Saying The F(e)iner Points of Leadership Why 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.
Coached clients on how to develop an MBA Gameplan and applications strategy for the portfolio of business schools to which they apply Translated that game plan into strategically sound approaches to responding to each school's different essay question configuration Harvested suitable anecdotes from clients and ranked them in terms of fit with strategy and mediagenic/halo effects Evaluated 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
MBA
Concentration: Marketing
B.A.
Concentration: History
Darren Kowitt is an avid fan of the French baroque (Atys, Platee) and also of early music and the Monteverdians of Italian city-states. He seems forever to be investing in upgrading components in his Martin Logan (Vantage) and Cambridge Audio home theater -- a passion/illness for which perhaps the neighbors have not yet forgiven him.
Social Networks