Oracle Customer Service
Resume:
Chytanya Galam
Oracle Financials Functional SME
acqa7h@r.postjobfree.com
Professional Summary:
** ***** ** ****** ***** experience in Oracle Applications implementation, development, upgrading, supporting and involved in full life cycle implementations of several releases 11i/11.x/R12. Specialized in functional areas of General Ledger (GL), Account Payables (AP), Account Receivables (AR), Cash Management (CE), Treasury, fixed assets (FA), E Business Tax (EB-Tax), Order Management (OM), Inventory (INV) and Purchasing (PO) modules.
Primary author of Oracle 12.2 EMEA add-on Localization User guides for Israel, Italy, Germany, Portugal, Finland, Belgium, CIS, Norway and Netherlands (My oracle support User guide Part numbers for reference: Israel User guide Part No. E49863-01, Italy User guide Part No. E49870-01, Germany User guide Part No. E49868-01, Portugal User guide Part No. E49869-01, Finland User guide Part No. E49867-01, Belgium User guide Part No. E49864-01, CIS User guide Part No. E15552-01, Norway User guide Part No. E49866-01, Netherlands User guide Part No. E49865-01).
Got Rising star award from Oracle SSI in May 2010.
Excellent Understanding of Oracle Application Financial Modules Such as General Ledger, Accounts Payables, Accounts Receivables, Cash management, EB -Tax and Fixed assets.
Involved in full life cycle implementations and development of several EMEA Add-on Localization objects for Russia, Norway, Portugal, Belgium, Israel, Finland and Italy etc.
Strong documentation, analysis, requirement skills and good interpersonal and communication skills to work with clients and team members.
Have a good implementation and upgrade experience from Oracle 11i to R12.
Sound Knowledge in Procure to Pay (PTP) and Order to Cash (OTC) process.
Documents Prepared as per AIM (Application Implementation Methodology).
Having Knowledge in Oracle unified methodology.
Experience in Inventory, order management and Purchasing Modules.
Proven skills of understanding Business requirements and translating them into functional specifications.
Perform implementation activities including, but not limited to, requirements analysis, business process redesign, setups, testing, documentation, training and end-user support.
Assists in design, development, testing and implementation of Oracle financials projects.
Involved in QA Testing process and coordinated with end users for Acceptance Testing.
Created test scripts, business process flows, and conducted multiple testing cycles.
Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; and analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.
Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
Technical activities: identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support.
Always willing to learn anything new depending on the business requirements.
Completed assessments conducted by Oracle SSI Academy.
Consistently Good Academic Record throughout.
EDUCATION
Masters in Business Administration, India, 2003-2005.
Bachelors in Commerce (Computer Applications), India, 2000-2003.
TECHNICAL SKILLS
ERP Oracle Financials Functional.
Modules GL, AP, AR, CM, EB-Tax, FA, PO, OM and INV.
Technologies Oracle 11i E-Business suite (11.5.8, 11.5.9, 11.5.10, 11.5.10.2), R12 E-Business suite (12.0.3, 12.0.5, 12.0.6, 12.1.1, 12.1.3 and 12.2.3).
Operating Systems Windows 98/NT/2000, Linux.
PROFESSIONAL EXPERIENCE:
Working as senior product manager with ORACLE Corporation from September 2011 to till date.
Worked as an Oracle Functional Consultant with ORACLE Corporation from June 2008 to Sep 2011.
Worked as an Oracle Functional consultant with Satyam Computers from April 2006 to June 2008.
PROJECTS EXPERIENCE:
Client: Oracle Corporation, Redwood city, CA and EMEA Add on Consulting Localizations.
Environment: Oracle Apps R12, R12.2 (GL, AP, AR, CE, Treasury, FA and EB Tax).
Project Type: Development, Implementation and support.
Role: Oracle Financials EBS R12 Senior Product Manager (Development, implementation, Support).
Duration: September 2011 to till date.
Description:
The Project entitled Separate VAT Accounting caters to legal requirements by the Russian legislation to calculate VAT from purchased goods or services used for export, sales without VAT and domestic sales. Russian legislation states that the VAT from purchased goods or services, which is used to manufacture export goods, and goods for sales without VAT must be accounted separately from other incoming VAT. Also there are some specific rules for VAT accounting in case of export sales and this entire process is known as Separate VAT accounting. This type of accounting is intended for the calculation of the part of incoming VAT which can be refunded in case when an enterprise sells goods with different VAT rates.
Responsibilities:
Working as Senior Product Manager in the EMEA Add-on Localizations team and responsibilities include interacting with Clients and Oracle engineers in the requirement analysis phase, mapping the requirement to Oracle Applications, designing solutions, providing functional support to technical developers and resolution of issues during implementation, development phase and Support. Has good experience in handling customer requests after proper analysis of the issues and has picked up the Process Flows in Financial modules, Forms Customization, Country specific reports and has excelled in providing quality deliverables within stipulated timeline. To achieve the desired functionality using Oracle EBS, to meet the customer specifications and data validations related to AP, AR, GL, EB Tax and Fixed Assets.
Performed 12.2 Regression testing for EMEA Add on Localization objects.
Configured AGIS setups.
Participated in multiple business meetings for Fit-Gap Analysis and Solution.
Assisted functional lead analyst to conduct CRP1 and CRP2.
Collect and analyze business requirements for Oracle financial projects.
Write business requirement documents and other functional and technical documentations.
Assist in design, development, testing and implementation of Oracle financials projects.
Provide suggestions to customize Oracle applications for optimal performance.
Resolve technical and operational problems in a timely fashion.
Respond to customer queries and concerns promptly.
Identify functional gaps and provide corrective actions.
Ensure that project deliverables meet customer specifications.
Support project team in developing RICE components. (Reports, tables, fields, data interfaces and application extensions).
Develop testing scenarios and write test scripts.
Prepared AS-IS and TO-BE documents as per AIM.
Prepared BR.100 Application setup and MD.50 Application Extensions Functional Design documents according to AIM.
Involved in configuration of CRP1, UAT and test instance.
Trained Super Users and troubleshooting during UAT (User Acceptance Test).
Used the System Administrator responsibility to define users and assign responsibilities and set profile options.
Preparation of Functional design documents and Functional test scripts and user guide.
Preparation of test cases for various business scenarios and testing the scenarios in Test instances.
Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.
Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes.
Design & Develop FSG reports in GL.
Set up AP bank accounts, bank documents, bank codes and expense report templates.
Defined profile options to specify certain implementation parameters.
Set up Recurring journals template, recurring journals and Auto-reversal in GL.
Set up suppliers, locations, and purchasing quick codes.
Setup payment terms, invoice distribution, matching of invoices against PO.
Configure Financial Options and Payables Options in AP.
Created custom Customer invoice print templates.
Configure System Options in CE.
Reconcile AP with bank statement in Cash Management.
Activation of various flex fields in the forms to gather the additional information.
Participated in user accepting testing in test instance and worked with certain key super users.
Work with documentation team to develop user guides and training materials.
Client: Oracle SSI Consulting Localizations, India
Environment: Oracle Apps R12, R12.1 (GL, AP, Purchasing, Projects, FA and EB Tax).
Project Type: Development and Implementation.
Role: Oracle Financials EBS R12 Functional Consultant (Development and implementation).
Duration: Oct 2010 to September 2011.
Description:
The Project entitled Vat Refund for Purchased assets caters to the legal requirements by the Russian legislation and the solution is essential part of the whole VAT Russian Localization solution. It is the process, when an incoming VAT amount is deducted from the VAT Liability and VAT refund is done by means of generating refunding invoices, which then can be reflected in the tax reports properly. VAT Refunding Invoice is the standard tax-only payables invoice, which is to make tax refund and users can track information about where assets came from; including sources such as invoice lines from accounts payable system and capital assets from Oracle Projects.
Responsibilities:
To achieve the desired functionality using Oracle EBS, to meet the customer specifications and data validations related to AP, Projects, EB Tax and Fixed Assets.
Preparation of Functional design documents and Functional test scripts.
Preparation of test cases for various business scenarios and testing the scenarios in Test instances.
Presented requirement questionnaire to the business and mapped business requirements.
Prepared RD.20 and BP.80 according to AIM implementation methodology.
Worked with the business to come up with the future business process.
Configured multi-org business structure in Oracle Ledger Setup, Legal Entity, and Establishment Setups and MOAC security.
Set up Multi-Currency environment.
Created Customized responsibilities, customized menus, customized request groups.
Designed a Prototype (Demo) configuration of CIS Localization as per client’s request.
Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA (Sub ledger Accounting).
Contributed towards Conference Room Pilots CRP1 and CRP2.
Coordinate with offshore technical team for data conversions.
Helping users upload journals using Web ADI in GL.
Involved in scheduling the reports.
Configured GCS (Global Consolidation System) to consolidate balances from Ledger with Parent company Ledger.
Setup International Tax Calculation including Russian (VAT), Kazakh and Ukraine (VAT).
Defining System Option Parameters in AR.
Prepared AS-IS and TO-BE documents as per AIM.
Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users.
Prepare and Configure Setups in Production Instance and Production Support.
Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in e-business Tax module.
Provided various custom solutions for client’s specific needs.
Trained end users using Oracle UPK (User productivity Kit).
Provided with post-production support after go live on GL, AP, AR and FA modules.
Client: Oracle SSI Consulting Localizations, India.
Environment: Oracle Apps R12, R12.1 (GL, AP, AR, Treasury, Purchasing, Projects, FA and EB Tax).
Project Type: Development and Support.
Role: Oracle Financials EBS R12 Functional Lead for CIS FA Reports.
Duration: Jun 2008 to Sep 2010.
Description:
The Project entitled “Fixed Assets solutions for CIS Consulting Localizations” caters to the legal requirements by the CIS legislation to display the needed reports as per the layout from the Russian, Kazakhstan and Ukraine legislation. There were dependencies on the reports with other reports and forms. I was involved in the areas of customizing the reports, forms as per the requirements needed. Worked on Fixed Assets, Purchasing and Payables modules for generating the solutions. This Project is about the development and support activities extended to all the solutions handled as part of the Support for EMEA Consulting Localizations specifically ‘CIS Consulting Localizations’ solutions build. Developed solutions for Russia, Kazakhstan and Ukraine. For all the developed solutions we are providing extensive support to customers. We will address the customer issues through service requests raised by them.
Responsibilities:
To achieve the desired functionality using Oracle EBS in order to meet the customer specifications.
The scope of learning is extensive and up gradation of reports done as per customer choice.
Preparation of Functional design documents, Functional Test scripts and User Guides needed for the customer or user understanding of the solution achieved.
Preparation of test cases for various business scenarios and testing them in test instances.
Enhancement in the technologies and scope of solutions involved.
Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers.
Writing TE.040 Test Scripts for Functional Testing of GL, AP, FA and developing Guided Navigations.
Developing Training Material for GL, AP, FA modules.
Conducted end user training sessions and User manuals.
Post implementation support and maintenance – performed successful nine month end and period close activities in the newly implemented modules.
Design and Configure Financial Statements Using FSG.
Maintain issue tracker using Bugzilla and issue resolution.
Conduct business meeting whenever required based on issues and new functional requirements.
Prepare documentation for change management process along with impact analysis on the proposed solution.
Prepared AS-IS and TO-BE documents as per AIM.
Follow up on Service Request (SR) raised by end users.
Client: Tom lee Music Company, Canada.
Environment: Oracle Financials 11i (GL, AP, AR, CE and FA).
Project Type: Implementation.
Role: Oracle Financials EBS Functional Consultant.
Duration: Sep 2007 to Jun 2008.
Description:
Tom Lee Music company is Canada‘s ultimate musical instrument mega-store. Tom Lee Music has been bringing music to the greater Vancouver community since 1969 and is one of the largest full-line musical instrument retailers in North America. They are well known for supporting the local music community and have received numerous awards in recognition of their dedication to music, excellence and support. They have nine full service community store locations conveniently located throughout Canada - Richmond, Vancouver, Coquitlam, Surrey, Langley, North Vancouver, Abbotsford, Nanaimo and Victoria. Tom Lee music project involved implementation of Oracle Financials, distribution and HRMS modules. Financial modules include GL, AP, AR, FA and Cash Management with AIM approach.
Responsibilities:
Understanding the Business Process of the Organization and its mapping to Oracle Financials.
Identified Business needs, Gaps and Requirements Analysis.
Map client business requirements to Oracle functionality and setup application in the Test, Development and Production environments.
Prepared AS-IS and TO-BE documents as per AIM
Configuration of Modules (GL, AP, AR & PO) and coordinating between offshore and Onsite.
Prepared Functional Specification documents using AIM Methodology.
Configuration setups in General Ledger, Accounts Payables, Fixed assets and Purchasing Modules.
Testing the Setup issues, giving offshore support to the client and providing functional support to the users.
Training of Key Users and prepared training manuals.
Defined GL Responsibilities, Value Sets, Key Flex field Segments, Period Types, Accounting Calendar, Currencies and created Set of Books.
Defined Recurring and Allocations Formulas.
Setup the Global Consolidation System, involved in Creation of customized reports as per the client’s requirement in Oracle GL using FSG.
Performed Complete Setups related to manual and automatic receipts.
Defined Profile Options to specify certain implementation parameters, Processing Options and System Options.
Defined Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources.
Involved in defining Tax features such as Codes and Rates.
Involved in Defining Organization, auto cash rule set, auto invoice tuning.
Defined receivable activities for miscellaneous receipts, finance charges, bank charges, defining distribution sets.
Defined receipt class, specifying creation method, Payment method, clearing method, defining collectors, defining aging buckets.
Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.
Trouble-shooting in GL & AP.
Involved in CRP 1 and CRP 2.
Involved in UAT user acceptance test.
Client: USG Corp, Chicago
Environment: Oracle Financials 11i (GL, AP, Treasury, CE, FA and PO).
Project Type: Support.
Role: Oracle Financials EBS Team Member-Support.
Duration: Apr 2006 to Aug 2007.
Description:
USG Corp is the world's leading producer of gypsum wallboard, joint compound and a vast array of related products for the construction and remodeling industries. They are global leaders in the manufacture of ceiling suspension systems and are recognized as the premier acoustical panel and specialty ceiling systems innovator. Their family of products provides creative building solutions that set new standards for productivity and efficiency, helping contractors and architects deliver high quality and innovative designs. Their products are used in everything from major commercial developments and residential housing to simple home improvements. Their flagship brands include SHEETROCK® Brand gypsum panels and DUROCK® Brand cement board, which are recognized around the world.
.
Responsibilities:
Resolving issues related to oracle financials and distribution modules.
Preparing and updating issue chart on weekly basis and getting the approvals.
Logging TAR‘s / SR‘s with oracle for technical assistance.
Assisting technical consultants and making them understand the functionality of scenarios related to issues.
Interacting with end users to get the requirements.
Resolution of issues logged in by the end users.
Supporting users in solving their regular day-to-day problems in the oracle applications.
Knowledge management sessions related to oracle General ledger, fixed assets and purchasing.
Understanding the Business Process of the Organization and its mapping to Oracle Financials.
Contact this candidate