WILLIAM J. JARVELA

** ******* **. *** ****, NC **562 678-***-**** (M) ac7zfb@r.postjobfree.com

Summary: IT Professional with 18 years of practical experience. Worked with, and mastered a wide variety of platforms, hardware, and software. Worked in a wide variety of roles including Management, Development, Support, Network/Systems Administration, and Technical Training. Hard working and career learner seeking a challenging IT position that will allow for professional growth. Hardware:PC (x386-present), Servers (Compaq/IBM/HP), Hubs, Routers, Switches, Peripherals OS/Software:Windows 95-Win 10/Server2000 - 2016, UNIX, Linux, DOS, Mac OS (7.5 – OS X), Active Directory, Azure, Administration, Meraki firewall, Microsoft Visual Studio (.net 2002 - 2018), VS Code, SQL Server 6.5 - 2016, SSIS, SSRS, Microsoft Dynamics GP (8.0 – 2015), Visio, Project, Office, Office365, Exchange, ISA Server, IIS, Microsoft MQ, Windows Workflow Foundation (WWF), Web API, Crystal Reports, mySQL, Oracle 9i/8i/7.x, ErWin, SQL Lab, SQL Navigator, Apache, CA Visual Express, Dreamweaver, Fireworks, Flash, Photoshop, Illustrator, Blend

Languages:ASP, ASP.Net (1.0, 1.1, 2.0, 3.5, 4.0, 4.5, 4.6, 4.7), C#, VB.Net, VB, Javascript, Jquery, VBscript, HTML5, CSS, Bootstrap (3,4), Angular, React, XML, XAML, Perl, Python, SQL, SQL+, PL/SQL IT Highlights:Worked hands-on with various platforms including IBM Mainframes (OS/390, zSeries), Microsoft Servers, Citrix Metaframe, UNIX, and Linux. Performed and coordinated Web Application Development (Highly Available -24/7- Enterprise Intranet, Business, e-commerce). Involved in Design, layout, graphics creation, and maintenance. Performed and coordinated Windows Application Development (in-house solutions to complex company/client specific needs). Worked with third party vendors and Retailers to satisfy complex EDI requirements. Created, maintained, and supported RDBMS (SQL Server 6.5-2016, Oracle, mySQL). Installed, configured, and maintained client/server workstations and networks including Hubs, Routers, and Switches. Provided Support and Training (desktop, Education, Technical) for both employees and clients. Also created and presented requirements/use case scenarios/updates for senior management/decision makers and end users to make sure requirements were being met.

Professional Experience

GSCCCA (Atlanta, GA) - .Net Developer August 2018 - November 2018 Update/Maintenance on some older applications. Design and create an ASP MVC using C#, JavaScript, CSS and Bootstrap application for their QA department. Transfer MVC knowledge to existing developers as they had never created an MVC application before. Take and translate user requirements converting them into usable code. Write all supporting stored procedure to integrate with the database (SQL Server). Created 30-40 SSRS reports to display data using the stored procedures written and then display within the MVC framework. Connected Analytics (Cumming, GA) - .Net Developer April 2018 - July 2018 Converting MongoDb data to SQL Server (Azure) designing database structure and writing stored procedures to support certain jobs and integrate with entity framework. CosmosDB in Azure, complete Azure shop. Design and develop application functionality written in ASP MVC using C#, JavaScript, Bootstrap, ChartJS, flexbox, as well as some smaller libraries, Entity Framework.

Regal Lager, Inc. (Kennesaw, GA) Senior .Net Developer/IT Manager August 2007 – March 2018 Responsible for all IT related functions within the company. Desktop support, Web site development and maintenance (ASP.Net/SQL Server/ C#, Telerik), EDI communications using TrueCommerce, Intranet application development (Sharepoint), Microsoft Dynamics Great Plains customization, Telco/Network implementation and support, Purchasing/Installation/Maintenance of all Hardware/Software, Microsoft Online Services Administration. Built several applications to assist staff in entering orders (ASP.Net/SQL Server/C#), reporting off sales/inventory data (Crystal reports/SQL Server Views/Stored Procedures), including order integration using GP Web services

(C#). Created externally facing web application (ASP.Net/SQL Server/ C#, Telerik) for Sales Reps and retailers to directly enter orders into our ERP system, implemented a drop ship program that would get shipping rates from UPS/FedEx via web service calls (C#). Built a store locator where we I would calculate the distance from an address or zip and then give back driving directions to a series of store we had in a database using GIS technology. Created Inventory Management and Planning application (ASP.Net MVC/SQL Server/C#) used to plan inventory purchases by looking at sales forecasts, current inventory levels, open orders, etc. Due to large lead-time for products arriving from overseas managing inventory levels was critical. Implemented incident reporting application (ASP.Net/SQL Server/ C#, Telerik) to gather customer complaints, product concerns, etc. This was required for generating quarterly reports for NHTSA (National Highway Traffic Safety Administration) as we began to sell car seats. Maintained inventory levels for online stores, updated customer address for store searches, database maintenance all using SSIS packages. Member of the management team that charted the direction of the company, brand selection, marketing strategy, trade show build/presentation, budgeting, and re-organization. Hired and directed interns to work on select projects, one for trade show order taking built on windows mobile platform (6.5), and a web application for retailer by brand comparison for various product sets that we sold. Wrote departmental procedure documents for handling day to day activities. Moved all on premise server technology to azure from exchange to office 365. Cobb County School District (Kennesaw, GA) Software Engineer Contractor May 2014 - Dec 2015 Worked within their Technical Services division developing a Curriculum Management application. The idea was that the state guidelines would be clearly displayed, and teachers could add content and/or lesson plans that met those requirements and were available for all teachers in that subject area to use, or get ideas from. The intent was to make sure that all state guidelines were being met, and students would be prepared for state exams. The application was created using ASP.net MVC using vb.net, HTML5, CSS, Bootstrap framework, and SQL server on the backend. I was also was responsible to run reports for the Assistant Superintendent in a number of areas from attendance, grades, and ethnicity which were to be used when reporting the school council and the Superintendent. All data was created by mining through SQL Server data running custom queries and then translated into material that could be easily be consumed by non-technical analysts. All projects were created, executed, and reviewed in collaboration with SME’s (subject matter experts), curriculum specialists, project managers and directors. Automatic Data Processing, Inc. (Atlanta, GA) Sr. Programmer Analyst Feb 2002 – July 2007 Led, designed and developed new components and upgrades to a suite of Workflow management intranet applications (ASP, ASP.NET, C#, VB.NET, JavaScript, SQL Server 2000 and Crystal Reports), which supported over $2 billion dollars of revenue for the company. This included interpreting various business unit requirements into analysis and design documents for developer use. Team consisted of four developers and contractors. Designed infrastructure, installed and configured servers, software installs, and supported the load balanced web farm that served this application. Was paramount in a nation-wide rollout of this application from two regions initially to 22 regions in less than two years (includes all of the US and Puerto Rico). This involved me creating and scripting new databases as well coding for individual regional requirements. Assisted in the design and development of a Vendor Integration solution using FedEx and UPS API products within an existing delivery management system. Designed, supported, installed, and configured the 24x7 highly available centralized hosting of several critical applications. Led migration of the Southeast Region intranet site from ASP to ASP.NET. Coded and provided analysis to a team merging two applications (ASP/ASP.Net 1.1 and Lotus Notes to ASP.NET 2.0 over Windows Workflow Foundation

(WWF) with SQL Server 2005 as the back-end). Designed and coded several web services to interact with mainframe data and coded WWF activities for drag and drop into newly created workflows. Coded and maintained much of the ingestion of client data from IBM zSeries mainframes, AS 400 and flat files for back-end application data, making use of Microsoft Replication Services and SSIS packages to transform and normalize data.. Designed and developed a customized change management system for code upgrades to meet the current needs of the application suite. Collaborated with other development groups within the company IT community to expose client delivery information via a secure client site. This included writing code to extract and expose the delivery data we collected. Provided analysis and coding to support SOX requirements for all applications within scope. Assisted and scripted the creation of a Hosted Training environment using Windows Terminal Services and Thin Clients. Assisted in configuring/testing of Citrix Metaframe thin client project. Factory Automation Systems (Atlanta, GA) Hardware/Software Manager May 2001 - Oct 2001 Evaluated and recommended internal Web/Email/FTP migration to Linux platform. Performed Hardware/Software installs. Assisted engineers in installing them in factories checking them for Viability/Metrics for PLCs interface with HP and Toshiba laptops using Rockwell Automation controls and PLC software, played with some Siemens as well. Assisted in the installation and migration to Sales Logix, SQL Server 7.0, and client workstations. Performed software customization of Estimating Software (ICE 2000). Davis Publication, Inc. (Worcester, MA) IT Manager May 2000 – May 2001 Administered, maintained, and backed up a hybrid Mac/NT network of 105 workstations and 5 servers. Created and maintained Customer Service, Marketing, and Inventory Databases (Solomon/Access). Developed, updated, and administered company e-commerce site (www.davis-art.com). Administered and configured Microsoft Exchange, Proxy Server/IIS for 100+ users. Recommended and implemented internet access upgrade from ISDN to 1.1 MB SDSL. Coordinated and performed purchasing, installation, and upgrades of all hardware and software. Developed company-wide training on Microsoft Office and how to work more efficiently using technology. Athol High School (Athol, MA) Technology Team Leader/Science Teacher July 1998 - May 2000 Technology Team leader for Athol-Royalston Regional School District. Assisted in installation and testing of network hardware and computers, including setup of UNIX-server at Athol High School which served as the district internet hub. Trained High School staff on basic computer use (Windows, internet, technology classroom integration). Developed, coordinated, and delivered district wide Professional Development on Technology based instruction.

Web/Application Developer (Part-time), 1995 – Present Have worked on a contract basis for Davis Publications, and several local businesses in both Massachusetts and Georgia to establish a web presence, online marketing, custom application development, and desktop/server/network support.

Education Clark University, Computer Career Institute (6/2000 – 2/2001) (Framingham, MA) Oracle Database Administration (320 Hours) Coursework included: Network Administration, Languages (SQL, SQL+, PL/SQL), Database Administration, Backup and Recovery, and Performance tuning State University of New York at Albany (Albany, NY) B.S. in Biology ’96 Cum Laude (GPA – 3.35) M.S. in Teaching of Biology ’97 (GPA – 3.5)