Antony Jebamani

x01a64@r.postjobfree.com

404-***-****

Skills Summary ---- Having Security Clearance currently working on federal projects ---

I have over 23+ IT years of experience as oracle architect/apps/data warehouse/core/dev DBA in which 9+ years Oracle ERP apps/ production DBA (24/7 on call) in USPS, Oracle corporation and Accenture(Bellsouth & AT&T). Oracle Datawarehouse / Informatica and UNIX soft admin, shell scripting, programmer analyst, computer engineering lecturer with management consulting experience exposure to people, process, technology, methodology on implementing new infrastructure. Experience in Oracle 10g/11g RAC/ASM/OEM 11g/10g/9x/8x/6x admin, Administering Oracle 11i CRM /r12 ASCP,Demantra, Obiee, ODI, applications- installing, patching, cloning, production maintaining for business solutions in Telecom Industry; Developing/Integrating enterprise Crystal info adm & Reporting, Exposure Dataware house DBA & Informatica, Configuring NT/IIS servers, TCP-IP/assembly coding, designing PCB board, administering Unix Servers like Sun OS, AT&T/Sco Unix, developing codes using Unix Sell Scripting (ksh,sh) , C, C++, Pro*c, pl/sql, COBOL,Java; Graphic system-Quick Action procedure AutoCAD, Auto Lisp, GS 1000 Graphic Simulations; 3GL and 4GL database applications, Integra-SQL, Inscript, VAX/Delphi and exposure to Sybase and ingress and Informix databases with Open System. I have the experience to work well with both technical and non-technical skilled workers with excellent communications as project groups.

.

References: Upon Request.

Education:

Master of Computer Application (full time attended college) from Bharathidasan University, St.Joseph’s College, 1989.

Bachelor of Computer Science (full time attended college), from Bharathidasan University, St.Joseph’s College, 1986.

Certifications: AutoCAD and Oracle SQL & Pl-sql, 11i training from Oracle Corporation while working as Oracle Employee, Attended Oracle 11g feature seminar at Oracle Corporation.

Recent Updated Skills

Oracle r12.1.1 ASCP (RAC) , ORACLE OBIEE 10.1.3.4.1, DEMANTRA 7.3.0,Oracle SOA Suite 10.1.3.1

Demantra 7.3 Tech /Obiee Install & Configuring with ODI and Topology Manager.

Oracle ERP DB clone, Oracle rman backup, rman db clone.

Used rman duplicate for cloning and

Hands on experience 10g/11g RAC/ASM build in Solaris, Migrating 10g database to Linux RAC.

DOM/GIS, WEB LOGIC APPS

Performance tuning on DOM/GIS, WEB LOGIC apps.

Building and deploying Weblogic Server.

Installation of weblogic tools, apps & web tools.

Data warehouse/informatica/odi support and tuning issues.

Exposer to 11i/12i RAC.

DB project planning & Execution.

Technical knowledge of :

Oracle r12.1.1 ASCP (RAC) , ORACLE OBIEE 10.1.3.4.1, DEMANTRA 7.3.0,Oracle SOA Suite 10.1.3.1

Upgrading 11.5.10i with 10g ASM_Upgrade, Informatica Power Center 7.3.

Upgrade 8i to 9i, 9i to 10g and 10g to 11g experience.

Cloning R12/ RAC/ASM instance,OEM.

Skills:

Databases: Oracle 10g/11g,Oracle - 11i ERP DBA(RM) / R12 ERP DBA (ASCP)

Dataware House: People Soft / OBIEE architect / Seibel Analytical / Reporting.

Strong in Oracle Performance Tuning, Oracle Stream, Upgrading, Cloning and DB Design.

APPS/TOOLS: ODI, Informatica ,ETL, Crystal Info Server, Crystal Security Reporting, DOM/GIS & Weblogic apps .

Strong in Oracle Tools - Discoverer, Forms, Report, Graphics, Pl/Sql programming.

