Confidential is a senior Oracle PL/SQL Developer with 8 progressive years of experience delivering complex Oracle Database applications for enterprise level clients. As a Senior Developer, he has led the development and maintenance efforts of Oracle database applications. Venkatesh is experienced in conceptualizing software solutions at both the unit level and at the system level and also has experience in Linux Unix environments knowledgeable in both navigation and use of shell scripting. Venkatesh demonstrates a thorough understanding of the latest development techniques including development standards, philosophies, tools and applications. Venkatesh's communication skills coupled with his extensive technical skills in Oracle Database systems will quickly provide value to your organization.

Summary

• Around 8 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11g , SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Rich experience in project management activities like scheduling, planning, reviews, status tracking, risk management and Quality Assurance.
• Having diversified experience in software design, development, testing and implementation using PL/SQL, UNIX Shell and Perl scripting.
• Responsible for conducting performance evaluation and performance tuning and optimizing Oracle database using Explain plan, Partitioning, Indexes etc.
• Managing project scope and change control and escalating issues where necessary
• Liaison with, and updates progress to, project steering board/senior management
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block
• Responsible for team building and provide technical assistance to the project team.
• Experience in handling activities allied with interface files maintenance, incident/problem/change management support, and post change support.
• MS SQL Server and SQL programming experience knowledge
• Worked on Production Support, attending production calls, troubleshooting the application slowness to meet the SLA's.
• Expert in creating PL/SQL Packages, Analytic Functions, Stored Procedures, Triggers, Views, Material Views, Indexes, Constraints, Oracle XML packages,Sequences, Exception Handling, Collections and Records using PL/SQL Developer and TOAD.
• Working knowledge of SQL Trace, TK-Prof, Explain Plan, SQL Loader for performance tuning and database optimization.
• Experienced in Data Warehousing project.
• Strong knowledge in DBMS RDBMS and OOPS concepts.
• Hands on experience in UNIX - Putty ETL tool.
• Experienced in Software testing life cycle STLC models like Water Fall, Agile and V-model.
• Maintaining and updating the system and data base management as per the requirements of the organization. Involved in appraising team members during the design and implementation of the project.
• Source code changes exactly in line with Technical Specifications and Program Specifications. Coding standards are followed in all the source changes made.
• Maintain the code versions in PVCS and CVS.
• Ensure developers complete the Source/program changes on or before target end date with NIL defects.
• All the source code/snippet/retrofit changes are present in the latest/final version of source codes.
• Zero tolerance in Check-in and Check-out activities.
• Having good exposure at Jira for issue tracking and project management.
• Working closely with Interfaces teams for in-time delivery of project.
• Experience in a variety of different environments like Unix, HP-UX, Solaris and Windows
• Experience in Loading the files data by SQL Loader and External tables
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• 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.

Technical Skills

• Programming Languages: SQL, PL/SQL
• Database Utilities: TOAD, PL SQL Developer,SQL Plus,SQL Developer
• Database: Oracle 8i, 9i, 10g, 11g, MS SQL Server
• Reporting Tools Crystal reports,OBIEE
• Operating Systems: Windows, UNIX, HP-UX,Solaris,Linux
• Scripting Languages: Shell, Perl
• Configuration Controller: Clearcase, SVN
• Issue Tracking Tools Atlassian Jira
• Others SQL Loader, External Tables,VM Ware,Script Runner, UTL FILE utility
• Performance TK-Prof,Explain Plan,SQL TRace

Professional Experience

Confidential Senior DB Developer

• Project Description: The V3 System is a fully browser-based, Java/Oracle, software application. It is an extremely configurable, scalable solution designed to meet the unique needs of medium and large scale insurance, pension, investment and benefit administrators. The V3 System's vast array of processing capabilities all exist in a single, fully integrated solution. This includes deep domain-specific functionality spanning insurance, pension, investment and benefit processing features. This also includes extensive enterprise capabilities like workflow, imaging, self-service, CRM, Business Intelligence and more. The system's many features and capabilities can be used in any combination in a single installation. This creates tremendous opportunities for system consolidation and data de-duplication while potentially revolutionizing your organization's administrative capabilities and customer service offerings.
• The V3 System is a contemporary technology solution that can be deployed as a traditional on premise application or as a fully-hosted, cloud-based solution. The V3 System supports current releases of Internet Explorer, Firefox, Safari and Chrome. It runs on the Oracle 10g or 11g database and supports both Web Logic and Web Sphere application servers.

Responsibilities:

