Charles F. Fargis

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

Hillsborough, NJ 08844

Phone 908-***-****

E-mail abp97s@r.postjobfree.com

SUMMARY:

Experienced and adept at analyzing business requirements, structured analysis, designing, developing, testing and implementing database management systems. Experienced in several multi-million dollar and one 6.5 billion dollar business enterprises. A proven track record in telecommunications and consulting industries with specific concentration in decision support systems, information technologies and integrating diverse systems. Support and development experience in integrating systems from order processing and fulfillment, to implementing voice and data networks for call centers, trouble analysis support systems, and billing networks for diverse network elements. Principal designer/developer in areas related to logical and physical database design. User interface designer in multiple platforms and tools including MS Access, MS Excel, VB and VBA, Unix, NT, Oracle and SQL Server, shell and 3GL and 4GL Languages such as C, ksh, DOS/NT batch. Multiple years experience in both Unix and NT as architect, DBA, and developer. Recent experience in VBA in Excel and MS Access in pharmaceutical financial application.

Software

C, VB and VBA and ASP, Oracle SQLPLUS, PL/SQL, Oracle DBA + TOOLS, Informix 4GL/ESQL/SE, MS Office Professional (MS Access and MS Excel) Windows, Windows (All) Workstation and Server, Unix (AT&T, BSD & Solaris), MKS Toolkit, ksh (Korne Shell), Netscape + IE, HTML, TCP/IP, ADO, IIS, ODBC, SQL Server 2005,2000,6.5 and 7.0

Hardware

Sun Sparc and Ultra Sparc, HP-B and J class, x86 PCs and Servers, AT&T 3Bxx, Sync and Async Comm. (CSU, DSU, Terminals and Modems), Dell PE 1650/1750 and C D Laptops, and most Wintel based systems.

Work Experience

April 2007 – Present Pfizer Tools and Analysis supporting Software and Hardware Asset Management. Replaced existing Excel manual software purchase and inventory system with an MSACCESS, Oracle, ADO, DAO, IIS and SQL Server based tools. System recognized software purchases from Excel file, and did ETL necessary to load into HP Peregrine AssetCenter. Discovered installed software from SMS. Built ETL process in SQL server 2000 using DTS, linked servers, created Oracle views in Oracle. Designed and built over 50 stored procedures along with a new schema. System processes over 30 million records daily from SMS. Electronically audited ITIL CMDB Oracle DB with SMS discovery data. Provided analysis reports for a dashboard. Mentored the Business Objects developer in building and correcting Oracle PL/SQL procedures. Worked in ITIL and CFR 21 controlled pharmaceutical environment. Documented all phase of my work according to Pfizer standards. Produced reusable and repeatable process that removed a risk of liability of over 6 million. Trained others to perform my duties. Developed requirements for CFR 21 qualified system that interfaced to a Validated inventory system. Tested the product that was developed. Discovered 2 bugs leading to RFCs on a qualified system and worked with the Connect-It developer to effect the change. Worked with organizational peers to find and analyze enterprise data to corroborate data and or refute it.

Work Experience

Nov. 2005 – Dec. 15, 2006 AT&T Replaced existing Excel,and MS ACCESS system with a 27 step procedure. Designed system with Excel front end and MS ACCESS ASP and ADO to a single step web based one. Later ported DBMS to SQL 2005 .Proliant ML 360 which include 60 stored procedures and enforced referential integrity. Exposed problems customer requested database design audit of unrelated system. Produced defects reports demonstrating lack of referential integrity, unwanted upper/lower case sensitivity, invalid denormalization, and lack of primary keys in all entities. Provided ETL support of migration of an ITIL Asset Inventory database in Oracle to a Peregrine EDI database. Provided pivot tables by responsible manager and system admin of asset inventory. Made bulk data insert process more reliable by adding hardware validation of manufacturers and models via Excel data validation using evaluated ranges.

Work Experience

Jan. 2002 – Oct. 2005 4 contracts in Oracle and MS Access. Developed web based retail application for art studio course catalogue and class scheduling. Developed hardware inventory for systems integrator. Developed outsourcing status handler for a collections agency mining facts for outsourced accounts using Oracle 9i, ASP, Access Queries and Reports and html. Developed maintenance procedures for manufacturing environment in Free BSD 4.7 and 4.9. Learned and maintained PXE net boot server and used it to manufacture and ship about 30 systems. Also used Free BSD to manufacture DVDs and CDs for demos and system documentation. Trained others in its usage. All involved analysis of business and normalizing the database to as few tables and columns as needed.

Work experience Oct. 2001 – Jan. 2002 Biomedical Research Institute Phila., PA Developed Trans Atlantic Renal Council’s Microsoft SQL server 6.5 to 7.0 software for importing and transforming Fed. Govt. DB into custom report system. Developed 35 MS Access reports and 35 stored procs in db. Platform was mixed win98 Access 97 and Win2K and Access2K. Fixed referential integrity, store procedure and data loading (ETL) issues.

