Project Manager Sql Server

Abe Diaz

*** ******* **., ****** ** *****

Cell Phone: 479-***-****

E-mail: ***.****.**@*****.***

OBJECTIVE

To obtain a position as Sr. C# .NET Web Developer that will utilize my previous experience and allow for

professional growth

SUMMARY OF QUALIFICATIONS

U.S. citizen with 13+ years of software development experience

3+ years of ASP.NET, C#, AJAX Web and Mobile device development, and writing stored procedures

4+ years of ASP, JSP, ADO, HTML, CSS, JavaScript, AJAX Web development

4+ years of Windows user interface client/server database applications with Delphi and JAVA Swing

5+ years experience migrating databases: Access to SQL Server, FoxPro to DB2, Paradox to BDE

SKILLS

Industries: Consulting, Manufacturing, Retail, Human Resources, Logistics

Languages: C#, ASP.NET, VB, Transact-SQL, HTML, CSS, VBA, Javascript, AJAX, JSP, ASP, Servlets, JSP, C,

Delphi, C++, JAVA

Tools: Visual Studio 2005/2008, Crystal Reports, Websphere, Eclipse

Databases: SQL Server 2000/2005, Informix, DB2, MS Access, FoxPro, BDE

Software: Vault, Dreamweaver, Fireworks, IIS, Visio, Microsoft Project

EMPLOYMENT

Advanced Environmental Recycling Technologies, Inc. 2005-2009

Senior Programmer Analyst

Acted as project manager for all custom-software development in the areas of inventory management,

claims tracking, shipping, barcode labeling, barcode systems for this recycled composite lumber

manufacturing company

Maintained and enhanced existing intranet applications written in ASP. Created new web applications in

ASP.NET and C#. Created new mobile device applications using C# and Visual Studio 2005. Device

programs run on .NET Compact Framework and SQL Server Compact Edition under Windows Mobile CE

and Pocket PC / Windows Mobile 2003 operating systems.

Migrated databases and applications from Access to SQL Server 2000 and ASP.NET/C# for the new web-

based Claims Tracking System and the web-based All-Inventory system .NET reports

Developed C# mobile device programs running on Windows Mobile 5.0/Pocket PC based barcode scanner

guns made by Motorola/Symbol. Deployed for use in inventory movement of raw materials and finished

goods, fulfilling orders, creation of shipping bill-of-lading, and month-end inventory counting.

Converted the scanners for use by the ROSS ERP System to run on both Pocket PC based MC-9060

scanners and Windows Mobile 5.0 based MC-9090 scanners

Wrote many web-based reports, web applications, and mobile device applications using Visual Studio

2005 and SQL Server 2005 Management Studio, C# and ASP.NET. Device applications:

DatabaseExecutable – C# Windows app to upload device EXE program to SQL Server database

DeployExecutable – C# Device app to check for new releases of device app and download from server

DeviceClassLibrary – C# device library in DLL form storing common functions for mobile applications

AERTScanner1 – C# device application used for inventory movements recorded on local SQL CE

database and uploaded by batch to SQL Server using wireless network connection

LowesScanner – C# device application for scanning barcodes to selected locations used in inventory

counting. Stores barcode data to local SQL CE device database. Uses C# threads for fast scanning.

RawMatLookup – C# device application for looking up details of barcoded item

ShipOut – C# device application that downloads order pick list and fulfills orders for shipping

WscanIt – C# device application for scanning barcodes when moving finished goods items

Wal-Mart Stores, Inc. 2002-2005

Programmer Analyst (HR Team) 2004-2005

Worked in the Information Systems Division team of 18 – 21 persons developing web-based applications

and supporting Informix 4GL applications. Project development teams are from five to twelve

programmers

Acted as project manager for a team of four developers for the Performance Evaluation System

Used the following technologies UML, XML, XSLT, J2EE, WebSphere, DB2, Design Patterns, CSS, DOM,

