Sr. Data Warehouse Engineer Resume Pasadena, CA - Hire IT People

SUMMARY:

Expert SQL Server Database Consutltant pursuing use of acquired knowledge, critical thinking and skills to support your company in an Administrator or Data Engineering role.

TECHNICAL EXPERTISE:

Database design for ORACLE RDBMS: Advanced ORACLE Applications for developers, Oracle 10g, Sybase IQ

Databases: MS - SQL Server 2008-2012-2016-2017 - Oracle 10g - 11g MySql Sybase

Software: Team Foundation Server (TFS), SSIS, SSRS, SSAS, T-SQL, Erwin, ER Studio

Tools: SSIS, SSAS, SSRS, AWK, SED, V B, TFS, Jira, Tableau, Python, PowerShell

Industries: Banking, Insurance, Mortgage, Risk, Entertainment, Oil Ind, Utilities Co.

OS: Windows server 2008 R2, Linux

PROFESSIONAL EXPERIENCE:

Sr. Data Warehouse Engineer

Confidential, Pasadena, CA

Responsibilities:

Designing and implementing Data Warehouse solutions
SSIS ETL development
SSIS package
Production support of ETL SSIS packages and SQL jobs
MSSQL 2012 - 2016 Store procedure, triggers, functions
Developed control totals to ensure accuracy of data import
Release Manager for Production deployments
Tableau report development

Analytics & Database Developer

Confidential, Westlake Village

Responsibilities:

Data warehouse/Data Mart Conceptual design and Implementation
MSSQL 2008 Stored procedure writing
Integration Services - ETL packages, deployment configurations
SSRS Reporting Services
OLAP Design SQL Server 2008 - Cube creation and processing
ETL Project configurations, TFS versioning
Production Release management (TFS, Scripting)

SQL Database Administrator

Confidential, Santa Ana, CA

Responsibilities:

SSRS Risk analysis Management reports
Data Mart modeling and implementation
MSSQL 2005 stored procedures and functions development
SSAS Analysis Services Cube development and process

Database Administrator

Confidential, Simi Valley

Responsibilities:

SQL Server 2008 BI Architecture. Data warehouse / Data Marts
SSIS - ETL package creation and automation for monthly process
Responsible for Hardware Architecture implementation/capacity plans
Analysis Services design and implementation in SQL Server 2000-2005
SQL server migration from 2000 to 2005 and 2008
SQL server Disaster Recovery design and implementation

Data Architect

Confidential, Santa Ana, CA

Responsibilities:

Data Architecture/Modeling, design and implementation of DW/DM
BI Risk Analysis for Mortgage Products
Team Management of DBA group US and offshore (Bangalore India)
Sybase IQ and SQL Server 2000/2005
SQL 2000 to SQL 2005 migration planning and implementation

Sr. Data Architect

Confidential, Los Angeles, CA

Responsibilities:

Data Architecture/Modeling of new Studio Systems
OLTP Data Entry System development
Implemented Transactional replication
Disaster and Data Recovery strategic planning.
Directed Change Management and Production releases

We provide IT Staff Augmentation Services!

Sr. Data Warehouse Engineer Resume

Pasadena, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship