Post Job Free

Resume

Sign in

Oracle Project

Location:
Suwanee, GA
Posted:
April 21, 2020

Contact this candidate

Resume:

Page * of *

Amit Behrani

Oracle ERP Cloud Consultant

adcwi9@r.postjobfree.com

678-***-****

Atlanta, GA

PROFILE SUMMARY

Experienced Oracle Specialist with 14+ years of Experience in System Analysis, Design, Development, Production Support, Customization and Implementation of business applications.

12 years’ Experience of Oracle EBS Financials Modules (GL, AP, AR, PO) and Oracle EBS Projects (PA) with unique blend of Techno-functional capabilities.

3 years’ Experience of Oracle ERP Cloud (Oracle Financial Cloud Modules & Oracle PPM Cloud).

Certified Implementation Specialist for Oracle Cloud PPM and Oracle E-Business Suite R12 Projects

Strong Implementation experience with 5 Oracle EBS Financial Implementations and 2 Oracle ERP Cloud Implementations

Oracle Cloud Expert in Application Security, BI Publisher, OTBI Reports, Financial Reporting and Conversions.

Successfully Lead Onsite and Off-shore Teams, Managed Projects and Managed Clients being onsite and Off-site.

Experienced in Full Life Cycle Oracle Implementation from Requirement Gathering, Fit-Gap Analysis, To-Be Process Designing, Solution Designing, Application Configuration, Security Configuration, Conversion, Integration, Reporting, User Training, SIT, UAT and Go Live.

Experience in Configuration, Security Setups and Design & Development of Application components (Interfaces, Conversions, Customizations and Reports) for Oracle ERP Cloud, Oracle EBS Financials & Projects modules.

Considerable Pre-Sales experience with Requirement gathering, Demo, RFP Analysis, POC, Proposals and Estimations.

Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions by utilizing business insights. SKILLS

Enviornments / RDBMS Oracle ERP Cloud R13(19D), Oracle Applications 11i / R12 Oracle ERP Cloud Financials, Applications Security, BI Publisher, OTBI, PPM Cloud (PFM) Oracle E-Business Suite(EBS) GL, AP, AR, GL, PO, XML/BI Publisher, OTL, PA(Project Costing, Project Billing) Languages C / C++, PL/SQL

Database Oracle 9i/10g/11g/12c

Reporting Tools Oracle Reports, Noetix Reports, Business Objects, Discoverer 10g, EiS eXpress CERTIFICATIONS

Oracle Project Portfolio Management Cloud 2018 Certified Implementation Specialist

Oracle Project Portfolio Management Cloud 2017 Certified Implementation Specialist

Oracle E-Business Suite R12 Project Certified Implementation Specialist

Oracle E-Business Suite R12: E-Business Essentials - for Financials Implementers

OCA (Oracle Certified Associate) in Developers’ Track. AWARDS & ACHIVEMENTS

Capgemini Individual Excellence Award for H2 2012 which is a top most award in Capgemini FS.

Wright brother’s Award for providing the critical Analytics for Management Reporting for Capgemini Global FS.

Best Performing Team Award for H1 2014 in Infosys Technologies for Telstra Project ACADEMIC QUALIFICATIONS

Masters In Commerce (Business Administration) – MLSU, India- 2005

C-DAC’s Diploma in Advance Computing - MET’s IIT, India -2002. Page 2 of 6

PROJECT DETAILS

Implementation and Support – Oracle ERP Cloud (Financials & Projects Portfolio Management ) EiS Technologies, Inc Apr’2019 till Mar’2020

Client : Inspire Brands, Atlanta

Inspire Brands has implemented Oracle ERP Cloud for their Financials and Projects requirements. This project required Configurations for New Business Units with security setups and segregation of duties, Design & Development of Financials Reports and Financials Support for functional issues. Role Oracle ERP Cloud Consultant

Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical detail design documents.

Configuration of Business Units with setting up of Business Unit functions and Security.

Configuration of Segregation of Duties by setting up of Custom Roles and Data security policies for Financials, Projects and HCM as per the Business requirements

Uploaded key setup such as Chart of Accounts values & Hierarchies using Spreadsheet templates.

Developed OTBI and BI Publisher Reports to provide accurate analytics.

Configured & Applied Sandboxes for the Roles based Page level Customizations

FBDI (File Based Data Import) to upload a data for Roles, GL Segment Values etc.

Configured Custom SLA Rules

Trained Business User to use ADF DI for uploading GL Journals.

Conduct of End User Training & User Acceptance Test (UAT).

End User Support on various functional Issues for Cloud Financials, Projects and HCM Environment & Tools Oracle ERP Cloud R13, OTBI, BI Publisher, FBDI Implementation & Support – Oracle ERP Cloud (Financials) EiS Technologies, Inc Nov’2017 till Mar’2019

Client : SplashBI, Atlanta

SplashBI required Oracle Cloud Financials module to be implemented on SaaS. This project required All basic Application Configurations along with security setups. This also required Design & Development of Financials Reports; Financials Support for functional issues. Role Oracle ERP Cloud Functional Consultant

Job Duties and Responsibilities

Setting up of Environment with basic Financials and Security Configurations.

Setup of Offerings, Implementation Project, Roles, Tasks, Business Units & Reference Data set.

Performed GL Setups - COA, Structures, Calendar, Legal Entity, Ledgers etc.

Security Setup for Financials Modules using Business Unit functions, Procurement Agent Setup, Custom Roles, Data Access, Auto Provisioning Role, Report access etc.

Development of OTBI and BI Publisher Reports for Financials

Used FBDI for migration/import of various entities such as COA, Hierarchies, Journals, Suppliers, Sites, Open Invoices, Projects and Custom Role etc.

Created financials, Projects & HCM Custom Roles for Reporting and Inquiry Only duties.

Worked on Projects Portfolio Management Setups such as Project Basic Configurations, Project unit, Classifications, Projects Costing and Billing Configurations etc.

Worked on Accounts payable Configurations such as Supplier, Sites, Bank, Bank Accounts, Payment Terms etc.

Solution Design for integration of Cloud Financials for third party reporting tool.

Conducted End User Training for using the Standard functionalities.

Worked on Sandbox for Page Customizations

Raising SR with Oracle for Bugs, issues and Standard Functionalities. Environment & Tools Oracle ERP Cloud R13, SplashBI, BI Publisher, Sandbox, Application Security Page 3 of 6

Implementation and Support – Oracle EBS R12

EiS Technologies, Inc Oct’2016 till Nov’2017

Client : Realogy Corporation

Worked on EBS Implementation Projects with Realogy Corporation where I was responsible for Project Management, Implementation, Customization, Support and Report Development Role Oracle EBS Consultant & Project Manager

Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical detail design documents.

Successfully executed entire Project as a Project manager by managing On-site and Off-shore teams.

Configured Operating Units with Security setups, Responsibility, Profile options etc.

Configured GL Setups and PA Setups.

Setting up of Applications KFFs, DFFs and Auto-Accounting Rules

Contributed as Individual Contributor and developed various Financials, Projects and SCM Reports using PL/SQL and EiS.

Conduct of End User Training & User Acceptance Test (UAT).

Conducted Training Sessions for End Users, Developers and Administrators

Support to Finance End Users on Various Functional & Technical issues of Financials, PA & PO. Environment & Tools Oracle Applications R12, Oracle PL/SQL, EiS express EBS Support & Custom Report Development – Oracle EBS R12 EiS technologies, Inc May’2016 till Oct’2016

Client : Dover Fluids - Wilden

Worked on EBS Support & Custom Development Project with Dover Fluids Wilden for Project Management, Customization, Support and Report Development.

Role Oracle EBS Consultant & Project Manager

Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical detail design documents.

Successfully executed entire Project as a Project manager by managing On-site and Off-shore teams.

Contributed as Individual Contributor and developed various Financials and SCM Reports using PL/SQL and EiS.

Conduct of End User Training & User Acceptance Test (UAT).

Conducted Training Sessions for End Users, Developers and Administrators

Support to Finance End Users on Various Functional & Technical issues of Financials, PA & PO. Environment & Tools Oracle Applications R12, Oracle PL/SQL, EiS express Discoverer Migration to EiS eXpress Reporting – Oracle EBS R12 EiS Technologies, Inc Aug’2015 till Oct’2017

