Since 1994 Knowledgy Solutions has significantly increased market value for their fortune 500 companies. We specialize in the design, implementation, optimization and administration of very large, cost-effective, high performance enterprise information infrastructures focused on solving today’s complex business challenges.Scroll down to view professional history in chronological order or select the company from the links on the right (also in chronological order with the top being the most recent or current project).
Lead Master Data Management Architect / Sr. Data Modeler / Sr. ETL Engineer - Consultant
Ford Motor Company (APCO Division)
July 2008 – Nov 2008
Technology: Sql Server 2005/2008, SSIS, ERwin, T-SQL, SQL, ETL, OLTP, OLAP, MOLAP, PL/SQL, Visual Studio, VB, Team System for Database Professional, XML, SMO, SQLCMD, Business Objects XI, Crystal Reports, all Embarcedero DB tools, Clustering, Replication
Model, design and roll out Ford’s first centralized Master Data Management (MDM) database repository integrating finance, manufacturing, customer, accounting, dealership, warranty, service, sales and marketing lines of business. Completed database will reduce application development time, eliminate data anomalies and redundancies, reduce administration and maintenance costs, increase performance and is projected to lower operating expenses saving $500,000 - $650,000 annually. Engineered data mining MOLAP systems to mine data from international data stores for knowledge discovery and customer trending to discover new areas for cross market selling and increasing revenue. Develop ETL processes for collecting, consolidating, aggregating, quality-assuring, persisting, matching and distributing data throughout the enterprise and ensure consistency and control in the ongoing maintenance and use of this information. Reverse engineer legacy databases; integrate all existing data models, data flows and data dictionaries into new Meta-Data Repository. Conduct interviews with end-users and subject matter experts to gather and document data requirements and translate business rules into normalized conceptual, logical and denormalized physical data models. Responsible for change control management, daily development/test database roll outs, security, data access, data names and definitions. Conduct conformed facts and data model review meetings and act as liaison between development teams and business stakeholders.
Senior SQL Business Intelligence Systems Architect - Consultant
ING Financial ServicesSept 2007 – July 2008
Sql Server 2005/2008, SSIS, Proclarity, Visual PHP, Visual Basic, VB.NET, ASP.NET, ADO.NET, XML, SQL, T-SQL, Visual Studio 2005, Team System Foundation, Analysis Services, MDX, Reporting Services, Clustering, Replication
- Designed and implemented large-scale global data warehouse and associated data marts for the ING Financial system.
- Developed ETL framework standard for automating SSIS development which increased employee productivity over 100%
- Developed financial business intelligence data mining dashboards accessing multidimensional database cubes mining 1.5 terabytes of real time stock market data.
- Developed automated data capture processes and systems for regulatory reporting, operations analysis, governmental compliance reducing manual operating expenses $150,000 - $250,000 annually.
- Took lead role in writing the DRM (Data Reference Model document) for the data warehouse architecture.
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.
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.
Senior Instructor teaching Data Modeling (OLTP/OLAP), SQL+, PL/SQL Programming, Database Administration, Performace Tuning, Optimization
Oracle Corporation , Atlanta Sept 2000-May 2003 - 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 / UNIX 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
|
