Jeffrey Jacobs Email & Phone Number

• AltaSQL SELECT Discover is now available on the Snowflake Marketplace. Preparing release of AltaSQL SELECT Standard, Plus and CREATE products.SQL VIEWs have long been the industry standard for sharing queries. Hand.
• Unlimited usage and users!
• Unlimited View Definitions!
• Unlimited repositories!
• Unlimited possibilities!Visit AltaSQL.io for more information!

Multiple Client Engagements include:California Child Welfare SystemsLead data architect for all aspects of Snowflake analytics warehouse for green field implementatation new of Child Welfare management system. Developed standardized data model and pipeline for Kafka JSON pipeline from Salesforce due to integrations such Fivetran not FedRamp Mod certified..

Austin, Texas, US

Sr. Data Architect for Fusion Applications (FA) Life Cycle Management in the Cloud.Architecture and technical support for migration of FA to Edition Based Redefinition (EBR). Developed EBR framework for ZDT versioning/editioning seed data requiring no changes to FA's multi-million lines of runtime code.Technical support for migration of FA to new Oracle.

Foster City, California, US

Database and infrastructure architecture, data modeling, performance tuning. Oracle 12C.

Member of board of directors of IOUG Exadata SIG. Promote education and support for Oracle Exadata Database Machine users.

Chicago, Illinois, US

Conceptual, logical and physical modeling and design for multiple EDW efforts including regulatory reporting (CCAR), AFS, digital marketing (Adobe Catalyst), et alia. Performance tuning, process improvement and automation, gap analysis and mentoring. Assessment of commercial data models and products for banking.

Oakland, California, US

Dimensional modeling for data warehouse and datamarts. Process and performance improvements.

San Jose, CA, US

• Architecture, modeling and design for site facing Oracle databases. Performance tuning and troubleshooting.
• Developed full life cycle architecture for multi-billion row OLTP database ETL’ed from Hadoop into Exadata with both incremental and full refresh capabilities and zero downtime.
• Re-architected real-time performance monitoring database.
• Extensive performance analysis and tuning. Received spot bonus for in-depth analysis resulting in 3X improvement of PayPal’s main transaction database.
• Worked closely with multiple product development groups on database modifications for new features

Bentonville, Arkansas, US

• Wide ranging responsibilities including:
• Data architecture for near, mid and long term site scalability projects. Member Enterprise Architecture Council
• Led migration and re-architecture of single instance databases to RAC. Resolved numerous technical issues resulting in successful Black Friday.
• Oracle RAC,SQL, PL/SQL, Advanced Queuing and application performance tuning.

Oakland, CA, US

Reviewed and revised design, requirements and project plan for enhancements to data warehouse using OBIEE and OWB. Developed plan for migration to Oracle Exadata Database Machine. Developed logical E/R models. Identified critical performance improvements.

San Jose, CA, US

Data modeling for Cisco's enterprise data warehouse migration from Oracle to Teradata. Meta-data repository design and population. Designed and developed system for generating data warehouse quality test scripts driven by meta-data extracted from ER/Studio models.

Management of major Oracle user group. Conference Chair for ODTUG's 2010 and 2009 Kaleidoscope conferences. Program Manager for Seriously Practical Conference series. Served as President from 1994-1999.

Oakland, California, US

• Data modeling, database design and performance improvement including:
• Redesigned hotel database for improved functionality, flexibility and performance.
• Designed schema and queries for revenue reporting.
• Preliminary design of corporate data warehouse.
• Created Wiki pages on Oracle performance, SQL and PL/SQL best practices.
• Refactored SQL query generator, improving generated query performance by a factor of 12 for the worst cases

US

• Data modeling, database design and development DBA responsibilities including:
• Developed a comprehensive enterprise model for pricing and product catalog.
• Led successful architecture and development of new pricing engine for T1 product lines, resulting in double digit improvement in revenues.
• Designed meta-data driven, “what you need is what you get” XML Data Services framework.
• Trained and mentored staff in ER modeling and relational design techniques.
• Identified and implemented numerous opportunities for performance improvement of both in-house and COTS systems.

Austin, Texas, US

Marketing and evangelism for data lifecycle products.

Independent consultant providing services in data architecture, product management, software process improvement and business requirements analysis

San Jose, CA, US

Senior staff to VP/GM. Responsibilities include due diligence for M&A, technical presentations and coordination with business partners, product management & marketing and mentoring of junior staff.

Directed turnkey development of e-commerce web sites. Responsibilities included ensuring on-time project delivery, business development, customer relationship management, hiring, career development and mentoring. Managed staff of 75.

Founded a successful consulting and training business assisting Fortune 1000 companies in identifying and adopting best practices for large-scale database systems development. Engagements included conceptual/logical data and business modeling, database design, project planning, methodology adoption, IT strategy and architecture, Business Process.

Austin, Texas, US

Consultant and instructor specializing in modeling techniques and systems development methodologies.Trained executives, analysts and developers in logical/conceptual Data Modeling, Strategic Business Analysis, Detailed Analysis, Database and Systems Design, Oracle CASE products and SQL.