Angela Hegemann Email & Phone Number

Us

Omaha, Nebraska, Us

Contracting for Northern Natural Gas, a division of Berkshire Hathaway Energy. Work in the Accounting Systems Support group within Accounting and Finance to provide support for multiple finance-related systems. Software experience in this role includes UI (Utilities International) and PowerPlan, both of which are used to support capital projects for energy-related companies. Also support some Oracle EBS processes. Main responsibilities include access and termination requests for these systems. Additionally, troubleshooting for employees using these systems is a major component of this position. Currently involved in financial-related data mapping for long-term Oracle Fusion ERP implementation.

Primarily worked on Oracle Fusion ERP business implementation for this start-up hog production farmer’s cooperative, which had recently purchased one of the last remaining Hormel production facilities. Was predominantly focused on the accounting/finance and transportation modules of the implementation. Worked with acting CIO to gather business needs, collected and transformed financial data for conversion, mapped data to Oracle Fusion loading templates, and participated heavily in unit testing activities. Worked in Oracle Fusion’s OTBI reporting solution to create ad hoc reports for finance and accounting and procurement.In addition, created several spreadsheets using pivot tables and VBA to automate information for various departments and purposes. These projects were one-off projects requested by my manager.

Business analyst specializing in hog processing systems and processes.

Omaha, Nebraska, Us

Dubuque, Ia, Us

Supplemental cancer, heart attack, and stroke is insurance.

• Led and inspired Retail Wireless Consultant in providing an unparalleled customer experience.• Coached on the sales floor, demonstrating how to most effectively handle various situations.• Inspired continuous learning on new products and solutions.• Provided customers with troubleshooting assistance on their wireless devices.

Snyder, Ne, Us

• Review aerial fire truck specifications, determine what materials need to be added to the bill of materials to maintain proper inventory, and populate the bill of materials for each truck.• Ensure non-standard materials are correctly entered into the bill of materials within a timely manner so that they may be purchased and received in time for truck assembly.• Obsolete items in the Item Master as necessary to help maintain a clean database.• Research materials needed for non-standard fire truck options, using various resources, such as vendor websites, previous truck specifications, speaking with production employees, and reviewing bills of material for similar fire trucks.• Create and maintain spreadsheets to track previous fire trucks to aid in collecting data for future trucks. This includes exporting data, using higher-level formulas such as VLOOKUP, and creating charts and graphs to provide good visual representation of the data.

Chicago, Illinois, Us

• Maintained and enhanced monthly customer service scorecard, running queries and coordinating information collection as needed.• Maintained current customer service dashboard and slide.• Created and updated periodic and ad hoc queries as needed in ShowCase Query.• Maintained all training documentation (BPPs, SOPs, and job aids) on Portal, shared drive, and training document database.• Provided backup assistance on departmental tasks, such as contract changes, sample requests, and reprice requests.• Provided data analysis and spreadsheet assistance to other members of the department as needed.• Provided customer deep-dive information for Sales as requested, looking specifically at customer ordering trends.• Used advanced features of MS Excel on a daily basis: VLOOKUP, PivotTables, charts & graphs, subtotals, formulas, and other functions.

Chicago, Illinois, Us

• Reviewed, corrected (where necessary), and routed CIRs (capital investment requests) and CTIDs (capital transfer and divestment requests) for the Meal Preparation group ($35MM budget).• Created and maintained a CIR/CTID tracking log.• During the planning cycle, involved in reviewing entered projects for accuracy and completion of information. Provided users with required access to the Capital Planning and Tracking system.• Involved in the Capital Roadmap session and a member of the post-audit committee that was formed as a result of the Roadmap session.• General administrative duties, including distributing mail, ordering office supplies, preparing shipments, making travel arrangements, coordinating engineers' out-of-office calendar, processing BERs and reconciling purchase cards, scanning documents, scheduling meetings, etc.

Chicago, Illinois, Us

• Assisted Vice President, Compensation and nine other members of the Compensation team.• Prepared documents, spreadsheets and charts using Microsoft Office products for HR Committee meetings. Tracked versions and organized both hard & soft files for each Committee meeting.• Scheduled many high-profile meetings with members of upper management up to and including the CEO & Chairman of the Board.• Coordinated with outside brokers and provided customer service to those employees wishing to exercise their stock options by providing information on the general process and helping them prepare paperwork. In addition, sent daily reports to transfer agent, forwarded exercise confirmations to employees, and filed copies of all exercises.• Prepared multiple mail merges for various mailings throughout the year, including option expiration notifications, dividend notices, insider window notifications, and long-term grant vesting.• Generated job data forms to notify payroll of upcoming changes to senior management pay and personal employee records.• Maintained smooth functioning of busy office: scheduled meetings, answered phone for VP, ordered office supplies and business stationery, coordinated office machine maintenance and office moves, prepared new hire paperwork, and created binders to organize information.

• Managed staff of three individuals and assisted eleven managers and insurance agents.• Responsible for disbursement of weekly office payroll and agent advanced commissions, bonuses, and incentive checks.• Administered accounts payable/receivable using QuickBooks 99.• Processed insurance applications and generated weekly reports to track new business.• Maintained and regularly updated customer database (MS Access).• Processed customer cancels, lapses and other changes and corrections to policy information.• Reviewed monthly commission statements, researched and resolved any payment discrepancies, and paid agents’ monthly commissions.

Omaha, Ne, Us

• Introduced all new products and bills of material into various databases. Acted as liaison between Marketing and Production throughout this process. Also discontinued non-active products as necessary.• Created and implemented an improved literature and video fulfillment process; trained Customer Service on new procedures.• Updated and maintained contact management software, including importing new contacts, exporting contact information for mailings, and archiving outdated contact information as required.• Generated sales and inventory reports as needed using Crystal Reports 7.0.• Trained the Marketing department in the effective use of our contact management software.• Documented several business processes used by Marketing and Customer Service.• Built automated processes in GoldMine to automate follow-up literature to customers and leads following sales and literature requests.• Completed vendor applications, requests for proposal (RFPs) and other required forms in order to receive bid awards among school districts, schools and other government agencies across the nation.

Downers Grove, Il, Us

• Coordinated $15.8 million capital budget for Elkay Division.• Processed and tracked all capital expenditure authorizations (CEAs) for Elkay Division.• Created Access database to replace non-Y2K compliant capital budget software program. Trained five individuals on its use.• Produced an Access database to track manufacturing components, bills of material and routings.• Designed and implemented Access databases to track daily productivity at two sink plants.• Created and maintained a task list and Gantt chart to track 280 tasks for a $9.6 million project using MS Project.• Documented several business processes.• From 10/97 to 1998, was a secretary to the Director, Engineering.

• Typed reports and business letters from transcription for 3 partners in the executive recruiting industry.• Answered telephones and transferred to partners/researchers.• Provided general administrative duties.

• Answered phones and transferred to candidates or counselors.• Typed resumes/cover letters for outplaced executives.

Master'S, Information Systems Management With Concentration In Database Management

Bachelor Of Science (Bs), Business Administration

Education record