## BIO
Resume for Mark Cline
Education - Bachelors in Computer Science, University of Texas, Austin
Work Experience Summary
* Database administration, data warehousing, data modeling, distributed database design, database conversion
* Highly skilled with SQL, query optimization, database tuning
* Software engineering through complete life-cycle
* Report writing, automated report generation
* Web site creation, interactive and dynamic web content, web-based applications
* Project management, team leadership, project and resource planning
Previous Employment
**Reliance Aeroproducts**(December 2002 – Present : part-time)
· Wrote web-based system in SQL Server and ASP for tracking repairs to commercial aircraft integral fuel tanks. This system, although web-based, provides drag-and-drop functionality to track service locations for historical reporting.
· Worked with client to design application, custom tracking database, interfaces and functionality.
**Myriad Development** (June 2002 - August 2003)
· Led project to create a SQL Server data warehouse, collecting data from Oracle and SQL Server and constructing a data mart in SQL Server. Wrote PL/SQL and used DTS to perform ETL from Oracle database into SQL Server. Created web-based reports using ASP and ChartDirector.
· Wrote a sales pipeline application using SQL Server and ASP to work with and view sales data. Designed databases, provided user training and support.
· Designed and wrote system using COM+ to remotely install and register components across all computers on a NT domain. This system remotely connects to a computer’s registry and file system and makes changes in order to install and register components.
· Led project to design and construct a marketing management system using SQL Server and ASP. Worked with client to design a custom database and application to suit their needs. Provided technical training and mentoring to developers and client staff in web programming methodologies.
**Consulting, Dell and TEA** (May 2001 – June 2002)
· Team leader on project to develop software to scan hardware and OS resources. Wrote software in three months that had been bid for development by Dell’s external vendors at several hundred thousand dollars.
· Wrote x86 assembler, C and C++ to gather information from BIOS, WMI, file system and Windows registry.
· Wrote SQL Server database dictionary tool using ASP, SQL and stored procedures that documents SQL Server database and can reconcile even small differences between two SQL Server databases.
· Architect and developer for large-scale SQL Server application, data warehouse and reporting data marts, with and ASP web application and reporting system interfaces.
· Administered and provided ongoing resource planning for IIS web servers, SQL Server database servers, and VSS source code repository.
· Wrote ASP source code generation tool using ASP, COM+ and SQL Server stored procedures. This system will query an existing SQL Server database to create a metadata repository. After a user defines the basic operations of an ASP screen they need, the COM+ components generate finished, working ASP code.
**Myriad Development** (May 2000 – May 2001)
· Developed payroll application using SQL Server. Created tables, views, stored procedures. Established security and wrote COM+ components to provide business logic and security layers. Created ASP interfaces for working with and viewing payroll. Integrated payroll system with AccPac accounting software.
· Developed SQL Server data warehouse, wrote ETL routines, created DTS processes and wrote custom database replication procedures. Wrote extensive data dictionary to support ongoing reporting needs for other teams.
· Led teams in designing and developing enterprise business management reporting systems using ASP and Crystal Reports. Created high-level graphical reports and charts using ChartDirector.
· Reconciled AccPac accounting systems with business systems by directly querying underlying SQL Server data. Corrected accounting problems by exploring and researching underlying tables and writing custom SQL scripts.
**AIS Consulting** (February 1999 – May 2000)
· Programmed high-volume data processing services using ASP, COM+ and Portal middleware.
· Wrote SQL scripts to research and correct issues in Oracle databases. Supported accounting staff by creating tool to perform data loading, custom spreadsheet extraction, and reconcile business information with accounting figures.
· Wrote various utilities using Visual Basic and ASP to allow customer service agents to research accounts, perform accounting and configure customer accounts.
· Programmed with Visual Basic Active Document to deploy web-based executable application.
· Wrote MS Access utilities to manage project tasks, such as task assignment, bug-fix tracking and project timeline.
**Broadwing** (February 1998 – February 1999)
· Created Oracle data warehouse to collect telecommunications information for calculating fees and charges. Wrote custom PL/SQL scripts for processing very large volumes of data, including configuration of special rollback segments, tablespaces and iterative processing to allow frequent commits during processing.
· Wrote billing application with SQR and VC++ to calculate telecommunications charges for other telecommunications resellers. Billing application produced professional quality invoices summarized over hundreds of pages.
· Created Oracle data warehouse to collect billing information for multiple database sources (including SQL Server, Oracle and Excel) to aggregate accounting information across organization and calculate earned revenue for financial disclosure.
**State of Texas TDPRS** (May 1993 – February 1998)
· Developed large number of systems across agency using dBase, Access, ASP, Visual Basic, SQL Server, and Oracle. For example, wrote systems for tracking items checked out from staff libraries, system to track complaints that came into the Ombudsman office, systems to track correspondence, outstanding litigation and pending legislation.
· Developed system using SQL Server, ASP, and MS access to collect program information for runaways throughout Texas to qualify agency for matching federal funds, resulting in qualification for millions of dollars from federal programs.
· Developed Oracle data warehouse using PL/SQL to consolidate information into a series of data-marts.
## Area of Expertise
**Project Management
**· Writing project proposals
· System architecture
· Team leadership and mentoring
**Languages
**· C#
· C/C++, VC++, ATL
· VB
· VBScript
· Java
· SQR
**Systems
**· MS Access
· Crystal Reports
· Cold Fusion
**Database
**· ANSI SQL
· Relational database design
· SQL Server, including Transact SQL, SQL Trace and DTS
· Oracle, including PL-SQL
· Data warehouse design and implementation
**Web
**· HTML
· JavaScript and DHTML
· ISAPI
· XML/XSL
· MTS and COM+
· IIS
**Technologies
**· .NET
· ADSI
· ActiveX
· N-Tier
· custom middleware
· sockets
· multi-threading