We provide IT Staff Augmentation Services!

Technical Consultant Resume

New Jersy, NJ

Summary:

  • Around 2.8 years of experience in Information Technology industry in the software development with SQL, Oracle, Oracle Apps.
  • Oracle Techno - Functional Experience in E-Business Suite.
  • Experience in making of all Reports (XML, RDF) using Report Builder, Interface, Conversion, Workflow and dynamic SQL Query
  • Sound knowledge in creating of view, writing database trigger, stored packages, cursors, sequences, procedures, function, error handling, collections, objects and records.
  • An organized, hardworking, and highly motivated professional, with strong communication and interpersonal skills, and the ability to perform individually or as a dedicated team member.
  • Knowledge of end to end cycles of P2P and O2C.

TECHNICAL EXPERTISE:

  • Oracle Application R12 up-gradation/Implémentations.
  • Tools & GUI.
  • Oracle Reports 6i, SQL Developer, XML Publisher, TOAD.
  • Oracle 9i/10g/11g, SQL, PL/SQL, C, C++.

WORK Experience:
1.6 year working experience as Technical Consultant and 1.2 year as Techno-Functional Consultant.
Confidential,India
Sept. 2011 –till date
Primary Modules (AOL, PO, AR, AP and FA)
Secondary Modules (CM, INV, OM and GL)
Skill Used: Oracle Apps Modules (AOL, PO, AP, AR, CM, GL, FA).
Version: Oracle Application 12.0.6, Oracle 11g.
Platform: Oracle Sparc Solaris.
Role in project:

    • Help desk management, Query analysis and resolution.
    • Working on PL/SQL stored procedure, function, Trigger, cursors and Dynamic SQL.
    • Working on Payables invoice interface (data migration from legacy to Oracle Apps.) through interface table.
    • Working on Key Flex Fields, Descriptive Flex Fields and registration of value sets.
    • Working on resolving problems with Procure to Pay and Order to Cash cycle.
    • Working on challenging aging Reports (RDF & XML).
    • Have knowledge of Oracle Standard API, SQL, PL/SQL.Toad.
    • Have knowledge of Registration Reports through back end.
    • Worked in resolving problems with Oracle GL,AR interface related issues, help transfer data from subledger account to GL, setup related issues, Payable transactions hold related issues etc.
    • Created and supported oracle service requests for oracle bugs in R12, Providing APlist for problematic invoices, trace files and log files for the steps involved and version details as requested for the SR
    • Techno Functional support for Oracle Financials modules.
    • The responsibilities include understanding functional requirement, development of detail level technical design documents, and preparation of code.
    • Gather user requirements for customization, reports and changes to existing functionality and make Recommendations as to the same.
    • Have knowledge of Approval hierarchy of purchasing.
    • Rectifying malfunctions, setup modifications, Troubleshooting & Roll Outs.
    • Well versed with finalization of As Is & To Be Processes as per Business Requirements, carrying out end-to-end testing of application, testing for CRF and UAT with business users, user training, month-end processes, providing end-to-end and production support.
    • Understanding of Oracle Subledger Accounting, Accounting setup manager, Flexfields.
    • Provide all the required information like Functional setup, Process flow, control related information to our External auditors.
    • Provide training to end users as monthly basis and take feedback and understand their needs and fulfill their requirements.

Confidential,Noida, India.
Dec. 2010 –Aug.2011

  • Worked for various clients
  • Worked on various projects
  • Confidential,GurgaonJune 2011-Aug.2011

Skill Used: Oracle Apps Technical Modules (PO, AP, AR, GL).
Version: Oracle Application 11.5.10.2, Oracle 10g.
Role in project:

    • Worked on XML report of inv. module.
    • Worked on Invoice detail report as debit and credit wish.
    • Worked on HRMS interface and data migration from legacy to Ebsuit.

Confidential,Dec.2010-June 2011
Skill Used: Oracle Apps Technical Modules (PO, AP, AR, GL).
Version: Oracle Application 11.5.10, Oracle 10g.
Role in project:

    • Worked on Key Flex Fields and Descriptive Flex Fields.
    • Creating a Folder on UNIX server by Concurrent Program.
    • Worked in Oracle PL/SQL and Oracle Reports.
    • Worked on PL/SQL stored procedure and function, Trigger, cursors, Dynamic SQL.
    • Worked on making oracle reports based upon rdf (customize).
    • Worked on registration of value sets.
    • Worked on Registration Reports through back end.
    • Worked on Oracle Standard API, SQL, PL/SQL.Toad.
    • Worked on XML Publisher.
    • Worked on challenging aging Reports.

Confidential,Noida, India.
Feb 2010 to Sep.2010
Project: Oracle APEX-Issue Tracker and Report Developer.
Version: 11.5.10
Role in project:

    • Worked on Oracle PL/SQL and Oracle Reports.
    • Worked on PL/SQL stored procedure and function, Trigger, cursors, Dynamic SQL.
    • Worked on making oracle reports based upon rdf and xml publisher (new and customize).
    • Worked on registration of value sets. (Table Type, Independent, Dependent.)
    • Worked on registration of executables, concurrent programs. (plsql type/reports/sql loader)
    • Worked on creation of form function, menu etc to register a .fmb forms.
    • Having good exposure to working with query developer tool like SQL Builder and Toad.
    • Worked on APIs for registering concurrent programs, value sets, executable and attaching the concurrent program to request Group

EDUCATIONAL PROFILE:

B.E. in Computer Science

Hire Now