SUMMARY OF QUALIFICATION

• Eight plus years of IT experience as an Oracle developer, PL/SQL developer, System Analysis, Design ,Development Support of Oracle Database 9i,10g and 11g in Production, Staging, Development environments.
• Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and using the latest features to optimize performance Bulk Binds, Inline views, Global Temporary Tables, Flashback .
• Extensive Experience with Oracle tools like SQL, PL/SQL, SQL PLUS, Oracle Enterprise Manager, SQL Developer, Oracle9i/10g Developers suite Reports.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, varrays, nested tables and Dynamic SQL.
• Excellent experience with performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Experience in application fine-tuning and database fine-tuning using Explain Plan, SQL Trace and TKPROF.
• Experience in working high transacted OLTP systems.
• Strong experience with Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Well Versed with Crystal Reports 8.5/10/11 and using TOAD 8.5/8.6/9 in secure databases.
• Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS and DBMS SCHEDULER.
• Expert in UNIX Shell scripting Bourne, Korn .
• Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Knowledge of Relational Database Management System RDBMS .
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Responsibilities:

• Involved in Analyzing a system, creating Design Documents, Coding, Development, Unit testing and Implementation.
• Creating and enhancing Oracle database objects, develop Pl/Sql packages/procedures and forms/Reports, perform application tuning using Oracle tools and utilities.
• Created new forms, modified existing forms for the user to use as a front end of application
• Created tables, Functions, Triggers, procedures for different projects.
• Creating and monitoring CA Workload/Autosys control center jobs used for automation of various processes.
• Providing efficient solutions by developing documentation, flowcharts, layouts, diagrams etc.
• Extending support to the production environment in providing solutions to issues there by reducing the impact.
• Utilizing knowledge of scripting languages which provide access to UNIX, Linux systems.
• Performing technology upgrades to enhance the performance of the applications. .
• The Skillset required to perform the job duties include expertise in Oracle Pl/Sql, Oracle forms 10g/11g,
• Oracle Reports 10g/11g, Linux, Pro C along with few other Financial Insurance applications.
• Upgraded the oracle database from 10g to 11g and also changed the platform from HP to AIX and then Linux.

Environment: TOAD 8.5, Oracle Forms Builder 11g, Oracle Reports Builder 11g, Putty, AutoSys, PL/SQL Developer 9, SQL Plus, MS Office Suite, Oracle JDeveloper 10.1.3.3, Crystal reports 8.5

Confidential

Oracle PL/SQL Report Developer

Responsibilities:

• Involved in Coding, Data conversion, Development and Implementation.
• Created SQL codes to generate the reports according to requirement of the front users.
• Created tables, Functions, Triggers, procedures for generating some complex reports.
• Encrypted the PL/SQL code using wrappers.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Involved in writing test cases to ensure that requirements are met in the developed application.
• Created Korn Shell scripts for automating tasks.
• Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
• Used the rollup and cube operators to generate summaries.

Environment: Oracle 11g/9i, Advance Query Tool, SQL Developer, SQL PLUS, SQL, PL/SQL, UNIX, Windows XP, Oracle Reports, MS Office 2010.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Loading of customer data from flat files using SQL loader.
• Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules.
• Encrypted the PL/SQL code using wrappers.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Involved in writing test cases to ensure that requirements are met in the developed application.
• Created Korn Shell scripts, Bourne Shell Scripts and Bash Shell for automating tasks as well as for creating extracts.
• Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
• Used the rollup and cube operators to generate summaries.
• Created SQL codes to generate the reports according to requirement of the front users.

Environment: Oracle 10g/11g, Solaris 5.8, UNIX, Windows XP, PL/SQL, SQL PLUS,

Oracle Reports, SQL Developer.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed of customer specifications and custom design of applications successfully and
• implementing designs in new/existing application using PL/SQL.
• Developed PL/SQL-Packages, SQL Scripts and Database Triggers to populate the historic data in the tables applying business logic.
• Used to extract data from external source s and transform and load into data warehouse.
• Developed database objects like tables, views, indexes, triggers, stored procedures.
• Used SQL Loader scripts to load the flat files into the Oracle Database.
• Performed application SQL Tuning using SQL Trace Explain plan for better performance.
• Created various simple and complex by joining more than two tables views.
• Involved in coding and designing of the Transaction Module using PL/SQL Procedure.
• Used various SQL Expressions and Conditions in standalone procedures and functions.
• Used File Transfer Protocol FTP tool to transfer files from one server to other.
• Implemented Export/Import Oracle utilities to move data to different testing environments.
• Developed Oracle Reports to displayed sales margins for daily, weekly, monthly, and
• quarterly totals along with detailed inventory information.
• Worked on Unix Shell Scripting for Scheduling Batch Jobs using Crontab.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL PLUS, Informatica, TOAD, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirement from different clients and translated user requirements
• into data flows, detail technical specifications and database requirement.
• Created stored procedures, packages, triggers.
• Used Wrappers for code security.
• Used cursors, exception handling methods along with pragma exception init in
• order to associate our own created exception names.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Created the Temp tables in the stored procedure for different applications.
• Automation of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Loaded data from flat files into Database using SQL loader.
• Created UNIX scripts for automated process.
• Used DBMS JOBS package for job scheduling.

Environment: Oracle 10g, Solaris 5.8, UNIX, Windows XP, SQL Developer, Crystal

Reports.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Good understanding on high level business scenario of the company's financial functional structure.
• Created SQL codes to generate the reports according to requirement of the front users.
• Created tables, Functions, Triggers, procedures for generating some complex reports.
• Involved in the development of database objects.
• Involved in Oracle User creation assigning Roles Privileges.
• Writing Tuned SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and handling exceptions.
• Used Import/Export utilities of Oracle.
• Created and managed primary data base objects such as Tables, Views, Indexes, Sequences and Synonyms.
• Preparation of Pre and Post test cases.
• Unit testing of developed components.

Environment: Oracle 10g/9i, MS Access, SQL/PL SQL, UNIX, Oracle Reports 6i Windows NT/98.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in all the phases of System Development Life cycle.
• Creation of storyboard.
• Loading flat files using SQL Loader.
• Used to extract data from external source s and transform and load into data warehouse.
• Created various database objects like tables, views, indexes, triggers, sequences, synonyms.
• Created PL/SQL procedures, functions, packages required for the application.
• Writing the queries to get the data from different sources
• Tuning application using tools like SQL Trace, Analyze, and Explain Plan.
• Partitioning of tables for faster data retrieval.
• Helped in the creation of summary tables.
• Use of DBMS JOBS package to automate jobs.

Environment: Oracle 9i, Unix, MySql, Informatica, SQL, SQL Developer