SUMMARY:

• Highly motivated and well - rounded database professional. A unique combination of inspiring perseverance, in-depth knowledge of technology, and hands-on expertise. Expert in database architecture, database modeling, development and administration, data warehousing, relational and big data.
• Database architecture/performance/security: physical desing/platform configuration, modeling, massively parallel systems, metadata-driven applications, database-centric design, privacy, data protection, disaster recovery, access controls; relational and object-relational technologies, big data.
• Data warehousing/business intelligence: data migration, data cleansing, data quality, ETL, ODS, OLAP, enterprise performance management, central data warehouse, data marts, star/snowflake schema design, data warehouse processes and technologies. In-depth knowledge of Kimball methodology and both Kimball and Inmon architectures.
• Languages/tools/environments: ASP.NET, BASIC, C, C#, C++, Hive-QL, Pascal, Perl, PL/SQL, Presto, Python, REXX, SQL, SQL*Plus, T-SQL; DB2, Hadoon, Hive, Illustra, Informix, Ingress, MySQL, Oracle, PostgreSQL, Presto, SQL Server, Sybase; Actuate, Cognos, ERwin, ETI Extract, MicroStrategy, QualityStage, SSIS, SSRS.

TECHNICAL SKILLS:

• Relational big data pen systems windows client/server
• AIX
• RS6000/pSeries
• Oracle
• Solaris
• DB2 UDB
• SQL Server
• Informix
• PostgreSQL

PROFESSIONAL EXPERIENCE:

Confidential, La Jolla, CA

Database Consultant

Responsibilities:

• Provided architectural guidance and project management for complex enterprise data migration: moving certain enterprise functionality from legacy enterprise applications, including EBS and SFDC, to Siebel UCM/CRM, TIBCO AC/AF/Middleware, Singleview, Vertex, and Apttus, with heavy focus on ETL processes and implementation.
• Managed a team of 30 between California and India, and worked closely with eight cross-product teams.
• This cross-functional project covered all enterprise areas and functions: Confidential (customer, product, pricing, data center), billing, capacity management, Confidential, install base, reporting, sales and sales operations, portals, and integration. Oracle 11g/12g, SQL, PL/SQL

Confidential, Menlo Park, CA

Sr. Data Engineer

Responsibilities:

• Proposed initial data strategy plans to optimize the complex data eco system through data value analysis, critical data selection, eco system analysis, optimal destination platform, and data governance. Hive, Hadoop, Presto, Raptor, Oracle, Vertica, Tableau, Microstrategy
• Engineering in analytics and data warehousing, ads, ads interfaces, ETL, ETL architecture and processes, big data. Leading a team of 10 analysts and data engineers, and working with 15 cross-functional partner teams. Office 2016, MySQL, HDFS, Hadoop, Hive, Presto, Tableau, Unidash, Raptor

Confidential, San Diego, CA

Data Engineering Head

Responsibilities:

• Defined critical areas to focus within data engineering as a discipline, such as archiving/purging, performance, model maintenance and automated model change management, multi-tenancy, data migrations, ETL, etc. SQL Server 2005/08/12, Oracle, DB2/iSeries, SQL, PL/SQL
• Proposed organizational and technical enhancements to optimally and expediently develop and expose enterprise information and data model. Commonly neglected in practice, this focus has a far-reaching effect on all aspects of data, and thus company’s ability to develop, migrate, integrate, improve, comply, market, and grow.
• Proposed a loose application integration approach which leverages an information bus architecture, where enterprise and/or cross-application unified model drives definition and mapping across the products and enterprise, minimizing the need for “hard”, i.e., revolutionary, integration, which hard integration is costly, lengthy, error-prone, and customer-satisfaction risky.

Confidential, San Diego, CA

Senior Information Architect

Responsibilities:

• Implemented order of magnitude database performance improvements for the company’s flagship SaaS product MySQL 5.1/5.5
• Evaluated products and vendors DB2 9.7, MySQL 5.1/5.5, Oracle 11g, SQL Server 2008 R2
• Evangelized, designed, and implemented a database-centric integration platform architecture DB2 9.7, MySQL 5.1/5.5, Oracle 10g/11g, SQL Anywhere 10/11/12, SQL, PL/SQL
• Instrumental in improving customer satisfaction through complete overhaul of database access methods, converting the application from inadequate and customer-churning to high-performance and appealing, thus enabling company acquisition by API Healthcare MySQL 5.1

Confidential, San Diego, CA

Database Architect

Responsibilities:

• Developed database design and implementation roadmap in first 3 months. Conceived consolidated database process improvements, increasing operational efficiency.
• Within first 12 months, achieved multifold improvement in capacity metrics, including performance and scalability by systematic application of performance improvement methods. Transferred the knowledge to multiple, global company units. SQL Server 2000/2005/2008, Oracle 9i/10g/11g, SQL, PL/SQL
• Designed and implemented a robust data layer based on ADO.NET in C#. SQL Server 2000/2005/2008

Confidential, La Jolla, CA

Database Consultant

Responsibilities:

• Products include student management: admissions, financial aid, retention, etc. SQL Server 2008
• Reviewed database product, including model and logic, and proposed two orders of magnitude database improvements. SQL Server 2008
• Advised on SQL Server setup and information architecture for a rules based analytics engine. Implemented the ELT and analytics system used for reporting and analytics in 58 hours. SQL Server 2008, SSMS, T-SQL
• Advised on IT platform and developed a critical database Web application for data mining. Worked with a team of four developers and client’s employees. SQL Server 2008, SSMS, T-SQL
• Developed strategic plans for data warehouse development effort in this fast-growing auto finance company, now owned by Confidential . Worked with a team of six contractors and employees. SQL Server 2005, SSMS, T-SQL
• Planned, configured, designed, and implemented a 19-node SP2 data warehouse for the Confidential and created their data management evolution strategy. In addition to the technical leadership role for a team of eight employees, contractors, and managers, performed many roles of the senior data warehouse manager, such as data warehouse planning, project management, building the data warehouse department, interacting with the user groups.
• Designed and developed all components of the data warehouse environment: operational data store, staging area, central data warehouse, data marts, cubes, reports. Built availability models to compare computer and storage configuration options. Reviewed development methodologies, including RUP and DSDM, for consideration in the implementation of the data warehouse. Evaluated MicroStrategy and ETI Extract technology. Cognos, Powerplay, DB2 UDB 5/6/7
• Led technical implementation of contract: Sirena-3 Offline Fares Management system, managing a team of six developers and coordinating the effort with the larger team of 30 developers.
• Placed the system in the framework of SABRE product line. Generalized and enhanced product to meet future customers’ demands. DB2 UDB 5, Oracle 7/8, SQL, PL/SQL