Project Sql Server

Dear Hiring Manager:

I am seeking to obtain position with a firm that will utilize my broad knowledge as a data analyst, project manager, system designer, or programmer.

My more than twenty-five years’ design experience spans across industries, from medical billing to manufacturing and supply chain. In these projects, my principal responsibility has been the design and programming of custom systems for many different firms, utilizing the major computer languages and hardware.

For the last ten years I have been working as a subcontractor for consulting firms writing Microsoft Visual Basic, .Net applications using SQL Server databases. Also during this time, I have designed web-based applications using Visual Basic, Javascript, ASP.Net, HTML and AJAX.

My primary strength is in determining requirements; designing and implementing the system solution that will best meet my clients’ business objectives, managing the project through full life cycle.

I am looking for projects that can use my background in system design and programming to develop and improve business systems.

My ideal position would consist of the following

• System design

• New system development or upgrade

• Creative team environment

I would like the opportunity to discuss my background in more detail.

Please call 513-***-**** or reply via e-mail to ************@*******.***

Thank you in advance for your kind consideration.

David R. Farris

Position: Business Analyst/System Analyst/ Programmer

Background Knowledge: Strong Data Modeling and System Design Skills

Recent Technical Background: ASP.net 3.5 using Visual Basic, Ajax, Visual Basic.Net 2010, .Net 2008, SQL Server 2008 Crystal Reports 2008, SQL Server Reporting Services 2008

Past Technical Background: VB.Net 2002-2008, Visual Basic 3-6, Crystal Reports 3-11.5,

SQL Server 2005, 2000, 7.0, MS Access 2-2000, HTML, ASP, Javascript, VBbscript

Education: Ohio State University, Youngstown State University Computer Science

Work History:

2011 Contractor PNC Bank

2011 Contractor Grote Manufacturing

2011 Volunteer United Cerebral Palsy Cincinnati

2009-2011 Employee State of Kentucky as a Data Analyst

2007-2008 Employee of CPI World

1991-2007 Farris Consulting (Owner) Freelance Consultant/Contractor

1986-1991 Leahy-Farris & Company (Partner) Software Consulting Firm

1980-1985 Farris Consulting (Owner) Freelance Consultant/Contractor

Sample of Project Design History:

Quote Bid Tracking System, Data Warehouse setup and reporting

Real Time SPC interface for product testing for quality control

Production control for manufacturing of lens

Activex.dll interface to statistical process control Software

Employee Time Entry System, Order Entry System

Stand Alone Salesman Quoting System, Order Process System

Bill of Material System, Purchasing System

Tax Preparation Software, Remote Ordering/Quoting System Digital Catalog

Sales Reporting, Mail List, System conversions

Custom Distribution systems for office supply companies, Medical Billing systems

Work Experience:

Consulting last 30 years as Business Analyst, computer consultant/programmer subcontracting projects to software firms.

Sample of Past Clients:

P&G, Hamilton County Purchasing, Vector, AT&T SBC Communications, Ghent, John Morrell, Gardens Alive, Pepsi Cola Bottling, Zontec, Pole/Zero Corp, Super Systems, Liebel-Flarsheim, CAE Ransohoff, Drapery Stitch, Western Southern Life, Office Depot, Frost & Jacobs, GE, B&W Corp, BATUS Corp, J.A. Kindel Co., Shippers Paper Products, Ohio Knife, Slush Puppy

Recent Project History:

Firm: PNC Bank (Contract) Oct. 2011 – Dec. 2011

Language: VB.net 2008, SQL Server 2008, and SQL Reporting Services 2008

Project: Writing Reports for PNC leasing system-using SSRS. Writing conversion programs using VB.net 2008

Firm: Grote Manufacturing (Contract) Madison, Indiana (July 2011-Sept 2011)

Language: VB.Net 2010, SQL Server 2008, and ASP. Net, JavaScript, Ajax

Project: Intranet project to write and update current VB.Net 2010 ASP.Net Manufacturing applications. Project included pulling and updating data from an AS/400 computer and writing reports using Crystal Reports.

