Professional Summary

• Overall 8 years of experience as an Oracle Functional Consultant with expertise in both 11i and R12 versions financial modules General Ledger, Accounts Payable, Accounts Receivable, Financial Accounting Hub FAH , Sub-Ledger Accounting SLA , Fixed Assets and Cash Management.
• Experience on EBS integration with ODS, PeopleSoft, Hyperion and Web-Methods.
• Experience on Oracle EBS integration with Planning, Reserving and Reporting applications.
• Expertize on Non Oracle Applications / Sub-ledger systems integration with Oracle GL.
• Expertise in all ERP implementation stages including Requirement gathering, GAP Analysis, Solution Design, Configurations, Migrations, Testing, Documentation, go-live and Post Production support.
• Expertise in SDLC methodologies like AGILE, Waterfall.
• Have expertise in Oracle Financials Implementations based on OUM/AIM methodologies.
• Involved in MOAC Multi-Org setups for multiple clients.
• Handled User issues / Production issues directly and guide them on various modules of the system.
• Done end to end Set-ups / configuration in all environments Development, QA, UAT, SIT, GOLD and Production .
• Exposure in documentations like MD 50, MD070, BR 100, TE040, FSDs, TSDs, Test Cases, Business Process BP , Training Cook-Book and Design Documents, Conversion, Interfaces and Report Requirement.
• Sound knowledge on Financial Accounting, Financial Reporting, Procure to Pay P2P and Order to Cash O2C Cycles.
• Worked on ERP Implementation as well as ERP Support Projects at client locations onsite
• Strong skills in Business Analysis with proven success in analyzing and translating business requirement into functional and technical requirements.
• Worked on PeopleSoft Integration with Oracle E-Business Suite using DVM and AIA/PIP architecture.
• Expertise on Business process modeling.
• Capable of thinking in and out of the box with innovative ideas and solution to make efficient system architecture.
• Worked on Purchasing, Inventory, Order Management Supply Chain SCM modules as part of the P2P and O2C implementations. Worked on Item Master IMO as part of the e2e implementations.
• Effective communication skills maintaining collaborative relationship among stakeholders, customer and business unit.
• Expertise in End User Trainings and UAT.
• Involved in Period Close Activities, Job monitoring, and Post go-live support.
• Good Domain knowledge especially in Banking, Finance, Insurance and Manufacturing.

Skill Set

Professional Experience

Confidential

Confidential is a reinsurance company based outConfidential It is world's second largest reinsurer after having acquired Confidential. Swiss-re operates through offices in more than 25 countries. Swiss-Re was ranked 334th in Fortune Global 500 in 2013. Swiss-Re consist three Business units Re-insurance, Corporate Solutions CorSo and Admin-Re. Reinsurance is Swiss-Re's largest business in income terms, providing about 80 of gross premium through P C and Life Health Insurance. Corporate Solutions offers insurance to mid-sized and multi-national corporations across the globe. Admin-Re provides risk and capital management solutions.

Role: Solution Architect /Business Analyst

Responsibilities:

• Analyze the existing Process architecture, Financial Data flow, GL and Sub-Ledger systems and provide solutions in terms of Data Integration, Financial Accounting and Reporting with 0 dependencies on technical interfaces LFD Local Financial Data and GFD Global Financial Data .
• Provide Solutions for Multi GAAP reporting for USA, Canada, Australia, Luxemburg, Japan, Brazil geographies for Insurance, Claims and Investment Legacy systems.
• Analyze the CorSo business and understand the accounting rules required to be setup in the SLAM templates for US GAAP, US STAT, IFRS, AUS GAAP / APRA, LUX GAAP, JGAAP, Brazil GAAP reporting for all legacy systems.
• Analyze the existing data integration, conversion, interfaces and build the ODS Oracle FAH / GL interface keeping ODS as hub for all data and Oracle FAH as sole owner for all financial accounting.
• Build the extensions in FAH for DAC Amortization calculation and Reserve-Discounting calculations and accounting.
• Configure Oracle FAH for all legacy systems / Non-Oracle Sub-Ledger Applications to facilitate the Multi GAAP, Multi Ledger, Multi Currency and Multi period reporting.
• Configure Oracle GL handling Multi GAAP, Reporting Currency and Geographic specific requirement.
• Setup MOAC to control the user access.
• Data conversion, Mapping and Migration.
• Documentations BRD, BR100, Functional Specification, Conversion, Use Case, Technical Specifications, TE040
• GL Mass Allocation, Manual Journal Loads through ADI, Data Conversion, Translation and Revaluation, Thin Ledgers Architecture, Reporting Currency Ledgers.

Environment: Oracle Application E-Business Suite R12, 12.1.3 GL, FAH, SLA , Legacy Sub-Ledger Applications, ODS, Oracle 11g, TOAD, SQL Loader.

Confidential

Confidential is an Confidential global diversified industrial company founded in Confidential. Ingersoll-Rand has been a constituent of the S P 500. On Confidential, Ingersoll-Rand completed the spin-off of its security hardware sector into standalone business named Allegion. Allegion maintains well known commercial and residential security hardware brands such as Confidential

