Datawarehouse Architect Resume

PROFESSIONAL EXPERIENCE

Datawarehouse Architect

Confidential

Responsibilities:

Architected enterprise near real time Confidential warehouse to include Confidential modeling, Confidential flow and documentation
Development of database release management tools to include deployment script generation, schema compare, and delta script generation
Stored procedure development
Development of Confidential Comparison tool using Java for enterprise level Confidential comparisons
Development of dev loads to facilitate rapid report prototyping from messaging and DB sources using various languages

Technology Stack: ER Studio, SQL Server, Snowflake, SQL/PLSQL, Java, JavaScript, Rabbit, Kafka, PowerShell, Talend, VBA

Senior Database Developer

Confidential

Responsibilities:

Technology Stack: Netezza, Talend, SQL/PLSQL, Tableau, PowerShell, VBA, Oracle

Software Engineer

Confidential

Responsibilities:

Development of reporting and dashboards using Tableau and SSRS with an emphasis on report performance.
Stored procedure development and Confidential modeling for reporting and operational systems.
Build and maintain Confidential warehouse
Working directly with clients for report development and validation purposes via various communication channels.
SSIS package development
Documentation of report specifications
Numerical integration of Normal CDF for reporting in SQL Server.
Confidential load automation

Technology Stack: SQL Server, SQL/TSQL, SSRS, Tableau

Database Analyst

Confidential

Responsibilities:

Development of reporting utilizing Tableau.
Development of reporting solutions including gather business requirements, Confidential modeling, procedure development, QA testing, and dashboard design and implementation.
Ad - hoc analysis to analyze trends and look for statistical significance.
Rewrote inefficient SQL/PLSQL for clarity and speed.
Implementation of Tortoise repository for scripts, procedures, and DDLs.
Generating routine reporting.

Technology Stack: Oracle, Teradata, Tableau