Sql Server Project

Andrew Tegethoff

404-***-**** **********@*******.***

SUMMARY OF QUALIFICATIONS

Andy is an accomplished business intelligence and software consulting professional with 11+ years of experience designing, building and

maintaining software and data solutions across a wide variety of platforms, environments, and business domains.

Well-rounded and a fast learner, Andy s strengths include excellent communication and interpersonal skills, high-level problem-solving

and design abilities, superior attention to detail and "best practices" development techniques, and a creative, achievement-oriented

nature.

Proven leadership in various technical and "peopleware" capacities, providing full-life cycle technical steering from strategy to project

requirements to development to code maintenance. Pursues "win/win" compromises between business and technical goals, always

working to minimize overall solution TCO while maximizing value and maintainability.

Holds BA in English and Psychology from Vanderbilt University, as well as multiple Microsoft certifications in the .NET development and

SQL Server BI toolsets. Non-technical business experience in HR, management, sales, marketing, clerical, retail.

Experienced in multiple development and RDBMS platforms, with exposure to a broad range of development methodologies and

standards (Agile/XP/SCRUM, RUP, etc.).

TECHNOLOGIES

SQL Server (7.0 2008 R2) Legacy web and Windows programming (ASP, VB 6.0,

Oracle (8i 10g) COM/COM+, Java/JSP/Servlets, etc.)

T-SQL/MDX/PL-SQL Wherescape Red

Microsoft Visual Studio & .NET Framework (v1.1 3.5) ER-WIN

PROFESSIONAL EXPERIENCE

Northridge Systems, Inc. 04/06 present

1080 Holcomb Bridge Rd, Roswell Summit 100, Suite 300, Roswell, GA 30076

Senior Business Intelligence Consultant Permanent consulting position; advising/collaborating with business clients on data/BI strategies,

implementing full-stack custom business intelligence solutions on the Microsoft SQL Server 2005 and 2008 platforms. Led and performed

the architecture, design and construction of data warehouses, ETL processes, OLAP cubes, and reports using SQL Server Integration Services,

Analysis Services, and Reporting Services. Clients and projects supported include:

Allstate

Regional Intelligence project Designed and implemented a full-stack SQL Server 2005 BI solution for Allstate s Southeast region,

consolidating multiple sources of competitive intelligence data into a single data mart for reporting and analysis as the data foundation

of a regional collaboration portal.

Consulted with business leaders to develop an overall business intelligence strategy; established technical requirements and

specifications for the initial development phase; explored existing data sources and processes.

Designed, constructed and deployed Data Mart dimensional database (SQL Server Database Engine), several ETL processes (SQL

Server Integration Services, SQL Agent), multiple Reports (SQL Server Reporting Services), and an OLAP cube (SQL Server Analysis

Services) as part of the solution.

Planned all regular system maintenance activities; Coordinated ETL processes with existing batch job schedules; Installed and

configured various platform tools including SQL Server Reporting services

Galen Advisors

Galen Analytics project Responsible for complete architecture, design and BI implementation of a customer-facing analytics portal for

a growing medical practice management consulting company using MOSS 2007 and the SQL Server 2008 BI stack.

Worked with client COO, CFO, and other top-level business leaders to establish requirements for a new line-of-business internet

analytical reporting portal using the client s existing medical practice management software/data.

Consulted on marketing and sales dimensions of the portal offering, system growth and development, strategic addition of source

systems supported. Worked closely with client representatives throughout project to refine specifications and to test the

completed solution.

Architected a multi-tier/multi-function system which includes a full Data Warehouse and ETL process, an OLAP cube, and a data

gathering subsystem housed on a small form-factor appliance on the client practice s network using a combination of custom

Windows and Web services to collect data and transmit to Galen s servers.

Implemented and developed the system s BI elements on the SQL Server 2008 platform, including ETL processes built in SSIS 200 8

and an OLAP cube built in SSAS 2008.

Implemented role-based security for all users at the cube level using Kerberos protocol, and custom C# security.

Andrew Tegethoff Page 1

404-***-**** **********@*******.***

SharePoint Dashboard project Implemented changes to cube security and dimension usage in an existing SQL Server 2005 BI

installation. The BI installation supported a set of customer-facing dashboard reports hosted in SharePoint via SQL Server Reporting

Services.

Designed and implemented a custom .NET/C# assembly to add custom data security to an existing OLAP cube.

Wrote MDX queries to authenticate Role-level data access via the custom security Assembly.

Extended cube data by adding a new Dimension and Dimension Hierarchy; created of new views/tables in underlying dimensional

data warehouse for exposure via the cube s Data Source View.

The Network

Reporting Portal project Added Ad-Hoc reporting functionality to an existing web application. Functionality was implemented using

