Oracle Sql

Location:

2451

Posted:

March 09, 2010

Contact this candidate

Resume:

UMAKANTH PIPPALAPALLI Oracle Developer.

Email: ********.*@*****.*** Phone Number: 217-***-****.

SUMMARY:

• 6+ years of strong experience in software development using Oracle Forms 6i, Reports

6i, SQL, PL/SQL.

• Worked on Customization, Implementation and Technical Support of Oracle

Applications modules.

• Good Experience in working with RICE components.

• Vast experience in working with end users in analyzing business requirements.

• Extensive experience in design, development and testing of Oracle applications using

PL/SQL, Forms 6i, Reports 6i.

• Strong experience in data migration processes using PL/SQL, SQL*Loader, Shell

Scripts, Pro*C, CLEARCASE TOOLS etc.

• Extensively fine tuned queries using EXPLAIN PLAN and TKPROF.

• Extensively worked on Data Conversion and Interfaces using Oracle Standard API’s

and Open Interfaces.

• Full life cycle development experience including design, analysis, implementation and

testing.

• Excellent presentation and communication skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, XML, JAVA/J2EE, JSP, C, C++, VB.net, UNIX

Shell Scripts, DCL Scripts.

Web: HTML, XML, JavaScript and VBScript

Database and Tools: Oracle RDBMS, Oracle 8i/9i/10g, Forms 6i, Reports 6i,

SQL*Loader, Discoverer4i, Oracle Designer 6

Application Servers: Oracle Application Server, Apache Web server, Citrix Server

Platforms: Windows NT/2000/XP, HP-UNIX, AIX 4.3, Sun Solaris, Linux

ERP: Oracle Applications 11i.

PROFESSIONAL EXPERIENCE:

McCarthy Buildings Inc., St.Louis, MO Mar 2008- Present

Role: Oracle PL/SQL Developer

Responsibilities:

• Worked on developing new PL/SQL procedures and customizing the existing ones to

match the requirements.

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to

retrieve data from the database.

• Extensively involved in the development of new custom forms with template.fmb to

support the business needs.

• Customized reports like Order Details Report, Order/Invoice Report according to the

requirements.

• Involved in the customization of several reports like 1099 reports, Tax Information

Verification Letter in Payables, Form 4797 reports, Employee Vehicle Assignment

report in FA, built new reports like New Hire report Payroll and Rental Expenses

Report Project Accounting.

• Fine tuned the existing Reports and Procedures using Explain Plan and TK Prof.

• Wrote test cases and performed Unit testing.

• Involved in modifying various existing packages, procedures, functions and triggers

according to the new business needs.

• Defining concurrent programs, executables, and value sets, creating users, defining

responsibilities and assigning responsibilities to users with System administrator

responsibility.

• Used Oracle Designer for creating tables, views, packages, triggers etc.

• Involved in collecting requirements from the user along with the functional team and

providing solutions.

• Designed different value sets were designed and set to control the parameters

required for concurrent programs.

• Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow

diagrams using Microsoft Visio.

• Used SQL LOADER to upload the information into the database.

• Used Explain Plan for query optimization.

• Used Clearquest/ Clearcase tools for Version control.

• Developed Rational ClearCase application, (integrated with ClearQuest), to provide

automated Configuration Management/Release Management capabilities to local

development team.

• Documented technical specifications (MD 70), data conversion documents, test

scripts using AIM methodology.

• Involved in migration of Database tables from Oracle 9i to Oracle 10g, gap and map

analysis, design and customization as per the business rules.

Project Environment:

• Windows XP, Oracle Applications 11i, Oracle 10g, Forms 6i, Reports 6i, Oracle

Designer 6, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX Shell scripts.

Mar 2007 – Feb 2008

Oxford Health Plans, Trumbull, CT

Role: Oracle Developer

Responsibilities:

• Customized forms using custom.pll in AP, AR

• Customized several Reports in AR, GL and PO using Reports 6i.

• Collected User Requirements by participating in meetings and studying existing

System

• Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow

diagrams using Oracle Designer.

• XML Publisher reports like Employee performance report, Direct Debit Letter for

Customer Receipts (AR) and Payment Acceptance Letter (AP).

• Implemented Extraction, Transformation and Loading procedures for Transactions,

Holdings, Assets and Ratings data extracts.

• Used IBM Rational ClearCase as a versioning tool for checking in and checking out

files and packaging them for deployment.

• Created database objects like tables, views, Sequences, Directories, Synonyms, stored

procedures, function, packages, Cursor, Ref Cursor and Triggers.

• Involved in analysis, design, coding and Testing

• Involved in modifying various existing packages, procedures, functions and triggers

according to the new business needs.

• Created Unit Test Cases and Results to verify the process, Created process flow

diagram, used PVCS to manage change control for all the code.

• Customizing the developed screens according to user requirements.

• Created Database design and converting them into database objects.

