My fantastic Webdings Logo

 

Knowledgy Solutions

Business Intelligence and Data Warehouse Consultants Atlanta



SQL Information Management Consultant

Contact







Senior Business Intelligence and Master Data Management Architect

ING Investment International, Atlanta

November 2007 - Present

  • Entity Relational Data ModelCurrently standardizing and consolidating world-wide real-time data centric infrastructure for ING Investment, an international conglomerate earning $76 billion a year in revenue.
  • Responsible for data modeling, architecture of international ETL data warehouse framework for heterogeneous data collection and strategic data delivery using SSIS (Sql Server Integration Services), BizTalk, Visual C#.NET and PHP.
  • Visual Basic, .NET, ASP.NET, ADO.NET, XML, SQL and T-SQL with Visual Studio 2005 and Team System Foundation for project management used in designing data intensive application systems and middleware messaging that are tightly coupled to backend SQL Server 2005 and 2008 and Oracle databases.
  • Driving business intelligence and data warehousing initiatives through engineering of automated regulatory requirements systems for governmental compliance, analysis and reporting.
  • Leading a team of 12 developers in a strategic approach to information data quality and performance optimization.
  • Educating executives, management and end-users on the importance of enterprise data integration and master data management methodologies to improve current data quality and use data as a way increase revenue with current assets.
  • Challenged with the task of engineering data mining MOLAP systems to mine data from international data stores for knowledge discovery of customer trending and analysis to reduce expenses.

 

Sr./Team Lead Business Intelligence, Data and ETL Architect

Homebanc Mortgage Corporation, Atlanta

Oct 2004 - Sept 2007

  • Analyzed loan origination work flows and data modeled (IEE and ER) information repositories for new mortgage system that increased sales an average of 3 loans or $1,500,000 in extra net income per branch.
  • Guided data management development teams in the architecture of enterprise-wide SQL Server transactional (OLTP) and analytical (OLAP) databases and data warehouses. Systems coded in XML, VB, T-SQL, CLR, SMO, running on BizTalk Server and SQL Server 2000 and 2005.
  • Performance tuned systems, initiated standards and automated Sarbanes Oxley security and auditing controls, eliminating 115 hours of monthly manual report generation and administration costs.
  • Developed design standards and managed Visual Source Safe 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 bussiness intelligence SSAS 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.
  • Used Sagent, DTS and SSIS (coded with ASP, VBscript, ActiveX, DMO) ETL tools to deliver data in real-time improving employee ad-hoc querying and end of month
  • Business Objects report generation times by 3 days, reducing manual operating costs.
  • Designed predictive analytical data warehouse enabling Directors and Executives to forecast and uncover hidden revenue streams and increase REIT revenue.
  • Directed Sarbanes Oxley compliance initiatives, assumed role of Production DBA, managed 100+ heterogeneous databases on multiple instances, storing several terabytes of sensitive financial data.

Team Lead Business Knowledge and Solutions Architect
LabLynx Medical Information Systems, Inc., Atlanta

May 2004-Oct 2004

  • Engineered automated SSIS and Informatica Extraction, Transformation and Load (ETL) processes, data cleansing routines and data mining forensics algorithms from into SQL Server and Oracle data warehouse.
  • Wrote SQL, T-SQL, PL/SQL, ActiveX, ASP, ADO, OLE DB, XML, ODBC, VB, VB Script code using Query Analyzer, Toad, Visual Studio and Procedure Builder IDEs' and Data
  • Transformation Services (DTS) ETL systems and to supply data to business intelligence data warehouses and web services. Actuate and Business Objects used for reporting.
  • Refactured conceptual data models and implemented performance tuned physical designs, improving query execution times, in some cases, from 10 hours down to 15 minutes.
  • Used Erwin and Embarcadero's ER Studio data modeling tools to engineer logical, conceptual and physical DB2, Oracle and SQL Server relational databases and MS Analysis Services multi-dimensional data warehouses.
  • Traced long running busines intelligence queries, investigated execution plans then performance tuned indexing, partitioning, parallel execution, bulk loading techniques and re-engineered SQL, T-SQL, PL/SQL packages, procedures, functions and triggers increasing data access performance of middleware applications (ASP, ADO, VB, VBScript, OLE DB).

Enterprise BI Data Warehouse Architect / ETL Engineer
United Parcel Service (UPS), Atlanta

May 2003-May 2004

  • Designed business intelligence system that uncovered $180,000 of lost sales revenue and provided aditional annual income gains.
  • Designed Sales Lead Measurement Initiative business intelligence data warehouse system that directly increased revenue by reducing customer churn by 20%.
  • Engineered SQL Server transactional databases for real-time package tracking and business intelligent routing systems handling 3.35 Terabytes of live transactional data.
  • Automated SQL Profiler to monitor database activity to performance tune data warehouses and transactional OLTP databases. Analysis of execution plans, disk I/O, DBA instance statistics and redesign of code improved system response times by an average of 45%.
  • Leading developer on the data warehouse OLAP and business intelligence team, established data granularity standards, designed and built star and snowflake dimensional models during Customer Volume and Behavior Analysis Tool architecture and implementation.
  • Analyzed upper management's informational needs to calculate Sales, Operational and Financial KPI's.
  • Led meetings to conform facts and common objects among disparate databases and implemented a standardized international decision support data warehouse reducing future design and administration costs by 15%.
  • Involved in Full Life Cycle development of Small Segment Acquisition and Sales business opportunity, built and coded complex T-SQL, PL/SQL, SQL, Embedded SQL, XML, J Script programs and DTS packages for the ETL processes.
  • Adhered to proven incremental development methodology for design of Data warehouse and XP (Extreme Programming) like methodology of rapid deployments, small incremental changes and real-time testing of designs and code providing immediate benefits to UPS end-users.

