Oracle Dabatabe Architect
veHere Technology
Total years of experience :25 years, 9 Months
I have total 25 yrs of software development with database design and 10 years of Senior Oracle DBA experience (mostly on Oracle 8i, 9i, 10g, 11g with frontend D2K, JAVA, VB, .Net) in different sectors namely Automobiles, FMCG, Banking, Pharmaceuticals, Publishing House, Civil Construction, Textiles Weaving & Fabric Export, Chemicals Export, Sales Chain & CRM, Finance with Branch wise/Divn Wise P/Loss & B/Sheet (Schedule VI) & apportionment, Textiles Inventory, ERP on manufacturing, Database and Application Migration from Oracle 8i(windows) to Oracle 10g(AIX 5.3l) and Oracle 10g AS, Outstanding Analysis, Debtors/Creditors List, Age Analysis, Yarn Management etc.
EXPERIENCE SUMMARY
Experience in Application Development/DB Admin on Oracle 8i/9i/10g/11g(Rel2)
Initial Planning for Database Creation & Schema Designing
Oracle 8i/9i/10g/11g Installations (OEL 6.3AIX 5.3L; RHEL AS 4.0; HPUx-11i)
Oracle ASM, RMAN, Data guard configuration, DB Tuning, etc.
Resource Planning, Client and User Interaction, Allocation, Job spec scheduling.
Project Planning, Man power allocation, Form Design, Programming \[10g AS\]. Unix Scripting, etc.
Also proficient in :-
Oracle (9i/10g) Database Administration
Oracle Application Development
Oracle 10g AS for Forms & Reports (Application Server in HP-Ux11i)
Oracle 10g DS for Forms & Reports (Windows Client)
Oracle SQL/PLSQL
Java (J2EE) Language Programming
Oracle ADF (ver 10g & 11g) Moderate knowledge
Oracle Web Logic Server Moderate knowledge
OS
Unix Shell Scripting
AIX 5.3 L
HP-Ux 11i
RHEL AS 4.0
OEL 6.3
Windows Client Version
Oracle 10g AS (Application Development)
Oracle 10g DS \[10.1.2.0.2\]
Oracle ERP (Finance, Inventory, Production, HR, Sales, Purchase)
More than 24 years of IT experience in the following domain
Oracle Production Databases, Software Design and Development
Banking, Financial & Insurance
SBI Foreign Exchange Reconciliation, Currency List Summary & Day Book
ABN AMRO Bank (All India Inventory Project)
MAGMA FINCORP
Automobiles
Sales, Spares, Inventory, Cost Centre analysis, GL, AP, AR, Personal Ledgers, P/L & B/Sheet
FMCG (Confectioners)
Finance, Production, Sales & Distribution, Sales Monitoring, Order Management, Dealers’ Commission, Outstanding Analysis, etc.
Production, Inventory & Stock Management
Pharmaceuticals
Sales & Distribution, Sales Monitoring, Supply Chain Management, Health Care & Pharmaceuticals
Financial System
Branch wise, Division wise Profit & Loss Accounts
Branch wise, Division wise Balance Sheet (Schedule - VI)
Outstanding Analysis
Factory & Organizational Payroll
Databases for Telecoms
State & Central Security Databases (OLAP and OLTP)
Managed instances of 3 TB and more in size
Expertise in System Administration AIX5.3, RHEL 4 & 5, HP Ux 11i,
Windows XP professional (client)
Proficiency in SSAD, System Documentation, Impact Analysis, Change Management, Software Test Phases and Version Release
Client Interaction, understanding requirement analysis
OCA 9i DBA Track