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