Project Manager
Resume:
Dan Cappel
*** * ******** ***, ******, AK *****
*******@*****.***
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-***-**** **********@*******.***
Karthik Muthiah
eMAKS Technology Group
515 Rockbridge Road SW
Lilburn, GA 30047
678-***-**** *******.*******@*****.***
Andrius Vegelevicius
Siemens
415 Sablewood
Alpharetta, GA 30004
770-***-**** *************@*******.***
Daniel B. Cappel September 2010 Page 7 of 7
Contact this candidate