John Edgar Email & Phone Number

United States

• Utilized Python to scrape data from Confluence and Google Sheets to develop a task management tool.• Filtered & stored data into a BigQuery database, and generated task reminders to managers, reducing task planning time by 40%.• Built an automated remediation dashboard using SQL and Python to pull and filter data from Jira to streamline communication and reduce reporting time by 10 hours per week and improve team efficiency by 15%.• Forecasted project health with a regression… Show more • Utilized Python to scrape data from Confluence and Google Sheets to develop a task management tool.• Filtered & stored data into a BigQuery database, and generated task reminders to managers, reducing task planning time by 40%.• Built an automated remediation dashboard using SQL and Python to pull and filter data from Jira to streamline communication and reduce reporting time by 10 hours per week and improve team efficiency by 15%.• Forecasted project health with a regression model using python to pull past project data and predict future workloads for managers.• Implemented retrieval-augmented generation (RAG) using Python on an AI security chatbot to provide accurate internal code for security engineers.• Conducted interviews with seven managers to document insights and identify user pain points, translating these findings into applicable deliveries such as a remediation dashboard and task management tool.• Designed, analyzed, and presented five dashboard UI concepts and gathered feedback to then refine the user experience. Show less

•Driving the release of a new data pipeline by applying it to hardware, software, and security products within Seagate.•Collaborating with Salesforce Engineers to help build a customer-focused management tool that will enable tracking, visualization, and analysis of customer sentiment towards technologies.

•Led a team of software engineers through Agile Methodologies, utilizing Jira, to implement S3 support, a file uploader, and GUI.•Organized and defined project plans and schedules to drive project execution, while also teaching developers’ agile management to individually implement daily stand ups, goal setting, sprint planning, and iteration review/retrospective meetings.•Presented bi-weekly project updates and progress to upper management and executives by using burndown charts and… Show more •Led a team of software engineers through Agile Methodologies, utilizing Jira, to implement S3 support, a file uploader, and GUI.•Organized and defined project plans and schedules to drive project execution, while also teaching developers’ agile management to individually implement daily stand ups, goal setting, sprint planning, and iteration review/retrospective meetings.•Presented bi-weekly project updates and progress to upper management and executives by using burndown charts and showcasing feature development. •Ensured tight team coordination and communicated technical issues with software engineers and other program managers.•Handled cross-functional projects involving product managers and software engineering teams to create automated project dashboards and increase project communication. •Created project documentation showcasing architecture and software/product development lifecycle. Show less

•Evaluated new product features and documented observations to be reported and reviewed by product managers.•Utilized complex SQL queries using the Select, From, Between, Join, Group By, Order By, Where, and more functions to extract, manipulate, and analyze data from the company's database. •Built and produced 7+ Excel reports to map relationships to identify patterns and trends in user behavior. Found patterns of users across regions in the USA, based on the total amount of revenue… Show more •Evaluated new product features and documented observations to be reported and reviewed by product managers.•Utilized complex SQL queries using the Select, From, Between, Join, Group By, Order By, Where, and more functions to extract, manipulate, and analyze data from the company's database. •Built and produced 7+ Excel reports to map relationships to identify patterns and trends in user behavior. Found patterns of users across regions in the USA, based on the total amount of revenue and redemptions generated at specific times of the day.­•Communicated with high-level executives and conducted Android mobile testing. Show less

•Manager GenCap's SharePoint site, ensuring all content is up-to-date and relevant, and implementing new features and functionalities as needed.•Wrote algorithms in Dynamo using Python scripts and visual programming to automate Revit drawings, saving significant time and effort for engineering teams.

•Collaborated and conducted meetings with technical stakeholders and executives to define expectations, document requirements, and create a project schedule to build a companywide SharePoint site.•Ensured project success by leading cross-functional engineer, management, and operation teams to meet requirements. •Designed a user-centered information architecture and user interface that simplified navigation and made it easy for employees to find the information they needed.•Designed… Show more •Collaborated and conducted meetings with technical stakeholders and executives to define expectations, document requirements, and create a project schedule to build a companywide SharePoint site.•Ensured project success by leading cross-functional engineer, management, and operation teams to meet requirements. •Designed a user-centered information architecture and user interface that simplified navigation and made it easy for employees to find the information they needed.•Designed and developed algorithms using Dynamo and Python scripts to automate repetitive tasks, saving significant time and effort for VDR managers.•Leveraged python to create efficient yet scalable solutions that simplified various processes, such as reading sheets and automating repetitive drawings and measurements. Show less

•Self-managed the entire lifecycle of two iOS mobile game applications from ideation to launch.•Identified and built all aspects of product development, system design, prototyping, user testing, and feature development.

Bachelor'S Degree, Computer Science

Activities and Societies: PM Association (Founder & President), Association for Computing Machinery (Member), Sigma Pi Fraternity.

Education record

Ranked #1 public high school in the state of Washington.