Kevin Sanford
Hiram, GA *****
Cellular 404-***-****
acul9o@r.postjobfree.com
CAREER SUMMARY:
Strong background in all phases of ETL development life cycle including analysis, design, development, coding, testing, quality assurance, implementation and maintenance.
WORK EXPERIENCE:
Cardlytics Atlanta, GA October 2015 – Current
Senior ETL Developer
Projects: ETL Process
Environment: SQL Server 2012, SSIS, Redgate
Responsible for designing and developing ETL packages based on business requirements and service level agreements
Review requirements and contributing to design components of ongoing and upcoming projects and effectively estimating development effort
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Created automated ETL processes to export/ingest between multiple sources and Data Warehouse
Designed and implemented stored procedures, views and other application code objects to aid in complex mappings
Moxie Atlanta, GA May 2014 – October 2015
Senior ETL Developer (Contractor)
Projects: ETL Process
Environment: SQL Server 2012, SQL Server 2008R2, SSIS
Responsible for designing and developing ETL, Reporting and BI Solutions including data analysis, transformations and integration between source applications
Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution
Analyze data content and ensure validity of the data structures in support of the ETL and BI needs
Develop, test and implement program logic along based from translated business requirements into end user applications
Collaborate with Data Analyst to develop data warehouse models, design specifications, metadata process and documentation
Alere Inc. Atlanta, GA June 2008 – May 2014
ETL Developer
Projects: ETL Process
Environment: SQL Server 2008R2, SSIS, SSAS, Data Junction
Create ETL processes for the purpose of loading data for analysis, validation and standardization
Performed key data conversions of internal application, translation and validation for external business partners
Developed new ETL Workflow using SSIS with one overall process for all clients’ sources. This provided the benefit to the company of having to maintain only one process as opposed to having to update 300 separate processes when changes were required
Created Relational Database Structure to underpin the new ETL Process detailed above to contain all client’s configuration information needed to support one overall SSIS workflow
Develop SQL stored procedures in Management Studio using SQL Server 2005/2008 to cleanse and update data. Also perform data analysis/certification using SQL to ensure the results of the transformations are correct per the requirements
Provide support to production to resolve issues when packages fail and implement changes to SSIS packages based on updated requirements
VCG, LLC Roswell, GA September 2005 – June 2008
Data Migration Engineer
Projects: Data Migrations
Database: SQL Server 2000/2005, Oracle 10g, Data Junction, Toad
Define/design the overall conversion tactics and strategy to migrate data
Hands on in developing and testing the data migration processes, resolving issues and leading the Go-Live project
Develop detailed ETL project plans conversion/transformation specifications and data mappings based on requirements
Responsible for analyzing and understanding of relational databases
PRG Schultz Atlanta, GA March 2002– September 2005
Business Information Analyst
Projects: PRG Audits
Environment: SQL Server, Microsoft Access 97/2000, AS/400, Data Junction, NT Tool Build
Responsible for working with large amounts of raw data converting to SQL 2000
Created Project Tracking Reports using Microsoft Access and SQL 2000
Provided complex SQL scripts to assist in data manipulationfor auditors to write claims.
Developed and maintained several databases for different clients such as Pep boys, Sysco & Burlington Coat Factory
Homestar Funding Atlanta, GA April 2001 – March 2002
Programmer Analyst
Project: Destiny Mortgage Software Implementation
Environment: SQL Server, Platinum Erwin 3.5.2, Visual Basic6.0, Microsoft Access 2000, Crystal Reports
8.0,SQL Server 2000
Designed large and complex data models withSQL 2000 & Platinum Erwin 3.5.2
Assisted in research, analysis, testing and maintenance Of Destiny mortgage software
Developed user interfaces written in Visual Basic 6.0 And Microsoft Access for loan warehouse process
Created pipeline and detail reports using Crystal Reports 8.0. Queried SQL database to write complex Multiple table joins to produce the correct information.
Provided training and technical support to the end users
EDUCATION:
Saint Peter’s College, Jersey City, NJ
B.S., Computer Science-MIS & Business Management, 1997