DONALD G. KAPP
*** ********* ***. ********* ** 14609
585-***-**** ********@*****.***
SUMMARY
Twenty-five years of information technology including nine years’ of Security using DLP (Data Loss Prevention) and the following (Endpoint Prevent, Network Monitor and Network Discover). Four years’ experience in Hyperion Essbase Analytic Applications including the following, (Essbase/EAS/ /MDM/Planning/Shared Services/SmartView). Extensive system administrator skills in AIX, Solaris, MAC and Windows operating systems. Strong database design with Microsoft SQL Server and Oracle. Vast experience in SCM, CRM and SDLC practices for all phases of Development/QA/DR and Production.
TECHNICAL SKILLS
Specialization: Symantec DLP v15.0 MP1 (Data Loss Prevention), Oracle Hyperion System 9.x Essbase Administration, SQL Server 2014, Oracle 11g/12c, XML, WebSphere 5.1, Informatica SCM/MDM (Modular Data Management Platform)
Software/Tools: SQL Server 2014 Management Studio, Hyperion Presentation Layer Applications Reports/Analyzer/MDM/Planning/Excel Add-In/SmartView/EAS, Oracle 10g OEM. Visual SourceSafe, Visio, Flash Builder
Operating Systems: Windows 2008/2012/2016/WIN7/WIN10, MAC 10.13.2, AIX, Linux, Solaris
Database: MS SQL Server 2005/2012/2014, MS Access, Oracle 10g/11g training with 12c
Languages: UNIX ksh, bash/HTML, XML
Web Servers: IIS 4.0/5.0/6.0, WebSphere 5.1/6.0, Tomcat
Hardware: IBM RISC6000 (AIX), HP Servers, SUN Servers, SPARC SUN station, Web Application Servers, Black Diamond Switch, IBM PCs & Compatibles, Cisco switches and firewalls
EXPERIENCE
(CIBER Solutions) Rochester, NY Sept. 2009 to Present
Consulting Assignment: XEROX/CONDUENT CORPORATION
Senior Development Consultant
Responsibilities
Symantec DLP (Data Loss Protection) System Developer/Administrator
Installation and configuration of full suite of Symantec DLP software including (Enforce, Endpoint Manager, Network Discover, Network Monitor), and the Oracle 11g data warehouse
Developer/Architect of DLP policies and response rule for Enterprise set of data requirements.
Documentation and delivery of the engagements for DLP at both Xerox and Conduent SaS
Created VMWare server environment for development and test hosts using DLP software.
Developed DLP system alerts to monitoring ongoing system events for all serves.
Developed DLP policy reports for configured policies for Endpoint Agent, Network Monitor, and Network Discover incidents.
Created automated SMS installation for the rollout of Agent software to 100’s of users.
Developed process to monitor Agent installation by using Access as the front end to merge DLP and end-user data.
Development of a SQL Server 2012 database with a Microsoft Access front end for data input that included the setup of Altiris to support the deployment of the DLP software
Reviewed DLP data for incident remediation.
Created SSL certifications at all levels of encryption for the DLP product, including COMODO and key tool creation.
Trained with Splunk to help the Splunk POC (Proof of Concept) team in understanding the results of the production SIEM feeds, provided valuable feedback to the customer based on findings.
Worked with the FireEye POC team to help create the manual install scripts for Endpoint users
Worked with the McAfee Application Monitoring team to determine feasibility, reliability, and usability within the Xerox environment.
Architected the separation project to split the Xerox and Conduent DLP solution for both companies.
Trained 50+ DRI Security Specialist and Manager to work with the Enforce console on how to remediate DLP incidents.
(CIBER Solutions) Rochester, NY April 2008 to Sept. 2009
Consulting Assignment: ESL Federal Credit Union
Senior Development Consultant
Responsibilities:
Development of a SQL Server 2008 database with a Microsoft Access front end for data input.
Developed SQL 2005 Server Data Model for financial management system.
Reviewed, updated and modified all data fields based on findings from an original set of requirements.
Responsible for all design, build, documentation, and deployment/training activities
Finalized requirements for a new relational database for financial management reporting and analytical data sources.
Created and scripted lookup tables for Access Form design.
Created SQL security roles based on different types of users.
Converted Access 2000 to Access 2003 format due to additional requirements in the functionality of Access Forms.
Migrated Access 2003 data to newly developed SQL Server 2005 database.
(CIBER, Inc.) Rochester, NY Dec 2007 to April 2008
Consulting Assignment: Xerox Corporation
Business Analyst/Technical Documentation (DMS and BDC XIM Applications)
Responsibilities:
Researched, evaluated, recommended and designed a new technology solution for User and Training Documentation with Flash Builder.
Worked with XIM Application Support, Development and Project Management to gather requirements for Technical User and Training documentation for both the Business Development Center (BDC) and Download Management System (DMS 2.0) applications.
Trained and transitioned to the DMS Application Support Team the use of the Flash application. This was a new software product called “Flash Builder”.
Created a separate User Guide for an XML Editing tool that would generate a file for batch uploading.
Evaluated and tested the DMS 2.0 application with the creation of the XML load files.
(CIBER Solutions) Rochester, NY September 2005 to March 2008
Consulting Assignment: XEROX CORPORATION
Senior Production Support Consultant
Responsibilities:
Implemented the installation phase for all releases throughout the Development, Test and Production cycle using the Hyperion Essbase/Reports/Analyzer/Planning/MDM and Excel-Add-In software.
Debug DTS and SQL Sentry production job errors due to problems with data loads completing.
Work closely with the development and other QA team members in communicating, diagnosing, and resolving bugs.
Write DTS packages to automate server functional tests.
Test, configure and maintain 24/7 support of the Windows 2003 Server clusters for the Xerox Financial Data Warehouse using SQL Server.
Work closely with the core Essbase product to identify problem areas as well as to isolate problems as a core and/or service related defect.
Resolving customer support issues related to Hosted sites, client application environments which include: databases, applications, servers, networks, and Hyperion products including (Essbase, Reports, Analyzer, Planning, MDM, and the Excel Add-in tool.
Work with customer escalations to quickly identify issues and push it to the correct development teams.
Reported on the status of Hyperion Escalations and Installs to the Xerox Financial Re-Engineer Management team for review on a weekly basis.
Supporting Xerox finical customers from all over the world via the Web, telephone, and E-mail to resolve their issues related to Hyperion products.
Manage escalation of high profile cases to resolution working with Engineering and various departments within Xerox.
Author and edit technical documents (FAQ's and Resolutions).
Mentor junior staff on customer management, queue management, and technical troubleshooting.
Design and write test plans and test cases based on design and functional specifications for Platform releases that I develop.
Backup to the SCM Manager. Building and verifying software release for readiness.
KForce Consulting, Tampa, FL Dec 2003 – September 2005
Consulting Assignment: (Hewlett Packard)
Responsibilities:
ATL (Area Team Lead) for Hewlett Packard/7-11 Backroom Server/Switch Upgrade
San Francisco/Bay Area ATL for the Hewlett Packard controlled Backroom upgrade for all the 711s Nationwide.
Duties include Supervision and Training all PCE level technicians to remove old ISP and install new HP/Proliant Server and Pro Curve Switches.
I have currently 9 PCEs and one ATL under my supervision.
Consulting Assignment: New York Life Insurance
Responsibilities:
Compaq ML-350 Server Refresh:
Bring Old Server down after backup complete.
Disconnect/Reconnect RIB Card, Network Connections, UPS, External Tape Drive, All Peripherals.
Ran Backup procedures to bring New Compaq ML-350 Server in-line with current Database.
Trained Administrative Manager new Backup Procedures.
Brackin Consulting, Wilmington, DE June 2003 - Dec 2003
Consulting Assignment: QVC Shopping Network
Responsibilities:
Performed KANA Connect 1.0 through 6.2 Upgrades. This included going on-site 3 times in two months.
The KANA Connect eCRM Software was spread over multiple servers and needed careful attention to detail and readiness. This was due to the fact that I had was the key installation developer and tester of this product.
Wrote expectations of where QVC might have some issues on the Kana Connect Upgrade (will supply Documentation).
KANA Software, Menlo Park, CA Apr 2000 – June 2003
Senior QA Engineer/Team Lead, Senior Technical Support Engineer/Team Lead
Responsibilities:
ERG (Emergency Response Group) Team Lead, which included third-tier support for our Connect 1.0 and 6.0 products.
Wrote Shell scripts to automate the diagnosis our customer issues with their clusters.
Also, file any bugs associated with the issue.
Led and implemented our installation phase for all types of Operating Systems throughout the development cycle.
Design and write test plans and test cases based on design and functional specifications.
Create Phase 1 mappings in Informatica data loading tool for Connect 6.0 to Oracle 8i and 9i databases.
Debug Phase II mappings in the Informatica data loading tool when there were problems with data loads completing.
Work closely with the development and other QA team members in communicating, diagnosing, and resolving bugs.
Write Shell scripts to automate server functional tests.
Test and configure clusters for our eCRM Connect 6.0 product.
Work closely with the core product to identify problem areas as well as to isolate problems as a core and/or Service bug.
Run test clusters for the core product and push the service tests into the QA team.
Work with customer escalations to quickly identify issues and push it to the correct development teams.
Reported on the status of ERG Escalations and Installs to the Development Management team for review on a daily basis.
Backup for all Managers in the QA development area when needed.
Support customers, partners and sales engineers via the Web, telephone, and E-mail to resolve their issues related to KANA products.
Reproduce problems to determine the cause and solution.
Manage escalation of high profile cases to resolution working with Engineering and various departments within KANA.
Author and edit technical documents (FAQ's and Resolutions).
Mentor junior staff on customer management, queue management, and technical troubleshooting.
Xerox Corporation, Rochester, NY Jan 1999 – Mar 2000
Consulting Assignment
Responsibilities:
UNIX developer working within a middleware software environment utilizing UNIX KORN SHELL scripts and Solaris Packaging.
Design and development of UNIX KORN SHELL scripts to install MessageBroker middleware software applications on a Solaris Sun box utilizing Solaris 2.7/2.8
Design and development of Solaris packages for all Xerox XIM/MessageBroker engagements, including ValueQuix, DSG, Simon, eCommerce, and Metered Supplies.
Part of QIT (Quality Improvement Team) which is responsible for the direction and future of all engagement installations and how they will be developed.
Technical Lead for this project.
Design and write test plans and test cases based on design and functional specifications.
Train other Xerox developers on the process and know-how of Solaris packaging.
SCM (Software Configuration Management) developer.
Building and verifying software release for readiness.
Prime for this position for 6 months while a replacement could be found.
Nortel (Northern Telecom), Rochester, NY Nov 1996 – Dec 1998
Consulting Assignment
Responsibilities:
UNIX developer working within a telecommunications environment utilizing Solaris 2.7 for UNIX KORN SHELL scripts and PL/1.
Design and development of UNIX KORN SHELL scripts to install audio applications on a NavBase 003 CSU04/05 platform.
Maintenance and debugging of NavBase 03 CSU and ISU software written in PERL.
Troubleshooting UNIX and PERL scripts for readiness and completeness using Solaris 2.7
Customer site installation support of CCSN 1.03, ISNDA 1.01, EBAS 1.01, and EBAS 1.02
Setting up hardware configuration for the NAV.
UNIX Administration utilizing Solaris 2.7 including UNIX commands to determine hardware/software requirements of the NavBase node. Commands include:
Kernel configuration using the vmexgen command to update the number of T1s on the NavBase Shelf.
Also some memory configurations on the PSOS side of an MSP board.
DSE (Disk Slice Editor), this UNIX administration is used to add and remove slices of the disk from the hard drive on a NavBase Node.
Informix database administration, which includes checking and validating database updates for the product version during an installation of a NavBase Node.
The Health Association of Monroe County, Rochester, NY Jun 1989 – Nov 1996
Programmer
Responsibilities:
Designed and created Informix forms utilizing Informix Form Generator to create input/output forms for LifeLine staff.
Created reports with Shell Unix programming.
Created lookup tables and linking multiple tables for report generation.
Utilized Informix to create Index reports that could be changed for further updating by users.
System Analyst I
Daily operated a Novell Netware 3.12 on a Compaq Prosigna Server including system assignments, report generation, backup, and system maintenance of Novell Netware 3.12.
Installed all hardware and software on a Novell Network for over 100 users.
Backup for Senior System Analyst on a Digital VAX 4000/200 running PATHWORKS and VMS.
Supervised Production Office and Administrative Service Assistant.
EDUCATION
Bryant & Stratton Institute, Rochester, NY: AAS Computer Science Degree
CERTIFICATIONS: IBM DB2, UNIX Development, Oracle Hyperion Essbase 11.x System Administration certified - Training completed on 10/2007
SECURITY: Splunk Reports, dashboards, lookups, and alerts. It also introduced datasets features and Pivot interface. Other topics included Splunk indexers and search heads, configuration, management, and monitoring. Training completed on 10/2016