Vijay Kumar Singh(oracle Dba)

P RO FE S SI O NAL PRO FI LE

VIJAY KUMAR SINGH CONTACT INFORMATION:

GH-12/205, Paschim Vihar, New Delhi – 110087 Phone : +91-11-25273588 Mobile : 9810059826 E-Mail:[email protected] [email protected]

EDUCATION:

Bachelor of Engineering in Computer Engineering from Delhi College of Engineering, University of Delhi, India, 1999. Pursuing Diploma in Business Administration from IMT Ghaziabad.

WORK EXPERIENCE:

6.5 years in Software Consultancy

SUMMARY:

Graduated in Bachelor of Engineering-Computer Science from Delhi College of Engineering, Delhi, having thorough knowledge of hardware & software. Working as Project Leader in HCL Technologies Ltd from July 2003 till date. Worked on an overseas assignment in US and Singapore for 3 months. Previously worked as Lead Systems Engineer for Tata Infotech Limited from July 1999 to June 2003, mainly on deputation to Tata Consultancy Services. Total experience in Software industry is 80 months (6.5Years). Have extensive experience of 5.5 years in Oracle Database Administration.

PLATFORM SKILLS:

Windows 2000 Professional/NT/ Win 98 Sun Solaris UNIX 5.8 RS 6000, SP2 IBM Machines

SOFTWARE SKILLS:

Operating Systems: DOS, UNIX, WINDOWS NT/95/98/2K Professional Packages: Informatica PowerMart/PowerCentre, Oracle Financial 11.5.4, MS Office-97, Visio Professional, Dream Weaver, Autocad-12, Animator Pro, 3-D Studio. Programming Languages: PL/SQL, SQL, C, C++ RDBMS: Oracle 8/8i/9i,SQL Server 2000/2005 Teradata, MSAccess.

8982996.doc

1

P RO FE S SI O NAL PRO FI LE

GUI: TOAD, SQL Navigator, Informatica, DataMirror, Developer 2000, Designer 2000, Report 6i, TIP, DPS

PROJECTS SUMMARY Project Title

Platform

Role

Duration

AMD Data Center Support

Oracle 8i, Informatica Powercenter and Powermart

Oracle & SQL Server DBA (Team Lead), Informatica Administrator

July 03 onwards

GE Rail Car Management (Client GE Rail Car)

Oracle 8i, Oracle Financial 11.5.4, Teradata, Informatica, DataMirror

Oracle DBA, Teradata DBA Oracle Financials DBA

7 Months

GE Tip Integration (Client GE Rail Car)

Oracle 8I, Informatica, DataMirror

Oracle DBA

2 Months

GE Read State Development (Client GE Rail Car)

Oracle 8i, ASP, VB script

Oracle DBA and Team Leader

3 Months

Oracle Center of Excellence

Oracle 8i/9i, Oracle 9iAS

Oracle DBA and Team Leader

5.5 months

WISPER (Client EATON) TCS

Oracle 8i, JSP, EJB, Servlet, iPlanet server.

Oracle DBA and Team leader

3.5 months

CSS Focus –3 (Client PONL) TCS

Developer 2000, Designer 2000, PL/SQL, Oracle 8.0

Team member

9.5 months

GTS porting (Client PONL) TCS.

Developer 2000 Oracle 8.0, Unix and C

Team member and Oracle DBA

5 Months

Oracle DBA

Oracle 8.0

Oracle DBA

4 months

8982996.doc

2

P RO FE S SI O NAL PRO FI LE

PROJECT EXPERIENCE AMD DATA CENTER SUPPORT AT AMD, SUNNYVALE, CALIFORNIA, USA. (07/2003–TILL DATE) AMD (Advanced Micro Devices) designs and produces microprocessors, Flash memory devices and system-on-chip solutions for the computer, communications and consumer electronics industries. AMD is dedicated to helping its customers deliver standards-based, customer-focused solutions for technology users, ranging from enterprises to government agencies and individual consumers. Founded in 1969, AMD is a Standard & Poor's 500 company with global operations and manufacturing facilities in the United States, Europe, Japan and Asia. Vijay’s responsibilities include: •

•

