Harikrishna yaddanapudi

7
HARIKRISHNA YADDANAPUDI E-mail Address: [email protected] Mobile: (0) 98853 07204 OBJECTIVE 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:11.5.10.2/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 [050] , MD [070], MD [120] and BR [100] Good Team player with excellent interpersonal and problem solving skills.

Transcript of Harikrishna yaddanapudi

Page 1: Harikrishna yaddanapudi

HARIKRISHNA YADDANAPUDI

E-mail Address: [email protected] Mobile: (0) 98853 07204

OBJECTIVE

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:11.5.10.2/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 [050] , MD [070], MD [120] and BR [100] 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.

Page 2: Harikrishna yaddanapudi

PROJECTS SUMMARY

Project – 1COMPANY Triniti Advanced Software Pvt. Ltd.Client SunPower Corporation, USADuration May 2015 – Till Date Team Size 6Role Oracle Applications Technical ConsultantEnvironment Oracle Applications R12 (12.1.3): Purchasing and Order-Management

Modules.

Project Description: SunPower has been leading global solar innovation. SunPower solar panels consistently 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 – 2COMPANY J2LOGIX INDIA Pvt, Limited.Client Calix Technologies, USA www.calix.comDuration July 2014 – April-2015Team Size 10Role Team coordinatorEnvironment Oracle Applications R12 (12.1.3): Service Contracts and

Order 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.

Page 3: Harikrishna yaddanapudi

Project – 3COMPANY Wipro Technologies, Bangalore. Client Seagate Technology LLC. www.seagate.comDuration Jan 2014 – June 2014 Team Size 8Role Project CoordinatorEnvironment 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: 11.5.10.2 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 – 4COMPANY Noetix Software India Pvt. Ltd Client Boart Longyear, USA – URL: www.boartlongyear.comDuration Nov 2011 – June-2013 Team Size 14Role Team LeadEnvironment 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 – 5

Page 4: Harikrishna yaddanapudi

COMPANY Noetix Software India Pvt. Ltd Client QUALCOMM, USA www.qualcomm.com Duration Jan 2010 – Oct 2011Team Size 10Role Team memberEnvironment 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 – 6COMPANY Noetix Software India Pvt. Ltd Client EMERSON, Mohali www.emerson.comDuration July 2007 – Dec 2009Team Size 20Environment 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.

Page 5: Harikrishna yaddanapudi

Worked on Order Confirmation Report and Purchase Order Report, Consignment Stock Report, Delivery Note Report and OM Pick list report.

Project – 7COMPANY Liquid Hub Inc. HyderabadClient Teva Pharmaceuticals., USA – URL: www.tevapharm.comRole Team Member.Duration March 2006 – June 2007 Team Size 10Role Team memberEnvironment Oracle Applications 11i(11.5.10.2): OPM Modules–GMD,GME,GMF,GMI,

TOAD, Discoverer and Reports 6i

Project Description: This is an Oracle Applications implementation Project. Oracle Applications 11.5.10.2 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.

Key Responsibilities: 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 -8COMPANY Sierra Atlantic. HyderabadClient Greaves Ltd. Chennai.Role Team Member Duration Feb-2004 - Feb 2006Team Size 15Environment 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.

Page 6: Harikrishna yaddanapudi

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.