CLARK I . ANDERSON PROFILE Skilled Computer Professional with proven abilities and experience in: . . . User Interface Design and Development . . Database Design and Development . Data Conversions and Reports SOFTWARE SKILLS Languages, Environments and Tools include: . Established: Visual Basic 6.0, SQL, SQL Server 2005, SSIS, Report Services, Access, HTML, Windows9x/NT/2000/XP, XML, XSLT, XPath . Other Experience: VBA, VBUnit, Oracle , Oracle Forms Builder , Oracle Reports Builder, PL/SQL, Toad, SQL*Plus, VB.NET, ODBC, OSQL Scripts, SourceSafe, InstallShield, EDI, PowerPoint, JAVA, Eclipse, C/C++, UNIX, UNIX Shell Scripting SOFTWARE DEVELOPMENT Applications Developer Weston Distance Learning, Fort Collins, CO 2007-2008 . Migrated 130 Million data records into 244 tables from 5 legacy databases with 300 tables within 15 hours. [SQL Server, SSIS, SQL, Visual Studio] . Developed 7 Integration Services projects with 72 SSIS Packages and 283 SQL queries to implement the migration. . Created a Report Services project with 5 data sources and 144 simple reports to monitor quality of data migrated. Programmer Analyst not-for-profit projects, Longmont, CO 2003 - 2006 . Created utility program to query database and generate report. [VB.NET, SQL, XML, NUnit] . Created management system for ticket printing, distribution, sales and use with full reports for non-profit events. [Visual Basic, SQL, DAO, Access, XML, XSLT, XPath, VBUnit,InstallShield] . Analyzed needs, redesigned database to manage Manpower budgets at three levels, Programs, Projects & Employees. Created the user interface. This system also provides for tracking the actual hours expended for comparison to the budget. Queries were written to import the existing data. [Access, VBA, SQL] Programmer Analyst HighlandIT & StaffMark, Longmont, CO 2003 . Technical Support for IDT/NIC Software Products. [Visual Basic, SQL, Oracle Forms & Reports] . Updated Work Order system to maintain secondary as well as primary database. [Access, VBA, SQL, ODBC, ORACLE, SQL*Plus] . Created training slide shows for several enterprise data entry applications. [PowerPoint] Programmer Analyst IDT - NIC, Longmont, CO 1997 - 2002 Duties: Design, Develop, Test, Maintain and Provide Technical Support for IDT Software Products. . Designed and developed code allowing data to be validated from database tables rather than strictly through forms, providing additional flexibility and accuracy. [Visual Basic 6.0, SQL] . Developed Web-based User Interfaces for managing User Preferences, Account Profiles, Transaction Status and Reports. [Oracle Forms & Reports Builder 6, PL/SQL, SQL*Plus, Toad] . Provided User Interface experience in small team to create transaction archive and reporting system, that in its first months of service identified 1000 billable transactions. [JAVA, JBuilder, XML, XSLT] . Developed and maintained programs to read and write Electronic Data Interchange ASC-X12 transaction sets (TS150, TS286, TS813) for the product team. [Visual Basic 6.0, SQL, EDI] . Performed overall product archive and build. [Visual Basic 6.0, SourceSafe, InstallShield] . Shared my skills in a team environment to deliver quality software products on time and provide continuous improvement in the areas of consistent and intuitive User Interface with stable performance. [Visual Basic 6.0, SQL, Access, C] Computer Programmer STARPAK - StarTek, Denver, CO 1996 - 1997 Duties: Data Entry Form and Database Design, Development and Maintenance. . Built interactive data search and entry programs with full use of standardized utility modules to satisfy the changing needs of technical support agents and reduce training and maintenance costs. [Visual Basic, SQL, Access, Crystal Reports] . Conceived and built utility programs to help my customers manage relational databases that are used to: * Consolidate duplicate customer records. This task had been avoided. [Visual Basic, SQL, Access] * Maintain Lookup Tables. This saves cost of additional licenses. [Visual Basic, SQL, Access] . Developed the relational data model and interactive personnel assignment and performance evaluation and reporting program that was data-driven for flexibility. This tool served several different departments each with their own measures of Quality. [Visual Basic, SQL, Access, Crystal Reports] . Created a "push button" report generator, to publish periodic client reports with tables and charts in a few hours instead of several days. This flexible tool has saved time and money for at least a dozen product areas. [Access, SQL, OLE/Graph] PREVIOUS ENGINEERING and PROGRAMMING ACCOMPLISHMENTS . Proposed, developed, and supported integrated computer analysis tools that streamlined the design process and yielded 75% improvement in design cycle time and simplified the training for new employees. . Converted these design analysis programs and databases from the mainframe to UNIX, for approximately 30% reduction in operating costs. [FORTRAN, C, Korn Shell] . Conceived a method to analyze the response of electronic devices to lightning strikes and proved that low cost commercial components would meet design requirements in place of costly custom parts, saving the company $500/unit or $20000/year in one product alone. [FORTRAN] EDUCATION BS: Double major: Mechanical Engineering and Mathematics Ohio University, Athens, Ohio. Graduate Studies: Syracuse University and University of Connecticut Client/Server Graphical User Interface Design Training Extended Relational Analysis (Data Modeling) Workshop Program: Programming in Visual Basic AFFILIATIONS / PUBLICATIONS Member: The Institute of Electrical and Electronic Engineers (IEEE) PC Users Group of Colorado Published Articles Denver-Area Access Users Group Published Articles Volunteer: CTEK - Making Business Happen/Venture Labor Track