Oracle Manager

Mahesh Nyati

Morrisville, NC

Email: ***********@*****.***

Mobile: +1-704-***-****

Experience Summary:

More than Fourteen years of experience in Oracle Apps E-Business suite (ERP) project management, implementations, support, upgrade, configurations, customization, integration, automation, testing & enhancement. My core competency lies in client facing roles, across industries, involving Oracle Financials and SCM (Release 12, 11i & Fusion,) and integration of Oracle EBS with various other systems. I also have expert knowledge of AIM methodologies. Having travelled different countries, in connection with my work, and having worked on multiple, large scale, end-to-end implementation assignments with Big 3 consulting firms.

Expertise in Oracle General Ledger, iExpense, Accounts Payable, iProcurement, Purchasing, Order Management, Accounts Receivables, Advanced collections, Fixed Assets, EBTax, System Integration, System Administrator,

Knowledge of oracle process flows -Procure-to-Pay(P2P), Order-to Cash(O2C), Record to Report(R2R) & Projects to Receivables(P2AR) process flows .

Hands on experience in managing and executing tasks and deliverables in the following elements of a project lifecycle: Design, Build/Configuration, Training, Testing, Deploy, Support

Extensive experience in gathering requirements, fit & gap analysis, design, configuration, CRP, Testing, user training, documentation.

Extensively used Oracle AIM, OUM Methodology for various Functional Design, Setup, Test Scripts and process flows documentation.

Knowledge of Quality Process in building Standard Process documentations for Oracle Applications.

Expertise in SDLC/Agile project methodologies.

Project management experience of 5+ years in managing small and medium sized teams.

Apt in writing SQL queries, using reporting tools & back end table architecture.

Conducted training workshops on Financial Modules to users & Supported as Oracle Apps trainer at Organizations level contributer for TCS, Accenture & Capgemini .Awarded as People developer several times.

Consulting Skills

Effectively manages scope and customer expectations on individual assignments

Strong analytical skills for issue resolution adhering project timelines.

Complete ownership of issues & Follows through on all project assignments.

Excellent written & verbal Communication skills.

Consistently produces clear, concise status reports

Builds confidence and trust with clients

Role: - Oracle apps Functional Financials.

Clients Served - FACEBOOK,Lendlease, GE-CCL, GE (P&W), GE Commercial Finance, Cisco, NBTY (Vitamin World), JPMorgan Chase, British-Telecom.

Technology

ERP Oracle Applications Fusion/R12/11i – Financial/SCM Domain

(GL,AP,AR,OM,CM,FA,PO, iExpense,iProc, PB,PC,PA),

Oracle Discoverer 4i & 10G

Certification PMP ( Training completed,Exam In Progress)

Six Sigma Green Belt Certification

Oracle Financials GLs -1z200 (GL)

Oracle Financials Cloud: General Ledger 2018 -1Z0-1004

Oracle Certified Associate

Qualifications

Degree

Institute

Major and Specialization

Year of Passing

Bachelor of Engineering

UNIVERSITY OF RAJASTHAN,

Jaipur, (Raj) India

Electronics & Communication

2001-2005

Career Profile

Client: Syneos Health

Global BAU Support & Enhancement, Morrisville- NC

Brief description of the project: Mar 2018 –till Date

Phased Global implementation of various operating units post merger of

INC Research, Inventive Health & BAU support for 60+ countries.

Responsibilities:

Oracle EBS R12 Functional lead

Implemented Oracle Fusion Expenses Mobile App integrating with R12 keeping current customizations as-is & using a DMZ configuration rolling out 10 new operating units from Selling solutions Commercial business.

Gathering business requirements and translating them into Detailed Functional/Test design specification for the Oracle Financials project

Collaborating with Business and other stake holders in order to understand the business requirements & provide feasible solutions by having in-depth knowledge

& expertise of Oracle EBS Financial modules

Perform Fit gap analysis on Oracle EBS functionality to determine setup, configuration & development pertaining to Business requirement

