Talented, Imaginative Senior Database Architect, Database Designer, and Database programmer with over 25 years' experience in Design, Architecture, Data Modeling, Optimization, and ETL processing

TECHNICAL SKILLS

• Operating Systems: Microsoft Windows version 3.1 Current , Microsoft Server version 2003 Current , Android 2.2 - 4.4.4, Ubuntu
• Database Management Systems: Microsoft SQL Server version 4.2 2014 , Sybase 4.2, 4.9 , MySQL
• Programming Languages: SQL, Transact-SQL TSQL , XML, JSON, C .Net, VB.Net, ASP.Net., C, UML, HTML
• Development Environment: SSIS, SSRS, SSAS, Visual Studi version 1.1 Current , Notepad . Team Foundation Server TFS
• CASE Tools: ERwin, Embarcader ER Studio, Visio
• ETL Tools: SSIS, C , Batch Files, PowerShell
• OLAP Tools: SSIS, SSRS, SSAS
• API/Frameworks: .Net framework, MDAC, REST, HTTP
• Office Software: Microsoft Office, IE, Chrome, Firefox
• Project Management Software: Microsoft Project
• Methodology: Dimensional Modeling, 3NF Model, Agile, RAD, Incremental and Iterative, Spiral, Waterfall

PROFESIONAL EXPERIENCE

Confidential

Senior Data Warehouse Architect

• Warehouse designer for totality of enterprise fixed income reference data
• Extensive use of Agile methodology and Dimensional Modeling approach
• Provided physical and logical data warehouse design using ERwin and Visio
• Designed and created fact tables
• Designed and created dimension tables
• Tested performance of implementation
• Created numerous Stored Procedures and functions
• Created dozens of synchronization triggers
• Created and maintained data warehouse metadata
• Created staging environment for metadata and temporary results
• Create ETL processes using SSIS, C , and PowerShell
• Generated SSRS strategy reports scatter plots, time series line graphs, trend line from data warehouse data

Senior Data Architect, Senior DBA, database programmer SSIS developer

Confidential

Assignments:

Senior Data Architect, Senior DBA, database programmer SSIS developer

Confidential

• Conceptualized and drove entire DTS t SSIS conversion process under a tight deadline
• Generated high level project plan
• Converted 200 legacy DTS/ETL packages running on SQL Server 2000 against an AS400 t ETL processes using SSIS 2008 under SQL Server 2008 R2
• Implemented numerous SQL, Stored Procedure, and ETL code enhancements increasing speed often over 1000x
• Replaced elaborate VBA conversion code with C reducing code surface area by 90 while increasing processing speed by over 50
• Implemented additional improvements in numerous batch files reducing code surface area by 75
• Enhanced security in ETL process
• Provided additional enhancements outside ETL t staff cleaning up Stored Procedures and SQL code eliminating deadlock and blocking contention
• Designed fact and dimension tables for future BI/Data Warehouse efforts

Senior DBA, Senior BI Architect, database programmer and architect

Confidential

• Re-designed OLTP database for proprietary online shopping cart using ERwin
• Created Stored Procedures and functions against new design
• Implemented Data Warehouse OLAP dimension and fact tables with Star schema design
• Implemented SSAS and SSIS functionality for Data Warehouse
• Implemented SSRS reports against Data Warehouse
• Vastly increased efficiency of numerous SQL Queries and stored procedures
• Implemented Solr faceted search for web creating import routines and procedures
• Reengineered C code for front end programmer's greatly increasing speed and minimizing code surface area
• Implementation was accomplished both on-site in China and via telecommuting.

Senior DBA, Senior database architect, database programmer

Confidential

• Created Project Plan t implement the following...
• Re-designed database moving entire set of tables some containing over 200,000,000 rows from Microsoft SQL Server 2005 t 2008 implementing TDE Transparent data encryption .
• Converted dozens of columns using column lever encryption
• Converted 100 Stored Procedures removing column level encryption and employing optimizations
• Provided all functionality while system was live absent any down time
• Used parallel triggers, replication, and Service Broker for data movement and synchronization
• Managed programmers in implementing front end code for increased speed and process transition

Database Architect, Website developer, Database Programmer, DBA

Confidential

• Created complete web site using PHP 5.3.x, MS SQL Server R2, jQuery 1.7, JavaScript, CSS3
• Used ERwin 7.2 for base SQL Server data design
• Implemented a number of REST interfaces using PHP, XML and JSON

Senior Database Architect, Senior DBA, Database Developer

Confidential

• Re-engineered and designed portions of database implemented in over 700 hospitals
• Increased Stored Procedure response times by 10 t 100 times
• Created Stored Procedures, functions, and triggers
• Created numerous XML shredding procedures with implementing XSDs as needed
• Solved numerous blocking and deadlock issues
• Implemented SSIS ETL t import client data

Database Architect, Database Developer, ASP Developer

Confidential

• Senior Database Engineer developing portions of inventory control system
• Developed numerous Stored Procedures, triggers, and UDFs
• Created data access ASP code

Senior Database Architect, Database Developer

Confidential

• Created OLTP and OLAP data model using ERwin
• Created database schema s s and packaged for field distribution and update
• Created Stored Procedures, triggers, and UDFs
• Increased speed of data access on average between 10 and 100 times
• Developed client side coding in Visual Studio, C for database access
• Senior Database Architect, Database Developer

Confidential

• Created entire OLTP data model for medical claims administration database
• Create numerous Stored Procedures, triggers, and UDFs
• Developed client side C coding using Visual Studi for database access
• Database designer, C Programmer

Confidential

• Created C code for scanning application
• Developed numerous Stored Procedures, triggers, and UDFs t save scanned documents
• Developed client side coding for database access

PROFESIONAL EMPLOYEE EXPERIENCE

Programmer

Confidential

Both part of a larger team and sole developer on several smaller projects. Skillset Used on the larger project was C under Windows 3.1 and Sybase 4.2/4.9.1 under UNIX. The smaller projects required use of Visual Basic 2.0/3.0 utilizing ODBC 1.0 SDK int Sybase.

Programmer

Confidential

Programmer on large team using C, C-Scape, and Clipper in support of ON CALL AIR.