We provide IT Staff Augmentation Services!

Oracle Technology Consultant Resume

3.00/5 (Submit Your Rating)

Ks, UsA

Experience Summary:

  • 7 years of Experience as an Oracle Programmer Analyst working as a PL/SQL Developer, Oracle Apps Business Analyst, Oracle Apps QA, Oracle Apps Developer and Fusion Middleware (SOA) Consultant.
  • Extensive experience in Oracle E-Business suite Applications, SCM and CRM modules including Inventory (INV), Order Management (OM), Bills of Material (BOM), Work In Progress (WIP), Material Requirements Planning/Forecasting (MRP), Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Purchase Order (PO), Sys Admin and AOL.
  • Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
  • Extensively worked on the Oracle Fusion Middle Technology.
  • Tools worked on: Reports 6iDiscoverer Reports, PL/SQL Reports, XML Publisher Reports, STT, XML, XSLT, Oracle BPEL JDeveloper, Oracle OSB, and Oracle ESB.
  • Comfortable working with Testing, Debugging, and Deployment of Applications.
  • Proficient in developing Oracle PL/SQL packages, stored procedures, functions, triggers and cursors.
  • Was a part of Center of Excellence initiatives (R&D projects) and many POCs for the projects at Practice level.
  • Was a part of Center of Excellence initiatives (R&D projects) and many POCs on R12 for the projects at Oracle Practice level.
  • Performed Data Conversion from Flat files to Oracle using Oracle SQL* Loader, Datastage.
  • Experience in Performance Tuning and Optimization of Oracle Scripts.
  • Excellent conceptual and working knowledge of Oracle Database Design and Development, Object Oriented Design (OOD), SQL, PL/SQL, UNIX Shell Scripting, XML.
  • Strong experience in client interaction and understanding business application, business data flow and data elements
  • Experience in design and development of reporting environments
  • API: Worked on Oracle APIs to convert data from legacy systems into Oracle ERP.
  • AOL: Worked on AOL, registration and customization form through CUSTOM library, Standard packages and reports in Oracle Applications as per business needs.
  • Open Interface: Extensive experience in Oracle open interface tables. Held positions where major responsibilities included coding and unit testing reports, interfaces, conversions & enhancement programs.
  • System Administration: Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
  • Experience in Design and Development of Reports, Interfaces development of Oracle financial modules.
  • Proficient in designing, writing Technical and functional Specification documents, gathering end user and business requirements and GAP analysis
  • Well conversant with all the phases of Software Development Life Cycle (SDLC) and AIM Methodology.
  • Trained on various R12 features like MOAC (Multi Org Access Control)SES (Secure Enterprise Search) Integration Repository, RBAC (Role Based Access Control) XML Publisher, Business event Systems (replacing Workflows).
  • Define user requirements, functional requirements and develop functional designs and Technical designs for custom modules.
  • Create end-user documentation to provide training to end users especially in Oracle Fusion Technology and BPEL.
  • Experience in System Requirement Study, System Design, Database Design, Programming, Testing and Implementation.
  • Experience in Oracle Discoverer reporting functionality and features, including LOV s, functions, aggregations, parameter utilization, and drill down.
  • Involved in coding comprising of Dynamic Triggers, Stored Procedures, Functions, Packages, SQL tuning, Templates and Classes
  • Expert in execute unit test scripts, Quality Assurance Testing, support function and user acceptance testing
  • Domain expertise: Manufacturing and Oil & Gas Plants and Telecom Industry.
  • Worked as an Offshore Lead in my recent Projects and Managed a Team of 4 People.
  • Proven ability to deliver output on time and detail oriented.
  • Ability to learn new skills and take on greater responsibilities. Good analytical, problem solving, interpersonal and communication skills.

Certification:

Certified ‘On Demand Implementation Champion’ by Oracle Partner Network, Oracle Corporation.

Education:

Bachelor of Engineering (B.E.) with specialization in Electrical and Electronics Engineering (With distinction)

Confidential,University.

Technical Proficiency:

ERP

Oracle Applications (INV, WIP, BOM, OM, Shipping, AP, AR, GL, FA, AOL, Sys Admin), Oracle Install Base.

Oracle Tools/Utilities

TOAD, SQL Plus, PL/SQL Developer , PVCS

Programming Languages

C, PL/SQL, SQL, XML, XSLT, Business Process Execution Language (BPEL), Web Service Definition Language (WSDL), HTML, XML

Other Tools