Firm: United Cerebral Palsy Cincinnati May 2011-June 2011 (Volunteer)

Language: VB.Net 2008, SQL Server 2008

Project: Design and write software to allow clients to use PC’s to be able to use the Internet and to control the PC. For the past 1 years I have been working part time writing software for Children’s Hospital and United Cerebral Palsy to help clients work with PC’s. These projects have included custom web browsers, web page readers and head tracking software using web cams and EGG devices.

Firm: State of Kentucky NKADD, Nov. 2009 – May 2011) (Employee)

Language: VB.Net 2008, SQL Server 2008, and ASP.Net and Crystal Reports 2008

Database: SQL Server 2008

Hardware: Windows Server 2008

Projects: Design and build intranet projects for food warehouse which was an purchasing and inventory order entry system for food distribution, Training request system for state financial aid tracking students performance and expenses from entry to exit and training provided

Firm: Private Investment Group June. 2009 – Nov. 2009) (Contractor)

Language: VB.Net 2008

Database: None

Hardware: Windows XP, EEG device

Project: This project is to connect a Windows PC to a new EEG device and to record reading to allow for machine control by using the EEG biofeedback. I have a non-discloser agreement with this firm and cannot disclose the firm or the product that is being developed. This project is finishing the proof of concept and may continue into phase two.

Firm: Drapery Stitch May, 2009 – June, 2009) (Contractor)

Language: ASP.net VB.Net

Database: SQL Server 2000

Hardware: Windows 2003

Project: Web Site upgrade, Design and programming www.draperystitch.com

Firm: PoleZero Corp Dec. 2008 – May, 2009) (Contractor)

Language: SQL Server Reporting Services 2005, VB.Net, and SQL

Database: Oracle

Hardware: Windows 2003

Project: Report writing for an ERP package using SSRS and VB.Net

Responsibilities: Design and write reports for an installed ERP package

Firm: Siemens IT Solutions. Oct. 2008 – Dec, 2008) (Contractor)

Language: Visual Basic 2005, ASP.Net 2.0, and SSRS

Database: SQL Server 2005

Hardware: Windows 2003

Project: Work with Siemens IT call in support center to work on data reporting issues

Responsibilities: Design and fix web-based reports being used by customers and employees

Firm: Drapery Stitch. Aug. 2008 – Oct. 2008 (Short term contract)

Language: Visual Basic 2008, ASP.Net 3.5

Database: SQL Server 2005

Hardware: Windows 2003

Project: Transfer customer data to a web server with updates to the current status of orders. Customers should be allowed to login to the web site to check order status and inventory levels for items they have ordered. This system is designed to cut down on phone calls from customers. For orders that are short inventory, generate a PDF report and attach it to an email to notify the customer of the issue.

Responsibilities: Design a system that will run once a day that will connect to a web server database and update all active orders. The system should update new web users logons based on new customers from the current customer table.

Firm: CPI International July 2007-Aug 2008 (As Employee) (Project Canceled)

Language ASP.Net 2.0 using VB 2005.net, Crystal Reports

Database: SQL Server 2005, SQL Server 2000

Hardware: Windows 2003

Project: Redesign an outplacement web site that allows coaching of employees that have been let go from firms. The software would track the progress of the candidates as they looked for new positions. The system would allow for dynamic web pages to be generated base on the candidates setup. As part of this project, a report generator was built, allowing for easy data extract from the system databases. The site was to translate all screen based on the language of the user logging into the system. This design was based on an open source product called DOTNETNUKE approach to a site portal.

Responsibilities: Redesign and move current software to ASP 3.0 and SQL Server 2005. Design an easy to setup and run report generator based on selected fields from the database. The generator will find all the relationships between data with the database and build the SQL query to run the request. Also data filters would be generated, allowing for selection of date and data ranges. Reports could be exported to Excel or printed.

Firm: HWS- Sogeti Feb. 2007 – July 2007 (As Farris Consulting)

Language: ASP.Net 2.0 using Visual Basic, VB 2005.net, Crystal Reports 11.5

Database: SQL Server 2005

Hardware: Windows 2000

