Project Manager Sql Server

Richard Michael Fults

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

Lakewood Ranch, FL 34202

****.*******@*****.***

Home – 941-***-****

Mobile - 941-***-****

Technical Skills:

MS SQL Server Versions 6.0 through 2012 (Standard/Enterprise)

Database Architecture, Data Modeling (Transactional and Data Warehouse), Views, Indexing Schemes, Stored

Procedures, SSAS, SSIS, SSRS

Analysis Tools

ProClarity, MS Excel Pivot Tables, Power Pivot, Analysis Services Add-in for Excel, MS Accelerator for

Business Intelligence, MS Business Scorecard Accelerator, MS Data Analyzer, custom web parts. Familiar with

Tableau, Brio and Cognos.

Languages

Transact-SQL, MDX, VBScript, Visual Basic v3-6, limited VB.NET and ASP.NET, ASP, VBA, XML

Other tools

MS Office (95-2013) (Access, Excel, InfoPath, Word, PowerPoint, Outlook, Visio, Publisher, OneNote), MS

Project/Project Server, Crystal Reports (through 9.0), MS Small Business Manager (MPP Certified), Great Plains

6.0 – 9.0, COBOL, Fortran, MS SourceSafe, MS Expressions, MS SharePoint Designer, Office 365

Functional Skills

Business Analyst/Project Manager

Identified and gathered the requirements that are critical to the business mission. Interviewed business area

experts asking detailed questions. Led project teams to consensus on project scope. Provided an approach for

documenting, categorizing, and packaging requirements. Have a thorough understanding of application

development methodologies (applied MS Solution Framework). Verified that requirements were realistic and

testable. Conducted periodic requirement reviews. Gathered requirements in a group setting by preparing an

agenda and managing the group discussion. Managed scope creep from outset. Developed and managed project

timeline, critical path, and resource allocation.

Professional Experience:

01/14 – Current WebFinitySRQ, Inc. Sarasota, FL

Managing Director / Owner

• Created an IT Services company, specializing in Web Design and Development.

• Responsible for all lead generation, sales, and requirement gathering.

• Developing a VirtualCIO product, providing local companies with guidance on all IT matters; vendor/solution

selection, RFP creation, Infrastructure, etc…

• Developing a VirtualDBA product, providing local companies with World-Class DBA services

06/14 – 01/15 LiveSmart360 Sarasota, FL

Director of Information Technology / SQL Server Developer / Data Architect

• Managed all software development projects. Responsible for timeline, cost, and quality of all initiatives.

• Implemented a scaled down version of the Agile Methodology (Kaizen).

• Responsible for organization compliance (CFPB, SAS70, SSAE16, HIPPA)

• Developed and implemented Disaster Recovery Plans

• Responsible for Vision and Direction of Information Technology

• Designed Help Desk processes and managed implementation of ticketing system

• Lead Business Process development sessions; provided leadership with guidance in regards to developing SOP for

departments

• Developed Data Centric, Web Based Architecture, integrating many solutions into a central data hub. Microsoft

Azure based.

• Developed and interpreted organizational goals, policies, and procedures

• Evaluated data processing proposals to assess project feasibility and requirements.

• Assigned and reviewed the work of systems analysts, programmers, and other computer-related workers.

• Responsible for identifying and managing all IT Infrastructure projects

• Hands on SQL Server DBA; developed Data Warehouse, SSAS, SSRS, and SSIS solutions

Resume - R. Michael Fults Page

1 of 5

09/10 – 07/14 DS Data Services Largo, FL

Director of Information Technology / SQL Server Developer / Data Architect

• Hired originally as a Database Architect; assumed Dir-IT role in June 2011

• Managed all aspects of IT. Responsible for timeline, cost, and quality of all initiatives.

• Responsible for concept, architecture, design, and implementation of SQL 2008 R2 transactional data store and data

warehouse. Migrated databases and solutions to SQL Server 2012

• Developed data application for core business product.

• Responsible for Data Center architecture and implementation. VM Ware solution hosted in Level 3 data center

• Developed ETL for importing 100’s of different file layouts.

• Developed all analytics and reporting for company; Microsoft BI stack.

• Responsible for identifying, implementing and managing all IT Infrastructure (Phone, email, 3rd party provided

solutions)

01/09 – 06/10 Sogeti USA, LLC Tampa, FL

Managing Consultant

• Managing Consultant; Manager of Microsoft SharePoint 2007 and SQL Server 2005/2008 Business Intelligence

