Ronald Profenno

**** ****** ***. - ***. ***

Portland, ME 04103

207-***-**** (Home) 207-***-**** (Cell)

aces7w@r.postjobfree.com

IT Programming and Software Skills

Proficient in MS Access 97 - 2010; VBA (Visual Basic for Applications) /

(VB 6.0 Development Environment); Microsoft Windows 3.1 - VISTA OS; MS

Office 2003 - 2010 (Word, Excel, & Outlook); Internet Explorer; Access

(VBA, macros, functions and formulas); Excel (functions and formulas);

SQL/GUI utilizing ODBC

Experience with Crystal Reports 11; Easy View (Crystal Reports Viewer);

File Maker Pro 4.0; Front page 2000; HTML; Java Script; Omnis Studio v 4.3;

Oracle Siebel; SQL; VFO(Virtual Front Office) ; M6(MetaSolv)

Professional Experience

04/2013 - 09/2013 Consultant Westbrook,

Maine

Programmer/Developer

. Developed MS Access 2003 - 2010 Databases & Reports utilizing Visual

Basic for Applications for clients

09/2009 - 04/2011 FairPoint Communications Portland,

Maine

Wholesale Department Call Center/LSR (Local Service Request) Order Writer

. Write Wholesale & Resale Complex LSR orders such as: Centrex; ISDN;

DID/DOD PBX; port in and port outs; loop; loop with number portability &

disconnects of Wholesale services and packages

. Verify orders are entered and submitted correctly through the Web based

VFO (Virtual Front Office/Synchronoss) according to LSOG 9.12.1 Local

Business Rules

. Enter services, USOC's, Labels & Values into M6 (MetaSolv); process and

provision the orders

. Answer calls regarding order issues and assign tracking numbers and

updates to Lotus Notes database; keep track of order until problem/issue

has been resolved and notify customer of the end results

. Create EXCEL spreadsheets/formulas for the wholesale LSR department for

Matrix tracking purposes LOR (Late Order Report) to assure orders that are

late are addressed and completed

. Create preorder manual and system generated CSI (Customer Service

Inquiries) reports for Vendors

01/2009 - 08/2009 Consultant Westbrook,

Maine

Programmer/Developer

. Developed MS Access 2003 - 2007 Databases & Reports utilizing Visual

Basic for Applications for clients

1992 - 10/2008 North East Insurance Company Scarborough,

Maine

Help Desk/Computer Operations Coordinator/Programmer (VBA)

. Provide desktop and telephone support for local and remote users with

regards to company hardware and various application software

. Log, distribute and track known issues through problem tracking database

until resolved

. Customer support for all up/down loads of Agency quoted data files

. Install and configure both computer hardware and software

. Assist company network administrator in managing the network and

troubleshooting errors

. Setup network users and PCs using active directory in Windows 2003 Server

. Maintain, inventory and order computer/printer supplies

. Develop Access databases and reports using Visual Basic for Applications

. Create Crystal Reports from Oracle Databases using an ODBC connection

. Run nightly Operations; EOD/EOM Cycles; take corrective actions when

errors occur; setup and schedule Arcserve backups and file restores; FTP

and copy EOD processed files to remote sites

. Run am data dump backups; setup and process jobs for the mailroom staff

to print and mail

. Initiate User ID's and passwords; developed/maintain Access Password

Security database

. Provide hardware and software support for Executone IDS telephone system

and Infostar VX3 voice mail system; program keys; setup voice mail and

phone configurations

. Create Microsoft Excel & Word forms; Perform other duties or special

projects as required or as assigned

1981 - 1991 United States NAVY United States Government

Computer Operator

. Telecommunications - install cabling; multiplexers; modems; enter

parameters to reroute; up/down and clear communication lines; operate

communications center main consoles on Atlantic Research and Racal Milgo

Network Control Systems

. Supervisor of the Electronic Data Processing department aboard the USS

Nimitz

. Operations Supervisor - operate main console and peripherals; run daily

operations; EOD/EOM cycles; utilities and backups on HP 3000, IBM 360 and

UNISYS 1500 main frame systems

. Query Navy Intelligence Processing System (NIPS) Data base for vital

information for pilots performing flight ops and routines

. Database management; tape librarian; up/down load of system files

transmissions

. Job Control Language and Executive Control Language

Education

High School Diploma - South Portland High School, South Portland, ME - 1975

Certificate - Fundamentals of Quality Control - University of Maine,

Gorham, ME - 1980

Certificate - Quality Control Inspecting Tools & Gauging - University of

Maine, Gorham, ME - 1980

Certificate - USN Data Processing "A" School - Service School Command, San

Diego, CA - 1981

Certificates IT: - PC Service and Support/A+; Windows 95 Mod II; Windows NT

4.0; Word 97 Merges/ Macros and Forms; HTML Scripting Introduction;

Intermediate and Advanced; Front Page 2000; XML Fundamentals; MS Access

2000 Mod I; II and III; MS Access 2000 VBA Programming; SQL; VISIO 2000;

Microsoft Visual Basic.Net Introduction; Microsoft ADO.Net Introduction;

Crystal Reports 9.0 and 11.0 Introduction and Power User - VTEC South

Portland, Maine - 1996 - 2007

Certificates Telecommunications: - Wholesale Telecommunications Local

Service Request Training - FairPoint Communications Portland, Maine

September - November 2009

* Certificates Online Training MS Access & Excel: - MS Access 2007 - 2010

Beginning - Advanced and Power User; EXCEL 2007 - 2010 Beginning -

Advanced: - Skill - Soft online training/partnering with RobertHalf -

September 2011 - January 2012

Contact this candidate