Candidates About

John P. Penna

 

 

Highly motivated IT Professional with extensive experience in all facets of IT with specialization in Database Development, Administration & Programming. Abundant experience in Data Architecture, Data Quality, Profiling, Analysis & Business Intelligence.

Excellent technical, organizational and communication skills, with proven hands-on skills to implement technology based solutions for greater business productivity.

 

Security Clearance:  Active Secret

 

Client Solution Architects (CSA) –Lakehurst, NJ                                                July 2017 – Present
Senior Computer Specialist

Support NAVAIR 6.7

• Develop and maintain Database based Tracking Application tools to support CH-53K(KSAT) & V-22(VOAT) acquisition providing enhanced tracking & reporting in single source
• Develop & improve Extract, Transform & Load(ETL) process for updating all tools more efficiently
• Perform monthly ETL on each Database Tools using downloaded SERD data from SEMS and provided warehouse inventory & shipping reports
• Assisted with maintenance & modifications to the local CH-53K Logistics database tool providing logistic data elements for all Peculiar Support Equipment (PSE)
• Researched and reviewed possibility to combine CH-53K Logistics and KSAT tools for consolidation
• Consulted in development & customization Monthly Status Report Project (MSR)

 

AIG Life Health & Disability –Neptune, NJ                                                   June 2013 – July 2017
Data Architect/Database Admin                                                                                                         

• Performed Database Administration on multiple databases across all environments
• Coordinated development contracting teams on Admin application project utilizing VSTS
• Analyzed business requirements; translating into conceptual, logical & physical data models for ongoing Data Warehouse project
• Administered & maintained meta data manager for data warehouse integration project
• Enforced Data Governance compliance requiring naming standards and data dictionary for data models
• Optimized & Coordinated data migration, transfer, validation processes for efficiency and accuracy
• Provided valuable input into project plans and schedules
• Develop, manage, and deploy weekly builds with continuous integration over course of projects for synchronized environments
• Administered Voltage encryption tool; maintained and added new processes for PII/PCI data transfer during development projects, production issues and system tests

 

TEKsystems Inc./CSA – DLA Troop Support - NE Philadelphia                    Feb 2013 – June 2013
Senior Database Support Analyst                                                                                                       

Supported the Defense Logistics Agency (DLA) that provides logistics support and technical services to all branches of the military as well as to a number of Federal agencies:

• Managed Construction & Equipment (C&E) Database applications, such as BidWiser
• Optimized processes by implementing changes to database schemas, PL/SQL coding, and packages resulting in higher efficiency and data quality
• Managed multiple environments of development, staging, and production
• Performed database migration to port the data into a centralized set of Oracle 11g tables
• Provided support for warehousing C&E Savings Dashboard Report information and associated ETL processes
• Investigated DODAAC (Department of Defense Activity Address Code) history and designed routine to refresh
• Provided support to Business Analysts and .Net Developers in development & tuning of complex queries and development of PL/SQL code

 

TEKsystems Inc. - Bristol-Meyers Squibb – Princeton, New Jersey                      Aug 2011 – Dec 2012
Senior Data Quality Solution Architect                                                                                               

Develop Data Quality Solutions.

·         Performed data profiling, mining, analysis and management

·         Instrumental in migration to new Dataflux Application

·         Migrated DataFlux data jobs, SQL, PL/SQL & Shell scripts to upgraded DataFlux version

·         Documented best practices and protocols on utilizing a BRMS to house business rules for various sets of information

·         Contributed to design sessions that include data modeling, system architecture & framework plans

·         Designed & maintained Functional and Technical Documentation mapping out function and flow of applications and jobs within data quality monitoring tool kit

·         Provided project scoping, coordinating and tracking to the project manager

·         Constructed data quality solutions and ensuring implementation of solution

 

TEKsystems Inc. – Bank of America/Merrill Lynch – Pennington, New Jersey      Jan 2011 – Aug 2011
Data Profiler for Account Data Quality Center (ADQC)

·         Performed in-depth data profiling, mining, analysis and management on newly received data

·         Monitored account data from outside systems migrating into the Core Account Opening environment.

·         Administered scheduled Data Stage jobs that load production and development via stored procedures and script processes

·         Developed & maintained standard reports and dashboards that monitor production data; provided trends, statistics and exceptions

·         Developed, implemented and maintained processes to import and profile new data for migration into the Bank’s main system.

·         Developed queries and procedures to analyze the new data based on the requirements

·         Interfaced with management & analysts to discuss processes, requirements and progress

·         Generated reports of findings via Cognos or Excel per requirements

·         Lead implementation and installation of Cognos for our ADQC Group:

·         Administered & maintained Cognos model, Oracle databases

·         Contributed to design sessions that include data modeling, system architecture & framework plans.

 

Savantage Solutions – Fort Monmouth, Eatontown, New Jersey                       Jan 2010 – Dec 2010
L-3 Communications – Fort Monmouth, Eatontown, New Jersey                      Sep 2008 – Jan 2010
Senior Database Administrator and Developer                                                                                  

Supported the Army’s CHESS Program providing technology solutions to all branches of the military.

·         Maintained & administered Oracle 10g & 11g database systems; such as, install patches and perform server upgrades.

·         Migrated Oracle 10g system to an Oracle 11g RAC system.

·         Implemented and supported back end database procedures that interface with website application and system.

·         Developed and maintained standard & adhoc reports and procedures in Cognos, SQL & PL/SQL.

·         Performed data mining, data analysis and data management utilizing Cognos Report Studio, Query Studio, SQL & PL/SQL.

·         Performed ETL on sales and order status vendor files using custom data quality processes to ensure data integrity

