Bhanu Kosuri

acojva@r.postjobfree.com

804-***-****

Sr.ERP/PROJECTS & FINANCIAL FUNCTIONAL ANALYST/BSA/SME

IT Expertise Skilled Analysis

.Having 11+ years of professional experience in Oracle E-Business

Suite Release 11i/R12

.Extensive experience in requirement gathering, analysis, design,

setup, configuration, development, testing and support

. Worked on setup, configuration, development and support of RICE

components in Oracle E-Business Suite - Project Accounting and

Financial modules

. Functional expertise in Oracle General Ledger, Project Costing,

Project Billing, Account Payables, Account Receivables, Fixed

Assets, SLA, Cash Management, Oracle Time and Labor and I-Expenses

modules

. Technical expertise in Oracle Project Costing, General Ledger,

Project Billing and Payables modules

. Worked on implementation of various custom components in Oracle

Projects and Financial modules

. Worked on integration of Oracle Projects with Oracle General

Ledger, Account Payables, Purchasing, Time & Labor, Internet

Expenses, Fixed Assets and Receivables modules

. Well versed with Oracle Projects conversion, interface and client

extension processes

. Developed and configured data migration strategy from Legacy System

to Oracle EBS and vice versa

. Extensively worked on SQL, PL/SQL, UNIX Shell Scripting and

SQL*Loader utility

. Experience in System Administrator activities like defining

concurrent program executables, concurrent programs, user set up,

defining responsibilities, lookups, value sets, registering menus and

reports, OBIEE.

. Experience in project documentation for internal quality and SOX

audit

. Well versed in preparing and reviewing Oracle AIM BR100, MD050,

MD070, CV040, TE020, TE040

. Self motivated with excellent communication, interpersonal and

analytical skills.

. Worked extensively in Procure to Pay lifecycle and good knowledge

on Order to Cash cycle.

Professional Experience

Client: Kellogg Brown & Root (KBR Inc), Houston TX

Duration: June' 2014 - Present (Project Accounting Lead & Financial

Functional Consultant)

Environment: Oracle Applications Release R12 (Project Costing, Project

Billing, Project Management, Oracle General Ledger, SLA,

Accounts Payables, Account Receivables, Internet Expenses,

iProcurement, Purchasing, Fixed Assets, Oracle Time and

Labor, Cash Management, More4Apps.)

Responsibilities:

. Maintained proactive interaction with client to understand business

practices to aid in system configuration.

. Performed functional testing for various financial modules involving

P2P cycle and bug fixes.

. Worked as functional consultant for implementation of Oracle Project

Accounting (Costing & Billing)

. Worked on Project Hindcast comparing forecast of current month to last

month (Project Management)

. Conducted requirement gathering, gap analysis testing and

documentation.

. Drafted Project Implementation documents like BR100, BR-035 (Gap

Analysis).

. Performed the standard configuration and setups for project

accounting.

. Set-up of Expenditure categories and expenditure types.

. Validated Integration with Account Receivable: Project related

Purchase Order Integration with Payables: Import and Review Project

Expense

. Conducted demo of Contracts for Project Documentation, Deliverables,

Billing Initiation etc.

. Drafted the testing document (TE-050) for the Project Accounting (PA)

module and participated in SIT and UAT testing.

. Conducted CRP testing, developed test scripts carried out integration

testing.

. Designed and configured setup of flexfields.

. Implemented silent features of Project Accounting such as rate

schedule, transaction control, and auto accounting rules,

implementation of labor cost rate schedules.

. Prepared and laid out Auto Accounting rules based on segments

configured.

. Handled daily tickets related to various user problems in FA, AP, AR,

GL, CE, PJC, PJB, OTL Modules

. Worked as Apps system administrator and logged 25 TAR's with Oracle

Metalink, including quantitative data analysis and their

resolution/rollover.

Client: Geokinetics, Houston TX

Duration: Jan' 2014 - June'2014 (Project Accounting Lead & Financial

Functional Consultant)

Environment: Oracle Applications Release R12 (Project Costing, Project

Billing, Project Management, Oracle General Ledger, SLA,

Accounts Payables, Account Receivables, Internet Expenses,

Purchasing, Fixed Assets, Oracle Time and Labor)

