Posted by on March 32, 19103 at 12:06:07:

Satvinder Mann is presently working as a Software Architect with IT Factory that is a Denmark based company and deals with various products and third party tools. She has 4 and a half years experience in full cycle software development including system study, analysis & design, development, testing and implementation.

Professional Qualification:
v CLP Principal in Domino R5 Application Developer.
v Certified Lotus Professional in R5 System Administration.
v Certification in DB2 Administration.
v Advanced Diploma in Software Development (NIIT, Delhi) [1997- 1999]

Educational Qualification:
v Master of Computer Applications (IGNOU, Delhi)
v Bachelor of Science (Zoology Hon. Delhi University 1994 –1997)
v Pursuing Masters in Business Administration (PTU Online)
v CBSE - Senior Secondary (10+2)
1992–1994 Hillgrove Public School Delhi

Work Experience:
Working with IT Factory as Software Architect since August 2002.
Worked with Global GroupWare Solutions as Team Leader from August 1998 – July 2002.

Projects Undertaken:

Company: IT FACTORY A/S (ITF) provides market-leading technologies that manage the non-transactional business processes based on, and fully integrated to, ERP and CRM systems and messaging platforms.

ITF’s collaborative solutions are built around core business applications that have a direct impact in areas such as sales force automation, knowledge management, human resources, customer relationship management and a host of others. The development environment includes a host of award winning application development tools for IBM’s Lotus Notes/Domino platform.

CUSTOMER CARE SOLUTION
This project was developed on J2EE and Lotus Notes. Both The applications accessed the same Database Instance in Oracle. This application delt with providing a customer care software solution. The Users will register themselves and post queries. The company providing the customer care solution will then provide solutions via e mail to the registered customers.
As a Software Architect she is responsible for:
v System study and Documentation of the Process flow.
v Understanding of the business logic to be developed.
v Connectivity of Lotus Notes with Oracle using LEI.
v Synchronization of data between the Lotus Notes Application and J2EE application.
v Designing the database Forms, ACL rights, Views and screens.
v Co-ordinating with the team members.
v Coding, Unit Testing & Integration Testing.
SYSTEM ENVIRONMENT: Windows 2000, Lotus Notes R5 & Domino, EJB 1.0, Web Sphere 4.0, Seagate Crystal Reports, JSP, Servlets, HTML, JAVA Script, Oracle, XML.

PROJECT MANAGEMENT
Project Management is a product developed through the integration of Lotus Notes and MS Project 2000. The application is developed in order to maintain and manage the projects within different teams in an organization. It is designed in a way that all the tasks updated in Lotus Notes are updated in MS Project and vice versa.
As a Software Architect she was responsible for:
v System study and Documentation of the Process flow.
v Understanding of the business logic to be developed.
v Co-ordinating with the team members and the support team.
v Connectivity of Lotus Notes with MS Project.
v Designing the database Forms, ACL rights, Views and screens.
v Coding, Unit Testing & Integration Testing.
v Deployment of the application on RNext and testing of the same.
SYSTEM ENVIRONMENT: Windows 2000, Lotus Notes R5 & Domino.

HUMAN RESOURCES MANAGEMENT
Human Resources Management is an application developed to manage the HR processes within an organization that includes 3 main modules: Recruitment, Courses and Staff. The application can be accessed both from the Notes Client as well as Web client. The role of HRM starts at the point when an organization needs to recruit new people in the different departments. Any person can apply for any of the positions in the organization. There is an approval cycle for the same. The HRM also handles the process flow for appraisals and trainings for the employees.
This application was also deployed using Websphere as the application server and Lotus Domino as the HTTP server. The servlets used JDBC drivers, and using simple SQL queries the data was fetched and inserted into Notes.
As a Software Architect she was responsible for:
v System study and Documentation of the Process flow.
v Connectivity between Domino and Websphere and development of the servlets.
v Deployment of the application on Websphere.
v Enhancements for the HRM flow.
v Studying of other HRM projects.
v Understanding of the business logic to be developed.
v Co-ordinating with the team members and the support team.
v Connectivity of Lotus Notes with MS Project.
v Designing the database Forms, ACL rights, Views and screens.
v Coding, Unit Testing & Integration Testing.
SYSTEM ENVIRONMENT: Windows 2000, Lotus Notes R5 & Domino, Websphere Application Server, Application Assembly tool.

Company: GLOBAL GROUPWARE SOLUTIONS is one of the leading Customer Relationship Management Solution provider in India providing solutions both in Lotus Notes and Java based solutions. She was working as a Team Leader.

APPLICATION TRACKER/ LEAD TRACKER FOR MAX NEW YORK LIFE, INDIA
MNYL, has automated the Lead Tracking and Application Tracking System at their 9 General Offices throughout India and 1 Home Office. The application is designed to capture customer leads received via various sources like telephone, cold calls etc, and keeps a track of the various leads, their status, and thus maximizing the closed cases, and having centralized information across all the locations. It also includes the Application Tracker to keep a track of the application received at the various locations.
As a Team Leader she was responsible for:
v System study and preparation of Process flow/Workflow Diagram, Functional Decomposition Diagram, Data flow Diagram.
v Preparation of User Requirements Document and Detailed Design Document.
v Implementation of user and location based security, and replication.
v Designing the database Forms, ACL rights, Views and screens.
v Integration of the system with the Amarta, a system developed in Oracle.
v Understanding the business logic, and co-ordintation between the end users and the team members.
v Coding, Unit Testing & Integration Testing.
v Working in co-ordination with the Implementation team for the User level Trainings.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 & Domino.

TELEPHONE EXPENSE CLASSIFICATION FOR MCKINSEY KNOWLEDGE MANAGEMENT CENTER, GURGAON
The Mckinsey Knowledge Management Center, comprises of 140 members. MCKC members need to make telephone calls on a regular basis. It is required that each such telephone call made as part of research for a particular project be associated with the charge code of the project. Every user is assigned a user code that is entered as part of the dialing string while making the telephone call.
The organization uses a Definity EPBAX from Tata Telecom Ltd. The software associated with the EPBAX gives the organization the ability to take a regular extract of the telephone call log. Beforehand, this was made available on a user wise basis to individual consultants in MS Excel format, who then enter the requisite charge code against each entry.
The application runs at the Corporate Office In Gurgaon. With users at the eight GO locations working with local copies of the application databases on their individual desktops. These databases are replicated with the Domino server at the Corporate Office at regular intervals for exchange of updates.
As a Software Analyst she was responsible for:
v System study and preparation of Process flow/Workflow Diagram, Functional Decomposition Diagram, Data flow Diagram.
v Preparation of User Requirements Document and Detailed Design Document.
v Implementation of user and location based security, and replication.
v Connectivity of Lotus Notes with MS Access and MS Excel.
v Designing the database Forms, ACL rights, Views and screens.
v Coding, Unit Testing & Integration Testing.
v Working in co-ordination with the Implementation team for the User level Trainings.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 & Domino.

SMILES - A CUSTOMER RELATIONSHIP MANAGEMENT SOLUTION
Smiles CRM is a product developed and marketed by Global GroupWare solutions. Smiles helps its users nurture individual customers, enchant them with quick efficient and responsive service, and build abiding relationships with each one of them It leverages the enabling information technologies
to help gain organizations customer fidelity, provide personalized service to customer, acquire better knowledge of customer.
Smiles eliminates multiple mouse clicks to switch between three different applications for managing your information related to your much valuable customer. Smiles brings in three different spikes of CRM under the same umbrella reducing your precious time and helping you in good and effective management of data. The three different modules in Smiles are:
1. Sales Force Automation (SFA).
2. Order Fulfillment Automation (OFA).
3. Customer Support Automation (CSA).
Name of the each spike of an umbrella is self-explanatory and it informs you how all the widespread areas of Customer Relationship Management has been covered in a skillful manner in Smiles.
Smiles combines flexible and powerful features that are ideally suited for organizations and provides multi-location support. It provides an easy to use edit features to enable user to manipulate information within the application. Ideally, Smiles is best if used with all the modules but it does not deprive you of the option of opting for the only required modules.
Smiles allows company to track sales opportunities within a clearly defined sales cycle. Critical information relating to sales opportunity such as sales value, items, close date and key contacts can be recorded. As an opportunity progresses, the sales cycle status is updated, allowing a company take a snapshot of its position at any moment in time.

