Post Job Free

Resume

Sign in

Project Manager Sql Server

Location:
Mesquite, NV, 89034
Posted:
May 26, 2011

Contact this candidate

Resume:

Claude R. Nikula

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

Mesquite NV, 89034

858-***-****

abhf17@r.postjobfree.com

OBJECTIVE: A career position in business to effectively utilize educational background and skills in computer

programming and information systems.

Bank Of America Agoura Hills, California, Certificate 2009

EDUCATION:

ECMS Program Overview

Bank Of America Agoura Hills, California, Certificate 2009

ECMS DTS Integration

Bank Of America Agoura Hills, California, Certificate 2009

DSS Waterfall and Responsibilities

Bank Of America Agoura Hills, California, Certificate 2009

DSS Waterfall Process

Bank Of America Agoura Hills, California, Certificate 2009

2009 Fair Lending

Bank Of America Agoura Hills, California, Certificate 2009

Information Protection and Privacy

Bank Of America Agoura Hills, California, Certificate 2009

2009 AML Enterprise Awareness v2

Vortex Education, Certificate 2005

C# .Net

Hands On Technology Transfer, Certificate. 2003

Visual Basic.Net,

UCSD, La Jolla, California 2001

Advance HTML

Microsoft Education Certificate 1999

Mastering Enterprise Development

Microsoft Education Certificate 1998

Visual Basic 6.0, Visual FoxPro 6 and Solutions Framework

Oracle Education Certificate 1997

Oracle RDB

UCSD, La Jolla, California 1995

Bachelor of Science in Computer Science

Mesa College, San Diego, California 1995

Certification in Visual Basic 3.0

Coleman College, La Mesa, California 1994

Certificate in Computer Information Science

Platt College, San Diego, California 1985

Certificate Mechanical/Electrical Design/Auto CAD

PUBLICATIONS: FoxPro Advisor, Free the Client!. January 2001.

San Diego FoxPro Developer magazine February 2000.

HARDWARE: Structured real-time and application programming on IBM 9221 mainframe,

IBM 9404, AS/400, i-Series, Honeywell BULL, VMS and Microcomputers.

LANGUAGES:

Visual FoxPro 5,6,7, 8 and 9 ADO.Net ASP.Net C#

FoxPro 2.6 Win/DOS

MS SQL 6.5, 7.0, 2000, Oracle RDB ADO 2.0, 2.1 & 2.5 ASP, HTML, PHP, Zend

2005, and 2008 (Transact SQL) ADO .Net Server

MySQL, Com and Com + MTS Auto LISP

Turbo Pascal 6 C, C++ Visual Basic 3, 6 MS QuickBasic

PL/1 RPP/400 COBOL IIS, Apache

AREAS OF Networking Theory Networking Administration

STUDIES: Computerized Accounting Principles of Programming

Computer Concepts Arch. and JCL

Inventory Applications Computer Operations

System Analyst and Design Database Design and Structures

Enterprise Development Project Management

Database Design

WORK

EXPERIENCE:

SUMMARY

Combined experience in the last seventeen (17) years in the Mechanical Electrical Engineering

and Computer Science field. My primary focus has been on Enterprise Development (Client

Server and Websites), Database Application for Microsoft NT, Novell, Windows 2000, Windows

2003, Windows 2008 Server, Window XP, Vista, Window 7 and Linux

03/01/10 – Present Project Lead Programmer/Project Manager

Mesquite Information Technologies, LLC

I was responsible for building 3 websites and SEO for one of our client.

The 1st site was for a medical office Five Star Vein Institute [www.fivestarvein.com] This site

was built with PHP, JavaScript, custom CSS and MYSQL. This is a CMS using Drupal.

