Developer Sql Server Data .Net Sales Office Software
Resume:
Rodney Crosby
Chicago, IL *0620
E-mail: abj4oq@r.postjobfree.com
OBJECTIVE
To further a career in the Information Technology field as a web developer.
SKILLS
MS-Access, ASP.NET, C#, VB.NET, SQL Server, LINQ, JavaScript, CSS
EXPERIENCE
Illinois Army National Guard, Chicago, IL September 1988 - Present
Computer Analyst
. Supplement military IT staff during periods between civilian jobs.
. Use MS-Access, or ASP.NET as a front end to SQL Server 2005 databases
depending on supervisor preferences.
. Use Transact-SQL to create stored procedures and views in SQL Server
2005/2008.
. Use JavaScript/ AJAX/ CSS for client-side data validation and formatting.
. Install office suites and military-specific applications.
. Configure, maintain, and troubleshoot network systems and client
computers.
Lettuce Entertain You Enterprises, Chicago, IL April 2008 -
September 2008
Web Developer (Contractor)
. Perform duties as a temporary employee assigned by JDMi, Inc.
. Follow development of new web pages and reports through the entire SDLC
. Use C# under ASP.NET 2008, HTML, CSS, and JavaScript to produce intranet
reports and web pages as needed.
. Use SQL Server 2005/2008 to hold customer data for sales reporting.
. Use LINQ to extract data from SQL Server for use in reports.
Illinois Tollway, Downers Grove, IL February 2008
Programmer (Contractor)
. Perform duties as a temporary employee assigned by PreCise Staffing.
. Follow development of a web site through the entire SDLC.
. Create a MySQL database to hold data from an ASP.NET website.
. Use ASP.NET to record, display, and present error messages from the
website.
Zurich Insurance, Schaumburg, IL April 2007 - July 2007
Active Directory Scripter (Contractor)
. Perform duties as a temporary employee assigned by TekSystems, Inc.
. Use VB.net to create user-friendly versions of the VBScript utilities.
. Create reports using LDAP queries, VB.NET or Visual Basic Script, using
HTML or MS-Excel as a front end.
. Use VBScript to prepare data to be migrated from a Windows 2000 to a
Windows 2003 network, while overcoming the limitations of a Windows NT
4.0 migration utility.
. Append user data fields that cannot be moved using the Windows NT 4.0
migration utility to the description field.
. Following the migration, parse the description field of each user and
separate move data to the corresponding fields in the Windows 2003 active
directory database.
. Use Visual Basic Script to create Active Directory utilities for Zurich
Insurance.
The Orsini Group, Arlington Heights, IL June 2006
Database Developer
. Convert MS-Access databases to SQL Server 2005 databases to be shared on
the company intranet via ASP.NET.
. Modify VB.NET code in ASP.NET web pages as necessary to display table
data from SQL Server 2005.
. Translate MS-Access SQL to Transact-SQL in order to duplicate the
functionality of queries in MS-Access using stored procedures and views
in SQL Server 2005.
. Install and troubleshoot office computers and software.
. Analyze and convert the syntax of MS-Access queries to the syntax of SQL
Server Queries for use in stored procedures and views.
Katten Muchin Rosenman, Chicago, IL September 2004 -
November 2004
Litigation Support Specialist
. Perform duties as a temporary employee as assigned by Technical
Solutions, Inc.
. Use VBA macros to format documents, automate MS-Office, and manipulate
multiple files
. Create, update, and troubleshoot Dataflight Concordance and MS-Access
2000 databases
. Transfer data transfer from Dataflight Concordance into MS-Access 2000
databases
. Perform duties assigned by Katten Muchin Zavis Rosenman as a temporary
employee.
. Use Dataflight Concordance.
Kirkland and Ellis LLP, Chicago, IL October 1999 - September
2003
Developer and Cost Recovery Specialist
. Develop MS-Access 97/2000 and Dataflight Concordance relational databases
to assist in the analysis of court case data.
. Use Visual Basic 6.0 and VBA macros to create Windows 2000 utilities and
custom MS-Office applications.
. Use ASP 3.0 in the Firm intranet accounting portal to perform
calculations on data imported from SQL Server, DB2, and MS-Access 2000
databases.
. Upgrade legacy databases from Q&A for DOS and MS-Access 2.0 to MS-Access
97 databases.
. Create consistent interfaces for newly upgraded databases.
. Use SQL to create queries in MS-Access for use in the creation of
managerial reports.
. Incorporate shared tables in upgraded databases with consistent data for
drop-down lists to reduce spelling errors for addresses and vendor names.
. Use ODBC to import lists of vendors from the accounts payable DB2
database for use in MS-Access forms' drop-down lists to avoid spelling
errors and increase the speed of data entry for check requests.
. Use ODBC in MS-Access to export check request data to DB2 databases.
. Use VBScript to create an automated process to transfer text-based
transaction files from a Windows NT server to a DB2 application to be
used by the accounting department for billing.
. Use Windows Scheduler to begin automated processes during non-business
hours.
. Enable all scheduled scripts to email error reports in the event of
failure for immediate troubleshooting and resolution.
. Use SQL on the IBM AS/400 to query transaction logs and verify the
consistency of data in DB2 tables following scheduled uploads.
Alternative Resources Corporation, Chicago, IL October 1999 -
January 2000
Computer Programmer
. Perform duties assigned by Kirkland and Ellis LLP as a temporary
employee.
Catholic Charities, Chicago, IL November 1992 - October
1999
Assistant Systems Administrator
. Use VBA to simplify software tasks in Microsoft Office 97 and WordPerfect
Script in WordPerfect.
. Create MS-Access 97 databases to track inventory, equipment repairs
status, and maintain a help log.
. Upgrade Dbase II and Lotus 1-2-3 tables to MS-Access 97 databases.
. Perform desktop support for 40 offices distributed across 4 departments.
. Configure and test new computers prior to delivering them to various
offices.
. Upgrade 150 486-based computers to Windows 95 using a custom SETUP.INF
file.
. Install modems in 6 court offices from Markham to Rolling Meadows for
remote communication.
. Create a BASIC executable menu/scheduler to replace all DOS-based batch
menus.
. Configure the scheduler to run ProComm Plus and place each computer into
host mode during non-work hours.
. Use the ProComm Plus scripting language to create a script at the main
office to dial out to each computer during non-work hours and download
the daily data files.
. Set up and test peer-to-peer networks using TCP/IP.
EDUCATION
Roosevelt University, Chicago, IL December 2000
Bachelor of Science Computer Science
CompTIA, Chicago, IL October 2007
Security+ Certification
Contact this candidate