Resume

OBJECTIVE: Highly productive, versatile and certified database and business intelligence developer with proven expertise in databasedevelopment and enterprise applications migration, scalability,implementation and technical support. Has successfully applieddevelopment concepts for business intelligence, technical support,and training projects to financial, energy, and government entities.Passionate about providing data in a quick, accurate and businessfriendly format to vested decision makers.

CONFIDENTIAL

Industry: Healthcare Services

BI Developer

Accomplishments:

• Tuned ETL packages and queries to support high volume Trip Management System
• Developed SSRS reports for using trip management and geospatial data
• Provided requirements, specs, and proof of concept design for Self Service Reporting and Self Service BI using SQL 2012
• Developed a processing system for inbound EDI acknowledgements and error messages

CONFIDENTIAL

Industry: Construction - Industrial Facilities and Infrastructure

Reports Developer

Accomplishments:

• Established new process to provide Sales data from Lawson to a BPW data warehouse using DB2 queries and SQL Server Analysis Designed and developed several reports and dashboards for managers, developers and users.
• Developed dynamic .Net interfaces to support reduction of total reports needed to give slight variances in reporting requirement

CONFIDENTIAL

Information Security Developer

• Accomplishments: Developed ETL processes for user security access data in all SunTrust applications. Provided real time reports to monitor incoming feed files. Utilized Linked Server functions between Oracle and PeopleSoft databases.
• Implemented the Courion Access Assurance Suite version 7.70 within project budget and timelines Designed and developed several reports and dashboards for managers, developers and users to give specific metrics for auto provisioning data to reduce lookup time in support calls. SharePoint, SSRS 2005/2008, SSAS
• Provided dashboard and email trouble alerts for logged error conditions at the data and application level. SQL Server, C , ASP 3.5 .NET, SharePoint.

CONFIDENTIAL

Database Consultant

Accomplishments:

• Completed the total migration of all objects and accounts from SQL Server 2000 to SQL Server 2005 to which involved all of Apogee's customized websites, images, and applications
• Implemented new website search function to replace the Index Catalogs previously used for all websites
• Provided content management via T-SQL scripts Developed and implemented customized web pages, utility applications, and customized reports for utility customers
• Helped produce and implement Flash based energy calculators

CONFIDENTIAL

Database Consultant

Developed reports and automated application troubleshooting for customer data supporting Good Cents Route match Implementation used to help track customer data and dispatch field installers. Implemented a system of automated ETL Extract, Transfer, and Load Scripts from SSIS packages to ensure notification and delivery for comma separated CSV and Excel data to be processed by external customers.

CONFIDENTIAL

Remote Technical Assistance Engineer

Remote Technical Assistance Engineer

• Responsible for maintaining service level agreements for Philips Cardiology Systems customers which includes Tier 2 resolution of SQL Server and Windows based cardiology applications
• Diagnosis and post implementation engineering for SQL Server 2000, Datafirst archive, and Internet based medical solutions.

CONFIDENTIAL

Database Consultant

• Supported the Henry County Water Authority with SQL support on SQL Server 2000 as a backend to Great Plains 7.5/8.0 Accounting, Payroll, Inventory, FRx, Sales, Finance , Track It 6.0, and HMS Cashiering and Billing Applications. Troubleshooting and resolution of user issues, execution of database maintenance scripts to perserve server space and performance, maintenance and production of reports in MS Access and Crystal to support applications.
• Provided short term project support to Atlanta area insurance, customer service, and educational systems on Microsoft Office and Back

Office.

• Helped setup Extract Transfer and Load packages ETL using SQL
• Server Data Transformation Services and linked servers to Oracle 9i
• Also setup dynamic reporting using SQL Server Reporting Services,
• Business Objects, and ASP code.
• CONFIDENTIAL
• Industry: no industry preference

Database Administrator

Provided membership reporting and overall database and development support to a national association representing over 30,000 member agencies. Specific duties include: reporting from IMIS association membership software , design and development in SQL Server, administration of all web and database applications which reside on Windows 2000 Servers using Microsoft BackOffice, Active Directory and .NET development technology.

CONFIDENTIAL

Database Specialist

