Posted by on July 21, 19101 at 19:14:57:
Mohamed Khan Khan_Mohamed@hotmail.com
+001-804-825-4970 (USA)
5 years of experience in the IT industry, in the various phases of software development life cycle, with excellent knowledge of relational databases and in-depth knowledge and hands-on experience in design, development and implementation of Siebel, Oracle, and Visual Basic. I am proficient in Client-Server, Customer Relationship Management (CRM) application development and have strong knowledge and experience in requirement analysis, design, testing and configuration. Worked with Sales Force Automation, Customer Support and Actuate Reports application software.
Education
M.C.A (Master of Computer Application) from Bharathidasan University 1992-95 – First Class
B.Sc. (Bachelor of Physics) from Madurai Kamaraj University 1989- 92 – FirstClass
Technical Skills
Operating System: Windows NT 4.0, Windows 95/98, Ms Dos
Databases: Oracle 7.x/8.x, SQL Server 6.5/7.0, DB2, MS Access
Languages: Turbo C, C++, COBOL and FORTRAN
GUI Visual Basic 5.0/6.0
CRM Siebel 99/2000
(Configuration, EIM, Product Configurator, Smart Script, VB Script/ e Script)
Report Tool Actuate 3.0/4.0, Crystal Reports, Cognus
Project Details
Project Name: Sales Force Automation
Client Name: Aspect Inc, California (Jan 01 – May 01)
Environment: Windows NT 4, SQL 7.0, Siebel Call Center 2000 and Actuate 4.0
Responsibilities as a CRM Consultant
· Created Technical Design Document
· Created and Modified Business Objects
· Using Siebel tools to create different Links and Joins, Applets and Multi Value Group(MVG)
· Data mapping between Siebel and legacy system for EIM process
· Configuring Extension tables and creating new columns for configuration
· Running Server tasks for EIM to migrate data from legacy system to siebel database
Performed Database extracts and backup of repositories files and perform imports and exporting of data in the Siebel database using EIM. Analyzing the data to be imported and the interface tables for proper transfer of data. Used the database SQL Server tools like Data Transformation Service to the legacy database for exporting/importing data into the Siebel interface tables. Analyzing and preparing the interface tables. Check the EIM Configuration file and make the required modification to it. Running the EIM process after an initial test run on the sample data. Check the base tables and their columns for the expected results. Writing SQL queries for data mapping
· Written Siebel VB/e Script to invoke triggers
· Developed test plans and test data
· Created new Actuate Reports and modified Siebel Vanilla Reports
· Created a Model for sales quote through Product Configurator.
Project Name: Siebel Call Center Application
Client Name: Harris Corporation Inc, California (Aug 00 – Dec 00)
Environment: Windows NT 4, Oracle 8.0, Siebel Call Center 2000
Responsibilities as a CRM Consultant
· Documented all objects and field mappings to facilitate mappings to interface tables and EIM processes into base tables of Siebel.
· Developed and implemented customized views for Contacts, Accounts, Literature, Activities and Application administration of data maintenance and user control functionality. Customized the synchronization capabilities of Siebel data with Outlook applications. Business Objects Contacts, Calendar, and activities had modified.
· Performed trouble-shooting, debugging, and technical support duties for over 80 mobile national sales representatives, the sales planning and analysis department, and directors in the production environment.
· Created Pop-up Screens and customer interactive screens through smart scripts.
· Design and develop Cross-sell functionality using custom Business Components, SmartScripts and Script VB.
· Performed Database extracts and backup of repositories files and perform imports and exporting of data in the Siebel database using EIM. Analyzing the data to be imported and the interface tables for proper transfer of data. Used the database Oracle SQL Loader tools like Data Transformation Service to the legacy database for exporting/importing data into the Siebel interface tables. Analyzing and preparing the interface tables. Check the EIM Configuration file and make the required modification to it. Running the EIM process after an initial test run on the sample data. Check the base tables and their columns for the expected results.
Project Name: Interactive Training System
Client Name: P & O Containers, London (Sep 99– May 00)
Environment: Windows NT 4, Oracle 8.0, and Visual Basic 6.0
Responsibilities as a Programmer Analyst
· Developed for P&O Containers, London. This system consists of knowledge, acquisition component, presentation component & off-line utilities as major modules. The sequencer is the main working environment of the knowledge acquisition module.
· The inputs to the module are accepted from the designer through the keyboard or the mouse.
· The sequencer is represented as icons with labels on a flow line that resembles the file manager in Windows. The presentation module is the end result of a designer’s effort in developing a training material. The off-line utilities module consists of operations like Install, De-install, etc. The project uses MS Access Database for Data Storage and multimedia Authoware Professional for effective presentations.
Project Name: Stock Control System
Client Name: Easylink Information Systems (May 98 – Aug 99)
Environment: Windows NT 4, Oracle 7.3 and Visual Basic 5.0, Crystal reports
Responsibilities as a Programmer Analyst
VB [Object Oriented RDO programming] with ORACLE as backend.
Designed to implement three - tier architecture. Also developed stored
Procedures and views using ORACLE for this system.
· The system was specifically designed to handle the inventory of garment industry where all materials belong to a kind of an order and a style.
· The system covers most of the issues like Payment requisition, purchase order, , allocation, deallocation, reallocation, internal requisition and so on.
· Some of the modules and reports done are:
i) Goods Return To Supplier
ii) Payment Requisition
iii) Activity Report
· Age Analysis, ABC Analysis, Stock Holdings Summary & Item
· Allocation Summary.
· Reports for various stocks
· General Report, Required Item Detail.
· Stock Movement Summary Report and Tax Details.
Project Name: Equipment Maintenance System
Client Name: SPIC LTD, India (May 97 – Apr 98)
Environment: Windows NT 4, Oracle 7.3 and Visual Basic 5.0
Responsibilities as a Programmer Analyst
· The System Preventive Maintenance System has been Developed primarily to ensure that all plant /equipment is maintained in a cost efficient manner and is to reduce the frequency of equipment breakdown into minimum.
· The System will provide the Plant Engineering Maintenance department the capability to prepare in Advance the necessary man power and spare parts requirement and step by step work/task description For a pre-scheduled preventive maintenance.
· Additionally, the System will help the plant engineer to access the performance and reliability and maintenance cost effectiveness of each equipment by keeping Track of the frequency of their preventive as well as corrective measures. This system calculating the man-hours and Spare Parts used for the maintenance and generating daily and monthly reports.
Project Name: Payroll cum Attendance Maintenance System
Client Name: ABK-AOTS-DOSOKAI, Japan (Nov 96 – Mar 97)
Environment: Windows NT 4, Oracle 7.3 and Visual Basic 5.0
Responsibilities as a Programmer
· System includes Payroll System and Attendance Maintenance Modules.
· Payroll System takes care of pay information of employee’s .It includes employee Personal information, Loan Details, Allowances and Deductions & Preparation of PaySlip.
· The Attendance Maintenance System takes care of maintaining the attendance of employees in hour basis. It handles absentee’s list, over time and lack of time in working hours. Preparation of daily attendance reports to report to the Human Resource Department.
Project Name: Accounting Information System
Client Name: Kurlon Limited, India (May 96 – Sep 96)
Environment: Windows NT 4, Oracle 7.3 and Visual Basic 5.0
Responsibilities as a Programmer
· System includes preparation of Balance Sheet, Profit & Loss Account from Trial Balance.
· The Balance Sheet Module takes care of all sources like share holder funds, Loans, Application Funds
Etc. Every source is identified by a schedule name.
· The Profit and Loss account Module includes information about Expenses and Incomes of the company.
· Every source has a schedule name to identify the account and this package facilitates to prepare all types of Reports.
Project Name: Sales Distribution System
Client Name: AJ Company Pvt. (LTD), India (Jan 96 – Apr 96)
Environment: Windows NT 4, Oracle 7.3 and Visual Basic 5.0
Responsibilities as a Programmer
· Involved in order entry and maintenance module.
· Screen developed using visual basic forms
· Form validation
· Designed customer master and item master tables.
· Restocking Inventory
PERSONAL DETAILS:
Date of Birth : 15 June 1972
Nationality : Indian
Phone Number : +91-4652-228710 (India)
+001-804-825-4970 (USA)
Passport Number : U470182 (Valid upto 2005)