SEARCH

Database Developer Consultant Resume Example

Resume Score: 90%

Love this resume? Build Your Own Now
DATABASE DEVELOPER CONSULTANT
Career Overview
To obtain a position that allows me to use my skills as a developer. Two years of experience as a database developer with strong technical background. Involved in all phases of the SDLC (Software Development Life Cycle) from collecting the requirements, analyze, design, development, testing and implantation. Proficient in SQL and PL/SQL programming. In depth knowledge about varieties of databases, such as Oracle 10g/11g, SQL Server, MS Access, and etc. Experienced in collecting data from different resources like Excel, Flat file, Sales Force, CSG; communicating with different databases via ETL (Extracting, Transforming and Loading) process.
Qualifications

About 3 years of experience as a database analyst and developer, being involved in all phases of the SDLC (Software Development Life Cycle) from collecting the requirements, analyze, design, development, testing and implantation.

  • Proficient SQL and PL/SQL programmer
  • In depth knowledge about varieties of databases, such as Oracle 10g/11g, SQL Server, MS Access, and etc.
Skills
Active Directory, AJAX, B2B, C, CSS, clients, data analysis, data migration, Databases, database, DBMS, designing, ETL, Excel VBA, FTP, functional, HP, Hewlett-Packard, HTML, IIS 7, JAVA, JSP, JavaScript, JDBC, Linux, Logistics, marketing, Access, Access database, MS Access, MS Excel, Excel, Windows XP, Microstrategy, migration, MySQL, enterprise, ODBC, OLE, OS, optimization, Oracle, Oracle database, DB, Oracle) database, Developer, PL/SQL, Oracle/SQL, pivot table, processes, Quality, QA, Redhat, reporting, requirement, Sales, Samba, SDLC, SSH, servers, Software Development, SQL, SQL Server, SQL Loader, Struts, System Analysis, TOAD, Tomcat, UNIX, UNIX shell scripts, UNIX shell scripting, Visio, Vista, VBA, websites, Windows Server
Work Experience
Charter Communications, Inc February 2015 to September 2015 Database Developer Consultant
Stamford, CT
  • Created, implemented and optimized a series of complex SQL queries to query CSG (Oracle) database and SQL Server according to business requirements.
  • Designed ETL process to transfer data among Oracle, SQL Server, MS Access, Sales Force and other internal resources by using SQL Server Management Studio, SSIS, TOAD.
  • Provided data analysis on company new order manager system, and migrated reports from old system to new one.
  • Developed complicated Microstrategy Dashboard report based on business needs.
Cablevision Systems Corporation August 2013 to December 2014 Oracle PL/SQL Developer Consultant
Long Island, NY
  • Developed brand new fraud detection reports in the process of Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis, Architecture and Design, Development, Testing and Deployment.
  • Built Data Flow, Data Model with tools like MS Visio, SQL Developer, according to the project requirements.
  • Reverse engineering legend SMART Collection reports on old Access database, created mapping documents and re-designed based on the new system running on Oracle.
  • Created customized PL/SQL Procedures, Functions, Triggers and UNIX shell scripts for various business needs with Exception handler.
  • Achieved query optimization and tuning using index, Hints, Explain Plan, and DBMS_STATS.
  • Developed PL/SQL Packages for table Mirroring between different database servers, and scheduled the mirroring job executing in a reasonable frequency with Oracle Scheduler.
  • Performed Extract, Transform, Load (ETL) process for data migration between FTP Server and databases with SQL Loader.
  • Developed UNIX CRON jobs to detect user's action on FTP Server in a specific time range with a specific frequency.
  • Created Excel VBA (Macro) programs to automatically refresh Excel workbooks; generate pivot table; and populate employee performance reports and invoices in a user-friendly format.
  • Configured the ODBC/OLE DB to connect Oracle/SQL Server/Access databases.
  • Provided 24/7 Production support.
  • Log service requests and resolve the issues reported by the clients.
Hewlett-Packard Co., Ltd September 2010 to March 2011 Quality Assurance Intern
Shanghai, China
  • Worked with Hewlett-Packard's ePrime product, which is the best enterprise-focused B2B solution for its lucid user prompting, trim structure and integration of external and internal processes.
  • Assisted in analyzing customers' requirements, designing test plan for functional testing of ePrime products, as well as mapping test cases from MS Excel to HP Quality Center.
  • Involved in UAT testing in Software Development Life Cycle (SDLC), reporting user issues to development.
  • Worked with QA teams in different locations to resolve defects in Oracle database migration process.
  • Created SQL queries for validating target data with the source.
  • Dealer Management System Designed dealer management system based on business requirement.
  • Integrated ExtJS framework with Struts, Spring and Hibernate frameworks (SSH), providing a high-performance customized web application, which enabled customers manage their dealers, supply and marketing process.
  • Logistics Information System Designed and implemented package tracking and price quote system for a logistics company, using MySQL as backend database, JDBC, Tomcat, JSP, JavaScript, HTML/CSS, and AJAX.
  • An interface was also provided for the system to interact with other websites.
Education and Training
New Jersey Institute of Technology May 2013 MS: Information Technology Administration and Security Newark, NJ Information Technology Administration and Security
Fudan University Jun 2011 BS: Computer Science Shanghai, China Computer Science
Build Your Own Now

Resume Overview

Companies Worked For:

  • Charter Communications, Inc
  • Cablevision Systems Corporation
  • Hewlett-Packard Co., Ltd

School Attended

  • New Jersey Institute of Technology
  • Fudan University

Job Titles Held:

  • Database Developer Consultant
  • Oracle PL/SQL Developer Consultant
  • Quality Assurance Intern

Degrees

  • MS : Information Technology Administration and Security
    BS : Computer Science

Advertisement

Similar Resumes

View All

Database Developer

RentPath

Duluth, Georgia

Posted 1026 days ago