We provide IT Staff Augmentation Services!

Senior Applications Analyst Resume

4.00/5 (Submit Your Rating)

Winston Salem North, CarolinA

PROFESSIONAL SUMMARY:

  • Working as an Oracle Applications Finance Techno Functional Consultant, having over 12+ years of professional experience in the industry out of which 10+ years in Oracle Financials.
  • Led improvements for implementing our Vertex taxing software engine, enabling proper tax collecting, reporting and order placements
  • Have done 3 full life cycle Implementations, 2 upgrades, 40+ Rollouts for 23 Countries and 2 support projects.
  • Knowledge in Oracle Fusion Financials Applications (GL, AP, AR)
  • Worked in Oracle technologies SQL, PL/SQL, Forms 6i, Reports 6i both development and support.
  • Expert in SLA Setups and MOAC
  • Played Key Role while Implementing the Financial Accounting HUB (FAH). 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
  • Defined Request Set and Interfaced the data to oracle via FAH by scheduling Interface Jobs from Legacy Systems
  • Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables.
  • Developed Customer Conversion to load historical data into Oracle base tables
  • Having complete idea of the business flow among GL, AP, AR, FA, CM, and having a Substantial implementation, Supporting and Testing experience in the Finance Modules.
  • Good control over Procure to Pay, Order to Cash cycle. Have working knowledge on Inventory, PO and OM.
  • Having extensive experience in Requirement Gathering, Functional Fit-Gap Analysis, Application Design, Configuration, good at preparing documents such as Project Implementation methodology documents, SOP’s, Training Guides, User Manuals and Test scripts
  • Conducted many AS-IS and To-BE Sessions, CRP’s, Super User and User Trainings
  • Created Data Mapping templates between Oracle applications tables and Legacy Systems
  • Skills and areas of expertise in AP / AR / GL / CE / eBiz Tax
  • Extensive experience in Master Data Conversions, Open Data Conversions and Reconciliations from legacy to Oracle.
  • Worked under production support environment for the following modules GL, AP, AR, FA Inventory, Order Management, Purchasing, System Admin in the India localization stream.
  • Having hands on experience in creating Web ADI and Data loader templates
  • Effectively participated in Client Interactions for clarifications and resolving issues, ability to learn new things quickly and work under pressure. Have logical and analytical skills.
  • Hands on experience in Implementing lifecycle phases in Oracle Applications 11.5.10.2 and R12 as Functional Consultant.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, WINDOWS 9X/NT, WINDOWS 2000

Languages: Oracle PL/SQL

Tools & Utilities: MS-ACCESS, ORACLE 11i, Toad

Enterprise resource Planning packages: Oracle Applications 11i(11.5.9) (11.5.10.2) & R12.1.3, R12.2.4

Finance Modules: GL, AP, AR, CM, FA.

Awareness Modules: OM, PO, INV, Purchasing, Cost Management

PROFESSIONAL EXPERIENCE:

Confidential, Winston Salem, North Carolina

Senior Applications Analyst

Responsibilities:

  • Functioning as an Upgrade Lead for R12 Project for finance Track.
  • Worked closely with team to retrofit CEMLI's to R12.
  • Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report
  • Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables.
  • Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table Led cross functional discussion with business users to address critical upgrade issues.
  • Performed Pre Upgrade setups and Post Upgrade Setups Finance modules
  • Worked on SLA Upgrade, SLA Changes
  • Customized AGIS Process
  • Worked on Vertex tax engine for all countries, defined setups, created rules
  • Worked widely on Order Management- AR Invoice receipt custom process
  • Worked precisely on Vendor royalty payments (Distributor Payments on sales)
  • Developed Custom payments structures to hold PPR’s at various levels for validations till payments
  • Extensively worked on Oracle EB tax configurations, Vertex rate updates, ebtax loaders, SLA, AGIS and Payment process.
  • Configured Use tax (Self-Assessment Tax) and offset tax setups.
  • Involved in EMEA VAT process setup and VAT registers.
  • Prepared tax loader files, vertex post and pre calculation rules.
  • Configured India GST setups (IGST, SGST, and CGST) in Ebtax and vertex.
  • Worked on AGIS personalization’s and SLA changes as per business requirements.
  • Worked extensively with Oracle SR’s in application of patches, reproducing the issues, providing MGDF’s, Logs, AP lists etc
  • End to End integration testing of Order to Cash procure to pay till General Ledger flow processes touching integration points and customizations.
  • Prepare the Future State Design Document across Financial Modules
  • Work Closely with Other Module Leads to define the dependency on each Modules
  • Preparation of Functional design documents for new Customizations
  • Worked on many custom reports with technical team, making them in understanding and developing as per client requirements

