We provide IT Staff Augmentation Services!

Systems Engineer, Principal Resume

Reston, VA

SKILLS:

  • Dimensional Design
  • Kimball Design
  • SSAS Tabular
  • Table Partitioning
  • Powerview
  • PowerPivot
  • Stream Insight
  • ASP.NET
  • SSRS
  • SSIS
  • AJAX
  • CSS
  • HTML/XHTML
  • JavaScript
  • T - SQL
  • XML/XSL
  • SQL Server 6.5-2016
  • Oracle
  • MySQL
  • PostgreSQL
  • Windows 2003/2008 R2
  • Windows Vista/XP/7
  • Linux RedHat
  • ServiceNow
  • IIS
  • WebSphere MQ Series
  • Splunk

EXPERIENCE:

Systems Engineer, Principal

Confidential, Reston, VA

Responsibilities:

  • Developed and maintain a Business Intelligence data warehouse solution for an enterprise network using SSRS, SSIS and SQL Server 2008 R 2/2012/2016.
  • The warehouse is loaded in a nightly basis using Extract, Transform and Load (ETL) techniques and best practices for OLAP/OLTP databases
  • Use DMV’s and other performance tools to identify bottlenecks and performance problems.
  • Recommend and implement changes to improve database performance.
  • Developed reporting systems using SSRS with charts, KPI’s and data driven subscriptions.
  • Write complex queries using T - SQL and stored procedures.
  • Design database security models and lock down database with the latest security measures.
  • Responsible for the design, implementation and maintenance of self service business intelligence portals, client/internal dashboards and all associated reports, data feeds and implementing and maintaining reporting and business intelligence solutions to support the customer in a Splunk environment

Senior Database Analyst

Confidential, Reston, VA

Responsibilities:

  • Developed and maintain a Business Intelligence data warehouse solution for an enterprise network using SSRS, SSIS and SQL Server 2008 R2/2012.
  • The warehouse is loaded in a nightly basis using Extract, Transform and Load (ETL) techniques and best practices for OLAP/OLTP databases.
  • Use the Kimball method to design dimensional model and Kimball best practices.
  • Used DMV’s and other performance tools to identify bottlenecks and performance problems.
  • Recommend and implement changes to improve database performance.
  • Developed reporting systems using SSRS with charts, KPI’s and data driven subscriptions.
  • Write complex queries using T-SQL and stored procedures.
  • Design database security models and lock down database with the latest security measures.
  • Responsible for the design, implementation and maintenance of self service business intelligence portals, client/internal dashboards and all associated reports, data feeds and implementing and maintaining reporting and business intelligence solutions to support the customer in a Splunk environment.

Database Analyst

Confidential, Reston, VA

Responsibilities:

  • Support of a mission critical high availability system using Windows 2008 R2 active/passive cluster and SQL Server2008 R2 database.
  • Responsible for monitoring, tuning and general O&M and development of database application.
  • Implemented TDE for database security and compliance with PL3 security requirements.
  • Designed SQL Server 2012 solution using Availability Groups for HA in a Citrix environment.
  • Developed reporting system using SSRS and SSIS for the ETL of data sources.
  • Created SQL Server backup jobs to insure quick database and disaster recovery.
  • Expert at database tuning and identifying bottlenecks using performance metric tools and make recommendations for performance improvements. Set up a 5.5.28 MySQL database solution using semi-synchronous replication on a Linux RedHat 6.2 operating system for continuous failover capabilities.
  • Installed and configured self-hosting environment for ServiceNow software.
  • Customized the ServiceNow software to use LDAP and MySQL database backend.
  • Participate in development meeting using the agile development techniques.

Business Intelligence Consultant

Confidential, Reston, VA

Responsibilities:

  • Developed and maintain a Business Intelligence data warehouse solution for an enterprise network using SSRS, SSIS and SQL Server 2008 R2.
  • The warehouse is loaded in a nightly basis using Extract, Transform and Load (ETL) techniques and best practices for OLAP/OLTP databases.
  • Use the Kimball method to design dimensional model and Kimball best practices.
  • Used DMV’s and other performance tools to identify bottlenecks and performance problems.
  • Recommend and implement changes to improve database performance.
  • Developed reporting systems using SSRS with charts, KPI’s and data driven subscriptions.
  • Write complex queries using T-SQL and stored procedures.
  • Design database security models and lock down database with the latest security measures.

Database Developer/Technical Lead

Confidential, Chantilly, VA

Responsibilities:

  • Developed the physical design and implementation of the Nationwide Automated Identification System for the United States Coast Guard.
  • Assumed the Technical Lead role in the implementation of the Electronic Notice of Arrival/Departure (e-NOA/D) for the Department of Homeland Security.
  • Re-engineered a highly visible, enterprise-wide DHS multi-terabyte database capable of handling over 5000 inserts per second and 18TB is size.
  • Redesigned legacy production MS SQL Server applications, reducing down time by 80% and increasing performance by 45%.
  • Engineered multi-terabyte database using table partitioning and filegroups and piecemeal restores for disaster recovery and performance.
  • Utilized IBM Websphere 6.0 to create middleware between two DHS agencies for data sharing.
  • Developed Enterprise SOA architecture using Fiorano ESB.
  • Technologies include MS SQL Server 2000/2005/2008 , SQL Server Database Log Shipping, SQL Server Transactional Replication, SQL Server Reporting Services, SQL Server SSIS & DTS, T-SQL, SQL Query Analyzer, Windows 2003, Active Directory, IBM Websphere MQ version 6.0, Fiorano ESB and ASP.NET.

Hire Now