Jay Mccormick Email & Phone Number

Justice, Il, Us

Mclean, Virginia, United States

* Worked in Agile team on a contract for the State of Illinos DCFS on a large scale application conversion and upgrade project across the State Agency.* Developed a refactoring tool to scan MS Access VBA code in numerous databases used by 6 team members to efficiently perform important code upgrades in hundreds of MS Access databases.

Chicago, Illinois, United States

• AMK Products (Virginia) - Fastener Company - Large custom eCommerce website, ERP System for tracking fastener orders, inventory, reporting, and pulling orders from inventory. Technical Environment: WordPress PHP, MySQL, MS Access VBA, WEB Integration• Down To Earth Landscaping (Chicago) - Mulch and rock delivery company - Mobile web application for truck drivers, integrated with local orders application. Technical Environment: MS Access VBA, .net MVC, SQL Server• Cambridge Partners (Chicago) - Asset valuation and Return mail processing - Migrated legacy SQL Server DTS packages to SSIS, reprogrammed ETL ProcessTechnical Environment: SQL Server Integration Services, SQL Server, MS Access VBA• Avance - Psychological counseling office - Patient and Billing database, reporting Technical Environment: MS Access VBA, SQL Server

Chicago, Illinois, United States

Leading real estate company - lead developer for heavily coded MIS Management tool using Excel and Access that is used in 1,800 offices nationwide. Re-wrote complex ETL process and reduced run time by 50%

Chicago, Illinois, United States

Built highly complex permit tracking system for new renewable energy siting applications that developers must complete for development.

Justice, Il

• AMK Products (Virginia) - Fastener Company - Large custom eCommerce website, ERP System for tracking fastener orders, inventory, reporting, and pulling orders from inventory. Technical Environment: WordPress PHP, MySQL, MS Access VBA, WEB Integration• Circle 8 Logistics - Complex 3PL Application for Freight Brokers - Added custom features and specialized reporting. Collaborated with staff and management closely.Technical Environment: MS Access VBA, T-SQL, EDI WEB for truck loads, JSON / XML• Trident Pipeline - Pipeline inspection company - developed remote field work force time reporting application with integrated customer invoicing and reporting.Technical Environment: MS Access VBA, SQL Azure• Mestek (Massachusetts) - Manufacturer of Baseboard Heaters - Equipment maintenance application to track hundreds of machines on 40K sq/ft facility, used by staff of 20+ users.Technical Environment: MS Access VBA• Keith Zars Pools (Texas) - Complex ERP System for large custom pool builder – Application has 120+ users and over 100 forms and reports. Completed task-based projects to add and enhance features for various departments like purchasing, engineering, and maintenance. Fixed application inefficiencies.Technical Environment: MS Access, SQL Server, T-SQL• Special Managers Insurance – Development of intricate system to generate insurance policy pdf documents using word and pdf manipulation. Policy pricing and payments calculator. Developed reports and data exports for Lloyds of London. Technical Environment: MS Access VBA, MS Word VBA, PDF Coding.• Instructor of MS Excel and MS Access advanced VBA classes in computer training facility.• Various mid-sized companies – Custom database projects to enhance existing and develop new MS Access applications.

Woodridge, Il

Develop Business Intelligence processes to deliver data dashboards, reporting, and analysis to both education, government, and healthcare verticals within enterprise. Tools used are Visual Studio, SQL Server - SSMS, SIS, SRS, and SQL Analytical Services.

Chicago, Il

Develop MS Access solutions with SQL Server as data source for a variety of companies.

Addison, Il

-Performing extensive business analysis across three departments to tie together Cap Contract re-calc process that is currently overly-fragmented.-Developed system that re-calculates the cap amount based on six months of usage for clients.

Chicago, Il

• Part-time subcontracting work corp-to-corp on small projects.• Modified and enhanced application for label machine, integrated through automation with MS Access and proprietary label software. Developed new label and application interface.• Modified complex code that produces sin wave points for robotics operation file, to auto-punch holes in leather console for Rolls Royce automobiles. Used VB6 for application.• Developed custom PO and purchasing system from requirements, for conveyor manufacturing company. Designed interface, coded, tested, and trained with finance department.

Schaumburg, Il

• Modify and enhance application for label machine, integrated through automation with MS Access and proprietary label software. Developed new label and application interface.• Modified complex code that produces sin wave points for robotics operation file, to auto-punch holes in leather console for Rolls Royce automobiles. Used VB6 for application.• Developed custom PO and purchasing system from requirements, for conveyor manufacturing company. Designed interface, coded, tested, and trained with finance department.

