SUMMARY

• Financials System Consultant/ Business Analyst with total experience of more

than 15 years in Financial and HR Systems, Oracle Applications E-Business Suite Release 11i, R12, Oracle Fusion Cloud Financials, Accounting, Taxation and SOX compliance.

• Oracle Application Implementations, Rollouts, Upgrade and Support Projects

• Comprehensive experience in analysis, and design, testing implementation of business systems involving Oracle Applications 11i./R12 / Fusion Cloud Modules: General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management(CE), Project Costing, Billing, HCM.

• Exposure in PO, INV, OM, Project Accounting, Oracle Time and Labour (OTL), i-Exp, i-Proc and System Administrator

• Also Expert in Oracle Fusion Financials Cloud- Functional Setup Manager

(FSM), Enterprise Structure Definition, Hierarchy and Functionalities

• Rich Exp in Record to Report, Procure to Pay and Order to Cash Cycles

.

• Experience and knowledge in SQL, PL/SQL, Toad, SQL Developer, FSG, Web ADI, Desktop ADI and other Reporting Tools.

• Knowledge on FRS (Financial Reporting Studio), FBDI tools in Oracle Fusion Financials.

• Expert knowledge of differences between Oracle Fusion and Oracle EBS R12 as relates to functions, features, configuration, transactions and reporting. PERSONAL SKILLS

• Always open for new challenges and enriching my knowledgebase.

• Strong communication skills and ability to build strong working relationships with business users and peer group.

• Ability to learn and adapt quickly to a dynamic environment.

• Ability to multi-task and efficiently prioritize tasks assigned.

• Expert in Design, Documentation, Business Process Flows and Designing the system.

• Preparing User Manuals and SOP and training the trainers. Vikram Khandelwal

https://www.linkedin.com/in/vikramkhandelwal

adcjvo@r.postjobfree.com

Cell: 310-***-****

Orlando, FL

Employer: Wyndham

Destinations

Job- Financial System

Lead

ROLES

§ Functional Analyst

§ Project Manager

§ Team Member

EDUCATION

§ Masters in Business

Administration

§ Masters in Commerce

§ Certified Accounting

Technician from ICAI

CONTINUING EDUCATION

§ Oracle Applications (EBS

R12)

§ Oracle Fusion Financials

(Cloud)

§ Oracle EBS 11i

INDUSTRY APPLICATION

§ Public Sector

§ Manufacturing

§ Financial

§ Telecom

§ Transport

§ Retail

LEADERSHIP/ACCOLADES

§ Mentoring in technology

and software best practices

§ Handled Team sizes up to

12

§ Managed 4

implementations end to end

(including R12

implementations)

§ Done 11i to R12 Upgrade

Projects

PROFESSIONAL JOURNEY: (IN REVERSE CHRONOLOGICAL ORDER) EMPLOYER NAME WYNDHAM DESTINATIONS, FLORIDA

DURATION

WORK AREA

MAY-2018– TILL DATE

GLOBAL FINANCIALS IMPLEMENTATION AND SUPPORT

ROLE ORACLE FUNCTIONAL LEAD

Wyndham Destinations is the world’s largest vacation ownership and exchange company. It includes very well known brands in the hospitality industry like RCI, Wyndham Vacation Ownership, Worldmark, Margaritaville, Shell Vacation Club, Club Wyndham, Dial and Exchange, Love Home Swap etc having presence across the globe in 110 countries. Wyndham Destinations uses Oracle EBS, Peoplesoft, Workday, Kyriba, Concur and other niche applications as part of Global Financial Systems. Responsibilities:

• Manage and Lead the Financial System -Oracle EBS and other related systems and integrations

• Lead the functional design and setup of all the Financial and Procurement related modules – GL, AP, AR< FA, CM, EBTax, SLA, PO, Inventory, iProcurement etc.

• Integration of Oracle AP\ Cash Management treasury functions with Kyriba.

• Manage Implementation and Production Support of Global Financial Applications.

• Manage Contract resources, assign and align the work with regular status updates to keep the projects and support on track.

• Interact with different regions including North America, LATAM, EMEA and APAC for requirement and design of business processes.

• Work on reporting related requirements using OBIEE and other reporting tools.

• Lay out, manage and work on plan for Automated and Manual regression testing related to DB Upgrade, Application upgrade and patch applications.

EMPLOYER NAME DOUGLAS COUNTY, NEBRASKA

DURATION

WORK AREA

MAY-2016 – MAY-2018

ORACLE FINANCIALS IMPLEMENTATION AND SUPPORT

ROLE ORACLE FUNCTIONAL LEAD \ IT MANAGER

Douglas County manages Real Property Taxes, Vehicle Registrations, Driver License Issuance and Renewal and manages all others Grants, Funds and Investments of the county. Public Building Commission, Health Center, Clerk office, Treasurer, Assessor and different groups use the Oracle EBS.

Responsibilities:

• Manage application setup for Oracle EBS R12 Financial application used by Douglas County.

• Participate in meetings to determine business needs, develop technical specifications and design solutions based on module capabilities.

• Research and provide recommendations on applications that will solve business problems or gaps upgrades.

• Identify additional opportunities to enhance the alignment of business processes and application capabilities.

• Document solution and configure modules to perform based on documentation, ensuring thorough testing is performed prior to roll out.

• Analyze applications to ensure maximum utilization of features for all users.

• Meet with end users to develop specifications for existing and new report requests.

• Act as a liaison with internal information technology groups to support peripheral applications and infrastructure, monitoring requests to assist with a timely resolution.

• Monitor and manage the interfaces from different custom systems to EBS and also troubleshoot the issues for exceptions and errors.

• Integration of Oracle with different systems like Property Tax (IMS), VTR, Inovah (POS), Real Auction systems.

• Integration with PayIT (SaaS) for payment on mobile or online and interface to Oracle EBS using amazon web services

(AWS).

• Implemented and supporting different tools like API Wizard for AP and AR, EIS Express (reporting) for ease of use for business users.

EMPLOYER NAME HERBALIFE INTERNATIONAL, WINSTON SALEM, NORTH CAROLINA DURATION

WORK AREA

MAY-2012 – MAY-2016

ORACLE FINANCIALS IMPLEMENTATION, SUPPORT AND ENHANCEMENT ROLE SR APPLICATION ANALYST / PROJECT MANAGER

Herbalife is a leading health products company with global presence in over 90+ countries. Herbalife runs its business on Oracle ERP 11i, R12 and Oracle Fusion. Oracle Financials Specialist for all the financials modules ( GL, AP, AR, FA, CM, SL, AGIS, EBTax, iExpense Project Costing, HR etc) . Working on 11i and R12 at the same time. Responsibilities:

• Requirement Gathering

• Gap Analysis

• Functional Design Documentation

• Conducting CRP

• Test Cases and UAT

• Production Setups and Go Live Strategy

• Implemented Check, EFT, Wire Payments in XML formats.

• Worked on reporting and data analysis tools such as Web ADI, Desktop ADI and GL Wand

• Implemented WebService based solution in partnership with PNM to attract cash sales where customers can go and make cash payment at any 7-Eleven or Family Dollar Store.

• Implemented Sanctioned Payment Screening process to screen all Customers and AP Suppliers data against OFAC, EU Treasury list and apply automatic payment hold on matched records.

• Implemented Credit Card Tokenization process to comply with PCI ( Payment Card Industry) regulations.

• Managing Vertex Tax Engine O Series Integration with Oracle EBS.

• Monthly Vertex Update (Patch) analysis and testing.

• Defining Vertex Pre-rules, Overriding rules for some ad hoc tax changes.

• Running monthly and quarterly Sales Tax Extracts from Vertex.

• Customized AR Invoice using Bill Presentment Architecture (BPA) in R12

• Working closely with Development Team / Technical Team to translate the Busniess requirements in to best possible solution for the business.

• Project Management and Primavera Activities.

• Expertise in SNOW ( ServiceNow) to manage Production Incidents and Change process.

• Managing Consultant /contractors, explaining them requirement and design and follow up to ensure delivery. EMPLOYER NAME LARSEN & TOUBRO INFOTECH

DURATION

WORK AREA

JUNE 2010 – MAY 2012

ORACLE FINANCIALS IMPLEMENTATION AND SUPPORT

ROLE ORACLE EBS FINANCIALS LEAD \ PROJECT MANAGER

This engagement was for client American Axle and Manufacturing based in Detroit MI. AAM is well known name in Auto Industry as leading auto parts manufacturing co. Its main customers include GM, Chrysler, Nissan, Toyota etc.

Responsibilities:

• Supporting day to day business process, month end, quarter end and year end closing.

• Acting as Finance SMEs and approving all the CRs related to Financial Modules.

• Responsible for all the financials modules GL, AP, AR, FA, CM, iexp .

• Managing Custom modules like Labor Distribution System (LDS), DPTS (Direct Pay Tax System) etc.

• Monitoring Lockbox, Bank Statements, Hourly Payroll Files coming and loading on daily basis.

• Peoplesoft Employee Interface with Oracle Employee Data on daily basis. Fixing issues related to PeopleSoft Interface.

• System and Security Admin and

• Mentoring and managing offshore team.

• Resolving critical issue directly onsite.

• Assigning development to offshore with proper inputs and guidance.

• Preparing Business Process Documents for New processed or changes. EMPLOYER NAME CAPGEMINI CONSULTING

DURATION

WORK AREA

JAN 2010 –JUNE-2010

ORACLE EBS R12 IMPLEMENTATION

ROLE SENIOR FUNCTIONAL CONSULTANT

Implemented Oracle EBS R12 Financials for retail client Cross Roads having business in Australia and New Zealand. Responsibilities:

• Involved in As Is, To Be Process, Mapping and Gap Analysis.

• Hosting CRP for Client on Oracle Financials module and demonstrating various useful functionalities and features.

• Discussion on To be Process (BP080) and Sign Off for the same.

• Productions Setup and BR100 Document

• MD050 for Custom functional designs.

• Creating User Training manuals.

EMPLOYER NAME WIPRO

DURATION

PROJECT

JUNE 2009-DEC-2009

ORACLE EBS R12 IMPLEMENTATION

ROLE PROJECT MANAGER –ORACLE FINANCIALS

Indus Towers (Wipro’s Client) is a Joint Venture of Vodafone, Bharti-Airtel and Idea. The Company offers services to all telecom operators in the wireless space and other wireless service providers such as broadcasters and broadband service providers. Oracle Financials, HRMS and SCM modules have been implemented during Phase-I and now self servicing and business intelligence modules are being implemented for Phase-II.

Responsibilities:

• Involved in As Is, To Be Process, Mapping and Gap Analysis.

• Hosting CRP for Client on i-Procurement, Service Procurement, iSupplier/Sourcing, VMI/ Collaborative Planning, i- Expense and eAM.

• Discussion on To be Process (BP080) and Sign Off for the same.

• Conducting Weekly Review Meeting.

• Preparing Weekly Status Report.

• Managing Resources, assigning task, tracking progress and preparing Agenda to meet project plan.

• Conducting Quality Review for Important Documentation and Deliverables.

• Following up escalations.

EMPLOYER NAME MARVEL SOLUTIONS

DURATION

EMPLOYER NAME

DURATION

PROJECTS

FEB 2009 – JUN-2009

TRIUNE TECHNOLOGIES

SEP2008 – FEB 2009

ORACLE EBS R12 IMPLEMENTATIONS

ROLE SENIOR ORACLE FUNCTIONAL CONSULTANT

During this period I did 2 R12 implementation projects where implementation partners were Oracle Consulting and IBM. I was Associated as Financials Functional Consultant for the implementation of Financials Modules. I implemented GL, AP, AR, I-Expense, SLA, EBT, FA and Cash Management.

• Involved in As Is, To Be Process, Mapping and Gap Analysis.

• Designing Chart of Account (CoA) Structure, Cross Validation Rules (CVR), Security Rules, Security Profiles, and Data Access Set etc.

• Units Test Plans Preparation and Testing.

• Using Business Accelerator Tool for setting up CRP Instances.

• Preparing Business Flow docs for Order to Cash, Procure to Pay, Expense Report to Invoice, Period End Close to Financial Report, Subledger Journals to Post etc.

• Demonstration of different business flows to users.

• Preparation of Functional Spec, Documents on AIM- RD20, RD30, BP80, BR100, TE40

• Go Live and Production Support.

• Supporting Period Close for Financials Modules.

EMPLOYER NAME SIERRA ATLANTIC ( NOW HITACHI CONSULTING) DURATION

PROJECT

JUN 2007 – AUG 2008

VARIOUS R11 AND R12 PROJECTS

ROLE ONSITE FINANCIALS LEAD

During this period worked for multiple US based clients for Sierra Atlantic and did a significant upgrade from 11i to R12 ( one of the first R12 projects for a Top 10 customers for Oracle and worked with Oracle on Demand to resolve lots of bugs in new release of R12.

• Manage the production support queue for Financials Modules like GL, AP, AR, FA, CM, PO, INV, OM etc. Responsible for working with business users to understanding, troubleshooting and resolving production support tickets.

• Work with Oracle Support to resolve e-Business Suite issues with Oracle seeded functionality.

• Work with development staff in order to resolve production support tickets related to custom functionality.

• Lead or be a part of a team for small enhancement projects and ensure all development activities are carried according to Clopay’s development processes.

• Work with business users to gather requirements and complete functional and technical specifications for small enhancement projects.

• Assist technical staff with development activities.

• Assist business users preparing and executing functional test cases for small projects.

• Additional duties and responsibilities as requested by the Oracle Development Manager.

• Supporting Period Close and Year Close for Financials Modules. COLT Technology also know as City of London Telecom is one of the biggest Telecom company in Europe and owned and managed by Fidelity. It provides Data, Voice and managed services across 13 counties in Europe with a large network. Responsibilities

• Supporting All the Financials modules GL, AP, AR, FA, OM, CE, Project Accounting, Costing and Billing.

• Solving tickets coming from users and complying with the SLAs.

• Also supporting problems on Desktop ADI and Web ADI.

• I have also been involved in providing user training and cross module trainings and preparing SOPs and training manuals.

• Using ITSM (Remedy) tool to generate report on the issues and updating SRs and providing root cause analysis.

• Actively Participating in UAT/QA Process for preparing Functional Test Cases and co-operating users in executing the test plans and doing impact analysis for any patch or data fix. EMPLOYER NAME Tata Consulting Services ( On Contract) DURATION

PROJECT

MAY 2004 – DEC 2006

IMPLEMENTATION AND SUPPORT FOR FINANCIALS

ROLE ORACLE FUNCTIONAL CONSULTANT

Worked on various clients for TCS including GE business units. Involved in various kind of projects ranging from implementation and support projects.

Responsibilities: GL, AP, AR AND FA

• Defined the Set of Books and Chart of Accounts. Summarized accounting information required by product, by department.

• Design of Accounting Flexifield Structure and Set of Books

• Set up budget organizations & set up systems for entering budget amounts & journals. EMPLOYER NAME COLT TECHNOLOGY SERVICES ( A FIDELITY CO) DURATION

PROJECT

DEC 2006 – JUN 2007

IN-HOUSE SUPPORT FOR ORACLE FINANCIALS

ROLE SUPPORT ANALYST - FINANCIALS

• Set Cross Validation and Security rules.

• Defined Rollup Groups, Summary Accounts and Suspense Accounts.\

• Set up of Oracle Receivable that included - Defining System Options, Accounting Rules, Aging Buckets,

• Banks, Bank Charges, Bank transaction Codes, Dunning Letters, Transaction Types, Payment Terms, Invoicing etc.

• Implemented Payables - Payment Terms, Pay Group, Tax Set up, supplier’s Sites, Bank, Distribution set and Financial and Payable options.

• Defining Budgets and Budget Organizations

• Setting up of security rules and assigning to different responsibilities

• Defining accounting aliases to ease the account entry

• Generating financial statements using FSG

• Define Payment terms, Transaction type, Transaction Sources Receipt Class, Sales Person, Collector Etc.

• Defining Organization

• Defining System Profile Option

• Defining Customers and Customer Profile Classes

• Setup Invoice, Credit Memo, Receipt, Deposit, Guarantee, Charge back and Recurring Invoices

• Setting up Asset Key, Location and Category KFFs

• Defining Fiscal Year, Calendar and Prorate Conventions

• Defining Book Controls- Corporate, Tax and Budget

• Defining Depreciation Methods- Flat, Production, Calculated & Table

• Asset Additions- Mass, Detail and Quick Additions

• Asset Retirement, Transfer, Changes and Revaluation

• Production Support, Change Management following SOX compliance.

Contact this candidate