Janet Frogner
*** ********** ***** 651-***-****
Mahtomedi, MN 55115 acefl6@r.postjobfree.com
[pic]
QUALIFICATIONS SUMMARY
Experienced and skilled Senior Planner, Buyer, Inventory Analyst and
Project Manager in high-value projects. Bring expertise in all aspects of
procurement, supply chain and finance, while meeting stringent time
constraints. Worked in complex integration settings to unify two different
airline systems in specific areas. Skilled in: lowering materials costs,
keeping inventory down; identifying cost avoidance factors. Degrees: BA
in Education; AAS in Accounting.
[pic]
CORE COMPETENCIES: Analysis/Forecasting Supply Chain Management
Lean Principles
SAP (System Appl./Products) Sceptre Inventory Syst. Sourcing &
Negotiation Aeroexchange(B2B) American Software, Inc.(ASI) Vendor
Performance and Relationships Customer Service Skills
Requirement Forecasting Management Systems (RFMS) SAS Fundamentals
SAS Assist
Materials Requirements Planning (MRP) Microsoft Office Products
Access
[pic]
PROFESSIONAL EXPERIENCE
DELTA AIR LINES, INC., (Formerly Northwest Airlines, NWA), St. Paul, MN
1993 to 2013
Senior Planner, Buyer, Inventory Control Accountant and Repair
Administrator
Configuration Controller / Integration Specialist Delta
Sr. Planner, Buyer, Repair Administrator, and Inventory Controller /
Accountant - NWA
Apply lean principles to streamline work functions and methods, and
identify process improvements. Manage
optimal inventory levels, procure material, products and services, ensure
that parts are received on time
without complications and support supply chain activities. Analyze
material requirements and forecasts.
. Successfully sourced and negotiated vendor contracts incurring annual
savings of $3.8 million
. Expediting purchase of products and service to support the needs of
Supply Chain, to ensure parts are received on time and without
complications
. Prioritized a heavy workload as an interior parts buyer for a fleet of
400 aircraft
. Managed/maintained procurement for 15,000 part numbers with an average
inventory cost of $24M
> Achieved a significant savings by forecasting anticipated need
for "critical" items especially and
secured an agreement to lower costs, representing a savings of
$750,000
> Managed a $1.8M outsourced paint project of 330 aircraft at 4
paint sites and 8 paint lines
> Collaborated with engineering, quality assurance and supply
chain management team to approve and implement system-wide
contracts, policies, procedures, and programs
> Negotiated/approved service repair work orders outsourced to
vendor agencies that resulted in
15% cost reduction and a 35% reduction in repair turnaround time
. Maintained and provided updated product data to engineering and
technical publication personnel
. Designed programming (SAS, SAS Assist, Brio) and spreadsheet
applications to extract, summarize, and report financial data and
inventory valued at $950 million
> Initiated, presented, and implemented plans to bring inventory
levels down
Janet Frogner
Page 2 of 2
acefl6@r.postjobfree.com
> Created standard reporting packages for material management by
departments and performed
variance analysis monthly, quarterly, and annually
> Improved data sources by brainstorming with information
systems (IS), material management and
engineering departments
Configuration Controller/ Integration Specialist (Delta): Specially
chosen to implement major integration and conversion projects. Evaluate
configuration control for interchangeability of aircraft parts between
two airlines. Assess and analyze engineering drawings, technical
manuals, and service bulletins to ensure quality assurance best practice.
Maintain/update script to provide step-by-step guidance for parts
integration. One of 6 among many who remained after the NWA acquisition;
became subject-matter person to parts personnel
. Recruited to implement a complex parts integration project of 950K
into multiple inventory and procurement software, applications, and
databases; accessed Delta and NWA unique databases to account for
different aircraft used by each entity
. Lead project to standardize fleet specific information across Delta's
component tracking system
. Recommended by manager and engineers for "Script Expert & Peer
Reviewer" responsibilities to provide leadership, direction, and
education to personnel in parts integration
. Converted company engineering orders to end state engineering orders
while ensuring safety and compliance with federal regulations and
guidelines
. Special project lead in a team that solved technical operation
material integration (TOMI) inaccuracies between Delta and NWA part
numbers
. Evaluated configuration control to identify interchangeability and
qualified part attribute data resulting
in synergy savings through cross utilization of common inventories
between the 2 airlines
[pic]
RECOGNITION AND COMMENDATION
Recipient of Commendation awarded and presented by Unit Division Department
Head/NWA for "Outstanding Contributions to the Technical Operations Finance
Department "
Recipient of Commendation presented by Acting Dir., Material
Requirements/NWA for "Supporting Many Cross-effectivity Issues and
Analyzing Impact to Provisioning Requirement"
[pic]
EDUCATION AND TRAINING
UNIVERSITY OF MINNESOTA - MORRIS, Morris, MN
Degree: Bachelor of Arts in Education Emphases in Statistics and Group
Dynamics Graduate
WILLMAR AREA VOCATIONAL TECHNICAL INSTITUTE, Willmar, MN
Degree: Associate of Applied Science (AAS) Major: Accounting Dean's
List; Graduate
ADDITIONAL COMPUTER PROFICIENCIES:
Microsoft Windows, Word, Excel, Outlook, Access, Internet Explorer,
PowerPoint, Sharepoint and Harvard Graphics
TOMMS System, IATA Invoice Works, McCormick & Dodge Accounts Payable
System, Time Share Options Basics(TSO), Brio Software (Business
Intelligence Software)