SUMMARY:

• Results driven, seasoned professional with a strong domain experience in finance, accounting, taxation and management reporting. Over 12+ years of experience (consulting and corporate technology) in managing, implementing and supporting enterprise applications across different industry verticals.
• 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 Law graduate.
• An effective Oracle Functional Financial Lead with good communication, interpersonal skills.
• Well-organized, inquisitive problem solver who enjoys challenges. Good client facing and interacting skills, experience with on-site and Off-shore Development teams.
• 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 Versions Latest Release 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 Distribution, Manufacturing and Oracle Project Accounting,

TECHNICAL SKILLS:

Financials: General Ledger(GL), Accounts Payables(AP), Fixed Assets(FA), Cash ManagementAccounts Receivables (AR), E-Business Tax, Procure-to-Pay cycle(P2P), Order-to-Cash Cycle(O2C)}, i-expenses, Advanced collections

Oracle Project suite(PA): Project Costing, Project Billing

Oracle Distribution: Purchasing (PUR), Inventory(INV) & Order Management(OM)

PROFESSIONAL EXPERIENCE:

Confidential, New York

Oracle Order to Cash lead

Modules: Accounts Receivable, Order management, Service Contracts, Advanced collections.

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.
• Built solution to trigger a right invoice type based on the source service contract. As the client is engaged in publishing business, the revenues mostly are driven by Advertising income. So the Invoice layout and design differ based on the type of advertising.
• Modifying Auto Accounting rules based on change in the accounting specified by the users
• 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.
• Assist in the development and delivery of end user training.
• Prepare detailed conversion strategy document operating unit wise
• Initiate and follow through on Oracle Service Requests.
• 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
• 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

Oracle Functional Lead

Modules: AR, AP, FA, CM, Advanced Collections, GL

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
• Configuration and Setups done in Development, Release, Test & Production Instances as part of post-upgrade steps
• Creating, modifying Financials Discover Reports and publish them.
• Setup the EDI payments in the new system in Accounts Payables
• Working with business users to identify functional specifications & gathering requirements
• Designing Web ADI Journal templates to upload Journal Entries
• Designing and modifying FSG reports as per user specifications
• 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.
• Designed & configured Sub ledger accounting for Fixed asset accounting, which hitherto was handled through Oracle accounting generator.
• Setup of Fixed Assets Projections in the new release
• Provide regular metrics on open, resolved and closed issues
• Analyze and test integration with 3rd Parties and legacy systems.
• Full CRP1,CRP2 testing cycles, with issue trackers and SME s sign of
• Perform the detailed functional design of the application enhancements.
• Setups of all TCA parties was carefully considered for all transactions including tax transactions and reports
• Assist in the development and delivery of end user training.
• Work Allocation to Business Analysts, Senior Business Analysts and technical Team both in onsite and at offshore. Scheduling shifts to the staff and monitoring them
• Define new business requirements and assist with gap analysis.
• Tracking performance appraisals of the Analysts and reporting them on monthly basis
• Preparing Weekly and monthly status reports regarding the work allocated
• Revenue accounting (revenue recognition, maintaining deferred revenue and related reconciliations)
• Liaison with technical support team and DBA’s on the project
• Perform setups and execute testing scenarios in test environments to verify new functionality, patches, custom development, new implementations, and integration with external systems.

Confidential, Wisconsin

Modules: GL,AR, AP, FA, CM,Project Costing and Billing

Oracle Functional Lead

Environment: Oracle Apps Release11.5.10, TOAD, SQL.

Responsibilities:

• Working with business users to identify functional specifications & gathering requirements
• Designing Web ADI Journal templates to upload Journal Entries
• Ensuring posting of entries from reconciliation of accounts from all sub-ledgers
• Leading an offshore team of 4 and guiding them to solve the issues.
• 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 and setup and implementation of financial modules
• Responsible for Design, Build and Implementation of all the Oracle financial modules and involved partly in the deployment of Oracle projects suite and HRMS modules.
• Reviewed legacy systems to understand existing landscape with a view to deploying tactical solutions.
• Led the team for strategic rollouts to other European countries.
• Designed unique Asset rental solution for the customer which fulfills the business requirement of tracking the rental asset across globe.
• Effective asset tracking solution has resulted in saving the company’s assets to the tune of 500 thousand GBP.
• Built solution to report the utilization of Rental assets on a daily basis thereby increasing the overall revenue of the organization and also identifying the Obsolete/ slow moving stock for disposal.
• Deployment responsibility of custom developments, release and configuration management.
• Creation and responsibility for all architectural solution such as Multi org across EMEA, Financial reporting.
• Maintenance of a global single instance configures to support the common processes.
• An integrated ERP solution to meet complex financial and supply chain management requirements
• Prepared documentation set consisting of process definition, Process to function analysis, Application set up, User guides, Test scripts.
• Established the vision and roadmap for the requirements gathering, analysis, and design.
• Tested and validated the foundation objects in R12 Instance and delivered.
• Lead the cross functional teams in developing the extension that included multiple modules (External system/ Projects/ Accounts receivable).

Confidential

Modules: AR, AP, CM

Oracle Senior Consultant

Environment: Oracle Apps Release 11.5.10.2 TOAD, SQL.

Responsibilities:

• Implementation of Financial modules (CM, AR and AP) in a team
• Responsible for gathering user requirements, data conversions, customizations and testing.
• Suggesting the best practices in the industry in conjunction with local requirement.
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Defined Value Sets, Descriptive Flex fields, and Custom Profile Options

