Sql Server Customer Service

Philip R. Gould - 609-***-**** - ********@*******.***

APPLICATION MIGRATION SPECIALIST / DATABASE PROGRAMMER / PROGRAMMER ANALYST

Application Migration Specialist with extensive experience in system

conversions and migrations, including MS Access to SQL Server, VMS Alpha to

Unix, VMS VAX to VMS Alpha, and PDP-11 to VMS VAX. Experienced in program

design and testing, team leadership, customer service, and professional

development. Possesses excellent problem solving and interpersonal skills,

along with proven ability to manage all aspects of client relations.

Recognized for success in diagnosing problems and collaborating with others

to develop positive, cost effective solutions that effective met the needs

of the clients. Flexible, proactive and always willing to take on whatever

responsibilities are required to complete a project.

PROFESSIONAL EXPERIENCE

PUBLIC SERVICE ELECTRIC & GAS OF NEW JERSEY, Lawrence Township, NJ

September 2011 - December 2013

Data Base Consultant

. Supported and Upgraded an Application that used Microsoft Access 2003.

. Removed redundant VB Code Modules and Forms, creating a combined

system that performed the same tasks in a more efficient manner.

. Created new functionality for the users.

. Converted MS Access Macros to VBA Code to allow for improved security

as well as improve efficiency.

. Redesigned Data Tables to be more organized and normalized.

. Updated Equipment to Project Tracking mechanism including creating

method to indicate Project Completion.

. Created internal Code Based Rules to improve Data Validation

. Created User Access and Roles Lists for the purpose of increasing

Security.

. Created Administration Support Form to allow secure updating of the

tables.

. Provided Real Time database evaluation and support.

. Provided User Reports in Access Datasheet Format and Excel Format as

required

. Provided method to email Administrative Reports to Project Management

Personnel.

. Provided support for User Training.

. Converted an Application that used Microsoft Access 2003 as its Front End

and Microsoft Access 2003 as its Back End, to an application that used

Microsoft Access 2003 as its Front End and Microsoft SQL Server 2005 as

its Back End.

. Converted Program code to run on SQL Server using Views, T-SQL

Procedures and Pass-Through queries. Streamlined additional code,

allowing the system to perform faster.

. Converted MS Access Macros to VBA Code to allow for improved security

as well as improve efficiency.

. Modified Table and Column structures to comply with SQL Server

Standards.

. Supported SQL Server Database used to store Equipment Records

. Evaluated Data Content and produced On Demand Reports.

. Updated Data Content to eliminate data Anomalies.

STANDARD & POORS, NYC, NY October 2011 - May 2012

Programming Consultant

. Member of team performing a Alpha VMS to OpenVMS System Conversion

o Project was completed on schedule and applications ran without

issues in the new environment.

o VAX VMS Systems were no longer used for production with the

applications.

RESEARCH DIETS INC, North Brunswick, NJ 2008 - February 2011

Data Base Consultant

. Participated in implementation of the Google Search Appliance.

. Completed Training classes on the implementation and use of the

Appliance.

. Created Appliance queries that allowed users to view available

documents using their Google Desktop application.

. Converted an Application that used Microsoft Access 2003 as its Front End

and Microsoft Access 2003 as its Back End, to an application that used

Microsoft Access 2003 as its Front End and Microsoft SQL Server 2005 as

its Back End.

. Converted Program code to run on SQL Server using Views, T-SQL

Procedures and Pass-Through queries. Streamlined additional code,

allowing the system to perform up to 500% faster with less competition

for the Database resources.

. Converted MS Access Macros to VBA Code to allow for improved security

as well as improve efficiency.

. Modified Table and Column structures to comply with SQL Server

Standards.

. Arranged and supervised QA and Installation of the new system.

KELLY SERVICES, New Brunswick, NJ 2007

Temporary Staffing Services

. Member of a team of data entry and event support specialists serving a

specialized hiring fair held by Johnson and Johnson in Orlando Florida.

. Arranged initial schedules of applicants and hiring managers to make

sure that the desired interviews would be held, taking into account

any schedules for travel and meetings that might interfere)

. Fielded requests to change schedules at the hiring event if the

circumstances required doing so.

. Assisted with other event management support issues as required.

STANDARD & POORS, NYC, NY 1989 - 2007

Senior Systems Analyst

Provided support for day-to-day and year-end processing for Securities

Processing applications, including development, modification, and

training support. Provided support for internal operations and help

desk personnel external customers, and vendors as well as coordinating

system platform conversions for existing applications. Support of

