C V of Jyothilingam (Jothi)
Baan Application Support Analyst
-----------------------------------------------------------------------------------------------------------------------------------------------
SNAPSHOT OF MY IT EXPERIENCE:
Over all exeperience
• Possess 5 years of Baan Application Support Analyst sound experience in Implementation and supporting experience for various customer requirements in Baan IV and Baan Vc

Full Life Cycle Implementation
• Done 3 full life cycle implementation (Installation / Development / Customization / Trouble Shooting and Administration) , right from “as it is process study”, “to be process and gap finalization” as per Baan Target.

Hr Package Support / Development
• Migrated HR Package Developed in BaanIVc4 to BaanVc and supporting in development and administration. Having good knowledge of BaanVc application.

Microsoft Excel / Macros
• Wrote Many Excel Macros to Import and Export Baan Data on Excel for Customized Sessions.
• Developed Baan reports using Excel as Reporting Tool (From Baan To Excel)

Desiging and Development
• Hands on Experience in Designing and Development of Integrating Web Application and BaaN, also possess three and half years of Experience in Development and support of Application Software on Banking and Manufacturing Domain using Visual Basic / ASP, MS SQL and Oracle, Windows NT, Windows 95, 98, XP.
• Designed and Developed HR Package similar to BaanVc (Session/Screen) using VB / SQL / COM+ / MTS.
• Hands on Experience in VB Active X Controls & DLL, COM+ and created database objects like Triggers, Stored Procedures, PL/SQL

Key / End User Baan Application Support
• Coordination with the End user, Requirement Study, Development and Training. Follow up and monitoring, till Customization get stabilized
• Trouble Shoot, Modifying Data at GTM (ttaad4100), with out disturbing Baan Business Logic

Automation Development
• Developed Application Similar to EDI using Baan AFS Technology
Present, Baan - Mirnah (Hand Held Computer Application) Van Sales Application
Full Automation of Session RPL/Sales Order/Generate Outbound/Release Outbound/PDSO/Posting Transaction in Finance Module Based on Cash/Credit, Client Oman Nation Dairy Company Oman

Modification Tracking and Reserved Table
• For Each Modification/Customization, cases will be booked, after, When the job is done, the cases will be followed and will be closed after the testing is over…
• All customized tables, sessions and development were followed as per Baan Customization advice on Test VRC and coped to production VRC
• External Customization were all done in one Test VRC (Customer Based) and Export to their Respective VRC.
• Loading of Baan Patches/Service on the Standalone (Test) Server, New Changes were noted down, after testing and approving from the concern department (Key user/User), after a proper signoff, the patches will be loaded to the live environment.



Exchanges Schenes and SQL to Update item Data in Baan on Request.
• Made Many Exchange Schemes (Baan Utilities) for Importing Item Master Data from Legacy system to Baan
• Made Many Exchange Schemes for exporting data to rectify the corrupted data.
• Use MS SQL / Oracle update and delete statements for modification as well as to delete some junk record from Database

Replication process Knowledge and ownership
• During the Baan Implementation, Common Records Like, Customer, Supplier, Item Master (with their Mandatory Master Records) and whatever common columns (Mandatory Fields) were mapped and imported to Baan using Exchanges Schemes.

Assist Oracle DBA with functional table Relationship
• Well aware of all functional table entity relationship right from (TC, TF, TD and TI packages)

Hand on Experience
• SQL, PL/SQL, Baan Architecture (Right Bshell / Driver/Porting set/ Database (Oracle/MS SQL)) Key / End User coordination, preparing the scope of Requirement, Developing Technical Specification, preparing Testing methodology (functional and without functional), bug fixing preparing User Documents and Training Study, Develop and Implementation of Business requirements


Good Knowledge., Functional
Distribution - TD (Inventory, Purchase, Sales, Location Control, Lot Control)
Finance - TF (General Ledger, Accounts Payable, Accounts Receivable)
Manufacturing - TI (Bill of Material, Project Control System)

PROGRAMMING SKILLS:
ERP: BaaNIVc4, BaaNVC
GUI: BaanNIV Forms & Reports, Visual Basic 6.0, Crystal Reports 6.5
WEB DESIGN: Html, Java Script, VB Script, And ASP 3.0
RDBMS: Oracle 9.2.1.0.1, MS SQL 2000, Sybase
OPERATING SYSTEM: Windows 95, 98, XP, Windows NT, Windows 2000 serve

EXPERIENCE IN DETAIL:
(from current employment to previous…) TITLE / EMPLOYER / PERIOD

1.APPLICATION SUPPORT ANALYST, BAAN TOOLS (TECHNICAL) / DUBAI INVESTMENTS, DUBAI, UAE From 03.09.2004 To TILL DATE.

Under Dubai Investments Umbrella, there are about 11 companies running in BaanIVc4 and many more customer too., I am the only Technical consultant for development supporting all the companies and customer too away from Dubai. All the 11 companies not under group company set up.

Developed session for finding Consolidated Profit / Loss and Balance Sheet across multiple companies on Non-Group Company set up also Developed Raw Material Consumption and Gross Profit (Project wise), Rebuild tdinv700 table from other standard tables.

