SUMMARY:

• Over fifteen years experience in the Information Technology industry. Extensive systems and development experience in Business Intelligence, Analysis Services, Data Warehousing, Database Administration, Replication and High Availability Clustering environments.
• Responsible for a variety of large Business Intelligence and Data Warehousing projects, building SQL Server 2016/2014 Analysis/OLAP Services Tabular and Multidimensional Cubes for Data Analysis, creating complex SSIS/ETL (Extraction, Transformation, Loading) packages and designing large Data Warehouses using Star and Snowflake schemas; in addition to reports/analysis using Power Pivot, Power BI and SQL Server Reporting Services.
• Experienced with SQL Server 2016/2014 installation, configuration, development, performance & tuning, replication, security, encrypting/decrypting, backup and disaster recovery in high availability high performance SQL Server 2016/2014 always on availability clustered environments.

TECHNICAL SKILLS:

Key Words: Business Intelligence, Data Warehousing, Database Design(OLTP, OLAP), SQL Server Administration, SSAS 2016/2014 (SQL Server Analysis Services), SSIS 2016/2014 (SQL Server Integration Services), SSRS 2016/2014 (SQL Server Reporting Services), DQS 2016/2014 (Data Quality Service), Replication, High - Availability Clustering, Always On Availability, Full-Text, Backup & Recovery, Performance & Tuning XML, JSON, MDX, DAX Power Pivot, Power BI, C# .NET, VB .NET, ASP .NET, Power Shell, Web Forms, MVC, JQuery, Web Services.

PRESENT POSITION:

Confidential, Washington, DC

Senior Business Intelligence / Database Administrator

Responsibilities:

• Tasked with getting all SQL Servers secured per DS (Diplomatic Security) guidelines.
• Work entailed implementation of Confidential across all SQL Servers. Protecting database availability through Availability Groups on Windows Cluster.
• Created a script to encrypt and decrypt all SQL objects, in addition to partitioning the databases and wrote complex SSIS packages to cleanse and load data.
• Installed Analysis Services in tabular mode, and assisted several business analysts with analyzing the data by creating cubes and using Power Pivot & DAX to query the cubes.
• Also built several demo dashboard reports using Power BI to compare with Tableau reports.
• Responsible for automating / monitoring SQL jobs, backing/restoring databases. In addition to performance & tuning, optimization of databases, granting revoking permissions on database objects and troubleshooting failed jobs in addition to changing service passwords and Confidential key encrypted password files.

Confidential

Responsibilities:

• Upgraded the Confidential SQL Servers to SQL Server 2012 from SQL Server 2008R2.Wrote several SSIS ETL packages utilizing script component with C#; work involved loading different metric data such as Remedy data and other performance data.
• Work constituted understanding the business rules, normalizing tables and writing/designing complex SSIS packages to retrieve data from different sources XML ( Confidential data), SharePoint and excel files and cleaning the data using DQS.
• After which several reports were created in SSRS to display which contracts were meeting their metric requirements within DOS.
• Worked closely with the Strategic Source Licensing team to load all invoices for all licenses from 2005-present. Work involved understanding the invoicing process, cleansing the data, and reformatting it prior to moving the data to their final dim and fact tables.
• Work entailed developing custom ETL/SSIS, SSAS Cubes and SSRS Reports.
• Set up linked Servers, configured Kerberos between the Report Server and the Database Server; extracted data from active directory, in addition to verifying the integrity and security of the production environment.
• Deployed and scheduled SSIS packages in production, in addition to deploying reports to production and granting the necessary permissions to users to view the reports.

Commander, Washington, DC

Senior Business Intelligence / Database Administrator / Database & Report Developer Consultant

Responsibilities:

• Responsible for the Confidential installations funding requirements BI project. Work involved analyzing and estimating different funding levels to see which Confidential COL could be satisfied.
• This entails developing custom ETL/SSIS utilizing script component with C#, SSAS Cubes and SSRS Reports for BI Analytics to better forecast the effects of future funding for Confidential installations.
• Work encompasses architecture, design and implementation of ETL/SSIS, SSAS Cubes and SSRS Reports integrated with SharePoint for the Confidential BI project

Confidential, Fairfax, VA

Senior Business Intelligence / Database Administrator

Responsibilities:

• Wrote several SSIS ETL packages using SQL Server 2008 Business Intelligence Development Studio to load and perform analysis on Confidential (none performing loans), first look sampling, second look sampling in order to verify servicers are meeting the guidelines set by Treasury.
• Work involved writing complex SSIS packages for sampling, generating XML files and e-mailing package status in HTML.
• Worked on loading data into a staging area, prior to moving the data into an OLAP Fact and Dimension tables.
• Analysis Services (SSAS 2008) to build the cubes, and SQL Reporting Services (SSRS 2008) for reports.
• Designed several reports using SSRS and wrote complex MDX statements against the cubes to retrieve the data.
• Also administered Analysis Services, he made sure the incremental builds ran successfully, and the OLAP databases were backed up.

Confidential

Responsibilities:

• Responsible for the design &implementation of Confidential Management Access Control (MAC) reporting system.
• This includes the design, architecture and implementation of various ETL/Cube/Report builds.
• Wrote several SSIS ETL packages using SQL Server 2008 Business Intelligence Development Studio to load security event logs from different platforms across Confidential
• Work involved working with various administrators/developers from other environments to generate the logs, verifying the structure of the logs, parsing/loading security logs into a staging area, prior to moving the data into an OLAP Fact and Dimension tables.
• Analysis Services (SSAS 2008) to build the cubes, and SQL Reporting Services (SSRS 2008) for displaying the reports.

Confidential

Senior Business Intelligence / Database Administrator / Database Developer Consultant

Responsibilities:

• Responsible for analyzing Confidential
• This encompasses the design, architecture and writing complex SSIS ETL packages using SQL Server 2008 Business Intelligence
• Development Studio to parse and load Broker Price Opinion XML Log files.
• The work involved using Confidential to convert Confidential into XSD, designing the tables, parsing XML files through OpenXML, and loading the data into a staging database, before moving the data into the dimension and fact tables.
• Worked with Confidential credit risk business analysts to map Pre-foreclosure BPO with CLM BPO to have a better understanding of the trend within the data.

Confidential, Fort Belvoir, Virginia

Senior Business Intelligence / Database Administrator

Responsibilities:

• Wrote complex SSIS ETL packages using SQL Server 2005 Business Intelligence Development Studio to parse and load Web Log files utilizing the script component with C#.
• Work entailed designing the tables, parsing files and loading them into dimensional and fact tables. In addition to the design and implementation of various OLAP databases using Analysis Services, work involved building dimensions, cubes and allocation of data within each measure group to a particular partition.
• Work also involved writing MDX statements for calculated measures, and KPIs.
• Various business actions within Analysis Services 2005 were created to point to reports within SQL 2005 Reporting Services and other URLS.
• Monitored disk space usage for the data warehouse databases and the OLAP cubes.
• Was responsible for automating / monitoring SQL jobs, backing/restoring OLTP and OLAP databases. In addition to performance & tuning, optimization of databases, granting revoking permissions on database objects and troubleshooting failed jobs.

Confidential

Senior Database Administrator / Database Developer Consultant

Responsibilities:

• As a Database Administrator I was responsible for analysis, architecture, system integration and production rollout of the Confidential ‘Guardian’ SQL Server 2005.
• Worked on the migration of the legacy Guardian system from the dot COM domain to the dot MIL domain, migrating applications and functional testing.
• Work also involved rewriting DTS packages in SSIS.

Confidential

Senior Database Administrator / Database Developer Consultant

Responsibilities:

• Installed and maintained the Confidential SQL Server 2005 transactional replication environment.
• Upgraded the Confidential SQL Servers to SQL Server 2005 from SQL Server 2000, in addition to rewriting DTS packages in SSIS.

Confidential

Senior Business Intelligence / Database Administrator

Responsibilities:

• Responsible for the International Mail Data Warehouse running on Windows 2000 Advanced Server on a two node high-availability cluster.
• The work involved maintenance, backup/restore and performance tuning.
• Worked on creating prototype multidimensional cubes using Microsoft Analysis Services, the purpose of which was to determine feasibility of moving cube builds from Cognos to Analysis Services due to performance issues with the Cognos cube builds.
• Wrote complex DTS packages for ETL (Extraction, Transformation and Loading) into Postal Data Warehouses using Star and Snow Flake schemas.
• I was a key member in creating and loading the Common database. The Common database contains all tables that are common in all the databases.
• Work involved designing the tables and identifying their relationships using Erwin 4.0, and then populating the tables using DTS.