Database Architect Resume

SKILLS:

Software Development: Scala object - oriented and functional programming API development eclipse, C C++ C# .NET MFC Borland Owl ATL ADO.NET Web Services WSDL

Databases: Cassandra DSE CQL DataStax Studio cqlsh, SQL Server T-SQL SSIS In-Memory OLTP Service Broker SQL Server Agent SSRS, ANSI SQL XML XSD XQuery/XPath JSON Crystal Reports BusinessObjects WSDL

ER/Studio Redgate tools: Relational/dimensional modeling conceptual/logical/physical modeling DDL/DML query performance tuning ETL

Knowledgeable/Some Experience: Java JVM Spark Azure Cosmos DB Oracle data warehousing ASP.NET MVC concurrent programming MDM

Special Skills: Technical document and article writing Excellent verbal and written communication PowerPoint and Visio presentations Agile/Scrum Jira Teaching Requirements gathering

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect

Responsibilities:

Paid article writing - see series on Cassandra above
Continued research into Spark, Scala, Cassandra and other technologies

Confidential, CA

Database Designer/Architect

Responsibilities:

Designer/developer of the Listings System.
An OLTP database system for tracking listings by realtors, city-states, price histories and other.
Written both in relational and NoSQL databases.
Developed my unique Cassandra design methodology based in relational theory.
Includes attribute closure package in Scala.

Confidential, San Francisco, CA

Database Architect

Responsibilities:

Architect/developer of the Email Marketing system.
The extensible software supports YP customers with summary statistics over all their advertising campaigns.
Architect/developer of the Job Monitor system for tracking and coordinating progress and error conditions for scheduled jobs on multiple servers.
Designed and developed an experimental Scala library for evaluating combinations of advertising packages.
Reworked database ETL flow with a custom triggering system to limit data transfer to current changes.

Environment: SQL Server, Scala, ETL systems in SSIS and ad hoc coding, C#, JSON, performance tuning, JIRA, Agile/Scrum

Confidential, Fremont, CA

Database Engineer

Responsibilities:

Data architect on a team developing the next-generation Referral Tracking System (RTS), a complex, n-tier system managing cross-selling throughout the company.
Architect/developer of the GAL Refactor , a subsystem that found customer identity issues as part of a company-wide master data management (MDM) project.
Architect of the Mirror-Delta technique for optimizing ETL data flows, a department standard.

Environment: SQL Server, ETL, SSIS, Replication, MDM, Agile/Scrum

Confidential, San Francisco, CA

Database Engineer

Responsibilities:

Architect/developer of the Paris Engine (PE), a database application for all customer-side generic drug sales rebates.
This app is at the heart of promotional accounting.
Architect/developer of Ival/PPA, a database application that generates into other databases all data needed for time interval rectification, archiving and prior period adjustment statistics.
Architect/developer of the Service Broker Framework (SBF), my third generic system that abstracts out almost all Service Broker plumbing to allow the user to focus on message handling.
Architect/developer on the WAVE waiver program, a package used by Confidential sales personnel to propose, validate, and authorize or deny waiver applications.
Designer of the initial bus matrix and schema for the departmental Data Warehouse.

Environment: SQL Server, Service Broker for multithreading and inter-process communication, Data Reports in SSRS and ad hoc

Confidential

Software Architect/Developer

Responsibilities:

Designer and chief developer of the County Recorder’s Package, a three-tier distributed system that performs major accounting tasks for county-level clerk recorder’s offices.
Tasks include collection of fees for all mortgage-related work as well as Vitals and does periodic reporting.

Environment: C++, ATL Templates, SQL Server, Crystal Reports, GUI, WSDL, multithreading

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship