Software Engineer Oracle

B.Madhav kumar Mobile+91-888******* Email: ******.**********@*****.***

Professional Summary

• Oracle Technical consultant with over all experience of 3.5 years which includes rich experience involving the development and supporting process.

• Worked extensively on Oracle Purchase order, Inventory, Accounts Payable, Accounts Receivable and Order management.

• Experience in building Forms, generating Reports, XML Reports and registering them as concurrent programs in Oracle applications using AOL.

• A synergistic team player with strong and excellent interpersonal skills.

• Troubleshooting and coordination with Oracle Customer Support for resolution of issues.

• Very good experience in understanding the Multi Org Environment.

• Understanding the Business Process of Oracle Applications covering Procure to payment and Order to cash Business Cycles.

• Used AIM Methodologies for various Technical designs-Setup, Requirement study, Test Scripts flows etc.

• Extensively worked on Interfaces and conversion.

• Possess strong organizational skills and ability to timely complete necessary documentation and reports

Educational Qualification

• B.Sc (2006 - 2009) from SK University, ANANTAPUR

Professional Experience

Organization Name Designation From Date To Date

FCS Software Engineer Jul 2010 Till Date

Wissen InfoTech Associate Software Engineer Apr 2009 Jun 2010

Technical Skills

Operating Systems : Windows 98/XP/2000, MS-DOS, UNIX, LINUX.

ERP Package : Oracle Applications 11i.

Programming Languages : SQL and PL/SQL, C, HTML

Databases : Oracle 10g

Productivity Tools : SQL *Loader, TOAD, Dollar Universe, D2K, SQL * Plus

Migration Tools : Kintana, PVCS, Remedy, Quality Centre.

Projects Portfolio

Project # 3

Client : Belden Inc

Environment : Oracle Apps R12

Role : Developer

Duration : Apr 2011 – Till date

Team Size : 8

Description:

Belden Inc designs, manufactures, and markets highly engineered signal transmission products for demanding applications. These cable, connectivity and networking products serve the industrial automation, enterprise, security, transportation, infrastructure, residential and consumer electronics markets. Belden is one of the largest U.S.-based manufacturers of high-speed electronic cables and the company is best known for its high-speed signal transmission products primarily used in entertainment, residential, industrial and security markets

Roles & Responsibilities:

• Registrations of Custom Tables and Concurrent Programs.

• Creation of Value sets in various Modules of the application.

• Preparation of SQL Loader scripts

• Development of XML Reports.

• Registrations of Tables.

• Executing concurrent programs from PL/SQL.

• Creation of Value sets in various Modules of the application.

• PL/SQL method of submitting Concurrent programs

• Development and Customization of Reports, PL/SQL Procedures, and Packages.

• Registering reports in Oracle Applications

• Registering forms in Oracle Applications

• Developed inbound interface to transfer data from legacy system to oracle applications

• Developed outbound interface to extract the data from the Oracle Apps Tables to the Flat file using UTL_File utility.

• Registering reports in Oracle 11i Applications

Project # 2

Client : Bristol-Myers Squibb

Environment : Oracle Apps 11i

Role : Team Member

Duration : 2010 Jul to 2011 Mar.

Team Size : 11

Description:

Bristol-Myers Squibb is a pharmaceutical company, headquartered in New York City. Bristol-Myers Squibb manufactures prescription pharmaceuticals in several therapeutic areas, including cancer, cardiovascular disease, diabetes, hepatitis, rheumatoid arthritis and psychiatric disorders. Its mission is to "discover, develop and deliver innovative medicines that help patients prevail over serious diseases." BMS' primary R&D sites are located in Princeton, New Jersey (formerly Squibb) and Wallingford, Connecticut (formerly Bristol-Myers), with other sites in Hopewell and New Brunswick, New Jersey, and in Braine-l'Alleud, Belgium, and Tokyo

Responsibilities:

• Design, Development and Customization of RICE components

• 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

• Performing Unit testing and Code review for developed RICE Components

• Preparation of MD120 doc for Code migration

• Preparation of TE020 doc for Unit Test cases

• Monitoring the deliverables during each phase of project

• Attending the weekly status calls and weekly reporting

• Writing SQL queries according to customer requirement

• Understanding customer issues.

• Define value sets

Project # 1

Title : Oracle Application Implementation.

Client : Dresser INC

Environment : Oracle Apps 11i

Role : Team Member

Duration : 2009 Apr to 2010 Jun

Team Size : 9 Members.

Description:

Dresser INC, USA 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

Responsibilities:

• Analysis of the Requirements provided by the clients.

• Creation of PL/SQL procedures, Functions and Packages.

• Creating Database Objects like tables, views, sequences, Indexes.

• Writing SQL queries according to customer requirement.

• Responsible for developing the Interfaces and conversions.

• Developed control files for loading legacy data into staging tables using SQL*LOADER.

• Writing PL/SQL Programs for implementing validation rules and loading data from

Staging tables to Interface Tables.

• Developed Outbound interface to extract data from Base tables to Flat file using the UTL_FILE Package.

• Writing custom packages and using API’s to develop the interface Programs.

• Involved in the Reports and Forms development and Customization.

• Post Production support.

• Preparation of MD070 and MD120 installation documents.

• Prepare release scripts to migrate code to other instances.

• Attend weekly status meetings with Client to explain the current status of all open issue and pro-actively suggest any processes which can be improved

Contact this candidate