Business Intelligence Engineer Resume Seattle, WA - Hire IT People

TECHNICAL SKILLS:

OLAP: Multi - dimensional Analysis, Cube Design and Development, Data Warehouse Design / Dimensional Modeling (Kimball Methodology), Logical Data Mapping, ETL Process

Report Design: Tableau - Data Visualization

SQL Server SSRS: - Reports Development: Tabular, Matrix, Chart

SQL Server SSAS: - Data Warehousing Design, Cube Designing, Programming and Configuration, MDX Query Development - Analytical Dataset, Calculated Members, Named Sets, KPI, Data Mining Structure

DQS: - Data Quality Services/ SSIS DQS Cleaning Transformation

SQL Server SSIS: - Data Profiling, ETL Process, CDC

Data Mining Techniques: - Supervised (Decision Tree, Regression, Time Series Algorithms) and Unsupervised Learning (Clustering, Association Algorithm), Confusion (Classification) Matrix, Market Basket Analysis, Statistics

OLTP: : Relational Database Design - Logical Modeling and Physical Implementation, Normalization, Indexing, DRI, T-SQL (DDL, DML), T-SQL Programming - Scripts, Stored Procedures, Triggers, User-defined Functions, Views, Temporary Tables, Derived Table (sub-query, CTE), Table Variables

Programming: Proficient in MDX, T-SQL, C# Development

Tools: Tableau 10, Tableau Desktop 10. Tableau Server 10, SQL Server Management Studio 2016, SQL Server Business Intelligence Development Studio (BIDS) / SQL Server Data Tools (SSDT), Visual Studio 2015, Access 2010, Visio 2013

WORK EXPERIENCE:

Confidential, Seattle, WA

Business Intelligence Engineer

Responsibilities:

Senior Business Intelligence Engineer working on Redshift Data Warehouse and Oracle Data Warehouse, Leading data visualization reporting development via Redshift Virt .
Created Confidential tables from Oracle Data Warehouse and Redshift Data Warehouse.
Wrote scripts to extract data via ETL service.
Scheduled jobs to load the data to the Confidential table in Virt.
Automated current reporting system via Tableau.

Confidential, Bellevue, WA

BI Developer II

Responsibilities:

Senior Business Intelligence Developer working on analytical reporting portal. On OLAP platform development environment, leading Tableau data visualization reporting development from various sources via all types of servers or files. Sources include multi-dimensional database, data warehouse, cloud-based data sources, relational database, and flat file data sources.
Automated reports via Tableau.
Extracted data from data warehouse and cube.
Structured cube architectures including attribute hierarchy and user-hierarchy.
Designed dashboard visualizations with a perspective of analytical insight.
Architected data structure of the data source and request process for end-users.
Analyzed the entire reporting portal and systems.
Developed solutions for report automation.

Confidential, Seattle, WA

SQL Developer

Responsibilities:

Senior Developer working on financial reporting portal for clients.
Created and developed key components within all tiers (UI, middle-tier and database) of the SaaS cross-browser web application. Projects included design and development of a fully customizable, drag & drop report designer; user interface design and development of product authorization system, which is now being introduced for other products in the suite.
Developed stored procedures as source data according to complex business scenarios for reporting and data integrity, generating auto emails for data operations to finish the data cleaning.
Designed report interface.
Maintained data integrity and database structure including tables, views and triggers.
Published SSRS report subscriptions to the report server and generated automatic emails to end users.
Developed and maintained source code in development environments via TFS.

Confidential, Seattle, WA

Data Analyst II

Responsibilities:

Senior Analyst working on legal reporting portal for clients.
Was responsible for gathering the business requirements and business rules.
Designed relational database model and implemented physical model.
Analyzed source data, transformed the data and loaded into relational database.
Wrote Ad-Hoc SQL queries to extract data for reporting.
Analyzed report data and provided insights of the data to the end user.
Created stored procedures and user-defined functions.
Designed report interface and published to SharePoint portal.

Confidential, Bellevue, WA

IT Business Analyst / Database Developer

Responsibilities:

Database & Software Developer working on UI and database tier of the CRM software development.
Defined business rules for CRM software.
Designed OLTP logical model.
Implemented physical database model.
Designed UI - CRM application.

We provide IT Staff Augmentation Services!

Business Intelligence Engineer Resume

Seattle, WA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship