Pallab Gupta

About Me

Over twenty years of rigorous experience as System Architect and developer in the Financial Services, Multi-Media, and communications applications. Thorough in .NET, Visual Basic/MS Access/Visual Interdev, SQL Server, MySQL and Oracle environments. Strong in server based development using stored procedures and triggers. Sound foundation in Windows architecture and systems programming. Conversant with relational database design methodologies and tools. Work experience involves extensive development in all aspects of the software development cycle. Excellent team and communication skills.

Resume created on DoYouBuzz

Experiences

Currently working on back-end data management and front-end development for meeting management services. Back-end jobs include complex stored procedures, scheduled jobs, remoting services using .NET. Front end development includes ASP.NET and Windows Forms development for complex management utilities, downloadable reports. Business tier development includes implementation of rules, process flows and business logic for data presentation, extraction and uploads from various sources.
Created .NET remoting services for background web service calls. Also created windows services for background jobs.
Implemented ASP.NET AJAX libraries and jQuery. Implemented Google Maps to show custom data.
Created dashboard with combination of ASP.NET Ajax and jQuery. Created webmethods to supply data to the Ajax calls.
Created .NET remoting services for background web service calls. Also created windows services for background jobs.
Implemented ASP.NET AJAX libraries and jQuery. Implemented Google Maps to show custom data.
Created dashboard with combination of ASP.NET Ajax and jQuery. Created webmethods to supply data to the Ajax calls
Created LRS using MongoDb and TinCanAPI

Worked on GIS systems and Windows Mobile apps.

Learn more

Worked in a team to create a client facing healthcare related website in ASP.NET

Learn more

Developed complex procedures in SQL Server for MS Word merge, XML data input, bulk uploads.

Created complex reports to drive Excel. Created websites for clients of MediVia in ASP.NET/C#. These web sites use authentication and enable clients to check their program statuses. The clients can download programs as Outlook Calendar events and Excel spreadsheets that are dynamically generated. Created complete Admin modules for website for MediVia to update and enter documents, data etc. non-programatically. Created user components and used AJAX for non-postback updates. Used Web Services for geo-coding data along with AJAX calls for auto populating forms. Created mail/fax queue to work with Exchange and GFI Faxmaker. Used MapQuest/Google Maps API to show locations on Web Page. Extensive use of DataSets, DataGrids, Enterprise Libraries for Data and Security. Created procs for Zip/Radius search from Census data.
Created SQL Documentor in C#. This application is used to call SQL Server objects and put an XML header about the object. This includes description, notes, creator, parameters etc. Once this is done, the Documentor produces a MSDN style help for each object and also creates files that can be compiled by the Microsoft Help Workshop to a standard .CHM help file. Thus a complete standalone object documentation for the code can be made available.

