|
|
123456789101112131415
Resume 5
Joe Jefferson
Summary
Highly qualified IT professional with over 17 years of development experience spanning mainframe, n-tier and client server platforms. Personable, professional and highly motivated individual with a proven track record of project success. Greatest strengths in:
- Technical Project Management
- Systems Analysis & Design
- Web Site Design and Development
- Database Design & Administration
- Application Development & Coding
- Network & Server Administration
- Team Leadership & Collaboration
- Verbal & Written Communication Skills
- Problem Research & Resolution
- Customer Needs Analysis
Extensive and diverse background in various industries including medical, insurance, e-business, cable television, telecommunications, accounting, banking, payroll, income tax, manufacturing, fleet management, inventory control and human resources.
Technical Summary
Operating Systems: UNIX, VM/CMS, TSO, OS/MVS, JCL, VAX/VMS, MS-DOS, Windows 3.x, Windows NT, Windows 95/98.
Hardware: HP, Sun, DEC and Sequent servers, DEC VAX servers, PC Compatibles, Apple and all IBM and compatible mainframes.
Databases: Sybase, MS SQL Server, Oracle, EDA/SQL, Watcom SQL, XBase, DB2, FOCUS.
Software: Microsoft Commercial Internet System, MS-Site Server, MS-Commerce Server, MS-Visual InterDev, MS-Source-Safe, MS-Team Manager, MS-Exchange Server, MS-Internet Information Server, MS-Netmeeting, MS-Outlook, MS-Publisher, Adobe Pagemaker, MS-FrontPage, MS-Project, MS-Word, MS-Excel, MS-PowerPoint, Oberon Prospero, Crystal Reports, Cognos Impromptu, InstallShield, Corel Draw, PaintShop Pro, TSO/ISPF, Panvalet.
Languages: MS-Visual Basic 1.0 - 6.0, COM, SQL, Objectview, PowerBuilder, FOCUS, Easytrieve, BASIC, COBOL, various Macro and Batch languages.
Professional Experience
1998 - Present System Administrator/ Webmaster
Designer and System Administrator for small office 100BaseT network including a Windows 2000 Server running IIS 5.0. Includes broadband connectivity for main server, backup server and 4 workstations, Cisco router and Netgear firewall. Web developer and Webmaster, currently hosting seven separate commercial web sites on 24/7/365 schedule, including security.
Key Achievements:
- Built main server, backup server and all workstations from chassis up, including all hardware and software configuration.
- Installed and maintain all server software including Windows 2000 Server, Internet Information Server, SQL Server and MS Exchange server for multiple domains.
- Monitor server up time, web server log, security log, DSL connectivity and report to user clients.
Technical Environment: Windows 2000 Server, Internet Information Server 5.0, SQL Server 7.0 & 2000, MS Exchange 5.5, WebPosition Gold, WebTrends.
Designed and developed web-based form processing system for Crampede Fulfillment & More. This system allows customized input forms to be created using various data elements stored in a SQL Server 2000 database. The system is self-generating so that all web forms are constructed from data maintained by non-technical users.
Key Achievements:
- Designed site layout, navigation and page layout and created web data input forms.
- Redesigned database structure to accommodate required elements for form creation.
- Wrote all VBScript code to create input forms dynamically from pre-configured data elements and to save required affiliate data in SQL Server database.
- Provide ongoing additions and site maintenance.
Technical Environment: Visual InterDev 6.0, MS Front Page, SQL Server 2000, Internet Information Server.
Designed and developed corporate presence web site for Qirkpatrick Windows, Inc. Host and maintain www.Qirkpatrickwindows.com.
Key Achievements:
- Designed site layout, navigation and page layout and created primarily static pages using MS Front Page.
- Designed and created all site graphics, including redesign of existing company logo.
- Wrote all site copy to customer specifications.
- Prepared all site photographs using both scanned photographs from film as well as digital images from Kodak DC4800 digital camera, including cropping, picture frames and thumbnails.
- Provide ongoing additions, site maintenance and site hosting.
Technical Environment: Visual InterDev 6.0, MS Front Page, Paint Shop Pro, Internet Information Server.
Designed and developed corporate presence web site for Sorrera Technologies, Inc. Host and maintain www.sorreratech.com.
Key Achievements:
- Designed site layout, navigation and page layout and created site pages using Front Page 2000.
- Designed and created all site graphics, including design of company logo.
- Wrote all site copy to customer specifications.
- Provide ongoing additions, site maintenance and site hosting.
Technical Environment: Visual InterDev 6.0, MS Front Page, Paint Shop Pro, Internet Information Server.
Designed and developed corporate presence web site for Beyond Prospectives, Inc. (currently offline for restructuring after client s change in business plan).
Key Achievements:
- Designed site layout, navigation and page layout and created site pages using MS Front Page.
- Designed and created all site graphics, including design of company logo.
- Wrote all site copy to customer specifications.
- Prepared all site photographs using scanned photographs from film including cropping, picture frames and thumbnails.
Technical Environment: Visual InterDev 6.0, MS Front Page, Paint Shop Pro, Internet Information Server.
Independent Contractor 1999 - Present
Recruited as a senior developer on a large-scale project for Terrific West Life to replace a 16-bit medical claims processing system with a 32-bit, state-of-the-art system.
Key Achievements:
- Created eight separate Visual Basic applications designed to run unassisted and perform critical data analysis, data loading and related database cleanup functions in a high-volume transaction environment.
- Created all technical and end-user documentation for the above applications.
- Created and adapted necessary COM objects to facilitate database access for these eight applications.
- Performed technical application classroom training for the Production Support staff.
- Designed and developed a web-based reporting system using Seagate Info for report scheduling, a Visual Basic interface for report staging and Active Server Pages for report delivery.
- Installed and administered Windows NT 4.0, IIS 4.0, Seagate Info 7.0 on a Dell server for report delivery.
- Mentored junior developers and assisted project manager with some project planning tasks.
Technical Environment: Oracle 8i, Visual Basic 4.0 & 6.0, COM, Visual InterDev 6.0, Windows 9x, Windows NT 4.0, Internet Information Server, Seagate Crystal Reports, Seagate Info and Filenet.
Recruited as a web designer/developer for Creative Networks on the creation of a B2B web portal.
Key Achievements:
- Provided key technical expertise on developing web portal site using MS Site Server.
- Assisted in installation and deployment of Microsoft Commercial Internet System (MCIS) and Site Server Commerce Edition.
- Developed a proprietary NNTP interface for the site to allow newsgroup access from within the web browser.
- Customized and implemented MCIS template forms for usage in portal membership creation and administration and management of portal user content publishing.
- Assisted junior Database Administrator with SQL Server database design and stored procedure development.
Technical Environment: MCIS 2.5, MS Site Server Commerce Edition, Visual InterDev 6.0, Windows NT 4.0, Internet Information Server, MS-SQL Server 7.0, MS Front Page 2000.
Recruited as a Project Manager for AT&T Broadband for a Year 2000 compliance project involving testing and Y2K certification of all in-house applications developed with Visual Basic, MS Access and MS Excel.
Key Achievements:
- Designed the specifications and procedures for all testing to company requirements.
- Designed and programmed a web-based tracking system for managing workflow and compliance reporting, including database and report design.
- Selected all testing and remediation tools used for application certification.
- Designed and coded a Visual Basic application to automate uploading of multiple applications onto the team s staging server for testing.
- Hired and managed a team of five experienced developers to operate within an environment requiring legal compliance to the Year 2000 Information and Readiness Disclosure Act.
- Brought in the project two months ahead of schedule and with an end result that 0% of the applications tested and certified were found to be non-compliant after January 1, 2000.
Technical Environment: Visual Basic 4.0 - 5.0 - 6.0, Visual InterDev 6.0, Windows NT 4.0, Internet Information Server, MS Site Server, MS-SQL Server 6.5, MS Access 95 & 97, MS Excel 95 & 97, Inspector 2000, Date Detective, ACC-Fix 2000, DateSpy 2000.
Recruited as a Project Manager for Logiset, Inc. to assume responsibility for a large-scale project developing a specialized ERP solution for the Cable TV/Telecommunications industry. Even though some of the applications were already in production, client satisfaction was seriously lacking and the project was badly off-track and in danger of failing.
Key Achievements:
- Assessed the expertise of the seven member development staff and reassigned developer responsibilities. This reallocation of developer resources resulted in limiting cross-application overlap and confusion, maximizing individual expertise and streamlining the overall development process.
- Restructured how user requirements were gathered and translated into application requirements to formalize the process and better manage the client s expectations.
- Assumed responsibility for all DBA functions to limit and manage database change impact and instituted a structured process for database change requests and fulfillment.
- Assumed responsibility for coding all stored procedures and triggers, including changes to existing database objects.
- Restructured the database to improve response time and query efficiency.
- Revamped the bug reporting system to better classify bug severity and its attendant affect on service releases.
- Instituted a program to schedule bug releases to better manage the clients expectations on bug fixes and to provide a manageable process for the developers to work within. This eliminated unreasonable expectations on the part of the clients and provided a predicable schedule and attainable goals for the developers, greatly improving the efficacy of the process on both sides.
Technical Environment: Visual Basic 5.0, Visual InterDev 6.0, SourceSafe, Windows NT, MS-SQL Server 6.5, and Crystal Reports 6.0.
Accomplishments, Inc. 1997 - 1999
Co-founded a consulting start-up company with three colleagues to provide turnkey project consulting services to small business. Held the titles of Vice President/Chief Technical Officer & Director of Projects as well as operated in the capacity of staff manager and system administrator. By the company s second year of operation, head count included 13 full-time employees.
Key Achievements:
- Managed multiple revenue-generating projects while maintaining daily corporate responsibilities that included NT System Administration, Novell System Administration, SQL Server and Sybase DBA administration, including stored procedures and triggers.
- Managed a project to its successful completion for Potlatch Corporation s Consumer Paper division including all interface design, database design and administration, work assignments, project monitoring, liaising with the client and delivery and installation of the system. Also included user support of the system when initially installed.
- Managed a project to develop an e-commerce web site for a nutritional supplement manufacturer to its successful completion. Included all graphic/page design and underlying database design as well as all server and database administration.
- Managed a project to develop an adjunct product for Crystal Reports using Visual Basic to exploit the MS Windows API and Crystal Reports API. While the project was successfully completed, the product was never releases due to legal complications.
- Designed and developed Accomplishments corporate web site and operated as corporate Webmaster.
Technical Environment: Visual Basic 4.0/5.0, Visual SourceSafe, Visual InterDev 1.0, MS Site Server, Windows NT 4.0, Novell Netware 4.11, Sybase System 11, Crystal Reports 6.0, Borland Paradox, FrontPage 98, Access 97, MS-SQL Server 6.5, Corel Draw 7.0, PaintShop Pro 5.0.
Avalon, Inc. 1989 -1997
Worked as a staff consultant providing contract programming services to Avalon clients. Originally hired for FOCUS and mainframe development but segued into client/server development in the early 1990 s.
Key Achievements:
- Lead developer on project for U S WEST to develop custom software solution for forecasting new telephone construction requirements and all related reporting.
Technical Environment: Oracle, Visual Basic 4.0, Access 95, Cognos Impromptu 2.0.
- As Lead Developer consulting to MCI, redesigned and re-coded an advanced GUI application using Visual Basic to create mailing and calling lists for member retention marketing efforts. Also redesigned the underlying data structure to enhance system response time and reporting flexibility.
Technical Environment: Sybase System 10, Visual Basic 3.0/4.0, Crystal Reports 5.0 and Brio.
- Project manager originally recruited by US West to provide short-term business analysis duties that led to an opportunity to present a proposal to develop a replacement for their antiquated R-base manual check processing system. This led to the project manager position. Additionally responsible for creating much of the database design, stored procedures and triggers for the system.
Technical Environment: MS SQL Server 4.2, Objectview, Andyne GQL.
- Developed a decision support system for the above check processing system including all requirements analysis, user interface design, creation of database entity relationship model and the design & programming of the system shell and reports using GQL Reports.
Technical Environment: MS SQL Server 4.2/5.0, Objectview, and Andyne GQL.
- Recruited as a FOCUS subject matter expert and lead developer of a large-scale project for US West involving the conversion of a mainframe FOCUS/DB2 system to an HP9000/ORACLE system.
Technical Environment: OS/MVS, JCL, HP 9000, Unix, DB2, and FOCUS.
- For Ajilon s Open Systems Lab, designed and developed a complex Visual Basic front-end for a system that demonstrated the cross-platform integration capabilities of the Lab via a common user interface. Successfully implemented the system under critical deadline pressure, proving the RAD capability of Visual Basic.
Technical Environment: MS SQL Server 4.2, Sybase SQL Server, Visual Basic 3.0, and Access 2.0.
- Designed and developed a comprehensive in-house Marketing and Recruiting system.
Technical Environment: MS SQL Server 4.2, Sybase SQL Server, Visual Basic 3.0, and Access 2.0.
- Employed as a technical lead and programmer re-designing and rewriting reports used within US West s payroll department. Also designed, developed and implemented a multi-user check tracking application using PC FOCUS.
Technical Environment: OS/MVS, VM/CMS, FOCUS, and Oracle.
- As a contractor to MCI, developed a large-scale mainframe application to provide tracking and cancellation of MCI customers not actively using their accounts. Later developed a series of complex reports for assisting in customer retention marketing efforts.
Technical Environment: OS/MVS, COBOL, Easytrieve, and JCL.
InfoBuilders, Inc. 1987 - 1989
Performed analysis and development work for various clients using FOCUS on various platforms.
Key Achievements:
- Created a tax apportionment system for Enron Holding to proportionally calculate taxes across a 48 state operating region.
Technical Environment: OS/MVS, FOCUS.
- As contractor to Marvin Windows, created applications to interface with their Man-Man manufacturing system to provide bills-of-material, inventory control and invoicing interfaces for their back office staff.
Technical Envrionment: VAX/VMS, FOCUS, Man-Man.
- Employed as a contractor to US West to create various parts of a fleet management system used to track the entire US West automotive fleet.
Technical Environment: VAX/VMS, FOCUS.
Trudo Club International 1981 - 1987
Originally employed as a research analyst in the Customer Service Department. Promoted to supervisor in Customer Service and was responsible for as many as 21 direct reports. Promoted to Manager in Customer Service of a special department that provided fulfillment services for card member retention marketing programs where exposure to software development began. Eventually transferred into the Systems & Development department and performed programming and development work using BASIC, QuickBASIC, FOCUS and COBOL on various in-house development projects.
123456789101112131415
|
|