﻿Praveen Arini                                    Mail:praveen.arini@yahoo.com
Mobile: +91 9960899666
Oracle Apps Technical and Oracle Apps MDM Functional Consultant
Summary
Having around 12 years of total IT Experience out of which 5+ Years of experience as Oracle Apps Technical Consultant in design, analysis, development and implementation of various commercial applications in ERP Using Oracle Applications 11i/R12, Oracle 9i/10g And 6+ years of experience as Oracle Apps EBS MDM (Master Data Maintenance) Functional consultant.
Knowledge
Technical: Good Exposure on RICE components in Oracle E-Business Suite R12 like Reports, Forms, Interfaces (inbound and outbound) and conversions.
Functional: Oracle MDM (Master Data Management) setups related to Supplier Master Data Maintenance, Customer Master Data Maintenance Master Data Maintenance and Account Payables.
Having Technical and Functional Knowledge on Purchasing (PO), Account Payables (AP), Inventory (INV), Order Management (OM) and General Ledger (GL).
Good Knowledge on P2P, O2C and other GL Basic Setups.
Good Knowledge on code migration tool SBM( Serena Business Manager)
Good Knowledge in raise SR’s and RFC’s using Oracle Support Portal. 
Extensive experience in AOL concepts by registering Executables, Concurrent Programs, Flex fields, Value sets and etc.
Good programming experience in creating Procedures, Packages, Functions and other database objects using SQL, PL/SQL and advanced plsql concepts. 
Good experience in using tools like SQL Developer, TOAD and SQL*LOADER.
Good Exposure on developing XML Reports and Bursting Reports using the rtf and xls templates.
Good Knowledge on Cloud Application.
Good interpersonal skills, commitment, Zeal to learn new technologies and undertake challenging tasks.
Quick learner and Excellent Team Player, ability to meet Deadlines.
Education and Certifications
Bachelor of Technology from Jnt University.
Diploma from NIIT in Software Engineering.
Oracle Data Integrator ODI 12c Certified Implementation Specialist.
Experience
Worked as System Engineer for IBM India Pvt Ltd from June 2011 to October 2019.
Worked as Senior Technical Consultant for RECVUE India Pvt. Ltd. From December 2019 to November 2021
Working as Software Consultant to Oracle India Pvt Ltd through Payroll of Team lease Digital Pvt Ltd from Jan 2022 to till date.
Project Experience
Vertiv
Oracle Apps Technical Consultant Jan 2022 – Till date
Vertiv is an American, Ohio-based, provider of equipment and services for data centers.
Platinum Equity acquired the Emerson Network Power business from Emerson Electric in a transaction valued in excess of $4 billion, completed in December 2016. Emerson Network Power was rebranded as Vertiv. Emerson also retained a subordinated equity piece in the company.
Responsibilities as Team Member:
Involved in Oracle advanced supporting activities like monitoring EBS system for application issues, long running Program requests , performance tuning of programs, creating SR’s  and working with SR to get resolved for functional issues and bugs, month end activities to create data fixes and SBM reviews and migration of objects through Serena tool.
Involved in doing smoke tests for the application for the monthly patches.
Involved in Retro fitment of version upgrades in R12 and supported for code changes and issues after retro fitment.
Involved in enhancements of cloud Bi publisher reports, Customization of Reports in reports and xml publisher reports.
Involved in creation of AOL activities like registering concurrent programs, request groups, value sets in applications.
Created Tables, Indexes, Views, Triggers, Stored Procedures, Functions and Package
Executing concurrent programs from PL/SQL.
Light Tower Crown Castle 
Technical Consultant Jan 2021 – Nov 2021
Crown Castle is a real estate investment trust and provider of shared communications infrastructure in the United States. Its network includes over 40,000 cell towers and nearly 80,000 route miles of fiber supporting small cells and fiber solutions.
Responsibilities:
Developed BI reports in cloud application.
Worked on code fixes in custom packages and modifications
Involved in implementation and code changes in interfaces.
ICANN 
Technical Consultant Jan 2020– Dec 2020
The Internet Corporation for Assigned Names and Numbers (ICANN) is an American multi stakeholder group and nonprofit organization responsible for coordinating the maintenance and procedures of several databases related to the namespaces and numerical spaces of the Internet, ensuring the network's stable and secure operation
Responsibilities:
Creation of Custom reports.
Worked on code fixes in custom packages and modifications
Involved client weekly status calls with business to update the status.
Global Foundries, USA
Oracle Apps functional MDM Consultant and Technical Consultant May 2012 – Sep 2019
Global Foundries is a semiconductor foundry headquartered in Santa Clara, California, United States. Global Foundries was created by the divestiture of the manufacturing arm of Advanced Micro Devices (AMD) on March 2, 2009, expanded through the acquisition of Chartered Semiconductor on January 23, 2010, and further expanded through the acquisition of IBM Microelectronics on July 1, 2015. The Emirate of Abu Dhabi is the owner of the company through its subsidiary Advanced Technology Investment Company (ATIC).
Responsibilities as Senior Consultant:
Creation and maintenance of PO Vendors, NonPO Vendors, Payroll Related Vendors, IC Vendors and Employee Vendors.
Creation and modification of Non-trade Customers and trade customers.
Creation of COA related requests on Natural accounts, Sub accounts, Cost centers, PA Codes. 
Creation of Ship to Locations, Tool Ids and assets.
Creating Employees, Buyers, Positions and approval hierarchies for PO Hierarchies.
Involved in creation of Cross Validation rules, Supplier merge, DNCN setups, Link resource &amp; Employee’s setups and Risk Waiver Approver setups.
Involved in data fixes.
Idea cellular limited
Oracle Apps Technical Consultant Nov 2011 – Apr 2012
Idea Cellular (commonly referred to as simply Idea and stylized as !dea) is an Indian mobile network operator based in Mumbai, Maharashtra. Idea is a pan-India integrated GSM operator offering 2G, 3G and 4G mobile services.
Responsibilities as Team Member:
Involved in Retro fitment activates for version change in R12 
Supported for code changes in reports and packages.
Created to migration documents to move the objects from Dev to Test and Production.
Developing Reports, Customization of Reports in reports and xml publisher reports.
Biesse
Oracle Apps Consultant Jul 2011 – Oct 2011
Biesse is the Group's business unit specializing in the woodworking segment.Since 1969, it has designed, manufactured and marketed a comprehensive range of technologies and solutions for joiners and large furniture, windows, doors and wood building components manufacturers.In recent years, it has also been active in the plastic processing machinery sector, developing ad-hoc solutions for a growing market.
Responsibilities as Team Member:
Preparation of Technical specification documentation from the functional specifications using AIM Methodology.
Developing sql*loader scripts to load data from flat files to temporary tables.
Developing custom programs to load data from temporary tables to interface tables using open interface tables performing necessary primary and secondary validations.
Registered concurrent programs for reports to AOL.
Creating value sets for report parameters and registering them in applications.
Created Tables, Indexes, Views, Triggers, Stored Procedures, Functions and Package



