CHANDRASEKARAN K

MOBIL-979*******

DBA • ERP CONSULTANT • SYSTEM ADMINISTRATOR

SAP-Techno Functional

Accomplished & quality-focused ERP Software & System admin with 11+ year’s record of success in Database Management(Oracle,SQL,FOX), UNIX/WINDOWS/Mail Server Administration, SAP Techno Functional and General Administration at startup, mid-size & corporate levels in production & development environment. Versatile technical expertise with ability to complete projects of varying scale, regularly meet deadlines, motivate co-workers & consistently exceed expectations. Effective communicator; able to explain complex processes in user-friendly terms. Skilled in proactive identification & resolution of critical problems. Good exposure to overseas project development & implementation.

CORE COMPETENCIES:

New & Emerging Technologies

Application Administration

User Training & Support Tools

Network Connectivity Issues

Testing & Troubleshooting

Windows & Unix Platforms

Disaster Recovery Planning

Client Needs Fulfillment

Systems Integration / Migration

Problem Identification / Analysis

Business Process Optimization

TECHNOLOGY SKILLS

HARD WARE

SOFT WARE

NETWORKING

OPERATING SYSTEM

APPLICATION

DATA BASE

CROSS FUNCTIONS IBM, Compaq Prolient Servers, Unisys, HCL, Compaq & HP PCs.

Windows 3x/9x/NT/2000/XP, Microsoft Office Tools, Anti Virus Environments, Remote Desktop & Drive Copy & NetMeeting.

Client Server with TCP/IP, WAN/LAN, Ethernet, MUX, Firewall & HUBS, Routers & Switches.

SCO UNIX , Solaris, Linux, Windows NT 4.0 Server & Windows 2003 Server.

SAP Business Suite, (SQL * Plus), Power Builder 6, Visual Basic 6, V Fox Pro, FoxBASE , ASP .NET.

Oracle, SQL Server 2000, MySQL, MS Access & FoxBASE.

Accounting, Inventory, MIS, Pharmacy, Payroll System, Budget Management & Factory Production.

EDUCATION & TRAINING

MBA-IT (Pursuing)

Bachelors in Science (Physics), MADURAI KAMARAJ UNIVERSITY, 1987

PGDCA – Private.

Oracle 10g (DBA), ORACLE UNIVERSITY, 2007

Basic Admin Course, SAP, 2007

Certification on Sun Solaris 9 Administration.

SAP BW course completed.

CAREER DEVELOPMENT

EDP-In-Charge

National Plastic Technologies Ltd,(From Sept-2009- Till Date)

National Plastics Group has a significant presence on the national scene with specialization in Packaging, Automotive and other OEM parts and consumer ware. The group has seven plants across India.

Roles and Responsibilities

SAP Basis Administration.

All Modules Trouble Shooting

Database and OS Administration. (DB2, Linux)

IBM Blade Server Installation and Maintenance.

Backup & Recovery.

User level support on Functional Modules. (FICO, MM, SD, PP)

Projects Handled

One Full life Cycle Implementation of SAP ECC 6 EHP4.

Implementation Of FICO Module.

DBA –Oracle 9i,10g. & MySql and Payroll Admin

Xtreme Infotech Pvt Ltd,(From July 2007 – April 2009)

Xtreme Infotech Pvt Ltd is a professional Software Development, Web Design and Web Development Company that provides affordable, professional and practical solutions. It has multi platform development team for web designing and application development viz., ASP.Net,Java and PHP.

As an Oracle DBA created logical and physical database, design, implementation, and maintenance on Linux, Solaris and Win NT.

Roles and Responsibilities

l

Installation, Upgrade, patching and managing Oracle 9i & 10G DB.

Creating users, mass user creation, deletion, locking and unlocking users.

Analysis of Background jobs and monitoring, Scheduling and co-ordinate with developers after finding expensive statements for fine-tuning and improving the performance.

Performance analysis and Tuning of Oracle DB.

Backup & Recovery using RMAN.

RMAN concepts and scripting.

RAC Configuration.

ASM Configuration and trouble shooting.

