SUMMARY

• Innovative, collaborative, and dedicated IT professional with more than 30 years of experience in creating unique technical solutions to challenging business opportunities.
• Leads the design and development of data driven applications and data warehouses.
• Enables software developers to take ownership of their data layer through mentoring relationships while providing a documented data architecture including logical / physical data models, data dictionaries, and data lineage diagrams. Implements cloud and on premise data platform infrastructure. Secures data assets by script based administration and an operations focused architecture.
• Thrives on interacting with all levels of the business and end users to elicit their needs and truly understand how to help them be successful and meet stakeholder and customer expectations.
• Recognized as a researcher and tenacious problem solver skilled at taking complex issues and breaking them into understandable and executable tasks while teaching others and helping them to learn and grow in their own roles.

AREAS OF EXPERTISE

• Microsoft SQL Server Google Big Query
• Confidential Redshift Confidential Web Services (AWS)
• Data Modeling - Dimensional, Relational, NoSQL, Data Vault Eliciting Stakeholder Needs
• Data Warehousing (ETL) Data Wrangling
• Transactional Data Application Development Data Governance
• Database Design Data Analysis
• Database Administration Data Visualization
• Salesforce Integration Agile Practices
• Programming Languages and Frameworks Internet Integrations
• Analytical Problem Solving Analysis of Infrastructure
• Excellent Communication Skills Strong Customer Service Skills

TECHNICAL SKILLS

• SCRUM/Agile, Waterfall, Method/1
• Google Big Query Google AdWords YouTube
• Salesforce Google Analytics Bing Ads
• Facebook Ads Facebook Pages Apex (Chat)
• Lamark (email) Vendasta (Directory Listings) gShift (SEO)
• Confidential Redshift Confidential Web Services (AWS) Google Big Query
• Dimensional Modeling E/R Studio Relational Modeling
• Data Vault Modeling NoSQL Modeling MS SQL
• Visual Paradigm Aqua Data Studio Architectural Design
• T-SQL SQL Profiler SSMS
• DTS Query Analyzer SSRS
• DBCC SSIS XML
• Git DMV/DMF Performance Tuning
• C# Visual Studio.NET TFS
• Lotus Notes Visio Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, TEMPE, AZ

Data Engineer

Responsibilities:

• Worked as the sole Data Engineer within the Brand Services Program to design and build a new data warehouse based on internal Confidential ETL tools and the AWS/Redshift data platform.
• Documented existing data pipelines supporting brand health metrics reporting for brand owners on the Confidential site using Visual Paradigm and Aqua Data Studio.
• Wrangled twenty four inconsistent internal data sources ranging up to 750 Tb in size with volatile delivery mechanisms to provide a single integrated source of truth for Brand Program reporting and analysis.
• Optimized Redshift database performance evaluating query plans, manipulating distribution and sort settings, and refactoring queries to take advantage of Redshift’s column store architecture.
• Managed three Redshift clusters including one I provisioned to support a production data warehouse.
• Implemented source control for data assets and standardized data development and deployment processes.

Confidential, PHOENIX, AZ

Enterprise Data Architect

Responsibilities:

• Built a team to support an enterprise data warehouse that is transitioning at the end of 2018 due to the sale of a sister company
• Integrated Big Data / NoSQL (Google Big Query) with the enterprise data warehouse, loading key dimensional data into SQL server, allowing for support of change tracking, high velocity data loading, and point in time reporting while minimizing the need to move large amounts of data
• Enabled collaboration as a liaison between the business and technologies, created and managed enterprise wide business domain model, developed database design and architecture documentation in MS Visio and E/R Studio for the development, management, and executive teams, helped set the vision for the future of Business Intelligence, and mentored business users on how to leverage the data to impact business outcomes
• Supported product development teams by identifying, evaluating, and onboarding data sources (Instagram, YouTube, Google My Business, etc.), and researched, documented, and tracked data source API versions (Salesforce, Google Analytics, Facebook, Bing Ads, Google AdWords, etc.) to allow for planning updates and constructing migration plans
• Reduced cost in the SDLC by implementing a Kimball design pattern using Data Vault as a persistent staging area (PSA) to support slowly changing dimensions and compliance requirements; combined with a bottom up approach to allow for incremental build out, easy business rules change management, quick implementation, and early data acquisition
• Optimized SQL (MS SQL 2014) database performance using query optimization, model refactoring, index management, and system configuration
• Provided insight into suggestions for changing database storage and utilization requirements; analyzed database implementation methods to assure they were in alignment with technical best practices, company policy, and external regulations (SOX, Basil II/III)

Database Architect/DBA

Confidential

Responsibilities:

• Developed a proprietary transactional application designed to manage pay per click (PPC) digital marketing accounts, campaigns, and advertising asset inventory; utilized integrations with Google AdWords, Bing Ads, and Salesforce as the foundation of the application
• Architected and implemented mission critical, high performance transactional Microsoft SQL databases primarily leveraging Microsoft SQL (2012) and C# .Net; championed documentation and standardization of development best practices
• Contributed to a cross-functional team in charge of delivering new features and capabilities on an iterative basis, actively participated in risk management, planning, and scoping of projects, and participated in code and documentation reviews throughout the iteration
• Performed SQL (2012, 2014) Database Administration for very large (500GB+) databases in a clustered environment, created and managed scheduled maintenance plans including backups and indexing, collaborated with Systems Architects to proactively design and optimize databases and their underlying hardware and OS platforms to meet future capacity planning needs in a high growth environment
• Implemented Database source code management and Unit testing (tSQLt) using Visual Studio and Git
• Developed high performance queries accessing tables with 500M+ rows using DML & DDL T-SQL statements, stored procedures, triggers, user defined functions, etc.

Confidential, ARIZONA, PHOENIX, AZ

Data Services Team Lead

Responsibilities:

• Led a team of four Enterprise DBAs and six ETL Developers supporting over 160 SQL instances processing structured, semi-structured, and unstructured data files from thousands of data sources daily
• Provided leadership as the Chairperson of the SQL Guidance and Education Committee resulting in acceptance of the first set of Enterprise SQL Standards and Guidelines
• Represented the team in corporate planning and budgeting processes; served as a SME for the BCBSAZ Business Intelligence infrastructure and ETL processes
• Selected as the DBA team member to work directly with web, business, and ETL development teams to produce consistent standardized SQL solutions reducing total cost of ownership; optimization efforts resulted in deferment of an expected hardware update saving over $100,000 within the first few months of effort
• Developed and supported a large library of ETL processes utilizing DTS, SSIS, T-SQL, SQL Agent, and Active Batch for multiple large data marts
• Consulted with application developers to insure optimal usage of SQL resources and T-SQL best practices; facilitated implementation of SQL Standards and Guidelines for ETL and OLTP Application interfaces
• Developed tools to automate standard administrative tasks and monitor performance statistics; monitored performance and drafted recommendations for application optimization

Confidential, PHOENIX, AZ

Database Migration Consultant

Responsibilities:

• Short-term contract migrating from SQL 6.5 to SQL 2005 updating data structures, T-SQL, agent jobs, and DTS packages to continue availability after conversion to SQL 2005; trained internal developers in standards and best practices for SQL 2005
• Short-term project at franchise headquarters to consolidate data from over 250 independent point-of-sale systems to facilitate corporate reporting
• Administered two instances of SQL Server 2008 and six instances of SQL Server 2005 with over 100 SQL databases ranging in size from 10 MB to 200 GB for package applications; optimized SQL performance by re-engineering stored procedures, creating data archive processes, and implementing appropriate indexing
• Designed conceptual, logical, and physical data models; addressed validation, clean up, and mapping issues for ETL processing of inconsistent source data with minimal relational integrity; developed and deployed reports in SQL Server Reporting Services (SSRS) 2008; implemented release management standards, mitigating migration impacts

Confidential, PHOENIX, AZ

Database Architect

Responsibilities:

• Provided System Administration, Architecture, and Database Development services to successfully support several SaaS offerings focused on identity theft, background checks, and fraud prevention
• Elicited and documented business data requirements; designed conceptual, logical, and physical data models; communicated expectations and dependencies to project managers; mentored programmers to develop relational database design and SQL development skills; supported the production environment on a 24/7 basis
• Administered ten instances of SQL Server with over 200 SQL databases ranging in size from 10MB to 60GB for a suite of internally developed Windows and web-based business applications; monitored SQL Server and database performance and availability by utilizing tools such as Performance Monitor (PerfMon), SQL Profiler, the Database Consistency Checker (DBCC), and Dynamic Management Views and Functions (DMV/DMF); optimized SQL performance by re-engineering stored procedures, creating data archive processes, and implementing appropriate indices

Confidential, PHOENIX, AZ

Lead Analyst / Development DBA

Responsibilities:

• Designed, built, implemented, and supported SQL databases for high traffic consumer website generating more than $8M per day; product included very large (100+ GB) primary database and several smaller ancillary databases
• Database Architect, Administrator, and Senior SQL Programmer for large team of application programmers, mentoring SQL skills while lending expertise to the ongoing development efforts
• Monitored database and application performance and exception handling; reported and recommended solutions for system enhancements based on results
• Provided full range of database design, architecture, and administration for clients on a contract basis, including developing vertical market applications using n-tier architecture with .Net Framework and Visual Studio, creating MDI WinForms applications with advanced features, and extending Microsoft and third-party control libraries to deliver advanced features

Confidential, PHOENIX, AZ

Lead Software Specialist

Responsibilities:

• Led team in defining, architecting, and building multiple applications to support global project management practices and standards; served as Project Manager and Architect of n-tier intranet solutions for end to end project management utilizing Microsoft’s .NET architecture with an MS SQL 2000 data tier; designed data model and architecture to integrate globally distributed information from DB2, MS-SQL, and Lotus Notes into a single central MS-SQL-based repository for reporting of Technologies Department’s time and billing information
• Negotiated contract terms and cost reductions with external resource providers and vendors to mitigate project risk; managed project expectations, issues, risk, and change control to obtain excellent results in project cost, scope, and schedule dimensions
• Architected and developed project management system integrating Lotus Notes and DB2 data; additional Lotus Notes-based solutions included tracking, broadcast, and workflow applications