Candidates About

 

Rama Soundariya  

Experience Summary

·         9+ years of Techno-Functional experience in Oracle ERP (GL, AP and AR & HRMS) and Oracle Fusion Financials.

·         Finance- General Ledger, Sub Ledger Accounting, Finance Accounting Hub(FAH), Fusion Financials

·         Strong technical knowledge in Account receivables (AR), Payables (AP) and asset management (EAM).

·         Developed, configured and customized multiple workflows.

·         Extensively worked with Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, TOAD, Discoverer (10g /4i), XML/BI Publisher, SQL*Loader, WebADI, Forms 6i/10g, Reports 6i/10g, OBIEE

·         Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.

·         Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

·         Strong working knowledge on the design and configuration of Chart of Accounts (COA), Multi Org Access Control (MOAC), GL Accounting Cycle and GL Work Flow.

·         Extensive experience in all phases of full life-cycle Oracle Applications implementation i.e. Requirements Gathering, Analysis, Application Configuration, Development, Testing, Implementation, Post Go-Live Support, Production support, User Training and Documentation

·         Expertise in writing Fast Formulas for Oracle HRMS (OAB) and Compensation Work Bench (CWB).

·         Functional & Technical Expertise in OAB Open enrolment processes.

·         Prepared Functional (MD50), Technical (MD70), Conversion (CV40/60) and Business Requirement/Mapping (BR100) documents using AIM methodology.

·         Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.

·         Strong knowledge in creating RTF templates in MS Word by connecting to XML and BI Publisher, and publish these templates for the reports to view data in OBIEE BI Publisher

·         Experienced in developing Conversion Programs, Inbound and Outbound Interface, Forms Customization, and Oracle Alerts.

·         Exposure to OFSAA and participated in multiple Oracle apps r12 implementations in multi org/multi-currency scenarios.

 

Technical Skills

 

Languages                                       PL/SQL, UNIX

