SUMMARY:

• Database Analysis, Architecture, Design, Development, Engineering and Administration.
• Database optimization and performance tuning.
• Database and data conversion and migration.
• Data Architecture, conversion and ETL mapping from source to target.
• System Development Life Cycle.
• Strong problem solving and analytical skills.
• Strong written and verbal communication skills.
• Experience in regulated industries (i.e. health, medical and financial).
• Experience with Microsoft products/tools.

TECHNICAL EXPERIENCE:

Operating Systems: Windows Server (x64) Hyper - V server version 2012 R2 Windows Server (x64) 2012 R2, 2012, 2008 R2 Windows workstation (x64) version 10, 8.1, 8, 7 SUN Solaris 8.0, 7.0, Linux

Language/Applications: Microsoft SQL Server Enterprise (x64) versions 2016, 2014, 2012 R2, 2008 R2, 2005, 2000, 7.0/6.5 Microsoft Aure. Microsoft Windows Server Failover Clustering (WSFC) Microsoft SQL Server Always On Availability Groups (2016, 2014) Microsoft SQL Server Reporting Service (SSRS) Microsoft SQL Server Analysis Service (SSAS) Microsoft SQL Server Integration Service (SSIS) Microsoft SQL Server Service Broker (SSSB) Microsoft Transact - SQL (T-SQL) Oracle SQL database version 11.2c, 10.x, 9.x, 8.3 Oracle PL/SQL TOAD Sybase SQL Server 12.5 Microsoft Visual Studio 2015, 2013 and 2012Microsoft Access 2012, 2010, 2007

Methodologies: OLTP, OLAP and Data Warehouse database design, Reporting System, Cluster Services ANSI SQL 99, 92, 89 System Development Life cycle (SDLC) System Analysis and Design (SSADM) Object Oriented Analysis and Design (OOA, OOD) Web and Client Server Designs Entity Relationship Design (ERD) IDEF1X (Erwin ERX and ER Studio) CASE Tools Logical and physical data modeling XML Local Area Networks (LAN) and wireless (Wi - Fi) designs

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect, DBA, Developer, Data Analyst

Responsibilities:

• Perform analysis and requirement for database upgrade from server version 2005 and 2008 to version 2016
• Upgrade databases to version 2014
• Update and rewrite T-SQL stored procedures and views
• Optimized views and index for enhanced system performance
• Create new server security and upgrade data security procedures
• Convert DTS packages to SSIS packages
• Create new maintenance plans for proactive system monitoring
• Perform analysis and recommendation to convert reporting database to SSAS and migrate SSAS cubes from version 2008
• Perform database, data and system analysis and recommendation to combined multiples databases into a single version that can be migrated to the cloud based version Azure

Confidential

Database Architect, Data Analyst, Developer

Responsibilities:

• Conduct analysis of current database and system procedures
• Gather functional business specification requirements from business and developer
• Create new database architecture and design framework
• Translate functional business requirements into data design and technical specifications that adheres to the architectural framework
• Develop new logical and physical data model
• Develop supporting views and packages
• Analyze source to target data mapping

Confidential

Database Architect and Developer

Responsibilities:

• Performed analysis of the current system to in corporate performance enhancement upgrades
• Performed data profiling to isolate least performing queries
• Rewrite queries in Transact-SQL (T-SQL) and create new indexes

Confidential

Database Architect / Business Intelligence / Development

Responsibilities:

• Performed system assessment of the legacy ROC and VSM database to upgrade to a new system
• Performed data analysis and created logical and physical model for proposed new database schema
• Performed ETL migration from legacy system

Confidential

DBA / Developer

Responsibilities:

• Update the SSAS cubes (i.e. fact and dimension tables)
• Minor maintenance and updates to existing reports and SSIS ETL packages
• Performed server performance enhancements and updates
• Modified and enhanced Transact-SQL (T-SQL) stored procedures

Confidential

Database Architect / Business Intelligence / DBA

Responsibilities:

• Modified and upgraded the data mart conversion process from SQL Server 2008 on Windows 2003 server to SQL Server 2014 on Window 2012 R2
• Extract data from legacy version of JD Edwards for the ETL portion
• Resolved performance issues associated with high latency disk throughput in the VMWare environment as well slow data retrieval speed from JDE fields on the AS400
• Provided recommendation and programming examples for converting scripts to SSIS packages for data retrieval
• Reviewed the physical data schema of the SSAS DW schema and provide minor fixes and upgrade
• Modified and enhanced Transact-SQL (T-SQL) procedures

