SUMMARY:

• A systems and cloud architecture datawarehouse and database specialist enterprise.
• Architect, configured, and implemented (IaaS/SaaS/DBaaS) from ground to Cloud on MS Azure / Amazon Web Services (AWS) / Google Cloud Platform (GCP).
• Designed and implemented Data Warehouse by using SQL Server 2008R2(BIDS) / 2014 (SSDT) to design, process and control all SSIS / ETL packages cleansing and enhancing metadata before build SSAS (KPI, MDX for OLAP, CUBE) via STAR / SNOW FLAKE schemas.
• Processed and deployed all reports to server (Dashboard) by using SSRS, PowerBI, Tableau 9 - 10.
• Implemented, managed, and monitored over 29 databases (Oracle 9-12, SAP HANA, SQL 2005-2014) for daily backup / performance (Indexes, Locks, Triggers, Job Schedules)
• Coordinated and built a project team with Project manager. Gathering and iterating information from users and business rules to architect, design, and build database from scratch to QA to delivery product using ITIL, Scrum, Spiral, Agile methodologies.

TECHNICAL SKILLS:

Application Tools: Tableau 9 - 10, PowerBI, Allegro, SQL Business Intelligent IS / AS / RS.

Systems / Cloud: UNIX / Linux, Windows OS, Amazon Web Services (AWS), Microsoft Azure.

Database: MS SQL 2008 - 2016, Oracle 8-12C, RDS, Azure SQL, SAP Hana.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Responsibilities:

• Architect and implemented migration local/VM database servers (Oracle, SAP, SQL Server) to cloud (Amazon Web Services-AWS, Azure Cloud, and Google Cloud Platform-GCP) for TCO vs ROI, Managed, implemented, and analyzed monitor tools (CloudWatch, StackDriver,Azure Portal) databases and datawarehouse and commercial trade (SaaS and DaaS) Cloud proof of concepts.
• Supported and troubleshot Allegro application performance for Confidential Trading / Commercial team on daily, weekly, and monthly processes. Built dashboard database performance reports for Confidential Power Plant data pipelines and monitoring site plant managers. Implemented, upgraded, and deployed all Trending and Forecast Tableau v9 to v10 from Stage to Production.
• Implemented data pipelines (IoT) for Confidential Trading and Commercial teams using GPC Big Data tools: Pub/Sub (Topic/Subsciption), DataProc using Spark/Hadoop (job, worker node), DataFlow (ETL), Genomic (pattern, variants, callsets), BigQuery, and Cloud Storage.
• Managed and maintained daily, weekly, and monthly processes of all databases and Datawarehouses for Champion Energy Enterprise (SQL 2012-2014) on SQL Transaction Log Shipping and Servers Clustering.

Confidential, Houston, TX

BI / DBA

Responsibilities:

• Upgraded and managed Spark Energy databases from SQL 2008R2 to 2012 for daily tasks performance (backups/load/indexes, and diskspace), troubleshot and resolved any long queries, lock/.block transactions. Architect and assisted Business Intelligent team to design ETL(SSIS), partition table indexes (Columnstores), load OLAP(SSAS), and dashboard (SSRS) for Spark Energy Datawarehouse Enterprise. Installed, supported, and implemented Allegro for Trading team on daily, and monthly processes.

Confidential, Houston, TX

BI / DBA Consultant

Responsibilities:

• Supported Confidential, DG GIS-IPS team to resolve issues and tracking errors on Application production NetEnum Scanning, ACL Revocation, Instinct / ADAPTS via Trigger/SP/Alert Loading SSIS.
• Created SSIS / SSRS package migrated from DEV-to-UAT-to-Prod SQL Server 2008R2 - 2014 DB stage for release and migration packages via BIDS & Infomatica.
• Monitored and managed all daily / weekly maintenance plans such as Reorg/Rebuild index, primary / foreign keys, Backup/Restore AlwaysOn for Microsoft SQL 2014 via SQL Jobs and Poweshell scripts..
• Coordinated with Comelectric and implemented migration and conversion Wachovia banking system to Confidential Enterprise system via SharePoint, Windows 2008 Servers, and Workstation.
• Built and deployed all SSIS (DTS/ETL), SSAS, SSRS packages conditional scope, optimizing, and maintained performance via Execute Package Tasks to stage CUBE, MDX, and Report Server.
• Prepared and deployed all ETL/DTS via MSDS-SSIS and building OLAP, Cube, Data Mining, and metadata via MSDS-SSAS, MOSS and SSRS post reports and Data Mart trend over SharePoint for GE Gas and Petroleum Department.

