Andrew C.

## BIO ANDREW CLARK EDUCATION: Widener University Computer Science coursework Chester, PA 5/04-8/04 Syracuse University B.S. in Computer Science • Dean’s Scholar 1998-2002 Syracuse, NY 8/98-12/02 CURRENT POSITION: Curascript, Inc. Technical Consultant/Application Programmer Work closely with business analysts and end users to design and implement solutions to system upgrade requests. Provide input into business requirements, work flow change, and database design. Complete change requests in a timely manner so they may be delivered to testing in a rigorous QA environment at least one week before going into production. Pharmacy application is designed in SQL/Windows 2.1 using an Oracle 9i back-end. Orlando, FL 7/06-current RELEVANT EXPERIENCE: Eastern Business Software Programmer Analyst Write and maintain software written in SQL/Windows, Visual Studio .NET, and Visual Basic 6. Create solutions for new customer needs using Team Developer using SQL Server, Oracle, SQLBase. Provide application support to various clients on a daily basis. Media, PA 11/04-current Independent Consulting Personal computers and home networking Installed and configured home networks and PCs for friends, family and Internet clients. Consulting on software and hardware. Most varieties of Windows including 95/98, ME, NT 3/4, 2000. Programming tasks in C, C++, PHP, Javascript with MySql and Apache, HTML, CSS Various 9/98-11/04 Delaware County – Department of Human Services Intern for MIS Dept. Assisted with running a technical help desk. Duties included troubleshooting desktop PCs running Windows 95/NT 4.0 and networking with Novell. Upper Darby, PA 5/00-8/00, 6/99-8/99 Syracuse University Teaching Assistant Responsible for the education of two classes of freshman Computer Science students. Class size was approximately 20-25 students each. Topics included basic file IO, rudimentary algorithms, linked lists, and computer graphics. Syracuse, NY 1/00-5/00 PROJECTS: Minnesota Dept. of Transportation Program & Project Management System Design and implement program fixes and enhancements to a system responsible for tracking department projects across the state. Designed in SQL/Windows 3.1 using an Oracle 9i back-end. Uses a complex class hierarchy supporting QuickObjects for all interaction with the Oracle database. Work closely with the DBAs to implement structural changes in the database, such as new tables, views, and packages. Minneapolis, MN 4/05-7/06 Clarks of England Extranet 3C Upgrade Application upgrade of the Extranet system. Maintain control of independent resource development on ASP/VB components as well as internal development on upgrading back-end Oracle 9i database. Develop a new database access layer between the ASP pages and the Oracle database with real-time supply chain information capture. The user interface layer works with the VB object/component layer to provide functionality. Develop an Oracle package to interface with the internal Oracle database to focus data flow. Boston, MA 1/06-7/06 Georgia Dept. of Corrections RxPro32 Maintain and provide database, application, and user support for an enterprise pharmacy application that generates over 1,000,000 prescriptions each year for 45,000+ inmates at 15 prisons throughout the state. Perform monthly updates of the drug interaction, duplicate therapy, and allergy-condition engine. Support Java code used to create these updates. The application utilizes multiple functional and object classes and a robust class hierarchy. Designed in SQL/Windows 1.5 using a SQLBase back-end. It is essential for all components to function exactly how the specification demands because of the nature of prescription drugs. Atlanta, GA 12/04-7/06 Spectrum Healthcare Resources Labor Management System Provide on-site and remote support for applications, end users, and DBMS; major enhancements and program fixes to an employee management system. Written in SQL/Windows 2.1 using SQL Server and SQLBase databases. Support peripheral applications in SQL/Windows, Visual Basic, Microsoft Excel and Access. The application generates payroll and billing for 2000+ employees and therefore requires a very high level of accuracy and attention to detail. The suite of applications supported comprise an enterprise solution. St. Louis, MO 6/05-7/06 Abbott Laboratories CMS Lite Maintain and enhance a call system used by field agents in 60 countries to track and report incidents in an FDA-regulated environment. Written in SQL/Windows 3.1 with a SQLBase back-end Chicago, IL 6/05-2/06 Intertek ETL Entela Perform upgrade to SQL/Windows 2005 of nine custom applications written in SQL/Windows 1.1 using an Oracle back-end. Redesign applications to use new database structure provided by a third-party software vendor in accordance with simultaneous upgrade of their payroll system. Grand Rapids, MI 1/05-3/06 LAWTRAC Online Lawtrac Provide user support for and enhancements to a system to track legal cases. Application uses a complex class hierarchy to present the user with data from the back-end. Written in SQL/Windows 3.1 and using SQL Server and SQLBase databases. Uniondale, NY 11/04-3/06 ## Area of Expertise Operating Systems: Windows 9x/ME/2000/XP, 2000 Advanced Server, Server 2003 [SP1, R2] Databases: Oracle, Microsoft SQL Server, Gupta SQLBase Web Servers: IIS 5.x, 6.x; Apache 1.x, 2.x Application Development: Gupta Team Developer (through 2005), Visual Studio 6/.NET, Microsoft Office 2003 Programming languages/idioms: C, C++, Java, SQL/Windows, Javascript, HTML, XML, PHP, CSS, Visual Basic, ASP