TECHNICAL SKILLS:

Microsoft Excel, Word, PowerPoint, Outlook, Adobe Photoshop and Illustrator, Visio, SQL, SAP, Blackbaud

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

IT Business Analyst

Responsibilities:

• Supports Blackbaud software ( Confidential & Confidential ) on behalf of food banks including upgrades, brake/fix, and enhancement requests
• Collaborates with software vendor (developers, analysts, etc.) and end users to create, test, and deliver solutions that provide clear organizational value
• Prioritizes and manages multiple priorities on a daily basis
• Provides admin support for Salesforce.com, gathers use cases for additional Confidential departments looking to utilize Salesforce.com
• Liaison for technology volunteer groups using agile methodology
• Assists in coordinating the IT Audit with internal and external partners
• Served on a grant review committee to award a competitive grant opportunity to 20 food banks
• Participated in initial search and feedback sessions related to finding a new D.C. office location
• Enhances company culture: serves on the Confidential Employee Giving Campaign committee, won 2nd place in the annual holiday party ugly sweater contest (2015), developed and hosted an activity during an organization wide meeting to help 200+ Confidential employees get to know their executive team staff better (2016)

Confidential, Oak Brook, IL

IT Business Analyst

Responsibilities:

• Participated in designing and implementing Order Management and Transportation Management solutions and functionality across Kellogg’s global network, managed small and medium projects involving cross - functional teams
• Assisted in SAP integration of Pringles® worldwide Confidential after the Confidential acquired Pringles®
• Gathered requirements from business users for approved projects and enhancements, modeled data if required, inputted new projects and enhancements into project management tool
• Managed enhancements, break/fixes, and projects through SDLC and ITIL procedures
• Participated in vendor evaluations and proposed recommendations by the IT department
• Developed IT Surveys and KPI’s to measure process effectiveness and to track organizational maturity
• Order to Cash and Transportation IT experience in SAP regarding ECC, SCM, TP/VS, and Event Manager
• Develop templates for Business Analysts to use in Systems Development Life Cycle (SDLC) process
• Participated in Organizational Change Management (OCM) brainstorming sessions and facilitated OCM activities
• Partnered with business users, IT infrastructure teams, and other IT teams to ensure that solutions to business requirements were properly configured and that all development objects perform as designed
• Provided knowledge transfer sessions to other IT employees as well as provided training and tactical support for business users to learn new software or enhancements related to order to cash and transportation solutions
• Participated in the development and documentation of technical specifications for programming and/or configuration, partnered daily with developers and when appropriate with solution architects and DBA’s
• Represented Kellogg at campus recruiting events (seeking candidates for full-time and internship roles)

Customer Service Supply Chain Analyst

Confidential, Elmhurst, IL

Responsibilities:

• Utilized SAP to gather information to help analyze customer purchase orders and to help manage customer orders through order fulfillment process and shipment
• Found ways to optimize transportation efficiencies for Confidential, Fronthaul, and CPU loads then encouraged external and internal customers to execute those efficiencies with current and future orders
• Communicated with Sales, Marketing, Demand Planning, and Distribution Center personnel to help monitor and forecast product and packaging inventory for future customer orders to maximize order fill rates
• Mediated disputes between distribution centers and transportation companies
• Leveraged reports sent to Customer Service team by comparing them with current customer orders in order to identify trends and issues of potential concern
• Maintained documentation for Sarbanes Oxley 404 compliance
• Utilized Excel pivot tables generated by others to analyze case fill, product availability against open orders, dollar amount shipped by period, and to help manage orders through product changes

Deduction Analyst

Confidential, Elmhurst, IL

Responsibilities:

• Utilized SAP’s CRM software to manage customer trade spend
• Analyzed payment requests and issued customer checks utilizing SAP and CRM
• Investigated customer claims, identified trends, and proactively worked with customers, Deduction Management, and Sales to efficiently resolve issues that caused invalid deductions
• Established relationships with customers to maintain communication essential to achieving established deduction targets and a quick turnaround time for trade payables
• Partnered with customer service to verify deductions for overages, shortages, damages, pricing, and misc. charges

Deduction Analyst

Confidential, Battle Creek, MI

Responsibilities:

• Supported sales team by investigating deductions in CRM, analyzing them, and reporting on related to trade spend
• Communicated with field sales and customers to research monies owed to Kellogg due to invalid deductions then followed through to collect monies for those invalid deductions

Confidential, Grand Rapids, MI

Production Artist

Responsibilities:

• Supported Sales by communicating technical details of digital artwork files to clients
• Bilingual; communicated project instructions to creative team in English and Spanish
• Created custom vector art in program Adobe Illustrator to fit client specifications while mindful of any constraints posed by elements of glass etching process
• Examined customer supplied digital artwork files in Illustrator then simplified and made necessary adjustments to customer digital artwork files in order to output artwork to vinyl or film

Confidential, Battle Creek, MI

Deduction Analyst

Responsibilities:

• Gathered information on various deductions from databases, utilized computer software programs SAP and CRM to further investigate and process deductions related to trade spend
• Shared information regarding deduction amounts, utilization of sales promotions, and trends with Deduction Management and Regional Sales Managers through frequent oral and written communications including formal weekly and monthly reports prepared with Excel
• Excel reporting; utilizing Pivot Tables with Vlookups included: Deduction write-off reason code report (to analyze reasons for tax write-offs by customer), team metrics report (to measure progress against goals)
• Other Excel reports: accounts payable turnover report and trade deductions by region report (used by Sales team and Deduction Analysts to detect trends in trade spend)

Confidential, Kalamazoo, MI

Teacher

Responsibilities:

• Presented curriculum, evaluated students' existing learning needs and developed additional educational materials to engage the students and meet desired learning goals

Confidential, Delton, MI

Associate Art Director

Responsibilities:

• Blended information and art in Photoshop and Illustrator to create sales and promotional ads and coupons reflecting the image of each client's small business
• Organized between 20 to 40 incoming ad and coupon requests daily, prioritized them, delegated them among a team of graphic designers, and managed work projects through processes to ensure timely delivery of quality ads
• Examined ads and coupons aesthetic properties and impact, including proofreading, before sending them to print