Arup Nanda

SKILLS SUMMARY

Senior Oracle DBA with 10 years of experience in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, ProC, C, Unix, NT, Shell Scripting.

EXPERIENCE PROFILE

•  Heavy Database Administration in Oracle Production Databases (in both Oracle8 and 8i)

•  Oracle Parallel Server (Oracle 7.3 and Oracle 8i)

•  Integration of Web to Database (including XML)

•  Distributed Data Warehouse Design, Development and Administration

•  Oracle Advanced Replication

•  Financial Data Warehouse Development

•  Health Insurance Network Hub Management Interface

•  Complete Banking and Financial Services System (Design and Development)

•  Professional Training Resources Management Systems

•  Financial Portfolio Management System (Design and Development)

•  Customer Support and Maintenance System (Design and Development)

•  Decision Support System in Inventory Management

•  Material Management System

PROJECT HISTORY

(January 2001 till present) Database Administration and Migration of a Large Scale Oracle 8i Parallel Server Database at Oxford Health Plans.

The database is a dual purpose one; its OLTP side, of about 800 GB, supports the enrollment, verification and claims processing of various Oxford insurance plans and its Datawarehouse side, of about 900 GB, supports the managerial decision-making. The implementation was on Oracle Parallel Server (later renamed Real Application Cluster) on a four-node 16-way Hewlett Packard N-Class Cluster with Fiber Interconnect. He was one of the Senior DBAs supporting the database in relatively complicated tasks like Performance tuning, Backup strategy tuning, Net8 load balancing, among other routine tasks. He was in the design review committee to draft a best practices solution. He was part of the team doing the migration of one of the databases from 7.3 to Oracle8i.

Tasks Design and Development of DB Objects like Materialized View, Views, Tables and Associated objects like Indexes and Triggers DBA Tasks - Access Issues, Security, Space, Tuning, Alternative Solutions Like Distributed Databases, Database Objects, Etc. Net8 Load Balancing, Migration.

Software Oracle8i Parallel Server, Enterprise Manager and DBA Studio, PL/SQL, SQL*Plus, Windows 2000, HP-UX 11.

(April 2000 till January 2001) Design, Development and Implementation of Financial Products at At Financial Products Division of Priceline.Com.

The division was responsible for developing and maintaining the products like home mortgage, refinancing, pre-approvals, term life insurance, auto insurance and credit cards. It was a database intensive application based on Oracle 8 and Oracle 8i. He was responsible for designing the database from the user interactions, creating and administering the database pertaining to the products mentioned, providing support to the developers on database access, troubleshooting oracle related problems, enhancing applications by tuning database access and designing alternative solutions. He was also responsible for the creation and maintenance of the XML DTD and the XML documents used to communicate with the partner companies. The special aspect of this project was the direct impact of the tuning on the bottom line of the company.

Tasks Design, Development And Maintenance Of All Database Related Objects Like Tables, Views, DB Links, Procedures and Packages in Development, Test and Production Databases. DBA Tasks - Access Issues, Security, Space, Tuning, Alternative Solutions Like Distributed Databases, Database Objects, Etc. Creation of XML Docs and DTD.

Software Oracle 8 and 8i, Net8, Enterprise Manager and DBA Studio, PL/SQL, XML, SQL*Plus, Solaris 2.6, Windows NT 4.0 Server and Workstation.

(April 1998 till April 2000) Design and Development and Implementation of a Customer Equipment Upgrade System At Lucent Technologies. Due to certain flaws in some manufactured products, the company has to make sure that the customers are adequately transitioned into the better and later equipment. The system designed helps about 15000 Sales Managers across North America pursuing that task. It had a web interface accessing an Oracle8 database and links to most major company databases. He was involved from the very beginning, at the conceptualization stage and later responsible for design, development of the database components and finally the database administration

Tasks Design and Development of All Database Related Objects like tables, views, db links, procedures, etc. in Development, Test and Production Databases. Production Database Administration Tasks - Security, Space, Tuning, Access Issues, etc. Design of Advance Solutions like Distributed Database Systems

Software Oracle8.0, Oracle8i, Net8, Oracle Enterprise Manager, Shell Scripts, OEM Performance Pak, PL/SQL, ProC, SQL*Plus, Solaris 2.5, Perl