Lead- Finance Implementations & Conversions

Confidential, Indiana

Responsibilities:

  • Analyze the business systems, business process requirements and future needs
  • Collection of the necessary master data and setting up (application setup) all the financial modules in Test and Production instances to meet the requirements of client
  • Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA (Sub ledger Accounting)
  • Participated and demonstrated the Functionality of FAH during the CPR Sessions
  • Coordinate with offshore technical team for data conversion..
  • Test Sub-ledger integration for procure to pay and order to cash cycles.
  • Demonstrate Sub ledger Accounting (SLA) functionality and Create Accounting program to streamline month end close process and check sub ledger journal entries before transfer to General Ledger.
  • Perform system administrator role, and created users and custom responsibilities.
  • Prepare data conversion reports, and uploaded data using Data load software.
  • Prepare training manuals, test scripts and conducted training and CRP.
  • Conduct FSG training session for end users.
  • Identify problems, researched the issues and provided solution
  • Master Data and Transaction Data (AP Transaction, Fixed Assets) migration using Application Desktop Integrator, Data loader and migration interface, testing for data migration
  • Facilitate the Testing of the solution (designed as a part of To Be) by users in Conference Room Piloting (CRP)
  • Study of existing data for the purpose of data migration and provided the data template to the client for data migration.
  • Interact with the user for business requirement scenarios (RD-050)
  • Prepare the ‘To Be’ business process flows based upon the existing business practices and business requirement scenarios.
  • Map business scenarios, and identified the high-level gaps (BR-030).
  • Decision on Custom Reports, designing of Report Layout and parameterization.

Confidential

Responsibilities:

  • Participated and helped Confidential team in understanding AS-IS Process of GBS India in upgrading for 11i to R12
  • Gave all Master Data and Open Data extracts for CRP’s and Production
  • Converted more than 24000 Assets from GBS to Confidential in Production
  • Have done all consolidations of GBS India Ledgers and Migrated to Confidential
  • Conducted KT sessions for Confidential team to understand GBS India business process

Confidential

Track Lead- Enhancements

Responsibilities:

  • Rolled out 40+ ledgers for Asia Oracle in 23 Countries covering finance modules GL, AP, AR and FA
  • Well Documented as per the AIM methodology standards prior to CRP/KUT session along with site leads. And responsible to attend the calls with the client from off shore as and when required.
  • Conducted CRP and KUT sessions to exhibit the business presentation on proposed solution designs according to the baseline business requirements along with PM and Site leads.
  • Carried out the KUT sessions to the ledger owners (Super users) followed by the CRP.
  • Modified the existing Interfaces and developed the custom reports as per the functional specs with the help of Tech team. Involved proactively in legacy data migration of financial data into oracle.
  • Achieved the GO-Live date and released the instance to the users before announced date subsequently provided the short period post production support and proactively close the issues and facilitated to the users in closing the quarter end and year-end financial books.
  • Participated in various kinds of issue resolution for Financial functional issues and was responsible for areas such as GL, AP, AR, FA, CM and India Localization.
  • Involved in resolving the day-to-day issues, which are faced by the end users but not limited to, like the errors that are generated, not progressing with actual flow of the functionalities, making use of certain new functionalities.
  • Responsible for supporting the applications based upon the functional requirements of the client taking into their considerations by discussions, Teleconferences.
  • Coordinated with core users with regard to solution for Service Requests raised by them with Oracle
  • Helped Technical Consultants in preparing the conversions, documentation and helped them in preparing the reports by providing them with the functional aspects.

Confidential

Team Member - Financials

Responsibilities:

  • Provided analysis, design, and mapping of client’s requirements to Oracle
  • Designed customized reports, fit gap analysis, and all documentation and deliverables.
  • Developed interfaces and data conversion programs for applications
  • Report and coordinate activities with customer project manager
  • Handled connection issues, bank related problems, and printer installations.
  • Maintenance of issue logs at each stage of project and their resolution
  • Address operational problems, concerns, and questions posed by users
  • Involved in the Data Migration to external systems.
  • Preparation of data conversion strategy, data conversion into Production Instance
  • Preparation of Project Documentation, such as Test Scripts, Standard Operating Procedures, Training Material and Setup Document

