SUMMARY:

• Microsoft SQL Server 2016/2014/2012/2008 R2/2005/2000 Database Development
• DBA (Database Administrator); Backup Solutions, Maintenance, Performance Tuning, Monitoring
• SSIS, SSRS (2015/2010/2008 ), Custom ETL, DTS support and conversion to SSIS
• Microsoft VB.NET (2017/2015/2012/2010/2008/2005/2003 ), ASP.NET; Web/Win/Console
• Microsoft MapPoint, Excel and Word API (object library) wrapping with VB; also, VBA directly
• Banking, al, Manufacturing, Financial, Healthcare, Marketing, Distribution, Mining
• Integration of Disparate Systems, MS Access upgrades to T - SQL and .NET (and legacy mods)
• Experienced with Mainframe and Distributed Minicomputer Systems (VAX, Prime)
• Data Warehousing, Teradata Experience, Data Analysis and Scrubbing

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• DBA responsible for 23 corporate servers (Microsfot SQL Server), local and remote (as far away as Singapore), for backups (native and IBM Data Protection for SQL as a redundant method), upgrades, monitoring, data migration, file system clean-up and reporting using SSRS and custom generic Web based reporting. Also did application support and specialty routines uing
• VB.Net, SSIS and T-SQL including data refresh from/to various systems including MySQL, server-to-server (local to/from remote), etc, supporting daily operations (product shipping, reporting). Support for various 3rd party vendor needs (almost everything at this client was purchased from a variety of vendors). Custom T-SQL to monitor all servers automatically via meta-information instructional data (a custom central management server). Legacy DTS and MS Access conversions to SSIS and T-SQL and also relocation of MS Access tables to SQL Server

Confidential

Responsibilities:

• Data Warehousing design and implementation, Data Analyses, Performance Tuning and data issue discovery and resolution (identified hundreds of cases where bad data was being brought into the warehouse). Provided data for analytical team usage. Replaced various flush and fill routines that took 10 to 12 hours to run with intelligent routines that take just minutes to run (the data warehouse is populated from a legacy Progress batch collection system).
• Table sizes ranged from 50 million to 1 billion rows. Pre-aggregation of detail data to facilitate reporting (information on demand with no waiting whereas the user community would normally have to wait weeks for custom-programmed reports from the system of record)

Confidential

Responsibilities:

• Sophisticated ETL solutions to retrieve system of record data from legacy systems (OSAS BBx, Foxpro tables) to a central SQL Server database and also importing of State of Ohio data (in pieces) requiring much scrubbing. These are run on demand by the user interface (seeds a table where a sentinel program carries out this and many other tasks on their behalf to ensure no-crash, etc.) and when invoked from the web interface the user is shown status for every step of the job(s) via a recursive page (which reads the log file). A status bar informs the user when the system of record and central database are out of sync when the web interface is not running
• Provided a solid and stable up-to-date infrastructure to permit this small business to replicate its operation to other metro area markets beginning with an attractive two sided invoice (SSRS) where the back side shows the customer’s buying history as well as what they should be buying (based upon what other like-customers are buying). The invoice number is also a barcode that is scanned to a particular route for delivery and also tracked on the daily ledger as being delivered. The invoicing and ledger process are web based vb.net that show a myriad of useful information such as sales commissions (daily and weekly accumulation), a “paid” indicator, a panel of “items not scanned” (invoices are printed when product is orderd) and logic to cancel subsequent credit memos should a manual adjustment be made pre or post ledger
• The scanning process is windows based vb.net wrapping Microsoft Mappoint which optimizes the scanned routing data showing side-by-side maps of the delivery routes and also a combined polyline route map overlay to help identify routing conflicts and potential optimizations
• Similarly, created a sales route mapping interface where the operator chooses a particular planned stop and may visually explore prospects nearby adjusting the highlighted radius circle (and accompanying list) of the search as desired. The purpose of course is to make the route more valuable and reduce delivery costs since a delivery vehicle is already in that area. The base pushpin map is reproduced periodically (automated) from the State of Ohio data, former customers and current customers)

Confidential

Responsibilities:

