Developer Project

602-***-**** Abhi ******@*********.***

Experience Synopsis

Around 9 years of experience in the IT industry mainly implementing ERP systems primarily using, PL/SQL, Workflow Builder, Developer 2000/6i/10g, SQL* Loader, Discoverer, XML publisher and Oracle Applications.

Successfully completed 3 Full life cycles projects with Oracle Applications 11i (11.5.8 & 11.5.10) and recent experience in R12 (12.0.4, 12.1.3 & 12.2.3).

Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation.

Experience in Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CE), Advanced Collections (IEX), Projects(PA/PJC/PJB), Order Management (OM/ONT), Inventory (INV), Supply chain (ASCP), Bill of Materials (BOM), Work in Process (WIP) & Purchasing (PO)

Strong experience in Conversions, Interfaces, Customizations (Forms/Reports), Personalization, Extensions, Work flow, OA Framework and Shell Scripting

Involved in writing documents MD50, MD70, CV40, MD120 etc using AIM (Application Implementation Methodology)

Extensive knowledge on all the Data flows/Processes in Financial modules including Order to Cash(OTC) and Procure to Pay (PTP)

Expert in troubleshooting and fixing the bugs, creation of SR/TAR with Oracle Support/Metalink, obtaining and applying patches with coordination of Apps DBA

Recent experience in Conversions/Implementation of Oracle Financial & SCM modules

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite v R12, 11i

ERP Modules: Oracle Financials (AR/AP/GL/FA/CM)

Oracle Order Management (OE/OKS)

Oracle Manufacturing (INV/OPM/BOM/WIP)

Interface Tools: Forms 10g/6i, SQL*Loader, TOAD, J-Developer and Workflow Builder

RDBMS: Oracle 11g /10g/9i/8i, SQL Server 7/2000, Access 97/2000

Languages: SQL, PL/SQL, XML, JAVA, HTML, C

Operating Systems: Ms-Dos, Windows 9.X, Windows NT/2000/XP, UNIX, Linux, HP-UX

Reporting Tools: Reports 10g/9i/6i, Oracle BI Publisher (XML Publisher), Discoverer 4i/10g,

Version Control

/Supporting Tools: Serena Changeman VM, PVCS Merant, STAR Team

Serena Team Track, SVN, ClearCase, Mercury QC, Kintana, Sorround SCM, hp PPM

Education

Bachelor of Technology (B.Tech.), JNT University, India

Professional Experience

Katalyst DM, Houston,TX Aug 2015- Till Date

Oracle Consultant

Katalyst is a Data Management company which provides the only integrated, end-to-end subsurface data management solution for the oil and gas industry.Katalyst solutions are driven by data management needs. Katalyst clients can access and view their seismic data (seismic line, tapes, maps) spatially through iGlass software a convenient and user-friendly map-based portal and secure web storage solution.

As part of this Project ConocoPhillips Data Migration, performed data Migration from conco data to ppdm data which is accessible by I glass interface.

Responsibilities:

Data Profiling and Data Analyzing

Design and build PL/SQL migrating scripts

Design and Customizing Meta data from legacy database to PPDM database

Mapping the legacy data to PPDM standards

Data Cleanup

Interfacing the legacy data to the I glass

Modified existing mappings for enhancements of new business requirements.

Fixed and Tested Prod Issues and Bugs.

Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)

Generated several drill down and drill through reports using SSRS.

Environment: Golden6 V6.2, Iglass V5.0.1, SQL Server 4.0.3.16, Putty, PPDM 3.8, UNIX, Oracle 9i/11g, 2008, SQL Server Integration Services (SSIS),Reporting Services (SSRS).

Exterran Energy, Houston, TX Jul 2014 –Jun 2015

Oracle Consultant (Upgrade)

Exterran Holdings, Inc is an industry leader in natural gas compression products and services – plus a premier provider of equipment solutions for petroleum production, gas processing, produced water treatment and aftermarket parts and services.

As part of this project ‘APOLLO’, Performed R12.2.3upgrade (Technical upgrade only from 11.5.10.2) as Global Consultant for IT Convergence (Upgrade Partner).Worked on more than 60 CEMLIs.

Responsibilities:

PL/SQL:

Upgraded 11i customizations as per R12 Changes

Worked on 11i conversion related objects to remediate for R12

Redone the custom Interfaces

oAR Utility Packages

oEXH Contract District, Reporting Area and Contract Group

oEXH Delete Item Cost Interface

oEXH OM to SR Creation

