Senior Consultant Resume Profile ,MO - Hire IT People

COMPUTER EXPERIENCE:

Software: MS SQL Server 6.5/7/2000/2005, Oracle9i, MySQL, Cognos, ArcGIS,
ArcSDE, ERwin, ER/Studio, ArcIMS, MapInfo, MS Access, MS Excel, Intergraph, ESP, SAS, Aremos, Adobe Acrobat Exchange Reader, Satellite Forms, ColdFusion, AlterYX, IBM WebSphere
Languages: T-SQL, PL/SQL, Visual Basic, ASP, HTML, VBScript, JavaScript
Systems: MS Windows XP/NT/2000/2003, H-P UNIX, DOS and Macintosh

CAREER EXPERIENCE:

Confidential

Senior Consultant

Create implement technical resolutions using T-SQL scripts for hundreds of troubleshooting maintenance issues of the USDA Tobacco Transition Payment Program TTPP system and accompanying Successor-In-Interest SII system.
Design, develop and maintain SQL Server Stored Procedures for the USDA monetary Obligations component of the TTPP SII systems.
Manage and maintain 8 different report generating processes using T-SQL scripts, VBA, MS Access MS Excel.
Design and write documentation for 8 different report generating processes for the USDA TTPP and SII systems.

Confidential

Manager of Application Development

Design, develop and implement Enterprise System Architecture.
Re-engineer, redesign manage Business Process that cut processing time from 3 weeks to a day.
Manage and maintain Data Warehouse for MCH-GeoPoints that supplies data to Department of Homeland Security, National Geospatial-Intelligence Agency and others. This Oracle9i MS SQL Server 2005 database system stores and distributes Points Of Interest POI data.
Design, develop, implement maintain customized Data Mining routines that use ArcSDE, Oracle PL/SQL scripts, SQL Server Packages/scripts and AlterYX ETL scripts to create data deliverables for Department of Homeland Security, National Geospatial-Intelligence Agency, various State government customers and Tele Atlas.

Confidential

Senior Database/Web/GIS Specialist

Design and develop database for Kansas Department of Health and Environment using Oracle. Create accompanying web site using ColdFusion. This web application helped the State of Kansas save approximately 1 million.
Design database and develop web-enabled operations and maintenance manual for the city of Westminster, Colorado's Water Treatment Facility using ASP and Microsoft SQL Server 2000.
Design and develop a data warehouse for the Defense Program Office/U.S. Navy. This Oracle database system stores classified military and utility infrastructure data. In addition, implemented ArcSDE, several Oracle stored procedures, PL/SQL scripts and data model design in ERwin.
Built an inventory control management system for a PDA. Using Satellite Forms, MS Access and Pocket PC developed several forms for the Egyptian Air Force Base Activation Program.

Confidential

Senior Software Engineer

Technical Lead/Project Manager for Starnet web site.
Design, create, maintain and monitor ASP web pages including Sybase stored procedures, Visual Basic components, JavaScript code, VBScript code and Crystal Reports files.
Enhance and maintain Docupact web site.
Improved the post-replication process from four hours to thirty seconds by re-designing and re-writing several Sybase stored procedures.

Confidential

DBA/Web Developer

Design, build maintain Kiosk Statistics Website using Visual Interdev, ASP MS SQL Server 7.0.
Design, create, maintain monitor Databases in MS SQL Server 7.0 including writing stored procedures, replication, writing database schema scripts, creating scheduled jobs backup of schema scripts.
Enhance maintain Kiosk Inventory Database using MS Access '97.
Analyze test ASP programs and MS SQL Server stored procedures for Y2K compliance.
Design write the Kiosk Stats Website System's Y2K Compliance Document.
Design write the DBA: Security Operations Guide for DriverNet.Com.

Confidential

Programmer

Analyzed solved various problems in MS Access, MS SQL Server, Progress and MS Excel i.e. using VBA for the I/S Maintenance Department.
Designed built a financial data dictionary system in MS Access i.e. using VBA for Houston subsidiary.
Tested Analyzed computer programs for the Company's Summer '98 Upgrade for the I/S Quality Assurance Department.
Designed built Company's Online Reference Manual known as the FerrellWayOnLine using Adobe Acrobat Exchange.

Confidential

Systems Analyst / Project Manager

Consulted Leavenworth Police Department in design of their GIS
using ArcView software on PC.
Contracted services to produce and maintain thematic maps and database for Sprint PCS for their Intranet WebPages using MapInfo software and HTML programming language.
Managed and Implemented GIS market analysis project using
MapInfo for Datacore KC marketing firm.
Designed and developed Desktop Mapping Division's specifications for its home page.
Coordinated and marketed the Company's products and services at the ITEC Exposition Trade Show in Kansas City.