Currently re-architecting a new framework to automate generating checksums of executables on various OS versions (Windows, Linux, MacOS) as well as rewriting Python, Java, C++ and C# utility applications into a portable single application in C. This also requires developing Packer, Ansible and Terraform for Infrastructure as Code and deployment scripts.

City National Bank | Jan 2021 - Jul 2021

Senior Enterprise Data Engineer

- In this role I worked on writing Python and Hive HQL code to load tables from the existing Oracle Data warehouse and Excel spreadsheets into the new Hadoop environment - Oracle Big Data Appliance tables. - Architected the foundational framework of the group's new DevOps practice with Azure DevOps

City National Bank | Jan 2020 - Dec 2020

Senior Dev SQL Server DBA

- Maintained 8 Dev, QA, Test SQL Server instances - Provided support to developers to make database changes - Provided query tuning advisement - Deployed SSIS packages as pipeline jobs in CA DSeries scheduler - Provided DataOps support for migrating code from test through to production readiness - Worked on migrating Digital (online banking) Dev/Test/QA SQL Server databases to Azure SQL databases

City National Bank | Aug 2017 - Dec 2019

Technical Lead

- Architected a design for the Weblogic middleware tier to use failover clustering for redundancy - Worked with the vendor (ClusterSeven) of an End User Computing application for Excel Spreadsheet tracking application to design a server architecture and installed and configured the application - Worked with vendor Informatica to spec out a server configuration and install and configure the Informatica Data Masking application - Migrated over 300 CA DSeries Enterprise job scheduler jobs to a new Windows 2012 server environment - Performed daily guidance to DBA team as acting manager who was on sick leave - Lead the implementation TDE on SQL Server and Oracle with InfoSec and a Security consulting team - Lead Oracle license audit with Oracle reps and CNB legal team - Assisted the Wire Transfer team in resolving an application/OS upgrade issue pertaining the the AIX OS

First Republic Bank | Jun 2016 - Aug 2017

CTR Engineer - Risk and Compliance Technology

• Developed a sophisticated PowerShell script for the new CTR system on Tomcat to initiate, manage and monitor the daily load of four transaction files, and then output the “CTR” report to file with the Federal Government • Integrated and configured the ClusterSeven End User Computing application for tracked and securing corporate Excel Spreadsheet assets

Union Bank | Dec 2014 - May 2016

Lead Middleware Engineer - Fraud and Risk Analysis Systems

• Developed a Perl script to decrypt web traffic data from an application called Silvertail and send the data to Splunk via TCP/IP-REST listener for analysis • Updated a REST client Java code base to fetch customer transaction data from a vendor API update • Modified a Java Excel financial transaction data loader application that converted an Excel file to a CSV file and staged it for loading on the Informatica server into the Oracle Data Warehouse

iSpace | Oct 2014 - Dec 2014

Application Support Engineer contractor for DaVita

• Developed an AIX bash shell script to automatically re-queue failed medical record transactions reducing the reprocessing time from days to under 2 minutes • Created several Splunk queries and dashboard content • Support Engineer for JBoss Fuse ESB, HIE and JCAPS data integration

TEKsystems | Jun 2013 - Oct 2014

Linux Engineer contactor for DirecTV

• Developed a suite of scripts to implement CFEngine to add DevOps control for 5000 RedHat Linux nodes in four data centers across the country. Further, developed automated deployment scripts for 86 tomcat and JBoss java applications. Used GIT as the version control system • Designed and developed a Java v6 JMX metrics monitoring tool in Perl and Java as a “scripted input” data to Splunk. This pulled the same java.lang.* MBean metrics that JConsole accesses from the JVM • Wrote 21 Gomez Synthetic testing scripts to test NFL Sunday customer facing web sites for performance and availability • Created several Gomez web portal metrics dashboards based on the testing scripts output • Wrote a java SOAP client with JAXB and XPath to connect to a .NET SOAP service to the Gomez portal to pull down test metrics to push to Splunk • Developed an NFL “blackout” Java REST client to test if NFL games in specific zip codes were blacked out according to NFL rules and pushed the resulting data to Splunk • Created a Splunk Gomez testing metrics dashboard to display the Gomez metrics in Splunk • Updated existing Splunk JMX monitoring dashboard with metrics from my JMX monitoring tool which gave the NOC more, and accurate JMX data than the native Splunk “JMX4SPLUNK” application

Union Bank | Jun 2007 - May 2013

Senior Middleware Engineer - Fraud and Risk Analysis Systems

- Maintained the code base for AAD – Account Activity Database – an application using MS Access on the front end and Oracle 11 on the back end (analyzing customer wire transactions for the previous monthly period and applying SQL analytics to evaluate customer behavior for possible fraud and money laundering), which ran a monthly data extract of the bank’s financial transactions and analyzed it with a 30,000-line PL/SQL stored procedure. Maintained the Visual Basic front end code base that was used by end users to evaluation the analytical findings - Developed a java application to parse an Excel file of daily transactions, change the format, and sFTP the resultant text file to the Informatica server for ETL loading into the transaction database - Developed an IBM WebSphere MQ Java client to reprocess Wire system transactions that failed - Deployed and Integrated the Actimize Anti-Money Laundering application on Linux and Tomcat - Deployed and Integrated the LEA (Loss Event Application) on Linux and Websphere - Deployed and Integrated IBM OpenPages on Weblogic and Windows 2012 - First person on the team to create an ETL to use XML data with Informatica Power Center

Union Bank | Jun 2005 - Jul 2007

Senior Security Engineer

• Architected and developed an automated system I wrote in bash shell to seamlessly manage AIX, Solaris, and Linux user ID creation, deletion, and modification on over 500 nodes locally from a single management node. This was so effective one could create an ID on one, several, or all 500+ UNIX nodes in minutes. This tool also provisioned security software and set security configuration changes on all nodes. There were 40 automation functions of this tool that I created. The tool was mostly written in bash with a sprinkling of perl and C for a total size of 15,000 lines of code.

City National Bank | Sep 2002 - May 2005

MTS Administrator

• Architected and implemented the conversion of the VMS-VAX MTS (Money Transfer System) to IBM AIX MTS • Designed and implemented a 3 node geographical cluster for MTS with 2 local nodes in Los Angeles and one node in Alameda CA using real time database replication • Implemented an Oracle funds transfer transaction data warehouse with a DR node in Alameda CA • Designed and implemented a Windows 2000 fax server sending approximately 2000 faxes per day, with a DR node in Alameda CA • Designed and implemented IBM TSM (Tivoli Storage Manager) backups for the cluster • Developed several data parsing and data conversion applications on AIX for MTS data transfer interfaces • Implemented 2 AIX SNA Gateways for connectivity to the US Federal Reserve Bank for US Dollar Funds Transfers • Implemented "SWIFTnet" from an 82k X.25 dialup connector to a 40 megabyte, multi-application PKI protected environment using BEA Tuxedo Transaction Manager with a VPN and Dial on Demand TCP/IP connectivity for International non US Dollar Funds Transfers • Developed procedures for day to day operations, administration, troubleshooting, patching and upgrades for the MTS environment • Developed, implemented and tested Disaster Recovery procedures for the MTS system, Fax Server, Oracle database, SNA, SWIFTnet and various network connectivity failover scenarios • Successfully maintained the day to day system administration of the AIX servers, cluster and Windows 2000 Fax Servers • Successfully maintained the day to day application administration of the MTS, 2 - Oracle 9i database instances, fax server software, End of Day Reports reporting tool Cognos Impromptu and SWIFTnet • Successfully developed new AIX software tools and utilities for administration, and interface utilities to the MTS Application in C • Successfully developed new reports and SQL Queries for the Oracle data warehouse • During my tenure I continued the architectural development and refinement of the overall MTS environment

Southwest Systems Integrators | Mar 1996 - Sep 2002

Consultant

Various consultant roles for various clients like DirecTV, Imperial Bank and Edwards Air Force Base to name a few noteworthy clients.

My Education

Take a look at my formal education

Computer SciencePierce College | 1992

About Me

I would certainly like to improve my data analysis and data analytics skills to move from a systems engineer to a BI developer position in something like Data Analytics. I do have past experience in Oracle and SQL Server Administration and SQL.

Create Your Data Portfolio for Free