Smiles is developed in 3 versions:
1. Client -server based application developed for Lotus Notes clients with Lotus Notes as the main platform.
2. Web based application using Lotus Notes as the platform and using JavaScript and Servlets for different tasks.
3. Web based application developed with WebSphere Studio and DB2 as the back end database.

Her responsibilities included:
Understanding the industry requirements, preparation of Process flow/Workflow Diagram, Functional Decomposition Diagram, Data flow Diagram.
Designing the screens and defining the security of databases at User Level, Server Level and also for Web Users.
While working on the client server based application her responsibility include:
v To integrate the new technologies, and enhance the product features.
v Coordination with other team members.
v Adding all the workflow related and other validations.
v Designing the user interface, using Pages and forms.
v Provided the facility of deletion of documents at the view level according to the role of the user.
v Hosting a part of the application on the web to be accessed from any part of the world by valid users and customers in order to have a look at the status of their complaints.
v Designing the database Forms, ACL Rights and Views.
v Writing the Agents and preparation of the flow of the escalation.
v Generating the report from Smiles by using the functionality of Notes and Crystal Reports.
v Standardization of the error messages throughout the application.
v Integrating Lotus Notes with other platforms like SQL using DECS Administrator.
v Coding, Unit Testing & Integrated Testing.
v Presentation to the various prospects.

While working for the Web based application using Lotus Notes, her responsibility included:
v Coordination with other team members to have better understanding of the product.
v Making the enhancements in the product.
v Using JavaScript for all the validations.
v Designing the user interface, using Pages and HTML.
v Provided the facility of deletion of documents at the view level by integrating the Java Script and HTML.
v Hosting the database on the web to be accessed from any part of the world by valid users.
v Designing the database Forms, ACL Rights and Views.
v Writing the Agents.
v Generating the report from Smiles by using the functionality of Notes and Crystal Reports.
v Implementation of Frames for the Web by making use of Notes, JavaScript & HTML features.
v Defining and Designing User Interface Standards for Web Applications.
v Coding, Unit Testing & Integrated Testing.
v Standardization of the error messages throughout the application.
v Maintenance of the time sheets, status reports and conducting status report meetings.
v Presentation to the various prospects.

While working for the Web based application using DB2 and WebSphere Studio, her responsibility included:
v Part of the Design Team, based on MVC (Model View Controller) pattern.
v Developed the sales and the service module of the system.
v Design security for the product and was involved in development of the same.
v Design the user role allocation security for the product and was involved in development of the same.
v Involved in solving key issues of the application such as memory leakage, connection pooling, transaction management, error handling and application deployment.
v Provided the generic solution for the reports, which includes user defined reports, exporting of data and format in text file and viewing the report through report viewer built in Visual Basic
v Making the enhancements in the product.
v Using JavaScript for all client side the validations.
v Designing the user interface, using JSPs and HTML.
v Creating the table structure needed for the application.
v Writing the Servlets.
v Defining and Designing User Interface Standards for the application.
v Coding, Unit Testing & Integration Testing.
v Standardization of the error messages throughout the application.
v Presentation to the various prospects.

SYSTEM ENVIRONMENT: Windows NT 4.0, DB2, and Visual Age for Java, WebSphere Application Server.

SALES FORCE MANAGEMENT (A MODULE OF SMILES CUSTOMISED)
To be able to track sales cases in a structured fashion across all the Business Units, Tele Dynamics Sdn. Bhd. (Malaysia) wanted automation of the Pre Sales Process. As a Project in-charge her responsibilities included:
v Collecting client requirements, System study, preparation of Process flow/Workflow Diagram, Functional Decomposition Diagram, Data flow Diagram and preparation of the complete Functional Specification Document.
v Preparation of User Requirements Document and Detailed Design Document.
v Designing the screens and defining the various security-levels like User Level, Server level and for Web Users.
v Designing the database Forms, ACL Rights and Views.
v Writing the Agents.
v Used Notes and Crystal Reports for report generation.
v Integration of Lotus Notes with the Progress database.
v Providing the security using Reader's name fields and author fields in the application.
v Coding, Unit Testing & Integration Testing.
v Preparing and maintaining the time sheets, status reports and project schedules.
v Implementation at the client site, and conducting the User Training.
SYSTEM ENVIRONMENT: Windows 98, Lotus Notes R5 & Domino.

