|
|
Joel Danner
Clermont, FL
currently: Job hunting
|
Answers from Joel
How would you describe your dream job in 10 words or less?
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.... 
Posted @ 06:03AM, May 05, 2008
by Joel Danner | Permalink
Answer this question | See all answers for this question
|
Work history
Field Applications Tech Specialist
How would you describe your time at Avatar Holdings?
*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.
*Authorized user access to all databases and created views for those users to restrict access to the actual tables of the database.
*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.
*Ran backups and system recovery as needed. Also ran database restores as needed.
*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.
*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....
SalesLogix Programmer/Administrator
tags:
crystal reports
• sql server
• saleslogix
How would you describe your time at JM Huber/CP Kelco?
*Administered a CRM Program called SalesLogix Ver 5.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.
*Created and maintained KnowledgeSync Alerts for the Organization for SalesLogix.
*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.
*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.
*Ran backups and system recovery as needed. Also ran database restores as needed.
*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....
SalesLogix Consultant/Programmer for Business Partners
tags:
visual basic
• crystal reports
• sql server
• saleslogix
How would you describe your time at Contactivation?
*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.
*Attended a 1-week long SalesLogix 6.2 Administrator course for certification for business partners and received my certification as a SalesLogix ver 6.2 Administrator.
*Completed the SalesLogix Developer certification test and received certification as a SalesLogix ver 6.2 Developer for business partners.
*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.
*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.
*Ran backups and system recovery as needed. Also ran database restores as needed.
*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....
SalesLogix Developer/Administrator
tags:
saleslogix
• sql server
• visual basic
• crystal reports
How would you describe your time at Concurrent Computer?
*Administered a CRM Program called SalesLogix Ver 6.1 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 long SalesLogix course for Scripting & Customization ver 6.2.
*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.
*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.
*Ran backups and system recovery as needed. Also ran database restores as needed.
*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....
Programmer, DBA, PC Tech, Network Engineer
tags:
sql server
• visual basic
• crystal reports
• ms-access
How would you describe your time at FLATEL (Florida Telephone)?
*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.
*Produced new/maintained web pages/HTML & DHTML using Visual InterDev, VBScript, Flash, FrontPage 97, 98, 2000, 2002 and some work with JavaScript for business departments.
*Fashioned Active Server Pages (ASP) in Web Pages and connected them to a back-end SQL Server Databases.
*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.
Programs Created:
Telephone Manager: This Visual Basic program was designed to maintain a telephone companies Customers, Dealers, Account, Invoicing, Data Collection, Marketing, and Sales. It is attached to a backside SQL Server.
FLATEL Web Site: This Web site program was designed to maintain and advertise the companies??? products and services. See www.flatel.net
Programmer: for SalesLogix CRM System....
Programmer/DB Admin/PC Tech
tags:
sql server
• ms-access
• crystal reports
• visual basic
• saleslogix
• odbc & sql
How would you describe your time at JDs Programming Service?
*Created new stand-alone/networked MS-Access95/97/2000, Visual Basic 4.0/5.0/6.0, SQL server 6.5/7.0/2000, and Crystal Report 7.0/8.0 programs using VBA (Visual Basic for Applications), VB, and SQL languages.
*Used methods and properties in creating Access and Visual Basic programs, such as; ADO & DAO.
*Formed Visual Basic Classes, COM, DCOM, and ActiveX Controls.
*Made use of Sub-Procedures/Functions to complete Access and 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.
*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.
*Created new and maintained help files using RoboHelp 8.0 and Have experience in Goldmine Apps.
*Produced new/maintained web pages/HTML & DHTML using Visual InterDev, VBScript, Flash, FrontPage 97, 98, 2000, 2002 and some work with JavaScript for business departments.
*Fashioned Active Server Pages (ASP) in Web Pages and connected them to a back-end SQL Server Databases.
*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.
*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.
*Controlled access to all networked systems and assigned access as needed.
*Recommended and made purchases of all hardware and software.
*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 for clients.
*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 for clients.
*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 for clients.
*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 for clients.
*Produced the new SalesLogix Library. Published new reports created by myself in Crystal Reports that were made available to all SalesLogix users for clients.
Programs Created:
Patient Prognostix VB Database: This Visual Basic program was designed to maintain a persons health by collecting data on the individual and providing it Doctors and/or Nurses for insurance companies, drug companies, etc. It is attached to a backside SQL Server.
Patient Prognostix Web Database: This Web Page program, created in ASP, was designed to maintain a persons health by collecting data on the individual and providing it Doctors and/or Nurses for insurance companies, drug companies, etc. It is attached to a backside SQL Server.
Administrator/Programmer: for SalesLogix CRM System for clients....
Programmer/DB Admin
tags:
sql server
• odbc & sql
• visual basic
• saleslogix
• crystal reports
How would you describe your time at Pegasus Airwave?
*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.
*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.
*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.
*Produced new/maintained web pages/HTML & DHTML using Visual InterDev, VBScript, JavaScript, Flash, FrontPage 97, 98, 2000, 2002 and some work with JavaScript for business departments.
*Produced Active Server Pages (ASP) in Web Pages and connected them to a back-end SQL Server Databases.
*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.
Programs Created:
Collections Database: This program was designed to maintain this company's collection effort by tracking those accounts that were in a collection status. It is attached to a back-side SQL Server.
Orders and Inventory Web/Database: This web site was designed to allow this company's Techs to order parts and keep track of their inventory. It is attached to a back-side SQL Server using ASP. Also created a front side program that processed the parts orders.
Administrator/Programmer: for SalesLogix CRM System....
Programmer/DB Admin/PC Tech
tags:
saleslogix
• ms-access
• odbc & sql
• visual basic
• sql server
How would you describe your time at Alaska PC Services?
*Shaped new & sustained stand-alone/networked MS-Access95/97/2000, MS-Excel95/97/2000, MS-FrontPage95/98/2000, VB 4.5/5.0/6.0, SQL server 6.5/7.0/2000, and Crystal Reports 7.0/8.0 programs using VBA (Visual Basic for Applications), VB (Visual Basic), and SQL languages for clients.
*Used methods and properties such as; ADO & DAO.
*Created Visual Basic Classes COM, DCOM, And ActiveX Controls.
*Planned programs, within the MS-Office suite, to use Automation/Replication to simplify within MS-Access.
*Created Sub-Procedures and Functions to complete programming tasks. Also made calls to the Windows API interface from MS-Access and Visual Basic.
*Executed and created SQL Server Stored Procedures, Triggers, and Business rules to ensure data integrity.
*Administrated a SQL Server Database by Authorizing Access, Conducting Back-Ups, and Creating/Maintaining Synchronization.
*Produced new Databases in SQL Server, Visual Basic, and MS-Access.
*Setup connections and used database technologies, such as; ODBC & OLE-DB.
*Shaped financial reports, Budget Reports, & Personnel systems using MS-Access, Visual Basic, MS-Excel, and Crystal Reports for Clients. Produced help files using RoboHelp 8.0 and Have experience in Goldmine Apps.
*Designed programs using Visual Basic that connected to back-end databases/spreadsheets.
*Produced new/maintained web pages/HTML and DHTML using Visual InterDev, FrontPage 97, 98, 2000, and 2002 for Clients.
*Produced Active Server Pages (ASP) in Web Pages and connected them to a back-end SQL Server Database.
*Designed/used Sub-procedures & Functions that created recordsets that added, updated, or deleted records within an SQL server, Visual Basic, & MS-Access.
*Produced Forms and/or Reports within MS-Access and Visual Basic to assist with the simplest user interaction for Databases only.
*Well versed in program design, from discussion and creation of a new program, to alpha and beta testing, to a fully functional program.
*Controlled access to all networked systems and assigned access as needed.
*Recommended and made purchases of all hardware and software for the unit.
*Also can setup network systems using NT Server/Workstation.
Programs Created:
ETS Database: This program was designed for the Army Corps of Engineers in the Alaska District. It is a program that keeps track of time worked and billing against a specific project. It is very complex and was designed to run on SQL Server.
Subway Database: This program was designed for Subway and keeps track of all assigned personnel. Such as, Promotions, Birthdays, Hire Dates, etc. This program can run on its own....
Full Time Student
How would you describe your time at Student UAA?
Completed 2 years of a 4 year MIS Degree. Then Lost funding.
Information Sys Manager
tags:
visual basic
• ms-access
• sql server
• crystal reports
• odbc & sql
How would you describe your time at US Air Force Elmendorf AFB AK?
Programmer, Network Administrator, and PC Tech as Information Systems Manager to military unit assigned
*Formed new & maintained stand-alone/networked MS-Access 2.0, MS-Excel 5.0, VB 4.0/5.0, and SQL server 6.5/7.0 programs using VBA (Visual Basic for Applications), VB (Visual Basic), and SQL languages for unit which assigned.
*Used methods and properties within programming technologies, such as; DAO.
*Designed programs, within the MS-Office suite, to use Automation/Replication to simplify tasks between all Office products, such as MS-Access, MS-Excel, and MS-Word for unit users.
*Used Sub-Procedures and Functions to complete programming tasks. Also made calls to the Windows API interface from MS-Access and Visual Basic.
*Certified as a PC Tech in IBM Compatible and MS-DOS systems. Also can setup network systems using Windows NT Server/Workstation.
*Can fix just about any PC Problem from motherboards to sound cards. Video cards to CD-ROMs. Hard drives to NICs ,etc.
*Controlled access to all networked systems and assigned access as needed.
*Recommended and made purchases of all hardware and software for the unit....
Network Administrator and PC Tech
tags:
sql server
• ms-access
• crystal reports
• odbc & sql
• visual basic
How would you describe your time at US Air Force Malmstrom AFB,...?
Information Systems Admin to military unit assigned
*Certified as a PC Tech in IBM Compatible and MS-DOS systems. Also can setup network systems using Windows NT Server/Workstation.
*Can fix just about any PC Problem from motherboards to sound cards. Video cards to CD-ROMs. Hard drives to NICs ,etc.
*Controlled access to all networked systems and assigned access as needed.
*Recommended and made purchases of all hardware and software for the unit....
Education
Info Systems
How would you describe your time at See Resume for all cllases ...?
Many Certifications and schools attended. See resume for for 40 classes completed.
Similar People
|
|
Team/Tech Lead
BirlaSoft (India)...
|
Application Devel...
Oil States
|
|
|
Principal Leader,...
computer science
|
BS, Computer Info...
metro state colle...
|
|
|
|
|
|
|
