ANU ABRAHAM
anuabraha
...@hotmail.com
SUMMARY:
* Senior Consultant possessing extensive Internet and Client Server software
development experience along with Microsoft Certification in Visual Basic.
Projects undertaken include B2B E-Commerce Web Applications, Database
Management Systems, Multimedia Applications. These projects have been carried
out in Perl, Mod_Perl, ASP/JSP, Java, XML, Apache, HTML, Visual Basic (ADO,
COM, Active X, IIS Application using Web Class for ASP), Crystal Reports,
JavaScript, CGI, Oracle 8/7, 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
:-http://www.brainbench.com/transcript.jsp?pid=1876737
TECHNICAL PROFILE:
Perl, Mod_Perl, XML, ASP (Active Server Pages), Active X, Java, JSP (Java
Server Pages), JavaScript, DreamWeaver, HTML, Visual Basic (6.0/5.0/4.0),
WebLogic, VisualSourceSafe, CVS, Developer 2000, MS Access 97, Oracle 8/7,
Sybase, 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. Web site development and maintenance.
* Responsible for coding in Perl/CGI/mod_perl/mysql. Design & development in
mysql database. ‘SendMail’ was used for sending emails The site contained a
‘talk’ section which was powered by wwwthreads, was involved in configuring
and implementing necessary changes to the wwwthreads software.
* 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 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.
Was responsible for coding ‘guess the view game’ for the Mastercard
promotion.
* Database design and writing stored procedure in Oracle.
* Coding in Perl, 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.
* 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.
* Was responsible for coding in Perl/mod_Perl/ Oracle 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::Oracle etc. Web server
used was Apache.
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
* Was responsible for all web site 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.
OnSite Project For Vivaldi Networks, Menlo Park CA, June 2000 to Nov 2000
Web Site Development
Environment: Perl, Mod_Perl, XML, Apache, CVS, Sybase, MySQL, 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, 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. Linux 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.
OnSite Project For TradeInteriors.com, San Mateo CA, Jan. 2000 to June 2000
Environment: JSP, JavaScript, HTML, Visual SourceSafe, MS SQL Server, 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 code 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 Present
Environment: ASP, IIS Server, Visual Basic 6.0, Oracle 7.1
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 7.1
for data storage. 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. 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. Use of
HTML 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, 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 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, 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.
Web Enabled Sales and Distribution System, April 1998 to July 1998
Environment: ASP, IIS Server, 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. 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