CUSTOMER RELATIONSHIP MANAGEMENT (FOR CARRIER AIRCON, INDIA)
Carrier Aircon, India has automated both the Pre-Sales activities and Service Centre. The application is designed to handle sales inquiries and complains received telephonically and via paper format, and also provides handle all the calls logged by the customer either directly or via web. The application also provides a VB interface to view the customized and parameterized crystal reports.
As a Senior Developer she was responsible for:
v System study and preparation of Process flow/Workflow Diagram, Functional Decomposition Diagram, Data flow Diagram.
v Preparation of User Requirements Document and Detailed Design Document.
v Designing the database Forms, ACL rights, Views and screens.
v Coding, Unit Testing & Integration Testing.
v Creating the interface for the parameterized reports using VB and crystal reports.
v Creating the web interface for the customers to log a complaint directly from the Web.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 & Domino, VB 5.0 and Crystal Reports 7.0.

CUSTOMER ASSISTANCE CENTRE (CAC FOR MERCEDES BENZ INDIA LIMITED)
Mercedes Benz India Limited, head quartered in Pune, India has automated their Customer Assistance Centre, both from the sales and service perspectives at the corporate level. The application is designed to handle sales inquiries and complains received telephonically and via web or paper format. The application also provides connectivity with Oracle database and a VB interface to view the customized and parameterized crystal reports. The application sets connectivity between MS Exchange and Domino for the routing of mails
As an Analyst her responsibilities included:
v Preparation of Functional Decomposition Diagram, Data flow Diagram.
v Preparation of User Requirements Document and Detailed Design Document.
v Designing the screens, database Forms, ACL rights & Views.
v Writing the Agents.
v Coding, Unit Testing & Integration Testing.
v Continuous connectivity of Lotus Notes with the Oracle database and FoxPro database
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 & Domino, VB 5.0 and Crystal Reports 7.0.

SALES FORCE AUTOMATION (FOR TATA TELECOM LTD.)
Sales Force Automation makes all instances of contact with the prospective customers transparent. It keeps track of all opportunities that might translate into sales orders for an organization. The application helps the organization build up a knowledge base to support sales & marketing personnel so that the company can have a complete picture of all the prospective Customers and can always follow with these customers at regular interval of time after understanding their area of business. Besides this, it includes the introduction of suspect in a company and covers the whole process till it converts to a relationship i.e. lead management, follow-ups and request for invoicing. It had to be implemented in different locations of the Client Company and thus maintaining the security of the system according to the user roles and locations.
As a Groupware Analyst, she was responsible for designing the application using the features like workflow, section security and edit access control. She had provided the security to the database using the concept of "Reader names" and "Author names". Reports generation was done using the Crystal Reports and Notes. She was also responsible for the coding, unit and integration testing.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 and Domino, VB 5.0 and Crystal Reports 7.0.

CUSTOMER SUPPORT AUTOMATION APPLICATION (TRANSMARCO DATA SYSTEMS, SINGAPORE)
The application developed for Transmarco Data Systems (S) PTE Ltd., Singapore creates a set of inter-linked automated processes so as to minimize data entry by users. Few modules like Pre-Service process for Invoiced Service Entities, Pre-Service process for contracted service entities, Loan and collect process, third party repair process and project tracking process were included besides the basic CRM module. The application provides the continuous connectivity of Lotus Notes with the SQL Server and the FoxPro database with the help of which data gets updated both in Notes and SQL database. It also provides the facility of logging a call on web, and faxing and paging services directly from Lotus Notes.
As a Groupware Analyst, she was responsible for designing the system, databases, forms & views, coding, testing and connectivity with SQL and FoxPro and MS Access with Lotus Notes and creating the Crystal Reports and the VB interface required for viewing the reports and implementation at the client site.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 and Domino, VB 5.0 and Crystal Reports 7.0.

