Oracle Developer

Prabhu Shankar

Information Technology and Services Consultant

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

Phone : 214-***-****

Over 25 years experience in Analysis, Design, Development and Implementation of Oracle ERP & other RDBMS packages. Over 22 years of Development, Implementation and Support of Oracle ERP Applications. Additional Responsibilities include developing project plans, preparing solutions documents for the project, helping in development of bids and proposals, mentoring and training of consultants. Reviewing the utilization, goals achieved, skills improvement and development of the consultants

Specialties:

• Business Development IT Services and Solutions.

• Management and delivery of ERP Solutions.

• Expertise in services & solutions with Enterprise Oracle /Oracle Applications systems.

• Client Relations Development and Management

EXPERIENCE

US Steel / Lonestar Steel - USA Feb 2000 – June 2020 Senior Principal Consultant - Oracle ERP

Contracted Through Hencie Consulting and P&R Solutions Worked on this project for more than 20 years. Conversions from Mainframe to Oracle ERP is how this started. Was on this project from day one. From planning to designing to conversions to interfacing other systems to implementation to enhancements to production support. The entire cycle of a project from start to finish – involved in all the implemented applications including System Administration, Applications Developer, Financials, Manufacturing and Distributions modules (GL, AP, AR, PO, Inventory, Order Entry, Work In Process, Bills And Routings, HR). Complete knowledge of all the table structures, background process, APIs, Spawn processes and File Structures

Was the technical team lead for a group of 8 technical resources. Initial process involved working on the current system (legacy mainframe) and pulling data out and converting them into oracle. Built custom interfaces to interface between the other working systems and integrating them into the oracle system. Worked extensively on the different reports the company was using, finding the appropriate oracle standard reports that could replace and also building other custom reports using Oracle Reports Designer. Since the steel industry has very custom requirements, customizations were extensive and hence many custom forms were built using Oracle Forms Designer. Single handedly, created the Positive Pay system where bank transfers were done using Sql*Loader, Unix Shell Scripts, Oracle SQL and PL/SQL. Also, designed and developed a new shipping solution using Oracle Forms and PL/SQL as the standard oracle shipping did not satisfy what the steel plant required. Also designed and developed a new Inventory Movements Solution where User could pull up a particular item using catalog element values, using a custom form and it would bring up every item in inventory and in WIP for that condition and user can use reason codes which would automatically perform different inventory transactions and assign appropriate accounts to it and create the specific transactions. This was a one screen form which was used in multiple plants and was the most used system in the company. It helped users to get things done quickly and also helped the business side of the company.

Implmented the oracle applications system in 2003 and was involved in every enhancement that was done from then on. Created a HOLD system which would put the scrap, reworks and remakes on HOLD and not to be transacted. User did not have to manually put them on HOLD using the standard oracle system. Extensive use of PL/SQL to create Triggers, Concurrent Processes and Send Notification Emails.

Was involved in using Formscape, a third party tool to print reports (both standard and custom) with Logos and other custom information. Was involved in using custom reporting systems that would show some of the oracle reports on the Intranet – from the Oracle Applications to Unix to the Intranet. Was useful to the business administrators mostly During this project, was also involved in mentoring and managing junior consultants, performance reviews of consultants in the team, assigning tasks to other team members, reporting to upper management, project planning, project management, project delivery, customer interaction and customer relationship

Extensive Usage of Oracle Applications, PL/SQL, SQL scripts, Oracle Forms, Oracle Reports, Unix Shell Scripts, Workflow Builder, SQL*Loader, TOAD, Formscape and RMS Toni & Guy USA Inc - USA April 1999 to Feb 2000

Senior Principal Consultant

Contracted through KPMG Consulting and Hencie Consulting Used KPMGs ROI method for this implementation. Started this project one day one – involved in planning, designing, implementation and support of the project. This project involved conversions, interfaces, implementation and support. Data was already pulled out and in .csv format. Had to convert them all into oracle. Multiple interfaces needed to be built in order to interface some of their systems into the oracle applications. Since Toni & Guy is a retail industry, there were multiple reports and processes that had to be dynamic and current. Developed many reports which would keep changing by the minute (including the headers and footers in the report). Also developed a point of sale system for their daily proceses. The Positive Pay process was also developed. System Administration, Applications Developer, GL, AP, AR, HR, PO and Inventory were the modules used.

Extensive Usage of Oracle Applications, PL/SQL, SQL scripts, Oracle Forms, Oracle Reports, Unix Shell Scripts, SQL*Loader and TOAD

Optel Inc - USA May 1998 to April 1999

Principal Consultant

Contracted through KPMG Consulting and Hencie Consulting Used KPMGs ROI method for this implementation. Started this project one day one – involved in planning, designing, implementation and support of the project. Was the only technical resource on this project. This project involved conversions, interfaces, implementation and support. Data was already pulled out and provided from the legacy system. Had to convert them all into oracle. This was a cable company and just the financials modules were implemented and supported. System Administration, Applications Developer, GL, AP, AR, HR, PO and Inventory were the modules used.

Extensive Usage of Oracle Applications, PL/SQL, SQL scripts, Oracle Reports, Unix Shell Scripts and SQL*Loader

Southwestern Bell Corporation (SBC) - USA Feb 1997 to May 1998 Software Consultant

Contracted through Pentafour Softwares & Exports

Primarily Worked in the Accounts Payables and General Ledger Modules of Oracle ERP. Developed interfaces from the mainframe system to Oracle using PL/SQL and Unix Shell Scripts. Was involved in the support of the project. Had to monitor background processes every night and if any issues arose, had to call up the developer or the person in charge of the system, fix the issue and get it corrected in a timely manner.

Extensive Usage of Oracle Applications GL and AP modules, PL/SQL, SQL scripts, SQL*Loader and Unix Shell Scripts

5th Generation Systems - India Jan 1993 to Feb 1997 Director

Partnership concern started in 1993. Started off with training software packages like Oracle, PowerBuilder, Visual Basic, C, C++ and FoxPro. Later on, expanded the company to handle Software Development Projects also. The company later handled off shore consulting services, contracting consultants to companies in USA, Singapore and Dubai, Solutions Design and Development and Software Training. At one point had 300 students in the training division to be trained

National Institute of Information Technology - India May 1991 to Jan 1993 Senior Coordinator

Training students enrolling at NIIT. Languages trained in were Cobol, DBase III+ and DBase IV, FoxPro and C. Was also involved in some of the marketing areas of the company EDUCATION & STATUS

Bachelors of Science

US Citizen

SKILLS

Oracle E-Business Suite, PL/SQL, Oracle DB, Oracle Applications (Financials, Manufacturing, Distributions, HR), Enterprise Resource Planning (ERP), Unix Shell Scripting, Oracle Reports, Oracle Forms, Visual Basic, Requirements Analysis, Oracle Discoverer, Business Intelligence, Software Project Management, IT Service Management, CRM, Enterprise Architecture, Microsoft Products

(Word, Excel, Power Point, Projects, Visio)

Contact this candidate