Dennis Nerada

**** ********* *****

Woodridge, IL 60517

630-***-****

adzmoo@r.postjobfree.com

Highly accomplished Information Technology Professional with a verifiable track record of managing complex IT projects and exceeding expectations. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reduce costs. Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders. Recognized project management skills, consistently deliver complex projects on time and within budget. TECHNICAL SKILLS

Operating Systems: Workstations (Windows XP, 7, 8, 10,11), Windows Server (2019/2016/2010/2008/2007/2003) Development Tools: Visual Studio 2012, 2010, 2008; VB.NET / Visual Basic 6.0 / 5.0; Microsoft Access (365, 2013 2010, 2007); Microsoft Office (365, 2016, 2013, 2010, 2007), Microsoft SharePoint, PowerApps, Power Automate and Power BI.

Databases: SQL Server (2019, 2017, 2016, 2014 2012, 2010, 2008); Access (365,2016, 2013, 2010, 2007, 2003), MySQL Other Packages: Microsoft Exchange (2007, 2003), Microsoft Excel (2007, 2010, 2016), IIS (7.0, 6.0, 5.0), SCCM (2007), SSRS, SSIS, Microsoft Office 365 including Microsoft Teams, Microsoft Viso, Microsoft PowerPoint, SharePoint, Jira, Issue Trak and the most recent version of the document management software DASH

(www.dashdev.com).

PROFESSIONAL EXPERIENCE

Screws Industries – Glendale Heights, IL. August 2022 – July 2023 Project Manager/Data Analyst/MS Access developer

• Managed the following projects.

o Assisted in converting Microsoft Access adp files to 365 Microsoft Access accdb files. o Sponsored the existing .NET applications and the 365 MS Access files to utilize the Microsoft Azure SQL server. o Vetted SAGE consultants to upgrade the SAGE accounting software to the latest version. o Evaluated over a dozen website development vendors to choose the best vendor for the Screws Industries website. Also, developed a website requirements document which also included SEO and keywords to be placed on the website for better visibility.

o Automated the EDI invoicing process with customers that required that invoices be sent via EDI. Worked directly with SPS Commerce to automate this process.

• Created an IT support workflow that aided end-users in receiving the correct support from the IT department.

• Conducted weekly meetings to inform management of IT project status updates.

• Assisted the IT team to convert existing charts into interactive PowerBI reports.

• Managed the implementation of Microsoft SharePoint across the enterprise.

• Monitor historical and real-time performances of key metrics to detect and report anomalies.

• Recommend solutions by applying business analysis skills to complex business wants/needs, with consideration of associated business benefits, risks, cost and timescales.

• Build and execute data queries and views using tools such as SQL and Microsoft Access. Rose International/ ComEd – Oakbrook Terrace, IL. May 2019 – July 2022 Distribution Engineering Standards Database Administrator

• Development and administration of departmental SharePoint sites utilizing new emerging Microsoft-related technologies like PowerApps, Microsoft Automate, and Power BI.

• Design and implement a Microsoft Access database which tracks in-house failure analysis for faulty equipment found in the field. The database integrates with several other data sources like SharePoint lists, CAFTA statistical software databases and MS Outlook.

• Processed ad hoc requests, interpreted data, and prepared reports regarding various MS Access databases.

• Administer the departmental SQL Server. Install updates, create tables and views as required by existing and new database applications (MS Access, Oracle – Oracle in OraClient 12home1)

• Modify Microsoft Access 365 databases per departmental user’s requirements.

• Upgrade AutoCAD 2014 to AutoCAD 2018 along with all the customized third-party VBA software associated with AutoCAD.

• Provided support for 12-15 end users within the Distribution Engineering Standards department with software installations and configurations.

NeraData, Inc. – Streamwood, IL. May 2010 – Present Owner (Microsoft Access & VB6 Developer)

• Integrated an MS Access database to a payroll processing application to automate the entering of hours for all the employees. (Sandra Holdings- Pandora)

• Followed complete systems development life cycle process by writing requirements, creating a database schema, creating a prototype, performing both QA and UAT testing and installation.

• Prepared project costs and work-effort estimates for each project

• Automated the process of formatting Excel spreadsheets so that they can successfully be imported into both MS Access and SQL Server database tables.

• Design and published a Microsoft Access web database by using Microsoft Access 2010 and Access Services publishing to a SharePoint 2010 server so the client can access the database using a web browser instead of Microsoft Access.

• Created a Microsoft Access database interface to a SharePoint 2010 list so the client can update the SharePoint list via Microsoft Access

• Created a module for two separate customers which exports the required data to a flat file for both SAGE and QuickBooks accounting software.

• Created necessary import templates in SAGE to accept the exported flat file.

