Sr Developer & Analyst

BASAVARAJ B.V

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

Mob: 91-968*******

Objective To work on Database Development , Maintenance or Support with committed and dedicated people in the vast fields of software development

Summary Having done 1.5yrs of experience in ORACLE 9i/10g PLSQL Developer

xxxxx company.

with the guidance of Database Architect

Have experience in Software Development, Testing maintenance of Databases on both UNIX and Windows Environments

Having Sound skills in implementing the Developments on Oracle 9i/10g.

Sound knowledge on oracle 9i/10g, SQL (Tables, Views, Materialized views, Normalization, Indexes, sub queries, joins, Constraints, Sequences, Sql Functions, UNION Operators, Hierarchical queries, Aggregate Functions, Sql Performance Tuning, Advanced Queries, Report Generation ), PLSQL (Procedures, Functions, Packages and Triggers, Cursors, Dynamic SQL, DBMS Packages, Collections, Error Handling, Object Types) UNIX and Shell Scripting.

Having exposure to Retail applications

Ability to co-ordinate with people by being a team player

Strong Problem analyzing skills to provide quick solutions

Certification Oracle certified as sql\plsql developer.

Academic Chronicle

Bachelor’s Degree (B.E in ECE ) from Appa Institute of Engineering & Technology, Gulbarga.

10+2from Siddaganga PU College, Tumkur.

S.S.L.C from Government High School, Kakkera.

Skill Profile

Skill Profile

(Continued)

System Design and Development

Coding, Support, Maintenance, Production Release, Troubleshooting,

Onsite project coordination

Operating Systems

Unix, Windows.

RDBMS

Oracle 9i/10g

Languages

oracle 9i/10g, SQL (Tables, Views, Materialized views, Normalization, Indexes, sub queries, joins, Constraints, Sequences, Sql Functions, UNION Operators, Hierarchical queries, Aggregate Functions, Sql Performance Tuning, Advanced Queries, Report Generation ), PLSQL (Procedures, Functions, Packages and Triggers, Cursors, Dynamic SQL, DBMS Packages, Collections, Error Handling, Object Types) UNIX and Shell Scripting.

Tools & Utilities

TOAD (Tool for Oracle Application Developer),

isql, Sql * Plus, Control M

Assignments

Project #1

Product Marketing System

Operating System

Unix (Server), Windows XP (Clients)

Languages

Oracle 9i/10g , SQL, PLSQL, UNIX.

Description

The Product Marketing System (PMS) is the database used by all retail mutual fund applications like CRM, data integrity maintenance System, Siebel Analytics, Reporting system and Mobile sales force application.

PMS database follows a 3-tiered hierarchical structure – Dealer, Branch, Agent (AG). A Dealer has many branches, spread all over the Country. A branch has many Agents or Sales representatives working within it.

Customers are serviced by a team of wholesalers, organized by line of business.

Customers can engage in 3 types of transactions - purchase, redemption and exchange (when money is transferred from one fund to another).

Responsibilities

• Involved in Maintenance and development of the application

• Involved in Creating table definitions, Table creations, Mapping, Data Flow.

• Involved in Creating views, Indexes, Constraints

• Writing Procedures and Cursors for Data manipulation and Data Massaging.

• Writing Functions for Data Validations

• Creating Packages for Grouping related activities in single package and to handle it globally

• Evaluating the Performance and tuning the queries and procedures

• Writing Dynamic SQL for Report generation and automating the same using UNIX Shell Scripts

• Testing the Code in QA and fixing the Bugs and releasing it into production.

• Scheduling the jobs using DBMS_Job, Control M and Corn Tab and running the same.

Assignments

(Continued)

Project #2

Academic Project : PIR based boarder security system.

A PIR (passive infrared) detector coupled with an electric light is now widely used for intruder protection. The PIR detector used in this circuit reacts to fast temperature variations caused by the movement of people or animals in an enclosed space. A GSM module is used for communication and RFID tags for identification. This project used to prevent intruders from invading privacy. This system is used in shops to keep an eye on shop lifters and used in homes to prevent intruders from invading your privacy.

Achievements

First prize in district level volley ball.

Favorite Pursuits Listening music, playing volley ball, watching cricket, cooking.

Contact Details

#193/B, 55th cross, 4th block, Rajajinagar

Bangalore 560010

Languages

Known English, Kannada,hindi

Declaration: I hereby declare that the above statements are true to best of my knowledge.

Place: Bangalore. Signature:Basavaraj B.V.

Contact this candidate