2nd Website was for Laird Plastics [http://www.lairdplastics.com/] This site was actually

converted from a framework called Moombo to a Joomla website. This site required an extensive

rework because of the conversion and custom theme work. This also required lots of

customization to the Joomla modules. One of the reasons that it required extensive customization

is that it required us to connect Joomla to JDE database (DB2). Also, this site is running on a i-

series (AS400) with AIX OS and Zend Server, which presented its own problem.

3rd Website was built for Laird Plastics [http://lairdu19.lairdplastics.com/] This site is the

employees educational website that allows them to go through specific courses and be certified.

This site automatically grades the students and issues a certificate when appropriate. This site can

be opened also to their vendors. It was built on Moodle. The primary technology used for this is

PHP, JavaScript, MYSQL, and Zend Server, running on a i-Series (AS400) with a OS of AIX.

Currently I am working on the company’s first product. There are 3 phase for this project.

Phase I building a stand-alone desk top application written in VFP 9. Phase II is to build a

Website and a backend database using MYSQL, PHP 5.3 or later, JavaScript. Phase II will also

send text message and alerts to cell phones. Phase III will interphases with RV Dealerships

As a project manager I am responsible for making sure our project come in on time and within

our budged. I also write Requirement documents for our projects and the bids.

06/02/08 – 03/01/10 Project Lead Programmer

Mesquite Information Technologies & Sapphire Technologies

As a consultant for Sapphire I was assigned to work on the Bank of America and Countrywide

Software Merger, in Agoura Hills, California. I was primarily responsible for enhancing and

merging Bank of America features into Countrywide’s flag ship home loan mortgage program

(EDGE). Some of the features that I had added are NACA, Massachusetts home loan partnership,

RegX which is the new federal government regulations for 2010, low to moderate income

consolidation, and Opt Out tax and or flood insurance. The primary software development tools

that I used for these projects are VFP7, VFP9, MS SQL Server 2005, and .Net Web services.

Additional duties that I performed were to review and make corrections on functional specs, and

review and make corrections on technical specifications. After implementing code changes or

enhancements I was responsible for documenting my own unit testing, reviewing quality control

test documents and approving them, preparing a content review document in reference of the

changes I made, and presenting to Support Desk level one through three. Some additional

management tools that I used to perform all these tasks was Viper-Project Management Tool,

PVCS-Version Control Tool, and Visual Source Safe-Version Control Tool.

02/01/03 – 06/02/08 Senior Analyst/Systems Integration Specialist

GNS Information Technologies, Inc. San Diego CA

As a consultant for GNS IT my primary responsibilities are to manage projects, write project

specifications and code as well. I was the primary consultant for three of GNS IT clients. The first

one is Kaiser Permanente where I was maintaining one of their VFP 8 Appointment Scheduling

Systems. I also wrote a new application for them, in VFP 9 that is used for writing prescriptions

and scheduling follow up appointments, as well as, rehabilitation classes.

The second company was Mediafax Incorporated who is located in Puerto Rico. I have completed

working on a marketing statistical analysis application which is used for marketing ratings

throughout Puerto Rico and South America. This application is written in VFP 9, VMP, And

Microsoft SQL Server 2000 (Transact – SQL).

The third company was Psychology clinic in Los Angeles, California where I had assisting them

in the data conversion of their primary application that is written in FoxPro for DOS, I converted

their tables into Microsoft SQL Server 20005. My primary role for them was to write the

conversion processes and automate their data validation testing.

Created a Vertical Market application in VFP9 SP2 for a company based out of Los Angeles,

CA. Some of my other clients are FourSource Software, Inc, Amedisys. Performing duties like

Database Design, Stored Procedure (VFP DBC & DBF, Microsoft SQL Server 2005) and User

Interfaces (UI)

In addition to the above duties I was responsible for GNS IT in maintaining the books, accounts

payable, accounts receivable, and maintaining GNS IT website which was written in C# and

HTML, however it now has been rewritten in PHP.

05/06/02 – 02/01/03 Senior Analyst/Systems Integration Specialist

GST/MOCC US Navy, North Island, San Diego, California

I had rewritten their main Database application witch runs on a UNX and was written in Cobol.

The customers US Navy and Marin Corp dials in very day and uploads changes to the main

system, then once a month they get a copy of their inventory on a CD. The new system will be

rewritten in VFP 7 and ASP and the data engine will be VFP 7 and MS SQL2000. This

application will be deployed to all calibration labs and US Navy Ships

11/96 – 04/19/02 Senior Analyst/Programmer

District Attorney's Office, San Diego, California

As a project leader/developer I was responsible for numerous development projects for short term

and long term. At any given time I was supervising one to four programmers on various projects.

It was my responsibility to interface with our customers (users) and to insure that their

recommendations and concerns were implemented in the various projects. It also was my

responsibility to insure that each project was maintained on schedule and on budget, and that

included all the testing as well.

One of the applications that I create tracks potential Welfare fraud that is called the District

Attorney Parent Locator (DAPL) program. The program downloads data from the Oracle

database that resides on the VAX System and updates DAPL. DAPL then does some Data

Mining and alerts Child Support Officers of potential cases that Welfare fraud may be committed

on. I have also written a DMV Screen Scrape, which allows a Child Enforcement Officer to

connect to the DMV mainframe, and scrape the record and load it into our database. The Screen

Scrape was written in FoxPro 2.6. I wrote a Com Object in VFP 6 SP3 for the Screen Scrape that

is to be used in The New Bureau of Child Support System (Rally2000). This system was

coauthored with Microsoft and myself. Rally2000 has a user interface written in VB 6, and the

Com Objects for the middle Tier were written in VB 6 and VFP 6, and the data resides in

Microsoft SQL 7.0, which is our Data Tier. All Com Objects run on MTS, which is our Business

Tier. Also, I wrote all the data transfer Automation Servers to support the Legacy Application.

The Data Transfer Modules are primarily written in VFP 7. For the new system I wrote a Stress

Tester, which was written in VB, C++ ATL. And VFP 7

1/96 - 11/96 Computer Specialist Analyst

Prospective Computer Analysts, Inc., San Diego, California

My primary functions were reviewing, designing, coding applications, analyzing problems, and

recommending and implementing solutions. Projects that I had been involved in were primarily

written in FoxPro 2.6 and Cobol.

2/95 - 1/96 Application Programmer/Network Administrator

CTI/DCS, San Diego, California

My responsibilities were to create applications to automate the functions of various departments.

I also assisted customers with their programming needs by generating various statistical reports

regarding measure operation. I was the primary Network Administrator for NOVELL 4.1.

06/93-10/94 Designer

(TSA) FLUID COMPONENTS INC., San Marcos, California

Development of new products, assembly, and fabrication drawings.

Developed and maintained database in FoxPro 2.5 for DOS for configuration management, and

tracking of other information.

10/92-06/93 Designer

(TSA) NELLCOR INC., San Diego, California

CAD conversion coordinator. As the coordinator of cad conversion, I developed and wrote the

routines in dBASE III to help me manage the CAD conversion by recording all the necessary

information to manage this project.

05/91-10/92 Designer

SYSTEMS ENGINEERING & MANAGEMENT CO., Carlsbad, California

I designed transmitter receiver enclosures and PC layouts, and did a reverse engineering on the

C-5B maintenance simulator, C-17, P-3, and Ground Tulininary (MGT). Also, I created drawings

for the Basic Electronic Maintenance Trainer.

09/89-05/91 Designer

COMPUTER SYSTEMS DEVELOPMENT CORP., San Diego, California

Provided support to the Automatic Test Programs branch of the Naval Aviation Depot at North

Island, California (ATE, HTS, and RSTS). Updated the 74D040934, created over 700 test

diagrams, and created test diagnostic flow charts.

Personal Profile: I am a veteran of the United States Marine Corps. I served eight years with an honorable

discharge, a grade rating of Staff Sergeant, and held a Top Secret Clearance. I am currently a

board member for the San Diego FoxPro Development Network.



Contact this candidate