Alan Baumann Email & Phone Number

United States

Columbia, South Carolina Area

Columbia, South Carolina Area

Columbia, South Carolina Area

Conducts data modeling and analysis while developing and maintaining databases Assists department management / Sr. management with the preparation of department metrics Assists management in gathering, interpreting and comparing benchmarking data to the company’s operations while performing statistical analysisWorks with Excel, Access, System i Navigator and Business Objects to design ad hoc reports for Sr. leadershipSelected to partner with external contractors and Transformation team to provide potential data extraction solutions for Aflac Group Future State, a part of the Data Transformation projectPoint of contact to validate external contractors’ specifications for report design for the Data Transformation project and Aflac Group Future State

Greater Pittsburgh Area

Develop and maintain inventory analytics designed to improve inventory management and margin controls for all lines of business (Excel/SQL)Designed and implemented FY2016 and FY2017 Shrink budget plan per line of business and store using Hyperion Essbase (annual budget $175M)Track 172 store shrink budget vs. actual performance weekly through macro developed workbooks Develop automated reports to communicate to store leaders via SharePointDesign ad hoc reports for Store Leaders that identify shrink opportunity areas.Work with Directors and Sr. Management to better understand the origins of shrink and use data analytics to provide recommendations in an effort to reduce the amount of loss.Build and continuously modify queries that evaluate credit cost adjustments with Accounting

Columbia, South Carolina Area

Works with auditors (KPMG) to resolve financial issues on accounting documentation. Writes and manipulates SQL codes to retrieve data and update tables Develops reports using SAP, Genelco, PayPilot, Business Objects and Microsoft Access/Excel Comprehensive database management and migration from Genelco to SAP accounts, as well as updated SAP accounts through manual adjustments.Resolves ad hoc reports to assist management and auditors in determining state and line of business asset allocationCoordinates with headquarters submission of yearly state premium taxes

Columbia, South Carolina Area

Works with student-athletes as a tutor of Management, Finance, Accounting, and Computer Business classes.Responsible for scheduling and tutoring 5 students a semester.Maintains high level of leadership and academic integrity among students.Drives participation, organization, motivation and overall understanding on course work among students.Student – Mentor evaluation results 4.87 out of 5.0 scale

Columbus, Georgia Area

Reconciles general ledger balances with all 32 Individually owned banksAdjusts monthly charge offs, non-producing assets, past due loans and restructures troubled debt balancesPrepares monthly Moody’s investors reportsProvides guidance to Senior Managers and Director of Credit on monthly debt reported and prepares trend documents and loan comparison analysis for executive leadershipPrepares loan portfolio data for public press releases Develops reports using Business Objects, Microsoft Access/Excel and Metavante 3270 Creates ad hoc reports to assist executive level leadership in determining errors in loan master data

Columbus, Georgia Area

Licensed in Securities, Series 6 & 63, Life Insurance and Variable LifePrepares, compiles, and submits daily branch goals in spreadsheetsCommunicates with clients and services account problems in ARGO and Emerald platformsEducates clients on investments and loan rates and provides guidance for making valued decisionsPartners with Loan Officers and other bankers to find client solutionsReconciles client’s accounts and offers solutions via phone conversation when neededMonitors and coaches tellers on daily goalsStatistical knowledge of the values of loansOrganizes daily client appointments to maximize sales opportunitiesOffers online support for banking clientsHas advanced experience in Microsoft Excel, Word, PowerPoint, OutlookTrained in fair and responsible lending, anti-money laundering, estate settlement procedures, fair credit

Philippi, Wv

Evaluate vendors sponsorship requestsResponsible for East Coast recruitment of players possessing the skills and talents needed for successful student athletesResponsible for compiling team statistics and sending files to the Conference DirectorsManaged team’s general business operation functions including renting facilities and purchasing equipmentPlanned daily practices and team travel arrangementsEnsured sound communication among all sports as the Sports Information Director of the collegeSupported both individual and team player developmentTrained and maintained an effective program (overall record 29-11)

Master'S Degree, Personal Financial Planning

- Statistical Methods for Science (SAS) - Statistical Methods I (SAS) - Advanced Statistical Methods (SAS) - Family Resource Management.

Mba, Management, Finance, 3.83

-Cost Accounting -Quantitative Analysis for Managers -Managerial Accounting -Finance -Managerial Economics -Business Research -Business.

Business Adminstration, Minor In Accounting

Activities and Societies: Alderson-Broaddus SIFE team Treasurer 2007, Alderson-Broaddus Baseball Team Captain 2008, Named.