profile

Kris Traughber

Database and Business Intelligence Developer

Los Angeles

Skills

MS Access

T-SQL

VBA

SQL Server

About

I am a database developer with over 13 years of experience working with Microsoft Access and SQL Server.

Education

Union University

Sociology , Sociology

May 1994 - May 1994

Paducah Community College

Experience

Database Analyst

Answer Financial

February 2011 - January 2012

Provide business intelligence and reporting using MS SQL Server, Integration Services, and Reporting Services.

Reporting
System Analyst

Nigro Karlin Segal & Feldstein, LLP , Century City, CA

April 2009 - July 2011

Worked in the audit department on a team of three people to provide dababase reporting to support the audits. Provide reports, data extracts, and reporting tools for auditors using Microsoft Access and Microsoft SQL Server 2005 and 2008. Use SQL Server Reporting Services to deliver reports and SQL Server Integration Services to import and transform data.

Reporting
Contractor

ING Advisors Network , El Segundo, CA

January 2009 - February 2009

Enhanced a Microsoft Access 2000 database that was used by six different departments. Mainly performed front-end enhancements by adding new controls and Visual Basic code to forms. Also added new tables, queries, and macros where needed to support the front-end enhancements.

Developer
Systems Analyst

Nuveen Investments , Century City, CA

April 2007 - July 2008

Provided SQL Server 2000 and 2005 database and middle tier support for Charles River Investment Management System. Created a nightly batch job cycle that consisted of approximately 40 jobs that transfer data between the Charles River Investment system and the SimCorp Dimension accounting system using flat files. This was done using a product called AutoMate, which is a job scheduler and batch-programming platform with it's own proprietary scripting language.

Database Application Support
Technology Consultant

Edge of Technology , Burbank, CA

August 2006 - April 2007

Edge of Technology was a small startup specializing in providing complete IT services and solutions for small business usually smaller than 50 people. Provided application solutions for small businesses, including support for 3rd party SQL Server applications and creation of Microsoft Access databases. Won a one-month contract for Edge of Technology to change over 100 Microsoft Access databases.

Database Application Support
Reporting
System Analyst

ING , El Segundo, CA

November 2000 - August 2006

Provided production support for SQL Server applications. Also created various reports and ETLs using a combination of SQL Server DTS, Oracle, and/or MS Access.

Application Support
Reporting
ETL
Systems Analyst

SunTrust Bank , Orlando, FL

April 1997 - October 1999

This is where I learned to write T-SQL. I used this knowledge to support a VB6 /SQL Server application and create ad hoc reports using MS Access.

Reporting
Application Support

Workplace personality

100+

Company Size

12

Day Length

25+

Team Size

Loud

Noise Level

Formal

Dress Code

Benefits

N/A

Commute

Copyright © 2020 Kinzaa.com. All rights reserved