Summary

• Over 8 years of IT experience and 6 years of experience in Oracle E - Business Suite (11.5.7, 11.5.8, 11.5.9, 11.5.10, R12 andFusion) as a Techno-Functional Consultant with expertise in Oracle Supply Chain (SCM) module implementation, interface customization and development including the recent Fusion modules.
• Extensive experience on Oracle Forms 6i, Reports 6i, Oracle Applications Framework (OA Framework) Oracle 8/9i, SQL* Plus, PL/SQL, AOL, XML Publisher
• Hands on experience in Java/J2EE Architecture, Oracle Fusion Middleware, ADF BC & ADF UI - Application Development Framework Business Components and Application Development Framework User Interfaces, SOA - Service Oriented Architecture, WS - Web Services, OWSM - Oracle Web Services Manager, BPEL - Business Process Execution Language, ESB - Enterprise Service Bus, BPM - Business Process Manager, BAM - Business Activity Monitoring and Adapters.
• Experience in Developing, Customizing, Maintaining and Supporting Oracle Applications version 11.5.7, 11.5.8, 11.5.9, 11.5.10, R12 (Inventory - INV, Warehouse Management System - WMS, Work-In-Process - WIP, Bill Of Materials - BOM, Oracle Receiving (RCV: Procure-To-Pay), Oracle Order Management (OM: Order-To-Cash), Oracle Shipping - WSH, Workflow and System Admin.) and Oracle Fusion
• In-depth knowledge of Oracle Applications Inventory (INV), Warehouse Management System (WMS), Work-In-Process (WIP) and the underlying tables that support the application modules.
• Proven skills in implementation of Software Applications, developing & customizing Oracle forms and Reports in Oracle Applications using Forms 6i and Reports 6i respectively and Creating reports in XML Publisher using RTF Templates.
• Gathered expertise in ERP applications assessment, analyzing business requirement, creating functional and technical specifications, articulating application architecture and design, managing technology delivery, leading and coordinating discussions with development resources, customers and functional managers through full software development cycle
• Proficient in Designing Relational Data Structures, writing Stored Procedures, Packages and Functions using PL/SQL, SQL and Java
• Technical activities includes identifying functional and technical gaps, work estimate, architecting system interactions, designing custom solutions, programming, scheduling, documenting and providing production support.
• Proficient in Technical Analysis and testing of new development and customization of existing systems involving Techno-Functional expertise in different modules of Oracle ERP.
• Have good knowledge and experience in project planning, tracking deliverables, execution, testing and deployment.
• Focused functional and technical documentation skills.
• Exposure to different roles ranging from Functional consulting to Technical roles to conducting E-Business Suite Trainings.
• Have a complete exposure to Product Development Lifecycle (SDLC) and the various stages through which product goes through while in development, testing and maintenance.
• Worked in Release V 1.0 of Oracle Fusion in developing the complete UOM Setup module in Inventory and creating functional and technical specs for the same.
• Excellent learning skills and ability to adapt quickly to rapidly changing/new technologies.
• Ready to take the challenges with a Positive attitude and dedication towards the task in hand
• Strong analytical, problem solving, communication and presentation skills. A very good team player

Technology Expertise:

Programming: PL/SQL, Java, Swings, JSP, UNIX shell script, XML, XSL, XSLT, HTML and SAX & DOM Parsers.

Oracle Applications: Oracle Application (Oracle Manufacturing modules - INV, WMS, WSH, OM, BOM and WIP) in 11.5.7, 11.5.8, 11.5.9, 11.5.10, R12 and Fusion Development

Oracle Tools: SQL Navigator, Toad, SQL* plus, JDeveloper,Oracle Developer 2000 (Forms 6i and Reports 6i), XML Publisher, Oracle Fusion Middleware, SOA, Web Services, OWSM, BPEL, ESB, BPM, BAM and Adapters.

Oracle Frameworks: OAF - Oracle Applications Framework, ADF BC and UI - Application Development Framework Business Components and User Interface

Operating Systems: Windows XP/2000/NT/98, Red Hat Linux 7.3, UNIX and Solaris.

Database: Oracle 8i/9i/10G, MS-SQL Server, Postgres and Sybase

