Gurmeet Kalsi
0019528355154 9810244321
7360 Gallagher dr, apt 228, Edina, MN USA 55435 Ph952 835 5154
Current Location: US
Title: / Software developer with 4 years experience in VB, SQL, ASP and .NETWork Experience: / 6 years
Skills: / .NET, VB, SQL, ASP, Oracle, PL/SQL, XML, client server, database programming, UML
Current Organization: / IBM
Previous Organization(s): / Polaris Software Labs
Industry: / Banking/ Financial Services,IT/ Computers Software
Highest Degree Held: / MBA/PGDM (Marketing) ,IPM Ghaziabad
Gender: / Male
Date of Birth: / 6th Feburary 1975
Current Annual Salary (Rs. in Lacs): / 6.0
Detailed Resume:
Contact Information
7360 Gallagher Drive, Apt-228
Edina, MN -55435
USA
Phone : +1-952-835-5154 (Resi.)
E-mail:
Gurmeet Singh Kalsi
Professional Summary
About 6+ years (20 Months .NET) of experience in the area of Client-Server
based application design and development using .Net, SQL Server 2000, COM+
using VB 6.0 and ASP.
1.5+ year onsite experience in USA.
Technical Summary
Technologies .NET Framework, COM+ Development
with VB 6.0,
Dimensional Modeling (Data Warehousing).
Hardware IBM-Pentium
Operating System Windows-2000 Server/Professional, Windows XP
Professional,
Windows-95, Windows-NT 4.0
GUI/Front-End VB.Net, Visual Basic 6.0
Languages C, C++.
RDBMS SQL Server 2000, Oracle 8.0
Internet Technologies .NET, ASP 2.0, XML, IIS 5.0
System Designing OOPS, UML, Rational Rose, Multi-Tier
Designing using MTS.
Tools Cognos 7.2, BO 6.0, Informatica 6.0 (Exposure
Only).
Education
B.Sc. (Electronics), Delhi University. 1993-
1996
MBA (Marketing) Institute of Productivity Management, Ghaziabad
1996-1999
2 Years Diploma from NIIT, New Delhi 1996-
1998
Microsoft Solution Developer (MCSD) Feb'
1999
Certificate course in Oracle from Oracle India Ltd.
Jan' 1999
(SQL Star International Ltd. New Delhi)
Corporate Trainings attended:
1. Dimensional modeling-Design and Architecture - IBM
2. Business Objects - IBM
3. UML using Rational Rose - Polaris Software Labs
4. .Net Architecture and Framework - Polaris Software Labs
5. Quality Management System (QMS) - Polaris Software Labs
Personal Details
Date of Birth 6th February 1975
Passport No. A-6845163 (valid till Dec' 2008) + H1 Visa
(Stamped), expiring Sept 2006.
Experience Summary
IBM Global Services, Gurgaon, India (Sept' 2003 - Till
Date)
IBM Global services cater the need of business solutions for domestic and
overseas market. CMM Level 5 company with a global existence and brand
name, I have worked on on-site projects at AMEX, New Delhi, Phoenix &
Minneapolis, USA
Designation Application Programmer
Polaris Software Labs Ltd. Gurgaon, India (Oct' 2002 -
Sept'2003)
World's 1st CMMi Level 5 Company and has renowned name in the financial and
banking sector. Polaris is one of the top 5 IT companies in India. I myself
as a software consultant, worked in finance related projects for GE
Capitals, India.
Designation Associate Consultant
Beehive Systems Ltd. Noida, India (April' 2001 -
Oct' 2002)
Ventured by Citibank in year 2001 is renounced among all the Television
Media for last ten years for its excellence in software and hardware and
has worked almost with all the TV channels running in India. The company is
solely into software development and is providing software support and
services to the media industry.
Designation Programmer
JCT Electronics Ltd. (Thapar Group), New Delhi, India (Aug' 2000 -
Apr' 2001)
Analyses, Designing and Development of front-end applications using VB 6.0
and SQL Server 7.0. Though the company is into the business of
manufacturing colour picture tubes but the IT department is mainly
concerned about the in-house development of software applications, testing
and implementing to the company's corporate office. The company has also
implemented SAP AG and was currently in the phase of implementing the R/3
System
Designation Programming Officer
Newgen Software Tech. Ltd. New Delhi, India (Dec' 1999 - Jul'
2000)
Development of drivers using VB 6.0 tools for image processing DLLs
developed by the company which contains processing of OMR images, barcodes,
MICRs and different file formats like tiff, targa, dcx, gif, jpeg, DIB etc.
Providing support to the team by developing the necessary drivers for their
respective functions. Testing and managing the release of functions to the
other groups
Designation Trainee (Programmer)
Nucleus Software Engg. Pvt Ltd. New Delhi , India (Jun'
1998 - Aug' 1998)
Well Renowned Company in the financial industry. Working as a trainee I
used to generate reports out of COBOL programs using PERL 5 (scripts) in NT
environment
Designation Trainee (Programmer)
Projects Undertaken
MoSes
Technologies Used : Informatica, BO, SQL Server
Team Size : 3
Client(s) : AMEX, Minneapolis, USA.
Role : Project Lead
This the current project I working on. The system caters the top
management. It is actually a data-mining application for which IBM has
proposed a solution to the client. My task here would be to work closely
with the business, to under stand system its behavior and future needs and
support. Finally a 24/7 support system would be rolled off and also a
development team which will in turn facilitate the enhancement of the
system.
Responsibilities
Requirement gathering and work as a SPOC for the business.
Enhance team size to cater the business.
Design and develop the support model for the system.
Understand the future development needs and provide efficient resources to
the team.
Expense Management System (XMS)
Technologies Used : VB.NET, SQL Server 2000, Cognos 7.2
Team Size : 4
Client(s) : AMEX, Phoenix, USA.
Role : Team Lead
Expense Management System (XMS) is a third party application used by Amex
employees through out in USA and Canada to manage official expenses
incurred upon their corporate cards and there after to have the report
approved and paid by the accounts payables depts.
The main responsibility of our team was design develop an application which
can pull data from live database on to the reporting database. A VB.NET
application was developed . The biggest challenge for these packages was
that the data was in huge number and efficiency was the primary motive as
the reporting database needs to be updated twice in a day.
In addition to this, our team was also responsible for the
complete support of the existing system and the new
developed system.
Responsibilities
Design and develop VB.NET application to transform data from Live SQL
Server to reporting server used by Cognos.
Completely support the XMS application.
Follow method 1 process as stated and implemented by AMEX.
MIS for Acquisition (MISA)
Technologies Used : VB.NET, SQL Server 2000, Cognos 7.2
Team Size : 3
Client(s) : AMEX, New Delhi, India
Role : Tech Lead
An opportunity/need exists within American Express to create a standard
platform across the JAPA(Far East) region to calculate the commission of
Agents based on the acquisition of engaged and active credit cards
customers and to provide reporting at various levels. The purpose of this
project is to create a flexible, parameter based technology solution to
calculate commissions based on the basis of new compensation structure and
create a central repository of commission information.
The main objectives that this project will help the business achieve are as
follows:
Provide auditable and compliant payment MIS platform for upfront card
related acquisition effort.
Maintain central repository of the above database.
Basis source code and Campaign Planning Tool (CPT) (once CPT is live),
calculate incentive/commission for various sales channels in APA market.
Produce standard report for the acquisition effort of sales channel for all
APA market.
Responsibilities
Development of front end application and server applications in VB.NET
Designing, development of Stored procedures in SQL 2000
Acquire coordination with other teams providing the raw data for the MISA.
Total Accounts Payable System (TAPS)
Technologies Used : VB 6.0, SQL Server 2000
Team Size : 3
Client(s) : AMEX, New Delhi, India
Role : Team member
The use of TAPS by the various functions can be defined as:
Raising Purchase Requisition /Purchase Order is done by local markets.
Vendors Payable team processes invoices
Cashiers processes miscellaneous invoices & releases the payment
MCU team does the budget planning & monitoring
The key system functions in the developed/developing system are as follows:
1. Creation and Maintenance of Control Database master entities.
2. Raising Purchase Requisitions (Normal & Marketing)
3. Online Approval of Purchase Requisitions as the defined business
rules.
4. Automatic mapping of Purchase requisition to Purchase Orders.
5. Issuing of Purchase Orders
6. Receive function.
7. Invoice Generation.
8. Complete writing of Reports using Excel Objects.
Comprehensive Application Usage Monitoring
Technologies Used : VB 6.0, ASP, COM+, SQL Server 2000, BO
5.1
Team Size : 4
Client(s) : GE Capital India Ltd.
Role : Team Member
The software gives detailed reports on each and every activity that the
users do on their desktop system in a networked environment.
The system would store / track the following data:
1) The time spent by the user on the applications.
2) The key logs for specified applications.
3) The break time of the user.
4) Total number of logins with timestamp.
5) Applications opened by the user during his usage of the workstation.
6) Total idle/break time of the user.
7) All keystrokes typed by the user in particular applications.
And Reports the following:
Productive / Idle Time spent by users on their PCs.
Time spent by users in different work areas.
Time spent by users in various applications and the work done therein.
The information so captured is to be uploaded to a central database server
from where various reports on user activities will be generated on
demand basis.
Fin Wizard Financial Graphic Automation System
Technologies Used : VB.NET, SQL Server 7.0, XML, ASP 2.0,
Java
Team Size : 8
Client(s) : CNBC India, TCS Singapore, Doordarshan-
India
Role : Tech Lead
The FinWizard is intended for broadcasters who want to display the latest
financial data from the stock markets. The FinWizard comprises four
different applications that are responsible for fetching, managing,
formatting and displaying different data on the Television. The key
advantage of this product is that it supports onscreen updates. This system
has a backend Bridge Feed module that continuously fetches live data from
the stock markets using the bridge feed and updates the database. The
second application in this system is the Query Terminal. The user can
select different types of graphics in this application and send it to be
displayed on the television. The actual display of graphics on Television
is done through the Playout System. There is another application called the
Playlist Server through which the data sent from the Query Terminal to the
Playout System is routed. The backend Bridge Feed module also routes the
data for onscreen updates via this module.
IsleWizard Automated Broadcast Graphic System (isle'Wiz)
Technologies Used : VB 6.0, SQL Server 7.0, XML, ASP 2.0
Team Size : 10
Client(s) : Aaj Tak (TV Today, India)
Role : Team Member
The isle' Wiz is a unique product for the broadcast industry that allows
the display of multiple streams of data simultaneously on the television
screen. The isle' Wiz is designed to allow Television and Cable
broadcasters, digital signage companies and hospitality channels to
communicate variable information and visuals from a single affordable pc.
The isle' Wiz graphic automation suite is intended to fulfill the graphic
requirement of any television channel. This system allows a broadcaster to
create and display any kind of graphic with dynamically changing content
without much effort. The broadcaster has complete control over the design
of the graphic templates as well as their position on the television
screen. The system also allows its users to connect to any database and
retrieve information from it
SMS GAME APPLICATION
Technologies Used : VB 6.0, SQL Server 7.0, ASP 2.0
Team Size : 4
Client(s) : Logon Asia Thailand
Role : Team Member
The basic functionality of the system was to display particular questions
on air and register users to its database on SQL Server. It system consist
for 3 applications, one of them acting as SMS receiver, second one a
program written on RTX MATROX card to generate output on TV and the third
one as ASP intranet site which was solely developed by myself. The web
application has a utilities like user registration, administrator module,
preferences settings, send SMS to a registered user, show, add, delete and
alter active questions to go on air, it can also specify the feel and look
of the output generated to the TV. It also had a very efficient and
advanced search engine to find a particular user and questions.
TWI TENNIS GRAPHICS
Technologies Used : VB 6.0, SQL Server 7.0
Team Size : 4
Client(s) : TWI India
Role : Tech Lead
The system provides user a very robust sort of environment for entering
tennis player's data and storing in into the database point wise during a
particular game. The system can also provide the user with analytical and
historical data of the games played. The system also contains a scoring
module which is developed keeping in mind the rules and regulations of the
sport. It also keeps track of all the games played during the tournament
and generates report for each player during the finals. The data henceforth
is displayed on air using RTX-Matrox card programming.
ACCOUNTS RECEIVABLES SYSTEM
Technologies Used : VB 6.0, SQL Server 7.0, Crystal Reports
Team Size : 3
Client(s) : JCT Electronics Ltd.
Role : Team Member
The Account Receivables System at JCTEL is a centralized collection of
function and requires consolidation of decentralized sales and invoicing at
the plants, to determine the final receivables at Head Office.
The system would perform ageing analysis - till date, month till date, year
till date, as also would post the details of each transaction in ledger.
The system starts by capturing the invoices as the entry point of all
analysis; the invoices can also be imported through the supplied .DBF files
which bypass the manual capture of sales data. For effective monitoring of
receivables. It also provides - capture of transactions, capture of Letter
of Credit, preparation of Bill of Exchange and its discounting bank,
discounting and collections, managing account ledgers, general ledgers and
sub ledgers, online reporting and receivable ageing, reporting of write
offs and bad debts. All necessary MIS reports are developed using Crystal
Reports. The application is designed for multi-user environment and applies
effective user management features.
IMAGE VIEWER APPLICATION
Technologies Used : VB 6.0
Team Size : 1
Client(s) : Newgen Software Technologies Ltd.
Role : Trainee Programmer.
This driver is basically responsible for using DLLs containing the set of
image processing functions and required constant amendments. It included
generation and decode of barcodes (USS39, EAN8, CODABAR etc.), it provided
a driver for OMR forms, MICRs etc. It also allowed resizing rotating,
detect skew in an image. TIFF files can be viewed page by page, a new page
can be inserted into an existing TIFF file, can also be deleted. Image
files can be converted from one file format to another.
Date: Thursday, December 22, 2005
Place: Minneapolis, USA
Gurmeet Singh Kalsi
Resume of Gurmeet KalsiPage 1