SUMMARY OF QUALIFICATIONS

• Dynamic, ambitious, vibrant, and committed ingenious software consultant:
• Strong analytical, communication, organizational, reporting, and problem solving skills
• Full life cycle development and many aspects of support, including design, analysis, data modeling, coding, testing, debugging, implementing enhancements, tracking multiple product versions, beta and production creation, documentation, and client support
• Extensive professional software engineering experience in a professional work environment
• Proficient in 16- and 32-bit API routines, GUI development, object-oriented programming, multi-threaded design, multi-tasking environments, network topology, mainframe, and Intranet/Internet communications
• Programmed and designed many types of customized databases and spreadsheets frequently including reports with usage of tables, queries, forms, modules, relationships, formulas, functions, subtotals, outlining, summarization, grand totals, and Pivot Table reports and many types of graphs and presentations
• Database analysis, management, reporting, and support for survey statistical reporting using Microsoft Access
• Strong skills and knowledge of several programming languages, flat-file and relational databases, client/server applications, and operating system internals
• Able to anticipate and resolve client challenges quickly and efficiently
• Collaborative, flexible, passionate and personally committed to getting the job done regardless of obstacles
• Fluent in many popular languages including HTML, XHTML, DHTML, PHP, XML, JavaScript, AJAX, VBScript, BASIC, C/C /C , SQL, Visual Basic, VBA, PowerBuilder, and AS/SET CASE tools
• InstallShield, Wise, WiX, and Windows Installer technology experience
• Proficient in the entire Microsoft Office Suite 97-2013 and a certified Microsoft Office Specialist MOS in Word, Excel, Access, and PowerPoint
• Extensive experience and expert computer literacy with computers, electronics, Internet, networking, servers, documents, spreadsheets, presentations, reports, word-processing, databases, ActiveX and DOM, TCP/IP, UDP, sockets and real-time streaming data feeds.

EXPERIENCE

Confidential

Web Developer Search Engine Optimization Specialist/VBA Specialist,

• Responsibilities include developing and maintaining professional web-site, computer service and technical support, Search Engine Optimization, PPC Management, and social networking management.
• Web-Site Development and Enhancements of 700 page web-site
• Migrated 700 page web-site to WordPress
• Service and repair computers and provide technical support
• Implemented XML Meta Tags for Search Engine Optimization
• Managed Google AdWords, AdSense, Webmaster Tools, and Analytics campaigns
• Windows, Office, E-Mail, Photoshop, and general computer training and troubleshooting
• Produce in-depth progress and statistical reports for web-site keyword performance
• Manage SEO link-building campaigns and social networking applications.
• Created macro in Excel to read and update HTML web-pages and index them nicely into worksheets
• Created macro in PowerPoint to insert downloaded pictures into presentations
• Created macro in Outlook to export contacts to Constant Contact

Confidential

Senior Visual Basic and REALbasic Software Consultant,

• Responsibilities included working closely with owners, developers, principals, teachers, network administrators, and students to develop and maintain multiple educational products for schools in Northwest Indiana for use in schools and homes. My primary role was as Senior Software Engineer. I provided programming and troubleshooting services and was involved in developing product concepts and programming design and coding, planned the features for each release, maintained a list of changes per release, maintained a defect report, managed the development staging in production and distribution software environments, and created implementation schedules for each product release.
• Used Visual Basic 6.0 and REALbasic to update, debug, and test Windows and Apple application software for spelling and scheduling special classes in schools
• Integrated Visual Basic for Applications and Microsoft Office with REALbasic applications using Office automation and shelling
• Generated Microsoft Excel Workbooks using Visual Basic and Microsoft's Component Object Model
• Utilized Microsoft Word in REALbasic for spell checking using Office Automation
• Implemented ActiveX controls such as the Microsoft Flex Grid, WebBrowser, and Forms 2.0, and Brew City Software's ubGridX and CoolButton
• Composed several GUI form wizards and help modules using HTML and Microsoft Office Document Object Model
• Implemented speech technology that reads words and phrases to students and personally proofed and recorded spelling words
• Created a Microsoft Access database to track customers and VBA procedures to code and decode serial numbers using encryption
• Created Wise for Windows Installer Professional Edition 5.21 installation packages for application and repository distribution
• Produced WSI, MSI, and EXE for complex local and network installations including the use of merge modules and custom actions that launch applications
• Utilized registry, shortcut, and file association features and third-party ActiveX control inclusion
• Handled many different support issues for the installer packages on different platforms including Windows 95, 98, Me, 2000, NT, Novell, XP, Windows Server 2003, and iMac
• Utilized technical support and researched issues in forums and network user groups to solve issues with core programming IDE and compiler issues
• Using CrossLoop technology, I provided remote assistance to troubleshoot problems
• Assisted in resolving computer and networking problems on PCs and Macs
• Provided technical support via e-mail, telephone, and on-site client support.

