We provide IT Staff Augmentation Services!

Oracle Dba Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • 11+ years of Hands - on Functional Experience including over 3+ years of Leadership and Management Experience
  • 4+ years of Audit Domain Experience on Tax Audit, Statutory Audit & Internal Audit
  • Comprehensive knowledge of SDLC (System Development Life Cycle), Agile Programming practices and Implementation Road Maps
  • Strong understanding of Business Fundamentals including almost all Organizational Functional Areas
  • Demonstrated ability in effectively translating Business Requirements into Input for Technical & Testing teams
  • Lead requirements gathering Meetings
  • Ability to work well with ambiguities calling for the need to creatively address Business Problems and Challenges
  • Demonstrated ability in managing Large Complex Projects from End-to-End
  • Good working knowledge of SOA (Service Oriented Architecture)
  • Knowledge of usability processes, Best Practice Adoption, Standards Compliance and Enterprise-Wide Application Integration
  • Excellent Written, Communication and Group Development Skills
  • Experience interacting and driving internal product teams, the user community, IT Operations and Executives; Experience with Functional Teams with a Strong focus on Group dynamics
  • Experience with round-trip business methods using Function-point and Use Case estimation methods using well-defined workflow (Project and Initiatives proposal presentation techniques)
  • Possess Excellent Analytical Skills, Quick learner, coming up to speed on Functional issues

TECHNICAL SKILLS:

  • Oracle EBS 11i & R12 Functional on AP, AR, GL, CM, OM, AR & FA, iExp & iProc
  • Oracle iSetup
  • Project Management / Team Lead
  • Client Management
  • Business Process Design / Re: design
  • Project Budgeting and Planning
  • Project Risk and Scope
  • End User
  • Management of Offshore & Onsite Resources

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

  • Leading and Managing and Supporting 11.5.10 Oracle Financial Modules on GL, FA & OM
  • Interact directly with business users to assess Incident, Break Fix, Enhancements
  • Prepare Functional Design document and Estimate Development & Migration time
  • Co-ordination with Offshore Technical Team
  • Feedback on Incident Review Meetings
  • Client Interactions and Meetings on Status Reporting and Enhancement Request
  • Offshore Functional Team Management on Incidents, Break Fix & Change Request
  • Supporting Offshore Testing Team on development of Test Scripts for Test Execution
  • Meeting of business requirements on upgrade to Release 12

Confidential

Responsibilities:

  • Enabled Automated Defaulting of customer and item information on the sales orders, which helped the customer to reduce manual data entry problem and improving productivity during sales order and RMA creation.
  • Implemented Firm/ Un-firm feature to prevent sales order delivery lines changes.
  • Enabled manual and automatic Delivery creation to group multiple sales order lines onto a single delivery.
  • Enabled partial order fulfillment through Split lines feature. This was done by splitting single Delivery into multiple lines, thereby shipping the order partially.
  • Provided a solution to support shortage of items on a delivery and complete the Trip, by un-assigning delivery from the Trip.
  • Provided a solution to fulfill the customer orders by shipping the items from the supplier directly to the customer, through the Drop Ship Process, eliminating the inventory management costs with no upfront inventory and ensuring positive cash flow.
  • Implemented feature based Order Configurator process that enables order processing of CTO (Configure to Order) and ATO (Assemble to Order) type of products including the manufacturing of the configured products.
  • Implemented Vendor Managed Inventory (VMI) where the suppliers are responsible for replenishing the stocks by monitoring the stock levels.
  • Defined pick slip grouping rules based on varied grouping criteria to allow smooth picking process.
  • Defined release sequence rules to specify the release criteria based on order number, outstanding invoice value, scheduled date departure date and shipment priority.
  • Enabled automatic or manual attachments of documents on sales orders and returns to capture important information.
  • Increased the order fulfillment and revenue using product substitution process at the time of order entry.
  • Defined Customer items and cross s to link the customer items with inventory organization.
  • Increased the inventory accuracy by implementing Physical Count which resulted in bridging the discrepancies between system and actual quantity periodically. This also helped in reporting and closing the financial statements at the month and year end.
  • Provided lot and serial transaction controls for the items during all receiving, manufacturing and shipping transactions.

Confidential

Responsibilities:

  • Analyzed the business requirements and provided the fit GAP analysis
  • Prepared As-Is, To-Be process flows documentation using AIM Methodology.
  • Enabled upsell / cross sell and substitute items by defining items relationships in oracle inventory for the increase in revenue through fast order fulfillment.
  • Defined payment terms and also Implemented a solution to apply Holds on multiple entities.
  • Defined Processing constraints according to business process and prevented certain unwanted changes by validating the changes against the processing constraint enabled.
  • Implemented Defaulting rules by defining defaulting condition templates and defaulting rules based on sales order attributes. This reduces the amount of information that must be entered manually on Sales Order form.
  • Implemented Retro-Billing Process which helped in changing the amounts on already invoiced orders on customer request.
  • Implemented freight cost charging to sales order during shipping process.
  • Defined shipment transit times by setting up the relationship between organizations by specifying the Ship Method and other associated parameters for the inter location movement of the goods.
  • Enabled partial order fulfillment through split lines feature. This was done by splitting single delivery into multiple lines, thereby shipping the order partially.
  • Implemented Shipping Process enabling Auto Create Deliveries and Trips.
  • According to Business needs, enabled Surcharges to a particular order type which helped in defaulting surcharge price on to the sales order.
  • Implemented pricing modifications based on coupon with help of modifiers on sales orders during order processing.
  • Implemented Item upgrade modifiers by defining the relationship between items and Upgraded items in Inventory.
  • Implemented multiple BOM’s, component substitution, alternate operations lead time inquiry, and BOM comparison to improve the manufacturing process and to identify the discrepancies.
  • Implemented alternate routings, copy routing and common routing for the manufacturing process.
  • Automated processes for count points, back flushing, floor stock replenishment, over completions and resource charging.
  • Used the common bills concept for the maintenance of the BOMs for the common products across organizations.
  • Enhanced the Work in Process productivity through the creation of standard documents and attaching them to the discrete jobs which provided as SOP for shop floor assembly operation resources
  • Automated standard discrete job creation process in the organization by auto creating discrete Jobs, based on the sales order scheduling in a CTO environment.
  • Implemented Material Work Bench to perform material transactions like mass move, mass issue in order to issue or move the material to the selected location.
  • Effectively utilized closed loop system to define outside processing resource requirements, automatically generate requisitions for outside processed assembly items, receive the items back into inventory and update the WIP job.
  • Provided a solution for adding and updating material requirements to discrete jobs with the appropriate job statuses.
  • Enabled serial number tracking for standard and non-standard discrete jobs. This enabled to assign and associate serial numbers to a job, and track the assembly by serial number as it progresses on the shop floor.
  • Prepared MD50 and MD70 documents.
  • Conducted CRP, SIT and UAT testing.

Confidential

Responsibilities:

  • Define Accounts Receivables related setups. Data migration from the legacy.
  • Define Functional specification for custom changes on forms and reports and sign off with cross-functional team.
  • Identify and work with development for the modifications as per the Functional Specification.
  • Drive Business Process flows for Test Cycles and Pre-Production run.
  • Create and Update Project Business Process Flows and Material.
  • Drive Business Process flows for Test Cycles and Pre-Production run.
  • Extensive 24x 7 Support during GO Live and a year’s support after go-live.

Confidential

Responsibilities:

  • Identification of the Entities and their hierarchy in the Organization.
  • Master Data Setup with interacting with the User Champs and established the standardization of it.
  • Coordination with the Finance Dept. And the Corporate for establishing the Charts of Account and their rollups
  • Written a user-friendly interface for migrating the data from old existing system to the ERP to make it operational in accordance with implementation plan
  • Coordination of the program for end user to get them acquainted in new System
  • Explanation of the functionality of the Finance module and it's dependence and integration to other modules of ERP through slides and transparency .to management
  • Customization of the ERP Package and incorporating the changes in it Database Administration in Oracle & DB2 Database
  • Involved in the System study
  • Involve in Logical and Physical Design of database
  • Involved in Space management, User creation, performance and database tuning, Establishing secured backup procedure, maintaining and ensuring the validity of various data base objects so that ERP run smoothly and trouble free in the environment
  • Involved in Performance tuning and Setup of database and Performed database setup
  • Involved in server tuning and security setup
  • Performed backup, recovery and troubleshooting
  • Involved in analysis and low level designing of modules
  • Performed configuration management

We'd love your feedback!