• Developed a customized quoting application for a trucking company that utilizes the Google maps API to calculate the distance between two zip codes.

• Created project budgets, work breakdown structures, key milestones, and detailed schedules.

• Developed final deliverables consisting of Microsoft Access or Visual Basic application(s) which met all user requirements on schedule and under budget.

• Utilized latest Microsoft technologies (Microsoft Access 2007 and 2010, SQL Server 2008, and Microsoft Windows Azure Platform) to deliver customized applications to the end users.

• Performed on-site and remote training sessions to train end users on the new and/or revised application(s)

• Made full use of a third-party data-binding ActiveX image control for Microsoft Access (Ammara Digital Image Solutions DBPix) allowing users to store images in the local access tables effectively and efficiently.

• Developed using Visual Basic (using ADO, DAO, and ODBC to connect to several SQL Server databases), Excel VBA, Word VBA and Office 2003, 2007 and 2010, 2013 and 2016 running under Windows XP, 7 and 10

• Wrote and documented a database conversion program as part of a spreadsheet to database migration project from Microsoft Excel 2007 to Microsoft Access 2007

• Created generalized model conversion tool to automate modification of Excel spreadsheets in analysts' company models.

• Coordinated user acceptance testing of various custom applications.

• Developed various front office applications using the latest Microsoft technologies such as Microsoft SQL Server 2008, Microsoft Access 2010, and Microsoft Visual Studio 2010 Bourntec / Xylem Inc. – Morton Grove, IL. May 2018 – April 2019 Sr. Software Developer II (MS Access and VB6)

• Code, test, debug, document, implement and maintain software applications.

• Developed a content posting ASP.Net page which included the following: o Storing data with SQL Server

o Using the Grid View control to present and edit dynamic data. o Creating a data entry system

o Attaching external CSS files

o Creating pages to log in and authenticate visitors. o Installing Internet Information Services (IIS) on Windows 10 and Windows 2003 and Windows 2010 servers. o Deploying an ASP.NET website on all IIS instances located on Windows 10, Windows 2003 and Windows 10 servers.

• Provide production system support for front end sales to order systems.

• Conduct analysis and engage in gathering and designing business requirements documentation.

• Develop new and existing applications and architecture.

• Develop and maintain custom applications and extension to existing systems.

• Manage customer requests and functional specifications per project. MacLean-Fogg – Mundelein, IL. October 2013 – September 2017 Business System Engineer

• Processed ad hoc requests, interpreted data, and prepared reports regarding various MS Access databases and Visual Basic 6 applications within the organization.

• Supported a third-party document management software application named DASH (www.dashdev.com) at multiple locations throughout the US.

• Worked closely with DASH support to integrate the software with the existing ERP software by creating new document types, configuring new user and self-running processes. Also generated ad-hoc reports on the data stored in the DASH SQL Server

• Worked closely with Terillium consultants to assist in the conversion process from MS Access to JD Edwards.

• Created an extraordinarily complex multi-functional costing application using MS Access to support various sales teams throughout the enterprise.

• Supported Microsoft Access 2010, 2013 and 2016 databases in numerous departments.

• Data analysis and data migration by transferring them using SSIS packages.

• Supported multiple customized ASP.NET applications which mostly interfaced with SQL Server 2008 R2 by making necessary additions or modifications to the application.

• Utilized the Bartender label generating software API to automate shop floor processes via the VB6 application. Associated Insurance Plans – Libertyville, IL. August 2012 – June 2013 Microsoft Access Developer / Systems Analyst

• Built and configured an offsite Windows Window 2007 Server and configured the IIS server accordingly.

• Developed a fully functional ASP.NET / JAVA solution for Associated Insurance plans; the application uses student’s demographic and insurance waiver data to help streamline the student onboarding and online wavering process

