Gokulakannan Balakrishnan
Lead Technical Consultant
+91 7032411824
gokul8303@yahoo.co.in
EXECUTIVE SUMMARY
Around 1.5 years of experience in Oracle Fusion Cloud Consultant with Supporting based projects
related to Oracle Fusion cloud applications
Around 13+ years of extensive Oracle Technical E-Business Suite experience in Financials and SCM
in Implementation, Customization, Interface Design,Reports Development,OAF page development.
Technically strong in SQL, PL/SQL,Procedures, Packages, Functions,Triggers, Bulk Collect, Reports
10G, XML Publisher, Interfaces, Oracle forms, OAF,Workflow.
Oracle Certified Professional (OCP) in Oracle 9i SQL/PLSQL.
Good Knowledge on functional flows, Tables and Relationships of PO, AP, GL, AR, OM, WIP and BOM
Experience in Procure to Pay and Order to Cash Life Cycles.
Well versed in design, development and Customization of OAF pages.
Well versed in design, development and Customization of different Oracle reports.
Been a Part of R12 Implementation and Migration Team.
Have good Experience in Oracle Workflow.
Prepared Technical Documents (TDD) based on based on the requirements provided by the
Functional Team
Involved in providing Post production implementation support.
Professional Experience:
Organization Role/Designation Duration (in Years)
Wipro Technical Production Support Nov 2022 to till Date
Sutherland Global Technical Production support 8 Months
M&S Consulting Lead Consultant 3 years
Enrich IT/Dataintensity Oracle apps Senior Technical 5 years
Consultant
Tube Investments of India Ltd., Chennai Oracle apps Technical consultant 5 Years
Tube Products of India,Avadi,Chennai. Oracle PL/SQL Developer 2.5 years
Overall experience - 15 years
Functional and Technical Skills:
Oracle Fusion Cloud Inventory, Procurement, Costing, Product Data Hub/PLM
Inventory, Accounts Receivables, Accounts Payables,General Ledger,Order
Oracle ERP Applications
Management, Purchasing, System Administration.
Application Versions 11i & R12 and BI Apps
BI Publisher, PL/SQL Developer, Oracle SQL Developer, SQL*Plus,
Tools SQL*Loader, DataLoad, FNDLOAD, Oracle Forms, JDeveloper,TKPROF, SVN
and TOAD,Service Now,FBDI Import template
Languages Oracle SQL, PL/SQL and Java
Oracle Project Experience:
Type of Project Number of Clients Years of Experience
End to End Implementation 2 3 Years
Implementation Support 4 5 years
Enhancement Support 1 2.5 years
Oracle Projects Profile:
Project #1 Wipro
Customer Cisco Systems Inc
Period Jun2024 – Till Date
Role Technical Lead
Modules Oraacle Fusion Cloud Inventory,Procurement,Product Data Hub/PLM
Description
Responsibilitie Involved in various setup related activities related to Inventory and Procurement
s like Transfer order and approval related transactions
Worked on various Inventory related process like Account alias issue,receipt,cycle
count etc.
Worked on various Item related setup activities in PDH module like Serial or lot
control changes, Item attribute changes etc.
Worked on FBDI templates in resolving multiple issues related to Inventory issues
like COO correction etc.
Participated in the Period-end/Month-end closing activities, ensuring accurate and
timely financial reporting
Analyzing the issues for incidents raised by the business end-users in ticketing tool
on Inventory, Procurement and PDH modules.
Performing shipping reconciliation between Order management and WMS.
Providing timely resolution of the issues and long-term functional solutions in order
to reduce incidents and enhancing business processes.
Did few Roles provisioning in Access Management module.
SOAK testing/Regression testing to test new features of upcoming latest releases
with available test scenarios.
Smoke testing to support various other integrated upstream/downstream
applications.
Project #2 Wipro
Customer Enhance Group - Oman
Period Jan2024 – May 2024
Role Technical Lead
Modules Oracle EBS R12.2.6 – SCM,Finance,Inventory,GL,WIP
Description As the FMCG and Retail Business cluster of the WJ Towell Group, Enhance is the
leading provider of Brand Distribution and Retail Management Solutions in Oman
with expanding management responsibilities in other GCC Markets.
Responsibilitie Worked on Various API related enhancements and Modifications
s Worked on OAF page changes and OAF Personalizations.
Worked on Various Process related enhancements through Procedures and
Packages
Worked on Creating new Reports and modifying existing reports
Address few performance tuning related issues and got appreciation as well
Develop RICEW components as per business requirements
Worked on defects and enhancements.
Development of new concurrent programs and BI reports.
Attending status meetings daily with the client.
Project #3 Wipro
Customer Panasonic
Period Nov'22 – Till Date
Role Technical Lead
Modules Oracle EBS R12.1.3 – SCM,Finance,WIP
Description Panasonic Holdings Corporation[a] is a Japanese multinational electronics company,
headquartered in Kadoma, Osaka. It was founded in 1918 as Matsushita Electric
Housewares Manufacturing Works[b] in Fukushima, Osaka by Kōnosuke Matsushita.
In 1935, it was incorporated and renamed Matsushita Electric Industrial Co., Ltd.
[c] In 2008, it changed its name to Panasonic Corporation[d
Responsibilitie Worked on Workflow related Changes.
s Addressing performance tuning related issues.
Retro-fitment of custom packages/Development of new code as per business
requirements
Develop RICEW components as per business requirements
Worked on O2C and P2P cycles
Developed Test documents
Resolved UAT defects.
Raised SRs in Oracle .
Working on defects and enhancements.
Attending status meetings daily with the client.
Project #4 M&S Consulting
Customer Carnegie Learning
Period Apr'21 – Till Date
Role Senior Technical Finance Consultant
Modules Oracle EBS R12.1.3 – Payables,Receivables.
Description Carnegie Learning, Inc. is a provider of online education solutions and services for
math, literacy and ELA, world languages, and applied sciences. Carnegie Learning,
Inc. is located in the Union Trust Building in Pittsburgh, PA.
Responsibilitie Created ACH Template(US NACHA IAT Format) for Canadian
s Organization and included the necessary fields like Payee Bank
Account Number,Payee Bank Branch number,Payment amount,Payee
Address,Payee Legal entity name,Payee City,Country,Postal code and
Supplier Bank account number.
Created Check Template in RTF format for Canadian Organization
and included the necessary fields like Entity Name and Address,Bank
Name and address,Check number,Payment Date,Payment Amount
Value, Payment Amount Value(In words),Payee Name,Vendor Name,
Vendor Number,Check Date,Invoice Number,Invoice Date,Invoice
Amount,Invoice Description.
Project #5 M&S Consulting
Customer Modcloth
Period Aug'18 – Till Date
Role Senior Technical Finance/SCM Consultant
Modules Oracle EBS R12.1.3 – Inventory,Purchasing,Payables,Receivables,General Ledger.
Description ModCloth is an American online retailer of indie and vintage-inspired women’s
clothing.The company is headquartered in San Francisco with an office in Los
Angeles and a joint office/fulfillment center in Pittsburgh.
Responsibilitie Modified the custom Regular invoice program to process Global-e
s invoices and CreditMemo separately from regular OMS invoices/CMs.
Involved in modification of Invoice process program to eliminate
COGS missing channel and area and finally fixed the variance
Involved in modification of various reconciliation report in finance to
add columns and also bug fixes.
Developed a new XML Publisher report for capturing Sales data items
and also for capturing revenue information for PID’S which are sold at
a particular Date range which can be reported to the Royalty
partners on a periodic basis based on GL Accounting date.
Involved in development of numerous XML publisher reports using
Data templates and RDF.
Developed Reports that can be exported into CSV format/Excel
format.
Performance Tuning done for a custom Inventory Adjustments
concurrent program which was running for more than 20 minutes and
after tuning,performance have significantly improved and the custom
concurrent is now getting completed in less than 2 mins.
Included Sub inventory transfer in a custom concurrent program for
transferring quantities from one subinventory to another
subinventory.
Created a custom Process or a concurrent program to update Vendor
Remittance email information for ACH
Created functional setups of Procure to Pay cycle like Setup of
Suppliers, Purchasing, Receiving and Financial options
Created custom Responsibility, custom Menu & functions, and
defined User.
Project #6 OAF Personalizations/Extensions for Essilor
Customer Essilor
Period Jun’18 – Aug'18
Role
Senior SCM Consultant
Modules Oracle EBS R12.2.3 – Isupplier portal
Description Essilor International S.A. is a French-based international ophthalmic optics
company that designs, manufactures and markets lenses to correct or protect
eyesight. Its headquarters is based in Charenton-le-Pont, France. Essilor is quoted
on the Euronext Paris Stock Exchange.
Responsibilities To remove multiple PO changes option and planning from orders tab in
Isupplier portal responsibility
Included various floater tip options in various tabs like Orders,Finance and
Admin tab in isupplier portal
Removed upload ASN from from shipments tab from isuuplier portal
Made Supplier Address non editable from Admin tab in Isupplier Portal.
Captured Essilor Contact name and contact email in the DFF fields which
are available in Isupplier portal.
Project #7 Managed services and support for Assurant
Customer Assurant
Period Oct’17 – Jun’18
Role Senior SCM Technical Consultant
Modules Oracle EBS R12.2.3 – Order Management,Inventory,Purchasing,Payables
Description Assurant, Inc. is a global provider of risk management products and service with
headquarters in New York City.Its businesses provide a diverse set of specialty,
niche-market insurance products in the property, casualty, extended device
protection, and preneed insurance sectors. The company’s three operating
segments are Global Housing, Global Lifestyle, and Global Preneed.
Global Lifestyle, which offers mobile device protection services and extended
service contracts for consumer electronics and appliances, vehicle protection
services, and credit and other insurance.
Responsibilitie Developed Accounts receivable interface to import data from Third party
s software to Oracle base tables for Receipts processing.
To provide maintenance and support for Assurant based applications
Handling Business related issues,analyze the reason and take necessary
action.Sending the shift handover on daily basis.
Clearing Transactions which are stuck in pending transactions.
Handling Subinventory transfer,Bulk Stock transfer and move order issues.
Handling report error issues and clearing invalid lines in Telnet applications.
Handled Ecommerce orders fail to hit Oracle,Item code change issues.
Developed OAF based customized page for RMA Process for Receiving
Damaged Phone devices into receiving sub Inventory.This page has several
fields like IMEI number,ClaimID,Policy ID,SKU,Exception flag,Receiving sub
inventory code.This page also displays the order information as well as the
customer information for which the damaged IMEI belongs to.
Involved in providing on-going support
Project #8 Tail Spend Management-Mobile App integration with Oracle Applications (ERP).
Customer Goprocure
Period Jan’14 – Jun’17
Role Senior SCM Technical Consultant
Modules Oracle EBS R12.2.3 –Purchasing,Payables,iProcurement
Description GoProcure is looking to develop a system for Tail Spend Management (TSM) which
consists of a custom application on top of Oracle EBS 12.2.5 Procurement and
Payables Suite.
Responsibilitie Developed RFQ process through API’S and thereby integrating with Mobile
s application for sending Request for quotation to different suppliers to choose
a best Quote through mobile app.
Developed RFQ Report and RFQ Mail Publishing concurrent through which
RFQ Template would be send as an email attachment to different suppliers
through which suppliers would be quoting their prices to the Customer.
Developed a Payment invoice report to report the summary of all unpaid
supplier invoices for a given period and for a particular client.
Worked on various workflow component to address the business user
requirements.
Involved in providing Post production implementation support.
Project #9 TI Cycles – R12 Implementation and Enhancements.
Customer TI Cycles of India
Period Apr’10 – May’14
Role SCM/Finance Technical Consultant
Modules Oracle EBS R12.1.5 –Finance
Description R12 Implementation and Enhancements for TI cycles.
Responsibilities Inorder to ease the process of MRP for users,developed a Pegging report
which is used as a master report by sourcing users.All the details of
demand,supply and prerequisities are in a single report to be used which
enables the users to do Partial cancellation and full cancellation easily
during MRP process
Developed a Report in xml Publisher to track OTD based upon order date,
request date, promise date and scheduled shipment date for a
particular operating unit.
Developed a Report in PDF in order management that shows the list of all
the material that needs to be issued to subcontractors.
Developed a Query Form in OAF Inventory orgwise and Product Type Wise
to DisplaySubinventory,Product Type,Product Type Description,Inventory
Org.
Developed a Report in Work in process to bring about consolidation of 4
major reports as a single report to identify overall equipment efficiency,
performance efficiency and Quality rating for all manufacturing related
activities.
Developed a report in Advanced Supply Chain Planning to capture the
status and distribution details for all buy items.
Localization Tables have been Replaced by New Set of Tables During R12
Implementation
Developed a Report in Work in process to bring about consolidation of 4
major reports as a single report to identify overall equipment efficiency,
performance efficiency and Quality rating for all manufacturing related
activities.
Project #10 Production Support for Legacy system.
Customer Tube Products of India
Period Nov’06 – Apr’09
Role Apps Technical Consultant
Modules Legacy Systems
Description Production Support for Legacy system.
Responsibilitie Troubleshooting and fixing bugs in Inventory interface that is used to import
s on hand inventory for Finished Goods from legacy system to Oracle.
Troubleshooting and fixing bugs in Order Management interface that is used
to send sales order information from Oracle to legacy systems.
Monitoring and Maintaining Legacy Transactions on daily Basis.
Activities like taking backup for the day, week and Month.
Academics & Certification:
Qualification Qualification Year Subject
Category From To
Bachelor of Engineering (B.E) UG 2001 2005 Computer Science Engineering