Project Oracle
Resume:
SUDHIR {Oracle iStore/OAF Expert} Contact:
Oracle Apps Development Lead / Manager
Email: **************@*****.***
(OAF/Sales Online/ iStore/CRM)
Summary
. Over 11 years of experience in Analysis, Design, Development and
Managing in Java, J2EE and Oracle Applications (Oracle 11i).
. Worked on all the phases of Software Development Life Cycle.
. Excellent Experience in Developing the Project Plans, Managing the
Projects, Coordinating with other teams and effectively delivering the
Project within the Timelines and Budgets.
. Over eight years of experience in using Oracle Technologies for
Designing, Developing and Managing Oracle Applications (Oracle 11i /
R12) Projects.
. Excellent experience in developing, customizing, personalizing the
self-service web pages in OA Framework (Oracle Application Framework)
using JDeveloper.
. Great understanding of the pages developed using JTF/JTT Framework
that are used in the Oracle PRM, CRM Foundation, iStore, iSupport,
Sales Online, Service Contracts, Quoting Modules.
. Excellent experience in developing, customizing and performing
functional setups in the modules of Oracle iStore and Configurator.
. Excellent Working Experience in the modules of Financials (GL, AR),
CRM Oracle iStore, OM, inventory, BOM, Configurator, iExpenses,
iProcurement, Sales Online, Quoting, Pricing, Oracle PRM Modules of
Oracle Applications.
. Extensively used Toad and SQL Navigator for developing PL/SQL
procedures, Functions and packages.
. Worked with Microsoft tools like MS Word, Excel Spreadsheet, Power
Point and Projects for delivering the status and maintenance of the
Project.
. Strong experience in developing and using Oracle 6i Forms and Reports.
. Good problem solving skills and the ability to execute timely
solutions.
. Excellent communication skills in describing the problems and the
resolutions of the problems.
. Ability to handle multiple tasks and work independently as well as in
a team.
Education
MS Computer Science (M.Tech), from
Indian Institute of Technology (IIT Madras), India.
BS Information Technology (B.Tech) from
Nagarjuna University, India.
Professional Experience
* Neopost Milford, CT April
2010 - Till Date
Role : iStore Lead
Environment : Java, JSP, SQL, PL/SQL, Linux, HTML, CSS, Oracle iStore,
Sales Online,
Configurator, Oracle Apps R12, Toad, JDeveloper
Neopost supplies the parts, machines used for
printing stamps. The project of upgrading Oracle ERP 11.5.10 to R12 is
being done. Identifying the customizations in 11.5.10 and implementing
them in R12 including further enhancements are being done as part of
iStore upgrade project. Implemented the Configurator for doing the meter
rentals from iStore. Customizations include setting the attributes on
Order Header, display TCN Number based on Shipping Address, check the
minimum order quantity.
Responsiblities:
. Identified the customizations done in iStore by going through the
iStore pages, JSP code.
. Involved in the meetings with business users for understanding the
enhancement requests.
. Performed the Configurator and iStore setups for store creation,
catalog, content and for achieving the meter rentals.
. Implemented the customizations in JSP, Java, SQL, PL/SQL using
tools like JDeveloper and Toad.
. Performed the setups for User Registration using CRM HTML
Administrator Responsibility.
. Developed the PL/SQL procedures for migrating the Catalog Section
and Items between the instances.
. Performed the unit testing of the code.
. Prepared the migration scripts/documents for migrating the code to
test and preprod instances.
* AICPA Durham, NC Jun 2008
- Feb 2010
Role : SRI Development Lead / Manager
Environment : Java, JSP, Oracle, SQL, PL/SQL, Linux, OAF, EJB, Toad, CSS,
HTML, XML, JDeveloper, VSS, Oracle EBS, Oracle
iStore, Sales Online, Quoting,
Pricing, OM, Service Contracts, Field Sales,
Oracle 10g Server.
AICPA is the major institute for CPAs. AICPA has
implemented Oracle Apps 11.5.9 for the maintenance of its Members and
Firms. Oracle Sales Online is implemented for maintaining the Persons,
Organizations, Relationships and Oracle iStore is implemented for the
Dues Payment and Profile Updates. SRI is Service revenue integration
project targeted to make the Membership Applications, and Integrated
Preference Center Online and Rebranding of iStore for Dues Payment and
Profile Update.
Responsibilities:
. Gathered the Requirements and formulated the scope of the Project
from the meetings with the User.
. Involved in the discussions for the Scope and Development of the
Project.
. Developed the Estimates for Development, Budget Analysis for the
entire scope of the Project.
. Identify all the modules affected by the Project and testing
strategies planned accordingly.
. Developed the Technical Architecture and Integration points with
other Systems.
. Performed the API Analysis on the Oracle TCA, Sales Online, Quotes,
iStore Modules.
. Implemented the iStore and OA Framework for Development.
. Developed the pages in JSPs, and OA Framework using JDeveloper.
. Managed the Development of the Project by coordinating with the
Developers.
. Primarily used Java, JSP, Toad, JDeveloper, OA Framework, CSS,
HTML, Workflow for development.
. iStore JSP code is customized and new JSPs are developed for
Membership Application.
. Developed the Migration Procedure and Performed the Migrations.
. Resolved the issues from Testing.
. Version Control is done by VSS.
* Texas Instruments Dallas, TX
Oct 2007 - Jun 2008
Role : iStore Team Lead
Environment : Java, JSP, Oracle, SQL, PL/SQL, Linux, OA Framework, Toad,
CSS,
HTML, XML, JDeveloper, WinCvs, Oracle EBS,
Oracle iStore, iPayment, iSupport,
Quoting, Pricing, OM, Service Contracts,
Telesales.
Education Technology is a part of Texas Instruments
developed for managing all the Education related operations. Oracle CRM
Modules are used selling the Calculators, Materials and support them on
the web and Knowledge Base is developed for handling user queries. The
project of Rebranding iStore, KBase and iSupport is designed by the User
Interface Team and is developed by the Technical Team. The Rebranding
project mainly focuses on the look and feel of the iStore Pages and also
modified some of the functional changes. Also worked on the Order
Management Module for doing the Credit card validations.
Responsibilities:
. Involved in the Project from the Analysis stage to Production
Maintenance.
. Developed the code for completing the Project.
. Managed the Technical team for the Rebranding Project.
. Involved in the discussions for Design, Development, Testing and
Migration of the Project.
. Resolved the issues logged as Kintana Tickets on iStore, KBase and
iSupport.
. Primarily used Java, JSP, Toad, JDeveloper, OA Framework, CSS, HTML
for development.
. Resolved the issue for Credit Card Authorizations in iStore.
. Performed the unit testing of the Rebranding Project.
. Version Control is done by WinCvs.
. Developed the code for Localization of the Messages on iStore
Profile Pages.
* Earth Tech Richmond, VA
May 2007 - Sept 2007
Role : OA Framework Lead
Environment : Java, JSP, Oracle, SQL, PL/SQL, Linux, OA Framework,
JDeveloper,XML,
Oracle EBS, Oracle iExpenses,
iProcurement, iStore, Service Contracts, TeleSales.
This Project of Earth Tech has lot of Oracle
Application modules that are developed to meet the client needs at US,
Canada and Australia. The customizations include the changing of the
Expense Type in Oracle iExpenses and Expenditure Type in Oracle
iProcurement. The Daily Rate is calculated using the Perdiem Logic for
Itemization in iExpenses. A new Tax Amount field is also needed that is to
be displayed when the receipt Amount is entered on the new Expense Report.
Developed the code for iTime for retrieving Over Time Rules Documents
based on the OT mode of the user who logged in. Developing the code for the
Receipts in AR (Financials).
Responsibilities:
. Developed all the code for the needed customizations in OA
Framework.
. Created new View Objects and Application Modules for the Expense
Type and Expenditure Type fields.
. Migration of the files developed and registering the objects
developed as custom objects.
. Unit Testing of the customized product is also done in iExpenses
and iProcurement.
. Restored all the Personalizations which were lost due to
migration of the Custom Page XML files.
. Developed the code for iTime to open the Over Time Rules
Document based on the User OT Mode.
. Migration of the Personalizations is done to save from redoing
the Personalizations again in the environment.
. Implemented the modifications using Java, OA Framework, JSP,
SQL, PL/SQL.
. JDeveloper, Java, JSP, Toad, WinSCP, Oracle Forms are the tools
used for developing this project.
* Rexel Inc Dallas, TX
June 2006 - April 2007
Role : iStore Team Lead
Environment : Java, JSP, Oracle, SQL, PL/SQL, Linux, MKS, OA
Framework, JDeveloper,
Oracle EBS, Oracle iStore, iSupport,
Service Contracts.
Rexel Express is an iStore project that is
developed to enable the customers to order their products without calling
the Sales Person. Oracle iStore 11.5.9 is customized to meet the
requirements of the customers and also modified it to make it compatible
with the customizations of Order Management. Major changes like Branch
specific product offering, Delivery/Willcall orders were made in the Rexel
Express. Integration with the CRM Foundation pages is also done for the
User Management of iStore. Rexel Express is a whole new project that went
into production for the first time.
Responsibilities:
. Involved in the complete life cycle of iStore Development from the
requirements gathering phase to the production maintenance phase.
. Participated in all the discussions from Functional Design reviews to
the actual Product Roll Out.
. Implemented the designs and developed the code using Java, JSP, SQL,
PL/SQL, OA Framework and Linux.
. Integrated the iStore pages with the CRM Foundation using JTF pages
for the purpose of User Registration in iStore.
. Customized the pages from iSupport to integrate with iStore for the
purpose of User Management.
. Shipping and Billing Pages are customized to accommodate the Customer
Part Numbers for the B2B users.
. Unit Testing of the code is also done.
. Version control for the files using the MKS tool.
. Fixing of the Enhancements and Bugs that were logged as MKS tickets
created out of the System Testing.
. JDeveloper, Toad, WinSCP, MKS, Oracle Forms are the tools used for
developing the project.
* EMC2 Westborough, MA Jan' 2006 - June
2006
Company : Accenture
Role : Application Developer
Environment : OA Framework, Java, JSPs, Oracle, SQL, PL/SQL, Unix,
Clearquest, Oracle
EBS, Oracle Partner Management, Sales Online.
Enabling Sales Effectiveness (ESE) is a development
team under the Synery project of EMC dedicated to customize the Oracle
Sales, iStore, OM and PRM Modules and enhance the functionality to suit to
that of the client. Oracle iStore customizations comprise of the display
style of the Shopping Cart, Search functionality, Shipping methods and the
functional setup for creating the stores. The customizations include the
maintenance of Partners and Partner Contacts. The Partners that are visible
to the users is controlled by the privileges of the users who log in. Only
the Contacts that are created by the PRM users should be visible.
Additional information like the mobile and fax numbers are to be stored for
the Partner Contacts. Address Purpose is one required information based on
which the visibility of the contacts depends on.
Responsibilities:
. Reviewed the Functional Designs and involved in the discussions to
specify the actual requirements.
. Developed the Technical Designs as per the Functional Requirements.
. Build the Objects using the OA (Oracle Applications) Framework, JSPs,
Java, Oracle, SQL, PL/SQL in the Linux environment.
. The search functionality is modified in Oracle iStore for adding the
customer part numbers using Java, JSP, PL/SQL.
. Shipping methods are created and mapped with that of Order Management
methods.
. Pricing Adjustments are done to take into account for the new pricing
qualifiers.
. Rewritten the SQL queries in order to increase the performance of the
output.
. Unit Testing is also done on the build objects.
. Fixed the SIRs (System Investigative Report) that are logged as part
of the Functional Testing.
. Development is also done for the Enhancement SIRs that are logged.
. File versions are maintained using the Harvest.
. JDeveloper, Toad, SQL Navigator, WinSCP, Harvest, Clearquest, Oracle
Forms are the tools used for the development of the Objects.
* Oracle Corporation, India Aug' 2004 - Dec
2005
Environment : Java, J2EE, JSP, Servlets, Oracle 9i, Forms/ Reports,
ProC,
PL/SQL, XML, OA Framework, JDeveloper, UNIX,
Linux, Oracle General
Ledgers. Oracle EBS
Role : Applications Developer
General Ledgers controls all accounting information of
an organization and reports the information to the decision makers. This
includes the collection, processing, analyzing and measuring financial
information of an organization. This module takes data from different sub
products like manufacturing, integrates and processes them. General Ledger
Accounting Cycle controls all the transactions during the year and also the
year-end processes.
Projects:
iSetup
This project is used for export/import of data from the
database tables of one client database instance to a different database
instance. This project is build upon the BC4J (Business Components For
Java) Model and follows the MVC Architecture. Selection set, export,
import are the three processes defined and developed in this project.
Responsibilities:
. Designed and Developed the self-service web pages using OA Framework.
. Extensively used Oracle JDeveloper for completing the project.
. XML is used for the internal representation of data during the
export/import process.
. Developed Stored procedures in PL/SQL for the purpose of data
validation.
. Separate pages are developed for the purpose of the LOVs.
. Build many XML files for testing different cases and conditions in the
project.
. Oracle 9i is used as the back-end storage.
Account Hierarchy Manager
Organizations have many accounts that fall into categories
like expenses, liabilities, assets, revenues etc. Maintenance of these
accounts is made very easy by developing a GUI for solving the operations
like creating a new account, deleting an existing account, merging the
accounts using simple drag and drop feature of java swings etc.
Responsibilities:
. Java Swing components are extensively used for the presentation layer.
. Added the TCF (Thin Client Framework) to the module that allows
minimal jar files to
be downloaded at the client side and thus increasing the
performance.
. PL/SQL procedures and packages are used to retrieve and update the
data from the
database tables.
. Oracle 8i is used as the back-end storage of data.
. Build JSP pages to launch the application from the client machine.
. Have extensively worked on the J2SE 1.4.2/1.5 Swing changes from Sun
to resolve the
incompatibilities with the earlier versions.
Project of Journals Desktop Integrator
Applications Desktop Integrator is an application that
enables users to use simple MS Excel sheets to enter/modify data as in
Oracle Forms for the applications. This project is mainly used by the
higher-level officials who need not download the entire Oracle
Applications but can work on the forms with the help of MS Excel.
Responsibilities:
. Coordinated with other teams to gather the requirements, perform
analysis and design of
the project.
. Extensively used Java in completing the project.
. Completely understood the underlying data model for the web ADI
involving the Components, Validators and Parameter Java files
. Developed components for passing the information from the Excel sheet
to the actual
data storage.
. Global parameters are passed into the program through various methods
like profiles,
SQL statements, Java files.
. Designed and developed layouts that can be changed/modified by adding,
removing
fields to the Excel sheet.
. Validation of data is done by PL/SQL procedures and by having separate
java validator
files.
Currency Revaluation Module
Currency Revaluation is a module that re-calculates
all the foreign currency transactions using the daily rates and period
rates as part of the month-end and year-end processes. The resulted
profit/loss amounts are stored in the gain/loss accounts of that
particular Organization.
Responsibilities:
. Extensively used C, ProC, PL/SQL and Oracle for this project.
. Prepared the design document of the module.
. Developed and tested the code as per the design document.
. Build several test scenarios to ensure the code is working properly.
. Have done performance tests and modified the SQL statements to
retrieve the results
from the database in a much lesser time.
. Created global temporary tables to increase the performance of the
module.
. Make file is developed and used to resolve the dependencies between
the files.
. Have won accolades for early completion and a bug-free module.
* ITTIAM, India
Aug' 2002 - May 2004
1 Team : AIDB
Environment : Java, Servlets, Unix, Oracle, Java Script, Websphere, WSAD,
Swing, XML, XSL,
XSD, Eclipse, Linux
Role : Java Developer
Projects:
2 Online Human Resources System
The HR online system is a web-based Intranet solution. The
employees can check their vacation, HR benefits through their accounts
online. They can update their information through their accounts. This
system also provides admin capabilities to add, delete and change user
profiles. Adding the features of Authentication and Authorization provides
employee security.
Responsibilities:
. Involved in development of the HR site design, member account and
benefit details information modules.
. Used MVC Architecture for designing the project.
. JavaScript was used for client side data validations.
. Extensively used Eclipse IDE for completing this project.
. The Server side programming was done using Java, Servlets, which
gathers the information from the database.
. Database connectivity was done through JDBC.
. JSPs are used for presentation view.
. Performed integration, system, module and unit testing using JUNIT.
. Added the Authentication and Authorization features by introducing
Roles and Responsibilities.
Implementation of XQuery, an XML Query Language.
XML has many query languages like XML-QL, XQL...ALL the
above languages have limitations in terms of speed of processing of the
query. XQuery resolves the issue by using TAX (Tree Algebra for XML).
This language is fully complete. TIMBER is one implementation. This
project is a variation of TIMBER that has the advantages of both speed
and completeness.
Responsibilities:
. This project is a research cum implementation project.
. Analyzed different query languages like XML-QL, XQL etc.
. Created the specifications document for the implementation of the
project.
. XML Schema is developed and used for the validation of the XML
document.
. Designed and developed the project using the Webspere Application
Server.
. Extensively used WSAD for completing this project.
. Developed the project in the Linux Operating System.
. Written several SQL queries to test the output of the project with the
actual results.
. The managers have rated 9 for this project on a 1 to 10 scale.
Contact this candidate