DEREK J LORBER
IT Analyst
Springfield,MO
Summary
- Senior IT Consultant
- Engineering Manager
- Manufacturing Design Engineer
- System Analyst SQL Queries
- Executive Communication
- Cross-Functional Communication
- Application Support Optimized Data Exchanges
- Supported Key Staff
- Tested Functionality
- Synthesized BI Reports Translated Technical Functions
- Structured Databases
- Authored Documentation
- Reduced Costs
Overview
18
18
years of professional experience
Work History
Computing Programming, System Setup, SQL Data Reports, Tableau Reports
Freelance Consulting
01.2020 - Current
- Advised professionals in multiple sectors to improve end-to-end business operations
- Enhanced customer satisfaction and engagement levels through SME assistance
- Customized Tableau reports for client meetings to streamline and enhance communication
- Designed SQL queries to efficiently parse data and normalize databases
System Analyst
Nelnet
03.2017 - 02.2019
- Defined, implemented, and maintained critical IT processes, including security standards training, intricate systems analysis, and procedural development for auditable IT deliveries
- Collaborated with cross-functional business units, including the NBS Cybersecurity and Infrastructure Teams, to establish and launch organizational security protocols
- Spearheaded IT risk management, consulting on internal audits, control documentation, risk assessments, control compliance, and remediations
- Coordinated audits, vulnerability tests, and compliance reviews to fulfill IT security needs
Senior Engineering IT Specialist
The Toro Company
11.2013 - 03.2017
- Saved over $15,000 in labor costs by instituting procedural guides and comprehensive documentation on all supported applications
- Supported over70 Engineering and Lab staff through requirements collection, website maintenance, database management, and application support
- Administered4 NIST-compliant Access databases with proprietary company information
- Conducted rigorous testing for new functionalities and processes
- Collaborated with Engineering, IT, and Procurement teams to gather hardware and software requirements, aligning with internal standards and leveraging pricing concessions
- Analyzed data and synthesized business intelligence reports by leveraging VBA, SQL, and Excel queries, reports, and pivot tables
- Improved WCAG compliance while executing stakeholder layout and content change requests
- Transmitted technical data into the SAP PLM system as the primary Technical Liaison
- Software maintenance and monitoring via NOC (Network Operations Center)
Design Engineer
Spirit AeroSystems (aka Boeing Company)
03.2010 - 06.2013
- Bypassed a32,000-object limit by structuring an Access standards database with multiple queries and pivot tables, saving over $200,000
- Mastered SAP and ABAP as a3-year member of the SAP Implementation team
- Created detailed assembly drawings for Boeing787 aircraft
- Aided Engineering staff in system designs and component development
- Collaborated with stakeholders, Fabrication Managers, and Advanced Manufacturing Engineers to resolve manufacturability and cost design issues
- Authored technical documentation for accepted designs and assemblies
IT Analyst Level III
Spirit AeroSystems (aka Boeing Company)
02.2008 - 04.2010
- Created TC codes for seamless engineering data conversions, eliminating the need for external resources, in collaboration with an onsite SAP Consultant
- Maintained a centiCONNECT Enterprise Connector for CATIA data integration and an Office Adapter for transferring non-CAD data into Microsoft Office applications
- Facilitated SAP installations during the company’s migration to Sprint by testing and validating multiple CATIA block points for full compatibility
- Supported the Senior Leadership team by recommending initiatives and improvements regarding business systems, data trends, and process initiatives
- Analyzed, designed, and implemented computing systems to optimize data exchange
Fuselage IT Relationship Management CRM
10.2006 - 02.2008
- Resolved a significant wireless device latency issue where13% dropped offline
- Coordinated regional IT requirements, installed new operating models, introduced IT solutions, conducted market research on emerging products, and evaluated operational readiness
- Navigated communication between IT and the Fuselage Business Unit's factory floor to streamline resolution and root cause analysis for significant escalations
- Translated client-specific business requirements into customized CRM solutions
- Aligned innovative technologies, data, and metrics with organizational visions and objectives
- Compiled cross-functional operational performance reports across all system lifecycle stages
- Automated essential business processes through CRM solutions to increase efficiency
- Prior Experience: The Boeing Company, Computing Network Operations, IT Lead for767 Tanker Program, IT Account Administrator, Design Engineer747
Education
Bachelor of Science - Computer Science & Information Systems
Friends University
Wichita, KSAssociate of Science - Aerospace Engineering
National Institute of Aerospace Research
Wichita, KSAssociate of Science - Computer-Aided Design, Architectural & Mechanical
Western Dakota Technical Institute
Rapid City, SDSkills
- Technologies: C#, C, Salesforce, Amazon Web Services (AWS), VMware, Oracle Database, Adobe Acrobat, Citrix, Microsoft Dynamics CRM, Windows, Unix, HTML5, SQL, VBA, NET, SAP, SQL Server, Access, Power BI, Tableau, AutoCAD, CATIA, Creo4, Solid Works, MS Office, Adobe Creative Suite, Maximo, CMPRO, Remedy, Smartsheet, Jira, SaaS, ITIL4, CMMI, Agile, ITSM, ServiceNow
Timeline
Computing Programming, System Setup, SQL Data Reports, Tableau Reports
Freelance Consulting
01.2020 - Current
System Analyst
Nelnet
03.2017 - 02.2019
Senior Engineering IT Specialist
The Toro Company
11.2013 - 03.2017
Design Engineer
Spirit AeroSystems (aka Boeing Company)
03.2010 - 06.2013
IT Analyst Level III
Spirit AeroSystems (aka Boeing Company)
02.2008 - 04.2010
Fuselage IT Relationship Management CRM
10.2006 - 02.2008
Bachelor of Science - Computer Science & Information Systems
Friends University
Associate of Science - Aerospace Engineering
National Institute of Aerospace Research
Associate of Science - Computer-Aided Design, Architectural & Mechanical
Western Dakota Technical Institute
Similar Profiles
SAIKRISHNA RATHANPALKESAIKRISHNA RATHANPALKE
Data Analyst - Supply Chain & Procurement Analytics at Freelance ConsultingData Analyst - Supply Chain & Procurement Analytics at Freelance Consulting
RAHUL MALIKRAHUL MALIK
Consultant at Freelance ConsultingConsultant at Freelance Consulting
Brodie MitchellBrodie Mitchell
Consultant at Freelance ConsultingConsultant at Freelance Consulting
Brad WarrenBrad Warren
Technical Specialist at Freelance ConsultingTechnical Specialist at Freelance Consulting
David HurfordDavid Hurford
Painter at G&G Painting LLCPainter at G&G Painting LLC