SQL Server 2005 Reporting Services and C#/.NET coding.

Assisted in programming and configuration of Forms Authorization to fit with existing application domain security scheme.

Designed and implemented Report Model with row-level data security for use in SSRS Report Builder, which provided ad-hoc report

generation functionality across all customer sites.

Senior Software Developer - Permanent consulting position; led teams in new development of custom software systems on Microsoft

platforms in a fast-paced, customer service-focused consulting environment. Clients and projects included:

TitleMax

CheckMax CLPro project retail operations software for CheckMax, the payday loan division of TitleMax, Inc., with branches in multiple

states across the southeast. Used daily in a high-volume retail/financial environment.

Managed full life-cycle development of CLPro, from requirements to implementation; supervised and led coding efforts; managed

junior developers; coordinated with project manager.

Application implements an adaptation of the Manager pattern in C# using Visual Studio 2005, utilizing web services over HTTP as

a middle tier and SQL Server 2005 as the underlying relational data store.

Functionality includes advanced imaging capabilities for document handling, extensive reporting, and integrations w/ Great Plains

rd

accounting software and 3 party banking service/ information providers.

ZC Sterling, Inc. 02/04 04/06

210 Interstate North Pkwy, Suite 400, Atlanta, GA 30339

Senior Programmer/Developer (ZCTS product) - Permanent position; performed maintenance and new development in a mixed technical

