Patrick S. Kaplan Email & Phone Number

Charlotte, North Carolina Area

Provide service and support to the Home Lending business partners through maintenance and development of non-automated reporting and tools to increase business effectivenessDevelop call center dashboard and analytics based on current business structure that can be used to identify trends and opportunities in the businessLead weekly discussion around call center dashboard to identify trends and help drive the businessProvide consultative input and direction on home lending activities that gives business intelligence on performance trends, challenges, successes, and opportunitiesIdentify opportunities in our business performance and process through analytics, recommend actions for improvement and change, present analytic findingsUse Sequel Server to create SQL queriesFinancial/Data Analyst – Consultant (2014-2015)Responsible for performing reconciliations of WISe Data Marts supporting regulatory reporting and iHub dataAnalyzed and investigated variances; worked business partners to take action to remediate issues Supported the iHub project by analyzing System of Records data feeds and determining the appropriate parameters to perform Financial Comparisons/reconciliationsUsed TOAD to create SQL queriesPerformed audits on the output of iHub Financial Comparisons data and research issuesCreated SQL queries on cross-platform relational databases including Oracle and SQL Server

Charlotte, North Carolina Area

Generated and executed weekly replenishment orders for Regional WarehousesPerformed inventory audits of warehoused productsParticipated in transformational projects and process improvementsMaintained manual replenishment planning reportsUpdated reporting templates to reflect network changes as needed and add New Planning Groups as appropriate

Charlotte, North Carolina Area

Works closely with Lowe’s a fortune 500 company to streamline the order fulfillment processMaintain weekly and monthly performance KPI’s and vendor scorecards through dash boardingPrepare monthly journal entries for all inventoried items marked for destruction or manual orders Provide detailed cost and revenue analysis on all shipped inventory on a per piece basis Prepare all financial reporting and analysis on Period End Close documentation Works closely with IT to come up with new IT solutions development and integrationPrepare high level business process modeling through data mining and data visualization

Salibury, North Carolina

Collaborates with Category Manager to manage vendor allowances to ensure sales targets are met Perform margin analysis on all wine and liquor items in order to make sure products are being purchased at a reasonable cost and that retails are set at approved markup ratesManage margin percent and margin dollars on an ongoing basis to ensure that all Delhaize banners are being profitable on all items soldProvide financial and pricing recommendations to banner merchandising teams in support of the banner strategies Prepare weekly margin and sales projection analysis in order to predict sales volume, product movement and margin growthWork with the Pricing Specialist to prepare daily variance analysis on all inventoried items to make cost and retail adjustments where neededPrepare weekly and quarterly sales forecasting and item movement projections in conjunction with promotional and non promotional margin percent forecastingUtilize macros and pivot tables and a series of V-Looks in order to extract data from various sources in order to update the Weekly Projection Template(WPT)

Concord, North Carolina

Improved the account reconciliation process by streamlining accounts.Reported, analyzed and interpreted financial data including revenue, cost, product/customer profitability. Actively participated in month-end close processes, booked journal entries and provided appropriate detail level review and analysis, forecasting and budgeting Used macros to upload journal entries into GL and v-lookups to source data from databasePrepared and analyzed the actual vs. forecasted variance analysis for senior management. Performed audit-level expense and balance sheet account analysis on certain high profile accounts.Established and built productive working relationships for ACN vendors and internal departments. Analyzed carrier invoices against contracts to ensure accuracy of terms and conditions. Analyzed financial performance and made recommendations for future policies and action.

Charlotte, North Carolina Area

Created and maintained incentive plans based on participant productivity reports and market trendsCalculated monthly and quarterly incentives for all Retail and Commercial branch personnel Reconciled monthly expense vs accrual ledgersPrepared financial reporting models for senior managementTracked and maintained productivity reports for Commercial lendersImplemented new processes for calculating incentives which cut the calculating time down from 1 month to 1 week per business unitCreated a serious of macros to upload data from GL into Crystal Reports which created the Incentives ReportCoordinated with payroll to ensure all monthly and quarterly incentives were paid on a timely basis

Charlotte, North Carolina Area

Assisted in the analysis of complex investment instruments and strategies as they relate to current and new lines of business and productsResearched and processed all daily trade tickets which included resolving all daily trade edits and other trade related issueCompleted various tasked as requested from team leader

Charlotte, North Carolina Area

Staff Accountant (2005)Prepared daily reconciliations, exception reporting, research, analysis, and project work as assigned in the Securities Operations– Accounting groupReconciled Financing and Inventory transactions for securities tradesPrepared and analyzed reporting for significant variance and exceptionsPrepared journal entries by using pivot tables and v-lookups for GL account for adjustments and reclassificationsPerformed reconciliations for Profit/Loss accounts, Wash accounts, and GL RejectsPortfolio Analyst (2000-2004)Managed investment portfolios for Institutional clientsCompiled and created statistical data to report performance to clients on daily, monthly, and quarterly basisPerformed risk based analysis through asset allocations studies to determine the best way fully invest client capital Served as liaison for Portfolio Manager and client operations.

Charlotte, North Carolina Area

Trust Accountant (1999-2000) Processed and executed payrolls for defined contribution plansTracked and resolved problems concerning contribution activity and transfer problemsAssisted in creating polices and procedures to streamline contribution processesCross-trained in our loan, distributions, and participant account serviceslDecisioner/Underwriter (1997-1999) Processed and Decisioned all First Union Real Estate and Consumer LoansReviewed title searches, collateral valuation, credit history, and income verifications, to ensure that customer’s loan to values and debt to income meets with First Union’s guidelines. Reviewed flood zone determinations and insurance coverageResolved all customer and lender issues in a timely manner in order to meet or exceed turn around time on all loansIn conjunction with the loan officers, reviewed and structured all loans prior to processing and sending to customersResolved and processed an average of 10 loans per day with a 15 day turn around time as required by First Union’s policies

Charlotte, North Carolina Area

Conducted highly technical accounting based research and analysis to provide senior management with definitive financial dataSet up subsidiary Fixed Asset Ledgers and maintain Fixed Asset Ledgers while tracking income and expensesPrepared financial forecasts. Conduct cost analysis for capital expenditures and all inventoried assetsDetermined if proper depreciation methods were applied to assets in accordance with company and accounting policiesReconciled Fixed Assets Ledgers, A/P, and A/R to General LedgerWorked with Store Managers to ensure assets are properly inventoried and Equipment Ledgers are maintained. Perform preliminary internal audits