Andrea Shepherd Email and Phone Number
Andrea Shepherd work email
- Valid
- Valid
Andrea Shepherd personal email
- Valid
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
Royal Neighbors Of America
View- Website:
- royalneighbors.org
- Employees:
- 197
-
Accounting And Financial Planning And Analysis ManagerRoyal Neighbors Of AmericaKnoxville, Tn, Us -
Accounting & Financial Planning And Analysis ManagerRoyal Neighbors Of America Feb 2024 - PresentRock 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. -
Assistant Controller & Financial Planning AnalystRoyal Neighbors Of America Oct 2021 - Feb 2024Rock 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 -
Senior Accountant And SupervisorHni Corporation Jan 2021 - Oct 2021Muscatine, 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 -
Business Analyst In Global It Finance, Sap Fico Controlling - Corporate Headquarters, Moline, IlJohn Deere May 2018 - Aug 2020Moline, 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 -
Accounting Supervisor In Fixed Asset Shared Services - Corporate Headquarters, Moline, IlJohn Deere Jun 2016 - Apr 2018Moline, 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 -
Cost Analyst In Construction & Forestry - Davenport Works, Davenport, IaJohn Deere Apr 2012 - Jun 2016Moline, 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 -
General Ledger Accountant In Direct Sales - Construction & Forestry Marketing, Moline, IlJohn Deere Jan 2011 - Apr 2012Moline, 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 -
International Consolidations Accountant - Corporate Headquarters, Moline, IlJohn Deere Apr 2008 - Jan 2011Moline, 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 -
Financial Internal Auditor - Corporate Headquarters, Moline, IlJohn Deere Jun 2006 - Apr 2008Moline, 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 -
Property Accountant In Construction & Forestry - Davenport Works, Davenport, IaJohn Deere May 2005 - Jun 2006Moline, 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 -
General Ledger Accountant In Part Time Student Program - Parts Distribution Center, Milan, IlJohn Deere Aug 2004 - May 2005Moline, 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 -
Accounting & Finance Intern - John Deere Parts Distribution Center, Milan, IlJohn Deere May 2004 - Aug 2004Moline, 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 -
Accounting Clerk In Part Time Student Program - 19Th Street Computer Center, Moline, IlJohn Deere Apr 2001 - May 2004Moline, 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
Andrea Shepherd Education Details
-
Western Illinois UniversityAccounting
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial