Gurpreet Singh

About Gurpreet Singh

Over 20 years of experience in the IT industry, specializing in Database architecture, design and development. Expertise in the complete SDLC of Data Warehousing, Legacy and OLTP systems assuming the role of Architect, Lead Developer, Data Quality Analyst, Modeler/Designer. Over 8 years of experience in Database Modeling & Design. Over 17 years of experience with OLTP/ Data Warehousing Systems as a Lead Developer / Architect with excellent performance tuning skills Expert in utilizing Oracle Structural Query language, scripting, J2EE, Java, Perl, UNIX and Agile development methodology. • Oracle RDBMS 11G, 10G Enterprise Edition, RAC implementation, Oracle Enterprise Manager.• Languages: SQL, PL/SQL, UNIX Scripts (ksh), HTML, C, Transact –SQL,Java,J2EE, Sybase IQ, Sybase, Core Java,#Ne Win forms• Operating Systems: UNIX( IBM, Solaris, HP, Linux ),Windows DOS,VAXVMS ToolsData Modeling: Erwin, VisioETL: Informatica Power Center7.x/8.x, SQL, PL/SQL, SQL*Loader, Export/Import, FTPJob Scheduler: Control – M, Cron, Oracle Job scheduler, AutosysBI Reporting: SQL*Plus, Oracle Reports, CSV ReportsDB Tools: SQL*Plus, TOAD, SQL Navigator, PLSQL Developer, Rapid SQL, Aqua Data StudioFront End: Forms & Reports - Oracle 11ias, Developer 6i, Developer/, Control: PVCS, Subversion, Clear questProductivity: Microsoft Office (Word, Excel, PowerPoint), MS- Project, Visio, Rational ApplicationsWeb Technologies : Java, J2EE, HTML, XML.NET, WinformsScripting Languages: UNIX Shell Script, PerlSpecialties: Oracle Database, Sybase IQ, OLTP Databases, Data Warehousing, Database Architecture, Performance Tuning, Project Management, Team Management, Project Planing\"Hadoop Platform and Application Framework by University of California, San Diego on Coursera. Certificate earned on December 9, 2015\".

Experience

1. Associate Director

   The Depository Trust & Clearing Corporation (DTCC)

   Mar 2021 — Present · Jersey City, NJ, US

   Principal Software Engineer in DTCC - Derivatives Business. Working in Global Trade Repository for Swaps reporting to CFTC in US and other regulators in Canada, ESMA, Singapore, Australia, Japan. Lead Engineer and proficient in all areas of software development.

Education

• Stevens Institute of Technology

  MBA, Howe School of Technology - Technology Management

  2010 — 2016

• Veer Surendra Sai University Of Technology (VSSUT,Formerly UCE), Burla

  Bachelor of Engineering - BE, Electronics and Telecommunication Engineering

  1992 — 1996

• Stevens Institute of Technology

  MS, Howe School of Technology Management - Information Systems

  2007 — 2009

• St Pauls

  High School, Science Math

  1989 — 1991

Skills

• Database Design
• Databases
• Database Development
• Performance Tuning
• Software Development Life Cycle (Sdlc)
• Informatica
• Unix Shell Scripting
• Oltp
• Sybase Iq
• Business Intelligence
• Sybase
• Data Analysis
• Sdlc
• Apache Pig
• Sql
• Pl/Sql
• Unix
• Data Modeling
• Apache Spark
• Hadoop
• Sybase Products
• Solaris
• Relational Databases
• Oracle
• Hive
• Data Warehousing
• Data Warehouse Architecture
• Shell Scripting
• Sqoop