We provide IT Staff Augmentation Services!

Data-warehouse Developer Resume

4.00/5 (Submit Your Rating)

SUMMARY:

A results - driven database/data-warehouse developer with multifaceted experience in designing, developing, integrating and administration of ORACLE and MS SQL Server databases/data-warehouse using SQL (PL/SQL, T-SQL) programming and ETL tools (Informatica PowerCenter, SSIS, ODI) for utility, healthcare, research and other industries. Forward-thinking and focused top-performer, creatively solving complex technical problems, resourcefully troubleshooting issues utilizing strong technical knowledge and analytical skills. Involved in software testing and implementations, solving performance and user-experience challenges, experienced leader of strong teams delivering results.

TECHNICAL SKILLS:

  • ORACLE
  • PL/SQL
  • SQL Server
  • T - SQL
  • Informatica
  • SSIS/SSAS
  • MS Access
  • Python
  • Linux Shell
  • Unix Shell
  • HTML
  • JavaScript
  • XML
  • PowerDesigner
  • SQL*Load
  • Power BI

PROFESSIONAL EXPERIENCE:

Confidential

Data-warehouse Developer

Responsibilities:

  • Maintain a data warehouse (SQL Server) for business intelligence analysis.
  • Built data model for business intelligence analysis/presentation using Power Pivot and Power BI.

Confidential, Westwood, MA

Databases/Data-warehouse Developer and DBA

Responsibilities:

  • Built and administrated database/data-warehouse (ORACLE, SQL Server) for business intelligence, which improved the company’s Energy Efficiency BI analysis capability.
  • Designed and developed ETL data integration processes, with PL/SQL, Informatica PowerCenter, SSIS to extract and transform data from various data sources including OLTP DB, legacy DB, Excel spreadsheets, flat files and XML files to a well-designed star-schema ORACLE data warehouse which supports the company’s energy efficiency BI analysis and significantly accelerated processing speed, capability and data quality.
  • Optimized and turned SQL queries and stored-procedures to enable better performance in executing OLAP processes such as data cleanse and aggregation.
  • Developed a MS Access and VBA based application which facilitated the processing of the company’s web site of “Customer Engagement Platform”. Enabling faster and easier routine works of publishing of related data to the Internet.
  • Built Power BI data model and prepared data sets for business intelligence analysis team.

Confidential

Senior Software Engineer and Data Architect, Team Leader

Responsibilities:

  • Designed and developed RDB databases for Confidential and Confidential project by using PowerDesigner; which were operational RDBs (OLTP), used as data provider and collectors for the interactive web sites of Confidential and Confidential projects.
  • Designed and developed a ROLAP data warehouse (SQL Server) based on the operational RDBs.
  • Accomplished data integration by using ETL tools such as SSIS, Informatica PowerCenter to build and administrate the data warehouse.
  • Developed data processing scripts and stored procedures for the data integration.

Confidential, BOSTON

Senior Software Engineer, DBA and Database Developer, Bioinformatics

Responsibilities:

  • Designed and developed on ORACLE 10g, MS SQL Server (2005 - 2008R2) database for genomics data processing (zebrafish genome project). Wrote queries, views, stored procedures and functions.
  • Collected genome data from NIH, HHMI, bio-medical companies and peer laboratories as well as top genomic websites in the world. Designed various ETL processes to integrate data in various forms, such as Excel spreadsheets, flat files, XML files as well as RDBs, loaded data into a RDB for laboratories’ experiments and/or further data processing based on lab’s proprietary protocols, by directly programming with UNIX/Linux shell scripting or by using tools such as DTS and SSIS. These RDBs were also functioned as data providers for lab’s web site.
  • Provided lab IT services as system admin, network administration as well as technical support for lab’s PCs, servers of Windows/Linux, NAS (file storages) and robots.
  • Integrated open source software with the applications developed internally.
  • Built and maintain Linux High Performance Cluster for Genomic computation.

Confidential

Senior Software Engineer

Responsibilities:

  • Developed and maintained education platform, for teaching math and English courses, in desktop version (VB6, VC++6) and web-based version (ASP).
  • Built and administrated an OLTP database (SQL Server 7, MS Access), which stored customer profiles and contents, account control and knowledge bases for AI.

Confidential

Senior Software Engineer

Responsibilities:

  • Contributed to software and database design and development. Managed satellite communications system for Confidential (Japanese equivalent of Confidential ) using shell scripting and C++ on UNIX system.
  • Developed Mail Management System application and related RDB for Japanese postal service department, and Job Search Management application and related RDB for Japanese Education Bureau.
  • Performed remote data exchange via civic telephone network for earthquake surveillance and forecast using VC++ 6 and SQL Server 7, end-users were very satisfied and received award.

We'd love your feedback!