Skills and Experience
Systems Analysis
Systems Design
Systems Dev.
Systems Conversion
Systems Testing
Systems Maint.
Systems Doc.
Business Mgmt.
General Accounting
Financial Reporting
Process Analysis
Employee Dev.
Industry Lines
Healthcare
Automotive
Aerospace
Computer Applications
MS Excel
MS Word
MS Access
MS SQL Server
MS SSIS
MS SSAS
MS SSMS
Crystal Reports
EAS 9.0
QuickBooks Pro
Education
M.S., System Analysis/Business, Univ. of West FL
B.S., System Science/Business,
Univ. of West FL
MCSD
MCT
MCP
QuickBooks Pro Cert.
CA Real Estate (Ret.)
Principal Areas of Practice
Business Systems Analysis, Data Warehouse Architecture (BI, Analytics, SSIS, ETL, etc.), and accounting / bookkeeping, with a Master of Science, Business, degree (Systems Analysis-Business), bringing extensive experience in business systems, including accounts payable, accounts receivable, payroll, data warehouse (DW) development, and business administration and automation. Accurate and organized with strong problem-solving skills, attention to details, and willingness to accomplish any challenge. Experienced in business systems requirements definition, design, development, conversion, testing, implementation, maintenance, documentation, and personnel training; i.e., full SDLC.
Major Projects
BI Analytics Data Warehouse System Development
Designed, developed, programmed, and optimized a World-Wide Parts Analysis BI system for ISUZU Motors North America, Inc. using SQL Server (extensive use of complex Stored Procedures), Microsoft OLAP Services including ETL, and Visual Basic on a Windows Server. This system required the integration of legacy data from numerous systems from around the country such as IBM (DB2 & IMS), Oracle, UNIX, and others.
Corporate Accounting & Business Automation
Designed and developed numerous Microsoft SSIS (SQL Server Integration Services) projects designed to automate the ETL, Import/Export of Corporate Accounting Information from over 36 subsidiary companies and many national vendors (e.g., AMEX, Office Depot, etc.) to and from the corporate accounting system (EAS v9.0), using Microsoft’s BIDS (Business Intelligence Development System – SSIS, SSAS, SSRS, SQL-Server).
Designed, developed, programmed, tuned, optimized, and supported the front and back ends of the critical proprietary Transaction Processing / Customer Billing System for Roam International, Inc., a specialized global Internet service provider partner with IPASS, Inc., using SQL Server, Microsoft OLAP Services, and Visual Basic on a Windows Server.
Highlights of Career Positions prior to Consulting Career
ISUZU Motors North America, Inc.
Tenet Healthsystems Corp., Santa Monica, CA
Wells Fargo Bank, Inc., San Diego, CA
Peregrine Systems, Inc., Carlsbad, CA
Professional Work History
Company / Title / Date
FLORIDA GROUP UNLIMITED, INC.; Bus. Analyst / Consultant; 09/2010 – Present
ROBERT HALF MANAGEMENT RESOURCES, Analytics Consultant; on request/sub-contract
UNIVERSAL AMERICAN CORP.; Sr. Bus. Systems Analyst; 05/2008 – 09/2010
GLOBAL GROUP UNLIMITED, INC, Bus. Systems Analyst / ETL / Rpt Dev; 06/2005 – 05/2008
ROAM INTERNATIONAL, INC. Sr. Bus. Analyst / Systems Developer / DW, 01/2002 – 06/2005
ITRESOURCES, INC., Sr. Lead DW Bus. Systems Analyst, 09/2000 – 01/2002
COTELLIGENT, INC., Sr. Consultant / SQL Server DW Developer, 04/1997 09/2000
SYNERGISTIC DATA, INC., Bus. Systems Analyst / Programmer / Database Developer, 1996-1997
TENET HEALTHSYSTEMS CORP., Bus. Systems Analyst / Programmer / DB Developer, 1994-1996