Translating the client’s business requirements into detailed functional requirements for RICEW components in accordance with Oracle OUM methodology. End to end Solution design / Configuration /Testing of Oracle EBS R12 components. Creating AN100 for functional design specification, TE 25 for developing unit test scripts and TE70 for developing system test scripts

Detailed Analysis & troubleshooting of issues reported by users on integration of Oracle Payables, iExpense, Purchasing, Projects (Costing/Billing) and Oracle Finance modules like General Ledger, & Cash Management, Accounts Receivables.

Analyze post deployment incidents pertaining to various Oracle EBS R12 Financial modules in Release R12 & provide resolution to incidents, Bug fixes, Tasks & Change Requests.

Perform System Integration test (SIT) and Plan, Coordinate User Acceptance Test (UAT) with Business users

Prepare training documents & conduct user training for Oracle EBS financial

Raise Service Requests with Oracle & work together with Oracle Analysts

On high priority critical issues to support month end process & closing of Oracle EBS financial books.

Undertake complete responsibility and ownership for Application support. Resolution/Closure of incidents, Bug fixes, Tasks & Change Requests pertaining to Oracle EBS Financial modules within the agreed Service Level Agreement (SLA)

Collaborate & Coordinate with development team/off shore team for development progress & solution validation. Work closely with offshore team aligning with their schedule/changes so that overall solution can be delivered on time.

Participate in daily status meetings to discuss issues & project updates

Provide status, risks & issues to IT, Business management for Oracle Stabilization Projects.

Client: Lend lease- Implementation cum roll out (T230-US)

& Enhancement Support, NC July 2016 –Jan 2018

Responsibilities:

Oracle Fusion Functional lead to Lendlease IT

Responsible for complete ownership of T230 (USA) roll out and managing it single handedly from US .

Requirements gathered, identify gaps with existing functionality and translate business requirements

into solution.

Responsible for detailed documentation of solution design, maintenance for enhancements pertaining.

Complete ownership for setup, configuration of complete P2P business process cycle.

Design & deployment of enhancements, new functionalities pertaining to various Fusion financials modules -

GL, AP & AR :

Implementation of 1099 Tax reporting with 2017 Patch,

Implementation of AR Lock Box Processing,

BOA ACH & Bank Cheque Processing,

Modification of SLA -Account Derivation rule for debit memo with Retainage Release,

Ownership for Functional Testing, Test Data Preparation. Test Scenario prep for deployed enhancements.

Co-ordinate with UK/Aus/India teams on issues resolution pertaining to functional testing for

Enhancements deployed by other regions on customizations & shared functionalities.

Provide research, analysis, and problem resolution including creating and monitoring

service requests with Oracle, Textura Support

Collaborate & work closely with the business teams (AR, AP, PO, PAR and MDM) to provide day-to-day application

Support and bug fixes.

Work closely with Engineering organization to develop and test system extensions enhancements, integrations

Support business users and help to troubleshoot simple to complex application issues and develop

creative solutions to support business needs & priorities, manage functional requirements for support pertaining to

T230 (US roll out).

Knowledge sharing – maintaining business process knowledge base .Document business requirements.

Functional design, test scenarios and scripts, and end-user training materials.

360 degrees sharing of knowledge – report back to offshore SDM on service and lessons learnt.

Conducted AS-IS and To-BE sessions, Super User and User trainings on the newly deployed enhancements,

New functionality.

Client: GE Corporate -CCL Stamford, CT Sep2015- July-2016

Brief description of the project:

Oracle Fusion/R12 Functional Lead for CCL

Lead this multi-track Oracle Cloud project for validation across multiple tracks for CCL financials modules.

Lead efforts to gather requirements gathering, structure documentation and present findings.

Assist project leaders by scoping the proposed solution leading to accurate cost and time estimates.

Setup & Configuration pertaining to various Fusion financials modules.

Maintain and Support Oracle Fusion Financial Cloud production environment for the

(GL, AP, AR) modules.

Created, analysed, and executed complex reports, queries, and data using OTBI to support the various reporting requirements of Finance and Operations

Collaborate with functional areas of the business and IT to identify, evaluate and implement new applications, business processes and technologies to drive business performance improvements

Develop test strategy & plan on need basis and accommodate changes as required.