Responsibilities:

. Maintained proactive interaction with client to understand business

practices to aid in system configuration.

. Conducted Business Process Review (BPR) and fit-gap analysis to

fulfill business requirements.

. Prepared various documents required under AIM methodology like MD50,

TE50 etc.

. Worked on different client extensions and customizing as per Business

requirement.

. Creation of expenditure types to interface supplier costs and

miscellaneous transactions.

. Designed functional specs for auto accounting rules.

. Configuration of Project Costing auto accounting to standardize stream

line the account generation for labor and miscellaneous transactions.

. Configuration of key areas in Project Costing and Project Billing and

suggesting suitable Business flow setups to client.

. Prepared Integrated test cases for each setup and End User training

material on Project Accounting module.

. Participated in SIT and UAT testing and conducted training sessions to

end users.

. Coordinated with Oracle On-Demand for team for issue resolutions on

patches, bugs etc.

. Supported Month End Close Issues and assisting users in completing the

transactions.

. Maintained historical records of problems solved to build knowledge

base for future issues.

. Performed Quality assurance reviews and supported Internal and

external audit teams for transactional and reporting questionnaire.

Client: ASRC Energy Services, Anchorage AK

Duration: June'13 - Dec-'13 (Project Accounting Lead & Financial Functional

Consultant)

Environment: Oracle Applications Release R12 (Project Costing, Project

Billing, Project Management, Oracle General Ledger, SLA,

Accounts Payables, Account Receivables, Internet Expenses,

iProcurement, Purchasing, Fixed Assets, Oracle Time and

Labor)

Responsibilities:

. R12 Upgrade Assessment and Impact Analysis on Project Suite of modules

. Worked with Business users to gather, evaluate, clarify and understand

business requirements.

. Building Trial R12 Upgrade Instances for conducting CRP Sessions

. Managed the CRP's and UAT's with global user base, signing off on

business test cases, managing the issues, managing the enhancement and

change requests from 11.5.10 to R12 conversions and upgrade projects.

. Assemble and coordinate with multiple cross-functional teams to

support releases of varying size and complexity.

. Showcasing R12 Delta Features.

. Functional Testing and defect resolution for functional and technical

components.

. Identifying nice to have features and road map for parking lot Items.

. Review the status reports to team members and address issues as

appropriate.

. Analysis and assessment of 3'rd Party Applications Interfacing with

Projects Suite

. Worked with Technical Team in re-designing CEMLI Components

. Perform detailed analysis of business and technical requirements and

design the solution through customizations of standard objects.

. Prepared BR100 document which is setup/configurations in the system

. Designed various process development and best practices documents.

. Raised SRs (Service Requests) to Oracle Support and aggressively

followed up the issues for timely resolution.

Client: Rosetta Stone, Sanfrancisco CA & Arlington VA

Duration: Nov'12 - May'13 (Project Accounting Lead & Financial Functional

Consultant)

Environment: Oracle Applications Release R12 (Oracle General Ledger, SLA,

Accounts Payables, Account Receivables Internet Expenses,

Order Management, Inventory, Concur, Fixed Assets, Project

Costing, Project Billing, Oracle Time and Labor)

Responsibilities:

. Design and documentation of functional specifications (MD050) for

Sales Force to OM Integration.

. Perform detailed analysis of business and technical requirements and

design the solution through customizations of standard objects.

. Design, Analysis and documentation around AR Invoicing, Customer

Invoicing and EFT

. Prepare & manage BRD, User Stories, Functional Specs, User Acceptance

Testing (UAT)

. Worked with Business users to gather, evaluate, clarify and understand

business requirements.

. Managed the CRP's and UAT's with business users, signing off on

business test cases, managing the issues, managing the enhancement and

change requests from 11.5.10 to R12 conversions and upgrade projects.

. Prepared BR100 document which is setup/configurations in the system

. Assemble and lead multiple cross-functional teams to support releases

of varying size and complexity.

. Created users, roles, public groups, queues, delegated administration

groups and implemented roles hierarchies, sharing rules and record

