Post Job Free

Resume

Sign in

Oracle Financials Functional consultant

Location:
Alpharetta, GA
Posted:
September 23, 2015

Contact this candidate

Resume:

Sreedevi Koppala

acrtgi@r.postjobfree.com

Summary:

Over 10 years of IT Experience including successful hands-on ERP experience in Oracle Application Development, Global Implementation, Testing, Upgrade and Support

Efficient identification and gathering of Business Requirement, Business Process Analysis, Gap Analysis, Design, Requirements Definition, Development and Testing

Worked on SLA(Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction

Proficient in delivering apt Techno-Functional skills to accomplish the project goals using the extensive experience gained in Oracle - GL, AP, PO, EB Tax, Projects and CE

Remarkable negotiation and coordination skills with the Global / Offshore Business Partners, External systems and Team members

Experienced in P2Pcycle

Exposure to SYSADMIN including managing concurrent programs & managers, application User setup, defining responsibilities, Values Sets, Flex field and Registering menus

Expertise in preparing Test Plans and Test Scripts for carrying out Functional, Integration and User Acceptance Testing

Excellent team player, quick learner, highly motivated and ability to work independently

Demonstrated skills in problem identification and solution framing, interpersonal relationship building with outstanding written & verbal communication skills

Good Understanding of Industry business process in financial arena

Technical Skills:

Operating Systems : Windows 95/98/2000/NT and UNIX.

ERP : Oracle Applications 11i/R12

Other Software Packages : MS-Word, MS-PowerPoint, MS Excel

Modules : AP, AR, GL and Ebiz Tax

Services : SLA (Sub Ledger Accounting)

Axis Insurance DEC’ 13 to Till Date

Implementation & Production Support

Alpharetta, GA

Responsibilities:

FAH:

Played Key Role while Implementing the Financial Accounting HUB(FAH)

Worked Closely with Business in gathering Requirements (Initiation) Phase

Participated and demonstrated the Functionality of FAH during the CPR Sessions

Followed AIM Documentation in Preparing BR100, TE 40’s

Supporting users on daily Productions issues

Used Oracle SQL Developer to debug the issues in production and notify the users same

Fetching data from Non-Oracle database via FAH to Oracle by defining Sub ledger Accounting setups using Accounting Method Builder : Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements

Achieved Business Complex Accounting rules via Account Derivation Rules

GL:

Configured Legal Entities, Ledgers, Value Sets, Data Access Set, Sequence, Journal Source, Journal Category, Currency, Rates and Ledger Sets

Configured Complete COA Structure, Primary and Secondary and Statutory Ledgers, Legal Entities

Configured Intercompany Setups, Mass Allocations, Revaluation, and Translations

Defined Request Set and Interfaced the data to oracle via FAH by scheduling Interface Jobs from Legacy Systems

Defined Cross Validation Rules for Various ledgers, Migrated Complete Set of CVR Rules to Production using Data Loader

AP & FA

Configured Complete ACH Setups in Accounts Payables

Configured Asset Flexfield, Depreciation Method, Book Controls, Quick Codes, Asset Categories.

Configured Banks Accounts, LookUps, Aging Periods, Payment Methods, XML Publisher Format Template, Formats, Payment Documents, Payment process profile, Payment Systems, System security Options, JLD’s and Supporting References

Hyperion:

Supported and Interfaced data from SunGL to Hyperion Financial Management in Production Env

Updated and Modified Metadata file Using Hyperion Client

ENV: ORACLE R12, AP, FA, GL, FAH

ROLTA INTERNATIONALS INC., AUG ‘12 to Nov’ 13

Location: Alpharetta, GA

Implementation & Production Support.

Responsibilities:

Production Support:

Handled both the implementation of Oracle Projects and users support on the day

to day use of the application

Supported Accounts Payable, Purchasing, Cash Management and Receivable, GL, HR and OTL on the day-to-day operation of the Departments for functional issues

Supported production environments and users on a daily basis by responding to emergency requests

Analyzing user needs, conferring with users to improve procedures and identifying and solving problems

Gathered and converted the requirements into Process flow charts and Documents

Used AIM Methodology for Documentation

Designed test scripts of all sub-process identified in assessment phase

Demonstrate approaches to replace the legacy systems with Oracle e business suite Projects suite

Trouble shooting end to end Orders flow

Worked with Development team during the Data Migration to Oracle projects from Legacy systems

Proposing solutions, evaluating setups and flows based on the key business drivers such as work Break down structure, revenue recognition, Invoice Formats, Cash Forecasting, Project Managers Reporting Options

Defined Expenditure Types, Expenditure and Revenue Categories, Transaction Sources

Defined Complete Cost Process Flow in Projects to Interface data between various modules like Payables, Receivables, PO, OTL, Expense Reports to Oracle projects

Worked as a liaison between users, developers and technical staff regarding application, database and performance issues. This included troubleshooting and follow-up with Oracle Corporation’s technical support.

Configured Billing Setups like Bill Rates, Event Types, Invoice Formats, AR Transactions type Extensions.

Defined Project Setup: Project Templates, Projects Types, Project Role and Service Types,

Project Classifications, Project Statuses

Configured Auto Accounting Rules like Labour Revenue, Expense Revenue and Lookup sets for Projects.

Defining Suppliers, Supplier sites, supplier types and pay groups to classify suppliers into various categories

Generated and Recognized Revenue in project Billing

Configured Workflow notifications for Draft Invoice Approvals

Post go-live support.

Configured ACH/Electronic Payments as a Enhancement Feature in Oracle Payments

Performed corporate credit Card setups to consolidate the Payments.

Configured Automatic Receipt creation via Lockbox in Receivables

Defined and ran Income Statement Reports using Financial Statement Generator

Defined and Used Sub ledger Accounting for better Reporting purposes

Trouble shooting the Period End Closings by reviewing Holds, Unaccounted Transactions, Transferring Approved Invoices and payments to GL.

Used Oracle Discoverer Reports to Create Custom Reports for Project Managers

ENV: Oracle Applications R12 Modules: AP, AR, GL, PO, Projects, OTL, HR IExpense, Oracle BI Disco Report, and OM

Zynga Games/IBM Feb ‘12’ – AUG ‘12’

Location: San Francisco, CA

Functional consultant (Implementation & SUPPORT)

Responsibilities:

Developed a configuration document that contained all common configurations that reached across AP and GL (GL to the extent of Currency, Calendar, Chart of Accounts and Ledger setups)

Involved in GL Monthly Cycle.

Involved in Implementation of Order Management – Defined Shipping Parameters, Created Pick Release Document set for Pick Release Process.

Configured Shipping related setups

Configured Auto Accountings for Auto Invoice program

Created Inventory Organizations, Category Sets, adding items to Organizations,

Configured Sales Order FlexFields for Order management.

Automated the Creation of Receipt in Receivables via creating rules in Workflow

Documented requirements specifications for enhancements.

Setup and Configuration of Recurring Journals, Auto Reversals Setup, Summary of Accounts, Mixed Journals, Mass Allocation Formulae.

Implemented the Web ADI for users to upload and download data in excel format

Configured separate COA Structure to Configure Inter/Intra Company setup and Rules.

Generated Reports like Balance Sheet Report, Income Statement Report,

Translated Amount Report and Multi Currency Report Using FSG (Financial Statement Generator)

Defining Suppliers, Supplier sites, supplier types and pay groups to classify suppliers into various categories.

Trouble shooting the day to day issues for Modules like Financials and OM

Defining Supplier, Internal banks, bank documents and format programs

Defining payment terms and Distribution Sets

Configured PO matching process

Defining transaction types and transaction sources to default details during invoice creations.

Familiar with the configuration of Production and Training instances and provide support on Oracle Applications modules including GL, AP, AR.

Analyzing and reviewing the complete setup process and preparing BR100’s based on business flow of successful markets

Providing solutions to the tickets raised concerned with functional issues

Providing required setup solution as requested by user. Involved in functional setup issues in coordination with the users

Providing the complete setup of Multi-Org for the Financial Modules (GL, AP & AR) & testing the integration with other modules and Testing

Coordinating with technical team in solving the functional issues

Preparation of Standard Operating Manuals and the Training Materials for Oracle Accounts Receivable and Account Payables

Environment: Oracle Applications R12 Modules: AP, AR, GL, PO,Order Management,Inventory and

WorkFlow

Alticor Inc, June’10’– Dec ‘11’

Location: Ada, Michigan

Functional Consultant (Implementation and Support)

Responsibilities:

As a Functional Consultant implemented the modules: Ebiz Tax, PO, AP, AR and GL in Multi-Org Environment

Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications

Configured Oracle GL, AP, AR, Ebiz Tax and PO from scratch and simultaneously created BR100 documentation for the setups

Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules

Configured COA structure, Currency, Calendar, Ledger and attached Standard Accrual method developed in SLA

Configured Auto Accounting for Order Management.

Configured Rollup Groups, Summary Accounts, Recurring Journals, Auto Reversals, Mass Allocation, Mixed Journals

Defined CVR rule, Descriptive Flex Fields as per Business requirements

Configured Consolidation setups

Create and assigning respective responsibilities to Users

Configured GL, AP, AR Monthly Cycle setups

Setup of Vendors, Invoices, Banks, Recurring Invoice

Configured Desktop integrator using WEB ADI.

Configured Pay run using payment profiles

Setup of Recurring Invoices

Implemented Auto Lock box Functionality, Auto Invoice,Auto Receipt in AR

Defined Financial system options, Financial options and Payable options, Payment Terms, supplier, Banks, Pay run, Document sequencing

Defined System options, Transaction types, Source types, and Payment terms, Remit TO Address, Auto Accounting, Distribution sets and customers in Receivables

Configured the Revenue Recognition Program

Defined Account Setups in Ebiz for AP, AR and GL

Configured Regime to Rate Flow, Party, Reduced Tax Exemptions using Determination Rules

Configured INV ORG, Financial Options, Purchasing Options, UOM, JOBs, Employee, Buyers, Approval Groups and Categories

Configured Three way Matching process

Environment: Oracle Apps R12 (AP, AR, GL, PO, EBIZ TAX)

Good Technologies, July ’09’– May ‘10’

Location: Santa Clara, CA

Functional Consultant (Upgrade and Support)

Responsibilities:

Successfully upgraded and gathered requirements for implementation of R12 E-Business Tax

Prepared the various documents required under the AIM methodology. Received and analyzed current business processes for Oracle Receivables, Oracle Payables and General Ledger

Configured Regime to Rate flow, Tax Determination Defaults and Rules from Tax Manager

Resolved the functional issues due to Migration activities

Configured Tax set up in GL module

Set up of Auto Invoice functionality

Ran Diagnostic Reports before and after the Upgrade

Configured MOAC functionality

Performed End to End Integration on Transactional Flow

Configured APAR Netting

Coordinated the effort for identifying the technical issues and strategy to resolve them

Worked on SEV 1 SR’s for critical Issues

Used FSG to generate the Balance sheet Report, Translated Amount and Income Statement Report.

Configured the Pay Run to pay multiple invoices pertaining to multiple vendors

Modified Check layout as per client requirements

Used SLA to Modify the Journals before Posting to GL

Involved in technical discussions for Migrating the code and validated the code

Worked with the Testing Team to resolve the testing issues

Involved in identifying the Gap’s with the New User Interface and reported the business and mapped the requirements with the New User Interface

Conducted Training and CRP Sessions for the users

Involved in data clean up for the Upgrade Project from the interface tables

Prepared issues list, Risk plan, change request forms and regular client status reports

Coordinated with the Development teams, testing teams (offshore) and provide them the functional designs

Environment: Oracle Apps 11.5.10.2 to R12.1.3, Modules: AP, AR, GL

Agilent Technologies Apr ‘08’ – May ‘09’

Location: Santa Clara, CA

Functional consultant (Implementation and QA)

Responsibilities:

Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document

Utilised AIM methodology as an integrated approach to plan and track all phases of the project

Carried out full cycle implementation

Mapped the Future Process Requirement into Oracle AP module

Analyzed the identified gaps in reports. Worked with the technical team to create new reports

Carried out the set-up of the Accounts Payable module

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

Activated some descriptive flex fields to capture additional information for the client not available in standard oracle

Defined PO matching tolerances, and invoice approval codes

Defined distribution sets, expense reports templates, Locations. Defined financial options, Payables options, Payment programs, and Bank accounts

Set up the format for expense distribution detail report and Aging report, special calendars for key indicators and recurring invoices, and profile options forms

Set up Suppliers and Banks for AP use

Worked with the technical team for the migration of the legacy data like suppliers and open invoices into oracle AP module for production

Performed the unit and integration tests. Prepared test scripts

Participated in the Conference Room Pilot Test for all the modules implemented by the client. Guided the client Team to carry out Accounts Payable period end closing. Did some basic training for the key users of the client

Authored some AIM documents for the Accounts Payable Module including: BR.020- Business Requirement Mapping Document, BR.110- Security Profile Document, CV.060- Conversion Strategy, BR.100- Setup Document, TE-40 Test Scripts

Performed complete End to End Testing

Designed and set up the Set of Books after defining the Calendar, the functional currency and the 7 segment Chat of Accounts

Designed and set up accounting structure with AR/A/GL

Defined system and financial options

Created summary accounts and modified accounts hierarchy

Defined value sets, key flex field segments and roll-up groups with security and cross validation rules, used ADI (Application Desktop Integrator) to integrate the GL module to the Excel spread sheet

Created summary Accounts and modified Account Hierarchy

Designed the Chart of Accounts for the client

Defined Mass Allocation Formula, journals and budgets (standard and formula)

Environment: Oracle Apps 11i, AP, AR and GL

Thysen Krupp Elevators, May ’07’– March ‘08’

Functional Consultant, QA & Support

Responsibilities:

Performed complete set-ups related to manual and automatic receipts

Set up transaction types, invoices, guarantees, deposit, and credit memos, debit memos

Defined system options parameters

Defined Invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources

Defined tax features such as codes, rates, exceptions and exemptions

Defined system Item flex field

Defined auto cash rule set, auto invoicing

Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets

Defined receipt class, specified creation method, payment method, clearing method

Defined collectors and aging buckets

Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes

Worked on the full testing of the account receivable module

Defined suppliers, supplier sites and banks for AP use

Defined payment terms and recurring invoice templates

Defined PO matching tolerances and approval codes

Responsible for creating test scripts and performing SIT and E2E testing.

Interacted with Oracle support to resolve application issues, bugs and TAR/SR management

Defined lookup codes

Environment: AP, AR

NOVA Information Systems Feb ‘04 – Mar ‘07

Quality Analyst

Responsibilities:

Responsible for the creation of the Test Plan, Test Strategy, Test Cases. Generation of Various Test Scenarios & Test Cases. Test Cases Review and Test Execution

Performed manual system testing (Functional testing and End to End testing of the application).

Implemented entire life cycle of QA Methodologies starting from Planning, Capturing, Creating and Executing, reporting and tracking the defects

Responsible for Black Box testing of the applications. Performed various black box testing using methodologies such as Regression Testing, Functional Testing, Integration Testing and System Testing, Sanity testing on the Application

Involved in setting up the QA Process to achieve better results

Connected to Mainframe Host and performed Testing

Used SFTP to send the Reports to Users

Conducted Back End Testing, Positive Testing, Negative Testing and End-to-End Testing

Coordinated with developers to fix the defects and enhanced the application

Responsible for QA Certification with Associations like MC, VISA, DISCOVER and AMEX

Prepared and maintained Traceability Matrix

Identifying the Tables from the Procedures

Responsible for writing SQL Queries to validate data in Front end app & Database

Performed User Acceptance Testing with 100% compliance with all end to end test specifications

Created and Executed SQL queries to fetch data from oracle database to validate compare and expected results with those actually obtained for Reporting Purposes

Educational Qualification

MBA from India

Work Status: Green Card



Contact this candidate