Involved in administration of over 150 Oracle instances and over 50 SQL Server instances for AMD applications. Involved in the setup of oracle replication for several application in AMD like Vignette application for AMD.com, RIS application, Espec application, QIS application etc Involved in the administration of Informatica Powercenter and PowerMart, his responsibility includes Informatica server administration, user management, repository management, server manager administration etc. Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases Involved in the process of tuning and refining queries of various applications. Involved in team management, team building exercises for the DBA team Wrote several shell scripts for checking oracle errors in alert file and database backup log files.

GE RAIL CAR MANAGEMENT PROJECT FOR GE RAIL CAR AT TCS NOIDA PHASE II, INDIA. (09/2002–TILL DATE) This project is being done for GE for their Rail Car Management system. This is a datawarehousing project and is presently under maintenance. He is working as an Oracle and Teradata DBA. The assignment involves storing data for warehousing in Teradata database in two ways. One way is to load data into Teradata by scheduling Mload and Fload scripts of Teradata. The second way is to upload data from Oracle database to Teradata by using Informatica mappings. Vijay’s responsibilities include: • •

• • • •

Involved in administration of 20 Oracle instances and 2 Teradata instances for GE RAIL CAR production and test system. Worked as Oracle Financial DBA for GE RAIL CAR system. Responsibilities include activities like monitoring, backup of OF application, application user and responsibility management, cloning of application from production environment to test environment and application of patches. Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalogue for the same. Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases Involved in the process of tuning and refining queries of various applications. Wrote several shell scripts for checking oracle errors in alert file and RMAN backup log files.

8982996.doc

3

P RO FE S SI O NAL PRO FI LE •

Handled overall DBA activities of Teradata Database like Space management, process monitoring using PMON, user creation/deletion, Granting/revoking privileges to the users, creating and dropping objects in database, tuning queries etc.

GE TIP INTEGRATION PROJECT FOR GE RAIL CAR AT TCS NOIDA PHASE II, INDIA. (07/2002 – 09/2002) This project involved the integration of data and applications for GE Rail Car with the applications for TIP Intermodal. It was a Data warehousing project where the data comes from AS400 and this data is migrated in Oracle through Informatica Mappings. A front end application was made for client using JavaScript and Servletts where users can see all the details about Customers and various other activities like administration, calculation of depreciated values for containers, and creating reports for containers. Vijay’s responsibilities included: • • • •

Database administration of the Oracle database of GE RAIL CAR System. Performing Backup/Recovery of all the Oracle databases using RMAN, also set RMAN catalogue for the same. Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases Involved in the process of tuning and refining queries of various applications.

GE REAL STATE DEVELOPMENT PROJECT FOR GE REAL STATE AT TCS NOIDA PHASE II, INDIA. (04/2002 – 06/2002) This project was done for GE Real Estate. In this project reports were built in ASP and VB script for end users where they can see various details about the headcount, Net income, equity and debts of the company and various transactions that took place within a given time period. Back end coding was done in PL/SQL and his responsibility was to administer the database and writing packages in PL/SQL for the application. Vijay’s responsibilities includes: • • • •

Involved in administration of Oracle database for GE REAL ESTATE system. Involved in the writing most of the packages, procedures, and functions for the application. Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases Involved in the process of tuning and refining queries of various applications.

ORACLE COE (CENTRE OF EXCELLENCE) FOR TATA INFOTECH LTD. AT TATA INFOTECH LTD., NEPZ, NOIDA. (10/2001 – 03/2002) The Oracle COE Group has been formed with an objective to consolidate the information on various Oracle technologies and products. The main objective of this group is to study and explore future areas like web enabling of existing 2 tier legacy applications, Middleware architecture, consulting, e-com requirement, content management, web server evaluation, security integration and others areas. Vijay’s responsibilities included: Involved in the process of exploring new areas of Oracle and its products. Team Coordination

8982996.doc

4

P RO FE S SI O NAL PRO FI LE Worked as Database administrator for the Human Resources database WISPER FOR EATON AT TATA CONSULTANCY SERVICES (TCS), DELHI, INDIA (07/2001 – 10/2001) WISPER (Worldwide Interactive Supplier Performance Resource) project was awarded to TCS by EATON Corporation, Cleveland, USA. It’s a Fortune 500 Company currently listed at 213th position. Eaton is a global diversified industrial manufacturer that serves industrial, vehicle, commercial, construction and aerospace markets. WISPER deals with software development for EATON to measure Supplier performance and keep track of supplier activities. Vijay’s responsibilities included: • • • • •