applications required knowledge of Oracle 9i Oracle 10g, and PRO-C for

VMS, along with Unix C. Knowledge of VMS and Unix Shell Scripting, as

well as VMS and Unix Programming tools was also required.

. Worked with the business units as liaison to the Systems and

Engineering groups to help to determine the programming requirements

for projects

o Design of client and internal user reports and other user

defined output.

o Program design for coding changes

o Testing and validation procedures

. Coordinated a team of Systems Analysts that upgraded the Electronic

Press Release System

o Upgraded the built in parser to properly identify stories that

were being missed, making 40% more stories available to the

automated systems.

o Changed transmission of Press Releases to FTP delivery, creating

a more secure delivery environment.

. Coordinated a team of Systems Analysts that included external

consultants in a project to migrate applications off the Alpha Based

VMS System, to a Solaris Based UNIX System

o Electronic Press Release System was converted and put into

production.

o Securities Processing and Reporting System was converted and put

into production.

o Index Directories Publication System was converted and waiting

to be put into production.

o Alpha VMS Systems were no longer used for production with the

applications.

. Member of team performing Y2K related modifications to application

systems

o Project was completed on schedule and applications ran without

issues after January 1, 2000.

. Member of team performing a VAX VMS to Alpha VMS System Conversion

o Project was completed on schedule and applications ran without

issues in the new environment.

o VAX VMS Systems were no longer used for production with the

applications.

. Led a team upgrading the Stock Market News System

o Automated production of content coming from external and

internal data sources, eliminating the need for editorial staff

to copy the information.

o Automated the reproduction of content into multiple formats

o Increased speed and efficiency of the production and delivery

processes.

o Enabled production of European and Canadian versions of the

Stock Market News System.

o Created a database of historical Stock Market News Stories for

use by internal personnel.

o Created an End-of-Day Archive Process for the Electronic

Distribution System so that the System could be recovered and

restored in the event of any unusual issues in production or

transmission.

Member of a team of Systems Analysts that created and supported

Applications.

. Led a team upgrading the Electronic Distribution System

o Electronic Distribution System allowed for delivery of non text-

based products such as Stock Reports, as well as the news.

o Developed detailed documentation, which was provided to new

clients of the new service.

o Collaborated with client technical support groups to migrate

from using other communications protocols to using TCP/IP.

o Increased speed and efficiency of data delivery and Data

Transmission Security built into TCP/IP.

. Electronic Press Release System

o News Wire Service Press Releases, which were previously printed,

copied and distributed, were collected and stored in a database.

o The system printed documents to over 40 print devices.

o The system allowed for transmission of the Press Releases to

clients.

o The Traffic Cop/Action Editor System was a new system that

allowed access to the data stored in the Electronic Press

Release Database from user Workstations and eliminated the need

to print documents.

. PDP-11 to VAX System Conversion

o Migrated the Stock Market News System from a PDP-11 Based RSTS

System, to a VAX Based VMS System.

o Migrated Electronic Distribution of products for over 20 clients

from a PDP-11 Based RSTS System, to a VAX Based VMS System,

creating faster and more secure delivery of the data.

o Collaborated with programmers, engineers and technicians to get

new clients connected and receiving the data

o PDP-11 Systems were no longer used for production

COMPUTER HORIZONS CORPORATION, Parsippany, NJ - Consultant 1988 - 1989

APPLIED SYSTEMS INSTITUTE, Washington, DC - Programmer 1987 - 1988

ITT AVIONICS, Nutley, NJ - Software Engineer 1985 - 1986

DOW JONES & COMPANY, South Brunswick, NJ - Programmer/Analyst 1982 - 1984

BASE TEN SYSTEMS, Hamilton, NJ - Software Engineer 1980 - 1982

EDUCATION

B.A., Mathematics, Newberry College, Newberry, SC

TECHNICAL SKILLS

Conversion of data files (contents and structure)

Writing and updating program/system documentation.

Writing and updating QA acceptance test plans.

ASP.Net Programming using VB.Net.

MS Access and Excel Programming using VBA and Macros.

Microsoft Office Tools including Word, Excel, Access, and PowerPoint.

Microsoft SQL Server, T-SQL, Macro and Procedure writing.

C with Korn Shell Scripts along with awk/nawk scripting for Unix.

Oracle 8i, 9i, and related tools for VMS.

BASIC, C, Pro-C, and job scripting for VMS;

BASIC Plus, BASIC+2, FORTRAN and job scripting for the PDP-11

Contact this candidate