Project Oracle
Resume:
Bhanu Kosuri
********@*****.***
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