Dan Cappel

*** * ******** ***, ******, AK *****

907-***-****

abup7z@r.postjobfree.com

Daniel B. Cappel

Languages SQL, PL/SQL, Transact SQL, VB, Java, JavaScript, SAS, XML, HTML

Tools Microsoft Reporting Services, Visio, Microsoft Project, Lenel OnGuard, INDX XHQ, Adobe

Photoshop, Adobe Acrobat Distiller, Logmein, SAS, Honeywell Uniformance, Wiki, Snagit,

Camtasia, Smart Store, Remedy, Alopa, ACSR, Crystal Reports, SAP, Maximo, Thermo

Sample Manager.

Databases Oracle, MS SQL Server, Jet, SAS, MS Access, DB2

Operating Systems Windows XP, Windows Server 2003 / 2008, Unix, Open VMS, Windows NT, VM, MVS

Development

Experience Senior Project Manger / Analyst / Consultant January 1989-Present

B P – I T&S Department, Alaska Program Manager for Operations Applications

Manage project development for North Slope operations applications

•

Consult with operations team on project development

•

Oversee project managers during project execution.

•

Serve as point of escalation for projects.

•

Help drive application strategies.

•

Approve all application artifacts.

•

Work with project managers to help them improve management skills.

•

IT interface for operations team.

•

Consult with operations on budget issues.

•

State of Alaska - Department of Motor Vehicles, Commercial Drivers License

Examiner Scheduling

Designed and developed a web application for DMV including third party examination

•

providers to coordinate exams through scheduling of examiners and tracking of test results

to ensure exam integrity

Scheduling component was implemented through Telerik RadScheduler, an MS Outlook

•

style AJAX control

Consumed DMV web service to verify applicant’s identity against DMV Drivers License

•

database

Designed and implemented database schema in SQL Server 2005

•

Managed resources for the project. Stewarded project timeline and budget. Provided

•

oversight regarding technical progress toward completion.

Daniel B. Cappel September 2010 Page 1 of 7

M ind Matters Research, Website and Patient Management Application

Gathered requirements for both an interactive website and patient management application

•

for a Tier II NIH project Mind Matters

Wrote Functional Requirements Document for Mind Matters Research Website and Patient

•

Management Application.

Managed resources for the project. Stewarded project timeline and budget. Provided

•

oversight regarding technical progress toward completion.

M atSu Borough, Online Form Migration

Gathered requirements for migration of forms to website,

•

Identified key infrastructure needed for development of all forms online.

•

Wrote Functional Requirements Document for Online Mandatory Land Use Permit

•

Application.

Managed resources for the project. Stewarded project timeline and budget. Oversaw

•

technical progress toward completion.

State of Alaska - Department of Natural Resources (Division of Oil & Gas), Software

Development

Worked with the Division of Oil and Gas on the development of their royalty account

•

management application..

Developed processes for handling the filing of royalty reports, their validation and the

•

reconciliation of the reports.

Automated the FTP process for receiving EDI transmissions and processing them into the

•

database.

Converted existing Crystal Reports into SQL Server Reporting Services format and created

•

new SQL Server Reporting Services reports.

Augmented an existing console application so that it could be run as part of a scheduled

•

task and so that it would accept command line arguments.

Worked on the conversion of the source control system from Visual Sourcesafe to

•

Subversion.

Developed a Windows Service that runs the automated validation of EDI and Excel based

•

royalty filings.

Managed resources for the project. Stewarded project timeline and budget. Oversaw

•

technical progress toward completion.

Projected new task order submissions.

•

Worked with sales effort to secure necessary task orders to complete the project.

•

State of Alaska - Department of Revenue, Credit Tracking Application

Architected a SQL database for tracking the tax credits applied for by oil and gas producers

•

in Alaska. This application is designed to meet the internal audit group tracking

requirements and provide the economic researchers with forecasting information for state

budgeting.

Researched and implemented framework. This was primarily a work flow application and

•

the Microsoft Work Flow Foundation was chosen as the framework tool.

Managed resources and project budget.

•

Led testing and product deployment.

•

Daniel B. Cappel September 2010 Page 2 of 7

State of Alaska – Division of Community & Regional Affairs, eDocument System Analysis

Analysis for creation of an electronic document management system. The client needed to

•

clearly understand the scope of the proposed system as it impacted all departments with the

division. They had a diverse set of needs across many departments and needed to find a

common solution.

Produced a requirements document addressing the multifaceted needs of the division and

•

high-level cost estimates for project.

State of Alaska - Department of Public Safety, Alcoholic Beverage Control Board Local

Option Database

Architected SQL Server database to monitor package store liquor purchases being shipped

•