Confidential

Role: Solution Architect / Functional Consultant AP/AR/Purchasing/SLA/Web-Methods

Responsibilities:

• Enhancements Worked on Oracle AP/AR Integration with ACS/BOA Banking systems through Web-Method interface. Worked on custom API to load supplier and supplier bank details.
• Support Maintenance Providing daily end to end support for Oracle AP/AR modules.
• Worked on Period Closing for Oracle GL and Sub-Ledger modules.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Address Operational, Functional issues raised by end users providing timely solutions and training.
• Follow up of SR and Applications of Patches as and when required
• Worked on Purchasing and Inventory modules while resolving the issues came during daily monitoring in AP and AR modules.
• Responsible for leading the Support activities and managing the offshore team.
• Responsible for Leading and handling the Change request and providing continued improvements for the client team.

Environment: Oracle Application E-Business Suite 11i GL, AP, AR, Purchasing, Inventory , R12 12.1.3 GL, SLA , APPLOAD, Oracle 11g, BMC Remedy, SQL Developer, Web-Methods.Confidential is the leading manufacturing company and global supplier of advanced micro-acoustic, specialty components and human interfaces solutions in the mobile communications, consumer electronics, medical technologies, military / space and other industrial end markets.

Role: Solution Architect / Functional Consultant GL / SLA / AP

Responsibilities:

• Providing Solutions on Accounting Reclassification 11i issues using R12 SLA features.
• Provide solution on Primary Ledger, Secondary Ledger, COA structures
• Functional setup, configuration and Testing in R12 Development and QA Instance.
• User training and Presentations to Knowles Functional Team on R12 Financial Modules GL, AP, AR, FAH specially focusing on new features in R12.
• Understanding the existing functionality in 11i and helped the Knowles Functional team during e2e configurations in R12.

Environment: Oracle Application E-Business Suite 11i GL, AP, AR , R12 12.1.3 GL, AP, AR, FA, SLA , Oracle 11g, HP Quality Centre, TOAD.

The Confidential is a fortune 500 company and of Confidentiallargest Investment and Insurance company. The company's earnings are divided between Property Casualty P C operations, Group Benefits and Mutual funds. The Hartford is the 12th largest P C company in the United States based on Direct written Premium. The Confidential sells its products primarily through a network of independent agents and brokers and has been the direct auto and home insurance writer for AARP's members for more than 25 years.

Role: Functional Consultant / Functional Lead R12

Responsibilities:

• Requirement Analysis, gathering and AS-IS sessions with the HIG stakeholders, Finance Team and GL Admins.
• Understanding the existing functionality and financial data flow from Sub-ledgers to GL and Hyperion.
• Developing new interface and coordinating with technical people
• Explaining Process and functionality to the technical team
• Understanding the integration involved in this project.
• Build end to end solutions for all implementations and enhancements.
• Work as Liaison between TCS Off-shore and HIG Business Team.
• Prepared BR100, DS030, MD50, TE40, FSD and Business Process BP for all implementations and enhancements as per AIM methodology.
• Mapping with Legacy to Oracle FAH.
• Functional owner for integration between Oracle GL and PeopleSoft GL.
• Done E2E setup in Gold, UAT, QA, Configuration and Development Instance. Manual and Automated . Total 78 Sub-Ledger systems
• Done Oracle GL /SLA/FAH configuration along with the integration with PeopleSoft through DVMs.
• Worked closely with DBA for Sub-Ledger Template migration among different instances through FND and AAD upload.
• Done code review for the customized packages to ensure the requirement is correctly addressed through the prepared executable.
• Done customizations using Custom Source, PL/SQL Functions, Look ups and DFFs.
• Prepared Oracle Template for Mapping.
• Tested all end to end functionalities in financial modules.
• Tested on Period end and Financial Closure
• Troubleshooting Journal sub ledger transfer and journal import issues
• Troubleshooting data issue fail during validation and Processing stage Event Creation and Accounting with in FAH.
• Ownership for Warranty support and later enhancements CR's .
• Conduct user trainings for Oracle FAH and GL modules and create training material Cook-Book .

Environment: Oracle Application E-Business Suite R12 12.1.3 GL, FAH , Oracle 11g, HP Quality Centre, TOAD, PeopleSoft, Legacy Sub-Ledger systems, ODI Interface, BPEL, Data Loader.

Confidential based networking and other products related to the communications and information technology IT industry and provide services associated with these products and their use. The Company provides a line of products for transporting data, voice, and video within buildings, across campuses, and around the world. Its products are designed to transform how people connect, communicate, and collaborate. Its products are installed at enterprise businesses, public institutions, telecommunications companies, commercial businesses, and personal residences. The Company operates in three segments Confidential.

Role: Business Analyst / Solution Architect

Responsibilities:

• Requirement Analysis- Requirement gathering, Feasibility analysis based on SABA 5.4, Resolution of doubts faced by WIRE FRAME team, requirement owners during Business Requirement Release. Key Role during Concept commit and Executive commit from IT Analysis Solution team.
• Development Deliverables GUI development, Test scenarios, Business Requirement, Functional Requirement Document, Technical Requirement, Training Material creation, Communication piece, Data migration, Quality approvals for all the deliverables.
• Process modeling Process / Application modeling on ARIS tool. Use Case TRD preparation, Data modeling.
• Process monitoring On going process monitored after deployment using impacted production data, bug-fix or data-fix execution if required for successful implementation of requirement in the live system.
• Issue resolution with user Facilitating Data-fix/Bug-fix activity, Analysis of CR raised, Enhancement sign-off with user taking design development concerns into account.
• Interface study while discussing the requirement with other system owners, End to end verification on interface development.
• Policy sign-off, UAT Final subsidiary creation in production,
• Communication with the end users.

Environment: SABA, TOAD, OHARMS, PAYROLL, LMS, CPC, HP Quality Centre

transform ideas into world-class products and solutions. Confidential provides technology consulting, new product development, system integration and testing services for leading product companies, service providers and aspiring start-ups. A part of the 100 billion Confidential addresses the communications, consumer products, defense, healthcare, media entertainment, semiconductor and transportation sectors. Key services include embedded product design, industrial design, animation visual effects and systems integration.

Role: Functional Consultant / Functional Configurator

Responsibilities:

• Responsible for handling activities involved in the end to end SDLC process while implementing Oracle Applications R12 AR, AP, GL, FA and SLA.
• Responsible for all the documentation related to Requirement Gathering, Solution Design Testing and User Training.
• Financial/Projects Data Analysis and Migration into Oracle Apps from Legacy system.
• Suggested and implemented the Secondary Ledger solution to handle multi-period and multi currency reporting requirement of a subsidiary.
• Responsible for e2e OGL setup in Prod, UAT, QA and DEV instance.
• Handling the tickets, resolving the issues on day to day basis on priority.
• Prepared CR Documents for any changes in Production Instance
• E2E Testing for GL and SLA in Dev, QA and UAT environment.
• Prepared Test documents for All issued and keeping in Share point
• Getting inputs from Users and resolved issues based on priority.
• Done setup configuration for finance modules in all instance- DEV, QA, UAT and PRODUCTION.
• Suggested to technical consultants for Customization objects.
• Raising the SR to oracle when the issue is critical and follow up with DBA Team
• Testing thoroughly issues and providing solutions to the end users
• Prepared Impact Analysis documents and delivered to the Client

Environment: Oracle 11i GL, AP, AR, FA , R12 GL, AP, AR, SLA, FAH , PL/SQL Developer, GHD, SQL Loader

India-based company engaged in the business of providing information technology-enabled services ITES / business processing outsourcing BPO services, primarily to Citigroup entities worldwide.

Role: Financial Functional Analyst / Product Configurator

Responsibilities:

• Working on the project by using AIM methodology
• Prepared Business Process documents based on client requirements BP80
• Prepared training documents for CRP1 and CRP2.
• Prepared data migration documents for all financials modules
• Prepared documents for UAT and Test scripts.
• Prepare other project Documents like TE-40, BR-100, MD-50.
• Requirement Gathering and Configuration for AR, AP, GL Modules
• Configured various setup's in GL Accounting calendar, Currencies, chart of Accounts, Ledgers, Cross validation segments, Segment Security Rules , Auto Post criteria, Reversal Journal , Recurring Journals, Journal Sources Categories, Suspense accounts , Intercompany Accounts Budgets , Financial Statement Generator.
• Configured various setup's in AP Supplier Creation, Setting up Financial, Payables options, Payment Terms, Distribution sets, Payment formats, Employee Expense Management and Supplier Bank Creation
• Configured various setup's in Purchasing and Inventory Item Master Creation, Item Attributes setup, Item Master Organization IMO
• Participated in System Integrated Testing, Regression Conversion instances Testing.
• Setting up Financial, Payables options, Payment Terms, Distribution sets, Payment formats and Document sequencing.
• Setting up Data Access Set Definition Access Set.
• Defining the Ledgers and Ledger sets
• Trained End users conducted UAT.
• Handled Post Implementation Support for GL, AP and FA.
• Interacting with technical consultants DBAs.
• Prepared End user Manuals Deliverable documents
• Supporting and solving day to day end users problems.
• Report to Management on the status of the developments.
• Testing new business requirements in the Test Instance and validating the same in Production.
• Raising the SR to oracle when the issue is critical.
• Preparing and Reviewing Functional specification and understanding about Customizations to provide KT to Team members.
• Supporting on Day to Day operational issue on financial modules
• Troubleshooting Journal sub ledger transfer and journal import issues
• Helping customer on sub ledger and General Ledger balances reconciliation.
• Supporting on day to day end user issues
• Supporting on Period end and Financial Closure

Environment: Oracle 11i GL, AP, AR, FA , R12 GL, AP, AR, FA , PL/SQL Developer, GHD, SQL Loader