Objective

• To obtain a position where I can provide business enhancing, data - centered expertise in an environment that both leverages my existing skills and challenges me to acquire new ones.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Data Architect

Responsibilities:

• Designed, architected and built company’s first ever data warehouse in Amazon AWS Redshift and S3 using FiveTran and dbt
• Oversaw business and BI team transition from reporting off of raw data sources directly to Looker reports pointing to data warehouse
• Optimized SQL within data warehouse ETL and Looker
• Passed dbt Analytics Engineering Certification exam from dbt Labs and am now a dbt Certified Developer

Confidential, Atlanta, GA

Senior Data Architect

Responsibilities:

• Designed and directed construction of a replacement data warehouse as part of business wide systems overhaul
• Full agile, continuous integration process designed and implemented using Redgate tools and SQL Server and PowerShell scripts
• Served as technical lead acting as bridge to the business for multiple projects outside the data warehouse
• Warehouse implemented with star schema rolled up to SSAS (SQL Server Analysis Services) cubes with additional functionality coded in MDX, Reporting in Tableau

Confidential, Detroit, MI

Remote Power BI Subcontractor

Responsibilities:

• Designing and implementing data models and Power BI datasets for several clients using Dynamics CRM, Dynamics GP, and Dynamics 365
• Creating Power BI reports and dashboards
• Developing complex visualizations using DAX functions

Confidential, Atlanta, GA

Senior Data Architect

Responsibilities:

• Implemented “data vault” data warehouse for mainline application
• Implemented data access/storage layer for views and stored procedures
• ETL framework design/implementation for data loading with SSIS

Confidential, Atlanta, GA

Senior Database Developer, Data Warehouse Team Lead

Responsibilities:

• Gathered requirements, designed, developed POC and Phase I of an Enterprise Data Warehouse to replace the previous DW which was at end of life.
• Responsibilities included end to end, business analysis, SSIS, ETL, T-SQL
• PowerShell, SQL Server relational and SSAS databases/cubes with MDX as well as logging, scheduling framework.
• Wide ranging business problems and technical challenges successfully solved and met throughout.

Confidential, Atlanta, GA

Senior SQL Developer, Team Lead, Manager Database Development

Responsibilities:

• Designed and implemented custom, partition by partition, defrag process for 1.5 Terabyte table with 800 million rows.
• Architect for numerous expansions of existing system integrating with Google, Facebook, Bing and other search engines.
• Designed and implemented continuous integration database build process with auto-generated release scripts using TeamCity and Redgate tools.
• Saved many hundreds of man hours over the past two years and allowed us to go to a weekly release schedule.
• Lead Architect of an 18-month overhaul of a system designed to support gigabytes of data into one scalable to 100s of terabytes.
• Successfully prototyped and implemented a Service Broker messaging system to integrate the database layer into the new architecture.
• Designed a database build system that could handle localized development for groups in US, Europe, and China but still allow for unified QA build for weekly release testing.
• Created new and modified existing advanced T-SQL and SSIS processes for analysis of datasets in the millions of records.
• Performance tuning of jobs and complex queries.

Confidential, Dallas, TX

Senior SQL Developer

Responsibilities:

• Administered development/staging/production environments for 5 clustered servers, 80 databases, including a SSIS/SSRS Business Intelligence dashboard/data warehouse.
• Tasked with implemented performance, maintenance, and disaster recovery plans as well as long range planning and design of systems in support of business goals.

Confidential, Las Colinas, TX

Senior SQL Designer/Developer

Responsibilities:

• Lead engineer for migrating data during business system replacement.
• Designed and developed ETL process to migrate 50 GB of data from legacy system to Microsoft CRM.
• Documented and implemented business logic and rules by converting them to T-SQL scripts and SSIS packages.
• Oversaw validation, audit and final acceptance of data conversion.

Confidential, Dallas, TX

Senior Data Engineer

Responsibilities:

• Led database architecture and design for new website based on SQL Server 2005.
• Used transactional replication to allow for scale out for large numbers of users.
• Implemented new messaging and rating system from design to development to deployment.

Confidential, Richardson, TX

Senior Data Engineer

Responsibilities:

• Led data team that designed and built a complete Sales/CRM replacement for 300 users.
• Responsible for schema and all advanced T-SQL.
• Heavily used 2005 features including Service Broker, SSIS, CTEs, CLR, windowing functions, encryption, schema, and Reporting Services.

Confidential, Troy, MI

Lead Database Consultant

Responsibilities:

• Led development team on multiple client projects that used SQL 7.0/2000/2005/2008
• Fundraising information subscription website, www. Confidential .com, based on ASP, ASP.NET and SQL Server.
• Complete cycle of database design, implementation, and iterative improvements.
• The Legal Services Plan of the United Auto Workers based on ASP and SQL Server.
• Complete cycle of database design, implementation, and iterative improvements.
• Custom replication application.