SUMMARY OF QUALIFICATIONS:

• Over FIVE years of experience in the field of Software Design, Development, Implementation and production support with proficiency in Oracle8i/9i/10g/11g, SQL, PL/SQL that includes Complete System Development LifeCycle from Analysis and Design to Implementation.
• Over THREE years of Experience in Java, J2EE.
• Over THREE Years of Experience in Perl Scripting UNIXShell scriptingPerl/awk.
• Over THREE Years of Experience in VB6.
• Expertise in writing Packages, Stored Procedures, Functions, Views and DatabaseTriggers using SQL and PL/SQL in Oracle.
• Development focusing on Website/Email tracking, database Queries.
• Experienced with the latest Technologies, Architectures and Frameworks such as Enterprise Java Beans, Servlets, Java Server Pages, Hibernate, Spring, JDBC, JUnit, JUnitPerf, STRUTS, XML,Web Services, WSDL, SOAP, REST, UML, SQL, C .
• Worked with query tools like TOAD, SQL Plus, SQL Developer. Proficient knowledge in HTML and JavaScript. Created ERDiagrams on Erwin using Normalization Techniques. Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
• Has knowledge and understanding of underlying DatabaseArchitecture and Concepts.
• Experience in data migration from legacy system to OracleRDBMS.
• Proficiency in relational databases RDBMS , data modeling and in building Data Warehouse Data Marts using Star Schema and Snowflake Schema.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD. Experience in Performance Tuning Optimization of SQL statements. Extensively worked in Oracledatabase environments of up to 10terabytes in size including very large data sets and partitioned data.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications. Created materialized views like primary key, rowid and sub querymaterialized views.
• Strong in writing StoredProcedures and SQLqueries. Designed and developed the Extraction, Transformation and Loading ETL . Strong Domain knowledge of Insurance,Banking Systems, TelecomSystems andHealth Care.
• Involved in MigratingDatabase for text files to Oracle databases UsingSQL Loaders.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS:

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX,

Languages: Java, C, C , VB6.0, SQL, PL/SQL, FOXPRO,

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL Plus, TOAD, iSQL Plus, SQL Loader,

Development Tools: Developer 10g/9i/6i/2000 Release 1 2,

Scripting Languages: Java Script, UNIX Scripting,

Web Technologies: HTML.

PROFESSIONAL EXPERIENCE:

EMPLOYMENT

Confidential

Job Title: Sr. Oracle Developer

Responsibilities:

• Created database objects like tables, views, synonyms, procedures, functions and data base triggers to meet the business requirements. Created constraints on the tables and the relations between the tables to meet the requirements.
• Involved in the Performance tuning of the queries using Explain Plan. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Analyzed the execution plan and the statistics of the optimizer and passed the hints and placed indexes wherever necessary.
• Successfully manipulatedStoredProcedures, Functions, Triggers and Packages using TOAD. Created numerous views and materialized views based on the business requirement. Using SQL Loaderscript created a job to load everyday file in to status table.
• Provided technical decision support for the system and business analysts. Developed batch processes for financial reporting applications and modules using Perl and Kornshellscripts on Oracledatabase with partitions and sub-partitions.
• Involved in migrating database from OracleCreated and used Table Partitions to further improve the performance while using tables containing large amount of data. Created a secure FTPscript which runs every day to send the daily Agent training file. These jobs scheduled to run everyday using Control-M.
• Did unit testing with the test daily file and sent the everyday test Agent training file by running the jobs manually. Crated, handled and maintained the .SQLscripts, .CMD files and RDFs according to the changes in the business requirements.
• Successfully moved these objects to the Production server. Worked on production support and resolved the issues occurred with the jobs. Using Perlscript, parsed the XML file which is then used by Java.
• Processing and system capabilities, uses and requirements. Defining Key flex fields and values sets. Ensured timely completion of development projects within estimated costs and standards.
• Explored to work and Mappings and Mapplets for ETL process using Transformations like Source Qualifier, Lookup, Joiner, sorter, Stored procedure, Sequence generator, Aggregate, Filter, Update Strategy, Expression, Router, Rank, and etc
• Led and technically mentored a group of 7 intermediate and senior developers. 9i to Oracle10g for horizon application.

Environment: VB 6, JAVA, Oracle 10g/11g, SQL, PL/SQL, SQL LOADER, SQL Plus, TOAD, XML, UNIX, Perl, VSS.

Confidential

Job Title: Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and datamodeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• DevelopedDatabaseTriggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQLpackage. Used PL/SQL to validate data and to populate billing tables. Using UNIXShellscriptingPerl/sh/awk.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance. Developed Installation scripts for all the deliverables.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from Oracle9i to 10gdatabase. Involved in developingscreens and generating reports.

Environment: VB 6, Oracle 9i/10g/11g SQL, PL/SQL,SQL Loader, SQL Navigator, TOAD.

Confidential

Job Title: Oracle Developer/Analyst

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic, using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Created management analysis reporting sing ParallelQueries, Javastoredprocedure, HTPPackage and WEB.SHOW DOCUMENT. Participated in change and code reviews to understand the testing needs of the change components. Working on troubleshooting defects in timely manner.
• Involved in creating UNIXshellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in databaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIXShellscripts to automate repetitive databaseprocesses.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL LOADER,SQL PLUS, HTML,TOAD, XML, HP-UNIX shell scripting.

Confidential

Job Title: Oracle PL/SQL Developer

Responsibilities:

• Monitored Usage Processing of TTL-OSS-BILLING System. For six states namely Delhi, Gujarat, Tamilnadu, Karnataka, AndraPradesh and Mumbai. Analysis Review of Usage Reports. Scheduling MIU Batches by shell scripting for releasing error calls.
• Configuration of Usage points by using SQLstatements. Extensively Performed backend databasedevelopment tasks such as PL/SQL, Triggers, SQLQueries, Functions and packages. Built complex queries using SQL and wrote storedprocedures using PL/SQL.
• Involved in performance tuning and monitoring, tuned SQLqueries using Code Statistics and Explain plan features and analyzing number of hits and scans for an optimal execution plan, adding hints, indexes and parallel processing techniques for the queries.
• Provided Cross Training to Team Members on the Developer tools, PL/SQL, SQL. Create and maintain UNIXshellscripts for log rotation and backup.
• Generating DDL files to create new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, storedprocedures, roles and granting privileges by incorporating business standards throughout the files.

Environment: VB 6, ORACLE 9i, SQL, PL/SQL, TOAD, UNIX Shell Scripts.