(December 1997 till March 1998) Enhancement and Administration of Sales Management At Lucent Technologies. This was a tool developed by an external vendor for the company and was supposed to be handed over to the internal team. However, it was at an unfinished stage when delivered and he was involved in the final work on the product. It is a web-based tool designed to help the Sales Managers to target potential customers and start sales campaigns. I was responsible for installing the databases, configuring them and making distributed connections to multiple databases. I was also responsible for the database administration tasks like security, tuning and other exercises.

Tasks Design and Development of all Database Related Objects like tables, view, db links, Procedures Database Administration Tasks- Security, Space, Tuning, Access Issues, etc. Design of Advance Solutions like Distributed Database Systems.

Software Oracle 8.0, Net8, Oracle Enterprise Manager, Windows NT, Solaris 2.5 Oracle Call Interface, OEM Performance Pak, PL/SQL, SQL*Plus

(September 1996 till November 1997) Design, Development and Administration of Customer and Inventory Data Warehouse At Lucent Technologies. The project involves construction and maintenance of several very large databases for storing data related to the equipment sold to the customers. The system handles online as well as summarized and intensive search oriented users totaling four hundred and size hovering around 600 Gigabytes. The special tasks noteworthy in this project are the tuning based on the heavy online and batch access, the coexistence of several types of front end tools like Unix, X-windows, PowerBuilder, Visual Basic, Developer/2000 and Web. As the leader of the DBA team, he is the interface between database administrators and users such as managers, developers, production support personnel, end users and testers. He participates in design of all sub-projects and develops the database-related objects. He is directly responsible for production databases maintenance and supervises maintenance of other databases. The high point of his performance in this project is the introduction of an online client server design to make a distributed database system out of several heterogeneous systems. He also worked on upgrading the remaining Oracle7 databases to Oracle8.

Tasks Design and Development of all Database related objects like tables, views, db links, procedures, etc. in Development, Test and Production Databases. Production Database Administration Tasks - Security, Space, Tuning, Access Issues, etc. Design of Advance Solutions like Distributed Database Systems

Software Oracle 7.1, 7.2, 7.3, 8.0, 8.1, Developer 2000, SQL*Net, Net8, Oracle Enterprise Manager, OEM Performance Pak, PL/SQL, Pro*C, SQL*Plus, Solaris 2.5, Windows NT, BMC Patrol, Platinum Server Manager, Sablime.

(June 1996 till September 1996) Design, Development and Administration of a Data Warehouse for Financial Data At Yale University. The project involved the design and development of a Very Large Database of size around 400GB of financial related data. He was involved in the design of tables, view, and optimized queries; development of the database related procedures, objects and methodologies. As the DBA he was responsible for performance tuning, space management and security administration. The advanced tuning methodologies utilized are Parallel Query Servers, Disk Striping, Start Schema, etc.

Tasks Design and Development of all Oracle related programs like Forms, PL/SQL, etc. Database Administration Tasks - tuning, space, security management, etc.

Software Oracle7.3, Developer/2000 suite: Oracle*Forms 4.5, Oracle*Reports 2.5, PL/SQL 2, Pro*C 2, SQL*Net2, SQL*Plus, AIX on IBM RS/6000

(June 1995 till June 1996) Design and Development of a Health Insurance Data Warehouse for Blue Cross Blue Shield of VA on Oracle. The project involved the design and development of a data warehouse of mainly insurance related information. At the center of the project was the hub - which was the traffic interchange for all the flow within the network. The hub also hosted the data warehouse of size approximately 100 GB. He was the application and database administrator of the database overseeing the application development, providing the application support to the non-Oracle application developers, data modeling and database administration. The task encompassed the design and development of various database objects like Tables, Indexes, Views, Snapshots, Stored Procedures, Stored Functions, Packages, Upload Programs, Interface Programs, Pipes, etc. The modules that were covered in the project were the database repository, data-communication interface, pricing, security and performance monitoring modules. The database was used as a repository for providing the information between the providers and members among the network. In addition to that he is also the only DBA in database administration tasks like security management, space reorganization, performance tuning, etc.

Tasks Design and Development of all Oracle related programs in Pro*C, Forms, PL/SQL, etc. Database Administration Tasks.

