SUMMARY:

• Repeatedly demonstrated simultaneous handling of multiple assignments with deliverables causing minimal disruption to users. Accomplished career in SQL Server database warehousing, database design, data conversion from legacy systems, query and performance optimization. Proven ability to navigate complex IT environments.
• Technology Snapshot: SQL Server 2005/2008, SSRS, T - SQL, DTS, OLTP, MS Access, VBA, Active Directory, XML, Extensive use and knowledge of data mining in SAP using Oracle database on UNIX and Windows platforms, Optiva, Visual Basic, Omnis Studio, 4th Dimension, DataStage, Infor VISUAL, Motorola MC9200 Handheld Computer
• Database Administration
• Extract, Transform and Load (ETL)
• Client Needs Analysis
• Business Intelligence (BI)
• Data Mining
• Database Reverse Engineering

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

VB.NET Programmer

Responsibilities:

• Modified existing Visual Basic code to operate on new replacement handheld computer scanners (model Motorola MC9200) used for inventory movement. Added features to read new Confidential proprietary format barcode for supplier labels - a single code containing multiple data elements - in addition to processing legacy multiple single data element barcodes. Differentiation of barcodes is determined by the VB code/scanner requiring no user intervention.

Confidential, Louisville, KY

SQL Developer

Responsibilities:

• Developed TSQL and VBA processes to scrub data and automate entry of proprietary, industry specific spreadsheets into Infor VISUAL tables bypassing ERP interface. Required in depth forensic analysis of Infor Visual structures as table relationships were not typical parent/child architecture. Created reports and dashboards for Finance, Engineering and Manufacturing. Reverse engineering of VISUAL processes.

Confidential, Louisville, KY

ETL Analyst

Responsibilities:

• Corrected failed ETL processes; suggested improvements to IT infrastructure; reporting system in development - identify information and create process to extract from legacy retail sales system with Pervasive database.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

• Forensic ETL between two third party applications. Extract from Taleo with minimal documentation, transform and selectively load into SuccessFactors.

Confidential, Elizabethtown, KY

Database Administrator

Responsibilities:

• Triage problem tickets; create new and modify existing reports in SSRS; debug T-SQL code; review T-SQL code produced by offshore resources; produce Excel spreadsheets based on ad hoc queries. SQL Server 2005/2008

Confidential, Fort Knox, KY

ETL Analyst

Responsibilities:

• HP contractor. Created BI data warehouse structures in Oracle, processes in IBM Datastage 8.1 to combine information from Oracle, Sybase, SQL Server 2008, Excel and text file sources into tables suitable for long term data analysis.

Confidential, Elizabethtown, KY

Data Warehouse

Responsibilities:

• Developed purge process to copy inactive/aged information from production database to archive database.
• Designed de - normalized archive database on linked server to retain relevant information as determined by business.
• Purge process deleted related table information to prevent orphan records; process in archive database deleted records at end of retention period.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

• Preparation of electronic transmissions. Assisted web developers with T - SQL (SQL Server 2000) performance issues, creation of complex SQL queries.
• Manually prepared contract/plan/pharmacy/drug pricing submissions to Centers for Medicare and Medicaid Services (CMS).
• Developed automated CMS submission to replace manual process.
• Enhanced existing pharmacy networks application to synchronize pharmacy rate and fee information with pharmacy claims processor.

Confidential, Louisville, KY

Database Administrator

Responsibilities:

• Performed database administration for multiple servers located on three continents. Provided trouble shooting assistance with database, web and terminal servers. Wrote DTS packages for real time data access from SAP databases. Migrated databases from SQL Server 7 to 2000 . Utilized virtualization to create autonomous testing, development and small scale production environments. Configured SAN for optimal performance.
• Determined appropriate equipment, wrote and implemented conversion plan for software upgrade and new hardware installation which resulted in no service interruption for users.
• Converted chemical formula information from several legacy systems located on three continents in various languages to standard database table formats - retaining native language instructions.
• Refined data conversion procedures to include audit and accountability for data migration from legacy systems.
• Utilized linked servers, DTS packages and T-SQL code to extract, transform and load data warehouse.
• Configured primary database server as failover cluster for high availability, used replication to remote warm site for disaster recovery.

Confidential, Louisville, KY

Access Application Developer

Responsibilities:

• Added functionality to existing help desk application to produce metrics and email results to user defined addresses. Converted from Access database to client server architecture using SQL Server 7.0. Interfaced with AS400 DB2 tables using ODBC. Used Access to run DB2 processes.

Confidential, Louisville, KY

Application Developer

Responsibilities:

• Utilizing Access, Visual Basic and 4th Dimension developed new, or added functionality to existing applications for manufacturing, publishing and printing companies.
• Working with top level management, developed an Access application to quantify employee work output during a given time period. User customized reports were developed for each department to objectively assign a value to the work performed. System was extremely adaptable in that reporting criteria and format could easily be changed without programming.
• Increased performance of an in - house developed 4th Dimension application for tracking job reworks. Added functionality and trained in house personnel on advanced features of 4th Dimension.
• Developed Access app for tracking inventory and projecting sales at remote location for printing company.
• As part of a team developed a Visual Basic application for magazine layouts. Software used ODBC, RDO and file transfers to move information from/to AS400 DB2 tables and SQL Server 6.5 tables. Primary administrator for SQL Server 6.5.

Confidential, Louisville, KY

Automation Consultant

Responsibilities:

• At corporate office - replaced Xerox word processors with network of Macintosh computers, MS Office, email, shared file and printing resources. After initial installation, network was expanded to include Law, Central Admissions, Quality Assurance and Human Resources departments. The administrative offices at each hospital received similar equipment to facilitate localization of master documents received from the corporate office.
• Based on forms and workflow developed by Central Admissions Department - automated the Confidential t referral and admission tracking system using Omnis 5.
• Utilizing a centralized tape backup system - desktop computers were automatically backed up and backups maintained by the Records Retention Department.
• Converted manual graphic arts department to computerized equipment including scanners, laser typesetter and slide imager.

Confidential, Louisville, KY

Macintosh Consultant

Responsibilities:

• The Louisville office was chosen as a pilot site for integration of Macintosh computers into all departments of the accounting firm. Working closely with Apple Computer and selected vendors, was responsible for all aspects of network design, network equipment selection and installation. The project concluded the substantial investment in technology was warranted by the increase in productivity.
• Designed 180 node network (Appletalk/Ethernet/routers) - at installation was largest Mac network in state.
• Using Omnis 5 developed software to track progress of client tax preparation and assign client tasks to users.
• To accommodate DOS based tax software, installed twisted pair Ethernet cabling for PCs in tax department. Linked Mac email to PC email.