John Morga, PhD ad09e6@r.postjobfree.com

www.linkedin.com/in/jmorga/

Data Engineer Excel VBA Developer

Project Management ERP Systems Business Applications VBA Automation creative technologist offering an accomplished record of achievement leading and contributing in all phases of Data Management in IT, Finance, Supply Chain, Logistics, Inventory Mgt, Manufacturing, Industrial, and Applications Technology projects. A logical thinker, problem solver, and resolution specialist that designs, builds, and implements technologically efficient data systems that align goals with enterprise objectives. Attributes and Areas of Expertise

IT Management & Leadership System / Enterprise Architecture Data Scrubbing & Migration

Business Intelligence Data Analysis / Statistics / Trends Data Collection Projects

SC, Inventory, MFG, Fin Data Debug Audit Data Support Infor XA / SQL / BI

Excel / SQL ERP, Seamless DB integration, Apps & Utilities Design VBA / SQL / Data Forensics Business Strategist: Plans, manages, and contributes to all levels of technology projects with solutions to drive process improvements, competitive advantage, and bottom-line gains. Excellent Communicator: Leverages technical, business, and scholarly acumen to communicate effectively with client executives and their respective teams. University professor, instructor, and trainer. Exemplary presentation, documentation, and PhD-level writing skills.

Current Roles

IT Manager & Principal System Analyst ERP, Excel / SQL / Data Analytics, VBA Automation, and Forensics CPI Aerostructures, Jan 2018 – Present

Skills & roles:

IT business-to-technology liaison meeting functional challenges and evaluating products, procedures, and processes. Solution development and implementation.

Data Applications, Utilities, Analysis, BI: Dozens of end-user applications, data exporting utilities, reporting utilities, automated processing, and data troubleshooting for MRP processing, accounting closures, inventory reporting, procurement costing, vendor performance, FP&A analysis, sales opportunities, and other business needs.

SQL-Server and IBM DB2 Applications DBA. Data manager and architect responsibilities include the design and construction of database tables, views, and import/export processors. Custom reporting, data transition, data migration.

Very strong proficiency in Microsoft VBA (Excel macros), understanding the advantages and pitfalls of recording macros and editing the resulting code. Programmatically creating pivot tables, sorts, application objects (like ScreenUpdating, DisplayAlerts, DisplayStatusBar, etc.), row & column referencing versus

.Range(.Cell) referencing, .Find, .AdvancedFilter, dynamic assembly of VLOOKUP formulas, defining CommandButton or Shape object Click events and setting their properties for effective coding strategies and efficient runtimes.

Strong proficiency in SQL statements, left & right joins, outer joins, unions, cross joins, etc.

Strong proficiency in dissecting other system SQL statements to determine table usage, columns, case statements, manipulation of dates, filtering, grouping, ordering, etc. A

John Morga, PhD ad09e6@r.postjobfree.com

Knowledge of SQL development tools (ie: Toad, Flyspeed, SQuerriL,PopSQL, WinSQL, SSMS)

Strong strategic approach to application architecture & design in Excel, with an understanding of why we use these functions in a particular subroutine and how they contribute to an application being developed.

Knowledge of ODBC driver configuration setups for Microsoft Windows.

Basic experience with stored procedures.

Relevant Projects

SEC 8-K Financial Restatement Analysis & System Correction: For Units of Measure inventory faults, Average Costing calculation system faults, and Duplicate Labor collection system faults. Two-year effort involved massive data calculations for:

Mathematical analysis for cost correction, update of inventory UoM costing, part definitions, and re-training of Engineering, Procurement, and Production Control staff to design and buy materials correctly.

Bottom-up item costing analysis through BOM structures for average costing errors that was built up through the BOM levels, programming for calculating average cost corrective deltas in material costs, and upload/apply to finished goods in stock and WIP assemblies being fabricated in the shop.

Bottom-up item costing analysis through BOM structures for duplicate labor applied as a programmatic error in Job Costing, programming for calculating corrective labor and overhead rate deltas, and upload/apply to finished goods in stock and WIP assemblies being fabricated in the shop. Subsidiary ERP Data Migration: Full-scale enterprise data migration following acquisition of subsidiary company. Organized, aligned, and transferred entire data suite of database contents from Epicor to Infor ERP including GL, AP, AR, cash assets, CRM, open customer orders, engineering BOMs, PDM, on-hand inventory, WIP, floor stock, VMI, purchase order data, receipts, accept/reject QA, work cell definitions, facilities, routings, outside/secondary operations, vendors, open manufacturing orders, and rework. Previous Roles

NYC Head of Technical Operations

CIVIQ Smartscapes / LinkNYC, Feb 2016 – Jan 2018

Senior technology leader (IT, Engineering, Operations, Logistics) NYC with “last-mile” deployment responsibility for New York City's LinkNYC communications network of 7,500+ informational kiosk structures known as Links. Established entire NYC technical operations from startup phase incorporating electrical and application software testing and inspection standards, Linux and Android zero-touch software provisioning, daily network collaboration with Google engineers and Google Network Operation Centers. Links provide free high-speed Gigabit Wi-Fi, free voice calling, USB device charging, maps and directions, 911 Emergency Call services, and HD digital advertising that generates $300M revenue annually. http://www.Link.NYC

IT Project Manager Contractor

Time Inc, Oct 2015 –Mar 2016

IT Project Manager executing 3,500 employee restructure of World Financial Center Tower 2 (Brookfield Place) in Manhattan and Industry City in Brooklyn. Oversight of 25-technician team that conducted entire end-user infrastructure migration services for servers, engineering workstations, mobile device management, print/scan technology equipment, and thousands of iMacs, Mac Pros, Mac Mini's, Mac books, Windows desktops, and John Morga, PhD ad09e6@r.postjobfree.com

Lenovo laptops. Extensive mount conversion of thousands of Apple Cinema and Thunderbolt displays. Large-scale collaboration with Time Inc infrastructure management, facilities management, and more than 12 independent logistics services.

IT Project Manager Contractor

Cablevision (now Altice, Inc), Sep 2014 – Dec 2015 IT Project Manager for $12 million enterprise managed desktop upgrade of Windows desktops, laptops, virtual machines, Optimum Online network head-end hardware, and NEWS-12 On-The-Air studio editing and production equipment. 18,000 computers in 148 locations: Long Island (Nassau, Suffolk counties), Manhattan, Brooklyn, Bronx, Queens, Westchester, New Jersey, Connecticut, and Pennsylvania. Microsoft System Center Management suite (SCCM), Eracent ITMC asset management, HP Asset Center, over 1,100 applications packaged for virtual deployment, PXE-boot and flash-drive based OS imaging technology. Domain, OU, and Microsoft Office version choices built into the base image, lifecycle license management.

IT Senior Director of Applications & Software Engineer Telephonics Corporation, Mar 1987 – Aug 2014

Reported to VP of IT with full evaluative, investigative, operational, and technical responsibility in Engineering, Manufacturing, Warehousing, and Supply Chain. Integrated with staff of 30 to deliver complete, full-scope, regression- tested solutions that work. Served as management and technology lead for projects and other technical aspects within the organization.

Education

PhD, Information Technology, Capella University

Master of Business Administration, Management, Dowling College Bachelor of Science, Electrical Engineering, New York University

Contact this candidate