Documentation: BRD (Business Requirement Document), FUD (Functional Uptake Document), FSA (Functional Solution Approach), FDD (Functional Design Document), TUD (Technical Uptake Document), TSA (Technical Solution Approach), TDD (Technical Design Document), STP (Software Test Plan), and STR (Software Test Report)

Testing: JUnit, Test Plans, Test cases and Unit testing

Prototyping: Microsoft Visio and Dreamweaver Rapid Prototyping Environment tool

Professional Experience:

Confidential

Title: Oracle Fusion Middleware Consultant

Project: Oracle EBS - Servigistics Integration.

Client: ThyssenKrupp Elevator, Atlanta, Georgia.

Duration:

Project Description:

Functionalities implemented for the Project:

• Integration from EBS to Servigistics (Outbound Integration) via various BPEL services to handle creation and modification of various business entities like Facilities, Customers, Products, Contracts, Employees and Service Requests (SRs).
• Integrated the outbound BPEL services with the JMS Queue at the Servigistics side.
• Create DB CHANGE NOTIFICATIONS on respective DB objects to invoke BPEL service directly from the DB.
• EBS with SoundNet Integration (Outbound) via BPEL services and handling the acknowledgements.
• Integration from Servigistcs to EBS (Inbound Integration) via a specific BPEL service to handle Service Requests.
• Provide integration with Dexterra for synchronization.
• Logging appropriate errors and invoking callback procedure to address the errors logged.
• Provide scheduler support for batch processing of records

Responsibilities:

• Provide architectural suggestions to integrate the involved systems efficiently using Oracle Fusion Tools.
• Communicated with different vendors involved and gathered the requirements.
• Create initial working prototype with various systems involved
• Create necessary data model for the entities.
• Create and maintain MD50 and MD70 documents.
• Design and development of code components
• Communicate with other team members and review the code developed by them.
• Integrate the code and do a complete flow testing
• Reworked on areas which required modification from new requirements
• Provide the complete test plan
• Creating deployment scripts and migration from development to production system
• Monitor the process status and handle and exceptions

Environment: Oracle11.5.10 (FIN, INV, WMS, OM, WSH), Web Services, Oracle Fusion Middleware technologies like BPEL, OWSM, OA Adapters, JMS Queue, Oracle 10g database and PL/SQL.

Confidential

Title: Technical Analyst - Oracle Technical Consultant

Project: FedEx Shipments Reconciliation.

Client: Confidential, Fort Worth, Texas.

Duration:

Project Description:

Confidential, is a premier provider of third party logistics and supply chain services for high-velocity, high-tech devices, in addition to other equipment and components. Industry focus includes wireless, broadband, electronics, medical, industrial and automotive. ATCLE is an 11.5.8 customer with INV, WSH, OM, FIN and other modules of Oracle Apps. ATC has tie-ups with FedEx, UPS and other third party logistics for shipment and delivery. Due to expansion in business, the customer was in need of a better reconciliation process that will strengthen internal controls for accurately stating their freight liability position on a monthly basis as well as increase their ability to detect freight related errors.

Functionalities implemented for the Project:

• Automated the process to upload the invoice information (Data migration) from the FedEx server to Oracle database.
• Customize the code that will manifest the shipping information and generate respective labels.
• Modified the warranty claims process that will collect the necessary details for reconciliation
• Generate different reconciliation reports based on business requirements
• Generate preliminary receipt report during the item receiving process

Responsibilities:

• As a Technical Analyst, I was involved in analyzing change requests and proposing suitable recommendations for addressing the requirements
• Initiate communication between business and the technical team involved to resolve any open issues
• Writing technical spec document, Unit test cases and implementation process document
• Coded and implemented the proposed design using Oracle technologies involving Oracle Forms 6i, Reports 6i, PL/SQL and SQL Loader
• Performed developer test cases and provided necessary documentation and support during User Acceptance Testing (UAT)
• Provide necessary post-production support

Environment: Oracle11.5.8 (INV, WMS, OM, WSH), Oracle Forms 6i, Reports 6i, PL/SQL, SQL Loader.

Confidential

Title: Programmer Analyst - Oracle Fusion Consultant

Project: Kyphon-Siebel Integration

Client: Confidential, Minneapolis, Minnesota.

Duration: Jly

Project Description:

Functionalities implemented for the Project:

• Utilized Siebel web services (from Medtronic side) to provide a generic demographic based search for Kyphon system. Utilized the pagination feature in Siebel to control the retrieval of number of records so as to enhance performance.
• Provided functionality to perform multiple CSN (Customer Service Number) search in a single shot
• Insert a new contact into Siebel system
• Update an existing contact

Responsibilities:

• As a Technical Consultant, I was involved in reviewing functional design, writing technical spec document, coding and implementing the proposed design using Oracle Fusion Middleware suite, unit testing, Integration testing, performance monitoring and production support cum maintenance.
• Acted as a technical mediator between Kyphon team and Medtronic team to convey the design gaps and address any issues
• Involved in functional phase to map the requirements and provided analysis and feedback on the design
• Created the Technical Spec document and presented it to the technical architecture team for approval
• Code the BPEL and ESB logic and integrated it with both the systems
• Created exhaustive test case document and reviewed the performance of the system designed
• Address any issues that may arise during deployment to production and provide necessary support during go-live

Environment: JDeveloper, Oracle Fusion Middleware, Web Services, BPEL, ESB, Siebel CRM (Life Sciences module), Oracle 10G and Windows NT

Confidential

Title: Project Leader - ERP

Project: Units of Measure Setup in Fusion V1

Client: Confidential

Duration:

Project Description:

Design, Implement and Migrate the existing UOM Setup screens in INV to Oracle Fusion: This is a setup project to convert the UOM setup screens from FORMS to Oracle FUSION technology stack. These setup screens are very much required for the Inventory and Warehouse Management System products to be fully functional and therefore are considered high profile. Other products also require the information that will be setup using these screens. This module was completely designed using Oracle SOA Suite, ADF BC and ADF UI, BC4J, Web Services, PLSQL APIs and Public APIs as Web Services etc.

Functionalities implemented for the Project:

• Define Units of Measure (UOM) Classes
• Define Units of Measures
• Define UOM Conversions
• Define Lot Inter-class Item UOM Conversions

As a Project Leader, I was involved in communication with Product Management, SMEs, technical architecture team at Oracle Corporation and various customers on progress of the implementation and issues they are facing. This will help all the customers across the globe to implement the solution in a very easy and user friendly way.

Responsibilities:

• Responsible for the complete UOM Setup functionality in Fusion V1
• Coordinate between the IT team of various customers and Oracle team on the implementation issues
• Came up with a new and very user-friendly design that will help the customers to perform the setup very easily
• Enhance the existing solution as per customer requirement for above-mentioned areas
• Creating design documents for above-mentioned areas. Take forward the design documents for development and complete them in time. Development includes 6 Oracle ADF screens, Backend components and necessary APIs
• The solution developed works for English and other supported languages
• Coordinated with the local team and monitored the project phases
• Coordinated/communicated with the documentation specialists to document the changes incorporated
• Modified the Data Model as per the Fusion standards.
• Creation of ADF Business Components (Entity Objects - EOs, Entity Associations, Entity-Level Accessors, View Objects - VOs, View Accessors VAs, View Links VLs and Validation VVOs) for respective entities.
• Creating user interface for the complete UOM Setup using ADF UI.
• Created web services for UOM BC for cross-pillar invocation
• Deploying, testing (Unit and Integration testing) and integrating various flows in the UOM Setup.

Environment: Oracle Fusion Middleware, JSF, ADF BC & UI, BPEL, WS, ESB, PL/SQL, SQL, Oracle 10G, Linux/Windows and JDeveloper

Confidential

Title: Project Leader - ERP

Project: Labor Management System - R12

Client: Confidential

Duration:

Project Description:

This project was undertaken to in corporate a new functionality/product to the R12 Release of Oracle Applications. The most striking feature of this product is its ability to track labor and resources. Labor costs constitute a major portion of the operating expenses in a distribution center. Warehouse managers need a system to log user performance, accurately measure how much work has been completed and is left to complete, and reward employees accordingly.

The Oracle Labor Management feature provides valuable analytics that will help distribution managers optimize their resources. This feature allows you to view the amount of time that specific events within the warehouse would take, as well as define a benchmark for employees to strive for in terms of productivity. Engineered Labor Standards (ELS) benchmarks can be set by the distribution manager. This feature will compare the deviation of the actual productivity versus the expected productivity for individuals and groups of work. It will allow the warehouse manager to compare expected to actual times taken to perform work, forecast the amount of labor required and optimize labor usage.

