Andrew Troemner Email & Phone Number

Indianapolis, Indiana, United States

Atlanta, Georgia, Us

- Developing cutting-edge AI & ML capabilities for customer success and operational efficiency- Implementing LLM and NLP API's through OpenAI for entity resolution detection across multiple conflicting source systems for web browse data, accounting for common abbreviation changes, spelling changes, or typos- Prospect scoring of most valuable contact opportunities for prioritization

Indianapolis, Indiana, Us

- Consulting with clients implementing Salesforce Customer Data Platform (CDP) applications- Integrating multiple data sources into a single source of truth- Resolving data quality issues of reliability & consistency- Personalization & marketing journey strategy- Statistical analysis for optimizing demographic targeting- Strategy for using AI/ML products for messaging, like SFMC Einstein or Interaction Studio for propensity scoring, send timeliness, and product recommendations

Chicago, Illinois, Us

- Building innovative AI & Machine Learning-as-a-Service products in the Digital Marketing space- Product recommenders using collaborative filtering techniques- Send Time Optimization as a native integrated email application- Expert Portal ML-as-a-Service for sophisticated clients- Engineered in-house ML build & deploy pipeline for turnkey automation

San Francisco, California, Us

- Developing and deploying ML solutions for product recommendations, image recognition, propensity modeling, chatbot dialogue trees- Consulting directly with clients to evaluate marketing program health & identify opportunities for improvement- Producing market segmentation studies to identify messaging challenges- Combining client-side CRM data with email response data to prove how email drives sales success- Extracting raw database information using highly efficient SQL queries, pulling regularly from tables with hundreds of millions of rows- Performing statistical analysis on 10+ GB datasets, combining from multiple systems across different customer data models- Developing Python data-mining applications to get rapid insights from across a sharded database structure of 90+ servers

Indianapolis, In, Us

- Supported & administered Prophet 21, an Epicor ERP- Developed software extensions in C# and TSQL to allow dynamic item order replacement & cycle through obsolete parts- Developed SQL reports through SSRS and Crystal Reports for critical business data- Maintained SQL data through scripted imports and order data audits- Performed Jr. DBA server tasks (database replication, backup restoration, data integration)- Wrote administrative scripts in Python and PowerShell for data cleaning and integration alerts- Helped to manage Electronic Data Interchange (EDI) transmission

Indianapolis, In, Us

- Predicted grant utilization using SPSS and Microsoft SQL Server database analysis tools, reducing forecast error by 65%- Built data dashboard of managerial KPI's- Developed program evaluation metrics to recommend changes to under-performing programs- Assembled statistics for public reports & surveys- Constructed ad hoc SQL data queries and statistical summary tables to support policymakers

- Drafted literature reviews and grant proposals- Edited research papers to prep for publication- Reviewed empirical statistical results

Graduate Studies In Business, Finance, Marketing

Master Of Science - Ms, Economics

Ba, Economics