to Bush local option communities. This database required extensive data auditing

capabilities and mirror auditing tables were created to capture user interaction with the

database. The persistence layer was created using SQL stored procedures and interfaced to

a user GUI which was web hosted. This application had both internal and externally facing

components.

Researched and implemented framework.

•

Managed a team of 4 analysts and 3 developers for this project. Monitored the project

•

budget and reported status to the state project manager.

Led testing and product deployment.

•

U niversity of Alaska Anchorage, Recruitment Web Site

Directed redesign of web site. The web site look and feel was updated to provide a more

•

contemporary presence for the recruitment department. The client had a preferred CMS

for the web content.

Managed junior resource for onsite work and project budget.

•

CompuCom, Real Estate Web Application

Directed design of web site. The client required an interactive real estate search site which

•

allowed sellers to post listings and buyers to review active listings.

Architected SQL database schema. .NETNUKE was chosen as the framework for this

•

application to provide for a standard set of utility objects for the website.

Managed junior resources for onsite work and project budget.

•

State of Alaska - Department of Motor Vehicles, Performance Registration Improvement

Systems Management

Directed development of web services and client applications to exchange data between

•

Alaska DMV and US Department of Transportation.

Created schema and tables for real-time processing and future registration renewals. This

•

application extended the existing Oracle database for the client. Several points of interface

were established between the new and existing tables in Oracle.

Managed junior resource for onsite work and stewarded the project budget.

•

P ublic Employees Local 71, Benefits Enrollment System Replacement

Evaluated existing application and MS Access database by interviewing users to clarify

•

application requirements and potential enhancements.

Researched 3rd-party solutions and performed gap analysis.

•

Prepared findings document with recommendations and assisted in product acquisition.

•

State of Alaska - Department of Revenue, Production Tax Scoping Project

Assessed and reported on requirements for an oil production tax system, including

•

Daniel B. Cappel September 2010 Page 3 of 7

requirements for developing a tax return and identifying data elements for informational

returns.

Determined methodology and infrastructure needed to collect and analyze data, and create

•

data warehouse.

Produced project plan with estimated costs and implementation time schedule of proposed

•

system.

State of Alaska - Department of Environmental Conservation, AirTools Migration Analysis

and Implementation Design

Developed plan for migration of Oracle database to MS SQL. The client desired to change

•

the database platform to conform to the department technology standards. This required

matching the functionality from one Oracle to SQL. The SQL code differences had to be

extensively documented for the migration effort.

Detailed analysis of current database design with gap analysis for migration and evaluation

•

of need for additional user modifications.

State of Alaska - Department of Environmental Conservation, Complaint Automated

Tracking System

Developed strategy for migration of MS Access database to MS SQL. The client was

•

looking for a web application to replace a client/server application that had reached the end

of its life cycle. Extensive data architectural changes were made to the database to conform

to database engineering standard practices. A non-normalized approach was recommended

for this database.

Created Functional Requirements Document, Visual Design Specifications Document and

•

Detailed Design Document for upgraded web based complaint tracking system.

State of Alaska - Department of Administration, Procurement Certification Program

Evaluation

Evaluate current system and perform gap assessment with recommendations for future

•

development of the application, including 3rd party software solutions.

State of Alaska - Department of Administration, Lease Management System Evaluation

Evaluated current system and performed gap assessment with recommendations for future

•

development of the application..

Evaluated and coordinated demonstrations of potential 3rd party solutions.

•

State of Alaska – Department of Motor Vehicles, SQL Replication Hardware Upgrade

Provided support for new hardware implementation and verified replication approach for

•

remote servers.

B resnan Communications, Virtual Tier 1 Project.

Developed original concept, defined project scope, selected appropriate technology and

•

presented proof-of-concept demonstration.

Built beta testing scenarios

•

Generated standards and maintenance documents for ongoing support.

•

e MAKS Technology Group, Revise POS Application for U.S. Release.

Researched work flow processes and analyzed application requirements, then designed

•

database changes to match U.S. work flow methods.

Coordinated off-shore technology center project development. Performed QA for same.

•

Beta tested application, built and documented user training plan. Beta tested user training.

•

Provided U.S. user technical support.

•

Daniel B. Cappel September 2010 Page 4 of 7

E xxonMobil, Laboratory Information System Upgrade.

Designed and programmed user interface for laboratory data.

•

Used SQL to build data packets for inclusion in INDX XHQ browser interface and built

•

XHQ windows to present data.

Modified JAVA code for Oracle transfer engine

•

Produced user training materials and presented user training.

•

E xxonMobil, Management Information System – Refining Division.

Analyzed customer work flow process and worked with corporate managers to develop

•

