Roderick Hood
Newington,CT
Summary
Experienced IT professional with a strong background in MS Access database development, requirement analysis, and software design. Skilled in network design, configurations, and PC desktop support in high-volume environments. Proficient in Java, MS Excel, Oracle, and other tools for designing and developing data repositories. Expertise in developing database management solutions using VB/VBA, SQL, ODBC, and ADO. Familiarity with HTML, CSS, and C++ languages, with a syntax structure similar to Turbo Pascal used in Delphi development.
Overview
33
33
years of professional experience
Work History
Sr. MS Access VBA Developer/ IT Application Analyst
Edgewater Federal Solutions Inc.
Frederick, MD
03.2024 - Current
- Update/Maintain existing Capital Working Fund applications for Dept. of Energy
- Support and maintain SQL server applications (Stored procedures, views, etc.)
- Provide user support and instruction
- Manage seven MS Access applications for three department
- Developed new deployment strategy resulting in a 20-minute decrease in processing time
- Troubleshot and resolved issues in existing VBA applications, enhancing overall system stability and reliability.
- Consistently met project deadlines by efficiently managing multiple concurrent assignments as a dedicated VBA Developer.
- Increased data accuracy by designing validation checks within VBA scripts to ensure consistency across datasets.
- Spearheaded a data conversion from Access to SQL Azure
- Trained colleagues on best practices for VBA development, contributing to a more skilled and efficient team environment.
- Improved workflow efficiency by automating repetitive tasks with VBA scripts.
- Contributed to increased productivity levels by creating time-saving macros that automated monotonous manual tasks across departments.
- Maintained excellent communication throughout projects, providing regular updates and seeking feedback to ensure alignment with stakeholder objectives.
- Enhanced user experience for internal tools by developing user-friendly interfaces with custom forms and controls.
- Implemented security measures within VBA code to protect sensitive company information from unauthorized access or tampering.
- Provided comprehensive documentation for developed VBA modules, facilitating ease of maintenance and future updates.
- Migrated legacy systems to modern platforms using expert knowledge of VBA compatibility and integration techniques.
- Developed conversion and system implementation plans.
Sr. MS Access VBA Developer/IT Analyst
Next Step Recruiting
Newington, Connecticut
06.2023 - 02.2024
- Develop new Access/Excel applications
- Maintain existing applications
- Support and maintain SQL server applications (Stored procedures, views, etc.)
- Provide user SQL logins
- Provide user access and security to Database applications
- Corrected, modified and upgraded software to improve performance.
- Designed and developed forward-thinking systems that meet user needs and improve productivity.
MS Access VBA Developer
Dept. of Energy & Environmental Protection (DEEP) State of CT for New York Global Consultants Inc (NYGCI)
Hartford, CT
06.2021 - 04.2023
- Provide technical and application support for State of CT MS Access support
- Coordinate, supervise and implement MS Access database conversion project
- Coordinate Unit, Integration, UAT testing for database conversion projects
- Solution provider for existing applications
- Design and develop all MS Access applications
- Recommend and implement best practices in application development and deployment
- Access to SQL Conversion
- Pioneered the adoption of best practices for VBA code optimization within the organization, leading to improved performance across all applications.
- Contributed to increased productivity levels by creating time-saving macros that automated monotonous manual tasks across departments.
- Increased data accuracy by designing validation checks within VBA scripts to ensure consistency across datasets.
MS Access VBA Developer
Southwest Business Systems Corporation (SWBC)
San Antonio, Texas
06.2021 - 02.2023
- Convert Manual Mortgage Post Close Process to automated process using MS Access
- Design and develop new Post Close Database
- Recommend and implement best practices in application development and deployment
- Access to SQL Conversion
- Improved workflow efficiency by automating repetitive tasks with VBA scripts.
- Developed custom reporting tools using VBA, streamlining the generation of critical business insights for decisionmakers.
- Provided comprehensive documentation for developed VBA modules, facilitating ease of maintenance and future updates.
- Corrected, modified and upgraded software to improve performance.
MS Access VBA Developer/Application Support Specialist
Athena Health Care Systems
01.2021 - 03.2022
- Design, implement, test, documents, and support new and existing software or systems.
- Reengineering of legacy database applications. collaboration with IS department.
- Recommend and restructure of deployment processes for all Access applications.
- Participated in operational projects while performing programming and scripting utilizing for 1 or more of the following programming languages and SQL; VBA, VB script.
- Assisted in planning and systems analysis and,software configuration and training of employees on Company systems : Provided Network and desktop support.
MS Access VBA Developer
IRIS USA Inc.
08.2020 - 12.2020
- Design, implement, test, documents, and support new and existing software or systems.
- Took an active role in problem-solving by meeting with employees at all levels to better integrate the use of IS resources into the company. Shared and collaborated with other members of the IS department.
- Participated in operational projects; while performing programming and scripting utilizing for 1 or more of the following programming languages and SQL; VBA, VB script.
- Assisted in planning and systems analysis and,software configuration and training of employees on Company systems : Provided Network and desktop support.
MS Access Developer
State of Connecticut, Hartford, CT for Tri-Com Consulting Group
01.2020 - 06.2020
- Provide technical and application support for State of CT MS Access support
- Coordinate, supervise and implement a 1000 MS Access database conversion project
- Coordinate Unit, Integration, UAT testing for database conversion projects
- Solution provider for existing applications
- Design and develop all MS Access applications
- Solution provider for existing applications
- Recommend and implement best practices in application development
Database Application Developer
Graham Packaging, Lancaster, PA for Next Level Business Services, Inc.
10.2019 - 05.2020
- Develop a database application tool to update the feasibility process and training that will focus Graham on strategic and financially relevant opportunities
- Develop a process to increase the number of opportunities killed in the feasibility phase
- Develop a process to increase the % of quotes submitted that are won
- Develop a process to reduce the average quoting life cycle and re-work
- Develop and implement best practices in application development
Database Administrator/Sr. MS Access Developer
Newport News Shipbuilders, Newport News, VA for American Cybersystems
05.2019 - 09.2019
- Implemented and maintained smooth operation and physical design of databases. Conducted performance tuning of indexes and databases in general.
- Reviewed database design and system integration.
- Evaluate and assess database design structure
- Re-design legacy database applications for Engineering and Submarine retrofits
- Solution provider for existing applications
- Develop and implement best practices in application development
Lead MS Access Developer and Support
Russell Investments, Seattle, WA for Crescens Inc
01.2019 - 05.2019
- Evaluate and assess database design structure
- Recommend and implement enhancements and modifications
- Re-design legacy database applications
- Solution provider for existing applications
- Recommend and implement best practices in application development
- Support SQL server applications as they relate to Access applications
Lead Developer and Support for MS Access/Excel applications
First Data Corporation, Atlanta, GA for Panzer Solutions
07.2018 - 10.2018
- Evaluate and assess database design structure
- Recommend and implement enhancements and modifications
- Re-design legacy database applications
- Solution provider for existing applications
- Recommend and implement best practices in application development
- Support Oracle and SQL server applications as they relate to Access applications
- Supported SharePoint/Access/Excel integrated applications
- Designed and developed MS Excel templates for data transfer and manipulation
- Maintained Excel VBA and macros
- Created automation process for Access and Excel data transfer
MS Access Developer
The Hershey Company, Hershey, PA for Computer Aid, Inc.
10.2016 - 06.2018
- Provide technical and application support for Hershey IS MS Access/Excel support
- Coordinate, supervise and implement a 5000 MS Access database conversion project, completing weeks ahead of project scope
- Coordinate Unit, Integration, UAT testing for database conversion projects
- Coordinate, design and supervise global application solutions. Developed multi record upload decreasing a manual process of 45 minutes to 3 minutes.
- Solution provider for existing applications
- Supervise and implement best practices in application development
- Design and developed MS Excel templates for data transfer and manipulation
- Maintain Excel VBA and macros
- Create automation process for Access and Excel data transfer used in 17 countries
- Supervise and coordinate development teams
- Served as developer and business analyst
- Design and develop all MS Access applications
- Solution provider for existing applications
- Recommend and implement best practices in application development
- Support SQL Server and Oracle applications as they pertain to the Access front ends
- Support JDA platform services
- Support Control-M Batch processing Services
- Support Unix Server applications
- Support and maintain SharePoint integrated applications.
- Provide remote support and assistance
- Coordinate and supervise requirements gathering sessions, supervise design, development processes including all MS Access applications
- Coordinate and supervise third party software interfaces (i.e., SAP)
Sr. Access Developer/Application Support
Commonwealth of PA, Harrisburg, PA for DevCare Solutions
01.2016 - 10.2016
- Provide technical and application support for the State of PA Department of Human Services (DHS)
- Administered, structured and supervised Commonwealth’s database design and support processes
- Coordinated and implement application design enhancements
- Develop and maintain front end database objects (i.e, tables, queries, forms, reports, etc.)
- Performed data analysis to develop best solutions and practices
- Managed/maintained Excel templates and VBA source code
Sr. Access Developer/Application Support Tech
Boston Scientific, Spencer, IN for Experis
07.2015 - 12.2015
- Analyze modify/enhance existing Access application.
- Restructured / converted macros to VBA code.
- Developed extensive functions and sub routines using VBA code exclusively
- Performed detailed analysis of business processes/requirements
- Writing/documenting functional requirements
- Redesign Access front-end User interface.
- Update PL/SQL stored procedures.
- Develop and maintain SQL and Access backends
- Develop and maintain front end database objects (i.e, tables, queries, forms, reports, etc.)
- Proposed and developed and time and cost-effective solutions
- Integrated Access with other Microsoft applications (i.e., Excel, Word) and external applications
- Provided technical support/assistance for all application modifications (front- end and back-end).
- Note: All procedures are written using Access VBA code and PL/SQL exclusively.
Access Developer/Applications Support
Nemschoff Corp, Sheboygan, WI (Remote developer- Contract)
03.2015 - 12.2015
- Remote Access developer.
- Developed functions and sub routines using VBA code exclusively
- Performed detailed analysis of business processes/requirements
- Writing/documenting functional requirements
- Redesign Access front-end User interface via virtual terminals.
- Redesign SQL ODBC backend connections.
- Develop and maintain front end database objects (tables, queries, forms, reports, etc.)
- Proposed and developed and time and cost-effective solutions
- Integrated Access with other Microsoft applications (i.e., Excel, Word) and external applications
- Performed database conversions from Access 2003 to Access 2013
- Performed data analysis to develop best solutions and practices
- Provided technical support/assistance for all application modifications (front- end and back-end).
- Note: All procedures are written using Access VBA code and SQL exclusively.
Access 2010 Developer/Systems Support Tech
Lincoln Financial Group, Fort Wayne, IN
06.2013 - 02.2015
- Converted and developed 1800 Access 2003 databases to Access 2010.
- Converted approximately 200 Word 2003 Documents to Word 2010 with MS Access and Excel integration.
- Ability to take abstract instructions and develop detailed systems to meet the objectives
- Access query development
- Work well independently with the ability to think on my feet
- Self-starter with excellent communication and interpersonal skills
- Interface design using various design products (i.e., Adobe Creative Suite, (InDesign, LiveCycle, MS Access interface designs).
- Developer skill set within MS Access/Excel/VBA 2003/2007/2010, SQL
- Project management skill set
- Highly effective communicator
- Ability to lead a team of developers
- Database documentation skills
- Automation and Process Improvement knowledge
- Developing and managing multiple projects in parallel with tight deadlines
- Integrated SQL Server Integration Services (SSIS)
- End-User network support
- Recommended time effective network configuration modifications
- Note: All procedures are written using Access VBA code and PL/SQL exclusively.
Access 2010 Developer
Capital One HSBC, Mettawa, IL
04.2013 - 06.2013
- Using Access 2010 designed and developed new application from legacy application.
- Desire and ability to take abstract instructions and develop detailed systems to meet the objectives
- Work well independently with the ability to think on my feet
- Self-starter with excellent communication and interpersonal skills
- Developer skill set within MS Access/Excel/VBA 2003/2007/2010
- Project management skill set
- Database documentation skills
- Automation and Process Improvement knowledge
- Mainframe file conversion to Access database file format
- Extracted Data using SAP Data Services
- Note: All procedures are written using Access VBA code and SQL exclusively.
Access 2010 Developer/Systems Support Tech
Rehrig Pacific Logistics, Racine, WI
02.2013 - 04.2013
- Using Access 2010 designed and developed front-end UI for SQL Server data querying.
- Strong PC-skills (MS Office, IE, Microsoft Outlook)
- Desire and ability to take abstract instructions and develop detailed systems to meet the objectives
- Development of queries in MS SQL Server
- Work well independently with the ability to think on my feet
- Self-starter with excellent communication and interpersonal skills
- Developer skill set within MS Access/Excel/VBA 2003/2007/2010
- Developer skill set within MS SQL Server 2005/2008
- Project management skill set
- Highly effective communicator
- Ability to lead a team of developers
- Database documentation skills
- Automation and Process Improvement knowledge
- Experience handling multiple projects in parallel with tight deadlines
- Experience with MS SQL Server
- Familiar with general development/support life cycle
- Limited inclusion of SSIS with applications
Access/SQL Developer
Blue Cross Blue Shield of IL, Chicago, IL
09.2012 - 02.2013
- Access developer 2010.
- Architect of BCBSs administrative portal to clients benefit selection software.
- Converted manual processes to fully automated application.
- VBA, SQL, T-SQL, stored procedures.
- Used Cognos in limited capacity
Access Developer
Case New Holland (CNH), Racine, WI
02.2011 - 09.2012
- Primary Access 2010 developer of CNH’s employee manufacturing performance application.
- Designed and developed a “Kaizen” approach application which measures and calculates degrees of human error, and successes.
- Designed SQL connection strings for SQL server integration.
- Designed a cost benefit analysis application to calculate cost benefits of the manufacturing processes.
- Developed an employee call log system for employee call INS.
- This system was a manual process consuming approximately 15-20 minutes per call.
- The application cut time to 2 minutes per call maximum.
Developer
Diversey Corp., Sturtevant, WI
07.2010 - 02.2011
- Developed customer analytics application for customer services division.
- Configured and established server connections.
Senior MS Access VBA developer
Quad Graphics, Addison, TX
03.2009 - 06.2010
- SQL, XML, CVS, and Excel file conversion to designed Access database.
- Restructured various databases to be incorporated into one system in a multi-user environment.
- Created fully automated file conversion procedure to load and convert daily approximately 38,000 – 43,000 MS Excel rows to an Access table.
- Created SQL connection strings from Access to SQL Server and Data warehouse tables in conjunction with Business Objects/BI Tools.
Access Developer
Clifton Gunderson, L.L.P, Glen Allen, VA
12.2008 - 02.2009
- Using MS Access, design and develop an employee and qualification database.
- After an MS Excel file conversion, this database is used for generating resumes and biographies with photos and submission to potential clients/customers.
- Created SQL Server conversion process, converting MS Access tables to SQL Server database.
- Created and implemented SQL connection strings for SQL Server.
Global Developer
Manpower Corp., Milwaukee, WI
10.2007 - 11.2008
- This position reports to the Manager of Software Development and Support.
- Primary responsibilities consisted of analysis, Java programming and maintenance/support tasks related to the development of enterprise information systems.
- Duties listed would vary in terms of relative importance and others may be added or eliminated as the computer environment changes and grows.
- Using Java, MS Access, MS Excel, MS Visio, MS Project and Oracle, Design and Develop and data repository for searching and reporting of components of the global applications
- Created and implemented PL-SQL scripts for data conversions
- Develop, modify, and maintain web-based Java application, which will track client services from intake, assessment, service planning, treatment, and discharge.
- Create and maintain documentation for the web-based application, including producing well-documented code.
- Testing of the application to ensure, user friendly, interface and required functionality.
- Interact with users to ensure application operates efficiently. Respond to user’s requests for enhancements and/or troubleshooting.
- Implementation / deployment of the application.
- Develop or assist in the development of interfaces to other enterprise information systems, especially the financial software.
- Diagnose and resolve application software problems.
- Practice and promotes safety in the workplace.
- Performs other duties as assigned.
Access Developer
Genentech Corp, South San Francisco, CA
04.2006 - 09.2007
- Remote Access/SQL developer for Contract project at Genentech Corp.
- Primary developer and technical support for Genentech’s pharmaceutical marketing team.
- This project was done remotely however required bi-weekly and sometimes weekly site visits.
Access Developer
AT&T, Rosemont, IL (Remote Development)
04.2006 - 06.2007
- Remote Access/SQL developer for Contract project at AT&T.
- Primary developer for AT&T, Bell South and Cingular mergers.
- Responsibility included data conversion of three data environments to operate in an Access/VBA environment.
- This position was also responsible for training systems and software training as well as the provisions of technical support of systems and software applications.
- This project was done remotely however required bi-weekly and sometimes weekly site visits.
Access Developer
US Cellular, Chicago, IL
01.2006 - 04.2006
- Contract project at US Cellular as an MS Access Developer.
- Position required data conversion from Excel, SAP and MARS to an Access database for analysis and manipulation.
- Specific reports were generated from this data and then converted to Excel for further analysis and manipulation.
Access Developer
Ochoas Sorting Services Corp, South Holland, IL (Remote Development)
04.2000 - 06.2005
- Developed database management solutions and customized applications utilizing VB/MS-Access, SQL, ODBC and ADO.
- Collects, normalizes, and reconciles data for reporting purposes.
- Provides a variety of server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Performed MS Access data conversions to a SQL Server database providing increased data stability using the SQL engine instead of the Access Jet engine.
- In addition, designed Visual Basic applications based on previously designed Access applications.
- Transferred Access reports and data to Excel spreadsheet formats for data manipulation.
- Evaluated proposed system and software purchase considerations.
- Maintained all computer needs such as Network design and development, systems upgrades and all levels of technical support.
- Developed user instructional materials/training manuals.
- Designing, Developing, and Testing Database Applications for server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developing MS Access Packages and Stored Procedures.
- Network setup and installation.
- Systems, software and network support.
- Resources/Languages: Windows XP, Windows 2000, ActiveX, Stored Procedures, SQL, VB6, VBA, MS Access, MS Vision, MS Project, MS PowerPoint, MS Excel, Office 2000 - 2007
Access Developer
Rogers Corporation, Carol Stream, IL, USA (Remote Development)
04.2001 - 06.2002
- This was an Application Development Project for the Bisco Materials Unit of Rogers Corporation.
- Performed data conversion of Lotus 123 files to MS Access database with a later conversion to VB6 front end and SQL Server back end.
- Performed data transfers from Access tables to Excel Spreadsheets for data manipulation.
- Collected, normalized, and reconciled data from the various legacy and emerging Local Network Systems for reporting purposes.
- Provided a variety of server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developed user instructional materials/training manuals.
- Provided telephone consultation on software functionality, maintenance and software requirements gathering for upcoming projects.
- Front end responsibilities include Designing, Developing, Testing and Migration to Testing and Production of Database Applications for server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developing MS Access Packages and Stored Procedures.
- SQL tuning for better performance of Reports.
- Resources/Languages: Windows NT, Windows 2000, ActiveX, Stored Procedures, SQL, VB6, VBA, MS Access
Access Developer
PSCU Service Centers/St. Petersburg, FL, USA
10.2000 - 04.2001
- Developed database management solutions and customized applications utilizing VB6, MS-Access, VBA, SQL, Delphi, Crystal Reports and Oracle 8.
- Designing, Developing, Testing and Migration to Testing and Production of Database Applications for server and web-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developing MS Access and Delphi Packages and Stored Procedures. SQL tuning for better performance of Reports.
- Resources/Languages: Windows NT, ActiveX, Stored Procedures, SQL, VB6, VBA, MS Access, Visual Source, Safe, Delphi, Object Pascal, Crystal Reports, Oracle 8, ADO, COM
Project Lead, Access Developer
MacDill AFB, Tampa, FL
08.1999 - 08.2000
- This was an Application Development/Network and Systems support Project for the Logistical Networking Division of MacDill Air Force Base, FL.
- Designed and developed Fast Track a consolidated help Desk, Inventory, System Repair and equipment disposal database tracking program.
- Managed, coordinated and implemented the help Desk and inventory Automation tracking system, including the design and development of user and technical manuals.
- Designed and implemented help desk and inventory training programs with instruction guides.
- Transferred Access data to Excel spreadsheets and back. Instructor, Microsoft Office Suite applications.
- Configured and maintained SQL server and server reporting.
- The SQL server was used as a back-end to a VB/VBA front end application.
- Server requirements consisted of creating tables and generating reports.
- Provided a variety of server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developed user instructional materials/training manuals.
- Provide telephone consultation on software functionality, maintenance and software requirements gathering for upcoming projects.
- Designing, Developing and Testing Database Applications for server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developing MS Access Packages and Stored Procedures.
- SQL tuning for better performance of Reports.
- Designed and developed the Air Force's Personnel Movement and Management system (PMAMS), an MS Access application.
- Developed database management solutions and customized applications.
- Developed Client/Server applications utilizing MS-Access, Visual Basic and SQL.
- Experienced in full life cycle of client/server development process.
- Performed Database Administration on Access databases and SQL server.
- Created and implemented 2 and 3 tier applications.
- Performed lead duties and mentored other developers in VB/VBA and Access.
Access Developer
SecureTech Security Systems, Tampa, FL (Remote Development)
10.1999 - 02.2000
- This is a Contract Application Development Project for the SecureTech Division of ADT Security.
- Developed database management solutions and customized applications utilizing MS-Access, SQL, ODBC, and ADO.
- Collects, normalizes, and reconciles data for reporting purposes.
- Provided a variety of server-based reporting tools that allowed users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developed user instructional materials/training manuals.
- Designing, Developing, and Testing Database Applications for server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developing MS Access Packages and Stored Procedures.
- SQL tuning for better performance of Reports.
- Hardware/Operating System: Windows NT, ActiveX, Stored Procedures, SQL, VB, VBA, MS Access
Lead Access Developer
Randolph AFB, San Antonio, TX
11.1997 - 07.1999
- Task/Project lead and lead analyst for the reengineering and enhancement of the Air Force's Commercial Activities Management Information systems (CAMIS).
- Performed systems reengineering support to the Air Force Center for Quality Management and Innovation (AFCQMI).
- Collected, normalized, and reconciled data from the various legacy and emerging Local Network.
- Designed and implemented user requested enhancements and made the system significantly more users friendly.
- MS-Access application. VB6/VBA and associated software tools. Provided a variety of server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Developed user instructional materials/training manuals.
- Provide telephone consultation on software functionality, maintenance and software requirements gathering for upcoming projects.
- Designing, Developing, Testing and Migration to Testing and Production of Database Applications for server-based reporting tools that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Used SQL daily to create, alter, delete and manipulate RDBMS databases.
- Developed form-based user interface using MS-Access, VBA/VB for data Access, query and editing of RDBMS databases
- Developed server-side code for client application Access
Help desk, PC Support Technician
Citicorp, Technical Support, San Antonio, TX
02.1997 - 11.1997
- Provided hardware/software maintenance support for Citicorp users.
- This support included program support, tests and debugging for Novell 3.1, 3.5 and 4.0 servers as well as supporting applications on the Windows NT server.
- Primary responsibilities included identifying and resolving problems with hardware and networks to include Novell and NT password resets, system re-imaging, and printer drive re-mapping.
- Provided user instruction and training on network security.
- Generated trouble tickets and tech service reports.
- Designing, Developing, and Testing of Database Applications that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Used SQL daily to create, alter, delete and manipulate RDBMS databases.
- Developed form-based user interface using MS-Access, VBA/VB for data Access, query and editing of RDBMS databases
- Developed server-side code for client application Access
Access Development
Interim Staffing Services, El Paso, TX
08.1992 - 02.1997
- Provided user training and support on PC and network systems.
- Primary responsibilities included MS Access and Paradox database application development including, but not limited to, developing, maintaining and training for all database applications.
- Designed and developed corporate software training programs.
- Provided installation and maintenance support for the Novell network, MS Office Suite for Windows 95, Windows 3.11, Lotus 3.4, Lotus 5 for Windows and WordPerfect.
- Developed data conversion applications between PC and (AS-400 and System 36) mainframe systems that reduced time and cost of providing information by 50%.
- Designing, Developing, and Testing of Database Applications that allow users to view pre-defined reports as well as perform ad-hoc queries to generate customized reports.
- Used SQL daily to create, alter, and manipulate RDBMS databases.
- Developed form-based user interface using MS-Access, VBA/VB for data Access, query and editing of RDBMS databases
Education
Bachelor of Science - Management Information Systems, Database Design and Administration
Kaplan University
On-Line01.2007
Skills
- Proficient in Windows operating systems
- Languages/Technology: VB SCRIPT, VB6, VBA, ACTIVE-X, SQL, PL/SQL, OBJECT PASCAL
- Resources: MS Access, MS Office Suite, (Excel, PowerPoint, Word), Visual Source Safe, MS SQL Azure, MS-SQL Server 2000 and up, SharePoint, MS-Project, Delphi, MS-Outlook 9x, 2000 and up, Oracle, Teradata, SAP, JDA Platform, SQL Server, WCM
Timeline
Sr. MS Access VBA Developer/ IT Application Analyst
Edgewater Federal Solutions Inc.
03.2024 - Current
Sr. MS Access VBA Developer/IT Analyst
Next Step Recruiting
06.2023 - 02.2024
MS Access VBA Developer
Dept. of Energy & Environmental Protection (DEEP) State of CT for New York Global Consultants Inc (NYGCI)
06.2021 - 04.2023
MS Access VBA Developer
Southwest Business Systems Corporation (SWBC)
06.2021 - 02.2023
MS Access VBA Developer/Application Support Specialist
Athena Health Care Systems
01.2021 - 03.2022
MS Access VBA Developer
IRIS USA Inc.
08.2020 - 12.2020
MS Access Developer
State of Connecticut, Hartford, CT for Tri-Com Consulting Group
01.2020 - 06.2020
Database Application Developer
Graham Packaging, Lancaster, PA for Next Level Business Services, Inc.
10.2019 - 05.2020
Database Administrator/Sr. MS Access Developer
Newport News Shipbuilders, Newport News, VA for American Cybersystems
05.2019 - 09.2019
Lead MS Access Developer and Support
Russell Investments, Seattle, WA for Crescens Inc
01.2019 - 05.2019
Lead Developer and Support for MS Access/Excel applications
First Data Corporation, Atlanta, GA for Panzer Solutions
07.2018 - 10.2018
MS Access Developer
The Hershey Company, Hershey, PA for Computer Aid, Inc.
10.2016 - 06.2018
Sr. Access Developer/Application Support
Commonwealth of PA, Harrisburg, PA for DevCare Solutions
01.2016 - 10.2016
Sr. Access Developer/Application Support Tech
Boston Scientific, Spencer, IN for Experis
07.2015 - 12.2015
Access Developer/Applications Support
Nemschoff Corp, Sheboygan, WI (Remote developer- Contract)
03.2015 - 12.2015
Access 2010 Developer/Systems Support Tech
Lincoln Financial Group, Fort Wayne, IN
06.2013 - 02.2015
Access 2010 Developer
Capital One HSBC, Mettawa, IL
04.2013 - 06.2013
Access 2010 Developer/Systems Support Tech
Rehrig Pacific Logistics, Racine, WI
02.2013 - 04.2013
Access/SQL Developer
Blue Cross Blue Shield of IL, Chicago, IL
09.2012 - 02.2013
Access Developer
Case New Holland (CNH), Racine, WI
02.2011 - 09.2012
Developer
Diversey Corp., Sturtevant, WI
07.2010 - 02.2011
Senior MS Access VBA developer
Quad Graphics, Addison, TX
03.2009 - 06.2010
Access Developer
Clifton Gunderson, L.L.P, Glen Allen, VA
12.2008 - 02.2009
Global Developer
Manpower Corp., Milwaukee, WI
10.2007 - 11.2008
Access Developer
Genentech Corp, South San Francisco, CA
04.2006 - 09.2007
Access Developer
AT&T, Rosemont, IL (Remote Development)
04.2006 - 06.2007
Access Developer
US Cellular, Chicago, IL
01.2006 - 04.2006
Access Developer
Rogers Corporation, Carol Stream, IL, USA (Remote Development)
04.2001 - 06.2002
Access Developer
PSCU Service Centers/St. Petersburg, FL, USA
10.2000 - 04.2001
Access Developer
Ochoas Sorting Services Corp, South Holland, IL (Remote Development)
04.2000 - 06.2005
Access Developer
SecureTech Security Systems, Tampa, FL (Remote Development)
10.1999 - 02.2000
Project Lead, Access Developer
MacDill AFB, Tampa, FL
08.1999 - 08.2000
Lead Access Developer
Randolph AFB, San Antonio, TX
11.1997 - 07.1999
Help desk, PC Support Technician
Citicorp, Technical Support, San Antonio, TX
02.1997 - 11.1997
Access Development
Interim Staffing Services, El Paso, TX
08.1992 - 02.1997
Bachelor of Science - Management Information Systems, Database Design and Administration
Kaplan University
Similar Profiles
Hannah CheathamHannah Cheatham
Subcontracts Administrator at Edgewater Federal Solutions, Inc.Subcontracts Administrator at Edgewater Federal Solutions, Inc.
Ethan IsenhauerEthan Isenhauer
Concrete Finisher at Ikentech LLC , Edgewater Concrete Solutions LLCConcrete Finisher at Ikentech LLC , Edgewater Concrete Solutions LLC
Landon LinkLandon Link
Enterprise Services and Customer Services Manager at Kikaha, Solutions / TrueStone FederalEnterprise Services and Customer Services Manager at Kikaha, Solutions / TrueStone Federal
William LynchWilliam Lynch
Communications and Media Intern at West Hartford Community InteractiveCommunications and Media Intern at West Hartford Community Interactive
Noel MirandaNoel Miranda
Warehouse Shipper at SaputoWarehouse Shipper at Saputo