Ian H. Fletcher

adxzxy@r.postjobfree.com • 415-***-****

San Francisco, CA 94123 • linkedin.com/in/ian-fletcher-413a3b171

professional profile

Microsoft Access, Excel, VB, VBA, .NET, WinForms, SQL, Azure, and AWS developer for clients in high technology, financial services, real estate, manufacturing, logistics, government, and other industries.

Development, data integration, system migration, testing, implementation, and documentation of custom software for sales reporting, operational forecasting, event calendaring, quality control, logistics, and file cataloguing. Software design life cycle (SDLC) from requirements gathering and functional specification to programming and user acceptance testing (UAT). Creation of custom add-ins and DLLs for Access, Excel, and other apps for extending functionality and integration with other software and web applications. Published technical author and technical writer. Experienced in financial mathematics and accounting.

Core Competencies

Solutions Design & Engineering

Software Development Lifecycle

Process Improvement

User Acceptance Testing

Business Requirements Analysis

Project Management

Data Management & Analytics

BI Reporting Tools Creation

Database Administration (SQL/Oracle)

System Integration & Validation

Cross-Functional Collaboration

Team Leadership

Data Reporting & Analytics

Customer Coordination

Stakeholder Management

Professional Experience

Help4Access, San Francisco, CA Jan 2015 – Present

Senior VB, VBA & SQL Application Developer

Designing, developing, and managing technical solutions to business needs of multiple clients. Managing multiple contributors of diverse teams. Architecting custom business solutions for nationwide clients with MS Access, Excel, VBA, VB, C#, .NET, WinForms, & SQL, including:

●Major Regional Real Estate Firm Developed major enhancements for main line-of-business software system with 200 users accessed via MS Remote Desktop and mobile app. Access & WinForms front end and SQL back-end had with six independent desktop applications and four SQL databases with 30MB of data. Built.NET DLLs in Visual Studio to programmatically edit PDFs and to interface with DocuSign.com using VB, C# & WinForms. Administered SQL Server on Azure.

●Nationwide Medical Monitoring Company Developed major upgrades for real-time medical monitoring system with Access front end, SQL back-end, and 10MB of data. Interfaced with large team of in-house programmers. Tested system to life-or-death medical standard. Visualized operational effectiveness KPIs in Tableau.

●Medical Device Manufacturer Developed major upgrades for management information system with Access front end, SQL back-end, and 25MB of data. Traveled to client offices to gather requirements and teach use of system.

●Supermarket Chain Executed survey of Access database on Fortune 500 company’s entire network with proprietary self-developed Excel-based tool developed for cataloging 100,000+ subdirectories. Reported results in Tableau.

●Regional Construction Firm Developed major upgrades for Access / SQL management information system for construction firm.

●Technical Recruiting Company Developed major upgrades for Access / Excel management information system.

●Regional Transportation Authority Developed Access / SQL contact and calendar management system.

Google, Mountain View, CA Feb 2015 – Apr 2015

Big Data Analyst

Analyzed, interpreted, and translated enterprise data into meaningful information to drive business analytics. Constructed SQL database of every apartment building in the U.S. and loaded data for big-data analysis.

●Supported Google Fiber’s nationwide network expansion while analyzing data in Excel, Google Sheets, Google PLX, R, Teradata, and MS Access.

CardioDx, Redwood City, CA Dec 2014 – Jan 2015

Business Intelligence Developer

Empowered business decision-making by creating systems used to automatically collect, analyze, and report business intelligence data. Provided an overview of ongoing sales and marketing activities to senior leadership by devising BI tools.

●Revamped and enhanced firm-wide sales reporting system built in Excel, Access, SAS, MySQL, and VBA.

Stonecrop Technologies, Petaluma, CA Mar 2014 – Nov 2014

MS Access, VBA & SQL Application Developer

Produced high quality, maintainable, and test-driven software programs. Carried out analysis to identify and remove programming errors to improve effectiveness of end product. Analyzed and interpreted business requirements, created technical specifications, and leveraged advanced technologies to build fully testable programs.

●Created operational forecasting system and other apps for cellular network logistics company by leveraging Access, Excel, VBA, MS SQL Server, T-SQL, PL/SQL, AWS, and Azure. Administered SQL Server on Azure and AWS.

Additional Experience

Programmer ShoppingScout/Engage3 Sep 2013 – Dec 2013

Programmer/DBA Datautomation Jun 2013 – Sep 2013

Programmer/DBA Cygnusoft Feb 2013 – Jun 2013

Programmer Barclay’s Global Investors Sep 2010 – Feb 2013

Prog./Proj. Mgr. JP Morgan Chase Jun 2004 – Aug 2010

Programmer OMD Worldwide Jan 2004 – Mar 2004

Programmer Columbia Bus. School Jul 2003 – Jan 2004

Programmer JP Morgan Chase Apr 2003 – Jul 2003

Education & Credentials

Bachelor of Arts, Cum Laude, Philosophy University of Chicago

Microsoft: Certified Solutions Expert, Data Management & Analytics.

Microsoft: Programming in HTML5, JavaScript, and CSS3

Oracle: Database 11g: SQL Fundamentals I

SEC Series 7 Stockbroker’s License

Microsoft: Azure Data Fundamentals

Microsoft: Programming in C#

Technical Proficiencies

Databases:

MS Access to 2021, MS SQL Server to 2022; Oracle SQL Server to 19c, Sybase, IBM DB2, MySQL to 8.0, PostgreSQL to 13.10, SQLite to 3.4, T-SQL, PL/SQL

Development Tools:

MS Visual Studio, MS Project, AllFusion ERwin Data Modeler, SourceForge, Subversion, TortoiseSVN, UML, Embarcadero RapidSQL

Administration Tools:

Active Directory, LDAP, LDIFDE, CSVDE, MS Management Console, SMS

Reporting Tools:

Crystal Reports to 8.5, Crystal Enterprise, Crystal Decisions, Business Objects, Salesforce, Tableau, SAS Data Integration Studio, Power BI

DLLs:

VB & C# DLLs on Visual Studio.

Collaboration Tools:

NetMeeting, Zoom, GoToMeeting, Slack, MS Teams

Operating Systems:

DOS, Windows 2000, ME, XP, XP Pro, Linux

Virtualization Tools:

Oracle VM VirtualBox, Citrix, Amazon Workspaces, Azure Virtual Desktop

Programming Languages:

Visual Basic (VB), Visual Basic for Applications (VBA): Access VBA, Excel VBA, Word VBA, Outlook VBA, VB.Net, VBScript, LotusScript, C#, PowerShell

Programming Technologies:

VB .NET, Windows Forms, DAO, ADO, COM, DCOM, ASP, DLLs, Windows registry, type libraries, ActiveX, OCX, component services, n-tier applications, component services, SOAP, metadata, class libraries, XML, DynamicPDF

Workflow Systems:

Lotus Notes to 4.1, Remedy Action Request System

Big Data:

HortonWorks Sandbox, Hive, Pig, Grunt, Oozie, Beeswax, HCatalog

External Integrations:

DocuSign, Chilkat, DynamicPDF, Google Maps

Financial Tools:

Bloomberg, Reuters, Excel, FastExcel, Tiblink

US & UK Citizen Fluent in English Client References on Request

Contact this candidate