Fawn Rice Email & Phone Number

Alpharetta, Ga, Us

Los Angeles, California, Us

Dublin 2, Ie

Developed sales and marketing analytics reports and dashboards to provide actionable insights that support data-driven decision-making for management teams.Built ad-hoc custom reports and dashboards for sales meetings and forecasts with Salesforce, Google Sheets and Power BI.Crafted data stories through presentations, written summaries, and data visualizations that accurately outline problem statements and provide actionable and unbiased intelligence and recommendations.Participate in defining, documenting, and implementing sales processes.Identify, investigate and resolve challenges to existing business processes to support a seller-focused sales environment by reducing administrative lift.Analyze seller behavior, efficiency, and effectiveness to properly align sales processes, workload, and seller capacity with sales goals/metrics.Gathered and documented business requirements, functional requirements, and design specifications. Planned and executed User Acceptance Testing (UAT) and training with business users.

Alpharetta, Georgia, Us

Work with the Program Directors to define KPIs, analytical requirements, build the solution, provide prototypes, test for quality and ensure the analytics meet the requirements and support overall business goals.Use a heavy daily mix of Salesforce and Excel to analyze performance data and provide on-going reports & analytics. Prep and clean client data. Create data maps using Dataloader and import data into Salesforce while identifying potential process and/or implementation issues that may cause reporting irregularities or data integrity issues.Create and maintain Salesforce and Power BI or Tableau reports and dashboards for clients, managers and reps, including exception reports to proactively identity areas of risk.Modify Saleforce instances after program launch to better fit business process including creating objects and fields, modifying pages and setting up automationWrite and document business requirements, functional requirements, and design specifications. Planned and executed User Acceptance Testing (UAT) and training with business users.

Utilized ETL tools for the procurement of distributor and master data files and GPO reports and extracts. Created technical and business documents via data maps and technical/business SOP processes documents. Provided operational support to sales data analyst team. Analyzed Distributor and Manufacturer Data and created reports and scorecards utilizing Excel, SQL and Power BI. Conducted UAT for conversion to new system. Company was recent bought out.

Atlanta, Georgia, Us

Analyzed global $3B Salesforce funnel data and created executive summary for VP of Sales. Created weekly funnel reports and ad hoc reports for sales and marketing managers. Created NCR’s first annuity forecasting model based on the sales pipeline data, win-close rates and lead times. Position moved off shore.

Analyzed call center data and processes for the United States Army IT Help Desk. Effectively translated information into reports and presentations to communicate results to senior management team in easily understandable format to “tell the story” of how operational changes impact KPIs and SLAs. Designed and maintained monthly call volume forecast. Created ad hoc and routine reports using SQL, SQL Server Reporting Services (SSRS), ITSM Remedy 7.6, Right Now Web (RNW), Microsoft Excel/Access/PowerPoint and Verizon Virtual Contact Center (VCC). Compiled data from disparate sources to create daily scorecard. Maintained Secret Security Clearance.

Created SharePoint portal with dashboards and reports for senior leadership team to have transparency to trial marketing activities, details and results. Documented process and provided user training.

Analyzed distributor point of sales data and created sustainable reports to track indirect sales to end users in their vertical markets to identify gaps and potential opportunities. Created brochures, websites other marketing functions for Siemens power distribution product managers.

Munich, De

Responsible for project management and implementation of large and small scale cross functional projects for the VP of Channel Management.• Defined business and technical requirements, process work flow, for new online co-op promotional funding reimbursement application. Successfully outsourced audit and payment processing. Managed project plan, vendors, budget, roll-out and communication plan. Created reports to track success of the initiative. 1,200 Distributors, 400 sales engineers, • Created and maintained Siemens first distributor marketing resource guide including onboarding process, corporate policies and procedures relating to warranties, returns and rebates.• Launched annual sales incentive program including data analysis, program design and budget modeling, online enrollment, vendor and creative management, print, distribution other and related marketing communicationsBusiness Systems Analyst 1998 – 2004 • Gathered and defined business requirements and technical from distributors, sales engineers, business units, and other stakeholders for Online Customer Service e-commerce. Wrote technical specification including process flow and wire frames. Performed quality assurance and user acceptance testing. Set up test cases, performed and assisted users in UAT.• Managed VMI (Vendor Managed Inventory) program for 12 distributor including onboarding new distributors, processing files and managing exceptions.

Bachelor Of Business Administration, Economics

Mba