Executing SIT and assisting UAT for impacted changes.

Provide end-user instruction, training and support to resolve application issues.

GILEAD Life Sciences, Foster City, CA March 2015 - September 2015

Oracle Fusion Functional: Serialization project (INV, OM, Axway, GEM, Systech)

Gilead has implemented serialization methodology to capture life cycle of the product manufactured and shipped to customer.

Understand Oracle Fusion release enhancements, Support assessment & impact analysis of enhancements

Create functional testing requirements & review same with business.

Coordinate with Gem (Fusion middleware), Axway (DB) & Sytech teams, Drive the release testing execution & provide communications to business.

Interact with Functional team and Business team for requirements, clarifications and results validations.

Project status reporting and project execution

Lead calls / meetings with extended program team & business on Daily/Weekly basis.

Update status with Customer on a Day to Day basis.

Client: GE (Power & Water) -ACCORD-Apex Feb 2014- Mar 2015

Role:

Brief description of the project:

Accord-Apex provides a comprehensive and integrated suite of harmonious business applications and processes based on a scalable ERP backbone with seamless integrations to pillar applications, manufacturing business growth and process efficiencies.

Oracle EBS Functional Lead for Accord-Apex (P2P, O2C)

Understand Oracle-APex testing requirement, Design the testing scripts, datasheets, output results and review the developed scripts for modules BMA, IBS, LTL, Sabrix-AP, Sabrix AR & Web-ADI

Coordinate, Drive the Apex SIT testing execution & provide updates to business during stand up & defect calls.

Manual/UFT testing execution per requirement during SIT.

Interact with Functional team and Business team for requirements, clarifications and results validations.

Prepare Test Data, validation & results for completeness of testing.

Mentor & guide team on Testing modules be it customization or standard Oracle functionality.

Interact with Customer on a Day to Day basis.

Stabilizing the future cycles for SABRIX (AP, AR) & Apex regression testing using automation and MS excel features, & RCA of Defects.

Environment:

Oracle Application R12 (PO, AP, OM, AR), Sabrix, Oracle Database 10G, HPQC

Client- CISCO – CCW, Aug 2013 – Feb2014

Role :Oracle EBS Functional Lead (O2C, EBTax)

Participate in Requirement discussions related to Order to Cash Manufacturing Process.

RTM preparation and get the required sign-off from the stakeholders.

Sales Order creation from upstream systems

OT/CCW order validation within ERP (Oracle Applications)

Validating EBTax related set-ups and updating configurations, Verifying the Tax rates for various items and services shipped globally.

Writing functional and regression test cases.

Execute the Functional & Regression test cases.

Test the Order to Cash functionality within Oracle Applications

Co-ordinate and help the BAT and UAT users during their testing

Report the Bugs and work closely with the Development teams for the defect / issue resolution

Environment:

Oracle Application R12 (OM, AR, INV, EBTax), HP-Quality Centre

Client: NBTY, Ronkonkoma, NY Oct 2012- Aug2013

Project: NBTY - P1 Oracle Implementation

NBTY, is an American manufacturer, of vitamins and nutritional supplements.

Role: Oracle Functional Consultant for manufacturing processes.

Creating Functional Designs for GL conversion and assigned AP, FA components.

Reviewing Technical Designs for RICEFW components

Creating Test scripts & co-ordinating executing of test scripts for RICEFW Components

Project status reporting and project execution (Both with Business as well as Project Manager).

Drafting AP322 & Configuring QA, UAT & Production.

Configuring Financial EBS modules using Data Loader Record and Playback feature.

Configuring Asset Categories, Corporate and Tax Related Books.

Conducted Training session for entire team on Data Loader Pro- Record and Playback feature

Environment:

Oracle Application R12. (FA, AP, GL), Oracle Database 10G, Data Loader Pro

Client: FACEBOOK – Aug 2011-Oct2012

Project Facebook Application Support USA Hyderabad/Menlo Park

Role: Business Application Architect (P2P, O2C, R2R)

SME for supporting and enhancements for Oracle financials modules: GL, AP, FA, AR and many customizations related to Intercompany, Revenue recognition.