Developed Customized Statement of Accounts Supplier wise, Audit for the year ended, Balance confirmation, Landed Cost, Gross Profit / Summary calculation Project wise, Cost of goods sold vs WIP Reports

Developed many Inventory / Production / Project / Lot / Location wise reports, Pre Printed Stationery Customaization

Developed Property Management Application which contains Monthly Rent / Income Schedules, Posting in Finance (Maintain Transaction)

Developed Meter Reading System where the file of Hand Held device of Cooling System is loaded into Baan for generating Sales invoice in (Maintain Sales Invoice / Lines)

Imported BaanIVc4 HR (Customized Package) into Baan5.0c for further customisation in Baan5.0c. and developed many HR customaized Session and Report

Developed many excel macros to import data and export data from Baan

Exporting and Importing of Baan data on Microsoft Excel and many more customized.


Performance Tuning for the Slow Reports


Integration of Van Sales Software (Mirnah) and Baan using AFS (Application Function Server) Technology and automation of Sales Order Header Lines, RPL Order Header Lines, Sales Invoice Header Lines, Maintain Transaction, GOBA / ROBA, Print Sales Acknowledge, Print Sales Invoice and many more on automation.


2.CONSULTANT, BAAN TOOLS (Technical) / POLARIS SOFTWARE LAB PVT LTD, (INDIA) / FROM 18.02.2001 To 31.08.2004

BAAN/ASP/VB Experience:
PRODUCT NAME: DEPOT MANAGEMENT SYSTEM
ENVIRONMENT: Visual Basic 6.0, ASP 3.0, COM+ And MS SQL 2000 (Stored Procedure)
SERVER: Windows 2000 Server, Version 5.0
PROFILE: System Requirement Study and Making Understanding Documents, Designing Architecture, Writing Specifications.
1 BaaN - Coding Application Function server (AFS) to Integrate existing web application with BaaN through BOI (Business Object Interface), many standard sessions were automated
2 ASP - Developing Web pages and creating stored procedure on MSSQL 2000
3 VB – Developing Batch Program and Creating & Deploying Components on COM+.
4 The whole application as developed on client server architecture (3-Tier) and COM+ used for connection pooling and Excel Reports.

BAAN SPECIALISATION:

Two Full Life Cycle Development And Implementation

RESPONSIBILITIES: Installing, Administration, Customisation, Development, Trouble Shooting
ENVIRONMENT: BaaNIVC4, IN5, IS5, Windows 2000 Server, Oracle 9i (9.2.0.1.0) and MSSQL 2000
SERVER: IBM @ Server x series 235, Intel Pentium III Xeon 2.4 Ghz, 2.5 GB RAM, 36.4 GB x 2 HD with RAID 1 option and 36.4 GB x 4 HD RAID 5 option.
NETWORK DESIGN: Designing network in multi-site environment involving three factories and corporate head-office with dial-up option as backup. Ethernet configuration used for optimal load sharing on Network.
ADMINISTRATION: Installed BaaNIVc4 on Windows 2000 Advance Server with Oracle 9.2.1.0.1 / MS SQL 2000, Loaded Service Pack From 1 To 12 and latest porting set6c.04 Loading Solution Through PMC, Derived VRC, User Creation, Device Mapping, and Assigned Tables for Audit, Adding sessions to Job Management.
Impart Tools and Oracle 9i Training to LRT IT Dept. Uploaded the Legacy System Data into BaaN Database through Exchange Schemes and Migrated Data from Test Server.
Planning on table space and database back strategy for Oracle.
CUSTOMIZATION: Manufacturing – WIP Report, Routing Sheet and Paycard, Distribution – Sales cum Excise Invoice and Export Orient Units – Form ARE 3 on Preprinted Stationery - Auto Updating of Sales Order, Proforma Invoice, Order Confirmation, Shipment Invoices (Post & Pre), Order Confirmation, Purchase Order.
Created Database Triggers (Delete, Modify & Addition) for exporting and Integrating of employee data from BaaN to Payroll Package (Third Party Software VB/SQL).

SUPPORT (ONSITE/OFFSHORE):
RESPONSIBILITIES: Administration, Customization, Development, Trouble Shooting and Training
CUSTOMIZATION: Customization of Purchase Order / Sales Orders, Quotation, Invoices on Preprinted Stationeries.
DEVELOPMENT: Developed Reports Like Trial Balance for Local Reporting, Cash/General voucher, Inventory Valuation Report monthly and yearly, Vendor rating, Delivery Lead Time, Stock Ledger, Stock adjustment, Pending Purchase / Sales Order, Pending Delivery.
Developed a Pro-type integrating VB 6.0 with BaaNIV HR Module. Many Forms (.frm) were developed similar to BaaN HR Module, Data Input through VB Forms, resulting in updation of BaaN tables and displayed in BaaN sessions and vice versa. Later All VB Forms will be converted in ASP Pages.

VB/ASP EXPERIENCE :
PRODUCT NAME: HR MASTER
RESPONSIBILITIES: Designing Architecture & Database, Component Based Applications, Creating And Deploying Components on COM+.
ENVIRONMENT: Visual Basic 6.0, COM+, XML And MS SQL 2000
SERVER: Windows 2000 Server, Version 5.0
PROFILE: Design and development the whole application as component-based, on client server architecture (3-Tier), which is similar to the architecture of BaaN ERP. Reports were displayed on Internet explorer and generated using XML.

PREVIOUS EMPLOYMENT HISTORY

NAME OF THE ORGANISATION / POST HELD
PERIOD
EXPERIENCE
( consolidated for ease of quick reckon )
LASER SOFT INFO SYSTEMS LTD- Sr.Prorammer
05.10.1998 -
15.02.2001
• Hands on Experience in Active X Controls & DLL, MTS, COM, DCOM, ODBC Database Triggers, Stored Procedures, Cursors, Crystal Reports, and API Calls
• Devised LAN configuration, identification, specification for set up of IT infrastructure (Server & Client PCs) for multi user environment.
• Detailed of Experience in Analysis, Design, Development, Testing, Documentation and Implementation of Banking Application Software using Visual Basic, MS SQL, Oracle and MS Access, Windows NT, Windows 95, 98, XP.
• Key User, Testing and Implementation coordinator
AALA TEXTILE
MILLS PVT LTD-
Programmer
05.01.1998 -
30.09.1998
NATIONAL CHEMICAL FERTILIZER CO.
(SAUDI ARABIA)
Inventory Administrator

20.04.1990 -
31.12.1997
TECHSCIENCE
SERVICES PVT LTD 02.05.1988 -
13.04.1990

3.PROGRAMMER, LASER SOFT INFOSYSTEM PVT LTD (TAMILNADU), FROM 05.10.98 TO 15.02.01:
Joined in Visual Basic Team of Laser Soft Infosystems Ltd, Chennai in Oct. 1998 and involved in developing Banking Software packages such as Prohesy, Probanker and Profunds. Also was involved in developing and Testing of Active X Controls and Active X Dll for the above packages.
Clients: American Express, Indusind Bank, Corporation Bank, Andhra Bank and ICICI Bank.
Prophesy, Probanker and Profunds are Client Server Applications developed in Three Tier Architecture Technology using Visual Basic 6.0, MS SQL 7.0, Oracle 7.3.x and Crystal Report 6.5



4. PROGRAMMER, ALAA TEXTILE MILLS PVT LTD., ((TAMILNADU), FROM 05.01.98 TO 30.09.01:
Stock Control, Sales Order and Purchase Order
Programmer, Developed the stock control module, Developed sales and purchase order modules.
Extensively used reports and ODBC, Technical Environment: Visual Basic 5.0, MS SQL 6.5, Crystal Reports 5.0, Windows NT server 4.0, RDO

5. Inventory Administrator / Saudi Arabian Fertilizer Company. (SAFCO). Dammam/National , Jubail, Saudi Arabia / (20.04.1990-31.12.1997):

8 years Professional Experience as an Inventory Administrator
Area of expertise was in Computerized Materials Management systems.
Good Knowledge of MESC (Material and Equipment Standardization Code): a mainframe (IBM AS 400) based Software developed by Shell International,
Worked in ERP Software MAPICS, training conducted by IBM and in Prism.
Key User, Testing and Implementation coordinator
Prism (ERP Software) Started as Key user, got trained by Prism Implementation Coordinator and successfully Implemented Materials Management Module in Natioanal Chemical Fertilizer Company.
Worked as Implementation Group Member with Marcam representative for testing and Implementation. The primary job was Parallel Run Testing, Modifications, Training end users and Reports Generation.

6. Materials Controller / Techscience Services Pvt Ltd., INDIA (02.05.1988 –13.04.1990)
I was involved in controlling the overall flow of Materials, Reordering and Analyzing of Material Consumption, Implementing effective Inventory Management System and Technical Evaluation. I was also involved in maintaining cardex system and store keeping.


PERSONAL PARTICULARS:


Name: MOHANAN JYOTHILINGAM
Nationality: Indian

Contact mail ID: jothilingam_mohanan@hotmail.com
jothilingam.mohanan@gmail.com

Permanent address: AP30, 12TH Main Road,
7TH Street, L-Block,
Annanagar West,
Chennai – 600 040,
Tamil Nadu, INDIA
Telephone: 0091 44 6211079
Mobile: 9940357644

ACADEMIC QUALIFICATIONS:
Bachelor’s Degree in Commerce
Management Accounting, Cost Accounting, Commerce, Economics, Mathematics and Banking Law as Major Subjects at D.G. Vaishnav College, Madras University from 1985 to 1988.

ADDITIONAL TECHNICAL SKILLS:
BaaN Triton6.1 For The Enterprise Tools Module. Visual Basic Version 5.0 And Oracle 7.1 with Developer/2000. A certification course conducted by Bhari Information Technology Systems pvt ltd (BITECH)
Passed BrainBench Certification Exam in VB 6.0

__________________
Jothilingam

Please have a look of http://www.baanboard.com/node/2479