SUMMARY

• Over 10 years of IT experience providing Analysis, Design, Development, Implementation, Business solutions, Production issues support for Onsite and offshore clients.
• Working as a PRINCIPAL APPLICATIONS ENGINEER in Oracle Corporation.
• Currently involved in development and maintenance of EBS Extensions for Endeca for Oracle iProcurement product along with Contract Lifecycle Management (CLM) and XML Gateway under Procurement module of Oracle E - Business Suite.
• Involved in the implementation of iProcurement CLM iProcurement project for Defense Logistics Agency of US Federal Government.
• Helped Citi group in implementing EBS Extensions for Endeca for iProcurement.
• Have strong knowledge in OAF, ADF (Java and J2EE based Frameworks), Endeca Info Discovery, SQL, PL/SQL, Workflows, Java and cXML.
• Have very good experience in developing XML Publisher / BI Publisher Reports.
• Have good understanding on OBIEE and ODI. Used them as part of some integration projects.
• Have strong functional knowledge in SCM and Financial modules with good understanding of Procure to pay and Order to Cash cycles of Supply Chain Management (SCM) with hands on knowledge in Purchasing, iProcurement, iSupplierPortal, Sourcing and Order Management modules of Oracle EBS.
• Having expertise in Integration of ERP products with legacy systems or other ERPs using XML Gateway, BODs and Flat files.
• Have good understanding about the architecture of ERPs Oracle E-Business Suite and Infor ERP LN.
• Have worked over 3 years of strong expertise in Infor ERP LN, Baan IV and Baan 5c in developing customizations in Finance and Logistics modules.
• Expertise in giving internal and external trainings in technical and functional domains.

TECHNICAL SKILLS

ERP: Oracle Applications E-Business Suite 11i and R12Infor ERP LN 6.1, Baan ERP 5.0c, Conversion Adapter (Migration tool)

BI tools: Oracle Endeca Information Discovery, OBIEE, ODI 11g, BI Publisher for Oracle Apps

Environment: Windows 2000/XP/NT/Vista/7, UNIX, Linux and MS-Dos.

RDBMS: Oracle 8/10g, MySQL5.0, SQL Server.

Tools: Clover ETL, Endeca Studio, Oracle Forms, Oracle Workflows, TOAD6.0, EclipseFTP Client, SOAP UI, cXML Gateway, Web services, SQL tools.

Languages: Java, J2EE, SQL, PL/SQL and Baan Tools (4GL & 3 GL).

Framework: Oracle Apps Framework (OAF), Application Development Framework (ADF).

PROFESSIONAL EXPERIENCE

Confidential

Principal Applications Engineer

Responsibilities:

• Involving in design and coding as per the business requirements.
• Preparing data models on Endeca server side to accommodate all the data required for guided search.
• Creating Clover graphs to perform ETL from source EBS system to target Endeca server.
• Defining Endeca views on the server side.
• Working with core Endeca team.
• Providing Data Creation Scripts to create large volume data for performance team.
• Involving in GAP and Impact Analysis for business Requirements.
• Preparing and Executing End to End System Testing and Regression Testing and involve in defect resolution. Coordinating and supporting the Business users during Customer Acceptance Testing.
• Involving in Prototype development in the initial phases of integration.

Confidential

Responsibilities:

• Acting as a single point of contact in Development and taking care of implementation proceedings from offshore.
• Analyzing, Reproducing and fixing of defects.
• Writing Technical designs and developing new enhancements in CLM.
• Getting clarifications from support teams and customers if needed.
• Interacting with Product management team to implement designs and finalize approach for solutions.

Confidential

Responsibilities:

• Analyzed the requirement and prepared Technical design document for it.
• Setup JDeveloper environment for developing the requirement.
• Exploring BI publisher and workflow tools in order to in corporate them into this project.
• Executing tests after development.
• Coordinating with Product management team and QA team for resolving issues.
• Participating in team meetings to update development status.

Confidential

Responsibilities:

• Analyzed the requirement and prepared Technical design document for it.
• Setup JDeveloper environment for developing the requirement.
• Executing tests after development.
• Coordinating with Product management team and QA team for resolving issues.
• Participating in team meetings to update development status.

Confidential

Responsibilities:

• Design and development of product.
• Analyze, reproduce and fix customer reported issues

Confidential

Responsibilities:

• Interacted with business analysts for requirements analysis and to define functional specifications.
• Analyzed reporting requirements and participated in the documentation of Business Requirements.
• Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Performed unit and integration testing of reports and dashboards.

Confidential

Responsibilities:

• Analyzing, Reproducing and fixing of defects.
• Getting clarifications from support teams and customers if needed.
• Developing new XGM maps when needed.
• Single point contact for all the requisition related issues in cXML area.

Confidential

Responsibilities:

• Writing Technical designs, perform coding and coordinating with team members in delivering Enhancements related to the product.
• Analyzing, Reproducing, fixing and reviewing of defects.
• Getting clarifications from support teams and customers if needed.
• Executing tests before releasing solutions.
• Updating defect tracking system which is used to get some reports.
• Participating in team meetings to update the status of the queue.

Confidential

Responsibilities:

• Developed scripts to populate sequential files based on table data in ERP LN and to consume it to create target tables in Oracle Apps.
• Participated in internal team meetings and external vendors like Engineering IT and architects.
• Led the team in accomplishing all the tasks as the project is completely developed onsite at customer’s place.
• Migration from Baan 5 to LN FP3 for Boeing, USA: Boeing has migrated from Baan 5 (Verdi) to ERP LN 6.1 FP3. Wrote migration logic for many tables in Verdi and developed post migration sessions in ERP LN FP3 to migrate and adjust data according to the higher version. Data migration has been done through a Conversion adapter software and export/import of data through files
• Split Work Orders for Frontken, Singapore: Every time an item comes for service, work order will be created in the background along with a maintenance sales order. Maintenance sales order is for to the customer and work order is for tracking the status inside the service floor. If multiple items come for service and part them were already repaired, Frontken wants send the repaired goods in the middle before finishing repair of all the items. To achieve that, the work order has to be split and a new maintenance sales order line will be created for the remaining items.
• Wrong Receipts for Ferrari, Italy: Ferrari sometimes receives goods on a wrong warehouse. The received goods will then be moved to the correct warehouse. In that case, they want to have a transfer order to be created automatically during warehouse receipts process. This transfer order creation and its processing will be taken care automatically without user intervention.
• Cash Flow Statement Reports for Malaysian Transformers, Malaysia: This is an Excel based report developed to print Cash flow structure in a tabular format. Cash flow structure should be defined in a tree structure for this. Here, output is report layout is set by the customer. So, the report has been developed using the background XML structure of the excel sheet.
• Reopened Periods for Invensys Rail Ltd, Australia: Sometimes there would be a need to post transactions in a closed period which is not possible in standard. IRL wants to post some financial transactions in a closed period. For this, they wanted to have authority structure which was defined by their management. Some employees having the authority will be able to post transaction in the closed period. They need to re-close the periods and year after posting.
• Lockbox Preprocessor for Pittsburg Glass Works, USA: Lockbox preprocessor is a way of adjusting all the invoices receipts through bank files. Here bank will send the paid invoice details in a file and the cheques information. We should create unallocated receipts for the cheque amount and assign that to all the invoices in that file. This is a customized version of EBS and Remittance. But here, the whole process of creation of documents and assignments will be done automatically.
• Invoicing for Italian Customers for Planter Filters, Homedics and Astaldi, Italy: All the Italian customizations were handled at customer’s place. This project involves the support for existing customizations and development of new customizations. Also handled many customizations for different customers based on the specification from Italian PSO. This is a generic invoicing report developed for Italian customers according to their legal requirements. This report contains information according to their tax structure. Total invoice report layout has been changed according to their requirement.
• Packing List for ABB Power Systems, Sweden: This customization deals with the generation of handling unit structure for a BOM item based on the criteria given by customer. Handling unit structure will be generated for all the items associated with the BOM structure. This customization will generate a packing slip number automatically for the shipments based on the criteria specified by ABB.Involved in the development of various customizations and support for existing customizations and provided onsite support at go live.
• ERP-Telepro & EPR-WAS Integrations for Tyco, Singapore: This is an integration project which will create an XML file during some times of service order activities. These XMLs will be sent to some interfaces for further processing.

Confidential

Responsibilities:

• Analyzing, Reproducing and fixing of defects.
• Previewing and reviewing the defects.
• Getting clarifications from support teams and customers if needed.
• Executing tests before releasing solutions.
• Updating defect tracking system which is used to get some reports.
• Participating in team meetings to update the status of the queue.
• Worked as a team lead for 4 members here.
• Distributed work and took status updates regularly.