Corporate Headquarters - Riverwoods, Il

• Working in the Risk business unit, in the Vendor Audit Policy & Procedure Analytics department. I collaborated with team members to create the SAR Tracker (Suspicious Activity Reporting Tracking system) that 50 personnel used for their primary job function in two cities. • Led and initiated numerous meetings and create database and application design with little direction. Worked iteratively with team leads to insure application met all their needs. Performed extensive tests to determine optimum data configuration, and built relationships with key personnel. • Utilized MS Access 2010 VBA with ADO Data connections to create the application. Trained a small team of other consultants to maintain the application.

Corporate Headquarters - Naperville, Il

• Designed, created, and trained users on MS Excel based Sales tracking application. Directly queries SQL Server of all sales transactions, posts summarized in bands across daily, week to date, month to date, quarter to date, year to date, and other categories by four different groupings: Product category, sales region, product type, and market type.• Application ran efficiently from any network-connected computer, and auto-populated to the current day's sales upon opening. Application included drill-down capability for looking at individual sales rep's performance within any given region, and a drill down for product category to view all product types.• Collaboratively worked with finance team to understand and pull data from SAP accounting system using SQL Server and ADO Connections inside MS Excel.• Target audience of this sales analysis tool were the Vice Presidents of sales in all regions across the country. The project was met with great appreciation and had a high profile, mitigating impact on a number of key business 'pain points' the leaders of the sales teen have been experiencing for many years. I trained directly a number of Vice Presidents of Sales in use of the application.• Was hired by Office Max, and at close of project Office Max was purchased by Office Depot.

Whiting Refinery Modernization Project - Whiting, In

• For IMPT Project Controls, collaboratively designed and developed cost management and accounting tool that integrated with SAP. Used by team manage budgets, cost accounts, change management logs, and to produce monthly cost reports used by lead management team on WRMP. Trained personnel on use of system.• For 12 PipeStill, developed a data integration tool from COINS software, forecast numbers, and manually entered milestones to produce five key weekly mission-critical reports. Trained personnel on use of system.• For 12 PipeStill, developed daily manpower force reporting system for 12 contractors reporting in to major area of project. Automates excel spreadsheet tabulation for site-wide report of headcount. Implemented training of contractors.• Developed rental equipment management system. I assisted the Commercial Manager in the coordination of many departments, managers, and personnel. Led meetings and conducted training for groups of contractors. Developed collection and reporting system for all data.• Performed business analysis, process refinement, and maintained professional business relationships with managers and staff among a wide variety of departments and areas of the project.

Oak Brook Terrace, Il

• Developed process automation applications for efficient processing of medical claim analysis within MS Access 2007, integrated with Attachmate Reflections scripting. This application saved the company hundreds of hours of manual processing• Automated access of government medicare system and scraped results back into custom built application, processed results, and posted final data calculations.• Automated the process of retrieving, reactivating, and scanning for medicare payments on all claims that were analyzed by Vaughan Holland Consulting.• Setup and installed MS SQL Server 2008 from newly purchased server.• Moved Managed Care database application from MS Access 2003 to SQL Server 2008 using migration tools, and SQL Scripts.• Modified the Managed Care database to normalize table and field names and changed references throughout the entire system to reflect changes.• Assisted owners and other Vaughan Holland personnel with various MS Access projects.

Lisle, Il

• Determined feasibility, performed development, as well as big fix of mailing systems databases using MS ACCESS, Planet Press Software, VB Script, and verious other third party tools. These system integrated into the automated folding and inserting machines do that a raw data file could be loaded, and after processing, a postal coded and sorted file is fed into the system for printing, folding, inserting and sealing of envelopes.

• Responsible for the overall operations of IT in the company, I supervised the IT Department and was mainly responsible for implementing a company-wide software program through all departments. I also developed a complete application for paperless invoicing through DSSI which is a third party clearing house. Company has fourteen locations in nine states.

• Worked as a developer on numerous applications to support the Credit Insurance division. Performed business analysis extensively, analyzed requirements, performed testing, and user acceptance. Was promoted from team member to team lead of three programmers within one month of working in position. 200+ employees in this division, our team served all applications they used.

Bachelor Of Science, Business Administration

Activities and Societies: Internation Business Club Intermural FootballBusiness Degree with minor in Russian Language

High School Diploma, College Prep

College Prep