Resume 13

A Lotus Notes professional with Eight years of information technology experience that includes Six years in Lotus Notes development/administration. Expertise spans application architecture, application design, and development and deployment of Lotus Notes/Domino Web applications. Highly Proficient in programming the Lotus Notes/Domino 5.x & 4.x using Lotus Script, Lotus Formula, JavaScript, HTML, DHTML, XML, XSL and Java. Proficient in developing applications for the enterprise integration with Oracle databases using Lotus Enterprise Integrator LEI , DECS and LSX. Good exposure and knowledge of Ms-Access, Oracle, Sametime, Domino.Doc 3.0, quickplace ODBC.Highly experienced in Software development life cycle Analysis and Design of Business process analysis, gathering user requirement specifications, Testing Implementation and Maintenance in Notes & Domino applications. Hands on experience in migrating Data From Lotus to RDBMS.Excellent communication, technical writing, documentation skills

Bachelors in Science B.S.
Post Graduate Diploma in Systems and Software Management GNIIT

Completed Lotus Notes R5 Development and Administration Course from Top Gun Academy, Boston-MA.

• Lotus Notes : Lotus Domino R5.0.9/5.0.7, R5.0.3, Lotus Notes v 4.x, Lotus Notes v 3.x, Lotus Notes Administration
• Programming : Lotus Script, Formulas, SQL and Java.
• Web Development : HTML, DHTML, XML, DTD, XSL, ASP, JavaScript, CSS, Domino Designer, Domino HTTP server.
• Lotus Technologies : Domino.doc, Sametime 2.0,Domino Workflow, quickplace, DECS, LS: DO, LEI, IIS, VBA, Excel, Lotus Notes Components.
• RDBMS : MS Access, DB2, SQL Server, Oracle and Progress.
• Operating Systems : Unix, Novell Netware Win NT 4.0 server /2000/95/98,RS6000/AIX AS/400,Novell Netware.
• Other Software : People Soft, Photoshop, Dream weaver, TeamStudio, MS-Office, Crystal Reports.

Environment :
Lotus notes 5.0.9/Domino, HTML, JAVASCRIPT, LOTUS SCRIPT Communicator & Internet Explorer, MS-Project, vba, Excel, Windows NT 4.0,Solaris.

Description :
Migrating 3000 Lotus Notes 5.x users to Microsoft Exchange 5.5.

• Migrated the users to Exchange using migration tools.
• Wrote Lotus Script agents that generate report on users mail files on server to check for encrypted mails for the last 30 Days and export the documents to Excel Spread sheet.
• Wrote Lotus script agent to add Domain Admin Group on each user s mail files for Exchange Migration.
• Wrote Lotus Script agent to generate ACL List for All databases on the server and export to excel.
• Wrote Lotus Script agent to compare an Excel sheet with documents in Address book and Copy the matching documents to another database.
• Wrote agents to Lock/Unlock All Ids except the Administrator s ID for migration.
• Wrote Agent for forwarding mails from notes to exchange.
• Created Replica copies of All databases before migration.
• Created directory catalog and directory assistance for the server.
• Created exchange user accounts and configured outlook clients for the end users.

Environment :
Lotus notes 5.0.3/Domino, HTML, JAVASCRIPT, LOTUS SCRIPT Sametime2.0, MS-Project, Communicator & Internet Explorer, Windows NT 4.0.

Description :
Study the Sametime Collaboration tool and incorporate it with notes and Domino application like discussion and team room databases in SCT. Suggested the upgrade of Sametime 1.5 to 2.0 server and clients because of new features like multimedia support, multilingual chat, broadcast meeting and share application.

