DILBAGH S GILL
Tel: (952) 564-4965 (Cell)
dilbaghsinghgill@gmail.com
EXPERIENCE SUMMARY
Over
17 years of experience in software application development, IT Project
Management & Database Administration this includes Mortgage Banking, manufacturing,
insurance, distribution, security industries, plenty of experience in database migration/conversion
projects. Consultant is especially skilled in ASP.NET, C#, MVC, Progress, WebSpeed
and has very good knowledge of JavaScript, HTML, Microsoft SQL Server, UNIX/Linux,
Windows and Novell.
SOFTWARE
EXPERIENCE
Development Tools
Progress OpenEdge, App Builder WebSpeed
3.1x, Eclipse with CVS
Progress 4GL, ABL, SONIC MQ C#,
AST.NET, Visual Studio 2010
JavaScript, and HTML, jQuery PHP/MySQL,
SONIC ESB
MS-ACCESS, MVC, MVC3 Progress
Openclient Technology
RDBMS
PROGESS 6.0, 8.2, 9.1x, OpenEdge 10.x, ORACLE 8.X,
MS-SQL Server
Internet Tools and other utilities
Netscape Enterprise Server 2.0, 3.6 Apache
Web Server
IIS, JDK MS-Office
Operating Systems
Windows 95, NT, 2000, 2003,
SCO UnixWare 7.1 UNISYS
UNIX Release 4.0
IRIX, AIX 4.3.2 MS-DOS
Redhat Enterprise Linux
Networking and Communication
Good knowledge of configuring TCP/IP networks
HARDWARE
EXPERIENCE
Intel
based PCs and servers
Silicon Graphics (Indy and Challenge)
IBM RS6000
Ethernet networking products.
INDUSTRY
EXPERIENCE
Mortgage
Banking, Insurance, Manufacturing, Distribution, Supply Chain, E-commerce
Applications
ACADEMIC
QUALIFICATIONS
4
Year Bachelor Degree of Engineering in Computer Science and Technology
EXPERIENCE DETAILS
Company: Quicken Loans, Detroit, MI
Period: February 2010 - Present
Role: Sr.
Software Engineer
Application: Loan
Origination, Lead Allocation System (LOLA)
Description: LOLA
is a web based Loan Origination and Lead Allocation Mortgage banking software
which allows Quicken Loans to Allocate leads based on banker state licensing,
banker team association and other factors on a given lead. LOLA has a fully
integrated incoming call router, outgoing call dialer which allows mortgage
bankers to dial automatically. Some of features of the system are:
· Web based user
interface.
· Loan Origination
· Lead Allocation
Engine.
· Incoming Call
Router based on banker state licensing and other business rules.
· Custom Phone
dialer which gets feed from banker lead pipeline.
· Integration with
Loan underwriting software.
· Fully integrated all
three credit reporting agencies.
· Fully integrated
document management system (completely paperless).
· Use of web
services and SONIC MQ for integration with other systems
· Customized Data
Exports & Imports.
My
Responsibilities:
· Working with
Business Leaders to gather Business Specifications.
· Enhancements to Incoming
Call Router.
· Enhancements to
Lead Prioritization Engine.
· Enhancements to
Lead Allocation Engine
· Integration of
MISMO XML standard services with LOLA.
· Documentation,
Preparing Tutorials.
· Supporting
end-users for their day-to-day needs (Over 1500 users).
· Dealing with team
mates on version control & other programming issues.
Software
Used: ASP.NET C#, MVC, MS-SQL Server, IIS,
Progress 10.1B, Webspeed, JavaScript, Java, HTML, AIX, Redhat Linux and Progress
App Server, Apache Web Server, SONIC MQ and ESB.
Company: 3i Infotech Inc. (formerly Corban
Systems, Inc), Eden Prairie, MN USA
Period: Jan-2000 – Jan 2001, Jul-2001 – February 2010
Role: Project/Product
Manager.
Application: Premia Lite
Description: Premia
Lite is a web extension of regular Agentaid system. Premia Lite is specially
designed for insurance companies in order to provide online quotes and manage
retail broker/agency accounts. With help of this tool insurance
companies/general agents can design their own web pages for any line of
business without having any programming knowledge. Agentaid is a complete
insurance management system. Some of features of the system are:
· Webspeed based
user interface.
· Policy Rating
Engine for P&C, Medical Mal Practice, Other Health Insurance Products
· Deliver filled
quote, application, and certificates in Adobe Acrobat format on the fly.
· Retail
Broker/agency level security.
· Handle claim
information delivery.
· Policy processing.
· Fully integrated
accounting system
· Fully integrated
document management system (completely paperless).
· Customized Data Exports
& Imports.
My
Responsibilities:
· Project Management
and Product Management
· Programming and
managing Premia Lite.
· Customizing core
product for new customers.
· Database
Administration, Design and fine tuning for over 15 clients. Database
backup/recovery.
· Dealing with new
clients for collecting specifications, Business Process Study.
· Documentation,
Preparing Tutorials.
· Maintaining
existing system.
· Supporting end-users
for their day-to-day needs (Over 15 clients with over 1000 users).
· Dealing with team
mates on version control & other programming issues.
Software
Used: ASP.NET C#, MS-SQL Server, IIS, Webspeed
3.0, Progress 8.2 – 10.1B, JavaScript, Java, HTML, SCO UnixWare 7.1, Redhat
Linux and Progress App Server, Apache Web Server.
Hardware: Gateway
ALR 8200 Server, PC-X86
Company: Barvepoint, Norcross, GA USA
Period: Jan-2001 – Jul-2001
Role: e-Business
Solutions Consultant.
Application: Webpro EX / MFG PRO
Description: Webpro
EX completely and seamlessly integrates ERP or Progress based application
functions online. By leveraging existing business logic and establishing a
native connection to existing databases, Webpro EX speeds implementation and
ensures compatibility with existing system. Some of features of the Webpro EX
are:
· Future-proof
design separating business logic and user interface.
· Reporting: Creates
reports directly from the browser and provides real-time access to order status,
inventory, credit history, item search, order entry, A/R status, etc.
· Order Templates:
Customers can reuse previous orders to expedite the order entry process.
· External
administration: Lets customers set up and change their own user ids and passwords.
· Style Sheets:
Enables easy customization of user interface.
· Layered
architecture: Allows to make changes without modifying original source code and
to add functionality while maintaining a style consistent with Web site.
Software
Used: Webspeed 3.x, Progress 9.1, JavaScript,
HTML, Linux 6.x and Apache Web Server.
Hardware: Intel
Based Server, Dell PC.
Company: Geotech Systems,
Inc.
Period: 8
Months (08-Feb-99 to 25-Sep-99).
Role: Analyst
Programmer/Project Leader.
Development & maintenance of
different modules, database administration and taking specifications from
client.
Application: OnGuard
Client:
Innertec Security,
Vancouver.
Description: A fully integrated
scheduling, billing, payroll and accounts receivable application with modules
for a complete mission-critical solution. OnGuard allows users to
schedule shift-employees, bill the services of these employees, generate
payroll information for the employees and manage accounts receivables. Some of the features of the system are:
· Client maintenance,
· Post maintenance
· Employee/guard maintenance
· Scheduling of guards at requested
client locations. It allows open scheduling which later can be fixed and
check-in sheets are prepared on that basis
· Billing of clients. Different type of
invoices i.e. Service Invoices, Misc. Invoices, Recurring Invoices, and
Pre-Bill Invoices. Accounts Receivable
· Time cards of guards containing the
amount they are liable to be paid by the company can be generated too taking
care of OT (overtime, holiday).
Software
Used: Progress 8.3, Webspeed, HTML,
JavaScript, AIX 4.3.2, Power tools.
Hardware: RISC
RS 6000, PC-X86
Company: Federation of
Indian Chambers of Commerce & Industry,
Period:
6 months (Aug-98 to 04-Feb-99)
Application:
FICCI-ACCOUNTING SYSTEM.
Description: This
application has been developed to automate the accounts department of FICCI.
Manages tasks such as voucher entry, balance sheet generation and profit and
loss report generation. This package also includes payroll and inventory
control modules. The application has capability to generate reports based on
user queries such as generation of annual account reports, information on
employee salaries and inventory status.
Role: Team
Leader. The responsibilities were to lead a team of developers in the following
tasks:
· Design and development of database structure
· Design and development network
compatible data entry modules
· Design and Development Data Entry
Modules
· Design of Reports having various
queries options
· Worked for Database Administration
(i.e. Fine tuning of database, Crash Recovery, Database Backup, Code
Optimization, Designing tables, indexes & Constraints. Configuring Database
as Windows NT Service, Setup clients for Databases.).
Necessary consultations were done with
the accounts department in order to develop the application as per the exact
requirements of the department and also in order to make the application user
friendly.
Software:
Progress 8.2 (Progress
Provision), Windows NT Server 4, and Windows 95
Hardware: IBM 325 server, Compaq DeskPro PC
Company: Federation of Indian Chambers of Commerce
& Industry, New Delhi, INDIA
Period:
May-96 to August-98
Application: BUSINESS INFORMATION SERVICE NETWORK
(BISNET)
Description: Design
and development of a database, data entry applications and retrieval
applications for a several websites for FICCI, SAARC and other commerce chamber
associations. http://www.ficci.com
Role: Team
Leader
· Worked for Database Administration
(i.e. Fine tuning of database, Crash Recovery, Database Backup, Code
Optimization, Designing tables, indexes & Constraints, Import & Export
data from and to other databases like ORACLE, MS-ACCESS, dBase. Used ORACLE
& MS-ACCESS as DataServer. Configuring Database as Windows NT Service,
Setup clients for Databases.). Worked for Administration of Webspeed
Transaction Server. Configuring Webspeed Brokers as Windows NT Service.
· Designed and developed database
structure, client server application BISNET using Progress App Builder,
Procedure Editor and data dictionary for Windows NT 4.0 platform.
· Developed data retrieval using Progress
App Builder for Windows NT 4.0 platform. These modules have queries based
report generation options.
· Developed Web Objects (WebSpeed
Programs) for generation of dynamic web pages Webspeed workshop as front-end
tool. These Web Objects have user friendly database search options.
· Developed database conversion applications
for converting database from Progress 6.0 for Unisys UNIX release 4.0 to
Progress 8.2 for Windows NT 4.0 platform. Consultant wrote scripts using client
side and server side JavaScript as well as Java applets.
· Team lead for developing HTML, JavaScript’s
and other work related to web projects. Also developed modules using 4GL for
web site security.
Software: Progress 6.0 and 8.2, WebSpeed 2.1,
JavaScript, HTML, JAVA, Netscape Enterprise Server 2.0 and LiveWire 1.0,
Windows NT Server 4, Windows 95 and Unisys UNIX release 4.0.
Hardware:
IBM 325 server, Compaq Deskpro
PCs.
Company: Infotecnics India Pvt. Ltd., New Delhi,
INDIA
Period: 6
months (Dec-95 to May-96)
Project: DATA BASE CONVERSION PROJECT
Description: Database Conversion from INGRES to ORACLE.
Role: Programmer
· Creation of database in ORACLE 6.0 for
IRIX using PL/SQL procedures
· Written Control files (ctl files) &
PL/SQL 1.0 procedures to import data from delimited text file created from
INGRES database. Used SQL Loader for loading data from fixed length delimited
text file
· Development of data entry forms using
Form 3.0, Also developed same forms using Developer 2000 (Oracle 7.0, Forms 4.5
and Oracle reports)
· Design of reports using Oracle Report
Writer 1.0
Software: Oracle
6.0 & 7.0, Forms 3.0, Report Writer 1.0, PL/SQL and Developer 2000.
IRIX, Windows 95.
Hardware: Silicon Graphics Indy and Challenge and Compaq DeskPro PCs.
Company: Infotecnics India Pvt. Ltd., New Delhi,
INDIA
Period:
6 months (28-May-95 To
Nov-95)
Application: IIPL-INVOICING SYSTEM.
Description: Design
and Development of Database, Data Entry Modules, Reports having various queries
options, Keep track of company’s Sale & Purchase, Tax paid, Margin
Analysis.
Role: Programmer.
· Designed and developed database
structure and network compatible data entry modules using FoxPro for Windows
2.6. This package includes invoice entry
and generation modules, inventory control module, reports and queries. This
package utilized Screen Builder, Report Wizards using SQL for customization.
· Keep track of company's Sale &
Purchase, Tax paid, and Margin Analysis. Generation of Invoices, Purchase
Orders, Reports for inventory status, Accounts Receivable
Software:
FoxPro for Windows 2.6,
Windows NT Server 4, Windows 95, and Novell NetWare 4.11
Hardware: Compaq Proliant server, Compaq Deskpro PCs.