Margie G. Barulsen
2864 Shane Drive
Snellville, Ga. 30078
404-784-6873
[Send email using form at bottom]
FINANCIAL SERVICES PROGRAMMER:
Detail-oriented, business savvy and results-driven technology manager with
expertise in managing the customization, design, development and support of
software solutions to support and advance key business initiatives.
SOLUTIONS and APPLICATIONS:
Contract Financial Systems Development 11/2007 - Present
D/B/A LOANTREK SOFTWARE SERVICES, Atlanta, Georgia
* Strategy Corps, LLC
Designed, developed and implemented SQL 2008 database and XML rule set for
custom processing of value added services such as High Interest, ATM Refunds and
Automatic Savings Transfers for small banking clients. Web Services provided for
XML parameter sets. SQL Server 2008, SQL Server 2008 Integration Services, VB
.Net 2008, ASP.Net 2008
* Crescent Mortgage Company
Designed, developed and implemented company-wide SQL 2005 staging database and
datamart for analysis, reporting and external vendor integration. Implementation
of new B2B LOS system and re-design of data sources to support internal Trading,
Mark to Market and Final Documentation systems. SQL Server 2005 Integration
Services, SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services,
MDX, MS Visual Studio 2005, VB .Net 2008, SQL Server 2000, DTS, VB 6.0
* Clayton
Supported Commercial due diligence of failed bank portfolios. Provided
searchable MS-Access database of loans for sale and changes to Underwriting
platform in support of client. MS-Access, MS-Excel, VB 6.0
* United Group Captive Insurance Company
Policies, billing and claims internal processing site. ASP 2.0 / SQL Server 2005
/ Business Objects IX
IT Director Conduit Services 3/2005 10/2007
CLAYTON, Shelton, Connecticut
* Key technologist in startup operation for 5 of 6 Client Conduit systems.
Designed and implemented XML messaging interface for proprietary Mortgage Pricing
and Locking systems. Integrated Automated Underwriting, Fraud, Automated Property
Valuation and Custodial systems of the clients choice. Technology relationship
manager for Morgan Stanley, UBS and WAMU. SQL Server 2000, MS Visual Studio 2003
(VB/C#), SQL Server 2000 DTS.
* Enterprise-wide SQL 2005 data modeling to support due diligence, reverse and
forward loan servicing, regulatory compliance and conduit services. SQL Server
2005, ER Studio
Consultant Financial Systems Development 1997 3/2005
D/B/A LOANTREK SOFTWARE SERVICES, Atlanta, Georgia
* Web Site Development for Wholesale Lender featuring Loan Registration, Pricing
& Locking and Loan Status options for Retail Lenders and Closing Agents with
bi-directional feeds to third-party Loan Management software. SQL Server 2000,
ASP 1.0
* Designed and Implemented Invoicing, Billing and Loan Payment History adjunct
to third party Commercial Lending software. VB 6.0, MS-Access
* Mark to Market and best execution routines for both Loan and Servicing Sales,
which integrated a variety of electronic feeds for diverse Price and Product
specifications including FNMA, FHLMC, GNMA, Private Investor / Servicer pricing
and adjustments. VB 6.0, SQL Server 2000, MS-Access, MS-Excel, VBA
* Automated Loan Production and Valuation analyses generated with Macros in
MS-Excel to display charts and from SQL Server 2000 and MS-Access sources.
* Extensive accounting, loan production and secondary marketing reporting
systems. MS-Excel, MS-Access, VBA Macros, Crystal Reports, Visual FoxPro.
* Bankruptcy helpdesk software development using MS-Exchange Server 2000 and
MS-Outlook Forms. VBA.
* Designed and Implemented Final Documentation reconciliations and tracking
module generated from custom Third Party data feeds. SQL Server 2000, DTS, VB
6.0, MS-Access
* Reconciliation of thousands of FNMA/FHLMC fee adjustments with loan data feeds
from originator. Facilitated data clean-up and fee reversal when appropriate.
MS-Excel, MS-Access, VBA, SQL Server 2000 DTS
VP Mortgage Systems Development 1991 1997
LONG ISLAND SAVINGS BANK / FIRST ADVANTAGE MORTGAGE / ENTRUST FUNDING, Melville,
New York & Atlanta, Georgia
* Managed 3 10 employees locally and remotely, Architect and development
Manager for custom Mortgage Origination, Secondary Marketing, Loan Processing and
Loan Closing modules. Successfully migrated DOS applications to Client/Server.
Sybase, Easel, OS/2, Clipper
VP Data Processing - Mortgage 1989 1991
ALW HOME MORTGAGES, INC, Atlanta, Georgia
* Managed 3 5 employees locally. Selected and customizes Mortgage Processing
solution for nationwide Mortgage Banking startup.
TECHNOLOGY INVENTORY:
SQL Server 2005/2008 Integration/Anal/Reporting
SQL Server 2000 and DTS
ER Studio
Stored Procedures, Functions, Triggers, MDX
C#/ASP Net 2.0
Visual Basic 6.0 / VB Dot Net 2005/2008 / VBA
Crystal Reports
Performance Point
Microsoft Office Scripting & Tools
Delphi/Clipper/XHarbour/FoxPro
Microsoft Access, Excel, Project & Visio
EDUCATION:
BA West Georgia College
Advanced Clipper
Programming in C+
Mortgage Bankers Assoc Technology Conferences
|