level permissions to provide shared access among different users

. Designed various process development and best practices documents.

. Review the status reports to team members and address issues as

appropriate.

. Data Mapping and validation of data between Legacy systems and Oracle

Projects & Financials

. Analysis of requirements, documentation of Integration approach to

Oracle Projects

. Worked as Apps system administrator and logged 30 TAR's with Oracle

Metalink, including quantitative data analysis and their

resolution/rollover to production

. Worked as the liaison between the Development Team and the Release

Management Team for the Release of new features and bug fixes

. Developed strong partnership with IT and Business Partners.

Client: Gap Inc, Sanfrancisco CA

Duration: Nov'11 - Oct'12 (Projects & Financials Functional Consultant)

GAP Inc. is one of the leading specialty retailers with 5 brands (GAP,

Banana Republic, Old Navy, Athleta & Piperlime) with more than 3100 stores

worldwide. Worked as Projects Lead supporting Gap Inc's 12.1.3 Upgrade.

Proposed recommendations for R12 upgrade, resolving upgrade issues,

configuring/setting up the system according to Gap Inc's Requirements.

Worked with multiple teams including directors, Finance Controllers, IT and

Business Team.

Environment: Oracle Applications Release R12 (Oracle General Ledger, SLA,

Vertex, Accounts Payables, Internet Expenses, Project

Costing, Project Billing, Project Management, Order

Management, Oracle Time and Labor, iSupplier, Fixed

Assets, Purchasing, eBiz Tax, Cash Management)

Responsibilities:

. Involved in review and preparation of functional and technical

documents using Oracle AIM

. Worked on Integration of Oracle Projects with other Oracle

Applications modules

. Supported CRP1, CRP2, UAT and Pre go-live activities, cutover

strategy, conversions, production setups and post production support

on Project Accounting module

. Worked with client on collecting the current business process and

documenting BP40

. Prepared BR100 document which is setup/configurations in the system

. Collected requirements and documented in BR30 document

. Identified future business process and documented BP80's

. Mapped the requirements to future business process and identified gaps

and documented in BR010

. Prepared MD20 document which is cost estimation for RICEW objects and

sent it for PMO/CCB approvals

. Prepared MD050 document for functional specifications for

customizations

. Worked closely with business team to gather requirements, analyze the

same to provide effort estimates.

. Worked on feasibility study and fit/gap analysis.

. Day to day support of interface and reconciliation process

. Troubleshooting of business critical issues reported by the users

. Performed SIT, support UAT on custom concurrent programs and defined

the same in production instance

Client: Saba Inc, Redwood City CA

Duration: Jan'11 - Oct'11 (Oracle Projects Lead & Financial Functional

Consultant)

Involved in design, implementation, testing and support of Oracle

Applications implementation of Saba Inc which is called Finance

Transformation project. I was responsible for collecting the current state

process, collecting the business requirements defining and documenting

future business process.

Environment: Oracle Applications Release R12 (Oracle General Ledger,

Accounts Payables, Internet Expenses, Project Costing,

Project Billing, Project Management, Project Resource

Management and Oracle Time and Labor, Fixed Assets,

Account Receivables, Cash Management, Order Management,

Inventory, Hyperion.)

Responsibilities:

. Carrying out requirement gathering, requirement analysis, high level

and granular level mapping, gap analysis, setups, functional and

technical extension modifications.

. Lead meetings with multiple project team on business side and prepared

meeting agenda's

. Prepared and reviewed MD050 and BR100 documents.

. Prepared CV40 document for conversions

. Prepared TE40 for test scripts and reviewed with Testing Team

. Prepared CV50 document for manual conversion process.

. Maintained Key decision document

. Assisted on design, configurations and involved in unit testing and

integration testing and CRP's.

. Provide functional expertise to developers during the technical design

and development phases of the project.

. Responsible for tracking support tickets for PA and Financial modules

according to business needs and support team capacity.

. Worked on localizations for different countries

. Worked as Apps system administrator and logged 30 TAR's with Oracle

Metalink, including quantitative data analysis and their

resolution/rollover to production.

. Validating and Testing Hyperion Reports and integration with EBS