practices.

• Solutions included intranet design, content management, business intelligence, reporting, dashboards, cubing, and

data warehousing.

• Responsibilities include participating in the sales process (RFP Response, Proposals, and Statement of Work), project

planning and management, design, implementation, and delivery of solutions. Additionally, performed as team lead

during development process.

• Projects include local county governments, mortgage service company, financial service company, and universities.

07/06 – 01/09 SouthTech Solutions, Inc. Sarasota, FL

Manager – Information Solutions

• Responsible for managing and implementing Information Solutions, which included custom .Net application

development, SharePoint deployments & customizations, SQL Server installations, migrations, upgrades, & MS

Dynamics (GP & CRM) implementations, consolidations, and customization. Technologies included SQL Server

7.0/2000/2005/2008 (Database architecture/design/maintenance, Analysis Services, Reporting Services, Integration

Services, etc SharePoint 2007 (MOSS & WSS, design/architect/implement), Architect & manager .Net

development projects (web, client/server, web services), managed Great Plains migration projects, implemented data

migration solutions.

• Managed custom application development project for large university medical school. Solution tracked and billed

time for resident doctor program at 5 campus facilities. Managed, architected, and developed an integration bridge

between MS Dynamics GP and an out-of-state fulfillment provider. Managed, architected, and developed a large data

migration and cleanup project, consolidating several standalone systems into one large data store. Responsible for

department budget, training, sales & marketing, and project management.

09/04 – 07/06 Intelligent Spirit Technologies, Inc. Lakewood

Ranch, FL

President / Founder

• Founded ISTI in 12/03 and began working full-time in 09/04. ISTI was an information technology consulting firm

that specialized in Business Intelligence. Managed all aspects of company.

• Developed marketing analytics tool using SQL Server 2005 Business Intelligence Stack for a local master-planned

community.

• Provided services to several local IT Companies needing expert SQL Server resources. Managed and/or participated

in dozens of SQL Server migrations and upgrades.

• Company was acquired by SouthTech Solutions in July 2006.

01/02 – 09/04 TechHouse Sarasota, FL

Senior Consultant / Business Analyst / Project Manager / Technical Liaison - Sales

• Developed Proof of Concept Business Intelligence solutions for a mid-size airline based in Fort Lauderdale and a

large manufacturer of tape products. Technologies included SQL Server, SPS/WSS 2003, Reporting Services.

• Developed application using VB6/SQL Server for local juice manufacturer. Application tracked and reported open-

enrollment selections of employees.

• Scorecard Accelerator, and Excel – Analysis Services Add-in. Gathered requirements and defined KPI.

Resume - R. Michael Fults Page

2 of 5

• Business Analyst on project with a large package and freight shipper. Gathered requirements on project to replace all

customer facing systems in the mid to enterprise market. Created and managed the following documents; project

vision, project structure, design and specification documents, and project plan.

• Defined and developed business intelligence solution for large drive-thru restaurant chain. Met with C-Level

individuals and Sr. Management to understand business objectives and gather requirements. Created data warehouse

architecture, ETL modules, data warehouse design, OLAP design, and KPI’s. Designed and implemented data scrub

routine to correct data discrepancies between systems. Developed financial and sales cubes; developed ProClarity

workbooks for Decision Support Group. Performed audit of data against original sources. Financial data was

extracted from LAWSON Accounting.

• Defined and developed business intelligence solution for large telephone equipment manufacturer. Met with Sr.

Management to understand business objectives and gather requirements. Created data warehouse architecture, ETL

modules, data warehouse design, OLAP design, and KPI’s. Developed cubes based on ERP systems (IMPACT/IFS);

developed ProClarity workbooks and Crystal Reports.

• Project Manager of an enterprise wide .Net application for a major juice company. Responsible for meeting with

sponsors and stakeholders; gathered requirements and created functional specifications. Led development team

though RAD process. Created and managed project plan and timeline. Led periodic team meetings with process

owners and developer led. Project was delivered on-time and on-budget.

• Developed Business Intelligence solution for a large community in East Manatee County. Extracted, transformed,

and loaded data from several disparate systems. Developed data scrub routine to correct discrepancies between

systems. Designed and developed data warehouse, along with determining KPI. Cube contained 27 dimensions and

4 measures. Modified existing Access front-end to switch data sources from Access to SQL Server; replaced queries

with views and stored procedures. Met with sponsors and stakeholders to gather requirements.

• Developed financial reporting system for large medical service provider. Using SQL Server Analysis Services and

Crystal Enterprise 9.0, created consolidated P/L reports and other consolidated reports. Also developed workbooks

using Brio. Developed data warehouse and OLAP cubes. Mentored internal IT staff on maintenance of cubes.

Performed as project manager and business analyst. Also led developers through development process. Data was

extracted from LAWSON Accounting.

• Led migration of Great Plains v6.0 to v7.0. Removed all 3rd party controls and replaced with MS Great Plains

standard functionality. Also installed Great Plains and Small Business Manager with several clients.

• Developed pilot Business Intelligence solution for large eye care provider. Designed data warehouse and OLAP

cubes. Developed DTS packages. Met with project sponsor and stakeholders to determine KPI’s and report delivery.

MS Data Analyzer was the front end solution. Excel using SQL Query was the reporting solution.

• Architected server farm for large electric co-op. Provided customer with 3 options for hosting several GB SQL

Server databases. Provided customer with all related documents and diagrams, including pricing of various options.

• Led several seminars for C-Level individuals regarding the merits of Business Intelligence and medium size

businesses.

• Taught several classes for user groups, including ProClarity, Pivot Table Services, and OLAP.

• Developed several other solutions using VB 6.0, Share Point Portal Server, Reporting Services, and InfoPath.

10/01 – 1/02 LazyDays RV Super Center Tampa, FL

Development/Production DBA – Project Manager (CONTRACT)

• Responsible for all projects timelines and milestones within IT department using MS Project 2000. Gathered tasks

from customers, prioritized phases, developed time lines, and assigned tasks. Performed as project manager on

intranet inventory application

• DBA for two production SQL Server installations, along with one development environment. Responsible for all

database maintenance, tuning, and backup plans.

• Developed several SQL replication tasks (Publisher and Subscriber), along with designing OLAP cubes to mine

national DMV records.

• Designed and implemented SQL Server 7.0/2000 databases for the marketing department. Developed migration plan

of data from legacy system (ADP Dealer Service) into SQL Server 7.0.

• Created stored procedures and SQL user-defined functions for data scrubbing of legacy data.

Resume - R. Michael Fults Page

3 of 5

2/00 – 9/01 Arthur Andersen, LLP Sarasota, FL

Senior Experienced SQL Application Developer – Team Lead

• Converted several SQL Server 6.5 databases to SQL Server 2000. Conversion included table structures, indexes,

constraints, data, views, stored procedures, and security. A significant portion of T-SQL required re-write, and was

optimized where necessary. All BCP calls were replaced with DTS. Created a locking scheme to take advantage of

SQL 2000 functionality. Met with Microsoft test lab personnel to discuss strategy and implementation scenarios.

• Responsible for architecture, design, and deployment of an application to create overtime calculations for

California hourly employees. Developed stored procedures to create .CSV files for importing into MS Excel. Stored

procedure rolled up data from a warehouse, created the .CSV file, and FTP the file to the web server. Additionally,

developed ASP pages to download the files to a local hard drive, or open immediately into an Excel spreadsheet.

• Created extensive data flow diagrams and data dictionaries for all existing databases within the WinTime suite of

products. Also created workflow diagrams for new and existing projects, including security models.

• Performed extensive MS Visual Basic 5 modification work to several existing internal audit tools. Modifications

included re-writing modules to increase client-side performance and data presentation.

• Developed and modified MTS components for web based application.

• Produced complex technical design documents for all development, which included concept, code snippets and

unit test scripts. These living documents were updated from “cradle to grave”. Documents were presented to full

team and selected users for input and discussion test results.

• Performed as Team Lead for the WinTime Reporter group regarding all SQL Server work. Carried out the

function of a technical leader, reviewing all design documents and oversaw all unit test results. Met with unit test

groups to discuss expectations, review results, and negotiated further enhancements to include/exclude from release.

• Participated on committee to create a test lab for the development group. Responsible for test lab becoming

“Black Box” system test lab versus developer “Test Crash” lab.

• Created and delivered training presentations regarding the Software Development Life Cycle to non-technical

groups to promote understanding of software development. Delivered point release presentations to the Global

Support teams when necessary.

3/99 – 2/00 Roster Control System Limited Sarasota, FL

Programmer/Analyst/Development DBA

• Developed commercial interface for Time and Attendance system to Ceridian Payroll and Great Plains

Accounting. Interface provided pathway for data from Access 2.0 into proprietary format for both Ceridian and Great

Plains. Project developed in Visual Basic 6.0 and Access 2000 using both ADO and RDO. Responsible for

architecture of data model. Extensive use of SQL and forms. Heavy use of ActiveX controls. Extensive development

of reports to customer specifications. Performed analysis from Planning Stages to delivery.

• Developed and modified MTS components for client server application.

• Designed custom interface for Client/Server Time and Attendance system. Developed using Visual Basic 6.0 and

SQL Server 7.0. Heavy use of T-SQL and Stored Procedures. Data exported from SQL Server 7.0 to a COBOL

legacy system using DTS.

• Performed extensive modification work to existing Visual Basic 3.0 / Access 2.0 commercial product. Performed

Y2K work using converted Date and Time ActiveX Controls. Added further functionality per customer

specifications.

• Provided ‘24/7’ technical/production support and national onsite support for customer base. Installed and

provided support for a telephony application.

• Created end user documentation for all systems developed or modified.

10/97–7/99 Inter-Con Security Systems, Inc. Pasadena, CA

Programmer/Analyst/Production DBA

• Developed and implemented migration plan for Enterprise Wide Relational Database System from Access 2.0 to

SQL Server 6.5, later SQL Server 7.0. Migrated data from existing system into SQL Server. Additionally, integrated

custom interfaces onto new platform

• Replaced existing ADP Payroll System with Zurich Payroll System. Created ODBC connections between

platforms for seamless data transfer.

• Designed and implemented multiple interfaces for existing Access 2.0 / VB3.0 application. Interfaces included

exporting data to standard payroll and billing systems, and custom reporting using Visual Basic 5.0 and Access 97.

Developed prototype for 100-user Document Routing System in Visual Basic 5.0 and Access 97.

• Developed company-wide operational procedures in use of existing and new software systems, including

business rules. Reduced payroll-processing time by 150% and increased accuracy over 200%.

• Provided system and user support in a 24-hour environment.

Resume - R. Michael Fults Page

4 of 5

• Responsible for 110 node NetWare 3.12 network (later Windows NT 4.0), 6 user proprietary network (InvisbleLan),

and 24 hour telephony Time and Attendance system.

7/94 – 10/97 Chuck Hasz Enterprises, Inc. Woodland Hills, CA

7/88 – 2/91 Programmer/Analyst

• Designed and implemented Construction Fund Disbursement System using Visual Basic 5.0 and Access 97. System

tracked all funds spent and lien information for construction projects. Responsible for program from ‘cradle to

grave’.

• Conceived Data Model and Entity Relationships based upon existing paper based procedures. Responsible for GUI

design. Extensive use of ActiveX Controls for both Date/Time and Financial calculations.

• Developed custom reporting for all facets of Company, including A/R, A/P, G/L, P/L, and inventory tracking.

Additional reports developed for Customer Disbursement Package. Reports designed in Access 97.

• Created product to estimate construction material cost based upon square footage of project. Database contained

prices and typical units of measure.

• Responsible for all technology decisions.

2/91–7/94 Storm Front Technologies Glendale,

CA

Programmer/Analyst – Partner

• Designed and marketed ProducePak, a complete accounting package for the Produce Industry. Program included

A/R, A/P, G/L, invoicing, P.O. tracking, payroll, real time inventory, bank and credit card account tracking, shipping,

point of sales, EDI, small word processor, and remote control software for support. Product was developed using

dBaseIV/Clipper on the DOS platform.

• Worked with industry leaders developing Data Model and functionality requirements. Product was developed to

handle multiple types of produce companies. Software was configurable to work with brokers, wholesales, shippers,

and retailers.

• Designed help desk database and end user documentation. Trained sales force on technical merits of product.

• Provided ‘24/7’ technical/production support and national onsite support for customer base.

• Manager of 4 person development team. Responsible for all technology decisions.

7/84 – 7/88 Consultant Los Angeles, CA

Programmer/Analyst

• Worked on various contracts developing DOS based applications. Developed using mostly QBASIC, Turbo

Pascal, dBase, Btrieve, and Lotus. Also provided code maintenance in a COBOL HP MPE environment.

Education:

1984-1986 Pasadena City College Pasadena, CA

Computer Science / Data Processing

Certification: Microsoft Certified Professional

SQL Server 2000, 2005

Microsoft Dynamics GP 6.0 – 9.0 / CRM 1.0

References:

Available upon request.

Resume - R. Michael Fults Page

5 of 5

Contact this candidate