Candidates About

                 

               Mallikarjun                                                

PROFESSIONAL SUMMARY:

§  Having 9+ years of extensive IT experience in design, development, implementation and Production Support of Oracle Applications R12, 11i (Oracle e-Business) modules like Purchasing (PO), Inventory (INV), Account Payables (AP), Account Receivable (AR), General Ledger (GL), Order Management (OM), HRMS and i-Procurement.

§  Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

§  Strong Technical and program solving skills related to APPS.

§  Experience in other modules like I-Procurement, I-Expenses, Project Accounting (PA), Bills of Material (BOM), Work in Progress (WIP), Oracle Shipping (WSH).

§  Proficient in Oracle Database 8i/9i/10g, Oracle Applications 11i, R12, Developer 2000 (Reports 6i).

§  Good Experience in RICE Components (Reports, Interfaces, Conversions and Extensions) and AOL.

§  Extensive experience in Financials, Procure to Pay (P2P) and Order to Cash (O2C) life cycles.

§  Extensive experience in Customizing and Developing Oracle Reports 6i/10g.

§  Prepared Technical Design Documents using AIM documentation methodology.

§  Proficient in writing stored Procedures, Packages and Functions using SQL and PL/SQL

§  Extensive experience in using SQL, PL/SQL, SQL*Loader, UNIX, and Shell Scripts.

§  Developed Inbound Interfaces and Outbound Interfaces using API. 

§  Worked on developing the punchout catalogue for GE vendors. Specialization in purchasing domain in I-procurement.

§  Worked on XML Publisher Reports, Creating Data Templates and complex XML Publisher Templates.

§  Excellent problem solving, communication, analytical, interpersonal & leadership skills

§  Trouble-shooting user problems during the go-live phase

§  Extensive experience identifying product gaps coordinated with development team by creating Technical Assistance Request (TAR)/SR and obtained one-off fixes.

§  Opened Service Requests with Oracle Support in different scenarios, for providing Solutions to the Bugs identified during Production Support. Resolved various bugs, working in collaboration with Oracle Support.

§  Experience in customizing and personalizing approvals using Oracle Approval Management (AME) steps.

§  Extensive experience in developing Interface and Conversion Programs to import data from various Legacy source files into Oracle Applications using PL/SQL, SQL*Loader, UTL File, Unix Shell script’s, and API’s.

§  Knowledge in OA Framework and customization and Personalization of JSP pages.

§  Knowledge in e-commerce gateway r12

§  Knowledge in developing OBIEE/Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, OBIEE/Siebel Security Setup (users/groups, access / query privileges), configured OBIEE/Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog Objects (Dashboard, Pages, Folders, Reports), scheduling iBots.

§  Worked on Discoverer Reports

§  Experience in Upgrading OBIEE and ODI environments.

§  Extensive experience with AOL to develop Flex fields, Lookups, Validation sets, Concurrent programs, Profile Values, Request Sets registration, and Responsibilities.

§  Proficient in writing Stored Procedures, Packages, Functions, Triggers using PL/SQL.

§  Well versed with client server environment and tools like Developer/2000, SQL* Loader, SQL Developer, JDeveloper, and TOAD.

§  Involved in performance tuning in oracle using Explain plan, Auto Trace, and Tkprof.

§  Upgraded shell scripts, which calls reports, control files and sql files which are in the production.

 

EDUCATION SUMMARY

Masters in Computer Science from Kakatiya University.

 

SKILLS SUMMARY

ERP	Oracle E-Business Suite R12(12.1.3), 11i
ERP Modules	PO, INV, AP, AR, GL, OM, PA, P2P, O2C, and System Administration.
Programming Languages	SQL, PL/SQL
Operating Systems	Windows NT/XP/Unix
RDBMS	Oracle 9i/10g/11g
Development Tools	Forms6i, Reports6i, XML Publisher, OBIEE 10g, 11g 11.1.1.7Reports,SQL*Loader, Discoverer Reports, Oracle Data Integrator (ODI)
Database Tools	Toad, PL/SQL Developer, SQL *Loader, Win SCP, PFileZilla, SVN, Stash, STAT(Dell)

 

 

Work Experience

 

                                                                                                                 Duration:            Apr-2016 to till date

