ORC Expert Advisory Services ORC International

  home    |    find an expert    |    request an expert    |    join our network    |    about us     expert login  
Expert Consulting and Expert Witness Services
  
  search tips 
Share this page:  Send to LinkedIn Send to Facebook Tweet This Email Print

 Expert  727863

Expert in Database, DB2, Oracle, Aix, HACMP, Websphere, MQ, Windows, BI Tools


Available for your Consulting and Expert Witness Needs

United Expertingdom
Education Work History Consulting Services Expert Witness

Summary of Expertise:

Listed with other top experts in: 

Expert considers that his credentials and interests match with your requirement and want to apply for suitable position in your company. Expert brings to you 10 years of IT infrastructure experience of which involves as a Database Analysis/Administration/Installation, Migration & Technical Support using (Database - DB2 UDB V8.2/9.1/5,Oracle V9.2/10g, Sybase)(O/S - AIX,HACMP, windows, VMS, Solaris, Linux)(Middleware - BEA weblogic, JBoss,IBM websphere, MQ and messaging) (Migration tools as Datastage, IBM Information Server) (BI - Abinitio, Informatica) and as system engineer & architecture for Administration and Troubleshooting of Middleware and frontend, DR and Contingency. With his diverse experience with Fortune 500 companies and others, he has acquired vast skills and knowledge from closely working with Architects, Designers, Project Managers at all times during his career.
 • 

client/server architecture

 • 

client/server computing

 • 

client/server database access software

 • 

computer system administration

 • 

data management

 • 

data processing

 • 

data recovery

 • 

database

 • 

database design

 • 

database file management

 • 

database management

 • 

database management system

 • 

database metalanguage

 • 

database programming language

 • 

database searching

 • 

database server

 • 

database technology

 • 

DB2

 • 

DB2/QMF

 • 

DB2/SQL

 • 

document scanning

 • 

federated database

 • 

multidimensional database

 • 

object-oriented database

 • 

open database connectivity standard

 • 

Oracle

 • 

relational database

 • 

SQL database

 • 

Standard for the Exchange of Product Model Data

 • 

Structured Query Language

 • 

transaction processing


Show Secondary and Basic Areas of Expertise

Education:
Year   Degree   Subject   Institution  
2000   Hardware - P5series   P5series/HACMP Certified   IBM Partner  
2000   HDSE   Diploma in Software Engineering   Aptech  
2001   Diploma in Ecommerce   Ecommerce   Comet  
2001   DBA   DB2, Oracle   Client Trained  
2000   Bachelors   Computers, Commerce   University of Mumbai  

Work History:
Years   Employer   Department   Title   Responsibilities

2007 to 2009

 

Cerner

 

IT

 

Senior Analyst

 

Group: - e-bookings and Cerner Millennium for NHS • Cerner tools such as e-bookings, power chart, schapt book, scheduling etc (Millennium Tools) • Maintain front-end, middleware & backend architecture, 4terabyte of data and components. • Automated system tasks. • Automated operating system tasks. • Administer/Install/upgrade Oracle 9i to 10g, Tune oracle database at a professional level. • Administer/Install/upgrade Aix and HACMP (Power HA). • Administer/Install/Upgrade MQseries backend and Websphere frontend. • Tuning frontend and backend nodes for an average of 40000 bookings made every day by GP´S. • Manage complex middleware back-end components. • Deploy Application patches/packages. • Correct back-end domain issues. • Project Implementation/Methodology • Support & maintain application to SLA and BAU • Communicate troubleshooting issue, escalation and resolution. • Provided migration support to internal GRID DB2 UDB v8.2/9x db on standalone nodes platform Aix 5.3 and power HA. • Contribute back to the knowledge community by sharing experience about Cerner culture, process and tools best practices to other associates.

2006 to 2007

 

IBM

 

IT

 

Consultant

 

• Designed RDA (Rational Data Architecture Models) Physical and Logical data models based on Architecture. • Equal Participation in db design and implementation strategies along with other groups. • Maintaining of DB Environmental Documentation for various environments Dev, Test, Pre-Prod and Prod. • Supported 24X7 DB performance tuning, Load Testing and Data loading with Data stage. • Generating Reports using datastage. • Defining of TSM and backup strategies for multiple Releases. • Provided client connectivity support and DB maintenance. • Attending meetings and conference on schedule basis and providing functional / technical support to group.

2006 to 2006

 

Bank of America

 

IT

 

Sr DBA

 

• Applying (CCC) security compliance checker code policies and script to maintain Banks security compliance and database administration. • Provided Support to all environments Dev, CIT, EPE, PreProd, Prod and Prod2(contingency/HADR Machines) • Done Aix upgrade to servers from 5.2 to 5.3 for servers and client. • Installed, configured and catalogued databases for report generation, being done for Ab initio. • Designed and deployed Optimized Ab initio graphs for High Volume transformations. • Implemented the aggregation of same data across different tables in the legacy system. • Designed and deployed Optimized Ab initio graphs for High Volume transformations. • Done Installation of DB2 8.1 and updating of fix pack 7.1a to 7.1b on servers and client machines. • Done Replications and database restore online/offline for contingency servers. • Troubleshoot the data issues during the migration. • Done Database cloning and replication, given hardware support Filer move, Tivoli storage etc.. • Installed Ab initio Co-operating v2.14 system and GDEv1.15 client software and helped developers in connection with database DB2 and Oracle. • Health Monitoring with Foglightv4.2 and spotlightv4.7 installation and implemented successful automated process of diagnosing and monitoring of many servers in Banking Environment. • Provided training to peers with installation and maintenance of 3rd party applications. • Administering Netbackups and SAN storages