Forms 6i,Reports 6i, Discoverer Reports, XML Publisher Reports, XML, XSLT, Oracle BPEL JDeveloper, Oracle ESB, Toad, SQL Plus, SQL Developer, PVCS, Mercury Quality Center, Kintana

Operating Systems

UNIX, Windows 95/NT/2000

Oracle Databases

Oracle 8i, Oracle 9i, Oracle Database 10g

Project Details:

Project Description: This project is intended to provide assistance in migrating and upgrading CaseOne and CaseCentral Oracle databases. Also to provide an insight on the best practices that needs to be implemented as part of performance issue resolution. The scope of this document is to provide resolution to the challenges caused due to the issues due to upgrade and migrate. 
Client: Confidential, KS, USA 
Domain: Healthcare 
Duration: April 2012- August 2012
Role: Oracle Technology Consultant 
Environment: Oracle 10g, Oracle SOA 10g (10.1.3.4), SQL.
Skills: Oracle 10g, Oracle 9i, SQL, PL/SQL, Unix, Oracle RAC, Performance tuning, Toad, JDeveloper. 
Contribution:

  • Understanding the business process and suggesting changes in the technical architecture.
  • Providing the best cost effective solution for upgrade from 9i to 10g and from single instance to
    • RAC cluster environment.
  • Involved in providing drawbacks in the design, suggestions for redesigning the processes.
  • Provided technical evaluation on the server performance and the metrics for CaseOne and
  • CaseCentral onto the existing CaseViewWeb RAC cluster.
  • Proposed solutions for performance issues and existing issues. Provided the list of queries
  • and view definitions for performance tuning and faster execution of queries in the
  • database.

2. Providing Solution for ESB and BPEL issues for CaseView Web Provider SOA interface:

Project Description: This project is intended to provide conceptual solution for the issues in CaseView Web Provider SOA interface. It provides an insight on the best practices that needs to be implemented as part of issue resolution. The scope of this document is to provide resolution to the challenges caused due to the issues due to BPEL Timeout and ESB Server Errors. 
Client: Confidential,Lenexa, KS, USA 
Domain: Healthcare 
Duration: February 2012- March 2012
Role: ORACLE Technology Consultant / SOA Programmer Analyst
Environment: Oracle 10g, Oracle SOA 10g (10.1.3.4), SQL.
Skills: Oracle 10g, Oracle SOA 10g (10.1.3.4), SQL, Oracle Fusion Middleware Technology (ESB and BPEL), Toad, JDeveloper. 
Contribution:

  • Understanding the business process and SOA interface design.
  • Providing conceptual solution guide for ESB and BPEL timeout issues.
  • Involved in providing debatching solution for ESB file adapter, drawbacks in the design, suggestions for redesigning the process.
  • Provided configuration changes to ESB file adapter to limit the number of polling threads, to read files ordered by time stamp, to throttle the number of files being processed by ESB file adapter.
  • Provided configuration changes to dequeue adapter in BPEL process.
  • Recommended the timeout values at BPEL console configuration level, at Application Server level, at EJB level, increasing JTA and JMS timeouts in ESB container, at Apache server configurations.
  • Proposed changes to BPEL processes for better performance and for faster execution time.
  • DB script modifications to purge scripts to purge BPEL instance data in Dehydration database.
  • Provided the list of queries and view definitions for performance tuning and faster execution of queries in the database.

3. Oracle Apps Production Support Development for Flowserve Corporation (Pumps division)

Project Description: Flowserve Pumps division has implemented Oracle Apps and went live in Aug 2010. This project is related to the strategy for supporting the manufacturing, order management, shipping, sales and purchasing modules. 
Client: Confidential,VA, USA 
Domain: Manufacturing
Duration: January 2011- December 2011 
Role: ORACLE APPS PRODUCTION SUPPORT DEVELOPER / ANALYST
Environment: Oracle 10g, Oracle Apps 11i manufacturing, Order Management and purchasing modules.
Skills: Oracle SQL, Oracle PL/SQL, SQL Developer, Discoverer reports, XML Publisher Reports, Toad, Oracle 10g, Oracle Applications, Oracle JDeveloper, Oracle Apps SCM modules, Oracle SOA, Oracle Fusion Middleware Technology. 
Contribution:

  • Understanding the manufacturing business related to the Flowserve Pumps division and to provide Post-Production support and Customizations to shipping and logistics.
  • Involved in conversions of Inventory items from legacy systems to Oracle Apps.
  • Involved in gathering the technical requirements from users and work through development and testing.
  • Involved in developing and customization of Oracle Reports, discoverer reports and customization of Oracle Workflows.
  • Involved in Production Support Issues, Change Requests, supporting CR’s.
  • Involved in supporting SOA (BPEL) interface for CHP using Oracle Fusion Middleware Technology.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.