Project: Build a VB 2005.Net, SQL Server 2005 front end to allow Crystal Reports to batch processed and assigned to business groups by user level security.

Responsibilities: Business Analyst, working with business groups to establish reporting needs and security. Based on these requirements, setup the necessary databases and data to support this system using VB.net and SQL Server 2005

Firm: P&G/HP Oct. 2006 – Jan. 2007 (As Farris Consulting)

Language: VB 2005.net, Access Reports

Database: Access 2000, SQL Server 2000

Hardware: Windows 2000

Project: Business Analyst, Building Proof of Concept for planning traffic needs between P&G’s manufacturing plants and two customers. This prototype system was designed to calculate the weekly trucking demands for manufacturing plants shipping to customers’ warehouses. Once the proof of concept was completed, P&G would contract to build a full worldwide system.

Responsibilities: Work with design team to program a test system using VB.net and Access 2000 based on the proof of concept design. This system would not be used in the final product, but would establish that the design would provide the necessary data to justify the next phase of the project.

Firm: MAP Software Aug 2006 – Sept 2006 (As Farris Consulting)

Language: Crystal Reports 10

Database: Oracle 8.1

Hardware: Windows 2000

Project: Help upgrade current software package Crystal Reports

Responsibilities: Redesign Current Crystal Report to Run Under New Upgrade

Scope of project: Short tem project to convert system reports to new release of MAPSoftware’s package software.

Firm: Hamilton County Purchasing Oct. 2005 – Aug. 2006 (As Farris Consulting)

Language: Visual Basic.Net 2002, 2005, Crystal Reports 11.5 and SQL

Database: SQL Server 2000

Hardware: Windows 2000

Project: Develop Bid Tracking System for Hamilton County for vendor quotes.

Responsibilities: Business Analyst, system designer and programmer.

Scope of project: Hamilton County required a system to compare bids from different vendors and to track bid history and performance. This system required that all bid activity for each vendor be tracked allowing for different price breaks and units of measure and substitute products from each vendor.

Firm: SBC Communications, Cincinnati Group Oct. 2004 – Sept 2005 (As Farris Consulting)

Language: Visual Basic. Net, Visual Basic 6, Crystal Reports 9.0 and SQL

Database: SQL Server 2000/ 7.0

Hardware: Windows 2000

Project: Develop Hazardous Material Disposition System for tracking the disposal of materials used by SBC Communication countrywide.

Responsibilities: Business Analyst, system designer to re-design and expanded the current software system to meet EPA requirements for hazardous materials. This requires auto updates for software and reports to different locations throughout the United States.

Scope of project: SBC Communications is in the process of consolidating all hazardous materials report to one central location. This system must report all hazardous material disposals from its locations within the United States to meet EPA requirements.