2005 to 2005

 

Chekfree

 

IT

 

Sr DBA

 

• Logical designed and physical implemented for multiple OLTP, OLAP, DSS systems running on UDB EEE v5, v6, v7 and v8 under AIX 4.3, AIX 5L platform. Included but not limited on instances , databases and all database objects creating, file systems setting up, space design and allocating, user accounts creating, system configuring, system access control setting up. All house keeping scripts created or prepared. • Configured and implemented Ab initio server and client and help ETL developers in data connection and support. • Used command line process to configure memory according to the number of concurrent users, workloads and the types of database operations (OLTP or DSS). Planned file systems/locations for data storages with consideration of data types and volumes. Implemented security on databases based on requirement of user/groups. • Planned and Implemented DB2 UDB V7.2 systems of Disaster Recovery (DR) and High availability (HA) strategy. • Participated DB2/UDB candidates technical interviews and responsible for on-the-job training of junior members of the Database Administration group.

2003 to 2004

 

Arabian Odyssey

 

IT

 

Sr DBA

 

• Installation and configuration of DB2 UDB v 7.2(UDB EEE) on AIX5.1. Functioned as a DB2 Database Administrator responsible for the performance and tuning of DB2 Programs. • Actively participated in brain storm sessions with Analyst in creating the ER diagrams in Erwin. • Created event monitors to check the health of the system. • Using replication summery tables , collocation tables is done • Created Database partition groups by grouping the different database partitions. • Created Snapshot monitors and event monitors to regularly check the health of the system. • Used various BMC tools for monitoring of database. • Created EXPLAIN tables and ran the Visual Explain utility on SQL statements. • Installed SQL-Server2000 and Win2000 and configured them to install ExpertMA. • Provided support to Oracle and SQL-Server2000. • Created EXPLAIN tables and ran the Visual Explain utility on SQL statements. • Used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data from Oracle database to DB2 database. • Performed Reorgchk, Reorg and RUNSTATS as and when necessary to eliminate the defragmentation. • Developed Backup and Recovery Strategies. • Used Quest Tool to monitor the Buffer Pools, Table spaces and Locks to improve the performance.

2002 to 2003

 

Igma Advertising

 


 

Sr DBA

 

• Installation and configuration of DB2 UDB v 7.2(UDB EEE) on SP2 (AIX). Moved databases from older version of DB2 V5.2 to 7.2 & from Oracle to V7.2 & Call support for production environment. • Functioned as a DB2 Database Administrator responsible for the performance and tuning of DB2 Programs. • Migration of People soft tables on Oracle to Peoplesoft 8.0 on DB2 UDB v 7.2 • Database design, customisation and administration of Websphere provided tables. • DB2 database analysis and design for data handling , physical and logical design , normalization and conversion of data from Oracle to DB2 • Setup of Tivoli ADSM for storage, Backup and restore. • Did performance tuning of E-CRM packages and HRMS modules for monthly releases. • Used Data Joiner to join the data between Oracle and DB2

2001 to 2002

 

Modi Measurements Systems

 

IT

 

Sr DBA

 

• Installation and configuration of DB2 UDB on AIX / Windows NT. • Provided 24/7 support for a Data Warehouse for both production and development databases on Multiple Database Partitioning Environment. • Created Instances for Development, Test and Production environments. • Installed and configured databases on Oracle8i and MS SQL Server7.0/2000. • Work involved create, configure, upgrade and maintenance of the UDB database in Windows NT and AIX environments. • Setup DB2 Clients on NT and Linux. • Setup of Tivoli ADSM for storage, Backup and restore. • Connected Sun and NT nodes to server. • BMC software was used in various database administration functions • Created Logical and Physical Design of the database. • Imported Data using Load and Import Utilities. • Created Snap shots and used Performance Monitor to analyze the current activity that is going on in the database. • Ran load and unload utilities on Mainframe to extract data from MVS and load it into DB2/UDB. • Wrote ETL scripts for data loads from various sources – Oracle 8i ,UDB and MS-SQL Server 6.5/7.0 • Written ETL scripts for the informatica (PowerMart4.7/PowerCenter1.7) in order to populate the IMS DataMart using the flat files.


Consulting Services:
Click the green button above to contact Expert for a free initial screening call regarding your expert consulting needs.  Expert is available for consulting to corporate, legal and government clients.  Remember, your initial screening call to speak with Expert is free.

Expert Witness:
Click the green button above to contact Expert for a free initial screening call regarding expert testimony, litigation consulting and support, forensic services, or any related expert witness services.  A few litigation needs include product liability, personal injury, economic loss, intellectual property (patent, trademark, trade secret, copyright), and insurance matters.  Remember, your initial screening call to speak with Expert is free.

International Experience:
Years   Country / Region   Summary
2007 to 2009   UExpert   Worked for Healthcare solution providing company.
2005 to 2007   UAE   Consulting for Financial and solution providing companies such as Chekfree, Bank of America and IBM.
2002 to 2004   UAE   Worked fulltime for Travel and Advertising company Arabian Odyssey and Igma Advertising
2001 to 2002   INDIA   Worked for Automotive and Commissioning company Modi Measurements.

Additional Skills and Services:
Training/Seminars

Developed - ERP : Oracle Financials11i (Techno/Functional) Miocrosoft Biztalk Server


 

Need the right expert?  We can help!

home       find an expert       request an expert       join our network       about us

Intota is now ORC Expert Advisory Services

FOLLOW ORC ON