Objective

Effectively use my communications, analytical and technical skills in the determination, development, implementation and support of cost-effective, quality solutions to Business Requirements.

Professional Summary

• A Senior IT Developer and Consultant with more than 20 years of SQL Server and ORACLE related data modeling, logical and physical design, development and implementation experience.
• Subject Matter Experience includes: Healthcare, Healthcare Insurance, Central Banking,
• Mental Healthcare, IT Management, and University Continuing Education Administration.
• Primary Roles include: Senior Database Developer, Data Integrator, Data Warehouse
• Developer, Business Intelligence Developer and Database Administrator.

Technical Experience:

Databases Operating Systems

• Microsoft SQL Server Windows Server
• ORACLE UNIX ksh
• DB/2

Languages and Utilities C.A.S.E. Tools

• Transact-SQL ERWin
• SSIS, SSAS, SSRS, EXCEL System Architect
• Replication / Log-shipping
• SQL Plus
• .Net VB

Professional Experience

• Database Developer Consultant Confidential Holly Hill FL
• Designed, prototyped and tested Claims, Accumulator, Eligibility, Groups, Prescriber and Patient Allergies Extract, Audit, Loads to support Customer's Insurance and Pharmacy functions.
• Developed and implemented SSIS Packages, SQL Server Agent Jobs and T-SQL processes to Extract, Transform, Audit/Cleanse identify/correct data issues and Load to destination.
• Environment: Windows XP/Windows Server 2008 Microsoft SQL Server 2008, Transact-SQL, SSIS, VB.Net.
• Confidential
• Designed, prototyped and tested Project/Portfolio Administration System to support Customer's Resource Management staffing and labor etc. Requirements.
• Developed and implemented Data Mart.
• Designed and Developed SSAS Cubes.
• Developed OLAP Reports to convey key performance metrics.
• Environment: Windows 7 Microsoft SQL Server 2008, Transact-SQL, SSAS, SSRS, MDX, EXCEL 2007.

Associate/Senior Technical Consultant

• Developed Data Warehouse and Data Mart star-schema modeled databases.
• Defined and implemented Physical File allocation Physical DB Design , Partitioned Tables, Clustered Indexing schemes.
• Performed data-mapping.
• Developed and integrated Data Warehouse and Data Marts to enhance and support WebCEO TM Product WebCEO TM based Data-PlanetTM subscription service which covers a variety of Subjects.
• Independent Contractor
• Environment: Windows 2003 Server Microsoft SQL Server 2005 and 2008, Log Shipping, Transact-SQL DDL, Stored Procedures, Functions Views , SSIS, SSAS, SSRS, MDX
• Provided on-going support including Database Tuning.
• Developed OLTP and OLAP Reports to convey key Customer performance metrics.
• Designed and Developed and implement SSAS Cubes.
• Developed and implemented Data Marts, SSIS Packages and T-SQL processes.
• Identified and produced Data Migration plans and specifications.
• flow latency.
• Developed, and optimized existing, Transact-SQL Queries to minimize information
• Developed and integrated Data Marts, Cubes and Dashboards for Customer's Hospital Business Intelligence requirements as they pertain to Throughput, Quality and Finance. Provided database administration assistance and development for the database components of the OLTP Applications.
• Database Engineer/BI Specialist
• Environment: Windows XP Microsoft SQL Server 2005, Transact-SQL DDL, Stored Procedures, Functions Views , SSIS, SSAS, SSRS, MDX, EXCEL 2007.
• Designed and Developed SSAS Cubes OLTP and OLAP Reports to convey key performance metrics and alerts.
• Developed and implemented Data Marts, SSIS Packages and T-SQL processes.
• Identified Data Migration plans and specifications.
• Designed, prototyped and tested quantitative Forecasting Methods to support Customer's Resource Management staffing and labor, material, supply etc. Requirements.
• Developed and implemented DTS and SSIS Packages and design parameters based

DTS ETL Pragma.

• Implemented Replication of staged Data Mart based data stores.
• Carried out Performance Tuning methods using SQL Profiler Trace and Performance Monitor.
• Consulted and/or implemented Maintenance Plans, Backup and Recovery Strategies, Clustering, Load-Balancing, Fail-over and Disaster Recovery.

Environment: Windows 2003 Server Microsoft SQL Server 2000/2005, DTS, SSIS

Consultant

• Developed Functional Technical Specifications and perform data-mapping.
• Developed and implemented Data Marts to facilitate the Practices' Financial Management Reporting across heterogeneous data sources.
• Developed Data Warehouse and Data Mart star-schema modeled databases.
• Implemented Partitioned Views.
• Developed and implemented DTS ETL including design parameters based Pragma.
• Developed and implemented Maintenance Plans.

Environment: Windows 2003 Server Microsoft SQL Server 2000/2005, DTS

Contractor

• Implemented encryption strategies securing Department of Health Mental Hygiene Program IHII data.
• Implemented. encryption of SQL Server Databases Windows 2003 Server Encrypting File System EFS .
• Implemented encrypted database backups and related recovery plans.
• Developed and implemented Maintenance Plans.

Environment: Windows 2003 Server Microsoft SQL Server 2000 2005, VB .Net

Contractor

• Developed and implemented T-SQL and Data Transform Services DTS components.
• Developed and implemented diagnostics packages.
• Integrated Office of Continuing Education and Conferences OCEC purchased package Plexus - Continuity 2000 TM with the University's central Financial Systems to provide OCEC Accounts information and leverage Continuity 2000 TM functionality.
• Developed and implemented Microsoft Access VBA user interfaces and functionality.

Environment: Windows 2000 Server/XP Microsoft SQL Server 2000, DTS

DBA/Staff Consultant

Developed, implemented and supported production of reports, processes and data transfers from internal and external systems for IT Assets hardware and software and IT Project Administration. Reduced administration of time, labor and other costs, as they pertain to programs, projects and plans and improve asset utilization and accountability.

• Developed and implemented the Database, Transact-SQL and Data Transform Services components of the IT Project Administration and Assets system.
• Developed Functional Technical Specifications and perform data-mapping.
• Implemented Business Process specific security.
• Performed Query Tuning and Database Maintenance.
• Upgraded existing SQL Server 7.0 databases to SQL Server 2000.

Environment: Windows NT/XP Microsoft SQL Server 7.0 2000

DBA/Staff Consultant

• Designed and implemented the Database, Transact-SQL and Data Transform Services components.
• Designed, developed and implemented the database components of a Coordination of Benefits system to reduce cost of claims processing.
• Created initial load processes using Data Transform Services and Bulk Load procedures.
• Implemented Business Process specific security.
• Carried out Performance Tuning methods.

Environment: Windows NT, Microsoft SQL Server 7.0

DBA

Provided Database Administration and Development of the Prepaid Calling Card TM System's functional aspects of the cards, including managing production scheduling and execution, tracking customer accounts, balances and usage, providing essential details for new product offerings and generating management reports. Increased the processing capacity of the system from 10 million to 40 million cards while maintaining responsiveness and reliability.

• Resolved locking, blocked processes, contention issues.
• Implemented replication and partition options dual-master sites .
• Developed and supported the Databases, PL/SQL, C and UNIX Shell components for several upgrades and expansions of the AT T Prepaid Calling Card TM
• Carried out Performance Tuning methods.
• Planned, implemented and supported backup and recovery processes.
• Designed and implemented PL/SQL Stored Procedures and Functions.

Environment: UNIX ORACLE v6 - v8.1, C