Andrew B. Brown

Summary

· Over 8 years experience in developing windows applications, web applications, windows services, n-tier business logic, reporting, and database architecture using C#, VB.NET, and SQL Server.

· Full SDLC: business analysis, design, development & testing, and support.

· Led teams of 3-5 people at StaffSoft, RealLegal, and Maricopa County.

· Worked in mortgage wholesaling, accounting, procurement, inventory, recruiting, legal, construction lending, finance, real estate, and healthcare.

Technical

Languages: C#, VB.NET, VB6, Foxpro

Databases: SQL Server (2000, 2005, 2008), Access, Foxpro

OS: Windows NT/2000/XP/Vista/2007

Software: C#, ASP.NET, AJAX, DCOM, VB.NET, COM, MTS, Win API, IIS,

DTS/SSIS, Visual Studio

Scripting: VBScript, VBA, Javascript, HTML, CSS

Source Ctrl: Source Safe, Team Foundation Server

Reporting: Crystal Reports, R&R Report writer

Certifications

Microsoft Certified Professional (MCP) Jun 2003

Visual Basic & SQL Server Design

SEC Series 7, 55, 63 (financial and securities licenses) Jan 2002

Employment

Principal Consultant (Wealth Management) 2013

Morgan Stanley (Genpact), NY, New York

· Designed the architecture and security for their mobile application framework

· Developed an identity-theft prevention system called Fingerprint Touch.

· Determined company purchases to meet talent resourcing requirements.

C#, .NET Web API, MVC, JQuery Mobile, SQL Server, ASP.NET, HTML5, CSS3

Software Consultant (Employee benefits) Apr 2012 – Aug 2012

Hodges-Mace, Atlanta, Georgia

Project: Rewrite an existing call-center application for employee benefits.

· Architected a business logical layer between the database and UI.

· Rewrote all stored procedures, business layer, and pages.

· No technical support calls when the application went live.

Technologies: C#, ASP.NET, SQL Server, AJAX, Javascript, HTML, CSS

Software Developer (Automobile sales analytics) Feb 2012 – Apr 2012

Princeton Information, Plant City, Florida

Project: Maintenance and development of existing auto dealership software.

· Created BI dashboards for management and salespeople providing real-time customer, inventory, data integrity, and sales leads.

· Wrote data-mining stored procedures for analytics.

· Designed a bridge to merge a business logic layer into existing Linq code.

Technologies: SQL Server, C#, ASP.NET, Javascript, AJAX, HTML, CSS

Self-employed Architect and Developer (Data-access layer) Mar 2011 – Jan 2012

Project: Create a data-access layer to work with any application (new or existing).

· Maps any stored procedure to any object and back with one line of code.

(Single objects use a PersistableAttribute. Lists inherit from PersistentList.)

· Created a code-generator for stored procedures and C# classes.

· Improved security while outperforming existing ORMs by over 50%.

· For more info, see http://andrewbbrown.com

Technologies: C#, SQL Server, Winforms

Self-employed Architect and Developer (Shareware) July 2009 – Jan 2011

Project: Create an application to secure and hide a user’s desktop and profile.

· Wrote a P/Invoke wrapper for nearly every Windows API in VB.NET.

· Integrated Winforms and keystrokes with the Windows Login screen.

· Locked down Access Control List (ACL) for registry and files.

· No technical support issues in over two years.

· For more info, see http://hiddendesktop.com

Technologies: C#, VB.NET, Win API, ASP.NET, Winforms

Lead ASP.NET Developer (Construction lending) Jan 2007 – June 2009

AccuDraw, Phoenix, Arizona

Project: Create a web application to monitor construction loan disbursements.

· Silverlight for GUI elements and uploading multiple files.

· Created interfaces for import/export to Excel and Word.

· Created web services for desktop application data synchronization.

Technologies: C#, ASP.NET, SQL Server, Web Services, Silverlight, HTML, CSS

Lead Programmer/Analyst (Healthcare/Medical claims) Sep 2004 – Dec 2006

Maricopa County Managed Care Systems, Phoenix, Arizona

Project: Manage healthcare claims software, vendor interfaces, and reporting.

· Led a team of 3-5 developers in migrating and interfacing to Facets.

· Performed as DBA managing 6 databases comprising the data warehouse.

· Developed over 130 operational reports within 3 months.

· Created BI dashboards for management views into claims processing.

Technologies: SQL Server, Crystal Reports, C#, VB6, ASP.NET, Winforms

Consultant/Liaison (Logistics and Shipping) Jun 2003 – Jul 2004

DHL/Alliance Consulting, Toronto, Canada

Project: Migrate all applications from Toronto into DHL’s datacenter in Phoenix.

· Served as liaison between DHL headquarters and a new acquisition.

Technologies: VB6, ASP, IIS, C#, .NET, SQL Server, AS/400

Proprietary Trader (Finance and Trading) Jan 2002 – May 2003

Worldco, San Francisco, California

Software Engineer (Legal) Oct 2000 – Jan 2002

Law.com/RealLegal, Inc., Denver, Colorado.

Project: Create an e-commerce app and design the framework for all web apps.

· Led a team of 3 taking a $1 million sunk-cost system live within 3 months.

· Designed and developed the framework behind the company’s 6 web apps.

· Administered IIS and SQL Server (light DBA).

Technologies: Java (J++), VB6, IIS, ADO, ASP, MTS, COM, Javascript, HTML, VBScript, SQL Server 2000, .NET, C#, CSS

Vice President of Development (Recruiting/Staffing) Feb 1997 – Feb 2000

StaffSoft Corporation, Houston, Texas

Project: Create software for sale to recruiters (permanent and temporary).

· Managed a team of 4 developer and tech support personnel.

· Integrated software with Great Plains, Solomon, Excel and Word (VBA).

· Closed the largest sale for the company.

Technologies: Visual Foxpro, VB6, Java, ASP, MTS, COM, IIS, SQL Server, HTML, Javascript, VBScript, Great Plains, Access

Senior Software Engineer (Accounting) May 1996 – Jan 1997

Petrobras, Houston, Texas

Project: Create all reports for the accounting and procurement system in Brazil.

· Designed and optimized SQL queries on 1,000,000+ record tables.

· Built BI dashboard showing current operational status of orders with drill-downs into A/P, A/R, inventory, material receipts, etc.

Technologies: Foxpro 2.6, VB6, Crystal Reports

Systems Analyst (Mortgage wholesaling) Oct 1993 – Apr 1996

Equivantage, Houston, Texas

Project: Design systems for mortgage underwriting and processing.

· Developed underwriter software to reduce pricing mistakes.

· Designed processing systems providing broker and appraisal data.

· Developed a legal expert system comprising state law specifics for closing.

· Integrated Foxpro with Excel and R&R Reports using VBA.

· Financial analysis for securitization.

Technologies: Foxpro 2.6, VB6, R&R Report Writer

Ad Valorem Tax Specialist (REO management) Jan 1991 – Sep 1993

Bank One, Houston, Texas

Project: Manage property taxes on 5,000+ REO properties.

· Maintained database of all properties tracking sales and tax liabilities.

· Performed financial analysis on commercial properties saving $6 million.