YONATAN ASSEFA

Client: U.S Department of Education/SUFS – Database Integration

• Collected database configuration details, DB warehouse architecture and DB security measures for our server migration to VPC
• Coordinated with the infrastructure team and assessed the dependencies for our datacenter for our VM server updates
• Developed comprehensive project budgets by estimating costs, defining financial constraints, and allocating resources efficiently
• Managed multiple projects within a portfolio, tracking financial performance across projects with proactive financial planning and budget adjustments using Clarity PPM
• Ensured project expenditures met budget and quality standards by aligning workforce planning with project needs and leveraging suitable tools and technologies while adhering to governmental regulation and internal policies
• Ensured data file requirements met DOE government standards and ensured data safety with server security patches
• Clarified the DOE and Legislative mandates for capturing the Enrollment and Students data and provided a report on the strategy, impact and approach being taken for each project
• Facilitated meetings to integrate our SAS and Cosmos DB Databases to streamline access to our internal SQL Data Warehouse
• Coordinated with Scrum Master on Azure DevOps User stories & Jira and Zendesk tickets to address all data inconsistencies & bugs
• Presented in Scrum Daily Stand-Up meetings to report on reports on SQL table updates as well as issues in our data schemas.

Client: Bayview Asset Management/Inspyr – Database Systems Migration

• Assisted in the migration from Access Database to Azure Cloud using Jira and Confluence project organization platforms
• Worked on multiple cloud projects on Azure platform and managed data throughout the DevOps pipeline
• Coordinated with the Scrum Master and BA on database technical requirements
• Presented in Scrum Daily Stand Up on our migration status along with issues with any User Stories, Features
• Assisted BA, and Scrum Master with Visio business process mapping for our current & future state business & technology initiatives

Client: Honda - Software Integration Project

• Provided recommendations based on quantitative data analysis regarding strategic direction.
• Analyzed key performance indicators to identify effective strategies.
• Assisted in Honda system update to incorporate test automation, intelligent integrated software application
• Assisted in the defining of architecture, components, interfaces, & other important characteristics the new Honda Enterprise Software
• Assessed transportation infrastructure needs for Honda USA to deliver integrated application requirements
• Communicated internal systems configuration details, and “mobility” technology requirements for the new optimized user interface
• Revised existing software architecture to adapt to new hardware and upgrade interfaces and improve connected performance
• Laid out retrofit telematics and connectivity solutions for process visualization.

Client: Airbus – Non-Conformity Systems Process Project

• Held Scrum Daily Stand-up meetings to identify and define Airbus’s Non-Conformity (NC) priority systems on the Final Assembly Line (FAL) using SAP database
• Enabled control measures and ramped up the NC enablement process reducing process from 1 week to 2 days through quality assurance
• Gave a 60% reduction in Aircraft NC’s through the final line assembly using MFT, ACM and back office streamlining
• Prioritized aircraft KPI’s following dashboarding to model, accelerate and optimize NC processing

• Submitted project deliverables to clients, consistently adhering to quality standards.
• Updated project plans based on changing objectives, specifications and staff availability.
• Managed risks throughout the duration of each project by identifying potential issues before they arose.
• Negotiated with project stakeholders or suppliers to obtain resources or materials.
• Collaborated with consultants, assisted with project reports, researched tools, PM methods for, meetings
• Communicated strategic objectives to internal team members to ensure projects are completed in alignment with strategy
• Analyzed results to determine project solutions and strategies to meet business functionality.
• Implemented strategies for improving quality control measures related to specific projects.

• Supported network department with TCP/IP routing connectivity and architecture transport analysis for a $13.5 million turnkey AVL county project
• Worked closely with stakeholders to define project scope and objectives.
• Updated project plans based on changing objectives, specifications and staff availability.
• Tracked costs and expenses and assessed closely against original project budget.
• Supported review of wireless access points, controllers and authentication mechanisms for infrastructure team
• Devolved code that identified CAD IP address for network infrastructure integration and support
• Reviewed SDN and NFV configuration management tools and network architecture models for packet analysis and security compliances (SSL/TLS)