Strong in Unix Shell Programming (ksh & sh), C & C++,Java Programming, COBOL, PASCAL,FORTRAN, FOXPROD & 3GL databases; Crystal Reports, Database Management and Administration, Data Architecture, Sun Solaris, HP 9000, HP-UX, Microsoft Windows 2000 Professional, Windows NT, Microsoft Access, Microsoft Project, Microsoft Office, TCP/IP,

Relevant Client Experience

Client: USPS Information Technology, Raleigh. May 2010 - Current

Oracle EBS r12 DBA with obiee & demantra Admin

Currently on SEAM (Solution for Enterprise Asset management) projects as USPS.

Environment:

Oracle r12.1.1 ASCP (RAC) , ORACLE OBIEE 10.1.3.4.1, DEMANTRA 7.3.0,Oracle SOA Suite 10.1.3.1

(Maintaining Dev/TEST/TRAIN/PREPROD/PROD 4Nodes LINUX x86_64 GNU/Linux RAC instances).

Installed & configured obiee & demantra for r12 rac ebs ascp application.

Clonning r12 RAC with multiple db/apps servers.

Rman duplicate / Rman Copy / DB vip move / Cluster Move

Upgrade from r12.1.1 to r12.1.4

Upgrade from 10g to 11g.

Customized context files for all db/apps.

Performing complete OBIEE admin & Architech.

Implementing OBIEE ssl & Ebs SSL

EBS , Demantra, OBIEE patches.

Maintaining & troubleshooting ASM instances

troubleshooting cluster/interconnect issues.

Resolved memory & configuration settings with ascp processes.

Troubleshooting concurrent managers/programs.

Performed r12 ascp/custom migrations with oracle RICE migration utility.

Experienced in demand planning architecture for supply chain it systems.

Demantra/OBIEE/ODI db/client server setup.

Demantra performance for demantra engine runs and its sales, item &location loads.

Improving the demantra worksheet performance.

Carryout customization across envs with db sync.

Demantra/obiee user administration.

Obiee RPD file/CATALOG migration.

ODI setup and managing the odi agents.

obiee job scheduling management.

Troubleshooting demantra db_params/system params.

Troubleshooting the demantra/obiee issues.

working with dev team to resolve their issues.

working with crs, rman backups & handing adhoc requests.

Accenture Nov 2007 – Apr 2010

AT&T (ex Bellsouth )

Atlanta, GA

Project Role: Oracle apps (prod) /Obiee DBA

24/7 support of DSL Production, Preprod, Test and Dev database system environment for AT&T which handles the fast access internet DSL ordering system. This is a 24/7 critical environment. There are more databases in Production cycles.

Migration of Oracle CRM into DOM/GIS applications.

Involved in all DB migration activities.

Rman backup & Rman db clone setup, test, implement.

Handling DOM/GIS performance issues by carefully analyzing Database statistics.

Working with Sterling Commerce, Oracle to resolve post migration issues,

Day to day adhoc requests and performing CDT (db structure move) from DB to DB as per DOM/GIS apps requirements.

Installing & Configuring Obiee admin server and Stream setup for datawarehouse.

Upgrading / Installing Databases to 10g / Data guard / MV / Oracle Stream Setup & Maintenance.

Tuned many inefficiency SQLs working with Dev team and doing day to day DB activities.

Connect direct & BSOM files process handling.

Resolving issues that occur due to other applications integration such as Kintana, Stargate etc.

COX Communications Jan 2007 – Oct 2007

Atlanta, GA

Project Role: Sr.Oracle (10g RAC) DW/Apps Prod DBA

Responsibility: Implementing New infrastructure on the process of migrating existing 9i production database to Linux 10g RAC cluster /ASM management. Lead DBA for data warehouse/repository Oracle Production servers with Architect to Warehouse New projects and 24/7 on call support with Team on rotation basis.

Primary:

Upgraded old Prod Database from Solaris 8i (8.17) to Solaris 9i (9.2.0.6).

Migrated repository dev/prod database from Solaris 9i to 10g and to Linux 10g RAC/ASM.

Designing logical infrastructure as team and implementing.

Installing new servers with 10g RAC/ASM and Client installation and configuration as per user requirements.

Upgrading 8i to 9i and 9i to 10g RAC.

Applying oracle patches worked with Oracle Corporation on Serv 1 issues.