Confidential

Microsoft Access 2007 VBA Consultant,

Designed and implement four new Access databases that included design, relationships, tables, fields, keys, linking tables, queries, macros, and forms for energy usage and conservation surveys in different markets

Established the needs of users and monitored user access and security

Considered both 'back end' organization of data and 'front end' accessibility for end users

Performed data modeling and optimization of the database layout to take the most advantage of the I/O subsystem

Implemented database schemas, and wrote complex SQL queries for subform manipulation utilizing VBA

Proactively monitored systems for optimum performance and capacity constraints.

Confidential

Microsoft Office/Sybase PowerBuilder Consultant,

Analyzed and assisted troubleshooting document corruption in Microsoft Word for APlus insurance application written in PowerBuilder 10.2.1 and utilized Sybase ASE 12 for foundation database

Worked closely with developers in Burbank, California to decipher root causes for document corruption and PDF creation failure

Worked with local claim representatives to identify trouble issues and help to resolve and troubleshoot and act as a liaison between the end-users and the development and management teams

Created documented suggestions for resolving numerous issues related to Office integration using Sybase and PowerBuilder

Located and identified PowerBuilder code deficiencies and researched and provided specific coding solutions to rectify Office OLE automation issues

Helped develop and test changes to the Word Master document template normal.dot

Created VBA code that would identify attributes of Word files that assisted in identifying problem properties with certain Word documents

Created VB Script to change Word application options during login script.

Confidential

Microsoft Excel 2007 VBA Consultant, November 2007 - December 2007

Developed Microsoft Excel macros for transferring worksheet data into Microsoft Word documents

Utilized Visual Basic for Applications to build macros to convert Excel insurance proposal pricing worksheets into Word documents using Office 2007

Using Visual Basic for Applications, I created complex Word tables and merged Excel data with Word templates to created insurance proposal letters.

Confidential

Microsoft Access VBA Consultant,

Utilized Visual Basic for Applications to build an Access database to track survey training questionnaires

Created table fields and data model and created validation rules for various data entry forms

Created supporting queries for forms and Visual Basic for Applications foundation code

Generated Excel workbooks from Access using Visual Basic for Applications to report on data using grouping and subtotals

Created report search criteria form to filter results by different categories.

Confidential

Microsoft Excel VBA Consultant,

Utilized Visual Basic for Applications to build a preprocessor and report generator for corporate human resource surveys

Processed incoming survey submissions to rebuild workbooks based on templates by reorganizing columns and worksheets

Created validation to report on insufficient and invalid data submissions

Eliminated bad references, blank rows, and fixed corrupted column headings from Excel template submittals

Created status worksheet from ACT and CM2K databases combined with preprocessor results

Generated reports, charts and graphs representing current status vs. goals and previous year's results.

Confidential

Contract Administrator Support Assistant,

Evaluation, maintenance, and report generation of agreement contracts, statements of work, and invoices using Corprasoft Legal Desktop

Created and maintained Excel workbooks for audit trails and quarterly and yearly reporting

Created and maintained Visio diagrams of work flow processes for Corporate Finance

Faxed and processed e-mail requests.

Confidential

Microsoft Excel VBA Consultant, J

Utilized Microsoft Excel to create various multi-national status, pipeline, and market penetration PivotTable reports using Visual Basic for Applications

Utilized Microsoft Access to compare various datasets

Created supporting documentation for Visual Basic for Application modules using Paint.NET, Word, PowerPoint, and ScreenHunter