Confidential, Ashburn, VA

Sr. System Engineer

Responsibilities:

• Redesigned Inventory database, created MDX (Multi-Dimension Expression) and KPI (Key Performance Indicator) report network hits per pledge marathon, and deployed all trends WAN/LAN traffic for SOS BP computer shop per disaster incident. Coded and deployed several C# and VBScript functions embedded within SSIS and SSAS to improve data retrieval and performance based on Resource Governor (SQL 2008 new features), SQL Profiler, Data Tuning Advisor (SQL 2005 & 2008 features).
• Implemented and managed Nightly / Weekly / Monthly Maintenance Plans, Maintenance Plans via SSMS and SSIS (DTS/ETL) and SQL Agent such as Reorganize Indexes, Rebuild Indexes, Full Backup, and FileGroup Backup for FDIC as systems as Subscriber servers from WorldBank and IMF as Publisher.
• Used SSMS, Performance Tools, and Database Advisor to troubleshoot, optimize, and monitore all application T-SQL poor performance via SQL Profiler to build trace files, and Tuning Index per Database Tuning Advisor or Partition Views & Filegroups to improve Indexes performance (SQL 2005 features).
• Designed and managed all matrix reports and charts the minimum ROI for Cavalry Energy Industry about alternate energy initialize investment versus grant from government via SSAS, SSRS, and Data Mining tools (DMX) via Log Shipping Servers (Datawarehouse) versus Replication (OTLP).
• Collected and analyzed data via SSMS and BI Report Services (SSRS) tools at Sales Department. Reported and Accredited according from NASD to FDIC. Cleaned and cleansed data from DS formats compound on DOD Coast Guard/National Guard MOA with DC Government to produce Policy Management, Stores Procedures, and procurement levels.
• Administered and managed all ETL (Extract-Load-Transform) 27 DB2 and Oracle instances from DOJ - Civilian Division - to CERT Division from to MS SQL DTS (SQL 2000) and Erwin to rebuild Data Structure as Snow Flake Schema. Monitored and performed Oracle daily/weekly/monthly tasks for DTS/ETL(SQL 2000 features), and MOSS Financial and Accounting Data Warehouse. Troubleshoot, assisted, and supported front-end users with any connectivity to Business Object and Cognos via SSL-Client VPN (Cisco firewall, Oracle client, LDAP, Oracle 9i).

Confidential, Ashburn, VA

Architecture Engineer

Responsibilities:

• Architecture and controlled database and applications for UNCF, Gates Millennium Scholarship, Federal Program, and Fund Raising Program. Implemented store procedures, triggers, and policies for all logging files database within DMZ, transactions, and CheckPoint 4.1.
• Defined and built PKI security keys for Certificate Authority Server and VeriSign Certificate Authority for several database servers Business To Consumers by using DCOM interface with Signio, and Business To Business with IBM Direct-web E-Commerce, edu.com by MS Data warehouse.
• Developed Primary/Secondary Replication MS SQL 2000 Database warehouses to central Data Mart system (DTS, Cognos, T-SQL, SQL Server 7.0/2000, and FrontPage 2000) via Star Schema Models for MCI- Confidential Small Business Customer Billing.
• Architecture and managed all stages from DTS(ETL) to OLAP and MOLAP to ROLAP partition storage dimension. Designed and maintained CUBE data versus Star Dimensions and Measures status of DSV and DBF.

Confidential, Rockville, MD

Database Programmer

Responsibilities:

• Converted all Windows DOS batch processes and implemented to Perl, C, Korn shell scripts onto HP Openview to monitor database status, UNIX servers, and e-mail / pager alert immediately surveying status processes varies database from different applications platforms (Sun Solaris, HP UX, AIX) for GE Network Operation Center (NOC).
• Monitored and performed batch processes for GE Internetworking Operation Servers Farm such as Informix snapshot, Oracle temp segments for sort extent pool, and Sybase database server).
• Migrated GE-NIM and Informix database from AIX 3.2 to HP UX 11.2 platform coordinated Oracle 6.0.
• Consolidated and managed migration processes of three databases for DII COE project (Sybase to Informix 7.1, Oracle 6.0 to Informix 7.1). Set up test scenarios and test cases based on Department of Army SOW and requirements per migration stage such as Develop, QA, and Production stage.
• Prepared, installed, configured, and documented all procedures and parameters of Informix 7.1 instance database servers on SUN Solaris Netra/E450 servers.