Confidential

Database Administrator

Responsibilities:

• Worked on the Product Life Cycle Management (PLM) project which involved the retirement and decommissioning of older version of databases and server
• Migrated data to ensure support to new version, since the Microsoft operating system version 2000 and 2003 was not able to be supported after July 2015
• Involved owner discovery and user request to determine which databases are candidates for this process

Confidential

Database Architect, DBA, Business Intelligence ArchitectData Analyst, Developer

Responsibilities:

• Redesigned the PharmGuard database server system for a high volume multi-server distributed environment
• Designed, created, and implemented the following:
• A data load procedures in Transact-SQL (T-SQL) for event transaction within a medical device (i.e. infusion pump)
• The logical and physical data model schema for the Transactional, Data Mart and Reporting version 1.0 and 1.1 and the Transactional Event Message system in version 2.0
• An Event Message ETL load procedure for the Transactional, Data Mart and DW databases
• A multi-server replication and synchronization device event messaging routine
• A table partitioning schema, data compression, messaging archival and off-line data storage routine
• An automatic database server system disaster recovery mechanism
• Performance enhancements, server health monitoring and server provisioning
• Designed and created programs (T-SQL) and routines for data migration from the previous database versions
• Designed and created a data warehouse system (OLAP) which is a consolidation of all versions of the PharmGuard release database from all client backups, as this system is used to analyze patterns and usage of various clinical metrics
• A SSIS ETL routine to transfer data to the hospital system (EMR)
• Converted and updated the database and applications from MS SQL Server 2005 in version 1.0 to version 2008 R2 environment for version 1.1. Test and validated Transact-SQL (T-SQL) scripts and Applications to works with the new environment
• Migrated to Windows Server 2012 and 2008 cluster services with Hyper-V
• Worked on the new database architecture version 2.0 which will in corporate globalization, multiple device type support, and larger data volume

Confidential

Database Developer

Responsibilities:

• Created and modified Report Services (SSRS ) reports and Analysis Services (SSAS) cubes
• Created (SSIS) ETL routine to load DW fact and dimension tables in the cubes
• Worked on performance enhancements and server troubleshooting
• Migrated to SQL Server 2008 from 2005 environment
• Tested and validated SQL scripts and application works with the new environment

Confidential

Database Architect, DBA

Responsibilities:

• Troubleshoot poor system performance and periodical database transaction locks that required rebooting the server
• Migrated the SQL Server 2005 production server that was operating at capacity to Windows 2003 server
• Tested and validated that replication, jobs and other application works with the new environment

Confidential

Data Architect, Developer

Responsibilities:

• Implemented and managed database backup and recovery strategies
• Responsible for the installation of new SQL Server database and upgrades
• Management of database and resource capacity planning
• Implemented and enhanced database security using proven methodologies
• Assisted development staff with the debugging and optimization of Transact-SQL (T-SQL) queries and stored procedures
• Mentored and assisted programmers in writing SQL code and DBA
• Performed ongoing database performance tuning and upgrades; including: monitoring and evaluation of all database patches and service packs
• Designed and managed database import/export processes used to populate test databases and global data marts
• Designed and managed database reports using Reporting Services
• Evaluated and tested SQL Server 2008 for upgrade of the current environment of SSIS and Report Services
• Member of the Architecture Review Board overseeing database designs

Confidential

Database Architect, Lead DBA

Responsibilities:

• Optimized system performance to comply with client’s SLA by analyzing several key areas of poorly performing applications in the system design
• Updated and enhanced the physical database schema
• Redesigned several major stored procedures create and modify indices and other general system fine tuning maintenance
• Drafted guidelines and recommendations on improving system performance
• Mentored and assisted programmers in writing SQL code and DBA

Confidential

Data Analyst, SQL Developer

Responsibilities:

• Applications: Microsoft SQL Server 2005
• Designed and created new NSC reporting database and SSIS report package based on student/learner’s data extracted from PeopleSoft ERP system
• Rewrote under-performing stored procedures (T-SQL), created, and modified indexes and other general system fine tuning maintenance
• Mentored and assisted programmers in writing SQL code and DBA on system maintenance/trouble-shooting

Confidential

Database Architect, DBA

Responsibilities:

• Maintained and enhanced performance of the NewRef system by modifying table structures, rewriting Transact-SQL (T-SQL) stored procedures and modifying indices
• Rewrote the ETL process to improve performance and reduce I/O load
• Converted NewRef database system from SQL 2000 to SQL2005 with full audit trail, recoverability and event logging
• Converted ETL system to a central SSIS ETL manager server
• Worked on Reporting Services to dashboard system event messages

Confidential

SQL Developer

Responsibilities:

• Created all reports for the JumpStart reporting system using SQL Server Reporting Services
• Created views and Transact-SQL (T-SQL) stored procedures to pull data from the Oracle 8.1, database
• Maintained and enhanced performance of system databases by modifying table structures, rewriting stored procedures and modifying indices
• Designed database and ER diagram for the new survey reporting system
• Migrated databases amongst the server environment
• Created maintenance plans and troubleshoot T-SQL scripts performing less TEMPthan optimal
• Provided and documented recommendations on the system and server designs, configurations and other system solutions
• Mentored junior DBA.

Confidential

Database Architect, DBA

Responsibilities:

• Server OS: Windows 2003
• Created and modified reports and built supporting SQL views for the accounting department
• Designed new ER diagram for the current system
• Rebuilt the data warehouse to improve performance and in corporate new features by modifying indices, Transact-SQL (T-SQL) stored procedures, and DTS ETL programs
• Created and modified cubes and dimensions in Analysis server and built supporting SQL views

Confidential

Database Architect

Responsibilities:

• Server OS: UNIX
• Reviewed and recommended changes to update and add tables in the data warehouse to in corporate new field requirements
• Revised Erwin diagrams and documented changes of the new version
• Developed Cognos reports for end-user validation

Confidential

Database Architect

Responsibilities:

• Server OS: Windows 2000
• Conducted reviews and troubleshoot of MS SQL Server database instances and Analysis Server OLAP cube loading that were experiencing poor performance.
• Scoped, traced, and analyzed network and SAN disk (EMC) configuration and activity
• Rewrote and rebuilt tables and indices, SQL application and queries, updated DTS routines for the OLAP cubes
• Performed updates and traced on OLAP partitions, cube optimization, memory allocation and tuning

Confidential

Database Architect/Access Developer

Responsibilities:

• Server OS: Windows 2003
• Designed and created the new DataCapture reporting system using an Access XP front-end and an SQL Server back-end
• Created de-normalized (2NF) summary tables with supporting stored procedures for reports and graphs. The reports will be ported to MS OLAP in the future
• Designed and created the data mart, including partitioned tables, stored procedures, views and DTS ETL scripts to load data from the CRS system on UNIX.

Confidential

Database Architect, SQL Developer

Responsibilities:

• Server OS: Windows 2000
• Redesigned and created the new client-server version of the ProjectGrid system using an Access XP front-end and an SQL Server back-end
• Designed and created all tables, Transact-SQL (T-SQL) stored procedures and views as well as a series of ETL scripts to port the old data from the old system written in Access 97
• Created this Access XP front-end application incorporates a master form (projects) and many other supporting forms and management reports which are exported into an Excel spreadsheet directly (The application will be used by 100 implementation project managers concurrently in 4-5 locations in the country.
• Server OS: Windows 2000
• Created and modified DTS scripts for ETL from legacy flat file systems
• Provided consultation on data mart design, performance tuning, index and cursors creation and Transact-SQL (T-SQL) stored procedures modification

Confidential

Database Architect, Data Analyst

Responsibilities:

• Server OS: Windows 2000, NT 4.0
• Designed and created the WSFX cross database to facilitate high volume transactions (50GB per month) between the Wennsoft and FieldCentrix systems for the $17M field automation system (FAST)
• Created triggers to mark records for transmission and load staging tables
• Designed and created procedures for:
• Created stored procedures to send and receive transaction between the systems
• Continuous database performance tuning
• System alerts and maintenance
• Preventing lost and duplicate transactions
• Disaster recovery and exception reports
• Designed and created complete transaction audit trail procedures in T-SQL to monitor all system activity, prevent data redundancy during retransmission, assist in disaster recovery of the system, and to ensure that processes are in place by applying strong levels of security in the sending, accessing, receiving, and storage of confidential data between local and remote systems
• Consulted with staff to resolve production problems in order to prevent and minimize the impact of unscheduled disruptions to production.
• Anticipate system performance problems, software and hardware errors and expedite resolutions in a timely manner
• Worked with management to develop functional and technical specifications for incorporating business processes. Created database schema and mapping in Visio for system documentation and