Created training videos using CamStudio and Camtasia Studio

Created macros for data entry using AutoHotkey

Managed documents using Microsoft SharePoint Services

Provided technical assistance in analyzing, creating, and modifying Excel reports.

Confidential

Microsoft Project Specialist, J

Responsibilities included the setup and maintenance of schedule and cost management for a commercial development project of condominiums using Microsoft Project Professional 2003

Performed task information setup and maintenance including outlining, linking, and dependencies

Reconciled Excel budget items to task items and setup cost and payment tracking information

Utilized Visual Basic for Applications to created pop-up window alerts for tasks that were behind schedule or over budget

Customized Microsoft Project to track change order information and adjust cost and schedule line items accordingly

Generated built-in and customized reports and used Visual Basic for Applications to create Microsoft Excel reports

Managed project collaboration between employees using Windows Server 2003

Directed training to employees and wrote in-depth documentation using Microsoft Word.

Confidential

Operations Manager/Access VBA Specialist, June 2002 - February 2003

Responsibilities included assisting the owners in running day-to-day operations, supervising warehouse operations, placing and receiving orders, customer service, greeting visitors, sorting and delivering mail, check, invoice and bill processing using QuickBooks. Provided assistance creating and maintaining numerous Microsoft Word documents, Excel workbooks and Access databases. Programmed MS Access database with SQL queries. Was also responsible for installing, customizing, maintaining, and updating a Microsoft Access application called Business Professional Edition, which is an accounting software package, and creating and maintaining customized Excel workbooks to track inventory for M M Mars utilizing Visual Basic for Applications, network troubleshooting, upgrading, and maintaining Windows 2000 Server. Successfully negotiated a new phone contract with SBC that saved thousands of dollars in phone expenses on an annual basis.

Confidential

Database Development and Support,

Responsibilities included database analysis, management, and support for survey statistical reporting using Microsoft Access. Utilized the Structured Query Language to retrieve data from an Oracle mainframe database through the Windows NT operating system. Used this information to create mailing and phone lists for survey execution, demographic, statistical, crosstab, and pivot table reports for clients from raw survey questionnaire data. Created customized databases and programmed form and report modules using Visual Basic for Applications to track surveyed panelists, manage database problems, generate reports, survey statistical reporting, and quality control.

Confidential

Database Development and Support,

Primary role was to assist in the design, setup, and maintenance of a Microsoft Access database to keeping track of and report on information about Amgen's EPOGEN Epoetin alfa which is a recombinant version of a human protein that stimulates the production of red blood cells and is used in the treatment of anemia associated with chronic renal failure for patients on dialysis. Was responsible for the setup and maintenance of a relational database that included creating and updating tables, relationships, queries, forms, and customized reports using Visual Basic for Applications to generate reports for clients in an Excel format. Additionally, conducted research, helped produce final research reports, provided training for employees, and client support.

Confidential

Office Assistant,

Responsibilities included typing meeting minutes and business recovery plans, tape transcription, creating Excel spreadsheets for weekly and quarterly reports using the information from Quota Server reports, modifying presentations, entering and balancing company ledgers, creating electronic forms/labels, and updating personnel profiles and business continuity plans using Comdisco's ComPAS software.

Confidential

Software Engineer,

My responsibilities included new development, maintenance, and testing of multiple versions of AS/SET IWS, a case tool developed for use on the IBM-PC OS/2 platform. Worked with Microsoft and IBM 16- and 32-bit C/C compilers to develop and maintain multiple versions of this highly complex application. The Intelligent Work Station IWS software worked in synchronization with the AS/SET Application Development Kernel ADK on the IBM AS/400 to generate AS/400 RPG applications. Provided client support and acted as a liaison between the software engineering, help-line, testing, quality control, and documentation departments.

Confidential

Software Engineer,

My responsibilities included developing, implementing, debugging, supporting, and testing educational software for the IBM-PC using Borland's Turbo C/C and Assembly language compilers, and Microsoft's Professional Development System. I worked directly with the owner providing support of this product that consisted of electronic documentation, a database, a tutorial, and terminate-stay-resident reminder software.