James V. Kraxberger

P.O. Box ****

Laguna Hills, California 92654

Phone: 949-***-****

E-mail: ad0dkn@r.postjobfree.com

Highlights

Multiple industry experience designing, developing and supporting various database applications including:

oAzure/Snowflake data warehousing using Matillion ETL

oPython, Matillion, Alation, Azure DevOps

oAzure AZ-900 Certification

oSQL Server SSMS/SSIS/SSRS (2019/2017/2016/2014/2012/2008/2005/2000/7)

oOLTP to ODS/Data Warehouse ETL architecture, design, mapping and processing

oDell Boomi ETL Cloud Atmosphere development with On-Premise Atom deployment

oSSRS reporting

Willing to lead projects at all levels from conception thru implementation.

Enjoys working with and mentoring others in computer technology.

Experience

SchoolsFirst Federal Credit Union Tustin, California

Database Engineer June 2016 to Present

Develop, document and maintain Azure/Snowflake data warehouse for Share and Loan data analysis using Matillion ETL

oCopy On-premise files to Azure BLOB via Boomi

oETL Azure BLOB to Snowflake Staging to ODS layer via Matillion

oETL Snowflake ODS to Data Warehouse via Matillion

oSnowflake ODS/Data Warehouse to Data Mart via abstract table views

oSecurity via role-based access

oDesign and maintain ODS/Data Warehouse/Mart data models via SqlDBM

Developed Python routines to conduct file cleansing/data quality, MelissaData email verification and website comment sentiment analysis (NLTK)

Implemented data quality standards along with Matillion/Snowflake data quality checking/reporting system

Orchestrate Snowflake ETL processing using Matillion

Developed Dell Boomi processes for deployment within on premise Atom

Deployed standardized library database containing corporate Calendars, common lookup tables/functions

Scaled out single to multiple test environments with databases/SSIS/SSRS variable pointers

Designed and developed SQL Server SSIS 2008R2 packages for file import/export/secured ftp.

Refactored existing ATM/POS transaction data ETL routines to parse and store EMV token data.

Designed SQL Server 2016 ODS automated monthly period data partition truncation routine.

Designed 256 asymmetric salted key tokenizer replacing PAN ClearText values with tokenized last 4 digits

Troubleshoot and debug ProActive Risk Manager 7.1/8.6 database issues.

Created backup copy of production PRM 7.1 historical data on separate server for SSRS reporting.

Provide on-call database production system support.

Perform monthly database re-indexing of SQL Server databases using Ola Hallengren solution

Conducted Business Analyst SQL Introduction training sessions.

iBASEt Foothill Ranch, California

Senior SQL Server Database Developer November 2014 to May 2016

Maintained multi-branch ER Diagrams (logical and physical) for both SQL Server 2012 and Oracle 12c using Embarcadero ER/Studio Data Architect with .Git versioning and JIRA project tracking.

Review SQL Coding for performance and optimize for SET-based vs. ROW-based processing.

Troubleshooted SQL Server 2008/2008R2/2012 performance issues using SQL Diagnostic Manager.

Converted Perl CLI Oracle database installer Flexera InstallAnywhere custom database installer project for multi-software package SQL Server / Oracle / Cognos database installations in customer environments.

Conducted training sessions SET-based vs. ROW-based design and coding changes.

NCR Aliso Viejo, California

Senior Database Administrator January 2014 to November 2014

Administrate over 100 SQL Server database servers (SQL Server 2012 SP1, 2008 R2 SP1, 2005 SP4, 2000 SP4).

oMaintain daily backup job checks using custom written VB.Net tool to scan all completed jobs for errors.

oUse Idera SQLsafe to compress/encrypt database backups.

oBuild clustered SQL Server 2012 SP1/2008 R2 SP1 SQL Servers with SSIS/SSAS/SSRS.

oManage SQL 2000 legacy database servers (backups, index rebuilds, checkdb).

Glidewell Laboratories Newport Beach, California

Data Architect August 2011 to January 2014

Designed and maintained SQL Server 2005 ODS ETL data feeds and 2008 OLAP Cube for historical data reporting across 12 facilities spanning 4 states and two countries with UTC date tracking using Kimball Enterprise Data Warehouse Bus Architecture.

oDesigned location-separated, AsOfDate-driven ETL for multiple location Tooth Milling XML data capture into an ODS for 3 milling locations with stale data feed identification.

oDesigned Milling ETL from ODS into Dundas Dashboard backend database.

oDesigned Human Resources ETL from Microsoft Great Plains into ODS.

oDesigned import FedEx ETL for storing delivery data into ODS with conforming address dictionary lookup logic to provide inbound package visibility to production managers.

oDesigned weekly SSIS ETL to export previous week’s dental lab order product shipments to 3rd party carrier data consolidator with subsequent week SSIS ETL import of multiple carrier invoice data into ODS for logistical analysis and reconcile of carrier rate and shipping charges.

Maintained SSAS cubes aggregations.

Optimized stored procedures from RBAR into set-based solutions saving hours of process time.

Maintained, reviewed and enforced corporate SQL Development Standards stored in SQL Wiki website.

Developed C# / RedGate SQLCompare API Winform application to detect enterprise database DDL object differences between source location and all remote locations.

Guthy Renker Fulfillment Services Foothill Ranch, California

Senior Database Administrator/Architect May 2005 to August 2011

Administrated over 320 SQL Server 2005/2000 corporate databases (4 TB+) across 14 servers with ongoing database conversions onto 2 EMC Clarion 12 TB SANs in California and North Carolina.

