SUMMARY

• With 18 years of overall experience, and 13 years of experience in Oracle Consulting within Financial and Investment, Service, Telecom and Telecommunications, Real estate and Construction, Hospitality, Education Sectors, Pharmaceutical and Bio - tech & Medical Equipment sectors.
• Over 10 plus years of full life cycle Global Implementation, Upgrade, Roll out and Customization experience using Oracle AIM methodology. Project Initiation, Scope and Design, Business Process study, GAP analysis, Solution Design and Development, Module configuration, Customization, CRP Testing and Client Training and Go-live support.
• A Chartered Accountant (equivalent to CPA) and a Cost Accountant (equivalent to CMA), Company Secretary (Final) with a meritorious track record.
• An effective Oracle Functional Financial Lead with good communication, interpersonal skills.
• Good experience interacting with Corporate and Tax Comptroller
• Worked as an Accounts Officer (for the Comptroller) for various internal projects.
• Well-organized, inquisitive problem solver who enjoys challenges. Good client facing and interacting skills, experience with on-site and Off-shore Development teams.
• Proficiency in Microsoft Project and other project management tools, Proven ability to manage scope and budget, Ability to meet tight implementation schedules, Strong technical, analytical, troubleshooting and problem solving abilities, Ability to establish effective working relationships and contribute in a team environment Trained on different modules
• Experience in managing application package acquisition, integration and implementation as well as new development. Experience with AIM Methodology, Business Process Engineering and Project Management tools and/or similar ERP implementation methodologies.
• Oracle Cloud Fusion Versions Latest Release 12 and 13 and EBS 12.1.3, 12.0.1, 11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.3
• Experience in all phases of Systems Development Life Cycle - Business process analysis; Design, mapping, Process/Software Gap Analysis, Development and Implementation, Testing Production and Go-live support.
• Extensive Functional and Technical Experience on various Oracle Financials as a Functional and Techno-functional Consultant, covering Oracle Financials, Oracle Manufacturing and Oracle Project Accounting and CRM Modules., Modules:- Financials: General Ledger(GL), Accounts Payables(AP), Fixed Assets(FA), Cash Management, Accounts Receivables (AR), E-Business Tax i.e. {Procure-to-Pay cycle(P2P), Order-to-Cash Cycle(O2C)},Grants, Oracle Project suite(PA).-Project Costing, Project Billing, Project Contracts and Project Management, Daily Business Intelligence (DBI), i-expenses, i-payables, i-Assets, i-procurement, i-receivables, Manufacturing: Purchasing (PUR) and Inventory(INV), Order Management(OM), System Administration .
• Well-versed with AIM Methodology.
• Good Knowledge on Oracle Discoverer, SQL, and Reporting Tools.
• Ability to work with different IT solution to find out suitable products that suits business needs.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills.
• 18 years of Experience in Oracle EBS R12 & Fusion Applications (R11 & R12) Implementation & Support Projects and working as Oracle Fusion Financial Functional Consultant.

TECHNICAL SKILLS

Primary Skills: Fusion R11, R12 & EBS R12 - Oracle General Ledger, Accounts Payables, Accounts Receivables, Cash Management, and Fixed Assets, Project Portfolio Management

Secondary Skills on SCM: Inventory, Purchasing, and Order Management

PROFESSIONAL EXPERIENCE

Confidential, Texas

Oracle Fusion Functional Consultant

Responsibilities:

• Configuring the missing Setups for Oracle Fusion Fixed Assets, creating Corporate Books and Tax Books for TPC US COA, TPC CA COA,TPC MX COA. ( for US, Canada and Mexico Primary Ledgers)
• Identifying the Reports and Interfaces to be developed or obsolete, General Ledger, Accounts Payable, Accounts Receivable, Cash Management and Fixed Assets Reports- GL Net Margin Report (based on Project, Task, Location etc), both customized and Standard Reports and Concurrent Programs.
• Worked on the Source Systems - TMS(Transportation Management Software), TMS-F, Mcleod, Comdata, Utltipro, Concur, Integra system (expense Transactions are interfaced) to document the process flow.
• Worked on Elimination entries for intra-company transactions where original entry is reversed with an Elimination project code in AP and AR . For inter -company transactions
• Documenting pay-when paid process flow to pay to the Carriers only when we receive from the customers.
• Setups made in the development instance for Inter-company Transactions to knock off Receiver and Provider Organization )- Inter-company Receivables and Inter-company Payables Account
• Helped in Decision-making to design interface for Truimph pay Payments(third party system used to pay Payments) to extend it to Canada and Mexico which is currently used for US

Confidential, Plano, Texas

Oracle Cloud Fusion PPM Consultant

Responsibilities:

• Strong Oracle Cloud Fusion Functional resource with expertise in Oracle Projects PPM
• Study of Inter-company process, Month-end Closing process,
• Undergoing Training on Oracle Financials and have experience working on EBS with Project Accounting module.
• Can provide best practices for deployments and data integration techniques.
• Prior experience transitioning legacy systems to new systems
• Ability to manage Oracle service requests.
• Experience on FSM, BPM, IDM, FBDI, FRS along with Fusion Projects
• Expertise in Designing Enterprise Structure/Multi-Org Structure based on client business
• Involved in requirement gathering and solution design, CRP, UAT, Training, Post Production support, documents preparation, and client interactions
• Prepared AIM Documents i.e BP040, RD050, MD050, TE040, BR100 and User Manuals
• Prepared OUM Documents i.e RD030, RD011, AN100, TE050, TE020, DO070 etc.
• Successfully managed end-to-end implementations and Support Projects
• Hands-on experience in planning & directing operation and selecting / training the technical staff; keen analyst with exceptional communication, negotiation and relationship management skills.
• Involved in System Configuration and prepared documents by following OUM Methodology
• Working on Fusion Financial Applications to support day to day application user issues
• Completing setups for new Business Units as rollout activity
• Working with FR Studio Reporting, Smart View, Account Inspector and Account Monitor, OTBI Reporting
• Setting up roles to user as per their responsibilities in OIM (Oracle Identity Manager)
• Preparation of Custom Job Roles for Employee to provide access to relevant tasks.
• Effectively worked with Oracle support team to resolve product related issues and bugs.
• Configuration and modification of Approval processes in Business Process Management.
• Coordinating with other team members for quick issue resolutions
• Conducting KT Session for team members.
• Understanding about client business process.
• Mapping with Oracle Fusion application standard functionality.
• Conducted prototype sessions (CRP) to business to get requirement sign-off.
• Handled UAT Sessions and prepared documents i.e RD030, RD011, AN100, TE050, TE020, DO070 etc.
• System configuration for all financial application in the environment of Application setup manager (FSM).
• Defining Approval Rules through BPM.
• Setting up Job role, duty role, and data roles as per business requirement.
• Completed testing for all financial applications (Unit & Integrated).
• Creating user and giving role provisioning in Security Console.
• Worked on FR Studio and Smart view.
• Enabling Business Unit functions.
• Loading Master and transactional data using FBDI Templates.
• Setting up Common Options for Payables and Procurement.
• Business process analysis includes understanding the existing business processes and designing the future processes with the standard Oracle functionality.
• Involved in designing the system with configuration setup for the above modules.
• Conducting thorough module testing in addition to cycle testing from Order to Cash and Purchase to pay with other functional consultants.
• Prepared documents with AIM approach BP040, RD050, MD050, TE040, BR100 and User Manuals.
• Gap analysis and Gap Documents were made, which includes various Pain Points and Wish lists for us from the existing legacy system.
• Involved in the CRP testing of module functionality. Iron out any issues/roadblocks come across during testing and CRP with customization or work around for successful implementation of projects.
• Involved in Multi-Org Configuration and setting up Financial Options, payable Options, and System Options.
• Working on issues related to Auto Invoice, Auto Accounting, and Receipts.
• Data Migration to Production instance, Completed the Required Setups for Financials.
• Prepared conversion documents as per the Migration strategy plan.
• Production Support for Financial Applications.
• Implementing the Oracle Financials AR, AP, FA, CM & GL.
• Managing CRP and UAT with business.
• Integrating with Order Management, Inventory and Purchasing modules.
• Data Conversion, Configuration and Customization.
• Preparing MD050 documents for customization.
• Facilitating the data migration from legacy system to Oracle Apps.
• Prepared RD050, BP080, BR100 Documents as per AIM Methodology.
• Prepared the documentation based on the AIM methodology for the Project Configuration.
• Set up configuration for GL, AR, AP & CM modules as per the BR100 documentation.
• Assisted in developing and testing software applications.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Testing modules’ setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (UAT).
• Data Migration from Legacy systems and Open Interfaces.

Confidential, New York

Oracle Financials

Environment: Oracle Apps Release12, TOAD, SQL.

Responsibilities:

• Good experience in Functional Requirement analysis, Solution Design, Gap Analysis, Technical Design, UAT, Configuring Applications, Data Analysis, Conversion Strategy, Data Migration, Go-live Support, Production Support, Training Business Users, Testing and Documentation.
• Defining and re-arranging Project Types as per client requirements and loading them to R12 - Indirect, Capital and Contract Project
• Defining auto accounting rules to reflect costs associated with the respective operating units associated with capital projects
• Modifying Auto Accounting rules based on change in the accounting specified by the users
• Re-designing and simplifying Project Templates based on the project types using activity codes
• Updating new global hierarchy based Country-Department & Location combination across 104 operating units
• Uploading Table A(operating Unit specific) and Table B labor billing rates in the respective Operating Units and designing interface to modify Table A and Table B rates accordingly
• Designing interface for calculation of AR interest to be accrued to the Project where customers pay beyond 30 days.
• Working on Oracle Project Interface in accordance with Oracle Employee Interface and Oracle Customer Interface from existing ORS system
• Designing interface to reflect Inter-company and cross charge transactions for the time sheets entered by Confidential consultants
• Re-defining Events and Expenditures and UOM based on the current requirements, interfaces and extensions.
• Re-designing and Setup of Expenditure and Event DFF’s to populate based on extension derived values
• Designing Labor Cost and Billing Extension for 60 countries and more than 100 Operating Units.
• Migrating Oracle Project Accounting setups in R12 and related to DFF .
• Global roll-out across Japan, US, UK, China operating Units
• Configuration and Setups done in Development, Release, Test & Production Instances as part of post-upgrade steps.
• Working with business users to identify functional specifications & gathering requirements .
• Ensuring posting of entries from reconciliation of accounts from all sub-ledgers.
• Understanding and identifying both business and technical requirements from business users and setup accordingly.
• Serving as trusted advisor and subject matter expert to the business regarding how the system can be used to support desired business processes and requirements .
• Performing Gap analysis to determine if the requirements are met by the existing application or will require enhancements or customization.
• Provide regular metrics on open, resolved and closed issues.
• Perform the detailed functional design of the application enhancements.
• Uploading Discount and Discount rates through data loader based on the type of discount given to the clients .
• Assist in the development and delivery of end user training.
• Define new business requirement and assist with gap analysis.
• Prepare detailed functional specifications for conversion of project information operating unit wise data extractors on project header and inception to date data conversion and reconciliation. Initiate and follow through on Oracle Service Requests.
• Re-designing month-end close process for the client and implementing the same.
• Complete application set-ups to support Conference Room Pilots .
• Facilitate business-owner reviews and obtain sign-off on functional designs.
• Work with other team members to ensure that the configuration and custom components meet application requirements and performance goals.
• Prepare Test scripts and Test cases and ensure that the application is working.
• Create documentation and provide end-user training and material .
• Serving as a trusted advisor and subject matter expert to the business regarding how the system can be used to support desired business processes and requirements .
• Automated business user functions and processes where applicable, viz., creating request set and scheduling the programs by the end of the week/day as the case may be .
• Addressing post-production issues and fix them accordingly and maintain issue log to track issues .
• Identifying alternatives to close gaps, making recommendations that best suit the business need and the long-term application strategy and translate these alternatives into an explicit list of required enhancements (process, RICE (reports, interfaces, conversions, extensions, workflow).
• Perform setups and execute testing scenarios in test environments to verify new functionality, patches, custom development, new implementations, and integration with external systems

Confidential, New Jersey

Oracle Functional

Environment: Oracle Apps Release12, TOAD, SQL.

Responsibilities:

• Good experience in Functional Requirement analysis, Solution Design, Gap Analysis, Technical Design, UAT, Configuring Applications, Data Analysis, Conversion Strategy, Data Migration, Go-live Support, Production Support, Training Business Users, Testing and Documentation.
• Upgrade of Financial and Project Accounting modules in Release 12.1.3
• Coordinating with Banks for approval of checks printed in R12 system
• Configuration and Setups done in Development, Release, Test & Production Instances as part of post-upgrade steps
• Setup the EDI payments in the new system in Accounts Payables
• Working with business users to identify functional specifications & gathering requirements
• Developing Discoverer Reports in the instance based on the user Requirements
• Consolidation of books of accounts on behalf of users
• Ensuring posting of entries from reconciliation of accounts from all sub-ledgers
• Identifying on-going training requirements and develops training plans and material to ensure that all system users are trained appropriately.
• Converting 3 months Trial Balance Data into Oracle through WEB ADI
• Done the requirement gathering, documentation, obtained approves, tested and implemented successfully.
• Understanding and identifying both business and technical requirements from business users and setup accordingly
• Serving as trusted advisor and subject matter expert to the business regarding how the system can be used to support desired business processes and requirements
• Performing Gap analysis to determine if the requirements are met by the existing application or will require enhancements or customization
• Provide regular metrics on open, resolved and closed issues
• Perform the detailed functional design of the application enhancements.
• Upgrading VEHICLE VIN NUMBERS tracked as a project, including revenue, cost, and margin reporting and analysis by vehicles
• Contract review for booking, revenue, pricing, billing, and payment terms
• Setups of all TCA parties was carefully considered for all transactions, including tax transactions and reports
• Research the proper accounting treatment for revenue and other transactions and develop / maintain accounting policies in conformity with US GAAP.
• Migrating Oracle Project Accounting setups in R12 and related to DFF
• Global roll-out across Japan, US, UK, China operating Units
• Define new business requirements and assist with gap analysis.
• Strong understanding of Project Controls
• Prepare detailed functional specifications for conversion of project information operating unit wise data extractors on project header and inception to date data conversion and reconciliation.
• Initiate and follow through on Oracle Service Requests.
• Complete application set-ups to support Conference Room Pilots
• Tracking performance appraisals of the Analysts and reporting them on monthly basis
• Preparing Weekly and monthly status reports regarding the work allocated.
• Defining Check templates for various banks and configuring the printing process.
• Revenue accounting (revenue recognition, maintaining deferred revenue and related reconciliations).
• Liaison with technical support team and DBA’s on the project.
• Facilitate business-owner reviews and obtain sign-off on functional designs.
• Work with other team members to ensure that the configuration and custom components meet application requirements and performance goals.
• Prepare Test scripts and Test cases and ensure that the application is working.
• Create documentation and provide end-user training and material.
• Addressing post-production issues and fix them accordingly and maintain issue log to track issues .
• Document the application to facilitate on-going support and future release development.
• Identifying alternatives to close gaps, making recommendations that best suit the business need and the long-term application strategy and translate these alternatives into an explicit list of required enhancements (process, RICE (reports, interfaces, conversions, extensions, workflow).
• Perform setups and execute testing scenarios in test environments to verify new functionality, patches, custom development, new implementations, and integration with external system

Confidential - Parsippany, NJ

Environment: Oracle Apps Release 11.5.10.2 TOAD, SQL.

Responsibilities:

• Project Lead managing a team of 12-16 onsite and off shore staff members.
• Configuring Project Accounting module in 11.5.10.2 Mapping the business requirements collected to the application.
• Perform gap analysis to determine if the requirements are met by the existing application or will require enhancements or customization
• Design the system based on the functional specifications.
• Setup and implementation of Project Accounting (PA)
• Facilitate business-owner reviews and obtain sign-off on functional designs
• Performing conference room pilot (CRP) testing and related documentation/deliverables
• Preparing training materials and conduct training sessions to train Business users on the functionality of the modules and any customizations developed.
• Addressing the queries of the business users from time to time
• Addressing post-production issues and fix them accordingly
• Initiating and incorporating enhancements and incorporating the relevant enhancements in the documents as a part of change control procedures
• Perform the detailed functional design of the application enhancements. Document the application to facilitate on-going support and future release development.
• Preparing status reports for upper management regarding status of each project
• Perform module set-up and configuration activities and following good design practices to ensure application quality
• Supporting the development team as it configures, builds, and tests the application enhancements
• Plan, prepare, and execute quality assurance and user acceptance testing. Engage business users during UAT and facilitate sign-off on test results.
• Provide regular metrics on open, resolved and closed issues
• Conduct and participate in issue management meeting on a regular basis
• Maintained historical records of problems solved to build a knowledge base for future issues.
• Automated business user functions and processes where applicable.
• Heading Functional and Technical Consultants including DBA’s

Confidential - New York City, NY

Senior Functional Consultant

E nvironment: Oracle Apps Release 12, Sun Solaris, Oracle 10g, TOAD, SQL

Responsibilities:

• Implement enhancements, upgrades, operation support, testing, and assisting with the governance and projects related to Oracle e-Business suite.
• Leading a team of 17 including Functional Consultants, DBAs and Technical consultants
• Customize Oracle applications to achieve high business value through standard functionality.
• Identify and prioritize opportunities to improve business processes.
• Convert from the existing excel based system to Oracle Applications.
• Analyze comprehensive business processes, complex problems, interprets operational needs, perform in-depth work analyses, and develop computer-generated flow charts.
• Facilitate business-owner reviews and obtain sign-off on functional designs.
• Perform conference room pilot (CRP) testing and related documentation/deliverables.
• Create test plans, test cases, test scripts and performs functional testing.
• Design the system based on the functional specifications.
• Perform gap analysis to determine if the requirements are met by the existing application or will require enhancements or customization
• Check unit test plans, technical documents and other quality reviews
• Prepare status reports for upper management regarding status of each project.
• Conduct and participate in issue management meetings on a regular basis.
• Work with Oracle users to develop procedures for regular system processing and report generation; includes determining which processes need to be run and developing a schedule for ongoing processing.
• Identify alternatives to close gaps and make recommendations that best suit the business needs and the long-term application strategy. Translate these alternatives into an explicit list of requirements.
• Executing and monitoring the project to determine the progress of the project and re-scheduling the project if there is lapse.
• Converting data from the legacy system to Oracle
• Interfaced Journal Data using Web ADI and used Oracle Discoverer to extract Reports.
• End user training to Corporate and Tax Department and General Affairs.
• Modifying FSG Reports and developing new reports based on the customer requirement.
• Co-ordinate with technical and DBA team for resolving the issues using issue log and matrix and documenting them.