SARFARAZ AHMED

PROFILE SUMMARY

 15+ years of experience in Oracle Applications Technical, and PL/SQL Programming.

 Expertise in Data Conversions, Data Migrations, Interfaces in EBS R12.
 Expertise in XML Publisher, D2K Forms, D2K Reports, Form Personalization, Extensions.
 Expertise in Oracle Workflow, Oracle Application Framework and Oracle Development Framework
 Worked on modules PO, INV, AP, AR, OM, Payments, Core HR,SSHR, Payroll and Oracle Projects.
 Good exposure on technical design documentation using AIM and OUM methodology.
 Ability to co-operatively work with teams to achieve goals.
 Having more than 10 Years’ experience in working on R12.
 Good Exposure to Agile methodology and Scrum calls

EDUCATION

 Bachelor Computer Science from University of Pune.

EMPLOYMENT HISTORY
 Sorbonne University - Contractor(Oct'19 - till date)
 Zenith Soft Pvt limited (Mar'17 - Mar'19)
 GoldLine Technologies (Aug'15 - Dec' 16)
 Hexaware Technologies (Feb'13 - Oct' 14)
 Velocity Technologies Pvt. Limited (Jun'11 - Feb' 13)
 Jade Global Pvt. Limited (Oct'09 - Jun' 11)
 System Plus Solutions (June '07 - Sep' 09)
 Fujitsu Consulting (Jan'07 - May' 07)
 System Plus Solutions (Jun'06 - Jan' 07)
 SSPL Technologies (Feb'04 - Jun' 06)
TECHNOLOGY AND APPLICATIONS

Operating Systems: Windows NT Server 2005, Windows 2000/XP

Databases: Oracle, PL/SQL
Languages: C, C++ , Java
ERP Oracle EBS 11i, R12
Modules PO, AP, GL, INV, AR, OM, HR, SSHR, PAYROLL, PA
RDBMS Oracle 9i, 10g
Front End tool Form Builder 10g, JDEV 10G,Kintana, WINCVS, STAT
Reporting Tool Reports 10g, XML Publisher, D2K , Discoverer
Back End Tools SQL *Loader, SQL *PLUS, TOAD, SQL Developer

PROJECT DETAILS
Project 1: Production Support and Overview: -Working on Production Support and
Enhancement Enhancement Project

Client: Sorbonne University , Abu Dhabi 1. Involved in Customization of Oracle XML Reports.
Location: Abu Dhabi , UAE
Duration: Oct-2019 – Till Date 2. OAF Extension.

3. Setup SIT and EIT and customize the Workflow.

Project 2: Upgrade (R12.1.3 to 12.2.6) Roles:Sr. Technical Consultant
and support
Overview: -Stanford University Upgraded their Oracle
Client:Stanford University, Palo Alto Financial System from 12.1.3 to 12.2.6.
Location:Pune, India
Duration: Mar-2017 – Mar-2019

Involve in technical solution design meetings and Tech

Team meetings.

 Worked on AP / AR Interfaces.
 Involved in creating Several Solution design
documents.
 Converted Oracle Forms to ADF screens
 Worked on Lock BOX Interfaces.
 Worked on setup for Payments.
 Worked on form personalization on AR Receipt
forms.
 Worked on Payment / AP and AR Tickets.
 Worked on Item Interfaces.
 Worked on OAF Extensions.
 Worked on creation of several new OAF and
ADF Screens as per the requirement.
 Involved in Customization of Seeded Workflow.
 Involved in Custom Workflow Development.
 Involved in OAF Personalization and new
development of a custom page calling XML
reports on that.
 Involved in creating XML Bursting Report.
 Developed Outbound Interfaces.
 Worked on Payment Process Automation.
 Worked on Financials Production support.
 Worked on development of several Oracle
Financials reports.
 Worked on new development of AP Trial
balance report.
 Worked on customization of AR Account
Analysis Report.
 worked on oracle forms customization.

Project 3:(R12 EBS Support)

Roles:Sr. Technical Consultant
Client:Delta Dental, California
Location: Pune (India) Overview: - Delta Dental is Dental Insurance
Duration: Aug-2015 – Dec-2016 company, California

The project includes implementation of modules viz.

(OM, INV, GL, AP, AR).
 Responsibilities:
 Involve in technical solution design meetings
and Tech Team meetings.
 Worked on Item Interface.
 Worked on On hand quantity Interface.
 Worked on AR and AP Production Support.
 Involved in several form personalization in
oracle receipt form.
 Extended the OAF region View Object to meet
the business requirement.
 Developed several extracts using Oracle
UTL_FILE functionality.
 Developed several Procedures and Database
Triggers as per Business requirement.
 Extensive experience in XML/BI Publisher,
which included working on report development
objects like data templates and RTF’s.
 Registered the Templates and Data Definitions
using XML/BI Publisher Administrator
responsibility
 Proficient with the System administrator
responsibility, which included customizing the
menus, adding new concurrent requests,
request sets, registering the custom
applications etc. Created Request Groups for
reports.
 Registered user defined tables into applications
using AD_DD utility.
 Used FND_SUBMIT Pub to Submit Requests,
Request Sets.
 Worked with FND_PROGRAM package to
Register, Delete the Concurrent Programs from
the backend.
 Developed a PL/SQL program that is scheduled
to submit concurrent programs in a desired
sequence as per the functional document. Used
standard FND API’s.
 Extensively utilized the Application Object
Library to register SQL*Loader programs,
PL/SQL packages and procedures, forms and
reports.
 Developed SQL*Loader scripts to load data into
staging tables.
 Modified Privileges for Users using System
Administration responsibility depending upon
various Organizations.
 Worked with Application Object Library
(Defined executable, programs, linked with
responsibilities, defined DFF and value sets).

Project 4: Toshiba (R12 EBS

Implementation / Support) Roles: Technical Lead

Client: Toshiba, UAE Overview: - Toshiba Power, Abu Dhabi

Location: India / UAE
Duration: Feb-2013 – Oct-2014 The project includes implementation of modules viz.
(Core HR , SSHR , I-Recruitment , Payroll).

Responsibilities:
 Worked with Application Object Library
(Defined executable, programs, linked with
responsibilities, defined DFF and value sets).
 Worked on EIT Setup
 Worked on SIT Setup
 Involved in creating Document Upload OAF
Page.
 Involved in Automating User Creation once the
employee gets created.
 Worked on Employee Migration / Interface
 Worked on Assignment Migration / Interface
 Worked in generating bank file for payments.
 Worked on XML Publisher reports.
 Involved in making custom pay slip reports
using OAF Page.
 Managed the team of 3 people

Project 5: WESCO (R12 EBS Implementation

/ Support) Roles: Technical Lead

Client: WESCO, Pittsburgh , US Overview: - WESCO, Pittsburgh

Location: India / Pittsburgh , US
Duration: Jun-2011 – Feb-2013 The project includes implementation of modules viz.
(Core HR , SSHR , I-Recruitment , Talent Management
, Succession Planning).

Responsibilities:
 Worked on Core HR, SSHR and I-Recruitment
Functional Support and technical development.
 Involved on raising and monitoring oracle SR for
standard functionality breaks.
 Unit testing of all programs before QA Test.
 Preparing User Training Document and Test
Documents.
 Given training to HR- Managers/ Supervisors for
Oracle I recruitment, Core HR and SSHR.
 Worked on I-Recruitment to Monster Job Portal
Interface for Job Posting/Deleting/Updating on R12
using SOAP Protocols.
 Worked on system extracts to generate file of the
employee information change.
 Worked on customization of SSHR Workflow to
meet the business requirement.
 Worked on I-Recruitment Page extension and
Personalization.
 Involved in Customization of Seeded Workflow.
 Involved in Custom Workflow Development.
 Involved in OAF Personalization and new
development of a custom page calling XML reports
 on that.
 Involved in creating XML Bursting Report.
 Developed Outbound Interfaces.
 Given Functional Support on Core HR, SSHR, I-
Recruitment and Succession Planning.
 Developed a Custom Module Leadership
Organization Review using OAF to meet the
Business Requirement to provide more security
and visibility then Succession Planning.
 Solved many critical Functional and Technical
issues related to Performance Management, I-
Recruitment and SSHR.
 Customized the Succession Planning page to meet
the Business Requirement.
 Extended the OAF region View Object to meet the
business requirement.
 Developed several extracts using Oracle UTL_FILE
functionality.
 Developed several Procedures and Database
Triggers as per Business requirement.
 Extensive experience in XML/BI Publisher, which
included working on report development objects
like data templates and RTF’s.
 Registered the Templates and Data Definitions
using XML/BI Publisher Administrator responsibility
 Proficient with the System administrator
responsibility, which included customizing the
menus, adding new concurrent requests, request
sets, registering the custom applications etc.
Created Request Groups for reports.
 Registered user defined tables into applications
using AD_DD utility.
 Used FND_SUBMIT Pub to Submit Requests,
Request Sets.
 Worked with FND_PROGRAM package to Register,
Delete the Concurrent Programs from the backend.
 Developed a PL/SQL program that is scheduled to
submit concurrent programs in a desired sequence
as per the functional document. Used standard
FND API’s.
 Extensively utilized the Application Object Library
to register SQL*Loader programs, PL/SQL
packages and procedures, forms and reports.
 Developed SQL*Loader scripts to load data into
staging tables.
 Modified Privileges for Users using System
Administration responsibility depending upon
various Organizations.
 Worked with Application Object Library (Defined
executable, programs, linked with responsibilities,
defined DFF and value sets).

Project 6: Twitter Inc. (R12 EBS

Roles: Technical Lead
Implementation) Overview: - Twitter, US

Client: Twitter, US The project includes implementation of modules viz.

Location: India (PO , AP , AR , GL ).
Duration: Jun-2010 – Jun-2011

Responsibilities:
 Involved in customization of PO Approval
Workflow.
 Involved in customization of REQ Approval
Workflow.
 Involved in the development of AP Invoice
Interface.
 Making MD-70, MD-120 Documents.
 Involved in creating several AP / AR XML
Publisher reports
 Worked on OAF Extension for customer 360
page.
 Worked on the new development of OAF Page
to meet the business requirement.

Project 7: SSN (R12 EBS Implementation) Roles: Sr. Technical Consultant/Team Lead

Client: Silver Spring Networks, US Overview: -SSN is a Chip Manufacturing company

Location: India / San-Jose, US based in California.
Duration: Oct-2009 – Jun-2010
The project includes implementation of modules viz.
(OM, INV, GL, AP, AR, PA).

Responsibilities:

 Technical Lead for Order Management module.

Tracking all OM custom components, Involve in
technical solution design meetings and Tech
Team meetings.
 Data Conversion for Item and Price Lists.
 Developing Custom Forms & Programs based
on business requirements.
 Technical, Unit Test and Installation
documentation for custom components.
 Designing Custom PLSQL Packages/Functions
as per business requirements.
 Worked on creating OAF Screen and ADF
Screens to meet the business requirement.

Project 8:PepsiCo - Europe

(Implementation / Support). Roles: Sr. Technical Consultant/Team Lead

Client: Pepsi Co International / Walkers- UK Overview: -Implemented Oracle EBS-11i for Pepsico-
Location:Pune (India) Belgium,Poland, Russia, Barcelona,Portugal, UK
Duration: Jun-2007 – Sep-2009 For modules AP, AR, INV, GL, INV, PO, OM , OPM.

Responsibilities:
 Managing Team and assigning tasks to the
team.
 Resolving escalated issues which are critical to
business.
 Interactions with the customer.
 Involved in daily or weekly meetings with
business about status updates or any escalated
issues.
 Fixing defects in the application and providing
possible workaround.
 Involved in development and customization of
oracle Report (XML, Discoverer, report6i)
according to each subsidiaryrequirement.
 Worked on customizing interfaces, conversions,
EDI issues.
 Making MD-70, MD-120 Documents.
 Raising SR to move the code from development
instance to Test instance and on Production.
 Unit testing of all programs before QA Test.
 Developed PL/SQL packages, procedures,
functions, XML-xsl, XML-rtf to meet the
business requirement.
 Used FND_SUBMIT Pub to Submit Requests,
Request Sets.
 Worked with FND_PROGRAM package to
Register, Delete the Concurrent Programs from
the backend.
 Developed a PL/SQL program that is scheduled
to submit concurrent programs in a desired
sequence as per the functional document. Used
standard FND API’s.
 Extensively utilized the Application Object
Library to register SQL*Loader programs,
PL/SQL packages and procedures, forms and
reports.
 Developed SQL*Loader scripts to load data into
staging tables.
 Modified Privileges for Users using System
Administration responsibility depending upon
various Organizations.
 Worked with Application Object Library
(Defined executable, programs, linked with
responsibilities, defined DFF and value sets).

Project 9: LG(Implementation) Roles: EAM Technical Consultant

Client:LG Electronics Overview: -

Location:Pune (India) LG Electronics implemented all SCM Modules Using

Duration: Feb-2004- Jun-2006 EBS (11.5.10)

Responsibilities:
 Making MD-70, MD-120 Documents.
 Implementing AP invoices Interfaces.
 Involved in making a custom module “Freight”.
 Giving technical as well as functional support to
users on shipping track.
 Looked after the barcode issues.
 Unit testing of all programs before QA Test.
 Involved in development and customization of
oracle Forms, reports.
 Involve in making pl-sql reports.