Candidates About

Summary:                                                                                                    

·         More than 15 years of IT Experience in Design and Development of software Systems in the areas of Oracle eBusiness suite (Oracle EBS).

·         Proficient in Developing, Customizing, and Implementation of forms 10g, reports 10g and XML Publisher reports.

·         Experience in coding Interface Programs for importing data from Legacy Systems in different modules mainly Oracle Financials (AP, AR, GL)

·         In depth experience in Implementation and post production support in EBS R12

·         Experience in configuring new Descriptive Flexfields (DFF) as per the business requirements

·         Strong PL/SQL skills with the ability to write efficient, complex queries against very large data sets good knowledge of tuning of queries.

·         Have been part of 6 implementations and 2 R12 upgrade projects

·         Extensive experience using AIM (Application Implementation Methodology)

·         In depth knowledge in creating Functional (MD50) and Technical (MD70) documentation

·         Good Knowledge in procurement software Coupa

·         Worked as Oracle Data Integration Architect in integrating of Coupa with Oracle EBS (Payables)

·         Extensive experience with integration of P2P Software and oracle EBS

·         Good working experience in Forms 4.5, 5.0, 6i, 10g Reports 2.5, 3.0, 6i, 10g, PL/SQL, BI Publisher, EDI, Oracle Databases 7/8/9i/10g/11i and RDBMS Concepts

·         Good Techno-Functional knowledge of Oracle Financials (AP, AR, GL), Order to Cash, P2P, Cash Management, Order management, Oracle Inventory, OPM, Oracle HRMS, Oracle Trading Community Architecture (TCA), Oracle Fixed Assets, Oracle Project Accounting, Oracle EAM, Oracle Service Contracts, Oracle CRM, OLFM

·         Experience in the analysis, design & development of financial & accounting applications.

·         Good experience in MS Office - Project, Visio, PowerPoint, Word, Excel

·         Oracle Certified Professional (OCP) who is highly motivated and thrives on seeking knowledge, adapting best practices, and collaborating with globally diverse team members.

·         Currently pursuing for Oracle E-Business Suite R12 Financials Certified Expert Consultant

 

Education:

 

·         Bachelor of Commerce from University of Bombay, Bombay, India (1998)

 

Certification:

 

·         Oracle E-Business Suite R12: E-Business Essentials, 2009

·         Oracle Certified 9i Database Administrator Associate, 2003

·         Oracle Certified Professional Application Developer Release 2 (OCP), 2001

·         Oracle Certified Professional Internet Application Developer ver.6/6i (OCP), 2001

·         Brain bench Certified Oracle Developer, 2001

 

 

Skills Matrix:

 

Skills	Years Used	Last Used	Rating
Oracle EBS 11.5.10/12.1.3/12.2.5/12.2.6
Oracle Financials (AR, AP, GL, CM, FA)	13	Current	8
Oracle Supply Chain (OM, Shipping, QP, PO, INV)	8	Current	8
Oracle HRMS	5	2014	8
Databases
Oracle 7/8/9i/10g/11g	15	Current	9
Languages/ Tools
Developer/2000- Oracle Forms 4.5, 5.0, 6i,10g	15	Current	8
Oracle Reports 2.5, 3.0, 6i,10g	15	Current	8
SQL, PL/SQL	15	Current	9
SQL*Loader	5	2011	8
TOAD	8	Current	8
Oracle SQL Developer	5	Current	8
BI Publisher (XML Publisher)	6	Current	9
Unix Scripting	5	2011	8
Operating Systems
Windows 2000 Server / Professional	11	Current	7
UNIX (AIX, Solaris and HP)	7	Current	8
LINUX	3	2010	7

 

Work Experience:

 

SGS Technologies, Jacksonville, FL                                                                                          Jul’2017 – Feb’ 2018

Client: Jacksonville Transportation Authority                                                                        

Role: Senior Oracle EBS Techno-Functional Consultant

·         Working at SGS Technologies to provide Oracle EBS production support for their client

·         Providing technical support AR, AP, PO

·         Creating new reports in BI Publisher

·         Creating new RFQ Supplier sites using API

 

Environment: Oracle EBS 12.2.5 (Oracle Financials (AR, AP)), PO

 

 

 

 

 

