Joshua Mcgee Email & Phone Number

Carlsbad, California, Us

• Created and maintained SQL databases: performing backups and restores, updating data, and data-mining information using T-SQL commands• Managed Microsoft Dynamic Nav, online ordering, APIs, and Jet Reports servers for maximum ERP and web performance• Developed reports using PowerBI, Jet Reports, ODBC, Excel, or SQL to analyze and assist executives with business requirements, including sales prices, margin, inventory, customer information, etc• Maintained data in the ERP database by updating item prices, customer information, and inventory details• Researched and implemented planning worksheets that incorporated sales and production forecasts to assist the purchasing department in the material requisition plan• Developed new tables for user management, accounting information, and new categories required for online ordering• Developed a program to sync files on the server with files on the website using a combination of SQL triggers to maintain the database, a text file that automatically syncs the files using WinSCP, and task scheduler to run the files• Assisted users with hardware, software, printer/scanner, phone, network, installation, maintenance, and troubleshooting to ensure that all areas had minimal downtime• Implemented computer infrastructure during a move to a new facility, including transferring servers, connecting the internet, running new network cables, changing IP addresses on printers, and reconnecting employees’ computers• Facilitated the IT infrastructure and processes to open a second facility• Ensured work stations operated smoothly, troubleshooting any computer or system problems for about 200 employees.• Implemented a paperless inventory control system and inventory dispatch program for handheld devices• Wrote Powershell scripts to sync orders and sales data with the corporate’s PowerBI system• Oversaw and implemented the upgrade from Microsoft Dynamics Navision 2013 to Business Central

• Oversaw marketing department and agencies to ensure web and print productions obtained company objectives• Managed and maintained company websites by creating and editing new content using tools such as Joomla, WordPress, Sitecore, Azure, HTML, CSS, PHP, ASP.Net, Javascript, SQL• Troubleshoot any website issues• Facilitated the company’s social media campaigns• Maintained SQL database and created reports to analyze website usage and online ordering data.• Wrote and published quarterly email newsletters and other marketing emails and announcements, online articles, and company profiles• Reviewed and edited company press releases• Managed online advertisements• Created and edited videos, slide shows, and interactive demonstrations• Coordinated with dealers to design and develop websites and consultation regarding their marketing objectives• Tracked and optimized search engine results using Google Analytics and webmaster tools.• Implemented new technology (forms, websites, user interfaces, etc.) to assist the company’s overall objectives• Researched digital marketing trends and competitive digital strategies• Collaborated with the sales department to achieve corporate objectives• Developed and maintained online ordering forms through E-con, Navision, Visual Studios, and SQL database. • Facilitated the timely testing of Projects-in-Process to minimize any negative consequences from modifications or upgrades• Managed IT tracking schedule for online ordering projects• Responded to quality issues that arise as a result of online ordering• Created and implemented plans to address manufacturing quality issues or online-ordering user errors• Managed the design and implementation of all marketing materials, including brochures, sales sheets, power points, banners, vehicle wraps, mailers• Facilitated yearly and as-needed training webinars and consulting sessions• Presented yearly marketing plans to the top 50 customers and executives

• Maintained Cover-Pools Websites built in CakePHP, Joomla, WordPress• Troubleshot website issues in HTML, CSS, PHP, and Javascript• Monitored and analyzed Google Analytics• Produced quarterly newsletters, online profiles, and other online marketing pieces• Managed social networking sites, including Facebook, Twitter, Youtube, Pinterest, and Houzz• Worked with developers to create web apps, mobile apps, and update website, including Cover-Pools app, filterable gallery, savings calculators, and online ordering system• Collaborated with marketing agencies to create and implement videos, online marketing campaigns, and search engine optimization• Created HTML5 animations using Adobe Edge• Wrote, filmed, and edited video tutorials• Edited videos using Adobe Premiere and After Effects• Created mobile web app using Dreamweaver with jQuery• Assisted dealers with website implementation by gathering assets and incorporating them into the web template• Used basic knowledge of HTML, CSS, Javascript, jQuery, PHP, SQL, MySQL, and ASP.Net to troubleshoot and add features to the website, email campaigns, and online ordering webpage• Designed and created websites using PHP for distributors• Programmed online ordering program using Asp.net, SQL, Nav, and E-con Solutions• Oversaw the audio and video equipment in the building and during conventions• Presented yearly marketing plans to the top 50 customers and executives• Created PowerPoints for sales presentations, training, and webinars

• Coordinate development and distribution of all installation instructions for new product development and modifications.• Create and maintain owner’s manuals, warranties, wiring diagrams, labels, instructions, price lists, and similar documentation.• Created 3D assemblies, parts, and e-drawings in SolidWorks.• Produced manufacturing instructions and engineering drawings to enhance accuracy in the manufacturing process.• Collaborated with engineers, document support, manufacturing managers, sales department, and marketing department to ensure standards of accuracy and usability.• Redesigned the instructions to improve readability and usability.• Established style guide criteria to maintain consistency between documents.• Created patent drawings, wiring diagrams, and illustrations used in marketing and technical documentation.

• Collaborated with two other product specialists to manage the Caretaker product line. • Worked with a committee of three other product specialists to manage the marketing and product development for Caretaker In-floor systems and water features.• Met with the sales team and dealers to discuss improvements.• Developed 5-year road maps and project scopes.• Wrote manufacturing instructions for the Caretaker product line.• Instrumental in moving manufacturing and engineering from Vista to Salt Lake, significantly improving quality control and reducing engineering lead times.• Revised product catalog for in-floor systems and water features.• Enhanced the Caretaker's section of the website by adding more details, images, and videos.• Attended trade shows as a Zodiac Caretaker and water feature products representative.• Developed various sales literature and PowerPoints.• Worked with a marketing agency to develop videos, brochures, and advertisements.

Us

• Wrote tutorials, fact sheets, and articles for ehow.com and other websites.• Wrote and edited web page copy.• Audited and redesigned web pages to improve usability.

• Designed, wrote and illustrated instruction manuals using Quark, Freehand, Photoshop, and SolidWorks.• Designed and conducted eight usability tests that resulted in improvements to the product and instruction manuals.• Wrote copy for a marketing sales guide.• Edited colleagues' work to ensure accuracy.

• Redesigned websites using photoshop, • Wrote and edited copy• Researched web design functions.

Chicago, Illinois, Us

• Managed up to 20 employees and managers per shift and 150 employees in total. • Created daily schedules, counted inventory, and projected and tracked the profit and loss.• Developed and supervised a training program for four stores.• Created an automatic scheduling program in Excel.

Master Of Science - Ms, Information Technology Management

Bs, English, Professional And Technical Communications, Marketing