Oracle Applications DBA
Resume:
Professional Summary
Over ** Years of IT experience serving as Senior Oracle Application and Oracle DBA for Oracle Database and Applications. Capable of handling any complex environments and architectures, enforcing good strategies to comply with industry’s latest compliances to make sure the database and applications are secure, experience in implementing Oracle products and suites on different flavors of OS and H/W in development, production and manufacturing domains. Good work ethics, communication, strong team player, very good technical writer.
My strengths are in better and smart leadership, good decision making, proper technical guidance and work closely with team and leaders in future technology development and consultations, work with new technology implementation and integration of various emerging technologies, project/resource planning and management co-ordination, within IT operations framework. High caliber to build, lead and manage a team of IT professionals in designing and implementing software products and services that completely meet the customer/end-user requirements and exceed their expectations consistently in new and innovative ways.
TECHNICAL PROFILE
RDBMS: Oracle Database Standard and Enterprise 10g/9i/8i, SQL Server 2000
Database Skill sets: Database performance tuning, Tools performance tuning, troubleshooting, diagnosis of errors and actions, RAC, RMAN, Backup & Recovery, Performance Tuning, Oracle Apps / DB Security, Patching, Cloning, appworx, Migrations, Unix Shell Scripting, Cron jobs, Oracle Enterprise Manager (OEM, 10g Grid Control) configuration, Datamigrator, tkprof, statspack, PL/SQL, SQL, Toad, Perl, Shell Scripts.
Oracle Application:
Oracle Applications E–Business Suite R12, 11.5.7/11.5.9/11.5.10.2 (11i), 11.0.3, Oracle Applications System Administration, Oracle User management Support (Role Based Access Control), 9iAS, iAS 1.0.2.2, 10giAS, PL/SQL, Oracle Developer suite 6i/10g(Forms & Reports), Oracle Discoverer, Discoverer Viewer, Discoverer plus (Datawarehousing). CRM.
Oracle Applications Modules:
Oracle Financials: (AOL, GL, AP, AR, FA, Cash Management, expenses. ADI/GLDI
Oracle Manufacturing (INV, OE, OM, PO, OSM, BOM, MRP, WIP, eMail Center, SSP5).
Oracle HRMS (Payroll, OTA, Advanced Benefits, Workflow, Framework, I-procurement)
Oracle Supply Chain Management Solution (SCM) (Supplier scheduling, iSupplier Portal, iProcurement, Advanced Supplied Chain Planning, Inventory optimization, Order Management, WMS, Engineering etc.
Compliance and Integration technologies:
Sarbanes-Oxley (SOX), SOA, Concurrent Versions System (CVS) and PVCS integration.
Tools:
Putty, Veritas Net Backup 4.5, SAN, Netapp, Sitescope, Noetix, Primavera, Barcode Tools, Formscape, Umero, Fax Util, Plum Tree Portal, Oracle Portal, Collaboration Server, Tomcat, Job Server, Business Objects, Rational Rose, Java Applications Server, Java J2EE, SSO, Web intelligence etc.,Tarentella, Concurrent Versions System & PVCS , Razor, Share point, Kintana, Vmware, SQL*Loader, Oracle Developer Suite 10g/6i/2000, Visual Basic, Cobol, Fortran, Pascal, Foxpro&C.
Operating Systems:
IBM/AIX 5L, HP UNIX 11.11, Sun Solaris8, Red Hat Linux 2.1 & 3.0, Compaq (HP) Tru64 Digital UNIX 5.1, Red Hat Linux 2.1 & 3.0, Windows Server 2003, Win2k, Windows XP
Hardware:
IBM 9117-570, HP RP7400, HP RP5470, Sun Enterprise E4500 server, Sun E420R server, Sun E220R server, Compaq DS20, Compaq ES40, Compaq Proliant 3000, Compaq DL380, Dell 2650.
PROFESSIONAL EXPERIENCE
(www.dataintensity.com) Sr. Oracle Applications DBA
(Bedford, MA) Jun’08 – Current
Managed responsibilities:
• Multi customers support environment with high volume of database management.
• SOA model architecture and support hi-caliber customers.
• Data warehousing support.
• 9.2.0.6 to 9.2.0.8 Database Upgrade.
• HRMS upgrade and Year end patches.
• Noetix implementation.
• 10g Database upgrade from 10.2.0.2 to 10.2.0.4.0
• Multi node RAC environment.
• Implementation of iexpenses module.
• Backup and Recovery using RMAN.
• Leading small DBA team.
• Co-ordination with offshore team.
• Fixing bugs, Trouble shooting and fixing problems.
• Technical support to the developing and functional teams.
• Provided production & test environment support, Cloning.
• E-Business Suite System Administration support.
• Control practice, Changing procedures & Implementation. Auditing user’s activity in sharepoint.
• Administering and reviewing logs. Escalate issues to management as appropriate.
Environment:
Oracle RDBMS- 10.2.0.4.0, Oracle Apps - 11.5.10.2, RAC, Linux, Solaris , Modules (GL, AP, AR, OM, HRMS, SOA) iAS - 1.0.2.2 rollup 4, Oracle Jinitiator - 1.3.1.21.
(www.brooks.com) Sr. Oracle Applications DBA
(Chelmsford, MA) Jan’08 – May’08
Managed responsibilities:
• Implementation of Oracle Applications 11.5.10.2 with 10.2.0.3.0 Database.
• Configuring Oracle Grid for managing different databases.
• Migrating design, architecture and data to Oracle Applications from Glovia
• Implementing Oracle user management (RBAC) & Data warehousing.
• Implementing Applications Security for SOX compliance.
• Generated SOX Compliance reports for Auditors.
• Involved in Cloning, DB & Apps Production & Test Environment Support, UAT.
• Multi architecture, multi node RAC environment.
Environment:
Oracle DB –10.2.0.3.0, Oracle Apps - 11.5.10.2, RAC, IBM/AIX 5L, Modules (GL,AP,AR,CE, Services (CRM)) iAS - 1.0.2.2 rollup 4, Oracle Jinitiator - 1.3.1.21.
(www.fidelity.com ) Sr. Oracle Applications DBA
(Merrimack, NH) Oct 06 – Dec’07
Managed responsibilities:
• Upgraded Oracle Database from 9.2.0.5 to 9.2.0.8
• Upgraded Oracle Applications from FND to RUP1 (ATG).
• Upgraded Oracle Applications to HRMS Family Pack K.
• Applied Legislative & hrglobal patches.
• Applied Daylight Savings Patches,
• Migrating configuration data from Non prod environment to Production Environment.
• Involved in Cloning, Support. UAT.
• Performing the Tech window along with Off shore team.
• Multi Architecture environment
• Multi Client Environment.
Environment:
Oracle DB – 9.2.0.8, Oracle Apps - 11.5.9/11.5.10.2, IBM/AIX 5L, Modules (OAB, Payroll, HRMS, GL, AP, AR), iAS - 1.0.2.2 rollup 4, Oracle Jinitiator - 1.3.1.21.
(www.shopnbc.com) Sr. Oracle Applications DBA
(Minnesota, MN) Mar 06 – Sep’06
Managed responsibilities:
• Upgraded Oracle Database from 8i(8.1.7.2) to 9i(9.2.0.6)
• Upgraded Oracle Applications from 11.5.5 to 11.5.9.
• Configured Oracle Discoverer 4.1.48 for Data warehousing.
• Involved in Cloning, Support, UAT.
• Applying different Database & Application patches as per the requirements.
• Performance Tuning of Database and Oracle Applications.
• Support of backup and recovery procedures
Environment:
Oracle DB – 9.2.0.6, Oracle Apps - 11.5.9, IBM/AIX 5L, Modules (FA, MSC, MRP, AR, GL, PO, INV, OM, BOM, CE, eMail-Center), iAS - 1.0.2.2 rollup 4, Oracle Jinitiator - 1.3.1.18.
(www.overstock.com) Sr. Oracle Applications DBA
(Salt lake City, UT) Sep 05 – Feb’06
Managed Responsibilities:
• Upgraded Oracle Applications from 11.5.10 (CU1) to 11.5.10 (CU2).
• Involved in Cloning, Support , testing interfaces.
• Applying different patches as per the requirements.
• Performance Tuning of Concurrent Manager and Database.
• Parallel Concurrent Processing, SHARED_APPLTOP
• Configured Evergreen Signature Printing from Oracle Apps.
• Implement Oracle Financials Run Book for the client.
• Generated SOX Compliance reports for Auditors.
• Carried out all the R11i Application system Administrator activities.
• Shell Scripts, Fixing Bugs, Trouble shooting and fixing problems.
• Redesigned, modified backup and recovery procedures.
• Oracle Apps / DB Security, Access Control, Audit Reports, Following SDLC, Monitoring, Troubleshooting. Change
Environment:
Oracle DB – 9.2.0.5, Oracle Apps - 11.5.10.1, IBM/AIX 5L, Modules (iProcuruement, iSupplier, CE, FA, GL, AP, INV, WMS, PO, Supplier Scheduling, OM), iAS - 1.0.2.2, Oracle Jinitiator - 1.3.1.18.
(www.miamiherald.com) Oracle Applications DBA
(Miami, FL) Apr 05 – Aug 05
Responsibilities:
• Involved in various tasks consists of Cloning, Support, testing, executing post task of oracle DB & Oracle Apps after HP UNIX OS upgrade.
• Loading monthly Vertex Sales Tax & Geo code information.
• Scheduling jobs using appworx.
• Applying different patches as per the requirements.
• Carried out all the R11i Application system Administrator activities.
• Implement re-vamps of coding and documentation standards.
• Worked with Client’s Application Development team to prepare project rollout plan.
• Shell Scripts, Fixing Bugs, Trouble shooting and fixing problems.
• Design, implementation and support of backup and recovery procedures.
• Oracle Apps / DB Security, Access Control, Audit Reports, Following SDLC, Monitoring, Performance Tuning & Troubleshooting. Change Control Practice, Changing Procedures & Implementation.Auditing User’s Activity.
Environment:
Oracle DB – 8.1.7.4.0, Oracle Apps - 11.5.7, HP Unix - 11.11, Modules (GL, AP, INV, FA, PO, iProcurement), iAS - 1.0.2.2, AppWorx - For scheduling the jobs,
Vertex Q Series load, razor - Control Versioning system for SOX, Oracle Jinitiator 1.1.8.16
Mindef (Ministry of Defense), Singapore Oracle ERP DBA
(www.mindef.gov.sg) Oct’04 – Jan’05
Responsibilities:
• Upgraded HRMS, Payroll & OTA modules.
• Upgraded 9iAS 1.0.2.2 and Apache from 1.3.12 to 1.3.19.
• Upgraded Oracle Frame Work to 5.7H, Workflow to 2.6.
• Applied Legislative, Core Patches for the above modules.
• Cloning to Testing Environment.
• Prepared an upgrade plan and submitted to the Project manager.
• Led a team of 6 people which includes technical and functional analysts.
• Oracle Database Support & Oracle Applications support.
• Involved with user teams to do the UAT in Test env. before move to Production env.
• Provided the status reporting to the Project Manager.
• Design, implementation and support of backup and recovery procedures.
• Configure and implement backup procedure using Veritas NetBackup – Installed Veritas Business Server to a host machine with attached autoloader tape library. Installed NetBackup clients on 4 remote machines to be able to backup data from remote servers. Installed NetBackup database agent for Oracle to use Oracle Recovery Manager (RMAN) to backup databases. Plan and created backup schedules.
• Oracle Apps / DB Security, Access Control, Audit Reports, Following SDLC [Software Development Life Cycle Method]
Environment: Oracle Applications 11.5.8 includes HRMS, OTA & Payroll modules, Oracle RDBMS 8.1.7.4.2, Oracle Jinitiator 1.1.8.22. Sun Solaris 8.
(www.charteredsemi.com) Oracle Applications DBA
(Woodlands, Singapore) Apr’99 – Sep’04
Responsibilities:
Implementation of SCORE Project (Supply Chain Optimization Responsiveness Engineering)
Oracle Applications 11.0.3 , Modules AP, GL AR, FA, Cash Management, OE, INV, OSM, PO, BOM, MRP, WMS, SSP5, Project Managemnt Tool – Primavera to all the Information Technology Departments to schedule their project, cost, time activity and the status and Barcode System for Logistics Deptartments like Shipping & Stores for printing barcoded labels.
• Installation, Implementation Oracle Applications 11.0.3.
• Installation of Oracle Webserver, concurrent manager, Form Server, Report Server
• Developer 2.1, Forms 4.5, Reports 2.5, Oracle Discoverer 4.1.37
• Oracle Application Desktop Integrator (ADI/GLDI) 7.1.17,
• Oracle Jdeveloper & Oracle Clients and managing concurrent managers
• Managing different type of customizations, code migrations and trouble shooting.
• Managing Custom tables, Procedures, Packages, Triggers, Alerts & Functions.
• Scheduling Cronjobs & Shell Scripts, Fixing Bugs, Trouble shooting and fixing problems.
• Involved with user teams to do the UAT in Test env. Before move to Production env.
• Carried out all the Application system Administrator activities including backups.
• Applying Patches, Cloning, Monitoring, Troubleshooting and Apps DBA Support.
• Access Control, Audit Reports, Following SDLC, Monitoring, Performance Tuning & Troubleshooting. Change Control Practice, Changing Procedures & Implementation. Auditing User’s Activity.
• Prepared implementation and rollout plan and submitted to the management team
• Installation of Windows 2000 Server, Oracle 8I Database.
• Installing and upgrading Primavera Enterprise Manager, Primavision, IIS.
• Managing projects, users and assigning different roles, privileges and responsibilities.
• Generating different reports to the Management Team
• Implementing Barcode project includes installation of Bar Tender, Seagull Server, configuring Barcode printer(Zebra printers) and drivers and fetching data from Oracle applications to print the barcode labels.
• Scheduling FTP job to collect the data from Oracle ERP and converting as a label format and printing to Barcode Printer.
• Training users to handle the application.
Implementation of Portal Tools for viewing data warehouse data via dashboard
• Led a team of 15 people which includes technical analysts and developers.
• Installation Oracle 8I Database
• Installing Apache,Installing Plumtree Component and Colabaration Server.
• Installing Job Server & Studio Server.
• Implementation of CVS for Sarbanes-Oxley compliance.
• Prepared and submitted project plan and UAT plan to the Datawarehousing team.
• Provided the status reporting to the Project Manager.
• Installing Tomcat, Installing Business Objects and Rational Rose.
• Installing Webintelligence, Broadcast Agent, Broadcast publisher.
• Configuring the above tools accordingly for the datawarehouse project.
• Design, implementation and support of backup and recovery procedures.
• Involved with user teams to do the UAT in Test env. before move to Production env
• Monitoring, Performance Tuning & Trouble Shooting and configuring all the above tools accordingly.
E-Form (Paperless project from E-Business Suite)
E-Form – Implementation E-Form for Customers, Vendors & Suppliers to send the datas from Oracle ERP like Invoices, Purchase orders & Order Entry details via Fax, E-mail & Printers.
• Installation of Windows 2000 Server
• Installation of SQL Server 2000
• Installation of SQL Database
• Installation of Formscape, Umero, Fax Util & Rightfax.
• Installation of Tomcat & Xserve[For Resubmission Process]
• Installing Printer and drivers
• Scheduling FTP job to collect the data from Oracle ERP to Umero.
• Converting XML to PDF/TIF format using Wind2PDF
• Installing Fax [Brooktrout] & SMS Card
• Configuring the above tools accordingly.
Environment: Microsoft SQL Server 2000, Formscape, Umero, Fax Util, Right Fax, Tomcat & Wind2PDF, Windows 2000 Server.
Computer Software College, Chennai, India. Programmer Analyst
Dec 97 to Jan 99
Projects developed and involved are Supermarket Automation System, Ledger Processing System.
Environment: Oracle 7.1 & Forms 4.5, SQL Report 2.5, Windows ’95.
Larsen & Toubro Limited, Bangalore, India. Programmer
Aug 95 to Nov 97
Projects Developed and implemented are Sub contractor's Billing System, Cash Bank Accounting System, Time Office System, and Financial Accounting System.
Environment: Oracle 7.1 & Forms 4.5, SQL Report 2.5, Windows ’95.
EDUCATION & TRAINING
• Bachelor of Science (Physics) Bharathidasan University , India.
• Post Graduate Diploma in Computer Science & Applications - India.
• Diploma in Applications System Administration R11 – Oracle Corporation Education Service – Singapore.
• Oracle 9i DBA Fundamentals I –Oracle Corporation, Singapore.
• Primavera Training including Admin & End User Training – CROWN Systems Singapore.
• Business Objects, Web-intelligence & Plumtree Admin & Implementation Training.
• E-form Implementation & Administration Training – Fuji Xerox Singapore Pte Ltd
• Hp Unix Training – HP Pte. Ltd – Singapore
• Oracle Applications R12 Installation & Upgradation Training – www.onlineappsdba.com - USA
Reference: Available upon request.
Contact this candidate