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, Vista                                                   Novell NetWare                      

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. Vancouver, BC CANADA

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, New Delhi, INDIA

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.