(http://www.aipstudentinsurance.com)

• Created VBScripts and configured the Windows Server Task Scheduler to Send Email Using CDO automatically

(Collaboration Data Objects)

• Redeveloped VB 6.0/Microsoft Access 97 database application to Access 2010/SQL Server 2008 ADP solution.

• Redeveloped an existing Perl, MySQL, Apache Server, and Progress database application to Microsoft IIS, .NET, and SQL Server 2008 solution.

• Migrated data from the existing MySQL database to the SQL Server 2008 database utilizing the MySQL ODBC driver and SQL Server Integration Services; administered and supported both current fully customized client and web applications.

• Maintained and customized vendor software, as well as designed and developed proprietary software required to maintain the continuous flow of technology at the firm.

• Ensured quality and integrity of technology infrastructure, monitored processes and procedures, and implemented additional automation as needed under the guidance of the development team lead. OTTO Engineering, Inc. – Carpentersville, IL. January 2011 – May 2012 Microsoft Access Developer / Systems Analyst

• Documented current Microsoft Access 2003 applications used (data definitions, report usage)

• Developed process flows and swim lane charts using Visio 2010

• Documented all areas of the organization where existing Microsoft Access databases were being utilized.

• Modified current Microsoft Access 2003 applications (Normalizing data, simplifying report generation, simplifying user interfaces, supplying each database with additional error trapping)

• Developed interfaces with existing Microsoft Access database to the current ERP system (EPICOR IBM Manufacturing Business System)

• Upgraded existing Microsoft Access 2003 databases to Access 2007

• Developed new applications using Microsoft Access 2007

• Migrated Access tables to SQL Server 2005 back-end and utilized Microsoft Access 2007 as the front-end of the application.

• Designed and created Microsoft Excel spreadsheets to implement mathematical data analysis models and to provide an attractive and functional user interface for the Quality Control department; the spreadsheets included the ability to retrieve data from an outside source and dynamically chart the data points captured from the Business system.

• Conducted Microsoft Access development classes for existing Microsoft Access developers to better understand relational databases and to develop applications which are more scalable and easier to manage from both a developer’s and an end user’s perspective.

• Created department wide Microsoft Access development standards for all developers to adhere to create and maintain new and existing production databases more efficiently. Durham School Services, Inc., Warrenville, IL. August 2010 – December 2010 VB6/.NET/Microsoft Access Developer/Analyst

• Continuous VB6/Microsoft Access 2003 development on existing application used in 120 different locations throughout the United States and Canada; mission critical application provided end users with a scheduling, invoicing, and payroll capability in each location.

• Utilized third party tools like Component One VSFlexGrid Pro ActiveX OCX and Component One True DBGrid Pro ActiveX OCX / ActiveX DLL in VB6 application to customize the display and presentation of dynamic data.

• Integrated Microsoft Access 2003 application to SQL Server Express 2005 database to provide users with updated tracking data captured in a school bus routing software including GPS fleet tracking, GPS fleet management, real-time GPS management and maintenance software systems.

• Provided management with necessary documentation consisting of process flow diagrams, use Cases, etc. of all integrated current mission critical applications using Visio 2008 to be used in high level decision making of the replacement of the current VB6 legacy system.

• Provided the IT infrastructure team with recommendations on centralizing the VB6/Microsoft Access 2003 application using the latest Microsoft technologies (Microsoft Virtual Server, VB.NET, SQL Server 2008) Geo. F. Brown & Sons, Inc. – Chicago, IL. August 2005 – May 2010 Microsoft Access/VB6 Programmer/Systems Analyst

• Managed and developed an on-line ASP.NET / SQL Server 2005 quoting/binding application for agents.

• Prepared and delivered a variety of reports using the SQL Server Reporting Services (SSRS)

• Developed a reporting tool using Crystal Reports 8.5 which would report on a purchased Agency Management System called AIM from Custom Insurance Services with a SQL Server 2005 back-end database.

• Developed in-house Microsoft Access 2003 Quoting and Policy Binding system which used a third-party tool Synectics PDF In-the-Box ActiveX to create PDF file programmatically.

• Administer existing VB 6.0 application used for Quoting, Binding, Issuing Real Estate E&O Insurance policies.

• Worked with senior management to determine and define problem issues and changes to customized apps.

• Support for user queries and reports, data transfers, imports, and exports as needed. Screws Industries – Glendale Heights, IL. May 1998 – August 2005 Microsoft Access Developer/Technical Support

• Database/application design, creation, and maintenance

• Development of an in-house, fully customized, and integrated MRP II system which included the following modules: Sales order entry, finished goods and WIP inventory, Purchasing, manufacturing (Shop Floor Control), Engineering (Part Master / Bill of Materials), and Scheduling and Forecasting

• Implemented company-wide migration from Lotus 1-2-3 spreadsheets into the newly developed customized MRP II system.

• Incorporated an AutoCAD file viewer module in the MRP system using a DWG Viewer ActiveX control for developers which allowed users to view the AutoCAD drawings in real-time.

• Installation and integration with bar code software (Seagull Scientific Bartender) and EDI software packages (Sterling Commerce GENTRAN)

EDUCATION

University of Wisconsin Parkside – Kenosha, WI. December 1992 Bachelor of Science in Management Information Systems Certificates/Training courses:

Advanced Programming Microsoft Access 2016, Programming Microsoft Access 2010, Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET, Database Programming with Visual Basic 6, Introduction to Microsoft SQL Server 2008 Administration, Crystal Reports 8.5, PowerBI (Guy in a Cube Course)

Contact this candidate