Project Manager Sql Server

Jos Fortuny

**** ***** ** . **** ******, FL ***** . 813-***-**** .

abmu0o@r.postjobfree.com

Executive Profile

RESULTS ORIENTED IT LEADER WITH 20+ YEARS OF DOMESTIC AND INTERNATIONAL

EXPERIENCE. OUTSTANDING MANAGEMENT, INTERPERSONAL AND TRAINING SKILLS.

PROJECT LEADERSHIP EXPERIENCE SPANNING DIVERSE INDUSTRIES; NOTED FOR THE

ABILITY TO DELIVER PROJECTS ACCORDING TO CLIENT SPECIFICATIONS AND WITHIN

TIME AND BUDGETARY CONSTRAINTS. EXPERTISE IN CUSTOM DATABASE ARCHITECTURE

FOR TRANSACTIONAL AND DIMENSIONAL REPOSITORIES AND SDLC METHODOLOGIES FOR

APPLICATION ANALYSIS, DESIGN, ARCHITECTURE, DEVELOPMENT, TESTING AND

INTEGRATION USING TRADITIONAL OR AGILE DEVELOPMENT METHODS. ADVANCED

REQUIREMENTS ANALYSIS AND NEEDS ASSESSMENT ABILITY.

Education

PURDUE UNIVERSITY, WEST LAFAYETTE, IN

Doctor of Philosophy: Industrial Engineering/Operations Research

Purdue University, West Lafayette, IN

Master of Science: Agricultural Economics

Universidad de C rdoba, Spain

Escuela Superior de T cnica Empresarial Agr cola

Licentiate: Business Administration

Professional Experience

LINCARE, INC, CLEARWATER, FL

02/2008 - PRESENT

Manager, Database Development

Hired to architect database replacements and improvements for legacy

systems (System i file-based legacy stores and SQL Server stores) and to

introduce dimensional database analysis and reporting environments in the

organization. Database environment consists of DB2 for i as well as SQL

Server 2005.

Hired to lead the development and upgrade of work force skills in the

Database Development team.

Evaluated requirements for the new data repositories and conducted gap

analysis to compare needs with existing application and database stores.

Directed the analysis, design and development of new database structures

and led the development of the enterprise data dictionary and documented

those data structures and data dictionary using Embarcadero's ER/Studio.

Directed the conversion of database structures and programs from SQL Server

2000 to SQL Server 2005 for home-grown and third party operational

databases.

eAutoclaims, Oldsmar, FL

04/2005 - 02/2008

IT Manager

Hired to architect database and application replacements for legacy claims

management systems.

Lead the design and development of a collection of new systems to replace

existing legacy applications. Managed projects leading to the replacement

with a team of 6 internal developers and additional offshore programming

resources.

Lead upgrade of work force skills in Information Systems.

Implemented iterative SDLC methodologies for the development of the new

systems.

Evaluated requirements for the new data repository and application and

conducted gap analysis to compare needs with existing application and

databases. Using UML methodologies (and the Enterprise Architect product),

documented the new requirements with use cases, business process models,

activity and sequence diagrams as well as distribution diagrams.

Analyzed, designed and developed database structures for the new

application and documented those data structures using a combination of UML

data and class models (in Enterprise Architect) and E/R diagrams (SQL

Server 2000).

Allocated module development tasks to members of the programming team and

managed project progress and deliverables (MS Project).

Technologies in use: UML/Enterprise Architect for data modeling, object

analysis and design, business process diagramming and process sequencing;

RUP for iterative design; MVC framework for class and object development

and for three-tier application partitioning; SQL Server 2000 and 2005 for

analysis, design and development of data structures and referential

integrity; Flex 2, ActionScript 3, ColdFusion MX 7 for development of the

data access and WEB interfaces to the database.

Fortuny Software Systems, Tampa, FL and Ozark, MO

08/1992 - 04/2005

Project Manager/Designer/Architect

Internet Based Payday Loan Processing

Designed and managed the development and implementation of an Internet

based payday loan application and delivery system for AAA Payday Cash (MO).

Personal responsibilities in the project included Business Analysis, System

Design, Unit Testing and Project implementation. Developed the database

structures in support of the project. Managed a team of developers, partly

offshore.

Technologies used: UML/Enterprise Architect, iterative design (RUP), Visio,

ASP.NET, VB.NET, SQL Server 2000.

Job Shop Manufacturing System

Designed and managed the development of a job-shop manufacturing system for

EDCO (document conversion company, MO) - consulted for client on production

management, software systems design and programming.

Personal responsibilities in the project were for Requirements Analysis,

Architecture of the system, Architecture of the Database, Application

Design and Project Management. Developed the database structures in support

of the project. Managed a team of business analysts (in country) and a team

of developers (offshore).

Technologies used: UML/Enterprise Architect, .NET tools, particularly

