|
Current Address 401 E.Gibbsboro Road Apt 113 Lindenwold, NJ -08021 |
Email Address and Contact No: (856) 309-1949 |
OBJECTIVE [TOP]
·
Position with responsibilities in Programming
and Software Development.
SUMMARY [TOP]
·
About
4.5 years of analysis, design and development experience
with heavy emphasis in client-server database development, user interface
design, Web development and reporting.
·
Excel at Visual
Basic, ASP, ADO, IIS, COM, Sybase, MS-SQL Server and Access.
CERTIFICATION [TOP]
·
Microsoft Certified Professional (MCP) in Visual
Basic 5.0.
·
Microsoft Certified Professional (MCP) in SQL
Server 6.5.
EDUCATION [TOP]
·
Bachelor Degree in Electrical and Electronics
Engineering.
TECHINICAL SUMMARY [TOP]
· Operating Systems Microsoft Windows 9X/NT (primary), UNIX, Microsoft DOS
· Language ASP, VBScript, HTML, DHTML, JavaScript (Client Side), Transact SQL, PL/SQL, C
· GUI Tools Visual Basic 6.0/5.0/4.0, Power Builder 6.0/5.0, FrontPage
·
Databases Sybase 11.5/11.9.X (Adaptive Server), MS-SQL Server 7.0/6.5,
MS Access 2000/97, Oracle 7.3, Embarcadero Rapid SQL
· Others CSS, IIS, ADO, RDO, ActiveX, COM, MSMQ, WSH, WMI, API, DLL, Visual Interdev, FrontPage, Erwin, Crystal Reports
EXPERIENCE [TOP]
April 2000 to Present: Advanta Leasing Services, Voorhees, NJ
E-commerce for Leasing.
January 2000 to April 2000: Advanta Leasing Services, Voorhees, NJ
Web Based System Management and Monitoring (Using WMI) [TOP]
The Production Monitoring system, a turnkey stand-alone system, I developed and implemented, provides a consistent, flexible infrastructure for the management of systems, applications, devices and networks using Windows® Management Instrumentation (WMI). WMI is a powerful technology that makes it possible to manage a single machine, or ten thousand all at once and enables remote management of Windows-based systems and apps.
This intranet based system is helpful for technical support group, whenever any problem occur in our production system, it notifies assigned individuals in the technical support group, via beeper and/or email, with detailed error message, error occurred time and server name. This helps them to fix the problem quickly and reduces the down time of the production system being monitored.
Contribution:
Environment: Visual basic 6.0, Active
Server Pages, Visual Interdev 6.0, Microsoft Access 2000, COM,
ActiveX DLL, Windows® Management Instrumentation (WMI), JMail, Front Page 2000,
VB Script, Java Script (Client Side), and ActiveX Data object, Internet
Information Server, Microsoft Visual Source Safe.
March 1999 to December 1999: Advanta Leasing Services, Voorhees, NJ
Bureau
Report Parser and Decision Support Data Manager [TOP]
Primary developer who designed and developed, in a team environment, a set of systems that, utilizing metadata, extracts pertinent data from parsed credit reports, standardizes the data and stores the result in a database structure. This data then feeds into a centralized database repository for analysis. A web front end was developed to automate extraction and display of that data for end users.
Advanta Corp. is a financial services company with services including mortgages, equipment leases, business credit cards, and insurance and deposit products.
Contribution:
·
Designed
and developed an interface for getting
raw information from credit bureaus (TU, EQ, EX, D&B) through Microsoft
Message Queue (MSMQ). Parses the raw data, constructs the
well-formatted data into structured SQL’s, which are finally stored in the
Sybase database. The whole interface is designed and driven based on METADATA.
·
Designed
and developed an incremental data
transfer system that copies highly normalized data from a leasing auto-approval system to a
flattened format for general end user reporting on daily basis.
·
Implemented
a 3-Tier architecture for a
standardized consumer credit bureau and business credit bureau reporting system via web interface. Provides ability to
view customer credit bureau reports over intranet in a custom format, which was
developed for a fraction of the estimated cost.
·
Designed
the Relational Data Model for a
standardized consumer credit bureau and business credit bureau reporting system
using ERwin tool.
·
Co-implemented
the foundations of a web-based status
reporting system, which monitors the progress of a core leasing decision
engine application and the aforementioned data transfer system.
·
Developed a utility for organizing the daily log files backup
using windows scripting Host (WSH).
·
Wrote
stored procedures and triggers for the
Web Interface.
·
Did
Unit Level testing and Technical documentation.
Environment: Visual Basic 6.0, Active Server Pages (ASP 2.0), Sybase Adaptive Server 11.5/11.9.X, MS SQL Server 7.0, HTML/DHTML/CSS, VBScript, ActiveX Data Object 2.1(ADO), Internet Information Server (IIS 4.0), MS Message Queue 1.0 (MSMQ), Visual Interdev 6.0, FrontPage 2000, Microsoft Windows Scripting Host 1.0 (WSH), Visual Source Safe 6.0, DLLs, Embarcadero Rapid SQL 5.22, ERwin
May 1998 to January 1999: Lucky Plaza, India
Material Management System (MMS) [TOP]
This is an interactive package to process all material related information for inventory management and analysis. Using this package a user can generate and print various queries and reports. The application was developed in Visual Basic using MDI forms with API, Class Modules etc.
Contribution:
·
Designed the User Interface. Designed and
developed screens like Customer Maintenance, Transaction screen (using control
Array) etc.
·
Created menu dynamically for MDI form and
Customer Maintenance forms.
·
Designed and developed ActiveX controls.
·
Using ODBC, accessed data from the backend in
SQL Server 6.5.
·
Wrote stored procedure for automatic generation
of customer ID in SQL Server and executed that procedure in Visual Basic.
·
Utilized Crystal Reports to generate management
reports.
·
Used RDO concepts to connect the front-end
application to the back-end databases.
·
Did system level testing and documentation.
Environment: Visual Basic 5.0, SQL Server
6.5, ODBC, RDO, DLL and Crystal Reports.
December 1997 to April 1998: Sooriya Automobiles, Madras, India.
Vehicle Finance System (VFS) [TOP]
This is an interactive package meant for
Automobile Financing. These modules comprise the Address Manager Module,
Vehicle Proposal Module, Agreement, Trade Advance, Receipts and Reports. It is
a menu driven and user-friendly package to handle the total financing process
for purchasing automobiles.
Contribution:
·
Designed user interface.
·
Developed forms like front screen display using
API.
·
Developed Address Manager Module etc.
·
Used RDO concepts and ODBC, to access the data
from the backend in SQL Server.
·
Used Visual Basic features like MDI forms, user
control, class modules etc.
·
Wrote triggers in MS-SQL Server.
·
Implemented Toolbars and status bar for
displaying the status of the current action etc.
·
Used Object Oriented Programming concepts.
Environment: Visual Basic 5.0, MS-SQL Server 6.0, ActiveX, MDI, API, and Crystal Reports.
July 1997 to November 1997: Sacs, Bangalore, India.
Total Inventory Control [TOP]
This package is for computerized gas agencies.
The system supports maintaining customer master, data addition, booking and
delivering goods and Report generation.
Contribution:
·
Designed and developed forms like Customer
Master data addition, Deletion, Modification, Booking the Cylinder, Stock
updating etc.
·
Created images for buttons, forms, etc for a
user-friendly interface.
·
Implemented progress bar and slider controls for
processing.
·
Did code review, testing, and documentation and
performance optimization.
·
Developed reports on stock in warehouse, voucher
maintenance etc.
Environment: Visual Basic 4.0, MS Access, DAO, Windows 95, and Crystal Reports.
February
1997 to June 1997: Titanium
Private Ltd., India
Human
Resource Management (HRM) [TOP]
This
is a Human Resource Management Package. The main modules are Recruitment,
Employee Information Management, Training, Appraisal, and Reports.
Contribution:
·
Designed the user interface.
·
Developed Master Maintenance forms like employee
educational background, Technical background, and Transactions forms like
Appraisals, Leave Cashing etc.
·
Developed many reports using Crystal Reports.
Environment:
Visual
Basic 4.0, Oracle 7.3, and Crystal Reports
September 1996 to January 1997: Nestor Pharmaceuticals Ltd., India
Payroll Processing System (PPS) [TOP]
This
package is for payroll related processing. It was developed using Turbo C.
Contribution:
·
Designed user interface, using Windows and
Menus.
·
Used pointers and doubly linked-lists
extensively.
·
Developed Reports using formatting function in
files.
Environment:
C, HP Net Server, Unix System V
February 1996 to
September 1996: Power System Study [TOP]
·
Computer based approach for minimizing the
transmission losses and improving voltage profiles
·
Calculation of power loss during Power
Transmission and calculation of Inductance and capacitance to compensate the
loss.
Environment: IBM PC 486, Fortran 77