Project Manager-Sr Consultant - Apps DBA
WIPRO LTD.
Total years of experience :31 years, 4 Months
Working as a Project Technical Manager. Leading a team of IT professionals in ERP project impelementation support and services. Specialised into Oracle DBA and Apps DBA Track, Apart having knowledge of other IT domain areas. more details can be provided later.
I have been working as an Independent Consultant - Oracle subject matter expert prividing IT services and solution to clients in Applications, Databases, e@business, SLAs, Audit, operation data center, Oracle and Microsoft technologies etc.
Working as a Part-time Director in a Pharma Marketing and Distribution Pvt. Company.
Worked as AVP IT Hitachi Systems Ltd. during Jul- Sep 2016.
Oracle DBA 9i/10g, Apps DBA, SQL PL/SQL, IBM AIX/UNIX, Oracle EBS 11i, Oracle Apps Techno Functional Knowledge, Project Managment, onsite/offsite client projects etc.
Worked for IBM - e@biz project implementations and other contracting assignments and consulting services.
Project Management & IT Management -
. Exposure of ERP implementation, business process improvement, oracle Apps DBA, Project Management implementation methodologies.
. Exposure of Managing an IT Center.
. Exposure of People management, Quality Assurance, Quality Controls, Risk Management, Training and Documentation and Procurement of Project Management.
. Exposure of managing various IT Applications, H/w's, Network and other resources.
. Knowledge of IT planning, budgeting, Security and other strategies as per the requirements time to time.
·Reporting to the Senior Head in IT of the Company.
APPS DATABASE
.Oracle Apps Installation, Configuration & Maintenance on IBM P-Series -RS/6000 AIX 4.3.3.
·Oracle Apps Installation on Windows 2000 Server.
· AD utilities like adadmin, adpatch, adrelink etc.
·Cloning and refreshing of DB and Apps.
·Formulation and Implementation of a Backup & Disaster Recovery strategy
·Monitoring and Tuning of Database Performace.
·Setting up Desktops for Oracle Database Connectivity using Net8 Assistance.
·Creating New DB with Spatial, text, Java and Replication features, Knowlege of iAS.
·Performance - STATSPAC and other tools.
APPS SYSADMIN
·Creating users, responsibilities, Menus etc.
·Setting Profiles and Application Security.
·Registering Forms AND Report through AOL.
·Monitoring of CM, inter Set UP
·Setting up Desktops with Oracle Apps - jinitiator setup.
·H/w Sizing & File System Setup req. for Apps.
SYSTEMS ADMINISTRATION
·Monitoring Resources likewise Space, I/O, Memory, Processes.
·Monitoring resources using SMITTY.
·Managing HACMP Cluster·
.Basic Sys Admin of AIX 4.3.3.
·Installation of Lang Sets and other inst.on AIX 4.3.3.
·OS Performance and tuning.
SOFTWARE DEVELOPMENT
·Custom devp - Forms6i & Reports and Integration within the Apps.
·Knowledge of Apps Schemas, Packages, Procedures and Functions.
·Interfacing Application with Dispatch Management System \[ DMIS\]
Responsibilities :-
·Controlling SIX Online Oracle Distributed Replicated Databases running across the country.
·Monitoring of calls status on VPS/Sun Solaris and managing all databases resources.
·DBA for Oracle 8i : Objects creation, users, space management, data security, performance tuning, Backup- Hot/Cold, SQL clients, Data transfer and Purging etc.
·Development of the Client/Server Applications & Maintaining of PCCP Application using Oracle developer/2000. Maintaining ERP Soloman IV on SQL Server.
·Billing Information Management System is design, developed & implemented successfully.
·Strong Analytical and Programming experience in handling MIS needs of various departments.
·Preparation of various reports and tasks required by the Senior Management.
·Data and Systems Security Policies. Supporting backend data for the www.atc.com.sa portal.
·Reporting to the Operational Director and indirectly to the GM of the company.
PROJECT : General Oraganisation of Social Insurance Statistical Information System/ Manpower Databank System ( Aug’98 - Oct’99)
CLIENT : Manpower Council, Riyadh
ROLE : Database Application Designer
PLATFORM : Sun Sparc 5000 connected to the Pentium Client using LAN
RDBMS : Developer/2000 Forms 4.5 & Report 2.5 and ErWin/Ex Case Tool.
PROJECT : Human Resource Management System (HRMS) ( Nov.’97 - Jul.98 )
CLIENT : MANPOWER COUNCIL, Riyadh, KSA
ROLE : Team Leader/Database Application Designer
PLATFORM : Sun Sparc/ Solaris, Novell with pentium Client using LAN.
SOFTWARE : Oracle Dev/2000 Forms 4.5/5 & Report 2.5, ErWin/Ex Case Tool.
PROJECT : Saudi National Employment In The Private Sector.(SNEPS) (May’97-Oct’97)
CLIENT : Manpower Council, Riyadh
ROLE : Database Application Designer
PLATFORM : Sun Sparc 5000 connected to the Pentium Client using LAN
RDBMS : Developer/2000 Forms 4.5 & Report 2.5 and ErWin/Ex Case Tool.
PROJECT : Revised Saudi Vacational Medical Payment Plan System & Other Medical Systems.
CLIENT : SAUDI ARAMCO, SAMSO, DAHARAN MEDICAL CENTRE, DAHARAN
ROLE : Systems Analyst
PLATFORM : Pentium PC, Oracle7.2 / PowerBuilder 4.0.
BRIEFS : The above mentioned system deals with the medical vacational payment plan system for the Saudi Aramco employees treatments in the KSA or in a abroad hospital. It has various types of patient categories and their treatment as per the company policy and the best available facility in the world. It maintains the patient information, statistical analysis and charting with age groups and vice versa and creation of various types of reports.
Responsibilities : PROJECT - Hospital Information Management System(HIS) ( Jul’95 -Dec’96)
ROLE : Oracle Systems Analyst/Developer
RESPONSIBILITIES :Program development, Maintenance, Conversion of Forms 3.0 modules to 4.5
PLATFORM : Oracle6/7, SQL*Forms 3.0, Sql*Plus, Pro*C, SQL*DBA. Developer/2000 Forms V4.5.
BRIEFS : This Project involved the computerization of all functional areas of the hospital. The modules of the H.I.S are designed in such a way that it allow phased implementation, commencing with one or more 'nucleus' modules and adding others as required. This system will comprehensively meet the requirements of hospital and will provide the hospital with the means to accommodate future extensions and new hospital functions. HIS Covers the following systems.
· Patient Registration And Master Index
· Medical Records ( ICD-9 or ICD-10)
· Inpatient Management System
· Outpatient Management System
· Emergency Management System
. Pharmacy Management System
· Radiology Management System
· Laboratory Management System
· Blood Bank Management System
· Inventory & Purchase Order System
· Committees & Offices Management System
· Configuration Control & Security System
Responsibilities : Worked on the following systems -
·On Line Tracking System - Unix/Oracle 6.0 Forms 3.0
·Point of Sales System \[ POS \].
·System Management Activities.
·LAN/Network Administration.
RESPONSIBILITIES :
·Teaching Theoretical/Application Computer Science to the BE/BS Computer Science students
·PG. Diploma’s and Dept. Of Electronics recommended ‘O’ Level Courses.
·In-house S/w Development, Project Co-ordination, Supervised several projects in Finance, Inventory, Banking, Reservation, Library, Payroll, Billing, Stocks, Mathematical, Games, Quiz etc.
·Attended Oracle Forms Development Training from Uptron India, New Delhi, 1994. ·Attended ERP Solomon IV training from Al-Amri Financial Consultants, Riyadh, 2000. ·Attended many In-house job training programs in software development and quality assurances. ·Training on E-business Project Oracle Apps 11.5.7 Implementations. ·Business Process Improvement Workshop & AIX systems administration training. ·Appearing OCP–DBA Oracle 9i . CANDIDATE ID – PR00******