DEREK J. LORBER

Macomb, MO • 316-***-**** • ad16gn@r.postjobfree.com

RESOURCEFUL DATABASE ADMINISTRATOR

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

WORK EXPERIENCE

Freelance Consulting; Macomb, MO Jan 2020 - present

Computing Programming, System Setup, SQL Data Reports, Tableau Reports

●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.

Nelnet; Lincoln, NE March 2017 - Feb 2019

System Analyst

●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.

The Toro Company; Beatrice, NE Nov 2013 - March 2017

Senior Engineering IT Specialist

●Saved over $15,000 in labor costs by instituting procedural guides and comprehensive documentation on all supported applications.

●Supported over 70 Engineering and Lab staff through requirements collection, website maintenance, database management, and application support.

●Administered 4 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.

Spirit AeroSystems (aka Boeing Company); Wichita, KS 2006 - 2013

Design Engineer March 2010 - June 2013

●Bypassed a 32,000-object limit by structuring an Access standards database with multiple queries and pivot tables, saving over $200,000.

●Mastered SAP and ABAP as a 3-year member of the SAP Implementation team.

●Created detailed assembly drawings for Boeing 787 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 Feb 2008 - April 2010

●Created TC codes for seamless engineering data conversions, eliminating the need for external resources, in collaboration with an onsite SAP Consultant.

●Maintained a cenitCONNECT 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 Oct 2006 - Feb 2008

●Resolved a significant wireless device latency issue where 13% 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 for 767 Tanker Program, IT Account Administrator, Design Engineer 747

EDUCATION

Friends University, Wichita, KS

Bachelor of Science, Computer Science & Information Systems

National Institute of Aerospace Research, Wichita, KS

Associate of Science, Aerospace Engineering

TECHNOLOGIES & PROFESSIONAL DEVELOPMENT

Technologies: C#, C++, Salesforce, SAS, Amazon Web Services (AWS), VMware, Oracle Database, Adobe Acrobat, Citrix, Microsoft Dynamics CRM, Windows, Linux, Unix, HTML5, SQL, VBA, .NET, SAP, SQL Server, Access, Power BI, Tableau, AutoCAD, CATIA, Creo 4, Solid Works,

MS Office, Adobe Creative Suite, Maximo, CMPRO, Remedy, Smartsheet, Jira, SpiraTest, TCP/IP, PPTP, VPN, IPSec

Professional Development: Computer-Aided Design, Architectural & Mechanical - Western Dakota Technical Institute

Contact this candidate