• Partnered with Automation and Global Technology Operations to implement new skills and capacity tool, Retain. Using my background, I was able to save time and money on the project, allowing resources to be distributed to other projects within Audit. Retain was released on time and under budget and will impact all of Audit.• As part of larger Retain project, I partnered with Automation to build a new version of the Audit Staffing Tool (system of record for Audit staffing data and organizational structure), that utilizes Tableau for reporting and feeds multiple Audit specific tools (i.e. Domino, ORCIT, Retain, Skills Library, etc.). This involved learning Tableau and SQL to be an informed tester and owner of business requirements.• Owned analytics and user interface portion of 2018 Skills Assessment. This involved creating WebSurveys, collecting the data from those surveys, establishing clean workbooks of 30k records to distribute, and a way to share the data while maintaining confidentiality of results. Over 200 skills were assessed across more than 900 employees, touching each area within Corporate Audit.

 Control new hires, updates, transfers, or terminations of benefits for all US Salary or US Retiree employees which involves data entry into EmPath system, sending COBRA or FSA notifications, and correcting and tracking any errors found in the EmPath system Run monthly Pension Reconciliations using reports from Bank of New York and verifying the data against EmPath (our system) reports; submit checks and backup materials to accounting for processing Run monthly Retiree Medical Phantom Account reports which involve reviewing current retirees on a specific medical plan and sending notice of plan cancellation or change in payment Run monthly 401k Fidelity Funding Contributions reports for salary employees Provide Business Objects reports as needed Improve current insurance reporting processes by streamlining reports in Business Objects and Excel (Blue Cross Blue Shield and Express Scripts reports) Run weekly Fidelity Feedback File Reports and provide results to Payroll Speak with employees, retirees or surviving annuitants and answer any questions they may have about their benefits and/or 401k loans or contributions

 Managed technical support for Corporate Workplace data tool, INFACT, which involved helping create reports in system, pulling report details in SQL when reports would not run in INFACT and running the SQL in SQL Developer, and reporting any data feed errors or data issues to technical team Taught educational classes on INFACT (both customized sessions and basic) in person and/or over the phone using Live Meeting; recorded these sessions using Camtasia Studio and posted videos on SharePoint for On Demand training Delivered monthly and quarterly statistics regarding data integrity issues and questions around INFACT; used Excel to compile data, PowerPoint to present findings and Quality Center as the source of the data Conducted informational presentation for large groups as part of our groups BEST Ideation campaign; involved interviews, research, PowerPoint, video recording and presenting

 Created Year End Reporting templates (referred to as “Manager Reporting Package” in Year End 2009 Manager Toolkit), utilized by Compensation and Managers across the bank, which allowed Executive ready analytics (i.e. 9-Box Grid, Associate Detail, Spend vs. Funding Grids, etc.); written in VBA via Excel Macro and used vLookup and various Excel functions Owned Compensation Reporting Tool (CARS) – maintained data integrity and worked with technology team, HRIS, to resolve issues; took data integrity questions via SharePoint InfoPath forms which I created; over 100 Compensation associates utilized system Lead several training courses for different tools (Access databases, Excel templates, CARS and eWorkplace) and processes within Compensation Responsible for Global Compensation SharePoint site and Shared Drives – maintained users, alerts, materials and data storage size; involves InfoPath, SharePoint Designer Helped establish access for new Compensation LMER associates (i.e. access to tools, shared spaces, etc.) to aid in transition; worked across LOBs Owned critical Plan ID Cleanup Tool – updated/maintained Access Database tool which assigns all associates Plan IDs by editing on the backend (involved multiple queries and table joins); assisted Compensation in creating Plan IDs and assigning all LMER (merged) associates to BAC Plan IDs; improved number of defects through analyzing associates and working with Compensation (decreased defect percentage from 15% to .05%); created various versions of Tool for backup or specific business which involved Access queries, joins to other databases, and switchboards Participated in UAT Testing of new payroll tool used across the company; involved data comparisons and logical tests in tool

 Year End 2006 Lead for LOB which involved communications to managers and HR team via PowerPoint decks, ensuring all deadlines are met by team members, creating Excel templates and teaching others how to use the embedded functions, and working with the HR team to meet their needs as well as the managers’ needs GC&SBB Reporting Lead in 2006/2007 – handled all reporting aspects of major GC&SBB processes (Year End, Total Comp Planning and Market Assessment) by creating processes for each Sub LOB to follow to ensure a smooth process, responsible for final Excel and PowerPoint templates/decks presented to top executives, and attended meetings with executives to review data Implemented and recorded several new processes to improve transactions and enable smoother transitions in the future – improvements were shared across the enterprise Developed automated SharePoint process from scratch for scoring FLSA Status of job codes for enterprise wide Legal Review. Learned new software, maintained SharePoint site, downloaded/uploaded data from website to Excel to Access, and answered any technology questions that arose.

 Assisted in executive event logistics by tracking attendees, preparing checklists, creating briefing books for various market visits, and being on-hand for any needs that may arise during an event Arranged meals for 2005 & 2006 Senior Leaders Meeting/Broadcast (top executives) Created Access database for tracking speaking opportunities as part of Executive Communications Greenbelt Project (did not receive Greenbelt, only assisted) Responsible for Senior Leader Meeting website which was HTML based  Participated in launch of new BAC Website, outsourced through PRNewswire, by categorizing speeches, updating press kits, recoding source in HTML for ADA Compliance standards, updating biographies and RCC photographs Developed multiple workbook Excel documents for executive speech tracking Provided basic computer technology/Microsoft Office support for team

 Streamlined Student Billing process through introducing excel documentation, utilizing Blackbaud software to its full extent, and decreasing the amount of paperwork involved Maintained Fixed Assets Depreciation Schedule for yearly audit Participated in yearly audit by gathering information and answering any questions regarding Student Billing Created and sustained Procedure Manual for Business Office Maintained monthly Accounts Payable and Bank Reconciliations for five accounts Ran summer camp programs by creating pamphlets and advertisements, collecting funds, tracking insurance and personal information of campers, and figuring the wage of the camp counselors Attended FE7 training at Blackbaud University Participated in 2004 November Gala, a fundraiser for the new high school, by learning the software used to collect funds and teaching the volunteers how to utilize the software