Confidential

Senior Principal Consultant

Modules: AP, AR, FA, CM

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

Responsibilities:

• Setup and implementation of Financials
• Leading a team of 5 including Functional Consultants and Technical consultants
• Customize Oracle applications to achieve high business value through standard functionality.
• Identify and prioritize opportunities to improve business processes.
• 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.
• Responsible for gathering user requirements, data conversions, customizations and testing.
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Defined Value Sets, Descriptive Flex fields, and Custom Profile Options

Confidential

Oracle Applications Consultant

Modules: Accounts Receivable, Order Management

Environment: Oracle Apps 11.5.10

Responsibilities:

• Design and deployment of Warranty solution to address the unique business requirement for Confidential, Creation of a logic to calculate the warranty reserves for each legal entity as per the country specific requirements
• Handling of eOM (Enterprise Order Management) Module, which is the basic source for Oracle sales orders generation .The logic has been designed and coded to calculate warranty reserve based on the inputs provided at eOM Level. The eOM module is a purely customized module from which orders get populated to Oracle Order Management.

Confidential, Rockville

Senior Oracle Consultant

Modules: AP, AR, CE, PO, FA

Environment: Oracle Apps 11.5.9.

Responsibilities:

• Responsible for gathering user requirements, data conversions, customizations and testing.
• Suggesting the best practices in the industry in conjunction with local requirement.
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support. Identifying skills and Task allocation to Technical staff and Other functional consultants
• Implementing the project plan along with careful controls to meet the timelines
• Lead a team of six in completing the project.
• Pro-actively interacted with client to understand the business operations and gathered requirements specific to the client and configured the system accordingly.
• Carried out gap analysis to determine best fit between organizational requirements and standard application functionality and if it can be tailored to clients specific Oracle E-Business Suite solution.
• Prepared the design documents carried out module configuration, solution design in release 11.5.9 .
• Performed, pre-production business testing, conference room pilot support and related documentation/deliverables

Confidential

Senior Oracle Consultant

Modules: GL, AP, AR, CE, PO, PA, FA

Environment: Oracle Apps 11.5.9.

Responsibilities:

• Worked on support related issues for Finance and Distribution modules.
• Managed the Overall Project, Delivery and Customer Relationship with total Project revenue of 400 Thousand USD per annum
• Lead a team of ten Functional Specialists and was responsible for trying out and suggesting solutions to project tasks on a daily basis.
• Preparation of Standard operating procedures (SOP s), end-user training material for Project Costing, Billing, Project Contracts and other customized modules.
• Provided support and ensured reliance on applications.

Confidential

Oracle Consultant

Modules: GL, AP, AR, CE, PO, PA, FA

Environment: Oracle Apps 11.5.9

Responsibilities:

• Responsible for deployment of Oracle solutions in USA and Roll out to other countries across globe.
• Responsible for gathering user requirements, data conversions, customizations and testing.
• Suggesting the best practices in the industry in conjunction with local requirement.
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, gap analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Analyze comprehensive business processes, complex problems, interprets operational needs perform in-depth work analyses, and develop computer-generated flow charts and identified gaps between the Oracle software system and Standard Business Process.
• Documenting the requirements with the enhancements in GL, AP, CM and FA.
• Setup of the new features and application of the patches.
• Communicate with Oracle personnel and follow-up with the TAR's raised with Oracle.
• Communicate and co-ordinate with the technical team for application of patches.
• CRP Testing the upgraded instance for the desired functionality.
• Train the Quality team on testing procedures.
• Mentor and monitor the Quality Assistants and assess their performance on regular basis.
• Addressed operational problems, concerns, and questions raised by business users.

Confidential

Oracle Consultant

Modules: GL, AP, AR, FA, CM

Environment: Oracle Apps 11.5.8

Responsibilities:

• Utilize project methodology to plan and execute overall projects and individual project tasks
• Design development and configuration strategy for new implementations.
• Perform gap analysis between current state and desired future state.
• Develop and execute testing and training plans.
• Develop functional requirements for custom reports & programs and coordinate the testing, Implementation and training for these custom objects with the technical team, other functional team members, and the end-user community.
• Developing the test scripts to automate testing process in future for Procure- to pay (PO,AP,GL) and order-to-Cash (AR, CM, and GL) cycle and Advanced Pricing using Win Runner tool {Procure-to-Pay) (P2P), Order-to-Cash Cycle (O2C)}
• Perform regressive testing to ensure that automated testing would give the desired result.
• Create documentation for Oracle Applications Financial modules, combining business processes and application functionality, as well as training the end-user community.
• Improve efficiency of the end-user community through analysis of existing processes & procedures and recommend cost effective changes.
• Perform setups and execute testing scenarios in test environments to verify new functionality, patches, custom development, new implementations, and integration with external systems

Confidential

Responsibilities:

• Conducting Statutory Audits, Tax Audits and Internal Audits
• Dealing with Company Law and Income Tax matters
• Finalization of Company Accounts
• Studying the business process flow of the enterprise and method of maintaining books of account and mapping them.
• Internal control systems review and reporting lapses and suggestions for improvement
• Fixed Assets Verification and Valuation
• Investments Verification
• Secured and Unsecured Loans and Advances
• Review of System of Collecting Data and Reporting and Suggesting Improvement
• Review of the system regarding custodianship and safeguarding the Assets.