SUMMARY
About five years of experience in the IT industry. Experience in analysis, design, development, testing and implementation of complete n-tier enterprise wide business systems using Visual Basic 6.0/5.0, COM/DCOM, ADO, ActiveX, MTS/COM+, ASP, VBScript with MS SQL Server 7.0/6.5 and Oracle 8i database. Experience in developing prototype systems using Visual Basic .NET.
MCP in Developing and Implementing Windows-based Applications with MS Visual Basic .NET and MS Visual Studio .NET.
MCSD (VB 6.0) / MCDBA (SQL Server 7.0) / MCSE (Windows 2000).
STRENGTHS
·
Experience in design and development of middle-tier components (COM /
ActiveX technologies) using Visual Basic.
·
Experience in COM/DCOM, MTS and COM+ technologies.
·
Experience in GUI design using Visual Basic.
·
Experience in developing Active Server Pages using IIS.
·
Experience in Card printing process (EPI Builder)
·
Exposure to Database Administration in SQL Server.
·
Experience in database programming (stored procedures, triggers) using
MSSQL Server (T-SQL) and Oracle (PL/SQL).
·
Experience in Visual Basic .NET and new methodology Extreme
Programming.
·
Extensive experience of installing, configuring and trouble shooting
Windows 2000.
·
Experience in SEI - CMM Level 4 procedures and documentation.
TECHNICAL SKILLS
Software: Visual Basic
6.0/5.0, ADO 2.5/2.0, ASP 3.0/2.0, Visual Basic .NET, ASP .NET, Visual InterDev
6.0, Dreamweaver 3.0, VBScript, JavaScript, HTML, XML
Middle Layer: COM/DCOM, ActiveX, MTS, COM+
Databases & Tools: MS SQL
Server 7.0/6.5,Oracle 8.1/7.3, MS Access 97, T-SQL, PL/SQL, SQL*PLUS, TOAD, SQL
Navigator 4.0, ERWin
Other Tools: Visual Source Safe 6.0,
TestDirecotr 6.0, WinRunner 6.0,
Operating Systems:
Windows 2000, Windows NT 4.0, Windows 98/95
EXPERIENCE
NYCTA – MNRR,
Brooklyn
NY
Oct ’01 – to date
The main aim of the project
is to create, update and print card records for employees as well as customers
of NYCT / MNRR. It also includes modules which carry out day to day business
operations like transmitting and receiving data to financial authorities using
Import/Export, maintaining security of the application and managing user roles,
creating reports, maintaining card inventory. The project is divided into main
modules – PIC
Responsibilities:
·
Designed entity
relationships and table structures in Oracle database for different modules in
the project.
·
Developed /
implemented Card Inventory module to handle Card stock maintenance.
·
Developed GUIs in Visual Basic 6.0.
·
Developed program
in VB 6.0 to read related information on proprietary encoded cards.
·
Code optimization
/ development for Print Queue and Print Card processes.
·
Optimized and debugged
code for printing different types of images (Photograph / Signature) on the
same card. Used EPI Builder application to create card formats.
·
Developed /
implemented Card module to create / print different type of cards and
implemented “Lost / Stolen” section for cards.
·
Developed PIC
Security module and implemented security features in all the modules of the
project. Creating-adding Users/Permissions, setting/enabling/disabling and
applying control level security.
·
Developed /
implemented Employee, TTP, Reduced Fare, Mail And Ride and Certifier modules.
·
Developed /
implemented AFC Export, Mail And Ride Import-Export, Remote Capture Employee
Export, EIS Import-Export.
·
Developed /
implemented PIC Administration module to create / update Card Formats, to set
Card Selection Parameters, set Image properties, Mass Re-issuance queries and
Customized Query builder and other administrative tasks.
·
Worked on Data
Migration in Oracle 8.1.6 / MS SQL Server 7.0 and Image Migration process to
convert images from MS SQL Server 7.0 to jpeg format and store them in Oracle
database.
·
Created custom
ActiveX controls in Visual Basic 6.0.
·
Developed reports
using Crystal Reports 8.0
·
Used SQL Navigator 4.0 for writing/debugging Oracle PL/SQL stored
procedures and triggers.
·
Involved in testing, review and code optimization for different modules
in the project.
·
Used Visual Source Safe 6.0 for source code control.
Environment: Visual Basic 6.0, ADO 2.5,
APEX True DB, EPI Builder 5.3, Crystal Reports 8.0, Oracle 8.1.6, MS SQL Server
7.0, SQL Navigator 4.0, PL/SQL, SQL*PLUS, Windows 2000 (Server / Professional),
NISCA Card Printer
National Utility Services,
NJ Sep
‘00 – Sep ‘01
NUS
- Verity
NUS studies the clients’ profile in terms of their
consumption by supply point, seasonal variation in consumption, rate charged by
the supplier(s), possible saving by going to the other supplier(s), local
rules, regulations and tax structure, etc. to find out possibility of savings.
It generally charges fixed service/retainer fee plus share of the savings
earned due to its recommendations for its services. The project was aimed at
creating a decision support and administrative maintenance system for National
Utility Services. The project was based on n-tier architecture with clear
physical and logical segregation of the various layers, viz. the
user-interface, the business logic layer and the database(s). The project was
divided into fifteen different modules that were further subdivided into
component parts. Oracle 8.1.6 was used as the database and all data-centric
operations were performed via stored procedures being called by middle layers.
All database operations were carried out through a single common data layer.
Very high security requirements were also implemented in this project.Component Services was used for resource
pooling.
Responsibilities:
·
Team lead for the Masters module of the project.
·
Developed a Generator Program in VB 6.0 to create standard Stored
Procedures (for Oracle 8.1.6 and Business Objects (for VB 6.0).
·
Developed GUIs in Visual Basic 6.0.
·
Used VB 6.0 for creation of middle-tier business logic and database
access. (COM and MTS technology).
·
Used
·
Used TOAD -Tool for Oracle Application Developers - for writing /
debugging Oracle PL/SQL stored procedures, triggers etc.
·
Involved in review of database procedures and code optimization for the
module.
·
As a member of Net-Recon team, was involved in developing prototype for
Master’s module using Visual Basic .NET Beta 2 release and MS SQL Server 7.0.
·
Used Visual Source Safe 6.0 for source code control. Handled the
responsibility of the VSS administrator.
·
Was involved in Regression and Stress testing.
Environment: Visual Basic 6.0, COM/DCOM, MTS, ADO 2.5, ASP 3.0,
IIS 5.0, Apex TrueDB, Merant Data Direct Provider, MS SQL Server 7.0, Oracle
8.1.6, TOAD, PL/SQL, SQL*PLUS, ERWin, Windows 2000 (Server / Professional)
Windows NT 4.0 (Server / Workstation).
Silverline
EXPO on Line Express,
London , UK
EX-EOE
This is an experimental research and parallel implementation wizard module of Expo Online Express. The product was developed using methodology of Extreme Programming. Expo is business portal build for the exhibition industry. For EXPO, clients are organizers, suppliers, venue-owners and trade exhibitors. Its main purpose is to facilitate information flow among its registered clients. The EOE is a wizard, which helps the user in generating a dynamic web site. Developers would be able to create online events, presentations and dynamic content with ease.
Responsibilities:
·
Involved in analyzing the requirements, estimation, design, coding, and
testing.
·
Developed COM components in Visual Basic 6.0.
·
Wrote stored procedures in MS SQL 7.0.
·
Used MTS for COM component deployment and resource pooling.
·
Developed main screens of the wizard using Visual InterDev/Dreamweaver.
·
Developed ASP pages for the main screens of the wizard.
·
Created test plans and scripts for all cycle releases using Test
Director.
·
Used Visual Source Safe 6.0 for source code control. Handled the
responsibility of the VSS administrator.
·
Performed business function testing.
Environment:
Visual
Basic 6.0, COM, MTS, ADO 2.0, ASP 2.0, HTML, MS SQL Server 7.0, Visual InterDev
6.0, Dreamweaver 3.0, WinRunner 5.0, Test Director 5.0, Visual Source Safe 6.0,
Windows NT 4.0
Silverline
CFN-Asia - Hong Kong Feb ’00 - Mar’00
EBS (Electronic Brokerage System)
Was involved in the design and development of
prototype electronic brokerage system.
EBS was developed to facilitate the clients to do
secure online trading. The system will gather information about the trading and
other transactions entered by users. It then periodically connects to the Hong
Kong Depository database to complete the transactions. The project was based on
three tier architecture with browser based front-end and VB/COM as the middle
tier with MS SQL Server 6.5 as the backend database. Interfaces were also
developed to communicate with the Depository database. The customers were
provided with additional facilities like personalized portfolios and e-mail
accounts.
Responsibilities:
·
Designed proposed system architecture.
·
Designed different modules in the proposed system such as Account
Executive, Operation Manager, Security Module, etc.
·
Developed prototype in VB/COM and ASP 2.0.
·
Developed COM components in Visual Basic 6.0.
·
Developed stored procedures in MS SQL Sever 7.0.
Environment: Visual Basic 6.0, COM, MTS,
ASP 2.0, HTML, Visual InterDev 6.0, IIS 4.0, MS SQL Server 7.0, Windows NT 4.0.
NSDL (National Securities
Depository Ltd.),
DPM (Depository Participant Module)
PMS (Problem Management System)
DPM:
User interface was needed for the clients to handle
regular system operations like Backup, Message queue checking, BOD and EOD
messages. Graphical Interface for System Management Operations (GISMO) was
provided to the clients for that purpose.
For querying the SQL Servers located on client
sites, remote login was used. Successfully completed the task of linking these
servers to main server at NSDL so that the need for remote login is eliminated.
Once the server is selected, the queries are entered with the regular syntax
and results are obtained in grid format. Parsing of the query to match appropriate
version of SQL Server syntax is handled by the underneath system.
PMS:
Problem Management System was developed to resolve
problems reported by the clients of NSDL and record solutions provided to them.
This system provides all the logs and tickets for problems reported. The system
offers ‘Text Search’ facility using keywords entered.
Problems like deadlock or attempt to violate unique
constraint are frequently reported. Developed scripts to automate the solution
for such problems. This solution works for a list of about 20 predefined
problems. The only action required is firing of appropriate script. The action
taken or comments are returned back as result.
Responsibilities:
·
Developed GUI in Visual Basic for GISMO (DPM) module with code in VB 5.0.
·
Developed Backup module.
·
Wrote stored procedures in MS SQL Server. Linked MS SQL Servers located
on client sites to main Server at NSDL.
·
Used the concept of linked servers and MSDTC for implementing the
above- mentioned task.
·
Developed the GUI in Visual Basic that allows the user to select
required server from a drop down list to connect to that server.
·
Wrote SQL scripts which collect the necessary information from
corresponding tables and automatically resolve problems like deadlock,
settlement number not found, pledge id not found.
·
Defined guidelines of Visual Basic coding standards for the group.
·
Provided technical support to the group.
·
Developed GUI in Visual Basic for PMS.
·
Did the Housekeeping Activities (re-indexing and truncating intermediate
transaction tables) on the client databases.
Environment: Visual Basic 6.0/5.0,
Lupin
Chemicals,
IMAS - Inventory Management Automation System
The project dealt with the automation and
integration of the entire inventory management. The project was developed with
VB 5.0 as the front end and MS Access as backend. RDO was used for data
connection and
Developed an ActiveX Control in Visual Basic 5.0,
which allows selecting a particular table from the database in the drop down
box. For this table name of columns are shown to user and user can select the
specific columns and query the database and get the results for those columns
only.
· Used VB 5.0 for GUI development.
·
Used VB 5.0 to write business logic using COM.
·
Created ActiveX controls in VB 5.0.
·
Used Crystal Reports for reporting.
Environment: Visual Basic 5.0,
EDUCATION / CERTIFICATON
·
Engineering from
·
MCSD (Microsoft Certified Solution Developer in VB 6.0)
·
MCDBA (Microsoft Certified Database Administrator in SQL Server 7.0)
·
MCSE (Microsoft Certified Systems Engineer in Windows 2000)
·
MCP in VB .NET (Windows-based Applications, Exam 70-306)
·
MCP in Visual Basic 6.0 (Distributed Applications, Exam 70-175)
·
MCP in Visual Basic 6.0 (Desktop Applications, Exam 70-176)
·
MCP in Solution Architecture (Exam 70-100)
·
MCP in Designing and Implementing Databases with Microsoft SQL Server
7.0 (Exam 70-029)
·
MCP in Administering Microsoft SQL Server 7.0 (Exam 70-028)
·
MCP in Microsoft Windows 2000 Professional (Exam 70-210)
·
MCP in Microsoft Windows 2000 Server (Exam 70-215)
·
MCP in Implementing and Administering a Microsoft Windows 2000 Network
Infrastructure (Exam 70-216)
·
MCP in Implementing and Administering a Microsoft Windows 2000
Directory Services Infrastructure (Exam 70-217)
·
MCP in Designing a Microsoft Windows 2000 Directory Services
Infrastructure (Exam 70-219)
·
Brainbench Certified Visual Basic 6.0 programmer
·
MCP in Visual Basic 5.0 (Exam 70-165)