QUALIFCATION HIGHLIGHTS

• Extensive experience working with all aspects of custom developed systems.
• Expertise in full project life cycle development for implementation and integration.
• Deep Understanding of technology with focus on delivering business solutions.
• Excel in high pressure situations.
• Works well as a team member or independently.

TECHNICAL EXPERTISE

• Microsoft SQL Server 2000, 2005, 2008
• Microsoft Reporting Services (SSRS)
• Crystal Reports 8.5
• Data Modeling Tools
• ErWin
• ER-Studio
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft Analysis Server
• T/SQL Stored Procedures
• Surround SCM
• TestTrack Pro
• XML, HTML, JavaScript
• Visual Basic 6.0

• C#
• ASP.NET
• DataMirror
• Java
• Oracle
• PL/SQL Stored Procedures

Professional Experience
Confidential,Indianapolis, Indiana April 2008 - Present
Automotive Body and Paints
Senior DBA
Maintain and support current production databases while developing a data warehouse, reports and database applications to support various corporate home office departments..

• Provided a Data Warehouse solution to enhance data analysis and corporate reporting using SQL Server 2005 and SQL Server Integration Services (SSIS). This solution takes advantage of Microsoft Analysis Server to allow business analysts to work on data independent of IT to minimize their time in creating custom Excel reports for their departments.

Confidential,continued

• Developed custom interface with 3rd Party vendor to provide data for creating Bill of Lading. This included working with summer intern and supply chain department to deliver this solution to our warehouses and branches in a timely manner.
• Created a reporting solution for Profit and Loss report from the AS/400 to SQL Server. Solution provided accounting department with Profit and Loss reports within minutes, instead of running job overnight on AS/400. Also, created a DataMart for our finance department to do detail analysis of financial data, this saved hours of manual data collection and provided data accuracy as well.
• Implemented a reporting solution for our Sales Department. This solution includes a web page for data entry, creation of multiple cubes and dimensions to provide as data source for multiple of datasets that the report consumes. The report then takes advantage of custom database development that provides a pdf version of the report that is e-mailed to the District Sales Managers.
• Monitor and support database environment. This includes performance monitoring and tuning of stored procedures and database tables/indexes.

Confidential,Indianapolis, Indiana Jan 2005 – April 2008
HealthCare Software Vendor
Senior Software Developer and DBA
Development and enhancement to in-house healthcare software product (ICMS) based upon client requirements. This includes requirements gathering, project management, coding/database management and implementation.

• Delivered a Data Warehouse solution to Client using SQL Server 2005 and the new SQL Server Integration Services (SSIS).
• Developed new modules and enhanced existing modules in Visual Basic 6.0 and SQL Server 2000 and 2005 for ICMS product.
• Used Surround SCM Source Control Tools for Code Management (Branching/Merging/Promote/Rebase) of source code.
• Used TestTrack Web based Pro Defect Tracking software to manage Client-reported defects and change requests as well as internal tracking and quality assurance.
• Provided training sessions for new Clients on the use of the ICMS application.
• Handled support and maintenance of ICMS and its SQL Server Database.
• Assisted with C# and ASP.NET development on next generation software development (eCare).
• Successfully implemented ICMS at several Client locations.
• Delivered additional Client requested projects, such as:
• Additional Reporting requirements
• Data Imports

Confidential,Indiana Feb 2001 – Jan 2005
Banking Software Vendor
Database Engineer
Database Administrator and Developer for Application Service Provider (ASP) product, Bank2Business.

• Managed over 100 database instances remotely within 3rd party data center. This included rolling out database structural changes and data changes in a systematic and controlled process.
• Conducted performance tuning and volumetric monitoring to ensure optimal performance, by performing the following
• Used SQL Profiler and analyzed Execution Plans in order to ensure optimal SQL Query performance and to reduce bottlenecks.
• Used SQL Server Tools to monitor data volume changes and anticipate additional data storage requirements.
• Created a dynamic DTS Package to provide MS-Access downloads for over 100 databases to be transferred to clients for their reporting needs via Secured File Transfer Protocol (FTP).
• Data modeling and update scripts using ErWin data modeling tool.
• Worked closely with quality assurance and support to ensure that database changes were successfully rolled out from Development to QA to Production in a controlled process.

Confidential,Ohio Mar 1999 – Feb 2001
Large Credit Processing Software Vendor
Software Developer

• Handled the support, maintenance, enhancement of a large credit processing system, developed using Centura SQL/Windows. Also, performed Client site product implementation.
• Assisted Clients in Training and providing 24x7 product support and developed custom code requirements.
• Created PL/SQL procedures, triggers and business reports using Business Objects 5.0, an OLAP reporting tool.
• Converted Client’s two-tier data entry software system for contracts, accounts and services in the Gas/Electric industry from Centura SQL/Windows to Visual Basic 6.0.
• Worked with Client’s QA team to ensure high quality and proper implementation of new system and the data conversion of the legacy system into the new system and worked with the client to ensure the proper interfacing between the new data entry system and their customer management system.

Education
BS, Computer Information Systems