Developer

Fred Check

TECHNICAL SKILLS

Microsoft Windows, Advanced VBA within Access, Excel, Word, PowerPoint and Outlook. SQL, stored procedures, ODBC, Oracle PL/SQL, entry level JAVA, HTML5, JavaScript, Perl.

PROFESSIONAL EXPERIENCE

06/2015 – 8/2015 CA Chiropractic San Diego, CA

Independent Contract – JAVA FX Development

Consulted with customers to identify and specify requirement.

Analyzed customer requirements and provided expert feedback to define systems requirements.

Performed needs analyses to define opportunities for new or improved business process solutions.

Defined functional and systems requirements to support proposed solution.

Planned and designed systems architecture.

Wrote a JAVA FX customized electronic customer sign-in application for a windows touchscreen (swipe left/right). Included options for updating/changing customer contact (address/phone) information, and screen for listing of current day patients log. Log shows patient information, sign-in time, serviced time, and wait times.

Installed, configured, and maintain software (when needed).

Worked with customer to test application.

01/2011 – 8/2011 AAFES Panzer Kaserne, Germany

Front Cashier

Cashier

08/2004 – 9/2010 MedImpact Healthcare Systems, Inc. San Diego, CA

Operations Technical Analyst III

Served as liaison/BA between the IT department and non-IT employees to analyze problems and develop solutions.

Held user experience design meetings to gather end-user requirements, process flow diagrams and product features.

Designed specs, wrote code, conducted unit testing, and debugged software applications.

Practiced good software engineering techniques and standards to minimize coding errors and ensure robustness and efficiency of work products.

Interfaced with internal teams and users to add new or custom features to company/stand-alone products.

Mentored coworkers in SQL and efficiency practices within a third party application used by clients.

Retrieved data from data mart and created customized reports, from client specifications, for various internal and external clients.

Built automation tools from the ideas and visions of the staff for various departments to use.

Created complex reports via online reporting tool utilizing VBA and complex SQL.

Utilized MDE databases, custom security lockdown, and enhanced security utilizing NT login. Produced professional, ‘off-the-shelf’ look, menu driven applications. Created various pass-through queries to gain access to Oracle tables and functions. Interacted with third party DLL's (RightFax 8.5) and MS API interfaces to automate tasks from within Access applications. Streamlined day-to-day processes that took hours, to minutes.

Created ad hoc queries/reports per request of department utilizing PL/SQL accessing large Oracle DB.

Created VBScripts to automated CRT input tasks.

Created complex VBA code within Access, Excel and Word interacting with each other to create complex yet time saving applications.

05/2003 – 06/2003, 6/2004 Elan Pharmaceuticals San Diego, CA

Access Programmer (Contract)

Met with SME's to analyze customer's problem areas and create a list of improvements and functional solutions.

Presented solutions and implemented changes/redesign of a database. Redesign included the use of ‘disconnected’ record sets, extensive VBA, and an ‘off-the-shelf’ professional appearance allowing for concurrent use with no record locking.

oDB used for tracking Clinical Trial Management information for multiple products/protocols, enrollment, site contacts, key dates within study, investigators/contacts, and various other study-specific data. Produced line graphs for key information pertaining to enrollment.

oCombo box values regulated via user interface with security.

oDatabase lock-down conducted without use of built-in access security. Checked user network login against stored DB users. No back-end entry was allowed and only DB admin could unlock DB.

oCustomizable reporting allowed users to run saved reports, grouped by user and general report name.

oCustom error handling stored errors created by users in folder where DB was located for programmer’s use. Stored user, time/date, error(s) and error description (from Err object), the object and process that caused error, and any additional (optional variable) information added by programmer.

oPresented final product with individual training.

09/2002 – 04/2003 RMA Home Services, Inc San Diego, CA & Atlanta, GA

Access Programmer (Contract)

Modified old, and created new, VBA code to minimize overhead memory usage and performance degradation. Created/modified SQL 7.0 stored procedures for use in Access database pass-through queries. Created new objects within Access application for company use. Managed multiple projects with various deadlines. Mentored five programmers, new to Access, to help improve their development skills. Created ad hoc queries and reports for management in Access/SQL.

Worked remotely for the Director of IT on new and outstanding Access projects for the field and corporate office. Enhanced and created new parts of a complex Service Order program for use within the company. Created class modules for better utilization of code. Introduced Direct ODBC methods to programmers for using pass-through queries in SQL. Created/modified complex stored procedures in SQL 7.0 & 8.0. Extensive use of VBA modules and coding.

05/2002 - 08/2002 GA Dept of Natural Resources Atlanta, GA

Access Programmer (Contract)

Complete life cycle development included requirements gathering, coding/development, testing, and training.

Responsible for complete redesign of existing Access 2000 database for tracking information for the Georgia Department of Natural Resources, Real Estate Unit.

Duties included GUI interface design, conversion of old DB into new DB format (new tables, forms, reports, VBA code, etc.), complex VBA coding to accommodate various business processes, end user training and support. Created a custom report filtering interface where filters were saved and a menu was created showing filters by user and by report.

08/2001 - 10/2001 King & Spalding Atlanta, GA

Access Programmer (Contract)

Worked closely with attorneys, paralegals and legal assistants to analyze a large Access/SQL databases that tracked case-specific details for large class action suits.

Proposed solutions gathered from end user feedback, problem areas and necessary enhancements.

Redesigned/enhanced database used on a slow network, with multiple users, to increase speed and usability with extensive VBA and VB.

Utilized ADO/DAO, MAPI32.DLL, and other Windows DLLs for GUI interfaces.

Created ad hoc reports for professional presentations and use.

01/2000 - 05/2001 Telemate.net Software, Inc. Atlanta, GA

Lead Programmer

Completed upgrades of multi-million dollar Cable & Wire management software, called ‘Asset Manager’, used for data, voice and cable connectivity tracking (Access97 and VB6.0). Included e-mail functionality, registry editing/adding using the MAPI32.DLL, AdvAPI.DLL, and various other DLLs with the use of VBA coding.

Responsible for design and maintenance of over 35 relational tables, 200 queries (union, update, delete, and select), 50 reports of which users were able to create customized filters that could be saved and re-run via the report manager, 20 macros, and approximately 15 detailed and sophisticated modules (4 class level).

Created and implemented customizable labels for form and report viewing/printing.

Created custom error handling procedures that logged specific information about the error and allowed users to give a more detailed explanation of what they were doing when the error happened. This was put into report format that was emailed automatically to the support technicians.

Upgraded and maintained custom Import/Export OCX and DLL for use between Access and Visio applications.

Used third party tools (True DB Grid) to further enhance capabilities of VB product.

Upgraded product to interact with MS SQL database and C++ application via ODBC connectivity.

Created custom, form level, user based application security.

Enhanced training manual for customer classes; installed software and taught 4-5 day classes on use of product at customer sites; followed-up on customer satisfaction, problems, and questions.

Responsible for maintenance of previously designed InstallShield 6.2 for Access application installation.

Debugged C++ projects moving towards MFC development role.

08/1998 – 12/1999 Norrell Corp. Atlanta, GA

Programmer/Analyst

Created/maintained Access databases used in day-to-day business.

Created automation programs within Access VBA to gather data from corporate Oracle DB for reporting daily, weekly, monthly and year-to-date reports.

Worked with various branch offices to gather data for Ad-hoc reports.

Managed 2-3 employees (based on workloads) within a reports gathering/distribution group.

02/1997 – 06/1998 Reese Brothers, Inc. Pittsburgh, PA

Analyst

Learned MS Access 2.0 from my mentor and co-worker.

Created/maintained Access databases used in day-to-day telemarketing business.

In charge of gathering data for daily, weekly, monthly and year-to-date reports distributed to the director of the non-profit part of the company.

Worked with branch offices to gather data for Ad-hoc reports.

Created and maintained complex Excel files for each branch office, totaling 10 branches.

EDUCATION

04/2015 Western Governors University Salt Lake City, UT

Bachelor of Science – Information Technology

CERTIFICATIONS

Microsoft Certified Professional

Microsoft Technology Associate (Fundamentals):

Networking

Database

Software Development

Windows Server Administration

Windows Operating System

CompTIA:

A+

Security+

Network+

Project+

CIW:

Web Development Professional

Web Foundations Associate

Web Design Specialist

Database Design Specialist

JavaScript Specialist

Perl Specialist

Oracle:

Java SE 7 Programmer

Contact this candidate