Optimized and tuned SQL performance for all SQL objects.

Developed SSIS packages for loading ad hoc data into BizTalk 2006 R2 transactional databases.

Transactionally replicated common lookup database data to three OLTP databases.

Setup high-performance mode database mirroring between production and BI ETL staging server.

Monitored and maintained multiple BizTalk 2006 R2 database environments for 3 applications.

Developed, maintained and enforced corporate SQL Development Standards.

Designed backup/purge strategy using Microsoft SQL Server and scheduled C# purge routine.

Administrated and maintained Production and Development SSRS instances.

Managed multiple, successful 32 to 64-bit SQL 2000 to 2005 SP2 Enterprise conversion projects.

Implemented secure zone, synchronous credit card encryption for PCI data security compliance.

Developed row-level auditing for tracking inserts, updates and deletes into data warehouse.

Developed abstraction layer support for legacy database structures with automated regeneration.

Developed SQL Data Dictionary for data warehousing ETL analysis.

Superior Communications Irwindale, California

Sr. Applications Manager April 2000 to May 2005

Managed staff of 2 (plus external contractors) and co-developed successful launch of both SSL-secured, in-frame B2C commerce telephone accessory website for www.BellSouth.com and subsequent website makeover for coordinated corporate launch of www.cingular.com (att.com).

Developed and administrated 6 production and 6 test SQL Server 2000 corporate databases.

oDesigned business logical schemas using triggers, functions and stored procedures.

oMaintained scheduled/ on-demand data feeds for commerce websites, intranet financial reporting and ad hoc analytical queries using DTS/T-SQL/ODBC/C#/VB/ADO/XML.

oWorked with users and groups to determine and enforce database security.

oDefined, designed and implemented corporate database backup/recovery procedures.

Architected VB.Net merged inventory label Bill of Materials (BOM) solution for printing item/customer-specific UPC, Country of Origin, SRP and phone-accessory compatibility data.

Architected Access VBA Phone-to-product compatibility tracking system.

Architected Access VBA Price List system that extracted Microsoft NAV ERP item unit prices, applied tiered/customer contractual group/item discounts via pricing rule engine, printed price lists and uploaded data to ERP for Sales Order Entry line-item pricing by customer-linked price list.

Warner Bros. Burbank, California

Senior Programmer Analyst August 1994 to April 2000

Team-developed client-server PowerBuilder 7/Oracle 8 theatrical sales system and integrated same to mainframe advertising and multiple external partner data systems.

Architected mainframe and MS Access VBA/ADO advertising system for budgeting, tracking, and billing newspaper/radio advertising campaigns.

Architected MS Access VBA/ADO publicity system for tracking movie premiere attendance.

Acted as FTP Technical Liaison between advertising/graphics departments and external advertising agency for distributing theatrical newspaper advertising images over the Internet via secured ftp.

Architected MS Access/Excel/VBA cooperative advertising newspaper entry data warehouse that collected and calculated shared advertising terms and costs for over 300 U.S. newspaper markets.

Jacobs Engineering Group, Inc. Pasadena, California

Business Systems Analyst November 1987 to August 1994

Architected multi-cycle, multiple job site mainframe manual check system.

Architected W-2/1099 TAX reporting systems with IRS transmitter certification.

Refactored project account reporting system for tracking fiscal project gain/loss with ad hoc reporting. Net savings: significantly reduced mainframe process time from 8 hours to 20 minutes.

Jointly maintained mainframe 6-cycle weekly payroll for hourly employees.

Developed curriculum and conducted seminars in introductory computing and electronic mail.

Golden State Sanwa Bank Pico Rivera, California

Senior Report Distribution Clerk (Night Shift) February 1985 to August 1985

Responsible for filling traveler bags with nightly mainframe–generated branch reports (including reprints), verifying individual branch bag report inventory and controlling bag release to morning drivers.

Pulled, decollated and separated multi-part (4/5/6 layer carbon-copy) DDA, Savings and Loan reports for over 30 Northern and Southern California branches.

Printed, burst, folded and envelop-stuffed customer savings statements.

Provided assistance as needed to computer operators and lead check sorter.

Education

DeVRY Institute of Technology City of Industry, California

Bachelor’s Degree in Computer Information Systems, 1984-1987

Certifications

Microsoft AZ-900 Azure Fundamentals (2020), ITIL Foundation Examination (2011)

Skills

Methodologies: Agile/Scrum, ORM (Object Role Modeling), Kimball (Data Warehousing).

Databases: Microsoft SQL Server 2016/2014/2012/2008/2005/2000/7, Oracle 8/7.3, Computer Associates IDMS 12/10.2, IBM DB2

Languages: T-SQL, C#, Python, XML, Oracle PL/SQL, Perl, Java, JavaScript, VB.Net, Visual Basic 6, Access 2.0-2016 (VBA/ADO/COM), ASP, IBM OS/JCL/COBOL II/74/68, Computer Associates IDMS/R+ADS/O, Sybase PowerBuilder, C/C++

Applications: Microsoft VS/TFS 2015/2013, CozyRoc SSIS+, Tableau 10.3, Splunk, Microsoft BizTalk 2006 R2, Idera Diagnostic Manager/SQLsafe, Dell Toad for SQL Server/Spotlight for SQL Server, Embarcadero ER/Studio Data Architect and DBArtisan 8.1, Red Gate SQL/Data Compare + SDK, Microsoft Office/Navision, Adobe Photoshop CS6/5.5

Contact this candidate