RONALD WASSERMAN

* ******** ***

Madison, NJ ****0

973-***-****

Summary of Qualifications:

Six years IT Support, two years MS Access VBA programming, two years Master

Data Analyst, two years compliance auditor, ten years Electrical Engineer

PROFESSIONAL

EXPERIENCE:

2012 - 2014 Business Credentialing Services

Insurance Compliance Auditor

Responsible for the auditing of Certificates of Insurance and

other vendor data in order to reach compliance with our

clients insurance requirements.

Initiate contact with service providers and agents to obtain

Certificates of Insurance and associated general

and auto liability endorsements

2012 Johnson & Johnson Ethicon

Siebel Business Analyst - consultant

entry of educational events into Siebel customer relationship

management (CRM) application

2012 Pfizer Consumer Healthcare

Siebel Business Analyst - consultant

entry and analysis of new product promotional events into

Siebel CRM application. Analysis of account

managers data for accuracy of product discount rate.

2010 - 2011 Novartis Pharmaceuticals Corporation

Master Data Analyst - consultant

. Responsible for analyzing, updating and maintaining

professional (HCP) and organizational (HCO) profiles in the

Novartis Customer Master Database.

. Analyzed and Performed merges of customer data from multiple

data Sources. Merged data was assigned a Unique Novartis ID

. Analyzed and Performed splits of customer data (the splitting

of consolidated records from integrated records). Split data

was assigned a Unique Novartis ID

. Researched and analyzed data using IMS Prescriber Validation

Service and performing internet based web searches to validate

data sources accuracy.

. Created and resolved data inquires to internal and external

data sources resulting in more accurate data records and less

discrepancies.

. resolved data discrepancies in Siperian Customer Master

2009 Citigroup

IT Asset Management - consultant

. ITAM Analyst utilizing customized Citigroup applications

including Procure-to-Pay (P2P), Licensed Software Management

System (LSM), Citicorp Technology Catalog (CTC) for various

Asset Management initiatives within bank.

. Conduct analysis of daily inflows of IT procurement data into

Citigroup systems to ensure accuracy. Resolve abnormalities

and implement corrective action.

. Prepare various weekly Control reports for senior management.

2007 - 2008 Johnson & Johnson McNeil Consumer Care division

Master Data Specialist - consultant

. Coordination and validation of product data from Packaging

Engineering, Promotions and Financial. The Master Data group

will allow the products to be shipped after our review.

1998 - 2006 Affiliated Computer Services/Chubb Group of Insurance

Companies

Application Tool Support Specialist

. Provide high-level support for the software developers using

the Microsoft developer products - Visual Basic 6, Visual

Studio .NET and Microsoft Access in client and Terminal Server

environments

This support includes code debugging, connectivity problems,

file conflict and registry analysis, and best practices.

Liaison to Microsoft premier support for our developers.

. To meet the needs of Chubb's Visual Basic .NET programmers, I

researched and published several documents for Chubb

developers

"ODBC .NET Managed Provider - An alternative to using a

native provider for DB2"

This paper provided a preferred alternative method to using

unmanaged classic ADO

"Problems when using certain ActiveX controls in a Visual

Studio .NET application"

. Developed an automatic (via Tivoli) process for the un-

installation MS Project98, Access97 and Visio without

disturbing the rest of the Microsoft Office suite.

It was assumed by management that this could not be done.

Since I was able to make it automatic, it saved hundreds of

man-hours of Field Technology Service labor time since there

were several thousand workstations affected.

The cost saving of having successfully made this procedure

automatic was tens of thousands of dollars.

. Worked with Microsoft in developing a strategy for the upgrade

of Access 97 to Access 2002 and assisted our developers in the

conversion process

Database Computer Programmer

( Enhancement of Chubb's Environmental Liability Information

System Database. This database system uses Microsoft Access as

its front-end graphical user interface and DB2 for its

database storage.

I was able to greatly improve the response time by

incorporating ODBC pass-through queries, creating Access

tables to temporarily hold only those records that were being

manipulated, and then updating the DB2 tables when that

manipulation is complete which is triggered when the user

closes the form.

( Provide the customer with periodic reports of conflicts

between Chubb's central database and the Environmental

Liability Database.

. Developed a Time Tracker Application using MS Access

User entry of weekly time spent on particular projects

Calculates statistical information for a user defined date

range

1994 - 1997 LOCKHEED MARTIN ASTRO SPACE, East Windsor, NJ

Power Sub-System Engineer

( Designed a 6 watt, 300kHz current-mode flyback converter

( Executed the following functions for a Battery Power

Converter:

Generated Worst Case Analysis for Telemetry board

Modeled the Power Stage for Computer Simulation

Wrote Test Procedure

Supported manufacturing

Performed Module level test

1989 - 1991 Low Voltage Power Supply Engineer

( Executed the following functions for a redundant

forward converter used on the Mars Observer spacecraft:

Generated Worst Case Analysis for Critical Design

Review including: -10V Post Regulator, Inrush Current

Limiter, Over-Current Shut Down Circuitry

Generated Failure Mode and Stress Analysis

Performed SPICE simulation of transient response of

the common output to a single side shut down

Designed Test Equipment and wrote Test Procedure

( Designed single output linear regulators for TIROS and

Landsat spacecraft

( Performed stability analysis of discrete post regulators

using Saber

( Performed Conducted Emissions analysis of a Jensen converter

using Saber

1991 - 1993 LAMBDA ELECTRONICS INC., Melville, NY

Product Design Engineer

( Designed and developed a 150 Watt Off-line current-mode

forward converter for the industrial market.

This product incorporates auto-selectable 115/230 input

voltage for both the European and American market.

It also meets VDE class B and MIL-461-D EMI

specifications.

Some of the functions I performed include:

Ripple simulation on the input capacitors using SPICE

Design of the output filter

Thermal analysis and derating of power components

Testing and debugging of the engineering model

Performed stability analysis using MathCAD

Pilot run and production support

EDUCATION: CHUBB PROFESSIONAL RESOURCES, North Brunswick, NJ

Graduate of Top Gun Training Program for

Unix Client Server environment.

Development skills in C, Visual Basic, Powerbuilder,

SQL, Oracle, Windows 95, UNIX.

PRATT INSTITUTE, Brooklyn, NY

Bachelor of Electrical Engineering

Member of Eta Kappa Nu Electrical Engineering

Honor Society

NEW YORK CITY TECHNICAL COLLEGE, Brooklyn, NY

Associate in Applied Science with Honors

Electromechanical Technology

COMPUTER

SKILLS: Microsoft Access, MS Excel, Siebel, Visual Basic

6, Visual Studio .NET, SQL Server

2000, SQL Server 2005, SharePoint, HTML, IS_SPICE, P-SPICE,

Analogy Saber, MathCAD, FORTRAN, Z-80 Assembly

Contact this candidate