SUMMARY

• 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 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 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.

TECHNICAL SKILLS

Languages: SQL*Plus, HTML

Tools: Microsoft office tools, SQL*Loader, XML, Win Runner, Quick Test Pro

Database: Oracle 10g/9i/8i, MS SQL Server 2000, 2003.

Operating Systems: UNIX, Windows 95/NT/2000, DOS.

PROFESSIONAL EXPERIENCE

Confidential

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 timesheets 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 dataloader 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, Cherry Hill, NJ

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 systems

Confidential, Union City, New Jersey

Environment: Oracle Apps Release12, TOAD, SQL.

Responsibilities:

• 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
• 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
• 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 and I-expenses
• Facilitate business-owner reviews and obtain sign-off on functional designs
• Performing conference room pilot (CRP) testing and related documentation/deliverables
• Leading an offshore team of 6 and guiding them to solve the issues.
• 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
• Initiating and incorporating enhancements and incorporating the relevant enhancements in the documents as a part of change control procedures
• Check unit test plans, technical documents and other quality reviews
• Perform the detailed functional design of the application enhancements. Document the application to facilitate on-going support and future release development.
• Liaison with technical support team and DBA’ s on the project
• Work with other team members to ensure that the configuration and custom components meet application requirements and performance goals
• 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
• Translate these alternatives into an explicit list of required enhancements RICE (reports, interfaces, conversions, extensions, and workflow).
• Plan, prepare, and execute quality assurance and user acceptance testing. Engage business users during UAT and facilitate sign-off on test results.
• Support QA and UAT by implementing design changes to address defects found in testing and giving post production support to address all the business or process related questions or concerns. .
• Conduct and participate in Issue Management meeting on a regular basis
• Review and track Oracle issues through resolution
• Leading an offshore team of 6 and guiding them to solve the issues.
• Perform the detailed functional design of the application enhancements.
• Facilitate business-owner reviews and obtain sign-off on functional designs
• Create documentation and provide end-user training and material

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

Environment: 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 docu.menting them.