Team Lead Data and ETL Architect / .NET Developer
Geofields Data Management, Atlanta

Nov 2001-May 2003

  • Designed, normalized, de-normalized, coded and tuned Oracle and SQL Server GIS and Relational Databases and Data warehouse for major pipeline companies reducing average response time of highly computational queries and stored procedures by 12% (between 20 - 30 minutes).
  • Gathered and prioritized Key Performance Indexes and metrics and designed real-time internet dashboards for Business Intelligence using Brio Performance Suite and Cognos to monitor data warehouse and for analysis of Oracle and SQL Server, providing a competitive advantage.
  • Developed Fail-Safe Disaster Recovery Plan by replicating disparate databases between Atlanta , GA and Houston , TX using DTS for ETL.
  • Conducted workflow and data flow studies to enhance employee performance and coded web services using SQL, T-SQL, PL/SQL, XML, ASP, ADO, VB and VB Script to run on Oracle, SQL Server, Windows and UNIX platforms.
  • Reduced OLAP data redundancy by 20%, integrated data from disparate data sources using Data Junction and DTS for ETL and data cleaning routines additionally lowering data administration costs by 30%.
  • Designed dimensional data models for MS Analysis Services MOLAP databases, built multidimensional cubes used in analytical and reporting web services, integrating financial and pipeline data for cost accounting reports sent to shareholders, financial institutes and the federal government.
  • Administered object and account security, password management and encryption policies, database auditing guidelines and created disaster recovery and back up plans.

Senior Instructor focusing on Data Architecture (OLTP/OLAP), SQL Programming and Data Administration
Oracle Corporation , Atlanta

Sept 2000-Oct 2001

  • Created, streamlined and enhanced Data Modeling, Data Warehouse, PL/SQL and SQL certification focused curriculums and labs increasing quarterly departmental revenues by 20%.
  • Consistently ranked in the Oracle Master Certification Quality club by scoring a 97% average weekly student evaluation and received recognition in award ceremony.
  • Very strong SQL skills, including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns, and creative use of the CASE and EXISTS operator.
  • Instructed courses in Data Warehousing, JAVA, PL/SQL, SQL, Object Oriented programming, OO software and database design with UML, ORM and ER engineering notation.
  • Expert knowledge and skills in Database Administration and Architecture, Performance Tuning, SQL Statement Tuning, Stored Procedures, Triggers, Extended Data Retrieval and Large Objects.

DBA / Database Developer
Per-Se Technologies (formerly Medaphis Corporation), Atlanta

Aug 1998-Sep 2000

  • Implemented coding and documentation standardization improving development and time to market by 15%.
  • Refined Conceptual, Physical and Logical Entity Relationship models and Systems and Event process models.
  • Used UML to document business process use cases and uncover areas for process enhancement.
  • Implemented SQL, T-SQL and PL/SQL for back-end data processing and Cold Fusion, ASP and XML for front-end data reporting and ad hoc querying.

DBA / Systems Administrator
CheckFree Corporation, Atlanta

Aug 1997-Aug 1998

  • DBA providing administration and security services, complex SQL query development, execution plan analysis and SQL query optimization for over 50 Oracle and SQL Server database instances.
  • Managed 30 replicated databases including data publishing services, automated database administration tasks for maintenance, tuning, monitoring, and backup. encrypted data and delivered over a terabyte of financial transactional data between 40 Financial Banks and the Federal Reserve Bank.
  • Unique Business Rules implemented through combination of constraints, keys, parent/child hierarchies, entity modeling, relationships, triggers, pattern modeling, data type and domain restrictions and look up tables.

CLR Software: Unix Support Administrator: Aug 1996 - Aug 1997 Supported financial clients on use of proprietary accounting software system.


Thomas Publishing: Financial Accountant: Jan 1994 - Aug 1996 Corporate financial accountant.

CERTIFICATIONS

• Develop PL/SQL Program Units •

• Introduction to Oracle: SQL and PL/SQL •

• Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition •

• Sun Certified Programmer for Java Platform •

• Implementing and Supporting Microsoft Windows •

• IBM AIX Advanced System Administration •

• IBM AIX System Administration •

• IBM AIX Basics •

 

EDUCATION

Bachelor of Business Administration

Hofstra University , Hempstead , NY

 

Berklee College of Music

Musical Performance-Percussion

 

PROFESSIONAL ASSOCIATIONS

Participating member of Technology Association of Georgia (TAG)

International Society for Performance Enhancement

Independent Computer Consultant Association

 

FOREIGN LANGUAGES

English

German - Fluent

Spanish - Some



 
$