Implemented automated data backup and restoration procedures. Provided technical support for database maintenance and disaster recovery

Basis support for installations, configurations, and maintenance of Oracle support packages.

Checking the free space and fragmentation of all table spaces, increased the free space in table spaces. Reorganized the table spaces.

Installation and configuration of Windows 2000/NT servers.

Pearl Shell scripting for startup/shutdown and other automated cron job functions.

Conversant with SQL and PLSQL.

TATA COFFEE LTD – VALPARAI, TN (2005 – Till July 2007 )

Tata Coffee Ltd. is the largest Coffee Plantation Company in Asia with operations worldwide

Junior Officer

Systems Dept In-Charge (System & Data Base Administration)

Entrusted with software conversion in five of Tata Coffee Ltd estates and three depts. from Tata Tea Ltd configurations. Developed & maintained framework for production data & sales details, calculate cost of production, labor deployment & other efficiency parameter details. Reviewed & Trained professionals from Outsourced companies to successfully complete & implement new projects within stringent deadlines.

Key Contributions & Accomplishments

Modified & Implemented revised Payroll programs of Staffs & Workers of the ERP package.

Fast track elevation from bottom staff level to independent charge of EDP across multiple locations & cross functions against consistent records of superior performance & company dedication.

Analysed & developed Programs for modification in all existing modules. Generate variants in accordance with policies changes and new settlement modules.

Supervised EDP functioning that became central to all company payroll processes & generation of funds.

Centrally consolidated monthly Financial Accounting of all estates & generated critical Important Management Information reports and Trial Balance to Finance Dep’t which yielded the P&L Statements.

Liaised & Collaborated with various Govt. bodies on statutory reports & filing of Annual Provident Fund returns & IT filing.

Generated Highly Confidential reports exclusively for the eyes of top-level management & assisted to monitor & analyse the progress status of the company.

Coordinated & administered calling quotations from corporate companies & finalized Annual Maintenance Contract for Systems Hardware, Easy Hand Held Terminals, UPS, etc.

Created Utilities to calculate Arrears for Individual employee & arrange for month wise new/old earnings & payment settlement in accordance with advisories issued by company.

Developed balanced system load to consolidate Financial Accounting for monthly Trial Balance & generate systematic Profit & Loss A/c’s & Financial Statements.

Developed plans for 1500 critical Programs conversion project using Shell Scripts.

Provided technical leadership in finalizing AMC for Hardware, UPS, and Hand Held Terminals for the year 2006-07.

Implemented in Estates & Dept’s for Payroll inputs to EDP this helped the crucial diminution of manpower.

KEY PROJECT EXECUTION

PROJECT : Full scale Conversion of Tata Tea Ltd ERP Package to Tata Coffee Ltd.

RESPONSIBILITY : Total In-charge for Operation & Implementation

DURATION : 3 months

PLATFORM USED : UNIX, FOX

LANGUAGES / APPLICATIONS USED : FOXBASE

DESCRIPTION : Development of Comprehensive Structure including Payroll Data, Financial Accounting, Productivity System, Store Keeping, Billing & Budgeting

Led team of 2 Engineers & Programmers to Develop Exclusive HHT Log to monitor Daily Data of workers, including, Attendance, Plucking details, Monthly Salary details, Payments of Maternity, Gratuity, Workman Compensation, Leave with Wages, Sick / Holiday Wages, Incentives, Bonuses, etc.

Planned ADL module for availability of stored data for correction, consolidation & processing at Estate Server through Interface Unit & EDP junctions throughout all estates.

Designed interface to automatically upload monthly expenditure journal in Accounting module.

Designed comparison interface to analyse statements like actual vs. budget on expenditure of Capital & Revenue.

Developed interface to generate analysis statements on key productivity indexes like, Plucking & rainfall averages, yield & comparison statements against previous year records.

Prepared module for maintaining, comparing & transferring key details like, materials supply, supplier expenses, Factory & Field storage details, etc.

Built module for preparing Annual Budget for the financial year with all key fixed & variable expenditures & enabled transfer & modification of data through Accounting module for analysis.