VB.NET, and SQL Server 2000.

Energy Systems

Created energy accounting system for AECI (MO) electric cooperative using

VB 6 and SQL Server 6.5 database server.

Designed and developed meter inspection subsystem and LIHEAP (Low Income

Home Energy Assistance Program) subsystem for City Utilities of Springfield

(MO) - integrated with existing CIS+ (Customer Information System -

developed in VB 6 using Oracle database backend.

Personal responsibilities in both projects were the analysis and design of

the application (modules) and the data structures required for

implementation as well as the integration of these modules with the

existing applications. In both cases, managed the programming (offshore)

and the integration teams.

Not-for-Profit Web Portal Development

Planned, designed and developed international non-for-profit Web portal for

secure registration and delivery of services for Students In Free

enterprise (SIFE, MO) .

Designed client outcomes management system.

Technologies used: VB, ASP, JavaScript, VBScript and SQL Server 7.0.

Other Projects

Engineered distributed clinical record information system, healthcare

information exchange network and repository - collaborated with other

Consultants under umbrella project managed by First Consulting Group.

Developed employee benefits management system in association with TPA

(Third Party Administrator) with 1st phase consisting of cafeteria plan

management system with both character based and client-server components.

Prepared and conducted training programs in relational database design, SQL

and Informix 4GL for various firms in Trucking, Printing and Development

industries.

Other Responsibilities

Provide technology consulting, software development/integration services

and system management services.

Operate in numerous roles to meet client needs, including: Project Manager,

Systems Architect, Software Designer, and Marketing and Administrative

Executive.

Plan, project manage and implement applications in open system, multi-

protocol-networked environments.

Whitlock, Selim & Keehn, Springfield, MO

06/1989 - 08/1992

Manager, Management Information Services

Directed business application and MIS (management information systems)

projects for clients of CPA firm.

Analyzed clients' needs and identified software, hardware, communications

and networking equipment to meet functional requirements.

Guided implementation of selected systems, employee training and

recruitment for installed systems.

Developed specialized order entry and manufacturing planning system for

printing company - utilized Informix-4GL using FourGen s CASE tools with

interface to FourGen accounts receivable package.

Devised and developed specialized labor tracking/payroll preparation system

for insulation contractor - in Informix-4GL using in part FourGen s CASE

tools with electronic interface to ADP payroll management system.

Created customized job tracking/costing system for insulation contractor.

Developed fund management system for not for profit corporation.

Held responsibility for system administration of Novell and TCP/IP networks

supporting mixture of UNIX and DOS systems, and various wide area network

communications systems.

Kuwait Petroleum International, London, England

02/1984 - 12/1988

Information Services Coordinator

Created and implemented corporate information technology policy throughout

12 affiliated European subsidiaries.

Managed $25-$35 million annual capital budget for replacement of legacy

systems by distributed, client-server open systems within time and

budgetary parameters.

Led upgrade of work force skills in Information Systems Departments

corporate-wide.

Santa Fe International Corporation, Alhambra, CA

05/1980 - 02/1984

Management Science Manager, International Drilling Division

Managed projects worldwide in areas of Operations Research, Scientific

Programming and Information Center.

Led development of system to improve movement of drilling rigs in Orinoco

Delta and development of systems to schedule preventive maintenance and

part replacements of field equipment for Lake Maracaibo operations.

Optimized scheduling of rig construction projects.

Developed network of information systems and marketing intelligence

software for Marketing Division of Kuwait Petroleum Corporation in Safat,

Kuwait.

School of Business Administration, University of California, Riverside, CA

07/1979 - 06/1981

Assistant Professor

Prepared and taught Management Science and Quantitative Methods courses.

Technical Skills[1]

METHODOLOGIES: UNIFIED MODELING LANGUAGE (UML) AND RATIONAL UNIFIED PROCESS

(RUP).

Software: Enterprise Architect, Microsoft Project, Office, ER/Studio,

Eclipse and Visual Studio (.NET).

Languages: T-SQL, MDX(intermediate), Adobe Flex 2 and ActionScript 3

(intermediate); Microsoft Visual Studio:VB.NET (elementary), C#

(intermediate) and ASP.NET (elementary); ColdFusion MX 7 (intermediate);

UNIX and Windows Shell Scripting

Databases: Microsoft SQL Server 2000, 2005 and 2008, SSAS, SSIS and SSRS;

Informix Dynamic Server; DB2.

Operating Systems: Various flavors of Microsoft Windows, Linux and UNIX

operating systems.

Networking: TCP/IP and NFS.

Publication

CONTRIBUTING AUTHOR, INFORMIX UNLEASHED, SAMS PUBLISHING, 1997

References available upon request.

[1] Skills at an advanced level unless explicitly noted otherwise.

Contact this candidate