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.