SUMMARY:

• To be recognized as an efficient & competent individual having good interpersonal, technical and functional skills. Being a hard worker with a positive attitude, I aspire to prove my talent in fast moving techno world. My broad level future goals are to work as functional consultant involving in improving client’s business by assisting them with the available business functionalities in Oracle E - Business Suite and Fusion.
• 9.6 years of experience in systems analysis, design, development and testing of complex software systems in service, paper and document industry.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle of Oracle E-business Suite11.5.9/R12/12.1.3.
• Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Worked as Module lead, and led a small team of three in two assignments and successfully delivered the project before given deadline.
• Have Extensive Knowledge in Oracle CRM Modules like Service Contracts, Install Base, Field Service, Tele service, Depot Repair and Mobile field service.
• Functional Knowledge in spares requirement, Service Parts Planning, Inventory, Advance Customer Exchange, Call Center applications, Shipping, Internal Sales Order, External Repair Exchange and Depot Repair.
• 2+ years of experience in implementing Oracle Field Service, Mobile field service, Teleservice and Advance Customer Exchange for Sun Microsystems which was acquired by Oracle.
• Experience in data migration and data conversion in modules like Oracle Service Contracts, Field Service, Customer Master and Item Master. Have transferred data from legacy system to oracle database for these modules.
• Also experienced in enhancement, customizing, maintaining applications and support in Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/XP.
• Developed Client-Server applications using front-end tools like Oracle Forms 6i, Oracle Reports 6i, SQL*Loader, SQL*Plus and SQL*Navigator.
• Hands on Experience with Oracle Application Object library like concurrent processing, menus, functions, profiles, security, executable, value sets, and descriptive flex fields, key flex fields and defining users and registration of forms and reports.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Good Exposure in implementing Oracle R12 for Oracle CRM modules.
• Detailed depth Knowledge in Oracle Architecture, Data Dictionary, API’s and DBMS Packages.
• Integrated the mailing system to alert various group on the status of various Jeopardy conditions that occur in various oracle business situations.
• Have done end to end implementation of Field Service, Depot Repair and Install Base for a transportation company based in Saudi Arabia.
• Involved in various pre-sales, demos of Fusion CRM modules to customers. Trained 25 people in Fusion CRM across 10 sessions and helped them to achieve certification. Certified Fusion CRM Sales Implementation Specialist.
• Implementation experience in Fusion CRM Sales and Marketing modules for Confidential Internal Implementation.
• Working on Co-existing Fusion CRM with other Oracle EBiz Modules.
• PoC on co-existence between Fusion CRM and Oracle EBS12.2.
• Experienced in Page/Application Composer, Extensibility and Groovy Scripting.
• Working as a Functional Consultant for the implementation of Oracle Field Service, Spares Requirement, Teleservice and related modules to Sun Micro Systems
• Functional knowledge of Oracle CRM Service modules like Service Contracts, Field Service, Tele service, Install Base, Spares requirement, Service Parts Planning, Inventory, Advance Customer Exchange, Call Center applications, Shipping, Internal Sales Order, External Repair Exchange and Depot Repair.
• Design, development, customization, implementation and testing of Oracle E-Business Suite 12.1.3
• Development using Oracle Forms 6i, Oracle Reports 6i, SQL, PL/SQL.
• Defect correction, code optimization and performance tuning.
• Enhancement based on customer’s business requirements apart from Oracle Standard products.
• Business requirement setups and development of custom based reports using PL/SQL to assist and improve business.
• Identifying issues with the standard product and fixing the same. Also do a check of standard functionalities.
• Patching and testing Oracle Standard functionalities that are very critical for client’s business.
• Develop custom solutions that are not met with Oracle standard product, testing and implementing.
• Preparing and assisting with the development of BR100 document setups and maintain the setups.
• Debugging functional issues and product issues and providing a solution and correcting the process for smooth functioning.
• Working as a Functional consultant in Fusion CRM implementation and co-existence.
• Have done pre-sales and proof of concept for Fusion CRM modules.

TECHNICAL SKILLS:

Languages: Oracle SQL, Oracle PL/SQL, Visual Basic 6.0, C, C++

Operating System: Windows 7/8

Scripts: PERL, Shell Script

Database: Oracle 10g/11g

Web Server / App Server: Oracle Application Server 10g

Version Control: Microsoft Visual Source Safe (VSS) 6.0

Tools: Oracle Forms 11i, Oracle Reports 11i, Toad 9.5, SQL Developer, SQL Navigator, Oracle SQL Plus 8.0, Remedy, Putty and HP Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Analyst - Techno Functional

Environment: Oracle R12.1.3

Responsibilities:

• Supporting the largest customized modules in depot repair and Tele-Service modules.
• Resolved go-live issues which affects Nintendo repairs and also took care of business processes.
• Cleared Install Base Transaction Errors that were caused during inventory and material transactions.
• Working technically in supporting customized Oracle modules for the business
• Also supporting O2C and Oracle ATG related issues during the project.

Confidential

Business Analyst - Techno Functional

Environment: Oracle R12, Oracle Service Contracts, Oracle Install Base and Oracle Field Service

Responsibilities:

• Supported Oracle modules used by Symmetricom.
• Resolved issues related to Oracle Service Contracts Billing, Contracts Renewal and Contract Creation custom issues.
• Cleared Install Base Transaction Errors that were acquired during inventory and material transactions.
• Technically analysed customer issues looking into the API code and error transactions.
• Resolved more than fifty incidents during the tenure at the project
• Also developed knowledge in SCM and O2C modules which interacts with Oracle Service Modules.

Confidential

Tool: Development and Testing

Environment: Oracle Service Contracts, Oracle Install Base and Oracle Field Service

Responsibilities:

• Tool will identify the modules bought and installed at the customer site.
• Tool will check for the data that has to be migrated to the new environment.
• Will check the volume and does data analysis.
• Uses query to perform the database analysis.
• Will run on customer’s environment to identify the best processes and the data to ne migrated for an upgrade or re-implementation.

Confidential

Application Implementation, Customization and Testing

Environment: Oracle E-Business Suite 12.1.3, SQL, PL/SQL, SQL Plus 8.0, SQL Developer and Oracle Database 11g

Responsibilities:

• Started with CRP1, CRP2 and CRP3. Held all these CRP’s for a total of 10 key users.
• Business process mapping with Hafil business and finding gap analysis.
• Provided standard functionalities for Hafil’s business.
• Also worked on custom codes to fulfil Hafil Depot Repair functions.
• Conducted User Training and User acceptance testing.
• Prepared BR100 documents which explains the setup related functions for the customizations.
• Product went live on March 31 st . Production Support Phase for Hafil
• Customization, testing and implementation of the project and supporting the customizations at production. Worked on completed End to End Implementation cycle.
• SQL Developer and Oracle SQL plus 8.0 are used for enhancement and customizing.

Confidential

Application Implementation, Customization and Testing

Environment: Oracle E-Business Suite 12.1.3, SQL, PL/SQL, SQL Plus 8.0, SQL Developer and Oracle Database 11g

Responsibilities:

• Involved in development and implementation of Oracle Application Field Service and related modules.
• Developed custom programs to notify field service engineers the availability of spare parts for servicing, the type of service contract they are working upon and managing jeopardy conditions that occur in the service sector.
• Development using SQL, PL/SQL and implementing the customized program in Oracle E-Business Suite 12.1.3.
• Worked upon the notification structure and registered the customized programs as Concurrent programs which are scheduled to run on a specified timeline.
• Developed custom programs for spare parts shipping that are integrated with a third party logistics. Communication with the third party is done using SOA architecture and XML.
• Prepared BR100 documents which explains the setup related functions for the customizations.
• Developed custom program for the cancellation of internal spares orders that is ordered but not shipped due to various issues. Internal spares order and planning orders are cancelled using a concurrent program.
• Worked on Supply Chain Command Centre, a tool that helps business users to monitor the shipment of an internal sales order from the warehouse to the customer location. Shipment is physically done by third party and logically stored in related Oracle standard tables.
• The Integration between the third party and Oracle Global instance is built with SOA architecture.
• Developed custom code for ordering spare parts for advance customer exchange where the field service engineer’s involvement is not there.
• Developed Custom report that is run as a concurrent program, which reports the one time install base address that are used by the customer’s to track and update Install Base.
• Developed a custom report that analyses the number of items and parts that are installed at customer’s location and to track the damaged spare parts that are transported to either repair warehouse or scrap agent.
• Customization, testing and implementation of the project and supporting the customizations at production. Worked on completed End to End Implementation cycle.
• SQL Developer and Oracle SQL plus 8.0 are used for enhancement and customizing.

Confidential

Application Implementation, Customization and Testing

Environment: Oracle E-Business Suite 12.1.3, SQL, PL/SQL, SQL Plus 8.0, SQL Developer and Oracle Database 11g

Responsibilities:

• Oracle Field Service helps to improve better service to customers at their site.
• Sun’s Field service engineers used Oracle FS worldwide to meet customer service. Users across globe used Sun’s hardware and servicing them at the installed location by using Oracle Field Service helps Oracle to grow. Implemented for 596 organizations.
• Implementation of Oracle 12.1.3 Field Service to improve Sun field Service business.
• Implemented Oracle Standard products based upon SUN’s business requirements.
• Business requirement that is not met in Oracle’s Standard product are developed by the team using PL/SQL and implemented.
• Setup’s related to the functioning of the Field Service, Install Base and related modules are taken care through Alerts and notifications.
• Resolved functional issues that occurred while implementing the product.
• Worked on Field Service, Spares requirement and Spares logistics related code and setups.
• Have an Understanding of FS related modules such as External Repair, Advance Exchange, Service Parts Planning, Inventory and B2B.
• Developed custom code for shipping and order management.
• Developed Custom Code which helped Field Service Engineer’s to understand the kind of contract they are working.
• As logistics part of FS is done by third party, developed a report that will synchronize Oracle’s logical item on hand quantity with the physical item on hand quantity which is possessed by third party.
• Also implemented Tele Service module to route all the SUN customer’s calls to the specific group which individually resolves various customer issues.
• Customization, testing and implementation of the project. Worked on completed End to End Implementation cycle.
• SQL Developer and Oracle SQL plus 8.0 are used for implementation.

Confidential

Requirement Analysis, Design, Coding and testing

Environment: PLSQL, Oracle Forms 11i, Oracle Reports 11i, SQL Plus 8.0, Toad 9.5 and Oracle Application Server 10G

Responsibilities:

• All existing modules like Service Contracts, Field Service, Install Base, Customer Master, Item Master, Inventory, Tele-service are moved from 11i to R12 using SQL, PL/SQL, Oracle Forms 11i and Oracle Reports 11i.
• Functional analysis and design done for the implementation of the Oracle modules from 11.5.9 to R12.
• All the new front end R12 functionalities are implemented and customers are trained to use the new front end functionalities.
• Changed all the existing customizations to adhere to the new R12 front end functionalities and the new R12 table structure for Oracle Applications.
• Functional testing and business testing for all the implemented R12 modules.
• Worked with business to analyse the impact of the new R12 functionalities and helping them with the selection of priority functionalities.
• Monitoring the performance related issues in the functioning of applications before R12 go-live in the test instances and supporting by interacting with Oracle Support through Metalink.
• Worked on functional role to communicate with business and get the requirement and then develop accordingly.