• Wrote PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Created database objects tables, views, triggers, according to the requirement.
• Extensively used Records, PL/SQL Tables, Objects, Collections Nested Tables and Arrays , and Bulk methods to improve the performance of the application
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Created database objects like tables, views, procedures, packages using Oracle tools like PLSQL developer and TOAD.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Report generation by using the Crystal reports
• Involved and Coordinated Production / QA release activity.
• Automated Batch Jobs by writing Unix Shell and Perl scripts.
• Performed exception handling for data that did not conform to the required format.
• Coded PL/SQL Procedures, Functions and Packages for batch processing of the applications
• Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting.
• Resolving the JIRA tickets on priority basis.
• Used Version Control tools like Tortoise SVN,Clearcase..
• Involved in unit, performance and integration testing of data stage jobs and prepared documentation.
• Able to hands on development on PL/SQL code on an Oracle 10g database, delivering the functionality detailed in the technical specifications, with sufficient focus on application performance.
• Expertise at working at remote systems via VM Ware machines
• Contributed extended support for system testing and UAT testing.

Environment: Windows XP, Oracle SQL PLSQL,SVN,Unix, VM ware , TOAD Tool for Oracle Application Developers ,PLSQL Developer, Crystal reports

Confidential Database Designer

Project Description: GRDW Group Risk Dataware House is an oracle MIS Bank application which consolidates on and off balance sheet information across the group. It is a single instance application and stores wholesale data at a Granular level and retail data at summarized pool level for group and subsidiaries.GRDW provides data to number of down streams operational and MI reporting system to measure and support management of the group's exposure to risk. It also provides data for BASEL capital calculations/reporting.

Responsibilities:

• Design/Develop various technical components such as PLSQL and SQL Reports, workflows, etc. as well as participate in the maintenance of existing reports.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database
• Experience in Report generation by using the Crystal reports
• Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.
• Created automated jobs using UNIX Shell scripts by passing all sql scripts as parameters.
• Involved in CMR creation and DB Changes Consolidation activities
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed various procedures, functions and packages to implement the new business using Oracle PL SQL.
• Statement level, row level database triggers were developed for auto updating the data.
• Responsible for code development using PL/SQL in UNIX environment.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes.
• Tuned SQL queries to enhance performance, using Explain Plan both at backend and in Toad.
• Extensively used complex SQL queries with various Joins, sub-queries to validate data.
• Creation of database objects like tables, views, procedures, packages using SQL Plus and PL/SQL
• Able to hands on development on PL/SQL code on an Oracle 10g database, delivering the functionality detailed in the technical specifications, with sufficient focus on application performance.

Environment: Oracle10g/11g SQL, PL/SQL, TOAD, SQL Developer, Unix, HP-UX, HPSA,Solaris, MS SQL Server, MS DTS/SSIS, Crystal reports

Confidential Software Developer

Project Description: Campaign Manager is a Web-based application that allows marketers to run online direct marketing campaigns from initiation to completion. Campaign Manager provides a modular workflow, allowing tasks to be distributed among personnel within a marketing program or between an agency and a marketing program. Along with Analytics Workstation, Campaign Manager is an integrated. Component of the IMPACT suite. IMPACT provides a complete set of online direct marketing tools. Campaign Manager can also function independently of Analytics Workstation.

Responsibilities:

• Requirement gathering, Functional technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Generated SQL and PL/SQL scripts to install Create and Drop database objects, including Tables, Views, Primary keys, Indexes, Constraints.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Loaded data to database using oracle tools like SQL loader and external tables to load data.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Worked extensively on exception handling, to trouble-shoot PL/SQL code.
• Prepared test plans and performed Unit Testing and Integration testing.
• Implemented Complex business Logic as per the client requirement in procedures, functions, packages.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL plus.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan.

Environment: Windows XP, Oracle 9i, 10g,Unix,Solaris,,SVN, Perl and Shell, Impact Manager tool

Confidential Software Developer

Project Description: The Company have various stores and maintains databases with lots of historical data. The system has a database, which stores information about sales, profits and contacts of customers. Using this existing database, the system should analyze the sales and profit and generate reports for Sales and Profits in month wise and year wise. With the Sales and Distribution Analysis, the resulting model gives us an idea about growth in profit, forecast about increase in sales. The data system was further used to do Market Based analysis. The data system plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies

Responsibilities:

• Created database objects such as tables, views, synonyms, indexes, sequences and as well as custom packages tailored to business requirements.
• Writing extensive PL/SQL code for customizations as needed
• Creation of unit test cases
• Optimized SQL statements for customer summary reports.
• Improved the performance of long running views and stored procedures.
• Wrote and modified stored procedures to implement the complex business needs for generating new customer number, account no, increasing, decreasing and setting credit limit as per business policies, updating user profiles, transaction processing, generating messages with code encryption
• Worked with Erwin data modeling tool
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts for database performance analysis

Environment: Oracle10G SQL, PL/SQL, TOAD Tool for Oracle Application Developers , PLSQL Developer, Unix