environment (ASP 3.0 front end, C#/.NET and Delphi COM+ middle-tier components, and Oracle 9i/10g databases). The web system is used

for management and delivery of real estate tax data to the mortgage servicing industry, in conjunction with a large batch system that collects

tax data from approx. 25,000 tax jurisdictions across the United States.

Adapted rapidly to complicated business/technical domains, performing development tasks with minimal ramp-up time.

Established .NET coding standards during introduction of C# code to application framework. Introduced more effective design

techniques to the team in the context of .NET coding.

Managed full life-cycle development of multiple new applications using ASP (including HTML, VBScript, JavaScript, and XML data

binding), C#, Delphi, and PL/SQL.

Led "strike team" to improve deployment/release procedures, cutting average man-hours per release by over 50%.

Coordinated and implemented upgrade to Oracle 9i client for servers in Dev, QA, and Production environments.

Planned and executed upgrade of all production application servers to Windows Server 2003.

Enhanced and maintained code across all layers and technical domains in the enterprise.

Sun Trust, Inc. 08/03 01/04

250 Piedmont Ave, Atlanta, GA 30308

Web Developer- (Project Reporting Subsystem project) - Contract position enhancing an ASP web application running against a SQL Server

7.0 database. The system is used for planning and budgeting, and is composed of multiple subsystems in a larger intranet application suite

supporting project mgmt. efforts in the Development Services Dept.

Beat all timelines for completion by 7 weeks, moving from design to production with 0 reported defects in under 3 weeks.

Designed and built employee time tracking subsystem (incl. data model, ASP pages, stored procedures).

Leveraged SQL Server 7.0 features to decouple data layer from presentation and business logic:

o Wrote SQL commands, introduced use of stored procedures

o Built Views to simplify data access and optimize reporting performance

o Automated recurring tasks with stored procedures and the SQL Server Job Scheduler.

Andrew Tegethoff Page 2

404-***-**** **********@*******.***

Resolved XMLHTTP POST and XSL stylesheet errors used for client-side data handling across different IE versions.

Constructed and deployed traditional ASP pages according to existing stylistic and functional guidelines.

Pallas Technology, Inc. 05/02 04/03

512 Means St, Suite 300, Atlanta, GA 30318

Senior Consultant (multiple projects) Permanent position with a full-service consulting company whose principal focus is on custom

software development in Java/JSP/Servlets and Visual Basic, using multiple database platforms (SQL Server Oracle, Sybase). K ey clients

include American Express and Cendant.

Rebuilt a secure, silent FTP agent (VB 6 ActiveX DLL) for clean functioning under multiple versions of Windows, enabling the product to

run cleanly under Windows9x/NT/2000/XP; product was licensed for use as a file transfer component in a third-party application.

Designed and implemented flexible, extensible and reusable data model (using ER-WIN) which served as back end for a reusable contact

management web application framework.

Installed, maintained and administered multiple staged instances of SQL Server 2000; responsible for bac kup operations, DTS scripts,

syncing DB changes between ER-WIN models and actual instances. Created reusable template for building stored procedures and user

functions; wrote and implemented custom stored procedures, functions and triggers.

Created custom data layer which was integrated into the middle-tier of an existing Java client/server application, used by American

Express for internal HR accounting and data entry. Responsible for design, development, testing, and debugging. Wrote stored

procedures in T-SQL under Sybase 11 to facilitate database querying.

Piloted work with .NET (specifically ASP.NET and ADO.NET in C#) on several client proposals. Built .NET versions of application

prototypes. Researched impact/implications of porting traditional COM/COM+ code to .NET.

Built multiple web applications (using JSP/Servlets) for various divisions of Cendant Corp. Responsible for: design and programming;

deployment to multiple supported platforms across a heterogeneous network.

GE Power Systems 01/01 05/02

1300 Parkwood Cir, Atlanta, GA 30339

Senior Software Developer (COSMOS Project) Contract position developing a client/server application used in modeling long-term service

agreements for power generation facilities constructed with Visual Basic 6/COM+ components and using a Unix-based Oracle 8i database,

deployed via Citrix Metaframe 1.8 on the Windows 2000 platform.

Boosted performance of several key COSMOS functionalities over 5000% by re-writing VB code as PL/SQL packages. Introduced PL/SQL

stored procedures and functions to improve overall architecture and to remove costly data access logic from the main body of code.

Tuned and optimized SQL statements for Oracle, and assisted in overall tuning of the COSMOS database.

Facilitated resolution of a critical memory leak in COSMOS, enlisting assistance from Microsoft, analyzing performance metrics using

Perfmon, other Microsoft debugging tools.

Researched, planned, and steered deployment of COSMOS on the Citrix platform. Performed analysis of needs and requirements,

requisitioned appropriate server hardware, installed and modified settings for both Windows 2000 Server and Citrix Metaframe

software, physically relocated server hardware to a remote location, troubleshot connectivity and user issues, and implemented the

Citrix NFuse web portal to allow user access via GE s intranet.

Lead Developer (CSATool Project) an offline tool constructed with VB 6.0 and MSXML 4.0, using data exported from COSMOS and allowing

manipulation of that data from a field sales perspective.

Coordinated extensively with business analysts in requirements gathering, supplementing existing k nowledge of the COSMOS tool user

base.

Authored design document, detailing functionality and architecture. Created XML Schema mapping the pertinent portions of the

COSMOS data model into the CSA tool s portable data store.

Leveraged reuse of existing code by integrating already-licensed ActiveX controls for reporting and compression capability.

Compass, Inc. 11/99 11/00

40 Technology Pkwy, Suite 150 Norcross, GA 30092

Web Developer (ClearStar Project) - an n-tier B2B e-commerce web application built on the Windows 2000 platform, utilizing stateless

COM+ components, SQL Server 7.0 stored procedures, MSMQ, and IIS 5, with supporting applications written in VB6.

Responsible for design and construction of site elements including a Reports component using Crystal Reports SmartViewer ActiveX, and

a Batch Management object and page used for managing, automatic faxing/emailing of orders.

Built user interfaces using ASP, JavaScript and HTML in MS Visual InterDev.

Created XML formats and schemas for outside interfaces to ClearStar using SOAP.

Programmed COM+ objects for the middle-tier using VB6.

Andrew Tegethoff Page 3

404-***-**** **********@*******.***

Designed and implemented table changes, wrote stored procedures, scheduled jobs for app's SQL Server 7 data source.

Created a marketing website for the product and wrote advertising copy for use in print/web marketing efforts.

Leveraged experience with development efforts on a high-volume transactional system into Windows-related skills

Windows Developer - Compass Clarity Project- an industry standard SQL Server 6.5 - based client-server application built using Visual Basic

Designed and built Invoice Manager" module; used dynamic SQL in stored procedures to allow filtering of invoice data based on user-

specified criteria. Allowed Clarity users to post/print/export/edit/view details of customer invoices according to Clarity business rules.

Enhanced functionality of Compass Clarity; prepared product for version 2.0 release, including conversion to SQL Server 7.0 from version

6.5, adding standardized error-handling code, major overhaul of several key components.

Fast-paced, small-group development atmosphere encouraged 'rapid development' project life cycles, plus multi-tasking, flexibility, and

accelerated skills growth.

Consultec, Inc. 5/99 11/99

9040 Roswell Rd. Atlanta, GA 30350

Programmer/Analyst (Georgia SUCCESS project) Permanent position; development for an IBM mainframe system that handles multiple

millions of transactions daily in batch/online modes. Used by the State of Georgia to administer public assistance programs.

Coded and maintained COBOL programs; compiled and tested programs in the mainframe environment using IBM OS/2 desktop, JCL,

and various other mainframe utilities.

Worked face-to-face with State employees on-site at their offices, assisting in training; interacted closely with Consultec colleagues at

small- and large-team levels during all stages of design, coding, testing, and production maintenance.

References available upon request.

Andrew Tegethoff Page 4

404-***-**** **********@*******.***

Contact this candidate