+91 0 9810 382282
30 August 2003
Curriculum Vitaé
Mohit Dubey
I have close to eight years of experience in the software industry, which includes more than five and a half years experience in Oracle 7.x/8.x/9i Database Architecting, Design and Administration on various Unix and NT platforms. I have extensive experience in client-server and multi-tier application design, development and implementation. With a background in using CASE tools like Rational Rose and Designer 2000, I possess strong analytical skills.
Database design of a Telecom Billing product being developed by one of the market leaders in this domain and administration of the development/test databases for the largest data warehouse in Asia-Pacific region and are some of my significant achievements.
A large proportion of my professional life has been spent at client sites. I am therefore very confident in client-facing roles. I have extensive experience working with large teams and in cross-project roles, both at client sites and offshore. The ability to manage competing work-pressures, prioritize them and address them in a timely and efficient manner is a skill I have honed to help me excel in such situations.
Having worked throughout in CMM and ISO certified organizations, I have an excellent grounding in Quality guidelines and procedures.
I am seeking a challenging position in the area of Oracle Database Design, Architecting and Administration.
Skills Matrix
Key:
1 - Done Training only; 2 - Can work with
Support; 3 - Can work independently; 4 - Can lead and guide others; 5 - Expert
|
Skills Area |
Experience (yrs.) |
Grading |
|
Software skills |
||
|
Oracle 7.x/8.x/9i Database Administration |
5.5 |
5 |
|
Sun Solaris Administration |
2.0 |
3 |
|
Oracle Enterprise Manager, Performance Pack |
2.0 |
3/4 |
|
Rational Rose 2000 |
2.5 |
3 |
|
Oracle Developer/2000 & R2 (Oracle Forms 4.5/5.0 & Reports 2.5/3.0) |
1.25 |
4/5 |
|
C & Pro*C |
2.0 |
5 |
|
Oracle Designer/2000 |
1.0 |
4/5 |
|
Unix/shell/awk (HP/UX, SunOS, SCO, DRS/NX, AIX) |
6.5 |
5 |
|
PL/SQL |
7.0 |
5 |
|
Hardware platforms |
||
|
Sun E10000, E4500, E450, E250 and UltraSparc series |
4.5 |
5 |
|
HP T520, T600 |
1.25 |
4/5 |
|
ICL DRS/6000 |
1.5 |
4/5 |
|
SCO OpenServer on IBM PC |
0.5 |
3 |
|
IBM PC and compatibles |
5.0 |
4/5 |
|
Functional Areas |
||
|
Telecom Billing and Data Warehousing |
2.0 |
3 |
|
Public Utilities and Services |
2.0 |
3 |
|
Retailing Sector |
1.5 |
3 |
|
Banking and Financial Sectors |
3.0 |
3 |
Project
Details
HCL
Perot Systems (September 1998 To Present)
|
Project |
Modular EPPIX (April 2003 To Present) |
||
|
Client |
LogicaCMG Wireless Data Solutions, U.K |
||
|
Location |
Birmingham, UK & New Delhi, India |
||
|
Environment |
H/w: Sun E4500 |
O/s: SunOS 5.x |
|
|
|
S/w: Oracle 8.1.7 |
Tools: Microsoft Visio 2003, Rational Rose 2000, Shell |
|
LogicaCMG is currently developing a GSM billing product for worldwide release – modular EPPIX – in multi-tier architecture of J2EE. HPS is engaged in the design and development of two modules within this product: Billing & Discounting and Prepaid.
The analysis & design phase of this project (which saw a team of 5 designers working on-site) has just completed and the implementation phase is about to start shortly.
Role: Senior Oracle DBA, Database & Systems Architecture and Design.
· Part of the core architecture and design team for the product
· Tasked with designing the database to support the two modules
· In-depth understanding of the client requirements & acquiring a domain-knowledge of Telecom Billing & Discounting and Prepaid processes has been a critical pre-requisite to this work
· Database architecture and design has included
o Preparation of logical models
o Creation of scripts to manage module schemas
o Creation of volume data generation scripts for performance testing
o Recommendations on database and critical table structures to support a high throughput
· Closely involved with the performance related aspects of all Batch/Online process designing. This includes
o Recommending data caching strategy to be followed
o Optimizing data-access logic within the design
o Recommending tuning of database structures (using indexes, index-organized tables and partitioning) where needed
· Recommendations on design of a crucial Discounting batch process have resulted in a projected performance increase by 10 times
· Additional responsibility of a Business Analyst responsible for vetting all application design before final deliveries to the client
|
Project |
AutoFX – Cross Border Payments (December 2002 To March 2003) |
||
|
Client |
Bank Of Ireland, Dublin |
||
|
Location |
New Delhi, India |
||
|
Environment |
H/w: Sun E4500/E6500 |
O/s: SunOS 5.x |
|
|
|
S/w: Oracle 8.1.7 |
Tools: Shell, PL/SQL, awk |
|
Bank Of Ireland’s overall strategic requirement is to automate all Cross Border payments processed through it’s Business Online (BOL) system.
The BOL system is implemented as a 4-tiered system with Web clients sitting in Tier-1 talking to Web servers in Tier-2. The web servers in turn communicate with Cool:Gen and EJB modules in Tier-3 which interact with Oracle servers in the same tier, or with mainframe systems in Tier-4 via MQ series.
Role: Senior Oracle DBA, System Architecture and Design.
· Principally responsible for an impact analysis of components in Tier-3
· Tasked with validating all architectural changes proposed therein. This included
o Application schema changes on Oracle
o Changes in various interfaces with upstream and downstream components
· Analysis was to be subsequently translated to implementation changes to schema and interface components
· Was responsible for looking after the entire project environment distributed between offshore and Dublin
|
Project |
MEMPHIS (August 2001 To November 2002) |
|
||
|
Client |
Union Bank Of Switzerland, London |
|||
|
Location |
London, United Kingdom |
|||
|
Environment |
H/w: Sun E4500/E6500 |
O/s: SunOS 5.6/5.8 |
||
|
|
S/w: Oracle 8.1.7 |
Tools: Shell, PL/SQL, awk, Oracle 8i Performance Pack, Quest Schema Manager, Sybase DirectConnect |
||
The MEMPHIS program was targeted towards building a comprehensive workflow-based system for processing Confirmations and Settlement transactions of the Investment Banking arm of UBS.
A Browser based application with BusinessObjects-Oracle backend was implemented to provide MIS reporting functionality. Another component of this program was the migration of existing application functionality from Sybase to Oracle.
The peak group size of MEMPHIS was more than 100 members with a number of projects of medium to high complexity running in parallel.
Role: Senior Application DBA, Database Administration
& System Architecture/Design.
· As the Oracle expert, one of my principal responsibilities was to architect strategies for implementing desired business functionality in Oracle
· Specific components designed and implemented in this regard include
o An optimized application load-balancing algorithm using Oracle Objects
o Document storage and retrieval mechanisms using BLOBS
o Optimized application auditing infrastructure
· My responsibilities as the Oracle DBA for the entire MEMPHIS program included
o Ground-up implementation of Oracle database utilization strategy
o Standardization of all MEMPHIS Oracle databases
o Implementation of Sybase to Oracle replication
o Setting up disaster-tolerance via Oracle Standby databases
o Performance enhancement of the MEMPHIS infrastructure (which saw the database bottlenecks decrease by 30%)
o Day-to-day maintenance and administration of all the MEMPHIS development, test and production instances (9 in number, peak size of 60 GB)
o Liaising with external support groups for specific hardware and software related problems
· Cross-program role necessitated the ability to juggle competing work-requests and pressures from different projects. I was able to successfully carry out my responsibilities and provide a high level of service in this challenging environment.
|
Project |
Clearstream Services (March 2000 To July 2001) |
|
||
|
Client |
Clearstream Services, Luxembourg |
|||
|
Location |
New Delhi, India & Luxembourg |
|||
|
Environment |
H/w: Sun E250/E450/E4500 |
O/s: SunOS 5.x |
||
|
|
S/w: Oracle 7.3.4/8.x |
Tools: Shell, PL/SQL |
||
This account was targeted towards building and maintaining an offshore Development Center and Testing Lab for Clearstream Services, a global financial giant.
Role: Team Leader & Sr. Application DBA. Database Administration & Solaris/NT Administration.
· My principal responsibility was the administration of four Oracle 7.3.4 and 8.x development/testing databases sized up to 60 GB. This included
o Creating new instances
o Administering users and security
o Downsizing and applying data cuts
o Migrating databases between Oracle versions
o Recommending, reviewing and applying structural database changes based on application-specific requirements
o Performance tuning of the developed code and providing general Oracle expertise to teams as needed
· Performed general Unix administration of the host Sun servers. This included
o Implementation planning, Configuration and Installation of new Sun servers and storage disk arrays
o Server build (OS install and initial disk partitioning)
o Disk space configuration/reconfiguration and maintenance on Sun A1000 and T1000 disk arrays
o Setup and maintenance of backups using DLT6000 Tape Library and Sun Solstice Backup Suite
o User accounts creation and maintenance
o OS patch application
o System health monitoring and diagnostics
o Assistance with network planning and configuration.
· Tasked with drawing up and budgeting proposals for hardware resource upgrades based on requirement analysis of projected growth in the account
|
Project |
MIS Data Warehouse (March 1999 To February 2000) |
|
||
|
Client |
IBM Global Services, Australia |
|||
|
Location |
Melbourne, Australia |
|||
|
Environment |
H/w: Sun E450/E10000 |
O/s: SunOS 5.6 |
||
|
|
S/w: Oracle 7.3.4/8.0.5 |
Tools: PL/SQL |
||
This project was targeted towards building a marketing Data Warehouse for IBM-GSA’s principal client - Telstra. With a size projected to grow up to 7 TB from an initial 2 TB, it was to be the largest Data Warehouse in the Asia-Pacific region.
Role: Application DBA, Database Administration.
· Principal responsibility was the administration of five development and testing databases. This involved
o Administering users and security
o Generating and applying data cuts
o Formulating application-specific security guidelines
o Recommending, reviewing and applying database structural changes
o Assisting the project team with all Oracle related issues
o General Unix administration of the development machine
· As part of supporting the development team, I was involved with
o Performance tuning of the developed code
o Preparing production/test sizing estimates
o Defining database storage allocation for various tables/indexes and subsequent production implementation of the same
· Also was one of the migration controllers and helped set-up a process for configuration management in the project
|
Project |
PHOENIX (January 1999 To February 1999) |
|
||
|
Client |
IBM Global Services, Australia |
|||
|
Location |
Melbourne, Australia |
|||
|
Environment |
H/w: HP T600 |
O/s: HP-UX 10.2 |
||
|
|
S/w: Oracle 7.3 |
Tools: Developer R2, Designer 2000 |
||
PHOENIX is a front-end application intended to provide a unified view of all the various data sources spread across different mainframe systems in Telstra. The project involved enhancement of this GUI front-end to upgrade it with new functionality.
Role: Team Member -
DBA and Data Analysis & Custody Teams.
· Responsibilities as a DBA Team Member included
o Administering the production database
o Applying data cuts and patches
o Building new development/test databases
o Assisting the development team with all Oracle related issues
· Responsibilities as a Data Analysis & Custody Team member included
o Reverse-engineer existing screens and reports written using Developer 2000 into Designer 2000
o Redevelop these using Designer 2000 and Developer R2
o Develop new screens and reports to support enhanced functionality
|
Project |
Cedel Bank (September 1998 To December 1998) |
|
||
|
Client |
Cedel Bank, Luxembourg |
|||
|
Location |
New Delhi, India |
|||
|
Environment |
H/w: HP-T520 |
O/s: HP-UX 10.2 |
||
|
|
S/w: Oracle 7.3 |
Tools: PL/SQL, Pro*C |
||
The project involved enhancement of an existing securities, deposits and financial transaction application to build in new functionality.
Role: DBA, Database Administration.
· Responsibilities as the project DBA included
o Creating, building and maintaining the offshore development database
o Administering database users and security
o Generating and uploading data cuts for development/testing
o Implementing a database backup strategy
o Resolving Oracle issues faced by the development team
o Reviewing all database structural changes proposed by the development team and applying them
· Carried out some Unix administration on the development server. This included
o User accounts and file system maintenance
o Application of software patches
o General monitoring and troubleshooting
ICIL
LTD. (NOVEMBER 1995 TO AUGUST 1998) (Currently
Zenstar Ltd.)
|
Project |
GB/Books (June 1998 To August 1998) |
|
||
|
Client |
Gordon and Breach, Reading, United Kingdom |
|||
|
Location |
Pune, India |
|||
|
Environment |
H/w: IBM PII300/P200 |
O/s: Windows NT 4.0 |
||
|
|
S/w: Oracle 7.3 |
Tools: Designer/2000, PL/SQL, Pro*C |
||
The project involved design, development and implementation of an enhanced version of an existing application to cater to the client's expanded business needs.
Role: Team Leader & DBA - Design and Database Administration.
· Responsibilities as the offshore design and development team leader included
o Approving the change specifications drawn up by the team
o Coordinating team's activities with the client on-site
o Managing work-allocation among team-members
o Tracking project delivery schedules and time-lines
o Prototype re-design through Designer/2000
· My responsibilities as a DBA involved
o Keeping the offshore database in sync with the onsite database
o Design and implementation of new database entities to support extended functionality
o Preparation of processing flow and entity relationship diagrams
o Design of table structures and normalization
|
Project |
19 Million Scaling (UK-LINK) (March 1997 To May 1998) |
|
||
|
Client |
British Gas Transco, Solihull, United Kingdom |
|||
|
Location |
Solihull, United Kingdom |
|||
|
Environment |
H/w: HP T520/T600 |
O/s: HP-UX 10.2 |
||
|
|
S/w: Oracle 7.3 |
Tools: PL/SQL, Pro*C, Unix |
||
The project involved design, development and implementation of a distributed database architecture to cater to increased data traffic and a middleware suite to support it.
Role: Team Member - Design, Development & Implementation and Post-Implementation Services.
· My responsibilities as a member of the designing and development team involved
o Requirement study for the batch component of middleware suite
o Preparation of system specifications and system design documents
o Preparation of processing flows, entity relationship diagrams and supporting database design
o Coding, testing and implementing the batch ROUTER component of the middleware suite
· Provided post-implementation support. This included
o Change impact analysis
o Problem resolution as part of a ‘Special Expertise Group’ assigned to all major system problems
|
Project |
Thai Daimaru (June 1996 To February 1997) |
|
||
|
Client |
Daimaru, Bangkok, Thailand |
|||
|
Location |
Pune, India |
|||
|
Environment |
H/w: ICL DRS6000 |
O/s: DRS/NX System V |
||
|
|
S/w: ORACLE 7.1 |
Tools: Forms 4.5 |
||
The project was to implement and customize the BERE Retail system, a proprietary retail package from ICIL, for Daimaru’s needs and do a pilot implementation in their Bangkok outlet.
Role: Team Member - Development & Testing.
· As a member of the development team, my responsibilities were
o Understanding the scope of changes required to the present system
o Coding changes in the screens and backend as per specifications using Developer 2000 and Oracle Procedure Builder
· As a member of the System and Integration Test team, was involved setting up test beds and evaluation of test results.
|
Project |
Project Sales System (PSS-60) (May 1996 To June 1996) |
|
||
|
Client |
ICL Ltd., Bracknell, United Kingdom |
|||
|
Location |
Solihull, United Kingdom |
|||
|
Environment |
H/w: ICL DRS6000 |
O/s: DRS/NX System V |
||
|
|
S/w: Progress 7.2 |
Tools: SQL |
||
The project involved the enhancement of an existing retail package called ISS, that was being customized by ICL for a client in the UK. The package was to be enhanced to handle ‘assembly’ type sales.
Role: Team Member - Design, Development & Testing.
· As a member of the designing and development team, responsibilities were
o Understanding the requirement specifications
o Preparation of module design documents
o Coding and testing
· Designing activities included
o Preparation of processing flow charts
o Preparation of entity relationship diagrams and normalized table structures
|
Project |
Back End Retailing Expert (BERE) (January 1996 To May 1996) |
|
||
|
Client |
Fujitsu Ltd., Japan |
|||
|
Location |
Pune, India |
|||
|
Environment |
H/w: ICL DRS6000 |
O/s: DRS/NX System V |
||
|
|
S/w: Oracle 7.1 |
Tools: Forms 4.5, Reports 2.5, Designer/2000 |
||
The project aimed at developing a generic package for retailing market which as initially to be used by CK-Tang group of stores in Singapore and subsequently marketed as a product.
Role: Team Member - Development and Testing.
· As a member of the designing and development team, responsibilities were
o Understanding the requirement and system specifications
o Preparation of screen and report design specifications
o Coding and testing as per specifications
· Performed the reverse engineering of modules in BERE to capture information for use in future maintenance and enhancements in the package.
|
Project |
Defect Tracking System (November 1995 To December 1995) |
|
||
|
Client |
ICIL Ltd, Pune, India |
|||
|
Location |
Pune, India |
|||
|
Environment |
H/w: ICL DRS6000 |
O/s: DRS/NX Unix System V |
||
|
|
S/w: Progress 7.2 |
Tools: SQL |
||
The project involved creating a tool for V&V teams to monitor defects during the Software Life Cycle. This was an in-house project aimed at evolving a standard platform for tracking software defect resolution to be used in all projects across the company.
Role: Team Member - Development and Testing.
· As a member of the designing and development team, responsibilities were
o Understanding the present manual system and requirement study
o Preparation of system specification and system design documents
o Coding and testing
· Designing included
o preparation of processing flow charts
o Preparation of entity relationship diagrams and designing normalized table structures
Educational
Qualifications
B.Tech. Electronics & Communication Engineering, Regional Engineering College, Jalandhar, 1995
(10+2) from Kendriya Vidyalaya, Shillong, 1991
Professional Training and Continuing Education
Oracle 8i Database Performance Tuning workshop 18 Feb 2001 - 22 Feb 2001 (Competency Development Center, India)
Oracle 8i Database Backup & Recovery workshop. 14 Feb 2001 - 17 Feb 2001 (Competency Development Center, India)
Oracle 8i Database Administration workshop. 7 Feb 2001 - 11 Feb 2001 (Competency Development Center, India)
SEI-CMM Quality Procedures and Process Implementation Workshop. 15 May 1999 - 25 May 1999 (IBM Global Services, Australia)
Oracle 8.0 Database Performance Tuning workshop 15 Nov 1998 - 17 Nov 1998 (Oracle Global Education, India)
Oracle 8.0 Database Backup & Recovery workshop 13 Nov 1998 - 14 Nov 1998 (Oracle Global Education, India)
Oracle 8.0 Database Administration workshop 6 Nov 1998 - 10 Nov 1998 (Oracle Global Education, India)
Oracle 7.x Database Administration (DBA), 9 March 1998 - 20 March 1998 (in-house)
Oracle 7 Forms 4.5 and Reports 2.5, SQL*Plus, PL/SQL, Nov 1995 (in-house)
Three Days training on ISO and QMS at ICIL, Pune
Awards and Achievements
Consistently classed as ‘Star Performer’ since 1998 by HCL Perot Systems
Presented with the ‘Exceptional Contribution Award’ for the year 2000 by HCL Perot Systems
Recognized as ‘Outstanding Performer’ for the year 1999 by HCL Perot Systems
Received ICIL Excellence Award for work done in UK-LINK
Declared ‘Super Performer’ for the year 1997
Ranked Second (Overall academic performance) in Engineering batch of 1995
References
Available upon request