NARASIMHAMURTHY
Email:acqq37@r.postjobfree.com
Technical Consultant/SCM and Finance ( +91-895*******
Profile
> Having 3.5 years of experience with Oracle Applications 11i and R12 As
Technical consultant, extensively worked on financial modules (AP, AR,
GL) and Distribution modules (PO, INV, OM).
> Having Functional knowledge on Purchasing, Inventory, Payables and
General ledger.
> Good understanding of the functional flow in Oracle Application on
Procure to Pay(P2P)and Order to Cash (O2C)
> Experience with Oracle and Other Utilities such as TOAD, SQL*Plus,
SQL*Loader.
> Creation and registration of Tables, Reports and Other Programs.
> Defining Value sets, Executables and Concurrent Programs.
> Worked on XML publisher Report.
> Experience in customization and development of reports using Report
Builder 6i.
> Involved in personalization of forms using Form personalization feature
of apps.
> Experience in writing stored procedures, functions and packages using sql
& pl/sql as part of inbound and outbound interfaces development in oracle
applications.
> Capable of working independently and as well as a part of a team.
> Knowledge on new form development.
> worked on forms personalization.
> Worked on D2K(Reports&Forms).
> Worked on custom forms development.
> Worked on Interfaces and Conversions.
> Knowledge on Customization of Reports as per client Requirement.
> Experience in Oracle Apps AOL activities (Conc. program, Value sets etc).
> Experience in writing Stored Procedures, Functions, Packages using SQL
and PL/SQL.
> Possess very good communication and interpersonal skills.
> Knowledge on Work Flow.
Experience
> Working as a Technical consultant with Hitachi Consulting, Bangalore
from 2012 Nov to till Date.
> Worked as a Technical consultant with CSC, Chennai from from
2011 Nov to 2012 Oct.
Academic Profile
> B.Sc from S.K University.
Technical Skills
ERP : Oracle Apps 11i and R12
Reporting Tools : XML Publisher, BI Publisher
RDBMS : Oracle 9i, 10g and 11g
Front-end Tools : Forms 6i, Forms 10g
Languages : SQL, PL/SQL
Reports : Reports 6i, Reports 10g
Tools : TOAD, SQL*Loader, SQL*Plus, WINSCP
Operating Systems : Windows 2003, XP.UNIX
Projects Profile
( Project #3:
Project Title : Form Factor, Inc...
Role : Team Member.
Environment : Oracle Applications R12.
Modules : PO, AP, OM, AR
Duration : 2013 to till date.
Description:
Form Factor is a world leader in developing and applying
microelectromechanical systems (MEMS) contact technology to advanced probe
card designs. In addition to superior electrical performance
characteristics, MEMS contacts can scale to new device requirements for
finer pad pitch and higher pin counts. By investing aggressively in R&D and
infrastructure, Form Factor draws on its commitment to innovation and the
industry's largest MEMS-based production facility to address customers'
unique applications, evolving chip design and growing need for production
capacity.
Responsibilities:
> Being a part of the offshore development team and responsible for the
development of following Technical Components.
> Responsible for Interfaces to move the data from legacy system and Oracle
Apps.
> Responsible for preparing procedures, functions, packages as per
requirements.
> Worked on form personalization as per the client requirement..
> Customize the Printed Requisition Report.
> Worked on the Inbound Interface to import Legacy system information
details to Oracle Applications Base tables.
> Extensively worked on form personalizations.
> Developed value sets and concurrent programs.
> Created Responsabilits, Request Groups, Concurrent Programs and Value
sets that are part of the Time Evaluation Module.
> Migrated Concurrent programs, Menus, Valuesets using FNDLOAD utility.
> Developed Inventory details out bound interface to write data into flat
file through UTL_FILE package.
> Worked on Purchase order interface.
> Provided the solutions for Post production issues.
> Provided the detailed query for getting the information about serial
controlled items which are non reserved items information.
> Created different types of Value Sets in Various modules of the
application.
> Developed the form personalization on OM Form.
> Developed Po Goods Receipt Report Item wise using XML Publisher.
> Involved in developing the Custom tables and registering in oracle
applications.
> Involved in developing the Custom Packages and procedures.
( Project #2:
Project Title : GB Electronic Productions
Role : Associate Technical Consultant.
Environment : Oracle Applications 11.5.10, Oracle 9i, Oracle Developer
6i, TOAD.
Modules : PO, AP, OM, AR, INV.
Duration : 2012 to 2013.
Description:
We are a UK manufacturing company based in South West England specializing
in all aspects of Electronic Manufacture. Our ethos is to provide personal
project managed electronic manufacturing solutions through all stages of
product design, development, pre-production and full-scale production. Our
in house manufacturing capabilities ensure the highest build quality to ISO
9001 standards. Using the latest SMT pick & place technology with
traditional hand craft assembly techniques, we are confident that we can
satisfy all your electronic assembly requirements.
Responsibilities:
> Preparation of technical documentation.
> Responsible for Interfaces to move the data from legacy system and Oracle
Apps.
> Responsible for preparing procedures, functions, packages as per
requirements.
> Worked on form personalization as per the client requirement.
> Worked on the Stock Locator Inbound interface to import the purchase
order details from legacy system to Oracle applications base tables.
> Worked on Stock Locator Interface.
> Extensively worked on form personalizations.
> Developed value sets and concurrent programs.
> Created Responsabilits, Request Groups, Concurrent Programs and Value
sets that are part of the Time Evaluation Module.
> Migration Concurrent programs, Menus, Value sets use in FNDLOAD utility.
> Created different types of Value Sets in Various modules of the
application.
> Worked on AR Billing Receipt report.
> Developed On hand-Qty xml report.
> Involved in developing the Custom tables and registering in oracle
applications.
> Involved in developing the custom Packages and procedures.
> Involved in writing Triggers.
> Customized the OEOH workflow as per client requirement.
( Project #1:
Client : Control Technologies FZE (Ctrl tech), UAE
Role : Technical Consultant
Environment : Oracle Applications 12.1.3
Modules : PO, AP, OM, AR, INV
Duration : 2011 to 2012
Description:
Control Technologies FZE (Ctrl tech) offers Power, Cooling & Monitoring
solutions for Datacenter and Server rooms. We supply and install Power,
Cooling and Monitoring equipments which includes Uninterruptible Power
Supply (UPS), Dehumidifier, Precision Air Conditioner or Close Control
Unit (CCU) or Computer Room Air Conditioner (CRAC), Voltage Stabilizer or
Voltage Regulators, Water leak detection system, Static Transfer Switch
(STS), Access flooring, Frequency Converter, FM200 fire suppression,
Humidifier etc. They have implemented Oracle Apps R12.1.3 to manage their
business activities.
Responsibilities
> Preparation of Technical Design documents (MD70)
> Worked on various XML Publisher Reports as per client requirement.
> Developed Inbound Interface to transfer the data from legacy system.
> Involved in Form Personalization as per client requirement.
> Prepared and reviewed MD070 documents based on MD050 document.
> Developed Inventory transactions XML Report.
> Worked on Requisition Interface.
> Developed Suppler Payment status report.
> Interact with functional consultant and knows the functional things for
better understanding and better development.
> Interact with clients while providing the solution for issues raised by
the customer through Oracle Web conference.
> Involved in developing the LDT files for Concurrent Programs and data
definitions and form personalization's.
> PL/SQL method of submitting Concurrent programs
> Development and Customization of Reports, PL/SQL Procedures, and
Packages.
> Registering reports in Oracle Applications
> Developed inbound interface to transfer data from legacy system to oracle
applications
> Developed outbound interface to extract the data from the Oracle Apps
Tables to the Flat file using UTL_File utility.
> Involved in develop a Custom form.
> Worked on Adding DFF, WHO Columns, Calendar to new form.
> Worked on Query Find Form.
Environment: Oracle Applications 12.1.3, PL/SQL, SQL, Oracle Database10g,
Oracle Forms/Reports 10g.Winscp, Putty, Toad, SQL* Loader, UTL_FILE.