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. Dilbagh S Gill Page: 2 of 2 Dilbagh S Gill Page: 1 of 1 Dilbagh S Gill Page: of 6 Dilbagh S Gill Page: 5 of 5