PROFESSIONAL SUMMARY:

• 9+ years of experience in Design, Development, Administration and Implementation of Oracle Applications both 11i and R12 SCM modules (Inventory, OM) and CRM Modules (Field Services, Install Base, Service contracts, Spares Management, iStore & iSupport). He Explored Knowledge on Financial Modules (AP, AR and GL), Quoting and Project Accounting modules.
• End to end implementation experience in Inventory, CRM Modules.
• Experience in various Functional setups of Field Services, Install Base, Service Contracts, iStore & iSupport, Inventory, OM modules.
• 2+ years of experience as Project lead.
• Interacted with clients during the Implementation process, Involved in Requirements gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Applications 11i & R12.
• Attend Business Process and Knowledge Transition Sessions with IT & Business Owners and Mapping Customers requirements into Oracle CRM Modules.
• Involved Business Process and Knowledge Transition Sessions with IT & Business Owners and Mapping Customers requirements into Oracle.
• I have understood the flow of business in afore mentioned modules comprehensively and design a solution for the integration. Implementation is guided by my thorough functional knowledge of the respective modules to provide a fool proof solution. The solution has included using of Java, PL/SQL, and UNIX at various integration points to design a seamless solution. With sufficient knowledge of the above - mentioned languages I can coordinate between resources and guided the design accordingly.
• Trained the end users in working with the Oracle modules provided technical expertise.
• Experience in retrieving Data using SQL queries.
• Solved the issues for UAT Training as per Priority and updated status Sheet.
• Prepared User training materials (SOP) with screenshots for each module.
• Prepared User guides and Conduct End user trainings.
• Understanding migration and release management practices.
• Quick work around and resolutions for Priority issues.
• Responsible for interacting with business partners to identify information needs and business requirements for Setups.
• Conforming to the Quality Procedures and Standards related to the project and Employer.
• Used Oracle standard APIs to develop custom scripts to create, update, delete the data.
• Excellent written and oral communication, leadership, team management, and people skills.
• Self-motivated/starter in fast paced environments.

TECHNICAL SKILLS:

Hardware: IBM Compatible PC’s

Operating Systems: Windows

Languages: C, C++

Databases: Oracle 10g

GUI: SQL Developer

Case Tools: Service Now

Tools: & Utilities: Toad, Oracle Forms Builder 9i, Reports Builder9i, WinSCP

Domain Knowledge: Oracle ERP 11i, R12

PROFESSIONAL EXPERIENCE:

Confidential, Schenectady, NY

Applications Analyst

Responsibilities:

• Provide technical and functional support to find the root cause analysis and bugs in CRM Modules like Field Services, Install Base, Service Contracts, Oracle Quoting, Spares Management, iStore, iSupport, etc.
• Involved in interaction with customer technical team or business team for any issues or concerns in accordance with implementation or requirements respectively.
• Developed scripts for data fixes by using API’s whenever there is any requirement from business to update the data related to Installed Base and Service Contracts.
• Worked on IB serialization issues and developed data fix scripts using APIs to update the Level0 Attributes for the turbines in Installed Base.
• Worked on OAF Personalization setups for Field Services Technician Portal.
• Involved in 24x5 production support activities in CRM (Field Services, Installed Base and Service Contracts)
• Attending CCB Calls, Code Review Calls and Business User Calls whenever required.
• Configured iStore admin setups Sites, Product catalog, Template management, Content management and customized roles.
• Involved in External and Internal User setup and Maintenance for iStore & iSupport.
• Involved in setting up iStore profile options.
• Oracle Order Capture to capture the customer’s order from the shopping cart.
• Involved in configuring iStore admin setups. He Involved in Implementation, Maintenance, support and Testing of Oracle iStore Application.
• Experience in Administration of iStore sites.

Confidential

Analyze

Responsibilities:

• SCM Modules: Account Receivables, Inventory and Order Management
• CRM Modules: Install Base and Service Contracts
• Responsibilities
• Creation of new Organization structure to implement Services while Understanding the existing Process and interfaces.
• Taking care new enhancements and implementing the changes while configuring new Operating Units.
• Taking lead in Legacy Systems while interfacing critical Customer Data for the newly created Operating Units.
• Lead the requirements gathering and finalizing the process flow for CRM Modules and other interface (SCM) Modules.
• Updating of documents like BR 100, MD 050 and BR 110 documents.
• Executed the Conference Room Pilot (CRP).
• Resolving Production related issues of high priority.
• Offshore support for Oracle CRM modules covering Field Service, Install Base, Service Contracts.

Confidential

DR4 Rollouts

Responsibilities:

• Creation of new Organization structure to implement Services while Understanding the existing Process and interfaces.
• Taking care new enhancements and implementing the changes while configuring new Operating Units.
• Taking lead in Legacy Systems while interfacing critical Customer Data for the newly created Operating Units.
• Led the requirements gathering and finalizing the process flow for CRM Modules and other interface (SCM) Modules.
• Updating of documents like BR 100, MD 050 and BR 110 documents.
• Executed the Conference Room Pilot (CRP).
• Resolving Production related issues of high priority.
• Offshore support for Oracle CRM modules covering Field Service, Install Base, Service Contracts.

Confidential

Labor Codes Simplification Project

Responsibilities:

• Analyze the mapping document provided by the business about the old and new labor codes.
• Prepare a project plan about the time lines for the delivery of the project.
• Disable the old Labor codes provided by the business in Inventory, create new labor codes in Inventory and assign them to the respective Operating Units, Inventory Organizations.
• Prepare a data fix to update all the open transactions i.e. Service Requests in Field Services.

Confidential

Labor Codes Simplification Project

Enhancement: Wind Field Services Debrief Extract to Install Base Configuration Update

Responsibilities:

• Creation of CF250 and MD200 documents.
• Develop custom program to extract the debrief Line DFF information from the field services and update the part in information in Install Base and replacing the part out information from filed services.
• Creation of custom lookups, Flex Fields.

Confidential

CRM to Sales Force Integration

Responsibilities:

• Preparation of MD200 document for all the Inbound & Outbound Programs.
• Develop outbound integration Program to send Service Request, Resource Sub inventory, Install Base, Internal Requisition data to Service Max.
• Taking lead in Legacy Systems while interfacing critical data.
• Led the requirements gathering and finalizing the process flow for CRM Modules and other interface (SCM) Modules.
• Updating of documents like BR 100, and BR 110 documents.
• Develop inbound integration program to receive Task, Debrief data from Service max.
• Creation of custom tables, Buffer tables for Web Methods.
• Creation of Common lookups, Flex Fields.
• Creation of new items i.e. Labor, Material and Expense required for Field Services, Install Base and Service Contracts.

Confidential

Juliet Support

Responsibilities:

• Customization of various Oracle Reports (RDF and XML Publisher based reports) as per the business requirements.
• Involved in interaction with customer technical team or business team for any issues or concerns in accordance with implementation or requirements respectively.
• Worked on integrations like CMS (Sales Force.com) to Juliet ERP Service Contracts (where opportunities in Sales Force hit the Juliet ERP tables via web methods interface).
• Developed scripts for data fixes by using Oracle Standard API’s whenever there is any requirement from business to update the data related to Installed Base & Service Contracts.
• Worked on IB serialization issues and developed data fix scripts using APIs to update the Level0 Attributes for the turbines in Installed Base.
• Worked on Form personalization on Service Request forms, Service Contracts to hide certain fields, increase field width, rename the fieldnames and making some fields as mandatory as per the business requirement
• Involved in 24x5 production support activities in the area of CRM (Field Services, Installed Base and Service Contracts)
• Attending CCB Calls, Code Review Calls and Business User Calls whenever required.

Confidential

Development Project

Responsibilities:

• Preparation of Technical specifications from the functional specifications received from the functional team, technical design following client’s own methodology.
• Development of custom report based on client requirements.
• Developing conversion and interface programs and registering them as concurrent programs and run from SRS form.