Mark Bernat's Email

Sr. Dynamics NAV Consultant @ Navision implementation, development, project management. Standards management, process definition From January 2013 to Present (3 years) NAV Developer @ Microsoft Dynamics NAV development. Lead developer for multi-national systems (multiple versions of NAV) including North American, Worldwide (with Polish customizations), using version 5.0, Nav 2009 and Nav 2009R2...consolidated companies for currency conversion. Support NAV installations in US/Poland/Sweden/China/Singapore/Malaysia SQL stored procedure development (pulling NAV data, converting/consolidating and pushing to data warehouse). Jet Reports, ShopVu, RF, Lanham From 2010 to 2013 (3 years) Navision Developer @ Microsoft Dynamics NAV / Navision. Develop, test and implement solutions and changes to NAV production environment. Dataport development to convert Dynamics GP systems to NAV. SQL Reporting Services report development and troubleshooting. From 2010 to 2010 (less than a year) Microsoft Dynamics NAV Applications Developer @ Lead Developer - Microsoft Dynamics NAV / Navision. Develop, test and implement solutions and changes to NAV production environment. Designed NAV module "Spare Parts". Two-way dataport development between Dynamics NAV and other SQL based applications, utilizing both Automation Objects and Stored Procedures. Project management including oversight of both internal and external resources. SQL Server 2000/2005 administration including backups, database design, stored procedures, triggers, reporting. Served as lead developer and project manager for public facing Environmental Compliance System, an ASP.NET 3.5/C# application. From 2008 to 2010 (2 years) Director of Internet Technologies @  Administration of collocated applications/database servers including MySQL 5, Apache, IIS, Microsoft Windows Advanced Server 2000, Linux.  Developed public facing internet portal www.wptapl.com. (PHP, MySQL, Javascript, Flash)  Developed private internet portal for access by corporate partners. (PHP, MySQL, Javascript)  Conceived marketing plan for customer loyalty program MyAPL Rewards (www.myaplrewards.com), delivering application development for public facing sites as well as back-office support applications for fulfillment, customer service and data mining: From 2006 to 2008 (2 years) Systems Manager @  Designed and implemented corporate IP network, utilizing WAN, VLAN, VPN, QoS and WLAN technologies to provide connectivity for data and VOIP network serving over 300 users at 15 sites in 3 states.  Designed and implemented $1.5M Citrix/Windows 2000 terminal services network, bringing project in on time and under budget.  Led 3 members of the IS team in the data conversion from proprietary legacy software running on Compaq Alpha hardware (VAX) and Open VMS operating system to Microsoft Advanced Server 2000 and Microsoft SQL, saving over $300K per year in support costs.  Led team including in-house and contract programmers in the development of the public facing portal for REIBANC, INC.  Managed IS team in support of all hardware and software issues in multi-platform, multi-network environment using Microsoft, Citrix, Digital OpenVMS, Linux, SCO Unix, Informix, Pervasive, MS-SQL, Veritas, Exchange From 2001 to 2006 (5 years) Vice President, Operations @ Managed all information technology and operations for FIMCO and subsidiary/sister companies. From 1997 to 2001 (4 years) Owner / Systems Design @  Provided consulting services on telephony issues/network integration, including voice, data and facsimile. Specialized in the design and implementation of Novell based network servers.  Applications development and consulting, specializing in database technologies: FoxPro, Clipper, Clarion/Btrieve  Developed “boilerplate” accounting software (AR, AP, GL, Payroll) modules to coordinate and work with various custom operation modules (work orders, scheduling, transportation, security, etc). From January 1989 to December 1996 (8 years)

Oral Roberts UniversityWichita State University Mark Bernat is skilled in: Navision, SQL Server, SQL, ERP, Microsoft Dynamics, Databases, Business Analysis, Business Intelligence, Software Development, T-SQL, Programming, Integration, Business Process, Requirements Analysis, Warehouse Management