SUMMARY:

• 25 + years of excellent expertise, 15+years of which is in ORACLE environment.
• Functional Expert with heavy exposure in the Oracle Fusion and Could Financials, Procurement, Order Orchestration, FAH, OBIEE, OTBI and R12 Modules of GL, AP, AR, CE, IE, FA, EB - Tax, O2C, P2P, OPM, TM, OTM, PA.
• Well versed on report generating tools such as OBIEE, Hyperion, Essbase, Discoverer, FSG, SQL queries.
• Working knowledge of Sys Admin, IDM, IAM, GRC and E-Commerce.
• Global oracle financials implementations with expertise in R12, Cloud and Fusion.
• Business process analysis, Solution Design, reengineering, mapping, global design, road maps and architecture.
• Program/Project management, team lead, deliverables, timelines, resource allocation, job scheduling, quality assurance and design presentations.
• Multi-Currency, Multi Org, Multi Companies (Group), Multi Location, expertise with Country specific Localizations.
• Extensive Functional knowledge and expertise in Oracle Applications Cloud, Fusion, R12, SQL*Loader, Forms, Reports, SQL and PL/SQL.
• Extensive knowledge in business requirement analysis, user consultations, software implementation, tests planning, and user support.
• Self-motivated and hard working with good leadership quality.
• Excellent communication & interpersonal skills and efficient team player.
• Excellent Accounting expertise as Chartered Accountant.

AREAS OF EXPERTISE:

• Developed from Oracle Functional consultant, Team Lead, Solution Architect, Project Manager to IT DIRECTOR.
• Provided IT Architecture and Road Maps of current and future environments for the IT Systems and Integrations with the suggested changes and impacts with Innovative ideas and thoughts.
• Prioritized IT Projects, based on business needs, made presentations in Management Committees, Steering Committees, provided options of Software Hardware Systems and Vendors with cost benefit analysis and pros and cons managed the IT Portfolio in the best way to the overall efficiency and growth of the company.
• Having the frequent meetings and interaction with the Business Managers, key stakeholders, understand their Business Processes and IT Requirements, work hand in hand, to make IT as a best Service Org.
• P repared IT Strategy Plan documents for medium(3yrs) and long terms(5yrs). This includes the changes planned in IT Systems of Software and Hardware, Business Processes, Change Management, Process re-engineering, Budgets.
• Maintained the IT Divisions’ Goals and Objectives, based on IT Portfolio, Business Plans. Accordingly set and measure the Goals and Objectives of Individual IT Managers and changes done having the quarterly and yearly reviews.
• Worked proactively and as role model Leadership for the IT Managers and Teams. Provided support and guidance to the IT Teams to improve their efficiencies.
• Had the transparency and prioritization methodologies in Business Issue Management process, made sure that the business operations run smoothly.
• Had the consulting experience through Big Five of Confidential.
• Managed the migration to Cloud Architecture from dedicated servers.
• With the Accounting and Finance background, suggested efficient and speedy period close processes and reports used for Accounting, Finance, Management and Operations. Successfully done Acquisitions and Mergers processes.
• Implemented best practices IT Governance and transparency in maintaining different environments of Dev, Test and Prod, code migration strategies and approval procedures, documentation and manuals and follow SDLC.
• Implemented and maintained the Cyber Security Policies and procedures, Disaster Recovery Methods.
• Worked with different Audit Teams and successfully completed IT Audit, Internal Audit, Sox Compliance, Security Compliance etc,.
• Attended seminars and forums to have the latest trends and innovations in the industry and IT, encouraged the same to the IT Team Leads.
• Organized Training Programs and Refresher Courses for the Business Operations users and IT teams to improve their efficiencies and operating methods and to understand the systems better and to learn cross functional processes.
• Managed the teams of off shore and on shore model, Hosting, Support, Network, Systems, DBA, Development, Analysts with 9 direct reports.

TECHNICAL SKILLS:

RDBMS: ORACLE 7.X-11G and Cloud.

Tools: & GUI: BI PUBLISHER, VISIO, MS OFFICE TOOLS. REPORTS 2.5 - 6i), DISCOVERER, FSG, SQL*PLUS,PL/SQL, SQL*LOADER, ADI, TOAD, EDI, OFA, HUMMING BIRD, KINTANA, MKS, MS PROJECTS, HYPERIAN, EIS REPORTS, DISCOVERER, ARTIMIS, TRACK WISE, DEMAND MANAGEMENT, CRM HELP DESK

Packages: ORACLE FINANCIALS 10.7 through R12, Fusion and Cloud

