Paul Mcfarlane Email & Phone Number

1111 Marcus Av

• Prepares and presents comparative analysis reports including trending and improvement recommendations using PlanningAnalytics (IBM) to leadership.• Leads a team on a $80 million budget analysis where we collaborate with leadership to ensure budget transparency andaccountability.• Reports to leadership key findings in areas such as recruitment, compensation comparisons and turnover rate.• Collaborates with HR Areas to develop and maintain scorecards in alignment with system/department goals.• Creates SQL scripts to pull data for various AdHoc requests and recurring projects.

Queens, New York, United States

• Provide reports and analysis, including performance, financial and cost savings summaries• Work with branches to ensure process efficiencies are implemented and maintained• Participate in execution, implementation and monitoring of process improvement initiatives and performance metrics• Travel to branch locations to conduct inquiries, analysis and audits

Queens, New York

• Provides insights and seeks trends on the air pollution status using SQL, with roughly 150 data sets around NYC area.• Applies story telling skills to given data sets to help Dept. of Health understand neighborhoods the most greatly affected by air pollution using PowerPoint presentations.• Uses Excel statistical models to find correlations between the measured air and source of pollution near the site.• Analyzes specific air pollution sources, proposes solutions based on cost, effectiveness etc.• Manages inventory budget and ensure budget is allocated appropriately and evenly.• Creates Powerful dashboards using graphs and visualizations that are being continuously updated.• Participates in complex projects and performs other duties as assigned by Manager.• Publishes reports and dashboards using Power BI.

New York New York

● Utilized data visualizations tools such as Tableau and Power Bi to analyze data sets and find insights.● Worked with a small team of four to present data findings on Apps and their installs through visualizedPowerPoint presentations.● Learned how to analyze website traffic through Google Analytics and understanding the metrics to helpmake recommendations to improve websites.● Expanded knowledge of excel by using Vlookup and Pivot Tables to categorize and organize data sets.● Logged over 200 hours learning the hard skills but also on communication and values at a workplace.

Queens, New York

● Drew blood from many different people who came into the hospital ages ranging from 12 to 95.● Entered patient’s information into the data base.

Urban studies B.S