KEY PROJECT EXECUTION

PROJECT : Factory Production Software

RESPONSIBILITY : Project Lead

DURATION : 2 months

PLATFORM USED : SQL SERVER, VB 6

LANGUAGES / APPLICATIONS USED : VB, SQL, ACCESS

DESCRIPTION : Development of Factory Production

Led team of 4 Engineers & Programmers to Develop Exclusive Software for five of Tata Coffee Ltd estates & factories that included creating interface for production & sales data details, cost calculation of production, labor deployment & other efficiency parameter details.

Trained outsourced software professionals & completed and successfully implemented test version within a period of 40 Days.

TATA TEA LTD. – MUNNAR, KERALA (YEAR 1999 – 2005)

Systems Assistant (Contract till Jan -2002 )

Tata Tea Ltd. is the largest tea manufacturing company in the world with its estates at different geographical locations worldwide, which are centrally controlled, from office at Munnar.

Data Base Administrator-Oracle 8. (INSTANT TEA DIVISION LTD.) (1999 – 2001)

Charged with Maintenance, Development and Implementation in existing software packages viz. Financial Accounting, Workers & Staff Payroll, Stores, Budget, Plucker Productivity System, Field Management & Factory Production Dispatch. Additional functions included Database Administration in INSTATNT TEA DIVISION LTD., a separate 100% exporting division of Tata Tea Ltd.

• Created Oracle 8 database for 2 large departments, from planning and testing through production.

• Migration of the Existing ERP Application from Oracle 7 to Oracle 8 database.

• Implemented backup and recovery procedures of databases in Windows NT environment: implemented backup and recovery procedures.

• Managed database remodeling and interface development during migration from Oracle7 to Oracle8

• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.

• Involved in all phases of database development, from needs assessment to QA/QC, design, and support

INTELLIGENTSIA SOFTWARE RESOURCES INC., MADURAI, TN (1997 – 1999)

Intelligentsia Software Resources Inc. is a premier solutions provider & exporter of hardware & software solutions with major clients.

Project Leader & Programmer

Charged with handling overseas client, project development & creation of integrated systems in accordance with customer needs & handling of off-shore problem solving & system maintenance. In addition trained & supported team of programmers & provided Software implementation & maintenance guidance to end users.

KEY PROJECT EXECUTION

PROJECT : Preparation of Management Information System for key client at Maldives, Focus Computers Ltd.

RESPONSIBILITY : Project Lead

DURATION : 3 months

PLATFORM USED : PB, ORACLE

LANGUAGES / APPLICATIONS USED : VB, PB

DESCRIPTION : Development of Comprehensive ERP Package & E&T Module for Training subsidiary.

Led team of 4 Engineers & Programmers to Develop Integrated system for swift generation of customer details with unique identity component, quotation parameters, order forms & sales closing, automated invoicing system & bar coding.

Designed modules to maintain stock details, location statistics, stock transfer & order placement details, order processing, invoicing & delivery details with pre-determined reorder level that warns & reminds key activities.

Developed vital Customer Support Interface to track warranty details, complaint registration & work order form, with Time card – that highlights goods brought in and send out after service & automated Analytical report – that categorises most often recurring faults.

Built module to process monthly staff wages & emoluments in addition to maintaining Master file of staff History with their identity logs & recent photographs.

Developed separate E&T modules for the subsidiary of parent client, Focus Computer Training centre that uniquely identified student details, including attendance & payment defaults & generated comparative performance charts.

Areas of Interest

Oracle DBA,SAP-Basis Admin, SAP-BW, Unix Admin.

Personal

Speaks Tamil, Malayalam and Telugu.

Love to travel and meet people.

Player - Football, Cricket, Badminton and Table Tennis.

Hardworking dedicated and easy adaptability to any new learning environments.

Birth Date: 4th May 1966

Marital Status: Married

Reference: On request.

Passport Expiry: 2017

NO. 14B Vijay Flats, Maduvappar1st Street,Laxmipuram, Chromepet, Chennai – 44

+91-979******* • ai6k2f@r.postjobfree.com

Contact this candidate