RAJEESH SUMMARY Rajeesh has over 9 years of working experience in design and coding Web and Client Server Applications under Microsoft Windows platforms with over two years of experience in ASP, Visual Interdev, VBA, HTML, VB and Java Script and IIS. He is Well-versed in Visual Basic, Oracle ,SQL Server and MS Access. He has Eighteen months of Singapore experience with JP Morgan, Western Digital and Texas Instruments. He has completed Bachelors Degree (B.Tech) from Regional Engineering College in 1994.He is a good team player with good communication skills and currently working with FORD motor company as a Team Lead. TECHNICAL SKILLS Operating System : WindowsNT,Windows95,DOS Web Server Technologies : Internet Information Server, Active Server Pages, Personal Web Server, Commercial Internet System, Microsoft Transaction Server Component Development : ActiveX Controls, Component Object Model (COM), OLE Browser Technologies : Cross Browser Development with Internet Explorer and Netscape. Data Access & Databases : ODBC, ADO,DDE, Oracle 8.0/7.3/7.0, MS-SQLServer6.5/6.0,MS-Access97/2.0 Languages : HTML, Dynamic HTML, JavaScript, VB Script, Cascading Style Sheets Visual Basic for Applications ,SQL,C Development Tools : Visual Interdev6.0/1.0,Visual Basic 6.0/5.0/4.0, Visual Studio6.0/5.0 TOAD,SA Fileup,Crystal Reports 5.0/4.5 Networking & Protocols : Windows Sockets, TCP/IP Office Development : Excel97/7.0,Access97/2.0, Frontpage98/1.0 Graphics Tools : Paint Shop Pro, Adobe Photo shop , MS-Image Composer Messaging : MS- Outlook ,Netscape ,MS-Exchange Client, Lotus Notes Web Sites :Southindianbooks.com(E-Commerce),JigsawpuzzleBand.com,Rajeesh.com EXPERIENCE FORD MOTOR COMPANY ,USA PROJECT : GLOBAL PARTS PRICING SYSTEM (GPPS) 01/01 –TILL DATE ROLE : TEAM LEAD TEAM SIZE: 6 The GPPS is the global price entry and financial analysis system for Ford Customer Service Division(FCSD). This system must be made in order for Europe to migrate from the existing pricing system (PIPS) to Global Parts Pricing System. The enhancements not only support the launch of Europe but also provide improved functionality to the existing North American customers. Involved in individual part pricing and part attribute screen * Visual Interdev, ASP, Java and VB Script, Oracle 8.0, SA fileup, TOAD,VBA , HTML,ADO-Excel Reporting PROJECT : MASS ANALYSIS SYSTEM (MAS) 03/99 -12/00 ROLE : WEB DEVELOPER TEAM SIZE: 12 The Mass Analysis System (MAS) is a web-based, database system that allows for efficient analysis, tracking and reporting of global vehicle program weight data for Mass Analysis. The intent of MAS is to aid the AVT Weight Engineering Department in documenting and communicating vehicle program weight data and recommendations to the program teams and regulatory agencies globally. In addition, the MAS system will be used to consolidate the weight information to a single source which will allow more efficient and consistent resolution of weight issues. As web developer responsible for designing and developing Regular Production Option(RPO) weight, relationship, mandatory, effects ,global change screens with complex algorithms and maintenance screens like body style,pmt, weight definitions and test loads. Involved in writing Implementation specifications, generating test plans and cross browser development of the system .Involved in customer discussions for understanding user requirements. Developed several reusable templates for the system using VB & Java Script and done the designing and generating weight definition reports using ADO-Excel web technology with different excel macros. * Visual Interdev, ASP, Java and VB Script, Oracle 8.0, VBA , HTML,ADO-Excel Reporting J P MORGAN (MORGAN TRUST COMPANY) , SINGAPORE PROJECT : REUTERS DATA CAPTURING SYSTEM (RDCS) 10/98 - 02/99 TEAM SIZE : 5 ROLE : SYSTEM ANALYST RDCS is an important data collection method for Singapore Mid Office to gather all the Reuters and EBS Dealing Information from three other offices. As a System Analyst done the design, prepared the project schedule , hardware setup and implementation of the system. Developed the client_ server application for the capture station to collect all the data from multiple serial ports and real time using MS Comm ActiveX control This will create data files at regular interval and run as WindowsNT Service. Designed and developed an intranet web application for mid office users for monitoring and updating the deals. This will also helps the traders to generate the day to day report for different deals in HTML format. * Visual Interdev, ASP, Java and VB Script, SQL Server 6.5,HTML,MS Comm Control,Visual Basic 6.0 J P MORGAN (MORGAN TRUST COMPANY) , SINGAPORE PROJECT : EURO CURRENCY CONVERSION 07/98 - 09/98 TEAM SIZE : 7 ROLE : SYSTEM ANALYST Setup of the EURO as currency in the existing system is the main objective of the project. This will includes the conversion of existing transaction base, instruments , and reference information. Provide Dual currency support for clients that wish to continue to trade and settle in domestic currencies . Involved in EURO currency setup for current Client Server Applications with Visual Basic and Excel macros which will provide dual currency support for maximum client flexibility to quote, trade, confirm and settle in domestic currency and maintain regulatory reporting and environment. Used DDE method with Lotus mail to manage all positions in EURO and process internally in EURO and developed new regulatory reporting environment with EURO currency using excel macros * Visual Basic 5.0 ,MS Excel97 (VBA) with DDE,SQL Server 6.5 WESTERN DIGITAL ,SINGAPORE PROJECT : ERROR MONITORING & ASSEMBLY LINE INFORMATION SYSTEM 06/98 - 07/98 TEAM SIZE : 6 ROLE : WEB DEVELOPER The main objective of this system is to alarm the operator when an error occurred in the production floor. The Number crunching and Report Generation part is handled by the Middle-Tier, which is being powered by ASP with Visual Basic ActiveX DLL Server. The VB ActiveX DLL Server queries the Star-Schema Data Warehouse which is residing at the ORACLE Database Server and generates reports in HTML format to be served to the browser through the Intranet Web Server. Done the detailed system study , design, testing and coding of the system. Developed the routines in all applications so that it will write both system error and process error into the database. Created a COM object called WDShare using ActiveX DLL and used with ASP for activating this application on intranet. This will help to attend the problem when it occurs and will help to reduce the downtime in production by taking a corrective action if an error occurs.. * Visual Basic 5.0, Visual Interdev 1.0, Oracle 7.3.3, Windows NT Workstation 4.0, ASP with ADO,COM ,VB Script, IIS3.0 WESTERN DIGITAL ,SINGAPORE FOR ITS WORLD WIDE MANUFACTURING SITES AT SINGAPORE ,MALAYSIA, WARE HOUSES AT BARRANCA (USA) AND EZI (GERMANY). PROJECT : H.S.A MRB TRACKING SYSTEM IN CIM 02/98 - 06/98 TEAM SIZE : 7 ROLE : WEB DEVELOPER The H.S.A Utilization and Tracking System will provide visibility and tracking H.S.As rejected in manufacturing. This software will print tickets like T111/T121, RMA/Rework Request and Shipping Requisition Charges on vendor and WD's scrap cost in excel format. Involved in detailed system study, design ,testing and rollout of the project. Plot the graphs and reports of the defect codes and failure trends for flexible charting at end user level using ADO-Excel Technology. Done the easy maintenance in material transformation from production to procurement location for returning vendor has been done. Developed the transaction for RMA/Rework Request, issue parts requisition and shipment requisition. * Visual Interdev 1.0, Oracle 7.3.3 , Microsoft Excel, ActiveX Graph & Grid Control , Crystal Reports Control , Windows NT 4.0 WESTERN DIGITAL ,SINGAPORE FOR ITS WORLD WIDE MANUFACTURING SITES AT SINGAPORE ,MALAYSIA, WARE HOUSES AT BARRANCA (USA) AND EZI (GERMANY). PROJECT : HARD DISK DRIVE LABEL PRINT SYSTEM IN CIM 11/97 - 02/98 TEAM SIZE : 5 ROLE : PROJECT LEADER The Software has been developed for printing Labels for Hard Disk drives using a special thermal ink-jet printer. The Label Print Client sends messages to the Server application which in-turn returns the client, the details of label to be printed for a hard disk of particular model and capacity. The label specifications needed for printing the label are stored in Oracle Database and Maintained. Conveyor Control through PLC to start and stop the conveyor also has been included in this Software. Involved in system study , user discussion , project schedule, designing system , testing and roll out of the system. Developed system message module using Visual Basic Socket Programming. Using Oracle Objects ,different functions are created inside InTrack (for controlling the queues of drives). Appropriate VB classes and procedures are created for OLE Automation Server (DLLs)to extract data from Oracle tables using TCI/IP protocol * Visual Basic 5.0, Oracle 7.3.3, Distinct Winsock Control (TCP/IP), InTrack & Zebra Printer, Windows NT 4.0 TEXAS INSTRUMENTS ,SINGAPORE PROJECT :WAY REPORTING SYSTEM 08/97 - 11/97 TEAM SIZE : 6 ROLE : WEB DEVELOPER The main objective of this system is to allow engineers and planners more consolidated level reporting . with different product groupings and allow users to maintain 7am report themselves, This will reduce the report change request cycle-time for users and allow more reporting options for users The system accepts the valid user input data from user, download mainframe SMS data, prepare reports in Client/Server environment and allow users for an easy and remote access of web reporting. Designed and developed the user maintenance forms and transaction form using different SQL Server stored procedures and VB classes to update database with mainframe SMS data on a regular schedule. Done the different report settings for engineers and planners and generate different reports in intranet web environment using ASP with ADO and done web reporting using Crystal reports for IIS. * Visual Interdev 1.0, Visual Basic 5.0 , SQL Server 6.5, IIS 3.0 , Crystal reports for IIS, WindowsNT4.0 KARNATAKA MILK FEDERATION,BANGALORE PROJECT :DEPOT OPERATION SOFTWARE 02/97 -07/97 TEAM SIZE : 5 ROLE : PROJECT LEADER This application is aimed for depot operations of KMF covering maintenance, financial accounting and sales analysis through a network of depot dealers, retailers. Involved in system study, design ,project schedule, database setup, testing and rollout. Created different stored procedures for accounting requirements such as daily maintenance of ledgers, stock receivable, and sales Reports and completion of monthly sales and tax returns .Using crystal reports, developed the receipts of stocks from various dairies. * Visual Basic 5.0, MS-SQL Server6.5, Crystal Reports, Windows NT 4.0 PROJECT :WEB DESIGN 06/96 -01/97 TEAM SIZE : 3 ROLE : WEB DESIGNER Client: HTTP://WWW.BPLAUDIO.COM : AUDIO DIVISION OF BPL COMPANY Client: HTTP://WWW.AINDIA.COM : SOFTWARE COMPANY Client: HTTP://WWW.SSPL.COM : SOFTWARE COMPANY Client: HTTP://WWW.SPARRL.COM : MANUFACTURER OF ELECTRONICS PRODUCTS. Client: HTTP://WWW.SUBEXGROUP.COM : SOFTWARE COMPANY. Involved in the user requirements study, developing HTML forms, graphic designs , setting internet site and uploading site (FTP) of entire site. * HTML, Java Script, Microsoft Frontpage1.0, Netscape, Internet Explorer, Adobe Photo Shop, Paint Shop Pro ELECTRONIC DEVELOPMENT AND TECHNOLOGY (CEDT) ,KERALA. PROJECT : ELECTRONIC DESIGN TOOL FOR SMPS 01/96 -05/96 TEAM SIZE : 5 ROLE : PROGRAMMER The tool automates the design process of Switch Mode Power supplies. The common dialog Vbx control allows the user to save the different input values in separate files. Entire reports created with the help of crystal report custom control. Developed different entry forms includes the options of add, edit, browse, view etc...Involved in the project co-ordination , development, testing and implementation of this application. * Visual Basic 4.0, MS-SQL Server6.0 under Windows NT3.51 LIFE INSRUANCE CORPORATION ,KERALA . PROJECT : POLICY DATA PROCESSING SYSTEM 03/95 -12/95 TEAM SIZE : 5 ROLE : PROGRAMMER The Project includes modules like Entries, Bonus, Reports and Bills. Reports and Bills for different categories are made using crystal reports. Developed the different types of entries includes New business, Agent and Bonus. Done the Reports which involves the reports based on age, sex, agent, policy etc.. using crystal reports and was Interfaced with the front-end and database tables. * Visual Basic4.0, Oracle7.0 under Windows NT3.51 KERALA TOURISM DEVELOPMENT CORPORATION (KTDC). PROJECT : TOURISM INFORMATION SYSTEM 11/94 -02/95 TEAM SIZE : 3 ROLE : PROGRAMMER Based on the tourist places selected by the user, a True Grid is populated with the various details about the place. The user also gets to see the major tourist attractions of the selected place in the form of a map. This was accomplished using OLE controls. Developed the part which handles to store the history of different tourist places, nearby hotels, traveling distance, fare, timings in a user-friendly manner. Designed the tourist map which allows the user to know the complete details of each place at the press of a button. * VB 3.0, MS-Access 2.0 under Windows for WorkGroup 3.11 Personal Web site : http://www.rajeesh.com/