Surya Maddiboina
acu0h4@r.postjobfree.com
SUMMARY
Expert experience in Oracle Financials and SCM with requirement gathering, setups & configure, testing, upgrade, onsite and offshore support projects. Hands on end-to-end full life cycle implementation experience with GL, AGIS, AP, AR, FA, PO, Treasury and Cash Management. using AIM, SDLC and Agile Methodology. Extensive experience in end to end testing cycle, ability to plan, functional testing, integration testing, defect reporting, automation script execution using QTP, HP-QC, JIRA, IBM Clear Quest and Clear Case.
SKILLS
Excellent experience in R12 with GL, SLA, AGIS, AP, PO, Projects, AR, FA, E-Business Tax, Cash Management and Treasury with Full Life Cycle implementation, Upgrade and Testing and Post production projects.
Expert in Oracle AIM, SDLC, Agile methodology, business process and Fit Gap Analysis. Documentation and analyze "As Is" and "To Be" process flows covering all the functionality to satisfy business requirements.
Proficient with Procure to Pay (P2P) and Order to Cash (O2C) cycles, covering modules GL, Inventory, PO, Payables, OM, Receivables Cash Management with integration and interfaces.
End to end implementation experience in Oracle Treasury end to end implementation and understanding Oracle Business Process for R12 Treasury setups and configuration.
Familiar with business planning, requirement gathering, design, setup & configuration, migration, testing, test script generation, documentation and user training.
Strong in GL, AP, AR, CE and FA along with concepts of Flex fields, Chart of Accounts (COA), Ledgers, LE, FSG, Revaluation, Translation and Consolidations.
Ability to lead and facilitate cross-functional teams to deliver complex projects in 11i & R12.
Developed test scenarios and test scripts, perform testing across products and interfaces.
EDUCATION
M.B.A. - Finance
Masters’ Degree in Accounting and Taxation
Diploma in Computer Science
TECHNICAL SKILLS
Oracle Application E-Business Suite R12 and 11i
Oracle Application Modules General Ledger (GL), Accounts Payables (AP), iExpense, Account Receivables
(AR), Fixed Assets (FA), Cash Management (CE), Treasury, E-Business Tax,
Purchasing (PO) and IFRS
Tools QTP, HP Quality Center, SQL, JIRA, IBM Clear Quest and Clear Case
XML Publisher, workflow and Oracle Reports, Web ADI.
PROFESSIONAL EXPERIENCE
Parexel International
Boston, MA
Oracle E-Business Functional Consultant Jul.2015 – Current
PAREXEL International is a multinational life sciences consulting firm. It conducts clinical trials on behalf of its pharmaceutical clients to expedite the drug approval process. Parexel is the second largest Global clinical research organization in the world.
Responsibilities:
Upgrade to R12.2.4 Financials, GL, AGIS, PO, AP, Fixed Assets, AR and Cash Management
Responsible for requirement gathering, setups and configuration, test plan, test design, test scenarios, test cases, test data generation, defect tracking, reporting and reviews of test deliverables. Also responsible to prepare test scripts, data sheets and execution of test scenarios within an R12.2.4 environment. Reviewed project documentation as a basis for testing documentation and product understanding.
Setup and configure Financial modules as per client requirements in R12.2.4 instance
Analyzed "As Is" and "To Be" process flows covering all the functionality as per business needs.
Involved in requirement gathering, design, documentation, Fit Gap and configure R12 Financials
Design and develop Chart of Accounts (COA), AGIS, Sub ledger Accounting (SLA) in R12 GL
Setup Product Types for short term money, wholesale term money, Discounted securities and FX
Upgrade P2P process with Inventory, PO, AP, AR, FA, GL, EB Tax and integrate with Vertex
Configure Revenue Recognition in R12 with Project Costing and Billing and related setups
Involved in month end close for Sub ledgers, Project Costing and Project Billing and data transfer to GL
Work closely with software engineers in the development, test execution and test results.
Coordinate with Onsite and Offshore teams, development teams and support teams.
Defined business requirements for R12 implementation using the AIM/Agile Methodology.
Converted business requirements into functional specifications and Gap Analysis for P2P process
Interact with Business to gather requirement and coordinate tech team for Acquisitions and Mergers.
Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.
Develop, review and executed test scripts, perform end to end testing as per business
Created test cases and implement QTP scripts for deploying to meet project schedules
Prepared RD.20 Requirement doc., BR.100 Setup doc, MD.50 Design doc and TE.40 Test case docs.
Centers for Medicare & Medicaid Services (IBM-HIGLAS)
Baltimore, MD
Oracle R12 Financials Consultant Jan.2015 – Jul.2015
The Centers for Medicare & Medicaid Services (CMS) is a federal agency within the US Department of Health and Human Services (DHHS) that administer Medicare program and works in partnership with State Governments to administer Medicaid, the State Children’s Health Insurance Program (SCHIP), and health insurance portability standards. In addition to these programs, CMS has other responsibilities, including the administrative simplification standards from the Health Insurance Portability and Accountability Act (HIPAA), quality standards in long-term care facilities.
Responsibilities:
Upgrade to R12 Financials, GL, SLA, PO, AP, AR, Federal Financials and Cash Management
Responsible for requirement gathering, setups and configuration, Test Plan, Test Design, Test scenarios, Test cases, Test Data generation, Defect tracking, Reporting and Reviews of Test Deliverables. Also responsible to prepare test scenarios, test scripts, data sheets and execution of test scenarios within an R12 Oracle Application environment. Reviewed project documentation as a basis for testing documentation and product understanding.
Setup and configure based on workflows as per client requirements in R12
Analyzed "As Is" and "To Be" process flows covering all the functionality as per business.
Involved in Requirement gathering, design, documentation, setup and configure R12 Financials
Work closely with software engineers in the development, execution, and results of tests.
Coordinate with Onsite and Offshore development and support teams for RICE objects/migration
Converted business requirements into functional specifications and Fit/Gap Analysis.
Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.
Develop, review and executed test scripts, perform end to end testing of business processes
Work on daily basis with IBM-HIGLAS Clear Quest and Clear Case. QC and QTP
Perform Oracle Financial Applications including execution of Reports, Interfaces, Extensions Conversions utilizing Web ADI
Create test cases and implement QTP scripts for deploying Oracle Financials
Prepared the business documentation for implementation of R12 using the AIM/Agile Methodology.
Develop BR.100 Setup Document, MD.50 Functional design document and TE.40 Testing document
Hyatt Hotels Corporation
Chicago, IL
Sr. Oracle Financials Consultant Jul.2014 – Dec.2014
Hyatt Hotels Corporation is an American international company and one of the world’s top operators of luxury hotels and resorts with more than 500 managed, franchised and owned properties in 45 countries. Its core Hyatt Regency brand offers hospitality services targeted primarily to business. gIn this R12 Implementation project I was involved in gathering requirements, develop As-Is and To-Be process, setup and configure GL, SLA, AP, AP, AR, CE, FA and EB Tax develop and execute test scripts with users in UAT.
Responsibilities:
Implement R12 GL, AGIS, SLA, PO, AP, Fixed Assets, AR, and Cash Management
Design Chart of Accounts (COA), Calendars, AGIS, Sub ledger Accounting (SLA) in R12
Setup E-Business Tax for Use Tax, Sales Tax, GST, PST, VAT in R12 E-Business Tax
Configure Credit management, Revenue Management and Project costing and Billing
Working with the onsite functional teams and business users to understand requirements
Managing offshore development and subsequent deployments of code to environments
Coordinate with Onsite and Offshore development and support teams for client deliverables
Working with the Infosys offshore team to translate the Business Requirement documents into Functional
Acting as a bridge between business team, technical team and offshore team for on time deliverables.
Month end close for Sub ledgers, Project Costing and Project Billing and transfer to GL
Preparation for System Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT)
Analyze As-Is and To-Be process, involved in Solution Design, CRP-I, Solution Piloting.
Design steps for implementation and prepared the business documentation for implementation and supporting of R12 using the AIM/Agile Methodology.
Define Calendar, Currency, multi-currency conversion, Credit Cards and Payment process profile.
Involved in setups including GL, Fixed Assets, Receivables and Payables, EB Tax, Cash Management, Bank operations, invoice mapping and using Web ADI for reports and transfer data
Develop RD20 Requirements, BR100 Setup, TE40 Testing document, and MD50 design documents
Chicago Transit Authority (IL State Govt.)
Chicago, IL
Lead Consultant-Oracle Financials Sep.2012 – Jun.2014
The Chicago Transit Authority (CTA) provides service to Chicago and 40 surrounding suburbs. CTA operates 24 hours each day and on an average weekday provides 1.7 million rides on buses and trains. It has approximately 1,800 buses that operate over 140 routes traveling along 2,230 route miles (3,658 km). The Chicago Transit Authority's 1,190 train cars operate over eight routes and 222 miles of track. Its trains provide about 750,000 customer trips each weekday and serve 144 stations in Chicago.
In this R12 Re-Implementation project I was involved in gathering requirements, develop As-Is and To-Be process, setup and configure Finance modules, develop and execute test scripts in Testing phase.
Responsibilities:
Implement R12 GL, SLA, PO, AP, AR, FA, Projects, Cash Management and Treasury
Analyze As-Is and To-Be process, involved in Solution Design, CRP-I Solution Piloting.
Design steps for implementation and prepare business documentation for implementation in
R12 using the AIM/Agile Methodology. Perform Web ADI and RICE objects.
Setup, configure and test end-to-end Order to Cash and Procure to pay processes.
Setup Product Types for short term money, wholesale term money, Discounted securities and FX
Configure Advanced collections, Credit management, Revenue Recognition and E-Business Tax
Define Chart of Accounts (COA), Calendar, Currencies, multi-currency conversion and SLA
Created Customer, Customer Classes, Revenue recognition, Banks using TCA
Define setups for GL included Budgeting, Multi Reporting Currency, SLA and Multi Org.
Setup GL, AP, AR, Cash Management, Banks and Bank Accounts for AP and AR transactions
Implemented Oracle Project Accounting with Costing and Billing and defined project related setups
Participated in UAT and tested R12 new features and functionality as per client requirements.
Develop RD20, BR 100 Functional setup, TE.040 Testing and MD50 Functional design documents
Execute Apps automation using Quality Center, QTP, JIRA and Clear Quest and Clear Case.
Wyndham Worldwide Corporation
Parsippany, NJ
Test Lead - Oracle Financials Jan’12 - Aug’12
Wyndham Hotel Group is the world's largest provider and franchiser of a diverse field of travel-related products and services for businesses and individual consumers, with brands in lodging franchising, vacation ownership, vacation rentals and vacation exchange. It is composed of nearly 6,900 hotels under 13 brands spanning 50 countries and 6 continents. Wyndham Worldwide is headquartered in Parsippany, New Jersey with more than 25,000 employees around the world.
Responsibilities:
Responsible for requirement gathering, setups, configuration, Test Plan, Test Design, Test scenarios, Test cases, Test Data generation, Defect tracking, Reporting and Reviews of Test Deliverables. I was Involved in Oracle R12 Financials testing project and understanding client requirements, Setup, configure, design, develop, test and validate Oracle Financials, modules GL, AGIS, AR, PO, AP, FA and Cash Management and Project Billing
Review project documentation as a basis for testing documentation and product understanding.
Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status.
Develop, review and executed test scripts, perform end to end testing of business processes
Configure and did complete end-to-end testing for Order to Cash and Procure to Pay Processes
Works closely with software engineers in the development, execution, and results of tests.
Coordinate with Onsite and Offshore development and support teams.
Converted business requirements into functional specifications and solutions.
Responsible for facilitating system/integration/user testing, training and documentation.
Ability to understand business processes, gather requirements and prepare design specifications.
BR.100 Setup Document, Future Business Requirements (MD.50) Functional design document and TE.40 Testing document using Agile/AIM Methodology.
Utilized Quality Center (QC), Quick Test Professional (QTP) and JIRA in end to end Testing Cycle
Wells Fargo
Charlotte, NC
Sr. Oracle Financials Consultant Jan’11 – Dec’11
Wells Fargo & Company is a diversified financial services company with operations around the world, it is the fourth largest bank in the US by assets and the second largest bank in deposits, home mortgage servicing, and debit card. I was involved in R12 Implementation with GL, AP, AR, FA, Treasury and Cash Management
Responsibilities:
Participated in CRP and mapping recommendations in GL, AP, FA, iExp and Cash Management
Defined setup and configure Fixed Assets, AP, AR, GL, SLA, AGIS, Projects and E-Business Tax
Involved in Requirement gathering, design, documentation, setup and configure for P2P cycle
Design and develop COA, Calendar, Currencies, multi-currency conversion, Legal Entities and SLA
Involved in Payment functions including Oracle Receivables, Payables with Bank operations.
Setup R12 GL, AP, Fixed Assets, iExpense and Bank Accounts for E-Business Tax
Involved in configure Receivables, Payables, Treasury, Revenue Management and Billing
Implement Project Accounting in R12 with Project Costing and Billing and related setups
Create authorization limits in AP and AR that sends notifications to the concerned people.
Defined setups for Oracle AR like Auto Cash Rule Set, Grouping Rules, transaction sources, Transaction types, payment methods, Sales tax flex fields Structure, System Options, collections, receipt class, receipt sources. Defined Centralized Tax Setups in E-Business Tax module.
Define Customer profile classes, bank accounts, payment terms and distribution sets.
Develop RD20 Requirements, MD.50 Design, TE040 Testing and BR100 setup documents using Agile/AIM Methodology
US Department of Education
Washington, DC
Oracle Financials Functional Consultant Jul’10-Dec’10
The US Department of Education is a Cabinet-level department, with about 50,000 employees. The agency's official acronym is ED. The core responsibilities of this position were Oracle R12 Upgrade of GL, SLA, PO, AP, AR, Federal Financials and Treasury.
Responsibilities:
Prepared BR100 R12 Functional Setup document for GL, SLA, PO, AR, AP and Treasury.
Define GL, AP, PO and Federal Financials setups and configure and test the applications.
Setting up System Profiles, Application Security (user, menus and responsibilities) Flex fields, Value sets, Ledgers, Chart of Accounts (COA), Calendar, Currency conversion and Sub Ledger Accounting (SLA).
Participate in making recommendations for implementation and to support users on resolving issues
Define Payment Terms, Invoicing and accounting rules, territories, Invoice Sources and Interfaces.
Develop RD20 Requirements, BR100 Setup, TE40 Testing document, and MD50 design documents.
Define accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set and auto invoice tuning.
Define AP and AR transactions for misc. receipts, finance charges, bank charges and distribution sets.
Define receipt class, specifying creation method, Payment method, clearing method, collectors, revenue recognition and aging buckets.
Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.
Define Auto accounting; assign receivable account, revenue account, unbilled account, clearing account and unearned account.
PWC
New York, NY
Oracle Financials Consultant Mar’09 to Jun’10
Price water house Coopers (PWC) is world’s second largest multinational professional network headquartered in New York, NY and operates in more than 157 countries with more than 184,000 people and one of the big auditor companies. My role in this R12 implementation was to setup, configure, test and validate modules GL, AP, PO, AR, FA, Cash Management and Inventory
Responsibilities:
Implement R12 GL, SLA, AGIS, AR, AP, PO, FA, Projects, Cash Management and Treasury.
Analyzed As-Is and To-Be process, involved in Solution Design, CRP-I, CRP-II, Solution Piloting.
Designed steps for implementation and prepared business documentation for implementation and supporting of R12 using the AIM/Agile Methodology and Advanced Global Intercompany System.
Setup GL, AP, AR, FA, and CE, E-Business Tax and integrate with Vertex as per client need
Configure Advanced collections, Revenue Recognition, Credit Management and E-Business Tax
Setup and configured business applications to support P&C Insurance and Consolidation
Define Calendar, Currency, multi-currency conversion and Chart of Accounts (COA) and SLA
Involved in setups including GL, Oracle Fixed Assets, Receivables and Payables with iExpense, Cash Management, Bank operations, invoice mapping and implementing strategies.
Involved in Business Requirements, As-Is and To-Be Processes, Fit/Gap Analysis and design.
Develop RD20 Requirements, BR100 Setup, TE40 Testing document, and MD50 design documents
Define setups for GL included Budgeting, Multi Reporting Currency, FSG and Multi Org.
Setup and configure and did complete end-to-end Order to Cash and Procure to Pay Processes.
Defined setups for Oracle AR, like Auto Cash Rule Set, Grouping Rules, transaction sources, Transaction types, payment methods, payment terms and Configure EB-Tax setups.
Morgan Keegan Bank
New York, NY
Oracle Financials Consultant Mar’08 to Feb’09
Morgan Keegan Bank, a subsidiary of Regions Financial Corporation, is a premier investment firm offering full-service investment banking, securities brokerage, and Trust and asset management. Morgan Keegan serves the diverse financial needs of individual investors, corporate and institutional clients throughout the US and abroad. I was involved in upgrade from 11i to R12 with GL, FA, PO, AP, FA, iExp, Treasury and Cash Management.
Responsibilities:
Involved in Business Requirements and prepared RD20 Questionnaires, BR 100 Setup Document, Requirement Mapping document (BR 30), MD50 Functional design using AIM Methodology.
Setup and configure business applications to meet business requirements in Procure to pay process.
Configure R12 new feature in GL, AP, Cash Management, Payables, EB Tax and iExpenses modules
Performed process analysis, solution design, build, test, delivery, and postproduction support for enterprise-wide GL, AP, AR, Fixed Assets, Treasury, Cash Management and P&C Insurance
Setting up the Oracle Payables, E-Business Tax, Cash Management and Payments in R12
Created parent-child relationships for segment values, Rollup Groups and Summary Accounts.
Defined Legal Entity, Primary Ledger, COA, Calendar, Currency conversion and budgeting.
Defined AR System Options, Customer Profiles, Transaction Types, Payment Terms, Auto Accounting Rules, Distribution Sets, Transaction Activities, Auto Cash Rule Sets, Receipt Sources and Lockboxes.
Involved in the setup of Financial Options and Payables Options, Distribution Sets, Suppliers and Banks.
Master Card International
St. Louis, MO
Oracle Financials Consultant Jan’07 to Feb’08
MasterCard International is a global payments company with one of the most recognized and respected brands in the world. MasterCard manages a full range of payment programs and services in Oracle 11i including Master Card credit cards, MasterCard debit cards, online debit cards etc.,
Responsibilities:
Gone through all stages of implementation like As-Is, To-Be, Solution Design, CRP Solution and UAT.
Responsible for Implementation and roll out of GL, AP, Cash Management and iExpense.
Develop functional designs in support of global 11i implementation using SDLC/AIM methodology
Defining and structuring of chart of accounts (COA) by mapping with the old account codes.
Experience in defining Calendar (Transaction Calendar), Currency conversion as per client requirements
Using Journal Approval limits so that journal goes for an approval if it exceed some thresholds.
Defined Tax setups for Use Tax, Sales Tax and VAT and exposure with iExpense.
Defining system options in Receivables, Payables and Cash Management.
Defining payable and financial options, System options and profile options.
Defined COA mapping, G/L balances conversion, Vendor and Customer conversion.
Developed functional designs in support of global 11i implementation using SDLC/AIM methodology.
Knight Ridder Inc.
Nashville, TN
Oracle Financials Consultant Jan’05 to Dec’06
Knight Ridder is a communications company engaged primarily in newspaper and internet publishing. The second-largest publisher in the U.S., it owns 32 dailies and operates a network of 56 regional websites. Knight Ridder Shared Services and Corporate Technology (SSC) provides software and hardware support to Knight Ridder’s Newspaper Division. Knight Ridder SSC was using Oracle 10.7 for its financials system. This project was involved in upgrade the modules GL, AP, PO, AR, OM and Fixed Assets, Cash Management from Oracle 10.7 to 11i
Responsibilities:
Upgrade Oracle GL, AP, PO, OM, AR, FA, Cash Management and involved in Testing and training.
Involved in setup, configure, test complete end-to-end Order to Cash Processes
Identify the Upgrade errors as a part of Iterations and resolving the issues sitting with the technical team.
Involved in defining custom descriptive flex fields and Tax requirements and rate conversion.
Worked as a conversion specialist and in customization of oracle Apps. Converted data from legacy system to Oracle Applications. The conversion includes Customer information and Receipt information in AR through Auto lock box, Customer interface.
Involved in implementation of GL, Account Receivables, Payables and Cash Management modules.
Performed Setup steps for Oracle Receivables like Auto Cash Rule Set, Tax Rules, transaction sources, Transaction types, payment methods, payment terms, Sales tax flex fields Structure, System Options, receipt class, receipt sources.
Defined AR Dunning letters to customers about outstanding due and Reconciliation.
Inter-Tel
Marietta, GA
Oracle Financials Analyst Jul’03 to Dec’04
Inter-Tel is a leading Distributor/Dealer of Scientific Instruments with distributing operations nation wide. Since the marketing, distributing and accounting operations are distributed the need for enterprise application integration arises. This project involved a full cycle implementation of Oracle GL, PO, AP, OM, FA and Cash Management
Responsibilities:
Implemented Oracle 11i GL, OM, AR, FA and Cash Management for a large distribution network.
Setup AR, Sales Tax and Cash management application workflow and process activities
Defined the Line Ordering and Grouping Rules to be used with the Auto Cash Rule Sets in order to maintain the desired sequence for transactions to appear in an invoice.
Completed the setup of the receipts workbench that included receivable activities, receipt classes, payment methods, receipt sources and distribution sets.
Setup, configured and did complete end-to-end testing of Order to Cash and Procure to Pay
Set up Banks account, transaction types, invoices, guarantees, deposit, and credit, debit memos.
Assigning receivable account, revenue account, unbilled account, fright account, clearing account, and unearned account to transaction types.
Defined Split payment terms for invoice installments that have different due dates and assigned multiple discounts to each payment line and Cash forecasting.
CITI Bank
New York, NY
Oracle Financials Analyst Jan’02 to Jun’03
The project was included requirement gathering, configure and testing GL, AP, iExp. FA, Cash Management.
All set up’s had to be made from scratch up as the client was contemplating for an ERP solution for the first time.
Responsibilities:
Participated in the configuration and implementation of GL, AP, Treasury, FA and Cash Management.
Defined Profile Options to specify certain implementation parameters, and Processing System Options.
Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources and payment methods.
Defined Tax setups such as Tax Codes, Rates, Exceptions and Exemptions.
Defining System Item Flex Field and Organization.
Defining accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set and auto invoice tuning.
Defining Receivable activities for receipts, finance charges, bank charges and defining distribution sets.
Defining receipt class, specifying creation method, Payment method, clearing method, collectors and aging buckets.
Set up transaction types, invoices, guarantees, deposit, credit memos and debit memos.
Assigning receivable account, revenue account, unbilled account, fright account, clearing account and unearned account to transaction types.