Confidential

Financial Functional Consultant

Responsibilities:

  • Analysis of the business requirements from client.
  • Extensive Interaction with Functional Super users to gather business requirement, performed analysis for change requirements.
  • Identified requirements/ functionalities, and conducted process/ gap analysis and mapping the business processes.
  • Analyzing the gaps and recommending to the necessary customizations.
  • Configuring the modules, designing reports, add-ons and coordinating with the technical team to monitor development and implementation progress.
  • Designing and implementing various tests, debugging the software and providing post-live support.
  • Facilitating end-user training and developing the various user manuals.
  • Created legal entity, Operating units and Inventory Organizations
  • Created Users, Responsibilities, Menus and Form Personalization in AP Invoice Workbench, and Customer Master
  • Setups pertains with india localization likewise Organization Additional Information,Sub inventory locations, Bonded Registers,VAT/Service Tax Regimes and item classes.
  • Setup Tax Codes, Tax Categories and Item Tax Categories and Supplier and Customer Additional Information.
  • Mapped OSP process between the Operating units and outside job work supplies.
  • Mapped IC-ISO functionality between OU’s for Stock transfer along with the customizations
  • Define Standard Apps setups in accordance with Entity GL Setups like Chart of Accounts, Set of Books, GL Account Aliases
  • Defined value sets, key flexfield segments and roll-up groups with security and cross validation rules and Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet
  • Defined Payables and Financial Options and Supplier and supplier sites and look up codes in AP Entity
  • Defined AR System Options, Auto Accounting and Transaction batch sources and Transactions types, Customer/Sites, Line/Grouping rules and so on in AR Entity.
  • Mapped DFF’s values between Entity and CORE instance
  • Developed Custom reports to ease the Financial Period Closing activities includes monthly, quarterly, and Yearly, includes Financial, legal reports and Manual Invoice reports.
  • Defined Subsidiary Set of Books as per Schedule - VI requirement, Defined Consolidation Rules and mapped between the Parent and Subsidiary Books.
  • Defined/Mapped Credit Check Functionality by involving in the AR and OE module in Custom environment Post Production Support:
  • Handled Issues related with GL, AP,AR, and Setups related issues and Custom reports remodifying
  • Handled month end activities for General Ledger and Accounts Payables and Accounts Receivables along with india localizations issues
  • Charts of Accounts maintenance, changes in setup of GL & AP as per process requirements.
  • Involving BOM, WIP, OE and Inventory related issues.

Confidential

Financial Functional Consultant

Responsibilities:

  • Handled Production Support Group issues related to Oracle Payables, Oracle Receivables, Oracle Cash Management, Oracle Order Management Modules
  • Team Member in the Production Support for Oracle Financials Modules.
  • Involved in setups & testing of Oracle Payable and Oracle Receivable Modules in testing instance for each new releases.
  • Configure the business process in the Test Instance and testing of various business scenarios.
  • Interaction with the DBA & Technical Consultants .
  • Troubleshooting and solving the issues related to Oracle Payables, Oracle Receivables, Oracle Cash Management and Oracle Order Management.
  • Proactively resolved AR Auto invoice Errors and then importing to AR base Table
  • Proactively monitoring the scheduled concurrent programs status on daily basis
  • Coordinating with Oracle support to resolve standard application issues.
  • Proactively worked on the customers stuck in the interface by resolving the errors and then importing to AR Base table.
  • Worked on the customer related issues like creating the relationships activating & inactivating the customers and customer sites
  • Resolved the AP interface errors and then importing to AP

Confidential

Financial Functional Consultant

Responsibilities:

  • Developed a reporting and tracking mechanism of the various fraud strategies in place to measure their effectiveness in terms of fraud decline rates and approval rates.
  • Movement of fraud related reports to the risk portal so as to be used as a dashboard of information. Distribution of redeem request: Approval and distribution of the payments according to the payment options and cash out limits.
  • Over charges: If the player is over charged (charged extra) for a deposit or not been given credit for the same. Investigations Team deals with all the deposit overcharges.
  • Delays in payments: When the cash outs have not been processed at their respective turnaround time and there is a delay.

We'd love your feedback!