Andrew B. Brown

+1 (512) 947-8282

Summary

· Managed teams through the full software development life cycle (SDLC): business analysis, design, development & testing, and support.

· 15+ years experience designing, developing, and supporting windows and web applications, services, reporting, n-tier and database architecture.

· Industries: mortgage, accounting, procurement, inventory, recruiting, legal, construction lending, trading, real estate, and healthcare.

Technical

Languages: C#, VB.NET, Visual Basic 6.0 (VB6), Java (J++), 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, JQuery Mobile

Scripting: VBScript, VBA, Javascript, HTML, CSS

Source Ctrl: Source Safe, Team Foundation Server

Reporting: Crystal Reports, R&R Report writer

Certifications

SEC Series 7, 55, and 63 Jan 2002

Visual Basic 6 (MCP) Jun 2003

SQL Server Design (MCP) Jun 2003

Employment

Principal Consultant (Wealth Management) Apr 2013 – Aug 2013

Morgan Stanley, New York, New York

Project: Create a wealth management CRM.

· Performed as the lead architect.

· Designed and wrote the framework for desktop and mobile.

· Designed an identity-theft prevention security system (Fingerprint Touch).

Technologies: C#, Web API, SQL Server, AJAX, Javascript, JQuery Mobile

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 Consultant (Automobile sales analytics) Feb 2012 – Apr 2012

Princeton Information, Plant City, Florida

Project: Maintenance and development of existing auto dealership software.

· Created BI dashboards providing real-time inventory 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

CEO (Security & Data access) Mar 2011 – Jan 2012

Salience Corporation, Bangkok, Thailand

Project: Create a secure data-access layer for any application.

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

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

· For more info, see http://systemdotpersistence.blogspot.com

Technologies: C#, SQL Server, Winforms

CEO (Windows Security for consumers) July 2009 – Jan 2011

Hidden Desktop, Bangkok, Thailand

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

· Created and sold Hidden Desktop to provide consumer security.

· Designed sales compensation schedules.

· No technical support issues in over two years.

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.

· 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, 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

Day Trader (NYSE) 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 (Recruiting/Staffing) Feb 1997 – Feb 2000

StaffSoft Corporation, Houston, Texas

Project: Manage the development and support of recruiting software.

· Promoted to VP within 3 months.

· Closed the largest sale for the company of $500,000.

· Rewrote the software while maintaining full functionality.

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.