Platforms: HP/UNIX, SUN SOLARIS, WINDOWS 3.11,WIDOWS NT

WORK EXPERIENCE:

Oracle Consultant

Confidential

Responsibilities:

• Configured and implemented the Fusion Oracle Finance modules of GL, AP, I-Exp, PO, AR, Revenue Management, OM and FA in Cloud environment and extensively worked on Order and Procurement streams.
• Captained third-party integrations—e.g., EDI, Eximware, Eminent, Banks, SMC3, e-commerce sites — with an Oracle footprint including Financials, Supply Chain, Transportation, Trade Management and Manufacturing modules.
• Seamless Integration for a smooth transaction flow amongst OM, INV, AR, TM, OTM, LCM, OPM, PO, AP, i-Exp, i-Supplier, EDI, GL, CREDIT, REVENUE, COLLECTIONS.
• Designed and configured FAH, Transactional Adhoc OTBI and Periodical BI Reports and Dash Boards in OBIEE with drill down and visibility in the cloud/Fusion environment with Hyperion Consolidations and Essbase.
• Provided key support to Confidential consultants during the IT Audit by Confidential and participated in the Oracle License Audit.
• Spearheaded successful Hosting Migration Project, delivering $50K in monthly cost-saving by merging servers to a common provider, which simultaneously increased operational transparence and accountability.
• Helped the CFO to reduce the Period Close time, by improving the Period Close processes.
• Worked closely with the Accounting and Finance teams and configured the Accounting processes from the third party systems using the FAH and SLA to meet the Accounting, reporting, GAAP, JSOX and Audit requirements.
• Developed and used ADI templates and APIs to load the journals and assets into GL and Oracle Asset Corp and Tax Books.
• Configured and set up new Bank Accounts, Payment Process Documents, Approval Process, Payment Files to make multinational and third party payments, securing the money laundering practices and various country specific requirements.
• Configured approval workflows for Purchase Orders, Payables Invoices and GL Journals.
• Designed and implemented Supplier update report and Alert system with Audit trial for any updates made on the Supplier records. Maintained User Access controls and Data Security through Sys Admin.
• Maintained User Access controls and Data Security through IDM and IAM.
• Plan and implement Disaster Recovery plan and site.
• Performed SOX and JSOX Compliance Audits.
• Configured integration process between Oracle Transportation Management, OM, AP and PO. Configured iSupplier module to track and monitor supplier and shipment documentation and integrate with US Customs and Broker.
• Designed Auto Receipt creation process in PO and Inventory through EDI directly from multiple warehouses.
• In OPM, added multiple costing buckets to include the carrying and fixed costs. Each lot selling decision(price) is determined every day based on lot cost of specific lot on that day. Had heavy customization to meet business needs. Rewrite the lot costs process. Certain costs are only for OPM subledger and costing reports purpose, but not go to GL for OPM is very well integrated with LCM, PO, PO receipt, Inv, OM etc,. Helped the CFO team and business users during period close processes, to fix the lot cost issues and in developing the required reports. Worked directly with OPM/LCM development teams of Confidential to fix some of the issues. Worked closely with business teams for the process re-engineering and change management.
• Managed 9 direct reportees of IT teams of BA, Development, QA, DBA, EDI, Network and Systems, provided guidance, conducted performance reviews, RFQs, Vendor Agreements.

Finance Lead

Confidential

Responsibilities:

• Provided Application Architecture, run the Solution designs workshops and CRPs, worked closely with Business Leads, got the requirements, discussed and resolved the issues, got the signoffs and BR100s.
• Lead the onsite Functional Team. Provided the guidance and monitor the day to day work of all Functional Consultants. Personally took the module ownership of AP, EB TAX, Oracle Payments and AGIS.
• Configured Sales and Use Taxes, VAT and Backup Withholding Taxes for various Counties, Tax Reports, Withholding Tax Certificates and Tax Payments.
• Designed and configured AP, EB TAX, I Expenses, Oracle Payments and AGIS for about 90+ OUs. Prepared BR100s, All these modules new design is with two Business Groups and segregated OUs, which were running hitherto in one Business Group and combined OUs for Finance and Publications business segments. For new Business Group new OUs were created.
• Reporting to Program Manager, PMO meetings. Prepared the Project Plans, Cutover Plans with mile stones and critical tasks. Maintained the Issue Logs.
• Updated the Functional Design documents (MD50s) for inbound/outbound interfaces, Reports and Custom Components and worked closely with offshore development team to make these components work in the new structure of two BGs and segregated OUs.
• Performed the Conversions and Data Fixes of Master and Transactional data from current BG/OUs to the new BG/OUs.
• Organized the meetings with the QA team, Development team, DBA team and Business Leads and performed the Defect management.

