SUMMARY:

• Program management and design of business solutions encompassing data management and reporting ranging in the specialties of eCommerce and Internet Portals, Finance, Government and Law, Marketing, Sales, Customer Service and Call Centers, CRM, RDBMS design, Product Development, Legal, Finance, Confidential, B2C, Data Acquisition, Data Analysis, Retail, Healthcare, Imaging Solutions, and Manufacturing.
• 17 years of experience improving and fully automating business processes utilizing Microsoft Office products (Excel, Access, Word, Outlook, PowerPoint, SharePoint) and MS SQL through advanced VBA programing of expert systems. Adroit integrator of non - Microsoft Products (Acrobat, BI Data, AS/400, Avaya Telephony Analytics, Google Analytics, AppleScript, Windows Shell, Oracle) for finished reports, data acquisition and warehousing, information dashboards, data analytics and corporate finance accounting.
• With a background in Presentation Graphics and the Arts, I merge data and technology to produce visually compelling, intuitive and informative systems that simplify complex data and processes with a focus on Project Management, Innovation, Communication, Customer Service, Relationships, and Team Building.

EMPLOYMENT HISTORY:

Confidential, Dedham, MA

Senior Application Developer

Responsibilities:

• Developed project plans and workflow documents for the automation of the monthly loading with a QC pre-check of over 300 Vendor data extracts. Now in software development
• Authored VBA audit program in Excel and Access for 3 data analytic QlikView applications utilizing Microsoft Active Directory security groups, user logs and Executive approval records for improved protection of PMI with full reporting. Responsible for supporting executive management and end-users while coordinating with IT support groups
• Authored automated VBA data extract delivery system for outside vendors from data sources embedded in Outlook emails by automatically scanning Inboxes, pulling appropriate data reports and converting through an ETL process
• Numerous security concerns were identified and solved with proactive design preventing future issues
• Responsible for daily and monthly manual data loading processes while designing automated solutions
• Author of Process Documentation, User and Administration guides
• Introduced an ODBC solution that automated SalesForce data table pulls for extracts and warehousing

Confidential, Cumberland, RI

Senior Application Developer

Responsibilities:

• Investigated and developed project plan for the upgrade of over 30 Access applications from version 2000 to 2010
• Authored VBA reporting application delivering automated dashboard reporting of OTS financial application
• Documented reverse engineering and initiated improvements of 5 Access financial applications
• SQL optimization yielded 50%-400% process time improvements
• Created automated security and upgrade VBS applets for existing manual processes including ETL
• Documented upgrade path from Access RDBS to SQL Mainframe applications
• Rapidly authored a financial accounting application in Access that queried 50 million plus records for General Ledger accounting and program audit. Porting the application to Oracle utilizing multiple Access front end applications for customized end user needs while managing the transition to the CVS IT DBA organization

Confidential, Boston, MA

Digital Project Manager, Application Developer

Responsibilities:

• Corporate savings in FTE reductions amounted to hundreds of thousands of dollars on an annual basis
• Rapid deployment of the VBA solution allowed the first running version to be introduced in weeks
• Created a versatile logic engine that was flexible for serving 7 unique state needs
• Produced thousands of dynamic and unique User Health Plan filings
• Designed a modular approach that allowed improvements and annual flexibility requiring minimal support while negating the need for VBA programming when document changes occurred
• Project achievements recognized by the CEO of UHG with the following commendation by the initial program state describing the state product change process:
• “This task would have taken 30-55 hours and now took less than a half hour. There were 112 Schedules built in 27 minutes.”
• Added an previously undefined automated dashboard report delivered by email documenting the processed filings

Confidential, Boston, MA

VP Operations, MS Office Application Developer

Responsibilities:

• Competitive BI research focusing on successes, strengths and weaknesses in relation to Confidential national and local strategic and tactical response: Uber, Lyft, Hailo, Yellowcab,Taxi Magic
• Feature, usability, and UI design consultation with offshore application developers
• Confidential and customer RDBMS design for data analysis and reporting deliverables through application and portal
• MS Office VBA application development for automation of all company business functions