4. Project North VIPR-UWP - Tier 2 Support for Frontier Communications

Project Description: Verizon has announced the spin/merge of their assets to Frontier Communications Industry and on high level all Verizon applications will be replicated in a data center. Tier 2 Support is related to the strategy for supporting all the databases related to VIPR/UP in SpinCo environment. 
Client: Confidential,Dallas, TX, USA 
Domain: Telecom
Duration: July 2010- Dec 2010 
Role: ORACLE PRODUCTION SUPPORT DEVELOPER / ANALYST
Environment: Oracle 10g, Java Application
Skills: Oracle SQL, Oracle PL/SQL, SQL Developer, Datastage, Toad, Java Application, Java EJBs, Eclipse, 
Contribution:

  • Understanding the architecture of the systems related to SPINCO to provide Production Support to the SPINCO systems.
  • As a part of Tier 2 Support for Frontier Communications, I was involved in resolving Single User issues.
  • Involved in Production Support Issues, Change Requests, supporting CA’s.
  • Coordinating with the Verizon folks on the top issue tickets rose.
  • Resolved issues pertaining to the Cron jobs for ISP Provisioning.
  • Involved in coordinating, testing – Database and Application changes for Monthly Releases for VIPR UP application.
  • Participated in the business discussions, and designing the Flows for Project North.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.

5. Project North for Verizon Wireless

Project Description: Verizon has announced the spin/merge of their assets to Frontier Communications Industry and on high level all Verizon applications will be replicated in a data center. These would include the Application Changes, Data Segmentation. The strategy for all databases related to VIPR/UP in SpinCo environment will be segregated based on the user list (VZ ID, BAN) provided by SSP (.NET and DNE/DNR/DNS users) and also the user list (USERNAME) provided by eReg (.COM USERS). 
Client: Confidential,Dallas, TX, USA
Domain: Telecom
Duration: October 2009- June 2010 
Role: ORACLE PL/SQL DEVELOPER / ANALYST
Environment: Oracle 10g, Java Application
Skills: Oracle SQL, Oracle PL/SQL, SQL Developer, Oracle Data ware house concepts, Datastage, Toad, Java Application, Java EJBs, Eclipse
Contribution:

  • Understanding the architecture of the systems related to SPINCO and RETAINCO to design, develop, and implement the SPINCO systems.
  • SpinCo – SUNLDAP – Update with an attribute. As a part of SSO/Portal system requirement,
  • need to update the SUNLDAP with vzcspinco attribute with a value of FTW.
  • Identify the tables based on .com/.net/dne/dnr/dns category and segregate the data in 5 data bases.
  • Involved in designing the strategy for all databases related to VIPR/UP in RetainCo environment will be segregated based on the user list (VZ ID, BAN) provided by SSP (.NET and DNE/DNR/DNS users) and also the user list (USERNAME) provided by eReg (.COM USERS). The SpinCo data will be removed from the tables identified for segregation.
  • RetainCo Environment: Involved in designing the strategy for all databases related to VIPR/UP in RetainCo environment will be segregated based on the user list (VZ ID, BAN) provided by SSP (.NET and DNE/DNR/DNS users) and also the user list (USERNAME) provided by eReg (.COM USERS). The SpinCo data will be removed from the tables identified for segregation.
  • Involved in designing, developing the Database segregation for ISP Provisioning.
  • Involved in testing of the VIPR UP application for Project North.
  • Participated in the business discussions, and designing the Flows for Project North.
  • Involved in analysis on the business flows and providing the solutions adhering to the client’s standards.
  • Was a part of Center of Excellence initiatives POCs on R12 apart from the project assignment.

6. (A) Trade Agreement Act (TAA) for Cisco Systems, Inc., USA