Lead DBA/Architect for Data warehouse support team for their new projects & Troubleshooting CRS/ASM issues.

Managing ASM disk groups on Production servers and Maintaining Production database backup & its archives.

Restoring Production databases on its critical downtime.

Code migration to Dev, Preprod and Production, Troubleshooting production issues.

Analyzing & Tuning Production poor performance queries using explain plan, DBMS packages.

Designing Proper indexes for dev queries, Developed automated Production monitoring scripts with shell scrip.

Managing Datawarehouse objects like Partitioned tables, Bit map indexes.

Fixing warehouse informatica load issues on PROD.

Secondary:

Design new projects as a project architect, Preprod project migration and troubleshooting the issues, worked closely with Datawarehouse Informatica/BO functional team, Improving load process performance.

Skill:

10g RAC/ASM/OEM, Informatica, Warehouse architect designs, Exposure & handling data of oracle 11.5.10i financial applications/ People soft applications.

Accenture September 2002 – Jan 2007

Client: BellSouth

Atlanta, GA

Project Role: Oracle application 11i CRM (prod) DBA

24/7 support of Production, Preprod, Test and Dev database system environment for Bellsouth which handles the fast access internet DSL ordering system. This is a 24/7 critical environment There are more databases in Production cycles. The responsibility of my job is

• To work with oracle 11i apps CRM projects with analytical method of using business logic and to minimize its production downtime at critical severity 1 cases and troubleshoot & resolve the errors often raised by the testers and developers.

• Analyzing the existing environment procedural business logics through programming. Developing & modifying existing UNIX shell scripts, Managing oracle apps concurrent jobs, queues and adapters through XDP monitoring pages; managing database shared Pool, checking Innotrac processing, frequent health checking for the tablespaces, diskspace, archive free space, specially during regression testing or load testing and writing automated Unix scripts to automate the regular monitoring activities.

• Performing offtime activites such as production release, backups of database and 11i binaries and space management such as reorg. Applying customized patches such as scripting, sdp, inet services, setups, oracle tools, API, apollo and Helios etc.

• Compiling and troubleshooting the Helios codes fro errors by check-in and check-out from Harvest environment to promote codes level.

• Creating TARS for major issues with Oracle Corporation. With oracle support, following up with their direction by applying core patches and tuning SQL if required. Upgrading oracle database versions.

• Monitoring other tools like dispatcher process, billing process, Innotrac process, Connect direct process, alera process and helios & web server logs and Wrote the XML scripts to build the web logic BEA environment

• Monitoring SOEG (Service Order Entry Gateway) flow through control. Checking and supporting the tools Dispatcher, TDSL, C MU.

• Maintenance Activities: Handling Server Fail-over,DB Analyze, completing OS and DB user requests, DB Verify, Backup and Restore Procedures: OS Backups, SQL Backtrack Backups, Cold Backups, TOP Backups , BCV’s;Applying custom code as well as redwood Shores patches and

• Performing periodic maintenance of database re-org, PURGES, sizing the database and SQL tuning.

• Cloning: Cloning the test environment from prod env including database clone and TOPs binaries clones. This clone verifies changing server names, port#, changing apps password, apps server and web server setup changes. Performing sanity test after clone.

Skills:

Oracle Apps 11i , upgrade 11.5.3/10, oracle databse 8.1.7, oracle 9i, 10G and Informatica, vantive, XML , Bea weblogic servies INET&APOLLO, TOAD, Oracle workflow 3.2, C:D, Innotrac, Alera, apache.

• Writing reports using Pro*c to access data in programming and running them through UNIX scripts. Installing developed custom patches.

• Upgrading software versions and writing automated scripts for the regular maintenance jobs.

Intercall Inc, Atlanta, GA Jun-2001 to Feb 2002

Project Role: Oracle DBA / Crystal Info Admin.

Worked on billing project of monthly running cycle and the scope of the project are to develop and design reports on crystal report 8.5 and deploying the reports on internet using Internet Information Server (IIS) using Crystal Info Server. My role in this project was Oracle DBA/Crystal Info Admin.

Primary Task Include:

Database sizing and SQL Tuning.

