We provide IT Staff Augmentation Services!

Data Warehouse Designer Resume

3.00/5 (Submit Your Rating)
Hire Now

Objective

To obtain a position as a Database Administrator.

Qualifications

  • Oracle Certified Professional (OCP) for Oracle 11g Administration with 3 years experience. Profound knowledge of RDBMS architecture, implementation, and administration; proficient in Oracle; familiar with MySQL, MS SQL, MS Access, and PostgreSQL.
  • Skilled in database design using different tools such as CA ERwin, MS Visio, and Toad Data Modeler.
  • Experience with Oracle database administration tasks such as backup & recovery, managing users & security, managing schema objects, managing resource, configuring & administering auditing, scheduling jobs, monitoring & tuning performance, and moving data with tools such as Data Pump and SQL*Loader.
  • Deep understanding of data warehousing theory; hands-on experiences with data extraction, transformation, and loading (ETL) processes, creation of OLAP cube, and design of slice and dice reports.
  • Expert level of SQL and PL/SQL programming; proficiency with SAS.
  • Knowledge of Oracle Data Guard, Golden Gate, ASM, and RAC.
  • Experience with both Windows & Linux systems; ability to write Linux shell scripts to automate DBA tasks.
  • Proficiency with database-driven application development and reports creation with Crystal Reports.

    • Certifications

  • Oracle Database 11g Administrator Certified Professional.
  • Oracle PL/SQL Developer Certified Associate.
  • Oracle Database SQL Certified Expert.
  • SAS Certified Base Programmer for SAS 9.
  • SAS Certified Advanced Programmer for SAS 9.

    • Training

  • Data Warehouse Fundamentals.

    • Education

    M.S. in Information Sciences and Technology
    PhD candidate and research assistant
    M.Eng in Mechanical Engineering
    M.S. in Mechanical Engineeering
    B.S. in Mechanical Engineering

    Relevant Coursework: Data Object Development, Database Architecture and Implementation, Database Client & Server Connectivity, Data Warehouse, Network Protocols, Unix/Linux, System Administration, Website Design & Technology, Programming for the Web, Java Programming, XML, Web Database Integration.

    Relevant Projects

  • Data warehouse design and implementation for decision support

    • Original data from a wine distribution company was cleansed with self-developed PHP scripts. Cleansed data was transformed to a Star Schema with SAS. A data warehouse was built by loading the transformed data into an Oracle database with SQL*Loader. Cube-organized materialized views were created for efficient access. Complex queries were built in SQL Developer using SQL Analytical Functions to generate reports for decision support.

  • Student information system design, implementation and administration

    • Conceptual, logical, and physical design was conducted for a student information system. An ER diagram was created using CA ERwin data modeler. A database was created with Oracle DBCA and user-managed and RMAN backups were performed. Bash scripts were created to automatically send performance reports
    based on AWR. Security plan, database disaster and recovery were also emphasized and implemented in the process.

  • Community hospital database design and application development

    • Given the background of a community hospital, the entities were correctly defined. An ER diagram was constructed with CA ERwin and the ER diagram was transposed to normalized relations. Table structures were created based on the relations and the final database was implemented with MySQL. An application employing JDBC was developed to access the database, support DML operations, and generate reports.

  • Installation and testing of RAC on Linux

    • A two node RAC environment was created on Oracle Enterprise Linux virtual machines using VMWare Server 2.0. Transparent Application Failover and Load Balancing Advisory were tested on the system.

  • Setting up a physical standby database using Oracle Data Guard

    • A primary database server, with Oracle 11gR2 software was installed and a database was created. A standby database server with a software-only Oracle 11gR2 was installed. Server switchover was tested.

  • Web-based third party logistics management system

    • The system provides inventory management for administrators and product management for customers. Database tier and presentation tier were created with Oracle and HTML, respectively. Business tier design was accomplished with PHP.

  • Database-driven online testing system design

    • The system allows users to takes quizzes online and produces a score report. A quiz database was created with MySQL; front-end was created with HTML/CSS/JavaScript; business tier was created with PHP.

    Hire Now
    Report an issue

    We'd love your feedback!

    Privacy Policy
    Resume Categories
    Client Services
    Job Seekers
    Visa Sponsorship