Project Description: As a part of Cisco\'s Service business with Government-US, there are few products (TAA products) that would be identified to be traded. The project therefore is based on trading of these products which fall into TAA (Trade Agreement Act). 
Client: Confidential,San Jose, USA 
Domain: Telecom 
Duration: November 2008- September 2009 
Role: ORACLE APPS DEVELOPER / ORACLE PL/SQL DEVELOPER 
Environment: Oracle Applications 11i (11.5.8), Toad, SQL Plus, PVCS, Kintana, Mercury Quality Center. 
Operating System(s): Windows-XP 
Skills: Oracle 9i, Oracle Reports, PL/SQL, SQL*Plus, TOAD, Oracle Manufacturing – Planning and Scheduling, 
Contribution:

  • Understanding the customer requirements, analysis, design, development and implementation of TAA products into the system
  • Gather and define business requirements, Improve business processes.
  • Involved in development, testing and enhancement of the report – TAA Consumption report for Q2FY09.
  • As a technical lead, participated in status meeting and walkthroughs.
  • Involved in Planning, Implementation, Testing, and Documentation.
  • Involved in the design and development of PL/SQL Reports.
  • Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.
  • Participated in the business discussions and designing the Functional design document and the technical design.
  • Involved in IT testing and was a key resource as a part of business testing
  • Involved in writing test plans and testing the application.
  • Involved in Code Review, Code Walk Through, and Unit Testing.
  • Involved in the migration activities using Kintana and PVCS and Pi-tool (Go-Live activities).
  • Verified that acceptance criteria had been met for all development/modifications, followed and enforced standardized change control procedures to move new interfaces/modifications into/out of production.
  • Involved in Architecture Review meetings in designing reports for the TAA products.
  • Involved in analysis on the gaps in business and providing the solutions adhering to the client’s standards.
  • Designed report tables to store temporary report-processing data, and used by the back-end report-processing program. These tables were very important and they had to be designed as per the requirement of the back-end program to ensure the main requirement of this project - “speed”.
  • Was a part of Center of Excellence initiatives POCs on R12 apart from the project assignment.

(B) AVP Enhancements Project for Cisco Systems, Inc., USA

Project Description: AVP (Automated Vendor Payment) is the Vendor Payment Tool. Cisco outsources the manufacturing to its Contract Manufacturers (CM). AVP systemically identifies and processes purchase agreements for 28 specific class codes and for Product Id level DF transformation fees. The project scope is to enhance the AVP tool. 
Client: Confidential,San Jose, USA 
Domain: Telecom 
Duration: September 2008 to October 2008 
Role: ORACLE APPS BUSINESS ANALYST / ORACLE PL/SQL DEVELOPER 
Environment: Oracle Applications 11i (11.5.8), Toad, PL/SQL Reports, SQL Plus. 
Operating System(s): Windows-XP, Unix 
Skills: Oracle 9i, Oracle Reports, PL/SQL, SQL Plus, TOAD, Oracle Custom Module, Technical Documentation and Analysis documentation. 
Contribution:

  • Involved in providing the analysis on the enhancements of Automated Vendor Payments (AVP) processes, a customized payment tool.
  • Involved in client interaction and understanding business application, business data flow and data elements
  • Involved in Business requirements analysis and standardization
  • Involved in various business discussions and Architecture Review meetings to ensure that the technical solution adheres to the Oracle Architecture standards and Business gaps.
  • Involved in development and testing of DF Exception Report and Recon Report which are key reports for the AVP business users and Cisco’s Contract Manufacturers.
  • Modified existing stored procedures and packages to incorporate effective migration of data from amongst the production, testing, and staging databases.
  • Involved in providing technical and functional analysis on the 13 day buildable backlog report.
  • Participated in status meetings and walkthroughs.
  • Involved in Planning, Implementation, Testing, and Documentation as per AIM Methodology.
  • Actively participated in managing the off-shore team and getting the deliverables from the resources on time.

(C) Synergy Commerce Transformation for Cisco Systems, Inc., USA

Project Description: As part of the evolution of Cisco\'s Service business and the Synergy Commerce Transformation roadmap, SMS3 needs to be migrated to the C3 platform in order to support the retirement of CIBER. 
Client: Confidential,San Jose, USA 
Domain: Telecom 
Duration: April 2008- August 2008 
Role: ORACLE PL/SQL DEVELOPER 
Environment: Oracle Applications 11i (11.5.10), Toad, SQL Plus, Kintana, PVCS, Mercury Quality Center. 
Operating System(s): Windows-XP, UNIX 
Skills: Oracle 9i, PL/SQL, SQL Plus, TOAD, Oracle Install Base, Technical documentation. 
Contribution:

  • Involved in testing and enhancement of interface – SIID Interface.
  • Modified existing stored procedures and packages to incorporate effective migration of data from amongst the production, testing, and staging databases.
  • Also used PVCS to modify the existing pl/sql scripts and to push the new code to the testing databases. The PVCS is mainly used to keep the history of all the code changes that have been made to an original codebase. Also involved in checking in and checking out of the codebase from the SSH serversusing PVCS at the local machine.
  • Integration and implementation of the system, including testing and troubleshooting.
  • Detected and Corrected bugs during system integration and user acceptance testing.
  • Involved in Code Review, Code Walk Through, and Unit Testing.
  • Involved in documentation of User requirements and Testing of developed modules.
  • Participated in the transition and Go-Live activities.