Software Oracle7.2, Developer/200 suite : Oracle*Forms4.5, Oracle*Reports2.5, PL/SQL 2, Pro*C 2, SQL*Net 2, SQL*Plus, CMVC config mgmt s/w, AIX on IBM RS/6000.

(August 1993 till May 1995) Design and Development of a Banking and Related Financial Services Software Package used by CitiBank and IndusInd Bank. The project involved a very large complete software development based on Oracle and related tools for the use of banking and financial institutions. It had 23 modules like Saving, Checking, Loans, Securities, Foreign Exchanges, General Ledger etc. The focus of this project was on distributed computing and the database processing. Additionally since the industry is so changing, The software had to be extremely flexible. It had about 15000 stored procedures and functions and 1500 forms. The design was based on Object Based Approach using Oracle Packages and Development was controlled by configuration software. The design was done using an in-house tool of TCS. The processing logic was handled by the Packages and the front end was in Oracle Forms. Reports were written in SQL*Reports and some in Pro*C. Along with the design and Development of the packages, he was also the DBA at the Client site managing the Production databases. He was involved in the migration from Oracle V6 to V7.

Tasks Design, Development, Testing and Implementation of the Product's Various Modules, Project Management and User Documentation Writing., Oracle Installation and Troubleshooting, Oracle DBA tasks

Software Oracle7.0, Oracle*Forms4, Oracle*Reports2, PL.SQL, Pro*C, Unix, Solaris, UX on DRS/6000, HP/9000 and Sun.

(April 1993 till July 1993 ) Design and Development of a Training Management System for the efficient organization of trainees, trainers and training resources for Tata Consultancy Services. The training activity in TCS is very complex due to the fact that TCS trains about 2000 persons both in-house and external using all kinds of resources. The project was to design and develop a complete task manager for the complex activities in Training Management. It had modules like Needs Assessment, Needs Definition, Class Composition, Faculty Assignment, Scheduler, Preparation of Support Material like Rosters, Quiz-sheets etc.

Tasks Analysis/Design/Development/Testing

Software Oracle 6.0, SQL*Forms3.0, SQL*ReportWriter1.1, Pro*C, PL/SQL, Unix

(January 1993 till March 1993) Design and Development of a Financial Portfolio Management System For Mishra Financial Services. The company specializes in financial markets and enjoys a large customer base. The major activity is advising the customers regarding the investment options and managing assets. Due the varying nature of customer preferences and the volume of data, it is almost impossible for the portfolio manager to constitute an acceptable portfolio. This project was to develop a system for decision support, pricing, accounting, projection and history monitoring. Using the software, the manager can assess the best combination of securities for the client, taking into account all factors, both supporting and limiting.

Tasks Analysis/Design/Development/Testing/User Manual Prep

Software Oracle 6.0, SQL*Forms 2.3, SQL*Reports, Pro*C, SQL*Menu XENIX on PC/AT

(August 1992 till December 1992) Design, Process Re-engineering and Development the Customer Service and Maintenance Activities for Radiant Systems, a major Network Equipment manufacturer. This project involved the detailed routing plans for the preventive maintenance engineers, handling of emergency assistance to customers, and the management of the Logistics like inventory control and warehousing of stocks. The company had a major growth of about 2000% in a single year with much larger geographic spread. This necessitated the need to reorganize the resources to deploy them efficiently and wisely. The end product of this project, the software fulfilled the need. It used the linear programming methods to optimize the system.

Tasks System Analysis, Design Process Re-engineering and Development, Testing and User- Manual Writing.

Software Oracle6.0, Forms, Reports, Pro*C, Menu, XENIX on PC/AT

(January 1992 till March 1992) Design and Development of Decision Support System for Inventory Management for Coats Viyella, a multinational Fabric Manufacturer. The client's problem was the management of a very large number of stock keeping units (about 1 million) and the unsuitability of any standard inventory management system. The project involved the development of a tool for aiding decision on the various logistics related problems like Re-Order Point, Re-Order Level etc. It combined a decision support tool with training software in inventory control using Monte-Carlo simulation technique. The resultant software was distributed to the company's branches for decision aid and training.

Tasks Systems Analysis, Design, Development, Testing

Software SQL*Forms 2.3, Oracle 6.0, XENIX, Pro*C, User Exits

© 2002, Proligence.