Developer Sql
Resume:
Biksham
Palabindela
*******@*****.***
(H)
(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