7. Sony Oracle 11i Patch Management Test Automation for Sony Electronics, USA

Project Description: Sony Electronics Inc. has implemented Oracle Applications for its Manufacturing Operations in Mexico and Pittsburgh plants. Sony ISSA team has been periodically applying the patches to fix the issue identified. Whenever a patch is applied we need to perform end to end Testing to make sure if nothing is broken and maintains the basic functionality. The evaluate the patch is working fine as expected , the users need to perform 2-3 rounds of testing for a good number of Test cases which may require functional expertise to test the same. 
Client: Confidential,San Diego, USA 
Domain: Manufacturing 
Role: ORACLE QA ANALYST and ORACLE APPS OM (ORDER MANAGEMENT) CONSULTANT
Duration: Jan 2008 – Apr 2008 
Environment: Oracle Applications 11i (11.5.10), Toad. 
Operating System(s): Windows-XP. 
Skills: Oracle 9i, Oracle Inventory, Oracle Purchasing, Oracle Logistics, Oracle Order Management, Oracle Shipping, Technical documents. 
Contribution

  • Involved in preparation of test cases of all the Manufacturing modules
  • Validated the functional flows for various modules of Oracle Inventory, Oracle Order Management, Oracle Purchasing, and Oracle Shipping.
  • Developed test plan, test cases and test scripts to thoroughly test the Oracle Applications.
  • Involved in preparing the test data for the test cases for the automation team.
  • Create end-user documentation to provide training to end users
  • Played a key role in bridging the gap between the testing team and Oracle Business.
  • Involved in client interaction and understanding business application, business data flow and data elements

8. NEO (Noble Energy Online)

Project Description: Noble Energy is a leading global oil and gas exploration and production company. As the part of the project, Noble Energy\'s legacy system has to be integrated with their legacy systems (Quorum, AS400, Kofax, etc.,) and to develop an integrated platform for all the reporting and Customer Data Hub (CDH). Noble Energy’s outstanding portfolio of international projects represents a clear growth path for several years to come. 
Client: Confidential,Texas 
Duration: Aug 2006 – Dec 2007 
Role: ORACLE PL/SQL DEVELOPER , ORACLE SOA CONSULTANT
Environment 
Oracle BPEL JDeveloper, Oracle Applications11i (11.5.10), Oracle 10g, Toad, Discoverer Reports Developer, SQL Developer. 
Operating System(s): AS/400, Windows-XP 
Skills: Oracle 9i, Oracle 10g, Oracle Reports, PL/SQL, SQL * LOADER, SQL Plus, TOAD, Business Process Execution Language (BPEL), OSB, Web Service Definition Language (WSDL), OracleFinancialsAsset Management, Finance, CRM modules,Technical Documentation, SQL/400, XML, XSLT, Oil and Gas Plants 
Contribution

  • Involved in designing the Technical design documents for the business requirements.
  • Involved in the development and testing of Discoverer reports
  • Involved in the development of Discoverer report and XML Publisher Reports.
  • Involved in creating interfaces using PL/SQL and designing the concurrent programs in Oracle.
  • Involved in installing the BPEL server and the designer.
  • Developed BPEL projects to integrate 13 legacy systems to Oracle Applications.
  • Responsible for 25 integrated components from legacy systems to Oracle applications using
  • BPEL JDeveloper.
  • Involved in designing the POCs to the client.
  • Involved in designing, development and testing of Interfaces using BPEL JDeveloper.
  • Won BUILD award at EAS Practice level at Wipro Technologies for significant achievement in competency building, delivery and adhering to the quality initiatives.
  • Involved in project Quality Assurance Review interviews.
  • Involved in providing training on the BPEL and Fusion Middleware suite.
  • Involved in creating end-user documentation to provide training to end users.
  • Involved in adhering to the Oracle On-demand quality standards.
  • Created schemas, tables, views and appropriate indexes on table columns at database level.
  • Imported data from text files using SQL* Loader into oracle database tables.
  • Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
  • Verified that acceptance criteria had been met for all development/modifications, followed and enforced standardized change control procedures to move new interfaces/modifications into/out of production.