Interacting with client, analysing enhancements and implementation of the same for P2P, R2R & O2C streams in Omega (Oracle apps R12). Using GIT tool for code Migration to different environments.

Configuring EBTax set up for new geographies and suppliers.

Resolving Tax related issue relating with third party integration tools like Vertex.

Project status reporting and project execution (Both with Business as well as Project Manager).

Unit, Regression, Integration, Performance Testing for the components Modified.

Co-ordinating with multiple team scenarios for Month End Issue’s for OSO & DSO processes (O2C stream).

Month end process monitoring and pre-check’s analysis.

Co-ordinating with multiple teams (Ad’s manager, Ad-server, Salesforce) for month end issue’s resolutions (lock box processing, Executing exception reports and assisting in smooth close.

Co-ordinating with Oracle SR support for critical/non-critical issue.

Data flow checks for receipts, ad account’s & supplier’s to & from between Sales force & Omega.

Resolving Set up related issue’s in AR, GL & EBTax.

New account updates in FSG report’s in GL.

Driving the logistics for Month End Call’s-Meetings and updating zoho docs

Environment:

Oracle Application R12 (PO, AP, GL, OM, AR, EBTax) Oracle Database 10G,SQL

Client: British Telecom Dec2010-July-2011

Chorus Build (Asia –Pac Wave 3)

Role: Team Leader Role

Interacting with client, analysing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD50 & creating TE40 and testing the changes and implementing the same in Test environment & production

Implementing using SVN tool for code Migration to different environments.

Creating and Executing BR100 document for set up configuration and implementation.

Project status reporting and project execution (Both with Business as well as Project Manager).

Mentoring & Supervising team to make sure 100 % compliance on deliverables.

Unit, Regression, Integration, Performance Testing for the components Modified.

Support for I-Expense related CEMLI’S and various setups involved.

Managing team activities and assessing junior resources and assisting ASG

Celli Reports development.

Designed & Implemented new AIRPLUS Interface System for four new location’s including the existing location. (Lufthansa Germany, Australia,Hongkong,Singapore)

Environment:

Oracle Application R12 (iExpense, AP), Oracle Database 10G,

JPMorgan Chase -Oracle Operate Paris Roll out Jan-2010-Dec2010

Team Leader Role

Interacting with client, analysing change requests, requirements, impact analysis, and implementation of the same. Preparing MD50 & creating TE40 and testing the changes and implementing the same in production (Third Party) using Autosys as configuration management tool.

Creating and Executing BR100 document to configure and implementing Oracle applications for JERSEY, PARIS & ISTANBUL locations.

Project status reporting and project execution (Both with Business as well as DU Manager).

Mentoring & Supervising team to make sure 100 % compliance on deliverables.

Monitoring of Autosys jobs and providing resolution if any failures.

Unit, Regression, Integration, Performance Testing for the components Modified.

Support for I-Expense related issues and various setups involved.

Managing team activities and assessing junior resources.

Cemli & Reports development.

Also worked as trainer in Oracle apps at organisation level.

Environment:

Oracle Application 11i (AP, GL, FA),Custom module-170

GE Commercial Finance

Team Leader Role GE Commercial Finance is a worldwide provider of leases, direct loans and a wide variety of financial and equipment management services. TCS has been working in implementing/Enhancements/ Supporting Oracle Applications at GE Commercial Finance. GECF is having 7 different businesses like CEF (Commercial Equipment finance), VFS 9 Vendor Financial systems), EFS (Energy financial Services), HFS (Health care financial services), CRE (Commercial real estate), CFS (Commercial financial Systems) and Fleet services. GECF is with a vision to integrate and consolidate all these business under same common GE standards (GSS) with common Chart of accounts, Tax rules, reporting aspects etc. I was contributing in Integration/ Conversion/ Upgrade and Support of these business Oracle Application systems during 2006-2010.

Client :GE CFS NA – Global Oracle Applications Support 11i June2008-Dec2010

Oracle Techno-Functional Consultant (P2P, O2C, GL)

Tech Lead Role

Project status reporting and project execution.

