Project Manager Developer
Resume:
Peter C. King
SUMMARY:
** ***** ** ********** ********** and implementing Oracle database applications
Thorough understanding of Design, Development and implementation of Data Warehouse, including database normalization, Star-Schema, Facts and Dimensions
Developed Database Objects, Tables, Functions, Procedures, Views, Materialized Views
Developed and Deployed Custom Databases for Federal Government, DoD Contracts, Municipalities, Biotechnology, Computer Engineering, Accounting, and E-Commerce Clients
Designed and developed Annual Reports using Cognos Impromptu and OBIEE
Integrated Databases for 16 Departments using Heterogenous Services, APEX, and BI Publisher
25 years of experience implementing IBM Informix Online Engine and Standard Edition
15 years of development with 4GL, HTMLDB, APEX 5.0 APEX 5.1, J2EE, Dreamweaver
Experience with 4Js and Genero Informix Database Client/Server, CityView, HTMLDB
Installed and configured servers ESRI SDE and other 3rd party database applications
Extensive experience with Cognos Impromptu 7 and Oracle Business Intelligence reporting, including OBIEE and BI Publisher, and ad-hoc reporting with SQL Developer, SQL, SQL Plus
Expert understanding of Microsoft Access, Excel, and Open Database Connectivity ODBC
Extensive use of FTP, SFTP, SSH, DOS, PuTTy, UNIX, and Linux Command Line
Excellent understanding of Database Architecture, Design, Implementation and Testing
Excellent experience working with web technologies like HTML, HTMLDB, JavaScript, CSS
Extensive programming experience in Database technology, including ODBC, JDBC, Javascript
Hands on knowledge & experience in Business Intelligence, OBIEE 10G, 11G
Solid experience with Database Connectivity 3-tier, ODBC, JDBC, tnsnames.ora and listener.ora
Excellent understanding & hands on experience in reading complex data models
Developed and Deployed Java WAR files and JAR files to Weblogic Server
Installed, secured, and configured AWS cloud servers and Amazon AWS virtual servers (Linux)
Installed and deployed Oracle 11g, 12c, 13c database setup and maintenance on Oracle Cloud
Excellent working knowledge in database security and role-based security using Active Directory
Hands on experience in deploying web and J2EE enterprise applications on Apache Tomcat, Application Server 9i, WebLogic 10g, 11g, 13c Application Servers
Knowledge and hands-on experience with SSL/TLS Certificates on J2EE Servers
Configured Load Balancers and Oracle Traffic Director OTD for SSL and DNS
Extensive use of methodologies like Agile, Scrum and Waterfall
Experience with Linux Bash Shell Scripting, CRON jobs, WinSCP, Putty, SSH/TLS
Extensive experience in Unix, LINUX and Windows Server Command Line
Outstanding communication and inter-personal skills
Exceptional analytical and problem-solving skills
TECHNICAL SKILLS:
Languages
Java, SQL, PL/SQL, 4GL, HTMLDB
J2EE Technologies
APEX, JAR, WAR, JDBC, Java Security, SSL/TLS Encryption, Hash Algorithms
Mark-up/XML Technologies
HTML5, JavaScript, CSS, XML, JQuery, JSON
Tools & Framework
SQL Plus, SQL Developer, ORDS Rest Data Services, Putty, PuTTyGen, SFTP
Web services
SOAP, Restful, ORDS, FTP, SFTP
Web/App Servers
Application Server, Weblogic Server, Glassfish, ORDS J2EE & Standalone
Database
Oracle 8i, 9i, 10g, 11g, 12C, SQL-Server, IBM Informix, MS Access, Pervasive
Database Integration
Integrated Oracle, Informix, Pervasive, SQL Server, Excel, and Access
Modeling/ CASE Tools
Oracle BI Repository, Visio, Microsoft Project
Testing Tools/ Others
ORDS, Putty, SQL Plus, SQL Developer, FTP, SFTP
OS & Environment
Windows, Sun Solaris, UNIX, Linux, Firewall, DNS, SSL, AD, LDAP
Professional Experience:
Jan 16 - Present
KIllerDB, L.L.C.
Role: Owner, Project Manager, Database Developer
Description: Custom Database Development, and Cloud Services
Responsibilities:
Involved in all phases of development using SQL and PL/SQL, APEX, J2EE, DBaaS, JCS
Master of Development of the User Interfaces using HTML, CSS, APEX, Javascript
Wrote Stored Procedures and complicated queries for Oracle 11g and 12c
Created tables, triggers, stored procedures, SQL queries, joins, integrity constraints and views for multiple databases, primarily Oracle using SQL Developer tool.
Installed, secured, and configured AWS cloud servers and Amazon AWS virtual servers (Linux)
Experienced working with database setup and maintenance on Oracle Cloud Services
Involved in Bug fixing of various modules that were raised by the testing teams in the application during the Integration testing phase.
Implemented PL/SQL procedures and views in Oracle SQL Developer, and SQL Plus
Debugged for Errors, using debug tool, SQL and PL/SQL
Performed deployment of applications on Oracle Weblogic Application Server.
Worked on UNIX, Linux environment for development
Environment: Java, HTML, CSS, JavaScript, JQuery, XML, SOA, RESTful Services, Oracle Java Cloud Services, DBaaS, SaaS, JCS
June 1998 – Sept 2015
City of Keene, NH
Role: Database Administrator
Description: Managed implementation of Enterprise Database Applications for 16 departments. Fund Accounting, Revenue Collection, Payroll, HR, Purchasing, for Fire, Police, City Clerks, Code Enforcement, Health Inspections, Airport, Public Works, Planning, Emergency Management, Emergency Operations Center (EOC), City Council, City Manager, Finance, IT, IMS, Facilities, and Engineering
Managed UNIX Servers, hardware upgrades, Sun Solaris, HP-UX, SANS Migrations, Windows Server NT, 2000, 2003, 2008, 2012, Developed Annual Reports, Finance, HR, Payroll, A/P, A/R, Utility Billing, Expenditure and Revenue YTD Status Reports, Ad-Hoc Reports, Client Software, and Database Connectivity. Developed database applications in Oracle 8i, 9i, 10g, 11g, 12C
Responsibilities:
Responsible for database development and database applications implementations
Installed and integrated 3rd party database applications, GIS, AA, CAMA, Tax, Utility Billing
End-to-end Project Management, including customization of product based on the department requirements, meeting delivery deadlines on development, testing, implementation phases of the system and consulting providers, 3rd party integration, and custom modifications
Used IIS, Apache, APEX, and Application Servers to generate web pages
Designing and editing GUI with Drupal, Adobe, HTML, OBIEE, BI Publisher
Deployed applications in J2EE using Oracle Weblogic Server
Managed Architecture, design and development of Custom and 3rd Party Database Applications
Developed Public and Private web applications using Sungard, Informix, Oracle Database Server, ESRI GIS Server (Maps), Cognos Impromptu, Oracle OBIEE and BI Publisher
Managed roles and permissions of users with LDAP and Active Directory
Created Packages, Stored Procedures, and Functions, using PL/SQL and SQL Developer
Integrated database applications using CSV, FTP, ODBC, JDBC
Built Data Warehouses in BI Repository using Star Schemas, Facts and Dimensions
Managed Network Connectivity and DB links to multiple database servers
Conduct knowledge sharing sessions among the team members in technical areas
Environment: Java, J2EE, HTML, CSS, Javascript, REST Data Services, Oracle Client, Informix Client 4Js and Genero, SDE Server, GIS Server and GIS Desktop, SQL, SQL Plus, SQL Developer, iSQL
January 2002 – July 2015
Town of Peterborough
Database Consultant
Description: Managed UNIX Servers, hardware upgrades, SCO and Windows Servers, Database Applications, Developed Annual Reports, Finance, HR, Payroll, A/P, A/R, Utility Billing, Expenditure and Revenue YTD Status Reports, Ad-Hoc Reports, Client Software, and Database Connectivity
Responsibilities:
Responsible for database development and database applications implementations
Installed and integrated 3rd party database applications, GIS, AA, CAMA, Tax, Utility Billing
End-to-end Project Management, including customization of product based on the department requirements, meeting delivery deadlines on development, testing, implementation phases of the system, working with consultants, and 3rd party providers, and custom modifications
Responsible for database integration with banks, mortgage companies, and lock box services
Used IIS, Apache, APEX, Weblogic Server, and Application Server to build web applications
Designing and editing Annual Reports with Cognos Impromptu
Managed Architecture, design and development of Custom and 3rd Party Database Applications
Developed Public and Private web applications using Sungard, Informix, Oracle Database Server, ESRI GIS Server (Maps), Cognos Impromptu, Oracle SQL Developer
Integrated database applications using CSV, FTP, ODBC, JDBC, Client Server
Managed Network Connectivity and DB links to multiple database servers
Conduct knowledge sharing sessions among the team members in technical areas
Environment: Java, J2EE, HTML, CSS, Javascript, REST Data Services, Oracle Client, Informix Client 4Js and Genero, SDE Server, GIS Server and GIS Desktop, SQL, SQL Plus, SQL Developer, iSQL
December 1993 – June 1998
NewBank, Inc.
Process Mapping Administrator/Systems Administrator/Database Administrator
Description:
Responsibilities:
Responsible for Oracle Financials Applications implementation, database development, client software configurations, and Ad-Hoc Reporting using Cognos Impromptu
MAPP – Make a Process Productive Coordination and Administration
Convert Electronic Publisher from Microfilm/Microfiche to CD-ROM and WEB
June 1984 – Sept 1991
Halifax Engineering Corporation
Field Engineer/Project Manager
Responsibilities: Computer Services Contracts with US Army Corps of Engineers, Rockwell/Rocketdyne, U.S. Naval Oceanographic Office, U.S. Air Force, DoD, U.S. Naval Air Command, and various DoD, and other Departments and Agencies in the Washington DC area
Responsibilities:
Management of Fixed Price and T&M Computer Services Contracts. Hardware and Inventory Database for 20,000 Computers at the Pentagon, Stennis Space Center, Michoud Space Shuttle Assembly Facility (Main Tank)
June 1989 – June 1994
Pan Am World Services/Range and Test Services National Space Technology Laboratories (NSTL)
Stennis Space Center MS
Electronics Technician/Field Engineer
Responsibilities: Support for NASA, Rockwell/Rocketdyne Space Shuttle Main Engine Test Facility. Electronic Communications, Power, Control, Lighting, Video, Liquid Hydrogen, Liquid Oxygen, and Nitrogen Pressure, Control and Instrumentation, Emergency Backup Power
Contact this candidate