Data Engineer Architect

Christopher A. Franks

Data Architect (**********@*****.***) 562-***-****

Accenture (Los Angeles) June 2021 to February 2025 – Data engineer for large social media client. Utilize Python and Presto SQL to build data warehouse pipelines in very large scale environment Build/maintain reporting dashboards, visualizations and alerts to enable the tracking of campaign/program KPI Performance. Monitor/maintain DW pipelines using Apache Airflow-like tool. Develop Jupyter-like notebook scripts to automate dashboard monitoring. Run SQL queries to uncover inefficiencies in pipeline scheduling.

Linux system administrator providing L2 SME tech support and applying security patches to servers using Ansible for large pharmacy retail client.

SmartDrive (San Diego) February 2019 to March 2020 – Data engineer maintaining legacy MS SQL Server/Wherescape ETL pipelines. Migrated pipelines to Python-PySpark/SQL Server. Developed/maintained Tableau reports. Fixed bugs in legacy stored procedures. Improved performance of SQL queries used by customer-facing web application. Maintained SSIS jobs and SSRS reports.

Avetta, LLC (Irvine) April 2014 to October 2018 – Data architect setting strategy to scale-up eight year-old startup applications and environments to an enterprise level. Mission-critical customer-facing web-based applications are based on MySQL in a LAMP environment across multiple data centers. Initially filled in as DBA and system administrator maintaining all RedHat-based DB and application servers - development, QA and production, using open source tools, Liquibase, Jenkins and various Confluence apps. Led team migrating in-house developed operational reporting system to a web-based embedded 3rd party analytics tool (Logi Analytics), fed by data migrated from MySQL operational DB to Amazon Redshift data warehouse. Logical and physical data modeling of data warehouse DB. Wrote all ETL scripts/processes (SQL in bash shell, migrated to Jenkins). Modified various Java programs to overcome Hibernate ORM issues. Developed/maintained Jasper and Tableau reports Migrated ETL scripts to MS SQL Server T-SQL.

Velocify (El Segundo) July 2012 to April 2014 – Data architect providing support to development teams for SQL Server and NoSQL databases for mission-critical web-based applications. Primary focus has been designing and developing internal and customer-facing operational and business intelligence reporting using T-Sql, Perl, Python, PHP and C# on Sql Server and MongoDB. Integrate data from a variety of data sources, including Sql Server, MongoDB, cloud-based CRM products. Provide operational DBA support: backups, restores, replication, schema deployments. Assist in requirements gathering, product research/evaluation, planning and building an enterprise data warehouse including databases, ETL and BI reporting tools. Logical and physical data modeling of transactional and data warehouse DB.

CCH Wolters Kluwer (Torrance) November 2007 to July 2012 – Lead data architect responsible for design, establish and enforcing standards and practices for SQL Server databases for a integrated suite of dot Net SOA applications. Line manager for a six person DBA team on- and off-shore. Developed and enforced methods and practices for managing and version-controlling DB changes (Visual Studio/TFS) by on- and off-shore distributed development teams, propagating changes to build and deployment environments. Managing all DB-related issues from development side: performance monitoring and tuning, partitioning/scalabity, data cloning, componentized-deployment, internal reporting/data warehousing. Logical and physical data modeling of transactional and data warehouse DB.

LRN Legal Knowledge (Westwood) March 2003 to November 2007 – Production DBA responsible for development, operation and maintenance of mission-critical production databases. Content for LRN’s primary product - online training - resides in Oracle 9i running on Sun Solaris and Linux. Duties include ensuring production databases are available, have reliable fail-over and recovery using RMAN and Oracle physical standby, and to perform maintenance and updates without impacting customers. Manage production reporting databases using Oracle logical standby and advanced replication (materialized views). Responsible for management (installation, data refresh) of over 30 production, QA and development Oracle DBs. Develop/test/run PL/SQL scripts, run in shell scripts, sqlplus and Toad to provide functionality missing from main applications. Enhanced DB manageability and improved internal LRN access to production data by developing web-based applications (Perl CGI). Logical and physical data modeling of transactional and data warehouse DB.

Hiwire, Inc (Downtown LA) October 1999 to March 2003 – Manage a department of DBAs/developers providing critical data services to Hiwire. Was the primary DBA responsible for design, development and operation of mission-critical production 24x7 ad server database, data warehouse, customer and management reporting, and invoicing. Initial systems used Informix. All DBs converted to Oracle. Logical and physical data modeling of transactional and data warehouse DB.