Creating and Executing BR100 document to configure and implementing Oracle modules.

Interacting with Business Users, analysing change requests, requirements, impact analysis, and implementation of the same.

Document Preparation using Oracle Standard Implementation Methodology.

Monitoring of Customized Interface Processing.

Developing the Inbound interfaces and Extraction scripts as per the design document received as a Change Request.

Unit, Regression, Integration, Performance Testing for the components Modified.

Analysing problems or change requests from Business Users in enhancements in GL & Oracle Discoverer, assisting the users in building complex and data intensive discoverer reports.

Support for I-Expense related issues and various setups involved.

Co-ordinate with Oracle for TAR Resolution.

Enhancement activities - Enhancement is an update to an existing system providing or adding on new or revised functionality.

Assisting GE Operations Managers with SOX Activities like USER Audits, Change Management process, Business Continuity plans like (Hot/Cold backups, clones, and DR tests), Audit for Applications Setup changes, Interface Process/Data audits.

Worked as six sigma spoc for process improvement activities for entire account.

Environment:

Oracle Application 11.5.10.2, Oracle Database 10G, Discoverer 10G, Unix, I-Expense, Oracle Metalink Support, PL/SQL, SQL

Client: GE Real Estate – Global Oracle Apps Re-implementation Aug2007-Jun2008

Oracle Techno-Functional Consultant

Module Lead

Gathering client’s requirement and building Design Documents

Creating and Executing BR100 document to configure and implementing Oracle modules

Project planning, Resource Allocation, Timely execution of project

Interfaces Design with legacy systems

Data conversion scripts preparation and Automating Data Reconciliation process for Business.

Co-ordinating with DBA, UNIX team for the DB related changes and UNIX setups.

Weekly status reporting to Business and Operational Managers

Developing the Inbound interfaces and Extraction scripts as per the design.

Unit, Regression, Integration, Performance Testing for the components Modified.

Instance to Instance Migration of setups.

Support during the User Acceptance Testing.

Resolve issues in Integration, UAT & Regression tests

Month End & Quarter closing technical support in co-ordination with the functional support team.

Production Deployment and Post Production Support.

Environment:

Oracle APPS 11i (11.5.9) from 11.0.3 instance, Oracle Database 9i, Sun Solaris 5.6, PL/SQL, SQL

Client: GE NA Fleet Services – Global Oracle Apps Re-implementation Jul2006-Aug2007

Role: Oracle Techno-Functional Consultant

Team Member

Preparation of GL Data Conversion scripts for Opening Balances and detailed Transactions.

Instance to Instance migration of Setups like value set registration and loading of Values, Concurrent Program registration and Customized components registration.

Weekly Status report to Client and Daily reporting for Internal Team

AppWorx Handling of all chains and modules for the scheduled Components.

Building and scheduling of Discoverer Reports.

Production Deployment and Post Production Support.

Environment :

Oracle Application 11i (11.5.8), Oracle Database 9i, Discoverer 4i, PL/SQL,SQL

Client: Verizon Support-Gurgaon (Feb2006- Jul2006)

Set-up configuration analyst.

Worked as Tester in Oracle PL/SQL, SQL in Health and benefit’s Domain (ERP –TBD).

Creating Test scripts and sharing the results with business on daily basis on the changes implemented by Development team.

Training / Continuing Education Summary

Title

Organised by

Oracle Fusion (Cloud) Bootcamp

Capgemini

Oracle Financials AP, iExpense

Accenture

ILP [ Initial Learning Program]

TCS Training Dept.

Oracle Apps Boot Camp

TCS (Oracle Centre of Excellence, COE)

Six Sigma Awareness

TCS- Account Level training program

Oracle Discoverer

TCS Training Dept.

Oracle Financials GL

TCS (Oracle Centre of Excellence, COE)

Email Etiquettes and Communication Tips

TCS- Training Dept.

Personal Details

Nationality

Indian

Marital Status

Married

Passport & Visa Details

Name as on passport

Visa & Validity

Mahesh Kumar Nyati

H1B -April 2023

Morrisville, NC Mahesh Nyati

Contact this candidate