Solutions Engineer
CurrentSalesforce development and data management are my main roles. I create policies for data management, formulate techniques for quality data collection and implement procedures for data handling, analysis and support.• Salesforce development: Design, build, test and implement solutions using workflows, triggers, Visual Force, APEX, Batch APEX, JavaScript, Conga ActionGrid and Lightning Apps. I researched and provided solutions for our transition to Lightning. I built out the Campaign module and added functionality to create mail files and created a Lightning App to scan returned mail using a barcode reader.• Designed and created forceExcel, an Excel VB app with Salesforce connectivity. The app compares multiple spreadsheets, Salesforce reports and Word tables to each other and cleans, analyzes and finds duplicate data. It's primarily used for cleaning and deduping lead lists and integrates with the SmartyStreet API, an address verification website. It's also used to analyze client purchase data.• Designed and created Autom8te, a programmable Excel VB app that automates bulk repetitive tasks in Salesforce that can't be achieved using Workflows or APEX. Use Cases: Automate the process of attaching Customer Information Records to accounts which increased productivity by 80%; Automate the Salesforce Weekly Export backups by downloading multiple export files to a specific location; Automate screen scraping to create lead lists. • Write Visual Basic scripts for statistical analysis of trading data• Lead generation using Dun & Bradstreet's Hoovers database, Mozenda's web-scraping tool and wrote VB macros to scrape leads• Used DemandTools to upload leads and perform mass updates• Designed and implemented an Excel VB app to improve Quality Assurance procedures for users entering new contracts in Salesforce• Analyze data sets to maximize asset recovery for Fortune 500 corporations• Competitor analysis and research