Sql Server Technical Support

Richard Fehl

925-***-**** ********@***.*** www.linkedin.com/in/rfehl

Database Analyst / Developer

Summary

Over fifteen years development with SQL Server and Oracle as database administrator, business analyst, production support, and report generator.

Twenty years MS Access, Excel and Crystal Reports for finance, health care, and law enforcement.

Ten years full cycle development in Visual Studio using both C# as well as VB.net.

Created applications for industries as diverse as banking, travel, telephone servicing, food distribution, police services, investment portfolios, disaster relief, health care, and pharmaceuticals.

Worked with non-technical people to translate business needs into design specifications and trained users.

Worked on projects that required top security (currency counting, criminal records, and banking).

Created automatic report writers now being used by doctors, insurance companies, banks, police, and the FBI.

Software Skills

SQL Server, DDL, DML, SSIS, SSAS, SSRS, VB, C#, VB.Net. ASP.NET, Java Script, MS Access and MS Office Products (Microsoft Certified), VBA, Oracle, PostgreSQL, SourceSafe, Team Foundation Server, IVR, XML, XSLT, web services, Windows services, Crystal Reports, Visio, ETL

Experience

Independent Contractor, Walnut Creek, CA Aug 2011 - Present

Clients include:

Professional Technical Informational Systems (ProTIS), San Francisco (Dec 2011 – April 2102, Sep 2015 – Sep 2016)

San Francisco, California

Created an application that moves db records to and from SQL Server to Oracle or PostgreSQL without the need of specialized scripting.

Created document tracking software in C# and T_SQL for use in multiple data base platforms, cultures, and languages.

Designed and developed database scripts for SQL Server and PostgreSQL.

Was a database administrator for a network of servers located in Australia, Russia, and the USA.

Superior Court of Alameda County, Oakland, CA (June 2015 – August 2015)

Created an ASP.Net application and a new SQL Server database for the Pretrial Services Department to determine if defendants were eligible for dismissal on their own recognizance. It was based on a study written by the Ohio institute of corrections.

Wrote DML and DDL scripts to manage database design while designing the UI in ASP.net

Wells Capital Management, Walnut Creek, CA (April 2014 – July 2014)

Modified and created accounting applications using SQL Server, C#, SharePoint, and DevExpress controls.

PG&E, San Ramon, CA (April 2012 – December 2013)

Created applications in MS Access, SQL, and Visual Studio for Accounting and Administration thereby lessening the workload for the Technical Support Department.

Created scheduled jobs on the database server to track performance over the statewide PG&E network in reporting new customer utility connections resulting in a ten to fifteen percent increase in company revenue.

Fine tuned database objects and optimized queries in SQL and Oracle running from tables with more than ten million records.

Migrated data using SSIS and created reports, charts, and graphs with SSRS and Crystal Reports.

Developed a more efficient web application for emergency services field technicians by adding a Windows service that automatically completed an Excel document and distributed it to the regional service personnel.

Devised a warning system to monitor application license usage through Oracle and SQL Server

Translated business requirements from project managers into technical specifications for a team of developers.

Worked with vendors to upgrade and enhance telecommunications and knowledge-base software.

Wells Fargo, San Francisco, CA (August 2011 – December 2011)

Added SQL logic to the non-sufficient funds report generator.

Used Visual Studio C# and SQL to add new features to the partially completed Rates Online Editor.

Assigned work groups, roles and privileges to users of financial web applications.

Worked closely with the QA department to deploy applications to production levels.

Jaroth, Inc./PTS (Pacific Telemanagement Services), San Leandro, CA Dec 2010 – Dec 2011

Software Engineer

Added features to an IVR service that allowed tech support to communicate with field service technicians.

Improved security in coin and currency-counting applications which eliminated waste and theft.

Worked on a project for mapping food delivery routes for trucks to cover more territory in less time.

Was promoted to company DBA as well as head of QA because of my “attention to detail”.

Frequently met with company executives to gather business requirements and to demonstrate the latest application software.

Investigated new software add-ons in order to optimize database performance.

Mentored other developers in SQL and ASP.Net

GRS Network / Triton Distribution Systems, Sausalito, CA July 1999 – Dec 2009

Senior Software Engineer

Worked on a Visual Studios/C# application that combined travel inventory from multiple distributors.

Was the company’s first DBA and created all the online travel databases

Created a web service for booking airline and hotel reservations directly from Chinese travel agents in time for the Beijing Olympics.

Lead a team that created a unique Windows application for booking Carnival cruises from the cruise line’s API.

Participated in developing booking applications using multiple API’s and SOAP/XML web services.

Worked on a team that created an Internet based accounting and data analysis system for travel agencies.

Created weekly flight segment reports using SQL Server and Crystal Reports.

Independent Contractor, Walnut Creek, CA March 1994 –July 1999

Clients include:

Concord Police Department, Concord, CA (March 1998 – July 1999)

Created crime statistics analysis software that combined evidence from various SQL databases (finger prints, stolen property license plates, addresses, etc) to expedite crime-solving and produce FBI reports.

Wrote a SQL Server based electronic line-up where selected photos could be screened filtered on data provided by witnesses. Graphics utilized Adobe Photo Shop and Lead Tool Controls.

Ernst and Young, San Francisco, CA (Jan 1998 – March 1998)

Developed a method of producing charts and graphs used in quarterly reports for investment portfolios.

Chevron, San Ramon, CA (December 1997 – January 1998)

Redesigned a program to keep track of internal time-share, and generated invoices.

Budget Car and Truck Rental, South San Francisco, CA (December 1997)

Wrote a program to keep track of commissions that were paid to hotel concierges.

Odwalla, Inc., Half Moon Bay, CA (September 1997 – December 1997)

Created an application for the HR department that area managers used to make changes to the employee records directly on the server while generating E-mail messages to HR.

Andersen Consulting, Chicago, IL and Phoenix, AZ (April 1997 – September 1997)

Created a program to track and reconcile employee relocation expenses.

Pharmacia Biotech, Alameda, CA (December 1996 – April 1997)

Led a team to devise an international database to exchange and update data and provide late-breaking information for sales and marketing.

Federal Home Loan Bank, San Francisco, CA (April 1996 – November 1996)

Built software for Affordable Housing to determine who merited FHLB's special low-interest loans.

Other clients included VISA, Satellite Dialysis, Kenetech Wind Power, and the Hoover Institution.

Education

B.S., Electrical Engineering, University of California, Riverside

A.S., Computer Science, Mission College, Santa Clara, CA

Graduate Studies, Electrical Engineering, UCLA

Contact this candidate