Client Name   : C&S Wholesale Grocers (http://www.cswg.com/ )

Role                : Oracle Apps(EBS) Technical Consultant  

Environment  : Oracle Applications R12 (PO, INV, AP, AR, GL and SCM )

 

Description:

C&S Wholesale Grocers is the lead supply chain company in the food industry today – and the largest wholesale grocery supply company in the U.S. We supply independent supermarkets, chain stores and institutions with over 170,000 different products – from more than 75 high-tech facilities, delivering everything from seafood to soup to soap. In fact, if it belongs on a supermarket shelf, it’s probably moving through a C&S warehouse right now.

 

 

Responsibilities:

 

• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices
• Analysis and resolution of Business Critical, Urgent and Normal Issues. Fixing the technical Issues encountered by the application users. Technical Issues include bug in coding the Reports, PL/SQL, Stored Procedures, interfaces.
• Developed custom Interfaces for Payable Invoice, Receivable and Receipts Interface
• Developed SQL*Loader control file and PL/SQL package (with Validations) for GL conversion, PO Conversion and Open AR Conversion
• Responsible for converting the Purchase Orders (PO) in P2P cycle using Import Standard Purchase Orders.
• Developed new reports and customization of existing reports as per the business requirement.
• Developed SQL*Loader control file and PL/SQL packages for   De normalization tables.
• Developed XML Publisher reports and Discoverer reports in various modules like

§  Developed AP Payables Interface program to load legacy payable invoices into Oracle Payables.

• Developed De normalization tables and loaded the data from Mainframes.
• Worked on GL Interface to load legacy data into oracle application systems
• Developed AR Statement Report as per custom requirement

 

 

                                                                                                                 Duration:            Sep-2012 to Mar-2016

Client Name   : Cross Country Home Services, FL (Florida) (http://www.cchs.com/ )

Project name :  ATRIUM

Role                : Oracle Apps Technical Consultant

Environment  : Oracle Applications 11i, R12 (PO, INV, AP, AR, GL and HRMS)

 

Description:

Cross Country Home Services, Inc. (CCHS) is cost-effective home solutions, including warranty products and maintenance plans. Since 1978, the company has built a reputation for excellence and today is one of the nation's leading providers of these products and services.CCHS home warranties are highly flexible to meet a homeowner's unique needs and are available through a number of distribution channels, including business partners in the mortgage, retail banking, insurance, real estate and utilities industries, as well as directly to consumers. Clients include companies such as Bank of America, CitiMortgage, Berkshire Hathaway/Home Services of America, Long & Foster and others. Over the past five years, CCHS has more than doubled its revenues and experienced similar employee growth. We have served millions of home warranties over the past 10 years.

       The Project includes Production support, implementation, and customization of Oracle E-Business Suite (EBS)/ Oracle Applications R12 (12.1.3), Purchasing (PO), Inventory (INV), Account Payables (AP), Account Receivable (AR), General Ledger (GL), Order Management (OM)

 

 

Responsibilities:

.

§  Worked on daily basis Production issues based on the priority, Like Manual data changes, bug fixing...etc.

§  Developed Supplier conversion and Customer conversion using API’s.

§  Developed Employee Salary Conversion to upload the data from Legacy to Oracle Apps.

§  Developed Cash Receipts Conversion and apply them against to Open AR invoices Using API’s.

§  Worked on various conversions activity as a part of implementation conversions developed are PO Locations, GL conversion and PO Conversion, Open AR Conversion.

§  As per the requirement created and implemented XML/BI Publisher reports for Supplier Creation, AP Invoice Creation.

§  Developed PL/SQL Packages, Procedures, and Functions for Creation of Suppliers, Supplier Sites, and Bank Accounts from the legacy system and imported into Oracle Application using the Supplier Open Interface Import, Supplier Sites Open Interface Import program and populated into the Base Tables.

§  Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger).

§  Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format

§  Developed technical design and test documents complying with Oracle AIM standards.

§  Worked on Version control software GIT/Stash for migrating code to higher instances.

§  Involved to discuss with the business people to explain the technical feasibility for their custom process.

§  Creation of Concurrent Programs, Executable and Creation of Values Sets.

§  Developed XML Publisher reports and Discoverer reports in various modules.

§  Coordinating weekly and daily status call with the client and businesses.

§  Developed SQL*Loader control file and PL/SQL package (with Validations) for   GL conversion

                                                                                                              Duration:                   Apr-2012 to Sep-2012

Project                                                                                              

Client Name   : Art.com Inc., Emeryville, CA. (  www.art.com )

Role                : Oracle Apps Technical Consultant

Environment  : Oracle Applications R12 (PO, INV, OM)

 

Description:

Art.com Company exist so you can have the art you love. This means giving you easy access to incredible art images and top-notch craftsmanship. Because when you find art you and that's what it's all about.

We work with passion to bring you the world's largest art collection. Whatever your interest, your décor style, your inspiration – we're sure to have that piece you can't live without. We believe art is dynamic, personal and connected to now, and the experience of buying and living with it should be too. From the moment you browse our site to the day your art is delivered, our team has one goal in mind: to delight you every step of the way.

Responsibilities:

 

§  Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories

§  Developed new reports and customization of existing reports as per the business requirement.

§  Defining Concurrent Programs, Executable and Creation of Values Sets.

§  Coordinating weekly status call with the client and businesses for the module

§  Developed PL/SQL Packages, Procedures, and Functions for Creation of Suppliers, Supplier Sites, and Bank Accounts from the legacy system and imported into Oracle Application using the Supplier Open Interface Import, Supplier Sites Open Interface Import program and populated into the Base Tables. Imported Legacy Journals data into GL using Journal import interface.

§  Developed XML/BI publisher reports in various modules like PO,INV.AP

§  Involved in production support Issues, bug fixing..etc.

§  Responsible for preparing procedures, functions, packages as per requirements

§  Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR_PAYMENTS_INTERFACE_ALL. Validated and imported the data into AR base tables.

§  Prepared technical documents (MD070) for reports, interfaces and concurrent programs as per business logic.

§  Developed Discoverer reports in Purchasing (PO) Module.

§  Worked as team member for designing the data migration plan from the legacy system to Oracle Applications, and coordinated with the other developers for preparing test plans, reconciliation reports and detailed design.

Project                                                                                                                  Nav-2011 to April 2012

Project Name: CPE, Denver,CO .( www.centurylink.com )

Client Name  : CenturyLink

Role               : Oracle Apps Technical Consultant

Environment : Oracle Applications 11i,R12(PO, INV, AP,HRMS)

 

Description :

CenturyLink is the third largest telecommunications company in the United States. The company provides broadband, voice and wireless services to consumers and businesses across the country and advanced entertainment services under the CenturyLink™ Prism™ TV and DIRECTV brands. In addition, the company provides data, voice and managed services to business, government and wholesale customers in local, national and select international markets through its high-quality advanced fiber optic network and multiple data centers. CenturyLink also is recognized as a leader in the network services market by key technology industry analyst firms, and is a global leader in cloud infrastructure and hosted IT solutions for enterprises through Savvis, a CenturyLink company. CenturyLink's customers range from Fortune 500 companies in some of the country's largest cities to families living in rural America. Headquartered in Monroe, La., CenturyLink is an S&P 500 company and is included among the Fortune 500 list of America's largest corporations.

       The Project includes implementation, customization and up gradation of Oracle Applications 11i to R12 modules: Account Payables (AP), Purchasing (PO), General Ledger (GL), Order Management (OM), Shipping (WSH),Inventory (INV) and Warehouse Management System (WMS), IExpense

 

Responsibilities:

 

§  Handled the production support environment, working with oracle teams raising SR's and handled severity1 issues

§  Developed new reports and customization of existing reports as per the business requirement.

§  Worked on LPN’s, Serial numbers in WMS module.

§  Developed a custom program Named “Mass Unpack”, used while unpacking the LPN’s.

§  Developing new reports and registered with Oracle Application (EBS).

§  Customized various transactions in Accounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).

