MarketSource Inc.Salesforce Business Analyst - Axalta Coating Systems Program
Jul. 2017 - Oct. 2018Alpharetta, GA Problem: Lead Generation reps were using the Opportunity object to create top of funnel Leads. Opportunity Pipeline was 63% at Stage 1 Prospecting and Opportunities did not progress through the funnel. Solution: Led Requirements Gathering session with Sales Managers and Directors. Based on findings, created a New Lead Business Process with Stages that captured the previously un-documented stages of the Distributor vetting of these New Leads. Communicated requirements to Developer for creation of a Flow.
Problem: Sales Director wanted a report to learn which customers could only be reached by voicemail each cycle. Solution: Led a Requirements Gathering Session with Sales Director and Sales Managers. Decided on two new fields: Last Live Contact and Unsuccessful Reason picklist field. Created these two fields, and a related validation rule. Communicated requirements to Developer to write a Trigger to update the Last Live Contact field based on the value of the Unsuccessful Reason field. Built a List View for the reps based on Last Live Contact greater than one cycle.
Worked with Project Manager, Business Stakeholders and IT Department to communicate and continually clarify requirements, assign incremental development tasks among team, test, troubleshoot and approve for release.
Build new features in dev box and write testing scripts, trouble shoot errors and approve for release.
Created Lightning Custom Pages and Consoles after gathering preferences from Users.
Declarative Salesforce Programming including: workflow rules for field updates and email notification, build processes with Process Builder, set field level security and page layout assignments, create custom fields including formula fields, changed page layouts, created validation rules, permission sets, sharing rules and email templates.
Direct a small team of Jr. Data Analyst on data matching projects between Salesforce and external databases.