Rohit Mehta

Experience

• 

  H P Expert Systems

  Apr 2000 - Mar 2002

  Software Engineer

   Designed, developed Oracle/VB based total lone solution. The system had 3000 tables and 7000 stored procedures, among others. Designed and developed a web base Complaint handling system CPWD application

• 

  Martin & Harris (P) Ltd

  Apr 2002 - Dec 2003

  IT Admin, ERP- DBA Analyst

   Implemented inventory & sale management for more than 2500 pharmaceutical product  Designed and implemented the Distributed Database features helping save the company approximately $1 million per year in maintenance.

• 

  Godrej Consumer Product Ltd

  Dec 2003 - Aug 2005

  ERP Consultant / DBA, IT Administration

   Administered and provided ERP production DBA support to the several databases of Financial Data Warehouse. Implement overall IT setup at Manufacturing plant and its warehouse  Developed the distributed database systems reducing significant load on the databases. Tuned the databases resulting in a 10% performance boost (20% is exceptional).

• 

  Sarvotham Care Limited

  Aug 2005 - Feb 2006

  Sarvotham Care Limited

   Designed, developed and managed a unique solution for a wide range of health care. Sarthovam cater to Gillette, Amway, Dr. Reddy's Laboratories, Pfizer etc. The Project involved the implementation of QAD ERP/ (Oracle Apps), IT setup.  Managed a team of 10 DBAs for Design, Development and Production support Administered 50+ ERP databases totalling 5000 GB, both OLTP and data warehouse. Developed and implemented a comprehensive Disaster Recovery Plan for the different ERP Databases at the division. Setup and managed EDI among several databases. Show less

• 

  Tata Consultancy Services (TCS)

  Apr 2006 - Nov 2007

  IT Analyst, ERP Consultant (DBA-Lead)

   Modeled, designed, implemented and administered the APEC division for QAD’s MFG-PRO customized ERP implementation. Post implementation customization support of MFG/PRO eB2 data centre for all the clients. Maintain and update their database for offshore development and testing purpose. To maintain and support all the servers (UNIX, Windows, Web Servers, Tomcat, and Apache) and interfaces like (Command Line, GUI, Web interface) to provide online demo and training to the clients using the B2B approach. Successfully designed, implemented MFG/PRO ERP for Uttam Galva is one of the major galvanised steel exporter. Project involves implementation of standard modules of MFG/PRO eB2, he was responsible for the MFG/PRO environments setup in Unix AIX 5.3 cluster environments with Desktop 2.8 (Web interface). Show less

• 

  Capgemini

  Nov 2007 - Jun 2009

  Senior IT-ERP Consultant (DBA-Project Leader)

   Implemented, administered and subsequently tuned a 1000+ GB Progress database for Marks and Spencer ERP, a retail giant, for its UK and Ireland offices. Capgemini deals with the production support of various applications used by Marks & Spencer stores and also the General Merchandise (Mainframe) applications Implementation& supported Oracle-ERP/QAD, Progress database of PeopleSoft ERP instances for Schneider & GE Electrical France. Implementation & supported the QAD, Progress-ERP database and data warehouse system totaling more than 2 TB 1200 database instances. Visteon is one of the leading automobiles parts manufacturer in the world. As a Database Administrator, was responsible for the support activities pertaining to applications having the Oracle/Progress MFG/PRO DB2 database Show less

• 

  NIIT Technologies Limited

  Jun 2009 - Mar 2015

  Technology Architect (Project Manager)

  • Designed, implemented and supported the databases (Progress-MFGPRO, QAD, Oracle, MSSQL) – including Warehouse Database for MOOG, Visteon, Holiday Autos website in London, for Last Minute (Travel website) and Saber Inc. in travel domain. • Designed and Implemented version migration for Progress/Oracle Databases and Datacenter from UK to Cyrus One data center in US• Manager DBA &Lead Production Support for 24X 7 (L1, L2 & L3) Live site support• Managed and lead DBA teams in across different locations around the world for a single project/client Show less

• 

  Al Hilal Group

  Mar 2015 - now

  Sr. Solutions Architect (Project Manager)

  • Upgrade and migrate the Progress databases (8x & 9X) to new ERP system and implementing the third party High Availability and backup solutions environment• IT Infrastructure, Version Migration of Application, OS and Cloud Solutions • Managing and consulting the multiple QAD/Oracle, Progress/OE Database Projects, Designing , implementation and supported for infrastructure, solution integration, the Application databases and ERP across different domains 24 X 7 support.• Project Management, Estimation, Technologies risk analysis, IT solutions, people management. Show less