CUSTOMER RELATIONSHIP MANAGEMENT (TATA INFOTECH LIMITED, INDIA)
Tata Infotech Limited, which was using the older version of Smiles on 4.6, upgraded to Smiles on 5.0 and thus needed all the data to be uploaded from existing databases. The application that is a full-fledged CRM package provides an automated environment at four different locations where the users of each location can view the data pertaining to their respective locations and the locations reporting to them.
As a Groupware Analyst, she was in-charge of the process flow in Lotus Notes, coding and testing and documentation of the enhancements added to the application. She was also involved in creating the web interface for the clients to log a complaint against the service entities that they have, so that they are able to view the status of their complaints as well. She was involved in creating the Crystal Reports and the VB interface required for viewing the reports as well as maintaining the security issues of the application
She was also involved in the migration of the application from 4.6 to R5.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes R5 and Domino, VB 5.0 and Crystal Reports 7.0.

ORDER DETAIL FORM (TATA TELECOM LTD., INDIA)
The application is designed in order to enhance the scope of Smiles product and integrating the invoicing process with the Service Support module. The application provides an integrated environment whereby the users can keep a track of the orders placed and the payments due for each customer along-with the details of the service entities and the customers.
This application was first designed on Notes 4.6, and then was migrated from 4.6 to Version 5.0. This also included changing the security of the application according to the new Organizational Hierarchy.
She was responsible for designing the system, designing the databases Forms, ACL Rights & Views, Writing the Agents, Coding & Implementation, Integration with Oracle database and creation of Crystal reports using Notes directly.
She was also involved in the migration of the application from 4.6 to R5, and changing the security of the application accordingly.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes 4.6, Lotus Notes R5 & Domino.

CHANNEL SALES PROCESS MANAGEMENT (CSPM, BHARTI CELLULAR LTD., INDIA)
An application in 4.6 to facilitate Airtel receive an application for SIM cards & Recharge Coupons from its dealers, issue SIM cards & Recharge Coupons, and track the payment details. The workflow is to operate between these distributors and the Sales, Accounting and Stores Departments at BCL. The primary needs being addressed by this application are procedure based and streamlined communication with distributors, and MIS generation based on the information gathered during the workflow. CSPM combines flexible and powerful features that are ideally suited for organizations and provides multi-location support. It provides an easy to use edit features to enable user to manipulate information within the application.
This application was first designed on Notes 4.6, and then was migrated from 4.6 to Version 5.0.
Her responsibility included designing the system, designing the database Forms, ACL Rights & Views, Writing the Agents, Coding & Implementation, Integration.
She was also involved in the migration of the application from 4.6 to R5 according to the new Organizational heirarchy.
SYSTEM ENVIRONMENT: Windows 95, Windows NT 4.0, Lotus Notes 4.6, Lotus Notes R5 & Domino.

CAR LOAN APPROVAL SYSTEM
The application creates a set of modules that keep a track of the knowledge base, and the setup of the organization. The application keeps a track of the loan processes starting from the entry of the loan form by the agent to the approval of the loan and disbursal of the loan amount to the customers, maintaining the security at the same time.
She was in-charge of creating the crystal reports and the VB interface for the 3 locations each having a different set of reports, creating the master forms in Lotus Notes and connectivity of Notes with MS Access

SPARES MANAGEMENT SYSTEM
Spares Management System is a comprehensive system; the front-end is developed in VB with data existing in MS Access and supported by Lotus Notes for connectivity across different branches of organisation in the Country. Countrywide tracking of spares movement is facilitated through this Application.
She was in-charge of creating the forms in Visual Basic, connectivity of Lotus Notes with MS Access and the replication of the data from one location to the other, unit testing and integrated testing, as well as creating crystal reports for the application.

Software Skills:
Hardware Intel Pentiums
Operating Systems Windows NT, windows 95, Linux
Languages JAVA, EJB, Lotus Script, Servlets, JSP, Java Script, HTML, C, C++, SQL, JDBC, VC++.
Groupware Lotus Notes 4.6, R5 & Domino, Lotus Notes RNext
Databases DB2, Oracle, MS Access, SQL 6.5, 7.0, FoxPro, Progress.
Web Technologies JAVA SCRIPT, HTML,
Others VB 5.0, Crystal Reports 4.6, 7.0 AND 8.0