Developer Oracle

Avanti Deshpande

Email: ***************@*****.***, Cell: 404-***-****, Home: 678-***-****

Summary:

. Over 5 years of IT experience in all aspects of Systems Development

and complete Project Life Cycle in Oracle and Java including

Requirements, Analysis, Design, Development, Testing and

Implementation.

. Extensively worked in development and maintenance of complex, high

performance and scalable distributed object-oriented applications in

Java, Java Applets, J2EE (Struts, Servlets, JSP, JDBC), Web Services,

XML, Pro*C. Hands on experience in Eclipse Plug-ins and WebSphere.

. Extensively worked in Client-Server application development using

Oracle 8.0/8i, 9i, 10g, PL/SQL and SQL *PLUS, SQL Trace, Explain Plan,

tkProf, SQL Loader.

. Extensively Worked on Oracle Database creation, Table space

management, expdp/impdp, data pump, DBCA, DBMS_STATS on Oracle 9i /

10g. Extensively worked in writing SQL queries, stored procedures,

database triggers, exception handlers, cursors, cursor variables,

PL/SQL programming and Query Level tuning.

. Highly skilled in UNIX Shell Scripting.

. Solid understanding of Object-Oriented concepts.

. Extensive experience in system administration.

. Familiar with Design Patterns (MVC), and Struts.

. Excellent Communication and Interpersonal skills.

. Experienced in managing offshore development team.

Education / Certification:

. BE in Instrumentation Engineering (Graduated - 2001)

. Post Graduate Diploma in Business Management (Graduated - 2003)

. Post Graduate Diploma in Advance computing (Graduated - 2005)

. SCJP (Sun certified Java Programmer)

Technical Summary:

Languages: Java /Java 2, J2EE, RDBMS: Oracle 8i, 9i, 10g

JavaScript, VBScript, Visual Basic,

C#, C, C++, Pro*C, SQL, HTML, XML,

ASP .NET, Power Builder

Java Skills: JFC/Swing, AWT, Applets, Web/Application Servers: Bea

JavaBeans, JMS, RMI, Servlets, JSP, WebLogic, IBM WebSphere

EJB, JNDI, JMS, JDBC, SOAP, Apache

Struts

Version Control: Clear Case, Tortoise Operating Systems: MS Windows

Sub Version Control XP / 2000 / NT4 / Vista, Unix

AIX, Linux

Experience:

Aldata Solutions Inc, Atlanta, GA

Sept 2008 - Current Date

Technical Consultant

Aldata is a global leader in the supply of integrated business solutions to

organizations that provide the best retail, wholesale, logistics, and

marketing services to billions of consumers around the world.

Responsibilities:

. Responsible for developing new screens for G.O.L.D Central frontend

module and enhancing the functionality of existing screens per client

needs; using Core Java and Applet

. Responsible for installing WebShphere Application server on Windows

and Unix platform. Responsible for resolving LDAP compatibility issues

with the WebSphere Server and G.O.L.D application.

. Responsible for development of the Web Services for the PIM module

within G.O.L.D application.

. Responsible for fixing bugs / defects; identified by Testing / Client

teams; for various G.O.L.D modules as well as Oracle Database. This

involved development and debugging in Core Java, Pro*C, database

objects.

. Created database objects such as table spaces, triggers etc. Developed

UNIX shell scripts for Importing and Exporting data into the database.

Familiar with Oracle Enterprise Manager Console.

. Responsible for environment set-up, module installation, maintenance

of Production Servers and Databases etc. for customer environment as

well Aldata Environment. Developed UNIX scripts for backing up the

server through corn job, Purging the space on the server.

. Responsible for source code version control for various G.O.L.D

modules for various clients. Developed the scripts for Branch creation

for the individual clients on Clearcase.

. Responsible for the Data Conversion at the client side using Pro*C.

. Instilled the Dev Testing process in Aldata technical team. Involved

in manual Functional testing (Unit Testing) for various G.O.L.D

modules pertaining to the bug fixes.

. Involved in defining new processes and enhancing existing processes

related to change management, on-site off-shore work distribution etc.

Responsible for creating documentation for operational tasks so that

team members can replicate the tasks consistently and efficiently.

. Responsible for managing the offshore Development team in India.

Environment:

Java Applet, JSP, Java Script, Web Services, XML, WebSphere 6.0/7.1,

Eclipse IDE, Ant, LDAP, Oracle 9i/10g, Windows NT/XP/VISTA/Windows7,

PL/SQL Developer 8.0, SQL Developer, TOAD, Linux, Unixm Oracle

utilities - Imp/Exp and Data Pump, SQL Trace and tkprof

Concept Software, Atlanta, GA

May 2008 - Sept 2008

Consultant / Developer

Worked on one of the most important client of Concept Software. The client

is leading provider of supply chain management software solutions for the

international retail, wholesale, manufacturing and 3rd party logistics

sectors.

Responsibilities:

. Involved in environment management and deployment of JAVA components

on WebSphere, creating WAR files for packaging and deployment.

. Created database objects such as table spaces, triggers etc.

. Developed UNIX shell scripts for Importing and Exporting data into the

database.

. Responsible for customer side environment set-up and module

installation.

. Responsible for bug verification, research and solution development

for the bugs / issues identified by QA / product support team in the

software deployed at client site.

. Responsible for creation of new process documentation and updating the

old documents for changed processes.

Environment:

Java Script, Java Applet, XML, WebSphere 6.0, Eclipse IDE, Oracle

