Candidate Information Name Available: Register for Free Title General Ledger Senior Financial Analyst Target Location US-OH-Columbus Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

Candidate's Name  J. McLELLANColumbus, OHPHONE NUMBER AVAILABLEEMAIL AVAILABLELINKEDIN LINK AVAILABLEReliable, versatile Finance Professional with over 15 years experience in expense management, reporting, budgeting, and forecasting. Highly skilled in a variety of technical tools and systems including spreadsheet pivot tables and lookups, database management, procedure documentation, and data summaries. Self-motivated, quick learner whoworks well both independently and on teams, striving to add value to the team and company.Key Competencies & SkillsFinancial AnalysisReport DesignBudget & ForecastingSAPMS Dynamics GP/SQLCustomer ServicePeopleSoft/nVisionHyperion SoftwareTraining/Process ImprovementNetwork AdministrationActuarial AnalysisGeneral Ledger (GAAP)PROFESSIONAL EXPERIENCEABB, Inc., Westerville, OH 2017  PresentConsultant  Financial AnalystDetermine Purchase Order available funds, investigate Back Charge Account, send invoices to Accounts Payable (A/P) with proper coding, post accruals and journal entries, and provide process improvements.Determine Purchase Order available funds for invoice payments and generate reports.Investigate Back Charge Account, ensuring invoices properly reimbursed from parent company in timely manner.Send invoices to A/P coded with correct Purchase Order and General Ledger account to pay from for timely payments.Provide process improvements and process documentation.Post journal entries and accruals during month end close.ROCKBRIDGE, Columbus, OH 2016  2017Consultant  Senior AccountantReconciled Accounts Receivable (A/R) and A/P to General Ledger, billed A/R customers, posted A/P payments to General Ledger.Reconciled A/P and A/R accounts to General Ledger, researched and investigated debits/credits obtaining zero balance General Ledger accounts.Coded invoices with correct General Ledger account to pay from, input invoice payments to A/P then posted to General Ledger, and processed wire transfers, initiating ACH payments.Provided supporting documentation for Ernst & Young and CBIZ audits.Posted journal entries and accruals during month end close, billed customers and posted to General Ledger.EMERSON NETWORK POWER, Columbus, OH 2016  2016Consultant  Senior Variable Compensation AnalystCalculated the commissions for sales associates, distributed various reports, and provided process documentation.Calculated monthly commissions for sales associates in United States and Canada and generated sales and commission statements.Provided accurate and timely monthly reporting of sales, orders, bonuses, and commissions to senior management for United States, Canada, and Latin America.Generated monthly commission payout reports for Payroll department.Provided process documentation for calculating commissions for sales associates, sales and commissions statements, bonuses, and payroll reports.JEYES LIMITED, New Albany, OH 2014  2015Consultant  Finance Manager-AccountingGenerated Payment Proposals and posted to General Ledger (GAAP), Bank Reconciliations, posted other Accounts Payable (A/P) payments to the General Ledger, and generated Weekly Financial Statement and Variance reports.Generated Payment Proposals from Dynamics SQL, determined payment timelines, and posted invoice payments to General Ledger.Reconciled General Ledger balance to Bank Accounts balance, researched to identify any discrepancies.Reviewed open Purchase Orders for main warehouse, determined cost of raw materials and vendor payment terms to project sales and other expenses.Posted A/P payments, journal entries, and accruals to General Ledger, generated Weekly Financial Statement, Production, Buying, and Material Variance reports for CEO, and updated Weekly Scorecard information for CFO.Researched and provided supporting documentation for Ernst and Young audit inquiries.MISSION ESSENTIAL PERSONNEL, Columbus, OH 2014  2014Consultant  Staff AccountantReconciled payroll and other costs for government contracts during audit.Reconciled payroll and other costs for government contracts.Researched and used problem solving to aid Compliance department during audit.Verified time and material and other direct costs directed to correct project.Identified invoice discrepancies versus general ledger entries.JPMORGAN CHASE & CO., Columbus, OH 2010  2013Senior Financial AnalystPrepared monthly executive financial reporting and analysis, including budgets, forecasts, and variance explanations.Provided monthly financial reporting package, as well as daily and weekly foreclosure sales reports, using SAP, Excel, Access, and PowerPoint, providing productivity reporting to upper management and regulators.Conducted research and detailed analysis on key metrics using Essbase and Excel, providing effective explanations of actual versus projected staff and expense variances.Supported assigned Default Operating Groups with monthly forecast, annual budget, and capacity planning using Essbase, Excel, and Financial Analysis Management System (FAMS).Created and maintained monthly Default Operations Capacity models and Portfolio expense models using Essbase and Excel, assisting in analysis of productivity and hiring needs for each area.Created monthly journal entries, accruals, and forecast trend reports using SAP, Essbase, FAMS, and Excel.Supported Corporate Finance initiatives through Ad Hoc analysis, Ad Hoc reporting, Risk Management and various projects impacting assigned operating groups.LIMITED BRANDS, Inc., Columbus, OH 2008  2009STERLING COMMERCE, Inc., Columbus, OH 2007  2007Consultant  Senior Financial AnalystPrepared weekly logistic reports and monthly financial reports and project analysis.Prepared weekly logistics reports using PkMS, MicroStrategy, and Kronos, analyzing Distribution Center (DC) cost trends for optimal operational and financial performance.Created monthly DC Operating and Profit and Loss statements, journal entries, accruals, and forecast reports using SAP, Essbase, and Excel, providing more accurate view of financial status.Created CFO memos, summarizing consulting engagements, equipment purchases, and projects.Prepared Project Approval Requests (PARs) and business case analysis, ensuring alignment with company strategy.Managed project approval and budgeting using Changepoint, PAR Workflow Tool, and Hewlett Packard Project and Portfolio Management (HP PPM) Tool, assisted in requirements gathering and implementation of HP PPM Tool.Investigated purchase orders, evaluating the impact of open purchase orders to budget.NATIONWIDE, Columbus, OH 1998  2007Financial Business Senior Analyst (September 2003  May 2007)Prepared budgets and forecasts and conducted financial review meetings to senior-level management.Evaluated monthly financials, investigated findings, and conducted financial review meetings, advising senior-level management on current financial status and recommendations.Prepared yearly budgets and salary planning using Hyperion, Essbase, and PeopleSoft Budget system, and created monthly financial reports using nVision, Tree Manager, and Excel, including forecasts and expense trends, analyzing the impact of variance to plan while keeping management apprised of risks.Facilitated training of new financial process flows and templates.Contributed to several Property and Casualty IT leadership teams, providing resource management, productivity analysis, and performance management.Actuarial Analyst (June 1998  September 2003)Managed PTS projections and analysis for Corporate Actuarial and analyzed benefit plans for Benefits Actuarial.Managed execution and reporting of PTS projections for all Nationwide Financial (NF) product lines including software path setup, and projection and duration settings, enabling successful data runs. Converted Provident Benefit plans to Nationwide Benefit plans, including life, medical, and retirement benefits, validating participant benefit data from Hewitt for government reports.EDUCATIONCompany Sponsored Actuarial Program (Nationwide)Continuing EducationSociety of Actuaries Exams:100 (Calculus)110 (Probability and Statistics)120 (Advanced Business Statistics)130 (Operations Research)Bachelor of Science (BS) in Mathematics, The Ohio State University, Columbus, OHCERTIFICATIONMicrosoft Certified Professional NT4Microsoft Exams: Windows NT Server and Windows NT WorkstationTECHNICAL SKILLSMS Excel AdvancedSAPHyperion ReportsHyperion PlanningMS Access AdvancedMS PowerPoint AdvancedPeopleSoft/nVisionMicroStrategyEssbaseNIKU/KRONOSHP PPM ToolPkMSMS Dynamics GP 2013MS Word AdvancedMicrosoft PublisherMS Dynamics SQL