Prudential Financials, Newark, NJ                                                                               Sep’2017 – Dec’2017

Role: Senior Oracle EBS Techno-Functional Consultant

·         Post Production Support and Enhancements for i-Expenses, Accounts Payable and Fixed Assets

·         Creating new custom PL/SQL packages as per the functional specifications

·         Gathering requirements from users creating technical specifications for the same

·         Creating new reports in BI Publisher

 

Environment: Oracle EBS 12.2.6 Oracle iExpense, AP

 

Mckinsey & Company, New York City, NY                                                                      May’2016 – Oct’ 2016

Role: Oracle EBS Data Integration Architect

·         Mckinsey in house project to replace the current Ariba Procure to Pay system with Coupa Cloud based Procure to Pay (P2P) system. Also involved in implementation of in house Supplier Information Management system called Vetted.  

·         Gathering business requirements from the users and creating functional documentation for the Inbound and Outbound AP Interfaces from OracleEBS

·         Mapping Columns from Coupa to Oracle EBS and doing the Gap Analysis

·         Creating different types of purchase orders in Coupa for testing the integration with Oracle EBS

·         End to end mock testing in different Instances like CRP, SIT and UAT

·         Assigning and Managing work to off shore technical team

·         Good Understanding of Agile Software Methodology to create and track stories

·         Creating functional documentation MD50

·         Mapping columns from Vetted to Oracle EBS and doing the Gap Analysis

·         Configured new Flexfields to as per the business requirements

 

        Environment: Oracle EBS 12.2.5 (Oracle Financials (AR, AP, GL)), P2P Cycle, Oracle Order  

        Management, Oracle Project Accounting, TOAD, Coupa, Vetted.

 

State of Rhode Island, Warwick, RI                                                                                               Jun’2015 – May’2016

Role: Senior Oracle EBS Techno-Functional Lead

·         Creating new PL/SQL packages to automate the Fairshare and Processing processes in OM.

·         Gathering requirements from users creating functional and technical specifications for the same

·         Creating new reports in Oracle reports

·         Providing technical support in various Oracle EBS modules like Inventory, Accounts Receivables, Accounts Payables and General Ledger, OTC