. Involved in reviewing and approval of the change management process,

coordinating with project managers and finance directors on resolving

various issues related to design, preparing process required by agency

Client: NetApp, Sunnyvale CA & Amsterdam Netherlands

Duration: Jan'10 - Dec'10 (Projects Functional Consultant)

Environment: Oracle Applications Release R12 (Oracle General Ledger,

Accounts Payables, Internet Expenses, Project Costing,

Project Billing, Project Management, Account Receivables,

Oracle Time and Labor, iProcurement, Cash Management,

Hyperion)

Responsibilities:

. Worked closely with business team to gather requirements, analyze the

same to provide effort estimates.

. Worked on feasibility study and fit/gap analysis.

. Integration of Oracle Projects with other Oracle Applications modules

. Design & Integration of timecards from Pulse into OTL and interfacing

to Projects (PA)

. Design & Integration of Resource attributes from Pulse into Projects

to calculate Accrual Amounts.(PA)

. Enabled Project Expenditure types for Expense report entry (OIE)

. Configured User and Supervisor as Employee, Employee Supplier, and

signing limits for supervisor (OIE)

. Involved in design, integration and data mapping, data modeling for

reporting from Projects to OBIEE (eBI)

. Prepared and reviewed BR100 and MD050 documents.

. Day to day support of interface and reconciliation process

. Troubleshooting of business critical issues reported by the users

. Performed SIT, support UAT on custom concurrent programs and defined

the same in production instance

. Requirement gathering for all the new interfaces to be included in the

interface toolkit

. Involved in review and preparation of functional and technical

documents using Oracle AIM

. Loading of credit card data in to AP orgs as requested by the users

during month end

. Worked on service requests related to Oracle Internet Expenses module

. Worked on Catalogs and punch-out's in iProcurement

. Defined set ups for employee expense templates, employee supervisor,

signing limits, employee supplier, users and securing attributes

. Correcting the journals which are waiting in interface table, posting

or deleting the journal batches as requested by users, scheduling auto

post programs in GL as per the cut off dates during month end

Client: Gulf States Toyota, Houston, TX

Duration: May'09 - Dec'10 (Functional Consultant)

Environment: Oracle E-Business Suite Release 12 (Project Costing, Project

Manufacturing, Oracle General Ledger, Subledger Accounting, Payables,

Purchasing, Cash Management, Receivables, Order Management, FAH)

Responsibilities:

. Worked closely with business team to gather requirements, analyze the

same to provide effort estimates

. Responsible for plan, design and execution of project effectively

under deadlines

. Setup and configuration of Subledger accounting as per the business

requirements

. Configured Journal line types, Journal entry description, Account

derivation rules, Journal line definitions, Application accounting

definitions, Subledger accounting methods and attaching SLAM to Ledger

for Payables to SLA setup

. Defined custom setups for Oracle Subledger Accounting

. Prepared and executed test cases as part of unit and integration

testing

. Prepared and reviewed BR100 and MD050 documents

. Coordinated with multiple teams during implementation and transition

phases

. Develop and execute plans for deploying the applications into

production environment

. Worked on Invoice and Revenue Recognition Processes (AR).

. Provided training documents on Oracle SLA features and functionality

. Demonstration of Oracle SLA module functions and features

. Facilitated and supported Issues around Revenue Recognition

. Facilitated knowledge transfer sessions for new team members

. Oversee and facilitate the work of others (developers and other

analysts) in support of the project execution process

Client: Pearson, Bloomington, MN

Duration: Nov'08 - Apr '09 (Functional Consultant)

Environment: Oracle E-Business Suite Release 11.5.10 (Oracle Project

Costing, Project Billing, General Ledger, Fixed Assets, Receivables,

Internet Expenses, Time and Labor, Purchasing, Payables, iSupplier)

Responsibilities:

. Worked on requirement gathering, analysis, solution design, setup,

configuration and development

. Mapping of business requirements to module capabilities

. Worked on level of effort analysis

. Worked on the custom setup of auto accounting

. Integration of Oracle Projects with other Oracle Applications modules

. Developed functional, technical and setup documents using Oracle AIM

. Developed and executed plans for deploying the applications into

