C# Front End

Ian H. Fletcher ************@*****.*** 415-***-**** 1990 Green St. #302

San Francisco, CA 94123 •linkedin.com/in/ian-fletcher-413a3b171 Experienced Desktop Developer Specializing in Modern Enterprise Solutions Technologies

SQL queries

SQL stored procedures

SQL DBA

Oracle

MS Access programming

Excel programming

Visual Basic for Applications (VBA)

Visual Basic (VB)

C-Sharp (C#)

Visual Studio

.NET Framework

.NET Core

DLL writing in VB (VB6-VB16) & C#

WinForms

Azure databases

Windows 11

GScript

Financial mathematics

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

Technical writing

Professional Experience (For work samples, please click here:) Help4Access, San Francisco, CA Jan 2015 – Present

Senior Access, SQL, VBA, & VB Developer (click here for profile on company site) 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, and PowerApps, 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 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. Developed PowerApps version of desktop app with SQL Server back end. 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.

● Internal Corporate Use Developed tools using PowerApps and PowerAutomate to manage CRM needs of firm. 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. Ian H. Fletcher Page 2

● 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 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, SSMS, SSIS ETL, Abinito, Dataverse

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, PowerApps Collaboration Tools: NetMeeting, Zoom, GoToMeeting, Slack, MS Teams, Agile, Scrum 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, Common Data Models No-Code Systems: Power Apps, PowerAutomate, PowerBI, PowerPlatform 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 References on Request

Contact this candidate