SUMMARY:

• Senior Database Architect with over 23 years experience with Database Administration, Data Modeling and Database Architecture and 16 years under SQL Server 4.21 - 2014.
• Managed nearly 75 transactional SQL Server databases under Windows 2003 to Windows 2012 R2 ranging from 25 to 200 Terabytes in support of application development done via Visual Basic, ASP, XML, and .Net/C#. SQL Server DBA experience includes extensive database design via Erwin 4.0, index and plan analysis, transaction management, stored procedure debugging, SQL development, operation and optimization, performance tuning, development of back up/recovery strategies, and database security.
• Additional experience with Oracle 7x/8i/9i/10g, 11g, 12c Database Architecture, Administration and development.
• Created MDM process to unify and structure across multiple departments within 2 large government agencies and private companies
• Communication skills appropriate for customer/user liaison.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Enterprise Database Architect

Responsibilities:

• Database Architecture Technical Lead responsibilities include requirements gatherings involving all internal warehouse design and customer interface meetings involving enterprise data warehouse.
• Created data conceptual, logical and physical database models based on user requirements using Erwin. The conceptual and logical models where based on business processes established from the business requirements. The physical data models created in 3rd normal form with parent/child entity relationships. Also created an additional set of user consuming reporting tables to use as the basis for enterprise warehouse reporting.
• Create and tested data definition language scripts created from the physical data model with the warehouse and reporting environments. These database scripts written in PL/SQL, (Oracle Version 12c), are used to create entities/attributes used in the warehouse and reporting environments.
• Manage data structures, performance management and tuning - Developed capacity planning for current and future database objects and created performance explain plans to tune PL/SQL queries with the warehouse and reporting environments.
• Develop Extract, Transform and Load (ETL) processes for new ingesting into data warehouse using Oracle Enterprise metadata manager.

Database Architect

Confidential

Responsibilities:

• Designed the implementation upgrade schedule to upgrade SQL Server 2005/2008 servers to SQL Server 2014 to support the Enterprise Data warehouse project
• Created database architecture for SQL Server 2014/2016 with High Availability groups for geo cluster to host SharePoint 2013 infrastructure.
• Created Logical and Physical design using Erwin for agency wide Datawarehouse for multi-agency Human Resources BI project using Oracle 12 and SQL Server 2014/2016, SSIS, SSRS, SharePoint and PowerBI. Identified all data sources and the processes to extract, clean, validate and integrate the data into the new warehouse .Designed and implement the process of continuously updating the databases and maintaining the quality of the data at all times.
• Technical Development Team lead across multiple development efforts using agile methodology.
• Develop data standards and date governance processes used for all HR Business processes.

Database Engineer Technical Team Lead

Confidential

Responsibilities:

• Created Logical and Physical design for Transactional and Datawarehouse Data Models using ERWin.
• Developing Metadata standards and structures for Confidential to define relate data for all Business Workflow Development using Confidential data standards guideline.
• Migration of specific HR and financial application into SQL Server 2012 and custom applications.
• Upgrade of SharePoint Database 2007 to SharePoint 2013. Create functional specifications and technical design specifications.
• Assist in the development of new resources and provide technical leadership to the team.
• Development and deployment of solutions (applications, reports, tools, training) based on management and customer demand.
• Test, debug and design enhancements to existing applications. Created custom reports for High Availability using SSIS from multiple data sources and SSRS to create custom reports.

ETL Developer

Confidential

Responsibilities:

• Assist in the development of new resources and provide technical leadership to the team .
• Creating star schema data models, performing ETLs using SSIS, SSRS and validating results with business representatives.
• Supported and implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Created processed to integrate with Microsoft Dynamics to migrate data from current systems.
• Collaborate with customers to define functional and technical requirements (design, workflow, layout).

Database Technical Team Lead

Confidential

Responsibilities:

• Upgraded and consolidated SQL Server 2008 R2 databases to SQL Server 2012 to private clouds using virtualization.
• Developed the security and configuration STIG architecture for SQL Server 2012 database servers with the private cloud.
• Created the COOP architecture using Database mirroring and High Availability groups to enable High Availability for databases at offsite locations.
• Created the SQL Server System health check using SQL Server Reporting Services and SQL Server Integration services to report on the status of individual databases.
• Created the SharePoint High availability architecture to replicate data between primary and secondary sites for content database.

SQL Server Technical Team Lead/Executive Office of President

Confidential

Responsibilities:

• SQL Server Technical Team Lead using SSIS to developed new transformation processes from SQL Server (2000, 2005 2008 R2, SQL Server 2012) and Oracle 11g.
• Developed SSIS standards to create XML Configurations and package logging for entire Federal Government Agency.
• Create functional specifications and technical design specifications.
• Migrated for multiple applications database from from SQL Server 2000 and 2008 R2 to SQL Server 2012. Performed SQL Server database optimization across various databases.
• Created SQL Server database architecture standards for backend development.
• Installed multiple SQL Server High Availability clusters in various locations and created the database mirroring architecture to allow database failover between primary and secondary sites.
• Development team lead to convert Crystal Reports reports to SQL Server Reporting services.
• Upgrade multiple SQL Server databases to MongoDB.
• Developed ETL processes using PL/SQL to transform data from additional external sources.
• Developed and designed custom databases schemas for transactional and data warehouse applications using Erwin.
• Created PL/SQL views to allow access to secure data for specific client audiences.
• Provided SQL Server database support (2008,2012) for clustering installations and performance monitoring.
• Upgrading and migrated multiple Oracle 11g databases to MongoDB V2.4.
• Created the MongoDB server architecture for ASI virtual applications.
• Keep abreast of current technology and industry trends and by reviewing industry related periodicals and attending seminars and related training.
• Attend software vendor conferences focusing on further technology and business improvements

