ANU ABRAHAM
(718)-981-7586
SUMMARY:
Senior Consultant possessing extensive Internet and Client Server
software development experience. Projects undertaken include B2C and
B2B E-Commerce Web Applications, Database Management Systems, and
Multimedia Applications.
These projects have been carried out in Perl, ASP (Active Server
Pages), JSP (Java Server Pages), HTML/DHTML/XML, JavaScript, Java,
Apache, HTML, Visual Basic (ADO, COM, Active X, IIS Application using
Web Class for ASP), Mod_Perl, OOA/OOD, Crystal Reports, CGI, Oracle
8/7,Sybase 11.9.2, MS-SQL server, MySql and MS Access.
Developed large public sites for the following clients: MasterCard
Intl, Maybelline / L'Oreal, DeBeers, M&M Mars, Vivaldi Networks,
TradeInteriors.
CERTIFICATIONS:
Microsoft Certified Professional (Visual Basic).
Brain Bench Certification in Perl.
TECHNICAL PROFILE:
Perl, Mod_Perl, XML, ASP (Active Server Pages), Active X, Java, JSP
(Java Server Pages), JavaScript, Dream Weaver, HTML, Visual Basic
(6.0/5.0/4.0), Web Logic, Visual SourceSafe, CVS, Developer 2000, MS
Access 97, Oracle 8/7, Sybase 11.9.2, MS SQL server, MySql, Win95,
Windows 3.11, MS Office, E-Macs, Unix, Linux, IIS, Apache.
PROFESSIONAL EXPERIENCE:
INTERMEDIA GROUP, INC. Jan 2000 to Present
OnSite Project For Luminant Worldwide Corporation, New York City, NY,
Dec 2000 to Present
Luminant Worldwide Corporation (www.luminant.com), a leading
professional services firm focused on technology-enabled business
solutions. As a Sr. Web developer was responsible for coding,
maintenance, enhancements for their leading clients in various
software packages and different platforms. Involved in the following
projects:-
Maybelline USA- L'Orιal USA, Inc (www.maybelline.com) Leading Cosmetic
Manufacturer in the US.
Environment: Perl, CGI, ASP, MySql, MS SQL server 2000, Apache, IIS
5.0.
Responsible for Web site development, coding and maintenance in
Perl/ASP/CGI. Design & development in mysql database.
Coded all monthly updates to the database, pages and coding for new
promotions. Then ftp data of various contests as per requirement.
Converting the entire site from Unix Solaris platform to NT.
Involved in NT transition where Active Perl was used along with DBI,
DBD::ODBC and MS SQL server. Emails were send using SMTP.
Did a complete rewrite of wwwthreads due to limitations on the
software to support of SQL server.
Exporting data from the existing Unix site which had a different
database structure compared to the new version. The web server used
under Unix was Apache and IIS under NT.
MasterCard (www.mastercard.com)- Leading credit card company in US.
Environment: Perl, CGI, HTML, JavaScript, Oracle 8
Was responsible for coding guess the view game' for the Mastercard
promotion.
Database design and writing stored procedure in Oracle.
Coding in Perl, OOA/OOD, DBI, Oracle for the web site requirements
with special importance given to security. Writing Perl scripts and
cron job for sending the results of winners on daily and weekly basis
to the company.
HTML and JavaScript was used for front end development.
Used encryption module from CPAN for data security.
Writing test scripts for testing as the 60 day promotion had to be
tested in a day.
Debeers ( www.forevermark.com ) Worlds leading diamond importer /
wholesaler company. Web site coding and maintenance of the web site in
many languages including Chinese, Japanese, Italian, German.
Environment: Perl, CGI, HTML, XML, Java Script, Oracle 8.0
Was responsible for coding in Perl/mod_Perl/ Oracle 8.0/HTML for the
web site requirement including a search feature in different languages
(Chinese, Japanese, Italian, German). Database design and development
in Oracle.
Used Object-Oriented Perl development and Embperl-processed
templates.
Coded using Mason for a special feature of browsing the ring.
Involved in coding in perl for an admin module for the site which
gives the statistics and other information of the site.
Used many PERL modules from CPAN for fast/efficient
design/creation/implementation of scripts into web sites for dynamic
web content of reports. Eg. HTML::TMPL, CGI_Lite, DBI, DBD::ODBC etc.
Web server used was Apache.
XML was used for include support for various languages
M&M Mars ( www.fundraiser.com, www.skittles.com, www.snickers.com,
www.cocopro.com, www.chocolateinfo.com, www.m-ms.com ) Leading
confections company. Web site coding and maintenance for the various
company promotions
Environment: Perl, CGI, HTML, Java Script, MySQL
Was responsible for all web sites coding for all above mentioned web
sites.
Coding included placing cookies, Search feature for
www.fundraiser.com, message board for www.skittles.com, Admin modules
for all the above mentioned sites.
Maintenance of web sites.
Writing code to send emails (using sendmail) to all their customers
to inform them of a promotion.
Using regular expressions for getting various results as the
database used for most of M&M site were plain tab limited text files.
Utilized perl scripts and cron to automate the maintenance of site.
Web server used was Netscape.
Responsibilities consisted of writing and maintaining PHP code which
interfaced with MySQL and writing Shell scripts and Java Scripts.
Modified the Polling program so that it would track individual IPs
to prevent users from voting more then once in a one day period.
HTML and JavaScript was used for front end development.
OnSite Project For Vivaldi Networks, Menlo Park CA, June 2000 to Nov
2000
Environment: Perl, Mod_Perl, XML, Java, HTML, Apache, CVS, Sybase,
MySQL, Unix Solaris,Oracle 8
Software Engineer working onsite at Vivaldi Networks (
www.vivaldinetworks.com ). The company was involved in providing
retailers with a rich Integrated Customer Profile (ICP) so that they
have in-depth knowledge about their customer's behavior across all
network and internetwork channels. The client is also involved in
putting up web pages by which consumers can retrieve information of
all their purchases (also can be used as a medium for retailers to
offer special promotional plans to the consumer on account of the
purchasing behavior of the consumers). As a senior web developer,
responsibilities include:
Web site development for the retailer as well as the consumer,
including writing handlers, sessions, DBI interfaces, OOA/OOD, SQL
Queries and stored procedures in Oracle.
Developed specific pages which included home page, lost password,
purchase history and message center. Credit card information
encryption using MD5 modules.
Site was originally made with Oracle database as backend but later
Sybase was used.
Tools utilized for this purpose included Mod_Perl, Apache as the web
server, CVS for version control, MySQL for session's management, and
Oracle for storing data. Unix was used as the operating system. Many
third party tools were also used for special requirements. Perl and
XML were both utilized for the loading of data received from the
retailers into the database. The XML files were parsed using the NSGML
parser.
Wrote front end in HTML( Dreamweaver) and JavaScript.
OnSite Project For TradeInteriors.com, San Mateo CA, Jan. 2000 to June
2000
Environment: JSP, JavaScript, HTML, Visual SourceSafe, MS SQL Server,
Sybase,Weblogic Server
Web Developer responsible for the web site development, maintenance
and testing of www.tradeinteriors.com. TradeInteriors.com is the
leading e-commerce web portal for the interior design trade,
addressing a wide range of designers' business needs, from product
research to client interaction. In addition to aggregating catalogs
from high-end furnishings manufacturers, the site provides a set of
tools that enable designers to better manage their business and work
with their suppliers and clients more easily.
Was responsible for the sites development, ongoing re-design and
updating. Tools utilized for this purpose included Visual SourceSafe,
which aided in version maintenance, Visual SourceSafe editor and
Dreamweaver, used to write JSPs (Java Server Pages), as well as HTML,
JavaScipt for user interfaces and functionality. Developed the new
registration pages, product detail area and numerous folders within
the site (e.g. Favorites and Client). Weblogic Server was used to
host the web site. Validations, Error Handlers, Utilities and other
code were written in common Java Files that were accessible by the
entire system.
PASSION INFOTECH CORP. April 1998 to Dec. 1999
Knowledge Management System, June 1999 to Dec 1999
Environment: ASP, IIS Server, Visual Basic 6.0, Oracle 8, HTML,
Cascading Style Sheet
Full Cycle Application Development, Documentation, and Testing.
Knowledge Management System is a package developed to keep track of
vital information. Information is categorized and each category has
its own problem, solution and effect. There is a problem solver module
that gives solutions depending on consultant and problem area. The
system used Oracle 8 for data storage. PL/SQL was used to create
tables, views, procedures etc. as well as certain constraints as
Primary Key, Unique, and Foreign key. User interface was provided with
Visual Basic. Here a number of already available ActiveX controls were
used such as Toolbox, StatusBar, Image List, DbCombo, Grid Control
etc. along with the standard controls. Data was accessed by ADO using
OLE-DB provider. ActiveX DLL was used to package complex routines
using Class Modules. Error Handlers were used to trap errors. The
reports generated were using crystal reports as well the reports for
problem solver made use of TreeView and Listview Control for getting a
view of all the solution category in a hierarchy. To make the system
more useful to people connected over net information could be
collected on-line and stored in the database, the reports could also
be send to authorized persons. For this purpose ASP was used.
Designed and built a mapping table utilized to import data to a
Oracle database .Use of HTML, Cascading Style sheet was also
necessary for this purpose. IIS Application project using Web Class-
this feature of VB was used. IIS server served the purpose of running
and testing ASP modules. Online help was provided using the tool for
the purpose. Debugging was done using a VB tool.
Web Based Recruitment Management System, Nov 1998 to May 1999
Environment: ASP, IIS Server, HTML, Visual Basic 6.0 and Oracle 7.1
Full Cycle Application Development, Documentation, and Testing.
Recruitment Management System is a package developed for Recruitment
Agencies which need to keep record of all the candidates approaching
them and finally selecting the list of candidates available for a
particular category. The software has a provision for video recording
of interviews, scanning of photograph and reports are generated in a
format that makes it convenient for the user to send mails directly
using MAPI and also access on the Internet. The application involved
Web database connectivity using ASP. The system was developed in VB
6.0 as Front-end. The user interface was made through Forms which used
a number of a number of ActiveX controls shipped with VB which include
Toolbox, StatusBar, Image List, DbCombo, Grid Control, MAPI controls
etc.) . The data was stored in a database server which in this case
was Oracle 7.1. Data Access method was ADO by using OLE-DB provider.
ActiveX DLL was used to package complex routines using Class Modules.
Error Handlers were used to trap errors. There was a special module in
which the data was collected and they replaced the bookmarks of a
formerly prepared word documents such as replacing directly the name,
address, salary etc. in an agreement letter and at the click of a
Print button the letter is printed with the details of the candidate
selected. OLE automation control made the video, audio and photo
scanning possible. To make the system Web enabled most of the objects
of ASP were used and finally the ASP, HTML modules were tested on IIS
server. An online Help was also made with the tool available with VB.
Web Authoring Tool, July 1998 to Nov 1998
Environment: ASP, IIS Server, HTML, Visual Basic 6.0, MS Access 97
Full Cycle Application Development, Documentation, and Testing,
Implementation and Training.
Authoring Tool is a tutor package and is developed using multimedia
controls. It provides provision for making stories and later
distributing them as per requirement. The project makes use of Active
X controls made for the various effects to be generated in order to
make the system visually appealing to the user. Making it an IIS
enabled application facilitates an on-line Internet tutor on variety
of applications to users. The database was stored in MS Access 97. The
Primary Key and other constraints and relationships were put on each
Table in database file. The process of accessing data was through ADO
using Jet Engine Provider 3.5. In the story writing section a user can
select an effect or a control (Designed using ActiveX control or DLL).
The control is positioned and there is a facility given to drag it to
the point the control is to be moved and this manner the position of
the control can be recorded. Or if in an effect you want to move a
control from one point to another then position for that is also
recorded. Extensive use of ActiveX controls and DLL is done to provide
the user with maximum effects and controls. An option is also provided
for recording bitmaps or any picture files, sound, Rich Text Files.
Each story can be compiled, played and distributed. API procedures
were used for some features such as SetWindowsPos, PlaySound etc. API
viewer provided the appropriate declarations for the Window API
procedures. Error Handlers were used to trap errors. Debug tools of
Visual Basic were used. And also help was provided using the tool for
the same. IIS Application project using Web Class- this feature of VB
was used for ASP, HTML.
Web Enabled Sales and Distribution System, April 1998 to July 1998
Environment: ASP, IIS Server, HTML, Visual Basic 6.0 /5.0, Oracle 7.1
Full Cycle Application Development, Documentation, and Testing.
The purpose of the project is to allow dealers to place orders for
the entire range of vehicles and spare parts and to dynamically manage
any change in the product information, pricing policy etc. The system
also has provision for accepting information on-line. It also deals
with financial aspects involved in the process. The system has
provision for multiple company information recording and generates
company-wide reports. The data was stored in a database server which
in this case was Oracle 7.1. PL/SQL was used to create tables, views,
procedures etc. as well as certain constraints as Primary Key, Unique,
Foreign key. User interface was provided with Visual Basic. Data
Access method was ADO by using ODBC . ActiveX DLL was used to package
complex routines using Class Modules as well as implement business
rules. Error Handlers were used to trap errors. IIS Application
project using Web Class- this feature of VB was used for ASP, HTML.
Reports were generated using Crystal Reports.
CROMPTON GREAVES CORP. June 1997 to March 1998
Sales Invoicing System, Nov 1997 to March 1998
Environment: Visual Basic 5.0 / Oracle 7.1
Application development, documentation, preparation of test script,
testing, implementation and training.
The indents are made when a customer places an order for goods
manufactured by the company. Once the material is ready to be send to
the customer a challan is prepared. The invoices are printed based on
the material delivered on the challan. The most important aspect of
this project was generation of all possible reports as required by the
company they included even graphical reports. The system was storing
all its data on a centralized Oracle server. PL/SQL was used to create
tables, views, procedures etc. as well as certain constraints as
Primary Key, Unique, Foreign key etc. Active X DLL was used to package
complex routines using Class Modules as well as implement business
rules. The front-end was developed using VB-5.0. To make the system
appealing to the user many ActiveX controls were used. Method used
for data-access was RDO and ODBC. The debug tools were used for
testing. Reports were generated using Crystal Reports. There were a
number of Graphs which were done using chart control and few using
Graph feature of Crystal Reports. Error Handlers were used to trap
errors. Debug Tools of Visual Basic were used. And also help was
provided using the tool for the same.
Payroll System, June 1997 to Oct 1997
Environment: Visual Basic 5.0, Oracle 7.1
Application development, documentation, preparation of test script,
testing, implementation and training.
Payroll System computerizes the payment activities of the employers
in the company. It contains modules for master maintenance of the
employees in the company and generating payslips. The system was
storing all its data on a centralized Oracle server. PL/SQL was used
to create tables, views, procedures etc. as well as certain
constraints as Primary Key, Unique, Foreign key etc. ActiveX DLL was
used to package complex routines using Class Modules as well as
implement business rules. The front-end was developed using VB-5.0.
The method used for data-access was RDO and ODBC. The debug tools
were used for testing. Reports were generated using Crystal Reports.
Error Handlers were used to trap errors. Debug Tools of Visual Basic
were used. And also help was provided using the tool for the same.
GLOBAL ELECTRONIC COMMERCE, INC. June 1996 to March 1997
Library Management System, Dec 1996 to March 1997
Environment: Visual Basic 4.0 / MS Access
Developing various modules and testing.
The system is a general package developed for Libraries to manage
their library so that the members can view the entire list of books,
CDs and Magazines along with the detailed status of any item. It
provided reports and issues of books and the books that have to be
returned. It also calculated fine for books not returned time. The
system was password protected. This was done by creating a table in MS
Access where the password was stored. An MDI form along with Menu
Editor was used to create the Main Menu. Then Menu consists of System
Admin, Masters(Books, Members, Staff etc.), Transaction(Purchase of
books, retired books, Daily transactions) and Reports (Memberwise,
Bookwise, Datewise). Different reports for various groups such as
books, CDs and Magazines etc.). The records was created in MS Access
in tables and all the tables together made a database(.mdb). The
Primary Key and other constraints and relationships were put on each
Table in database file. The front-end was developed using VB-4.0. All
the forms were made MDI child. Backup and Restore was done by creating
ASCII files. The method used for data-access was Data-Control, DAO.
Testing was done using the debugging tools provided with VB. Reports
were generated using Crystal Reports.
Material Management System, June 1996 to Nov 1996
Environment: Visual Basic 4.0 / MS Access
Developing various modules and testing.
The system was designed to provide the management with the
information of the stock, details of the material given to third party
and their sales. The system was password protected. This was done by
creating a table in MS Access where the password was stored. An MDI
form was used for Main Menu created by Menu Editor. Menu consists of
System Admin, Masters(Suppliers, Clients, Third Party, Item
Master,etc.), Transaction (Purchase Order etc.) And Reports. The
records was created in MS Access in tables and all the tables together
made a database (.mdb). The Primary Key and other constraints and
relationships were put on each Table in database file. The front-end
was developed using VB-4.0. All the forms were made MDI child. Backup
and Restore was done by creating ASCII files. The method used for
data-access was Data-Control, DAO. The debug tools were used for
testing. Reports were generated using Crystal Reports.
EDUCATION:
Microsoft Certified Professional (Visual Basic)
Master of Science (MSc.) Pune University-India
Masters Diploma In Information Technology Tulec(Tata Infotech
Education Centre), Pune-India