Andrea Shepherd

Andrea Shepherd Email and Phone Number

Accounting and Financial Planning and Analysis Manager @ Royal Neighbors of America
Knoxville, TN, US
Andrea Shepherd's Location
Knoxville, Tennessee, United States, United States
Andrea Shepherd's Contact Details

Andrea Shepherd work email

Andrea Shepherd personal email

About Andrea Shepherd

Summary:Senior business professional with 20+ years of diverse experience with a Fortune 100 company in the agriculture and construction manufacturing industries in Internal Auditing, Consolidations Accounting, Marketing Accounting, Cost Accounting, Fixed Assets Accounting, SAP FICO IT configuration, and office furniture manufacturing. Currently performing critical accounting functions in the non-profit life insurance industry. Thrives in a team environment where relationship building, excellent communication, and organizational skills are key. Strengths lie in training and leading teams, resolving problems, and improving processes and procedures. Accounting Skills:- Supervision of 6 Accounting Associates- Complex reconciliations and journal entries- Internal controls and auditing- Accounts payable and receivable- GAAP financial statement and budget analysis- Monthly, quarterly, and annual management report, product line, and sales tax reportingTechnical Skills:- MS Excel: VLOOKUP, XLOOKUP, SUMIF and IF statements, pivot tables, macros- SAP Controlling: 6 years, SAP Fixed Assets: 2 years, and SAP General Ledger: 2 years- 2+ years on IT scrum team following Agile principles- Other: Change Management, Active Control, DB2 queries, Host systems, Hyperion, Business Objects, Oracle, Oracle BI, Spreadsheet Server Excel Add-in, Blackline, Sharepoint, PowerBI, Sapiens PRO Financial GL, Sovos Stat Wings

Andrea Shepherd's Current Company Details
Royal Neighbors of America

Royal Neighbors Of America

