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 Confidential .

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

Confidential

Responsibilities:

• 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.

Confidential, Oakland, CA

Responsibilities:

• 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

Confidential, Walnut Creek, CA

Responsibilities:

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

Confidential, San Ramon, CA

Responsibilities:

• 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 Confidential & Confidential 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.

Confidential, San Francisco, CA

Responsibilities:

• 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.

Confidential, San Leandro, CA

Software Engineer

Responsibilities:

• 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

Confidential, Sausalito, CA

Senior Software Engineer

Responsibilities:

• 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

Confidential, Concord, CA

Responsibilities:

• 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 Confidential 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.