• Upgraded several of their SSIS packages for certain business funtionality and included verbose logging (isolates performance bottlenecks and pinpoints exact point of failure), quality error handling and the ability to rerun the package from any point of failure without the risk of data corruption. Utilized C# scripting, CHECKPOINTS and SAP BPC Interface scripting via the MODIFYSCRIPT package variable. Also did some Crystal Reports programming, MS Access debugging and SSRS reports

Confidential

Responsibilities:

• Conversion and enhancement of their Loan Modification Program (for loss mitigation) from MS Access to VB .Net Winforms application using SQL Server. This also included a newly designed SQL Server database to accommodate all of the enhancements from the older system for efficiency and performance. The program uses database driven information to dynamically render user input forms so that administrators instead of developers implement future changes to certain data-entry elements. Although the form size is fixed, if an administrator adds more data elements than it can hold, the effected panel (income, expense, calculation) will simple resize horizontally to accommodate and a scroll-bar will appear (then they can choose to leave it as is or struggle with the various business entities and change-control which could take months to get a more definable change implemented requiring the programming staff).
• The audience for this application is 350 users. The updated function of this program enabled the customer (PNC) to increase business with their external financial partners and is therefore a true "highly visible" endeavor as this new version of the program is slated to save many dollars that would have normally been lost due to default by a very large customer base. The program and database are very sophisticated in that all transactions are logged. The calculation of the Loan Modification offers are tracked historically - all inputs and outputs as well as the resulting product-offerings are kept which will be used to fine-hone operational procedures of the negotiators (the 350 user base).
• Programmed various utility programs such as a deployment program that checks for a newer version of the program and automatically down-loads it to the users machine. For first time users, this deployment program checks for various necessary drivers (IBM ODBC) to be installed and gives the user the ability to do such themselves if necessary.
• Programmed a web based feature where an authorized manager can modify the final offering of a loan modification by micro-tweaking the various inputs that drive the calculation engine to where they can easily view the before and after outputs and override the previous offering to the PNC customer resulting in a win-win situation for banker and customer.

Confidential

Responsibilities:

• Confidential processes medicaid claims for various school systems throughout the state of Ohio. Since starting, I’ve repaired damaged and inoperative routines and have enabled them to resume the normal montly billing process for their clients (when I arrived, there wasn’t a billing cycle processed for over 3 months). Since then, I’ve helped them upgrade their systems to SQL 2008 by eliminating DTS as well as porting VB.NET 2003 programs to 2010.
• Did modifications to their ETL routines as the specifications for these have been changed by ODJFS (Ohio Department of Job and Family Services). Most interestingly, one of their clients, the Cincinnatti school district, has chosen to not use the Confidential on-line system and now submits their student data in batch. Here, I created methods to import, scrub and audit the data and insert it into the database while still obeying all of the intrictate and many business rules (including grappling with a compromised improperly overly-normalized database). Furthermore, I’ve taken many of their disconnected distributed processes which took a day or more to complete and made them centralized semi-automatic processes with very few and simple operator controlled steps than are completed in less than an hour.

Confidential

Responsibilities:

• Developed intricate routines with SQL Server 2008 to do on-demand BOM matchups for shipping automotive components as well as receiving the requests for the same. This was some of the most serious intense business requirements I’ve been challenged with as the process of receiving the order and supplying the finished product happens in just a few seconds (regarding the exectution of thousands of lines of T-SQL code), that is, the matching of the entire BOM of the component requested with what’s either in the warehouse or still on the assembly line. Included was an interface that allows part substitutions (user defined) within the BOM seriously tasking SQL Server due to the quantity of inventory being augmented for all parts within the components and add to that various tie-breaking rules such as FIFO status and the actual location of the targeted component in the warehouse.
• The Benteler facility is an independent removed portion of the Chrysler assembly line (about a kilometer in distance). A vehicle enters the Chrysler assembly line and the broadcast is made to Benteler. The requested components are then assembled or pulled from inventory and trucked to the Chrysler assembly line. The penalty for delaying the Chrysler assembly line is $1,000 per minute.
• What further made this project interesting was it was programmed from specification with no real data to test with (other than some pretend data). You see, the broadcast came from a 3rd party vendor (INSequence) and the BOM or “as built” for the component parts came from another 3rd party vendor (PINpoint) and we all came together for go-live with no testing amongst each other (all interfaces were previously simulated with contrived test data with Confidential servers pretending to be the 3rd party real-time feeds including simulating shop floor PLC devices).
• Enlisted by the end client (saw a capable vendor in me) to enhance the Benteler systems that process what’s known as an “early broadcast” which is an advanced notice as to what should be coming in the official broadcast which allows their assembly line to get a head start.
• In summary, you have the cooperation of four separate sophisticated computer systems ( Confidential, Benteler, InSequence and PINpoint) that already existed that were radically altered to accommodate the avant-garde scheme known as the Modular Broadcast being efficient and necessary that allows the end client (Chrysler) to keep a competitive edge in the world automotive market.

Confidential

Responsibilities:

• Creation of the Innovation Fund grant application web/database portions for applicants as well as an administration interface using data driven methods. So, per database encoding, questions are configurable to allow responses in text, check box or option button choice lists. Utilized Ajax to do seamless auto-save as well as JavaScript programming to emulate Excel-type data entry for financial information.
• Continued working small projects, part time with Sirva as well as other former and new clients. Enhancements and maintenance to existing systems, mostly. Programmed new web based application; a sales contact application which allows the users to forecast their sales call goals and track the actual results. This “call log” information on the reporting side is compared to actual data in a 3rd party system so the managers can see how much business (or lack of) may have resulted per the calls. One noteworthy feature is that the sales rep doesn’t have to wait for the sales contact to exist in the 3rd party system.

Confidential

Responsibilities:

• Development of sophisticated SSIS packages to enhance and upgrade their automated survey process involving import/export (Excel, CVS, flat file, database tables/views/procs) to 3rd party processes (internal and external to SIRVA) utilizing many of the advanced features (for/each loops against file directories as well as recordsets, FTP interaction, package encryption which is necessary when scheduling packages that use FTP), common error handling with auto-email, complex scripts and parameter expressions). Also, engineered several work-arounds because SSIS like any newer product just doesn’t function as documented from time to time, for a variety of reasons. Enhancements and maintenance to various internal web interfaces. Heavy data analysis. Normalization of data from various source systems, made common, for data warehouse s and support.

Confidential

Responsibilities:

• Development using VB .Net (Windows, Web and Web Services), SQL Server (stored procedures, views, functions, DTS, design), Crystal and MS Access. Automation of several processes some of which used to require a great deal of manual intervention including daily reporting, the update of their RIS system for Radiologist Transcriptions where the user simply drops a .rtf file prepared outside of the system to a network directory and data screening & export to WebMD. Heavy use of metadata and data driven solutions. Large quantity of ad-hoc data query combining data from as many as three separate and distinct systems in some cases.

Confidential

Responsibilities:

• Development using VB .Net (Windows), SQL Server, Janus controls and Active Reports for this start up scholastic (cosmetology) software firm's turn-key package. Heavy use of stored procedures for feeding the reporting tool Active Reports, an interrupt driven programmatic reporting tool with design features similar to Crystal Reports.

Confidential

Responsibilities:

• Support for various legacy systems including debugging and enhancements. Ported an entire MS Access application that crunches financial data (account roll up) to SQL Server in rder to automate the process as well as to add stability. Database performance tuning.
• Responsible for the maintenance and enhancement of their Financial Consolidation Reporting system - a generic reporting system capable of producing over 900 reports from just a handful of templates.
• This is a Visual Basic .Net Windows application using Crystal Reports Enterprise version 9 calling parameterized stored procedures. The SQL Server 2000 database makes heavy use of Stored Procedures, Views, User Defined Functions and DTS packages. Made several enhancements to this system including performance improvements, a database switching component, automatic data archiving routines and the programming of utility programs (windows and web based) to manipulate the meta-data (previously, a painstaking manual process) that composes these data driven reports. In addition, engineered a change to produce quarterly reports and reports with augmented figures (for hypothetical situations) while staying within the original framework even though it was not originally designed to do this type of thing.

Confidential