production environment

. Coordinated with technical team in writing various data extraction

programs

. Customized Acknowledgement of PO (iSupplier)

. Coordinated with multiple teams in development and transition phases

. Facilitated knowledge transition sessions for new team members

. Prepared test case and migration documents

. Creation of concurrent programs, executables, lookups and value sets

in various modules of the application

. Ad-hoc demonstration of module functions and features

. Full Solution Development Life Cycle (SDLC) Support

Client: Zion's Bank, Salt Lake City, UT

Duration: May'08 - Oct'08 ( Projects and Financial Functional Consultant)

Environment: Oracle E-Business Suite Release 11.5.10 - R12 Upgrade (Oracle

Project Costing, Project Billing, Internet Expenses, Purchasing, Payables,

Fixed Assets, Time and Labor, General Ledger, Cash Management, Receivables)

Responsibilities:

. Involved in setup, configuration and implementation of Oracle Project

Costing and Project Billing modules as per the business requirements

. Developed transaction import interface to load data from external

systems into Oracle Projects

. Defined implementation options, project types, project templates,

project statuses, expenditure categories, revenue categories,

expenditure types, transaction controls, labor cost and non labor cost

implementation steps

. Created capital projects, defined assets, collected costs, generated

asset lines, interfaced assets to Oracle Assets and tieback asset

lines with Oracle Projects

. Created contract projects, defined agreements and funding, generated

revenue and invoices, interfaced revenue to General Ledger, interfaced

invoices to Account Receivables

. Supported UAT on setups and interface process to ensure that the

business expectations have been met

. Develop and execute plans for deploying the applications into

production environment

. Integration of Oracle Projects with Internet Expenses and Time & Labor

. Developed technical, functional and setup documents using AIM

methodology

Client: CARQUEST, Raleigh, NC

Duration: Jan'08 - May'08 (Functional Consultant)

Environment: Oracle E-Business Suite Release 11.5.10 ( Oracle General

Ledger, Internet Expenses, Payables, Purchasing,

iProcurement, System Administrator), SQL, PL/SQL, UNIX

Shell Scripting, Discoverer, SQL*Loader, Putty, TOAD,

Oracle AIM

Responsibilities:

. Developed data conversion program to transfer GL Artesia transactions

to the new 11.5.10 global instance

. Validation of conversion program for each period

. Identifying the missing mapping values and verifying with the business

. Documented As Is Process of GE Global interface toolkit

. Facilitated knowledge transfer for GE Global interface toolkit

. Requirement gathering, developing control files as per the data file

format, handling validations in control files using functions, testing

and deploying the interfaces into production environment

. Developed outbound interfaces using shell script programs to provide

the required data to reconciliation team

. Customized Requisition Approval Workflow (iProcurement)

. Sending the outbound interface files to reconciliation team IP address

through FTP using shell script programs

. Sending e-mail notifications to user distribution list about success /

failure of outbound interface process using shell script programs

. Day to day support of GL and AP interfaces

. Loading of credit card data in to AP orgs as requesting by the users

during month end

. Worked on service requests regarding Oracle I-Expenses module

. Defined set ups for employee expense templates, employee supervisor,

signing limits, employee supplier, users and securing attributes

. Involved in preparation of MD070s for all new interfaces

. Troubleshooting the business critical issues for the smooth

functioning of the applications

. Oversee and facilitate the work of others (developers and other

analysts) in support of the project execution process

. Analyzed report requirements, created new discoverer reports and

customized existing discoverer reports as per business requests

. Sharing discoverer business areas and reports with business users

. Worked as a configuration controller during CMMi level 5 appraisal

. Worked on SOX audit documentation

Client: Gateway, Sioux City, SD

Duration: July'07 - Dec'07 (Functional Consultant)

Environment: Oracle E-Business Suite Release 11.5.9 (Oracle General Ledger,

Payables, Internet Expenses, Receivables), SQL, PL/SQL,

UNIX Shell Scripting, Discoverer, SQL*Loader, Putty, TOAD,

Oracle AIM

Responsibilities:

. Interacted with multiple data vendor teams, requirement gathering,

