We provide IT Staff Augmentation Services!

Sr. Data Warehouse Engineer Resume

Pasadena, CA

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

Hire Now