Business Analyst

Confidential

Responsibilities:

• Prepared global structures for COA, inventory orgs, Operating Units, Legal Entities and Ledgers, consolidation hierarchies. Prepared the COA values, mapped the legacy values with Oracle values along with business.
• Done the conversion mappings from legacy to oracle for all the financial modules.
• Represented business users of Finance, Payables, Receivables, Fixed Assets and Cash Management of Corporate, UK, Germany, Italy, Argentina and Uruguay and transformed the requirements to Oracle Implementation team ( Confidential ) .
• Helped the business users in CRP1&2 in testing all the business scenarios.
• Logged the issues in TrackIT, assigned to the respective implementation team members and monitored the same until close.
• Prepared and monitored Finance functional tracker to monitor various functional events and setups, inputs and requirements.
• Collected various inputs required for implementation from different users and provided the same to the oracle implementation team on time.
• Reviewed the implementation documents and specs of CV040, CV060, MD050, MD070, TE040 etc. Helped the business users to write the test scripts and execute the same to cover all their business scenarios.
• Helped the Topps Management in monitoring and reviewing the Project Plan, delays, legacy data collection, weekly project progress reports and preparation of reports to the project executive committee.
• Organized the WEBEX meetings and conference calls for the remote users to participate in the meetings, CRPs and Testing.
• Worked with DBA team in the back up plans, instance planning and patch applications.

Solution Architect / Integration and Business Process Lead

Confidential

Responsibilities:

• Conducted detailed discussions with Business and Tech Leads. Analyzed current business processes and prepared the current and to be combined business process flows, system diagrams and data flows.
• Prepared, global list of legacy systems which can be sunset and advised changes required in business processes, automation of processes eliminating or minimizing the manual processes. Prepared the road map to improve the period closing processes, accounting and financial reporting.
• Gathered the high-level requirements and done fit gap analysis.
• Prepared the global design and architecture with country specific localizations and tax structures of Oracle Financials with suggestions on the required modules and the legacy systems, based on the cost benefit analysis.
• Prepared RFPs, helped in negotiations on RFP responses.
• Prepared the project plan with deliverables, time lines and milestones, resource plan. Presented the budget and obtained approvals from steering committee.

R12 Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Analyzed and prepared the current and to be business process flows from discussions with business leads. Provided global design and road map.
• Prepared the project plan with deliverables, time lines and milestones, resource plan. Presented the budget and obtained approvals from steering committee.
• To the up and running Oracle Financials for US, added new Legal Entities and Operating Units.
• Configured and done the setups, for General Ledgers, Accounts Receivables, E Business Tax for UK and Canada and Inter European Country Taxes. Until now Canada is being accounted through US.
• Developed the custom Consolidated Billing feature, with Accrual billing and the ability to customer to enter actual and run auto adjustments on Revenue and Final Billing based on Actuals entered. This customization includes custom Forms and custom Accounting.
• Done the requirement gathering, fit gap analysis, mapping, documentation, CRPs, obtained approvals, tested and implemented successfully.

Oracle Financials Functional Lead Consultant

Confidential

Responsibilities:

• Inter Company Payments Custom Module - Gathered Requirements, Designed, Obtained Approvals, Tested and Implemented. The custom module involves development of new forms, to capture the data for the payments, approvals, Netting Center by Company and Currency and forward the data to Treasury. The whole process involves AP, AR, CM, GL, PA and the Custom Module with Multi Currency and Multi Ledgers and Multi Legal Entities.
• The main features are Auto Generation of Inter Company Deals, Forex Deals and Exposure Deals for the Approved Payments, Auto Authorizations, Auto instructions to banks, Auto Loading of Forex Rates, LIBOR. Auto Accounting is done for Intercompany Expenses, Revenue, Payments and Settlements, Taxes and required Journal Entries are created and Invoices auto generated. Providing Monitoring, Controlling Reports for different levels of Users are part of Project.
• Global Production Support - Provided Production Support handling Siebel tickets on all the Oracle E-Business Suite modules of Procure to Pay and Order to Cash and Oracle Self Service Web Applications. Working with Oracle Support on SRs with escalations whenever required, Users, Developers on site and Off Shore, DBA team, Objects Migration Team are part of my Production Support responsibilities. Resolved the issues including Multi Country, Multi Currency, Multi Tax Structures.

