Qualifications:

• Mature, responsible, careful and dependable Application Developer/DBA/SQL Developer in either a Client-Server or Internet/Intranet environment using programming, reporting, database and Internet/Intranet technologies. Versatile and dependable in addressing a wide range of tasks and responsibilities. Accustomed to wearing many hats at the same time in the accomplishment of the mission.
• An analytical, independent thinker with the unique ability to cut to the heart of any situation and quickly determine the best and fastest way to proceed. Especially capable in supporting, troubleshooting and modifying old code in existing projects and finding the solution to difficult problems.
• Has used relational database systems extensively. Has from one to ten years experience with MS SQL Server, Sybase, Informix, MS Access and Btrieve. Has per formed DBA duties at different posts and has experience installing SQL Server Versions 7, 2000 and 2005, backups, database modeling and creating, indexing, stored procedures, triggers, etc.
• Is very experienced in working directly with the customers to best determine their needs and to continue to work closely with them throughout the project, moving quickly to address any concerns, ideas or further specifications that may be brought to light throughout the process.
• Experienced in Full Lifecycle processes as well as simply coding individual modules of project.
• Extensive experience with Crystal Reports from 1994 until present. Have worked integrating reporting capabilities in almost every project with which I have been associated.
• Experienced producing new and legacy apps for both financial/banking and mortgage company applications.
• Worked on many special projects for IT Managers and Project Managers.

Work History:

Confidential

• Modifying poorly-designed vb.net applications to make them work again and enhancements for same. Also writing stored procedures to gather, analyze and disseminate data from raw data brought in. Wrote email alert applications that track periodic cash distributions, stock sells and buys and cash onhand to alert user if intervention is needed to replenish cash level for distribution. Wrote application that sends alert emails when account cash inflow/outflow trips one of several preset trigger conditions . Rewrote document-handling application that assembles, merges and spools periodic and ad hoc mailings to clients. This application was also not working. Wrote application to pull 39,000 ticker listings from stock site and put them into SQL Server for use of tracking applications. Finally, am modifying web sites written in asp.net and vb.net for internal operations as well as client-facing website to make them work properly, look more professional and work faster.

Confidential

• VSTS/TFS 2008 Admin and helping Web Support with their data problems as part of large mainframe to web conversion effort. Worked with VSTS/TFS 2005, 2008 in setting up structure and security for the Safety-Kleen Koala project and created Sql Server 2005 stored procedures and dtsx packages for data transfer and conversion. Acted as Support Person for Project Works 3.0, an application that handled most of the company's Customer Support, PO creation and tracking, sales and Branch Activity Management. Performed duties as Build Manager for the conversion project and Performed various duties to assist the Coordinator, Coordinated Testing. These tasks were performed more or less concurrently. Did substantial amount of ad hoc SQL Server querying and stored procedures to solve problems in a dynamic atmosphere.

Confidential

• Jack Henry and Associates Administered database servers and created tables, stored procedures, maintenance plans, etc., for large commercial banking application project. Advised on tools and methods for data acquisition and storage as well as creating stored procedures to handle all database calls for application developers. Also used ASP.NET to modify web UI's to new specifications

Confidential

• Worked with Actuarial unit automating Excel spreadsheets using Excel 2003, Sql Server 2000, DTS and VBA. Converted data to pull from spreadsheets and put into tables I created for future use.

Confidential

• Worked with CPBA Reporting unit in Las Colinas and remotely with same unit in Washington state. Created and updated operations reports tracking worldwide software support and support vendors using SQL Server 2000, 2005, SQL Server2005 BI, Visual Basic 6.0 and .Net and VBA. Performed 30 adhoc querying and reporting, 40 VBA Excel automation and 30 job and database maintenance. Also created adhoc reports for customers and automated reports using SQL Server Reporting Services, Excel 2003, Excel 2007 and VBA.

• Daily use of T-SQL, Stored Procedures, Triggers, Functions, Joins inner, left, right... .
• Created adhoc queries in SQL Server 2000 and 2005.
• Creating Tables, creating and executing Views, UDF's and Stored Procedures.
• Created and deployed DTS and DTSX Packages SQL Server 2000 and SQL Server 2005 for database and data conversion operations including the use of Visual Basic 6.0, .Net, or VBScript to import and export text files.
• Understanding ER diagrams.
• Understanding how to read and optimize Execution Plans.
• Set up SQL Server security, including role based permissions.
• Setup databases on three remote servers and created maintenance plans for data backup.
• Worked with three remote servers and seventeen linked servers.
• Queries written comprised multiple complex inner, outer and self-joins.
• Setup or modified SQL Server Agent jobs for daily, weekly and monthly runs.

Confidential

