SUMMARY

• Above 9 years of Experience in Oracle E - Business Suite Implementation / Support / Testing / Upgrade and more than a decade of experience in various other processes. Worked as Functional Consultant in 4 full life cycle implementations, 2 Support Projects, 2 testing projects and an Upgrade project. Along with 7 years of Experience in Accounting & Finance.
• Hands on Experience in using Application Implementation Methodology, SSAD, QMS, SRS and System Development Life Cycle & Six-Sigma Methodologies.
• Implemented Project Costing, Project Billing, Project Contracts, Project Management, Property Manager, Accounts payables, fixed assets and Accounts receivables modules across industries with handful experience in GAP analysis, Fit-Gap Analysis and development of RICE components.
• Understand the current processes, gather requirements for the new / proposed business model and address the gaps and suggest alternate solutions which address the issues.
• Hands on Experience in conducting CRP/ UAT/ SIT Sessions and other training sessions to the User Community on various ERP Modules during Implementation.
• Experience in implementing and supporting multi-Application integrations with Primavera Contract management, Hyperion Planning, KRONOS, CONCUR, Maximo and Universal Content Management with Oracle E-Business Suite.
• Working with Oracle world wide support through Oracle Metalink for the bugs and defects identified during the day to day business Support and implementation activities by raising Service Requests/ TAR and resolving them.
• Supporting Client Business applications through Onsite - Offshore Business Model which include collaboration with multi-vendor onsite & offshore teams to run business processes uninterruptedly.
• Development of User manuals for UAT using Oracle User productivity kit for enhanced user friendly experience. Experience in handling tracking tools like Quality Center.

TECHNICAL SKILLS

• Project Costing
• Project Billing
• Project Management
• Project Contracts
• Property Manager
• Accounts Payable
• Accounts Receivable
• Fixed Assets
• General Ledger
• Inventory
• Oracle Contracts
• Workflow
• Enterprise asset management
• Oracle Purchasing
• SQL, PL/SQL
• Cash Management

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, Florida

Functional Consultant

Responsibilities:

• Responsible for implementation of Oracle E-business Suite R 12.1.3 Project Management Module in integration Microsoft Projects 2013 with IE 11 which is not certified yet by the Oracle.
• Providing Oracle Project Management solution in accordance with Oracle E-business Solution which includes HRMS, Project and Financial modules which were gone live in 2012. Also the Project Management solution shall not result in modifications to the existing customizations which were gone live in 2012.
• Developed API for loading Work plan schedules for the historic and as well as for the projects which are in progress. These work plans are used for tracking the progress updates in Oracle Project Management. Also developed API to enable work plan flag and deliverables for range of projects based on the input provided.
• Rebuild the custom Reports logic which was impacted by the implementation of Oracle Project Management Solution. All these reports are related to Project budgets which will become as Plan Types after the Project Management solution in place.
• Provided Oracle Project Management Training to the Project Managers who will be using the module for updating the Project Progress and Project schedules in integration with Microsoft Projects 2013.
• Converted all the historical projects in Project Accounting module to Project Management module including their Microsoft Project Schedules.

Confidential, Schenectady, NY

Team Lead

Responsibilities:

• Responsible for support of Oracle E-business Suite Modules Accounts Payable, Accounts Receivables, Fixed Assets, Project Costing and Project Billing Modules. Application support is extended Confidential Standard tools such as TRDSP, T&L, CONCUR and KRONOS Applications. All the deployments are developed using Six Sigma Methodology, QMS and SRS etc.
• As Confidential Business involved in manufacturing multiple products from electrical appliances to heavy wind turbines, the software applications used may not be consistent across all the businesses, which prompt for multi software application integrations and customizations, which sometimes result in business issues that need to be addressed by an expert. As a Functional consultant with the domain expertise and technical knowledge we provide Solutions in accordance with the business requirement. The Solutions provided are not restricted to only technical fixes but are also validated from a larger ambit of business functionality, US GAAP, International Accounting Standards and Law of the United States of America legal requirements.
• As Confidential spread over multiple Businesses across the Globe with different Oracle E-business Suite ERP mechanisms to run its business, it is very much required and important to make aware of the code changes of a specific pole to all the stake holders across the Globe, these changes will be communicated through a platform called Change Control Board Meeting, in short CCB Meeting. I represent the CCB Meeting as a Gasification business representative to understand the Code changes & patch applications and their impact on the Production Instance that are taking place during the week end. Also ensure these changes are on par with Sarbanes - Oxley Act of 2002.
• Support of various inbound and outbound integrations with Oracle E-business Suite for seem less online processing of data, these integrations are with different Legacy systems namely Internal Billing System, KRONOS System, CBSI System, SSP5 System, Maximo System, PCARD System, CONCUR System, T&L System, Microsoft Projects, etc.
• Based on the business criticality sometimes the issue has to be resolved within 2 or 4 hours, as the process involves multiple vendor teams in different time zones, to resolve these issues we establish bridge call and invite various vendor teams, Confidential IT Management and various other stake holders. Sometimes these issues prompt for collaboration with Oracle.
• Through Pattern & Trend Analysis of the ticket volume, we identify the repetitive issues which need to be addressed through permanent code fix and this Pattern & Trend Analysis are to be presented to the Confidential IT Management on a periodic basis to highlight the process improvements done.
• Deployment of new Components as per the business requirements which will be an enhancement to the standard Oracle E-business Suite currently in place. These new components are developed using the Application Implementation Methodology and SDLC to meet the standards of Oracle E-business Suite and Confidential Process Standards. Confidential Process Standards include release of these components through specific designated Enhancement Windows of the Calendar Year.
• The Deployment of components includes preparation of documents as per the Confidential Documentation Standards which are internal to Confidential business. As per the Confidential Standards these documents these documents are called as CF 250 (Functional Specification Document) and MD 200 (Technical Specification Document).
• Defining new calendars and pro rate rules in Fixed Assets module in accordance with Last calendar date changes of Period closing process.

