SUMMARY

Certified Microsoft Office Specialist as of March 2015.21-year technical professional with expert PC skills, developing in Access/VBA for 14 years specializing in designing, maintaining and supporting Access, Excel and Visual Basic applications. Resourceful, inquisitive and creative extrovert with an entrepreneurial spirit focusing onlogical systems analysis, event-level programming, data modeling, problem solving, customer service, technical support and troubleshooting.Possesses a broad general IT and marketing background and a strong desire and aptitude for learning new technologies.

Areas of Expertise / Relevant Experience

• Visual Basic for Applications Access, Excel, Word and Outlook
• VB.Net, Visual Studio 2010
• VBScript
• Instruction / Training
• Technical Writing
• Systems Analysis
• Database Administration and Development Access/SQL Front and Back End
• Data Modeling
• Graphic Design

Technical Proficiencies

• Platforms: Windows XP, Vista, 7 , OSX
• Networking: Basic Wired and Wireless LAN Administration, TCP/IP, SMTP, IMAP, POP3
• Languages: Visual Basic/VBA, VBScript, JavaScript, ASP, SQL, HTML
• Tools: MS Visual Studio, MS Visual Web Developer, MS Office MS Access, Excel, Word and PowerPoint , Microsoft SQL Server, Outlook, Adobe CS primarily Photoshop, InDesign and Illustrator

Professional Experience

Developer / Programmer Analyst

Confidential

Assisted with conversion of 10 accounting databases to updated technology. Original developer created and maintained database for over 10 years, and was no longer available as a resource, so the job requiredextensive reverse engineering and mystery-solving. Position also required the development of new ad-hoc applications to store, verify, reconcile and convert daily and monthly data feeds from other business units worldwide. Developed custom Access database applications use to reconcile monthly and annual stock reports and sub-ledgers, and automate UAT feeds. Created automated, custom Excel reports, with multiple tabs and pivot tables.

Confidential

Developed, tested and implemented custom Access database application used for tracking and scraping incoming and outgoing client support emails via Outlook VBA for 40 users. Application contains 30 tables all normalized , 30 forms and 70 queries, 15,000 lines of VBA code, and 200 custom procedures and functions. Advanced automated reporting based on user role and department via Excel VBA and pivot tables. Access front end attached to combination of SQL Server and Access back end. Version control automated via login procedures. Files stored with individual inquiry records using ADODB stream objects and DSN-less table connections. Used Regular Expressions to validate password requirements and search for specific patterns within email subjects and bodies unique ID numbers, email addresses to automate significant data collection. Created custom Outlook form for outgoing messages with VBScript to ensure proper tracking and storage of outgoing messages, independent of Outlook's built-in archiving capabilities. Automated daily report running and Outlook maintenance. Created context-sensitive error handling procedures to speed code maintenance. Developed custom live-backup procedure to save the production database every 30 minutes. Created user manual, quick start guide and job aid for training, as well as facilitated one-on-one and group training.

Confidential

Developed custom application Access front and back end designed to compare and reconcile multiple mainframe data extracts 150K records with 90 columns from BNY-Mellon and BlackRock. Also updated an existing application used to report BNYM's Straight-Through-Processing statistics to BlackRock. Reports were created and formatted using direct data export and Excel VBA.

Confidential

Custom application development for Takara Belmont in Somerset, NJ. Full Database Life Cycle inventory control, production scheduling and import tracking modules. 100,000 records formerly stored in Excel spreadsheets conversion to normalized Access tables, and creation of a custom GUI. Extensive VBA code developed for data manipulation and automation.

Confidential

VBA development of robust proprietary Excel spreadsheets for automated sales reporting, and ROI analysis of marketing programs. Secondary duties include troubleshooting network connectivity problems, software, hardware and printer installation and upgrades, as well as extensive ad-hoc graphic design work and marketing programs.

Confidential

VBA development and maintenance ofproprietary automated Access databases and Excel spreadsheets for financial and metric analysis using SQL and custom functions. Duties also informally included general IT support across both restaurants, including admin, installation and training on the POS system, hardware and software upgrades and peripheral installations.

Confidential

Continuing Education Instructor: Productivity Applications - Designed, implemented and instructed 10-week lesson plans for beginning, intermediate and advanced levels of Word, Excel, Access and Internet usage. Classes varied in size from five to twenty students, with a wide variety of technical competence and professional backgrounds.