Post on 14-Feb-2017
Embed Size (px)
E-mail Address: [email protected]
Mobile: (0) 98853 07204OBJECTIVE
Oracle E-Business Suite: Oracle Applications Technical Consultant with 8+ years of experience in development, testing, and deployment of custom reports, forms, BI(XML) Publisher and workflows. Having 2 years of experience in Oracle D2K (PL/SQL, Forms6i and Reports6i)SUMMARY
Expertise in Oracle Technologies: SQL, PL/SQL, Forms9i, Reports9i/10g, Oracle Applications Technical (AOL), BI (XML) Publisher and Oracle Alerts. Extensive experience in analysis, design, development, customization, implementation and testing Oracle Applications. Expertise in Oracle E-Business Suite:22.214.171.124/12.0.6/12.1.3 on AOL (Application Object Library) and SCM Modules: Inventory, Purchasing (PO) and Order Management (OM) and OPM Modules: GMD,GME,GMF and GMI. Service Contracts Module. For Oracle Quoting (ASO) module, designed and Developed Reports in Oracle Applications and also migrated the data from Oracle applications database to Datawarehouse using Informatica tool. Experience in development and implementation of RICE Components: Reports, Forms, Interfaces and Conversions.
Supported for a Qlick View project with Oracle scripts. Experience with Sales Orders, Purchase Orders, Invoices, Order-To-Cash(O2C) and Procure-To-Pay(P2P) cycles.
Good understanding and working experience with Oracle AIM Documents for Module Design and Build MD  , MD , MD  and BR  Good Team player with excellent interpersonal and problem solving skills.EMPLOYMENT HISTORY
1. Triniti Advanced Software Pvt. Ltd. Hyderabad : May-2015 to Till Date.2. J2LOGIX INDIA Pvt. Ltd., Bangalore : July-2014 to April-2015 . --Contract for One Year.3. Wipro Technologies, Bangalore : Jan-2014 to June-2014 . --Contract for Six Months4. Noetix Software India Pvt. Ltd., Hyderabad. www.noetix.com - July 2007 to June-2013.5. Liquid Hub India Pvt. Ltd., Hyderabad. www.liquidhub.com March 2006 to June 2007.6. Sierra Atlantic Software Solution Pvt. Ltd., (Current HITACHI). Hyderabad www.hitachi.co.in February 2004 to February 2006.EDUCATION
MCA (Master of Computer Applications) from Madras University.PROJECTS SUMMARY
Project 1COMPANYTriniti Advanced Software Pvt. Ltd.
ClientSunPower Corporation, USA
DurationMay 2015 Till Date
RoleOracle Applications Technical Consultant
Oracle Applications R12 (12.1.3): Purchasing and Order-Management Modules.
Project Description: SunPower has been leading global solar innovation. SunPowersolar panelsconsistently deliver more energy and long-term peace of mind with the highest performing solar power systems available. SunPower is the solar energy choice of more homeowners and businesses around the world.Key Responsibilities:
Scoping , Requirement gathering, Gap Analysis. Complete Design & Implementation of Procure to Pay (P2P) and Order to Cash (O2C)) including Oracle-Projects with Business presentations.
Solution Design, Development and End to End testing to map P2P and O2C process cycles in Oracle ERP as per business requirement. Map existing data in legacy ERP to Oracle. Validating the converted Legacy data, Form-Personalization, Reports. Project 2COMPANYJ2LOGIX INDIA Pvt, Limited.
ClientCalix Technologies, USA www.calix.com
DurationJuly 2014 April-2015
Oracle Applications R12 (12.1.3): Service Contracts andOrder Management. Conversions, Alerts and Oracle Discoverer Reports.
Project Description: Calix is a leading global provider of broadband communications access systems and software. The Calix Unified Access portfolio allows service providers to connect to their residential and business subscribers and deploy virtually any service over fiber- and copper-based network architectures. Key Responsibilities:
Worked on Data Conversion: Loading the data in a staging table and running couple of concurrent programs to create Subscription Orders and RMA orders.
Customized Discoverer Reports like CAP_ST_LT_Revenue_Report Prepared Project Deliverable documents like MD70.
Currently migrating the code from UAT instance to Production instance by coordinating with DBA team.
Project 3COMPANYWipro Technologies, Bangalore.
ClientSeagate Technology LLC. www.seagate.com
DurationJan 2014 June 2014
Oracle Applications R12 (12.1.3): Customer Data Hub (CDH) and Order Management.
Project Description: This is an upgrade project in Oracle E-Business Suite from: 126.96.36.199 to R12.1.3. It includes migration and customization of various modules in Financials and Manufacturing. Seagate has its own custom package : Master- Slave, which creates new customers and also modifies the data for existing customers. Any change required for a customer will be done at one operating unit which is called as Master Operating Unit and once the Master Slave Concurrent program runs the modified data will be reflected in all Operating Units (Slave Operating Units) for the same customer.Key Responsibilities:
Prepared a setup document for Customer Master. Understood the process of Master Slave concept. Implemented new functionality to the existing process. Defined Value sets.
Unit testing is done as per the test cases. Prepared Technical Design document as per Seagate standards.Project 4COMPANYNoetix Software India Pvt. Ltd
ClientBoart Longyear, USA URL: www.boartlongyear.com
DurationNov 2011 June-2013
Oracle Applications R12(12.1.3) : Inventory, Purchasing and Order Management. BI(XML) Publisher, Reports 10g(RDF) and Workflows.
Project Description: This project is Oracle E-Business Suite Release 12.1.3 implementation focused on manufacturing modules. As part of Mid-West region and Eastern Region implementation and migration, we have customized and developed reports in Inventory, Purchasing Order(PO) and Order Management(OM). Key Responsibilities:
Developed and Customized Reports as per the client requirement.
Worked on BI(XML) Publisher reports using RDF and Data Template.
Prepared SQL Loader scripts and PL/SQL programs for inbound interfaces.
Created PL/SQL Packages, Procedures, and Functions for data population and updated as per project requirements. Prepared Technical Design documents. (MD70)
Project 5COMPANYNoetix Software India Pvt. Ltd
ClientQUALCOMM, USA www.qualcomm.com
DurationJan 2010 Oct 2011
Oracle Applications R12(12.0.6) , XML Publisher and Reports 10g(RDF)Informatica 6.0.1
Project Description: As part of Noetix product, Oracle Quoting module was developed in both Oracle Applications and Data Warehouse. Developed complete technical architecture including the Extraction, Transformation, Storage and Data Access method .Key Responsibilities for Oracle Technologies/Data warehouse Developed and Customized of Reports as per the client requirement.
Worked on XML Publisher reports using RDF and Data Template.
Created PL/SQL Packages, Procedures, and Functions for data population and updated as per project requirements. Imported data from Oracle EBS to ODS(Operational Data Source) and from ODS to DM(Data Mart)
Developed OBIEE reports using DM as source.
Generated effective reports in OBIEE using formulae, sections, breaks, alerters, and filters.
Project 6COMPANYNoetix Software India Pvt. Ltd
ClientEMERSON, Mohali www.emerson.com
DurationJuly 2007 Dec 2009
Oracle Applications R12(12.0.6) : Inventory, Purchasing and Order Management. TOAD, XML Publisher, Discoverer and Reports 6i
Project Description: This project is Oracle E-Business Suite Release 12.0.6 implementation focused on manufacturing modules for the client : Emerson, at Mohali. This company combines industry knowledge, manufacturing expertise, and technological innovation to offer a broad portfolio of products and services to their customers across a wide range of industries. Customized and developed new reports in Inventory, Purchasing and Order Management. Key Responsibilities: Purchase Orders Import, AP Invoices Import, Sales Order Import, Price List import and Vendors Import.
Analyzed the functional specification document, identified interface tables to be used and columns to be populated in the interface tables.
Extracted data from legacy system. and uploaded the data from Data file into staging table.
Identified the standard program to be used to populate the data into oracle base tables from interface tables.
Worked on Order Confirmation Report and Purchase Order Report, Consignment Stock Report, Delivery Note Report and OM Pick list report.
Project 7COMPANYLiquid Hub Inc. Hyderabad
ClientTeva Pharmaceuticals., USA URL: www.tevapharm.com
DurationMarch 2006 June 2007
Oracle Applications 11i(188.8.131.52): OPM ModulesGMD,GME,GMF,GMI, TOAD, Discoverer and Reports 6i
Project Description: This is an Oracle Applications implementation Project. Oracle Applications 184.108.40.206 is implemented to cover the business of client. Implemented OPM modules. This company is a global pharmaceutical company specializing in the development, production and marketing of generic and proprietary branded pharmaceuticals as well as active pharmaceutical ingredients.
Developed and validated RDF reports for OPM: GMD,GME,GMF and GMI Involved in development of reports based on business requirements and registered them in Oracle applications. Defined value sets, concurrent programs, request sets, PL/SQL Procedures, and Packages. Involved in the development of interfaces to import the data from legacy system into oracle application base tables. Worked on UTL_PACKAGE and SQL*LOADER for the interfaces.Project -8COMPANYSierra Atlantic. Hyderabad
ClientGreaves Ltd. Chennai.
DurationFeb-2004 - Feb 2006
D2K(Forms6i and Reports6i)
Project Description:This Product was developed for Greaves Ltd., (owned by Thapar Group of Companies), India's leading manufacturer of diesel (LEU) and petrol (PEU) engines in India. They have 25 sales branches and 3 factories spread all over India.
Key Responsibilities: Receiving orders from the customers and branches.
Scheduling the orders and dispatching the orders based on stock and preparing delivery note and invoices for the orders.
Developed reports like pending orders, dispatches made, invoice amounts, sales tax, excise duty, Branch wise, customer wise and item wise and pre printed reports for invoice and delivery note printing.