Summary
Overview
Work History
Education
Skills
Interests
Quote
Timeline
References
Generic

Jaspreet Singh

Programmer & Data Analyst
#283 GF, Sector-111 Mohali, Punjab (India)

Summary

An adaptable, and results-oriented programmer and applications developer bringing proven experience in core application and database development projects. Possesses innovative thinking and problem-solving skills to develop thorough analysis and logical solutions to complex problems. Able to demonstrate strong project focus combined with a commitment to achieving key objectives. Demonstrated initiative and planning skills, with the organizational and time management skills required in order to complete multiple assignments within demanding deadlines

Overview

12
12

Years of professional experience.

20
20

Plus projects.

Work History

Data Analyst

Vertisystem (HGV)
01.2019 - 08.2023

Projects:

  • Credit Simulation Tool/Tour Score: Intent of Tour Score is to provide member level assessment of repayment risk over range of potential sales scenarios in order to assign touring customer into buying box of maximum sales amount and minimum cash down payment. This helps managing default risk to acceptable level.
  • Credit Segmentation Framework for forecasting using different loan attributes. This helps selecting pool for securitization.
  • Data Analytics/Complex Data Engineering.
  • Loan Portfolio Losses Analysis.
  • Pre-qualification data set development using Equifax and Experian.
  • Delinquency Analysis.
  • Database Development.
  • Cashflows Analysis.
  • Customer Analysis.
  • Manage Complex requests for Business area.
  • Automation of several complex data requests/processes.
  • Created SSIS Packages & SSRS Reports and automated all the process.

Lead Programmer

Metrix Credit Technologies
06.2015 - 12.2018
  • Lead Developer for Asset Backed Securitization Deal Manager, Tool for Deal Modeling and Cashflow Analysis
  • Structure Types: Overcollateralization, Senior Sub and Portfolio.
  • Asset Types: Auto Loans, Mortgages, Lease, Time Share, Credit Cards, Student Loans.
  • Database Development
  • Statistical Analysis
  • SCUSA Portfolio Analysis
  • IRB Model for Santander Bank US
  • Diamond Static Pool Analysis
  • Designed Database Structure
  • Loans Performance
  • Defaults (Loss Curves)
  • Prepayments
  • Delinquency Analysis
  • Dynamic Cohorts
  • Customer Analysis

Software Engineer

Smart Soft Vision
03.2013 - 02.2016
  • KeewSoft Inc - Robert Martin
  • Lab Portal
  • This portal is developed for Fujifilm’s internal reporting management and was developed to use only for their employee’s, and it was hosted under their local area network.
  • Cruise Workup
  • This application was initially developed in Visual Basic, Complete application is converted from Visual Basic to VB.Net windows form application.
  • Lab Dashboard
  • This application is developed for Graphical user interface to represent various Bar Charts, Line Charts, Pie Charts for customer information, printing information etc.
  • Velocity (FC), David Bachman
  • cConnects.
  • This Application is developed for connecting the organization employs, Managing efficiency of organization, Call Scheduling, Person to Person Connections and lot more in this.
  • Copenco
  • This was based on Event Management for Borsten IT Company from Denmark
  • Saldio
  • Saldio was eCommerce Application for computer hardware related products
  • Felix and Rover
  • This application built for Vet’s Pet clinics and Drug Management. This includes following modules
  • Admin Portal
  • Vet Portal
  • Warehouse Portal
  • Mobile Site developed using jQuery Mobile framework
  • Interactive Defense System (Bright City)
  • This application is developed for City Administration and Municipal, there are several modules in this project like, Accident Report, Lockbox, Port Watch, Division Units etc.
  • Real Estate Commission (Scorecard Site)
  • This application is Real Estate Search Engine for US Taxes State. Users can search real estate agents and view their ratings etc.
  • Phone Gap Apps
  • Bright City
  • Citizen App
  • Admin App
  • Best Title Deal

Junior Software Developer

Ironroad India IT Pvt Ltd
11.2011 - 02.2013
  • VMS Play
  • Video Messaging Service - Allows users to share video content through their mobile phone in inexpensive and quick way. It facilitates video blogging, mobile video chat, exchanging of video SMS and much more.
  • VMS Live Statistics
  • VMS Play Live Statistics shows complete statistics for VMS Play Users, Video Messages, This processes very heavy data set and shows statistics to users.
  • Business VMS Play
  • This portal is developed for VMS Play Business (Enterprise Users)
  • VMS Play Mini
  • VMS Play Mini portal is for users, Users can login and send, view video messages
  • Merapati Airlines video Contest
  • This application developed for Video Contest for Merapati Airlines Indonesia, Where Users can send video messages to Merapati and User with best video will get the airline ticket offers.
  • Employee of the Month November-2012

Education

Master of Computer Applications -

Punjab Technical University, Jalandhar Punjab
05.2009 - 04.2012

Bachelor of Computer Applications - Computer Science

Guru Nanak Dev University Amritsar Punjab
05.2006 - 06.2009

Skills

Database Development, Data Analytics, Data Engineering

undefined

Interests

Cashflow Modeling of different Structure types ie Overcollateralization, Senior Sub, Credit Cards

Asset Types ie Auto, Mortgages, Lease, Time Share, Credit Cards (Revolving) 

Static Pool Analysis, Performed Prepayments, Defaults, Delinquency Analysis for Static Pool extensive large data sets

Portfolio Database Design, Developed Stored Procedures, Complex queries for Strats, Replines, Statistical Analysis

Dynamic cohort Analysis, Repline Analysis

Quote

Every problem is a gift—without problems we would not grow.
Tony Robbins

Timeline

Data Analyst

Vertisystem (HGV)
01.2019 - 08.2023

Lead Programmer

Metrix Credit Technologies
06.2015 - 12.2018

Software Engineer

Smart Soft Vision
03.2013 - 02.2016

Junior Software Developer

Ironroad India IT Pvt Ltd
11.2011 - 02.2013

Master of Computer Applications -

Punjab Technical University, Jalandhar Punjab
05.2009 - 04.2012

Bachelor of Computer Applications - Computer Science

Guru Nanak Dev University Amritsar Punjab
05.2006 - 06.2009

References

Jaspreet SinghProgrammer & Data Analyst