Gurpreet Singh M.S,Mba Email & Phone Number

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.

Jersey City, NJ, US

• Cross Asset Database Architect for Foreign Exchange, Commodity, Credit, Interest Rates and Equity OTC Derivatives. I am Part of the Team building a Global Trade Repository for these derivatives products. I am one of.
• Responsible for performance enhancements to the system. Used latest constructs like RESULT_CACHE functions, collections, bulk processing to process massive amounts of data in shortest possible time.
• Overall Responsible for Dodd Frank Reporting for Commodity Swaps.
• Development of critical Processes for Commodities including Auto Exit Processing, Multi-Jurisdictional Reporting.
• Responsible for Commodities Reporting Batch Processing End to End.
• Responsible for overall health of the Trade Information Warehouse (TIW) Database.

Nashville, TN, US

Database Technical Lead in Alliance Bernstein Fixed Income Risk Analytics Group. There is a Risk Database called Fixed Income Risk Engine (FIRE) which is a risk analytics, security classifications and Benchmarks master database. 1.Worked on tuning the FIRE Overnight Batch by implementing Delta Processing, Parallel Queries, Table Partitioning, Analytic.

New York, New York, US

• Citigroup Investment Bank has built a risk analytics system which is part of Trader Workstation Software. All the traders can see the market, credit risk across all asset classes through this system. MARS system.
• Designing the Application by means of ER diagrams and Data Flow Diagrams.
• Carrying the project through the complete SDLC from design, development, testing and implementation.
• Development of Oracle Packages and Procedures. Developing generic flexible programs which are very responsive to change to requirements using metadata tables.
• Extensive use of Oracle Collections – PL/SQL Tables, Records, Nested Tables, Objects and REF CURSOR.
• Maintaining table partitions.

The Hague, South Holland, NL

• Transamerica Capital Management is a unit of Aegon Insurance and handles the annuity part of Aegon Business. They recently purchased Annuity business from Merrill Lynch worth 1.3 billion dollars. I Worked on Data.
• Made technical specification document and interacted with Business Analysts in gathering Business requirements.
• Worked extensively in developing Packages Procedures Functions utilizing Oracle PL/SQL
• Index analysis and Performance tuning of the application
• Used latest oracle features like Bulk Collect, PL/SQL Tables, Nested Collections.

New York, NY, US

• Lead Developer for the transaction processing of Brown Brothers Harriman’s Eagle Star Mutual Fund Accounting System. Reported to the SVP of IT and managed team of 2 full time developers and was responsible for in.
• Business Requirements Document review, scoping the project scheduling and monitoring. Also managed the risks associated with the Project.
• Process Modeling, Data modeling normalization/de normalization of tables using ERWIN and Visio.
• Resolved Production issues by interacting closely with business. Documented the processes and communicated the results effectively to the business.
• Performed Data Analysis and Data Quality checking
• Used PL/SQL Packages, Procedures, Functions, Table Functions, Views, Materialized views to implement the project.

Zurich, CH

Senior Lead Developer for Financial Online and Plan Admin Project.The division I worked for was Corporate Employee Financial Services division which was part of Wealth Management, UBS

New York, New York, US

Was part of a Legal - IT project for Pfizer Pharmaceuticals. Handled Legal Claims, Indemnity, Interface with law firms representing Pfizer across USA.Developed and maintained systems which handled hundreds of millions of dollars of payment to plaintiffs suffering from Asbestos related illnesses.

Murray Hill, NJ, US

Worked in Oracle Development Projects including Oracle Forms, Reports, Back end PL/SQL for Global Sales office of Lucent Microelectronics division.

Mumbai, Maharashtra, IN

Worked for National Stock Exchange Nationwide Clearing System.The system settled trades and generated deliveries for all the trades that took place from the trading system.NSE is the premier stock exchange in India handling millions of trades every day.

Mba, Howe School Of Technology - Technology Management

Ms, Howe School Of Technology Management - Information Systems

Bs, Electronics And Telecommunication Engineering

High School, Science Math