9. Sony MP TV Planning Project

Project Description: Sony Manufacturing Plant Planning Project team has designed, developed and customized forms and repots in Oracle Applications 11i. The solution is intended to enhance the requirements of Sony Electronics Limited. 
Client: Confidential,San Diego, USA 
Duration: Apr 2006 - Jul 2006 
Domain: Manufacturing 
Role: ORACLE PL/SQL DEVELOPER 
Environment: Oracle Applications 11i (11.5.10), Toad, Developer 2000 Reports 6i, PVCS, SQL Plus. 
Operating System(s): Windows-XP, UNIX. 
Skills: Oracle Database 10g, Developer 2000, SQL*Plus, Oracle Manufacturing, Inventory, SQL/400, Citrix Web Interface, Manufacturing. 
Contribution

  • Involved in the design and development and enhancements of and Reports using D2k
  • Involved in writing complex queries to generate reports as per client request
  • Involved in developing and customization of D2K Reports 6i for Sony Electronics Limited in Oracle Applications 11i.
  • Involved in performance fine-tuning of the queries for the reports.
  • 10. COLT Content Development
  • Project Description: STT is Kaplan IT Learning\'s suite of Enterprise Application Training solutions. Our team has developed the training material for COLT specific Oracle Applications 11i using STT to Create and Manage Simulations, Documentation & Demos.
  • Client: Confidential,UK
  • Duration: Dec 2005 - Mar 2006
  • Domain: Manufacturing
  • Role: ORACLE APPS MFG / OM (ORDER MANAGEMENT) CONSULTANT
  • Operating System(s): Windows-XP
  • Skills: Oracle Applications 11i (11.5.9) Inventory, Order Management, BOM, Shipping, ASCP), Oracle Logistics.
  • Environment: Oracle Applications 11i, STT Tool.
  • Contribution:
  • Involved in developing training material for various Oracle Applications 11i modules of Inventory, Order Management, BOM, Shipping, ASCP modules.
  • Involved in understanding the Oracle functional flows of our client and their custom modules and providing the training material.
  • Participated in acquiring hands-on experience on the STT tool.
  • Involved in creating the end-user documentation to provide training to end users

11. RMS (Returns Management Solution) – Center of Excellence Initiative

Project Description: In \'point solutions\' designed by centre of excellence, our team has developed a Return Management Solution. The solution is intended to enhance the Reverse Logistics business process by automating key business flows, enabling online access to information for all stakeholders and streamline integrated business processes within the organization. 
Client: Confidential 
Role: ORACLE APPS DEVELOPER 
Duration: Oct 2005 – Feb 2006 
Operating System: Windows-XP 
Skills: Oracle 8i, Oracle Workflow, Solutions Management 
Environment: Oracle Applications 11i (11.5.10) (Inventory, Order Management, Installed Base, Field Services, Depot Repair, BOM, WIP, Purchasing, Spares Management, Account Payables, Account Receivables), SQL. 
Contribution

  • Master module consists of Depot Repair and Order Management.
  • Involved in Oracle Apps setups for Depot Repair, Order Management and Inventory modules in Oracle applications 11i (11.5.10).
  • Involved in developing a Workflow Process to send the notifications based on the Business Event and Service Request Status.

12. APPSHHUB – Center of Excellence Initiative

Project Description: APPSHHUB replaces the existing Excel Sheet for capturing the employee details using the Oracle Applications 11i (11.5.10) custom module. 
Client: Confidential 
Duration: JAN 2003 - Sep 2005 
Role: ORACLE FORMS & REPORTS DEVELOPER 
Operating System: Windows-XP 
Skills: SQL 
Environment: Oracle forms 6i, Oracle Reports 6i, Discoverer Reports. 
Contribution:

  • Involved in developing Oracle D2K Forms
  • Involved in developing Oracle D2K Reports
  • Involved in developing Oracle Discoverer Reports
  • Involved in developing Oracle Workflow for necessary notifications and approval process.
  • Produced documentation of Forms and Reports.
  • Involved in Acceptance testing of the various applications.
  • Participated in status meeting and walkthroughs.
  • Involved in Code Review, Code Walk Through, and Unit Testing.
  • Also performed unit testing and integration testing for various development applications.

We'd love your feedback!