Work experience November, 1999 – Aug. 2001 ATS, Inc Red Bank, NJTesting planning and development with Telcordia Technologies Sprint Voice Over IP Project. Architected test hardware and designed & developed CORBA server ISO 9000 / CMM Level 5 testing software for provisioning interface using SQLPLUS, Tcl and Visibroker CORBA client to automate test process. Reviewed requirements, architecture & design. Wrote test plan and coded it for 70 interfaces and over 10K tests. Taught colleagues how to use it. Recommended dba replacement as there were no stored procedures, denormalization for speed, constraints, or plans for acquiring product updates.

Work experience August, 1998 – November, 1999 RSI, Inc Monmouth Junction, NJ .Network and workstation architect for Lucent Technologies on Saudi Telecom Company(STC) $6.5B telephone expansion program. Coordinated U.S., Saudi, UK, and Belgium based developers of systems for Operations, Administration and Maintenance of 16 operations support systems. Designed user access, data network architecture based on STC staffing needs, operational workflows, and systems to be used for over 90 servers and over 200 workstations for the STC enterprise. Also wrote 90-page customer acceptance test plan accepted by STC as customer’s test plan as well. Specified detailed aspects of physical hardware and how to phase in its implementation.

1997 – July, 1998 AT&T Somerset, NJ

Senior Member Tech. StaffEnterprise Applications Architect, Design and Developer – Teleconference ServicesDeveloped Reservation System Confirmation Server for faxing and printing Teleconference reservations. Developed platform components, using Optio DCS wrote application code to format 12 form styles; parse input field data from application interface, and dispatch requests to fax engine or lp. Designed and developed interface software to notify call center on status of requests. Provided hourly summary report of failed faxes. Taught production support maintenance procedures. Documented entire system using MS NT4 and IIS and Office 97. Negotiated network security needed for server and modems. Produced first year savings of $800K and annually $1M. Installed hardware when support person became disabled and trained maintenance personnel.Designed and Implemented Intranet solution to Provide Files and IIS/ADO based server for document sharing and for publishing MS Access databases. Convert MS Help files to HTML and set up document sharing from diverse locations with security. Used perl to implement data lookup in flat files.Ported Teleconference Desktop application from 16Bit to 32Bit VC++ 4.0 and VB 4.0. Negotiated new hardware configuration for Windows NT environment (Compaq PC/ Video/NIC) with Compaq channel partner and other vendors.Explored further use of Intranet using IIS/MS Office/ Oracle Web server 1994 –1997 AT&T Somerset, NJ

Senior Member Tech. StaffBuild 2 Teleconference Reservation Systems. Modify an existing Informix based system Developed in 2nd in NT + Oracle + VB + MS ACCESS. Oracle DBA and wrote application code for 13 VB projects to provision Conference Resources and Customers. Developed Reservation System Prototype. Hired and managed 3 developers in designing and coding reservation transactions for call center and reports.Designed and built network and procedures to transport call detail data for 50 Teleconference Bridges from Minneapolis to Somerset.Designed and Built VB application to recreate lost data when bridges crashed.1989 –1993 AT&T Somerset, NJ

Senior Member Tech. Staff

Designed and Developed Support System for AT&T 800 Service Maintenance Customer Care. Obtained user needs and designed Oracle database to determine call routing and responsible Local Carrier. Built associated trouble referral contact system. Interfaced this to X based GUI. Built automated interface to 31 terminal based systems that used either 3270 (IBM Mainframe) or Datakit (async) terminal interfaces. Built 2 finite state machines in C using 3270HLLAPI. Built X ksh based X resource configuration tool. Designed development process.1988 –1989 AT&T Somerset, NJ

SpecialistProject Lead and DBA for Oracle Based order processing System. System converted IBM mainframe order file to AT&T Network Switch transactions. System tracked, reported and alarmed order status. System also was required to rebuild Network switch records. 1986 –1988 AT&T Somerset, NJ

Supervisor

Project Management, Production Support and System Test for DEC MVS based message switch. Provided Project Plans and status for 2 projects and System test case generator for 1. Conducted 5 month field trials before cutover. 1983 –1986 AT&T Piscataway, NJ

Supervisor

Production Management, Requirements and System Test for 6 site Unix based order-processing System. Provided Project Plans, requirements, test cases, installation procedures, user training and support.

1978 –1983 AT&T Bell Laboratories Naperville, IL

Supervisor

Production Management, trouble incident analysis, Software and Hardware upgrade testing for 50-site 4ESS telephone switch. Analysis and documentation of all outages. Maintenance of M&Ps and tools and test equipment list, recommend hardware and software changes as needed. Designed (and received an award for) a hardware test case generator. Consultant to 5ESS design team on hardware system integrity monitoring and alarming in the public switched network. 1970 –1978 AT&T Naperville, IL

Supervisor

Repair and Administration supervisor for switching and carrier systems and engineering.

Education BEE 1975 Villanova University Villanova, PAPower and Computer Design SpecialtyChief Engineer College Radio Station WKVU FCC General Radiotelephone Operator’s License (PG-18-30253)

Contact this candidate