Nestmann, Jason Email & Phone Number

Louisville, Ky, Us

Louisville, Ky, Us

Louisville, Kentucky Area

* Based on requirements gathered from users, developed VBA to automate invoice reconciliation process by extracting data from multiple sources and transforming that data into standardized, cross-linked reports, summary dashboards and file feed for integration into Dynamics GP.* Translated PDF form into an Excel template and wrote VBA to aggregate multiple forms into a summary report.

Jeffersontown, Kentucky

* Assumed responsibility for a core data system (MIST)* Wrote VBA automating monthly coldate reporting, including monthly summary, by-state revenue reports and KY CET tax report.* Wrote VBA to prep contractor collection reports for loading into database.* Assumed Accounts Payable responsibilities in Oct. 2018.

Lexington, Kentucky Area

* Wrote VBA automating monthly budget reporting for entire division of Undergraduate Education.* Developed tutoring center traffic dashboard* Created interactive PowerPoint for marketing event (Wildcat Jeopardy)

Winston-Salem, Nc

* In 2004 Brown & Williamson merged with RJ Reynolds* Obtained SPHR certification* Prepared and maintained RJ Reynolds Affirmative Action Plans and associated government reporting* Implemented reporting changes to comply with new EEO regulations concerning expanded definitions of ethnic / race groups* Coordinated company response to OFFCP audits* Participated on the HR-IT Prioritization Team and IT Security Roundtable* Served as SharePoint administrator for all HR department team sites* Identify and capture performance metrics to assess the success of the HR function* Manage and report data to HR Project Management Office as well as assist in the design of new reports* Learned Excel VBA in order to streamline disparate treatment analysis in annual performance management process saving a day of work while also increasing accuracy and scope of analysis

Louisville, Kentucky Area

* Provided technical support during the Brown & Williamson, RJ Reynolds merger, tracking the identification, job offer, and deployment of approximately 800 ongoing field sales staff and the release of approximately 400 employees* Participated on the PeopleSoft upgrade team, migrating from 7.5 to 8.2, and subsequently assumed responsibility for PeopleSoft 8.2 security* Learned HTML in order to maintain the HR section of the company intranet, including the publishing of the Employment Practices Manual and Summary Plan Descriptions* Wrote instructional guide for managers on using Kalendra software for annual merit reviews

Louisville, Kentucky Area

* Audited pension records, specifically healthcare deductions, for Brown & Williamson Tobacco Co* Corresponded with retirees concerning healthcare deductions based on audit results* Directed outside vendor on necessary changes to restore appropriate balances