OS: DOS 6.2, Windows for Workgroups 3.11, Windows 95/98, Windows NT4.0

Languages: C, PASCAL, SQL, HTML, XML

DB: MS Access1.1, MS SQL Server6.5/7.0, Sybase 10, Oracle 7.3/8.0, & Faircom C-tree based ISAM Server

GUI: Visual Basic 3.0 / 4.0 / 5.0 / 6.0

Internet: IIS3.0/4.0, MTS1.0/2.0, MSMQ, MS Visual Interdev1.0/6.0, VBScript, Jscript, IE3.02/4.0, Netscape

Reporting Tools: Crystal Reports 5.0/7.0

Modelling Tools: Visual Modeller, Rational Rose

B. Tech (Computer Science & Engineering), MIT Manipal, India

Working towards a MCP Certification.

[1] Presented talks in Nucleus on: "Smart Cards", "Component Technology"

[2] Microsoft Sitebuilder Level2 Membership.

[3] Conferences attended:

• MS Web App. Developers Conference (at Scope Complex, New Delhi, Sep'97)
• MS Developer Days Conference (at Taj Residency, New Delhi, Apr'97)
• MS Professional Developers Conference (at Taj Palace, Bangalore, Feb'97)

Project Overview: The internet website was designed to improve the business processes in the Logistics/Warehousing industry.

• Suggesting MS platform architecture & environments suited to MS Technologies.
• Providing/Mentoring technical knowledge (MS Internet Technologies).
• Installation & Configuration of NT/IIS/MTS/VSS servers.
• Requirements gathering, Object Modelling, Code Standards & Templates for ASP & VB.

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, IIS4.0, MTS6.0, IE4.0/5.0, HTML, JScript, VBScript, Visual Basic6.0, Visual InterDev6.0, MS SQL SERVER7.0, VSS6.0 & APEX SCANNER

Project Overview: The Lucent Technologies E-Commerce Services website hosts the Invoicing System, Quotes System, Order Services, SBC Wireless Bulletin Board . The purpose of the Invoicing System is to allow Customer’s of Lucent to make payments/disputes online for any Products purchased.

Technical Overview: The "InvoiceLoad" program (as the name suggests, loads the invoices sent from the Mainframes in the form of Pipe-delimited / EDI format Input Files, onto the MS SQL Server) with certain customizations. The MTS Components (ActiveX Objects) developed in VB6.0 are installed to run on the Microsoft Transaction Server (MTS2.0). The web pages are developed using ASP technology using ActiveX Scripting (VBScript on the Server-side & Jscript on the Client-side) which calls the MTS components to provide the desired behavior. The hardcopy format of the Invoices are generated in the browser using Crystal Reports which the Customer can use to print a pre-formatted hardcopy

• Suggesting MS platform architecture & environments suited to MS Technologies.
• Studying (& subsequent implementation of) the requirements of the "PayIt Button" E-Commerce Internet Application based on the "Payment Server/Gateway" software implemented by ‘a bank’.
• Development of "InvoiceLoad", "Quotes Services" program & implementing subsequent enhancements on the various environments (Development/Migration/Production). Contacting the various Customer Team Contacts of Lucent branches across the US, for any issues related to the input files (Invoices) being sent every day, resolution of subsequent failures at the time of loading, if any.
• Maintaining & subsequent enhancement of SBC Wireless Bulletin Board Service.
• Responsible for any Production issues at the time of interruption on the Production environment.
• Providing/Mentoring technical knowledge (MS Technologies).

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, IIS4.0, MTS2.0, IE4.0/5.0, HTML, JScript, VBScript, Visual Basic6.0, Visual InterDev6.0, MS SQL SERVER6.5/7.0, XML, NetMeeting, Crystal Reports 7.0

Project Overview: The prototype called "Cold Extraction" was developed for a product being offered by VSoft Corporation. The Product was intended to shorten the duration required for searching large reports generated by Banking firms (Central Carolina Bank, CCB), for transactions pertaining to Customers across all their branches, by taking snapshots of the keyfields (already maintained for each Report) from the Mainframes onto the Oracle DB. The product was aimed at providing faster Online access to a Customer’s request (pertaining to transactions etc.) over the Internet, by the internal customers across all the branches.

• Understanding the requirement specifications of the Product & suggesting appropriate interfaces, related to the design of the Product.
• Development of the entire interface over the Internet, using VB6.0, ASP.
• Providing technical knowledge (MS Technologies, Security etc.) for subsequent development of their product.

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, Windows98, IIS4.0, IE/4.0, HTML, VBScript, Visual Basic6.0, Visual InterDev6.0, VisualC++6.0, Jukebox & Oracle8.0

Project Overview: The MTMS was produced in 1985 and was widely implemented in Citibank. It is to be found in over 1000 customer sites, supporting a great variety of banking applications. The original DOS implementation was outdated & as a result Citibank had decided to re-implement MTMS on a "Win32" (Win95 & NT40 or above) environment. The objective was to re-implement the facilities that have been essential to the CEEMEA electronic banking (TI) strategy, making them available in the modern environment. These were:

• Rapid Application Development
• The ability to completely validate transactions at the customer’s site
• An environment providing the facilities needed for the customer to manage his transactions in a convenient & secure fashion.

• Development of SDT
• Development of User Role Maintenance & User Role Matrix
• Development of ‘SpreadFind’ ActiveX Control.
• Design & Development of Product Setup & Installation
• Development of System Installation which comprised of Server Install, Local Client Install (LAN) & Remote Client Install (WAN)
• Evaluation of InstallShield Software (as it was not possible to automate the installation process using InstallShield), installation software was than developed in VB as things like Static/Dynamic Updates were required to be done during the Installation process.

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, Windows95,Visual SourceSafe5.0, Visual Basic5.0, C-Tree based ISAM DB server

Project Overview: The smart card prototype was developed to demonstrate the ability to do E-Commerce on the Net.

Technical Overview: It involved the development of ActiveX Components & ActiveX Controls which provided the required integration of the Smart Card & the Internet technology. The prototype was also integrated with existing Internet (E-Commerce) applications in order to demonstrate the dual access of certain sensitive & personalized information via normal login process as well as using the Smart Card in a secure manner. The Smart Card stored the personal information of the card holder, transaction log, balance amount etc. among other things..

• Development of ActiveX controls & ActiveX components using COM/DCOM
• Leveraging technology information for Smart Cards from Schlumberger, India.

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, Windows95, IIS3.0/4.0, IE3.0/4.0, HTML, VBScript, Visual Basic5.0, Visual InterDev1.0, SCR60 Card Reader, PayFlex cards.

Project Overview: The state of the art Intranet System was developed for the purpose of providing Online access (Univ. Information) to the top executives of the University, over the Intranet.

Technical Overview: The components (of the various modules) used RDO2.0 to connect to the MSSQL DB, wheras the ASPs used ADODB to connect to the MSSQL DB. The Intranet System had an advanced Security Management System (SMS), more or less similar to the NT40 OS, plus some additional features, specific to the requirements. This component was tested to run on MS Transaction Server (MTS1.0). The major features incorporated in the SMS were:

• De-centralized Security System – Each Module (Department) in the SUT Online had it’s own Administrator.
• Broadcasting System – The User of the Administrator group could broadcast messages to any/all the User’s currently logged in to the SUT Online.
• User Profile Maintenance – Among other things it also stored whether the User had restricted login access from a specified range of IP addresses. A User could belong to multiple modules although each would have a Primary Module associated with it. The Admin of the Primary Module was in charge of the User’s Account.
• Group’s Maintenance – Groups created in each Module.
• Functions Maintenance – Each function mapped to a specific resource (Link/Button/ in the SUT Online for which Access Rights would be required in order to access the functionality provided by it.
• User Function matrix – stored information regarding each User’s Access Rights to the various Functions in the Module.
• User Group Matrix – facility to map User’s to each Group of the corresponding Module.
• User / Database password change
• Audit Log information & other Reports.

• Identifying Actors & Use Cases
• Developing the Use Case Model & Design Model (using Rational Objectory Process 4.1).
• Component Based Development (CBD) of SMS as a REUSABLE COM/DCOM Component, to be used across Projects.
• Providing Code Templates for CBD in VB for the remaining Components in the Project.
• Integration of the Intranet System

Hardware: IBM-PCS AND COMPATIBLES

Software: NT4.0, Windows95, IIS3.0/4.0, MTS1.0, VSS5.0, IE3.0/4.0, Netscape, HTML, JScript, VBScript, VB5.0, Visual InterDev1.0, CrystalReports5.0, MS SQL Server & Rational Rose.

Project Overview: The state of the art Intranet System was developed for the purpose of providing Online Access to the entire Universities information, over the Internet. The various Departments in this University were the Student Services, Personnel, Finance, Administration, Stock, Research & Academics, Public Relations, Policy and Planning and Foreign Relations.

Technical Overview: Rational Rose case tool was used to design the system. The components used RD02.0 to connect to the Oracle DB, whereas the ASP’s used ADODB to connect to the Oracle DB. The Intranet System was also incorporated with a C2 Level conformance Security Management System (SMS). This component was developed to run on the MS Transaction Server (MTS1.0).

• Identifying Actors & Use Cases
• Developing the Use Case Model & Design Model (using Rational Objectory Process 4.1), for 5 out of the 9 Modules (Components).
• Installation & Management of the NT40 / IIS30 / MTS10 Development Server
• Development (CBD) of Personnel & SMS as COM/DCOM components
• Evaluation of the Visual Studio suite of tools, specifically Visual Interdev Client & Server (Beta Version) & Visual Basic 5.0
• Integration of the Intranet System

Hardware: ibm-pcs and compatibles

Software: NT4.0, Win98, IIS3.0, MTS1.0, VSS5.0, IE3.0, Netscape, HTML, VBScript, VB5.0, Visual InterDev1.0, CrystalReports5.0, SQLplus, Oracle7.3 & Rational Rose.

• Development & Integration of (OTS & SLG) modules.
• Intergration of M/S Word with Visual Basic using OLE Automation.

Hardware: ibm-pcs and compatibles

Software: Windows 95, Visual Basic 4.0, Sybase 10 on HP Server, Telnet, WISQL, Crystal Reports 5.0, etc.

Project Overview: EIS (Executive Information System) is a tool for marketing companies. It can help in converting inquiries into Orders. Key features of the package are keeping track of the clients and maintaining the documents exchanged. Password protection is provided for viewing and editing of the documents.

• Design & Development of modules.

Hardware: ibm-pcs and compatibles

Software: Windows 95, MS SQL Server, Visual Basic 4.0

Project Overview: Kunden is a Decision Support System for Budget Simulations. It simulates the expenses incurred by a department to transform the percentage of customers from Potential to Informed to Interested to Motivated to Satisfied. The number of actions performed during these transformations from potential to satisfied Customers is the Regulating Factor. The more actions performed at each stage, the more will be total expenses incurred by the company.

• Development & Integration of modules

Hardware: ibm-pcs and compatibles

Software: Windows 3.11, MS Excel 5.0, MS SQL Server, Visual Basic 4.0

Project Overview: This is a Decision Support system for Budget Simulation. It supports the decision to make optimum use of available resources so as to minimize the expenses of a department. It simulates the WorkLoad, Resource Utilization, Efficiency, and Lost hours and finally Expenses of the department using time series forecasting technique.

• Development & Integration of modules.

Hardware: ibm-pcs and compatibles

Software: Windows 3.11, MS Excel 5.0, MS SQL Server, Visual Basic 4.0

Project Overview: Took part in the development of an on-line system for Emergency Service Providers. This covers emergency areas like Medical, Crime, Fire & Vehicle Breakdown. A log is maintained for the drills made. Alarm is provided at a regular interval to remind the operator to contact the caller again until he gets the help.

• Development of Crime & Vehicle breakdown modules.

Hardware: ibm-pcs and compatibles

Software: Windows 3.11, MS Access 1.1, Visual Basic 3.0