Developer Sql

KAPILDEV MADHUSUDAN ARADHYE

Phone: +1-203-***-****

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

Visa Status: H1B

Title: Senior Oracle database developer with 9+ year's experience.

Career Objective: To acquire the challenging position where my creativity,

energy, management,

skills, in a manner that improves the quality of the

software, programming and

experience can be applied with new learning experience.

Summary:

. 9+ Years of Experience as an Senior Oracle PL/SQL Developer with

Proficiency in Oracle 11g/10g/9i/8i, SQL,

. Oracle PL/SQL, UNIX Shell Scripting.

. Hands on experience in design, development of end user screens and

reports using Oracle Developer/2000 and Oracle Forms 6i

. Experience in data warehousing project.

. Solid experience of creating PL/SQL packages, Procedures, Functions,

Triggers and Views to retrieve, manipulate and migrate complex data

sets in Oracle Databases.

. Extensive working knowledge in developing Database Triggers, Stored

Procedures, Functions for

developing Forms and Reports.

. Experience in Performance Tuning & Optimization of SQL statements

using various types of Hints, Indexes, Explain plan, Oracle

Enterprise Manager query observation.

. Extensive experience in using Cursors and Ref-cursors for processing

of data.

. Good Knowledge on advanced PL/SQL constructs like Oracle supplied

packages, Nested tables, Varrays, Records and Types.

. Strong programming skills on Oracle SQL, PL/SQL indexes, bulk

collects and bulk variables.

. Extensive experience in data migration techniques using SQL* Loader.

. Experience in UNIX Shell Scripting.

. Worked with query tools like Toad, SQL*Plus, PL/SQL Developer.

. Enforcing experience in data integrity using integrity constraints

and database triggers.

. Expertise in handling errors using Exceptions.

. Experience in creating Materialized Views and DB links.

. Strong understanding of Object Oriented Analysis and Design with

interaction to Data architects.

. Extensively worked on Materialized Views, Database links and Table

partitioning.

. Excellent experience in writing UNIX shell scripts and DBMS packages.

. Experience in logical and physical design of Databases, Data Modeling

and Data Architecture.

. Excellent experience in Performance tuning SQL queries to optimize

system performance.

. Proficient experience in optimization of ETL procedures and packages.

. Excellent analytical and interpersonal skills, oral and written

communication skills.

. Ability to work individually as well as in a team with excellent

problem solving and troubleshooting

capabilities.

. Proven ability to handle multiple tasks with strong technical

aptitude and learning skills to adapt the rapid changing technologies

and implementing the same at work.

. Good experience of onshore/offshore working model.

. Experience in data ware housing project, ETL tool.

Work Experience:

Infosys Technologies Limited

(August 2006 - Till Date)

Location: Goa, India.

: Stamford, CT, USA.

Designation: Technical Lead

Role: Senior Oracle Database Developer

Clients: UBS Investment Bank, Daimler AG

Responsibilities:

. Onsite coordinator in onshore/offshore model.

. Single person database developer with access to production environment

in leading Investment bank.

. Onshore database developer for Trading application in leading

investment bank with exposure to production environment.

. Experience in Manufacturing and Investment Banking domain.

. Design and Developing of workflow procedures.

. Interacted with client to gather the requirements and implement the

same in the project.

. Assisting DBA for with basic analysis with handling multiple dbs.

. Implemented PL/SQL queries, triggers and Stored Procedures as per the

design and development related requirements of the project.

. Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL* Loader, Query

performance tuning, created DDL scripts, Created database objects like

Tables, Views Indexes, Synonyms and Sequences.

. Worked on SQL*Loader to load data from flat files obtained from

various facilities every day. Used PL/SQL Collections and used BULK

Binding involved in writing database procedures, functions and

packages for Front End Module.

. Handled errors using Exception Handling extensively for the ease of

debugging and displaying the error messages in the application.

. Created indexes on the tables for faster retrieval of the data to

enhance database performance.

. Extensively used the advanced features of PL/SQL like Records, Tables,

Object types and Dynamic SQL.

. Performed SQL and PL/SQL tuning and Application tuning using various

tools like EXPLAIN PLAN,

AUTOTRACE and OEM tool (AWR, ADDM)

. Written the ETL code in PL/SQL as per the functionality in Cognos.

. Has done end to end testing of the applications and Error casual

analysis

. Used PL/SQL and SQL*Loader to create ETL packages for flat file

loading and error capturing into log tables.

. Involved in testing the application for Oracle 10g to 11g R2 upgrade.

. Tuning of the SQL queries, which takes long time to process the

request using Explain Plan, Hints to reduce the response time.

. Involved in all phases of database development, from needs assessment

to QA/QC, design, and support.

. Created job scheduling tables

. Designed, developed and maintained UNIX shell scripts to collect and

monitor database metrics

. Analyze SQL statements, reorganize database objects and design indexes

to improve response of queries

. Hands on experience on ETL tool Cognos - Decision Stream.

. Database designing using ERWin

Environment: Oracle 10g,11g, TOAD, OEM, Pl/Sql Developer, ERWin, SVN,

Unix Shell script, Perl scripting.

Zuari Industries Limited

(December 2005 - August 2006)

Location: Goa, India.

Designation: Management Trainee

Role: Oracle Developer

Responsibilities:

. Single person database developer/support for the internal application

for material management.

. Written, tested and implemented various UNIX Shell, PL/SQL and SQL

scripts to monitor the pulse of the database and system.

. Requirement gathering and worked according to the CR.

. Code Development as per the client requirements in SQL, PL/SQL, Oracle

Forms 6i

. Involved in the development backend code, altered tables to add new

columns, Constraints, Sequences and Indexes as per business

requirements.

. Perform DML, DDL Operations as per the Business requirement.

. Creating views and prepares the Business Reports.

. Resolved production issues by modifying backend code as and when

required.

. Used different joins, sub queries and nested query in SQL query.

. Strong communication with users for requirement and defect fixes.

Environment: Windows 98/NT/2000, Oracle 9i/8i, TOAD, Database

Tools/Utilities.

LIST Softwares Pvt. Ltd.

(June 2004 - December 2005)

Location: Maharashtra, India.

Designation: Technical Associate

Role: Oracle Developer

Responsibilities:

. Strong team player in database development.

. Hands on experience in retail banking projects.

. Code Development as per the client requirements in SQL, PL/SQL, Oracle

Forms 6i, Developer 2000

. Involved in the development backend code, altered tables to add new

columns, Constraints, Sequences and Indexes as per business

requirements.

. Perform DML, DDL Operations as per the Business requirement.

. Creating views and prepares the Business Reports.

. Resolved production issues by modifying backend code as and when

required.

. Used different joins, sub queries and nested query in SQL query.

Environment: Windows 98/NT/2000, Oracle 9i/8i, TOAD, Database

Tools/Utilities.

Educational Qualifications:

Master in Computer Applications.

Skill sets:

Programming Languages : Pl/Sql, Sql

DBMS and RDBMS : Oracle 8i/9i/10g/11g

Hands on Experience : Unix, Perl scripting, Oracle Forms

Tools : TOAD, Pl/Sql developer, ER Win, OEM.

Contact this candidate