oHCCA M2M Output Text File Creation

Forms:

Incorporated new R12 changes to the custom forms -

oEXH Depreciation Projection

oHCCA Collections Credit Form

oHCCA Single PO Print

oEXH EI Electronic Invoice History

Redone the customized form where standard form is changed

oEXT Material workbench

oHCCA Single PO Print

Done the Third party (Markview) integration changes to

oAP Invoice workbench

oFND Attachment form

oCustom.PLL

Forms Personalization:

Upgraded old 11i personalization’s as per R12 Changes

Worked with Oracle Support in remediating some of the existing Personalization’s

Reports:

Designed and developed new Aging reports

Upgraded custom reports from 11i to R12

Handled XML reports, 10g Reports and discoverer reports

Unix:

Prepared migration files to Production

Downloaded/Uploaded LDTs for Menus, Responsibilities, Request group

Helped with CEMLI migrations & Preparing shell scripts for offshore Technical team

Prod Support:

Participated in CRP, SIT, UAT,GO-live and Prod-support

Worked with Onsite and Offshore Model

Worked with various geographical business teams for testing – North America, LATAM (Brazil/Argentina/Mexico) and Eastern Hemisphere (UAE/Iraq/Singapore)

Participated in client DBA/SME discussions for issue resolution/Instance planning

Handled Critical and High Issues as a single onsite developer

Served as Backup Team Lead/Onsite coordinator for Offshore

Environment: Oracle Application EBS 12.2.3 (AP, AR, GL, PO, OM, WIP, BOM, Projects &CRM), Toad 11, UNIX, SQL, PL/SQL, Oracle 9i/11g, Developer Suite 11g (Forms/Reports)

Snyder’s Lance, Charlotte, NC Dec 2013- Jul 2014

Oracle Developer

Snyder's-Lance, Inc. is the second largest salty snack maker in the United States. It was formed by the 2010 merger of Lance and Snyder's of Hanover. This project ‘DSD implementation’ is a part of merging of the ERP systems (Converting Snyder’s JD Edwards information to Lance’s Oracle R12).

Responsibilities:

PL/SQL:

Designed & Developed customized customer model

Developed pricing model based on the new custom forms

Designed & Developed process to update the cost in the inventory & the replenishment process

Developed customized ‘common utility packages’ to use across the Org/by other developers

Forms & Reports:

Developed new/custom Pricing Setup Forms

oPB_PRICING_FORM

oDOW_HIERARCHY_FORM

Designed and developed few summary reports for the Pricing changes & replenishment process

Environment: Oracle Application EBS 12.1.3 (AP, AR, GL, PO, OM, WIP, BOM & iSupplier), Toad 11, UNIX, SQL, PL/SQL, Oracle 9i/11g, Developer Suite 10g (Forms/Reports)

NCI Group, Houston, TX Oct 2012 – Dec 2013

Oracle Conversion Consultant

NCI acquired RCC & this project involves Converting the data from Legacy System (Symix) to Oracle Applications for various modules

Account Payable (AP)/Account Receivables (AR)/General Ledger (GL)/Fixed Assets

Order Management (OM)/Purchasing(PO)/Inventory(INV)/ Trade Management (OTM)

MS/MRP/MBG

Projects

Responsibilities:

PL/SQL:

Designed and developed Staging tables, Conversion routines and Custom PL/SQL API and interfaces for

oFA – prepaid assets, Regular assets,CIP assets conversion

oPO – Standard & Blanket PO Import, PO Receipts

oAP – Customer conversion, Vendor conversion, Salesrep conversion

oINV - Items, Item Categories, Item revisions, On-hand qty

oPA - PA Cost conversion, PA invoice conversion, PA WBS/Tasks

Modified existing custom code (Inventory Interface, Applied labor/MRP Interface) to include the new integration logic

Designed and implemented Approvals Management (AME) for purchase requisition approval to send approval notifications to special pre-approvers, chain of authority and post-approvers.

Designed and implemented Approvals Management (AME) for requisition change order approval to send approval notifications to special pre-approvers, chain of authority and post-approvers.

Forms:

Worked on both 6i (With Apps 11i) & 9i forms (CITRIX system For OTM)

Modified existing custom Forms to include new integration logic

oDaily shipping input form

oAdd extra buttons & Logic to get BOL Number

omschd_shipping

Modified existing personalizations on various forms for fixing minor bugs

Customized OAF pages in Employee Self Service and Manager Self Service by extending View Objects to add additional fields

Reports/XML:

Modified Custom Report ‘OEABookingDetail’ as per new integration logic

Designed & developed Custom Report ‘MBG custom stock status report’

Developed custom discoverer reports like, Expense PO Details, Inventory PO Details.

Changed Text outputs to Excel outputs for 3 custom report by using XML templates

OA Framework:

Supervised the rewrite of Oracle i-Supplier Portal which was developed using OA Framework.

Involved in implementing i-Supplier Portal that supplier can view orders, notifications, invoices and their status

Environment: Oracle Application EBS 11i (AP, AR, GL, FA, PA, OTM, MS, MRP, OM, PO & INV), Toad 11, UNIX, SQL, PL/SQL, Oracle 11g, Citrix

AEES, San Antonio, TX Mar 2012 –Oct 2012

IT Consultant

This project involves upgrading Oracle Applications from version 11i to R12 (12.1.3) for Financial modules

Account Payable (AP)/Account Receivables (AR)/General Ledger (GL)

Responsibilities:

Analysis of existing custom objects for changes required for upgrade

Documentation, Development and Testing of changes identified

Personalized JSP pages for i-Supplier

PL/SQL:

All custom programs were rechecked/recompiled/modified as per R12 Upgrade changes.

Worked with DBAs for tuning/performance issues & with Oracle in getting latest Patches

Forms:

All the custom forms are recompiled using Forms 10g after making appropriate R12 changes

Modified existing personalizations on various forms for fixing minor bugs

Reports/XML:

All custom reports are modified in Reports 10g as per R12 changes. Parameters/Value sets for the reports were altered to make them work efficiently for R12

OA Framework:

Design and development of Agent Customer Info Update page

Personalized the branding image on Custom AR invoice search page.

Environment: Oracle Application EBS R12 (AP, AR, GL), Toad 11, UNIX, SQL, PL/SQL, Oracle 11g, hp PPM (Project and Portfolio Management), Seapine Surround SCM

Pepsi Beverages Company, Somers, NY Jan 2011 – Mar 2012

Oracle Techno-Functional Developer

This project involves implementation of Oracle Applications 12.0.4

Account Payable (AP)/General Ledger (GL)/Fixed Assets (FA)/Projects (PA/PJC/PJB)

Responsibilities:

Creating design (MD050/MD070) and Conversion (CV040/CV060) documents

Hands on development and Testing; Training end users

Worked as module owner for Accounts Payable (AP) & Assets (FA) conversion

PL/SQL:

Designed, documented and developed staging tables, conversion routines & Custom programs for converting

oOpen AP Invoices

oSuppliers & Supplier Sites

Developed PL/SQL routines for FA Conversion (Handling Flat files, loading to staging tables, validation and loading using APIs, Mass copy to tax books)

Developed the FA catch-up Process (To catch-up OFA vs. Legacy every period-end till go-live) to support FA Conversion. This process include,

oPrepare Delta file using period-end snapshot from Legacy

oUsing above, generate additions/retirements/Transfers/Adjustments/Other Changes to keep in sync

oRun depreciation, reconcile and close the period in Oracle Assets

oAll journals created by Oracle Assets, will be posted and reversed in Oracle General Ledger

Developed the FA Tax interfaces from Oracle to other third party systems

Involved in Projects Conversion and PA daily extracts

Developed custom process for daily extracts from AP & GL

Forms:

Designed and developed following custom form using Forms 10g,

Custom Assets Description Form

Custom Project Approval Form

Personalized standard AP forms to populate new attributes

Modified existing personalization on various forms for fixing minor bugs

Reports/XML:

Customized the standard FA What-If Report as per business requirements

Developed Custom PA: Project Spending vs. Plan/Forecast Report

Workflow:

Designed and developed Project Approver Workflow

OA Framework:

Personalized page to enable submit button on the train flow of iProcurement page

View Object extension for several OAF pages to display a new custom attribute column in the LOV

Environment: Oracle Application EBS R12 (AR, GL, IEX, OM), Toad 11, UNIX, SQL, PL/SQL, Oracle 10g, Workflow Builder 2.6, Developer 10g

Project Name: PBG/PAS Integration Duration: Oct 2010 -Nov 2010

Client: Pepsi Co, Winston-Salem, NC

PepsiCo merged with its bottlers PAS and PBG, to strengthen its North American beverage business. The North American bottling operations of PAS and PBG are now an operating unit of PepsiCo known as ‘Pepsi Beverages Company’. This project involves the PBG/PAS Integration.

Responsibilities:

Helped business in identifying the project requirements

