Project Manager Sql Server
Resume:
Claude R. Nikula
Mesquite NV, 89034
*******@**********.***
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