Functionalities implemented for the Project:

• Expected resource/time requirements analysis report generation
• Labor Productivity analysis report generation
• Register the Concurrent programs and in applications through System Administration and make them available to respective responsibilities
• Integrated with Oracle Workflow for sending notifications
• Generating chart based statistics for value added metrics

As a Senior Applications Engineer, I was involved in

• Studying the industry and gathered necessary requirements on how the product should be designed
• Interacting with various customers and product management team and came up with the functional design
• Coordinating with other members on Project planning that includes scheduling and assigning. Tracking status of the tasks
• Creating and reviewing the design documents
• Coding for my module and unit testing it
• Integration testing of various modules within the product
• System Testing

Responsibilities:

• Analyze/understand the existing tools available in the market and came up with a strategy for development
• Divided the screens amongst team members based on functionality
• Created the Functional and Technical design documents
• Created the Industry data for testing various flows of the product.
• Created tools for migrating the test date from one instance to another instance
• Created various prototype that convincing to various customers and the product management
• OA Coding (Business components, Creation of User Interface, page common regions and UI widgets)
• Creating charts (using OA Charts Components) for reporting purpose
• Creation of printable reports using XML Publisher (by using RTF templates) and report generation in various formats like PDF, RTF and MS Word etc.
• Testing of my modules and the modules developed by other members
• Integrating the page flows

Environment: Oracle Applications R12, PL/SQL, SQL, Oracle 10.1.2, Oracle Applications (OA) Framework, XML Publisher, Linux/Windows and JDeveloper.

Oracle Corp Title: Senior Applications Engineer - ERP Project: Customizable Labels for Release 11.5.10 2CU and R12

Client: Confidential

Duration:

Project Description:

This project provides an enhancement to the existing Label Printing architecture and will leverage the current Label Printing functionality to print label fields (a.k.a Industry attributes) on the flight. The attributes that are seen on any label generated from Oracle Applications are hard coded in the system. When customers need new industry attributes, they have a wait for the development team to create it for them and this process takes a considerable time span. Now with this feature, it gives the customer a facility to create an industry attribute using dynamic SQLs that can be instantaneously used within the label with minor code modifications. The result of the SQL will be added to the labels during label generation. This gives the customer a lead over time when it comes to creating a new industry attribute for their requirement.

As the lead for this project, I was solely responsible for coordinating/leading the project. I was involved with requirement gathering, Functional and Technical design, Coding, Unit Testing and Integration with the existing Oracle Applications. The project was complete well ahead of time and won many appreciations.

Functionalities implemented for the Project:

• Created User Interface in Forms 6i for creating Custom SQLs and integrated it with Oracle Applications
• Created a PL/SQL package to handle Inert/Update/Delete operations and validations
• Modified relevant Forms to include this functionality

Responsibilities:

• Studying the industry requirement for the need of this functionality and how it can be addressed
• Analyze/understand the existing Label Printing Architecture in Oracle Applications and provide a easy way to integrate the new functionality without affecting the existing functionality
• Creating the design document, which indicates how the data will be converted/mapped to the current architecture
• Writing an exhaustive test scripts for most of the business flows and validate them in the system
• Create an upgrade scripts that will help the existing customers to migrate to the new system easily
• Developing the User Interface using Forms and PLSQL technology
• Creating the Test plans for complete project covering old and new business flows in the product
• Unit test and Integrate test all the code as per the test plan and update the test report with details of transactions and status of testing

Environment: Oracle Applications 11.5.10 2CU and R12, PL/SQL, SQL, Forms 6i, Oracle 10.1.2, Linux and Windows

Oracle Corp Title: Senior Applications Engineer - ERP Project: Document Sets for Oracle Label Printing

Client: New Age Electronics, Eaton (Brazil), Emerson, Qualcomm

Duration:

Project Description:

This project provides a way to generate and print multiple business documents when needed. Earlier systems allow generation of only one document per business transaction. With this functionality, more than one business document can be created and printed.

Functionalities implemented for the Project:

• Creation a custom Document Set
• Enable and Disable document sets based on business requirement
• Add/Remove a document from existing document set

Responsibilities:

• Studying the existing document generation API
• Do gap analysis and provide necessary estimates
• Create technical design document and necessary test case documents
• Coding using Forms technology, deployment of packages and providing extensions to relevant forms.
• Creating testing documents and performing Unit as well as System Testing

Environment: Oracle Applications 11.5.10 2CU, PL/SQL, Forms 6i, Oracle 10.1.2, Linux and Windows

Confidential

Title: Applications Engineer - ERP

Project: Label Printing Enhancements and Re-architecture

Client:Confidential

Duration:

Project Description:

The aim of this project is to develop/implement extensions to the various label printing features in Oracle Applications.

Functionalities implemented for the Project:

• Incorporating new business flows to the existing label printing functionality
• Created new labels categories catering to changing industry needs
• Proposed initial designs to in corporate RFID into the label architecture
• Creating new modes of label generation
• API changes to enhance to performance
• Creating software tools (Print Server) to test the different modes of label generation, which is not possible otherwise during the development cycle.
• Bug fixes to the existing functionalities

As a developer, I was involved in creation of various features and enhancements for the Label Printing Architecture that was required to address the growing industry needs. As Label Printing functionality was required for other products like Shipping, Process Manufacturing, Work-In-Process etc., integration became a challenge for which architecture was slightly altered to address the issue smoothly. During this period, I have also addressed issues relating with Label Printing at various customer sites.

Responsibilities:

• Analyze/understand the requirements for all the above functionalities and create the technical design documents
• Creating and maintaining the database tables, views, sequences etc.
• Design, create and maintain the APIs, database packages and processes the data to load seed information into different tables
• Creating and maintaining Oracle Forms to capture the setup and transaction information
• Creating a Print Server to verify the labels generated via TCP/IP mode
• Coordinating the activities between functional and technical teams both internally within Oracle and externally with customers
• Address issues that may arise in the system due to various reasons like Upgrade, Migration etc. and provide the solution aptly
• Performance tune the code for huge data and scalability using the performance tools provided by Oracle
• Bug fixing and implement the enhancements to extend the functionality

Environment: Oracle Applications 11.5.7 - R12, Oracle 8i/9i/10G, Oracle Forms 6i, Oracle Reports 6i, SQL, PLSQL, TOAD,Windows and Linux

Confidential

Title: Programmer Analyst

Project: Enterprise Business Application - EBAP

Client: Confidential

Duration:

Project Description:

EBAP is a comprehensive and configurable Order Management and Fulfillment system, which has the ability to use the existing Product Management systems of the client to capture and process orders in addition to its own extensive Product Management features. EBAP is an application suite developed by HTC Global Services, Inc., which enables customers to transit from traditional business to e-Business by providing B2B and B2C layers around their existing Product Management systems.

Responsibilities:

• Created the Technical Design document using the high-level documents provided
• Coding - developed the client side user interface using Forms
• Created the test case document and performed Unit and Integration testing

Environment: Oracle Forms 6i, Oracle Reports 6i, SQL, PLSQL and Oracle 8i on Windows.

Confidential

Title: Programmer Analyst

Project: Bonneville Accounting Software - BAS

Client: Confidential

Duration:

Project Description:

BAS is a reporting tool done for Bell & Howell, USA. It involves creating a report, storing it in database and then retrieving it for editing. It also provides a graphical view of a report. The users can customize their report by defining their own tables and specify relationships between them, selecting the appropriate database fields and also create user-defined expressions.

I was part of 8 member development team and handling the development of user interface and PDF creation modules.

Modules implemented for the Project

• User Interface for the whole product using Java Swings and AWT toolkit
• Created web interface using JSP and Servlets
• PDF report creation using iTEXT plug-in

Responsibilities:

• Understand the requirements given by the customer and come up with a design document
• Developed user interface using Java Swing and integrate it with the backend and other modules. Provide an applet equivalent which enables users to open the application using a browser that supports applets
• Write the database code using Postgres DB
• Write Java Beans to handle different Business logic
• Unit Testing and Integration testing of the solution
• Packaging the product into a JAR file and ship the product to customer on a weekly basis for client testing
• Interacting with the customers via e-mail and conference calls and address issues then and there

Environment: Java SDK 1.4, JFC - Swings, Jboss-3.0.0alpha, Tomcat-4.0.2, JSP, EJB 2.0, XML, POSTGRES and iTEXT (a free PDF Library)