Peter Pollock Email & Phone Number

Columbus, Oh, Us

Columbus, Oh, Us

Columbus, Ohio, Us

Partner with Data, Finance, and Business Analytics to deliver cost-saving solutions to internal and external clients, managing data analysis, queries, and reporting to provide insight to fuel data-driven decision making. Perform accounting functions including A/P and A/R from key accounts—leveraging QuickBooks Enterprise, Crystal Reports, Power BI, and SQL—reconcile voluminous transactions, solve complex billing issues, and advise the accounting team on process, procedure, and control changes. Step in and assist with any and all day-to-day operations functions whether championing strategic priorities, or lending assistance on the production and warehouse floor.■ Drive continuous performance and process improvement, recognizing opportunities to close gaps, eliminate redundancies, and improve cross-functional collaboration—internal and external—and communication.■ Heavily involved in the design, testing, and deployment of new business analysis tools—Waterfall and Agile methods—proving vital during the testing process to ensure optimization of systems and environments■ Created complex monthly reporting packages for the company’s largest clients, tracking all shipping costs and comparing with historical data, providing daily updates on inventory, countdowns on projects and other visualization of data by migrating from Crystal Reports to Power BI and using this expertise to customize invoices and reporting to all customers.■ Designed a process to migrate invoices from a homegrown TMS by upgrading invoice process by integrating with Azure Database and Extensiv WMS. Integrated Billing Transactions into QuickBooks Enterprise, facilitating error checking, removal of duplicates, and weekly batch uploading. Providing strategic ideology, logic implementation, error correction to create easy customer access to their information within our TMS.■ Reduced order processing time by 60% through improved Warehouse Management System (WMS) procedures.

Columbus, Ohio, Us

Assumed concurrent responsibilities as facilities data analyst for the university and the medical center for two consecutive years. Charged with maintaining, updating, and reporting on core space utilization and cost for 65,000 rooms in 850 buildings throughout the university. Primary liaison with leadership, architects, engineers, consultants, vendors, and external reporting agencies to manage, update, and report on space information.■ Developed an automated means to produce two large Plant Operations & Maintenance and HEI State reports bi-annually. Built MS Access databases and tools to capture and report on critical data leveraged to collect $151M in reimbursements from the State of Ohio.■ Collaborated with the Facilities Assessment team to integrate data from the 7 campuses into the EvolveFM system. Developed tools to extract data from text files and Excel spreadsheets into the system as assets expanded to 93,000 rooms and 37,500,000 gross square feet in 1,375 building on 1,850 acres.■ Partnered with vendor to implement new features into the EvolveFM system that improved overall decision-making and reporting capability for sponsored research, student life, residential facilities, and food services. Interfaced with leadership and end-users to document needs to expand functionality and accessibility of financial, facilities, and construction data that was leveraged in building new hospital.

New York, Ny, Us

Database Access Administrator, Enterprise Access Administration (2015)■ Supported platforms including Oracle, SQL, Sybase, Teredata, and DB Toolkit; updated user access, schemas, and scripting access across all platforms. Managed daily administration and fulfillment of access requests.■ Work with domestic and international DBA teams-across the U.S., Europe, India, Singapore, and Hong Kong-to provide quality and timely access to worldwide database related to Finance, Loans, Card Services, and more.

Columbus, Oh, Us

Promoted to track, validate, and manipulate data within the facility management system to ensure the accurate processing of financial, facilities, regulatory, and departmental reports for 23,000 rooms in 57 buildings within the medical center. Interfaced with stakeholders and vendors to implement new functionality and resolve issues.■ Within 4 months of assuming new role, improved the overall quality of reports and mitigated financial risks to the medical center. Collaborated with departments and vendor to verify fields, update data, and eliminate functional and data quality issues within the IBM Tririga facility management software.■ Produced 125 annual financial and facilities reports leveraging MS Access and Excel. Developed tools to capture and extract data from large MS SQL Tririga system that encompassed more than 21,000 records.■ Contributed to researching, evaluating, and overseeing the replacement of IBM Tririga system with EvolveFM facilities management software that improved regulatory reporting capability. Liaised with users and vendors to identify and resolve integration, data quality, and functional issues.■ Designed, built, and produced portfolio of reports for senior leadership, departments, colleges, regulatory agencies, and facilities. Leveraged SQL Server Management Studio to extract, upload, and report on data residing within the EvolveFM database.

Columbus, Ohio, Us

Recruited to capture, enter, manipulate, and analyze data within CollegeNET’s Schedule25 and Student Database Management systems to determine optimal space allocation for 4,200 classes for the Winter and Summer semesters, large conferences and orientations during the Summer, and outdoor events held throughout the Winter, Spring, and Summer months. Interfaced extensively with all departments within the university to solve scheduling conflicts.■ Held critical role in rolling out new web-based scheduling system within 90 days to meet registration deadlines. Tested functionality of new system, validated accuracy of data following conversion, and interfaced with vendor to resolve all issues. Evolved as the Super User on the system, designed and delivered monthly training to users on new scheduling software, and liaised between vendor and stakeholders to enhance system.■ Collaborated with Classroom Services to integrate new data into web-based scheduling system that reduced scheduling issues for 420 classrooms. Conducted bi-annual physical audits of classrooms and updated information within the database.■ Partnered with multiple departments within the university to streamline the scheduling of outdoor events within the system, optimizing the safety and security of students, staff, and the public.■ Developed MS Access database that provided an automated means to research for needed resources.

Columbus, Ohio, Us

Provided support to the Dean and Associate Dean with all administrative functions and special projects. Created quarterly and yearly enrollment reports, processed travel requests, and created promotional materials for events.■ Participated in a large-scale project for the Dean to support a committee established by President Bill Clinton. Electronically filed and archived 1,000+ declassified Kennedy Assassination Records Review Board files.

Architecture - Building Construction

Business Information Systems