Rajiv Telang

RAJIV TELANG (B.E.-COMPUTER ENGINEERING) Date of Birth: Phone: Sex: E-mail:

14th Jan 1966 9891321398 Male [email protected] [email protected]

Passport No Present Address:

A6811267 (Till 23/12/08) c/o Mr. Sanjay Chakrawarti 131, Arunachal Appartment, Plot No 16, Sector 7 Dwarka New Delhi 75 Phone : 011-55975324

BRIEF PROFILE − Oracle Certified Professional (OCP) Oracle 9 i DBA .

− − −

−

SQL Star International Ltd. New Delhi Certified Oracle 9i DBA. More than 8 years of experience in Software Development, Database management, ABAP/4, SAP/R3, Testing & project management. Excellent interpersonal and communication skills. Worked in teams and coordinated teamwork in various projects successfully. B. E. (Computer Engineering) from SGSITS – Indore in the year 1994.

I.T. SKILLS

− − − −

−

DBA RDBMS: Front End Tools: ERP:

Oracle 9i (OCP) Oracle 8 Developer 2000, Form 4.5, Report 4.5 SAP R/3 - Sales and Distribution Module

−

Programming Languages: Operating System:

ABAP / 4, PL/SQL Windows 2000

−

Testing Tools

Working knowledge of Win Runner, Load Runner, Test Director

PROFESSIONAL EXPERIENCE C-NET Infotech Pvt. Ltd. Manager IT

Jan’ 05-Till date

C-NET Infotech Pvt Ltd. is a leading software company based in Bhopal. We have Developed and implemented the MIS Software for the MP Warehousing and Logistics Corporation Bhopal for their HQ, Regional Offices and 229 Branches all over in MP. This software consists of MIS, Business, Technical and Accounting system. The Automation modules meant for retrieving the commodity wise latest positions of the Stocks stored in the godowns, Insecticide used in godowns based upon the commodity stored ,Reservations of the warehouses (commodity type based), Delivery of goods and payments of the Warehouses, details of Establishment, whole database of technical cell and all the cases filed in courts of Legal cell . These all information get available at the regional offices and at the Head Quarter level. These information are the backbone of the business of the MP Warehousing and Logistics Corporation. Arm with these information one can plan the business in the better way. Role: I am the only person who is looking after all the Database Administration of oracle 9i database of the Bhopal Municipal Corporation project, Testing of the application developed for Citizen Facility Center . This consists of Backup , recovery and performance tuning of the database. Lead from concept to inception stage of the Software design , Database design, development and testing of the system. The application has several combination of the security to prevent the wrong data to insert in the database to keep the data consistency. Managing a team of 9 software developers. Also accountable for Implementation and maintenance of the software and technical support in all 229 branches and regional offices of MP Warehousing and Logistics Corporation, also remains keep in touch with the top officials of the MP Warehousing and Logistics Corporation Bhopal regarding requirements and documents needed for the development and Implementation of system which can enhance the performance of the software.

Worked as a lead person for the project of “National Project Cattle and Buffalo Breading “ of MP Government which is capable to provide MIS regarding all the activities of the MP State Livestock & Poultry Development Corporation. Integrated Infosys Apr’ 03-Jan’ 05 Astt. Manager Developed and implemented software for offices of Integrated Infosys, Bhopal in M.P. and Chattisgarh which updates latest information regarding sale of UPS, Inverters, heat sealed Batteries and collections. Role: Responsible for the Database Administration of oracle 8i database of the company. This consists of Backup and recovery of the database. Lead from concept to inception stage of the Database and software by the system in Oracle 8i as backend and Developer 2K as the front end . There are many checks and validation at the entry level to keep the data consistency . Its further maintenance and testing of the software. J. P. Cement Limited Mar’ 00 – Apr’ 03 System Analyst Development and implementation of software for all the 46 Depots in U.P. and outside offices situated at various parts of India to interchange latest information regarding sale of cement and collection of money, sending the processed data to the respective branches for Marketing, Sales & Accounts, from various other branches of J.P. Cement Limited (Total Nos. 46) and mini grinding unit situated in U.P. Also responsible for leading the IT and hardware team for over all management of Software, Data Base, File Server, Client and Nodes pertaining to Sales, Accounting & MIS via Lotus Notes and with the help of DMI server by telephone. Narmada Valley Development Authority Jun ’ 99- Feb’ 00 Programmer Narmada Valley Development Authority is a Madhya Pradesh government concern. As a team leader, the role was to develop: 1) Project Information System – Automated software which keeps track of Rehabilitation and resettlement of families affected by Sardar Sarovar & Indira Sagar Dam projects. 2) Payroll and Scheduling software 3) Income Tax & revenue management system. VISU Consultant, Noida Dec’ 98 – Jun’ 99 Trainee VISU consultant Pvt. Ltd., Noida is an offshore training and development center of Chavva InfoTech, USA. Role: As a trainee, I learnt ABAP/4 language and Sales and distribution module of SAP R/3 and did demo implementation in a soap company. Aditya Cement, Unit of Aditya Birla Group Dec ’95 – Aug’ 98 Programmer The company is a unit of Aditya Birla group and has a full fledged IT department to take care of its growing automation needs. As a programmer, I was part of a team which developed an ERP solution for Sales and Marketing department which automated dispatch system, billing, invoice generation, freight billing & reporting. Role: Concept to inception stage of the Database used by the system in Oracle 8 and its further maintenance. PROJECTS DONE 1. Enterprise Solution & Cement Marketing System JP Cement has a Regional Marketing Office (RMO) and various depots (sub branches) across India which needs to interact with each other for sharing data about customers and sales from time to

time. The system developed was capable of exchanging the data of the sale made by depots and passing on the customer information and its demand from RMO to depots and vice versa. The software had a multi-user interface and was capable of interacting data between parallel systems in batch mode via DMI protocol (End to end connection through a phone line). Database Used: Front End: Team size: Platform: Time frame:

11 1 year

Oracle 8 Developer 2000 Windows NT

Role: - Responsible for designing the technical architecture, data model and setting up the inter office network. - Leading a team of 10 software professionals for writing the code for various modules like sales, accounting and material tracking. - Leading the implementation team for testing the system, final deployment and post implementation maintenance. - Leading the hardware team from concept to implementation stage of setting up the required infrastructure within the RMO (Regional Marketing Office) and depots. 2. Enterprise Solution for HR The system developed was a complete HR tool and contained modules like payroll management, income tax calculator, Employee administration and recruitment manager. It was a stand alone system used by the administration and HR department. Database Used: Front End: Team size: Platform: Time frame:

Oracle 8 Developer 2000 4

Windows NT 6 months

3. Aditya Birla Group – Sales Account System As a programmer, part of a team which developed an ERP solution for Sales and Marketing department which automates dispatch system, billing, invoice generation, freight billing & reporting. The system use to first generate the instructions to the dispatch department for loading the particular grade of cement for the given quantity and a particular destination. According to that, the invoice use to be generated. The billing process & freight billing use to be done after the material is dispatched and the customer send the confirmation of receiving the goods. The system was also connected to 18 different depots from where the requirement was generated and conveyed to the company HQ. Database Used: Front End: Team size: Platform: Time frame:

4 1 year

Oracle 7x Developer 2000 Windows 98

4. Narmada Valley Development Authority – Rehabilitation Information System Developed and implemented software package to keep track for Rehabilitation & Resettlement pertaining to the project affected families of Sardar Sarover Dam Project and Indira Sagar Dam Project of Government of M.P. Database Used: Front End: Team size: Platform: Time frame:

3 1 year

Oracle 8 Developer 2000 Windows NT