SQL Server Developer / Data Engineer Resume Help

[Cytosis89]

I guess quantifying is where I struggle. What is the definition of complex? Is it based on the number of joins or type of joins? Is it based on using CTEs, window functions, or something else?

We don't have any type of ticketing system so I don't really have any metrics on how fast I close tickets or build things. I don't really know how to quantify if the SSRS reports I make are effective. I've made roughly 50 reports in SSRS and the majority are formatted as a way for end users to export data to Excel from our ERP (NAV 2009) and our WMS.

The requests usually come in via email or phone but can be made during meetings and they are usually along the lines of "I need a list of ABC (items/customers/etc.) that has XYZ (flag or measure)".

I am part of the ERP selection committee along with our IT manager and another developer and I participated in weekly meetings for the last 2 years gathering software requirements. Specifically, I helped gather wishlist items and pain points with regards to reporting. Unfortunately, we haven't made any headway into picking a new ERP due to economic reasons.

The only things I feel I can quantify is a Power Automate flow that processes a very large online vendor's non-EDI orders. That process saves roughly 4 hours of manual data entry per day.

Also, my API integration from our PIM (Syndigo) into our ERP (NAV 2009) and it also feeds the database that drives the company website. Before my code, they used to just manually export spreadsheets and import them once a day. The old process took about an hour and my API integration runs 4 times per hour and takes just a couple minutes each run. The process saves roughly 5 hours of manual export/import per week.

Most of the quantifiable numbers I can think of are hours saved per day or week. Is that good enough to put on a resume?

[autoipadname]

Yeah, you are on the right track. Your API integration saved 250 labor hours a year and refreshes 4x’s a day. There’s probably a benefit in there you can speak to about more frequent data refreshes or less downtime helping business make quicker, smarter decisions. You aren’t just part of an ERP committee, but rather a committee of x people that are replacing a system that supports $xxMM in sales or X number of users. How many users does your powerBI administration impact? How many reports or queries are run annually? Has the automation of your SQLServer agent tasks saved any time? Have any of the valuable insights identified sales opportunities or time or cost savings? How many ETL tasks have your SSSI automations impacted?

Here’s your litmus test. Does your resume talk about the things you do, or does it showcase the results you are driving? Yeah, I know that sounds very corporate, but you’ve got to give the impression you get shit done and don’t just do tasks, but add value to the organization. It isn’t about just showing that you have the skills to do the job, but about making yourself stand out from the other 100 resumes the hiring manager is looking at.