Created extensive parts management/forecasting application using VB6, VB.Net, SQL Server 2005, Crystal Reports 9. Application tracked PO's, Sales Orders, Inventory in addition to parts management and complex order forecasting component. Utilized SQL Server 2005 with 39 permanent tables, 8 temporary tables and 20 views. Also created Filewatcher program that sits in memory and watches for .XLS tables to be transferred, transfers data to permanent tables and moves .XLS files to converted directory weekly. App then sends emails to designated mailing list listing files transferred and number of records applied. Handled all duties related to administration of SQL Server 2005 databases including replication, backups, tuning, stored procedures, triggers, etc.

Confidential

Worked on extremely large Quick Basic 7.0 application that handled all warehouse inventory along with some POS and internal financial operations. Also performed limited VB 6.0 work, mostly applications to allow QA to simulate up to 9999 stores and their I/O operations for load testing. During this period was involved in non-stop application modification and debugging of existing problems with the application. QB application consisted of approximately 600 individual modules. Performed adhoc queries on request in Btrieve database.

Confidential

• Work with my own company doing short-term projects and enhancements for various other small companies, including:
• Visual Basic 6.0 and Crystal Reports Ver. 9.0 for various
• companies on contract.
• A Web-based application in ASP which allows a church's members to discover their Spiritual Gift or Gifts
• ASP enhancements to existing Web sites as well as new ASP modules and pages, and Seagate Crystal Reports creation and enhancements for various companies on contract.

Confidential

Replaced three programmers working on ASP, VB 6.0, and Delphi 5.0 applications. Maintained applications for six months while turnkey mortgage system was rolled out. Performed adhoc reporting in Crystal 8.0 and adhoc querying in SQL Server 7.0 on request from users. Also performed application modifications in aforementioned languages on request from users.

Confidential

Worked on modifying and debugging a commercial POS system using Microsoft Visual Studio 6.0, Microsoft Visual Basic 6.0 and Com. Performed modifications on the source code of the application to debug built-in errors and add new functionality. Utilized Crystal Reports 8.5 to add reporting functionality to application. Also did some end-user training.

Confidential

Worked on a commercial application that handled commercial banking monetary transfers electronic commercial banking . Application to be distributed to over 700 commercial banks and their satellites. Worked on special project for the IT Manager testing the viability of changing development environment from primarily Microsoft Visual Interdev with large amount of hand-written code to using Dreamweaver Ultradev for most of the code production. This was complicated by the necessity to dynamically build GUI menus based on UserID security parameters and permissions. Also worked out connectivity challenges using SQL Server 7.0 for the database server. Created large number of custom reports for application effort using Seagate Crystal Reports 8.0. Reports were published to the Web server, making them quickly available online from any satellite office. Main focus of this effort was to create dynamic reports, using parameters supplied by the user at runtime as well as permissions for that UserID. Reports could display or suppress information based on permissions. Wrote ASP scripting for the banking application as well as for the dynamic GUI's in JavaScript and VBScript.

Confidential

Planning, layout and creation of new reports using Seagate Crystal Reports 8.0. Gathered information and specifications from users and company reps for in-depth reporting from Hospital Emergency Room data. Web-enabled same reports for use in intranet reporting to be developed. Analyzed and recommended tools to be used for ad-hoc reporting from within company-created, proprietary software. Rewrote existing reports from ReportFX to Crystal 8.0.

Confidential

Developer

• Adams Golf - Worked on project implementing PeopleSoft package. Wrote custom reports and applets in SQR. Also wrote COM Objects to convert, manipulate and to integrate data from Siebel Call Center application into SQL Server databases and allow reporting from same. Wrote custom reports in Seagate Crystal Reports 7.0. Performed some end-user training on reporting and applications I had created.
• Affiliated Computer Services - Worked on ATM check cashing project using Microsoft Visual Basic 6.0. Installed, setup and maintained SQL Server 7.0 database handling all replication, BCP, backups, tuning, stored procedures, etc. Wrote interfaces and logic to do data maintenance, call center maintenance and user maintenance using VB 6.0, MS SQL Server 7.0, COM, DCOM, etc. Worked on ATM replenishment project using Microsoft Visual Basic 5.0. Wrote interfaces and logic to take input file, convert and distribute data to various tables, allow for manual data entry and output routing sheets for ATM replenishment.
• Also performed SQL Server DBA tech interviews for prospective DBA candidates.

Confidential

Consultant/Programmer/Software Systems Support

Texas Instruments - Worked on converting a Microsoft Visual Basic 3.0 project to Microsoft Visual Basic 5.0 which used an SQL Server 6.5 database in an SAP environment to serve up technical drawings. Wrote custom reports in Seagate Crystal Reports 6.0.

Confidential

Wrote, tested and deployed Unix scripts for data reporting using Oracle database. End-user training performed for script selection and execution. This was a short-term, fill-in contract.

Confidential

Systems Support