JavaScript, HTML, CSS, JSP, Servlets

Acted as chief architect and developer for the following projects:

Performance Evaluations

Acted as main developer for the following projects:

Diversity Placement Tracking

Career Preference

Programmer Analyst (Store Cash Systems & HR Team) 2003-2004

Worked in the Information Systems Division team of 18 – 21 persons developing web-based applications

and supporting Informix 4GL applications

Used the following technologies UML, XML, XSLT, IIS, DB2, CSS, DOM, ADO, ASP, JavaScript, HTML,

Visual Basic, COM+, XSL-FO

Acted as chief XML designer and back-end developer in a team of eight developers for the following

project:

Hiring Center

Programmer Analyst (Store PC Applications Team) 2002-2003

Worked in the Information Systems Division team of 18 – 21 persons developing web-based applications

and supporting PC-based training. Project development teams are from three to five programmers

Used the following technologies UML, XML, XSLT, J2EE, WebSphere, CSS, DOM, ADO, ASP, JavaScript,

HTML, Servlets, JSP, Informix, SQL Server 2000, AJAX

Acted as chief architect and developer for the following projects:

Warranty Return System

SAM'S Gas Comparison

JB Hunt Transport, Inc. 1999-2002

Programmer/Analyst

Worked on Marketing Services team for 18 months to enhance the pricing system used by account

representatives to provide on-the-spot quote of freight delivery prices

Duties include all phases of application from requirements gathering to design, data modeling, software

construction, testing, and deployment

Software tools used are: Lotus Notes and Visio for documentation; Delphi 3 for prototyping and rapid

application development of the client application running in Windows NT

Used as back-end database is DB2 version 6 running in IBM MVS. Tools used for building the database

queries and updates in the mainframe include QMF, SPUFI, and Platinum RC Query. Static SQL were

created in the mainframe and accessed via client/server using IBM's APPC protocol

Created a program, ran monthly, to upload the mainframe DB2 database with pricing data from an

ACCESS database.

For 5 months, enhanced the pricing contracts maintenance system (FoxPro 2.6), used to keep negotiated

price contracts

As part of a 5-person team, shared in the design and construction phases to convert this system to JAVA

(1.2.2). The client application was developed using VisualCafe 4 Expert Edition. The design included

writing of the SQL specification for the database operations that were implemented as DB2 stored

procedures. Design pattern used was the Model-View-Controller (MVC) and Java technology used were

the Java Swing components for the graphical user interface (GUI) and JDBC for database access.

Company provided 143 hours of training through instructor-led classes on the following: DB2 Tuning,

Basic / Intermediate / Advanced Java, Object-Oriented Development (OOD) Using Unified Modeling

Language (UML), etc.

American Drug Stores 1998-1999

Delphi Developer

Contracted by Keane Inc. as programmer during the construction phase of the project for conversion of

the Third Party Accounting System to client-server programming

Used Delphi 4 for the data-entry screens, DB2 on the mainframe for the database

As part of a team of 5 developers, coded windows from detail design specifications and wrote and

executed unit test scripts, enhanced technical architecture code including system error detection and

reporting (exception handling) in both the client and agent pieces of the multi-tier architecture, agent

method for connection to database and agents through MIDAS (Multi-tiered Distributed Application

Services), productivity logging, etc.

Researched on impacts of conversion from version 3 to version 4 of Delphi, and performed the conversion

of code by adapting new components to the existing architecture

Aided team in debugging existing windows and prototyping new ones

For system testing, developed screens for test data generation

Wrote specifications for DB2 Stored Procedures

EDUCATION

University of the Philippines

M.S.E.E. - Computers and Communications, 1997

Bachelor of Computer Science, 1989

CERTIFICATIONS & ACHIEVEMENTS

Dale Carnegie Course

Kevin Turner Star Team Award

ACTIVITIES & INTERESTS

Northwest Arkansas .NET Users Group

Contact this candidate