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 crafting SELECT and CREATE VIEW statements is labor intensive, and subject to frequent, difficult to resolve errors. Until now! AltaSQL’s patented technology (U.S. Pat. No. 11,977,539) offers a revolutionary new paradigm for automating, managing and sharing SQL queries. AltaSQL can transform the way your organization uses the Snowflake platform to achieve a higher level of productivity from your Snowflake investment. AltaSQL redefines SELECT and SQL VIEW management by automating SQL statement generation from "Virtual Views", eliminating up to 90% of manual effort. SQL statements are always properly qualified and quotesEffortlessly share and reuse SQL queries via AltaSQL's meta-data repository based View Definition architecture. Share SQL queries across teams of all technical levels to increase data worker productivity.Nothing to install! AltaSQL never has access to your data. AltaSQL is delivered as a Snowflake Shared Database via Secure UDFs, ensuring the security and integrity of your data at all times.All SQL, all the time! Use AltaSQL with your SQL tools of choice. AltaSQL does not execute generated SQL statements, enabling review and modification prior to execution.Create multiple naming conventions for the same data source! Produce data analysis work products in the natural language of business, or in any and all languages your organization uses globally.Generate and manage CREATE VIEW statement column lists automatically instead of using complex, error-prone manual processes. Add comments, tags, and dynamic data masking with ease.Subscription pricing with free trial• 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. Architecture utilizes layered VIEWs (ELVT), streams and tasks to efficiently manage slowly changing data and varying requirements for data availability.Rush Street Gaming, Chicago, ILConduct assessment of Snowflake infrastructure. Identified root cause of data discrepancies. Reduced compute spent by 60%.Brightmark, San Francisco, CAData architecture for "green field" enterprise Snowflake data warehouse. Developed POC, defined overall network topology for integrating SCADA systems supporting multiple sites. Technology assessments and selections.Confidential ClientData architecture and migration plan for on-prem Oracle to Snowflake migration.Docusign, San Franciso, CA Migrated Qlik Sense Salesforce and Eloqua presentation naming, business logic and data infrastructure into Snowflake database objects. Utilized meta-data repository and automation tools with full lineage mapping to underlying Snowflake tables and columns, providing reusable database components with well-defined presentation and semantic layers. Replaced 7000+ lines of Qlik Sense load script code. Delivered on-time and under budget despite highly compressed schedule.Trianz, Santa Clara, CAArchitecture for proposed new line of business based on Snowflake and its eco-system. Developed architecture for identifying PII/PCI/GDPR for tracking in CompilerWorks Lineage Solution.Talend, Redwood Shores, CADeveloped dimensional data warehouse for migration of Salesforce, Marketo and Gainsight data lake from Redshift to Snowflake. Performed extensive data quality and distribution analysis to determine and identify slowly changing dimensions.

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 Cloud Infrastructure (OCI)Architecture for fast loading of FA multi-language pack data.Developed technique for sparse data for FA seed and multi-language pack data.Extensive RDBMS trouble shooting and problem resolution.

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• Identified database tuning opportunities resulting in 35% improvement in overall database performance. Developed performance evaluation tools and queries to measure system level changes.• Refactored legacy SQL queries improving performance by an average factor of 15 and incorporating new functionality.• Identified and corrected wide variety of database quality issues. Worked with developers to improve database access practices

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 Improvement and Re-engineering.

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.