OBJECTIVE:

A position as a Microsoft SQL Server Business Intelligence Developer.

SUMMARY:

• Eight years of experience as a Microsoft SQL Server Database Administrator
• Ten years of experience with SQL Server Reporting Services
• Eight years of experience with MS SQL Server Analysis Services
• Twelve years of experience with MS SQL Server Integration Services
• Ten years of Experience performing Exploratory Data Analysis
• Three years of experience using Jupyter notebook and Jupyter lab
• One year Experienced using PostgreSQL 10.x
• Five years experience developing Qlikview 11.x DAR applications.
• Three years experience using R Statistical Programming Language
• Four years experience using Python For Data Science
• Two year experience with the Linux Operating System
• Two years experience using Apache Hive and Apache Pig
• One year experience working with Power BI

RELEVANT EXPERIENCE AND ACCOMPLISHMENTS:

Confidential

Responsibilities:

• Developed and implemented U - SQL scripts in Azure Data Lake Analytics.
• Created and deployed Azure SQL Data Warehouse databases in Azure Portal.
• Created and deployed Azure SQL Data Warehouse tables with round-robbin and hash distributions.
• Created and deployed virtual machines in Azure Portal.
• Created and deployed PySpark Jupyter Notebooks to Azure DataBricks.
• Experience writing HiveQL to query Hive Data Warehouse.
• Created SSIS scripts to extract data from Azure Data Lake.
• Experience writing Spark SQL queries to manipulate large data sets.
• Experience creating dimensional models in Azure SQL Data Warehouse .

Confidential

Responsibilities:

• Developed and implemented ETL instrumentation framework to track SSIS Package status, number of rows extracted, inserted, updated, and log package failures.
• Developed and implemented ETL framework to perform historical and incremental loads of dimensions, and fact tables utilizing master packages.
• Developed and implemented parallelization at the Master Package level to increase overall ETL throughput.
• Developed and implemented raw file and heap table utilization to maximize extraction throughput and minimize impact on source systems and to avoid contention with critical source processes.
• Developed and implemented ETL capabilities to target only new and changed records in incremental loads utilizing Transact-SQL row version data type, and created/modified time stamps to increase performance of the extraction process.
• Developed and implemented lookup transformations in fact table ETL to replace natural keys with dimension surrogate keys.
• Developed and implemented logic in fact table ETL to match NULL values to unknown members and unmatched values to early arriving members.
• Developed and implemented logic in fact table ETL to deal with late arriving facts.
• Developed and implemented Balanced Data Distributors in fact table ETL packages to increase load throughput.
• Developed and implemented package tuning methodology to identify and resolve performance bottlenecks.
• Implemented high speed ETL routines utilizing the hash bytes function to detect type 1, and type 2 changes as well as new records.
• Developed and implemented the use of update tables in incremental loads to replace OLEDB Command transformations (RBAR).
• Developed and implemented ETL solutions that mimic the Slowly Changing Dimension Wizard for fact tables that required insert, update, and soft delete transactions.
• Created and implemented SSIS proxy accounts to manage the ETL process under SQL Server Agent.
• Mentored and assisted junior BI developers on ETL design and best practices.
• Attended the Kimball’s University ETL Architecture in Depth course in the summer of 2012.
• Developed and implemented T-SQL Scripts to iterate through OLTP systems and generate Source to-Target Mappings documents used to document the ETL process.
• Extensive experience using Pragmatic Works BI Documenter tools to perform in depth data profiling of source system entities.
• Extensive experience using the SSIS Data Profiling task to extract source table metadata.
• Three years experience using QlikView’s ETL tools to generate historical and incremental loads.
• Three years experience working with Qlikview’s Inline, Resident, Crosstab, and Mapping tables.
• Experience using Qlikview’s ETL tools to extract from Salesforce, SQL Server, flat files and MS Excel documents.
• Experience using R Statistical Programming to perform exploratory data analysis.
• Experience using R Statistical Programming to perform data cleansing operations on datasets originating from SQL Server, flat files and MS Excel files.

