Donald Windrem, Software Developer in Sayreville, NJ, United States
Donald Windrem

Software Developer in Sayreville, NJ, United States

Member since October 4, 2019
Donald has a wealth of experience—ten years with Oracle Database Express Edition, five years with PostgreSQL/SQL and other databases, and five years with Python development. Recently, he’s been working with Django, Celery, Linux Shell, Java, JavaScript, HTML, among others. Environment-wise, Donald has worked with global, multicultural development teams, has AWS/GCP experience, and is equally comfortable with agile and waterfall methodologies.
Donald is now available for hire

Portfolio

Experience

Location

Sayreville, NJ, United States

Availability

Full-time

Preferred Environment

Subversion (SVN), Git, Windows, Linux

The most amazing...

...project was working on a global request handling and routing software that was able to handle the processing 25,000 requests per minute.

Employment

  • Associate Director

    2006 - 2018
    UBS Financial Services
    • Served as an associate director for Oracle Engineering Group (responsible fo all aspects of DevOps automation in an Oracle DBaaS environment, including strategy, design, engineering, development, and support at UBS worldwide).
    • Constructed the infrastructure, established the automated processes for provisioning databases, deployed upgrades, patches, and backups, worked with GoldenGate and Standby databases, and implemented user maintenance as well as other common DBA tasks.
    • Implemented Oracle OEM deployment procedures and Hewlett-Packard database and middleware automation tools for bulk migration processes. Coded in Linus Shell, Python/Jython, AWK, PL/SQL as well as others.
    • Led and managed the effort to automate the migration of databases from our legacy environment of thousands of Oracle 9, 10, and 11 databases on RedHat Linux and Solaris VMs and servers to our DBaaS environment of Oracle ExaData serves and ODAs with Oracle 11/12 running on them.
    • Served as the lead associate and team lead in the ServiceWorks group (a US-based in-house service request tool that handled various request types for wealth management groups), mainly working with Oracle databases. The app received and processes 25,000 requests/minute during the end-of-year tax rush between December 15 and January 1 of each year.
    • Worked for UBS Financial Services, one of the largest global wealth management corporations in the world with over 65,000 employees worldwide.
    • Converted for UBS a poorly designed ServiceWorks request database—mainly transforming materialized views into regular tables and views.
    • Reworked database model tables and used triggers, views, and packages to improve the performance; the database designers used materialized views that refreshed every four seconds to fix various performance issues rather than correcting the underlying database design issues.
    • Took a database with monthly crashes and transformed it into one that hasn’t had a crash for over the past two years; normal loads on the serve went from routinely hitting 80-90% to below 5%.
    • Acted as a senior associate and team lead of the HR group, working mainly with Oracle, SQL Server, MySQL databases, and Adobe ColdFusion as well as Linux Shell.
    Technologies: HP Cloud, Adobe ColdFusion, JavaScript, Java, Microsoft SQL Server, Python, PostgreSQL, Oracle PL/SQL
  • Web Developer | Database Developer

    1991 - 2006
    Lenox China
    • Occupied various positions including programmer, programmer/analyst, lead developer, and Oracle engineer.
    • Worked with RPG and COBOL on IBM I-series, ColdFusion, Oracle, and Java on RedHat Linux servers for various groups including physical warehousing and distribution and data marts for international purchasing, customs, HTS and domestic shipping.
    • Began work on the IBM AS/400, now called I-series.
    • Supported an international purchasing and shipment tracking application that handled purchase order creation and tracking, vendor tracking, and shipment tracking from the US or overseas, harmonized tariff calculations, and more.
    • Designed, developed, and traveled to each of Lenox's seven US facilities (for nine months)—installing, modifying, and training warehouse staff to use warehouse management and shipment management software.
    • Used Oracle 8i on RedHat Linux servers to support an in-house data mart that reported on international purchasing and shipping information from the application above.
    • Developed the front end in ColdFusion.
    Technologies: Shell, Linux, Adobe ColdFusion, Oracle PL/SQL

Experience

  • Oracle DBaaS Migration (Development)

    This was a DevOps automation project to migrate all of UBS's thousands of Oracle databases throughout the world from VMs or physical servers over to the UBS Oracle DBaaS environment of Exadata servers and ODAs.

    Work Done:
    • Set up the infrastructure.
    • Implementing automated processes for provisioning databases.
    • Migrating existing legacy databases to a DBaaS model.
    • Deployed upgrades, patches, and backups.
    • Worked with GoldenGate and Standby databases.
    • Performed user maintenance as well as other common DBA tasks.
    • Used Oracle OEM Deployment procedures and Hewlett-Packard database and middleware automation (DMA) tools for some of the migration processes.
    • Coded in Linux Shell, Python, AWK and SED, PL/SQL as well as others. XML and Oracle database was used heavily as well.

  • ServiceWorks Redesign (Development)

    The ServiceWorks application was the primary service request platform for UBS Wealth Management in the United States. The application and supporting Oracle database had consistent issues, especially in December when the year-end tax inquiries and requests would peak.

    Work Done:
    • Worked with the team to greatly improve performance. The original database designers used materialized views to fix various performance issues rather than correcting the underlying database design issues.
    • Reworked the database model tables and used views, triggers, and packages to further improve performance.
    • Handled the design, coding, and maintenance of all data handling packages and stored procedures within the ServiceWorks schemas.
    • Led the effort to perform detailed database performance tuning.

    Project Results:
    • Greatly improved the database performance and made the design easier to maintain as well.

  • Credit Account Reporting and Monitoring (Development)

    Work Done:
    • Worked on the corporate credit risk remediation application and database which handled corporate credit and margin accounts held at the bank.
    • Updated the database from Microsoft SQL 2000 to Microsoft SQL 2005 and then to Microsoft SQL 2008.
    • Converted many of the front-end data access scripts to use functions rather than directly accessing the database.

    Project Results:
    • Greatly improved the performance and functionality of the application.

  • Personal Website (Other amazing things)
    http://personal.dwindrem.com/

    I have a personal website that people can review to find out more about me. The website is written in Django and Python, with a Bootstrap framework for JavaScript and CSS and a PostgreSQL database.

Skills

  • Languages

    SQL, Python 3, Python, Java, JavaScript
  • Storage

    Oracle PL/SQL, PostgreSQL, MySQL, Microsoft SQL Server, SQL Server 2010
  • Tools

    Git, Subversion (SVN), Adobe ColdFusion, Shell, Celery
  • Platforms

    Linux, Windows, Amazon Web Services (AWS), Google Cloud SDK
  • Frameworks

    Django
  • Paradigms

    Agile, Waterfall Development
  • Other

    HP Cloud

Education

  • Certificate in Software and Web Development
    1996 - 1996
    Learning Tree International - New York, NY, USA
  • Associate's degree in Computer Science
    1991 - 1996
    Middlesex County College - Edison, NJ, USA

To view more profiles

Join Toptal
Share it with others