Oracle Project
Resume:
CURRICULUM VITAE
Ram
E.mail: *****.***@*****.***
Profile
> 3 years of experience as Oracle Technical Consultant on
OracleApplications R12.
> Worked with modules like Payables, General Ledger, Receivables, Fixed
Assets and Purchasing of Oracle Applications.
> Involved in different stages of the project such as requirement analysis,
design, development and Unit Testing.
> Experienced Technical Development skills in developing RICE Components
(Reports, Interfaces, Conversions, Extensions) in the domain of Oracle
Applications E- Business Suite.
> Experience with Oracle and Other Utilities such as TOAD, SQL*Plus,
SQL*Loader.
> Defining Value sets, Executables and Concurrent Programs.
> Experience in customization and development of reports using Report
Builder 9i.
> Experience in personalization of forms using Form personalization apps.
> Worked on FORMS Personalization and XML Publisher Reports & Discoverer
Report.
> Worked on Interfaces to transfer the legacy system information to
Release R12 which includes AP,GL,AR modules using PL/SQL, SQL* Plus, and
SQL* Loader
> Good Knowledge on Workflow and Exposure on OBIEE.
> Interacted with Clients to understand business and IT requirements.
> Involved 1 implementation and 3 supporting projects
Experience
> Working as Technical Consultant with Clover InfoTech, Bangalore from
May'10 toTill Date.
Academic Profile
> M.C.A from B.D.University, 2009.
Technical Skills
ERP : Oracle Apps R12 (AP,GL,FA,AR,PO)
Reporting Tools : XML Publisher, Discoverer
RDBMS : Oracle 9i, 10g
Front-end Tools : Forms 10g
Languages : SQL, PL/SQL
Reports : Reports 10g
Tools : TOAD, SQL*Loader, SQL*Plus
Operating Systems : Windows 2003, XP.
Projects Profile
( Project #1:
Title : India first Life Insurance
Client : IndiaFirst
Role : Technical Consultant
Environment : Oracle Applications 12.1.1, Oracle 10g, TOAD,SQL*
LOADER
Duration : May 2010 to Till Date.
Description:
The youngest Life Insurance Company in India with the fastest
run rate of performance, India First is emerging as the new face of the
Life Insurance Industry. Think New, Be Honest, Be Helpful and Do More - are
the four guiding values of our business which helped us establish the
fastest and financially the strongest momentum in the industry clocking
about Rs. 5,000 million of new business premiums in less than a year from
inception. Launched nationwide in March, 2010 by Shri Pranab Mukherjee,
Honourable Finance Minister, we provide you a variety of protection,
savings and investment and pension products through over 4500 offices of
our partner banks across 1000 cities and towns of India.
Responsibilities:
> Responsible for Development and Customization of Reports, Interfaces
between legacy system and Oracle Apps.
> Responsible for preparing procedures, functions, packages as per
requirements.
> Involved in moving AOL Objects like Concurrent programs, DFF, KFF and
Form Personalization's from one instance to another instance using FND
LOAD.
> Worked closely with functional team to understand the requirement.
> Involved Month end and year end activity.
> Defined tax setups and IL Taxes.
> Defined new financial purpose Calendar and Sequences.
Reports:
> Developed Vendor Detail Report
> Developed TDS Detail Report
> Developed IFL-Invoice Detail report
> Customized Account Analysis Report.
> Customized Asset Register Report.
> Developed Supplier Payment Report by using XML Publisher.
> Customized web ADI and Asset Integrator.
Interfaces:
> Worked on the AP Inbound Interface to import the Invoice details from
Legacy system to Oracle Applications Base tables.
> Worked on GL Interface to Import the Journals data from Legacy system to
Oracle Applications GL Base tables.
Forms:
> Customized the forms using custom.pll and Personalization.
> Implemented Maker-Checker Concept using Personalization on GL
Responsibility.
Project#2:
Project Title : India Pistions Ltd
Client : India Pistions Ltd
Role : Technical Consultant
Environment : Oracle Applications R12
Duration : Nov 2011 to Till Date
Responsibilities:
> Responsible for Development of Reports and Interfaces between legacy
system and Oracle Apps.
> Responsible for preparing procedures, functions, packages as per
requirements.
> Worked on form personalization as per the client requirement.
> Prepared technical documents (MD070) and Unit testing documents.
> Developed .rdf and XMLreports and e-text outbound format reports.
Reports:
> Developed Bill Discounting Report.
> Developed TDS Detail Report.
> Customizing Invoice Aging Report.
> Customized Payment Report.
Interfaces:
> Developed Supplier Creation Interface.
> Developed GL Interface to Upload the Journals from legacy system to
Oracle Apps Base tables.
Forms:
> Personalized Forms as per Client Requirement.
> Personalized Invoice Form as per Client Requirement.
( Project #3:
Project Title : SIRO CLIN PHARM.
Client : SIRO CLIN PHARM.
Role : Technical Consultant
Environment : Oracle Applications R12
Duration : Sep 2011 to Aug-12.
Description:
SIRO CLINPHARM is a leading full service Clinical Research
Organization that specializes in providing solutions to the win
challenges of speed and cost in clinical drug development. Pioneered
the development of alternative geographies for conducting clinical
trials, Providing world class facilities, expertise and unexplored
patient pools.
Responsibilities:
> Responsible for Development of Reports and Interfaces between legacy
system to Oracle Apps.
> Responsible for preparing procedures, functions, packages as per
requirements.
> Created Value sets, sequences.
> Worked on form personalization as per the client requirement.
> Involved in Moving the Code from one Instance to another Instance and
Loading the data from an Excel sheet to Oracle applications by
using DATA LOADER.
> Worked on Interfaces, .rdf reports, XML report and Discoverer reports.
Reports:
> Developed TDS Detail Report.
> Developed AP Invoice and payments analysis report.
> Customized Payment Report.
> Developed Sales book details report in XML Publisher.
Interfaces:
> Developed Supplier Creation Interface.
> Developed GL Interface to Upload the Journals from legacy system to
Oracle Apps Base tables.
Forms:
> Personalized Forms as per Client Requirement.
> Personalized Transaction Form as per Client Requirement.
Contact this candidate