Confidential

Responsibilities:

• Developed and implemented data warehouses and data marts to utilizing the data warehouse bus architecture.
• Developed and implemented data warehouse bus matrices models to document and visualize business processes, dimensions, and conformed dimensions.
• Developed and implemented Logical Data Maps to provide functional specifications to the ETL team, assist in the quality-assurance (QA) testing, and to answer questions during user-acceptance testing (UAT).
• Developed and implemented Entity Relationship Diagrams (ERD) for data marts using SQL Server and Visio to document data marts.
• Developed and implemented SQL Server Data Warehouses using the Star and Snow flake Schemas.
• Developed and implemented Type 1, 2, and hybrid slowly changing dimensions to present current and historical values.
• Developed and implemented Degenerate dimensions in fact tables to facilitate analysis.
• Developed and implemented Dimensions utilizing surrogate keys, and housekeeping attributes to track Row Effective Date/Time, Row End Date/Time, Current Flag, and Business Keys.
• Developed and implemented Unknown and Inferred Members in dimension design.
• Developed and implemented Role Playing Dimensions in Confidential .
• Developed and implemented transactional fact tables using table partitioning to improve table performance.
• Implemented foreign keys in between fact tables and dimensions to maintain referential integrity.
• Implemented covering indexes, indexes, and file groups in data warehouses using T-SQL.
• Developed and implemented data warehouses (Star, Snowflake, and Constellations) utilizing Qlikview application software and the Kimball methodology.
• Developed and implemented transactional and aggregate fact tables in Qlikview Data Warehouses.

Confidential

Responsibilities:

• Developed and implemented Cubes for accounting departments and clinical reporting utilizing MS SQL Server Analysis Services (SSAS).
• Developed and implemented reports for data warehouse utilizing QlikView, MS Excel, SSRS,.
• Experience writing MDX queries for SSAS.
• Developed and implemented Data Driven Subscriptions for SSRS.
• Developed and implemented cascading and multi value parameters in SSRS reports.
• Developed and implemented Matrix, Tablix, Graph, and KPI reports in SSRS.
• Seven years of experience writing DML and DDL statements in Transact SQL including stored procedures, table valued functions, scalar functions, views, synonyms, triggers, CTEs, and pivot statements.
• Experience developing and implementing Power BI dashboards.
• Developed and implemented personnel reports to support mission objectives of the United States Army for over 10 years.

Confidential

Responsibilities:

• Maintained on-line full, differential, and transaction log backups for production, historical, and development environments.
• Installed and configured multiple SQL Server instances in production, development, disaster recovery sites, and in a cluster environment.
• Extensive experience using SQL Server Profiler to troubleshoot query performance.
• Created and configured multiple SQL Server alerts to notify IT department of security, hardware, blocking, and transaction log problems.
• Used T-SQL to create user logins, grant permissions, execute backups/restores, query system views, and attach/detach databases.
• Developed and implemented databases, tables, queries, views, stored procedures, functions, triggers, synonyms, and CTE's using T-SQL.
• Implemented primary, foreign, and alternate keys; check constraints, unique constraints, and indexes using T-SQL to improve database performance.
• Implemented automated jobs to perform index defragmentation, database consistency checks, and update table statistics.
• Utilized the Database Tuning Advisor along with SQL Server Profiler to troubleshoot SQL Server performance.
• Implemented alert system to notify IT group of SQL Server errors 16 through 25 as well as blocking, and percent of database transaction log used.
• Experience supporting Microsoft DYNAMICS GP 10.0 Accounting software.
• Extensive experience installing and maintaining SSRS and SSIS.
• Documented databases using Entity Relationship Diagrams in MS Visio and MS SQL Server Diagramming Tools.
• Experience creating database mirrors and implementing database replication.