Home Homebanc Mortgage
PDF Print E-mail

Senior Business Intelligence, Data and ETL Architect - Consultant

Homebanc Mortgage Corporation

Oct 2004 – Sept 2007

Sql Server 2000/2005, Oracle, SSIS, Sagent, OLTP, OLAP, Business Objects, Crystal Reports, FRx, Lawson General Ledger, SSAS, SSRS, Visual Source Safe, in XML, VB, T-SQL, CLR, SMO, VB.NET, ActiveX, SMO, ASP.NET, All APEX Tools, MS MOM

  • Analyzed loan origination work flows and data modeled information repositories for new mortgage system that increased sales an average of 3 loans or $1,500,000 in extra net income per branch.
  • Directed Sarbanes Oxley compliance initiatives, assumed role of Production DBA, managed 100+ heterogeneous databases on multiple instances, securely storing 20-30 terabytes of sensitive financial data.
  • Performance tuned systems, initiated coding standards and automated developed Sarbanes Oxley security and auditing controls, eliminating 115+ hours of manual report generation time and administration costs.
  • Guided data management development teams in the architecture of enterprise-wide transactional (OLTP) and analytical (OLAP) databases.
  • Developed design standards and managed source and version control priorities, change and content management initiatives, and maintenance and support processes for this $12 billion/year net income producing financial institution.
  • Engineered Analysis Services OLAP cubes and SQL Server databases running FRX budgeting and forecasting systems, integrated with Oracle, DB2 and MySQL OLTP relational databases running Lawson general ledger and accounting packages.
  • Design ETL systems to deliver data in real-time improving employee ad-hoc querying and end of month Business Objects report generation times by 3 days and reducing manual operating costs.
  • Predictive analytical databases enabled Directors and Executives to forecast and uncover hidden revenue streams and increase REIT revenue.

 

Knowledgy SQL RSS

SearchSQLServer: Expert advice on database development
Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.
SearchSQLServer.com
  • Utilize SSAS for data predictions and classification using Excel
    Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Useful reading for users who are not typically creating data mining algorithms and SAS/SCL programmers

  • The sqlcmd utility in SQL Server
    The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting started using sqlcmd in interactive mode, and shows you have to use sqlcmd in Management Studio.

  • Top 10 SQL Server Tips of 2008
    Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most viewed SearchSQLServer.com tips of the year.