Financial Support Analyst
Dubai Silicon Oasis Authority
مجموع سنوات الخبرة :15 years, 10 أشهر
Support the Oracle finance system environment & manage projects related to Finance for Dubai Silicon Oasis Authority. Partner with the accounting team to stabilize, enhance and scale the Finance applications environment to meet DSOA’s accounting needs.
Contribution:
- End to End Understanding of the below processes in real estate industry
o Project Budgeting & Costing
o Fixed Assets Management & Accounting
o Community Fee Billing
o Leasing (Residential / Commercial / Multi Year Land Lease)
o Licensing
o Sale / Resale Properties
o CRM
o Procure to Pay
o Revenue Management
- Apply accounting knowledge and experience to implementing, supporting, migrating and enhancing DSOA’s Oracle applications.
- Operate as a functional financial systems expert for the Accounting and Finance department.
- Work with the accounting and technical resources to support, enhance and scale the existing Oracle Financials system.
- Gather and formalize business requirements and prepare detailed documentation.
- Align with accounting department to design and implement new business processes to align with system solutions.
- Setup and configure Financial modules in Oracle as needed.
- Partner and coordinate with developers and 3rd party hosting provider on executing Finance system improvements.
- Plan and conduct regression tests, user acceptance tests, and data validations.
- Provide support to business unit and work with team to resolve critical issues.
- Identify, document and expedite resolution of Oracle functionality issues. Track and expedite Oracle SR (Service Requests) and assist with the planning and testing of updates and patches.
- Develop and maintain training materials and job aides. Conduct end user training.
- Develop and maintain functional specifications for custom reports and processes utilizing Oracle FSG’s and Discoverer.
Project: SCM and Financial Package Implementation for Gerab National Enterprises (Dubai, UAE)
Role: Techno Functional Consultant
Duration: Nov-2012 to Present Date
Solution Environment: Oracle Applications E-business Suite 12.1.3 (ERP), SQL & PL/SQL, XML Publisher, Oracle Forms 10g, Oracle Report. 10g, SQL, PL/SQL, XML, BI Publisher, Oracle API, Oracle Open Interface Tables, Oracle Workflow, Oracle Alerts, and Oracle Forms Personalization
Modules Integrated: Payables, Receivables, Order management, Purchasing, Inventory, Work In Progress, Fixed Assets, and General Ledger
Project Description:
The scope of the project was to do fresh R12 implementation for Gerab National Enterprises. It was a large scale implementation involving all Financial and SCM modules.
Contribution:
- Interacting with the client to understand their requirements and provide the solutions for the same.
- Responsible for Data Migration/Conversions (Master & Open Balances).
- Documentation as per A.I.M methodology
- Fully responsible for migration of Supplier, Sales Order, Item Opening Balances, Item Master, Item Categories and AR Receipts.
- Responsible for the design & delivery of all the Custom Deliverables (Forms, Reports, Work Flow, Alerts).
- Reviewing the design & code of the team members.
- Data Migration
- Design & Build inbound & outbound interfaces.
- Oracle Alerts.
- Forms Personalization.
- Post Production Support.
- Helping with month end reconciliation and period end activities.
Role: Tech Lead
Duration: Dec-09 to Sep-10
Solution Environment: Oracle Applications E-business Suite 12.0.6 (ERP), SQL & PL/SQL, XML Publisher, Oracle Forms 10g, Oracle Report. 10g, SQL, PL/SQL, XML, BI Publisher, Oracle API, Oracle Open Interface Tables, Oracle Workflow, Oracle Alerts, and Oracle Forms Personalization
Modules Implemented: AP, PO, AR, FA, GL, CM and INV
Tools: PL/SQL Developer, XML Publisher, Oracle Forms 10g, Oracle Reports 10g
Responsibilities & Achievements:
- Tech Lead for the Project.
- Responsible for all the Data Migration/Conversions (Master & Open Balances).
- Worked on Employee, Supplier, Customer and Item master migration.
- Worked on open AP Invoice, AR Invoice, AR Receipts and AR Deposits migration.
- Responsible for the design & delivery of all the Custom Deliverables (Forms, Reports, Work Flow, Alerts).
- Writing and reviewing the Documents (MD050, MD070, CV010, CV060)
- Configured Electronic Funds Transfer in Oracle Payments for NEFT, RTGS, PODD and Direct Credit Formats.
- Reviewing the design & code of the team members.
- Design & Build inbound & outbound interfaces
- Oracle Alerts
- Forms Personalization
- Helped the functional consultants in procure to pay modules.
Qualification Branch Institute University/ Board % Year of Passing Bachelor Of Technology Information Technology Nirma Institute of Of Science & Technology Nirma University 70.5 2008
Pre-University (Class XII) Science St. Kabir Gujarat Board 78.5 2004
Secondary School Certificate (Class X) General C.U Shah English Highigh School Gujarat Board 80.5 2002