Sql Server Data

EMPHASIS

RDMBS Development and Administration, Data Warehouse Development, SQL Scripting, Stored Procedures, Functions, Triggers, Process Analysis and Automation.

SKILLS

•MS SQL Server/T-SQL 17 years

•Perl 17 years

•JavaScript 1 year

•PostgreSQL 1 year

•MS Analysis Server 8 years

Other Skills/Exposure:

DOS/batch, *nix (FreeBSD, Linux), *nix shell scripting, Apache, Nginx, Squid, DNS (Bind/Unbound), LDAP (Slapd), Git, Subversion, Business Objects, Informatica, DB2 (partitioned).

EXPERIENCE

Beacon Hill Technologies @ LexisNexis, Boca Raton, Florida

Perl/JavaScript Developer (October 2015– December 2015)

Developed custom functionality for the in-house ticketing system.

HTML, JavaScript, jQuery, Bootstrap, Perl

Developed custom forms and functionality for an open source ticketing system using Perl (Mason) and JavaScript including jQuery and Bootstrap.

MySQL

Developed queries using DBI (Perl) and REST/AJAX (JavaScript/jQuery).

Designed data models for new databases..

Perl

Developed object oriented scripts for back-end automated ticket processing.

Goal Driven Solutions, Seattle, Washington

Co-Developer (October 2014 – October2015)

Developed next generation web application platform.

PostgreSQL

Designed and developed function performance improvements increasing performance by up to two orders of magnitude.

Designed and developed a flexible application permissions system to allow application specific permissions to be data driven.

Developed binary tree and directed acyclic graph (DAG) systems.

NodeJS

Designed and developed Open ID Connection (OIDC) via anvil connect module. Required forking of several node modules to achieve desired platform functionality.

Implemented logging via Winston module. Required forking of Winston itself and a couple third-party transports.

Experis, LLC (formerly Comsys) @ Microsoft, Bellevue, Washington

System Analyst III (June 2010 – October 2014)

Developed and Administered ETL/Datamart database.

SQL Server

•Developed an end-to-end ETL solution using T-SQL to extract data from multiple sources including Analysis Server, SQL Server, and CVS files.

•Designed and developed system so that data is ultimately transformed into a single data-mart table for each downstream consumer.

•Designed and developed the system so that individual fact and dimension tables are also available to data consumers.

SQL Server, Perl, MSBatch

•Designed and developed daily automated backups, index maintenance, integrity checks, blocking alerts, space usage logging, and data collection.

•Developed web-based (SVG) graphic of daily auto-mated job status.

Expedia, Inc., Bellevue, Washington

Senior Data Warehouse Support Analyst (December 2005 – May 2010)

Data Warehouse planning, operations, and support.

SQL Server, Informatica, Business Objects

Planed for on-going and project resource needs.

Monitored and corrected daily issues in enterprise ETL system.

Worked daily with development team to design and develop corrective and new functionality.

Often my designs and code were deployed directly without further modification by development team.

Administered Data Warehouse applications.

Perl, DOS/NTBatch

Developed automated job monitoring scripts.

Bastyr University, Kenmore, Washington

Senior Database Analyst (March 2003 – October 2005)

Database administration, data modeling/database design, data analysis.

SQL Server, MS Access, Perl

•Designed and developed multiple databases.

•Developed front-end applications using MS Access.

•Implemented multiple warm-standby servers for mission-critical data.

•Designed and developed database backup plan including SMTP e-mail alerts.

Electronic Evidence Discovery, Seattle, Washington

Database Administrator/Analyst (August 2001 – May 2002)

Disaster recovery, ad-hoc queries, and ASP/HTML coding.

SQL Server, Perl, ASP

•Implemented warm-standby server for all production SQL servers.

•Designed and developed stored procedures for routine data maintenance.

•Developed T-SQL and ASP code to modify and add functionality per client requests.

Saltmine, Inc. @ Microsoft, Redmond, Washington

System Analyst III (December 2000 – June 2001)

Trouble-shot and corrected day-to-day SQL and Perl processing problems.

SQL Server

•Provided Tier 3 support for the MSN Search Testing Group.

•Used knowledge of Perl and SQL to resolve data loading problems.

BEST Consulting, Kirkland, Washington

SQL Developer/DBA (June 2000 – October 2000)

Responsible for all database development of e-commerce systems.

SQL Server

•Development Lead and sole SQL developer on multiple projects

•Used ERWin for logical and physical modeling

Volt @ Microsoft, Corp., Redmond, Washington

Data Analyst (November 1998 – June 2000)

Designed, developed, and deployed ETL processes.

SQL Server, Perl, DOS/NTBatch, Data Junction

•Designed and developed a batch job control and monitoring environment for automated ETL processing:

•Designed and developed an API for rapid implementation and deployment of new jobs.

•Designed and developed a meta-data repository accessible through API.

•Developed ETL jobs using the job control API to extract and convert data from customer feeds and load into in-house data store.

TLH Abatement, Inc., Seattle, Washington

Access Programmer (July 1996 – October 1998)

Full life cycle development of a job tracking and control application.

MS Access

•Solely responsible for software development life-cycle (SDLC)

•Specification discovery, analysis, and revision.

•Development, QA, and sign-off.

Contact this candidate