Multiple Clients

Oracle has officially ended supporting Discoverer Reporting which requires customer to migrate their Discoverer report to another Reporting tool. I managed the projects with multiple clients to migrate their reports to EiS eXpress report without hampering their reporting need and security access. Role Oracle Application Financials & Projects Consultant Job Duties and Responsibilities

Interact with business users to understand their Reporting Requirements and existing Security for Discoverer Reports.

Generation of Project Plan, Financial Plan and Resource assignment Plan.

Managing Development Team for Migration, development and Patching.

Migration of Discoverer Business Area and Reports to EiS Reporting.

Replicate EBS and Discoverer Security within Reporting Solution.

Conduct of End User Training & User Acceptance Test (UAT). Environment & Tools Oracle Applications R12, Oracle Discoverer, Oracle PL/SQL, EiS express Clients Hazelden Betty Ford Foundation

HD Supply

Best Buy

Page 4 of 6

Magellan Midstream Partners

Support & Custom Development – Oracle EBS R12/EiS eXpress Reporting EiS Technologies, Inc Dec’2014 till Jul’2015

Client : University of Oxford, UK

University of Oxford is extensively using Oracle Projects module with its Indirect and Capital Project functionality. They require seamless support for their functional implementation as well as their reporting requirements. Developed the Project Datamart for their efficient analysis of Historical Data Role Oracle Application Financials & Projects Consultant Job Duties and Responsibilities

Interact with Project Accountant and PMs to understand the Business Requirements on Data Analytics

Solution Design, Implementation and testing of the Project Datamart.

Development of Financials and Projects Reports/Dashboards using PL/SQL and EiS Express Reporting Solution.

Support to Finance End Users on Functional queries regarding Project Datamart.

Conduct of End User Training & User Acceptance Test (UAT). Environment & Tools Oracle Applications R12, Oracle PL/SQL, EiS express Implementation and Support – Oracle Applications R12 Infosys Technologies Dec’2012 till Nov’2014

Client : Telstra, Australia

Telstra is Australia's leading telecommunications and information services company, which requires Implementation and Support of its OUs across the globe for Global Finance and HR. This includes rollouts of new OUs, implementing standard and custom solutions, Custom Development and Prod Support for all the regions. Role Oracle Application Financials & Projects Consultant Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical detail design documents.

Solution Design, Implementation and testing of the various solutions as per business.

Development of various Financials Reports using PL/SQL and Concurrent Programs.

Support to Finance End Users on Various Functional and Technical issues including Custom Interfaces.

Conduct of End User Training & User Acceptance Test (UAT).

Implementation of Projects Costing and Projects Billing.

Setup of Program Roll-up feature of Project Management.

Designed various Interfaces to Create/Update Projects, Tasks, Budgets, Project’s Agreement, Funding, Key members and Classifications using Oracle Projects AMG APIs.

Preparation of User Manuals and Training Document for Standard & Custom functionalities.

Inbound Interface for AR Invoices using Auto Invoice Import Program; Developed and customized various AR Reports such as AR Aging Report, AR Receipt Application Report etc.

Created MD.50 and MD.70, the technical design documentation for the Technical Development team for Interfaces and Customization.

Setting up of Applications KFFs, DFFs and Auto-Accounting Rules Environment & Tools Oracle Applications R12, Oracle PL/SQL, Discoverer GFS – Global Financial System – Oracle Applications 11i CapGemini India Pvt. Ltd. Aug’2010 to Dec’2012

Client : CapGemini Global

Global Financial System (GFS) is a global implementation of Oracle Financial and Oracle Projects in all regions worldwide for all CapGemini entities into a single instance. It is a CapGemini Group internal project which comprises data migration, data conversion and integration of third party systems like Time & Expense, HR and Procurement of the regional CapGemini entities to a single instance of Oracle Application known as GFS. Role Oracle Application Financials & Projects Consultant Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical design Docs.

Solution Design for various critical Business requirements.

Creation of AIM Documentation including Functional Design MD50, Technical Design MD70, Test Plan TE40 and Setup Document BR100.

Page 5 of 6

Implementation and testing of the various solutions as per business.

