SUMMARY:

• IT Professional with over 20 years of technical experience in Requirement Analysis, Architecture Design, Software Design, Implementation, Database Design/Implementation, Business/Scientific Programming Migration, Production and Technical Support
• 20+ years experience - Application Development, MS Access
• 15+ Years Experience in ODBC
• Understanding of network design and configurations
• 20 + years of P.C. desktop support support experience in high volume environment
• 15 years of experience in a Microsoft Windows network environment
• 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
• Developer of database management solutions and customized applications - VB/VBA. MS- Access , SQL, ODBC and ADO

TECHNICAL SKILLS:

Operating Systems: Windows operating systems (WIN10, WIN7, XP)

Languages/Technology: ASP, 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 Server 2000 and up, Ms-Project, Delphi, Ms-Outlook 9x, 2000 and up, Oracle, Teradata, SAP, JDA Platform

PROFESSIONAL EXPERIENCE:

Confidential, Hershey, PA

Technical and application support

Responsibilities:

• Coordinated, supervised and implemented 35 database conversion projects, completing weeks ahead of project scope
• Coordinated Unit, Integration, UAT testing for database conversion projects
• Supervise and coordinate development teams
• Coordinate and supervise requirements gathering sessions
• Coordinate and supervise design and development processes
• Coordinate and supervise design and development of all MS Access applications
• Coordinate and supervise third party software interfaces (i.e., SAP)
• 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
• 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
• Provide remote support and assistance

Confidential, Harrisburg, PA

Sr. Access Developer/Application Support

Responsibilities:

• 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

Confidential, Spencer, IN

Sr. Access Developer/Application Support

Responsibilities:

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

Confidential, Sheboygan, WI

Access Developer/Applications Support

Responsibilities:

• Remote Access developer.
• Developed functions and sub routines using VBA code exclusively
• Performed detailed analysis of business processes/requirements
• Writing/documenting functional requirements
• Reengineer Access front-end User interface via virtual terminals.
• Redesign SQL ODBC backend connections.
• 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
• Performed database conversions from Access 2003 (mdb) to Access 2013 (accdb)
• Performed data analysis to develop best solutions and practices
• Provided technical support/assistance for all application modifications (front- end and back-end).

Confidential, Fort Wayne, IN

Access 2010 Developer/Systems Support Tech

Responsibilities:

• 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

Confidential, Mettawa, IL

Access 2010 Developer

Responsibilities:

• 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