## BIO
**Technical and Management Skill Summary**
· Database design, development, implementation, programming, optimization and data migration
· Microsoft SQL Server Development, Administration, and Business Intelligence (Microsoft Certifications)
· Sharepoint, MS Reporting Services, Crystal Reports, MS Access, FoxPro
· Familiar with .NET technology, XML, Visual Basic, Er*win*, Java script
· Project Management including requirements, budget, resource, schedule, and risk. (MS Project)
· Microsoft Certified Trainer teaching courses at UCSD, Learning Tree, and University of Phoenix
**Personal Skill Summary
** · More than twenty-five years of progressive experience in database design, application development, systems analysis, product development, technical support, and training.
· Innovative problem solver who enjoys challenges.
· Highly motivated self-starter with proven record of success. Outstanding team player and individual contributor, willing to do whatever is required to successfully complete projects.
· Excellent oral and written communication skills.
**Relevant Experience
***Independent Consultant/Owner: Best Technology Solutions (12/99 – present) – Representative projects listed*
· **Microsoft Certified Trainer** of all SQL Server-related courses, Sharepoint, and Crystal Reports.
· **Emergency Medicine Associates
**o Developed .NET application with Analysis and Reporting Services (SSAS/SSRS) to analyze hospital data.
o Installed and customized Sharepoint and created SSIS packages to migrate data from SQL Server to AD.
o Migrated from WSS 2.0 to WSS 3.0 and added web services and SSRS components.
· **Proflowers **
o Wrote complex stored procedures to support multifaceted reports and COM objects.
o Defined and developed DTS packages and SQL scripts to perform complex data conversion/scrubbing.
o Designed and developed processes for business-to-business information exchange using XML files.
· **University of California at San Diego**
o Assisted staff members with SQL Server development, administration, and performance tuning.
o Designed and created data warehouse (OLAP) to hold metrics of students, instructors, and courses.
o Worked with team to design and implement a Sharepoint/MOSS system for students and faculty.
· **Lightspan **
o Improved the efficiency of an existing intranet using stored procedures, triggers, and indexes.
o Developed a process using DTS packages and scripts to merge updated data from external sources with data modified internally based on a complex set of rules.
o Led project to develop a cross-department, multi-server system for subscription activation.
· **Engineered Business Solutions**
o Wrote more than 200 stored procedures used by an application that populates a data warehouse and reports on a wide variety of aspects of a plastics plant using Key Performance Indicators (KPIs).
o KPIs were obtained from proprietary data sources using mostly undocumented ODBC drivers.
· **American University**
o Migrated from FoxPro to web application using ASP/SQL Server; wrote DTS packages to migrate data.
o Developed stored procedures/triggers and incorporated Crystal Reports to support user requirements.
o Upgraded to SQL Server 2005 and converted Crystal Reports to SQL Server Reporting Service.
· **Business Software International **
o Redesigned complex data structures to support new requirements and to improve efficiency.
o Converted existing VBA code to stored procedures, triggers, and user-defined functions in SQL Server.
o Wrote DTS packages and migration scripts to move data from existing database to new structures.
· **Tax Compliance, Inc.**
o Converted FoxPro accounting application to use SQL Server and used DTS to migrate/cleanse data.
o Optimized queries and connectivity to produce acceptable performance for very large databases.
o Created complex Crystal Reports to use within the application.
*
*
**Certifications, Education, and Training
**· Microsoft Certification, Database Design & Implementation with SQL Server
· Microsoft Certification, SQL Server Administration
· Microsoft Certification, Designing and Implementing Data Warehouses with Microsoft SQL Server
· Microsoft Certification, Installing, Configuring, and Administering Microsoft Windows 2000 Server
· Microsoft Certification, Web Application Development and ASP/COM Development
· Microsoft Certified Trainer, currently teaching SQL Server and other technology courses
· BA, Computer Information Systems
· MS, Information Systems
· JD, specializing in intellectual property.
## Area of Expertise
Microsoft SQL Server Programming and Administration, Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
Sharepoint Services and MOSS
.NET development (C#, VB, ASP)
Microsoft Access
Crystal Reports
FoxPro for DOS and Visual FoxPro
Visual Basic