Responsibilities:

• Trial Balance software upgrade and performance enhancements from version 1.0 to 1.1 deployed to over 30,000 auditor laptops worldwide. Responsible for data migration from corporate personnel systems to the Novient (3rd party package) resource scheduling system via custom ETL solution. Heavy use of generic parameterized DTS, stored procedures and views. Enhancements and sophisticated migration routines (Transact SQL) for their in-house resource scheduling system to satisfy user requirements during the transition to Novient.
• Performed various tasks (programming, database, web, LAN) including maintenance on previous development as well as new projects, for existing and new clients; Confidential - customer web interfaces for their “tell a friend” and “customer survey” programs as well as a sophisticated data driven reporting engine using winform Crystal Reports against 3rd party demographics including an “import on demand” feature, Confidential - enhancements to their Laue (shop floor x-ray device) data interface, Confidential - new development of an in depth compliance program, SofTrends - customer support (LAN, hardware/software upgrades, web programming), Confidential corp - XML based web class to interface with Verisign credit card validation service.

Confidential

Responsibilities:

• Performed database normalization (table breakup, appropriate indexing, primary/foreign key, etc.) on their call center database. Created a repeatable DTS package to in corporate legacy information into the database (this data pre-dated the existing data collection systems). Developed various VB .Net routines for their new web site including a generic data driven calendar and a rich text display module.

Confidential

Responsibilities:

• Developed database driven Web CRM application for a beverage distributorship using ASP.NET (VB .NET Web Forms) and SQL Server 2000. The application supports the Prospect Call Center and Direct Sales efforts over the Internet. Developed many support modules using Stored Procedures, Triggers, DTS, COM+ and data maintenance programs with VB6, Crystal Reports, Excel Automation and GIS (Geographical Information System) interfaces. Configured IIS for internet and intranet applications, created database redundancy schemes, Local Area Networking and interfaces to existing legacy systems (DOS based and Foxpro).

Confidential

Responsibilities:

• Optimizations for their typical n-tier system programmed in VB 6.0, COM+, and SQL Server 2000. Moved certain middle tier code to the back end to reduce processing time in the middle tier, thereby increasing front-end response time. Implemented replication scheme to reduce risk of down time for this inbound call center application. Completed several front-end enhancements.

Confidential

Responsibilities:

• Converted a semi-automated Castings Measurements tracking system (DOS-based Paradox and a huge collection of Excel sheets) to Visual Basic 6.0 and SQL Server 7 including interfacing to existing and future Excel sheets with OLE Automation (including scraping and population of data at the cell level). Now, a common directory is used to access the Excel and non-Excel data and the Excel sheets are stored in the database. An entire file server and huge mess was eliminated.

Confidential

Responsibilities:

• Performed data conversion (ETL) for the ARMS Scheduling software package to its new version using DTS and custom routines including modifications and configuration of weekly information pulls from their National Information Warehouse, remote PeopleSoft database, and Canada legacy system. Developed the Request Monitor - a generic database driven task scheduling system in VB6 and SQL Server 7 used to control distribution and simultaneous execution of middle tier tasks load balanced across many servers, triggered by the browser front end. This system was key in bridging the gap between Microsoft COM and Java systems. Its myriad features include new object instantiation (by simply adding a row to a database table) and a job "heartbeat" to gather execution statistics.

Confidential

Responsibilities:

• Developed component used to retrieve transactional information from VAX system (for shop floor data collection) and apply it to SQL 7.0 database - the user need only drop in additional stored procedure to handle new transactions (i.e., no maintenance programming). This software runs in tandem with the same on other application servers (if one goes down, the other takes over). Heavy use of stored procedures, DTS, and VB 6.0 / ADO data access methods. Developed similar middle-ware component to move data from SQL Server to VAX via ODBC.

Confidential

Responsibilities:

• Database Administrator/Developer and Software Developer for Assurance Support Center Technology Development department. Responsible for database design, administration, troubleshooting, data modeling, and programming using Microsoft SQL Server 7.0 & 6.5 including triggers, stored procedures, VB 6.0 & 5.0 including ADO, RDO, & DAO data access methods and COM objects.