Firm: John Morrell Co. Aug. 2004 - Sept. 2004 (Project Canceled) (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 8.5 and SQL

Database: SQL Server 2000

Hardware: Windows 2000

Project: Develop Work in Process System for meat processing/packing.

Responsibilities: Work with design team to re-write current WIP system.

Scope of project: John Morrell is the third largest meat processing company in America. With multiple locations and systems. This project was to update the current WIP systems in place and to standardize all locations. This would enable consistent data collection and standard data warehouse reporting on performance and production output for each location.

Firm: Drapery Stitch. May 2004 – July 2004 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 9.0 and SQL

Database: SQL Server 2000, Access 2000

Hardware: Windows XP

Project: Upgrade MS Access 2000 to SQL Server 2000, Upgrade Crystal to 9.0

Responsibilities: Convert VB 6 programs without major changes from Access 2000 to SQL Server 2000.

Scope of project: The current software was written using DAO access. Any changes to this method would require major changes to the existing logic. The upgrade needed to continue to use DAO and still run under SQL 2000. Using linked table in MS Access 2000 allowed the existing access method to be used and to upgrade the database to SQL Server.

Firm: Gardens Alive Sept. 2003 – April 2004 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 9.0, MS DTS and SQL

Database: SQL Server 2000

Hardware: Windows 2000

Project: Build Data-warehouse Reporting System.

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: Transfer data from legacy order processing system into a SQL Server 2000 database for data management reports. This required the analyst of system requirements and reporting needs for millions of transactions. This required writing some MS DTS procedures to import text files from the legacy system into a new database format for reporting. As part of this project a Crystal Reports reporting front end was written to allow for easy reporting control and setup. This Data Warehouse reporting control restricted user access to reports and to database tables.

Firm: Pepsi Cola Bottling USA. May 2003 - Aug. 2003 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 9.0

Database: Access 2000. SQL Server 2000

Hardware: Windows 2000

Project: Upgrade current SPC quality testing system

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: Develop quality control testing system to interface to testing equipment and send the testing results to the quality control database at the home office. The home office would controlled of all testing update and synchronize all 16 local databases.

This system was designed to synchronize 16 plant databases with a home office server, sending transactions in both directions. These transactions would send testing data and database updates to insure that all systems were current. If a batch of transactions failed, all updates would be rolled back to before the update. If a system went offline, the transactions would be queued and transmitted when the systems connected.

Firm: Drapery Stitch. Jan. 2003 - May 2003 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 8.5

Database: Access 2000

Hardware: Windows XP

Project: Write Purchasing System

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: Develop a purchase order system for ordering inventory based off reorder points and order demand. This system was an addition to an existing package to provide better inventory control and reduce cost.

Firm: Clinical Supply Co. Oct. 2002 - Jan. 2003 (As Farris Consulting)

Language: Visual Basic 6, ASP, VBscript, Javascript, and Crystal Reports

Database: SQL Server 2000

Hardware: Windows NT

Project: Web site for Order Entry www.clinicalsupply.us

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: Write a web-based order processing system.

Firm: Zontec/Pepsi Cola Bottling USA April 2002 – Dec 2002 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 8.5

Database Access 2000, SQL Server 2000

Hardware: Window XP, Windows 2000

Project: Write product testing software for Pepsi to interface between lab product testing equipment and Zontec statistical software.

Responsibilities: Business Analyst, System Designer and Programmer

Scope of Project: Project was to design and program a product testing system for Pepsi Bottling. This system was to provide Pepsi with product testing data based on production around the country and to transfer the data to the quality control center at Pepsi corporate. The data will be transferred to Zontec’s Synergy 2000 statistical package for reporting.

Firm: Zontec Feb 2002 – March. 2002 (As Farris Consulting)

Language: Visual Basic 6

Database: SQL Server 7.0, Access 2000

Hardware: Window NT, 98

Project: Write a Visual Basic Interface between SQL Server 7.0 and a statistical process control Software using Activex.DLL.

Responsibilities: Business Analyst, System Designer and Programmer

Scope of Project: This project was to build an interface between Zontec statistical software and SQL Server using a DLL provided by Zontec to import data. This project was to demonstrate that Zontec software could import data from SQL Server into their statistical package. As part of this project an Activex.DLL was written for Zontec customers.

Firm: Super Systems Oct. 2001 – June 2002 (As Farris Consulting)

Language: Visual Basic 6, Crystal 8.5

Database: Access 2000

Hardware: Window 98, Windows NT

Project: Production control package to track the processing of eyeglass lens

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: This project was designed to track the receiving, production and processing of lens as they pass between work locations, recording detail information on the length of time each process took, as well as the state of the production process.

Firm: Pole/Zero Corp. Jan 2001 – Oct 2001 (As Farris Consulting)

Language: Visual Basic 6, Crystal Reports 8.5

Database: Access 2000

Hardware: Windows NT

Project: Employee time entry reporting system

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: This project was designed to collect employee time for manufacturing job management. Each employee would be required to enter time based on the job and project they were working on. This time would then be sent to the supervisor for approval. Once approved, the time would be submitted to the accounting department to be posted to an ADP payroll system. The system was designed to allow for multilevel control of system functions, based on a user’s security level, allowing for users to be restricted to only functions assigned to their security levels. A subsystem using Crystal Reports was installed allowing for a user-friendly report processing system.

Firm: Super Systems Feb. 2001 – Feb 2002 (As Farris Consulting)

Language: Visual Basic 6

Database: Access 2000

Hardware: Window 98

Project: Convert software written in VB 3 to VB 6

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: This project was to convert existing software that was designed to grind lens to Visual Basic 6. As part of this conversion process, the software was to be upgraded to take advantage of the newer features in Visual Basic 6.

Firm: BallsofAllSports.com Jan. 2001 – Aug 2001 (As Farris Consulting)

Language: VBscript, ASP, Javascript and HTML

Database: Access 2000 / SQL Server 7

Hardware: Windows NT

Project: Web-based order entry system for sporting goods distributing company.

Responsibilities: Business Analyst, System Designer and Programmer

Scope of Project: Balls of All Sports, is a supplier of sports balls to schools within the USA. This project was to design and program a web-based order processing system, allowing for special pricing based on quantity discounts, buy one product and get one free, and discounted products. Orders within this system used the Versign credit card processing systems to process orders.

Firm: E-FindBiz.com Aug. 2000 – Jan 2001 (As Farris Consulting)

Language: HTML, ASP, Javascript, and VBScript

Database: SQL Server 7.0

Hardware: Windows NT

Project: Business Directory System

Responsibilities: Business Analyst, System Designer and Programmer

Scope of Project: e-findbiz.com is a business directory for the Cincinnati, Ohio area. My task in this project was to design a classified ad sub-system for the site.

Firm: Liebel-Flarsheim/Tyco Nov. 1999 – Feb. 2002 (As Farris Consulting)

Language: Visual Basic 6

Database: Access 97

Hardware: Windows NT

Project: Sales Rep Quoting System

Responsibilities: Business Analyst, System Designer and Programmer

Scope of project: This project was designed to allow sales reps within the United States to enter quotes for medical equipment and send these quotes to the local home office to be processed. As part of this transfer process, quotes generated by the sales rep and the home office would be sent and sales reps’ PC’s would be updated to the latest machine configurations for parts and prices.

Firm: Liebel-Flarsheim/Tyco Nov. 2001 – Feb. 2002 (As Farris Consulting)

Language: Visual Basic 6

Database: Access 97

Hardware: Windows NT

Project: Continues Improvement System

Responsibilities: System Design Programming, Project Management

Scope of project: This project was designed to follow request for product changes or request for

Improvements in work processes. The system would track the initial request to completion allowing for assignment of responsibilities to the request and tracking the progress of the request until competition. All employees within the company would have access to the system and would have the ability to follow the progress of the request made.

Firm: CAE Ransohof Nov. 1996 – Aug. 2001 (As Farris Consulting)

Language: Visual Basic 6

Database: SQL 7.0 Access 97

Hardware: Windows NT 4.0

Project: Bill of Material, Purchasing System

Responsibilities: System Design, Programming and Project Management

Scope of project: CAE Ransohof is a manufacturer of industrial cleaning equipment. This project was to design and program a parts ordering system to interface into a purchasing system to order parts from suppliers based on customer machine designs. Each engineer would select the parts from lists of stock and non-stock parts and submit the list to purchasing. Purchasing would then select which parts to order from their vendor list and submit a purchase order. All changes made by engineering would be transferred to purchasing to update current purchase orders. Purchase orders received would be entered and existing purchase orders would be updated and the transactions sent to engineering to update the engineering drawings. This system was designed to allow for changes to be made as a machine was designed and to update the purchasing system with the current status of each job.

Firm: Drapery Stitch Aug. 1996 – Feb. 2002 (As Farris Consulting)

Language: Visual Basic 6

Database Access 97

Hardware: Window NT 4.0

Project: Manufacturing System, Order/Quoting System

Responsibilities: System Design, Programming and Project Management

Scope of project: Drapery Stitch is a custom drapery manufacturer for designers within the Cincinnati area. Each production job required custom material selection along with production processes to complete the manufacturing of the product. This system allowed for receiving of product for production and the tracking of all aspects of production until competition and shipping. The design converted Ordering, quoting and invoicing as part of the overall design.

For project prior to 1996, request projects dates and companies.

Contact this candidate