·         Configured new Flexfields in Item Master to support new business requirements

 

        Environment: Oracle EBS 12.2.4(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle Order to

        Cash, TOAD, Oracle Reports

 

Cubist Pharmaceuticals, Burlington, MA                                                                                  Aug’2014 – Apr’2015

Role: Oracle EBS Techno-Functional Lead

·         Working with the 3PL (Third Party Logistics) to get the legacy data as per Oracle EBS

·         Coordinate with functional consultants to map the data and get the MD50’s

·         Hiring and managing the resource for data integration

·         Creating Inbound Interfaces Inventory Item’s (Master and Organization), Inventory Material Transactions, Order Management, AR Invoices and creating shipping API’s using PL/SQL Packages

·         Created  PL/SQL package to Invoke RESTful JSON web services

·         Providing resource and work estimation for data integration

·         Created technical documentation MD70’s

 

        Environment: Oracle EBS 12.2.4(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle Order

        Management, Order to Cash, P2P, TOAD, Oracle 11g, Oracle Process Manufacturing(OPM)

 

Jacksonville Aviation Authority, Jacksonville, FL                                                                    Sep’2013 – Aug’2014

Role: Senior Oracle EBS Techno-Functional Lead

·         Participated in 11i to R12 upgrade.

·         Retrofitted 11i custom RICE/CEMLI objects to R12

·         Upgraded forms from 11i to R12 (Forms 6i to 10g)

·         Upgraded reports from 11i to R12 (Reports 6i to 10g)

·         Reviewed the existing code and made the changes to use R12 functionality/new features as necessary.

·         Successfully Implemented Oracle Inventory (R12.1.3) at JAA

·         Gathered data conversion requirements from BA mapped the legacy data from DataStream with oracle EBS tables

·         Responsible for validating data in staging tables and running custom program to import data from staging to interface tables and then running Mass Additions Concurrent Program to migrate data from interface to base tables in Fixed Assets (FA).

·         Extracting data from legacy system DataStream and inserting the data into Oracle EBS staging tables for conversion and cleansing the legacy data in Oracle

·         Designed and Developed Item Conversion to Import legacy inventory items in master and child organization

·         Developed custom interface program to load inventory (INV) Adjustment data from external system into MTL_TRANSACTION_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE tables

·         Created Inbound Interfaces using PL/SQL packages for Inventory, Categories, Costing and On Hand Quantity to import legacy system data into Oracle EBS using PL/SQL Packages

·         Reconciling of data in legacy system with oracle EBS once the integration is completed

·         Providing estimation for technical deliverables in different phases of implementation of the project

·         Worked closely with Business Analysts in gathering functional requirements (MD 50) and created technical documentation (MD 70)

·         Created a new Oracle Form to enter subcontractor details in Purchasing and also created new Flexfields

·         Providing technical support in various Oracle EBS modules like Inventory, Fixed Assets, Accounts Receivables, Accounts Payables, General Ledger, Order to Cash, Oracle EAM and Oracle CRM

 

        Environment: Oracle EBS 12.1.3(Oracle Inventory, Oracle Financials (AR, AP, GL)), Oracle project

        Accounting, Order to Cash, Oracle EAM, PO, Fixed Assets, Oracle CRM, SQL Developer, Oracle

        PL/SQL 9i, Executive Dash reporting tool, Oracle Forms 10g, Oracle Reports 10g, Oracle 10 g

 

 

 

RCMP (Federal Government) / JEA, Victoria, BC                                                                                    Sep’2011 – Mar’2013

Role: Senior Oracle Consultant

·         Customize Forms 10g, Reports 10g, BI Publisher Reports, Oracle packages

·         Customized XML Reports according to the user change requests

·         Working with Business Analysts in understanding the business requirement 

·         Creating Technical Documents for the business requirements

·         Providing estimations for technical deliverables to the client

·         Create Unit Test Plan for all developments

·         Working closely with other Developers, Business Analysts, Testers in creation and validation of

Business requirements and providing application support for in house Penfax Pension software

        Environment: Oracle PL/SQL 10g/11g, Oracle Reports 10g, Oracle Forms 10g, BI Publisher (XML

        Publisher)

 

Fujitsu Consulting Canada, Victoria, BC                                                                                    Jan’2010 – Sep’2011

Role: Senior Oracle EBS Developer

Client : Ministry of Labour and Citizen Services of British Columbia

·         Maintenance of ETL packages

·         Worked on maintenance and enhancements of Oracle Data warehouse 

·         Gather requirements from end user and create Technical Documents for the same

·         Providing estimations for technical deliverables to the client

·         Create Unit Test Plan for all customizations

·         Working closely with other Developers, Business Analysts, Testers in creation and validation of

Business requirements

·         Implementation of GST/HST Taxes

·         Providing application support to Oracle Financial, Order Management, Oracle to Cash, Oracle Inventory, Oracle Configurator modules, Oracle Projects, Oracle EAM

        Environment: Oracle EBS 11.5.10/12.1.3, Oracle Financials (AR, AP, GL), OM, FA, CM, Oracle EAM,

        Oracle Inventory, OLFM, Oracle Project Accounting, Oracle to Cash, P2P, Oracle Data

        Warehouse(ETL), Toad 9.7.2, Oracle PL/SQL 10g, Oracle Reports 6i/10g, Oracle Forms 6i/10g

 

Creation Technologies Inc., Burnaby, BC                                                                                   Aug’2007 – Sep’2009

Role: Systems Analyst (Oracle EBS)

·         Successfully Implemented Oracle Manufacturing, and Oracle Financials and Oracle Supply

Chain in 3 Business Units across US

·         Gathered data conversion requirements from BA mapped the legacy data with oracle EBS tables and did the Gap Analysis

·         Experience with Approval Management Engine (AME)

·         Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing, Oracle Financials, Oracle Install Base and Order to Cash Cycle to import legacy system data into Oracle EBS

·         Reconciling of data in legacy system with oracle EBS once the integration is completed

·         Created Inbound Inventory Item’s Interface to load Master and Organization Items

·         Worked closely with Business Analysts in gathering functional requirements (MD 50) and created technical documentation (MD 70) which included complex data flow diagrams, unit test plans and process diagrams

<p class="MsoN