Post Job Free

Resume

Sign in

Developer Sql

Location:
Sunnyvale, CA, 94087
Posted:
June 23, 2013

Contact this candidate

Resume:

Biksham

Palabindela

abzaj3@r.postjobfree.com

408-***-****

(H)

408-***-****

(C)

PROFILE:

A self-motivated and results oriented IT expert with over 16

years experience in the area of Relation Database Design and Development for

Client/Server environments. Competent Oracle Developer with proven project

experience in rapid application development using Oracle Developer/2000 (Forms

and Reports). I am keen to assume challenging responsibilities that will

utilize and further my current skills and experience.

Technical Summary:

Over

16 years experience in commercial application design and development, testing,

reverse engineering Oracle Designer/2000 and Oracle Developer/2000 tool sets in Windows NT.

Strong

in design and development of commercial, business, engineering and applications

using Structured Methodologies/CASE Tools.

Exposure

to quality assurance tests, User Interface Standards and coding standards.

Computer knowledge: Strong working knowledge of Oracle

and its tools SQL, SQL*PLUS, PL/SQL, Dynamic PL/SQL,

Oracle Forms/Reports(6I), Sql*report

writer, Sql*Loader, Imp /Exp. Utility, Performance, Tuning, UNIX, and CVS.

Languages: PHP, JavaScript, HTML, CSS, Dream weaver

4.0. BASIC, C, SQL, HTML,and CSS, VB

(6.0).

Packages : MySql, ORACLE (7.3,8.0,8I,9i,10g,11i, 11g).MKS,

TOAD.

Professional Experience:

eBay,

San Jose, CA June 2013- 2013

Hiring Talent:University Team is not able to track

the hiring activity of recent college grads and interns based on the university

or schools they are currently enrolled in or have received their degree

from. They need to know the degree and graduation

information to ensure they’re being put into the right program tracks.

Attend scrum meetings to quickly update

status of the tasks.

Analyze business requirements and

prepare solutions.

Design Databases for multiple projects

and programs.

Write reusable packages, procedures,

functions.

Space Systems/Loral,Palo Alto, CA Feb 2001- June 2012.

Designed and developed code for the

Telemetry and Command System. This

system enables satellite engineers to build up a complete database of software

commands (issued from ground control or the on-board computer) and associated

telemetry data (status and diagnostic data returned from satellite

electronics). All electronic devices, wiring, commands, and telemetry are

modeled, thus allowing a full simulation of satellite functionality to occur

prior to build and launch of satellite.

Coded generic change tracking and

approval system for all edited tables. This generic mechanism tracks every user change at the table and column

level.

Coded table-driven security mechanism

providing granular access to various aspects of systems (screens, menus,

subsets of data).

Major Contribution:

Ø Developed

much of the Code Generator that produces 90% of the PL/SQL code required to

support each user screen. Using advanced

dynamic SQL and PL/SQL techniques, this code reads Oracle Dictionary objects

(Table and Column definitions, Primary and Foreign Key Constraints, etc.) and

creates the following stored procedures (and much more):

Ø Produces

clean, formatted, indented code that follows company coding standards (variable

naming conventions, calls to common utilities, clean indenting and formatting

of code, etc.).

Ø Greatly

improves maintainability since the 45 generated packages all look and read the

same.

Represented our server development

group on the Test and Deployment Team. Worked closely with key super user and key client developer to develop

test procedures to fully test all logic scenarios.

Duties:

Attended daily Scrum meetings with the

team for daily updates on the projects.

Self-starter,

with ability to work in a team environment and as an individual.

Maintain

and modify PL/SQL programs.

Data Modeling, Data Warehousing, PL/SQL, ETL

processing.

Managing Oracle objects including tables,

indexes, views, constraints, db links, jobs, snapshots, etc.

Strong

PL/SQL experience writing Procedures, Functions, Packages, Triggers, Views etc.

Ability

to write well-abstracted, reusable code for all modules.

Testing

and validating work produced as part of the development process.

Strong

knowledge using Oracle Collections, Bulking techniques, Partition utilization

to increase performance.

Troubleshoot/Resolve

any Database/Application issues.

SQL Tuning experience. Understand the Oracle query optimizer..

Design,

Develop and Maintain of related Forms and Reports.

Developed

advanced database driven Web Applications.

Managed multiple assignments, set priorities

and meet deadlines..

Documenting

features, technical specifications & infrastructure requirements.

Environment:

Role: Sr.Oracle Developer.

OS: Windows NT 4.O. Windows

XP. Unix.

Languages: PHP,

Oracle, Dynamic SQL, PL/SQL 8.0,

SQL*PLUS, HTML, JavaScript, VB 6.0. And MKS

Mass Properties: Mass Properties Calculation and Fuel Analysis in the

Conceptual Design of Uninhabited Air Vehicles.

The determination of an aircraft’s mass

properties is critical during its conceptual design phase. Obtaining reliable

mass property information early in the design of an aircraft can prevent design

mistakes that can be extremely costly further along in the development process..

Duties:

Attended daily scrum meetings with the team for

daily updates on the projects.

Communicated with different client, team

members, project managers, and co-workers.

Participate in technical discussions. Come up

with innovative ways to improve the product and process.

Strong PL/SQL, SQL experience writing

Packages, Procedures, Functions, Triggers, Views, DB Links, Synonyms etc

Designed developed code using ORACLE Dynamic

PL/SQL, SQL, FORMS, HTML, CSS, JavaScript.

Develop

and maintain interfaces to/from external systems and custom code in accordance

with business requirements.

Performed key role in cross-functional teams

through development, testing, and product launch.

Inventory Tracking System:Developed

Inventory Tracking System for warehouse department. Software allows employees