To Estimate the performance of Oracle Database during Design.

Installing NT server and its IIS server with service pack.

Installing Crystal Web Reports with Row level and folder security.

Implementing the reports on Intranet with security.

Creating and maintaining users and groups using Info Administrator to logon Intranet web reports.

Wrote electronics report using PRO*C.

Designed Web Design for web reports.

Software used in this project: Crystal Info Server 7.5, Crystal Reports 8.5, Oracle Database 8.1.7, Informix Database 9, NT server 4.5, PRO*C, C, Java and HTML.

Oracle Corporation : Principal Consultant Jan 2001 to Apr 2001

Project Role: Principal Oracle Apps DBA

• Worked in a team of Oracle application Technical Architects and DBA’s to implement Oracle 11i (11.5). Installing and applying patch set for the following modules on 11i on Sun OS and Compaq Tru64unix2platform for customer support.

• Designed the Oracle 11i architect and created specifications to configured 8 instances, including a DR environment. Designed the multiple time zones document to achieve the local date stamp for transactional data. Maintained and modified the Instance Strategy.

• Created a DR document that has been followed since implementation.

• Conducted presentations and delivered several proposals to the client for technical enhancements to the applications. Wrote the cloning document and created the environment spreadsheet. This application was core financials with Oracle manufacturing. Created documents for the Interface Architecture portion of the implementation.

• Created training session for the new Analyst

Worked on Oracle client projects at Solution Centre, Atlanta, Oracle Corporation. Responsibilities: Installing and applying patch set for the following modules on 11i on Sun OS and Campaq Tru64unix2platform for customer support.

IProcurement (SSP5) Self Service Purchasing5

CRM modules: iStore, eMail Centre, iMarketing online, Oracle sales online, Sales

Compensation, Oracle telesales, configurator

OM Module: Order Management Module

Worked on Oracle Products:

11i apps/installation and applying patches (above modules)

11i apps/ functional (for above modules)

11i apps Administration

RDBMS 8x (UNIX/NT) DBA

RDBMS 7.3x (UNIX), RDBMS 6.0 (dos)

Oracle Enterprise Manager OEM (Performance Tunning Pack.)

PL/SQL, Developer 2000

Developer 6 [Forms 6/Graphics 6 / Reports 6]

SQL Plus, Server Manager, SQL*DBA, SQL*Loader, Import, Export

SQL*Net, Net8

Operating System:

HCL/HP-UNIX/Work-horse II/Magnum, SCO UNIX, Sun Solaris 8.x, Windows 2000, WinNT 4.0, Windows 95/98, Linux Red Hat 6.1, Novell Netware 3.x, VAX/VMS, AD/380 Graphic Workstation.

Jan’2000 – Dec’2000 System Analyst/Oracle cum UNIX System Administrator Miitech Inc., Atlanta

The scope of this project is to build a customer database and maintaining. The system is designed to hold all particular about customers. Client applications are developed under developer 6 to support data accessing and querying.

Primary Task Include:

Installed Oracle 8.x on Windows NT server-installed and configure 34 client systems for accessing the Oracle server- Maintaining Oracle Server monitoring space and performing backup – Creating users and controlling their access – Preparing SQL script for additional database creation – Installing Solaris 8 on Sun SPARC system – Configuring printer on Sun SPARC – Maintaining UNIX Server.

Oct’99 – Dec’99 Software Engineer Radiant Software

The scope of this project was to setup new servers and installing oracle software and maintaining the UNIX server - Maintaining the Oracle users.

Primary Task Include:

Installing Sun Solaris Unix / Intel Platform – Configuration NIS+ server – Installing Oracle 8 under Unix Environment – Maintaining the UNIX server – Maintaining the Oracle Server.

Radiant Software,

Project Role: Oracle DBA Oct’99 – Dec’99

The scope of this project was to setup new servers and installing oracle software and maintaining the UNIX server - Maintaining the Oracle users.

Primary Task Include:

Installing Sun Solaris Unix / Intel Platform – Configuration NIS+ server – Installing Oracle 8 under Unix Environment – Maintaining the UNIX server – Maintaining the Oracle Server.

