Sales Oracle
Resume:
Siva Puligadda
********@*******.***
Education
Fitchburg State University, Massachusetts, USA
MS Computer Science
Technical & Functional Skills
Oracle Applications: ORACLE Applications R12,11i, E-Business Suite 11i,
OM, Application Object Library (AOL), TCA,FND, Customer Data Hub,O2C,P2P
AP, AR,GL, INV, JTT, OAF, OBIEE, SOA, BPEL, Fusion Middleware, Application
Change Management Pack, AMP,OEM 11g.
Oracle CRM: Oracle CRM R12,11i, iStore, Configurator, iReceivables,
iContent, iSupport,TeleService,Order to Cash, Html Quoting, Ebusiness Tax,
Email Center, Funds Capture, Fund Disbursements, Tele sales, Install Base,
Service Contracts,ACMP.
Java Technologies: J2SDK1.x, j2ee, JDBC, Applets, Servlets, EJB, RMI,
JNDI, JMS, Java Mail.
Web technologies: JSP, HTML, XML, XSL, XSLT, CSS, JavaScript.
Languages: Java, C, C++, SQL, PL/SQL.
IDE & Other Tools: JDeveloper, JBuilder, TOAD, SQL Navigator,
WSAD/Eclipse, Visio 5, Ant.
App Servers: Web Sphere 5.0 /4.0, Apache, Tomcat 5, Oracle 9iAS,
Web logic 7.0.
Modeling Tools: Erwin, UML, Oracle Designer 2000, Rational Rose.
Operating Systems: Sun Solaris, LINUX, HP-UX, UNIX SVR4, WIN NT
Database: Oracle 7.x/8.x/9.x/10g, MYSQL, and DB2.
Professional Summary
9 years of experience with Oracle Applications and Java Technologies,
highlights included;
Experience
IconSoft Inc Mar 2014
to Till Date
Client:Underwriters Laboratories, Northbrook, IL
Oracle CRM Web Development Lead
Analysis of existing IT systems where in Oracle ERP and several standalone
open source systems are working collaboratively to achieve the common
corporate objectives.
Gather requirements for newly proposed systems, Evaluate possible
technology solutions with in the Oracle Sales iStore and other web based
Solutions.
Identified gaps, provided technology solutions and draft risks associated
with user provisioning for multiple web applications.
Implemented Third Party Payment System CyberSource with Oracle EBS module
like iReceivables, iStore, AR
Design and Implementation of Web store fronts for multiple operating units
to boost corporate business Sales via Web sales Channel.
Provide both seeded and custom Oracle Solutions that address the corporate
requirements for the online sales project, Specification drafts, review and
Responsible for project planning and execution.
Involved in Order Management settings for transaction types, basic pricing,
defaulting rules, web enabling fright carriers, pick slip rules etc.
Involved in Oracle Quoting for Salerep process and OM defaults like order
state, credit authorizations and also Install Base items views using bins
provided out of the box for customer purchase information, date, attributes
and service agreements in Order Tracker
Develop, code, install, test, debug, and document Web applications using
appropriate editors. Establish policies and procedures for publishing Web
pages and applications in conjunction with content creators.
Responsible for Specialty Sites Administration, Configurations across EBS
modules like Advanced Pricing, ONT, Quoting, INV, configurator set ups,,
Sales rep Default, general performance and maintenance of all iModules.
Funds Capture Setups for Payment System, Payee, Accounts and Routing rules
for Cybersource payment System Integration
Prepared and delivered long-term strategic plan for Oracle Web sales
channels development and presence, including standards and guidelines for
technical design, based on business goals and inputs from stakeholders.
FLSmidth
Midvale UT, Chennai, India.
Sept 2012 to Jan 2014
Application Release and Configuration Management
Iinvolved in setting up Release and Configuration Management process for
Oracle ERP, Engineering and other applications
Implemented ACMP 4.0 on OEM 11g for both 11i and release 12 EBS with
Subversion as source control repository.
Worked with Customization Manager, Patch Manager and Setup Manager for
different CEMLIs and worked with Oracle MOS on issues.
Prepared few documents like Files enabling guide, Packaging and Releasing
guide (DO 70 & DO 90) for Developers to use the tool in most efficient way.
Customized Patch Deployment Procedures to update package payload data and
actions to Custom DB by introducing a shell script custom step.
Responsible for creating detailed documents for Development Teams on
standards and best practices for packaging and deploying custom
applications
Debugging AD Worker logs and Re-synchronizing Agents on target when the
components on the instance are partially up.
Covered the majority of file types like OAF, java, forms, reports, xml
publisher, ctl, shell scripts, sql, plsql, ldt etc.
Environment: Oracle 10g, Oracle E Business Suite Release 11i, 12, OEM 11g,
AMP, ACMP 4.0, Subversion, IBM AIX.
Diviseema Solutions Feb 2011
to Mar 2012
National Trust, Swindon, UK
Cochlear Europe Ltd, Addlestone, UK
Oracle Ebusiness CRM Consultant
The National Trust is a charity and is completely independent of
government. Company relies for income on membership fees, donations,
legacies and revenue raised from commercial operations.
Established in 1981 Cochlear is the global leader in innovative,
implantable hearing solutions. Company is dedicated to bringing the gift of
sound to people all over the world. Today over 200'000 people across more
than 100 countries have been reconnected to their families, friends and
communities worldwide with one of cochlear hearing systems
Involved in Oracle Applications Upgrade project from 12.0.4 to 12.0.6
.Worked Closely with Technical, Testing and Release management teams to
deliver solutions designed for the billing and support systems.
Experience in Functional Setups associated with Oracle payment system
setups (Funds Capture & Disbursement )
Managed team of 5 people throughout the CRM System Upgrade
Worked with Web Ordering system (Support Tracker) for placing online orders
and subsequent support on the same OAF based portal application.
Interacted with Business Intelligence team on reporting requirements for
Business Leads and helped create analytics dashboards.
Experience in Email Center, Purge Emails, E-business Tax Setups for UKVAT
and associated Tax functionality.
Impact analysis for production releases at regular intervals and Patch
testing for the new functionality.
Worked on SOA web services for Eiger Bank Validation, address search etc.
in load balancer environment
Hands on experience designing and developing Oracle B2B, B2C iStore module
functionality such as Online Order Fulfillment, Custom Store Messages in
French,Customized User Registration, Search, Shop Cart, Lines Info,
Shipping, and Billing pages in order to meet client requirements.
Involved in High level Solution Design for Custom French Store. Multi Org
Specialty stores design and implementation for Korea, Germany.
Implementation of Customer Care in Teleservice and Custom Tabs
Experience in Global Address Formatting and Address Search
Customized Look and Feel of Customer facing UI and wrote several Business
classes to fulfill business requirements.
Hands on Functional and technical expertise with iStore technologies such
as JTF,OAF, iSupport, iStore, iPayment, iContent, iSupplier, iSupport and
extensive experience with Java/Oracle Development.
OrafinOne Global
Oracle CRM Custom Solutions Architect (Online Pricing)
Client: PR Newswire, Jersey City, NJ
Client: Koyo Corporation, Cleveland, OH
10/2009 - 10/2010
OrafinOne is software services provider in the areas of oracle application
implementation, up gradation, and customizations. The engagement with
PR newswire is a special type of project that required building a web
system that fits in to a highly fragmented IT landscape with in the
organization.
Analysis of existing IT systems where in Oracle ERP and several standalone
open source systems are working collaboratively to achieve the common
corporate objectives.
Gathered requirements for newly proposed systems, Evaluated possible
technology solutions with in the Oracle Sales Suite and other web based
Solutions.
Identified the gaps, provided technology solutions and drafted risks
associated.
Provided Custom iStore Solutions that addressed the corporate requirements
for the online pricing project Designed and Drafted Technology Solution
Document addressing all necessary requirements of the enterprise.
Oracle CRM Web and Fusion Middleware Lead Developer
Designed and Developed Oracle B2B iStore for Koyo Dealers to place orders
online. Customized User Registration, Search, Shop Cart, Lines Info,
Shipping, Billing pages in order to meet business demands.
Lead B2B iStore project with five Resources in hand and delivered project
within promised time frame.
Requirements gathering with Business users to understand existing business
processes and prepared Functional (MD 050), Technical (MD 070) and
Implementation (MD 120) documents.
Set up basic B2B iStore include initial profile setups for Store, Quoting,
OM, Pricing and all other integrated applications, defined store admins and
launched admin UI.
Designed and associated custom responsibilities, roles, permissions for
several functional privileges for the
Users also enabled the application for customizations.
Implemented Products Catalog, Content, Pricing, Promo codes, Payments
types, Shipping methods, Customers
And ATP checks.
Extensively worked on Globalization and multi org store set ups with
multiple custom responsibilities.
Worked with Oracle Applications Integrations Team to analyze and
incorporate latest technologies within Fusion Middleware 11g (BPEL,
MEDIATOR, HUMAN TASK, XML, XSL, SOAP, WEB SEVRICES, JMS, and MQ ADAPTERS).
Created several BPEL processes using Jdev 11g and Extensively Worked with
XML, WSDL, XSD, and XSL Transformations.
Developed Data Rules in Rule Author Using RL Functions and XML Facts also
worked with Work list Applications and Human Tasks. Configured Web logic
Console and Enterprise Manager for Different Processes and also
administered Deployed Applications.
Worked on Connection Pools, Data Source Connections and JNDI names in the
application server. Experience on OAGIS common data Model and also worked
on DB Adapter, JMS adapter, File Adapter etc.
Environment: Oracle 10g, Oracle E Business Suite Release 12, Fusion
Middleware 11g, iStore, iPayment, iContent, i Supplier, iSupport, PL/SQL,
OM, AR, INV, AP, OA Pages,TCA, SQL*Loader, O2C, Java, JSP, Java Script,
JDeveloper 11g, TOAD 7.5.0.0/8.0, HP UX.
Helen of Troy, El Paso, TX 11/2007 - 10/2009
Oracle CRM Web Development Lead
Helen of Troy Limited has established a leadership position in the personal
care products market. Helen of Troy is licensed to sell products under the
Vidal Sassoon? Revlon?, Dr. Scroll's?, Scroll?, Sunbeam?, Health at Home?,
Health o meter?, Sea Breeze? And Vitapointe? Trademarks and trade names.
Helen of Troy's owned trademarks include OXO?, Brut?, Vitalis?, Final Net?,
Ammens?, SkinMilk?, Time block?, Epic-Stop?, Daze?, Caruso?, Karina?,
DCNL?, and Nandi? In household consumer product categories. The Company's
products are sold primarily through mass merchandisers, drug store chains,
warehouse clubs, and grocery stores.
Designed and Implemented Custom web store fronts for multiple operating
units as and when corporate expanded via acquisitions and mergers.
Prepared and delivered long-term strategic plan for Oracle Web sales
channels development and presence, including standards and guidelines for
technical design, based on business goals and input from stakeholders.
Implemented payments module with iStore for paymentech of VeriSign gateway
model and configuration of BEP, EC App Servlet.
Review and analyze systems requirements in order to determine whether all
required elements have been included .Consults with clients to gather
information about application needs, objectives, functions, features, and
input and output requirements.
Wrote custom programs to publish content from iContent Module to directly
upload to the Customer facing UI.
Worked on CRM User setups and User type's creations with custom
responsibilities, roles and permissions in order to gain access custom
applications for both B2B and B2C.
Designed and Developed brand new custom OA Pages and integrated with Store
Merchant UI menu for several customized data presentation requirements both
for business users and end users.
Developed JSP based Custom Applications (JTT Framework) for all web related
projects information to customer support and salesrep departments heads and
supervisors.
Setting pricelists for different specialty stores and items and content
maintenance at regular intervals as and when new prices and items are added
in Advance Pricing.
Defined Transaction types in OM and custom Order Holds procedures for
specific transaction types are incorporated in web stores soon after order
submitted.
Identify, recommend, and prioritize new Web features and applications in
conjunction with business leaders and department managers. Oversee Web
development projects, including intranets and extra-nets.
Wrote SQL Loader concurrent programs to load ZIP code data to custom tables
and also store locations Geographical Data for Store Locator on the web
functions.
Develop, code, install, test, debug, and document Web applications using
appropriate editors. Establish policies and procedures for publishing Web
pages and applications in conjunction with content creators.
Integrated Google Analytics to all Specialty Stores to track analytics and
ROI from various sales channels.
Work with database administrator to design, develop, and update databases
as they relate to Web applications. Ensure security of all Web sites and
related applications. Perform periodic Web site audits. Monitor and report
on Web site traffic and performance.
Conduct research into current and emerging Web technologies and issues in
support of Web development efforts. Perform cost-benefit analysis of
proposed Web implementations, enhancements, and modifications.
Troubleshooting problems with the existing Oracle client/server systems and
also monitor performance of programs after implementation. Train personnel
in user departments in any specific procedures necessary to enter data into
systems for computer processing.
Set and enforce compatibility and interoperability standards that ensure
site accessibility for all users. Manage and/or provide guidance to junior
members of the team.
Environment: Oracle 10g, Oracle CRM 11i (11.5.9), iStore, iPayment,
iContent, iSupplier, iSupport, PL/SQL, OM, AR, INV, AP, OA Pages,TCA,
SQL*Loader, O2C, Java, JSP, Java Script, Quest Stat Application Change
Management, JDeveloper 10g/9.0.3, TOAD 7.5.0.0/8.0, HP UX.
Enterprise Solutions Inc., Santa Clara, CA 07/2006 - 11/2007
Oracle CRM Techno Functional Consultant
(Contract)
Enterprise Solutions Inc. has established a leadership position in the
personal care products market. The Company's products are sold primarily
through mass merchandisers, drug store chains, warehouse clubs, and grocery
stores.
Involved in requirements gathering for web applications, Design and
Development activities for B2C, B2B web store fronts (Sales Rep Store)
along with maintenance and enhancements of the existing systems.
iStore Merchant UI setups and customizations for Multi-Operating Units in
order to display Inventory items related to particular Inventory Org and
New Admin Tools Tab with extensions for Store Locator, News Articles,
Recipes, Chefs create, update and delete functionalities
Setting up BEP servlet configurations, EC app servlet, Payments system, and
payee setup Routing rules. VeriSign setups with ipayment. Vpspayment
properties setups
Total Custom iStore Merchant UI Application Screens for Customer care and
support Department Users for Orders and Back Orders.
Provided various production unique User and Items extracts at regular
intervals for the management.
Customized Direct item entry screens for sales rep portal for both obsolete
items and new items for Inventory flags like Customer Orders enabled, Web
Status, Published.
Create Promotion codes for various web order types, and Price lists for
different specialty stores.
Created many custom JSP pages and Java Classes for the look and feel at
section, sub section and product detail level as well as for business
critical data capture.
Implemented product cross reference in order to display related items at
the end product detail template.
Created custom template for Merchant UI product detail for capturing
addition info of the items like new, future availability date, physical
dimensions, dish washer safe, use and care, keywords for cross reference.
Market Survey Integration with third party web service provider for B2C web
store and email to friend about the product functionality from URL deep
linking not having to pick the store from minisites home page.
Created custom tables to capture data about store locations and load data
using Concurrent programs.
Wrote several Java Scripts for client side validations at user
registrations and at various input fields of the application.
Client: Jacobsen, a Textron Company, Charlotte, NC. 11/2005 - 03/2006
Oracle CRM Techno Functional Consultant
(Contract)
Jacobsen*, A Textron Company, is a $10 billion multi-industry company with
more than 43,000 employees in 40 countries. Jacobsen has got a rich
heritage in the turf care industry and dedicated to do more than just
mow. Jacobsen design, engineer, manufacture and support Bob-Cat?, Brouwer,
Bunton?, Cushman?, E-Z-GO?, Jacobsen?, Ransomes? Ryan? And SteinerT
equipment.
Involved in Design, Development and implementation on iStore, iSupport
modules in Oracle CRM 11i.
Involved in profile options set up for iStore like JTF profiles, look and
feel, CRM profiles, Order Capture, Site level profile options.
Worked on iStore Set ups the Site Administration UI, Create a basic site,
Set up the Customer UI, Test the site. Set up Concurrent Program
Administrator, Guest User Access.
Created Basic site launching Admin UI assigned languages, currencies,
price lists
Payment options, shipping methods, Responsibilities, Access Restrictions
for various Organizations
Created Custom Responsibilities, Roles, and Permissions for granular level
control of operations in iStore.
Involved in creation of users and user maintenance assigning
responsibilities, and Descriptive Flex fields (Securing attributes) at the
User Level that will let the user enter third party gardening portal
automatically from the iStore.
Customized user registration, create customer, direct item entry, shipping
and billing Page, Basic Store login customizations of the iStore.
Designed new JSP's for logging in to the third party gardening portal from
the iStore, Dealer Inventory, Warranty claims and wrote several Java beans
to suite new business demands of Jacobsen.
Wrote JavaScript for client side validations and UNIX shell scripts for
different requirements.
Wrote PL-SQL procedures for the serialized inventory of the dealers that
will populate Custom tables of dealer's inventory.
Worked on integrating iSupport in to iStore to get 360 degree view of the
application major integration activities involved are Product
Registrations, Rebates, Warranty claims, and Serialized inventory.
Modified Service Request Flow, Created custom regions, Attributes
established page region mappings in AK Developer, and Created form
functions of iSupport and integrated with iStore.
Worked on iSupport product registrations customizations.
Experience in JDeveloper set ups, OA Framework, TCA, OM, AP, INV, Install
Base, Telesales.
Environment: Oracle 9.1, Oracle CRM 11i (11.5.10), iStore, iSupplier,
iSupport, PL/SQL, Order Management, Telesales, TCA, Service Contracts,
Installed Base, SQL*Loader, Java, JSP, Java Script, RCS version control,
JDeveloper 10g/9.0.3, TOAD 7.5.0.0/8.0, SOLARIS.
Client: EMC Corporation, Westborough, MA. 5/2005 - 9/2005
Oracle iStore Developer
(Contract)
EMC Corporation is the world leader in systems, software, services, and
solutions for information storage and management. They help organizations
of all sizes across the globe implement information lifecycle management
(ILM) strategies that enable them to better and more cost-effectively
manage, use, protect, and share their information.
Channel Express is a tool that enables EMC user to configure, price, quote
and submit orders to EMC. This application is part of an EMC initiative to
provide EMC Partners with a set of tools and services to simplify the
experience of doing business with EMC. Major modules involved in channel
express are Project Registration, Product Selection, Carts and Cart
Sharing, Advanced Shopping Cart, Sales Assistance, Quotes, Order
Submission.
Involved in Shopping cart and Project registration and Email Notifications
modules.
Extensively involved in implementing, customizing and migrating Oracle
11.5.9 11.5.10 iStore.
Created JSP's to, Save Cart, Share Cart, delete, Continue Shopping,
Promotion Codes and shopping lists, attachments, Exporting Quotes.
Worked on several enhancements in iStore like Need Sales Rep Assistance,
Transfer Cart, and Quote Analysis.
Supported several stages of testing and fixing defects that come along the
way.
Wrote custom java classes to EMCCustomerAddressManager, EMCEmailSender,
EMCCustomerAddress, to save, validate address, get address, and send email
request to CMG (customer master group) for new customer creation by Channel
Express user.
Highly Involved in Customizing 11.5.10 iStore to EMC Channel Express
application in order to meet the new business demands.
Wrote custom java classes in the Project registration module
EMCIBEProjRegManager, EMCIBERegistrationListHandler.
Wrote Java Beans for multi part form data upload to the data base in order
to add attachments to the Carts and quotes in the Channel Express
application.
Created new JSP's and servlets for new customer account registration by the
Channel Express user in order to change Ship-to or install-at accounts.
Wrote a PL-SQL procedure to send EMAIL NOTIFICATION via Java mail to
Customer Master Group for Approval.
Created JSP for generating reports in various formats like Excel, PDF, XML
and RTF.
Worked on Password assistance for the Channel Express users to generate
Java mail to send new password to the user.
Created PL/SQL packages which are used by scripting for creating customers,
accounts, locations, contacts, leads, quotes.
Environment: Java, J2EE1.3, JSP 2.1, Servlets 2.3, java beans,JDBC, Java
Mail, Java Script,OA framework, Oracle 9i AS Application Server, Apache,
All Fusion Harvest CM 5.1.1, PL/SQL,TOAD, Oracle applications 11i E
Business Suite, iStore 11.5.9 & 11.5.10, Telesales, Install Base, SQL
navigator 4.x, SOLARIS.
Bureau of Motor Vehicles, Augusta, Maine
7/2004 - 1/2005
Java Developer (Contract)
BMV System is being developed with an intention to migrate from current
BULL Mainframe system to a more advanced web-based system that has many
advantages over the current system. The project involves several online
interactive modules, sub systems, batch processes, Real time and batch
interfaces designed and developed to maintain BMV information system. Major
modules include, Driver Licensing, POS (Point of Sale), Registration,
Customer maintenance, Letters and Reports, Vehicle, Title, Inventory, etc.
Involved in designing, developing, testing and implementation of use cases
for modules like Inventory, Registration, Customer and Driver Licensing.
Involved in full life cycle development of distributed and multi-tier
applications environment using JAVA, J2EE Technologies.
Based on specifications available from business analysts, designed
technical specifications, attended construction readiness reviews,
developed to specifications, unit tested and participated in code reviews.
Developed Model, View and Controller (MVC) components to process request,
identify action to send request to it, control flow of logic and produce
output to client. Provided support for design and development of database
and wrote procedures, triggers using PL/SQL.
Implemented and developed JSP s, EJB's and made accessible to the client in
Eclipse Integrated development environment and participated in page spec
tool Enhancements.
Wrote Action classes implementing the business logic by making use of
Jakarta Struts framework and BMV proprietary framework and extensively
worked on fixing bugs in the presentation tier which developed on XML, XSL,
XSLT templates.
Developed and maintained interfaces, online modules and batch components
for inventory subsystem, Letters subsystem and Driver licensing subsystems
- Inventory cycle counts, Calculate Registration Fees, Over Limit Permit
Fees, Calculate LTT Fees, re-Calc LTT Fees, Create Update LTT Registration,
Create LTT Billing Transactions, Create Update Vehicle subsystems.
Integrated above components with other subsystems such as POS, Inventory,
and Letters Notices.
Involved in generating Reports and Letters using Servlets, JMS, Java Beans
in the Web sphere 5.0 and MQ series for Asynchronous communication
between.
Applications. Used LDAP, Lightweight Directory Access Protocol, for user
authorization and authentication that look up information from server.
Followed the Rules of Extreme Programming, i.e. Planning (User Stories,
Release Planning, small releases, Project velocity, iterations & iteration
planning, stand up meetings.) Coding (always available, standards, unit
test first, pair programming, integrate code, collective code ownership,
optimization) Designing (Simplicity, System metaphor, CRC Cards) & finally
Testing (unit tests, Acceptance tests).
Designed, developed and tested online utility to maintain Batch Scheduler.
Batch Scheduler helps the system administrator to manage batch schedules
and to add, delete, update batch jobs. In addition it helps in tracking
batch job and batch schedule statuses on a daily basis.
Created code standards, code optimization and general OO design and
responsible for improving the performance of the Web Sphere Application
Server using WLM (work load management).
Environment: EJB 1.1, Java, J2EE1.3, Object Oriented Analysis and Design,
Jakarta Struts Framework, JBO( java business objects ), Eclipse
3.0,WebSphere 5.0 Application Server, MQ series, Tomcat, Oracle RDBMS, MS
Office, Rational Unified Process, UML, Rational Clear Case, Rational Clear
Quest, Rational Rose, XML, XSL, XSLT, Ant.
Contact this candidate