View
Accounting and Financial Planning and Analysis Manager
Knoxville, TN, US
Employees:
197
Andrea Shepherd Work Experience Details
  • Royal Neighbors Of America
    Accounting And Financial Planning And Analysis Manager
    Royal Neighbors Of America
    Knoxville, Tn, Us
  • Royal Neighbors Of America
    Accounting & Financial Planning And Analysis Manager
    Royal Neighbors Of America Feb 2024 - Present
    Rock Island, Il, Us
    • Coordinates annual expense budgeting and monthly budget variance reporting processes. Accumulates and loads annual plan into ledger.• Assists in activities and duties of the Accounting Department. Helps build infrastructure to more directly utilize the ledger to fulfill reporting requirements.• Develops models and business cases to support strategic initiatives.• Prepares financial reports including written interpretation and analysis of financial statements and other related financial information for RNA management to support financial decisions.• Develops, refines, and creates financial reporting tools to monitor product profitability.• Communicates outcomes of analyses and research to stakeholders to ensure successful end-to-end understanding of financials, strategy, process, and planning.• Acts as liaison between business units and Finance to ensure proper reporting of financial results.• Provides recommendations to meet financial objectives based on financial results and forecasting models created.• Acts as a liaison between the organization and the external audit firm and state auditors for the annual spring and 5-year State of Illinois exam; manages deliverables and organizes documentation.
  • Royal Neighbors Of America
    Assistant Controller & Financial Planning Analyst
    Royal Neighbors Of America Oct 2021 - Feb 2024
    Rock Island, Il, Us
    - Prepare all financial statements and supporting analysis to enable Managers' and Executives' financial decisions- Manage annual expense budget reporting and monthly budget variance reporting processes- Consolidate expense budget and plan data and load into ledger- Manage expense allocation process to support product line profitability reporting- Approve journal entries and wire transfers and assist with journal entry posting- Collaborate with other departments including Actuarial, Pricing, and IT to build infrastructure to more efficiently utilize the ledger to fulfill reporting requirements- Develop models and business cases to present to Management to support strategic initiatives- Develop and refine new financial reporting tools to monitor product profitability- Communicate outcomes of analyses and research to stakeholders to ensure successful end-to-end understanding of financials, strategy, process, and planning- Act as liaison between department managers and Finance to ensure proper reporting of financial results- Provide recommendations to meet financial objectives based on analysis of financial results and forecasting models created
  • Hni Corporation
    Senior Accountant And Supervisor
    Hni Corporation Jan 2021 - Oct 2021
    Muscatine, Iowa, Us
    - Supervise rotational Finance Development Program Financial Analyst by approving journal entries and reconciliations, providing work direction and support on projects, weekly payroll tasks, and monthly activities, and coaching employee development- Use Oracle to prepare monthly and quarterly accruals and reconciliations on behalf of multiple plants: * Payroll bonus, utility, WIP variance, Raw Material Excess and Obsolete reserves, In-transit inventory, and various other accruals * Warranty, Inventory, and other reconciliations supporting accruals- Ensure accuracy of financial reporting and adherence to internal controls by providing evidence to external auditors KPMG and internal auditors, performing key report testing, and managing multiple reports requiring plant Controller inputs for the quarterly Risk Review analysis- Significantly improve existing documentation and create new documentation to ensure consistent, accurate, and efficient execution of critical monthly, quarterly, and annual tasks- Implement multiple process improvements to improve efficiency: * Quarterly Raw Material Excess & Obsolete Reserves for multiple plants using PowerBI * Quarterly Capital Project reviews for multiple plants using PowerBI * Monthly Capital Project reconciliations: consolidate multiple plants into one * Delegation of Authority: ensure approvals provided are appropriate for job titles
  • John Deere
    Business Analyst In Global It Finance, Sap Fico Controlling - Corporate Headquarters, Moline, Il
    John Deere May 2018 - Aug 2020
    Moline, Il, Us
    - Led global employee survey team meetings and survey result analysis for approximately 100 employees, enabled team decisions, presented recommendations to management and the department, and designed department social media group on Yammer- Actively engaged in Agile rituals, created user stories, planned work based on capacity, and organized Agile training documentation- Demonstrated servant leadership by managing SAP security requests for team, ensuring alignment with Agile principles, scheduling weekly team video calls while team worked from home to increase team morale, and training new team members- Developed strong electronic communication skills collaborating with global team members in India, Germany, and Brazil to successfully implement multiple SAP configuration and program enhancements, including 2 significant changes- Embraced diversity and inclusion by recommending a Diwali celebration in the office for colleagues from India and helping with decorations and meeting with a Brazil teammate weekly at his request to improve his English-speaking skills and learn Portuguese- Overhauled existing and created new documentation for several processes to increase efficiency of team’s user support- Configured order types in 9 SAP landscapes, configured ALE connections, and configured complex assessment allocation cycles - Utilized Cost Accounting experience to test and validate 37 transactions for SAP HANA upgrade - Defined new configuration and master data for an SAP implementation and a data migration project- Analyzed root cause of archiving batch job failures, created an efficient process for resolution, and successfully archived 814M line items in 5 landscapes, enhancing system performance and availability
  • John Deere
    Accounting Supervisor In Fixed Asset Shared Services - Corporate Headquarters, Moline, Il
    John Deere Jun 2016 - Apr 2018
    Moline, Il, Us
    - Supervised fixed asset accounting for 6 Associates supporting 18 units by providing coaching, feedback, and recognition, supporting career development, evaluating performance, reviewing transactions, reconciliations, and journal entries for accuracy, and ensuring compliance with controls for clean audit reports- Trained Associates to successfully use Excel formulas to check work and fix errors and created supporting documentation - Addressed concerns from direct reports, improved communication, and ensured timely completion of closing process by developing a department schedule with timing of activities which significantly improved department’s ability to meet all deadlines- Ensured success of project to replace host-based system with SAP by configuring capitalization journal entry output, reconciling balances, running monthly SAP reports for Associates and units, designing a new process for tracking and reviewing asset changes, training Associates on new SAP transactions, and significantly improving documentation- Analyzed AFE balances throughout the year to ensure timely capitalization and counseled units on capital interest, capital lease, and international asset transfer requirements and prepared associated journal entries- Calculated all necessary asset depreciation adjustments and trued up depreciation annually
  • John Deere
    Cost Analyst In Construction & Forestry - Davenport Works, Davenport, Ia
    John Deere Apr 2012 - Jun 2016
    Moline, Il, Us
    - Led employee survey team meetings, presented recommendations to management, managed implementation of solutions, organized department lunches and volunteer activities, and distributed a monthly newsletter for employee recognition- Developed cross-functional communication skills resolving costing errors and explaining cost changes for monthly cost cycles, created Business Objects reports and ad-hoc reports for unit analysts, and analyzed customer orders for cab replacement quotes- Utilized strong organizational and time management skills to lead team through 2 annual standard cost cycles- Represented unit to explain standard cost cycle process to external auditors Deloitte & Touche and provide documentation - Supported SAP implementation by creating new processes for cost change analysis and streamlining cost cycle documentation
  • John Deere
    General Ledger Accountant In Direct Sales - Construction & Forestry Marketing, Moline, Il
    John Deere Jan 2011 - Apr 2012
    Moline, Il, Us
    - Built relationships with Government Sales and Rental Marketing to implement process improvements and strengthen controls - Utilized SAP and DB2 queries to prepare, analyze, and improve the timeliness of the unit’s Profit by Product report, reconcile accounts, prepare journal entries, ensure proper sales tax reporting, and reconcile host-based inventory to the ledger- Complied with complex government contracts for invoicing and created tracking process to ensure accurate revenue recognition- Prepared and analyzed budget reports to recommend updates, met with department owners, and updated budgets- Supported recent SAP implementation by converting documentation, reports, and journal entries
  • John Deere
    International Consolidations Accountant - Corporate Headquarters, Moline, Il
    John Deere Apr 2008 - Jan 2011
    Moline, Il, Us
    - Consolidated overseas financial data, prepared complex journal entries, analyzed account fluctuations to ensure accuracy of data submitted, and utilized macros and formulas to prepare Excel files for units’ monthly account reconciliations- Prepared monthly consolidated business segment report for assets and capital investments reports, analyzed and distributed monthly Exchange Rate bulletins, and prepared annual 10K disclosure information- Led meetings with and counseled units on US GAAP vs local GAAP differences, accounting entries, and financial statements- Documented and streamlined the global technical service agreements and related accounting entries
  • John Deere
    Financial Internal Auditor - Corporate Headquarters, Moline, Il
    John Deere Jun 2006 - Apr 2008
    Moline, Il, Us
    - Admin Auditor: coordinated meeting books for quarterly Audit Review Committee meetings, updated audit results in risk assessment spreadsheet for global audit planning, prepared management reports, analyzed expense and capital budgets- Communicated with department managers and external auditors Deloitte & Touche to improve timeliness and accuracy of multiple versions of materials which I collated for all management reviews and Audit Review Committee meetings- Internal Auditor: exhibited strong analytical and communication skills by performing financial and SOX audit procedures and internal control reviews with the highest degree of professionalism, skeptical criticism, and integrity
  • John Deere
    Property Accountant In Construction & Forestry - Davenport Works, Davenport, Ia
    John Deere May 2005 - Jun 2006
    Moline, Il, Us
    - Routed AFE’s for approval, counseled unit analysts on property account usage, prepared monthly financial statement, prepared and analyzed Profit by Product reports, calculated accruals, reconciled accounts, and managed Capital Budget submissions- Strengthened fixed asset cycle activities by improving documentation of SOX testing, creating new ICQ controls, and coordinating with the facilities teams to successfully complete the building assets audit for 2 factories and a marketing unit- Effectively communicated across departments to resolve several reconciling issues to successfully transfer computer assets from a host-based inventory and ledger to a new inventory software system and department prior to the established deadline
  • John Deere
    General Ledger Accountant In Part Time Student Program - Parts Distribution Center, Milan, Il
    John Deere Aug 2004 - May 2005
    Moline, Il, Us
    - Processed invoices for third party packaging facilities, prepared and distributed management reports, recorded accruals, performed account reconciliations, maintained AFE records and completed the tax return for an offsite warehouse- Supported upcoming SAP implementation by converting JV’s, reconciliations, and reports and documenting new processes
  • John Deere
    Accounting & Finance Intern - John Deere Parts Distribution Center, Milan, Il
    John Deere May 2004 - Aug 2004
    Moline, Il, Us
    - Streamlined PDC and depot financial reporting, analyzed account fluctuations for external auditors Deloitte & Touche, prepared exhibits, audited expense reports, and completed month-end tasks- Utilized strong internal control procedures in statistical and property audits
  • John Deere
    Accounting Clerk In Part Time Student Program - 19Th Street Computer Center, Moline, Il
    John Deere Apr 2001 - May 2004
    Moline, Il, Us
    - Investigated invoicing issues with vendors, ensured timely payment of invoices for computer servers and phone bills, effectively communicated to resolve invoice processing issues with Accounts Payable Shared Services and with Fixed Assets Shared Services and IT to properly capitalize assets- Audited computer inventory and contributed to the successful migration of computer inventory from a legacy Host database to Asset Center

Andrea Shepherd Skills

Direct Sales

Andrea Shepherd Education Details

  • Western Illinois University
    Western Illinois University
    Accounting

Frequently Asked Questions about Andrea Shepherd

What company does Andrea Shepherd work for?

Andrea Shepherd works for Royal Neighbors Of America

What is Andrea Shepherd's role at the current company?

Andrea Shepherd's current role is Accounting and Financial Planning and Analysis Manager.

What is Andrea Shepherd's email address?

Andrea Shepherd's email address is an****@****ere.com

What schools did Andrea Shepherd attend?

Andrea Shepherd attended Western Illinois University.

What skills is Andrea Shepherd known for?

Andrea Shepherd has skills like Direct Sales.

Who are Andrea Shepherd's colleagues?

Andrea Shepherd's colleagues are Rita Toalson, Jon Lucia, Sarah Reemtsma, Haley Arensdorf, Karla Carpenter, Kierra Egan, Mike Davis.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.