ETL/BI Architect Resume

SUMMARY:

A professional, proactive, and collaborative individual with strong management, analytic, and multi - tasking skills with extensive experience in ETL development, database administration, data warehousing, and translating business requirements into solutions that provide business value.

SKILL:

Data modeling with Visio and Erwin (3+ years)
SQL Server table, view, stored procedure, and function creation (15+ years)
Query Optimization (5+ years)
Teradata (4+ years)
Salesforce (3+ years)
SAS DI Studio (4+ years)
BI Architecture (one year)
Team Foundation Server (2+ years)
Office (10+ years)
SSRS (3+ years)
Sharepoint (3+ years)
SAS Enterprise Guide (3 years)
Gathering and storing Metadata (2+ years)
Dataflux (2 year)
Gaming Experience (7+ years)
Hotel Experience (4+ years)
SSIS (2+ years)

EXPERIENCE:

Confidential

ETL/BI Architect

Responsibilities:

Modified existing ETLs to increase performance by 50 percent through index analysis and optimization.
Created and deployed new ETLs to streamline business processes and reporting.
Worked closely with business partners to troubleshoot existing issues and define new requirements to increase analytic business value.
Created and extended Data Warehouse relational and multi-dimensional data models.
Worked on ETL, BI, and database projects with a strong emphasis on the software development lifecycle methodology and industry best practices.
Trained users on new implementations through one-on-one interaction and classroom style instruction.
Validated Enterprise Data Warehouse data through all steps of ETL back to source data systems.
SQL Server stored procedure, view, function, and table creation along with index optimization.
Met or exceeded project timelines, often up to a week or more before project is due.
Salesforce administration.
Maintained Teradata and SQL database users, roles, and profiles.
Teradata creation of tables, index, and views, database optimization and capacity planning.
Created SSRS reports for the various casino properties in the areas of POS, Title 31, and Veridocs, for example tip reports, summaries by Server, and property daily gross amounts. Managed SSRS site security.
SQL Development includes use of common table expressions, analytical functions like row number() and rank(). Extensive T-SQL. Creation of audit and error logging databases. Use of both physical and functional temp tables. ETL creation using stored procedures, functions, views, and SQL Agent jobs. Creation of stored procedures for parameter driven SSRS reports. CDC methodologies.
Use of SQL merge statements for Upserts.

Confidential

ETL/BI Architect

Responsibilities:

Contract work with Access applications to track hotel events and patron activities. Created reports as needed.
Updated Access database to expand functionality.

Confidential

ETL/BI Architect

Responsibilities:

Plan, design, and implement database objects, such as stored procedures, triggers, functions and views.
Build and maintain SQL scripts and complex queries for data analysis and extraction.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship