We provide IT Staff Augmentation Services!

Techno/functional Consultant Resume

2.00/5 (Submit Your Rating)

Dallas, TX

SUMMARY

Technically competent in Oracle Applications 11i, Oracle PL/SQL Developer & D2K Reports, with 5 years of experience predominantly in OraApps, Oracle 9i database, Developing Reports using Reports6i. Currently working as an Oracle Applications Technical/Functional Consultant using Oracle 11i E Business suite at NYSE. Worked on Order Management, Receivables, Inventory, WIP, BOM, Pricing, Advanced Pricing,

TECHNICAL SKILL

Package : Oracle 11i E Business suite, 12i
Database : Oracle 8i/9i, 10g
Tools/ Scripts/ Forms : TOAD, D2K (Oracle Reports6i, 10g), XML Publisher, PL/SQL developer
Languages : SQL, PL/SQL
Operating System : DOS, WindowsXP, Linux/ UNIX
Version Control Tools : Visual Source safe 6.0 (VSS), Serena Change Man Version Manager (PVCS)

Oracle Application (Oracle 11i E Business suite) knowledge:

  • Order Management (Sales Order Creation, Defaulting Rules, Price List Creation)
  • Advance Pricing (Formulas, Modifiers, Qualifiers, Custom Pricing Context)
  • Oracle Receivables and Trade Management
  • Form customization using custom package library and Forms personalization
  • Oracle Report development & customization.
  • Sql Reports development & customization.
  • Registering concurrent requests set, concurrent requests, valuesets, flexfields
  • System administration (user creation, assigning responsibilities, request groups)

Oracle 10g/9i knowledge:
SQL, PL/SQL, Triggers, Cursors, procedures, functions, Packages, (Basics of Oracle Reports 6i,10g and XML Publisher)

PROFESSIONAL EXPRERIENCE

Confidential, Dallas, TX : Oracle R12 Implementation

Employer : Confidential,
Environment : Oracle Apps 12i
Duration : Mar ‘10 Till date
Type : Implementation
Role : Techno/Functional Consultant

Project Description :
Confidential, has their receivable accounts with legacy system. This project involves migration of the receivable accounting from Legacy system to Oracle R12 using Oracle Receivables, Trade Management and GL modules.
The implementation included:

  • Conversion of Customer using TCA Architecture
  • Custom Inbound and Outbound Interfaces

Responsibilities:

  • Building of Customer Interfaces both Inbound & Outbound
  • Functional setups for Oracle Receivables and Trade Management.
  • Handling QA and UAT Issues.

Confidential: OM Implementation (SAP Billing Migration to Oracle)

Employer : Confidential,
Environment : Oracle Apps (11.5.10.2)
Duration : Dec 2007 Feb 2010
Type : Implementation & Support
Role : Techno/Functional Consultant
Responsibilities : Development of functional and technical specifications, programming, documentation, testing, data migration.

Project Description
Confidential, is world largest and most liquid exchange group that offers most diverse array of financial products and services. NYSE has 8 different billing processes currently using SAP Sales and Distribution Module, which is to be migrated to Oracle Apps Order Management, Inventory, Advance Pricing modules and Vertex for tax calculation.

The implementation included:

  • Conversion of existing historical data like Invoices and Contracts from SAP
  • Building custom interfaces and conversions
  • Building custom reports for reporting
  • Designing the customer structure to meet the business requirement of NYSE
  • Customization of standard forms using forms personalization and processing constraints to meet the business requirement
  • Creating Custom Invoices using XML
  • Conversion of Customer, Item and Price List Master Data from SAP

Responsibilities:

  • Onsite Functional Lead to understand the business process, business requirement and documentation.
  • Developer: Building custom interfaces, sql and Oracle reports and conversions.
  • Functional Setups of Order Management Advance Pricing and Defaulting Rules
  • Cycle testing, review of Interfaces and reports
  • CRP with client and end users
  • Support and on time resolution of Issues in Month end billing.

Confidential,: Implementation of Quality Module and Support to Inventory, BOM, WIP Modules

Environment : Oracle Apps(12i)
Role : Techno/Functional Consultant
Duration : Aug05 Dec07
Type : Implementation & Support

Responsibilities:

  • Implementing Quality checks through system while performing Inventory, WIP transactions through Quality Module
  • Developing custom reports for PPM calculations.
  • User Training
  • Month end Support for performing Month end transactions through Inventory, WIP modules.

EDUCATION

Bachelors in Mechanical Engineering

ACHIEVEMENTS

Awarded Gold Medal for gaining First position in Mechanical Engineering

We'd love your feedback!