Anil Passi (Technical Oracle Applications Consultant)
Anil has over 12
years Oracle Applications experience. Anil has worked as an Oracle Applications
consultant with two of the big 5consultancies. Anil has in-depth technical
knowledge of Oracle Applications in Release 12/11i/11/10.7, together with good
functional knowledge. Anil has worked on all the aspects of Oracle Applications.
Anil has delivered numerous consultancy solutions and has designed & developed
various critical business processes (SelfService, Forms, Reports, Interfaces, Business
Intelligence, Workflows & SOA BPEL/WebServices) for different clients
across the globe in a very efficient manner without compromising with the
Quality. Additionally Anil has also given Best Practices seminars on Oracle
Applications extensions for Oracle University in EMEA countries covering R12
functionalities.
Experience
Summary
·
Oracle Design & Development Experience :: 12 Years
·
Oracle Applications (Financials, HR, CRM &
Manufacturing):: 10 Years
Release 12/11i :: 8 Years
Release 11.02/03 :: 2 Years
10.7/10.6 (Character & SC) :: 2 Years
Oracle
Application Modules
Oracle
Receivables/Cash Mgmt/Treasury Oracle
iProcurement /Purchasing/Payables/Contracts
Oracle
HRMS/ SSHR/Time Mgmt/OTL Oracle
Payroll/Labor Distrbution/Learning/iRecruitment
Oracle
Order Entry/Management Oracle
Grants Management/Projects Accounting & Management
Oracle
CRM(Spares Mgmt, TeleServ) Oracle
Workflows/Oracle Exchange
Oracle
BOM/WIP/MRP Oracle
General Ledger
Oracle
Inventory Oracle
Student Systems
Primary
Skills
OA Framework Oracle
SOA Suite [ BPEL/ESB]
BI Publisher & OBIEE Oracle
Forms 9i/6i/4.5/2.3
Oracle Workflows 2.5 & 2.6 PL/SQL
ORACLE Reports & Discoverer Java,
Java Concurrent Programs, JDBC, XML
Jdeveloper 9.0.3, Eclipse, J2EE, SQL*Loader,
Pro*C
Unix Shell Scripts ASP,
SQL*Server, XML
JSP Servlets
Designer
2000
Forms 3.0 / Forms 2.3
EDUCATION
Bachelor’s
Degree in Engineering- with Distinction(Honors)
Unix
Release11, Sun Solaris 5.4, Ms Dos V 6.22, Windows NT/95/98/2K, Novell Netware
4.0.
Contact Information
Email : anilpassi@gmail.com
Address
PROJECT
ASSIGNMENTS
Interim Projects
1) RZB Bank Austria R12 [Oct
2007]
Designed & delivered interfaces
and extensions to OA Framework on Learning Mgmt and Self Service HR.
Also gave onsite training to their consultants for doing extensions in
eBusiness Suite.
2) 170 Systems –R12 Upgrade
[Nov2007-Dec2007]
Helped 170 Systems to
upgrade all of their Procurement extensions from Forms & CUSTOM.pll into OA
Framework, as many of the core procurement screens in R12 now use OA Framework.
170 Systems is a product development company, and these extensions were
performed to Markview functionality of their product
Major Projects
1) March 2003 – Contract Finishes in Jan 09 (London
Imperial College)
Imperial college was on
11.5.7 when I joined their project. I initially joined the project to implement
and customize iProcurement using Oracle Exchange on 11.5.7. This was followed
by upgrade to 11.5.9 & 11.5.10. I was the sole Tech consultant who carried
out all iProcurement & Self Service HR customizations. Also worked on Oracle
Grants, Receivables, Purchasing, General Ledger, Human Resource, Payroll,
Single Signon Project.
§
Carried out technical gap analysis, technical
design, user migration, event subscription, development & troubleshooting
to implement Single Signon of Oracle Apps with Microsoft Active Directory, via
OID. Various webservices were also
implemented to ensure streamlined operations with Active Directory.
§
Implemented Data Quality Management rules, to ensure
that duplicate parties are not created for Identity Mgmt
§
Performed various extensions to iRecruitment, OLM
& SSHR using OA Framework, Business Events & Web Services. All the extensions
were made in upgrade-safe manner. Set benchmarks for extensions in OAF.
§
Configured SSHR Personalizations in OAF, customized
Self Service Personal Details screen & different SIT’s.
§
Customized the core Self Service HR Workflow to
implement various different business requirements.
§
Designed/developed a HESA interface from HR/Payroll,
to report salary/employee details to University Authorities
§
Migrated data from SIT’s to Self Service
qualification screen. Extended OA Framework self service screen &
§
Java files to meet university
legislative requirements. These changes were done on JRAD Framework 5.7V4
Rollup
§
Designed element links, developed fast formulas for
recovery of Statutory elements like SPP, SPA etc.
§
Resolved various critical Payroll Costing, Element
Design, Balances, Fast Formula Design & Statutory issues.
§
Proof of concept to implement a new Skill Mgmt
Hierarchy for Appraisals using AME
§
Developed script to resolve issues for discrepancy
betwn Gross To Net & P35. Resolved various HR security issues
§
Migrated data into Oracle HRMS SIT’s,
qualifications, EITs, Previous Employments etc.
§
Developed Fast Formulas, balances for new Tax year
rules. Enabled WNU & P6 EDI with Inland Revenue.
§
Designed and developed discoverer reports for
Costing via Labor Distribution.
§
Developed process to transfer Payroll Element Entry
Values from non-standard Element Links to Standard Links.
Reports & Oracle Business Intelligence
§
Developed several reports using BI Publisher in
Oracle Grants and Procurement.
§
Implemented bursting for electronic distribution
remittance report to suppliers.
§
Worked with Physical, Logical and Presentation Layer
of BIEE
§
Implemented calculations to the fact.
§
Defined dimension Hierarchies for the Dimension
Logical Table
§
Developed Dashboards, Pages, Reports, Prompts and
configuring the navigation between these.
Oracle iProcurement, Receivables, Payables & Oracle Grants/Project Management
§
Implemented all the iProcurement customizations
using AK Developer and JSP Screens in 11.5.7-11.5.9
§
Re-Implemented iProcurement & all its
customizations using Oracle Framework on 11.5.10. Did the entire iProc upgrade
project myself. Used JDeveloper 9.0.3 to make all extensions/changes to OAF
components.
§
Enabled supplier punchouts using Oracle
Exchange to enable XML/cXML messaging. Helped suppliers resolve
§ Developed programs to create Approved
Contract PO’s, customized PO Print report for XML related changes.
§
Customized “PO Doc creation workflow”, “PO Approval
& Requisition Approval Workflow” for iProcurement.
§
Configured various
SelfService screens in iProcurement, using AK Developer & XML Templates.
§
Resolved problems with cXML
messages/encoding.Enabled PO_007 outbound messages via exchange for suppliers
§
Negotiated OAG XML PO_007 & response BOD
documents with various suppliers for seemless B2B integration.
§
Developed Workflow for Customer Interface using TCA
V2 API’s. Various other interfaces using TCA API’s.
§
Integrated Grants Management with iProcurement.
Designed/developed Payables/GMS account generator workflow
§
Migrated Awards & Projects with Costing details
to Oracle Grants and Oracle Projects using OpenInterfaces/Api’s
§
Migrated Purchasing Encumbrances into Grants.
Developed various migration reconciliation processes.
§
Designed & developed process to integrate Awards
and Projects from Proposal System into Oracle Grants & PA.
§
Developed various SQL’s for Auto-Accounting rules.
Troubleshooted and fixed various invoicing issues in Grants
§
Developed scripts to reconcile legacy data with migrated data.Reconciliation
scripts for setups were also developed
§
Various customizations to integrate iProcurement and
Purchasing with Oracle Grants.
§
A cost transfer functionality was designed &
developed along with workflow for their approvals. This functionality fills the
Gap in Oracle, as Oracle provides no standard functionality to move costs
between Grants and Non-Grants.
§ Designed and Implemented stored custom measures in Oracle Project Intelligence
§ Developed quick “project switch” extension to allow users to switch project from any tab in Project Management
§ Streamlined project creation to merge “copy options” into main screen by OA Framework Extension
§ Extended Project Management pages to display action history against project
§ Enhanced project search functionality in Oracle Project management via OA Framework
iExpenses Extensions
§
Carried out design and development of all the extensions in OA Framework for
iExpenses on 11.5.10 for this client.
Oracle Student System
§
I was responsible for migrating Students, program
attempts,unit sets, unit attempts, research details, exam details,
progressions, unit outcomes, previous education details into
§
Various different design/development of
customizations for Student System using CUSTOM.pll & Personalizations
In addition to
above, I worked upon open source initiatives in London Imperial College,
whereby a Digital Repository System was implemented. Design & development
spanned various technological toolkits like AXIS[Web Services],
Eclipse[JAVA/MDS Framework], Subversion for Source Control and ANT for
deployment
2) January 2002 – March
2003(Swiss Reinsurance)
Swiss Re is the second largest Re-Insurance Company. This project involved Global 11i(11.5.8) Implementation of various Financial Modules i.e. Oracle Treasury, Cash Mgmt, Payables, Receivables, HR and General Ledger. My role was that of a hybrid Function+Technical Consultant. I designed interfaces and developed data models for cash balances to be used in Business Objects reporting. Traveled to Europe and USA for meetings with business analysts, users and technical teams of other projects
§ Developed interface using JAVA to interface SWIFT network for incoming MT messages into Cash Management
§
Designed External Forecast Process to integrate cash
movements from investment system into Oracle Cash Mgmt
§
Designed data model for Cash Reporting for balances
with data from Cash Management & external sources
§
Interface Of Market Feed for FX Rates, Interest
rates and option values to support daily treasury operations.
§ Designed & developed Payables invoice interface & General Ledger interface using SAX parser in XML + Java.
§ Implemented Payables Invoice approval workflow using AME
§ Functional &
tech Design of Payables Invoice approval Workflow. Developed workflow prototype
for workshops
§ Functional/tech
design & development of workflow process to streamline approval of intercompany
FX transactions.
§ Interfaced
receipts into Oracle Receivables using new ‘Receipts API’, a method more
efficient than Lockboxes.
§ Migrated
employees and all related details into Oracle HRMS and Payroll.
§ Designed/developed generic workflow notification API, hence reducing development time for many team members.
3) October 2000 – December
2001(Oracle Consulting UK, As an independent contractor to Oracle UK)
a) August 2001 – January 2002(Oracle
Consulting
Release 11i Implementation of
Oracle HRMS, Oracle Payroll and Oracle
Time Management/OTL for Ladbrokes.
§ Designed
and developed a bespoke TimeSheet Entry Form using Forms 6i. This complex
screen uses Oracle Time
Management tables, Payroll Elements,
Oracle Time Labour timecard entry API’s. All the time information
was captured using Oracle Payroll
Elements. The screen also displayed various user defined Employee Balances.
§ Designed
and Developed Payroll Accounting interface to distribute Labor Costs across
various cost centers in
Oracle Payroll. The costing file was sent
by Rebus, which was apportioned across to Cost Centres & Payroll
Elements using Oracle Element Entry
API's. Over 1 Million transactions were processed using this each month.
§ Developed
a bespoke process to interface selected element entries from BEE, so as to
update Payroll Balances.
§ Developed
Reports to reconcile Oracle with Rebus, created Form showing employees
breaching EWT Directive.
§ Developed
FastFormula in Oracle Payroll to transfer values from one payroll balance to
another.
b) June 2001 - August
2001(Oracle Consulting
Oracle
run project to implement complete suite of 11i CRM along with Core Financials/ Order Management
for Ikon.
§
Developed interface processes to
automate creation of Purchase Orders when field engineers placed a requisition
at call center. Developed interface to place reservations against Sales Orders
when the goods were received in inventory. This process involved integrating
CRM Spare Module,
§ Automated
Customer call scheduler process to interface outstanding payments in Call
Center Agents diary.
§ Customized
AR Invoice print report, AR statement report. These reports were developed in
Bitmap format.
c) October 2000 - May
2001(Oracle Consulting
An
Oracle run project to design and build a bespoke Hire and Sales application for
SGB, an international scaffolding company. This application has been
built to Oracle Applications Release
11.03 standards and is heavily reliant on the standard OE, AR, INV, GL, and
FA. I designed and developed numerous Forms, PL*SQL packages/API’s and reports
§ Designed
& developed a mini CRM module for Customer Care in Oracle Receivables. This included development of bespoke Receivables
workbench form. Also developed Screens for Open/Closed AR Items, Quick Dispute Creation, Dispute
History/Resolution, Quick Customer Calls, and Turnover for each of the past
24months. This bespoke
Receivables workbench was integrated with standard Aging, Customer, Dunning and
Receivables Account Overview
screens. CUSTOM.pll was used extensively to integrate bespoke screens with
other AR screens.
§ Developed
a report for the Receivables Customer Care module to print all AR open/closed
items for a customer.
§ Developed
returns module for bespoke Hire Management software and interfaced to Inventory
& Receivables.
§
Developed various screens like
Returns Workbench, Over Returns, Charge for Damage, Hire Job Adjustments. Migrated
open return transaction data from SGB’s Legacy system.
§ Developed
Order Import API to import Sales Orders from Hire Sales screen into standard
Oracle Order Entry.
§ Developed
a PL/SQL interface to import Customer Contacts from Hire Sales screen into AR, using
open interface.
4) March 1998- October
2000(Electronic Arts
As
an Oracle Applications Techno-Functional consultant played a crucial role in Release
11.02 APPS implementations for Electronic Arts in their Pan-European
implementations. Responsible for Customizing/Creating various forms,
extensively customising & developing various OE,
November 1999 - October 2000
Release 11.03 implementation for EA Switzerland
§ Design
& development of module for managing customer subscription services. This
module generates sales orders based on bespoke algorithm. This module generates
40% of sales orders for EA Swiss.
§ Design
& development of RMA receipt/Subinventory transfer interface form based on
scanned item BarCodes.
§ Design
& development of Swiss Quick Order Entry Screen based on Swiss Pricing
Model using Order Interface
§ Design
& development of Mass Price Change and Mass SKU replacement process Open
Order Import tables.
§ Developed
ECommerce solution/interface for importing sales orders from the Internet.
§ Customised
the Check Printing report in Oracle Payables, also performed the payment format
setups.
September 1999 – October 1999
10.7 to Release 11.03 re-implementation for EA
France
§ Extensive
customisation of PO Print report, AR Invoice report displaying discount info on
French regulations.
§ Developed
RMA Receipts import process for the French warehouse legacy system.
June 1999 – September 1999
Release 11.02 implementation for EA Spain
§ Customised
Commercial Invoice, Onhand quantity report, Available quantities report, and
various other reports.
§ Customization
of standard RMA form, so as to perform quick RMA receipts online from RMA
screen in Order Entry. The standard pricing user exit was bypassed by custom
code as per Spanish pricing requirements.
§ Designed
& developed interfaces for electronic processing of sales order and AR
invoices for ECI customer. Error correction/mapping screens were developed as
well. ECI is responsible for 50% of EA Spain business.
November 1998 – May 1999
Release 11.02 implementation for EA Germany
§
Designed & developed mass sales order creation form using a matrix combination of
ship-to-sites, SKU & quantities. Using
this form 100 orders could be created in 20 minutes which by normal
process took 5hrs.
This process also
provided reservation swap process using the Demand Interface.
§ Designed
and developed mass order cancellation form based on standard cancel orders
form. Open orders could be cancelled on following parameters :: Item,
Customer/Site, Backlog option, Aging of line. Sales staff, which usually spent
hours on cancelling these orders, could now do it within 2minutes using this
form.
§ Developed
Quick Order Entry screen along with displaying backlog, available, site backlog
quantities.
§ Developed
SKU enquiry screen to query onhand, available, pick released quantity, backlog
quantity.
§ Developed
report to print expected future customer credits in bucket type format.
§
Automated the Intrastat
processing. Manual intrastat process involved a staff member in each warehouse
manually recording the transactions. This module could be run to create all
these transactions automatically.
§ Performed
EDI setup & developed bespoke triggers to import orders via EDI from a big
German customer.
March 1998 – October 1999
10.6 Character to 10.7 Character upgrade for EA
§ Imported
open AP invoices from 10.6 to 10.7 using the standard AP Invoice interface.
§ Developed
cargo link process to extract shipment information and ftp file to Cargo
Company which did shipments for Nordic warehouses. Also processed the return
file from cargo to update waybill information
§ Rewrote
program “Copy SKU costs across organizations” to overcome its various
limitations.
§
Customised AR Invoice, added
the consolidated invoicing feature, printed backlog quantities.
§ Certain
SKU quantities were transferred and their demands transferred using
transactions/demand interface.
§ Tuned
various SQL programs, reports, forms, views without affecting the business
purpose of the processes.
§ Customised
following reports Pick release, Sales order acknowledgement, Backlog report,
Backorder report, Open return report, Commercial invoice, Available quantity,
Negative onhand quantity report.
§ Designed
and developed various GL reports so as to upload data into excel to simulate
the intercompany transactions in 10.6. These included Shipments, PO/RMA
receipts, interorg transactions posted to GL.
§ Developed
various alerts like PO’s to be approved, high value
§ Provided
support in various functional and technical aspects of Oracle Applications.
This included support for Transactions Interface, Shipment Interface, Costing,
receivables interface, order interface.
5) December 1997- March 1998.
As
an Application Consultant, involved in the implementation and customization of
Oracle Applications for Mascot Systems. I was extensively involved in set-up
and customisation of Oracle Order Entry, Purchasing and Inventory.
RESPONSIBILITIES:
Discussion
with the client regarding the proposed solution and design for customization
and the migration strategy. Preparation of Setup Documents, Design Document
& Test cases.
Oracle Inventory:
Documented
setup of Organization structure, UOM conversions, item templates, item
catalogs, item categories and item category sets, Transaction types/source, ATP
rules, Planning using minmax planning & re-order point planning.
§ Developed
item interface to transfer item information from the legacy system into Oracle
Applications.
§ Developed Replenishment Interface in Oracle Inventory
based on data sent from warehouse in flat file.
Oracle Order Entry:
Documented
set up of Order cycles, order types, holds, payment terms, navigation
preferences Holds, Shipping information, Credit check rules, Standard value
rule sets, payment terms and Discount, Customer profiles/classes.
§ Uploaded
price lists into Oracle from the flat file. A form was developed to
show/correct the exceptions.
§ Customized
Order Confirmation report, Outstanding orders report & pick slip report.
Oracle Purchasing:
Involved
in the set up of Purchasing option, Receiving option, Position hierarchies,
Approval Hierarchies, control groups, Approved Suppliers List, line types,
transaction reasons, standard notes, Autosourcing rules.
§ Developed
an interface program to transfer the open requisitions from legacy system to
Oracle Applications.
§ Developed
a vendor rating report based on Lead-Time, Price, Payment terms, Inspection
results, Past record.
6) July 1997 - Dec 1997
Performed
analysis and development of Manufacturing Automation system for Matshushita-Japan. This project
involved manufacturing solution, production planning, forecasting, cost
management, shipment and order management.
§ Developed
a Complex Order Entry Screen, Shipment direction screen, shipment dispatch
document report.
7) Feb 1997 - July 1997.
As
an Analyst Programmer, was invloved in analysis and design of fully automated
foriegn allowance system.
§ Used
Designer 2000 to reverse engineer schema and generate Entity-Relationship
diagrams.
§ Generated
prototype screens by using Oracle Forms Generate utility of Designer 2000 and
developed reports.
8) May 1996- Feb 1997.
As
a programmer, developed and tested Retailing System for one of the largest
Singapore Retail Company (CK Tang).
§ Developed
screens for purchase order management that interfaces with inventory mgmt &
various sales reports.
9) June 1995- April 1996.
As
a programmer, was involved in development of financial accounting package for a
Boston Management Consultancy. This software includes maintenance of purchase book, ledger book, cash book, Bank
receipt book, Bank payment book.
Seminars on 11i and 12i development best practices and
OA Framework Training
Anil
Passi delivered best practices development seminars with Oracle Corp covering
all technologies in 11i & R12.
Seminar
topics cover all the current and future technologies like BPEL, ODI etc
Anil has also delivered training on OA Framework to oracle University with over
97% delivery scores.
www.oracle.com/global/dk/education/eblast/dk_anilpassi_250908_ol.html