Worked on various custom objects with requirements gathering and Training the end users

PL/SQL:

Designed, Documented Functional (MD050) and Technical Specification (MD070), Conversion Mapping (CV040) Documents and developed conversion routines, Custom PL/SQL programming for converting below PeopleSoft (PAS Legacy system) data to Oracle

oCUSTOMERS

oCUSTOMER CONTACTS

oTRANSACTIONS

oCOLLECTIONS

oCUSTOMER/COLLECTION/TRANSACTIONS COMMENTS

Designed and Developed new programs for special purposes.

oUpdate the account name for new PAS Customer

oWrite off of the PAS Conbill invoices and then moving them to PBC accounts

Forms:

Designed and developed following new custom form using Forms 6i,

oPS Closed Transactions Form – It is used for querying the closed transactions in legacy system. It was based on view from 2 years of historical data.

Modified existing personalization on few forms to facilitate new PAS users

Environment: Oracle Application EBS R12 (AR, GL, IEX, OM), Toad 11, UNIX, SQL, PL/SQL, Oracle 10g, Workflow Builder 2.6, Developer 10g

Project Name: OASIS Duration: Dec 2009– Sep 2010

Client: Agilent Technologies, Santa Clara, CA

Agilent delivers critical tools and technologies that sense, measure and interpret the physical and biological world. Agilent has facilities in more than 30 countries and develops products at manufacturing sites and having more than 1 million customers and Vendors using their Application. This project includes Implementation and Customization of AP, AR, GL, FA WIP, BOM, INV, APS (Advanced Planning and Scheduling), and AOL using Oracle Application Release 11i(11.5.8)

Responsibilities:

Wrote Technical specifications, Conversion-mapping documents for Item Import and Payables open Interface Import.

Wrote MD70, CV40 documents, conversion routines, created staging tables and Custom PL/SQL API’s for Items, Item Categories, Item Revisions, Inventory On hand Quantity Converting from legacy system

Wrote custom PL/SQL API’s for converting Sub processes in Order to Cash (O2C) like Customer, Order entry, Order fulfillment, Distribution, Invoicing, Customer payments, Receipt.

Imported Orders from legacy system to Order Entry Interface tables using SQL*Loader, and PL/SQL package (with validation)

Good understanding of the various processes involved in Order Management Module like Booking an order, Pick release, Pick confirm, Ship confirm and Closing the order

Good knowledge of the order management tables involved in these processes

Defined price lists, modifiers, qualifiers and qualifier groups in pricing.

Designed and Developed Conversion routines, custom PL SQL API’s for Item Import and Payables Open Interface Import (Invoice Import)

Designed and developed custom PL SQL program to assign categories, cross references, sourcing rules and locations to items.

Designed and Developed Sales Orders Items shortages report, Daily Inventory Transaction Report.

Developed a custom report to daily list all the rejected invoices based on the interface table.

Customized Journal Batch Summary Report, Aging 4-bucket report and past due invoice report.

Customized Packing slips report, MRP Detail Planning Report.

Customized Reports like Employee Benefit Eligibility Listing, Employee Benefit Enrollment Register

Environment: Oracle Application EBS 11i (AP, AR, GL, FA WIP, BOM, INV, APS), Toad, UNIX, SQL, PL/SQL, Oracle 8i, Workflow Builder 2.6, Developer 6i

Dhanush Infotech, Hyderabad, India Jan 2007– Sep 2009

Techno-Functional Consultant

The project involved in development and implementation of the financial accounting package for GE-CIS. High level of security, reliability, consistency and efficiency were the core areas of design precepts.

Responsibilities

Worked as Developer in a team of eight, handled development and Implementation of oracle applications, configuration of the Oracle server according to the application.

Development of modules using PL/SQL which included Template preparation, Trouble shooting, writing stored packages, procedures and functions, Unit testing and Debugging

System Analysis and Design

Written PL/SQL validation scripts

Customized PL/SQL Packages and written database procedures

Created new forms and reports using Forms builder and Reports builder

Created database objects like tables, views and triggers

Prepared program documentation and carried out unit and integration testing

Requirement analysis, data-mapping, functional and technical design of the interface(s) with Captura System

Application/Customizations design & development

Coordination of SIT, UAT and GO-LIVE

Production Support Work

Environment: Oracle Financials 11.5.8, Sun Solaris, Developer 2000, PL/SQL, SQL*Loader, PcAnyWhere, SameTime, Terminal Services and Oracle 8i

Contact this candidate