Lisa Mackenzie Email & Phone Number

Lunenburg, Ma, Us

Lunenburg, Ma, Us

Build best-in-class finance and accounting systems at a rapidly growing company.● Provide expertise and leadership to the company’s design, development and implementation of Sage Intacct.● Restated historical data from QuickBooks to Sage Intacct.● Integrated Service Titan, Bill, Silicon Valley Bank and Adaptive Planning with Sage Intacct. ● System Administration for Sage Intacct post go-live.

Tokyo, Jp

Manage ongoing integration, implementation and automation of financial systems and tools.● Provide project oversight to the PO Accrual Automation solution, project team member for the SAP MDG implementation and DoA Ariba rollout.● Partnered with FP&A to standardize reporting slides for the Long-Range Forecast utilizing CFOinUP dashboard.● Created an on-boarding document for new hires within the Finance organization. Including system access request forms and system overview documentation.● Provide oversight for analysis of user problems related to systems integration and related reporting systems. Developed an Issue Tracker to document system integration discrepancies and worked with users and system owners to resolve.● Key USBU Finance representative for the 500K Hours Think Tank project. Identified three areas of opportunities for automation including CFOinUP reporting standardization, PO Accrual Process Automation solution and DOA Ariba implementation project.

Billerica, Massachusetts, Us

Provided expertise and leadership to the company’s design, development, and implementation of SAP Business Planning and Consolidation (BPC) software. Provided ongoing expertise and training to continuously improve the company’s financial system and process capabilities. • Administered and optimized BPC including source system data integration, metadate dimension management, business rules and calculations, report and input template design and development, application security, system performance tuning and readiness, acquisition integration and transport collection. • Collaborated with the Treasury team to build out two additional BPC models for weekly cash reporting and a rolling three month cash forecast. Including creating the requirement and design documentation, developing the solution, creating test scripts for UAT, facilitating UAT, training and deployment. This project enabled Bruker to better plan for where the sources of cash are coming from and determine in advance the need for global movements of cash to meet operating needs.• Support internal and external control efforts in conjunction with Brukers SOX compliance program. Including System Development Life Cycle (SDLC), security access and reviews and external general ledger account mapping to BPC. • Managed the annual BPC EPM Excel-Add In upgrade project including identifying the most stable version to upgrade to, unit testing, coordinating UAT, setting up SharePoint site for documentation sharing and communicating go-live.• Provided oversight to a team of BW and Infomotion consultants to prioritize on-going deliverables. Including facilitating weekly team meetings, ticket monitoring, issue resolution and patch and upgrade recommendations.

Marlborough, Ma, Us

Financial Consolidation, Planning and Reporting Manager, overseeing a staff of 10 developers and BA’s. Created the vision, scope, objectives and overall strategy for the group including organization structure to align goals. • Team member on the Financial Consolidation, Planning and Reporting project to deliver a consistent view of the enterprise, improve the quality and availability of information and provide new business insight on which strategic decisions can be based. Primary focus is on leading the Hyperion Financial Management consolidation and reporting implementation, replacing Hyperion Enterprise. • Managed the Guidant Enterprise Integration project providing timely consolidated results to the finance community. Developed, analyzed and executed the project plan. Identified potential issues and facilitated issue resolution. Developed and delivered user training and documentation. Identified process improvement opportunities and implemented solutions. Effectively communicated project status to the leadership team.• Participated in the International Systems Alignment, Divisional Realignment, Restructuring, and Divestiture projects. Including, developing and documenting the new structures in Enterprise, testing new mapping scripts in Upstream WebLink, creating separate Hyperion Enterprise and Upstream WebLink applications for divested companies and moving the changes into production in line with expectations.

Marlborough, Ma, Us

• Strong knowledge of data transformation from managing numerous acquisition assimilations including data transformation from the local general ledger systems to Hyperion Enterprise to data transformation from Novo, ICRT, Pillar, Planning, WWSD and APEX. • Member of the Data Governance Council established to provides a framework to define and sustain common data definitions for use across the Enterprise. Managed the cost center cleanup effort across multiple systems.• Led a global, cross- functional team to centralize the Hyperion Enterprise infrastructure and to redesign the Hyperion Enterprise application. Utilized the Cadence Project Management techniques to develop a plan to implement on time and within budget. Received recognition from the Corporate Controller with an Outstanding Leadership & Teamwork plaque. • Established a Training committee to provide global training for Hyperion Enterprise and the monthly close process.• Partnered with I.T. to support and maintain the server environment, establish backup procedures and reboot schedules. Established a communication process for sending warning messages to users on the system prior to the backup and reboots to alert the users to log out of the application. Facilitated hardware and software upgrades and patch initiatives. Performed benchmark performance testing and assisted with improving performance within Europe and Japan. • Participated on the vendor selection team to assess business requirements and vendor strengths and weaknesses for a new mapping tool to map multiple sources of data into Enterprise. Managed the global implementation of the new Upstream WebLink data transformation tool.• Designed, developed and implemented a new Hyperion Enterprise application in support of the Euro currency conversion within Europe.

• Designed, developed and implemented Hyperion Enterprise consolidation and reporting software worldwide.• Created an automation process for reconciling financial data eliminating hours of manual effort.• Maintained the Hyperion Enterprise application as business and management requirements changed.• Liaison between Corporate and Operating Units for financial reporting systems.• Redesigned reporting capability to track currency exchange rate impact for senior management.• Redesigned the Hyperion Enterprise security access rights and established standard procedures to obtain an account on Hyperion Enterprise.

• Developed, tested and implemented Hyperion XA consolidation and reporting software worldwide.• Migrated business analysts to a WinFrame server used to access Hyperion XA, Excel Retrieve, and Analyst eliminating the need to support multiple platforms.• Defined, tested and implemented the data load, consolidation, data extract, security, and reporting WinBatch macros eliminating the need for manual intervention.• Designed and implemented security access rights to prevent business analysts from viewing or modifying proprietary information in the Hyperion applications.• Resident expert for Hyperion XA, Excel Retrieve, and Analyst issues.

• Responsible for the monthly consolidation and reporting of financial results for Corporate and the America’s zone.• Developed and conducted Micro Control Report Writer training in Europe.• Enhanced the Worldwide CTB Adjustment module resulting in increased productivity.• Participated in the development and maintenance of the Micro Control reporting and consolidation system for the Corporate Shared Service Center.• Managed the adjustment process in a fast paced corporate environment and supervised the individuals responsible for data entry.• Coordinated the Worldwide Consolidation and Reporting calendar.• Developed and executed user acceptance testing for the currency exchang system.• Developed and maintained the Micro Control reporting and consolidation system for the General International Area.• Consulted with financial analysts to include budget and forecast in the reporting system to produce comparative reporting for the business analysts.• Implemented Front End validation software and Micro Control reporting software in the Latin American Caribbean HQ’s and provided training.• Provided Micro Control Retrieve training to financial analysts enabling them to produce financial presentations in a timely manner.• Developed a data transmission model (Lotus) reflecting the FY92 reporting structure, and released it to the Latin American Caribbean district. As a result of my dedication and work excellence, I received recognition from the remote districts, LACR HQ’s and GIA staff and was the recipient of a FINANCIAL EXCELLENCE AWARD.• Collected, verified and distributed accounting data enabling smooth budget and forecast cycles.