analyzing and preparing setup and functional documents for new

interfaces

. Prepared and reviewed setup documents, MD050s and MD070s for all new

interfaces

. Loaded credit card data in to AP orgs as requesting by the users

during month end

. Worked on service requests related to Oracle Internet Expenses module

. Defined set ups for employee expense templates, employee supervisor,

signing limits, employee supplier, users and securing attributes

. Corrected the journals which are waiting in interface table, posting

or deleting the journal batches as requested by users, scheduling auto

post programs in GL as per the cut off dates during month end

. Day to day support of GL interfaces and reconciliation process

. Troubleshooting business critical issues reported by the users

. Designed and developed GL outbound interfaces using UNIX shell script

programs

. Created UNIX Shell script programs to automate the FTP process for

receiving and sending the files from many data vendors

. Sent e-mail notifications to user distribution list about

success/failure of inbound/outbound interfaces using shell script

programs

. Performed UAT on custom concurrent programs and defined the same in

production instance

. Oversee and facilitate the work of other team members in support of

the project execution process

Client: Maximus, Austin, TX

Duration: Dec'06 - June'07 (Functional Consultant)

Environment: Oracle E-Business Suite Release 11.5.9 ( Oracle General

Ledger, Internet Expenses, Payables, Purchasing, System

Administrator, Grant Accounting, Project Costing), SQL,

PL/SQL, UNIX Shell Scripting, Discoverer, SQL*Loader,

Putty, TOAD, Oracle AIM

Responsibilities:

. Converted Award Expenditures from Legacy system into Oracle based on

different Transaction Sources (GMS)

. Converted Projects from Legacy system to Oracle Projects using AMG

(PA)

. Part of Award Conversion Team (Team of 2) to convert Awards from

Legacy System to Oracle Grant Accounting using Oracle Private API's.

(GMS)

. Converted Project and Award Budget and developed an application that

creates Draft Award Budget based on funding pattern and baseline it is

using API (GMS)

. Worked on Project and Award Status reporting (GMS)

. Requirement gathering, developing control files as per the data file

format, handling validations in control files using functions, testing

and deploying the interfaces into production environment

. Developed outbound interfaces using shell script programs to provide

the required data to reconciliation team

. Sending the outbound interface files to reconciliation team IP address

through FTP using shell script programs

. Sending e-mail notifications to user distribution list about success /

failure of outbound interface process using shell script programs

. Day to day support of GL and AP interfaces

. Loading of credit card data in to AP orgs as requesting by the users

during month end

. Worked on service requests regarding Oracle I-Expenses module

. Defined set ups for employee expense templates, employee supervisor,

signing limits, employee supplier, users and securing attributes

. Involved in preparation of MD070s for all new interfaces

. Troubleshooting the business critical issues for the smooth

functioning of the applications

. Oversee and facilitate the work of others (developers and other

analysts) in support of the project execution process

. Analyzed report requirements, created new discoverer reports and

customized existing discoverer reports as per business requests

Hanson Constructions, Irving, TX

JAN 2005 - NOV 2006

Environment: Oracle E-Business Suite Release 11.5.10 (Oracle Project

Costing, Project Billing, General Ledger, Fixed Assets, Receivables,

Internet Expenses, Time and Labor, Purchasing, Payables).

Responsibilities:

. Conducted Business Process Review (BPR) and fit-gap analysis to

fulfill business requirements

. Worked on Integration and solution of Project Accounting to Fixed

Assets

. Involved in setup of Project Billing Module --auto accounting, event

type, implementation options and Bill Rate Schedules

. Worked on requirement gathering, analysis, solution design, setup,

configuration and development

. Mapping of business requirements to module capabilities

. Worked on level of effort analysis

. Worked on the custom setup of auto accounting

. Integration of Oracle Projects with other Oracle Applications modules

. Developed functional, technical and setup documents using Oracle AIM

. Coordinated with Offshore Technical Team and provided proper inputs

for issue resolution.

Education & Credentials

Master of Science in Engineering (M.S.) - Idaho University, USA

Bachelor of Engineering (B.E.) - Visweswaraiah Technological University,

India. [pic]

Contact this candidate