Application Developer

21-year technical professional with expert PC skills, developing in Access/VBA for 14 years specializing in designing, maintaining and supporting Access and Visual Basic applications. Resourceful, inquisitive and creative extrovert with an entrepreneurial spirit focusing on logical 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, 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 Contractor

Assisting clients with database design and development, including data modeling, table creation and normalization, VBA coding, systems analysis, process automation, query design and interface creation form and report development . Projects include working with exacting and difficult requests for improved features beyond the built-in functionality, report modifications, data integrity maintenance, Q/A testing and application-wide consistency.

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 required extensive 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.

Splash Zone Water Park 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.

Frog Spring Corporation Cabanas / Confidential

VBA development and maintenance of proprietary 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.

Confidential

Analyst / Help Desk Agent - Level One support agent for SunGard recovery software users. Problems ran the gamut from very basic Is your PC plugged in to high-level integration and customization. Extensive documentation of problem tickets was used for the purposes of sharing among other agents and creating a knowledge base.

Confidential

Systems Analyst / Trainer / Implementation Specialist - Prepared custom installations of HayXpert software, as well as provided all levels of technical support to end users. Duties included analyzing customer data and incorporating it into the software with customer-requested customizations. Position also included on-site installation and training.

Confidential

Lead Access Front End Developer / DBA - Front End Access Developer for an Oracle Database. Extensive use of VBA, Visual Basic, Access, Excel and Crystal Reports.

Confidential

Systems Analyst / Technical Writer - Assisted in development for call-center software used by the National Highway Traffic Safety Administration. Created hard copy documentation as well as online context sensitive help files for call center employees.