Confidential, Schenectady, NY

Sr. Functional Consultant

Responsibilities:

• Responsible for designing11 segments Chart of accounts in accordance implementing Confidential Confidential solution. The Confidential Solution bring non ERP counties and businesses into ERP System and upgrade current ERP R11 instances into R12.1.3 Environment.
• Defining and configuration of To-Be solution and decommissioning of various legacy systems with the extensive usage of AP, AR and Projects suite R12.1.3Modules &Features.
• Extensive usage of Change Management process as part of implementing Project management solution for updating Supplier POs & Financial Budgets. Usage of Project structures for scheduling requirements.
• Defining auto accounting Features, Functions, Function Transactions, Look ups, parameters, Intermediate values and rules and assigning these rules for generation of Revenue, Invoices, Costs from various transaction sources.
• Defining Cross-project access security rules vide project security rules at Operating units, Project Roles and Organization authority roles in accordance with business requirements.
• Defining work flows using employee supervisor hierarchy relationship for project Budgets, Project status changes and change management process. Sometimes building custom workflows using Work flow builder for other than employee supervisor hierarchy relationships.
• Defining Project Contracts, Authoring work bench, Contract Headers, Contact Lines, Articles, Terms & Conditions, Standard Notes, Parties & Contacts etc. Delivery tracking system for initiation of shipping, billing, planning and procurement activities.
• Project outstanding questions and problems brought into EPR through Issues and change management. These issues and change orders used for automatically updating of Project Budgets& Purchase orders.
• Prepared Test scripts for various test scenarios of Invoice to Payment cycle in Oracle Payables& Project creation to Receivables Invoice creation &collections.
• As there are pending Law suits against some of the projects records and the records have to be maintained indefinitely into future. This demanded for complete conversion of data from all the integrations from R11. .1.3 and defined Data Conversion strategy in these tight lines. The other demand for Conversion strategy is to give the same report outputs for all the existing Reports in R 12.1.3.
• Interfacing the CIP Assets from Project Accounting module to Fixed Assets using mass additions.
• Development of New prorates depreciation strategies in accordance with business requirement.

Confidential, Schenectady, NY

Functional Consultant

Responsibilities:

• Responsible for development and modification of custom components such as Employee Short Term Business Trip Income Tax calculations, CONCUR Inbound & Outbound changes Markup Extensions, Error Correction Form.
• As part of Component Development participated in series of meetings with Business users to understand the requirement and need of development of new components in the current business environment.
• Developed functional design document for the Custom component to be developed along with details such as Requirement, Assumptions, Dependencies, setups and test cases.
• These Custom Components are developed in collaboration with offshore technical team which works typically in a different time zone from India.
• Developed Auto-accounting rules for the new components in accordance with best accounting practices and law of the land.
• As part of release management applied various patches to maintain the sustainability of the oracle environment after rigorous patch impact analysis and end to end business cycle testing in non-production environment before moving to the production environment.
• The support activities include support of oracle modules Project Costing, Project Billing, Accounts Receivables and Fixed Assets module along with the integrations & Customizations.
• The new Component Development sometimes prompt for changes in Original Implementation Documents such as BP 080 (Solution Design) & BR 100 (Setup Document), which will be documented with Confidential Standard Version control numbering.
• These new version numbered documents are updated in Confidential Libraries for future reference which is called as Confidential Documentum. The document access is highly restricted to User Community based on the Confidential Security Standards and Business Export Control Policies & Standards of the law of the land.

Confidential

Functional Consultant

Responsibilities:

• Responsible for Implementation of Project Costing, Project Management, Fixed Assets & Accounts Payable and Project Contracts Modules seamless integrations and Build integration between Project Contracts and Universal Content management (used for storing the Contract Documents of large size in .pdf format). Integrations with Primavera Project Contracts Module and P6.
• Implemented solution with integrating Oracle E-Business Suite with Hyperion Planning, Siebel CRM Solution and Universal Content Management. Also implemented Delivery Tracking System as a part of Project Contract Module solution for Supplier Payment management.
• Gathered the Business requirements from different locations / units of Confidential Company across United Arab Emirates. ADPC is spread over United Arab Emirates country constructing Industrial zones and Ports.
• Mapped of the requirements to Oracle E-Business Suite, providing the Solution Design and fit gap analysis. Conducted Conference Room Pilot and various other Trainings to the Key Users and End Users of the ADPC for familiarizing the Business Users with Oracle E-Business Suite.
• Built custom approval workflows for difference processes like Project creation, Issue management, Change management and Budgets creation.
• Built Auto Accounting setup of Project accounting in accordance with General Ledger Chart of Accounts for costing and clearing accounts for various functional transactions like Labor Cost Account & Clearing Account, Miscellaneous Transaction Cost Account & Clearing Account, Burden Cost Account & Clearing Account, Revenue and Invoice Accounts, Labor Revenue Account, Miscellaneous Transaction Revenue Account, Event Revenue Account etc.
• Converted historical transactions from legacy system and Created interfaces for Inbound and outbound data conversion with Primavera Project Contract Management. Data migration from Legacy systems - APIs and Open Interfaces. Detailed mapping of legacy data elements, conversion and testing.
• Conducted Project Steering Committee meetings to resolve the issues which are not resolved due to different process followed by different units within Confidential Company, by providing solutions, which are best practices followed in the industry.
• Organizing meetings to define and Conclude Cost Code Structure for Projects to be followed uniformly throughout Confidential Company and defining values for the same.
• Implementation in Oracle E business suite in Government Organization and bringing Consensus among various stake holders on various matters which might result into projects risk have been resolved through Project meetings and escalation mechanism to Steering Committee.

Confidential

Functional Consultant

Responsibilities:

• Module lead for Project Costing. All Financial & Supply chain modules are getting upgraded from R11. .0.6. Project costing module is fresh implementation. The implementation went completely using Application Implementation Methodology.
• Studying the current business process followed in Confidential for building Capital Work in Process Projects. This includes how the Capital budget allocations are taking place and how these budget allocations are getting reflected in corporate budgets.
• Providing the solution design using the capital projects requirements collected and also considering the requirements collected for upgrade of financial and supply chain modules through collaboration with other implementation members.
• As part of Solution design we have integrated the project budgets with General Ledger budgets and used absolute / advisory method of budget control to exercise the control on the funds.
• Presenting the overview of the integration of Accounts Payables, Purchasing, Fixed Assets, Oracle Time and Labor, Inventory and General Ledger modules with Project Costing Modules to the key users and its impact after the R12 upgrade.
• Interfacing the Project CIP Assets through mass additions program to Oracle Fixed assets.
• Implementing the Solution provided along with the upgrade of R12 other modules in R12.0.6 and supporting the solution post implementation phase.
• As part of implementation process provided training to Key users and Super users on Oracle Project Costing module with respect to setting up Project Owning Organizations, Project Types, Project Templates, Projects, Tasks, Budgets, Expenditure Categories, Revenue Categories, Expenditures types etc.
• AIM documentation like BP 80, BR 100, TE 40, MD50 and SOP.

Confidential

Functional Consultant

Responsibilities:

• Responsible for implementation of Property Manager, Accounts Payable & Accounts Receivable modules which includes integration with other modules such as EAM, CM, PA, INV, FA&GL.
• Confidential Bank uses banking specific software for its banking applications. As part of as is study Understood the functionality of the current Legacy System its various processes and gathering requirements &expectations from the user community for development of Oracle ERP system.
• Conducted the FIT GAP analysis by mapping of the requirements with standard Oracle functionality and identified the RICE components to be developed.
• Preparation of Standard Procedural Documents for various processes that are to be followed due to change in system from Legacy to Oracle and Test Scripts for the CRP, UAT & SIT.
• Meeting the Technology Team and the User community on regular intervals to conclude accounting policies relating to Revenue Recognition, Accrual Entries, borrowing costs, deferred expenses etc.
• Responsible in carrying out the Master and Transaction Data conversions of Property Manager, Accounts Payable and Accounts Receivable modules.
• Adherence to AIM Methodology of Oracle for the project Implementation and preparation of documents like RD050, BP080, BR100, TE040 etc. and review of MD050 & MD070.
• Developed MD 050s for Custom Components in Property Manager Modules with Technical Team.
• Providing Training to the Users on Oracle E-Business suite Financial and Property Manager Modules.