Kishore Karanam

ac18yp@r.postjobfree.com

SUMMARY:

Oracle Functional Consultant with strong educational background and around 10 years of industry experience including 9 years of Oracle E- business Suite experience.

Implementation and Upgradation Knowledge of Oracle EBS modules which include General Ledger, Account Payable (AP), Account Receivables (AR), Fixed Asset (FA), Cash Management (CM), EB- Tax and System Administrator (Sys Admin).

Worked on Implementations, and Upgrade projects, including implementations in Oracle R12 (R12.0.3, R12.0.5, R12.0.6, R12.1.1, R12.1.3) and 11i (11.5.8, 11.5.9, 11.5.10, 11.5.10.2)

Understanding business processes and gathering of user input for the purpose of laying out the Functional Cutover plan

Comprehensive knowledge in preparation and maintenance of Oracle AIM methodology (RD20, BR30, BP80, BR100, MD50, CV040 and TE40 etc.

Experience in preparing other project documentation like As-Is and To-Be Process Flows.

Well versed with the understanding of Oracle R12 including Sub-ledger Accounting (SLA), FSG reporting.

Knowledge in Multi org, Multi-Currency, Revaluation, and Translation

Provide best oracle practice to client based on their nature and size of the organization including their existing transaction process flow with periodic document updates and responsible for getting signoff from respective business owners.

Demonstrated ability to quickly grasp new concepts and methods

Experienced in identifying GAPS, providing Fit-Gap analysis and solution designing to the RICE components, and coordinate technical team for the timely deliverables

Facilitated and participated in Joint Application Design (JAD) sessions, user workshops, conference calls and white board sessions to plan strategic Business decisions and detailed systems design.

Proficient skills in executing SQL queries using Toad.

Interaction with Oracle Technical Support on priority Service Requests.

Monitor and assist in resolving issues regarding the team's approach, staffing, responsibilities, and schedule

Communicate team member roles and expectations

Professional Experience:

Client: Dresser-Rand A Siemens Business. Feb, 2016 - Present

Role: Oracle Financials Functional Analyst

Location: Houston, TX

Modules/Skills used: Integration project of Oracle R12.1.3 (GL, AP, AR, FA, SLA) Post Production Support of (GL, AP, AR, CM, SLA) to SAP.

Responsibilities:

As a Functional Consultant my Responsibility was to analyze the Global Design project planning Integration and Re-Implementation approaches and deploy to the rest of countries as a part of integration and re-implementation and post production support plan.

As a part of Siemens integration project client requirement is to update Fiscal Calendar from Calendar year to Siemens Fiscal Year alignment (OCT01-SEP30).

Eprentise a third party vendor has assigned the task to update the Calendar Year to Fiscal Year.

Work closely with the Eprenstise technical team after post conversion of eprentise software steps.

Identified bugs with Eprentise software and suggested enhancements to the conversion as Translated Balances and Summary account balances are not reconstructed as part of their conversion.

Design and Develop impacted FSG reports based on country specific requirements due to calendar changes.

Extensive testing was done on all GL functionalities to verify the GL balances are intact after the calendar changes in place.

Conduct workshops and training sessions with Business users to explain the calendar changes impact pain points

Captured high level additional requirements Future Business Model (BP 080) for GL,AP,AR and CM modules, prepared the GAP Analysis document based on the study and then also prepared the setup Documents (BR 100).

Preparing MD 50 documents as part of calendar change solution design for AR, AP, GL custom reports.

Experience in creating, maintaining, and executing test cases and test labs using HP Quality Center /ALM for System Integration Test and User acceptance test cycles.

As part of Siemens integration Solutions for Record to Report (R2R) a third party Journal Approval tool Trintech Cadency is implemented.Siemens mandate the use of Trintech to support and control the Journal Approval, Account Reconciliation and assist in month end closing by integrating Oracle with Trintech.

Involved in the solution design discussion to build the needed interfaces from Trintech to Oracle and vice-versa.

Prepare and review MD050 documents as part of requirement to extract the approved joiurnal entries (Spreadsheet, Manual and Recurring nature in Oracle) in Trintech, interface to Oracle, import, post, and send the confirmation of successfully posted, or errors with error codes back to Trintech in the .txt format.

Responsible for design and preparing MD 50 document to provide visibility to the net currency position of each currency that each Dresser-Rand operations (reporting through Oracle) transacts in, for purposes of determining the foreign currency exchange open risk exposure for the entity that should be evaluated for purposes of currency hedging and associated hedge accounting.

Client: American Axle & Manufacturing Holdings Inc. Jan, 2015 – Feb, 2016

Implementing Partner: Centroid

Role: Oracle Financials Functional Analyst

Location: Southfield, MI

Modules/Skills used: Re-Implementation of R12.1.3 (GL, AP, AR, FA, CM, SLA) Post Production Support of (GL, AP, AR, CM, FA, SLA)

Responsibilities:

As a Functional Consultant my Responsibility was to analyze the Global Design project planning Integration and Re-Implementation approaches and deploy to the rest of countries as a part of re-implementation and post production support plan.

Conduct workshops with Business users to gather requirements and understand pain points

Captured high level additional requirements Future Business Model (BP 080) for GL,AP,AR and CM modules, prepared the GAP Analysis document based on the study and then also prepared the setup Documents (BR 100).

Prepared Current Assessment and Recommendation documentation for clients existing modules GL, AP, AR, CM for Mexico Entities.

Preparing MD 50 documents as part of solution design for AR, AP, GL, and CM. As client system is dependent on counter party system.

Preparing MD 50 documents as part of solution design for GL Budgeting without enabling Encumbrance accounting. As client replace their existing Budgetary control Funds Check system PIRS to use Oracle System.

Preparing MD 50 documents for interfaces from Oracle to Bank for Mexico Entities for Bank of America, Citibank & Banamex.

Preparing MD 50 documents for Check print solutions for Mexico entities for Banks BOA, Banamex.

Implemented BAI2, SWIFT940 bank statements format transaction codes in Oracle Cash Management as per Bank specifications.

Translated high-level, complex business requirements into functional specifications for client & Created detailed process business requirement documents for Budget by Cost center Functionality as discussed with the business end users for Mexico & Brazil.

Defining existing global design SLA Rules for AP, AR, FA, Cost management modules for Europe countries. Setting up SLA customizations for AP/AR/FA/Cost Management as per requirement for each entity.

As part of SLA Setups Create Journal Line Types, Create Journal Lines Definition, Create Application Accounting Definitions, Create Sub ledger Accounting Methods.

Defining Custom Account Derivation Rules, conditions and custom sources as per client requirement for AP, AR, FA and Cost Management.

Design and Develop FSG reports based on country specific requirements.

Partners with business and gains solid understanding of business requirements on financial reporting. Understand existing reports.

Document usage of the reports and finalize final set of existing reports which will be used as-is or needs further modifications

Writes/Reviews functional specification documents for finance reports on OBIEE

Work with technical team to build the reports

Level1 Support to All financial users.

Provides recommendations and solutions to problems

Responsible for diagnosing the root cause analysis of the support issues observed to avoid reoccurrence of such issues in the future.

Assists business with acceptance testing of final project results.

Ability to work cooperatively and collaboratively with all levels of employees and management.

Client: Global Partners Feb, 2014 – Dec, 2014

Implementing Partner: AT&T

Role: Oracle Financials Functional Analyst

Location: Waltham, MA

Modules/Skills used: Implementation of R12.1.3 (AR, CM) Production Support of (GL, AP, FA, OIE)

Responsibilities:

As a Functional Consultant my Responsibility was to do GAP Analysis project planning Integration and Implementation approaches and post production support plan.

Conduct workshops with Business users to gather requirements and understand pain points

Captured high level additional requirements Future Business Model (BP 080) for AR and CM modules, prepared the GAP Analysis document based on the study and then also prepared the setup Documents (BR 100).

Prepared Current Assessment and Recommendation documentation for clients existing modules GL, AP, OIE.

Experience in implementing Automatic Receipts and Remittance functionality in R12 Accounts Receivables.

Preparing MD 50 documents as part of solution design for AR, AP, GL, and CM. As client system is dependent on counter party system ETRM.

Preparing MD 50 documents for interfaces from Oracle to Bank (Direct Debit).

Implemented BAI2 bank statement format transaction codes in Oracle Cash Management as per Bank specifications.

Involved in designing the functional specifications of interfaces from counter party systems.

Work closely with technical team to ensure code delivery aligns with functional specifications and requirements.

Implemented mapping the bank layout NACHA file format for the client requirement to Direct Debit functionality in R12 Accounts Receivables

Production support – month-end reconciliation, interface issues, support enhancements, ad-hoc reports, bug fixes.

Issue resolution using Oracle Support, creation and follow up of Service Request with Oracle.

Review and Resolve Reconciliation between sub-ledger and general ledger.

Assist in new users in understanding the modules and other day to day activities

Periodic User Training for new employees.

Level1 Support to All financial users.

Responsible for diagnosing the root cause analysis of the support issues observed to avoid reoccurrence of such issues in the future

.

Client: NOV Wilson March, 2013 – Dec, 2013

Role: Oracle Financials Functional Support Analyst

Location: Houston, TX

Modules/Skills used: Production Support on R12 (GL, AP, AR, FA, SLA, PO)

Responsibilities:

Provide production support of the Oracle Financials R12.

Support the Remedy application for Helpdesk to assign tickets.

Support users in application error analysis and resolution.

Involved in Month-end support for close and reconciliation for AP and AR modules.

Prepared impact analysis for critical issues.

Resolved issues that occurred in the production.

Have followed up with the business for approval of the resolved issues.

Worked with the business to develop updated business policies based on issues resolved.

Actively involved in troubleshooting various issues.

Ability to write functional specifications for technical development.

Interacted with Oracle Support to resolve critical issues through SR/TAR

Perform application configuration and setup across Financial Modules of Oracle Application

Familiar with Oracle financial tables & the ability to write SQL queries

Provide support and recommendations to improve existing custom extensions and reports

Contact My Oracle Support raise SR’s and resolve critical issues on severity basis.

Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.

Client: CGGVeritas April, 2012 – December, 2012

Role: Oracle Financials Functional Support Analyst

Location: Houston, TX

Modules/Skills used: Upgrade and Production Support on R12.1.3 (GL, AP, AR, FA, SLA AP, EB- Tax)

Responsibilities:

Responsible for preparing upgrade plan for GL, AP & FA

Provide production support of the Oracle Financials R12

Facilitates the translation of business requirements into detailed functional requirements and works with IT to arrive at optimal best practice solutions

Prepared impact analysis document for the upgrade of financials module

Created users and modified the privileges for users, rollup group and summary accounts.

Responsible for setting up delta functional like MOAC, Data Access sets.

Conducted UAT and closed UAT issues on a timely basis.

Responsible for complete functional testing and resolving issues

Research, analyze, recommend and execute improvements to current processes and systems.

Develop, coordinate, and implement test plans for functional changes, bug fixes, enhancements, patches and upgrades

Configure, modify and develop application configurations and integrations within the Oracle Financial modules

Develop queries or reports to address operating needs of end-users

Analyze data, design and integration points to upstream and downstream applications that feed into and require data from Financial applications

Understand and adhere to IT quality controls, including development of test plans and scripts, providing proper documentation, respect of access and change control processes.

Support EB-Tax Production Issues related to tax configuration, tax regimes etc..

Participated in training sessions on Localizations limited to country specific training only.

Contact My Oracle Support raise SR’s and resolve critical issues on severity basis.

Client: Farmers Insurance Corp April, 2010 – April, 2012

Role: Oracle Financials Functional Analyst

Location: Los Angeles, CA

Modules/Skills used: Implementation of R12.1.3 (GL, AP)

Responsibilities:

Interacted with the Business and analyzed existing business practice and prepared business requirement document and identified Gaps.

Defined Business requirements for Oracle General Ledger, Accounts Payable.

Involved in preparation of test scripts (TE40) for all business areas in GL, AP.

Prepared Documentation of BR100, BR30 and Functional Extension and design Document MD50.

Conducted Conformance Room Pilot (CRP).

Created Chart of Accounts, calendar and currency according to the business requirement.

Defined Primary Ledger, secondary ledger and defined accounting setup options.

Setting up General Ledger, consolidation ledgers, FSG reports (Income statement, Cash flow statement, and Balance sheet statement).

Defined, Configured and implemented Chart of Accounts, Value Sets, Ledger, Security Rules, Cross Validation Rules, Calendar, Journal Source, Journal Category.

Configured the financials and payables options.

Defined payment terms, distribution sets, matching tolerances for purchase order matching and set up of bank details.

Set up included Defined Invoice attributes- Payment Terms, Approve, Hold & Release and Distribution Set.

Defined Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes.

Defined Payment Attributes-Payment Formats, Bank Account, Payable Documents.

Open/Close of payable Accounting periods, and Payable Transfer to GL.

Defined the Setup of Recurring Journals, Stat Journals & Mass Allocation Journals.

Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment.

Defined supplier sites, suppliers, and banks for payable use.

Responsible for creating Request sets and Concurrent Programs and scheduling various tasks as per requirements.

Perform the related setup tasks in the applications that work together with Expenses template to create an integrated environment for expenses reporting.

Client: Schneider Jan, 2009 – Feb, 2010

Role: Oracle Financials Functional Analyst

Location: Green bay, WI

Modules/Skills used: Upgrade of Oracle 11.5.10.2 to 12.1.1 (GL, AP, AR)

Responsibilities:

Participated in multiple business meetings for Fit-Gap Analysis and Solution.

Assisted functional analyst to conduct CRP1 and CRP2.

Involved in configuration of CRP1, UAT and test instance.

Involved in reviewing the Current Business Model (BP040) and designed the Future Process Model (BP80).

Prepared Application setup (BR100) and Application Extensions Functional Design documents (MD50) according to AIM.

Trained Business Users and troubleshooting during User Acceptance Test (UAT).

Define Legal Entity, ledger with using Account Setup Manager (ASM).

Design Intercompany Accounting.

Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.

Involved in setup for Payables, General Ledger based on deep understanding of the functional processes.

Defined the Payables and Financials Options.

Set up Recurring journals template, recurring journals and Auto-reversal in GL.

Design & Develop FSG reports in GL.

Set up AP bank accounts, bank documents, bank codes and expense report templates.

Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc and Setting up Payment methods, Payment format and Payment Process Profile etc.

Set up suppliers, locations.

Setup payment terms, invoice distribution, matching of invoices against PO.

Defined setup steps of the AR module. These included System Options, Receipts, and Lockbox.

Defined Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets.

Defined Invoicing information including Payment Terms, Invoicing and accounting rules.

Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets.

Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos.

Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types.

Defined profile options to specify certain implementation parameters.

Involved in analyst financial data in conversion life cycle.

Used the System Administrator responsibility to define users and assign responsibilities and set profile options.

Participated in testing, user accepting testing in test instance and worked with certain key super users

Client: State Street May, 2007 – Dec 2008

Role: Oracle Financials Functional Analyst

Location: Boston, MA

Modules/Skills used: Implementation of Oracle 11.5.10.2 (GL, AR, FA)

Responsibilities:

Defined Business requirements for Oracle GL and AP, involved in identifying GAPS.

Worked with the client team in understanding the business processes to prepare the business requirements definition document.

Responsible for successful CRP1 and CRP2.

Created BR100, RD20, MD50 and CV40 document for AP, GL.

Set up Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Set of Books.

Carried out the setup of General Ledger, Accounts Receivables, and Fixed Asset modules.

Defined value sets, segments, and rollup groups with security and cross validation rules.

Designed and setup the multi-org structure based on organization structure and client requirement.

Created value sets for report parameters and registering them in oracle application for validation of values entered.

Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.

Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment.

Set up Fixed Assets including defining category, location, and asset key flex fields.

Created mass additions, worked on Mass additions program and Asset workbench.

Defined the prorate calendars, depreciation rate and calendars, fiscal calendars.

Setup book controls, corporate book and tax book.

Define different deprecation method for corporate book and tax book.

Designed Financial Reports using Financial Statement Generator (FSG) tool.

Prepared the setup documents and configured system according to business requirements.

Defined Customers, organizations, locations.

Defined payables lookup, payables option, set up bank details, invoice payment terms.

Defined distribution sets, matching tolerances for purchase order matching, payment programs and payment formats.

Created different types of invoices and payment methods.

Setup financials and payables options including all key configurations in Accounts Payable

Corrected misclassified accounts in GL.

Client: Hewlett Packard /Brigade Corp March, 2004 – Feb, 2007

Role: Oracle Financials Functional Analyst

Location: Bangalore, India

Modules/Skills used: Upgrade from Oracle 11.5.8 to 11.5.10 (GL, AR, AP, FA and CE)

Responsibilities

Identifying standard functionality, and analyze gaps and complete solution for GL, AR, AP and CE depending on Business requirement..

Team member of the core implementation team. Created the setup documents.

Prepared Application configuration setup BR.100 and MD.50 Application Extensions Functional Design documents according to AIM.

Analyzed the business flow and involved in defining and finalizing Cost Center Segment for Chart of Accounts and defining security rules.

Creating new OU and responsibilities and assigning to users and Setting profiles as needed.

Defined Payment Terms, Tolerances, Financial and Payables Options, Aging Periods, Supplier Entry.

Setting up of banks, bank branches and bank accounts.

Set up the auto accounting and accounting rules.

Defined security and cross validation rules.

Defined recurring invoice templates. Set up employee expense templates and distribution sets.

Defined Payment terms, Transaction types,Sources,Auto accounting

Created receipt sources, receipt classes, Receivable activities.

Set up of fiscal calendar in FA that map to the new GL calendar.

Created new corp. books and tax books that are associated with new calendars and prorate conventions.

Assign asset categories to corresponding new corporate book and tax book.

Converted assets from old books to new books.

Configured new prorate conventions based on the fiscal calendars.

Trained end users in using Web ADI tool to upload day to day adjustment journal entries.

Designed and implemented bank statement reconciliation with Accounts Payable and Accounts Receivable transaction as part of Cash Management Implemented.

Designed and implemented bank statement import and bank statement reconciliation process.

Prepared and did extensive testing of TE 040 test scripts.

Generated financial statements (Income statements, Balance sheets) using Financial Statement Generation (FSG).

.

.

Client: GSI Lumonics Sept 2003 – Feb, 2004

Role: Jr Business Analyst

Location: Hyderabad, India

Responsibilities:

Researched and assessed client systems and business processes.

Explored all aspects of the claim processing lifecycle, starting from identifying a claim to its closure.

Used MS Word document for requirement gathering.

Worked intensively on various phases in the project lifecycle to design the system.

High risk claims could be easily identified and monitored.

Participated in preparing basis for Project Vision documentation.

Involved in walkthroughs with business team, architects and developers to refine the requirements.

Implemented Traceability Matrix and User Requirement Specification Document (URS) to verify the functionality.

Streamlined clerical work processes and mapped to the automated system.

Involved with the Software Quality Assurance (SQA) Team to develop Test plans.

Contact this candidate