Involved in the process of making screen layouts using Dream weaver tool in HLD phase. Worked as a Oracle Database Administrator of the project and responsibilities include overall administration of database like installation and creation of database, space management, backup/recovery, user and role administration, schema management etc.. Involved in the writing data migration scripts UTS and testing of scripts. Involved in the process of tuning and refining queries of various modules. Involved in process of making ERDs of system and modules by using Visio professional tool.

CSS (CUTOMER SERVICE SYSTEM) FOCUS –3 FOR PACIFIC ORIENTAL NEDLLOYD AT TCS, GURGAON, INDIA (09/2000 06/2001) Pacific & Oriental Nedlloyd is the world's second largest Cargo Container Company. CSS ATLAS Release -2 is designed to support the P&ONL's inland and landside operational activities. The business objective is to reduce operational costs worldwide, whilst providing quality services to customers. This means worldwide delivery of point-to-point transport services at minimum cost, ensuring delivery on time, providing high quality services and obtaining maximum utilization of P&ONL's network, via consolidation of operational activity at the global and regional levels within ATLAS Vijay’s responsibilities included: • • •

Involved in the process of development of the components in project. Involved in the process of HLD, LLD Coding and Testing of Forms. Involved in the process of managing repository in Designer 2000.

GTS PORTING FOR PACIFIC ORIENTAL NEDLLOYD AT TCS GURGAON, INDIA (05/2000 - 09/2000) Global Tracking System (GTS) tracks Container movement worldwide. GTS receives messages form Message Originators spread across the globe, Validate & track these messages, and send them to Internal Container Management (ICM) system situated at London. GTS’ existing system is on IBM's UTS Mainframe. PONL migrated it to IBM's AIX Mainframe as a consistent platform across PONL system. In the migration process GTS system was ported from Developer Form 3.0 (CUI Interface) to Form 6.0 (GUI Interface), Database from Oracle 7.1 to Oracle 8.0, and Compatible Server program migration form UTS to AIX System. Vijay’s responsibilities included:

8982996.doc

5

P RO FE S SI O NAL PRO FI LE • • • •

Involved in the process of development, review, testing and documentation of the components in project. Involved in the process of Conversion of Developer 2000 Form 3.0 to Form 6.0 Involved in the process of Porting of Database from Oracle 7.1 to Oracle 8.0. Above all he was heading the responsibility of DBA.

ORACLE DATABASE ADMINISTRATION GROUP FOR TATA INFOTECH LTD. AT TATA INFOTECH LTD., NEPZ, NOIDA. (01/2000–05/2000) The Oracle Database Administration Group has been formed with an objective to study the various aspects of all the database systems in different platforms, define a model for Oracle Database System Administration and develop a skill pool for the company in above areas. The group defined a model for database system administration skill-base development. Vijay’s responsibilities included: • • •

Involved in the process of development of the model Coordinating with the team members TMS coordination, modification of group website.

TRAINING & SELF DEVELOPMENT Training Undergone: Course Description

Duration

Year

Induction training at Tata Infotech Ltd., NEPZ. The training program covered various basic courses like Computer Hardware Concepts, Computer Networks, Introduction to Windows NT, Refresher one-day courses on Unix and C, DBMS Concepts, RDBMS Concepts, GUI Concepts, Data Structures and Effective Technical Documentation. Also included were various modules of Software Engineering – namely S/W Engineering Overview, S/W Development Methodologies, Systems Analysis and Requirements definition Study and S/W System Design. On the quality aspects, the courses covered were Quality Management Systems Awareness, S/W Reviews and Testing. Extensive training on the Unisys 2200 mainframe was imparted- i.e., 2200 Basic Concepts (including ECL, ED and IPF), Cobol (on 2200), Mapper, Y2K Awareness, DMS 1100 & TIP & DPS. Open systems training was on Oracle and DV 2000, C++ The participants were also given enough orientation on cross-functional skills like Communication and Presentation skills, Team Work, Customer Orientation, Office Manners and Business Etiquette, Creative Problem Solving, Selling Skills. In the end they executed a small project on 2200 mainframe using Cobol.

5 months

1999 Jul -Nov

THESIS/PROJECTS •

Developed a 2-D editor in graphics project as a part of curriculum in C language.

•

Developed an Employee Database Management system for the University of Aligarh as part of degree course.

•

Developed an Assembler as a Compiler in college in C language as a part of course.

8982996.doc

6

P RO FE S SI O NAL PRO FI LE

(Vijay Kumar Singh)

8982996.doc

7