The Associates, Auto Club Division - Worked on project to upgrade and maintain a Clipper application in preparation for conversion to C application. Data was in Sybase SQL Server on Unix and DB2 on Mainframe. This included writing enhancements per user request, responding to user bug reports, etc. Performed on-call duties maintaining 24/7 batch runs controlled by CA Unicenter. Maintained and debugged Unicenter scripts for batch runs. Also wrote new scripts for enhancements new to the run. Responded to customer requests for database runs and conversions and interfacing through Unix and OS2 to a high-speed datacard machine. Provided all programming work pertaining to a new business project in Mexico for Mazda, Ferrari, Ford and Lincoln. This involved writing software to handle character conversion between Spanish/English characters in data conversion, end-user training on the Mexico project and reporting.

Confidential

Worked on writing installation scripts for commercial gas/oil well maintenance, utilization and aging software program and VBA scripts to help integrate Microsoft Excel Spreadsheets into existing software. This included writing custom reports and report enhancements per user request in Seagate Crystal Reports 5.0.

Confidential

Wrote Web-based application for a marketing company using the Microsoft Visual InterDev 5.0, ASP, Microsoft IIS 4.0 and 5.0, COM, HTML and HotMetal Pro to capture, maintain and disseminate their data in Microsoft SQL Server 6.5 format to and from remote company sites and customers. Application provided site for customers to place orders and for local and remote company sites to handle order tracking and fulfillment.

Confidential

Systems Support

Projects included programming in CA Visual Objects, Microsoft Visual Basic 3.0/4.0, Delphi 1.0, Seagate Crystal Reports , COM/DCOM, PowerBuilder 4.0 and 5.0, SQR, Sybase SQL Server Ver. 4.2, 10 and 11, Microsoft SQL Server Ver. 6.0 and 6.5, Watcom SQL, Sybase, Windows, Unix and DOS environments.

Confidential

Projects include working on complete commercial software package for warehousing solution at a Michigan firm including R/AP/GL/Inventory/Invoicing/Item Tracking/Order Tracking/RF Barcoding, etc, in Microsoft Visual Basic.

Confidential

Project was an Inventory/Equipment Tracking/Maintenance Tracking/Equipment Order system in Microsoft Visual Basic 3.0 and 4.0 and COM/DCOM for an engineering firm. Data was downloaded and converted from Informix database used by Engineering Design group to Microsoft Access 2.5. All equipment was kept in high-security stocking room and used RF Barcoding to keep track of locations, etc. This included writing custom reports per user request in Seagate Crystal Reports. Also performed extensive end-user training in the proper use and utilization of the product.

Confidential

• Worked on complete plant system for large glass manufacturer which included all accounting functions, as well as Inventory management and tracking of plant functions such as maintenance, safety, materials ordering, etc. This was begun in CA Visual Objects and finished in Microsoft Visual Basic 4.0. Project rolled out to 40 locations worldwide.
• Caliber Logistics - Worked for 22 months doing software/customer support in large logistics firm. Primarily worked on new SQR reports and maintenance and troubleshooting of existing SQR reporting systems and Sybase 10 11 databases. Reporting ran the gamut from inventory, order entry, order tracking to AR/AP/Invoicing calculations and printouts and EDI reception and conversion programs. This was in a UNIX environment using Sybase SQL Server Ver. 4.2, 10 11, and SQR 2.1 and 3.0. Worked very closely with the end-users doing end-user training on proper execution of the EDI programs and the SQR reporting which I was creating for them. During this time, I was personally supporting over 30 separate call centers, each one handling all logistics for a major national or international client.

Confidential

Programmed custom interfaces and data manipulation programs in Microsoft Visual Basic 3.0 and Clipper 5.2 using Btrieve for the database and indexes. Worked on complete in-house system for large distributor of novelty items and videos including Inventory, Order Entry, Invoicing, Telephone Sales, Order Tracking, Warehousing, Purchasing, Barcoding for invoicing and inventory, Payroll and Shipping. Custom reporting via Seagate Crystal Reports.

Confidential

Worked on Inventory/Purchasing/Sales Tracking system in Clipper 5.2 using Btrieve. This system tracked sales at all permanently-located food and novelty vendors, as well as a large number of rolling food and novelty kiosks. This system also monitored all sales, adjusting inventory in real-time and checking inventory levels with every transaction.

Confidential

• Microcomputer Service Technology
• Full-time, certified teaching position teaching Basic Computer Service, Operating Systems, proper Software Use, Installation and Troubleshooting, Network Technology, and Programming. Also performed contract maintenance of four in-house Novell Networks, three of which were utilized primarily for instruction and one which controlled all administrative functions of the Adult Education Department. Served as Network Administrator on two of the instructional networks and the one in Adult Education. Also performed contract work from 1991 to 1993 maintaining the Adult Education Network and writing custom database manipulation and reporting software in Foxpro 2.5 to improve administrative functions.