Central Warehouse Corporation

India : Oracle DBA / Software Engg. Apr’97 – May’99

The scope of this project was to develop a new system to automat the on going transactions of Inland Container Depot and Air cargo Complex.

Primary Task Include:

System study and planning for computerization – Suggestion for hardware and software purchase – Installing and configuring Unix system – Analysis and design for new application – Installing application software under unix – writing shell scripts to perform administration activities – Troubleshooting and maintaining Unix System – Installing Oracle 7.3 under Unix and configuring – Managing the database resources through OEM – Guiding the development team to initialize data Model and to implement the physical design – Routine file system checkup, scheduling and maintaining backup devices – Planning and creation of users and groups – Creation Oracle users and granting controlled access to database resources.

Ttti

India: Programmer Analyst/ Oracle DBA (Development beginner) / UNIX admin (beginner) April’91 – May’97

UNIX

My responsibility was to maintain the existing unix system and oracle system and supporting for software development team in designing models, developing front end application which includes PL/SQL programming, PRO*C.

Primary Task Include:

Maintaining existing SCO Unix system – creating users and controlling their accounts – Adding new hard disk to update the system’s storage capacity – Developed shell scripts to perform all administrative tasks – Adding new printers in network and configuring – Maintaining tape device backup devices – Resolving users’ problem and system hang-up problems – Shutdown system property for cleaning space to reduce disk performance – Troubleshooting the Unix System from system failure – Planning storage device – Being a system administrator , checking file system resources frequently – Developed shell scripts to perform administrative tasks – Adding new printers in network and configuring – print job scheduling and managing – Extracting files from tape derive - Managing printing jobs at network – Installing peripheral devices Unix system in which oracle is running – Installing CD-Rom and other volume devices to access the unix file system – Reloading resources when required – writing SQL script for updating database – maintaining backup and made recovery whenever required – Migrating FoxPro data to Oracle data – System study and data modeling – Managing users and their resources – Scheduling monthly printout format using oracle report – Assisting in source code development for a Bank processing activities using Forms and report – Assisting in software logical and physical design – System design for Course management Information – Data/software Modeling and structuring tables – Guiding in developing application using SQL* form along with team – Integrated applications among users assigning permissions.

DOS

Developed / Involved in developing application software such as Hostel management (Oracle), ‘Payroll for NMR’ (Oracle), CBT Packages (Quest), ‘Stipend Processing’(Oracle), ‘Time table scheduling system’( C ) ,’Payroll’(FoxPro), ‘Branch Allocation’(COBOL),’Inventory Management System’(Dbase),’Question Bank’ ( COBOL).

Primary Task Includes:

System study and concept ional design – Writing and debugging source code – Created tables and populated old values – Designed forms to end user – Structuring report formats – System study and planning documentation – Structuring course materials for CBT – Writing PL/SQL code for appropriate triggers – Debugging and testing the developed application – Assisting in implementation – testing the software for sample data – Generating Random numbers for automatic allotment – Developing source code in database programming language – Writing and debugging dbase programs – Integrating modules by menu programs – User manual preparation – Maintaining HCL UNIX system – Administering backup and recovery – Creating users and maintaining backup – Maintaining printer jobs.

July’90 – May’91 Computer Lecturer Bharath Engineering College.

July’89 – May ’90 Computer Lecturer SRM Engineering College.

July’86 – May’87 programmer RAM Computer Division

My nature of work was to provide training to Computer Engineering Graduates and guiding their software projects and also involved in planning & purchasing new systems.

Primary Task Include:

Technical training to computer engineering Graduates – Handling Unix/OS, Oracle /SQL, Shell programming subjects – Model project guidance for graduate student projects – Maintaining Unix system proving accounts to users, maintaining backup devices, - Responsibility of Unix system shutdown and startup – Debugging C programs in Unix.

Dec’88 – May’90 Project trainee National Aeronautical Laboratory

I have developed a system software titled as “On screen menu creation for Graphic Processor workstation AD386” – Understanding the screen attributes by writing small programs – knowing the functions of each command of GS 1000 graphics package – writing programs using Quick Action procedure.

-----

Contact this candidate