Compiling the Job Portfolio Optional conferences 3 30pm 4 45pm Job Portfolio is due Optional independent conferences What Chat face to face I ll do my best to answer questions and offer suggestions No appointment necessary Where Office hours via Zoom When 3 30pm 4 45pm What should I bring Specific questions Depending on how many people show up a question like can you look at my portfolio is asking too much A question like do you have any suggestions on how I can better tailor my resume is solid How to compile the portfolio Submit the portfolio as a single document This may cause formatting issues with your resume Doc and PDF are both acceptable Each document should start on a new page When in doubt please ask At this point we ve covered 2 Finding a job internship or graduate program 4 Resume 5 Job application cover letter 6 List of interview questions which is just a list of questions We still need to discuss 1 Portfolio cover letter 3 Audience analysis 7 Interview reflection analysis 2 cover letters Portfolio Cover Letter This is a professional document which summarizes the contents of the portfolio It also includes a table of contents with a page number for each document This is the exact format a portfolio cover letter should follow for this assignment Numbers are flush right Points will be deducted why Story time Provide a large bowl of M Ms in the breakroom Remove all red M Ms If the stage manager finds red M Ms in the bowl they know the venue didn t read the contract closely enough What else did they not read You only get one first impression To err is human The stakes are high when it comes to professional documentation From the organization s standpoint you ve had all the time in the world to create a perfect document and yet mistakes were still made Question Does a single mistake on a professional document mean it s the end of the world 1 Create a table 2 Slide the center column line to the right 3 Fill in table with portfolio contents 4 5 6 Highlight select the table Right mouse click to open menu Select Table Properties 8 7 Example of audience job post analysis structure What position is the job post advertising Which website hosts the job post When was the position posted How is the job post organized Summary responsibilities preferred qualifications requirements etc What are the 3 primary attributes Why are these 3 primary attributes important for this position How do you apply for this position Who is the primary and secondary audience What tone and diction should you use Where did this structure come from From top to bottom The structure of your response oftentimes mirrors the question original documentation Sara Carter sent you 5 questions You answer the questions in the same order as they were asked Write an analysis of the job post Use the structure of the job post to write the analysis What position is the job post advertising Which website hosts the job post When was the position posted How is the job post organized Summary responsibilities preferred qualifications requirements etc What are the 3 primary attributes Why are these 3 primary attributes important for this position How do you apply for this position Who is the primary and secondary audience What tone and diction should you use Remember to use paragraph breaks 1 Overview of position history office location etc 2 Three most important characteristics in the job post 3 Primary audience tone style contact information etc 4 Conclusion Offer a brief overview of why you re qualified for this position excited about the position Basic questions I will be asking on the interview analysis Is the analysis organized both in terms of format and ideas 1 2 Does the writer use paragraph breaks and or transitions between paragraphs 3 How many sentences make up a paragraph Is it possible to have too many sentences in a paragraph 4 What is the longest sentence you can find in the analysis How many words are in the sentence Wait the interview analysis is supposed to follow a format I would like you to get into the habit of applying basic format and organization to every document you produce Unfortunately walls of text will result in points deducted What could the organization look like 1 2 3 Who did you interview What is your relationship to the interviewee What were your expectations prior to the interview What is the interviewee s background What kind of writing do they do How much is writing a part of the job Where did they learn to write What is the most stressful document they have had to write Tell the story Etc etc Last minute tips and suggestions In both your analysis and your resume cover letter be careful with focusing solely on hard skillsets Real position found on Linkedin Qualifications for a database developer SQL Three 3 or more years of TSQL Development Stored Procedures ETL Azure Cloud Synapse and Hadoop are preferred but not required skills Design and optimize database schema architecture queries and complex stored procedures for OLTP OLAP and unstructured data services Experience with Elastic Search Additional details regarding the same position database developer SQL Reporting to the Director of Engineering This person thrives in a fast paced environment and has a track record of creating alignment and inspiring trust with their peers and with the business stakeholders This role will be responsible for working closely with product owners and stakeholders to define scope requirements and implement new software solutions and product features We value learning risk taking If you are ready to work in a fun fast paced start up like environment let s chat It s blurry on purpose 100 hard skills Three 3 or more years of TSQL Development Stored Procedures ETL Azure Cloud Synapse and Hadoop are preferred but not required skills Design and optimize database schema architecture queries and complex stored procedures for OLTP OLAP and unstructured data services Experience with Elastic Search 90 hard skills 10 soft skills Three 3 or more years of TSQL Development Stored Procedures ETL Azure Cloud Synapse and Hadoop are preferred but not required skills Design and optimize database schema architecture queries and complex stored procedures for OLTP OLAP and unstructured data services Experience with Elastic Search Works well with others complex stored procedures for OLTP OLAP I have no idea what this means But I trust you do and I trust you know the hiring manager does as well This would be an opportunity to