Data Architect

Did this work during my tenure at HomeNet Automotive, Division of AutoTrader.com.

Description:
At the core, HomeNet is a data conduit for our customers. We move data quickly, reliably, and accurately to be a partner in their success. The data architect at HomeNet serves to manage that conduit and ensure it exceeds its potential. The data architect should find him or herself aligned with HomeNet strategic goals in becoming the platform of choice for both the AutoTrader Group and the automotive industry as a whole.

Strategic Objectives:
● Provide a strong voice and vision for data architecture and design.
● Develop and maintain data management standards and conventions, data element naming standards and metadata standards.
● Provide data oriented technical leadership and guidance to Development staff.
● Work with Development, DBA, IT and Product teams to meet HomeNet’s strategic goals.
● Evaluate new data oriented technologies and techniques to add value to HomeNet.
● Act as a hybrid architect, consultant, troubleshooter, developer and ETL expert.
● Be accountable to overall system health and all data centric projects.

Day-to-Day Responsibilities:
● Design and implement data models to support business needs.
● Translate requirements into procedural code: t-sql, stored procedures, SSIS, SSRS, SSAS, or other data centric technologies as required.
● Actively assist in the troubleshooting of HomeNet’s non-t-sql codebases (C#, Ruby, Etc.).
● Conduct data centric requirements gathering, design sessions and technical reviews.
● Establish automated methods and procedures for tracking data quality.
● Maintain optimal quality, health and configuration of data related systems.
● Act as a mentor, leader and advocate for data management and data personnel.
● Ensure short-term tactical solutions are aligned with long-term strategic data objectives.
● Provide advanced support to assist in the research and solution of data issues.
● Interface with external and internal support teams to ensure optimal system health of IOL.

Skills and Qualifications:
• Extensive experience with Microsoft SQL Server (2008+ preferred) database development.
• Excellent physical, logical and conceptual data modeling, analysis and mapping skills.
• Ability to manage, balance and prioritize multiple concurrent projects effectively.
• Excellent communication, facilitation and presentation skills, both written and verbal required and ability to work with all levels of personnel is required.
• Strong team work and collaboration skills.
• Mentor and lead other team members regarding best practices and established patterns.
• Should be able to resolve most technical issues with a minimum of help.
• Familiarity with performance tuning techniques at all application levels.
• Bachelor’s Degree in an Information Technology field.
• 8-10 years of experience in database development and data architecture.

Lead SQL Server Database Engineer

Did this work during my tenure at HomeNet Automotive, Division of AutoTrader.com.

• Collaborate with architecture/development teams to design and build scalable solutions
• Mentor and lead other team members regarding best practices and established patterns
• Assist in the definition and implementation of database standards.
• Work with various teams in order to troubleshoot and resolve production support issues.
• Work with Product Development, implementation teams and other customer facing teams, to analyze and decompose functional requirements into proper tasks.
• Ensure other team members are properly focused, efficient and meeting objectives.
• Participate in functional test planning and testing for the assigned application(s), functional area(s) or project(s)
• Share knowledge by effectively documenting work.
• Stay current with changes in the technical area of expertise.
• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Construct data models and database designs while also translating into a physical database design.
• Ensure scheduled updates to VIN data stores are completed successfully
• Develop database procedures, triggers and SQL scripts for development teams.
• Ensure proper reviews are completed when changes are made to application components.
• Should be able to resolve most technical issues with minimum help from other members of team
• Develop and/or maintain DTS/SSIS packages.

Custom Reporting Framework

Did this work during my tenure at The Elite Group.

A custom reporting framework was created for our internal users. The requirement was that they needed access to specific pieces of data on an infrequent basis. Not enough that a full (client facing) report for the front end should be developed, yet more that it couldn’t be handled as an ad-hoc data request.

The framework was written using the MVC3 framework in C#. The meta data was stored in such a way that the site didn’t need to be updated after each report was released. A T-SQL script could be used to push the report, and when the reporting framework loaded, it would detect the new report and present it as an option for the user to run.

TV Advertising Tax Software

Did this work during my tenure at Data Centric Design.

I was approached to assist a client in building a tool to assist with sales tax calculation for advertisements shown on television. This involved querying massive datasets that detail each ordered and shown television advertisement shown in multiple major television markets. Then aggregating the data and allowing custom sales tax profiles to be applied on a per customer basis. Finally, an admin website needed to be built to manage all this information.

EDI Developer

Did this work during my tenure at The Elite Group.

Developed various EDI reports as required. The initial files were generally one-time snapshots of data that would be used to transmit eligibility to various carriers. Since early 2010, most files were ongoing files, that were utilized to free up internal employees to focus on other areas of the application.

DataQualityControl

Did this work during my tenure at The Elite Group.

Coupled with the DataMart I implemented a framework that would automatically check the source data for data quality issues present. These issues were not causing errors in their respective source systems, but would cause issues on the EDI’s being developed.

The DataQualityControl database had a few initial requirements:

  • Speed – It was in the critical path for loading the DataMart, and it needed to get out of the way as quickly as possible.
  • Flexibility – Additional tests would need to be created over time, and be able to be integrated into DataMart as needed.
  • Reporting – There are two types of data recorded. First was an aggregate for historical purposes, and second was a daily log showing that days issues. Thus trends could be displayed over time to show how the errors were being addressed system wide, and the latest example of such an error could be quickly displayed.

All of these were met in the initial pass, and over time additional quality checks were added as the need arose.

DataMart

Did this work during my tenure at The Elite Group.

My initial project at Elite was to build a DataMart as a central repository for future reporting needs. No singular framework existed that could meet the needs of the EDI’s that were expected to be built moving forward.

Over a period of a few weeks, the DataMart was designed and implemented along with a DataQualityControl framework.

Each day, the system loads a snapshot of key fields in the source systems. Over time, this data could be used to meet all reporting needs.