§  Development of Documents like MD 70’s based on functional documents.

§  Worked On LPN, Serial numbers, WMS, INV, GL, AP modules and handled all the tickets for production support.

§  Defining Concurrent Programs, Executables and Creation of Values Sets.

§  Coordinating weekly status call with the client and businesses for the module

§  Developed SQL*Loader control file and PL/SQL package (with Validations) for   GL conversion

§  Involved in unit testing and reviewing of interfaces and reports

§  Wrote SQL*Loader script to migrate the data from the legacy system flat file to GL Staging table

§  Was involved in developing interface program for AP Invoice Interface and also report to show the imported and rejected data.

§  Designed and Developed PL/SQL process with validations to convert all legacy suppliers into AP

§  Worked on design and development interface and conversion programs to integrate to import data from various sources using Oracle applications, SQL, PL/SQL and SQL*Loader and TOAD

                                                                                                               Duration:           Oct 2010 to Oct-2011

Project Name      : OLF Implementation

Client Name        : Open Link Financials

Organization       : Intelligroup

Tools Used          : SQL, PL\SQL and Reports 6i,

Environment       : Oracle Apps R12 (AP, PO, GL and HRMS)

Role                     : Oracle Apps Technical Consultant

 

Description:

OpenLink provides world-class turnkey implementation solutions for our customers from pre-sales assistance through “go-live” events. These solutions are based on a proven implementation methodology developed over the past fifteen years and continually enhanced to address new technology developments and evolving market-driven business needs. OpenLink’s implementation solutions team has direct access to in-house subject matter experts and product development personnel to ensure on-time and on-budget implementations that consistently exceed client expectations.

