Software Consultant Resume Profile

SUMMARY:

Certified software developer with over 20 years' experience in database development and a broad range of computer applications. Very strong analytical and problem-solving skills. Meticulous, organized, collaborative, an outstanding trainer, and work well with all levels of users. Recognized by past clients and employers for excellence in both performance and character.

RELEVANT SKILLS:

Able to communicate with clients on all levels of the development cycle Strong experience programming with MS Access VBA Create application and data reports as necessary to support internal or client requests Train /instruct users on software applications Developing complex solutions in VBA Writing, coding, testing portable VBA code modules in MS Access Strong analytical skills Create ad hoc customized desktop systems for handling the creation and manipulation of data Enhance and test new applications Convert external data to MS Access Connect to SQL Server with MS Access using ADO or ODBC Complete lifecycle of software development from concept to delivery

TECHNICAL CERTIFICATIONS:

Microsoft Certified Application Specialist MCAS Microsoft Office Access 2007 Certified in SQL Server Admin Versions 4,6.5, and 2000 Certified in Visual Basic Programming Versions 3, 4, 5, and 6 Certified in Access Database Programming Versions 92, 95, and 97 Microsoft Certified Solutions Developer MCSD 2000 Microsoft Officer User Specialist Expert MOS-e 1998 Microsoft Certified Professional MCP 1995 TRAINING EXPERIENCE: 25 years of technical training experience Certified Technical Trainer CTT 1993 Microsoft Certified Trainer MCT 1992 Trained several thousand people on Microsoft Software from end-user products through Visual Basic and Access Programming

WORK HISTORY:

CONFIDENTAIL Software Consultant

Projects included:

Design complex macros that eliminate manual processing. Design, modify, and program Access database using queries, macros, and forms. Import, extract data from text files using VBA, and then importing the data into SQL Server. Build custom functions, queries, forms, and reports using VBA. Data analysis by creating pivot charts and tables. Import/export data to Excel spreadsheets from Access. Create complex dynamic queries using VBA. Create reports for management by exporting the data to Excel. Extrapolate data from text files into SQL server using Access VBA. Define what needs to be done in order to meet the business requirements. Gather detailed information about the business requirements for the project. Improve functionality of existing databases using VBA. Redesigned a new program into Access 2010, from a previous program that was written in Paradox saved client an average of 98,000 per year.

CONFIDENTAIL MS Access VBA Application Specialist Projects included: Writing, coding, testing portable VBA code modules in Access. Record set creation via dynamic queries in VBA code. Imported text files into a SQL database using VB.Net. Ability to import and manipulate data via complex queries, using ODBC connections. Updated existing Access database systems. Interfaced with SQL Server. Imported Excel spreadsheets into Access and created related tables. Developed tools that enabled the manager to manage the finances in a timely manner. Documentation of database design and implementation. CONFIDENTAIL MS Access Developer Projects included: Converted a manufacturing system in that existed in Excel to an Access database. There was a greater increase in efficiency in retrieving the information. Generation of timely reports that reflected all stages of material accounting. Better control of the entire manufacturing process. Converted pay scale from Excel to Access. Information was sorted and cataloged and then exported back to Excel. Compared top-executive salaries to like positions in other companies. There was a great savings of time for the HR department. Allowed sales personnel to track information about each student and what classes they took. Generated mass-mailings to each student. Allowed the tracking and generation of new classes. Generated thousands of dollars in income for the company.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship