Joel Danner Email & Phone Number

Wildwood Fl

•Created dot net programs (vb.net ver 2010) using MS-Access and SQL Server DBs on the back end.•Created classes and used objects in vb.net•Ran Recordsets and Used the SQL Reader to read, update, create new data in vb.net•Worked with UNET for Critical Managed Care unit.•Planned, Managed, Designed, and Produced new Databases in SQL Server/MS-Access, then used Visual Basic.net to create software packages that used the backside databases. •Created Databases, Tables, and Fields in SQL Server according to database normalization rules.•Setup connections to SQL Server Databases using database technologies, such as; ODBC & OLE-DB.•Used system methods and properties in creating a Visual Basic.net programs, such as; ADO & DAO.•Made use of Sub-Procedures/Functions to complete Visual Basic.net programming tasks.

Wildwood Fl

Unemployed

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

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

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

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

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

Boynton Beach, Fla

•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 Classic, and SQL languages. •Used methods and properties in creating Access and Visual Basic programs, such as; ADO & DAO. •Made use of Sub-Procedures/Functions to complete Access and Visual Basic Classic (VB6) programming tasks. •Wrote & called simple 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 simple DTS Packages, and have a complete understanding of Data Normalization. •Planned, Designed, and Produced new Databases in SQL Server/MS-Access/Visual Basic Classic (VB6) for Data Collection 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. •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.

•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. •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. •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. •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. •Produced the new SalesLogix Library. Published new reports created by myself in Crystal Reports that were made available to all SalesLogix users.

Anchorage, Ak

•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 Classic), and SQL languages for clients. •Used methods and properties such as; ADO & DAO. •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. •Executed and created simple 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 Classic, 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 Classic, MS-Excel, and Crystal Reports for Clients. •Designed programs using Visual Basic Classic (VB6) that connected to back-end databases/spreadsheets. •Designed/used Sub-procedures & Functions that created recordsets that added, updated, or deleted records within an SQL server, Visual Basic Classic, & MS-Access. •Produced Forms and/or Reports within MS-Access and Visual Basic Classic (VB6) 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.

Anchorage, Ak

Full time student in MIS Degree program. I completed only 2 years of a 4 year MIS Degree.

Anchorage, Alaska

•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 Classic), 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. •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.

Malmstrom Afb, Great Falls, Mt

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

Mgt Info Systems, Mis, 2.5

Activities and Societies: NoneCompleted 2 yrs of a MIS 4 yr degree

Ged, Hs

Activities and Societies: NoneCompleted HS GED