Sign in

Data Analyst

Aliso Viejo, CA
December 27, 2019

Contact this candidate



Aliso Viejo, CA

Cell: 626-***-****



IT professional with many years of industry experience with emphasis on administration and application development.

Experience administrator in 24/7 OLTP support and data warehouse database development


Databases: ORACLE 8i/10g/11g/12, MySQL 5.6/5.7, SQL Server 2005/2008/2012/2014, Postgres 9./10/11, Teradata

Tools: Red Hat Enterprise Linux, Oracle Grid Control, Oracle EM RAC, Export/Import, SQL Loader, SQLPlus, SAS, Pentaho 4.4.4, Visual Sourcesafe, Git, SQL Developer, MS Visio/Excel/Access, Toad DM, PgAdmin4, SqlYog, AWS, Navicat DM, gh-ost version 1.0.48, pt-table- sync version 3.0.11, percona xtrabackup, SSMS, SSIS/SSRS, AWS Rds Languages: SQL,PLSQL, Visual Basic 6.0, Perl, TCL scripting, C Shell, Java, C++/C, Bash shell scripting, Python3


2019- Present ACORNS, Irvine, CA

Database Administrator

Maintain 24/7 high availability application utilizing AWS architecture

Support over 50 Postgres databases and 10 Dynamodb databases 2014- 2019 INTERNET BRANDS, El Segundo, CA

Database Administrator

Maintained 24/7 high availability internet sites for IB including Fodors, DemandForce and WebMD

Troubleshoot and test disaster recovery planning

Migrated Mysql, Postgres, Mssql Server databases across data centers

Designed and scaled database backups, schemas, tables, indexes, users

Configured database processes, setup databases for test and production

Developed and designed ETL processes using SSIS packages

Worked with developers on performance tuning, store procedures

Developed data analysis TSQL/SQL to support dev projects

Experienced in working with high volume transactional databases on Linux/Windows

Implemented high availability solutions including clustering 2014 – 2014 KAISER PERMANENTE, Pasadena, CA

Technical Specialist

Extracted data from Clarity, HealthConnect production server

Worked with database team on ETL refresh processing

Worked with statisticians using SAS to report on diabetes population 2009 – 2014 KAISER PERMANENTE, Pharmacy Analytical Srvs, Downey, CA Data Consultant

Maintained 24/7 production application support for Pharmacy Online Interactive Tools (POINT) on data warehouse and OLTP side

Designed and maintained a Medicare supported application call Pharmacy Outpatient Pricing System (POPS) for national drug pricing

Designed and implemented database SOX requirement for the PSOS CM/CA Point tools for national compliance

2003 – 2009 KAISER PERMANENTE, Pharmacy Analytical Srvs, Downey, CA Senior Data Analyst

Manipulated and summarized large data sets for batch processing using Oracle 8i,10g, and 11g

Explained root cause, business processes using Remedy and track internal issues through Issue Manager

Designed ETL process using external tables for populating data marts

Extracted, loaded and maintained quality assurance for the membership data for the UCLA group for various sources

Asserted best practices in ETL transfer of information, data modeling

Provided technical guidance to junior developers to ensure standards are met for complex applications

2000 - 2002 SUNRISE TELECOM, INC., San Jose, CA

Software Engineer

Converted VoIPExplorer application database queries from MS Access to Oracle

Developed a graphical user interface for the Voice over IP application using Java with JDK 1.3 for VOIP simulation testing EDUCATION:

02/07 – 02/07 Oracle Database 10g Administrator Certified Professional 08/97 – 05/00 Bachelor of Science in Computer Science University of Kansas

Contact this candidate