• Developed database structure and design. Independently built and coded the databases in Notes R5 with standards based coding, detailed components design.
• Involved in the System Analysis and Design using standards
• Created Detailed Design Document Specification.
• Design high-level system structure, implement system design from specifications.
• Prepared functional document based on user requirements.
• Interacted with the clients and gathered user requirements.
• Identified basic entities and designed database based on user input.
• Devised validation, workflow, approval, mailing and data integration in Lotus Script.
• Developed agent that can send e-mail memos with URL of the documents to the respective team members.
• Created fields for authors and readers in the forms, roles for the database access and prepare access control list for setting up the database.
• Created JavaScript for form validation on web based intranet applications.
• Customized Sametime Template for the company needs.
• Created Sametime Applets in forms for real time collaboration.
• Planning was be done both graphically and using a list, depending on your preferences*The worklist shows your outstanding tasks, with a graphical overview of the entire process
• Replicating the notes database with Sametime server for collaboration functionality to work.
• Used JavaScript for browser client side processing, both Internet Explorer and Netscape Navigator. Coded Lotus Script Agents for document processing in the back end.
• Created mail in database for notifying users of new database,mail files.
• Designed suitable graphics in Photoshop 6.0.
• Tested and validated the entire process.
• Supported multiple Domino Servers including creating new IDs, scheduling replication, rebuilding damaged views, renaming users, database management on servers etc.

Environment :
Lotus notes 5.0.3/Domino, HTML, DHTML, XML, JAVASCRIPT, LOTUS SCRIPT, Communicator & Internet Explorer, RS/6000, AIX, Windows NT 4.0.

Description :
This is a Helpdesk Application for the external customers who use the ERP Packages. The customer submits his problem through the web and it generates three email memos one to the consultant, one to the pager and one to the Administrative account depending on the system selected. The consultant replies back to the customer stating the remedy to his problem and email memo is sent to the end user and the Administrative account when the ticket is closed. The consultant has a search feature to search for the ticket No, status etc submitted to the application.

• Involved in the System study for the application.
• Design high-level system structure, implement system design from specifications.
• Prepared design document, user document for the project.
• Developed forms and views for the application.
• XML was used to organize fields in forms.
• XML was used to display data in views and pages.
• Developed agent that sends e-mail memo with URL of the documents to the consultant.
• Designed and implemented site search capability in a Notes multi data base web enabled application.
• Created fields for authors and readers in the forms, roles for the database access and prepare access control list for setting up the database.
• Setting up the Security levels for the databases.
• Developed search function for the application. Testing was done by writing dummy IDS.
• Administered and supported multiple Domino Servers including creating new IDs, scheduling replication, rebuilding damaged views, renaming users, database management on servers etc.

Environment :
Lotus notes 4.6.3/Domino5.0, HTML, Javascript, Excel, DECS, LSX connectors, Communicator & Internet Explorer, vba, Excel, oracle 8,Windows NT 4.0.

Description :
Studied the existing systems in Lotus Notes and Proposed a New System in RDBMS along with how to migrate data from Notes to RDBMS. Worked on the Changes required in the existing databases in Notes.

• Study the Existing Systems in Lotus Notes and decide which databases should be moved to Oracle.
• Developed forms and views for the application.
• Used ASP Components to interact with Client and Server.
• Used MSXML3.0 to convert the data in XML format for further processing of data on client machine avoiding round trip to database.
• Coding in ASP and HTML to generate intranet enabled Reports.
• Connecting to Oracle using DECS connectivity.
• Migrated Notes Data to oracle using DECS.
• Written lotus script and scheduled to run on DECS for inserting, updating and deleting Records.
• Proposed a New System to be developed in Java using three-tier architecture.
• Crystal reports was used for reporting on the web.
• Developed a Prototype in java.
• Design high-level system structure, implement system design from specifications.
• Prepared a Project Plan and Migration Plan for the new system.
• Administered and supported multiple Domino Servers including creating new IDs, scheduling replication, rebuilding damaged views, renaming users, database management on servers etc.

Environment :
Lotus notes 4.6.2, HTML, JavaScript, HTML, LotusScript, Excel, Communicator & Internet Explorer, Windows NT 4.0.

Description :
This system was developed for the software Engineering Group to maintain the information of the servers in the The Best Bank Network. The information stored included the servers in the Private Clients Group, Answer Centers, Call centers and branches. The database stores one record in the database for each of the servers in the network. Several forms were designed in this database. Each form provides a different view of data depending upon the purpose of inquiry. Users can inquire form on a row of data or perform data entry on fields for which access has been granted. The field engineers in rebuilding or replacing the hard drive for a server use the Print form or configuration sheet.

• Involved in the System study design of forms and views for the application.
• Created Detailed Design Document Specification.
• Prepared functional document based on user requirements.
• Interacted with the clients and gathered user requirements.
• Design high-level system structure, implement system design from specifications
• Setting up the Security levels for the databases.
• Developed agents, which use OLE automation objects for exporting data from notes to excel.
• Loading or importing SQL data to notes using lotus script.
• Created roles for the database access and prepare access control list for setting up the database.
• Testing of data was done in the development server using the dummy ids.

Environment :
Lotus notes 4.6.1A/ Domino, HTML, Java Script, Lotus script, Peoplesoft, NotesPump, Netscape Communicator & Internet Explorer, Windows NT 4.0.

Description :
This system was developed for the management to monitor the performance of the employee each year. Before the beginning of each quarter, based on the corporate directives and specifics communicated by the supervisor, the employee sets the objectives and fills them in the appraisal form on-line and communicates the same to the supervisor with the URL. At the end of each quarter, supervisor evaluates the performance of each employee against the objectives and sends e-mail to his manager with URL, for review. Depending on the ratings, given by the manager and the supervisor, the employees are given benefits and measure to improve the performance and initiated. At the end of the year, batch job is used to copy the performance ratings into People Soft database.

• Involved in the System study design of forms and views for the application.
• Developed written agent that sends e-mail memo with URL of the documents for review and comments.
• Created a button that composes a memo form and sends a reply message to the supervisor.
• Created fields for authors and readers in the forms, roles for the database access and prepare access control list for setting up the database.
• Setting up the Security levels for the databases.
• Lotus Pump to connect domino and peoplesoft database for querying, updating and modifying data.
• Wrote Lotus script agents to populate data into People soft from domino.
• Developed crystal reports for Master Contract
• Developed PO commitment report and PO status report
• Modified PO printing based on the user requirements
• Developed Open order listing for Inventory
• Developed Receiving Line Asset Report
• Developed Inactive Items, brand name wise report and Transaction history report.
• Business Unit wise report of item master list and item group re-order quantity report.
• Testing was done by writing dummy IDS.

Environment :
Lotus notes 4.5,Lotus script, Lotus Components OLE , Notes Pump, Oracle 7.x, Windows 95, HTML, Java Script, Windows NT 3.51

Description :
This application was developed for a construction company to know the status of the project. This system helps in creating a project report at a site and reviewing it on line in the head office. This application has two databases - Report Database, Archive Database

• System study, Designing and developing forms, Testing and implementation.
• The Report Database prepared at the site helps to create and maintain its project details. This report is updated daily to the head office online. Lotus component was used to create sheets, according to the user s right of access.
• The Archive Database at the site maintains archived reports for that site. The H.O. maintains archived reports for all sites.
• The report consists of several sections like the contractor particulars, Executive summary, financial status, Progress report and Project personnel. These sections can be created at the site-by-site personnel. Easy to use navigators are provided to help in creation or viewing the report. The report reviewed is sent back to the site where it is kept in the report database for about two months. It is then archived and moved to the Archive database where old reports are maintained.
• Used Lotus Pump for connecting to Oracle Database for inserting, updating and modifying records.
• Carried out Unit level, system level and module level testing at different phases of the project by inputting test data on the test server. Involved in testing the system for user acceptance by inputting data during implementation for getting user acceptance certificate.
• Setting up the Security levels for the databases.
• Setting up the Notes servers on Windows NT 4.0 with single logon using TCP/IP Protocol
• Registering users and configuring the notes client on NetBEUI Protocol.
• Providing Access control list to each database according to the user needs.
• Regular scheduling for backup of the servers and tuning the databases.
• Migration of Notes Databases into Exchange as a test case.

Description :
This application helps the company in recruiting new candidates who sent in their bio- data for various positions. This maintains details of existing employees like qualifications, work experience, personal details etc. This also helps the HR in evaluating the employees at the time of annual appraisal. Carried out Unit level, system level and module level testing at different phases of the project by inputting test data on the test server. Involved in testing the system for user acceptance by inputting data during implementation for getting user acceptance certificate.

Environment :
Lotus notes 4.5,Lotus script, HTML, Java Script, Windows 95, Windows NT 3.51

• System study, Designing and developing form, testing and implementation.
• Involved in the System study for the application.
• Developed forms and views for the application
• Designing and coding of several forms and agents within the application using Lotus Script and Formula languages.
• Database has different access levels like Manager, author, reader or other for different users, taking into consideration security aspects.
• Lotus Script was used to ensure the security of the application.
• Carried out Unit level, system level and module level testing at different phases of the project by inputting test data on the test server.
• Involved in testing the system for user acceptance by inputting data during implementation for getting user acceptance certificate.

Environment :
Lotus notes 4.0,Lotus Script, Windows 95,Windows NT 3.51

Description :
The application was developed to keep online tracking of the machines in the company across various locations. This application not only keeps track of the systems in the company, but it also enables users to report the problems they face daily, through Notes Mail to the System Administrator, who can solve their problem. It also maintains details of the vendors and availability of software CD-ROM in the company.

• System study Designing and developing forms and implementation.
• Involved in the System study for the application.
• Developed forms and views for the application
• Designing and coding of several forms and agents within the application using Lotus Script and Formula languages.
• Database has different access levels like Manager, author, reader or other for different users, taking into consideration security aspects.
• Setting up the Security levels for the databases.
• Lotus Script was used to ensure the security of the application.
• Carried out Unit level, system level and module level testing at different phases of the project by inputting test data on the test server.
• Involved in testing the system for user acceptance by inputting data during implementation for getting user acceptance certificate.
• Setting up the Notes servers on Windows NT 4.0 with single logon using TCP/IP Protocol
• Registering users and configuring the notes client on NetBEUI Protocol.
• Providing Access control list to each database according to the user needs.
• Regular scheduling for backup of the servers and tuning the databases.
• Provided Daily Administration and Troubleshooting for Notes Network which included:
• Creating User accounts, Creating Server IDs, ID Management, Maintained Domino Clusters, Maintained all aspects of the Name and Address Book, Created Certifiers, Configured and Maintained ACLs,
• Maintained Domino Servers Across Multiple Platforms,
• Performance Monitoring, Preventive Maintenance and Insured Reliable Mail Routing and Replication
• Experienced Troubleshooting Server-to-Server and Client-to-Server Connectivity Issues related to TCP/IP, SPX/IPX, Token Ring, Ethernet, Firewalls, Gateways, Dial-ups, Replication and Domino Passthru Servers

Environment :
Lotus notes 4.5, Lotus script, Operating system : Windows 95, Windows NT 3.51

Description :
This application was developed to crosscheck the workdays utilized for each Project. The project leader allocates modules to each programmer with a time schedule to complete it. The programmer has to enter the details of his/her work during the day. Suppose a project gets over before the schedule date and the programmer has been updating his technical skills during the free time, said particulars are also entered into the system. This helps the HR to know whether he/she has effectively utilized the free time. This helps the company during the time of performance appraisal. It stores Client and their corresponding Project details. It also keeps track of Project Allocation and Project Activity details of each Associate. Carried out Unit level, system level and module level testing at different phases of the project by inputting test data on the test server. Involved in testing the system for user acceptance by inputting data during implementation for getting user acceptance certificate.

Role : System study, Designing and developing forms, Testing and implementation.

Environment :
Progress 6.0, UNIX

Description :
It is a Customization of MFG PRO Package .It analyzes the sales made in a day in each area like credit Sales, debit Sales, payment details and group wise inventory details.

Environment :
Progress 6.0, Unix

Description :
It is a Customization of MFG PRO Package. It captures data online regarding sales & transfers by the factory and the clearing and forwarding agents. It also generates Reports like daily Sales Report, weekly sales report, cashbook analysis and others.

Environment :
FoxPro 2.5, Novell NetWare.

Description :
Application generates multiple invoices, pre and post shipped documents, post balances to Accounts system automatically. Monthly sales tax statement, sales performance reports are some of the reports generated.

Environment :
FoxPro 2.5, Novell NetWare.

Description :
Application takes care of raw material purchase, inventory maintenance, production schedules. Purchase summary report, stock availability, and pending bills are generated.