9i/10g, Windows NT/XP, PL/SQL Developer 1.2.1, TOAD, Linux, Unix,

Oracle utilities Imp and Exp

SRG America, NJ

Dec 2007 - May 2008

Consultant / Developer

Worked on multiple projects the most prominent being for ETS (Educational

Testing Services). ETS supports products and services measure knowledge and

skills, promote learning and educational performance, and support education

and professional development for all people worldwide. The project was for

(National Board of Professional Teaching Standards) NBPTS the old system

was written in Forms and Oracle database. They were re-engineering their

Oracle Forms application to Java (JDeveloper). The business problem

addresses customer service, candidates, organizations, finance/accounting,

and warehouse operations.

Responsibilities:

. Responsible for bug verification, research and solution development

for the bugs / issues identified by QA / product support team in the

Web Based (Java) front end module deployed at client site. Used

Tortoise subversion repository for the project.

. Developed PL/SQL packages, Oracle tables, views, stored procedures,

functions, triggers via TOAD, SQL Developer, SQL *Plus.

. Performed Database Backup, Recovery and Performance tuning like SQL

tuning/Index tuning using Explain plan/Autotrace/Tkprof and sql trace

utility.

Environment:

Java, Servlets, JDBC, JSF, HTML, JavaScript, XML, Netbeans 5.0, JBoss with

Apache Webserver 1.0.1GA, Oracle 10g, Windows NT/XP, Tortoise SVN. PL/SQL

Developer 1.2.1, TOAD, Power Designer.

Citibank Dev Center Polaris, Mumbai, India

Jul 2005 - Jun 2006

Developer/Analyst

A TRIM is a system dealing with shipping documents related to banks such as

Letter of Credit (LC): Imports LC and Export LC, shipping bills etc. It is

one of the important projects handling Trade Transaction of CITIBANK;

currently live in 55 countries in ASIA, North America and EMEA regions. The

system was designed according to J2EE specifications. Servlets were used as

a Front Controller gateway into the system. Helper classes were used to

limit the business logic in the Servlet. EJBs were used to talk to the

database (Oracle 9i) and JSP along with HTML, XML were used to control the

client view.

Responsibilities:

. Involved in development of web interface using JSP, Servlets,

JavaScript and JDBC. Various forms were designed to implement the

business logic as identified by the requirements.

. Created complex SQL and used JDBC connectivity to access the database.

. Created database objects like tables, indexes, synonyms, views,

packages, stored procedures, triggers etc.

. Created test plan documents & scripts. Responsible for Unit testing.

. Supported Production activities.

Environment:

Oracle 8i/9i, TOAD, Windows NT/XP, UNIX, Plan View, JDK 1.3, EJB, Servlets,

JSP, JDBC, WebLogic Server 6.0.

Citibank Dev Center Polaris, Mumbai, India

Feb 2005 - Jun 2005

Developer

The project was to introduce a new processing center specific for Korea.

Citibank had taken over the KORAM, a regional bank in Korea. Citibank

management had decided to have Korea related data in separate database.

Hence there was a requirement to maintain a new Database and application

for Korea transactions. The old database was live in the Asia region from

2002, and the historical data was to be moved to new Database.

Responsibilities:

. Developed PL/SQL packages, Oracle tables, views, stored procedures,

functions, triggers and UNIX shell scripts via TOAD. Used built in

functions of PL/SQL such as SQLCODE, SQLERRM for error reporting.

. Created database storage structures such as table spaces, rollback

segments etc. Importing and exporting data into the database with

Oracle utilities Imp, Exp.

. Involved in Tuning the Queries to improve the Performance using

Explain Plan, DBMS_STATS etc. and analyzed tables and indexes for

performance tuning, optimizing database objects.

. Extensively worked in writing complex SQL Queries. Used SQL*Loader

control files to load data from external data sources into Oracle

database.

. Created test plan documents & scripts. Responsible for Unit testing.

Environment:

Oracle 8i/9i/10g, Unix, Windows NT/XP, Windows 2000, TOAD, MS Office 2000,

PL/SQL Developers, SQL*Plus, Power Builder 8.0, 10.0.

Post Graduate Diploma (C-DAC)

Aug 2004 - Feb 2005

Individual Contractor, India Aug

2003 - Aug 2004

Java Programmer/ Oracle Analyst

This project manages the flow of information for the advertising agency

from creating orders to billing to the client. Also helps to maintain the

standard data required for the agency such as client information, rates of

different newspapers etc. The project consists of an Intelligent Tool,

which helps the marketing team to provide optimal solutions to the clients

regarding the releases of the advertisements for various regions and

classes. It generates reports showing statistics, which helps the

management to take decisions at various levels.

Responsibilities:

. Utilized Struts (MVC2) framework and developed JSP pages, Action

Servlets and XML based action-mapping files for web tier.

. Involved in designed and development of web pages using JSP, Servlets,

JavaScript and JDBC for administering and managing users and clients.

. Responsible for developing and maintaining few of the entity and

session beans

. Worked on Database design, created functions, stored procedures,

trigger using SQL*Plus and written queries using PL/SQL. Created

SQL*Loader control files to load data from external data sources into

Oracle database.

. Conducted training sessions for the end-users.

Environment:

JAVA, J2EE, MVC and EJB frameworks, JSP, Servlets, Struts (Tiles, Taglibs),

J2EE Patterns, Oracle 8.0, PL/SQL, SQL, MS Office, Windows 95/98.

Multiple Lecturer positions, India

Apr 2001 - Aug 2004

Details will be provided upon request.

Contact this candidate