Designed and developed a sophisticated inventory management system for Hiwire’s Internet ad server. Written in PL/SQL, the system uses historical ad data to predict and control ad delivery, targeting internet radio tuners by listener demographics and time-of-day.

Architected, designed and managed coding and implementation of a production reporting system. The current report system has three Oracle databases. A PL/SQL-based ETL system moves data from the operational DB to a staging DB then to a report DB. Internal users and customers view all reports using web browsers. Reports are generated by Perl scripts that access the report DB. The Perl scripts run on an Apache web server.

Developed and implemented previous versions of the reporting systems, one using Informix/Perl and another using Informix Metacube. Built a test reporting system using Oracle9ias Portal and Discoverer

Informix Software (West LA) July 1994 to October 1999 – As an Informix consultant, provided project management, analysis, design, coding and training to Informix customer base. Specialize in large database (including data warehouses) design and administration, server configuration and tuning. Logical and physical data modeling of transactional and data warehouse DBs.

Informix Project Experience

Occidental Chemical – Provided database adminstration, configuration and performance tuning for enterprise SAP Financial application.

Carl Karcher Enterprises (Fullerton) – Provided application and Unix operational support, database adminstration, configuration and performance tuning for enterprise mission-critical PeopleSoft GL and HR. Sun and NT servers.

Safeway (Pleasanton) – Assist with design and loading of 50 GB retail data warehouse. Sun server.

The Money Store (Sacrament0) – Co-authored enterprise database architecture. Performed data analysis, design, development and administration of financial and marketing data warehouses. Designed, configured and trained customer in use of MetaCube OLAP tool. Performed database design and development of call center application. Sun server.

Great Western Bank (Simi Valley) – Performed data analysis, design, development and implementation of cross-product marketing 100+ GB data warehouse. HP server.

Certified Grocers (Commerce) – Provided project management as well as requirements analysis, design and initial development of 100GB data warehouse. Designed, configured and trained customer in use of MetaCube OLAP tool. Sun platform.

Kinkos (Ventura) – Built initial data warehouse performing various roles including project management, requirements analysis, design, development and implementation. Ten GB database designed to grow to 100GB. Designed, configured and trained customer in use of MetaCube OLAP tool. HP server.

CDB Infotek (Costa Mesa) – Designed and developed several multi-gigabyte public records databases used for on-line querying from Compuserve and other public access applications. HP server.

Other Experience

ASK/Ingres (West LA), July 1989 to July 1994 - Senior Technical Support Representative. Provided pre- and post-sales technical support to sales organization. Duties included sales and technical presentations, product installation and demonstration in a variety of hardware/software environments, technical account management, planning coordination and coding prototypes and benchmarks, proposal writing.

Hughes Aircraft Co (El Segundo), June 1983 to July 1989 - Member of Computing Staff. Provided consulting and programming support for division-wide PC, UNIX minicomputer and mainframe-based systems. System administrator for UNIX minicomputer. Developed and maintained administrative and financial database applications. Developed specifications for, evaluate, recommend and purchase software and hardware. Develop and maintain integrated mainframe, mini, and microcomputer-based applications. Develop material for and teach PC and database classes.

US Army (Virginia), August1973 to August 1976 – Defense Information Specialist. Award-winning photojournalist for base newspaper at Ft Belvoir, VA. Honorably discharged as Specialist 4th class.

EDUCATION

AA El Camino College, Torrance CA

Transfer to UCLA

Work towards BS Computer Science at CSU Dominguez Hills

Applications: PeopleSoft (PeopleTools), SAP (SAP R/3 Basis), NetSuite, Salesforce

Operating Systems: Redhat, CentOS Linux, MS Windows Server

Hardware: AWS including Redshift clusters, HP, IBM, Sun, PC

Languages: Python, PHP, Javascript, Perl, T/SQL, Oracle PL/SQL, Java, C#

Databases: MySQL, Redshift, MongoDB, MS SQL Server, Oracle, Informix,

Postgres, S3

Source Code Control: Git, Bitbucket, SourceTree, Visual Studio TFS, Airflow

Certificates: Certified Scrum Master

Contact this candidate