to receive, ship, and track parts as well as print out shipping and receiving

labels in pdf format. Application also allows employees to perform inventory

adjustments and cycle counts. Customers can log in and view inventory and

history reports.

Duties:

Attended daily scrum meetings with the team for

daily updates on the projects

Communicated with different client, team

members, project managers, and co-workers

Worked with Business Analysts and customers to

understand and validate end-user requirements in accordance with business need.

Develop PL/SQL packages, Procedures, Functions,

Triggers.

Developed advanced Web Reports by using PL/SQL,

SQL, HTML, JavaScript, and CSS.

Managed multiple assignments, set priorities

and meet deadlines.

Performed key role in cross-functional teams

through development, testing, and product launch.

Charitableway.comSan Carlos, CA Dec 2000 – Feb 2001.

Responsible for development of funds

disbursement process, which disbursed funds, based on affiliate’s specific

disburse routing options.

Writing code, which allow user’s to

change the charities, which are associated with pledges.

Developed data upload scripts using

SQL*Loader which uploads data from the legacy (spreadsheets format) into oracle

database.

The procedures, functions, packages and

triggers were developed using PL/SQL.

Also

handled some of the DBA’s responsibilities which includes creating user’s,

altering user’s, granting privileges, creating roles, modifying data types and

other responsibilities.

Environment:

Role: Oracle programmer.

OS: WindowsNT 4.O and UNIX.

Languages: Oracle8, SQL, PL/SQL

2.3,SQL*PLUS and SQL*Loader.

H

P: Santa Clara, CA. Jan 2000- Nov 2000.

Duties include monitoring and

reconciling daily production

Issues of the oracle 8.0 profiler database and data conversion.

Running and monitoring of the

customer’s sample database.

Application, additional tasks include

enhancing, testing

And implementing PL/SQL and HP-UX shell scripts to confront changing

business rules.

Create AD HOC SQL series to examine

possible data integrity flows and resolve phone and e-mail inquiries in a

timely manner regarding database structures and data analysis.

Also responsible for documentation

updates and production audit trail reports.

Analysis of exiting data, develop

strategy for conversion, develop processes to convert data, develop processes

to duplicate existing calculations, test Conversion routines, work closely with

the rest of the Reporting Project development team.

Environment:

Role: Oracle programmer.

OS: HP-UX.

Languages: SQL, PL/SQL 2.3,SQL*PLUS.

Bell Systems: Mountain

View, CA. Mar 99 to Dec 99

Responsible

for the design and development of a client- server application production

system consisting of software modules: portfolio entry, queue generation

forecasting module and account manager performance module using Oracle 8.0 and Developer/2000 (Forms 5.0

& Reports 3.0).

These

modules help in keeping track of portfolio details; product priority for

follows up details, performance forecasting at the end of each month and daily

performance of each account manager on daily basis.

Used

SQL, PL/SQL, SQL*Plus to write programs, functions and packages and manipulate

data.

Built

LOV'S, custom menus, master/detail relationship, record groups, object groups,

property classes, parameter lists, form parameters, libraries, and sequential

files to enhance the search methods and generation of forms and reports.

Designed

and developed Validation Triggers, Navigation Triggers, Mouse event Triggers,

Exceptions, System messages, Alerts, etc. to fully automate the system.

Environment:

Role: Oracle programmer

Software: Oracle

8.0, Developer 2000 (Forms 5.0, Report 3.0)

Languages: SQL, PL/SQL 2.3,SQL*PLUS.

SPNet Technologies: Milpitas, CA. May 98 to Feb 99

Responsible

for the design and development of a client- server application SISC system

consisting of three software modules: Product Entry, Pick slip generation and

Invoice Printing using Oracle 8.0 and

Developer/2000 (Forms 5.0 & Reports 30).

These

modules help in keeping track of order details; destination details, quality

and customer information, and details of scheduled delivery of partially or

completely filled orders.

Used

SQL, PL/SQL, SQL*Plus to write programs, functions and packages and manipulate

data.

Built

LOV'S, custom menus, master/detail relationship, record groups, object groups,

property classes, parameter lists, form parameters, libraries, and sequential

files to enhance the search methods and generation of forms and reports.

Designed

and developed Validation Triggers, Navigation Triggers, Mouse event Triggers,

Exceptions, System messages, Alerts, etc. to fully automate the system.

Environment:

Role: Oracle programmer

Software:Oracle 8.0, Developer 2000 (Forms 5.0, Report 3.0

OS: Windows

NT, 98

Source

one communication: Fremont, CA. Sept 97 to April 98

Part

of a team that developed Call Tracking and Information System for Customer

Relations Group.

This

system keeps track of all the calls, contact and Q&A information for a

Product Marketing Research group, Product module, research module, Quality

Assurance & Question Answer module,

I

was involved in the Development of GUI

using Forms 4.5 and Reports 2.5 for data entry of Product Information,

Research Information and Marketing Strategy. Multiple and Complex Reports were

written for research group, marketing group, and different management levels

sorting the data acquired.

Extensively

used triggers, packages to automate the system.

Customized

Menus

Triggers

were used to implement the business rules at the database end, to update the

data and for relevant calculations.

Environment:

Role: Oracle Developer

Hardware: IBM PC compatible

Software: Oracle

7.3, Developer 2000 (Forms 4.5, Report 2.5)

OS: Windows NT, 95

Education :

BS in Computers from Osmania

University, India.

Diploma

in Computer Applications from NIIT, Hyderabad- India

o Introduction

to Web Development from De Anza College, CA

o Diploma

in DBA from Exobase Corporation,

Santa Clara, CA.

Status: US Citizen.

References: Will be provided upon request.



Contact this candidate