Data Technical Support

Peter C. Molnar II

**** *********** ****, *******, ************ 19040

215-***-**** mobile ****@***************.***

Objective

To continue my information technology career in database architecture, modeling, and software development with a focus on standards, best practices.

Qualifications

Possess over 25 years of diverse IT experience including programming in various languages, database architecture, data modeling, database administration, BI and ETL operations, data conversions, performance tuning, QA testing, documentation, and end user training. In-depth understanding of technical environments with comprehensive experience in full life-cycle software projects. Advanced database programming skill set with an emphasis on T-SQL and SSIS. Demonstrated skills across a variety of domains which include: Accounting, Annuities, Commodities Trading, Distribution, Energy, Financial, Insurance, Logistics, Marketing, Medical, & Sales.

Work Experience

NRG (Formerly EnergyPlus), Philadelphia, Pennsylvania

August 2010– September 2017

Senior Database Developer/Database Architect/Tech Lead - Responsible for: Database architecture, Data Modeling, DDL scripting, database administration, SSIS package development, ETL Processes, data mapping, data conversions, database standards, code reviews, performance tuning, release management, source code control, and assisting developers and QA testers in an agile environment.

Develop continuous integration build tool for database deployments to Development, QA, & Regression environments

Provide high level & detailed data models, data dictionaries, & documentation to software developers, testers, and business stakeholders.

Conduct code reviews and enforce database standards on check-in to source control

Interface with users and managers to gather requirements and create conceptual models

Provide data dictionaries, data mapping, and process flow documentation

Database performance tuning, trouble shooting, Production support

Assist developers and QA analysts with database operations

Production release deployments to replicated SQL Server 2012 environments

Large merger/acquisition database conversions & data mapping projects

Manage and mentor Coop’s

Interview Database Developer candidates

Bowne & Company (Formerly GCom2 Solutions), Glen Mills, Pennsylvania

December 2007– August 2010

Database Architect - Responsible for: ER modeling, database architecture, DDL scripting, database administration, SSIS Package development and standards, database standards, load testing, performance tuning and assisting developers in an agile development environment. Work with a team of developers on a re-write of a specialized financial reporting application from Visual Fox Pro to .NET/Silverlight.

Provide detailed data dictionaries and data conversion & migration documents

Provide developers with targeted ER diagrams and data models for their specific tasks

Set database coding standards, perform code reviews, and encourage best practices

Develop processes to Map data from previous versions of the product to the latest version

Interface with users and managers to gather requirements

Assist team of .NET developers with database operations

Database performance tuning, trouble shooting, and load testing

Allianz Life/American Financial Marketing, Philadelphia, Pennsylvania

May 2005 – March 2007

DBA / Technical Assistant – Responsible for: Database & Network Administration and helpdesk support.

Maintain GoldMine CRM/SQL Server database

Create custom SQL’s, Tables, Views, & Stored procedures in SQL Server to extend the GoldMine CRM system

Define and implement data transformations/mapping from various data sources to SQL Server 2000 to assist in the merger of four different companies CRM systems and desperate data sources.

Custom Crystal Reports

Maintain a multi-site AVAYA IP telephone system and configure TAPI software to integrate with the GoldMine CRM.

Develop automated SMDR data acquisition process and reporting system on top of SQL Server database and AVAYA IP telephone system

On-sight and remote technical support

Implement and maintain a web based Helpdesk system

Passport Corporation Montvale, New Jersey

February 1993 – May 2005

Senior Programmer/Analyst/Consultant - Senior developer on a team responsible for the production of a multi-tier business process management and order entry system with a web/wireless enabled GUI front end. Design and develop bi-directional interface adapter to extract, transform, and load data from various external systems via direct database access, file drop-off, and XML via message oriented middleware products. Responsible for: ER modeling, database architecture, database administration, and design of stored procedures for new and existing projects. Design and develop internal bug tracking database and GUI front end. Responsible for software architectural design and requirements documents for new product features, development time estimates for project requirements, and support, training and standards documents for new developers. Interface with clients to gather functional requirements and translate to detailed technical specifications. Provide models, mapping, & documentation for client specific implementations of the Passport workflow engine. Specify development standards, procedures, FAQ’s, and coding samples.

Provide various on & off-site software development services

Database architecture, modeling, & prototyping

Interface with users, directors, and managers to define specifications

Build/Maintain generic 4GL/3GL procedure libraries

Build/Maintain stored procedure libraries

Provide on & off site technical support & training

Ad-hoc reporting

Performance tuning

Data conversion

Manage internal discussion forum/wiki

Business Process/Work Flow engine

Dynamic Forms Management

Summary of Passport consulting projects:

Paychex, Inc, Tibco Software Inc, Mobil Corporation, Managed Imaging, EDS, New York Power Authority

ATD American / Skylight Systems, Wyncote, Pennsylvania

June 1985 – December 1992

Programmer/Technical Assistant – Developed accounting, distribution and order fulfillment software for a distributor of textiles, office furniture and disposable products. Develop mail merge/letter generation tools. Assist in packaging the companies’ internal software for resale in the distribution market space. Performed data conversion tasks to move data between various databases and file systems. Designed and implemented Sybase and Oracle stored procedures. Provide ad-hoc reporting via various tools and development languages. Develop OS independent library functions in C to extend the functionality of the Passport 4GL.

Managed programmer library of generic 4GL/3GL procedures

Data Conversions between RMS files, DBASE, Oracle, & Sybase

Ad-hoc reporting

Interface with users/management to define specifications

Provided user training and support

Database administration

Overview of Skills, Tools and Environments

Atlassian

Benchmark Factory

C#

CSS

Crystal Reports

Enterprise Architect

Erwin ERX

Fortran

GoldMine

HTML

Idera

Informix

JavaScript

JIRA

MySQL

nSoftware

ODBC

Oracle

Passport 4GL

PL/SQL

PVCS

Redgate

SCCS

Subversion (SVN)

SQLServer

SSIS

Sybase

T-SQL

UNIX

Visual Basic

Visual Source Safe

Visual Studio

Watcom SQL

XML

XSL

Education / Certifications

Montgomery County Community College – Computer Science - Associates Degree Program

The Human Potential Project – Allianz Human Potential Initiative – Certificate of Completion

Interests

Automotive: restoration, repair, performance tuning; Electronics: experimentation, repair, keeping up with developing technologies and gadgetry; Physical Fitness: running, weight training, biking, and hiking.

Contact this candidate