• National Board for Professional Teacher Standards c/o ACSYS, Inc. Duties include: providing database administration for over 16,000 members and staff in support of nationwide teacher accreditation. Specific duties include:
• SQL Server 7 administration to include the creation/revision of databases, tables, stored procedures, Data Transformation Services
• Creation of enterprise reports using Crystal Reports 7.
• Preparation of data presentations using Microsoft Excel and Access.
• Worked with Cold Fusion tools and developers to produce web site reports and feedback forms.
• Prepared all databases for migration to the IMIS membership system.
• Trained management and staff in the operation of NBPTS databases.

CONFIDENTIAL

Tech Support/ Database Consultant

• Performed the following tasks for Corestaff clients which include
• Encompass Global Technologies, Trak Auto Inc., VISA USA, and
• Dominion Resources Services
• Currently working with Dominion Resources in Richmond Virginia training over 15,000 users for upgraded versions of SAP 4.6 Enjoy and Lotus Notes Release 5
• Provided technical writing, troubleshooting, database extraction, and migration for a major Great Plains Eenterprise implementation to automate processing for Accounting and Service Management departments. Currently training IT department in MS Access, Crystal Reports, and SQL Server Administration to assist with the data management. Also helping to install and operate the Sales Logix CRM product
• Trained management on the data flow process and highlighted trouble spots. Provided documentation for presentation purposes.
• Trained support group in the use and administration of the HEAT Call Package, implemented the Knowledge Tree to automate problem
• resolution and call entry

CONFIDENTIAL CONFIDENTIAL CONFIDENTIAL Client Server Administrator Responsible for supporting software development and maintenance at the Department of Housing and Urban Development with Windows NT and SQL Server administration. Systems and Services Y2K Consultant Inc. ABSS

Description: Responsible for ensuring that all systems used in the U.S. Department of Housing and UrbanDevelopment HUD are compliant with federal Year 2000 standards. Specific duties include the coordination and management of project plans, meetings,

• and relevant technical documentation analysis of HUD systems using Hitachi,
• Unisys, and LAN platforms facilitate the testing of all date functionality,
• business partners, and end to end testing of integrated systems for business

functionality.

Skills:

• Lotus Notes - statistics tracking and reporting, inventory, call tracking, document libraries
• Access - forms, statistics, SQL queries
• SQL Server 6.5/7.0 - migration of Notes and Access databases, Tech writing - test plans, user guides, technical editing
• 8/1994 - 1/2000 Part-time positions
• Industry: no industry preference

Operations Analyst

• AAMVA, August 1999-present, help desk support for IBM mainframe based systems
• Digital Dictation, August 1994-August 1995, help desk/operations support for OS/2 LAN based automated transcription/dictation system.
• 10/1993 - 5/1998 Amer. Assoc. of Motor Arlington, VA
• Vehicle Admin. AAMVA

Senior System Analyst/Project Manager

• Managed the support, implementation and configuration of driver licensing systems and programs used by state licensing agencies and the U.S. Department of Transportation. Specific duties include: providing implementation support to system developers on various platforms which were mostly MVS, IMS, and Unix-based providing support for an IBM network and data standards to facilitate the EDI exchange of driver data across an Advantis WAN using LU 6.2, and
• translating proprietary standards into open standards i.e. X12 and EDIFACT. Developed, managed, and presented driver systems training courses for state and federal government staff both technical and non-technical .

SKills

Developed repositories in Lotus Notes for tracking and configuration management. Developed Access database applications to manipulate tracking and test data. Provided consulting to vendors and agencies on the integration/migration of TCP/IP, Frame Relay, Ethernet LAN, and SNA based network communications. Used CICS, TSO, JCL, and DB2 to develop automated testing tools, scripts, and EDI host simulations. Used Yourdon methodology and the PACLAN CASE TOOL to support systems development activities.

Confidential

Systems Analyst U.S Postal Service

Provided technical support to the United States Postal Service for accounting systems on Unix PCs and VAX mainframes. Duties include: help desk support, SCO Unix scripting and file administration, vi editor commands, VAX, modem, and SNA administration and troubleshooting, testing of all new USPS systems, and hardware repair for failed units. Provided LAN support for Novell, Ethernet based LAN network, duties included installation, configuration, and backup. Produced training tools in the form of a question/answer video, online documentation, and user manuals.

Career Highlights

Written several scripts procedures, DDL commands, DML commands in T-SQL and PL/SQL Managed the first national driver database CDLIS Have successfully managed and administered over 25 system migrations/upgrades Certified as MCSE, SQL SERVER MCTS, and looking to add to

this list soon.