Lead Consultant (Oracle Apps Database Administrator)
GE Corporate
مجموع سنوات الخبرة :14 years, 9 أشهر
Mar 2009 - Mar 2012 GENPACT, Hyderabad, India.
Client: - GE Corporate (HRO POC Project)
Lead Consultant (Oracle Apps Database Administrator)
• Articulate the architectural vision, gathered client requirements, conceptualize and propose alternative Business Integration architectural approaches and validate the architecture against requirements for Oracle Business Rule Engine.
• Design the Service Oriented Architecture (SOA) tier.
• Installed and administered WebLogic 11g Server on Solaris & Windows.
• Installed, configure and administered Oracle SOA Suite 11g (Fusion Middleware 11g) with WebLogic Server 11g on Solaris & Windows.
• Work with SOA development team to implement SOA components like Repository and Integration registry to manage Oracle Rule Engine and web services
• Work with technical and functional teams to ensure effective delivery of systems.
• Resolve any application issues in a timely fashion.
• Work with vendors to resolve software issues.
• Support Maintenance: stop/start servers, monitor/report on server status, deploy applications and other routine administrative work, performance tuning, clustering, load balancing under multi-node clustered environment. Assume additional responsibility as required.
• Installed, configured and administered Tomcat Apache on Solaris.
• Deployed and administered Corticon Business Rule Engine with Tomcat Apache on Solaris.
• Work with development team to integrate Corticon Business Rules and web services.
Oct 2006 - Mar 2009 GENPACT, Hyderabad, India.
Client: - SABIC Innovative Plastics
Lead Consultant (Oracle Apps Database Administrator)
• Actively working on RTS cases and got recognition from the client
• Primary Contact and Support DBA for Oracle Application for Instances running in APAC region.
• Administered Oracle Applications Suite on HP UNIX.
• Installed New Instances and upgrade to latest release.
• Migrated existing Oracle Applications (Retrofit Project)
• Worked in Award Winning Project (LNP Integration) for Q3
• Worked on APAC Datacenter migration for SABIC.
• Migrated APAC production instances from Old Servers to Superdome.
• Implemented iStore application in Korea region.
• Upgraded APAC Oracle Applications from 11.5.9 to 11.5.10.2 release.
• Upgraded APAC database from 9.2.0.3 to 10.2.0.4
• Planned and configured DR Drill as per SOX compliance.
• Customizing Apps Modules for GE Specific Standards according to Business requirements.
• Managing Development, Testing and Production Instances.
• Timely refresh of all Instances with PROD Instance (Perform 2-tier clones of Oracle Applications 11.5.9 Instance)
• Hot backup and Cold backup of Code and Data.
• Analyze and Apply database and Application patches.
• Applied Localization Patches for country specific functionality.
• Monitor Concurrent Managers and Requests.
• Code Migration to Testing and Production Instances after functional Approval.
• Printer setups
• User Management
• Providing 24 X 7 Production Support.
March 2006 - Oct 2006 Eden Information Services Pvt. Ltd.,
Client: - GENPACT (GE Advance Material -Plastics), Hyderabad - India.
Consultant (Oracle Apps Database Administrator)
• Actively working on RTS cases and got recognition from the client
• Primary Contact and Support DBA for Oracle Application for Instances running in APAC region.
• Administered Oracle Applications Suite on HP UNIX.
• Installed New Instances and upgrade to latest release.
• Upgrading Oracle Applications from 11.5.9 to 11.5.10.2 release.
• Customizing Apps Modules for GE Specific Standards according to Business requirements.
• Managing Development, Testing and Production Instances.
• Timely refresh of all Instances with PROD Instance (Perform 2-tier clones of Oracle Applications 11.5.9 Instance)
• Hot backup and Cold backup of Code and Data.
• Analyze and Apply database and Application patches.
• Applied Localization Patches for country specific functionality.
• Monitor Concurrent Managers and Requests.
• Code Migration to Testing and Production Instances after functional Approval.
• Printer setups
• User Management
• Providing 24 X 7 Production Support.
Dec 2002 - March 2006 Alesayi United Company, Jeddah, KSA.
Systems Manager (Oracle Apps DBA)
• Implementing Oracle Apps 11i Suite for all Business of Alesayi United.
• Integrating Oracle Apps Application 11i with legacy systems running on different Software
• Migrating data from Non Oracle Data source to Oracle Database
• Implemented Financials and Inventory Modules
• Administered Oracle Applications Suite on Sun Solaris
• Installing New Instances, Upgrading to latest Releases.
• Customizing Apps Modules according to different Business requirements.
• Timely refresh of all Instances with PROD instance.
• Weekly Backup of All Instances
• Managing and Applying Patches
• Printer Setups
• ADI Setups
• User Management
• Performance Tuning
• Provided 24 X 7 Sys Admin Support for Production Instance
July 1997 - Dec 2002 Alesayi United Company, Jeddah, KSA.
Systems Engineer
• Successfully Analyzed, Designed and implemented Real Estate Project Management System, Human Resources & Payroll Management System, Integrated Accounting System for the whole group as a group leader for the multi org. company which covers different trading activities like Ready Made Garments, Textiles, Spare Parts, Carpet, Electrical Supplies, Sports Materials, Electronics, SEGA Video Games, Property Management, Real Estate, Trip Ticket, Health Insurance.
• Responsible in creating systematic strategic company planning in business operation. Monitoring the effectiveness of manpower in the implementation of Company System. Coordinating with the Chief Executive Officer for the different requirement for the group. Maintaining, Supporting and improving the existing modules by creating required managerial analysis requirements.
Projects Successfully Designed, Developed & Implemented
Title: Integrated Accounting System
Sales & Accounts Receivable System
Stock Controlling System
Procurement Follow-Up System
General Ledger, Budgeting & Fixed Assets
System is developed keeping in mind the future business requirements for the group. It has front office point of sale system which is completely parameterized bilingual ARABIC & ENGLISH. The back office is used for all the day to day business transactions which are closely integrated with general ledger. It is used in all the trading divisions of Alesayi United Company which has more than 50 showrooms, 20 warehouses with 8 different trading activities.
Human Resources which includes Personnel, Payroll, Attendance and Medical Insurance Systems
The system provides in detail Personnel and Official information about the employee from the join date till the end of service. It records all the internal transfer of employees, increments in salaries, employee evaluations, loans, complete track of job assignment of employees.
Daily attendance is recorded using card scanner for different working shifts. This will give the detail report at the time of producing monthly Payroll and at the time of vacations and settlements according to Saudi Labor Law.
Most of the forms that are required by all the main govt. departments can be printed from the system. It is bi lingual and it is in use to monitor the employees of 25 different business activities of Alesayi Group.
Real Estate Management System.
It consist of two modules
Project Management System
Sales Management System.
The software was developed for AQARAT REAL ESTATE Company which is the second largest real estate company in the Kingdom of Saudi Arabia. The project management module covers the full life cycle of project from the time of purchase till the completion of project. The system is designed in such a way it can hold multiple Real Estate Projects. It will give full information about the project like type of project, date of purchase, purchased value, development expenses, share value, partners transactions, Sold Area, Sold Value, Remaining Area, Project profitability, Collections, Discounts etc., This is used in day to day business transactions and it keeps track of customer information, collections and it produce more than 100 reports.
Some of the other systems developed for the company.
1) Cardex System For Warehouses
2) Office Management System
3) Property Management System
5) Shares Follow - Up System
Oracle University 10g RAC Compu Quest USA . Diploma in Computer Application.
Osmania University Hyd. Bachelor's Degree in Computer Sciences.