Confidential

Data Architect

Responsibilities:

• Created new data models(Transactional) for Java web based application and Enterprise Datawarehouse using Erwin.
• Developing database standards (for security, encryption and naming conventions).
• Developing ETL process using SSIS to move data from (Oracle and DB2) the External systems to Internal systems.
• Installed SQL Server 2008 R2 in clustered environment and migrated SQL Server 2005 databases to the new database instance.
• Created the security process used to secure data in the new instance of SQL Server 2008 R2.

Confidential

Data Architect

Responsibilities:

• Created Logical and Physical design for Transactional and Datawarehouse Data Models using ERWin.
• Developed Metadata standards and structures for Confidential to define relate data for all Business Workflow Development using Federal Provision.
• Developed ETL processes to transforms data from 30 data sources into a consolidated Production environment using SSIS and SQL Server 2005/2008.
• Developed SQL (base views and stored procedures) for Reports using Cognos 8.3. and 8.4 to pull data from multiple sources data sources (Oracleand DB2).
• Created internal policies and associated security structures to protect data from non classified personnel.
• Created MDM based structures across Customs and Border Protection to support 100,000 employees.
• Installed, administered and configured Sharepoint 2007/2010 servers for document management.
• Developed datawarehouse used for reporting projected project time and estimates.
• Upgraded SQL Server 2005 databases to SQL Server 2008 databases.

Confidential

Data Architect

Responsibilities:

• Upgrading SQL Server 2000 databases to SQL Server 2008.
• Developing standards and processes for sql coding. Database Performance tuning and monitoring SQL Server databases.
• Upgraded SQL Server Reporting services r3eports from SQL Server 2005 to SQL Server 2008i.
• ER Data Modeler for Transactional (OLTP) and Data Warehousing system for internal and external business systems for SQL Server 2000, 2005, 2008 and Oracle 10g. Integrated variable, fixed/life insurance policies and associated information for various sales channels into new common data repository database.
• Developed custom report using SQL Server Reporting Services for internal financial systems. Developed (ETL) using SSIS for sales distribution information into Salesforce.com.
• Created partitioning strategies for large tables and archived data. Performance Tuning and Optimization for SQL Server 2005 operational systems.
• Established/enforced the Enterprise information architecture and the data components of a Systems Development Lifecycle e.g.
• Documenting external interfaces, Data flow diagrams, Business process and enterprise modeling/mapping artifacts to a data architecture framework for Enterprise Data Management purposes.
• Keep abreast of current technology and industry trends and by reviewing industry related periodicals and attending seminars and related training.
• Attend software vendor conferences focusing on further technology and business improvements. Test, debug and design enhancements to existing applications.

Confidential

Project Manager/Data Architect

Responsibilities:

• Project Manager responsibilities included set timelines for application developer disseminating project information to all stakeholders, defining and collecting metrics for project progression and managing the overall schedule to ensure work is assigned and completed in time and within budget.
• Data Architect responsibilities included data modeling of Grants database to replace the manual process of awarding grants and financial tracking.
• Extract, Transform and Load of internal Excel files into the new Grants database.

Confidential

Managing Partner

Responsibilities:

• Providing data Integration services to transform web analysis data using SSIS. Set up SQL Server 2005 Mirroring and migrating SQL Server 2005 production environments to
• SQL Server Active/Passive Cluster.
• Develop SQL Server stored procedures for transaction database and provide performance tuning for application performance issues.

Confidential

SQL Server 2005 Data Warehouse Architect/Developer

Responsibilities:

• developed ETL process using SQL Server Integration Services to create Datawarehouse for integrated claims system.
• Created SQL Server Analysis cubes for claims system.
• SQL Server DBA administration for SQL Server 2005 servers running Enterprise Edition of SQL Server and Analysis Services

Confidential

Senior SQL Server DBA\Database Manager

Responsibilities:

• Managed 1 SQL Server DBA, 1 Oracle DBA and 1 Oracle consultant DBA.
• Created schedules and set policies and procedures for Enterprise wide internal and external applications.
• Reponsible for backup and recovery procedures along with database 24X7 SLA.
• Created internal SOX compliance auditing for all internal database systems.
• Developed Data Architecture strategies to support multiple external web sites and internal system.
• Designed and installed SQL Server 2005 clustered environment using Microsoft Clustering Services.
• Developed XML based processes to improve workflow between multiple external data sources and internal systems.
• SQL Server 2000/2005 Administrator for multiple external web sites and internal application development of back office fulfillment systems. (including Great Plains accounting system.) developed via Visual Basic, ASP and .Net, XML, and .Net C#.
• Manage nearly 100 SQL Server databases under Windows 2000/2003 ranging from 25 GB to 5TB on EMC SAN s. Database include OLTP processing systems and Data Warehouse Analytical systems.
• SQL Server experience includes extensive database design via Erwin 4.0, index and plan analysis, transaction managementstored procedure debugging, SQL development, operation and optimization, performance tuning, development of backup/recovery strategiesand database security.

Confidential

TECHNICAL DIRECTOR

Responsibilities:

• Develop internal Enterprise wide reporting architecture using Business Objects 2000.
• Create and develop revenue stream for Hitachi using Business Objects 2000.
• Demonstrate Hitachi s wireless Business Intelligence knowledge at various Data Warehouse Conferences.
• Accompany Hitachi s sales executive on various opportunity to serve as the Data Warehouse/ Business Intelligence technical liaison.