Diane Hallgren Email & Phone Number

Charlotte, North Carolina Area

• Work as part of a team to quickly and accurately cleanse chassis move data for the Domestic pool while adhering to business rules.
• Create and complete assigned reports on a timely basis.
• Exceed daily targets while achieving accuracy goals.

Tampa, Florida

• Supported the sales organization by creating standardized reports on sales information to track attainment of growth objectives, defined and tracked qualitative sales metrics.
• Performed maintenance on leads and customers in Salesforce by adding new leads submitted or updating existing leads or customers per company guidelines.
• Created a macro enabled Excel file to extract the monthly commission for each independent sales consultant from a master file, save it in a new file, and then create and email it to the sales consultant. This.
• Performed ad hoc analysis for staff in various departments and roles.

Zephyrhills, FL

Charlotte, North Carolina Area

• IT Data Analyst IV at Bank of America (Contract Position)Working in support of Bank of America’s Identity and Access Management initiative to reduce risk associated with access to bank information.
• Conducted online training sessions to instruct applications teams in how to complete the Third Party application validation process.
• Performed QA on Third Party Application validation templates and assisted application management teams with revisions to templates not in formation for testing.
• Facilitated the submittal of templates for testing and the communication of test results to application teams.
• Manage and enhance reporting to varying levels of staff.
• Transforming validation efforts into repeatable, sustainable process.

Charlotte, North Carolina Area

• Contract position working in support of Bank of America’s initiative to implement a process to calculate the monthly accrual for outside counsel fees.
• Participated in the design of the accrual process.
• Designed and developed an Access database to process the accrual monthly.
• Back tested the data from the database against the manual version that was previously used.
• Documented the new process and trained staff.

Charlotte, North Carolina Area

• Worked as part of a team utilizing Java and various web tracking tools to quickly and accurately cleanse chassis move data at various marine terminals in support of transition to a new reporting platform.
• Consistently exceeded daily targets while adapting to changing priorities.
• Worked collaboratively with other team members to identify data issues that could be addressed programmatically to expedite the cleansing process.

Charlotte, North Carolina Area

• Supported the Director of Logistics and other members of the logistics team for a major snack food manufacturer:
• Updated standard reports and created ad hoc reporting for the logistics department ensuring that all reports were accurate and delivered in a timely manner.
• Automated repetitive processes to increase efficiency of resources.
• Presented information on key initiatives at weekly meetings with supply chain staff.

Charlotte, North Carolina

• Worked as part of a team developing and implementing a process to manage software and hardware computing assets company-wide. Responsibilities included:
• Obtained and normalized data from multiple sources for upload to external management tool.
• Automated processes for ease of future updates.
• Wrote documentation for the process.

Hickory/Lenoir, North Carolina Area

• Responsible for creating, editing and scheduling Cognos reports for internal and external clients. Created and maintain custom client reports using client and in-house data. Performed data validation to investigate.
• Reconciled data between accounting and transportation management systems using Microsoft Dynamics GP and MercuryGate Edge.
• Provided one-off process automation solutions for other departments using Microsoft Access and VBA for Excel.
• Created customized reporting packages in support of obtaining new clients.

Charlotte, North Carolina Area

Provided support to a variety of small businesses in the Charlotte area while seeking new opportunities in the CPG industry.

Charlotte, North Carolina Area

• Developed and maintained value added reports to monitor the progress and effectiveness of product-line integration activities, and sales and service compliance initiatives impacting company and customer revenues.
• Developed and maintained reports to monitor the progress and effectiveness of product-line integration activities. Provided data to senior management for use in update meetings.
• Provided analyses to support service efficiency projects, resulting in the removal of over 400 unprofitable customer stops, representing a $400K cost savings annually in the pilot program (projected savings of $1.5MM.
• Compiled AC Nielsen and Oracle sales data to isolate, and then track the improvement on out of stock product issues at two major grocery chains that had represented $10MM of lost sales annually.
• Worked as part of a cross-functional team to create a new infrastructure and process to manage field sales data, resulting in reduced headcount and overtime totaling approximately $100K annually.

Charlotte, NC

• Conducted analyses of sales operations; developed methods to track and measure field sales performance against KPI’s and macro-driven tools for use by field sales staff. Major focus on operational issues and sales.
• Developed a reporting package to track the progress of a major DSD re-organization project, resulting in $10MM in improved operational efficiencies.
• Worked on various strategic planning initiatives; including the establishment of preferred service vendors, the reduction of spare delivery trucks and their placement, and the reduction of diesel powered delivery trucks.
• Provided insight into which products or geographical areas drove inventory and stale product issues.

Charlotte, NC

• Assisted the customer business teams in preparing quarterly estimates, and tracked progress to goals to attain bonus payout for region personnel. Performed trade spend tracking and analysis and post promotion analysis..
• Accurately analyzed sales data in a timely manner that contributed to region winning awards 5 times.
• Instrumental in exceeding sales quotas 23 (out of 28) times, resulting in bonus payout for all region staff.
• Prepared post promotion analysis and trade spend tracking and analysis for business teams in the Region.
• Provided support to category planners in preparation for bi-annual headquarter planning meetings. This included revenue, share, new item, distribution, and promotion performance.
• Developed and implemented systems to monitor region progress against monthly, quarterly, and annual sales goals.