Salesforce Administration and Development for a Amazon's Global Sales Advertising Unit 4,000+ users working together to create all advertising on Amazon.com

Participated in the execution of an end to end billing system designed an delivered in 5 weeks. Integrating Twitch's Salesforce org with Advertising's billing solution.

Salesforce Administration and Development for a Commercial Real Estate Mortgage company 335+ users, 29 offices, ~$8B in originations, and ~$26B in loan servicing AUM. We "Re-Org'd" to a brand new Org with a complex ERD (Entity-Relationship Diagram) design accommodating loan origination and servicing edge cases. Transitioning all legacy code, data, and SF solutions (APEX, Process Builder, Flow, Workflows, Approvals) while reformatting to the new ERD.

Helped build-out and hire an internal business IT team assisting in the transition from a previously external team. We grew the team from 6 to 20+ while delivering extreme value to the business through Salesforce automation and data centralization.

Led the Marketo implementation/integration with Salesforce and Marketo MSI (Marketing Sales Insight) to serve cross-department teams; Created efficiencies in communication between Sales & Marketing while making Salesforce the system of record for Marketing campaigns.

Nintex DocGen implementation to create massive efficiencies in document (Excel & Word) generation; substantial time savings while increasing platform adoption with 15+ custom packages. We digitized formerly paper-based CRE loan origination and servicing processes while centralizing data entry & document creation within Salesforce.

Contributed to the planning and architecture of a cloud database to merge multiple data sources for complex reporting & planning using PowerBI. This project circumvented some native Salesforce deficiencies to become the 'source-of-truth' for a centralized operational business database.

Implemented and utilized RingLead for deep data cleanup of 10,000+ records and proactive duplicate prevention.

Utilized a wide array of tools to manage projects and ensure data integrity including RingLead, SpringCM, JIRA, Confluence, Rally, WorkBench, VS Code, Dev Console, Sandboxes, DLSR, VS Code, DataLoader, Xappex XL-Connector, and others.

Closed ~$141,000,000 in transactions, over five properties in Manhattan, and the Bronx. On a two-person team that showed over $700,000,000 in multifamily properties while highlighting value-add opportunities to clients.

Created and rolled out a custom Salesforce application designed to streamline the investment sales brokerage process and facilitate closed deals. MapAnything, Ebsta, and Outlook integrations.

Coded custom Python web scrapers designed to find commercial real estate companies resulting in 10,000 leads interested in purchasing property.

Created a machine learning regression model that was trained on public NYC property data in order to assign a predicted price to all 50,000+ commercial properties.

Conducted market analysis, comprehensive underwriting, business plan creation, and initial site selection for a ~$35M Kosher Food Hall.

Hired and managed two junior brokers while providing them leads through the Salesforce.com platform.

Created and effectively ran Google PPC AdWords campaigns and Facebook Ad Campaigns for lead generation and as a seller feature resulting in ~$270,000 in closed transactions.

Used CartoDB to create visual heat maps from various kinds of City of Cincinnati building permit and license information to drive lead generation | View the heat map.

Analyzed and constructed buyer portfolios for out of state investors interested in the Cincinnati area | View some underwritten properties.

Used MLS, Auditor’s website, LoopNet, RPR, and City’s condemned house list, to geocode and analyze potential houses as rehab candidates.

Supported realtor and developer goals in site selection for on-going sports complex project in Lebanon, Ohio.

Provided rehab analysis, coordination, advice, and secured a buyer for out of state investors.

Submitted approximately 90 contracts for an institutional investor in a two month period.

Ran multiple social media accounts for an agent, myself and our real estate team for client retention, information, and generation.

A 492-unit apartment community in the suburb of West Chester, Ohio. This was my first job in high school and a unique opportunity to work at a heavy value-add property. Major improvments were made over a multi-year period including large-scale earthworks, building rehabilitation, and unit renovations. The owners exited via a sale to Colorado's Monarch Investment Group for a significant profit.

Responsibilities:
Maintained occupancy Excel and Yardi reports.
Provided Customer Service to current and prospective residents regarding availability, amenities and work order status.
Oversaw & assisted with general building maintenance.
Led tours of apartments with prospective residents.