Responsibilities:

§  Developed Employee Address Conversion to upload the data from Legacy to Oracle Apps.

§  Developed Employee Salary Conversion to upload the data from Legacy to Oracle Apps.

§  Developed Employee Contacts Conversion to upload the data from Legacy to Oracle Apps.

§  Developed Inbound Interfaces and Outbound Interfaces. 

§  Worked on BI Publisher reports.

§  Worked on various conversions activity as apart of implementation conversions developed are PO Locations, Employer Conversion, Customer Conversion, GL conversion and PO Conversion, Open AR Conversion.

§  Defined and created new Descriptive Flex fields, Lookups and Value sets to support new Business Requirements.

§  Developed test scripts for Unit testing, System Testing, and Integration Testing.

§  Developed custom responsibilities for Application End Users.

§  Developed many Technical Design documents for the RICE objects

§  Developed XML publisher reports in various modules like PO,INV,AP.

§  Develop UNIX SHELL SCRIPTS to move code from one instance to the other and perform unit testing.

§  As a technical consultant, responsible for Communicating to the end users, Requirements analysis, Functional Specification Documents, Designing Specifications, Coding, Testing, Change Management and support of the Customizations and application extension.

§  Created cross references for legacy data to new oracle data and created a profile cross reference translation which is useful for all modules.

§  Prepared technical specifications document (MD 70), test scripts (TE40), Conversion Document (CV40) and deployment documents (MD120) based on the functional requirement specifications (MD 50).

§  Involved in post-production support, bug fixing and enhancements of RICE objects.

                                                                                                      Duration:                         Oct 2008 to Oct 2010

Project Name      : GE –SSS (Shared Sourcing Services)

Client Name        : GE Corporate services

Organization        : UST Global

Tools Used         : SQL, PL\SQL and Reports 6i,

Environment        : Oracle Apps11i (PO, INV, AP, AR and GL)

Role                     : Oracle Apps Developer

 

Description:

GECIS-SSS is a project of GE corporate services to provide Oracle apps reports development to all its organizations across the globe for purchase to pay cycle where oracle application is not implemented and these organizations are using oracle apps of GECORP through EDI. As a part of development team we have to provide technical and functional support to development of new reports and customization of existing reports, development of AdHoc queries etc.

 

Responsibilities:

§  Analyzed the user requirements.

§  Developed new reports and customization of existing reports as per the business requirement.

§  Developing AdHoc queries.

§  Customized the standard reports in Purchase module like vendor reports, purchase order reports

§  Developing new reports and registered with Oracle Application.

§  Developing Procedures, Functions and Packages using SQL and PL/SQL.

§  Development of Documents like MD 200’s.

§  Development and enhancements of custom reports.

§  Registering PL/SQL Stored Procedures in Front End using Concurrent Program.

§  Defining Concurrent Programs, Executables and Creation of Values Sets.

§  Developing SQL scripts as per business requirements.

§  Worked extensively in Database Development like developing procedures, packages, triggers, functions, Reports.

§  Coordinating weekly status call with the client and businesses for the module

 

                                                                                                   Duration:                     July 2006 to Sep 2008

Project name  : AU ADPRO-APPS LINK <span styl