Michael May Email & Phone Number

Designed SQL server databases, queries, stored procedures and managed permissions. Automated business processes and reporting tasks. Created interactive Excel reports using VBA. • Created application to monitor, log and report database usage and patterns for all databases that IT department supported, eliminating 71% of 496 databases that IT supported. • Reverse-engineered legacy sales tax application by creating user interface that led user through sequence of well-defined step… Show more Designed SQL server databases, queries, stored procedures and managed permissions. Automated business processes and reporting tasks. Created interactive Excel reports using VBA. • Created application to monitor, log and report database usage and patterns for all databases that IT department supported, eliminating 71% of 496 databases that IT supported. • Reverse-engineered legacy sales tax application by creating user interface that led user through sequence of well-defined step to complete process, reducing workload of both IT and finance departments. • Documented HP 3000 tape rotation and archiving procedures, which included instructions for daily and weekly tape rotation, month-end closing, in-house and off-site tape storage, tape labeling and drive-head cleaning, leading to less downtime due to missed tape changes and better financial record-keeping compliance. • Created application to search code and objects across multiple access databases, allowing references to be discovered quicker to solve problems. Show less

Johnson City, New York, United States

Designed SQL server databases, queries, stored procedures and SQL server agent jobs. Automated data-entry, data transfer and reporting tasks. Authored user guides and technical documentation. DBA activities included backup, restore and creation of database maintenance plans. • Created SQL Server / Visual Basic application that facilitated root cause analysis and performance monitoring of pharmaceutical counting technology systems and devices, reducing average time to perform single… Show more Designed SQL server databases, queries, stored procedures and SQL server agent jobs. Automated data-entry, data transfer and reporting tasks. Authored user guides and technical documentation. DBA activities included backup, restore and creation of database maintenance plans. • Created SQL Server / Visual Basic application that facilitated root cause analysis and performance monitoring of pharmaceutical counting technology systems and devices, reducing average time to perform single analysis from 20 minutes to 5 minutes and reducing average time per day for total work from 9 hours to 2.25 hours. Show less

Endwell, New York (On-Site At Lockheed Martin - Owego)

Designed MS Access database applications. Developed a Visual Basic.NET to automate the process of creating and maintaining DOD engineering change proposal documentation. Created interactive Excel reports using VBA.

Johnson City, New York

Designed SQL Server databases, queries, stored procedures and Agent jobs; automated data-entry, data transfer and reporting tasks. Diagrammed data and process flows. Optimized SQL Server queries and stored procedures that ran against 300-gigabyte data store with over 1B records. Other tools and technologies used: MS Access, MS Excel and VBA.

Binghamton, New York

Developed MS Access application and user documentation for NYSEG's "Pole Access Management Program".

Binghamton, New York

Developed database and ASP programming that ran LookingYourBest.com (competitor to WebMD.com). Designed web-based order entry and call center applications. Created algorithms used by commercial banking application for mortgage and finance calculations. Collaborated with clients to translate project's business requirements into functional and technical specifications for software being developed.

Binghamton, New York

Designed SQL Server and MS Access database applications. Developed the programming logic for a 'one-to-one' marketing campaign using latitude and longitude coordinates along with customer survey data to individually match over 500,000 Bell Atlantic customers to more than 3,000 local and national merchants. Automated data-entry, data transfer and reporting tasks. Other tools and technologies used: MS Excel and VBA, geocoding, address standardization and MapInfo.

Binghamton, New York (On-Site At Children'S Home Of Wyoming Conference)

Built MS Access applications and reporting tools to support Children's Home quality improvement department.

Norwalk, Connecticut

Developed MS Access application to manage company calibration and measurement standards. Metrology work included performing tooling qualifications, reading engineering drawings and geometric dimensioning and tolerancing.