Core services team

Maps, data ingest platform - Release Automation

• Drove the release process and quality of publish/storage services for the launch of Business Connect (https://businessconnect.apple.com)

• Designed a unified marketing data platform by using Snowflake and Python to combine sales lead (Salesforce) and marketing (Google Analytics and LinkedIn Ads) data streams, enabling Sales and Marketing teams to collaborate using a singular reporting platform

• Developed a company-wide networking app that matches random pairs of employees every week for coffee chats

• Worked with security engineering and IT teams to integrate newly purchased tools into the internal data analytics platform

• Wrote ETL procedures in MySQL to sanitize and normalize data streams from multiple sources into a single data mart

• Automated the ingestion of sales campaign performance metrics, migrating from manual CSV uploads to hourly automated SQL transactions for executive-facing dashboards

• Developed T-SQL queries to automate the sanitation of healthcare provider data, eliminating the need for manual data entry

• Designed a data warehouse for the intake of field operations data from Salesforce, enabling operations teams to track the growth of their clinical trial outreach programs