Daniel Louis Galperin, Developer in Lake Forest, CA, United States
Daniel is available for hire
Hire Daniel

Daniel Louis Galperin

Verified Expert  in Engineering

Unix Shell Scripting Developer

Location
Lake Forest, CA, United States
Toptal Member Since
June 18, 2020

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.

Oracle Performance TuningOracle Forms & ReportsPL/SQLOracleSQLPL/SQL DeveloperOracle FinancialsT-SQL (Transact-SQL)Oracle DBAC#.NET WinFormsPerlOracle SQLOracle FormsOracle Reports

Portfolio

Bayer Crop Science
PL/SQL, Oracle SQL
Hyundai Capital USA
Oracle Reports, Oracle Forms, Pro*C, Unix Shell Scripting, PL/SQL
Nestle USA
Oracle Reports, Oracle Forms, Unix Shell Scripting, Perl, PL/SQL

Experience

PL/SQL - 18 yearsSQL - 18 yearsOracle - 18 yearsOracle Forms & Reports - 17 yearsUnix Shell Scripting - 17 yearsPL/SQL Tuning - 17 yearsT-SQL (Transact-SQL) - 4 yearsPro*C - 3 years

Availability

Part-time

Preferred Environment

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.

Work Experience

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: PL/SQL, Oracle 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: Oracle Reports, Oracle Forms, Pro*C, Unix Shell Scripting, PL/SQL

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: Oracle Reports, Oracle Forms, Unix Shell Scripting, Perl, PL/SQL

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: Oracle DBA, Reports, Forms, PL/SQL

Languages

SQL, Pro*C, T-SQL (Transact-SQL), Perl

Platforms

Oracle

Storage

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

Other

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

Tools

Oracle Financials, Oracle Forms, Oracle Reports, C#.NET WinForms

1994 - 1996

Master of Pubic Affairs Degree in Public Affairs

University of Texas at Austin - Austin, Texas

1989 - 1994

Ph.D. in Logic, Philosophy

University of Calfornia at Riverside - Riverside, CA

1984 - 1988

Bachelor of Arts Degree in Philisophy

University of Redlands - Redlands, CA

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring