Software Engineer Oracle

RESUME

Name: Poornachandar Lingampally

Mobile: +1-404-***-****

Email Id: **************@*****.***

Professional Summary:

Over 9 years of extensive experience as Oracle Application Technical Developer (EBS) in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.

Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), IProcurement, Cash management (CM), Inventory (INV) and Order management (OM).

Hands-on experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications.

Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).

Experience in Procure to Pay (P2P) life cycle.

Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, and software Development Life Cycle (SDLC).

Expertise on designing and implementing Oracle Alerts and Lookups.

Having Knowledge in OAF.

Hands-on experience in developing and customization in RDF reports and BI reports.

Good Exposure in writing SQL Queries, Procedures, Packages and Triggers.

Exposure in developing or customizing the Discoverer repots.

Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll.

Exposure in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).

Developed new Concurrent Programs, Reports and Flex Field Customizations.

Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle Forms, Oracle Reports, Workflow, Discoverer.

Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.

Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.

Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

Experience in customizing oracle workflows such as the Invoice approval process.

Experience in doing the Performance Tuning.

Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).

Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.

Interacted with users, fixed the bugs, developed test plans and provides daily production support.

Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF.

IT Expérience

Working as Sr. Software Engineer in Accenture Services Ltd, USA (2014 to Till Date).

Worked as Sr. Software Engineer in Birlasoft India Ltd, Hyderabad. (2011 to 2014).

Worked as a Software Engineer in Nyccos Software Solutions, Hyderabad. (2009-2011).

Academic Profile:

Bachelor of Engineering (B.Tech) from Jawaharlal Nehru Technological University, Hyderabad,

Technical SUMMARY:

Operating System

:

WINDOWS NT, WINDOWS 95, UNIX and Ms Dos

Packages

:

MS Office (MS Word, MS Excel)

Languages

:

SQL & PL/SQL, XML and HTML

GUI Tools

:

Form Builder, Report Builder, jdeveloper (10.1.3.3.0), Discoverer, XML Publisher, TOAD, Workflow

ERP

:

Oracle Applications 11i and R12, Knowledge in Oracle CLOUD.

Project Details:

PROJECT#1

Project Title: COX AMS Prod Support

Client: Cox Enterprises Inc. (Onshore)

Module: AP, GL, PO, FA in Oracle EBS Finance, Oracle AOIC.

Designation: Onshore Lead

Duration: Sep 2019 to Till Date

Description:

Cox Enterprises is a global company with approximately 55,000 employees and $21 billion in revenue.

Cox remains a values-driven private corporation that can invest in long-term growth and is proud of its

four-generation family leadership. Through our major divisions—Cox Communications and Cox Automotive —we lead in the

communications and automotive industries. Our widely recognized national brands include Autotrader, Kelley Blue Book and Cox Homelife.

Responsibilities:

As onshore lead handles the teams (Oracle EBS, Web Center and DBA).

Worked on P2 tickets and try to provide immediate data fixes to resolve the issues without missing SLA.

Co ordinating with 3 party systems and try to resolve the issues.

Engaging Oracle support and other teams and try to work on the high priority tickets.

Gathering the requirement from client share those details to offshore to work on the enhancements.

Attending status calls and provide the status on all the tickets.

Worked on Month End critical issues and resolved them with in the timeline.

Helping in Web-center related issues means co ordinating with business and engage third party systems to resolve the issues.

PROJECT#2

Project Title: CIGNA ETSG Prod Support & Enhancements (Oracle EBS)

Client: CIGNA Health Insurance (Onshore)

Module: AP, GL, PO, AR, CM, FA in Oracle EBS

Designation: Onshore Lead (2 years) Offshore (3 years)

Duration: Feb 2015 to Oct 2019

Description:

Established more than 50 years ago, in 1962, the Cigna Foundation carries out our corporate philanthropy goals of bringing Cigna's mission and brand promise to life for individuals and communities around the globe. This is accomplished through strategically focused charitable grants to nonprofit organizations whose work enhances the health of individuals and families and the well-being of their communities.

Responsibilities:

Developed the new interfaces and customizing the existing interfaces.

Handled all the production support/enhancement issues and try to close them with in the SLA time.

Created new lookups and value sets based on the requirement.

Developed and customized the reports, interfaces and workflows as per the client requirement.

Developed interface to load the workday payroll information into Oracle.

created Outbound interface to extract the payroll information and send it to downstream system (Hyperion),

Developed new interface to handle the R12 segments and load the data into GL for one of the source systems.

Customized in invoice workflow to change the interval for the reminder notification.

Developed Cigna invoice rejection xml report.

Fixed the issues in loading the data from source systems to Oracle in all the module AP, AR, GL.

Customized the interface to change 11i segment values to R12 segments and pass through FAH.

Drive the calls whenever there is any P2 incidents are going on and try to involve business and IT team and try to resolve the issues.

Raised SR's to Oracle and used to update in timely manner.

Handled the Month End and Quarter close issues.

PROJECT#3

Project Title: OLD Mutual I support (Implementation)

Client: OLD MUTUAL (Offshore)

Module: AP, PO, GL, OM in Oracle EBS

Designation: Sr. Software Engineer

Duration: Jul 2014 to Jan 2015

Description:

They provide innovative long-term savings and investment solutions which address both protection and retirement savings needs. They have a majority shareholding in Nedbank, one of South Africa's leading bank franchises, as well as banking interests in other countries in southern Africa.

Responsibilities:

Developed new XML and BI Publisher Reports based on the client requirement.

Worked on AOL object to register the programs in Oracle Application.

Created new RDF and Discoverer reports based on the client requirement.

Developed invoice interface to load the data from source system to Oracle.

PROJECT#4

Project Title: Clearorbit (Production Support & Enhancements)

Client: GE-Energy(Oil & Gas) (Offshore)

Module: AP, PO, GL in Oracle EBS

Designation: Sr. Software Engineer

Duration: Jan 2013 to Jul 2014

Description:

It’s a GE Energy application that digitizes the procurement cycle. The application provides an efficient way for suppliers to receive and collaborate on purchase orders, create shipments, submit invoices electronically and view payment details over the Internet.

Responsibilities:

Involved in production support activities.

Worked on various report level issues.

Created data fixes to load the data into Oracle which were struck in the interface tables.

Involved in working XML reports and debugging the XML reports.

Worked on Interface program related issues in PO and AP related issues.

Good knowledge on service now.

PROJECT #5

Project Title: Dresser-Oracle-Cold-Short (Implementation)

Client: GE-Energy(Oil & Gas) (Offshore)

Module: AP, AR, PO, GL, OM, INV in Oracle EBS

Designation: Sr. Software Engineer

Duration: Mar 2012 to Jan 2013

Description:

With a world class portfolio of energy infrastructure solutions and leading product brands, Dresser, Inc. is a recognized innovator in the global power and fuel industry. From oil and gas production and processing to power generation and fuel distribution, Dresser, Inc. has been defining and leading energy markets for more than 130 years. The Waukesha Motor Company to provide engines for boats, automobiles, trucks, and farm and construction equipment. Beginning in the 1980s, the Waukesha engine product line has focused on large, gaseous-fueled stationary engines for power generation and gas compression applications around the world.

Responsibilities:

Design, Development and Customization of RICE components.

Developed Vendor related information from source system to Oracle.

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface

Doing feasibility analysis and preparing technical design documents MD-070.

Coding and Development of RICE as per Naming and Coding Conventions.

Define Concurrent program, Request Sets and Executable (AOL)

Performing Unit testing and Code review for developed RICE Components

Created Email Alter based on the item creation in MTL tables.

Worked on Customization of AR interface Program.

Customized the reports to replace the logo by using $OA_MEDIA Top.

PROJECT #6

Project Title: OLM RTS R12

Client: GE-CAPITAL (Offshore)

Module: AP, Lease Management, PO, GL, OM in Oracle EBS

Designation: Software Engineer

Duration: Jan 2010 to Feb 2012

Description:

GE Capital is a leading provider of business lending and leasing for companies of all sizes in a wide array of industries. They work closely with the customers to provide business financing to purchase, lease and distribute equipment. They provide business capital for corporate acquisitions, refinancing and restructuring as well as services to manage large fleets of cars and other equipment.

Responsibilities:

Developed code for Dashboard Report.

Changed the reports as per the requirement.

Worked on day to day production supporting issues.

Worked on night batch monitoring.

Worked on Discover Report issue and also did some enhancements.

Worked on the XML Report issues to find out the root cause and try to resolve them.

Personal Details

Date of Birth : 15-AUG-1984

Nationality : Indian

Visa Status : Valid till 22 OCT 2020

Visa Type : H1 B

Email ID : **************@*****.***

Contact Number : +1-404-***-****

Contact this candidate