Oracle Financials Functional Lead Consultant

Confidential

Responsibilities:

• Conducted Business meetings to gather the requirements, approvals and finalized/performed Setup Steps, BR100s required for the implementation of Project Accounting and Fixed Assets for US, UK, Poland and Germany. Provided production Support to trouble shoot the production issues.
• Defined and Setup PA Periods, Expenditure/Revenue Categories, Expenditure Types, Burdens, Budgets, Project Types, Auto Accounting, Roles, Subledger Accounting, Project Templates. Integrated Project Accounting with Order Management, Inventory with Intercompany features for auto accounting and billing. Configured Contract Funding and Agreements.
• Through PA Interface converted the Project details from Legacy to Oracle Projects. Provided Functional Spec documents, obtained required approvals, worked with Development Team for development of Conversion Program, tested and successfully got the Projects Data into PA from Legacy. Using the APIs modified the Task details and created Projects.
• Designed and configured Labor Charges from HR to AP and finally to Project Accounting to have the correct accounting of Project Costs.
• Provided Functional Spec documents for the Assets Conversion, Project data Conversion, Inbound and Outbound Interfaces to Legacy System for Financial Planning.
• Setup Corp Book and Eight Tax Books, FA Calendar, Subledger Accounting, Profile Options, Category Flexfield, Location Flexfield and using the Asset Migration Program, created more than Two Million Assets into all the Books. Used multiple ADI templates to load Assets details.
• Implemented Assets creation custom process with custom Auto Accounting in Fixed Assets from Project Accounting and Accounts Payable.
• Defined /updated Depreciation Methods, Prorate Conventions, values in different Tax Books through Tax Interface, to meet the Latest Tax Laws of multiple Countries and States, worked closely with Federal/State and Property Tax Departments, to have huge Tax Savings.
• Designed and implemented EIS Reports for Financial Modules.
• Implemented More 4 Apps for PO & FA
• Setup the iReceivables with Customer Self-Registration feature. Designed and implemented the Customer’s Account Summary Home Page feature in addition to the Account Detail. Configured Online Aging, Interactive Invoices
• Implemented Payment by Credit Card/Bank Account Transfer, Bill Dispute and Credit Memo Request.
• Implemented Custom Auto Accounting to create the Expenditure Accounts, FA Locations, Custom Mass Additions to recalculate the Asset Life, Additional Mass Additions queues,
• Worked with DBA and Tech team to apply patches, Development and Testing the Processes and Programs, get the required instances etc.
• Performed End User Training and User Acceptance Testing, Test Scripts (TE 040) and Integration Testing.
• Responsible for conducting CRPs to test complete process flow in Oracle Financial modules. Demonstrated of key businesses and Accounting processes relating to Requisition, Purchase Order, Invoice, Transfer to Project Accounting, Fixed Assets and General Ledger.
• Flow/Functional Testing for Modules (AP, INV, OM, PO) to make sure “flow “ is working without any issues.
• Worked with Oracle Support for SR management, Patch Applications, Bug fixes, Data Fixes etc.
• Worked with Director of Oracle Support, Service Delivery Manager and Development Manager on critical issues like Failure of processes of Interface Supplier Costs, failure of PA WEB ADI, unable to close PA periods, wrong calculations of depreciations for new bonus depreciation methods, High volume reports failures, customize Depreciation projections reports, failure of Depreciation runs, failure of mass Transfers, Corruption of data on Retirements and Reinstatements.
• Implemented Mapping Tables and Forms to map the Oracle Segment Values with Legacy Account values and Assets Numbers.
• Configured Vertex to AP and AR to have the correct Tax calculations on Payables and Receivables Invoices.
• Using the Location Flexfield values, configured Parent Child hierarchies in GL to get the FSG Reports based on Locations.
• Designed and worked with Development Team to develop Discoverer Reports and Oracle Custom Reports and FSG Reports.
• Used MKS for Production Support Issue Management, Migration Process and maintained and ensured Version Controls/PVCS and SOX Compliance.
• Worked closely with Corporate Finance in Budget Planning and Financial Analysis in the areas of Hyperion and Outlooksoft.
• Provided Production Support in PO, AP, CE, FA, PA, AR and GL, interacting with the Business Users, Corporate Accounting, Tax Department, Development Team and DBA Team.
• Configured DFFs in Fixed Assets, Project Accounting and General Ledger and Quick Codes to map to Legacy Systems, define Reports, extend the Leasehold Life etc.
• Worked on resolving Month end and Quarter end closing issues.