Summary
Overview
Work History
Education
Certification
Accomplishments
Timeline
Generic

Prasanna Kumar

Melbourne

Summary

Oracle Apps DBA with 5+ years in the software industry developing Applications, performing information security tasks and supporting Oracle EBS/Database instances. Highly experienced in Installation, Upgradation, Migration, Memory Management, System Maintenance, Cloning, Patching, User Support, TAR Management, Database Security, Troubleshooting Database Design, Documentation, Backup and Recovery and supporting Application Deployment.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Oracle Apps DBA

Helen Of Troy Limited
02.2015 - Current
  • Installed, upgraded and administered Oracle Applications (11i, R12.1.x, R12.2.x) and Oracle Databases (11g and 12c).
  • Provide day to day maintenance such as patch and tuning concurrent managers.
  • Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
  • installed and configured Oracle Recovery Manager (RMAN), Oracle Management Server, Data Gatherer, Oracle Enterprise Manager with Diagnostic Pack and Tuning Pack.
  • Migrated Oracle Business Intelligence from an AIX platform to Linux platform.
  • Created and managed the project plan for upgrading EBS from 11i/11g-multi-node RAC/ASM/SSL and integration with OAS and compatibility/upgrade of several third-party products into a single integrated solution for global operations.
  • setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
  • Recovered/restored multiple databases from physical disk failure. These include lost of datafiles/system tablespace/control files/on-line redo logs.
  • Application support for user creation, schema management, export and import of various schema using expdp and impdp oracle utilities.
  • Performance tuning using Enterprise Manager Grid Control, ADDM and AWR tuning advisor reports, Explain Plan, TKPROF, DBArtisan and Toad.
  • Provide documentation for best practices when upgrading, patching, cloning and installing Oracle Application and Database.

Information Security Analyst

Centripetal
03.2014 - 01.2015
  • Created customized Dashboard vulnerability scan reports for management using QlikView and SQL Server Reporting Services (SSRS). Developed SQL scripts on MS SQL server for report creation.
  • Checks the status of all scans executed during the prior week to ensure that scans are completing properly, that there are no errors, that the scans are successfully authenticating to the configured hosts and that scans are completing in a timely manner
  • Created environment-specific vulnerability ratings for RBS Americas Vulnerability Rating Forum (VRF)
  • Assisted in creating Dynamic Asset tagging in McAfee Vulnerability Manager in order to effectively automate host compliance, vulnerability and patch scanning.
  • Performed monthly database scans for RBS Americas region using the Scuba tool. Created KPI reports from scuba database scans.

Market Risk Production Support Analyst

Banner Engineering
07.2013 - 03.2014
  • Provide support cover for Risk Technology software and systems
  • Coordinate investigation and resolution of system issues including liaison with other system teams over late/incorrect feeds, database(Oracle, Ms SQL Server, Sybase) or hardware problems
  • Liaise with Risk Systems end-users as required to identify, analyze and resolve reported problems
  • Ensure systems are ready for business for different business locations
  • Set up test environments and run tests in conjunction with Risk Technology project managers and external system and user teams
  • Amend/update system configuration (e.g. new feeds, schedules, static data)
  • Participate in introduction into operation/hand over to support of new risk technology systems and developments

Web Developer

Brigham Young University
05.2012 - 12.2012
  • Implemented Drupal to update, modify and recreate web pages for Brigham Young University admission department website
  • Created customized Drupal modules and themes
  • Created several web pages using PHP, JavaScript, CSS and MySQL

Education

Bachelor of Science - Information Technology

Brigham Young University
Provo, UT
2013

Certificate - Accounting

LDS Business College
Salt Lake City, UT
2009

Associate of Science - Accounting

University of Ghana
Accra, Greater Accra Region
2004

Certification

  • Oracle Linux Implementation Specialist Certified
  • Oracle Certified Associate (OCA 11g)

Accomplishments

    Service to the Court Award

    Utah State Court

    September 2013

    Evaluated requirements, developed and installed a web based Learning Management System built with node.js that allows the Utah State Court to manage lessons built using Adobe Captivate and accurately track employee progress. Since release it has been in use continuously and has expanded from approximately 1,000 employees to nearly 1,400.

Timeline

Oracle Apps DBA

Helen Of Troy Limited
02.2015 - Current

Information Security Analyst

Centripetal
03.2014 - 01.2015

Market Risk Production Support Analyst

Banner Engineering
07.2013 - 03.2014

Web Developer

Brigham Young University
05.2012 - 12.2012

Bachelor of Science - Information Technology

Brigham Young University

Certificate - Accounting

LDS Business College

Associate of Science - Accounting

University of Ghana

Similar Profiles

CREATE PROFILE
Prasanna Kumar