Oracle Project
Resume:
Divakar Jakkani
abkaku@r.postjobfree.com
Over 16 years of IT experience with more than 12 years in Oracle
Financials, Distribution, Manufacturing and HR as Sr. Technical Consultant.
Skilled in Application fit/gap Analysis, Process reengineering, System
Integration, Design, Development, extension, conversion and Implementation
of Oracle Application Modules using AIM and GE Six sigma methodology.
SKILLS
Applications: Oracle Financials and Manufacturing 10.6 SC/10.7/11 GUI, 11i
and R12. Oracle HRMS 11. Primary modules include - Public Sector
Receivables, Purchasing, SSP5 (iProcurement), ISP (Internet Supplier
Portal), Oracle Approval Management (AME), iExpense, Oracle Sourcing, AP,
GL, OE, BOM, Eng, XML gateway and EDI Gateway.
Tools: Oracle Jdeveloper 6i, XML Publisher, BPA, Oracle Developer 2000
(Forms 4.5/6i and Reports 2.5/6i), SQL*Loader, Oracle workflow builder
2.6/2.5/2.0, Oracle Discoverer 4i, XML Gateway message designer, Clear
Case, PVCS (Version Control), Kintana (Code migration and service
requests), Peregrine's service center and Fax commander (Third party fax
solution) and Appworx, DataLoader (for setup and data conversion), TOAD and
Hummingbird.
Operating Systems: RedHat Linux 3.0, Netware 4.1, HP-UX 9.x, Sun Solaris,
MS-Windows 3.11, Windows 95, Windows NT 4.0, Windows 2000 and DOS 6.22
Languages: C, Java, SQL, PL/SQL and Assembly Language (8086)
Middleware: Apache, OC4J and Weblogic 7.1
RDBMS: Oracle 7.3/8i/9i/10g
Business Areas: Finance, Insurance, Telecommunications, Automobile
Industry, Defense and Public sector.
EDUCATION
BE (Bachelor of Engineering) in Electronics and Communication, Osmania
University, Hyderabad, India
PROFESSIONAL TRAINING
GE Six Sigma Methodology Trained.
Trained with Sabrix Tax Engine for Oracle AP Connection implementation
WORK EXPERIENCE
New York State Department of Environmental Conservation, NY
December 07 - September 2010
Senior Technical Applications Lead
. Design and development of Invoice change automation using Receivables
APIs and open interface. This extension will reduce the manual work and
improve the accuracy of invoice modifications.
. Worked on the CAS Inbound (GL Inbound) from NY OSC (NY State office of
state Comptroller) Reconciliation Program on tuning and bug fixing.
. Worked on custom reports of NY State Oil Spill reports to customers using
XML publisher 5.6.3.
. Involved in design and development of custom interest and penalty
application for invoices.
. Setting up AME rule to meet Expense Approvals. Worked on the
customization and post upgrade fixes on the iExpense workflow.
. Worked on project plan, design and development to convert the revenue
invoices and customers from custom application into Oracle public sector
receivables to retire the custom application.
. Involved in design and development of custom solution to interface
customers and invoices from various DEC regulatory fee billing
departments (9 departments) into Oracle public sector receivables. This
interface has produced about 30k invoices for 30k customers worth USD 80
Millions in 3 years.
. Designed and developed Invoice Printing using BPA (Bill Presentment
Architecture)
. Designed and developed Custom Dunning Process and Printing using BPA.
Developed scripts to move BPA templates between instances (oracle has
this in enhancement). Created script to support duplex printing where the
new invoice will always start on an odd page.
. MD70 document preparation.
BAE Systems
February 07- November 07
Senior Oracle Applications Lead
. Design and develop Legacy to Oracle Conversions - Fixed Assets and
Customers
. Requirements gathering, gap analysis and preparing Technical design
documentation for the following interfaces
o Peoplesoft to Oracle HR. Built a HR repository in Oracle that can
be used by many third party apps.
o Peoplesoft to Autotime employees (KABA software's Time and Labor
application used Primarily in Manufacturing)
o Oracle Bill of Materials and Purchasing to Propricer (Proposal
application)
o Oracle and Autotime to Hyperion for actual to planned expenditure
reporting.
o Peoplesoft employee rate to Oracle GL for Allocation.
o General Ledger balances interface from legacy system.
. Customization of Oracle PO approval Workflow, Requisition workflow and
expense workflow for business requirements.
. Involved in Procuring Bar code app and designed and developed 'Receipt
traveler' report with Bar codes using XML Publisher.
. Developed process and automation to move XML publisher objects.
. Wrote the MD70 document for all projects and took KT session to support
and development teams when development rolled into Production.
General Electric
December 01 - February 07
Senior Oracle Applications Lead
. Hands on experience with implementing Procure-to-Pay (P2P) (iProcurement,
Purchasing, payables and GL) solution in an over 200 operating units
installation.
. Lead SOX (Sarbanes Oxley) compliance documentation for Tax application
and developed and oversaw the Disaster recovery plan.
. Lead technical to implement Tax solution for Oracle AP by integrating the
Sabrix Tax engine (Third Party software) for US Sales/Use Tax and VAT.
. Installation of Sabrix AP connector on Oracle ERP.
. Lead and developed Custom VAT (Value added Tax) solution for Europe as
interim solution to be replaced with Sabrix Tax engine.
. Implemented Oracle Tax Reporting Ledger (TRL) to integrate AP Tax Data
with Custom Tax warehouse to enable Tax reporting and reconciling.
. Lead the project vPayment for integrating GE Master Card with AP System
for Payments.
. Experienced in implementing 170 Systems (workflow based application using
images) to work with Oracle Payables in a Procure to Pay environment with
multiple Operating Units to automate Vendor Management and Invoice
approval process.
. Worked with GE Vendor Master File interface to Oracle Purchasing Vendors.
. Lead the project and implemented Oracle XML Gateway for PO XML outbound
and Invoice inbound. Rolled out for multiple GE businesses and multiple
GE vendors.
. Setup Oracle Approval Management (AME Rules) for Invoice Approval.
. Developed new custom workflow process to approve Invoices through ISP and
Customized the vendor registration Process for ISP.
. Customized ISP screens to meet business specific needs that are achieved
by oracle personalization.
. Lead the project to build extension to Oracle iProcurement One time ship
to address.
. Implemented iProcurement Punchout Technology for multiple businesses and
suppliers.
. Lead the project Repeat Pay with Offshore development. This project has a
custom screen developed in SSP5 (iProcurement) to create a requisition
for lease type of Pos. A single Master card is acquired online through PO
Approval workflow process for this PO and sent out in PO Print.
. Designed and developed Check Request Application to enable the urgent
payment that initiates the Check request from iProcurement Requisition
creation Process using a custom built SSP5 screen using custom servlets
to capture the information required to make a payment.
. FPG (Family Pack G) upgrade project. GE is moved from 11.5.3 to 11.5.6 of
iProcurement. As part of the upgrade the existing functionality like
iProcurement functionality, PO prints, EDI, Custom AK regions, Workflow
upgrade (2.6) and interfaces have to be tested and new functionality has
to be understood and evaluated.
. New MAPS for EDI 850, 860 and 832 are completely modified through the
upgraded process. Worked on MAPS to fix them manually. Tested end to end
with vendors.
. Upgraded the workflows with the seeded workflows coming with the upgrade.
Modified and tested the workflows.
. Load test for performance evaluation: conducted the load test on current
version of the application instance. Created test scenarios, complete
test scripts and required application set up. Conducted the Load test
with the help of APC (Application performance Center). Captured the
results and compiled the Load test results. Used this as the baseline for
Upgrade.
. Lead the PO Viewer Project. This Project enables the SSP5 Business users
to query the Pos/Releases through Oracle Flow Pages (AK Developer)
interface based on the search criteria and view the Pos/Releases in PDF
format online. Security is built based on Org, Buyer and Requestor level.
. Enhanced the PO Viewer application to drill down to Invoices from
PO/Release/shipment lines.
. Used Oracle APIs to build Projects Inbound Interface and HR inbound
interface.
. Rolled Out DELL XML PO Project. This Project involves understanding,
designing, developing, implementing and testing the transmission of PO in
XML format to DELL. cXML map is used to create the PO in XML format.
. Project involves implementing the eP-Card for GE businesses. ePcard
addresses an electronic settlement solution for Oracle Self service
Procurement (SSP5) Systems using GE Card Services Procurement Cards (P-
cards).
. As Part of GE sigma process, created MD200 (combining MD50 and MD70) with
functional analyst, Code move documentation for code migration and
support document for production control. And also KT sessions to
production support team and development team when the project goes live.
Sycamore Networks, Inc.
March 01 - November 01
Senior Oracle Applications Consultant
. Oracle Financials/Manufacturing
. Lead the project to reengineer an interface to Contract Manufacturer for
Order Management. Eliminated the need to change code to add/drop any
number of manufacturers instantly.
. Co-ordination with the Order Entry Team in upgrade process of Order Entry
(11) to Order Management (11i). Identified and evaluated the impact of
11i on the existing custom processes (Reports, forms, Interfaces and
other customizations).
. Sales acknowledgement report, Commercial Invoice, Backlog Extract,
Bookings Extract, Shipping Extract, Sales Forecast (Web Report), Sales
Forecast Extract (Web Report), Shipper's Export Document (SED).
. Developed UNIX shell scripts for Automatic uploading/downloading files
using ftp. And automatically route emails with the output/error messages
to the requestor.
. Developed inbound interface to GL from custom application.
. Developed Detail report to view the journals that are posted to the GL.
. Co-ordination with the DBA group to implement and test Reports 6i server.
Also studied and documented the Web Reporting Architecture for Oracle Web
reporting for Self service applications.
. Closely Involved in finalizing on the documentation based on the standard
AIM documents.
Arvinmeritor, Inc
March 00 - February 01
Oracle Applications Consultant
. Developed a PL/SQL procedure to explode the BOM using 11i BOM API to
create an alternative single level BOM to bring only certain items.
. Customized BOM explosion Form in Forms 6i. Implemented Tabbed Canvas
feature and also folder technology. The application coding standards are
followed.
. Lead the Project in Oracle Engineering to develop new workflow processes
using Oracle Workflow Builder 2.5. Developed new ECO (Engineering Change
Order) Approval Workflow process to follow the hierarchical Approval list
similar to Purchasing.
. Involved in data conversion from legacy system to Oracle Applications.
Specifically in AP (Accounts Payables), AR (Accounts Receivables) and GL
Balances Conversion.
. Developed interface to Custom check printing software from AP (Accounts
Payables). Interface to AR (Accounts Receivables) from custom/legacy
Warranty software.
. MD70 documentation for each customization and development.
Eaton Corporation
March 99 - February 00
Oracle Applications Consultant
. Responsible for studying the Feasibility and estimating the hours for the
reports and Oracle objects. Maintaining the status of the reports and
reporting the same to the team lead on regular basis. Interacting with
the user for finalizing specifications.
. Converted the data from legacy system into Custom module, Core Bank in
Oracle Application. Developed several new reports similar to the legacy
reports. As part of the post production, wrote and modified several new
PL/SQL procedures and modified Forms.
. Developed postscript reports in Order Entry. Pickslip Report, Packslip
Report and Bill of lading report customization. Commercial Invoice
Customization. Order Detail report with barcodes.
. Developed postscript reports in AR (Invoice, Credit memo and Debit Memo)
to user specification.
. Developed new and customized the Oracle reports with duplex styles and
barcodes and PL/SQL programs in OE, INV, BOM and MRP.
. MD70 documentation for each customization and development.
Sentrol, Inc.
November 98 - February 99
Oracle Applications Consultant
. Developed new reports in OE, PO and Oracle Service modules and customized
many Forms in AR, OSM and Oracle Service are modified as per the
requirement.
. Developed Printer drivers for Dot matrix printers for printing the
reports in the pre printed papers.
. MD70 documentation for each customization and development.
Tektronix, Inc.
July 98 - October 98
Oracle Applications consultant
. Involved in merging several application instances into one. This involved
studying the commonality and differences of all the custom programs to
eliminate and merge- forms, reports, pl/sql objects, proC and SQL plus
programs. Made Y2K compliant.
. Created documents to enlist all the redundant objects using modified MD70
document.
Nike
March 98 - June 98
Oracle Applications Consultant
. Development, coordinating with lead for functional and technical aspects
and Co ordination with end user. This is an upgrade project from 9.4 to
10.7.
. Upgrading involves incorporating custom modifications into 10.7 and
eliminating redundant programs (merging programs).
. Involved in upgrading SQL Reports from 9.4 to Reports 2.5 in 10.7.
Porting SQL plus programs from 9.4 to 10.7. Programming for Y2K
compliance. Tuning for performance.
. Writing new reports in Reports 2.5 using PL/SQL and SQL Plus.
. System administration and AOL.
. Creating printer drivers for reports to print into preprinted formats.
. MD70 documentation for each customization and development.
ABR (Applied Benefits Research)
July 97 - February 98
Lead Programmer/Analyst
. Finalized report requirements and design and developed Life insurance
remittance reports insurance companies like Aetna and Blue Cross Blue
shield using Oracle Report designer 2.5.
Contact this candidate