Home Homebanc Mortgage

Spotlight Module Content with Image

 

Newsflash 4

Knowledgy Solutions of Atlanta, Ga opens offices in New York!

 

Predictive Analysis with SQL Server 2008

Predictive Analysis with SQL Server 2008I've always found predictive analysis and data mining to be interesting and fun. I feel like a child walking through a cave amazed at the disoveries they are finding. So I couldn't wait to play around with the new predictive analysis tools in SQL Server 2008 Analysis Services. SSAS provides a complete data mining platform that is easy and fun to use. Organizations can use SSAS to infuse insight and prediction into everyday business decisions. The 2007 Office system uses Pervasive delivery through the Data Mining Add-Ins. These tools are a blast to use and will help you uncover knowledge hidden in your data. The comprehensive development environment and extensible range of innovative data mining algorithms combined with the enterprise-level scalability and manageability of SQL Server Analysis Services makes SQL Server 2008 an ideal and easy way to bring the benefits of predictive analysis to your enterprise. The predictive analysis capabilities of MSSQL 2008 makes it easy to incorporate intelligence into reporting, data integration, OLAP analysis, and business performance monitoring. It will help your business drive increased business agility, create a tangible competitive advantage and bottom line, grow revenues. The ability to extend the data mining technologies of SQL Server through custom algorithms and visualizations, together with the ability to embed predictive functionality into line-of-business applications makes SQL Server 2008 a powerful platform for introducing predictive analysis into existing business processes to add insight and recommendations into every operation.

 

Per-Se Technologies

DBA / Database DeveloperPer-Se Technologies (formerly Medaphis Corporation)Aug 1998 - Sept 2000DBA providing administration and security services, SQL, T-SQL and PL/SQL development, complex query development, performance analysis and SQL optimization for over 100 Oracle and SQL Server database instances reporting and ad hoc querying.
Ulti Clocks content
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.