·         Designed and administered Cognos data models

·         Improved processes with performance tuning.

·         Assisted in maintaining the web interface relation with the back-end database support.  

·         Provided technical support to staff on applications, equipment and systems.

·         Coordinated with vendors and government product leaders (PLs) to ensure adherence to contract management deliverables

·         Assisted in maintaining web pages and content

 

Merrill Lynch – Pennington, New Jersey                                                           Oct 2006 – Aug 2008
Assistant Vice President, Business Intelligence                                                                                   

Provided business intelligence and data analysis for upper management, sales force, and marketing.

·         Performed data mining, data analysis and data management utilizing SQL, PL/SQL, VB programs & scripts, MS Access, Midas & Cognos.

·         Reduced number of adhoc requests for product sales metrics by designing and implementing a suite of consolidated standardized reports in Cognos

·         Developed a user Portal utilizing Cognos to provide “one stop shopping” for all tools & reports available, resulting in easy access for users, less processing time, no manual distribution & reduced number of manual requests

·         Optimized and automated reports & programs which reduced processing time and expedites delivery

·         Developed, implemented and maintained databases, report & application systems as well as generated recurring & adhoc reporting for all facets of the financial services business.

·         Assisted in design of data models & cubes for Cognos report development by holding user meetings to collect & document data requirements & report design specs based on source systems such as Midas

·         Created, analyzed and supported all business metrics detailing product & FA performance tracking & analysis

·         Created test cases and performed validation & testing on newly developed dynamic web based query tool which allowed user to run customized reports choosing any metrics needed

·         Performed “deep dive” analyses to provide a history and detailed trend for products & associated approved FA’s to assess if further training, marketing and/or recruitment is necessary

·         Consistently provided analytics and reports for performance, risk management, projections, campaigns & marketing.

·         Enhanced & improved existing reports upon user & management requirements providing an updated and more detailed view of sales

·         Responded to ongoing internal customer requests for data and analysis.

 

Thomas Matthew Associates – Trenton, New Jersey                                         Jun 2006 – Aug 2006
Database Developer/Consultant – short term assignment at Charles Jones                                       

Enhanced and optimized data load processes by converting manual to automated modules using Unix shell scripting, ftp utilities, database packages, stored procedures, triggers & views.  These modules were developed, tested and deployed to production systems, then finally scheduled to load data for user applications and reporting systems transparent to the user community.

 

Symbolic Systems, Inc. – Fort Monmouth, Eatontown, New Jersey                 Mar 2004 – May 2006
Applications Developer & Administrator                                                                                            

Supported the Army’s CECOM’s Acquisition Center HR & Contract Systems           

·         Developed & implemented custom web based applications & database systems for an Army data initialization project for the warfighter

·         Upgraded & maintained HR & Contract systems

·         Enhanced performance & efficiency of existing applications

·         Improved & maintained data integrity by implementing Data Quality processes during ETL

·         Supported interface to Business Objects for reporting

·         Performed analysis & QA for newly created applications in a test environment

·         Performed database & system administration

·         Improved ftp process to automatically retrieve data files and load into database

·         Supported operations & user community by fielding problem calls and emails

·         Collected requirements and generated specs for new applications & provided training when moved to production

 

ConocoPhillips – Linden, New Jersey                                                                Oct 1995 – Oct 2003
Database & System Administrator                                                                                                      

Provided operational and developmental support for all refinery systems at four locations across the country

·         Created interfaces to and from Oracle Financials 11i and maintained quality assurance plans.

·         Responsible for directing the programming staff and performing ongoing application support & maintenance

·         Provided production support for maintenance management and time-keeping systems Optimized processes, reduced errors & data discrepancies by redesigning existing application as well as developing new ones through proactive investigation and user feedback

·         Assured 24\7 operations by providing operational & user support

·         Performed Y2K compliant upgrades to UNIX/AIX operating systems, Oracle databases, custom apps, scripts, etc.

·         Developed and maintained financial reports for inventory status, accounting, purchasing

·         Spearheaded installation of an electronic document management system to maintain & control documents, procedures and accounting files to move toward paperless environment

·         Assisted in setup and maintenance of servers, DNS and network services

·         Scheduled and maintained backups for databases and applications

·         Maintained disaster recovery procedures

·         Developed and conducted training programs for IT users and staff

 

Education: BS in Computer Science, Rowan University

 

Certifications and Training

Talend – Meta Data Manager/ Big Data

Project Management Workshop

Oracle PL/SQL

Oracle 3GL

Cognos

HP-UX Systems Administrator

MS-ACCESS CERTIFIED

MS-EXCEL CERTIFIED

Dreamweaver Seminar

Web Design & Programming

Online Army Webmaster Training Course

 

Technical Experience

Oracle:

PL\SQL, SQLPLUS, Stored Procedures, Triggers, Database Admin, Design & Development, Oracle 8i,9i,10g,11g including RAC, DataFlux, Toad, Oracle Enterprise Manager (OEM), RMAN, PL/SQL Optimization, ETL tools & processes, SQL Navigator

UNIX:

AIX, Solaris & HP-UX Sys Admin & Programming, UNIX Shell, AWK, Pro*C, Perl

Microsoft:

SQL Server, MS-ACCESS, MS Office, Project, Visual Studio Team Systems (VSTS), Team Foundation Server, Microsoft Test Manager (MTM)

Customer Support:

Technical Documentation, Training of Users, Production Support and Help Desk

Other:

Software Configuration & Install, TCPIP, DB2, Midas, Web Design using Dreamweaver, MS Front Page, Visual InterDev 6.0, Cognos Admin & Development, IBM InfoSphere DataStage Information Analyzer