• Worked on interfaces to AR and AP for importing customer information, Auto

Invoice and expense reports from legacy systems.

Project Environment:

• Windows XP, Oracle Applications 11i, Oracle 10g, Forms 6i, Reports 6i, PL/SQL,

SQL*Loader, SQL*Plus, Java, TOAD, UNIX Shell scripts

July 2005 – Feb 2007

Clinical Trial Services, Audubon, PA

Role: Oracle Developer

Responsibilities:

• Programmed using object-oriented tools of Oracle 8i and Forms/Reports 6i.

• Customized existing forms and reports and developed new forms and reports as per

requirement definition.

• Developed Business areas and Workbooks in several modules and created End User

Layers using Discoverer4i.

• Assigned securities and privileges to different users and developed custom folders in

Receivables and Purchasing using Discoverer 4i.

• Gathered requirements, developed functional & technical design for various revenue

forecasting reports, designed interface for the Payables Department to Process

Customer Refunds.

• Provided knowledge to users to drill through data with different time periods using

Discoverer 4i.

• Added new fields in the item status report and developed a new report to get the item

details in any given organization of Oracle Inventory.

• Customized Routing reports in BOM to add the System Items key flex field

quickpick for all the items based on user organization.

• Added ‘Item Type’ field in Listing and consolidated reports of Oracle BOM and

modified the report output.

• Developed conversions and interfaces of the company’s legacy information into

Oracle Applications Release 11i using PL/SQL, SQL* Plus, and SQL* Loader and

interface programs.

• Involved in extracting data from various data sources in particular relational database

(oracle and non - oracle), flat files and data that reside on mainframe systems, source

to target mapping in order to provide a context.

• Worked on interfaces for Journal Import, customer import, invoice import and budget

upload.

• SQL tuning by TK-PROF and EXPLAIN PLAN.

Project Environment:

• Unix, Oracle Applications 11i, Forms 6i, Reports 6i, Crystal Reports, Discoverer 4i,

PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX Shell scripts

Jan 2004 – Jun 2005

ADP, Roseland, NJ

Role: Team member

Responsibilities:

• Developed Stored Procedures, Function and Packages for a Financial Accounting

System. Used database triggers and PL/SQL for development of System.

• Designed and developed Implemented PL /SQL programs for AP Invoice Open

Interface Program.

• Responsible for setting up Key flexfields and descriptive flexfields. Modified reports

to reflect the descriptive flexfields.

• Registered Custom Reports, Forms and Concurrent Programs through AOL.

• Created tables and views in Oracle 10g database.

• Successfully completed all my tasks and met the expectation of client.

• Defining concurrent programs, executables, and value sets, creating users, defining

responsibilities and assigning responsibilities to users with System administrator

responsibility.

• Developed and modified various reports in purchasing module.

• Created instances, schemas, users, profiles and roles.

Project Environment:

• Oracle Applications 11i(11.5.9), Forms 6i and Reports 6i, PL/SQL, SQL*Loader,

SQL*Plus, TOAD, UNIX, Shell scripts

Feb 2003 – Dec 2003

DOUBLE CLICK, New York, NY

Role: Team member

Responsibilities:

• Responsible for collecting user requirements for customizing out of the box

implementations of GL, AP, AR.

• Responsible for setting up descriptive flex fields and Blanket Purchase orders in

Oracle Purchasing.

• Customized reports, forms to meet the customer requirements.

• Developed interfaces to port data from Legacy systems to Oracle.

• Modified reports to reflect the descriptive flex fields.

• Implemented conversions that include Customer information and Receipt information

in AR through Auto lock box, Customer interface.

• Developed and implemented Conversion programs for Standard Purchase orders.

• Installed and configured oracle 8i.

• Designed and Developed forms and reports with Oracle Developer6i/ Crystal Report,

PL/SQL, Procedures, Functions, Triggers

• Coding, unit, integration and load testing

Project Environment:

• Oracle Applications11i, Oracle 8i, SQL*Plus, SQL*Loader, PL/SQL, Forms 6i,

Reports 6i, Shell Script, TOAD, Sun Solaris, Windows 2000, Discoverer3.0

Jun 2002-Jan 2003

WEBTEK Software Ltd, Hyderabad, India

PL/SQL Programmer/Web designer

Responsibilities:

• Used Forms 6i to design front-end development application.

• Validations have done in front-end and as will in backend using triggers

• Wrote Procedures using Oracle supplied Packages

• Java Script was used for client side validations.

• Involved in programming using JDBC, Servlets and Oracle to retrieve data.

• Wrote many complex reports in Salary, Overtime, Bonus and other benefit by using

reports 3i.

• Used Snapshot to transfer the data from branch location.

• Receives data from different branches it will load by SQL Loader

• Involved in writing DB triggers to update in master tables and calculation

• Design and execute complex SQL Queries and PL/SQL codes to enhance the existing