Financial Analyst
Resume:
MICHELLE M. KRENKE
**************@*****.***
https://www.linkedin.com/in/michelle-krenke-finance
SUMMARY OF QUALIFICATIONS
Extensive technical and managerial accounting experience with a solid academic background in finance, accounting, and business administration
Skilled in process documentation and improvement
Areas of expertise:
Financial Reporting Financial Analysis-KPIs Budgeting/Forecasting
Reconciliation Cost Reduction Cash Flow Generation
GAAP Excel Proficient Data Mining
Policy Development Project Management Dashboard Development
EDUCATION & CERTIFICATIONS
MBA with Emphasis in Finance, Bellevue University, Bellevue NE
Certified Risk Manager (CRM), International Institute of Professional Education and Research
BS in Accounting and Finance, Dana College, Blair NE
TECHNICAL KNOWLEDGE & SKILLS
Accounting Software: SAP, PeopleSoft, Oracle Financials, JD Edwards, QuickBooks, MS Dynamics GP, Epicor, FAS1000 Asset Software, Oracle Crystal Ball
Budgeting/Reporting Software: Hyperion, Solver BI360, MS Forecaster, Oracle TM1, Oracle Reports, Power BI, Tableau
Banking, Payroll, HR & Other Software: Fiserv, PeopleSoft HR, ADP, WFN, Workday, GlobalView
Applications: MS Office (Excel, Word, PowerPoint, Outlook), MS Project, SharePoint
Database Management: MS Access, SQL, Essbase, Oracle 8
PROFESSIONAL EXPERIENCE
Banyan Medical Solutions, Omaha, NE, Feb 2024 – Dec 2024 (Company Restructure)
Financial Analyst
Developed Client Discovery Input Model
Set Up Client Dashboard
Development and Analysis of Client ROI Statements
Database Recovery for client statistical analysis
Designed Gross Margin Monthly and YTD Statements and backup
Calculated Loan Amortization
Contract Review and appliance to client financial analysis
Retrieval of data using Tableau Dashboards
Salelytics, Omaha, NE, Jan 2020 – Feb 2024
Financial Analyst
Established annual budgeting and monthly forecasting workbooks to more accurately estimate upcoming costs
Monthly P&L statement generation via TM1, review, and analysis
Analyzed monthly BVAs investigating why variances exist and whether it will be recurring to impact margin
Developed monthly key SGA Department cost trend reports with drilldown options to give management details on actual costs incurred
Reviewed sales associate bonuses and analyzed whether accruals were needed to tie to month earned
Developed Tableau monthly overtime trend report with hours and salaries by client and by employee with dashboards
Created custom C&B reports for CFO pulling live data from TM1 by account and client
Prepared allocations of labor and bonuses for associates working for multiple clients
Cornerstone Staffing, Dec 2019 – Jan 2020
Contract Data Conversion Analyst, Orion, Omaha, NE
Converted data from old template into new template
Designed reports within ADP WFN to support various data audits
Ran multiple reports and combined the data using either pivot tables or VLOOKUP.
Compared data with internal and external data sources.
Assisted with implementation of new software systems.
Assisted with various payroll and benefits audits.
Insight Global Staffing, Jun 2019 - Oct 2019
Contract Accountant 3, PayPal, LaVista, NE
Prepared bi-weekly payroll JE submission for PayPal Canada
Prepared and posted monthly PTO accruals
Monthly and quarterly sabbatical analysis and accrual entries
Analysis of monthly 401k contributions and accrual entries
Prepared and posted daily desktop deposits including JE to clearing account
Suggested and implemented process improvements for time and data entry efficiencies
Cargill, Inc, Blair, NE, Jul 2018 – Apr 2019
A&R Costing Analyst
Execution of consolidation and intercompany accounting duties
Forecasted monthly IBP for both volumes and financial aspects of the Polyols Division
Preparation and analysis of monthly P&L for Polyols Division; set up and conduct meeting for P&L review
Preparation of monthly journal entries including vendor invoice accruals and plant cost allocations
Researched material requisitions and subsequent vendor payable arrangements to discuss with operations/vendors
Researched SAP material balances versus product volume research and performed reconciliation
Investigated and paid accounts payable for the Polyols Division including intercompany transactions
Blue Cross Blue Shield of Nebraska, Omaha, NE, Jul 2014 – Apr 2018
Staff Accountant Financial Report Administrator
Consolidated, division, and ad hoc reporting creation, analysis and management
Shortened number of hours working on budget by 20% by offering more efficient ways of processing data
Modified system reports eliminating manual modifications and saving 2-4 hours on the report monthly
Administered MS GP: troubleshooting and instruction keeping end users working with minimal interruptions
Maintenance of MS Dynamics Management Reporter, hierarchy upkeep, and system enhancement
Served on Agile team for Workday process efficiencies
Liaison between Finance and Finance Delivery Team during GP2015 system implementation/upgrade
Served as Business Partner in charge of Solver BI360 implementation
Oversaw testing and reported user issues resulting in successful upgrade on time and within budget
Aureus Group, Dec 2012 – Jul 2014
Contract Capital Assets Accountant, Kiewit Corp, Omaha, NE
Reviewed and accessed contracts for terms involving billing of JV partners
Prepared financial statements for 5 leasing companies
Trued up JV partnership dealings; prepared cost letters for investment status to owners
Computed lease rates for new acquisitions; assigned to property and distributed depreciation via JE
Researched, coded, and prepared JEs for equipment rebates Acknowledging discounts towards projects
AccounTemps, Jan – Dec 2012
Contract Accounting Specialist, PayPal, LaVista, NE
Reconciled 20 international ACH Accounts daily and prepared journal entries to correct variances
Reviewed transaction history averaging 1000s of rows of detail for abnormal
Communicated with Deutsche Bank on transmittal issues
Worked with System Analysts regarding database issues to ensure accuracy of data
Aureus Group, Jan – Dec 2011
Contract Assistant Controller, Nebraska Department of Labor, Lincoln, NE
Planned and lead team meetings focusing on staffing needs and duties
Utilized Kanban (Agile) to track progress of management team toward staffing goals
Reviewed AP settings in system versus Payables Aging Schedule
Reviewed Accountants’ journal entries
Fund Accounting for Government Work
Reconciled Government Fund Accounts
Omaha Public Power District’s Fort Calhoun Station, Blair, NE, Feb 2001 – Oct 2010
Nuclear Planning Coordinator, May 2007 – Oct 2010
Supervised and trained department’s finance interns – SME for the plant, training new managers on financial terminology and how to read financial reports
Financial modeling for estimated plant life using regression analysis
Projected capital project costs to within 5% of actual, involved discussions, and trained Project Managers to arrive at accurate numbers
Presented financial information to industry regulators including over 10 industry matrices
Financial Planning Analyst, Contract via AccounTemps, Feb – Sept 2001; OPPD, Sep 2001 – May 2007
Served as Team Lead for annual budget including payroll projections for 23 departments and 5 divisions
Prepared monthly statistical performance indicators for 23 departments and 5 divisions and forecasts for cash management planning
Produced monthly variance explanations including over 10 matrices, graphs, and charts
Contact this candidate