We provide IT Staff Augmentation Services!

Business System Engineer Resume

Streamwood, IL

SUMMARY:

  • 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), Server (Windows Virtual Server 2003, Windows 2010/2008/2007/2003, Linux)

Development Tools: Visual Studio 2012, 2010, 2008; VB.NET / Visual Basic 6.0 / 5.0; Microsoft Access (2016, 2013 2010, 2007); Microsoft Office (2016, 2013, 2010, 2007)

Databases: SQL Server (2017, 2016, 2014 2012, 2010, 2008); Access (2016, 2013, 2010, 2007, 2003), MySQL

Other Packages: Microsoft Exchange (2007, 2003), Microsoft Excel (2007, 2010, 2016), IIS (7.0, 6.0, 5.0), Symantec Backup Exec, SCCM (2007), SSRS, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, IL

Business System Engineer

Responsibilities:

  • 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
  • Created a highly complex multi-functional costing application using MS Access to support various sales teams throughout the corporation
  • 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
  • Supported and developed departmental Microsoft Excel 2016 spreadsheets. The Microsoft Excel 2016 spreadsheets included formulas such as VLOOKUP, SUM, SUMIF and other basic formulas including Pivot tables and filtering.
  • Utilized the Bartender label generating software API to automate shop floor processes via the VB6 application

Confidential - Streamwood, IL

Owner (Microsoft Access & VB6 Developer)

Responsibilities:

  • 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 spreadsheet so that they can successfully be imported into both MS Access and SQL Server database tables.
  • 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 in order to accept the exported flat file
  • Developed a customized quoting application for a trucking company that utilizes the Google maps API in order 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 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

Confidential - Libertyville, IL

Microsoft Access Developer / Systems Analyst

Responsibilities:

  • Built and configured an offsite Windows Window 2007 Server and configured the IIS server accordingly
  • Developed a fully functional ASP.NET / JAVA solution for Confidential ; 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

Confidential, - Carpentersville, IL

Microsoft Access Developer / Systems Analyst

Responsibilities:

  • 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 in order to more efficiently create and maintain new and existing production databases

Confidential, Warrenville, IL

VB6/.NET/Microsoft Access Developer/Analyst

Responsibilities:

  • 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 in order 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)
  • Provided management with a portal created with Microsoft Visual Studio 2008 and Crystal Reports XI to generate ad-hoc reports that connect to various sources, including SQL Server 2005, Oracle iProcurement database, Oracle RTA Fleet Management database and Microsoft Access 2003 tables

Confidential - Chicago, IL

Microsoft Access/VB6 Programmer/Systems Analyst

Responsibilities:

  • 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 Synactics 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

Confidential - Glendale Heights, IL

Microsoft Access Developer/Technical Support

Responsibilities:

  • 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)

Hire Now