scoping document for global project.

Developed project plan and design documentation, then presented proof of concept.

•

Developed test plans and performed stress testing on pilot application

•

Built interfaces for various data sources, and produced automated tool for converting

•

graphics to web application.

Authored training documentation and created global training plan for users.

•

Installed application at 26 sites in 10 countries.

•

E xxonMobil, Physical Security Project.

Approved project plans, researched vendor and bid project. Provided ongoing financial

•

stewardship for project.

Monitored hardware installation, programmed security software and built reports as

•

required by client.

Authored maintenance plan and training documentation, then trained users.

•

E xxonMobil, Laboratory Data Systems.

Administered database on a day-to-day basis.

•

Planned, tracked and allocated resources for all projects related to system including creation

•

of client access tools, stress testing, software and hardware upgrades, statistical data analysis,

disaster recovery planning, business continuity planning, security planning and

implementation and creation of test plans.

E xxonMobil, Plant Data Systems.

Administered database on a day-to-day basis.

•

Planned, tracked and allocated resources for all projects related to system including creation

•

of client access tools, stress testing, software and hardware upgrades, statistical data analysis,

disaster recovery planning, business continuity planning, security planning and

implementation and creation of test plans.

Interfaced with Honeywell for application upgrades.

•

Managed projects to interface laboratory data and interface supply chain data.

•

E xxonMobil, Honeywell Uniformance Project.

Administered database on a day-to-day basis.

•

Planned, tracked and allocated resources for all projects related to system including creation

•

of client access tools, stress testing, data access guidelines, hardware installation, statistical

data analysis, disaster recovery planning, business continuity planning, and creation of test

plans

Interfaced with Honeywell on implementation.

•

Coordinated project rollout to 6 major sites in the U.S. and South America.

•

Daniel B. Cappel September 2010 Page 5 of 7

E xxonMobil, Clean Air Act Data Project.

Responsible for database administration, statistical data analysis, disaster recovery plans,

•

business continuity plans, hardware installation, data access guidelines, stress testing and test

plan creation.

Planned, tracked and allocated resources for project.

•

Built data modeling for air dispersion and built task sets for CAA compliance.

•

Performed rollout and training to 5 U.S. sites.

•

E xxonMobil, Mechanical Task Tracking Project.

Responsible for database administration, creating client access tools, statistical data analysis,

•

disaster recovery plans, business continuity plans, hardware installation, data access

guidelines, stress testing and test plan creation.

Planned, tracked and allocated resources for project.

•

Coordinated implementation with vendor.

•

E xxonMobil, Plant Performance Monitoring System.

Created first comprehensive database for plant data.

•

Created data transfer protocols.

•

Implemented internationally to all 18 sites in 9 countries.

•

Responsible for database administration, creating client access tools, statistical data analysis,

•

disaster recovery plans, business continuity plans, hardware installation, data access

guidelines, stress testing and test plan creation.

E xxonMobil, Process Operations April 1974 – April 1985

Oil and Gas

Experience Process Operator – Utilities and environmental section. Daily operations on rotating shift

•

Shift Supervisor – Managed shift crew on rotating shift. Maintained shift logs and

•

timekeeping for crew. Managed personnel issues.

Process Trainer – created three years of training material for process operators in all

•

departments. Lead training activities.

Offsite utilities supervisor – responsible for all off unit piping, electricity, gas, water, air, and

•

misc utility lines.

Chief console supervisor – control center supervisor for all refinery plant operations.

•

E xxonMobil, Environmental Engineer, May 1985 – January 1989

Waste water treatment for refinery

•

Hazardous waste coordinator

•

Hazardous materials land farm manager.

•

Air and water dispersion modeling

•

State and Federal permit creation

•

Daniel B. Cappel September 2010 Page 6 of 7

Education/

Certificates

Bachelor Degree in Math with a Minor in Computer Science

Lamar University, Beaumont, TX, 1972

SAS Level 3 Programmer

Oracle DBA

Lenel OnGuard Administrator

Honeywell Uniformance Developer

INDX XHQ Developer

Nationally Certified Facilitator/Seminar Leader

References

Harry Heinlein

State of Texas – Environmental Division

3103 Wilshire Ln.

Baytown, TX 77521

281-***-**** abup7z@r.postjobfree.com

Karthik Muthiah

eMAKS Technology Group

515 Rockbridge Road SW

Lilburn, GA 30047

678-***-**** abup7z@r.postjobfree.com

Andrius Vegelevicius

Siemens

415 Sablewood

Alpharetta, GA 30004

770-***-**** abup7z@r.postjobfree.com

Daniel B. Cappel September 2010 Page 7 of 7

Contact this candidate