PROFESSIONAL SUMMARY:

• 18+ Years IT Experience as a Software and Hardware Consulting professional.
• I have worked on many innovative and cutting edge projects starting with fiber optics Data Warehousing of which I was one of the pioneering developers of such data deliverables.
• My goal to an employer is to deliver the most expedient, reliable and reusable software possible.
• Physical storage, indexing, physical database design best practices, and the Query Optimizer.
• Normalization, de - normalization, and schemas for both OLTP and OLAP databases.
• Building business rules (business processes, business entities, designing the Data model).
• Creating Documentation to ( support, communicate, and validate the data model).
• Building ERD (entity relationship diagrams) documentation, business process diagrams, and process flow diagrams, metadata, etc.

TECHNICAL SKILLS:

Technical Skills: SSIS, DTS, Oracle OCI, Oracle SQL, Oracle Database admin, Sybase SQL, C Programming, Crystal Reports Design/coding, Database theory, ODBC Setup, Novell Admin, Meridian PBX programming, Toshiba PBX programming, PC Troubleshooting, Software Troubleshooting, Terminal Setup/Hardware, Terminal Server Programming, Voice Mail programming, TCP/IP programming, Email server setup, Unix Mini Frame Administration.

Office Skills: Typing, Filing, Faxing, Copying, Mail Room, Answering Phones, PBX Switchboard, and Help Desk.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Architect and design a system to recover Tax revenue and recommend addendum to the current process
• ERD Design and Development
• Custom ETL C#
• Design Mobile responsive system to tie 4 state departments
• Architect and devise best data cloud solution
• Devise a data dictionary
• Devise Data business rules
• Migration and Scheduling Reports for Management Team

SAP Crystal Reports Administrator

Confidential, Boca Raton, FL

Responsibilities:

• Single report admin presently per request
• Crystal Reports 2013 Development Consultant-Salesforce.com project
• CR Server Admin
• Migration and Scheduling Reports for Management Team
• Custom Naming Report scheduling conventions using C# VS2013.
• ETL consultant C# custom migrations

SAP Crystal Reports Administrator

Confidential, Boca Raton, FL

Responsibilities:

• Single report admin presently per request
• Crystal Reports 2013 Development Consultant-Salesforce.com project
• CR Server Admin
• Migration and Scheduling Reports for Management Team
• Custom Naming Report scheduling conventions using C# VS2013.

Crystal Reports Developer

Confidential, Sacramento, CA

Responsibilities:

• Data Hygiene methods and Development 1+ TB DB
• Field Force Specific Crystal Reports Deployment Effort to build a dynamic multi-layer Sales Force Penetration report with built in user security and Rollup design.
• Develop Correlated Sale force Data Model with Regional Rollup
• OLAP Development
• DDL and DML programming
• Convert existing EMR medical Data to archive reporting model

Consultant

Confidential, Greenacres, FL

Responsibilities:

• Custom Applicant intake and History Application for the needy families in south Florida.
• Custom software donation to help the assistance program track dispensed goods ( Custom C#, ASP.NET)

Data Architect Consultant

Confidential, Boca Raton, Fl

Responsibilities:

• DBA all data implantation solutions using MySql for OLAP
• Implemented Initial Demo Solution Using SQL Server, SSIS
• Pivot Table - Dashboards utilizing US Car Purchases projected and Polk Car Demographics.
• Built C# solutions for Daily Processing and Data Load (Chromedata,informa,ALG,IZMO)
• Built C# solutions utilizing FTPclient and Web Client for downloading and storing photo Galleries
• DBA and Developer Auto Purchasing Database
• DBA and Developer Dealership Sales and Inventory Database
• DBA Automotive, Nationwide Banking Rates, Tax and Residual Database( Chromedata,ALG,Informa and IZMO)
• Build Prototype deployment model
• Comprise Views for Residual Rollup
• Developed Prequalification Automotive Quoting Stored Procedure for a list of Vehicles within the parameters of the existing Equifax credit tier and Informa bank rates by state.
• Assist in Product Deployment Platform and Web Solutions - ATT Hosting, Custom PHP Solutions

DBA Consultant

Confidential, Pembroke Pines, Fl

Responsibilities:

• Data Migration MySQL 5.0 to Amazon EC2 ver 5.7
• MySQL DBA all Local and Production Servers
• MySQL Performance Tuning
• MySQL Cluster Development and Deployment

DBA Consultant

Confidential, Pompano Beach, Fl

Responsibilities:

• SQL Server Extracts and Excel Reports
• SQL Server Email Campaign Tool Development using C#
• SQL Server DBA all Local and Production Servers
• SQL Server Performance Tuning
• Migration Project from Asp.Net to Go Daddy

SQL Developer Crystal Reports

Confidential, GA

Responsibilities:

• Dynamic Dashboard Solutions ( CRM, HCRM and ERP)
• Data Hygiene methods and Development 1+ TB DB
• Crystal Reports Adhoc Developer
• OLAP Development
• MS Access to SQL Server Development
• PHP and MySQL Development
• SSRS conversion Project for existing Reporting Methods
• Custom ETL (SSIS and .Net Framework) existing data streams to SQL server
• SQL Dev Database Set up and Maintenance
• Oracle 10g DB PL/SQL, Forms and Reports Developer
• SQL Procedures for existing ETL and Crystal Reporting
• SSIS Programming Enhancements Data Migration.
• DBA Production services for over 5 SQL Server Clustered Databases (Reports and Migration process from Dev to Prod)
• SQL Programming (T-SQL,PL/SQL,SQL98) Data Normalization
• Senior Data Analyst in Data Hygiene
• Build Data insertion and Update procedures using T-SQL
• Reports programming and conversion (Reports programming using Crystal Reports CR10,XI and BO using: sql command, Stored Procedures, Distributed tables, Clustered data cubes)
• DDL and DML programming
• HTML, DOM and CSS thru Dreamweaver MX.

Crystal Reports Developer

Confidential, Phila., PA

Responsibilities:

• CR XI Reporting project to convert several Reports to new DB objects.
• Data Hygiene for existing Data cleansing and massage on 1 + TB DB
• OLAP Development
• DDL and DML programming
• SSRS conversion Project for existing CR
• SQL Server Stored Procedures Developer for CR implemeting Marketing Spreadsheets and Alumni Donations Reports
• Oracle 10g dev environment setup ( Views, Packages, Procedures)
• Help Desk Support (Report Solutions)

Crystal Reports Developer

Confidential, Princeton, NJ

Responsibilities:

• Data Hygiene methods and Development 1+ TB DB
• Field Force Specific Crystal Reports Deployment Effort to build a dynamic multi-layer Sales Force Penetration report with built in user security and Rollup design.
• Develop Correlated Sale force Data Model with Regional Rollup
• OLAP Development
• DDL and DML programming
• Oracle 10g dev environment setup

Data Analyst Developer

Confidential, PA

Responsibilities:

• Data Hygiene methods and Development 1+ TB DB
• Custom ETL DB2 WinRisk DB to SQL server 2005
• OLAP Development
• SQL 2005 Dev Database Set up and Maintenance
• SQL Hygiene Solutions Requirements for existing Actuate and Crystal Reporting
• Stored Procedure Development for Data Migration CDW (MoneyGuard Project)
• DBA Production services (Reports and Migration process from Dev to Prod)
• SQL2005 Programming (SQL Server 2005 Data Tables Standardization)
• Senior Data Analyst for LFD, CDW, and ESR
• SSRS conversion Project for existing CR
• Build Data insertion and Update procedures using T-SQL
• Reports programming and conversion (Reports programming using Crystal Reports CR10,XI and BO using: sql command, Stored Procedures, Distributed tables, Clustered data cubes)
• Correcting Commission Data Tables using DB2 links from SSIS procedures
• DDL and DML programming
• Create and Implement ETL Solution Data Stream MoneyGuard Feed Process using stored Procedures and C#
• .Net Programming for data stream automation

Crystal Reports Developer

Confidential, Long Beach, CA

Responsibilities:

• Reports programming and conversion (Reports programming using Crystal Reports CR10,XI and BO using: sql command, Stored Procedures, Distributed tables, Clustered data cubes)
• Normalizing Data Tables
• OLAP Development
• Create and Implement IDL data Stream
• .Net Programming for data stream automation

SQL Extracts and CR Reports Dev

Confidential, Long Beach, CA

Responsibilities:

• SQL Procedure Enhancements ETL Medical Insurance Data Migration
• Normalizing Data Tables
• OLAP Development
• Create and Implement IDL data Stream
• .Net Programming for data stream automation

Crystal Reports Developer

Confidential, Long Beach, CA

Responsibilities:

• Reports programming and conversion (Reports programming using Crystal Reports CR10,XI and BO using: sql command, Stored Procedures, Distributed tables, Clustered data cubes)
• Normalizing Data Tables and Data Hygiene
• OLAP Development
• Create and Implement IDL data Stream
• .Net Programming for data stream automation