Data Analyst

PETER CAMPBELL

516-***-**** • *****@*******.***

*** **** **** **, ***. 3B, New York, NY 10028

EXPERIENCE: Data Analytics Consultant Jul 2018 – Feb 2021 QueBIT Consulting, LLC, New York, NY

● 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.

Actuarial Analyst May 2015 – Jun 2018

Dickinson Group, LLC, Uniondale, NY

● Determined viability and estimated 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.

● Used the Indirect function in Excel to increase efficiency and decrease errors when updating the fund’s recent year’s claims experience and eligibility counts.

● Created and maintained Excel programs that calculated pension benefits using functions, including VLOOKUP, to display the benefits in a user-friendly format.

● Calculated pension and annuity benefits utilizing Excel and provided detailed calculations to the client, along with alternate options. Accounts Research Analyst October 2014 – May 2015

Election-America, Inc, Mineola, NY

● Researched and contacted potential election clients to initiate the sales process.

● Provided technical support to members needing assistance with electronic voting.

● Updated SQL code used to instruct voters in mass emails. Senior Statistics Tutor/Statistics Tutor January 2011 – May 2013 Cornell University, Ithaca, NY

● Mentored other tutors and tutored students in statistics courses.

● Promoted the Learning Strategies Center offerings in presentations to statistics classes. EDUCATION: Cornell University May 2013

Bachelor of Science in Biometry and Statistics

Concentration: Statistics

SKILLS: Proficient: Microsoft Word, Excel, and PowerPoint, IBM Planning Analytics (TM1, for Excel, Workspace), TurboIntegrator (ETL)

Familiar: Statistical Software Packages R and S+, Java, SQL, Python

Contact this candidate