Development of various Financials Reports using PL/SQL, Concurrent Programs and Business Objects XI2

Functional and technical Support for Business Objects XI R2.

Support to Finance End Users on Various Functional and Technical issues including Custom Interfaces.

Conduct of End User Training & User Acceptance Test (UAT).

Developed Various PA Reports such as UB/UE Report, Projects Contribution Margin Report, Employee Utilization Report, KPI Report etc.

Preparation of User Manuals and Training Document for Standard & Custom functionalities.

Developed and customized various GL Reports such as P&L Cross Check Report, Month End Period Close Status Report, Reconciliation Report for GL to AP, AR and PA Environment & Tools Oracle Applications 11i, Oracle PL/SQL, BI Publisher, Business Objects XI 2 NSoro – Integration and Re-Implementation - Oracle Applications 11i - Project Accounting / Financials Fujitsu Consulting limited May’2010 – Aug’2010

Client : NSoro Inc - USA (Subsidiary of Mastec Inc.) NSoro Inc is a Mastec Subsidiary Company having implemented Oracle Application for Projects Accounting and Financials needs. The business requires integration of NSoro to Mastec with the Multi Organization Setup. Role Oracle Application Financials & Projects - Technical Consultant Job Duties and Responsibilities

Lead the Team for Analysis, Design, Development and Implementation for Financials and Projects.

Creating Functional & technical detail design documents following Oracle Applications best practices.

Analysis and Design of data Structure and Volume for Migration.

Impact analysis of data migration for Mastec Instance.

Enhancements of existing Interfaces and Reports to support Multi-Org Setup.

Development of Various Migration Scripts for FND, Setup, Transaction and Custom Data using PL/SQL and APIs.

Migration of Various Custom Reports developed using Oracle 6i, Discoverer 10g and XML Publisher. Environment & Tools Oracle Applications 11i, Oracle PL/SQL, Discoverer 10g Mastec - Production Support & Custom Development - Oracle Applications 11i - Project Accounting/Financials Fujitsu Consulting limited Aug’2009 to May’2010

Client : Mastec Inc. – USA

Mastec is Telecommunication Company having implemented Oracle Application for its Projects Accounting and Financials needs. The business requires various customizations and automations to cater end user needs Role Oracle Application Financials & Projects - Technical Consultant Job Duties and Responsibilities

Coding & Development of Custom components for Applications using PL/SQL and APIs.

Development of various Financials Reports using PL/SQL, Concurrent Programs and Discoverer 10g.

Enhancements of existing Interfaces and Reports in support environment.

Technical Support on Oracle Applications Financials Issues to End Users.

Creating Functional & Technical Design documents following Oracle application’s best practices.

Implementation of Projects Costing and Projects Billing.

Designed various Interfaces to Create/Update Projects, Tasks, Budgets, Project’s Agreement, Funding, Key members and Classifications using Oracle Projects AMG APIs.

Designed and Developed Interface to Create/Update PA Projects Events using Event based APIs.

Developed PA Projects Event Conversion for Unbilled Invoice lines using Event based APIs. Environment & Tools Oracle Applications 11i, Oracle PL/SQL, XML Publisher, Forms 6i, Discoverer 10g ISG - Internal System Group – Oracle Applications 11i Capgemini India Pvt. Ltd Dec’2007 till Aug’2009

Client : Capgemini Financial Services

ISG is a CapGemini’s project comprise of all the internal applications to be used by the Capgemini Role Oracle Application Financials & Projects - Technical Consultant Job Duties and Responsibilities

Interact with business users to understand the Business need and creating Functional & technical detail design documents following Oracle Applications best practices. Coding & Development of Custom components for Applications using PL/SQL and APIs.

Page 6 of 6

Development of various Financials Reports using PL/SQL, Concurrent Programs and Noetix Reporting tool.

Technical Support on Oracle Applications Financials Issues to End Users.

Enhancements of existing Interfaces and Reports in support environment.

Data Conversion for the Migration to the higher version.

Designed and Developed an Interface to import Time and Expense information into PA. Environment & Tools Oracle Applications 11i, Oracle PL/SQL, Oracle Developer 6.0



Contact this candidate