Peter Campbell Email & Phone Number

New York, New York, United States

● Streamline processes and analyze data using VBA macros and advanced Excel formulas such as lookup and text functions● Analyze data using Pivot Tables and data visualization tools like Excel charts and Power BI● Provide data analytics support to other departments, including physicians and upper management, by creating, maintaining, and adjusting large Excel files (700,000 records)● Present Excel training to entire company via webinar● Oversee Treasury, Accounts Payable, and more by performing tasks such as managing banking data, processing invoices, and coordinating files for annual audits

New York, United States

● Solved clients’ financial business problems by increasing efficiency, improving usability, and decreasing errors using IBM TM1 - Planning Analytics (PA).● Assisted with the build, test, and deployment of IBM PA for clients to view Income Statements, Balance Sheets, and other financial data more easily.● Created and improved TurboIntegrator processes to extract, transform, and load data from multiple sources.● Wrote, reviewed, and updated IBM PA rules for better functionality.● Improved performance by editing SQL queries that access relational databases.● Enhanced user interfaces by creating input templates and financial reports with dynamic parameters in Planning Analytics for Excel and Planning Analytics Workspace.● Provided help desk support to clients; trained clients, both users and developers, on IBM PA; wrote and edited user manuals.

● Determine viability and ​estimate future liability of funds by comparing projected financial additions to projected financial deductions based on a fund’s past claims experience and past contributions in Excel. ● Use the Indirect function in Excel to increase efficiency and decrease errors when updating the fund’s recent year’s claims experience and eligibility counts​. ● Create and maintain Excel programs that calculate pension benefits using functions, including VLOOKUP, to display the benefits in a user-friendly format. ● Analyze pension plans to provide customers with diverse benefit options. ● Calculate pension and annuity benefits utilizing Excel and provide detailed calculations to the client.

Mineola, Ny

● Researched potential election clients to identify the decision-makers. ● Contacted (via telephone and email) the decision-makers to initiate the sales process. ● Provided help desk technical support to members needing assistance with the electronic voting process. ● Updated SQL code used to instruct voters in mass emails.

Ithaca, New York Area

● Mentored other tutors and tutored students in statistics courses. ● Promoted the Learning Strategies Center offerings in presentations to statistics classes. ● Organized and managed the statistics lab.

Ithaca, New York Area

Supervised peers, assisted chefs, and performed maintenance duties.

Master'S Degree, Business Analytics

Bachelor Of Science (Bs), Statistics