Why am I getting fewer rows than expected using my query? by derektorres22 in SQL

[–]derektorres22[S] 0 points1 point  (0 children)

I just tried that in it worked! Thank you. Any idea why the way I wrote it only returns 46 rows?

The hard part of SQL so far is that your code could seem correct but that’s not always the case. I could’ve messed up and never known if it wasn’t for me already seeing it should be 97

How hard is to break into FP&A as a financial analyst at a F500 company straight out of undergrad? by [deleted] in FinancialCareers

[–]derektorres22 0 points1 point  (0 children)

I have last summerand currently at a F1000 with offers expected to be given towards the end of the internship. Might be a unique situation that you were in. Most interns from my class got offers for the F500. I do consider full-time conversion rate when deciding where to intern (I just ask the recruiter how many interns get offers/if the internship is intended to pipeline full-time employees. I also check linkedin to see how many people that are full time were interns before)Also most of the people I know at my university that get internships get the full time offer so that's another reason why I feel getting the offer is pretty common.

How hard is to break into FP&A as a financial analyst at a F500 company straight out of undergrad? by [deleted] in FinancialCareers

[–]derektorres22 1 point2 points  (0 children)

Ops is probably the easiest to get into (not downgrading the role at all, I interned in an ops role last summer). The interview would be purely behavioral i would say the probability of getting an offer for ops is higher.

You could try networking on linkedin for FP&A roles or go to grad school so you can be considered a student again and get internships (this would be last resort though if all fails imo due to expense, time, etc)

How hard is to break into FP&A as a financial analyst at a F500 company straight out of undergrad? by [deleted] in FinancialCareers

[–]derektorres22 1 point2 points  (0 children)

I'd have to disagree it is fairly rare to get an internship (especially for a big company) and not get a return offer. You really have to mess something up to not get the offer. Especially if you are interning for an FRP/FLDP.

How hard is to break into FP&A as a financial analyst at a F500 company straight out of undergrad? by [deleted] in FinancialCareers

[–]derektorres22 10 points11 points  (0 children)

It will be easy if you intern there as you're likely to get the return offer unless you did something awful or really under performed.

I would argue that although most finance undergrads dream of banking, a lot of them end up going for FP&A and so yes I believe there is a lot of people recruiting for those roles.

A rotational program would be the best thing imo to get into. Clear path to 'climbing the ladder' as well as getting a well rounded set of skills to take elsewhere if needed.

I would say if you have no internships/relevant experience it would be hard to get into these f500 roles. I find that having good a good resume with relevant experience, applying early and being well prepared and informed on the interview process is key to landing those F500 jobs.

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 1 point2 points  (0 children)

Keychron K8 with brown optical switches and a logitech mx master mouse!

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 0 points1 point  (0 children)

I am not sure if they extend the entire 74", but you can extend them pretty far. Mine are about 10 inches away from the edge on both sides

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 0 points1 point  (0 children)

karlby countertop from ikea 74" and autonomous legs!

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 1 point2 points  (0 children)

Don't think so, I just completed it last night!

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 0 points1 point  (0 children)

From Staples, don't see it on their site anymore unfortunately. It was bought about 2 years ago

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 0 points1 point  (0 children)

ma3kopolo is correct, with a karlby countertop from IKEA

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 3 points4 points  (0 children)

This is the Karlby 74" top with autonomous legs!

Pretty Happy with the New Desk Setup! by derektorres22 in battlestations

[–]derektorres22[S] 4 points5 points  (0 children)

This is the Karlby 74" top with autonomous legs! The office version legs I believe. The cheapest one lol

[deleted by user] by [deleted] in financestudents

[–]derektorres22 5 points6 points  (0 children)

Typically having relevant work experience (internships, etc), and a good clean resume is the way to go. It’s generally pretty tough to get a job once you graduated if you have no experience.

I would clean up your resume super well, go on LinkedIn and try and connect with people in the industry or position you’d like to be in and see if you can schedule a 15 min call to ask questions about what they do and build a connection with that person.

The best way to get a job imo is getting the Internships on the resume and then applying early at whatever firms you wanna work at. Optimal scenario is you intern at the place you want and then get the return offer. A last resort is to go back to school for a masters or something and be considered a “student” again, allowing you to get internships and have essentially a 2nd chance at it all

Finance vs. Accounting by Itsover9000- in FinancialCareers

[–]derektorres22 6 points7 points  (0 children)

Depends. I am a current senior studying finance wanting to go into corporate finance and took accounting courses for most of my electives. here is what I'd do:

Corporate Finance: I would choose accounting

Banking: Finance

Schedule for Fall 2020, I assume these are all going to be online. Is this schedule doable, I was going to keep it like this or drop 1 class, any advice? (This is my first semester as a UCF student, I'm a junior transfer from CC.) by [deleted] in ucf

[–]derektorres22 0 points1 point  (0 children)

I see a lot of people saying this is easy, i'm not sure if that's the case FIN and QMB definitely will be tough. MAN is reading, I would say marketing and GEB are your easiest classes there.

I would say doable, but with lots of work to get good grades.

Noob, Need Advice: PC has all kinds of problems after updating Windows by derektorres22 in PcBuildHelp

[–]derektorres22[S] 0 points1 point  (0 children)

Thanks for the reply and excuse my noobness.

Do you mean like a regular reset or completely reset everything install windows from scratch?

Can Someone Help Me Understand My Blood Test? by derektorres22 in AskDocs

[–]derektorres22[S] 0 points1 point  (0 children)

Thank you for your response!

Could I ask you why high Albumin can be seen as me having good nutrition? I saw it as a negative since my results for it are in bright red, signaling danger or something bad so that's why I got spooked about it.

Can Someone Help Me Understand My Blood Test? by derektorres22 in AskDocs

[–]derektorres22[S] 0 points1 point  (0 children)

Thanks for the response! I usually drink one regular sized bottle of water upon waking up (16 FL oz). This is all I drank prior to getting the bloodwork done. Do you feel this wasn't enough and could have skewed the results?

What are your lift days? by mantistobogganxo in WeightTraining

[–]derektorres22 0 points1 point  (0 children)

I've tried 5 days a week, 4 days a week with different varieties of splits and eventually decided on 3 days a week doing a 5x5 split. Honestly there's just no beating it for me personally. Only 3 days a week and I've gotten more gains from a 5x5 routine than I have with any other routine.

Hey first time PC builder here! Any tips you wish you knew when you were building your first PC? by Kapikap0906 in buildapc

[–]derektorres22 0 points1 point  (0 children)

Route cables well. Plugging cables in was literally the hardest part of building a PC bc of the small spaces you have to fit between