Post Job Free

Resume

Sign in

Sql Server Data

Location:
Dallas, GA
Posted:
May 03, 2016

Contact this candidate

Resume:

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



Contact this candidate