Recruiters and hiring managers, I humbly welcome you to…

David Cloonan’s “Hire Me” Page!

I won’t bore you with a ton of “about me” stuff… that is all in my resume and LinkedIn. I just wanted to make a page where you could see examples of my work and what I do outside of work.

The slidesbelow are here to demonstrate what you can expect me to provide you. If you would like to download a PDF of them to see them at full size, please click here.

The purpose of the dashboard here was to give insights into the company’s sales pipeline at both a company level and be able to be drilled into at divisional, regional, and market levels.

The first slide shows a summary of all sales currently in the pipeline by where they are in the sales process. The second slide shows a visual representation of how the dollars flow through different statuses from beginning to end. This shows stakeholders the likelihood of certain jobs being completed.

A spreadsheet showing sales data, opportunities, and top active opportunities by total amount, with various filters and totals.
A flowchart diagram illustrating a sales process with multiple stages and outcomes, including prospecting, estimating, qualifying, proposing, closing, and various review and loss points, with different nodes representing stage transitions and counts.
A dashboard with four pie charts showing opportunities at various stages of a sales process. The charts illustrate the distribution of opportunities in stages 1 through 4, with labels such as Prospecting, Qualifying, Estimating, Proposal, and Closing. The top part of the dashboard includes filters for marketing bucket, fiscal year, month, vertical, created by, starting stage, stage 2 and 3, path end, and opportunity count. There is an informational note at the bottom explaining that the pie charts display the number of opportunities at each stage to track progress.
A data table and line graph related to sales opportunities and sales process stages. The table includes columns for marketing bucket, fiscal year, date, vertical, created by, starting stage, stage 2, stage 3, path end, and opportunity count. The graph plots the average time between stages and opportunity count across stage changes.

These slides were created to give insight into lost jobs. We can drill into who created the job, where it was coming from, and what business area it was related to. Then we can look at for example, if we are constantly over bidding on commercial properties. Or if we have one sales rep who is continually adding jobs to the pipeline that all close out as being a bad fit for the company.

Business dashboard with tables and charts showing financial and operational data. Includes a line graph tracking metrics over different fiscal quarters, a pie chart illustrating product distribution, and a bar graph depicting values across various periods.
Spreadsheet dashboard displaying marketing data, pie charts, and bar graphs related to financial and project metrics, with various categories and percentage breakdowns.

These slides are here to show how the total value of the pipeline fluctuated by status from a month to month basis and if we were recapturing opportunities properly. These required a custom DAX scrip that I wrote that was about 1000 lines in order to properly cleanse and transform the data to where it was usable.

A data dashboard with pie and bar charts, filters at top for marketing, fiscal year, month, vertical, service lines, created by, starting stage, current stage, and clones created, displaying financial and operational metrics over multiple quarters.
A financial data dashboard displaying bar charts and waterfall charts. The left side shows a bar chart with percentages for different categories such as Closed Lost Re-entry and MKTG Cloned, Not Cloned. The right side features waterfall charts illustrating revenue or financial changes with increase, decrease, and total segments in green, red, and blue respectively.
A financial dashboard with three bar charts showing data over time from June 2022 to March 2023, including filters for fiscal year, quarter, month, division, and region.
A detailed financial report with tables, and pie charts showing sales, revenue, and regional data for different divisions and regions.

Next Steps

Other files you should have:

Resume

Notable Accomplishments

Okay, if you made it this far, go ahead and copy and paste this script into where ever you run your R scripts. It should take the guesswork out of what to do.

library(RMySQL)

host <- "localhost"
user <- "BestRecruiter"
password <- "HireDave1985!"
database <- "CoolestCompany_OpenPositions"

con <- dbConnect(MySQL(), user = user, password = password, dbname = database, host = host)

update_query <- "

UPDATE applicant
JOIN job_listing ON applicant.candidateID = job_listing.candidateID
SET applicant.action = CASE
WHEN applicant.candidate_name = 'David Cloonan' THEN 'Contact for Interview'
ELSE 'Thank you for your interest.'
END
WHERE applicant.action IS NULL
AND job_listing.position_name = 'This position'
"

dbSendQuery(con, update_query)

dbDisconnect(con)

Email me quick before all the other cool companies get to me first!

dcloonan.jr@gmail.com

Last Ditch Effort

If everything else didn’t convince you to contact me about your open position… I hope that these pictures of my kids and dog will guilt you into wanting to help me provide for them.

A young girl with curly hair wearing a fake mustache on her face and a colorful shirt in a room with shelves, chairs, and a rainbow rug.

Elliott

Close-up of two sleeping dogs lying on colorful blankets on the floor in front of a brown couch.

Peanut

A young girl wearing glasses and a black t-shirt with yellow text, holding a display of small buckets with decorative handles in yellow and red. She is smiling slightly and has messy hair. In the background, there are various hanging clothes and storage containers.

Esther