profile

Name                                                         Rajeev Pandey

Contact                                                      rpandey2004@yahoo.com/+91 9953416666

Nationality                                                Indian

Total IT Experience                                  Over 16 Years

Overseas Experience                                Over 5 years   in USA, Over 7 Years in Japan                                  

Education                                                  BE Computer Engineering  (SGSITS Indore, India)

                                                                  MBA Finance (C.V.Raman Institute of Sc. & Tech, India)

                                                                  MBA (Simon School of Buss., Rochester, NY 8 credits)

Certification                                             Sun Certified System Administration–I (83%)

Languages                                                 English, Japanese (JLPT Level 3 certified).

SNAPSHOT

§  Over 12 years of experience in Oracle Applications  DBA, Project Management, Support & delivery.

§  Currently managing service delivery in onsite-offsite/offshore model which includes remote DBA support.

§  Oracle applications upgrade from 11.5.10.2 to 12.1 ; from 12.0.4 to 12.1.3 and from 11.5.9 to 11.5.10.2.

§ Leading support projects on Oracle Apps 12.x, Oracle 11g/RAC , datawarehousing ,DB upgrade(s)  and migration.

§ Good experience in formulation and implementation of disaster recovery solution using Oracle Standby/ DataGuard.

§  Very good experience with installing and configuring backup solutions like RMAN / Legato Networker

§  Good experience in Oracle Applications System Administration and end user support under heavy production 
§ Proven expertise in installation, configuration and cloning/ replication of Oracle database
 instances, performancetuning in RAC/Non-RAC environments

§  Over 4 years of MS SQL Server Database Administration, Upgrade, Seting up transactional replication and standby databases , in a  Windows 2000 and SQL Server 2000 Clustered environment.

§  Good experience in  Data Analysis/Architect/Design, Data Modeling /Dimensional Modeling (Star Schema) .

§  Extensive  backend database programming using PL-SQL/T-SQL and Shell /DOS Scripts.

§  Good experience with Business Intellgence Tools like OBIEE,Business Objects,Discoverer,Crystal Reports.

§   Hands-on experience in ETL Tools like Informatica and  DTS Package

§  Installation experience of OBIEE,on UNIX as well as Windows environments which included Discoverer migration, RPD design, report design and development  using OBIEE in an Oracle Financials environment.

Service and Project Leadership

§  Interface with Managers/Leads/Clients/Users for  gap analysis, finalising specifications & resource allocation.

§  Managing multiple accounts / teams , delivery management , defining SLAs,writing RFPs, SOWs, Sizing the systems,

§  Interact with team members to ensure smooth progress of project work.

§  Ensure adherence to quality norms throughout the upgrades  & implementation process.

§  A team player with strong communication, leadership, analytical, organizational and relationship management skills, with expertise in interfacing with international project teams for successful execution of projects.

Skill Summary

Database Administration Experience:

	Version	Duration
Oracle EBS	12.1,11.5.10.2,11.5.9,11.5.8,11.5.5,11.0.2	11 Years
Oracle RDBMS	11gR2,10g,9.2,8.x,7.2.3	11 Years
MS SQL Server	2000, 7, 6.5	4 Years
MySql	5.x	1 Year

UNIX Administration Experience:

Sun Solaris (on Sparc)	10/8	4 Year
Linux RHEL	5.x	1 Year

Work Summary:

Fujitsu Consulting, Noida, India (Since Mar’2011  )                    

Designation:Lead IT

Accomplishments:

·         Leading database practice as centre head of Noida location, managing 40 DBAs

·         Managing client engagements across India and overseas (Gulf, USA, Europe).

·         Managing onsite-offshore delivery model which includes remote database support.

·         Writing RFPs and SOWs

·         Hands-on dba activity on Oracle 11.1.0.7 in a datwarehouse environment involving OBIEE and Informatica

·         Hands-on work on oracle applications upgrade from 11.5.10.2 to 12.1 in AIX environment

·         Solution Architect on various proposals across Middle East

·         Leading support projects on Oracle Apps 12.x, Oracle 11g/RAC etc

Hudson Japan, Tokyo Japan (From July 2006 to Feb 2011):

Designation: Oracle Database Administrator

Managed Database and UNIX operations of Japan operations of an American Private Equity Fund.  Managing Oracle Applications (EBS Suite) and Windows based custom build Oracle 10g Databases. Hands on Sun Solaris 10 installation, upgrade and administration. Supporting Accounting Staff, DOTNET developers and business analysts in a global environment. Reporting directly to Senior VP Business Systems.  With following responsibilities:

·         Oracle Applications upgrade from 11.5.9 to 11.5.10.2

·         Oracle database upgrade from 9.2.0.5 to 10.2.0.4 and from 10.2.0.4 to 11.2.0.1

·         Installation and configuration of OBIEE 10.1.3.4.1 on sun Solaris as well as Windows

·         Upgraded Discoverer 4.1 to Discoverer 10g

·         Managing 6 Oracle Application Instances, 2 Production Instances on Sun Solaris with Oracle 10gi. 20 Oracle database Instances on Windows 2003 and Oracle 10g.

·         Oracle Application / Database Installation, Creation and maintenance on SUN Solaris.

·         Oracle 10g database administration on Windows 2003 and Sun OS 10

·         Database performance tuning and support to developers and end users.

·         RMAN database setup and backup configuration using Networker 7.2

