Scroll To View More
Daniel Louis Galperin, SQL Developer in Lake Forest, CA, United States
Daniel Louis Galperin

SQL Developer in Lake Forest, CA, United States

Member since August 20, 2017
Dan is an Oracle 12c programmer with over 18 years' experience, the last 12 of which have been remote. He specializes in PL/SQL, T-SQL, UNIX shell scripting, Oracle Forms and Reports, and has also done PERL and Python scripting. Dan has expert-level relational data modeling skills and knows T-SQL; thus, he would welcome SQL Server development projects, as well. He can read Pro*C/C well, and he can do most Oracle DBA work.
Daniel is now available for hire

Portfolio

Experience

  • PL/SQL, 18 years
  • Oracle, 18 years
  • SQL, 18 years
  • PL/SQL Tuning, 17 years
  • Oracle Forms & Reports, 17 years
  • Unix Shell Scripting, 17 years
  • T-SQL, 4 years
  • Pro*C, 3 years
Lake Forest, CA, United States

Availability

Full-time

Preferred Environment

Lots of programming; interact with users.

The most amazing...

...programming project I've done recently is to translate from Pro*C to PL/SQL over 10,000 lines of code devoted to Hyundai Capital's credit bureau rating logic.

Employment

  • Oracle Programming Consultant

    2017 - 2017
    Bayer Crop Science
    • Wrote complex queries to capture information on Bayer crop science studies. Collaborated with Bayer's scientists as users. Queries involved performance tuning, WITH clauses/factored subqueries, and db links.
    Technologies: Oracle SQL, PL/SQL
  • Oracle Developer

    2015 - 2017
    Hyundai Capital USA
    • Translated to 10,000 lines of Pro*C code to PL/SQL for a credit bureau rating conversion project.
    • Wrote numerous backend PL/SQL and UNIX shell programs for the company's loan origination system.
    • Modified complex Oracle Forms for the same system.
    Technologies: PL/SQL, UNIX shell scripting, Pro*C, Oracle Forms, Oracle Reports
  • Oracle Programmer

    2004 - 2015
    Nestle USA
    • Developed and maintained, using Oracle XML, PL/SQL, PERL, UNIX ksh scripting, Python, and Oracle Forms,Nestle Mobile Application Suite Oracle system. It was mission-critical and served over 2,000 daily routes.
    • Created and maintained Nestle's Supplier Quality Rating System for its large ice cream plants. Done it Oracle, this used PL/SQL, Oracle Designer, Oracle Forms and Oracle Reports.
    • Supported and developed custom code for Oracle Financials R12 Fixed Assets. The code populated fa_mass_additions, fa_mass_transfers, and fa_mass_retirements.
    • Served as business analyst, programming, and data modeler on Nestle's complex custom financial systems for pricing and promotions.
    • Performed advanced relational data modeling in creating new schemas for the above applications.
    Technologies: PL/SQL, PERL, UNIX shell scripting, Oracle Forms, Oracle Reports, Appworx
  • Oracle Programmer and DBA

    2000 - 2004
    California Department of Industrial Relations
    • Maintained and supported the agency's Worker's Compensation Information System and its Occupational Safety and Health Appeals Board Oracle systems.
    • Contributed to OracleDBA work especially in performance tuning, scheduling using the UNIX Cron, and Oracle export/import for backup and recovery.
    Technologies: PL/SWL, forms, reports, Oracle DBA

Skills

  • Languages

    SQL, Pro*C, T-SQL, Perl
  • Platforms

    Oracle
  • Storage

    Oracle 12c, PL/SQL, PL/SQL Developer, Oracle DBA
  • Other

    Oracle Performance Tuning, Oracle Forms & Reports, PL/SQL Tuning, Data Modeling, Unix Shell Scripting
  • Tools

    Oracle Financials, C#.NET WinForms

Education

  • Master of Pubic Affairs degree in Public Affairs
    1994 - 1996
    University of Texas at Austin - Austin, Texas
  • Ph.D. in Logic, Philosophy
    1989 - 1994
    University of Calfornia at Riverside - Riverside, CA
  • Bachelor of Arts degree in Philisophy
    1984 - 1988
    University of Redlands - Redlands, CA
I really like this profile
Share it with others