Sql Server Visual Basic
Resume:
Joel D. Danner
Apt ***
Tampa Fla., 33625
813-***-**** Cell
***********@***.**.***
I have been in the computer business for over 20 years. I am certified in
SalesLogix CRM, MS-Access 97 VBA (MCP), Visual Basic (MCSD) & SQL Server
(MCDBA) and A+ as a PC Tech. I am a team player, get along well with
others, have strong communication skills, am a self-starter and have a self-
drive to get things done when they need to be done. I love to program and
teach people new skills in the computer/PC world. Whether it be MS-Office
products or new programming skills.
WORK EXPERIENCE:
May 2008 - Present Avatech Solutions Inc.
SalesLogix Admin/Developer
. Administered a CRM Program called SalesLogix Ver 6.2 Database (though
SalesLogix Work Group Administrator) by cutting Remote Databases,
maintaining security through either Individual User Feature Security
or Teams, Managed remote users as well as remote offices, and
maintained the SalesLogix Sync Server.
. Created/Maintained SalesLogix Lookups & Groups as well as new business
processes to guide users through a step-by-step business process to
complete and close the sale.
. Did custom modifications in SalesLogix through Customization &
Scripting (SalesLogix Architect) by creating new Views, Basic Scripts,
Menu Strips, Pick Lists and Data Grids using SalesLogix SLAPI
Functions and created bundles to be loaded to the SalesLogix
Database/Remotes.
. Produced the new SalesLogix Library. Published new reports created by
myself in Crystal Reports that were made available to all SalesLogix
users.
. Planned, Managed, Designed, and Produced new Databases in SQL
Server/MS-Access, then used Visual Basic to create software packages
that used the backside databases.
. Created Databases, Tables, and Fields in SQL Server according to
database normalization rules.
. Authorized user access to all databases and created views for those
users to restrict access to the actual tables of the database.
. Wrote & called SQL Server Stored Procedures, Triggers, and Business
rules using TRANSACT SQL for updating recordsets.
May 2006 - May 2008 Avatar Holdings Inc.
Field Applications Tech Specialist
. Handled Problem Solving in CFT (Computers For Tracts) and used TrackIt
software for helpdesk tracking and reporting.
. Planned, Managed, Designed, and Produced new Databases in SQL
Server/MS-Access, then used Visual Basic to create software packages
that used the backside databases.
. Created Databases, Tables, and Fields in SQL Server according to
database normalization rules.
. Ran queries against the backside SQL Server Database for performance
tuning.
. Wrote & called SQL Server Stored Procedures, Triggers, and Business
rules using TRANSACT SQL for updating recordsets.
. Created DTS (Data Transformation Services) packages to automate import
and export of data to/from SQL Server to/from different systems.
. Setup connections to SQL Server Databases using database technologies,
such as; ODBC & OLE-DB.
. Created/Updated Contracts in CFT using Crystal Reports for users as
required.
. Created formulas to calc fields in a report. Used Crystal Objects in
VB for reporting purposes.
. Used methods and properties in creating a Visual Basic program, such
as; ADO & DAO.
Sep 2004 - May 2006 Contactivation, Alpharetta GA
Certified SalesLogix Consultant/Programmer for Business Partners
. Conducted Implementation and customizations for client companies in
SalesLogix ver 6.2
. Created/Maintained SalesLogix Lookups & Groups in ver 6.2 as well as
new business processes to guide users through a step-by-step business
process to complete and close the sale.
. Did custom modifications in SalesLogix ver 6.2 through Customization &
Scripting (SalesLogix Architect) by creating new Views, Basic Scripts,
Menu Strips, Pick Lists and Data Grids using SalesLogix SLAPI
Functions and created bundles to be loaded to the SalesLogix
Database/Remotes.
. Administered company SalesLogix Ver 6.2 Database (though SalesLogix
Work Group Administrator) by cutting Remote Databases, maintaining
security through either Individual User Feature Security or Teams,
Managed remote users as well as remote offices, and maintained the
SalesLogix Sync Server.
. Produced the new SalesLogix Library. Published new reports created by
myself in Crystal Reports that were made available to all SalesLogix
users.
. Planned, Managed, Designed, and Produced new Databases in SQL Server,
then used SalesLogix to create new system packages that used the
backside databases.
. Created Databases, Tables, and Fields in SQL Server according to
database normalization rules.
. Authorized user access to all databases and created views for those
users to restrict access to the actual tables of the database.
. Wrote & called SQL Server Stored Procedures, Triggers, and Business
rules using TRANSACT SQL for updating recordsets.
. Setup connections to SQL Server Databases using database technologies,
such as; ODBC & OLE-DB.
Oct 2002 - Sep 2004 FLATEL (Florida Telephone) Inc. West Palm Beach Fla.
All IT Support Functions including (Programmer, DBA, PC Tech, Network
Engineer)
. Created a new VB 6 program called Telephone Manager from the ground up
using VB 6, SQL Server 2000, and Crystal Report 9.0
. Used methods and properties in creating this Visual Basic program,
such as; ADO & DAO.
. Formed Visual Basic Classes, COM, DCOM, and ActiveX Controls in this
program.
. Made use of Sub-Procedures/Functions to complete Visual Basic
programming tasks. Also made calls to the Windows API interface from
Access and Visual Basic.
. Wrote & called SQL Server Stored Procedures, Triggers, and Business
rules using TRANSACT SQL for update recordsets for this program.
. Administrated a SQL Server Database by Authorizing Access, Conducting
Back-Ups/Restores, Created/Maintained Synchronization,
Created/Maintained DTS Packages, and have a complete understanding of
Data Normalization, Data Dictionaries, DB Tuning, Quality Assurance,
and Database Performance Monitoring.
. Planned, Designed, and Produced new Databases in SQL Server/MS-
Access/Visual Basic for Data Collection, scrubbing, and Distribution
as needed.
. Setup connections to SQL Server Databases using database technologies,
such as; ODBC & OLE-DB.
. Well versed in Program Design/Life Cycle, from discussion and creation
of a new program, to alpha and beta testing, to a fully functional
program.
. Doing custom modifications in SalesLogix through Customization &
Scripting (SalesLogix Architect) by creating new Views, Basic Scripts,
Menu Strips, Pick Lists and Data Grids using SalesLogix SLAPI
Functions and created bundles to be loaded to the SalesLogix
Database/Remotes on a part-time basis for a Houston Texas Co.
remotely.
Jan 2000 - Oct 2002 Pegasus Airwave Inc., Boca Raton, Fla.
MS-Access Programmer/DB Admin
. Produced new stand-alone/networked MS-Access97/2000, Visual Basic 6.0,
SQL server 7.0/2000, and Crystal Report 8.0 programs using VBA (Visual
Basic for Applications), VB, and SQL languages.
. Used OOP methods and properties in creating MS-Access and Visual Basic
programs, using database technologies such as; ADO & DAO.
. Created Visual Basic Classes, COM, DCOM, and ActiveX Controls.
. Used Sub-Procedures/Functions (such as Update, Delete, Add New) to
complete MS-Access and Visual Basic Database programming tasks for
Recordsets. Also made calls to the Windows API interface from MS-
Access and Visual Basic for system log-in, PC name, and Domain.
. Wrote & called SQL Server Stored Procedures, Triggers, and Business
rules using TRANSACT SQL to maintain Business Rules for maintaining
the Corp Database.
. Planned, Designed, and Produced new Databases in SQL Server/MS-
Access/Visual Basic for Data Collection, scrubbing, and Distribution
as needed.
. Setup connections to SQL Server Databases using database technologies,
such as; ODBC & OLE-DB.
. Produced financial reports and budget analyst using MS-Access, Visual
Basic, and Seagate Crystal Reports for departmental managers.
. Created new and maintained help files using RoboHelp 8.0 and Have
experience in Goldmine Apps.
. Well versed in Program Design/Life Cycle, from discussion and creation
of a new program, to alpha and beta testing, to a fully functional
program.
. Administered a CRM Program called SalesLogix 2000/Ver 4 and
SalesLogix.net/Ver 5 Database (though SalesLogix Work Group
Administrator) by cutting Remote Databases, maintaining security
through either Individual User Feature Security or Teams, Managed
remote users as well as remote offices, and maintained the SalesLogix
Sync Server.
. Created/Maintained SalesLogix Lookups & Groups as well as new business
processes to guide users through a step-by-step business process to
complete and close the sale.
. Did custom modifications in SalesLogix through Customization &
Scripting (SalesLogix Architect) by creating new Views, Basic Scripts,
Menu Strips, Pick Lists and Data Grids using SalesLogix SLAPI
Functions and created bundles to be loaded to the SalesLogix
Database/Remotes.
. Created new web pages and implemented the web based functionally for
SalesLogix in Microsoft IIS 5.0 by using Templates, Aliases,
SalesLogix WAPI Functions, Queries, ActiveX Controls, and the Web
Viewer.
. Produced the new SalesLogix Library. Published new reports created by
myself in Crystal Reports that were made available to all SalesLogix
users.
. Attended the 1-week SalesLogix course for Administrators, the 1 week
SalesLogix course for Scripting & Customization, along with the
SalesLogix 1-week course on web implementation.
. Can fix just about any PC Problem including motherboards, sound cards,
network cards, video cards, modems, hard drives, CD-ROMs, memory
modules and all aspects of PC repair/installation/configuration. I
have built, from scratch, all five of the PCs I have in my home
. I can setup network systems using Windows NT Server/Workstation. I
have a complete network setup at home using Microsoft Windows 2000
Server, with SQL Server 2000, Exchange Server 5.0, and Internet
Information Server 5.0 using TCP/IP, a Router for DSL, and 100Base-T
network cabling that I have configured myself.
Jun 71 - Jun 91 US Air Force 20 Years Military Service; Retiree
EDUCATION & TRAINING:
1. University of Alaska, Anchorage Mgt. Info Sys Candidate. Jun 91 - Jan
93
2. Complete 2 yrs of a 4 yr MIS Degree
3. Corum Mobile Pocket PC for SalesLogix ver 6.2 Jun 2005
4. Programming with MS VB.Net 1 week course Apr 2005
5. KnowledgeSync for SalesLogix 2 day course Mar 2005
6. SalesLogix Administrator Course for Ver 6.2 Nov 2004
7. SalesLogix Development for Ver 6.2 Aug 2004
8. Microsoft Certified Solutions Developer Oct 2002
9. Microsoft Certified Database Administrator Sep 2002
10. Microsoft Certified Trainer Dec 2001
11. SalesLogix Programmer (Scripting & Customization) and Web Developer
(Web Implementation) Jul 2001 (2 Week Course)
12. Advisor Seminar on MS-Access, Visual Basic, and Web Development May
2001
13. SalesLogix Systems Administration Jun 2000 (1 Week Course)
14. Microsoft Visual InterDev Mar 1999
15. Mastering Distributed Applications Using Visual Studio Oct 98
16. Advanced Crystal Report Programmer Sep 98
17. HEAT System Administrator Aug 98
18. MS-Visual Basic Certified. Jun 98
19. Implementing a Database Design on MS-SQL Server May 98
20. MS Internet Information Server Apr 98
21. MS-FrontPage 98 Apr 98
22. MS-Access VBA Certified Mar 98
23. Access 97 Application Development Mar 98
24. Intro/Intermediate/Advanced Windows 98 Feb 98
25. MS Visual Basic 5 Jan 98
26. A+ PC Tech Certified Dec 97
27. Intro to Windows 95 Sept 95
28. Intro/Intermediate/Advanced Excel 5.0 Jul 95
29. Intro/Intermediate PowerPoint 4.0 May 95
30. Intro/Intermediate/Advanced Access 2.0 Apr 95
31. Intro/Intermediate/Advanced Word 6.0 Mar 95
32. Intro to PCs and MS-DOS Feb 95
33. Microsoft Scheduler Plus 1.0 Feb 95
34. Microsoft Mail 3.2 Feb 95
35. Intro and Intermediate Windows 3.11 Feb 95
36. US Air Force NCO Academy Course, Executive Mgt. Skills Mar 88
37. US Air Force ADP Concepts & Terms, DOD Correspondence Course Basic
Computer Concepts and Terms. Jun 87
38. US Air Force NCO Leadership School, Supervision and Leadership Skills.
May 78
39. Trained in Computer Systems and Network Mgt. (20 Years) Jan 79 -
Present
40. Trained in Database programming and Administration (20 Years) Jan 79 -
Present
41. Trained in Program Design and Analyst (20 Years) Jan 79 - Present
REFERENCES:
Kevin Kuker, VP of Sales Operations
Avatech Solutions inc.
*****.*****@*******.***
Karl Dumas, President
Contactivation
*********@**************.***
Abby Matari, CEO/Corp Development
FLATEL Inc.
561-***-**** Ext 102
*******@******.***
Tom Matthews, Co-Worker
Avatech Solutions Inc.
***.********@*******.***
Contact this candidate