·         Sun Solaris 10 Installation, upgrade and administration including disk mirroring using SVM

·         DBA support to Discoverer Administrator.

·         Installation and configuration of Oracle Enterprise Manager 10.2.0.3

·         Functional System migration: Independently handled Oracle Payables

Environment: Oracle Applications 11i, Oracle Database 9i/10g/11g, Legato 7.2, Discoverer 10.1.2.3/4.2, Windows 2003/2008/Sun Solaris 10

Future Electronics, Tokyo Japan (Feb 2004 – July 2006):

Designation: Oracle E-Business Suite Administrator

Managed Oracle Applications system rollout to Asia Pacific Operations to different countries of a Japanese multinational logistic company as a consultant with following responsibilities:

·         Database  Upgrade from 8.1.7.4 to 9.2.0.6  on HP 11i under Oracle Applications 11i environment

·         Administration of the Oracle 8I Database and multinode NLS Oracle Applications 11.5.8.

·         System Maintenance and Performance Tuning for Optimal Performance and best uptime.

·         Oracle Apps 11i and Oracle 8i Database Characterset Migration from US7ASCII to UTF8

·         Supporting Multilingual Database Application

·         Setting up printers on HP-UX and Oracle Applications to Support multilingual printing.

·         Writing System Monitoring and Performance Tuning Scripts.

·         Coordinating with different groups in US, Japan, Singapore, Taiwan, Malaysia, China, Korea and Hong Kong teams

·         Writing Unix Shell Scripts for Database Health check, Performance Monitoring.

• Oracle Apps and Database Cloning to create various test and Development environments.

Environment: Oracle Applications 11.5.8, Oracle Database 9i/8.1.7.4,HP-UX 11i

Bharti Televentures, New Delhi, India (December 2002-March 2004)

Designation: Manager Information Technology.

Managed all India operation of Oracle Applications/databases and IT operation of India’s largest Telecom Service Provider in New Delhi India with following responsibilities:

·         Administration of the Database and Applications for Oracle Financials 11i

·         Upgrade of Oracle Applications 11.5.5 to Oracle Applications 11.5.9

Birlasoft, Noida, U.P., India (August 2002 – December 2002)

Designation: System Analyst

·         Worked on Datawarehousing project in Onsite Offshore Model.

·         Extraction of Legacy Data using Oracle SQL Loader in Distributed Database environment.

·         Data Modeling of Datawarehouse Schema using Erwin

·         PL/SQL code and SQL Tuning, DB Performance Tuning using Explain Plan and SQL Trace.

Environment: Oracle 7.2.3, Oracle 8.1.6, Business Objects 5.0, IBM Visual Age 3.0, Webserver 2.0, ASP 5.0, IIS 5.0, HP-UX 11i

BUY.COM, Orange County, California, USA (Feb’2001 - April 2002)

Designation: Senior Database Administrator

Managed e-commerce website databases, oracle applications and shipment data warehouse databases of a southern California based e-commerce Company with following responsibilities:

·         Oracle Financials System Release 11.0.2 Application Administration and Upgrade.

·         SQL Server 2000 DBA and Oracle 8i DBA in production environment.

·         Server Installation, System Monitoring, Replication-Administration, windows 2000 and SQL Server Cluster, Performance Tuning, Monitoring, Troubleshooting, Backups and Restores.

.

Environment: SQLServer 2000, Oracle 8.x/8i, Oracle Applications 11.x, Sun Solaris SPARC 2.6.

Mohawk Finishing, Amsterdam, NY, USA (September 1999 – October 2000):

Designation: Database Administrator

Managed MIS Environment in a manufacturing company supporting customer service and sales staff to use ADAGE (ERP system) with SQL Server database and data warehouse.

Environment: SQLServer 6.5/7.0, Windows NT 4.5, ADAGE,IQ-OBJECTS

Questra Corporation, Rochester, NY, USA (From September 1998 – September 1999):

Different projects with Questra are as follows:

SALOV-ADAGE: System constituted Server Installation, Analysis, Report Generation and Integration of SCT-Adage ERP System. IQ/Object was the tool used for Report Generation.

XCAMS (Xerox Customer Account Management System): Lead Developer in Migration of Watcom SQL4.0 based PowerBuilder Application to Access 2.0 and Oracle 7.3 Database. Independently handled the whole PowerBuilder part of the project, which included Prototyping, Development,

Environment: Oracle 7.3, SqlServer 6.5, PowerBuilder 5.0,  Windows 4.5

Future Technology, NJ (May 1997 – October 1997)

Computer People, NY (October 1997 – September, 1998) 

Was involved in Design, Development, Rollout and Maintenance of Business Information System (BIS) and Sales Tracking and Reporting System (STARS).

BIS: System included Sales and Marketing Reports, Customer Profit/Loss Reports etc. STARS: System covers all nation-wide Business Information for Packaging Division Environment: Oracle 7.2, PowerBuilder 4.0/5.0, SQL* Loader, Windows NT, AIX

NOVA SOFTWARE, Bombay, India (January 1995- April 1997)

Designation: Software Engineer

Worked on various offshore projects of Nova Software for its various US based clients.

Requirement Analysis, ERD preparation /implementation, GUI Design/Development, Application and Server Installation, Configuration and Application Tuning for the following projects:

·         Sales Configurator

·         Survey Information Processing and Reporting System

·         Aviation Information System

Environment: PowerBuilder 4.0, Windows NT