I was a volunteer consultant for this project.
Created a newsletter website (http://www.theroadreport.org) for Delta Ministries International, a non-profit organization. Delta wanted to be able to create and distribute e-newsletters in a simple way. The objective was that they should be able to create newsletters without knowing any HTML or any code. I created a complete admin portion for them where they could create a newsletter and type or copy/paste articles with pictures. Each article is one entry and a group of articles makes one newsletter. They can also create user lists and newsletter groups. Once a newsletter has to be sent out, all that they have to do is select the recipients as groups and/or individuals and click a button. As per their request, the e-newsletter is a condensed version of the online version with "Read More" links. The newsletter goes out in a MIME-encoded format so that the recepients can read the newsletter offline with all graphics intact. The website is up and running and so far has sent out newsletters to thousands of recipients. When a user clicks the "Read More", he gets into the site directly to the newsletter he wants to read. This process also creates a "Click-back" trigger that shows how many people actually read the newsletter as a result of the email and not by directly coming to the site. All online newsletters are created dynamically and the whole process is very fast. Admin users also get statistics and flash pie-graphs.

Also helped set-up a complete DotNetNuke (DNN) site with multiple modules at http://www.thenextmile.org.

Involved in creating stored procedures and views in SQL Server 2000. Also involved in complete project architecture / timeline creation. The views are to be mostly used by MS Word documents for mail merge. These documents are used in the Healthcare industry for event management. They are sent to event speakers/attendees at various stages of an event/conference. The Word documents are dynamically mailmerged. Created over 60 stored procs/views. Also working on data synchronization between 4D and SQL Server. Created DTS scripts. Created C# utilities for batch processing and interactive work. These utilities use ADO.NET.

Learn more

Developed a store/portal based on the IBuySpy skeleton (http://www.structuredcommerce.com/). Wrote my own Flash custom control and also developed RichTextBox custom control. Work included integration with PayPal, Froogle and future work entails making it a hierarchical category site. Working extensively with Server side controls, SQLClient and back-end SQL Server stored procs. Use of both code-behind and on-page coding.

Learn more

Was involved in creating stored procedures and views in SQL Server 2000. Created over 90 stored procs/views. Designed MS Access reports which use many of the above stored procs/views. However most of the above views are used by MS Word documents for mail merge.

Learn more

Created interactive voice applications. The applications were written in VoiceXML (VXML) on the Ascentel platform (check What's new and Voice Solutions on www.ascent-inc.com for details on Ascentel platform). Ascentel platform integrates TTS, ASR, VXML and telephony to create voice enabled applications. ASP was used to create the dynamic VXML pages and SQL Server 2000 is used for the back-end database. Wrote stored procedures on SQL.

Learn more

Wrote server side executables to work with Barra/Aegis Objects. This is to create executables to run daily as batch processes. They are used to process benchmarks, process portfolios, optimize portfolios, make split adjustments, generate and aggregate trade lists etc. These batch processes run with parameters and make ADT calls. They save the data in Oracle/Barra /Excel.
Here the VB applications are either GUI based or back end processes. For the GUI based application, settings can be retrieved and stored for future runs. Extensive error handling and error logging is built in to pinpoint problems. For the command line utilities, command line parameters define the execution. Other fairly static parameters are stored in profiles. Again extensive error handling and logging has been implemented.Microsoft Scripting has been used when expression evaluation is required.

Learn more

Designed and developed a Intranet solution for Global Broking Tracking System. This system is used to obtain premium flow to carriers. It is useful to the business placed by Marsh in terms of being able to provide benchmarking information about the business placed by Marsh and to provide a method of tracking performance of GB employees as well as the groups/companies with which Marsh did business. It can also track mid-term changes to policies.
As the Lead Architect, my responsibility was in designing the system. The system implements ASPs written in Visual Interdev 6.0. The business logic and data access objects are handled by a COM middleware written in Visual Basic 6.0. Some amount of presentation layer logic is also written as COM objects to speed up lengthy executions. This middleware provides specific objects, properties and methods to be used by the ASPs and is run through the Microsoft Transaction Server which takes care of connection pooling to efficiently use limited number of connections.
I have also done a fair amount of IIS administration for this project. I have set up the complete web site, created packages for the COM middleware and set up identity/transaction support for the package/components.
Remote Scripting and DHTML have been widely used to optimize user interaction. Login security is enforced to prevent unauthorized users to either login or view/change information at different levels of the system. The web system is run on IIS 4.0/NT and the backend is Oracle 7.3/Unix. Some reporting has been designed for MS-Word in which the data is brought into a macro from an ASP through XML. Then it is put in a DOM and used to populate the Word document.
On the back end, wrote stored procedures which were called by the middle tier and also ran as batch processes every night to take care of expiring policies.
A separate SQL Server system was also used for testing purposes to check the feasibility of changing the database to SQL Server from Oracle. COM+ has been used on this test platform with the intention of migrating the project to Win2K.

Learn more

Designed and developed Millenium Order Tracking System. The existing legacy system was being converted to a C/S architecture. The system had to track all orders for making existing H/W and S/W millenium compliant. The back end resides on ORACLE 7.3. The front end was designed using Visual Basic 5.0. Stored procedures have been written and are being used.The same system was also parallely devloped for the Intranet using Active Server Pages which involves designing ActiveX DLLs and use of ADO. The design was done using Visual Interdev 5.0.

Learn more

Developed a complete web site in Active Server Pages for Hotlist of available consultants. The consultant data is kept in a SQL Server database and a front end designed in Visual Basic lets the company simply enter the data of a consultant and his availability. The Active Server Page gives a list of available skills. When a user checks of the skills wanted, another page dynamically created gives the list of all available consultants at that point of time having one or many of the selected skill sets. Also the name of each consultant becomes a hyperlink for the resume of that consultant.

Learn more

Senior Developer

Bell Atlantic (formerly NYNEX)

December 1996 to March 1998

Consultant

New York

United States - New York

Involved in the migration of the billing system from Legacy to the Client/Server environment using Visual Basic 5.0 / 4.0 and MS Access 2.0. The design was modified and enhanced to incorporate the new business rules in the system. The data sent as text files from the legacy system is extracted and converted to MS Access tables by a VB routine. The complex billing algorithm was designed depending on the state, region and individual service options. The front end was designed using Visual Basic to look up each account details. A separate revenue table is created in the billing process which is used for reports. History tables are also generated for client side lookup of individual accounts.

The same application has now been developed using Oracle 8.0/7.3 database with VB. The Oracle Objects for OLE are being used instead of JET engine/ODBC. Stored procedures are being used for common processes. A dynamic script is run by SQLLoader from within VB to convert the text files from the legacy system to Oracle tables. The process and error logging is done through SQLLoader as files which are mailed to the administrator on a daily basis. Unlike Access 2.0 here the calculated data is kept in the database and so the front-end has been simplified to look up the data and not recalculate and so it is much faster. The billing procedure is done every night automatically by using the NT task scheduler.

Learn more

Involved in the design and development of an integrated resource management system to provide resource tracking, personnel, and financial planning information. The system architecture comprises of a Visual Basic 4.0 front-end and MS ACCESS 7 running on Windows NT. Responsible for user information needs, screen and interaction design, and server logic development. Other responsibilities included development of Home Page.

Learn more

Various

Learn more

Skills

SQL Server
MySql
Oracle
MongoDb

.NET 2.0/3.0/3.5/4.0
Microsoft Visual Earth
Google Maps
VS.NET
Sql Server Reporting Services
Windows Mobile
Other js libraries
TinCan API

ASP.NET
MVC
AJAX
jQuery
Knockout
Twitter Bootstrap
CSS
Javascript

Education

Electronics and Communications Engineering, Computer Science

Learn more

Physics, Chemistry, Logic, Mathematics, English

Learn more

Your browser is outdated!

Director Of Development Services

Director of Development Services

Senior Developer

Developer

Developer

Consultant

Senior Consultant

Senior Consultant

Consultant

Senior Consultant

Consultant

Lead Architect

Senior Developer

Senior Consultant

Senior Developer

Senior Consultant

Various

Travel

Database

Other

Websites

BE

Birla Institute of Technology

Intermediate of Science

St. Xavier's College, Ranchi

High School

St. Xavier's School, Doranda