JOHN R. KRELLNER
Cross Lanes, WV 25313
acr45t@r.postjobfree.com
EXPERIENCE
AM/NS CALVERT, LLC (ArcelorMittal / Nippon Steel & Sumitomo Metal) (formerly ThyssenKrupp Steel USA,LLC), Calvert, AL Nov 2011 – Apr 2015
Lead Specialist (Sr. Accountant) Financial Reporting
-Responsible for consolidating the monthly Functional P&L, Balance Sheet, Key Figures reports,
and reviewing/analyzing the results with plant senior management during the Earnings Review.
-Report monthly earnings results to the Steel Business Division (Duisburg, Germany) via
the Powerpoint Earnings Package and answering any follow-up questions/concerns.
-Complete and load ThyssenKrupp’s monthly corporate earnings results in Hyperion Financial
Management (HFM) and Financial Reporting system (FRS) for Corporate Headquarters (Essen,
Germany)
-Purchased and worked on roll out Adaptive Planning software system for 5-yr Budget
Plan and Forecast.
-Assist in quarterly and yearly audits with outside auditors, in quarterly physical
inventory, and other accounting projects as needed (recast results as stand alone
company for outside sale, internal review of contract results, etc.).
GEORGIA STATE ACCOUNTING OFFICE, Atlanta, GA Sept 2007 – Nov 2011
ERP Business Solutions Analyst
-Responsible for providing PeopleSoft ERP system functional support for 80+ State agencies on
maintenance, training, and problem solving.
-Set-up and system test multiple PeopleSoft module applications for agencies that transition from
legacy systems to the State’s PeopleSoft system.
-Develop training and user acceptance testing for agencies that transition to the State’s
PeopleSoft system.
-Main SAO functional support for GDOT system/report requests and issues.
-Functional support for flowcharting, system design, and process specs of new GDOT Billing
Process.
-Responsible for the weekly and monthly procurement module control reports including working
with Technical support on any correction SQL programming needed.
-Other projects as assigned by management (GO system, Putty/Golden, Trail Balance Recon,
Reports/Queries on SAO website, etc).
WOLVERINE TUBE, Inc., Huntsville, AL Mar 2004 – Sept. 2007
Senior Financial Analyst
-Responsible for preparing qtrly financial reporting packages for the Board of Directors meetings
and monthly analysis reports for the Executive Management Committee (EMC).
-Prepare financial packages (for both the Tube and Fab Products Group) for the annual
shareholders meeting.
-Developed qtrly Balance Sheet reconciliation packages for eleven plants to meet SOX 404 and
Internal Control requirements and worked with internal (D&T) and external (KPMG) auditors
during review.
-Create quarterly plant financial forecasts and develop/process plants annual financial budgets (in
conjunction with the EMC) in the TM1 system (similar to Hyperion).
-Develop plants annual capital budget and review all capital requests for compliance to company
Procedures.
-Create the Profit by Product Line report for the quarterly 10Q issuance.
-Worked with outside consultants (KZC) on building analysis tools for restructuring the
company.
-Filled in for vacant Plant Controllers as needed.
-Various other financial analysis projects (make vrs buy, product profitability, etc.) as required by
the EMC.
WERNER COMPANY, Anniston, AL Apr 2002 – Mar 2004
Financial / Systems Analyst (April 2002 – April 2003)
-Responsible for implementing Corporate Purchasing Card program with internet processing and
downloading to JD Edwards G/L system.
-Developed (with RGIS) files to pass inventory data obtained from barcode scans.
-Assisted in creating inventory cycle count program and worked on cycle count and annual
physical inventories.
-Learned and trained operators on extrusion production/shop floor systems.
-Created depreciation budget and helped on operating plan.
-Wrote policy on Winston product flow and re-wrote RMA policy
Continuous Improvement/Six Sigma (April 2003 – March 2004)
-Completed Six Sigma green belt and Lean Manufacturing training. Worked on 10+C.I. teams
and led the Payroll enhancement, PP&E vending, Internal Safety Awards, Worker Comp
(Dupont STOP program), and multiple Distribution Center projects.
-Participated on two Kaizen events and conducted multiple Business 101 training courses.
-Built two Access databases (Die Pull-Off's and Ladder Products Back-flush).
-C.I. generated approximately $5mm in savings/cost reductions versus prior year.
CONAGRA FOODS, Duluth, GA Oct. 1996 – Jan. 2002
Financial Analyst
-Responsible for development and management of capital budget/plan for sixteen poultry
Facilities.
-Reviewed capital requests from each of the company’s sixteen facilities.
-Tracked CIP and capitalized all projects directed by company headquarters.
-Created weekly consolidated financial performance and monthly detailed variance analysis
(versus plan and prior years) reports for each facility.
-Compiled Agristats (industry comparison) bottom-line report.
-Participated in the development of accounting standards for the capital/lease process.
E.I. DUPONT DeNEMOURS Co., Wilmington, DE Jun 1989 – Apr 1996
Project Accountant, Photomask IPO Spin-Off (Nov. 1995 – Apr. 1996)
-Designed and implemented $250 million fixed asset system for new Photomask Company’s
domestic sites.
-Developed financial reporting package, including company’s monthly P/L results, for senior
Management.
Project Accountant, Human Resources Department (Oct. 1993 – Oct. 1995)
Member of project team responsible for testing and implementing two new payroll projects (GTN/TPP Project & PAR 2A/2B)
-Prepared flowcharts of existing processes, designed new control/audit reports, tested new
systems and trained HR personnel.
-Served as accounting resource on moving expense system rewrite during this time.
Plant Cost Accountant, Dupont Agriculture Department, Belle, WV (Aug. 1991 – Sept. 1993)
Agriculture Department generated approx $2 billion in sales
-Prepared Ag-Belle’s manufacturing cost, PEO, and R&D budgets.
-Developed financial reports, graphs, and metrics for plant management.
-Implemented benchmarking of AG-Belle’s financial results versus industry competitors.
-Prepared Ag-Belle’s capital budget and project accounting.
-Primary contact for corporate business analysts.
-Supervised outside accounting contractor’s on-duty drawback documentation.
-Assisted in identifying and correcting internal control deficiencies at the plant.
International Accountant, Dupont Fibers Department (June 1989 – July 1991)
Fibers Department generated approx $8 billion in sales
-Responsible for consolidating Fibers Dept. international earnings.
-Led implementation of COGS systems (movement of manufacturing costs from transfer prices
to true costs for products sold overseas) for Fibers Dept.
-Primary resource/contact for Fibers Dept. business analysts, international subsidiaries
personnel and corporate accounting personnel.
-Closed Fibers Dept. sales and company-basis accounting ledgers/systems.
FRANKLIN STEEL COMPANY, Franklin PA, Summer 1988
Accounting Internship
FRANKLIN STEEL COMPANY, Franklin PA, Summer 1985,1986, 1987
Various Cold Mill jobs/Nightly Mill Scale removal
EDUCATION
B.S. Accounting, Indiana University Of Pennsylvania (IUP) - 1989
GPA 3.85 (Summa Cum Laude) Honors: Dean’s List (every semester)
OTHER
Six Sigma Green Belt Certification
COMPUTER/TECHNICAL SKILLS
SAP Enterprise System, Adaptive Planning Software, Business Objects Software, PeopleSoft Enterprise System, JD Edwards/OneWorld G/L Enterprise System, Oracle G/L and F/A Enterprise systems, TM1 Financial Analysis system, IBM mainframe systems- AS400, Microsoft Office Suite (Excel, Powerpoint, and Word), Lotus 1-2-3, GAAP, Cost Accounting, Visio-calc flowcharting system, multiple e-mail systems (Microsoft Outlook, Lotus Notes, etc.)
REFERENCES
Available Upon Request