Confidential, Quincy, MA

Data Manager, VBA Developer

Responsibilities:

• Developed and managed statistical reporting for client websites utilizing Google Analytics and supported Program Managers
• Multi layered Dashboard design for information and statistical analysis
• Documented proposed, new, and revised features as technical, user, and marketing feature guides
• Automated daily, weekly, and monthly reporting allowing staff requirements to be cut in half
• Instituted self-audit and regression testing into the programing cycle, increasing vitality of data collected and reported, while identifying past discrepancies in previous call center reporting and external provider data
• Rapidly instituted new automated programs as custom client needs dictated as automated expert systems with attention to workflow efficiency with user time reduction, and integration across business areas

Confidential, Boston, MA

Group Sales Manager/Systems Automation

Responsibilities:

• EAGLE, an automated Excel application Dashboard utilizing advanced VBA code, allowed sortable views of all available data found within various internal sources on specialty cruise packages by client criteria as an aid to the sales process.
• Increased Inbound CSR knowledge and throughput while reducing training needs, call times, with increased customer satisfaction by better equipping CSRs with a single page of quickly transformable information that linked to detailed cruise package as the conversation progressed
• Automated Outbound Sales functions for Outlook email correspondence with pertinent brochure delivery pulled from AS/400 database screen information with Eagle customer cruise results utilizing Windows Shell routines, AS/400 scripting and Excel VBA through push button triggers complete with data logging of daily activity
• Rapidly prototyped a call center administration attendance record application with HR process compliance utilizing Excel VBA with planned porting to Access RDBMS for multiple users and employee reporting

Confidential, Franklin, MA

President, Lead Programmer

Responsibilities:

• Administered Unix website server and security, SQL server database, and PHP forum software
• Pioneered election forums giving local candidates free exposure and direct 24/7 communication with voters
• Negotiated a precedent setting definition of “Fair Use” copyright law with a major news media organization that allowed increased content when faced with threat of lawsuit. A dedicated win/win problem solver.
• Developed proprietary code using MySql, PHP, and HTML for custom dynamic pages based on member city locations within vBulletin forum software framework pulling from various news feeds and city forums
• Authored reports and blog entries that reviewed local services in relation to interpreting municipal law for citizens and officials to make the vague and complex understandable
• Published report on municipal trash in Franklin that resulted in a substantial reduction to the residential cost structure without compromising features as well as changing methods of city budgetary finance

Confidential, Franklin, MA

President, Lead Programmer

Responsibilities:

• Authored proprietary routines integrating MacOS and Windows using AppleScript, Excel VBA, and Photoshop actions to automate the entire process of imaging and graphics production, increasing quality, decreasing turn-around, reducing personnel needs, integrating file audit management, and secure FTP upload. This placed the company in the forefront of competitors who unsuccessfully tried to reverse engineer our processes and match our quality or price
• Managed legal team that successfully defended company against delinquent major client in Federal Court setting copyright precedent in law journals as it relates to bankruptcy. This case has been later cited numerous times
• Developed and authored an AppleScript forensic HTTP image search engine in less than a day that ran on 4 iMacs, reading a centralized Excel database for file criteria, copying found results into a new Excel database complete with retrieved image files, URL location, and file name with date. This resulted in 100% payment as accepted and ordered by the Federal Court

Confidential, Franklin, MA

Owner,Technologist

Responsibilities:

• Proprietary low-fat food product line, prototyped and tested at consumer research level
• Virtual Reality Gaming utilizing custom networked 3D workstations, headsets, and the Unreal gaming engine
• Digital Storage for consumer and business Vertical Markets utilizing physical Confidential product placement
• Digital Imaging and Graphics for E-Commerce Domains utilizing systems automation (See Confidential )
• Community Forums (See Confidential )