Primary Skills                                      Oracle Fusion Financials, OIM (Oracle Identity Management) R12 General Ledger, Sub     Ledger Accounting, Finance Accounting Hub(FAH), Oracle Fusion Accounting Hub, Oracle Reports & Forms, XML Publisher, Core HR, Oracle Advanced Benefits, Financial Accounting Hub. Oracle Applications 11i (Core HRMS, Oracle Advanced Benefits (OAB), Oracle Reports and XML.

Operating Systems                        MS Windows 98/NT/2000/XP, Windows Server 2003

Development tools:                      TOAD, SQL*Plus Navigator Oracle Forms & Reports 6i and Oracle Discoverer (3i and 10i)

Databases:                                      Oracle 8i /9i/10g/11g/12c

ERP:                                                      Oracle Applications E-Business Suite 11i & R12, Oracle Fusion.

Oracle Fusion Financials, OIM (Oracle Identity Management)

 

 

 

 

Professional Experience

 

USAA, San Antonio, TX                                                                                                                                            May 2015-Till Date

Fusion Technical Consultant.

Oracle Fusion Implementation (Finance GL, AR)

 

Description of the project

The project involves the implementation Oracle Fusion accounting hub. Customizing the interfaces for the integrating with the legacy mainframe source systems. Journals are created in the PSFT GL.

Oracle Fusion and People Soft are integrated with ODI SOA/PIP architecture.

 

Responsibilities:

·         The project involved installation, development, planning, design and coding of various custom solutions as well as new enhancements and taking care of the release of custom code for Fusion Financials Module.

·         Designed and developed fast formulas for payroll process.

·         Designed and developed a custom workflow for Journal approval process.

·         Designed and developed custom validation program.

·         Developed a custom program for sending email notifications to the users when any of the program completed with error.

·         Developed Custom wrapper program for automating the jobs with Control M scheduler.

·         Developed a custom solution using post Accounting hook for Accrual reversal for the journals passed through FAH.

·         Involved in the Fusion version 10 upgrade and customized the Manual journal upload in the XLA tables. Also installed a fully customized workflow for the same using the SOA services in the Fusion middle ware

·         Involved in the implementation of Master Chart of accounts and implemented code combination rules.

·         Customized the application roles in OIM (Oracle Identity Management) and designed Custom roles for enabling read only option for the users.

·         Developed a customized code for the foreign ledger configuration and accounting rules set up.

·         Forms Personalization for accommodating business rules for rate calculations.

·         Custom Roles for enabling the differentiating the access the business and implementation user.

·         Liaised with the DBAs for achieving the TCA (Trading community Architecture) architecture as per Oracle recommendations.

·         Designed and developed Full C extract for EOI and underwriting files.

 

DISH Network, Denver, CO                                                                                                                                         Oct 2014-Apr 2015

Oracle Technical Consultant.

Oracle ERP (R12 GL, Shared HR)

 

Description of the project

The project involves both Finance and HRMS development involving planning, design and coding of various custom solutions as well as new enhancements and taking care of the Release of custom code. As a Technology Analyst, her responsibilities were supporting ERP modules like Finance, HRMS, Development Activities, Release Activities and coordinating with offshore for smooth running of the project. She is also involved in Quality Assurance carrying out testing activities deliver quality product to customer.

Responsibilities:

·         The project involved ERP development, planning, design and coding of various custom solutions as well as new enhancements and taking care of the Release of custom code for Fusion Financials Module.

·         Customize and convert existing ODBI and RDF reports that will run compatible as per the new multi-org structure and user requirement.

·         Develop PL/SQL program that extracts and generate a flat file with the client information from Automate the data load process by scheduling PL/SQL packaged procedure as a concurrent program

·         Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.

·         Involved in the Personalization of the custom international budget form so as to fit the US requirements.

·         Created custom Shell scripts to handle the loading the data file into the custom tables.

·         Extensively resolved issues in GL Accounting Cycle (Revaluation, Translation and Conversion), Designed and developed GL Work Flows.

·         Designed and developed the Events Model by interacting with the client and configured the Account Derivation rules, Mapping sets, Journal line types.

·         Designed and developed reports using Oracle 10g and XML Publisher.

·         Designed and configured the Flex field and segment qualifier as a part of COA Set up. Included the secondary tracking segment as a part of R12 upgrade.

·         Liaised with the DBAs for migrating the data form an external environment and configured TCA (Trading Community) so as to achieve data security.

·         Performance tuned  as well as customized a couple of packages with the newly achieved TCA.

                                                                                

Hartford Insurance Group                                                                                                                                        July 2012-Jul 2014

Oracle Finance Technical Consultant.

Oracle ERP (R12 Finance)

Description of the project:

The project involved the implementation of Financials Accounting Hub for processing the Events and deriving the accounting rule. The Ledgers are validated and posted in People soft. AIA PIP architecture was used to transfer the ledgers from FAH to PeopleSoft

 

Responsibilities:

·         Implementation and configuration of Financials Accounting Hub from scratch and transfer the journals to PeopleSoft

·         Configured and implemented the Chart of Accounts (COA).

·         Designed and developed the interface, custom validation program and RDF reports as a part of the FAH implementation.

·         Customized an existing workflow as per client requirements.

·         Used Oracle AQ for monitoring the queues while processing data as well as approving journals

·         Developed a Custom Validation program, involving XLA tables for journal validation using Pl/Sql and optimized performance (Bulk Collects, Collections, and Ref Cursors).

·         Developed the inbound interface to validate and post the journals in an external system.

·         Developed a new inbound interface for importing all inventory adjustments from legacy system to oracle base tables.

·         Developed the Reports using BI publisher (OBIEEE), ODBI and Oracle Reports 10g.

·         Developed Security rules and cross validation program.

·         Used the tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.

·         Involved user meetings for Gap Analysis and legacy field mapping.

·         Created intercompany Transaction, Consolidation, Elimination entries setups and configuration for user .The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger

·         Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and mapping of Costing fields with Oracle financials.

 

Michaels                                                                                                                                                                             April 2011- Jun2012

Oracle Finance Technical Consultant.

Oracle ERP (11i to R12 Upgrade)

 

Description of the project:

The project intends to perform r12 upgrade across its units. The R12 migration of all the Oracle modules was carried out successfully from 11i. This involved modifying the custom solution to make them work on R12 platform, bring new and advanced features into use so as to benefit the client. As a Software Engineer, the responsibilities were supporting modules like GL, AP and AR. was involved in the Development Activities, Release Activities and Migration Activities coordinating with offshore for smooth running of the project.

 

Responsibilities:

·         Development of concurrent program to extract date from the Oracle database to .csv files to be loaded in to the legacy database by using UTL_FILE.

·         The R12 migration of all the Oracle modules was carried out successfully from 11i. This involved modifying the custom solution to make them work on R12 platform, bring new and advanced features into use so as to benefit the client

·         Custom P2P(Procure to pay) Process: The process of procuring material from the organization and getting paid for the process of handling material .This process picks the PO’s which have AP invoice option defined in DFF and create Requisitions and creates against the Supplier.

·         Designed and executed ‘Data migration’ strategy for master and transactional data. Post go-live support.

·         Developed several XML publisher reports for Oracle HRMS and Fusion Financial modules.

·         User interaction and requirement gathering for new enhancements and resolved ongoing support tickets.

·         Fine-tuned the interface using SQL*Trace and TKPROF and worked on a couple of patches for year-end processing.

·         Extensively resolved issues in the GL Accounting cycle (Translation ,Revaluation ,Conversion ,Consolidation)

 

SUPERVALU                                                                                                                                                                       August 2010-May 2011

Keane Inc. (Formerly Caritor)

Oracle Finance Technical Consultant.

Oracle ERP (11i Finance)

 

 

Description of the project:

 The project involves ERP supporting for Supervalu, porting of the application to higher versions keeping the customization intact, planning and executing migration and taking care of the Release of custom code. As a Software Engineer, the responsibilities were supporting GL, and HRMS modules, Annual Enrollment, Release activities, Conversion Activities and coordinating with the onsite for smooth running of the project.

 

Responsibilities:

·         Enhanced of the existing interface using PL/SQL Developer for File transfer.

·         Developed RDF Reports and XML reports using Reports 6i/10g and XML Publisher

·         Worked on configuration changes for Brazil New entity (R12)

·         Configured Audit Trial for the Mapping sets to enhance the security while DML operations.

·         Analyzing issues reported by business in standard and custom oracle functionality and finding fixes for the issues.

·         Preparing Understanding documents, Design Documents, Unit Test Plans.

·         Gathered the requirements, enhanced and fine-tuned the Interface program using PL/SQL.

·         Developed the custom validation program using PL/SQL and the outcome of the validation will be sent out as a PDF reports to the users.

 

Fidelity Investments                                                                                                                                      September 2007- July 2010

Oracle Technical Consultant.

Oracle ERP (11i HRMS)

The project involves the configuration of Open Enrollments for the client of Fidelity investments and upgrading the application to r12.  As a Software Engineer, the responsibilities were customizing the GL and HRMS modules, release activities, conversion activities and coordinating with the onsite for smooth running of the project.

 

Responsibilities:

·         Designed Derived Factors, Life Events, Standard Rates, Variable Rates, and Coverage Calculations, Actual Premiums etc.

·         Form customization to enable COBRA Subsidy and developed Fast Formulas.

·         Developed OAB fast formulas for Person Change Cause Life event, Enrolment Coverage Start Date, End Date, Rate Start Date, Rate End Date, Coverage lower and upper limits, Dependent Eligibility rule, and Length of Service Date, Waiting Period Value and UOM formula types.

·         Developed outbound interface programs for OAB as per HIPAA compliance for Medical, Dental, Vision, COBRA and FSA Benefits information using System Extract processes to send interface files to third party providers.

·         Handled Annual Open Enrolment for two prestigious customers of Fidelity – DirecTV & Alstom

·         Developed custom date track forms to maintain employee union benefits and integrated with Oracle HR.

·         Created complex reports (On demand, Adhoc Reports, Summary Reports, and Letter Formatted, Graphical etc.) using XML Publisher and ODBI Reports.

·         Preparing Understanding documents, Design Documents, Unit Test Plans.

·         Designed and configured the grade structure

·         Involved in the configuration of ODI.

 

 

Education & Professional Development

B. Tech (Electrical and communication Engineering), SASTRA University, 2007