We provide IT Staff Augmentation Services!

Technical Consultant Resume

NY

SUMMARY

  • 7+ years of experience in working with IT industry, working as Oracle Applications Technical Consultant.
  • Working as technical consultant in oracle application modules OM, AR, PO, AP, INV, GL etc., (O2C and P2P cycles).
  • Worked on Application Object Library (AOL) objects.
  • Worked on R.I.C.E. components with Oracle Applications and is well versed with RDBMS
  • Strong skills in Oracle SQL, PL/SQL, SQL* Loader, Reports.
  • Skilled in Oracle Interfaces, Custom.pll, Forms Personalization.
  • Worked with Forms, Oracle API’s, XML Publisher.
  • Knowledge in UNIX Shell Scripts, XML and Java.
  • Exposure to R12 architecture and concepts.
  • Worked with Tools Toad, SQL Developer, Star Team, TTMS, Eclipse etc.,
  • Work Experience in articulating design and development concepts in technical specification documents (MD050, MD070, MD120), and Test script documents (TE020, TE040) using AIM Methodology.
  • Involved in Functional Design and System Integration Testing (SIT).

TECHNICAL SKILLS

ERP: Oracle Applications 11.5.10.2

Modules: OM, AR, PO, AP, INV, GL

Databases: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

Languages: SQL, PL/SQL, C, JAVA

Tools: TOAD, SQL*PLUS, SQL*Loader

GUI Tools: Oracle Reports and Forms

Operating Systems: Windows, UNIX, MS - DOS, SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, NY

Technical Consultant

Responsibilities:

  • Support work for technical queries/tickets.
  • Handling SCM/FIN track tickets
  • Responsible to handle Support of RICE components
  • Responsible for to create new or enhancements of RICE components
  • Defining Executable, Concurrent Programs and Value Sets.
  • Development of custom Oracle Application Reports.
  • Customization of Oracle Application Standard Reports
  • Developed SQL*Loader control file for loading data from data files to Staging tables.
  • Registering the PL/SQL procedures, control files, Reports, Shell Script as concurrent Programs.
  • Worked on various aspects of AOL setups.
  • Created PL/SQL Packages, Procedures, Functions as per the requirement.
  • Worked on Order import interface and other Interfaces.
  • Modified Standard reports like AR Invoice Report.
  • Created custom GL consolidation report.
  • Enabling or enhancing DFF’s for Order Header, Order Line, Shipment, Customer ‘s screen etc
  • Custom.pll validation for BOM component deletion.
  • Folder manipulation for in Order Entry Screen
  • Adhoc Scripts for order flow (Cancellation, Clear Reservations, Close Order etc.,)

Environment: Oracle Apps 11.5.10, TOAD, Star Team, TTMS, Java, BHUB etc.

Confidential, Silver spring, MD

Technical Consultant

Responsibilities:

  • Successfully created and debugged many PL/SQL Procedures, Functions and Packages for the application.
  • Responsible for creation of new reports
  • Worked on Form Personalization
  • Worked with Invoice interface, Customer interface etc
  • Responsible for technical documentation
  • Involved in unit testing
  • Created Table dependent value sets
  • Created Custom Profiles
  • Developed SQL Loader Control files for Inbound Interfaces
  • Registering the PL/SQL procedures, control files, Reports, Shell Script as concurrent Programs
  • Worked on various aspects of AOL setups

Environment: Oracle Apps 11.5.10, TOAD, Star Team, TTMS, Java, etc..

Confidential, Minneapolis, MN

Techno Consultant

Responsibilities:

  • OM Interfaces and standard order import program.
  • Receiving using 3rd party.CSV files and parsing them to staging tables.
  • Account Alias issue / Account Alias Receipt created using inventory transaction interface and mtl transaction interface tables. rdf reporting for processed/failed records
  • Mass cancellation program using OE ORDER PUB.
  • Designed Lookups to use the same program for multiple 3rd party order types.
  • Technical documentation for deliveries.
  • Created PL/SQL Packages, Procedures, Functions as per the requirement
  • Worked on various aspects of AOL setups.

Environment: Oracle Apps 11.5.9,OM,INV,PLSQL, XML Java Servlet, TOAD

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

  • Documentation - Technical documentation except pricing component.
  • Materialized views for order, shipment and product logical layers.
  • Involved in the project designing with DI team.
  • Involved with operations team to reduce performance issues.
  • Participated in design of SAL with architects.
  • Used Dynamic SQL to form sql statements to create materialized views.

Environment: PLSQL, TOAD, UNIX, SQL Plus

Confidential

PL/SQL Developer

Responsibilities:

  • Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader
  • Written database Triggers, Stored Procedures using PL/SQL
  • Successfully created and debugged many PL/SQL Procedures, Functions and Packages for the application.
  • Analyzing requirement of client, generating and designing reports.
  • Creating Data structures i.e. Tables & Views and applying the referential integrity.
  • Designing Data Conversion with use of SQL*Loader.
  • Preparing and talking with clients about enhancements and modifications
  • Documented USER requirements and Testing of Developed Modules
  • Interacted with UNIX Server using Commands and scripts
  • Improved system performance in data access by fine-tuning of indexes, SQL statements and Joins.
  • Involved in reviewing the Specs of the Reports before developing the Reports.
  • Also responsible for writing Test Plan documents and unit testing for the application modules.
  • Responsible for performing Code Reviews.
  • Worked with DBA in making enhancements to Physical DBA schema.
  • Writing high quality and well documented code according to standards.

Environment: HP-UX, AIX, Oracle 8i, 9i, TOAD, Explain Plan, Oracle Trace, TKPROF

Hire Now